//check for new friend requests
$frndreq = mysql_query("SELECT * FROM ".tb()."friend_reqs WHERE fid ='".$client['id']."'");
$checkreq = mysql_num_rows($frndreq);
//check for new messages
$checkmsg = mysql_query("SELECT * FROM ".tb()."messages WHERE to_id ='".$client['id']."' AND from_id > 0 AND hasread = 0");
$newmsg = mysql_num_rows($checkmsg);
//check for new notifications
$checknote = mysql_query("select * from `".tb()."messages` where to_id='{$client['id']}' and from_id=0 and !hasread");
$note = mysql_num_rows($checknote);
if($newmsg > '0' || $checkreq > '0' || $note > '0'){
if($newmsg > '0'){
echo '
'.$newmsg.' New Message(s)';
}
if($checkreq > '0'){
echo '
('.$checkreq.') New Friend Request(s)';
}
if($note > '0'){
echo '
('.$note.') New Notification(s)';
}
