diff options
| author | Marc Alexander <admin@m-a-styles.de> | 2013-07-20 15:09:28 +0200 |
|---|---|---|
| committer | Marc Alexander <admin@m-a-styles.de> | 2013-07-20 21:21:36 +0200 |
| commit | 603dc1f78617e64e41f61daf85f463b0465123ec (patch) | |
| tree | 1f0c7dd4f1bfacf78275c11e5ca966bcdc5938a9 /phpBB/search.php | |
| parent | e60816eeb12e70be88467d708685ffa49f177691 (diff) | |
| download | forums-603dc1f78617e64e41f61daf85f463b0465123ec.tar forums-603dc1f78617e64e41f61daf85f463b0465123ec.tar.gz forums-603dc1f78617e64e41f61daf85f463b0465123ec.tar.bz2 forums-603dc1f78617e64e41f61daf85f463b0465123ec.tar.xz forums-603dc1f78617e64e41f61daf85f463b0465123ec.zip | |
[ticket/11717] Use topic_posts_approved instead of topic_replies
Due to the move to soft-delete, the topic_replies column no longer exists
in the topics table. Instead, the column topic_posts_approved should be used.
PHPBB3-11717
Diffstat (limited to 'phpBB/search.php')
| -rw-r--r-- | phpBB/search.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/search.php b/phpBB/search.php index 2429c81dae..8bcbfc498b 100644 --- a/phpBB/search.php +++ b/phpBB/search.php @@ -366,7 +366,7 @@ if ($keywords || $author || $author_id || $search_id || $submit) { $sql = "SELECT p.post_id FROM $sort_join" . POSTS_TABLE . ' p, ' . TOPICS_TABLE . " t - WHERE t.topic_replies = 0 + WHERE t.topic_posts_approved = 1 AND p.topic_id = t.topic_id $last_post_time AND $m_approve_posts_fid_sql @@ -378,7 +378,7 @@ if ($keywords || $author || $author_id || $search_id || $submit) { $sql = 'SELECT DISTINCT ' . $sort_by_sql[$sort_key] . ", p.topic_id FROM $sort_join" . POSTS_TABLE . ' p, ' . TOPICS_TABLE . " t - WHERE t.topic_replies = 0 + WHERE t.topic_posts_approved = 1 AND t.topic_moved_id = 0 AND p.topic_id = t.topic_id $last_post_time |