Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function auth($user = NULL, $pass = NULL)
- {
- $logon = $this->_registry->wow->realms->logon->conn;
- $user = strtoupper($user);
- $result = $logon->query(
- sprintf("SELECT * FROM account WHERE `username` = '%s' AND `sha_pass_hash` = '%s' LIMIT 0, 1",
- $logon->escape_string($user),
- $this->makeHash($user, $pass)
- )
- );
- if(!$result->num_rows)
- return false;
- $query = Doctrine_Query::create()
- ->from("User_UserModel u")
- ->where("u.username = ?", $user);
- if(!$query->count())
- {
- $data = new User_UserModel();
- $data->username = $user;
- $data->link("Groups", 2);
- $data->save();
- }
- else
- $data = $query->fetchOne();
- // User Authenticated set loggedin state
- $_SESSION["ip"] = md5($_SERVER['REMOTE_ADDR']);
- $data->Session = new User_SessionModel();
- $data->Session->session_id = session_id();
- $data->Session->ip = $_SERVER['REMOTE_ADDR'];
- $data->Session->startTime = time();
- $data->save();
- $_COOKIE["session_id"] = session_id();
- setcookie("session_id", session_id(), time() + 3600, $this->_registry->config->cookie->path, $this->_registry->config->cookie->domain);
- return true;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement