All pastes #909665 Raw Edit

Someone

public text v1 · immutable
·published 2008-02-19 11:48 UTC
rendered paste body
$unreadmessages = ''; 
if($_COOKIE['bbuserid']) { 
    $sql_usersb = "SELECT count(*) FROM pm WHERE userid = " . $_COOKIE['bbuserid'] . " AND messageread = 0"; 
    $query_usersb = mysql_query($sql_usersb); 
    if(mysql_num_rows($query_usersb) == 1) { 
        $row_usersb = mysql_fetch_row($query_usersb); 
        if($row_usersb[0] > 0) 
            $unreadmessages = " (" . $row_usersb[0] .")"; 
    } 
} else if($_COOKIE['bbsessionhash']) { 
    $sql_usersb = "SELECT loggedin, userid FROM session WHERE sessionhash = '" . $_COOKIE['bbsessionhash'] . "'"; 
    $query_usersb = mysql_query($sql_usersb); 
    if(mysql_num_rows($query_usersb) == 1) { 
        $row_userb = mysql_fetch_array($query_usersb); 
        if($row_userb['loggedin'] == 2){ 
            $sql_usersb1 = "SELECT count(*) FROM pm WHERE userid = " . $row_userb['userid'] . " AND messageread = 0"; 
            $query_usersb1 = mysql_query($sql_usersb1); 
            if(mysql_num_rows($query_usersb1) == 1) { 
                $row_usersb = mysql_fetch_row($query_usersb1); 
                if($row_usersb[0] > 0) 
                    $unreadmessages = " (" . $row_usersb[0] .")"; 
            }         
        } 
    } 
}