MySQL Help

Originally Posted by pyro.699

$db->query_write("
UPDATE `" . TABLE_PREFIX . "user` SET `rpg_name` = 'Life' WHERE '" . $vbulletin->userinfo['userid'] . "'
`rpg_sex` = 'Life'
`rpg_skin` = 'Life'
`rpg_eyes` = 'Life'
`rpg_hair` = 'Life'
`rpg_age` = 'Life'
`rpg_height` = 'Life'
`rpg_build` = 'Life' WHERE '" . $vbulletin->userinfo['userid'] . "';
");

this is the query for my current rpg script, sorry if your offended by the word "sex".

it wont run, theres no errors, everytuhgn is fine, except it dosent do its job /;

Try this....

PHP Code:


$rpg = $db->query_write("UPDATE ". TABLE_PREFIX ."user
                  SET rpg_name='life', rpg_sex='life', rpg_skin='life', rpg_eyes='life',
                      rpg_hair='life', rpg_age='life', rpg_height='life', rpg_build='life'
                  WHERE userid='" . $vbulletin->userinfo['userid'] . "' 
                 "); 


Also, you should alter the default vbulletin user table, as it doesn't follow normalization rules. It would be best to make a seperate table and join the tables via userid. I'm also not sure if userid is the correct field name in the user table.