diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2013-03-14 12:10:07 +0100 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2013-03-14 12:10:07 +0100 |
| commit | d41cf293e1609be9d0cc08e5ccd37947481e61ca (patch) | |
| tree | a39fc712a1fe41165dcb9edec137a59156577383 /phpBB/docs/sphinx.sample.conf | |
| parent | 74f4fd724e64eba4092b48cd114b2a1ee9e399b3 (diff) | |
| download | forums-d41cf293e1609be9d0cc08e5ccd37947481e61ca.tar forums-d41cf293e1609be9d0cc08e5ccd37947481e61ca.tar.gz forums-d41cf293e1609be9d0cc08e5ccd37947481e61ca.tar.bz2 forums-d41cf293e1609be9d0cc08e5ccd37947481e61ca.tar.xz forums-d41cf293e1609be9d0cc08e5ccd37947481e61ca.zip | |
[ticket/9657] Check for post visibility when searching with Sphinx
This update will require admins to manually update their Sphinx config
file aswell as to delete the index and rebuild it from scratch. Before
this is done the search will not be usable anymore.
PHPBB3-9657
Diffstat (limited to 'phpBB/docs/sphinx.sample.conf')
| -rw-r--r-- | phpBB/docs/sphinx.sample.conf | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/phpBB/docs/sphinx.sample.conf b/phpBB/docs/sphinx.sample.conf index fcaba6dcf3..179f06b2e5 100644 --- a/phpBB/docs/sphinx.sample.conf +++ b/phpBB/docs/sphinx.sample.conf @@ -20,6 +20,8 @@ source source_phpbb_{SPHINX_ID}_main \ p.poster_id, \ + p.post_visibility, +\ CASE WHEN p.post_id = t.topic_first_post_id THEN 1 ELSE 0 END as topic_first_post, \ p.post_time, @@ -47,6 +49,7 @@ source source_phpbb_{SPHINX_ID}_main sql_attr_uint = forum_id sql_attr_uint = topic_id sql_attr_uint = poster_id + sql_attr_uint = post_visibility sql_attr_bool = topic_first_post sql_attr_bool = deleted sql_attr_timestamp = post_time @@ -67,6 +70,8 @@ source source_phpbb_{SPHINX_ID}_delta : source_phpbb_{SPHINX_ID}_main \ p.poster_id, \ + p.post_visibility, +\ CASE WHEN p.post_id = t.topic_first_post_id THEN 1 ELSE 0 END as topic_first_post, \ p.post_time, |