/** * Login user using $email and $password * * @param LoginForm $form * @throws WrongCredentialsException */ public static function login(LoginForm $form) { $query = new SelectQuery(TUsers::_NAME, TUsers::EMAIL, $form->getEmail()); $user = $query->fetchOneRow()->getOrElse(WrongCredentialsException::class); if (password_verify($form->getPassword(), $user[TUsers::PASSWORD])) { self::$session->set($user[TUsers::ID], "auth", "id"); } else { throw new WrongCredentialsException(); } }
public static function filterAlbums(SelectQuery $query) { $query->where(sprintf("EXISTS (SELECT %s FROM %s INNER JOIN %s USING (id) WHERE %s = %s AND %s = %s)", MetadataTable::ALBUM_ID_FULL, MetadataTable::TABLE_NAME, AudiosTable::TABLE_NAME, MetadataTable::ALBUM_ID_FULL, MetaAlbumsTable::ID_FULL, AudiosTable::USER_ID_FULL, self::$me->getId())); }
/** * @param int $user_id */ public function __construct($user_id) { $query = new SelectQuery(TUsers::_NAME, TUsers::ID, $user_id); $this->user = $query->fetchOneRow()->getOrThrow(UserNotFoundException::class); $this->user_id = $user_id; }