how can i fix this
in this script
his error
im getting this error
Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'Users_Detail'. (severity 16) in C:\xampp\htdocs\processor.php on line 40
Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\processor.php on line 40
Create Users_Detail Error! Thanks
in this script
PHP Code:
<?php
$ip = $_SERVER['REMOTE_ADDR'];
$userid = trim($_POST['userid']);
$pass = trim($_POST['pass']);
$repass = trim($_POST['passp']);
$cash_point = 1000000;
// Connection with MSSQL server
$conn=mssql_connect('127.0.0.1','Shaiya','Shaiya123');
$db = mssql_select_db('PS_UserData',$conn) or die("MSSQL Conection Error!");
$res = mssql_query("SELECT UserID FROM PS_UserData.dbo.Users_Master WHERE (UserID) = ('".$userid."')");
if (mssql_num_rows($res))
{
echo "Login already exist.";
}
else
{
if ($pass != $repass)
{
echo 'Passwords mismatch.';
}
else
{
// Check Last UserUID Number
$checkuseruid = "SELECT Max(UserUID) AS max FROM PS_UserData.dbo.Users_Master";
$resultado = mssql_query($checkuseruid);
$captura = mssql_fetch_array($resultado);
$UserUID = $captura["max"]+1;
// Insert Start
$query1 = mssql_query("INSERT INTO Users_Master (UserUID,UserID,Pw,JoinDate,Admin,AdminLevel,UseQueue,Status,Leave,LeaveDate,UserType,Point,EnPassword,UserIp) VALUES ('".$UserUID."','".$userid."','".$pass."',getdate(),'0','0','0','0','0',getdate(),'1','".$cash_point."','0','".$ip."')");
if ( $query1 == 1 )
{
$query2 = "exec OMG_GameWeb.dbo.sp_CreateOmgGMGameAccount '".$UserUID."','".$userid."','".$pass."','0'";
$rresult2 = mssql_query($query2) or die("Create GameAccountTBL Error!");
$query3 = mssql_query("INSERT INTO Users_Detail (UserID,UserUID,UserName,PwQuestion,PwAnswer,Email,NewsLetter,Sms,AdultAuth,EmailAuth) VALUES ('".$userid."','".$UserUID."','Real Name','Question?','Answer','[Only registered and activated users can see links. Click Here To Register...]','0','0','0','0')");
if ( $query3 == 1 )
{
$query4 = mssql_query("INSERT INTO Users_Block (UserUID,BlockEndDate) VALUES ('".$UserUID."',getdate())");
if ( $query4 == 1 )
{
echo "The account was created successfully.<br /><br /><b>User:</b> $userid<br><b>Password:</b> $pass";
}
else
{
echo "Create Users_Block Error!";
}
}
else
{
echo "Create Users_Detail Error!";
}
}
else
{
echo "Create Users_Master Error!";
}
}
}
?>
his error
im getting this error
Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'Users_Detail'. (severity 16) in C:\xampp\htdocs\processor.php on line 40
Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\processor.php on line 40
Create Users_Detail Error! Thanks
