Will not update user
 

Hey, i'm trying to make a small license verifier. Basicly, i make up a number like "123456". And put it into a field in the user table. Do if user is from usergroup id 2 then they need to add ther license #, and when its entered correcly they will be updated to usergroupid #9, This is to insure that members from vbhacks.us have a valid vbulletin, we've deciced it would be the best thing. So please any help is appricated.

This code below almost works. When a user has not verified there license, it will ask them to, once they enter "123456" it will check the database to make sure that is the correct number, if it is they get a success page, if it is not, they will get a error page. the only thing it's not doing is updating the user to the proper usergroup. It acually doesn't touch them at all.

Heres the code

Read the forum descriptions next time ;) Moved to PHP/MySQL.

erm, i don't see an update query, so you may have forgotten the most important part ^^

[SQL]UPDATE user SET usergroupid=9 where userid=xx[/sql]

Thanks Xenon! I remember adding that to the script when i first started but my tired brain must have deleted for some reason. Works perfect now :)

*gg*

you're welcome :)