Changeset 1280 in ExiteCMS for trunk/forum/viewthread.php

Timestamp:

02/14/08 15:02:48 (4 years ago)

Author:

hverton

Message:

added user option to show/hide the users own posts from the unread posts count

File:

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

trunk/forum/viewthread.php

@@ -191 +191 @@
 // number of unread posts in this thread
 if (iMEMBER) {
-    $result = dbquery("
-        SELECT count(*) as unread, tr.thread_last_read, tr.thread_page
-            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.thread_id = '".$thread_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)
-            GROUP BY tr.thread_id
-        ");
+    if ($userdata['user_posts_unread']) {
+        // include the users own posts
+        $result = dbquery("
+            SELECT count(*) as unread, tr.thread_last_read, tr.thread_page
+                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.thread_id = '".$thread_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)
+                GROUP BY tr.thread_id
+            ");
+    } else {
+        // filter the users own posts
+        $result = dbquery("
+            SELECT count(*) as unread, tr.thread_last_read, tr.thread_page
+                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 p.post_author != '".$userdata['user_id']."'
+                    AND p.post_edituser != '".$userdata['user_id']."'
+                    AND tr.thread_id = '".$thread_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)
+                GROUP BY tr.thread_id
+            ");
+    }
     if (dbrows($result)) {
         $data = dbarray($result);