/** * Checks the number of entries of given login name * * @param string $login Loginname * @param array $optionslData Optional data * @return integer */ public function checkLogin($login, array $optionalData = null) { $check = sprintf("\n SELECT\n login\n FROM\n %sfaquserlogin\n WHERE\n login = '******'", SQLPREFIX, $this->db->escape_string($login)); $check = $this->db->query($check); $error = $this->db->error(); if (strlen($error) > 0) { $this->errors[] = $error; return 0; } return $this->db->num_rows($check); }
/** * Checks the number of entries of given login name * * @param string $login Loginname * @param array $optionalData Optional data * * @return integer */ public function checkLogin($login, array $optionalData = null) { $check = sprintf("\n SELECT\n login\n FROM\n %sfaquserlogin\n WHERE\n login = '******'", PMF_Db::getTablePrefix(), $this->db->escape($login)); $check = $this->db->query($check); $error = $this->db->error(); if (strlen($error) > 0) { $this->errors[] = $error; return 0; } return $this->db->numRows($check); }
/** * deletes the user from the database. * * @return boolean */ public function deleteUser() { if (!isset($this->user_id) || $this->user_id == 0) { $this->errors[] = self::ERROR_USER_NO_USERID; return false; } if (!isset($this->login) || strlen($this->login) == 0) { $this->errors[] = self::ERROR_USER_LOGIN_INVALID; return false; } if (isset($this->allowed_status[$this->status]) && $this->allowed_status[$this->status] == self::STATUS_USER_PROTECTED) { $this->errors[] = self::ERROR_USER_CANNOT_DELETE_USER . self::STATUS_USER_PROTECTED; return false; } $this->perm->refuseAllUserRights($this->user_id); $delete = sprintf("\n DELETE FROM\n %sfaquser\n WHERE\n user_id = %d", SQLPREFIX, $this->user_id); $res = $this->db->query($delete); if (!$res) { $this->errors[] = self::ERROR_USER_CANNOT_DELETE_USER . 'error(): ' . $this->db->error(); return false; } if (!$this->userdata instanceof PMF_User_UserData) { $this->userdata = new PMF_User_UserData($this->db); } $data = $this->userdata->delete($this->getUserId()); if (!$data) { $this->errors[] = self::ERROR_USER_CANNOT_DELETE_USERDATA; return false; } $read_only = 0; $auth_count = 0; $delete = array(); foreach ($this->auth_container as $auth) { $auth_count++; if ($auth->setReadOnly()) { $read_only++; continue; } $delete[] = $auth->delete($this->login); } if ($read_only == $auth_count) { $this->errors[] = self::ERROR_USER_NO_AUTH_WRITABLE; } if (!in_array(true, $delete)) { return false; } return true; }