MSSQL ERRO * Login.php

[fks157]

someone can help me ?

i dont know how to fix it

Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\Download\Login.php on line 11

im using xamp it didnt runs ...

 Spoiler

<?php
$conf['db_host'] = "WIN-4512\SQLEXPRESS";
$conf['db_user'] = "sa";
$conf['db_pass'] = "123456789";
$conf['db_name'] = "OdinAccounts";

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


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

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

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

$setToken = null;

if (mssql_num_rows(mssql_query("SELECT * FROM tTokens WHERE nEMID = '".$PlaintxtnEMID."'")) >= 1)
{
mssql_query("DELETE FROM tTokens WHERE nEMID = '".$PlaintxtnEMID."'");
$setToken = mssql_query("INSERT INTO tTokens (nEMID, sToken) VALUES('".$PlaintxtnEMID."', '".$Token."')");
}
else
$setToken = mssql_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');
}

mssql_close();

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

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

return $str;
}
?>

please help me !!

[0xDnFx3]

What do you not understand at:

Call to "undefined function" mssql_connect()

????

Import right libs and it will work.

[fks157]

please i need help with it !! what do u mean ?

[skeleten]

Doesn't XAMP use MySQL, not MS-SQL?

[*Kaito]

Dont matter

[fks157]

help me please D how to fix?

[0xDnFx3]

[D0n!]

Originally Posted by fks157

someone can help me ?

i dont know how to fix it

Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\Download\Login.php on line 11

im using xamp it didnt runs ...

 Spoiler

<?php
$conf['db_host'] = "WIN-4512\SQLEXPRESS";
$conf['db_user'] = "sa";
$conf['db_pass'] = "123456789";
$conf['db_name'] = "OdinAccounts";

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


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

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

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

$setToken = null;

if (mssql_num_rows(mssql_query("SELECT * FROM tTokens WHERE nEMID = '".$PlaintxtnEMID."'")) >= 1)
{
mssql_query("DELETE FROM tTokens WHERE nEMID = '".$PlaintxtnEMID."'");
$setToken = mssql_query("INSERT INTO tTokens (nEMID, sToken) VALUES('".$PlaintxtnEMID."', '".$Token."')");
}
else
$setToken = mssql_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');
}

mssql_close();

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

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

return $str;
}
?>

please help me !!

Your PHP that xampp is running needs the sqlsrv driver to be installed.

Informations on how to setup xampp and php_sqlsrv driver you can get here:

 Spoiler

http://bendustries.co/wp/setting-up-xampp-to-work-with-mssql/

read this mindful and you'll know whats the problem and how to fix it.

[0xDnFx3]

Warum hilfst du dem noob, er hätte wirklich nur googeln müssen und hatte sofort etwas gefunden sogar auf YouTube.

[D0n!]

Ich hatte meinen sozialen, sorry.
Aber er muss immernoch lesen und verstehen warum weshalb wieso, von daher.

[fks157]

its not working >< how to fix it?

[0xDnFx3]

Originally Posted by fks157

its not working >< how to fix it?

Solution was postet.

#CloseRequest : Reported 07:37 (UTC +1)