kgp43
02-18-2006, 12:36 AM
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:"activemembers";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.
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:"activemembers";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.