Because the password from db its not md5 anymore and the function from site it does checking for the md5 password from db when it is in binary. If you really know some php i can provide my own code for login and you can remake the function for login. Here you go:
PHP Code:function login($username, $password) {
$login = mssql_query(sprintf("SELECT * from ".DB_LOGIN.".[dbo].[cabal_auth_table] where ID = '%s'",str_replace("'", "''", $username)));
$result = mssql_fetch_row($login);
$login_result_valid_encrypt_password = mssql_query('exec '.DB_LOGIN.'.dbo.cabal_sp_IsValidPassword_by_ID "'.$result[1].'" , "'.$password.'"');
$login_result= mssql_fetch_array($login_result_valid_encrypt_password);
$this->login_attempts($username);
return $login_result;
}
May be useful
PHP Code:<?
if (isset($_POST['sbmtOk'])){
$txtLogin = $_POST['txtLogin'];
$txtSenha = $_POST['txtSenha'];
if(eregi("[^0-9a-zA-Z ]", $txtLogin))
$Error .= "<font color=red>Login invalid</font>";
if(eregi("[^0-9a-zA-Z ]", $txtSenha))
$Error .= "<font color=red>Password invalid</font>";
if(empty($Error) == false)
echo '<div class=\'ferror\'>
<center><b>'.$Error.'</b> </center>
</div>';
else
{
$sql_Conta = mssql_num_rows(mssql_query("select ID from ".DB_ACC.".dbo.cabal_auth_table where ID='".$txtLogin."'"));
if($sql_Conta <= 0)
{
echo'<div class=\'ferror\'>
<center> <b><font color=red>Login invalid</font></b> </center>
</div>';
}
else
{
$sql_Senha = mssql_num_rows(mssql_query("select Password from ".DB_ACC.".dbo.cabal_auth_table where ID='".$txtLogin."' and PWDCOMPARE('".$txtSenha."', password) = 1"));
if($sql_Senha <= 0)
{
echo '<div class=\'ferror\'>
<center><b><font color=red>Password invalid</font></b> </center>
</div>';
}
else
{
$_SESSION['ss_txtLogin'] = $txtLogin;
$_SESSION['ss_txtSenha'] = $sql_Senha;
echo '<div class=\'ferror\'>
<center><font color="#39e62c">CONFIRMED DATA WAIT</font></center>
</div>';
echo"<meta http-equiv=refresh content=\"1;URL=./index.php\">";
}
}
mssql_close();
}
}
?>
I'm undertand. Thank you. But I use sqlsrv PHP: SQLSRV Функции - Manual
How me change mssql_fetch_row ?
Here you go: MSSQL vs. SQLSRV: What’s the Difference? (Part 2) - Brian Swan - Site Home - MSDN Blogs and happy codding.
CT4 login settings complete ^_^ with ADODB odbc_mssql.
i suggest you make your own web. if you gonna use sqlsrv, if you gonna use sqlsrv go to pdo Here the example