[Help] Web Resgister

[242badman]

i been trying for months the web register but always get a fatal error for Shaiya Epic 4.5

this is the error i always get: Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\1.php on line 32


this is line 32
$conn=mssql_connect(127.0.0.1 ,Shaiya,Shaiya123);

thanks in advance

[MentaL]

[KILLSTEAL]

did your Server files have this passwort for conection on SQL ?

Shaiya & shaiya123 or did you change this ?

[Twilight]

this is the error i always get: Fatal error: Call to undefined function mssql_connect()

in php.ini two parameters:
example

http://forum.ragezone.com/f400/solut...onnect-650068/

and restart ur webserver
.

[242badman]

did your Server files have this passwort for conection on SQL ?

Shaiya & shaiya123 or did you change this ?

yes it's haa the PW to connected to the SQL

---------- Post added at 01:35 PM ---------- Previous post was at 01:16 PM ----------

in php.ini two parameters:
example

http://forum.ragezone.com/f400/solut...onnect-650068/

and restart ur webserver
.

i did what is the link and still have same issue

[242badman]

i fixed the issue thanks now i have another one

in this script

<?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','email@email.com','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!";
                }
        }
    }
    
?>

this 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!