Tell us about yourself! Edit your profile now, just click here!
 |
logged in as:
Guest
query( "SELECT *, p.id as msgid FROM pms p LEFT JOIN members m ON p.from=m.id WHERE p.`to`=".$user["id"]." AND p.alerted=0 AND p.read_state=0" );
if ( $db->countRows() > 0 )
{
if ( $db->countRows() == 1 )
{
$r = $db->fetch();
$dgsd = "You have received a new message from ".$r["username"]." entitled \"".$r["subject"]."\".\n\nWould you like to read it now?";
?>
countRows();
$dgsd = "You have $r new messages! \n\nWould you like to go to your inbox now?";
?>
query( "UPDATE pms SET alerted=1 WHERE `to`=".$user["id"]." AND alerted=0" );
}
$db->query( "SELECT * FROM members WHERE plays>".intval($user["plays"])." OR (plays=".intval($user["plays"])." AND id<=".intval($user["id"]).")" );
$user["rank"] = $db->countRows();
?>
|
||||||
|
|||||||