Changeset 1312 in ExiteCMS

Timestamp:

02/27/08 11:28:54 (4 years ago)

Author:

hverton

Message:

added the new thread_first_read field to the posts unread queries in the pli-images.org themes, to get a more accurante unread posts number

Location:

themes/PLi-Fusion

Files:

• PLiTheme/php-files/themes/PLiTheme/theme.php (modified) (1 diff)
• PLiThemeCentered/php-files/themes/PLiThemeCentered/theme.php (modified) (1 diff)
• PLiXmas/php-files/themes/PLiXmas/theme.php (modified) (1 diff)

themes/PLi-Fusion/PLiTheme/php-files/themes/PLiTheme/theme.php

@@ -83 +83 @@
 // unread forum post indicator
 if (iMEMBER && $settings['revision'] >= 1193) {
-    $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 (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);
+    if ($userdata['user_posts_unread']) {
+        $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 (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 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['new_posts'] = ($result ? mysql_result($result, 0) : 0);
 } else {

themes/PLi-Fusion/PLiThemeCentered/php-files/themes/PLiThemeCentered/theme.php

@@ -83 +83 @@
 // unread forum post indicator
 if (iMEMBER && $settings['revision'] >= 1193) {
-    $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 (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);
+    if ($userdata['user_posts_unread']) {
+        $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 (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 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['new_posts'] = ($result ? mysql_result($result, 0) : 0);
 } else {

themes/PLi-Fusion/PLiXmas/php-files/themes/PLiXmas/theme.php

@@ -83 +83 @@
 // unread forum post indicator
 if (iMEMBER && $settings['revision'] >= 1193) {
-    $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 (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);
+    if ($userdata['user_posts_unread']) {
+        $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 (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 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['new_posts'] = ($result ? mysql_result($result, 0) : 0);
 } else {