Add user into table
 

Hi,

Have been reading these forums all day and changed my coding a billion time, but can't find the error.

I use this coding to add a user into the 'user' table, which works well.
But I cant login using the username/password.

Can someone see the error?

// Create forum account

// Other variables
$salt = chr(rand(32, 126));
$password_md5 = md5(md5($password1 . $salt));
$password_date = date('Y-m-d');
$ip = $_SERVER['REMOTE_ADDR'];
$time = time();

// Connect to forum db
mysql_select_db ("savemovie_forums") or die(mysql_error());

// Into user into forum
mysql_query("INSERT INTO user SET usergroupid='3', username='$username', password='$password_md5', email='$email', passworddate='$password_date', showvbcode='1', showbirthday='0', usertitle='Junior Member', joindate='$time', lastvisit='$time', lastactivity='$time', reputationlevelid='5', timezoneoffset='0', pmpopup='1', options='3415', ipaddress='$ip', birthday='0000-00-00', languageid='1', salt='$salt' ") or die(mysql_error());

///////////////////////////////////////////////////////////////////////////

Also:

- What does the "options" field in the user table mean? What should I set the value at?

- How does I update the statistics in the buttom of the screen?
(Threads: 0, Posts: 0, Members: 3, Active Members: 3=
I found the table but how do I modify those data?
Can I include a file which will update it?

a:4:{s:13:"numbermembers";s:1:"3";s:13:"activememb ers";s:1:"3";s:11:"newusername ";s:10:"kingphilip";s:9:"newuserid";s:1:"5";}

//////////////////////////////////////////////

anyone?

Any programmers with good vBulletin skills (I will pay)?
Need this fixed.