/** * @param string $authCode7 * @param string $username * @param string $password * @param string $passwordCurrent */ public function modify($authCode7, $username, $password, $passwordCurrent) { $result = []; $result['code'] = 0; $result['msg'] = ''; $user = $this->verifyAuthCode7($authCode7); if ($user === false) { $result['code'] = 1; $result['msg'] = 'Invalid authCode7'; return $result; } $resultSet = $this->portfolio->getDatabase()->prepare('SELECT 1 FROM users WHERE id = :id AND password = :password')->setParameter('id', $user)->setParameter('password', $this->encryptPass($passwordCurrent))->executeQuery(); if (!$resultSet->next()) { $result['code'] = 2; $result['msg'] = 'Uw huidige wachtwoord komt niet overeen.'; return $result; } if (!empty($username) && strlen($username) >= 3) { $this->portfolio->getDatabase()->prepare('UPDATE users SET username = :username WHERE id = :id')->setParameter('username', $username)->setParameter('id', $user)->execute(); } if (!empty($password) && strlen($password) >= 3) { $this->portfolio->getDatabase()->prepare('UPDATE users SET password = :password WHERE id = :id')->setParameter('password', $this->encryptPass($password))->setParameter('id', $user)->execute(); } $result['code'] = 3; $result['msg'] = 'Uw gegevens zijn gewijzigd.'; if (empty($username) && empty($password) && strlen($username) < 3 && strlen($password) < 3) { $result['code'] = 4; $result['msg'] = 'Er is niks gewijzigd.'; } return $result; }
/** * @param int $page * * @return bool */ public function delete($page) { return $this->portfolio->getDatabase()->prepare('UPDATE pages SET visible = 0 WHERE id = :page')->setParameter('page', $page)->execute(); }