error during registration

[punkADA]

this is my registration script :

[code]
<?

include "core.php";

//Preregistartion processing. Making the password string a valid format
$aaa=$_REQUEST['login'].$_REQUEST['pass'];
$md=md5($aaa);
$cc="0x";
$md52=$cc.$md;
$login = $_REQUEST['login'];
$question = $_REQUEST['question'];
$answer = $_REQUEST['answer'];
$email = $_REQUEST['email'];
$gender = $_REQUEST['gender'];
$realname = $_REQUEST['realname'];
$dn = 9401108; //$_REQUEST['dn'];
$mnumber = 9401108; //$_REQUEST['mnumber'];
$pnumber = 9401108; //$_REQUEST['pnumber'];
$province = "Japan"; //$_REQUEST['province'];
$city = $_REQUEST['city'];
$address = "777 Lucky Street"; //$_REQUEST['address'];
$zip = "777"; //$_REQUEST['zip'];

// Connection with MSSQL server
$conn=mssql_connect($SERVER,$ADMIN_NAME,$ADMIN_PASS);
$db = mssql_select_db($DATABASE,$conn) or die("Conex

[MentaL]

[chapellier]

hello,

i'am not sure but in your query adduser :

"exec adduser $login',$md52,'$question',$answer,'$realname',$dn','$email',$mnumber,'$province','$city',$pnumber,'$address','$zip','$gender','','1',$md52";

you have a single quote at $login' ... test with '$login' or $login without quote ...

bye

[punkADA]

hi, thanks four u post.

this way,

$query = "exec adduser '$login',$md52,'$question','$answer','$realname','$dn','$email','$mnumber','$province','$city','$pnumber','$address','$zip','$gender','','1',$md52";

i get this error :


Warning: mssql_query() [function.mssql-query]: message: Cannot insert duplicate key row in object 'users' with unique index 'IX_users_name'. (severity 14) in C:\AppServ\www\register\processor.php on line 39

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\register\processor.php on line 39
Failed to execute query! Something went wrong...

thanks, since now.

[elmon]

error in "adduser" script... can u show it?

[punkADA]

yeah, of course!

[code]
<?

include "core.php";

//Preregistartion processing. Making the password string a valid format
$aaa=$_REQUEST['login'].$_REQUEST['pass'];
$md=md5($aaa);
$cc="0x";
$md52=$cc.$md;
$login = $_REQUEST['login'];
$question = $_REQUEST['question'];
$answer = $_REQUEST['answer'];
$email = $_REQUEST['email'];
$gender = $_REQUEST['gender'];
$realname = $_REQUEST['realname'];
$dn = 9401108; //$_REQUEST['dn'];
$mnumber = 9401108; //$_REQUEST['mnumber'];
$pnumber = 9401108; //$_REQUEST['pnumber'];
$province = "Japan"; //$_REQUEST['province'];
$city = $_REQUEST['city'];
$address = "777 Lucky Street"; //$_REQUEST['address'];
$zip = "777"; //$_REQUEST['zip'];

// Connection with MSSQL server
$conn=mssql_connect($SERVER,$ADMIN_NAME,$ADMIN_PASS);
$db = mssql_select_db($DATABASE,$conn) or die("Conex