Query Database to see if new Posts have been made (Forumhome)

[rin]

Hello,

thanks for the hint. I read through the TXT and think you mean this one, right?

$postcount = $DB_site->query_first("SELECT COUNT(dateline) as pcount FROM ".TABLE_PREFIX."post WHERE dateline > ".$bbuserinfo['lastvisit']." ");

Basically, what I would do is:
Get the last post from the forum and check if it is newer or older than the last visit of the user?

If this is the way it works, would this in any kind be inferior to the way an unhacked vBulletin handles the lightbulbs?

I have tried to use your hack on a 3.5.4 forum. It does not work. It won't show anything in the templates.
I would assume, the if() is not working at all. Is there something I am not aware of?

unset($pcount, $rcount);
if ($bbuserinfo['userid'])
{
	$pcount = "No New Posts since your last visit.";
	$postcount = $DB_site->query_first("SELECT COUNT(dateline) as pcount FROM ".TABLE_PREFIX."post WHERE dateline > ".$bbuserinfo['lastvisit']." ");
	if ($postcount['pcount'])
	{
		if ($postcount['pcount'] == 1)
		{
			$pcount = "<a href='search.php?do=getnew'><b>1 New Post</b></a> since your last visit.";
		}
		else
		{
			$pcount = "<a href='search.php?do=getnew'><b>".$postcount['pcount']." New Posts</b></a> since your last visit.";
		}

}