/** * When a user's credentials have been validated, get more info on that user * @param int $user_id * @return User */ public function ReadDataForValidUser($user_id) { $user = null; $sql = "SELECT user_id, known_as, name_first, name_last, email, \r\n disabled, activated, requested_email\r\n FROM nsa_user WHERE user_id = " . Sql::ProtectNumeric($user_id); $result = $this->GetDataConnection()->query($sql); $row = $result->fetch(); if ($row) { $user = new User(); $user->SetId($row->user_id); $user->SetName($row->known_as); $user->SetFirstName($row->name_first); $user->SetLastName($row->name_last); $user->SetEmail($row->email); $user->SetRequestedEmail($row->requested_email); $user->SetAccountActivated($row->activated); $user->SetAccountDisabled($row->disabled); } return $user; }