function login($name, $password)
{
global $user, $userdb, $page;
$res = $userdb->getRow("SELECT auth_id, passwd FROM authenticate WHERE username='******'");
if (DB::isError($res)) {
raiseError($res);
}
if ($res['passwd'] != $password) {
error_log("Login failed for {$name} from " . getHostName(), 0);
return $page->getlocalized("invalid_login");
} else {
$user = new sotf_User($res['auth_id']);
debug("Login successful", $user->name . ' = ' . $user->id);
$userdb->query("UPDATE user_preferences SET num_logins=num_logins+1, last_visit='" . db_Wrap::getSQLDate() . "' WHERE auth_id='" . $user->id . "' ");
$_SESSION['currentUserId'] = $user->id;
}
}
function login($name, $password)
{
global $user, $userdb, $page;
$pwd = $userdb->getOne("SELECT passwd FROM authenticate WHERE username='******'");
if (DB::isError($pwd)) {
raiseError("could not compare passwords");
}
if ($pwd != $password) {
error_log("Login failed for {$name} from " . getHostName(), 0);
return $page->getlocalized("invalid_login");
} else {
$user = new sotf_User($name);
$userdb->query("UPDATE user_preferences SET num_logins=num_logins+1, last_visit='" . db_Wrap::getSQLDate() . "' WHERE auth_id='" . $user->id . "' ");
$_SESSION['username'] = $user->name;
}
}
