Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $movies = $db->query('SELECT
- `movie_key` AS `key`, /* Aqui eu informo que quero pegar o valor de "movie_key" e retornar em uma coluna chamada "key" */
- `movie_url` AS `url`, /* Aqui eu informo que quero pegar o valor de "movie_url" e retornar em uma coluna chamada "url" */
- `images_cover` AS `cover`,
- `movie_name` AS `name`,
- `movie_year` AS `year`
- FROM
- movies AS M,
- highlights AS H,
- images AS I
- WHERE
- (M.movie_key = H.featured_key AND I.images_key = M.movie_key)
- AND (I.images_type = H.featured_type)
- AND H.featured_status = "ativo"
- ORDER BY H.featured_id DESC
- LIMIT 5');
- $series = $db->query('SELECT
- `serie_key` AS `key`, /* Aqui eu informo que quero pegar o valor de "movie_key" e retornar em uma coluna chamada "key" */
- `serie_url` AS `url`, /* Aqui eu informo que quero pegar o valor de "movie_url" e retornar em uma coluna chamada "url" */
- `images_cover` AS `cover`,
- `serie_name` AS `name`,
- `serie_year` AS `year`
- FROM
- series AS S,
- highlights AS H,
- images AS I
- WHERE
- (S.serie_key = H.featured_key AND I.images_key = S.serie_key)
- AND (I.images_type = H.featured_type)
- AND H.featured_status = "ativo"
- ORDER BY H.featured_id DESC
- LIMIT 5');
- $animes = $db->query('SELECT
- `anime_key` AS `key`, /* Aqui eu informo que quero pegar o valor de "movie_key" e retornar em uma coluna chamada "key" */
- `anime_url` AS `url`, /* Aqui eu informo que quero pegar o valor de "movie_url" e retornar em uma coluna chamada "url" */
- `images_cover` AS `cover`,
- `anime_name` AS `name`,
- `anime_year` AS `year`
- FROM
- animes AS A,
- highlights AS H,
- images AS I
- WHERE
- (A.anime_key = H.featured_key AND I.images_key = A.anime_key)
- AND (I.images_type = H.featured_type)
- AND H.featured_status = "ativo"
- ORDER BY H.featured_id DESC
- LIMIT 5');
- echo Database::mostSeen($movies, "FILME");
- echo Database::mostSeen($series, "SÉRIE");
- echo Database::mostSeen($animes, "ANIME");
- public static function mostSeen($views, $type)
- {
- if($views->rowCount() != 0){
- while($database = $views->fetch())
- {
- //Gera a URL
- $url = sprintf(''.Loading::link('assistir', false).'%s/%s',
- //Traduz caracteres especiais como áéíóú
- strtolower(preg_replace("/W/", "", iconv("UTF-8", "ASCII//TRANSLIT", $type))),
- //Concatena a URL
- $database['url']);
- echo '
- <article class="w_item_b" id="post-'.$database['key'].'">
- <a href="'.$url.'">
- <div class="image">
- <img src="'.$database['cover'].'" alt="'.$database['name'].'" />
- </div>
- <div class="data">
- <h3>'.$database['name'].'</h3>
- <span class="wdate">'.$database['year'].'</span>
- <span class="wextra"><b><i class="icon-star2"></i> 7.5</b></span>
- </div>
- </a>
- </article>';
- }
- }
- }
Add Comment
Please, Sign In to add comment