Changeset 1307 in ExiteCMS for themes/PLi-Fusion/PLiThemeCentered/php-files/themes/PLiThemeCentered/theme.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:

• themes/PLi-Fusion/PLiThemeCentered/php-files/themes/PLiThemeCentered/theme.php (modified) (1 diff)

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

@@ -82 +82 @@
 
 // unread forum post indicator
-if (iMEMBER) {
+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);
     $variables['new_posts'] = ($result ? mysql_result($result, 0) : 0);