PHP Code:
$wturid = $db->query_first("
SELECT userid
FROM useractivation
WHERE activationid = '" . $db->escape_string($vbulletin->GPC['i']) . "'
AND emailchange=0;
");
$username = $db->query_first("
SELECT username
FROM user
WHERE userid = '$wturid'
");
Just wondered if anyone could have a quick look at this piece of code for me. For some reason its not posting the username in the result but leaving an empty space.