View file modules/movies/genre.php

File size: 17.54Kb
<?php  
acms_header('Онлайн кинотеатр - жанры');
is_active_module('PRIVATE_MOVIES');
require_once (ROOT.'/modules/movies/plugins/config.php');

?> 
<div class='menu-nav-content'>
  
<a class='menu-nav' href='/m/movies/?'>
<?=lg('Все')?>
</a>
    
<a class='menu-nav h' href='/m/movies/genre/'>
<?=lg('Жанры')?>
</a>
    
<a class='menu-nav' href='/m/movies/rating/'>
<?=lg('ТОП')?>
</a>
    
<a class='menu-nav' href='/m/movies/new/'>
<?=lg('Новинки')?>
</a>
  
</div> 
<?

require_once (ROOT.'/modules/movies/plugins/search.php');
require_once (ROOT.'/modules/movies/plugins/settings.php');
$id = intval(get('id'));

if ($id == 1){
  
  $title = 'Фантастика';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ?", ['%Фантастика%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Фантастика%']);
  
}elseif ($id == 2){
  
  $title = 'Комедии';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Комедии%', '%Комедия%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Комедии%', '%Комедия%']);
  
}elseif ($id == 3){
  
  $title = 'Боевики';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ?", ['%Боевик%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Боевик%']);
  
}elseif ($id == 4){
  
  $title = 'Мультфильмы';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ?", ['%Мультфильм%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Мультфильм%']);
  
}elseif ($id == 5){
  
  $title = 'Анимэ';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Анимэ%', '%Аниме%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Анимэ%', '%Аниме%']);
  
}elseif ($id == 6){
  
  $title = 'Биографии';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Биография%', '%Биографии%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Биография%', '%Биографии%']);
  
}elseif ($id == 7){
  
  $title = 'Вестерны';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ?", ['%Вестерн%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Вестерн%']);
  
}elseif ($id == 8){
  
  $title = 'Военные';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Военные%', '%Военный%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Военные%', '%Военный%']);
  
}elseif ($id == 9){
  
  $title = 'Детективы';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ?", ['%Детектив%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Детектив%']);
  
}elseif ($id == 10){
  
  $title = 'Драмы';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Драма%', '%Драмы%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Драма%', '%Драмы%']);
  
}elseif ($id == 11){
  
  $title = 'Документальные';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Документальные%', '%Документальный%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Документальные%', '%Документальный%']);
  
}elseif ($id == 12){
  
  $title = 'Фэнтези';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Фентези%', '%Фэнтези%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Фентези%', '%Фэнтези%']);
  
}elseif ($id == 13){
  
  $title = 'Ужасы';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Мистика%', '%Ужас%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Мистика%', '%Ужас%']);
  
}elseif ($id == 14){
  
  $title = 'Триллеры';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ?", ['%Триллер%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Триллер%']);
  
}elseif ($id == 15){
  
  $title = 'Спортивные';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Спорт%', '%Футбол%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Спорт%', '%Футбол%']);
  
}elseif ($id == 16){
  
  $title = 'Детские';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Детские%', '%Детский%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Детские%', '%Детский%']);
  
}elseif ($id == 17){
  
  $title = 'Приключения';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Приключения%', '%Приключение%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Приключения%', '%Приключение%']);
  
}elseif ($id == 18){
  
  $title = 'Русские фильмы';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `COUNTRY` LIKE ?", ['%Россия%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `COUNTRY` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Россия%']);
  
}elseif ($id == 19){
  
  $title = 'Турецкие фильмы';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `COUNTRY` LIKE ?", ['%Турция%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `COUNTRY` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Турция%']);
  
}elseif ($id == 20){
  
  $title = 'Индийские фильмы';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `COUNTRY` LIKE ?", ['%Индия%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `COUNTRY` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Индия%']);
  
}elseif ($id == 21){
  
  $title = 'Корейские фильмы';
  $column = db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `COUNTRY` LIKE ?", ['%Корея Южная%']);
  $spage = spage($column, PAGE_SETTINGS);
  $page = page($spage);
  $limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
  $data = db::get_string_all("SELECT * FROM `MOVIES` WHERE `COUNTRY` LIKE ? LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Корея Южная%']);
  
}

if ($id >= 1 && $id <= 21) {
  
  ?>
  <div class='list'><b><?=lg('Жанр')?> "<?=lg($title)?>"</b></div>
  <?
    
  if ($column == 0){ 
    
    html::empty('Пока пусто');
  
  }else{
    
    ?><div class='list-body'><?
    
  }
  
  while ($list = $data->fetch()) {
    
    require (ROOT.'/modules/movies/plugins/list.php');
    echo $movie_list;
  
  }
  
  if ($column > 0){ 
    
    ?></div><?
    
  }
  
  get_page('/m/movies/genre/?id='.$id.'&', $spage, $page, 'list');
  
  back('/m/movies/genre/');
  acms_footer();
  
}
  
?>
<div class='list-body'>
<b>
    
<a href='/m/movies/genre/?id=1'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Фантастика')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ?", ['%Фантастика%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=2'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Комедии')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Комедии%', '%Комедия%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=3'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Боевики')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ?", ['%Боевик%'])?></span></span>
</div>
</a> 
  
<a href='/m/movies/genre/?id=4'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Мультфильмы')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ?", ['%Мультфильм%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=5'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Анимэ')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Анимэ%', '%Аниме%'])?></span></span>
</div>
</a> 
  
<a href='/m/movies/genre/?id=6'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Биографии')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Биография%', '%Биографии%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=7'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Вестерны')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ?", ['%Вестерн%'])?></span></span>
</div>
</a> 
  
<a href='/m/movies/genre/?id=8'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Военные')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Военные%', '%Военный%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=9'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Детективы')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ?", ['%Детектив%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=10'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Драмы')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Драма%', '%Драмы%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=11'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Документальные')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Документальные%', '%Документальный%'])?></span></span>
</div>
</a> 
  
<a href='/m/movies/genre/?id=12'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Фэнтези')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Фентези%', '%Фэнтези%'])?></span></span>
</div>
</a> 
  
<a href='/m/movies/genre/?id=13'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Ужасы')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Мистика%', '%Ужас%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=14'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Триллеры')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ?", ['%Триллер%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=15'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Спортивные')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Спорт%', '%Футбол%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=16'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Детские')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Детские%', '%Детский%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=17'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Приключения')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `GENRE` LIKE ? OR `GENRE` LIKE ?", ['%Приключения%', '%Приключение%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=18'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Русские фильмы')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `COUNTRY` LIKE ?", ['%Россия%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=19'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Турецкие фильмы')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `COUNTRY` LIKE ?", ['%Турция%'])?></span></span>
</div>
</a> 
  
<a href='/m/movies/genre/?id=20'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Индийские фильмы')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `COUNTRY` LIKE ?", ['%Индия%'])?></span></span>
</div>
</a>
  
<a href='/m/movies/genre/?id=21'>
<div class='list-menu hover'>
<?=icons('film', 20, 'fa-fw')?> <span style='position: relative; top: 1px'><?=lg('Корейские фильмы')?> <span class='count'><?=db::get_column("SELECT COUNT(*) FROM `MOVIES` WHERE `COUNTRY` LIKE ?", ['%Корея Южная%'])?></span></span>
</div>
</a>
  
</b>
</div>
<?

back('/', 'На главную');
acms_footer();