diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2010-06-17 19:10:59 +0200 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2010-06-17 19:10:59 +0200 |
| commit | 4eac7dca6df00a6378d84d5f87dae7604142ec06 (patch) | |
| tree | 9fed41b999cfed2aea85b5c9e92f3f45a7076d89 /phpBB/includes/functions.php | |
| parent | 876a6e4686bbad12c456c87a7c96bc4486bd3d17 (diff) | |
| parent | d819ee343a3a6dc6282f709e67454cd2f0d1afcf (diff) | |
| download | forums-4eac7dca6df00a6378d84d5f87dae7604142ec06.tar forums-4eac7dca6df00a6378d84d5f87dae7604142ec06.tar.gz forums-4eac7dca6df00a6378d84d5f87dae7604142ec06.tar.bz2 forums-4eac7dca6df00a6378d84d5f87dae7604142ec06.tar.xz forums-4eac7dca6df00a6378d84d5f87dae7604142ec06.zip | |
Merge branch 'ticket/rxu/9606' into develop-olympus
* ticket/rxu/9606:
[ticket/9606] Optimize unread search option.
Diffstat (limited to 'phpBB/includes/functions.php')
| -rw-r--r-- | phpBB/includes/functions.php | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/phpBB/includes/functions.php b/phpBB/includes/functions.php index 3e80f93114..3f097f171f 100644 --- a/phpBB/includes/functions.php +++ b/phpBB/includes/functions.php @@ -1660,10 +1660,11 @@ function get_complete_topic_tracking($forum_id, $topic_ids, $global_announce_lis * @param string $sql_extra Extra WHERE SQL statement * @param string $sql_sort ORDER BY SQL sorting statement * @param string $sql_limit Limits the size of unread topics list, 0 for unlimited query +* @param string $sql_limit_offset Sets the offset of the first row to search, 0 to search from the start * * @return array[int][int] Topic ids as keys, mark_time of topic as value */ -function get_unread_topics($user_id = false, $sql_extra = '', $sql_sort = '', $sql_limit = 1001) +function get_unread_topics($user_id = false, $sql_extra = '', $sql_sort = '', $sql_limit = 1001, $sql_limit_offset = 0) { global $config, $db, $user; @@ -1709,7 +1710,7 @@ function get_unread_topics($user_id = false, $sql_extra = '', $sql_sort = '', $s ); $sql = $db->sql_build_query('SELECT', $sql_array); - $result = $db->sql_query_limit($sql, $sql_limit); + $result = $db->sql_query_limit($sql, $sql_limit, $sql_limit_offset); while ($row = $db->sql_fetchrow($result)) { @@ -1742,7 +1743,7 @@ function get_unread_topics($user_id = false, $sql_extra = '', $sql_sort = '', $s WHERE t.topic_last_post_time > ' . $user_lastmark . " $sql_extra $sql_sort"; - $result = $db->sql_query_limit($sql, $sql_limit); + $result = $db->sql_query_limit($sql, $sql_limit, $sql_limit_offset); while ($row = $db->sql_fetchrow($result)) { |