diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2013-03-16 01:18:15 +0100 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2013-03-16 01:18:15 +0100 |
| commit | c50af280770a9db13043a41e34238a2434176936 (patch) | |
| tree | 891750997a0d193905f1fd10ace3af5f24cb0ed3 /phpBB/docs/sphinx.sample.conf | |
| parent | 2b2bbf787c55e8922ae1c06242be1120a7e91eb7 (diff) | |
| download | forums-c50af280770a9db13043a41e34238a2434176936.tar forums-c50af280770a9db13043a41e34238a2434176936.tar.gz forums-c50af280770a9db13043a41e34238a2434176936.tar.bz2 forums-c50af280770a9db13043a41e34238a2434176936.tar.xz forums-c50af280770a9db13043a41e34238a2434176936.zip | |
[ticket/11438] Add spaces after # comment start and before \ line breaks
PHPBB3-11438
Diffstat (limited to 'phpBB/docs/sphinx.sample.conf')
| -rw-r--r-- | phpBB/docs/sphinx.sample.conf | 68 |
1 files changed, 34 insertions, 34 deletions
diff --git a/phpBB/docs/sphinx.sample.conf b/phpBB/docs/sphinx.sample.conf index 5da4ea78df..d1b98d6cbc 100644 --- a/phpBB/docs/sphinx.sample.conf +++ b/phpBB/docs/sphinx.sample.conf @@ -1,31 +1,31 @@ source source_phpbb_{SPHINX_ID}_main { - type = mysql #mysql or pgsql - sql_host = localhost #SQL server host sphinx connects to + type = mysql # mysql or pgsql + sql_host = localhost # SQL server host sphinx connects to sql_user = username sql_pass = password sql_db = db_name - sql_port = 3306 #optional, default is 3306 for mysql and 5432 for pgsql + sql_port = 3306 # optional, default is 3306 for mysql and 5432 for pgsql sql_query_pre = SET NAMES 'utf8' sql_query_pre = UPDATE phpbb_sphinx SET max_doc_id = (SELECT MAX(post_id) FROM phpbb_posts) WHERE counter_id = 1 sql_query_range = SELECT MIN(post_id), MAX(post_id) FROM phpbb_posts sql_range_step = 5000 - sql_query = SELECT\ - p.post_id AS id,\ - p.forum_id,\ - p.topic_id,\ - p.poster_id,\ - CASE WHEN p.post_id = t.topic_first_post_id THEN 1 ELSE 0 END as topic_first_post,\ - p.post_time,\ - p.post_subject,\ - p.post_subject as title,\ - p.post_text as data,\ - t.topic_last_post_time,\ + sql_query = SELECT \ + p.post_id AS id, \ + p.forum_id, \ + p.topic_id, \ + p.poster_id, \ + CASE WHEN p.post_id = t.topic_first_post_id THEN 1 ELSE 0 END as topic_first_post, \ + p.post_time, \ + p.post_subject, \ + p.post_subject as title, \ + p.post_text as data, \ + t.topic_last_post_time, \ 0 as deleted\ - FROM phpbb_posts p, phpbb_topics t\ - WHERE\ - p.topic_id = t.topic_id\ - AND p.post_id >= $start AND p.post_id <= $end + FROM phpbb_posts p, phpbb_topics t \ + WHERE \ + p.topic_id = t.topic_id \ + AND p.post_id >= $start AND p.post_id <= $end sql_query_post = sql_query_post_index = UPDATE phpbb_sphinx SET max_doc_id = $maxid WHERE counter_id = 1 sql_query_info = SELECT * FROM phpbb_posts WHERE post_id = $id @@ -43,22 +43,22 @@ source source_phpbb_{SPHINX_ID}_delta : source_phpbb_{SPHINX_ID}_main sql_query_pre = sql_query_range = sql_range_step = - sql_query = SELECT\ - p.post_id AS id,\ - p.forum_id,\ - p.topic_id,\ - p.poster_id,\ - CASE WHEN p.post_id = t.topic_first_post_id THEN 1 ELSE 0 END as topic_first_post,\ - p.post_time,\ - p.post_subject,\ - p.post_subject as title,\ - p.post_text as data,\ - t.topic_last_post_time,\ - 0 as deleted\ - FROM phpbb_posts p, phpbb_topics t\ - WHERE\ - p.topic_id = t.topic_id\ - AND p.post_id >= ( SELECT max_doc_id FROM phpbb_sphinx WHERE counter_id=1 ) + sql_query = SELECT \ + p.post_id AS id, \ + p.forum_id, \ + p.topic_id, \ + p.poster_id, \ + CASE WHEN p.post_id = t.topic_first_post_id THEN 1 ELSE 0 END as topic_first_post, \ + p.post_time, \ + p.post_subject, \ + p.post_subject as title, \ + p.post_text as data, \ + t.topic_last_post_time, \ + 0 as deleted \ + FROM phpbb_posts p, phpbb_topics t \ + WHERE \ + p.topic_id = t.topic_id \ + AND p.post_id >= ( SELECT max_doc_id FROM phpbb_sphinx WHERE counter_id=1 ) sql_query_pre = } index index_phpbb_{SPHINX_ID}_main |