diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-06-15 14:59:14 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-06-15 14:59:14 +0000 |
| commit | 832faaa6c8566d540cca152a52a82339c346a51e (patch) | |
| tree | 7072aeb017187de9e2c517657fd3c87cac8573ea | |
| parent | 75b3410e836ec9ed525a8cc287b4d49ee7e33d14 (diff) | |
| download | forums-832faaa6c8566d540cca152a52a82339c346a51e.tar forums-832faaa6c8566d540cca152a52a82339c346a51e.tar.gz forums-832faaa6c8566d540cca152a52a82339c346a51e.tar.bz2 forums-832faaa6c8566d540cca152a52a82339c346a51e.tar.xz forums-832faaa6c8566d540cca152a52a82339c346a51e.zip | |
fix a small mistake (bug #2238)
git-svn-id: file:///svn/phpbb/trunk@6068 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/viewtopic.php | 11 |
1 files changed, 5 insertions, 6 deletions
diff --git a/phpBB/viewtopic.php b/phpBB/viewtopic.php index d14533e4b7..71a97c3d43 100644 --- a/phpBB/viewtopic.php +++ b/phpBB/viewtopic.php @@ -224,12 +224,11 @@ if (!$topic_data) // This is for determining where we are (page) if ($post_id) { - $sql = 'SELECT COUNT(p.post_id) AS prev_posts - FROM ' . POSTS_TABLE . " p - WHERE p.post_approved = 1 - AND p.topic_id = {$topic_data['topic_id']} - " . ((!$auth->acl_get('m_approve', $forum_id)) ? 'AND p.post_approved = 1' : '') . " - AND " . (($sort_dir == 'd') ? "p.post_id >= $post_id" : "p.post_id <= $post_id"); + $sql = 'SELECT COUNT(post_id) AS prev_posts + FROM ' . POSTS_TABLE . " + WHERE topic_id = {$topic_data['topic_id']} + " . ((!$auth->acl_get('m_approve', $forum_id)) ? 'AND post_approved = 1' : '') . " + AND " . (($sort_dir == 'd') ? "post_id >= $post_id" : "post_id <= $post_id"); $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $db->sql_freeresult($result); |