phpBB

Development Wiki

Difference between revisions of "Table.phpbb forums track"

From phpBB Development Wiki

(Added info about phpbb_topics_track relationship)
m
 
Line 1: Line 1:
This table keeps record for visited forums in order to mark them as read or unread. We use the mark_time timestamp in conjunction with last post of forum x's timestamp to know if forum x is read or not.
+
This table keeps record for visited forums in order to mark them as read or unread. We use the mark_time timestamp in conjunction with last post of forum x's timestamp to know when all topics in forum x were last marked read.
  
 
In order to accurately tell whether a given topic is read, one has to also check phpbb_topics_track.  
 
In order to accurately tell whether a given topic is read, one has to also check phpbb_topics_track.  

Latest revision as of 21:20, 16 August 2011

This table keeps record for visited forums in order to mark them as read or unread. We use the mark_time timestamp in conjunction with last post of forum x's timestamp to know when all topics in forum x were last marked read.

In order to accurately tell whether a given topic is read, one has to also check phpbb_topics_track.

Fields

column type (MySQL) content default
user_id mediumint(8) unsigned primary key 0
forum_id mediumint(8) unsigned primary key 0
mark_time int(11) unsigned tbd 0


Keys

name fields
PRIMARY user_id
forum_id