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...

PHP Code:

    $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.