diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-03-20 01:25:59 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-03-20 01:25:59 +0000 |
| commit | ab34d6329cba809175b4b43fe58d6f7b0129154d (patch) | |
| tree | 73252ce9eb3daad1f682775af5bd197214c63af1 /phpBB/viewforum.php | |
| parent | f9f6cb194dc51454402a463d0391a477d1a92bdf (diff) | |
| download | forums-ab34d6329cba809175b4b43fe58d6f7b0129154d.tar forums-ab34d6329cba809175b4b43fe58d6f7b0129154d.tar.gz forums-ab34d6329cba809175b4b43fe58d6f7b0129154d.tar.bz2 forums-ab34d6329cba809175b4b43fe58d6f7b0129154d.tar.xz forums-ab34d6329cba809175b4b43fe58d6f7b0129154d.zip | |
Move to sql_query_limit
git-svn-id: file:///svn/phpbb/trunk@3686 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/viewforum.php')
| -rw-r--r-- | phpBB/viewforum.php | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/phpBB/viewforum.php b/phpBB/viewforum.php index 088e33319e..cbe33c3ae2 100644 --- a/phpBB/viewforum.php +++ b/phpBB/viewforum.php @@ -270,9 +270,8 @@ if ($forum_data['forum_postable']) WHERE (t.forum_id = $forum_id OR t.forum_id = 0) AND t.topic_type = " . POST_ANNOUNCE . " - ORDER BY $sort_order_sql - LIMIT " . $config['topics_per_page']; - $result = $db->sql_query($sql); + ORDER BY $sort_order_sql"; + $result = $db->sql_query_limit($sql, $config['topics_per_page']); while($row = $db->sql_fetchrow($result)) { @@ -290,8 +289,7 @@ if ($forum_data['forum_postable']) " . (($auth->acl_gets('m_approve', 'a_', $forum_id)) ? '' : 'AND t.topic_approved = 1') . " AND t.topic_type <> " . POST_ANNOUNCE . " $limit_topics_time - ORDER BY t.topic_type DESC, $sort_order_sql - LIMIT $start, " . $config['topics_per_page']; + ORDER BY t.topic_type DESC, $sort_order_sql"; /* } else { @@ -310,7 +308,7 @@ if ($forum_data['forum_postable']) AND u2.user_id = t.topic_last_poster_id ORDER BY $sort_order"; }*/ - $result = $db->sql_query($sql); + $result = $db->sql_query_limit($sql, $config['topics_per_page']); while($row = $db->sql_fetchrow($result)) { |