Check for new pm's on non-vb page

[finkdawg5]

Hiya,
I'm trying to include a php function on the rest of my site that will check for new pm's. global.php is already required on all my pages for other functions, so I don't think it should be too hard. But... I am a very new newbie to php so I'm completely lost. Can anyone help, or give me a hint on where to begin? Any guidance you can offer would be greatly appreciated. Thanks in advance!

Dan

[Sparkz]

Try this snippet...

$allpm=$DB_site->query_first("SELECT COUNT(*) AS messages,
SUM(IF(dateline>$bbuserinfo[lastvisit] AND folderid=0,1,0)) AS newpm,
SUM(IF(messageread=0 AND folderid=0,1,0)) AS unreadpm
FROM privatemessage WHERE userid=$bbuserinfo[userid] $ignoreusers");

$newpm['messages']=$allpm['newpm'];
$unreadpm['messages']=$allpm['unreadpm'];

[finkdawg5]

It worked!!! Thanx!!

[Sparkz]

You're welcome :)
Copied it from someone way back... Can't remember who, though. Might have been Firefly.