read topics

[groundup]

where does yabb store what you have and have not read?

[Big P]

Its all in the MySQL database. I *think* each board opens the database and checks read posts there.
Just look with PHPAdmin to make sure.

[groundup]

log_mark_read is the name of the mysql table but it only does it when you click "mark as read" and then it only does it to the board.  What I want to know is about each topic and how it decides where or not the topic is new

[Godai]

In which section of the board?

Anyway in BoardIndex.php it's done in this way:

Code Select Expand

      $result2 = mysql_query("SELECT ID_BOARD,name,description,moderators,numPosts,numTopics FROM {$db_prefix}boards WHERE (ID_CAT=$row_cat[ID_CAT]) ORDER BY boardOrder");
      while ($row_board = mysql_fetch_array($result2))
      {
         $result3 = mysql_query("SELECT m.posterName,m.ID_MEMBER,m.posterTime,m.modifiedTime,m.subject,t.ID_TOPIC,t.numReplies FROM {$db_prefix}messages as m, {$db_prefix}topics as t WHERE (m.ID_MSG=t.ID_LAST_MSG && t.ID_BOARD=$row_board[ID_BOARD]) ORDER BY m.posterTime DESC LIMIT 1");
         $latestPostName = $txt[470];
         $latestPostTime = $txt[470];
         $latestPostID = '-1';
         $latestModTime = $subject = $topicID = '';
         $numReplies = 0;
         if (mysql_num_rows($result3) > 0)
            list ($latestPostName,$latestPostID,$latestPostTime,$latestModTime,$subject,$topicID,$numReplies) = mysql_fetch_row($result3);
         $latestEditTime = $latestModTime = $latestPostTime;

         if ($latestPostID != '-1') {
            $result3 = mysql_query("SELECT memberName,realName FROM {$db_prefix}members WHERE ID_MEMBER=$latestPostID");
            $rowmem = mysql_fetch_row($result3);
            $latestPostRealName = isset($rowmem[1])?$rowmem[1]:$rowmem[0];
         }

         ........

         $new = "<img src=\"$imagesdir/off.gif\" alt=\"$txt[334]\">";

         if ($username!= 'Guest')
         {
            $result3 = mysql_query("SELECT logTime FROM {$db_prefix}log_boards WHERE (ID_BOARD=$row_board[ID_BOARD] && memberName='$username' && logTime >= $latestEditTime) LIMIT 1");
            $result3b = mysql_query("SELECT logTime FROM {$db_prefix}log_mark_read WHERE (ID_BOARD=$row_board[ID_BOARD] && memberName='$username' && logTime >= $latestEditTime) LIMIT 1");

            if (($latestPostTime != $txt[470]) && ((mysql_num_rows($result3) + mysql_num_rows($result3b)) == 0))
               $new = "<img src=\"$imagesdir/on.gif\" alt=\"$txt[333]\">";
         }

[groundup]

does anyone know where it logs what time that you read a post or an instant message?

[Godai]

I don't think it logs the time you have read it.

[groundup]

I think it does cuz it has a timestamp in mysql for the topic_logs.

[Joseph Fung]

Here's how it works.

When you view a board listing, and entry is added to log_boards  (it logs the ID_BOARD, the time and your user)

When you read a topic, an entry is added to log_topics (ID_TOPIC, time and your user).

When you click mark as read on the topic listing, it adds a record to mark_read, and deletes all the records in log_topic.

The reason it was done this way was so that when you click mark as read, it doesn't need to add a record for every single topic on the board.

[groundup]

so does it check to see if the current time is newer than the logged time or does it just determine whether or not the row is in mysql?