Launcher Error

**Mars** · 26-10-14

Hey everybody,
I'm trying to get my Login.php file for my launcher fixed.
The error we're getting is

Code:

Parse error: parse error in C:\xampp\htdocs\launcher\Login.php on line 14

Here's the Login.php code:

Code:

<?php
$conf['db_host'] = "";
$conf['db_user'] = "sa";
$conf['db_pass'] = "";
$conf['db_name'] = "OdinAccounts";


$user = sql_clean($_GET['Username']);
$passhash = sql_clean($_GET['Password']);




$constring = array("UID"=>$conf['db_user'],"PWD"=>$conf['db_pass'],"DATABASE"=>$conf['db_name']);
$con = sqlsrv_connect($conf['db_host'],$constring) or die('Database connect Fail.');


$exec = sqlsrv_query($conn, $sql "SELECT nEMID, sUserPass FROM tAccounts where sUsername = '$user'");


if($exec)
{
    if(sqlsrv_num_rows($exec) != 1)
    {
        die('Wrong Username.');
    }
    $AccountData = sqlsrv_fetch_assoc($exec);
    $PlaintxtPass = $AccountData['sUserPass'];
    $PlaintxtnEMID = $AccountData['nEMID'];
    if (MD5($PlaintxtPass) == $passhash)
    {
        $Token = RandomToken(35);


        $setToken = null;


        if (sqlsrv_num_rows(sqlsrv_query("SELECT * FROM tTokens WHERE nEMID = '".$PlaintxtnEMID."'")) >= 1)
        {
            sqlsrv_query("DELETE FROM tTokens WHERE nEMID = '".$PlaintxtnEMID."'");
            $setToken = sqlsrv_query("INSERT INTO tTokens (nEMID, sToken) VALUES('".$PlaintxtnEMID."', '".$Token."')");
        }
        else
            $setToken = sqlsrv_query("INSERT INTO tTokens (nEMID, sToken) VALUES('".$PlaintxtnEMID."', '".$Token."')");


        if ($setToken)
            die('OK#'.$Token);
        else
            die('SetToken Error');
    }
    else
    {
        die('Wrong Password.');
    }
}
else
{
    die('Query Failed');
}


sqlsrv_close();


function sql_clean($str)
{
    $search  = array("\\", "\0", "\n", "\r", "\x1a", "'", '"');
    $replace = array("", "", "", "", "", "", "");
    return str_replace($search, $replace, $str);
}


function RandomToken( $length )
{
    $chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
        $str = "";
    $size = strlen( $chars );
    for( $i = 0; $i < $length; $i++ ) {
        $str .= $chars[ rand( 0, $size - 1 ) ];
    }


    return $str;
}
?>

Any help is appreciated.
Thanks

**MentaL**

**Canic** · 27-10-14

Code:

<?php
$conf['db_host'] = "";
$conf['db_user'] = "sa";
$conf['db_pass'] = "";
$conf['db_name'] = "OdinAccounts";

$user = sql_clean($_GET['Username']);
$passhash = sql_clean($_GET['Password']);

$constring = array("UID"=>$conf['db_user'], "PWD"=>$conf['db_pass'], "Database"=>$conf['db_name']);
$con = sqlsrv_connect($conf['db_host'], $constring) or die('Database connect Fail.');


$exec = sqlsrv_query($conn, "SELECT nEMID, sUserPass FROM tAccounts where sUsername = ?", array($user), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));


if($exec)
{
    if(sqlsrv_num_rows($exec) != 1)
    {
        die('Wrong Username.');
    }
    $AccountData = sqlsrv_num_rows($exec);
    $PlaintxtPass = $AccountData['sUserPass'];
    $PlaintxtnEMID = $AccountData['nEMID'];
    if (MD5($PlaintxtPass) == $passhash)
    {
        $Token = RandomToken(35);

        $setToken = null;

        if (sqlsrv_num_rows(sqlsrv_query($conn, "SELECT * FROM tTokens WHERE nEMID = ?;", array($PlaintxtnEMID), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ))) >= 1)
        {
            sqlsrv_query($conn, "DELETE FROM tTokens WHERE nEMID = ?;", array($PlaintxtnEMID));
            $setToken = sqlsrv_query($conn, "INSERT INTO tTokens (nEMID, sToken) VALUES(?, ?);", array($PlaintxtnEMID, $Token));
        }else{
			$setToken = sqlsrv_query($conn, "INSERT INTO tTokens (nEMID, sToken) VALUES(?, ?);", array($PlaintxtnEMID, $Token));
		}
		
        if ($setToken)
            die('OK#'.$Token);
        else
            die('SetToken Error');
    }
    else
    {
        die('Wrong Password.');
    }
}
else
{
    die('Query Failed');
}

function sql_clean($str)
{
    $search  = array("\\", "\0", "\n", "\r", "\x1a", "'", '"');
    $replace = array("", "", "", "", "", "", "");
    return str_replace($search, $replace, $str);
}


function RandomToken( $length )
{
    $chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
        $str = "";
    $size = strlen( $chars );
    for( $i = 0; $i < $length; $i++ ) {
        $str .= $chars[ rand( 0, $size - 1 ) ];
    }

    return $str;
}
?>

should work now ;)

**Mars** · 27-10-14

Originally Posted by Canic

Code:

<?php
$conf['db_host'] = "";
$conf['db_user'] = "sa";
$conf['db_pass'] = "";
$conf['db_name'] = "OdinAccounts";

$user = sql_clean($_GET['Username']);
$passhash = sql_clean($_GET['Password']);

$constring = array("UID"=>$conf['db_user'], "PWD"=>$conf['db_pass'], "Database"=>$conf['db_name']);
$con = sqlsrv_connect($conf['db_host'], $constring) or die('Database connect Fail.');


$exec = sqlsrv_query($conn, "SELECT nEMID, sUserPass FROM tAccounts where sUsername = ?", array($user), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));


if($exec)
{
    if(sqlsrv_num_rows($exec) != 1)
    {
        die('Wrong Username.');
    }
    $AccountData = sqlsrv_num_rows($exec);
    $PlaintxtPass = $AccountData['sUserPass'];
    $PlaintxtnEMID = $AccountData['nEMID'];
    if (MD5($PlaintxtPass) == $passhash)
    {
        $Token = RandomToken(35);

        $setToken = null;

        if (sqlsrv_num_rows(sqlsrv_query($conn, "SELECT * FROM tTokens WHERE nEMID = ?;", array($PlaintxtnEMID), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ))) >= 1)
        {
            sqlsrv_query($conn, "DELETE FROM tTokens WHERE nEMID = ?;", array($PlaintxtnEMID));
            $setToken = sqlsrv_query($conn, "INSERT INTO tTokens (nEMID, sToken) VALUES(?, ?);", array($PlaintxtnEMID, $Token));
        }else{
            $setToken = sqlsrv_query($conn, "INSERT INTO tTokens (nEMID, sToken) VALUES(?, ?);", array($PlaintxtnEMID, $Token));
        }
        
        if ($setToken)
            die('OK#'.$Token);
        else
            die('SetToken Error');
    }
    else
    {
        die('Wrong Password.');
    }
}
else
{
    die('Query Failed');
}

function sql_clean($str)
{
    $search  = array("\\", "\0", "\n", "\r", "\x1a", "'", '"');
    $replace = array("", "", "", "", "", "", "");
    return str_replace($search, $replace, $str);
}


function RandomToken( $length )
{
    $chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
        $str = "";
    $size = strlen( $chars );
    for( $i = 0; $i < $length; $i++ ) {
        $str .= $chars[ rand( 0, $size - 1 ) ];
    }

    return $str;
}
?>

should work now ;)

Now this error pops up when I try to go to the page like "examplesite.com/launcher/Login.php"

Code:

Warning: sqlsrv_query() expects parameter 1 to be resource, null given in C:\xampp\htdocs\launcher\Login.php on line 14
Query Failed

Sorry, I completely suck at PHP

**Mars** · 28-10-14

Update: More information about the error

Code:

Warning: sqlsrv_query() expects parameter 1 to be resource, null given in C:\xampp\htdocs\launcher\Login.php on line 14
Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -33 (code) => -33 [2] => Invalid value type for option Database was specified. String type was expected. [message] => Invalid value type for option Database was specified. String type was expected. ) ) Query Failed

**xKeRnx** · 28-10-14

$con = sqlsrv_connect($conf['db_host'],$constring) or die('Database connect Fail.');

Change it to :

$conn = sqlsrv_connect($conf['db_host'],$constring) or die('Database connect Fail.');

Now it should work

**Mars** · 28-10-14

Originally Posted by xKeRnx

$con = sqlsrv_connect($conf['db_host'],$constring) or die('Database connect Fail.');

Change it to :

$conn = sqlsrv_connect($conf['db_host'],$constring) or die('Database connect Fail.');

Now it should work

It should display the text "Wrong username" when I try to go to http://examplesite.com/login.php" right?

**xKeRnx** · 28-10-14

what says the error log?

- - - Updated - - -

also when you will show if the website work then open it so examplesite.com/login.php?Username=plaplapla&Password=md5password

- - - Updated - - -

plaplapla is your Username
and md5password is your password with md5

**Mars** · 28-10-14

Now it says wrong password when I put the information in.

**xKeRnx** · 28-10-14

oh sh sorry i have do a mistake do enter your normal pw the script encoded the pw sorry also
examplesite.com/login.php?Username=plaplapla&Password=normalpassword

**Mars** · 28-10-14

Are you talking about the alt password?

**xKeRnx** · 28-10-14

also the password without encoding but your password in your database must have md5 encoding

**Mars** · 28-10-14

I found a thread on encrypted passwords, but I think it's for the older files.

- - - Updated - - -

Originally Posted by xKeRnx

also the password without encoding but your password in your database must have md5 encoding

Skype me?

**xKeRnx** · 28-10-14

ok but you must give me your addy i have a sh windows account :D

**Mars** · 28-10-14

Originally Posted by xKeRnx

ok but you must give me your addy i have a sh windows account :D

It's dakarai27tc

**Mars** · 30-10-14

Hey, when we try to login via the launcher, we get the error "Wrong password and password" and the information is typed correctly.
We added a tit.php file, and we're getting the php error "Call to undefined function sql_clean on line 7"
This is the code for it

Code:

<?php
$conf['db_host'] = "";
$conf['db_user'] = "sa";
$conf['db_pass'] = "";
$conf['db_name'] = "OdinAccounts";


$token = sql_clean($_GET['token']); 


$con = sqlsrv_connect($conf['db_host'],$conf['db_user'],$conf['db_pass']) or die('Database connect Fail.'); 
$db = sqlsrv_select_db($conf['db_name'], $con) or die('Database Init Fail.'); 


$exec = sqlsrv_query("SELECT [tAccounts].[nEMID], [tAccounts].[sUsername] FROM [tAccounts], [tTokens] WHERE [tAccounts].[nEMID] = [tTokens].[nEMID] and [tTokens].[sToken] = '$token'"); 


if($exec) 
{ 
    if(sqlsrv_num_rows($exec) != 1)
	{
        die('te1'); //Token Error
		}
    $AccountData = sqlsrv_fetch_assoc($exec); 
    $PlaintxtName = $AccountData['sUsername']; 
    $PlaintxtnEMID = $AccountData['nEMID']; 


echo '{"token_age":0,"user_id":'.$PlaintxtName.',"login":"'.$PlaintxtnEMID.'","user_role":"user","blocked":false}';


}
?>

**Mars** · 01-11-14

Ok, this is hopefully my last post. And hopefully someone replies :(
We got the launcher to start the game, but it's not logging in, it's saying "Authentication Failed".
Here's the code in our Login.php:

Code:

<?php
$conf['db_host'] = "";
$conf['db_user'] = "sa";
$conf['db_pass'] = "";
$conf['db_name'] = "OdinAccounts";


$user = sql_clean($_GET['Username']);
$passhash = sql_clean($_GET['Password']);


$constring = array("UID"=>$conf['db_user'], "PWD"=>$conf['db_pass'], "Database"=>$conf['db_name']);
$conn = sqlsrv_connect($conf['db_host'],$constring) or die('Database connect Fail.');




$exec = sqlsrv_query($conn, "SELECT nEMID, sUserPass FROM tAcc
ounts where sUsername = ?", array($user), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));




if($exec)
{
    if(sqlsrv_num_rows($exec) != 1)
    {
        die('Wrong Username.');
    }
    $AccountData = sqlsrv_num_rows($exec);
    $PlaintxtPass = $AccountData['sUserPass'];
    $PlaintxtnEMID = $AccountData['nEMID'];
    if (MD5($PlaintxtPass) == $passhash)
    {
        $Token = RandomToken(35);


        $setToken = null;


        if (sqlsrv_num_rows(sqlsrv_query($conn, "SELECT * FROM tTokens WHERE nEMID = ?;", array($PlaintxtnEMID), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ))) >= 1)
        {
            sqlsrv_query($conn, "DELETE FROM tTokens WHERE nEMID = ?;", array($PlaintxtnEMID));
            $setToken = sqlsrv_query($conn, "INSERT INTO tTokens (nEMID, sToken) VALUES(?, ?);", array($PlaintxtnEMID, $Token));
        }else{
            $setToken = sqlsrv_query($conn, "INSERT INTO tTokens (nEMID, sToken) VALUES(?, ?);", array($PlaintxtnEMID, $Token));
        }
        
        if ($setToken)
            die('OK#'.$Token);
        else
            die('SetToken Error');
    }
    else
    {
        die('Wrong Password.');
    }
}
else
{
    die('Query Failed');
}


function sql_clean($str)
{
    $search  = array("\\", "\0", "\n", "\r", "\x1a", "'", '"');
    $replace = array("", "", "", "", "", "", "");
    return str_replace($search, $replace, $str);
}




function RandomToken( $length )
{
    $chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
        $str = "";
    $size = strlen( $chars );
    for( $i = 0; $i < $length; $i++ ) {
        $str .= $chars[ rand( 0, $size - 1 ) ];
    }


    return $str;
}
?>

If you need to know anything else to better help me, please let me know.
Thanks

**Jaeru** · 02-11-14

Originally Posted by Marrs

Ok, this is hopefully my last post. And hopefully someone replies :(
We got the launcher to start the game, but it's not logging in, it's saying "Authentication Failed".
Here's the code in our Login.php:

Code:

<?php
$conf['db_host'] = "";
$conf['db_user'] = "sa";
$conf['db_pass'] = "";
$conf['db_name'] = "OdinAccounts";


$user = sql_clean($_GET['Username']);
$passhash = sql_clean($_GET['Password']);


$constring = array("UID"=>$conf['db_user'], "PWD"=>$conf['db_pass'], "Database"=>$conf['db_name']);
$conn = sqlsrv_connect($conf['db_host'],$constring) or die('Database connect Fail.');




$exec = sqlsrv_query($conn, "SELECT nEMID, sUserPass FROM tAcc
ounts where sUsername = ?", array($user), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));




if($exec)
{
    if(sqlsrv_num_rows($exec) != 1)
    {
        die('Wrong Username.');
    }
    $AccountData = sqlsrv_num_rows($exec);
    $PlaintxtPass = $AccountData['sUserPass'];
    $PlaintxtnEMID = $AccountData['nEMID'];
    if (MD5($PlaintxtPass) == $passhash)
    {
        $Token = RandomToken(35);


        $setToken = null;


        if (sqlsrv_num_rows(sqlsrv_query($conn, "SELECT * FROM tTokens WHERE nEMID = ?;", array($PlaintxtnEMID), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ))) >= 1)
        {
            sqlsrv_query($conn, "DELETE FROM tTokens WHERE nEMID = ?;", array($PlaintxtnEMID));
            $setToken = sqlsrv_query($conn, "INSERT INTO tTokens (nEMID, sToken) VALUES(?, ?);", array($PlaintxtnEMID, $Token));
        }else{
            $setToken = sqlsrv_query($conn, "INSERT INTO tTokens (nEMID, sToken) VALUES(?, ?);", array($PlaintxtnEMID, $Token));
        }
        
        if ($setToken)
            die('OK#'.$Token);
        else
            die('SetToken Error');
    }
    else
    {
        die('Wrong Password.');
    }
}
else
{
    die('Query Failed');
}


function sql_clean($str)
{
    $search  = array("\\", "\0", "\n", "\r", "\x1a", "'", '"');
    $replace = array("", "", "", "", "", "", "");
    return str_replace($search, $replace, $str);
}




function RandomToken( $length )
{
    $chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
        $str = "";
    $size = strlen( $chars );
    for( $i = 0; $i < $length; $i++ ) {
        $str .= $chars[ rand( 0, $size - 1 ) ];
    }


    return $str;
}
?>

If you need to know anything else to better help me, please let me know.
Thanks

You must be forgetting something, thing to remember:
- Autentication errors are always RestServer/Token related.

Now go and check your RestServer Logs and come back again... unless you can figure by your self what to do...

**Mars** · 02-11-14

Originally Posted by Jaeru

You must be forgetting something, thing to remember:
- Autentication errors are always RestServer/Token related.

Now go and check your RestServer Logs and come back again... unless you can figure by your self what to do...

It lets you log into any account though. If I put in asdfa;lksdj;k as the username and a;lkja;sldkfj as the password, it still launches the game.

- - - Updated - - -

Edit: It's saying "Wrong password or password" now

- - - Updated - - -

Originally Posted by Jaeru

You must be forgetting something, thing to remember:
- Autentication errors are always RestServer/Token related.

Now go and check your RestServer Logs and come back again... unless you can figure by your self what to do...

Code:

[8] [11/2/2014 7:28:50 PM] :: NoToken: Mars

Here's what's in the log.

**Jaeru** · 02-11-14

Originally Posted by Marrs

Code:

[8] [11/2/2014 7:28:50 PM] :: NoToken: Mars

Here's what's in the log.

As I see, your Launcher (Login.php) script is not inserting correctly the tokens to the database, or the RestServer is setted up in another IP, different one than the "stubedore.t" (if you are not using custom RestServer you must do that in host file)...

Code:

127.0.0.1 stubedore.t

And you need to set the OdinRestServerSettings.shn to the same IP (127.0.0.1 unless you change the one in hosts file, but those both need to be the same to send to the correct place the token request),

Launcher Error

Thread Tools

Search Thread

Launcher Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Login.php Parse Error

Re: Launcher Error

Re: Launcher Error

Re: Launcher Error

Re: Launcher Error

Advertisement