Changeset 1260 in ExiteCMS

Timestamp:

02/11/08 09:42:47 (4 years ago)

Author:

hverton

Message:

fixed bug in updating the threads_read datestamp, should only happen if the post read is newer then the last recorded datestamp

File:

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

trunk/forum/viewthread.php

@@ -377 +377 @@
 }
 
-// update the threads_read record for this user and thread
+// 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."'");
+    $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."'");
 }