diff options
| author | Nils Adermann <naderman@naderman.de> | 2011-01-23 18:34:50 +0100 |
|---|---|---|
| committer | Nils Adermann <naderman@naderman.de> | 2011-01-23 18:34:50 +0100 |
| commit | 42294907250e3e13c51e73c80aa7edbf2a8ec2ed (patch) | |
| tree | 89747a47fd224a36924000c16ff895b0cc540051 | |
| parent | ba5c7d8e63d97650989c2866c20c11f16f4c1128 (diff) | |
| parent | ab9d4b3b638ca02d026dc23574a88d510e5d2291 (diff) | |
| download | forums-42294907250e3e13c51e73c80aa7edbf2a8ec2ed.tar forums-42294907250e3e13c51e73c80aa7edbf2a8ec2ed.tar.gz forums-42294907250e3e13c51e73c80aa7edbf2a8ec2ed.tar.bz2 forums-42294907250e3e13c51e73c80aa7edbf2a8ec2ed.tar.xz forums-42294907250e3e13c51e73c80aa7edbf2a8ec2ed.zip | |
Merge branch 'ticket/rxu/8779' into develop-olympus
* ticket/rxu/8779:
[ticket/8779] Slow search for 'View unread posts'
| -rw-r--r-- | phpBB/includes/functions.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/phpBB/includes/functions.php b/phpBB/includes/functions.php index 65b9f22d12..9a8cc5d6b3 100644 --- a/phpBB/includes/functions.php +++ b/phpBB/includes/functions.php @@ -1698,7 +1698,7 @@ function get_unread_topics($user_id = false, $sql_extra = '', $sql_sort = '', $s if ($config['load_db_lastread'] && $user->data['is_registered']) { // Get list of the unread topics - $last_mark = $user->data['user_lastmark']; + $last_mark = (int) $user->data['user_lastmark']; $sql_array = array( 'SELECT' => 't.topic_id, t.topic_last_post_time, tt.mark_time as topic_mark_time, ft.mark_time as forum_mark_time', @@ -1717,10 +1717,11 @@ function get_unread_topics($user_id = false, $sql_extra = '', $sql_sort = '', $s ), 'WHERE' => " + t.topic_last_post_time > $last_mark AND ( (tt.mark_time IS NOT NULL AND t.topic_last_post_time > tt.mark_time) OR (tt.mark_time IS NULL AND ft.mark_time IS NOT NULL AND t.topic_last_post_time > ft.mark_time) OR - (tt.mark_time IS NULL AND ft.mark_time IS NULL AND t.topic_last_post_time > $last_mark) + (tt.mark_time IS NULL AND ft.mark_time IS NULL) ) $sql_extra $sql_sort", |