SQL queries to create a valid user

[zivester]

I'm creating my own registration form outside of the vbulletin templates... I would like to know what queries are required to successfully add a user to vbulletin. I've done a simple insert into vb_user table but when I try to edit that user from the admincp (they do show up), the form errors and I cannot edit them.

heres the query i use from php (it executes fine without any errors):

 $query = "INSERT INTO vb_user " .  "(usergroupid,username,password,passworddate,email,usertitle,joindate,lastvisit,lastactivity,timezoneoffset,birthday,birthday_search,ipaddress,languageid,salt) " .    "VALUES($usergroupid,'$username','$password',$passworddate,'$email','$usertitle',$joindate,$lastvisit,$lastactivity,$timezoneoffset,'$birthday',$birthday_search,'$ipaddress',$languageid,'$salt')";

What else must be done to create a user?