Changeset 1307 in ExiteCMS for trunk/forum/viewforum.php

Timestamp:

02/27/08 09:57:44 (4 years ago)

Author:

root

Message:

removed the thread_page field from the threads_read table

File:

• trunk/forum/viewforum.php (modified) (3 diffs)

trunk/forum/viewforum.php

@@ -107 +107 @@
     if ($userdata['user_posts_unread']) {
         // include the users own posts
-        $result = dbquery("SELECT count(*) as unread, sum(tr.thread_page) AS pages FROM ".$db_prefix."posts p LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id WHERE tr.user_id = '".$userdata['user_id']."' AND tr.forum_id = '".$forum_id."' AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].") AND (p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read)", false);
+        $result = dbquery("SELECT count(*) as unread FROM ".$db_prefix."posts p LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id WHERE tr.user_id = '".$userdata['user_id']."' AND tr.forum_id = '".$forum_id."' AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].") AND (p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read)", false);
     } else {
         // filter the users own posts
-        $result = dbquery("SELECT count(*) as unread, sum(tr.thread_page) AS pages FROM ".$db_prefix."posts p LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id WHERE tr.user_id = '".$userdata['user_id']."' AND tr.forum_id = '".$forum_id."' AND p.post_author != '".$userdata['user_id']."' AND p.post_edituser != '".$userdata['user_id']."' AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].") AND (p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read)", false);
+        $result = dbquery("SELECT count(*) as unread FROM ".$db_prefix."posts p LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id WHERE tr.user_id = '".$userdata['user_id']."' AND tr.forum_id = '".$forum_id."' AND p.post_author != '".$userdata['user_id']."' AND p.post_edituser != '".$userdata['user_id']."' AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].") AND (p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read)", false);
     }
     $variables['unread_posts'] = ($result ? mysql_result($result, 0) : 0);
@@ -152 +152 @@
     if (isset($userdata['user_id']) && $variables['unread_posts']) {
         $result2 = dbquery("
-            SELECT count(*) as unread, sum(tr.thread_page) AS pages, MIN(p.post_id) as post_id
+            SELECT count(*) as unread, MIN(p.post_id) as post_id
                 FROM ".$db_prefix."posts p 
                 LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 
@@ -173 +173 @@
         $data['first_unread_post'] = 0;
     }
-    // number of pages of posts in this thread
-    $data['thread_pages'] = ceil($data['thread_replies'] / $settings['numofthreads']) + 1;
     // correct the number of replies
     $data['thread_replies'] = max(0, $data['thread_replies'] - 1);