diff options
| author | Ruslan Uzdenov <rxu@mail.ru> | 2009-08-18 14:51:08 +0000 |
|---|---|---|
| committer | Ruslan Uzdenov <rxu@mail.ru> | 2009-08-18 14:51:08 +0000 |
| commit | d2d5ecef8d5fba02747b57e58bb89360100ea021 (patch) | |
| tree | 5505b2f3c145cb0777d72adb1453bdba2e75dece /phpBB/viewtopic.php | |
| parent | 54362bbe2bd3155262f3a8c7dd3034facc97b06c (diff) | |
| download | forums-d2d5ecef8d5fba02747b57e58bb89360100ea021.tar forums-d2d5ecef8d5fba02747b57e58bb89360100ea021.tar.gz forums-d2d5ecef8d5fba02747b57e58bb89360100ea021.tar.bz2 forums-d2d5ecef8d5fba02747b57e58bb89360100ea021.tar.xz forums-d2d5ecef8d5fba02747b57e58bb89360100ea021.zip | |
Better tracking of global announcements
Authorised by: AcydBurn
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10018 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/viewtopic.php')
| -rw-r--r-- | phpBB/viewtopic.php | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/phpBB/viewtopic.php b/phpBB/viewtopic.php index 1aa120622e..e743a92651 100644 --- a/phpBB/viewtopic.php +++ b/phpBB/viewtopic.php @@ -1593,6 +1593,27 @@ if (isset($user->data['session_page']) && !$user->data['is_bot'] && (strpos($use } } +// Get last post time for all global announcements +// to keep proper forums tracking +if ($topic_data['topic_type'] == POST_GLOBAL) +{ + $sql = 'SELECT topic_last_post_time as forum_last_post_time + FROM ' . TOPICS_TABLE . ' + WHERE forum_id = 0 + ORDER BY topic_last_post_time DESC'; + $result = $db->sql_query_limit($sql, 1); + $topic_data['forum_last_post_time'] = (int) $db->sql_fetchfield('forum_last_post_time'); + $db->sql_freeresult($result); + + $sql = 'SELECT mark_time as forum_mark_time + FROM ' . FORUMS_TRACK_TABLE . ' + WHERE forum_id = 0 + AND user_id = ' . $user->data['user_id']; + $result = $db->sql_query($sql); + $topic_data['forum_mark_time'] = (int) $db->sql_fetchfield('forum_mark_time'); + $db->sql_freeresult($result); +} + // Only mark topic if it's currently unread. Also make sure we do not set topic tracking back if earlier pages are viewed. if (isset($topic_tracking_info[$topic_id]) && $topic_data['topic_last_post_time'] > $topic_tracking_info[$topic_id] && $max_post_time > $topic_tracking_info[$topic_id]) { |