function __construct($params, $login, $pass)
{
$dbh = new PDO("mysql:host={$params['host']};dbname={$params['db']};", $params['username'], $params['password']);
$login = $dbh->quote($login);
$hash = $dbh->quote(passSalt($pass));
$stmt = $dbh->query("\n SELECT *\n FROM USERS \n WHERE HASH = {$hash}\n AND LOGIN = {$login}\n ;") or die(print_r($dbh->errorInfo(), true));
$data = $stmt->fetchAll();
if ($data[0]['U_ID'] != false) {
$expiration = time() + 86400;
setcookie('auth', 'true', $expiration, "/", false);
setcookie('user', $login, $expiration, "/", false);
header("Location: http://" . $_SERVER['SERVER_NAME'] . "/fnx_journals");
die;
} else {
return 0;
}
}
function addExampleUser($dbh, array $userdata)
{
$user = $dbh->quote($userdata[0]);
$pass = $dbh->quote(passSalt($userdata[1]));
$wallet = $dbh->quote($userdata[2]);
echo $user;
$dbh->query("\n INSERT INTO `USERS`(`LOGIN`, `HASH`, `WALLET`) \n SELECT * FROM (SELECT {$user}, {$pass}, {$wallet}) AS tmp\n WHERE NOT EXISTS (\n SELECT * FROM `USERS` \n WHERE `LOGIN` = {$user})\n ;") or die(print_r($dbh->errorInfo(), true));
echo "<p>Test user <b>'" . $user . "'</b> was added to database</p>";
return 0;
}
