Number of posts since last visit

Regular Joined: Jun 17, 2006 Posts: 81 Location: MD

A search of the forum didn't come up with what I am looking for, so I figure I should ask.

Previously, when operating a phpbb forum, there was a hack for displaying the number of posts since last visit in parenthesis, next to "View posts since last visit"

This number never decreased or anything, it did increase though with each page refresh if there were new posts.

I see it in use on Nuke sites, but can't find the actual code for it, except on phpbbhacks site.

I assume I can use the code supplied in the .mod for phpbb, but there is sure to be some conflict. Anyone implement this and know what changes are needed to make it compliant?

Here is the code from the MOD for phpbb

Code:

#


#-----[ OPEN ]------------------------------------------


#


index.php


#


#-----[ FIND ]------------------------------------------


#


//


// End session management


//


#


#-----[ AFTER ADD ]------------------------------------------


#


if( $userdata['session_logged_in'] ) 


{ 


   $sql = "SELECT COUNT(post_id) as total 


      FROM " . POSTS_TABLE . " 


      WHERE post_time >= " . $userdata['user_lastvisit'] . " 


      AND poster_id != " . $userdata['user_id']; 





   $result = $db->sql_query($sql); 


   if( $result ) 


   { 


      $row = $db->sql_fetchrow($result); 


      $lang['Search_new'] = $lang['Search_new'] . " (" . $row['total'] . ")"; 


   }


}


#


#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------


#


# EoM

I am sure the POSTS_TABLE needs to be changed, but what else?

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Not much to it...why not test? (be sure to backup...).

Posted: Mon Jul 31, 2006 4:40 pm

Well, it appears to work as is, no change necessary. WOOHOO!