reducing pm queries?

i replaced this code segment:

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

with:

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

actually it works. use it guys it will seve you 2 queries.

[DrkFusion]

Thanks, this worked really well on my graphics board.

Thanks
Arunan