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

Timestamp:

02/27/08 11:25:49 (4 years ago)

Author:

hverton

Message:

added the new thread_first_read field to all posts unread queries, to get a more accurante unread posts number

File:

• trunk/forum/viewforum.php (modified) (1 diff)

trunk/forum/viewforum.php

@@ -99 +99 @@
     // update the last_read datestamp of all threads found
     while ($data = dbarray($result)) {
-        $result2 = dbquery("UPDATE ".$db_prefix."threads_read SET thread_last_read = '".time()."' WHERE user_id = '".$userdata['user_id']."' AND thread_id = '".$data['thread_id']."'");
-    }
-}
-
-// get the number of unread posts in this forum
+        $result2 = dbquery("UPDATE ".$db_prefix."threads_read SET thread_first_read = '0', thread_last_read = '".time()."' WHERE user_id = '".$userdata['user_id']."' AND thread_id = '".$data['thread_id']."'");
+    }
+}
+
+// get the number of unread posts for this user in this forum
 if (iMEMBER) {
     if ($userdata['user_posts_unread']) {
-        // include the users own posts
-        $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 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_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)
+                        OR (p.post_datestamp < tr.thread_first_read OR (p.post_edittime != 0 AND p.post_edittime < tr.thread_first_read)))"
+            );
+    } else {
+        $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)
+                        OR (p.post_datestamp < tr.thread_first_read OR (p.post_edittime != 0 AND p.post_edittime < tr.thread_first_read)))"
+            );
+    } 
     $variables['unread_posts'] = ($result ? mysql_result($result, 0) : 0);
 } else {