Guest User

Untitled

a guest
Jan 18th, 2018
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.11 KB | None | 0 0
  1. $movies = $db->query('SELECT
  2. `movie_key` AS `key`, /* Aqui eu informo que quero pegar o valor de "movie_key" e retornar em uma coluna chamada "key" */
  3. `movie_url` AS `url`, /* Aqui eu informo que quero pegar o valor de "movie_url" e retornar em uma coluna chamada "url" */
  4. `images_cover` AS `cover`,
  5. `movie_name` AS `name`,
  6. `movie_year` AS `year`
  7. FROM
  8. movies AS M,
  9. highlights AS H,
  10. images AS I
  11. WHERE
  12. (M.movie_key = H.featured_key AND I.images_key = M.movie_key)
  13. AND (I.images_type = H.featured_type)
  14. AND H.featured_status = "ativo"
  15. ORDER BY H.featured_id DESC
  16. LIMIT 5');
  17.  
  18. $series = $db->query('SELECT
  19. `serie_key` AS `key`, /* Aqui eu informo que quero pegar o valor de "movie_key" e retornar em uma coluna chamada "key" */
  20. `serie_url` AS `url`, /* Aqui eu informo que quero pegar o valor de "movie_url" e retornar em uma coluna chamada "url" */
  21. `images_cover` AS `cover`,
  22. `serie_name` AS `name`,
  23. `serie_year` AS `year`
  24. FROM
  25. series AS S,
  26. highlights AS H,
  27. images AS I
  28. WHERE
  29. (S.serie_key = H.featured_key AND I.images_key = S.serie_key)
  30. AND (I.images_type = H.featured_type)
  31. AND H.featured_status = "ativo"
  32. ORDER BY H.featured_id DESC
  33. LIMIT 5');
  34.  
  35. $animes = $db->query('SELECT
  36. `anime_key` AS `key`, /* Aqui eu informo que quero pegar o valor de "movie_key" e retornar em uma coluna chamada "key" */
  37. `anime_url` AS `url`, /* Aqui eu informo que quero pegar o valor de "movie_url" e retornar em uma coluna chamada "url" */
  38. `images_cover` AS `cover`,
  39. `anime_name` AS `name`,
  40. `anime_year` AS `year`
  41. FROM
  42. animes AS A,
  43. highlights AS H,
  44. images AS I
  45. WHERE
  46. (A.anime_key = H.featured_key AND I.images_key = A.anime_key)
  47. AND (I.images_type = H.featured_type)
  48. AND H.featured_status = "ativo"
  49. ORDER BY H.featured_id DESC
  50. LIMIT 5');
  51.  
  52. echo Database::mostSeen($movies, "FILME");
  53. echo Database::mostSeen($series, "SÉRIE");
  54. echo Database::mostSeen($animes, "ANIME");
  55.  
  56. public static function mostSeen($views, $type)
  57. {
  58. if($views->rowCount() != 0){
  59. while($database = $views->fetch())
  60. {
  61. //Gera a URL
  62. $url = sprintf(''.Loading::link('assistir', false).'%s/%s',
  63.  
  64. //Traduz caracteres especiais como áéíóú
  65. strtolower(preg_replace("/W/", "", iconv("UTF-8", "ASCII//TRANSLIT", $type))),
  66.  
  67. //Concatena a URL
  68. $database['url']);
  69.  
  70. echo '
  71. <article class="w_item_b" id="post-'.$database['key'].'">
  72. <a href="'.$url.'">
  73. <div class="image">
  74. <img src="'.$database['cover'].'" alt="'.$database['name'].'" />
  75. </div>
  76. <div class="data">
  77. <h3>'.$database['name'].'</h3>
  78. <span class="wdate">'.$database['year'].'</span>
  79. <span class="wextra"><b><i class="icon-star2"></i> 7.5</b></span>
  80. </div>
  81. </a>
  82. </article>';
  83. }
  84. }
  85. }
Add Comment
Please, Sign In to add comment