예제 #1
0
파일: Auth.php 프로젝트: pldin601/HomeMusic
 /**
  * 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();
     }
 }
예제 #2
0
 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()));
 }
예제 #3
0
파일: User.php 프로젝트: pldin601/HomeMusic
 /**
  * @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;
 }