[Opserty]

If you are just selecting the first result try this:

PHP Code:

$user_f_rep = $vbulletin->db->query_first("
                        SELECT reputation.reputation, reputation.userid
                        FROM " . TABLE_PREFIX . "reputation AS reputation
                        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (reputation.userid = user.userid)
                        WHERE reputation.userid = '". $vbulletin->userinfo['userid'] ."'
                    ");