Changeset 1307 in ExiteCMS for trunk/forum/viewthread.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/viewthread.php (modified) (4 diffs)

trunk/forum/viewthread.php

@@ -194 +194 @@
         // include the users own posts
         $result = dbquery("
-            SELECT count(*) as unread, tr.thread_last_read, tr.thread_page
+            SELECT count(*) as unread, tr.thread_last_read
                 FROM ".$db_prefix."posts p
                 LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id
@@ -206 +206 @@
         // filter the users own posts
         $result = dbquery("
-            SELECT count(*) as unread, tr.thread_last_read, tr.thread_page
+            SELECT count(*) as unread, tr.thread_last_read
                 FROM ".$db_prefix."posts p
                 LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id
@@ -222 +222 @@
         $variables['unread_posts'] = $data['unread'];
         $thread_last_read = $data['thread_last_read'];
-        $thread_page = $data['thread_page'];
     } else {
         $variables['unread_posts'] = 0;
         $thread_last_read = time();
-        $thread_page = 0;
     }
 } else {
     $variables['unread_posts'] = 0;
     $thread_last_read = time();
-    $thread_page = 0;
 }
 
@@ -397 +394 @@
 // update the threads_read record for this user and thread when the last_post_datestamp is newer
 if (iMEMBER && $last_post_datestamp) {
-    $result = dbquery("UPDATE ".$db_prefix."threads_read SET thread_last_read = '".$last_post_datestamp."', thread_page = '".min($rowstart, $thread_page)."' WHERE user_id = '".$userdata['user_id']."' AND thread_id = '".$thread_id."' AND thread_last_read < '".$last_post_datestamp."'");
+    $result = dbquery("UPDATE ".$db_prefix."threads_read SET thread_last_read = '".$last_post_datestamp."' WHERE user_id = '".$userdata['user_id']."' AND thread_id = '".$thread_id."' AND thread_last_read < '".$last_post_datestamp."'");
 }