$tmpname = $vbulletin->db->query_first("SELECT email FROM " . TABLE_PREFIX . "user WHERE username = '" . $username . "'"); $useremail = $tmpname['email'];