[powerful_rogue]

Originally Posted by Lynne

Of course it's an unknown column 'user.userid' in the field list - you aren't joining to the user table, so how would it get that field? But in the query you wrote, you use "$vbulletin->GPC['i']" which is a variable that is passed. That doesn't mean that line is still in the database. Have you looked at that table which testing this process and seen whether the row you want is still there?

What I was saying about global.php is that it's called in the register.php page, so I'm not sure it needs to be called again.

Hi Lynne,
I knew that about the unknown column, I was just showing how I got a database error that confirmed the correct activationID was being associated with the user.

Originally Posted by Dismounted

PHP Code:

$userdata = $db->query_first("
    SELECT u.username
    FROM " . TABLE_PREFIX . "useractivation AS ua
    LEFT JOIN " . TABLE_PREFIX . "user AS u USING (userid) 
    WHERE ua.activationid = '" . $vbulletin->db->escape_string($vbulletin->GPC['i']) . "'
    AND ua.emailchange = 0
    LIMIT 1
");

$username = $userdata['username']; 


Hi Discountinued.

I replaced

PHP Code:

$username = htmlspecialchars_uni($vbulletin->userinfo['username']); 


with the above query, however it then throws up this error after confirming the email address

Fatal error: Call to a member function save() on a non-object in /home/dc/public_html/testsite/register.php on line 1079