Two more additions. These two blocks assure that people get an initial Mark Read entry in the database if they don't have one. Its set to 0:00AM for the day they enter without one.
This goes in the login method in member.php, before the URL portion:
Code:
// *** CODE ADDED BY ETHANK
$record_exists=$DB_site->query("select userid from markread where userid='$userid' AND forumid = '0'");
$num_records=$DB_site->num_rows($record_exists);
if($num_records<1)
{
$firsttime=mktime(0,0,0);
$DB_site->query("INSERT INTO markread (readtime, userid, forumid) VALUES ('$firsttime','$userid', '0')");
}
// END ADD
And this goes in register.php, after the initial databse insert after the Start Add Member comment. This goes right before the big insert method...:
Code:
// *** ADDED BY ETHANK
// Create Unix time for midnight...
$firsttime=mktime(0,0,0);
$DB_site->query("INSERT INTO markread (readtime, userid, forumid) VALUES ('$firsttime','$userid', '0')");
// END ADD
Bookmarks