AddNew User Into........

[Logitech-2004]

I Build A Nifty Little Shoping Cart, And It Has It's Own Member Management System, But I Wanted To Add A Small Code To Add The User Into The VB3 Database, But My SQL Query Must Be Wrong.... Or Something. Worked Great In Vb2.3.3.


$query="INSERT INTO user (usergroupid,username,password,passworddate,email, styleid,usertitle,salt,daysprune,reputation,pmpopu p,startofweek,pmtotal,pmunread,threadedmode,autosu bscribe,maxpost,referrerid,birthday_search,option, autosubscribe) VALUES ('$usergroupid','$username','$saltedpassword','$tr ansactiondate','$email','0','$title','$salt','0',' 10','1','1','0','0','0','-1','-1','0','0000-00-00','6487','-1')";
mysql_query($query);
$userid=mysql_insert_id();
$query="INSERT INTO userfield SET userid='$userid'";
mysql_query($query);
mysql_close();


Any Ideas?

[Mr. HillBilly]

Wrong area.

[Xenon]

*moved*

[Logitech-2004]

Anybody?

[insanctus]

Are you getting any errors ?

Or is it just not inserting?

[Logitech-2004]

Not Inserting.

[Logitech-2004]

Heres Some The Info:

$membershipstatus="Active";
$membershipexp=date('Ymd',time()+365*24*3600);
$membershippackage="PackageC";
$transactiontype="PackageC";
$transactiondate=date('Ymd',time());
$transactionamount=$HTTP_POST_VARS['mvc_MONEY'];
$transactionid=$HTTP_POST_VARS['transaction_id'];
$usergroupid="9";
$transactionprocessor="MVC";
$softwarekeys=2;
$title='Private Memeber';

$username=$HTTP_POST_VARS['mvc_NICK'];
$password=$HTTP_POST_VARS['mvc_PASSWORD'];
$nomd5pass=$HTTP_POST_VARS['mvc_PASSWORD'];
$password=md5(md5($password));
$email=$HTTP_POST_VARS['mvc_EMAIL'];
$salt='AbC'; <- I Change That Every Day.
$saltedpassword=md5(md5($password) . $salt);

[Logitech-2004]

Well I Got That Fixed... Next Problem Is, Am I Doing The Password Encoding Correctly?

$nomd5pass=$HTTP_POST_VARS['mvc_PASSWORD'];
$salt="AbC";
$saltedpassword=md5(md5($nomd5pass) . $salt);

[Logitech-2004]

Ok I Think I Got The Passwird Thing Worked Out. But VBull. Is Saying The Password Is Wrong Or The User Name Is Invalid.... :(

Heres The Entire Code.

//POST Vars.
$username=$HTTP_POST_VARS['mvc_NICK'];
$nomd5pass=$HTTP_POST_VARS['mvc_PASSWORD'];
$password=md5(md5($password));
$email=$HTTP_POST_VARS['mvc_EMAIL'];
$salt="AbC";

//PASSWORD
if (strlen(md5($nomd5pass)) == 32) {
$saltedpassword=md5($nomd5pass . $salt);
} else {
$saltedpassword=md5(md5($nomd5pass) . $salt);
}

//Add User To The VB3 Database.
$query="INSERT INTO user (usergroupid,displaygroupid,username,password,pass worddate,email,parentemail,usertitle,salt) VALUES ('$usergroupid','$usergroupid','$username','$passw ord','$transactiondate','$email','$email','$title' ,'$salt')";

mysql_query($query);
$userid=mysql_insert_id();
$query="INSERT INTO userfield SET userid='$userid'";
mysql_query($query);
$query="INSERT INTO usertextfield (userid) VALUES ($userid)";
mysql_query($query);


Help......

[Logitech-2004]

Did I Ask To Hard Of A Question? It Must Be Simple For You Advace Coders ;)