<?php
include_once('settings.php');
include_once('class-phpass.php');
define('USER_EXISTS' , 0);
define('USER_NOT_EXISTS', 1);
define('SQL_ERROR' , 2);
function IsPlayerInBase($db_handle, $login, $password) {
global $players_table_name;
$wp_hasher = new PasswordHash(8, TRUE);
$user = array(
'login' => $login,
'password' => $password
);
$sql = $db_handle->prepare("SELECT `user_pass` FROM `{$players_table_name}` WHERE `user_login`=:login");
if ($sql->execute(array('login' => $login)) {
$password_hashed = $sql->fetchColumn();
if($wp_hasher->CheckPassword($password, $password_hashed)) {
return USER_EXISTS;
} else {
return USER_NOT_EXISTS;
}
} else {
return SQL_ERROR;
}
}
?>