[grey_goose]

I run an RPG forum and user accounts are both players -and- characters. I've got a table with character (characters) info and I want to check it to see if a new account is for a character and if it is to populate some custom userfields.

It doesn't work :P

Taking a shot in the dark here, but is it because there's not a username/userid assigned yet? Is there some way to get the information or should I just add a query for the current MAX(userid), increment it, and use that? Or have I made some other mistake?

hook location: register_addmember_complete

PHP Code:

// Need to get variables
$getusername = $vbulletin->userinfo['username']; 
$getuserid = $vbulletin->userinfo['userid']; 

// Need to get Venue info and see if the new account exists as a current character
$result = $vbulletin->db->query_first_slave("
    SELECT Venue AS venue 
    FROM characters 
    WHERE char_userid = '$getuserid'
");  

// If the result is empty it's a player account 
// If the result isn't empty proceed
if (!empty($result)) {
    $venue = $result['venue'];
    $tracker = '[trackermini=$venue]'.$getusername.'[/trackermini]';
    
    // Update our custom profile fields
    $db->query_write("
        UPDATE userfield
        SET field260 = 'No',
            field101 = '$venue',
            field209 = '$getusername',
            field26 = '$getusername',
            field235 = '$tracker'
        WHERE userid = '$getuserid'
    ");
}