/** * getUserByLogin - Check login data andset email vars * * @access public * @param $emailname * @param $password * @return boolean */ public function getUserByLogin($username, $password) { $query = "SELECT username, password FROM zp_user \n\t\t WHERE username = :username LIMIT 1"; $stmn = $this->db->{'database'}->prepare($query); $stmn->bindValue(':username', $username, PDO::PARAM_STR); $stmn->execute(); $returnValues = $stmn->fetch(); $userCounter = count($returnValues); $stmn->closeCursor(); //echo 'getUserByLogin count:'. $userCounter; if ($userCounter === false || !$this->hasher->CheckPassword($password, $returnValues['password'])) { //echo 'return false<br>'; unset($_SESSION['userdata']); unset($_SESSION['template']); unset($_COOKIE); return false; } else { // $query = "SELECT \n\t\t\t\t\tid,\n\t\t\t\t\tusername,\n\t\t\t\t\trole,\n\t\t\t\t\tlastname AS name\n\t\t\t\t\t\n\t\t\t\t\t\tFROM zp_user \n\t\t\t WHERE username = :username\n\t\t\t LIMIT 1"; //echo $query; $stmn = $this->db->{'database'}->prepare($query); $stmn->bindValue(':username', $username, PDO::PARAM_STR); $stmn->execute(); $returnValues = $stmn->fetch(); $stmn->closeCursor(); $this->name = $returnValues['name']; $this->mail = $returnValues['username']; $this->userId = $returnValues['id']; $user = new users(); $roles = $user->getRole($returnValues['role']); $this->role = $roles['roleName']; $setting = new setting(); $roleArray = explode(',', $this->role); $this->sysOrgs = $setting->getSysOrgsStringByRoles($roleArray); return true; } }