Query problem with username

[kh99]

You would just insert it where you use $username in the query. For example in the code nhawk posted it would be:

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

$useremail = $tmpname['email'];