[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'];