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; } }