Ich suche eine funktinoerende Login.php
Ich weis es wurden schon mehere released aber diese bringen dauent fehlermeldungen
ZB die von xArva:
// Config - End
$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 (isset($_GET['username']) && isset($_GET['password'])){
$user = sql_clean($_GET['username']);
$pass = sql_clean($_GET['password']);
}else{
echo 'error';
exit();
}
if($exec)
{
if(mssql_num_rows($exec) != 1)
{
die('Account Not Found.');
}
$AccountData = mssql_fetch_assoc($exec);
$PlaintxtPass = $AccountData['sUserPass'];
$PlaintxtnEMID = $AccountData['nEMID'];
if (MD5($PlaintxtPass) == $passhash)
{
$Token = RandomToken(50);
$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;
}
?>
[Credits gehen hierbei an xArva]
zeigt mir wenn ich eingebe ..../Download/Login.php?Username=testp&Password=testp
ERROR
oder die von Cannic
[auch hier gehen die credits an Cannic ]
conf['db_name'] = "OdinAccounts";
//############### DON'T EDIT AFTER THIS LINE #############
if (isset($_GET['username']) && isset($_GET['password'])){
$user = sql_clean($_GET['username']);
$pass = sql_clean($_GET['password']);
}else{
echo 'error';
exit();
}
$con = $connectionInfo = array( "Database"=>$INFO['SQLDB'], "UID"=>$INFO['SQLUID'], "PWD"=>$INFO['SQLPWD']);
$conn = sqlsrv_connect( $INFO['SQLHost'], $connectionInfo);
$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('User does not exist');
}
$AccountData = sqlsrv_fetch_array($exec);
$PlaintxtPass = $AccountData['sUserPass'];
$PlaintxtnEMID = $AccountData['nEMID'];
if ($PlaintxtPass == $pass)
{
$Token = RandomToken(50);
$setToken = null;
$checkTokensRows = sqlsrv_query($conn, "SELECT * FROM tTokens WHERE nEMID = ?", array($PlaintxtnEMID), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
if (sqlsrv_num_rows($checkTokensRows) >= 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('success#'.$Token);
}else{
die('SetToken Error'.print_r(sqlsrv_errors(), True));
}
}
else
{
die('error 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 = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVW XYZ0123456789";
$str = "";
$size = strlen( $chars );
for( $i = 0; $i < $length; $i++ ) {
$str .= $chars[ rand( 0, $size - 1 ) ];
}
return $str;
}
?>
welche mir zeigt
Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\Download\LoginKa.php on line 13
line 13:
$con = mssql_connect($conf['db_host'],$conf['db_user'],$conf['db_pass']) or die('Database connect Fail.');
Vielen Dank im vorraus für alle Lösungsvorschläge oder Sinnvolle Beiträge
xI3lackVirs
PS: RECHTSCHREIBUNG FTW
#edit
muss noch hinzufügen das oben die leiste mit der confic weggelassen worden ist weil pw undso
OdinAccounts Stimmt auch also daran kanns nicht liegen
LG
xI3lackVirus
