<?php
acms_header('Новости мира - категории');
is_active_module('PRIVATE_RNEWS');
require_once (ROOT.'/modules/rnews/plugins/config.php');
?>
<div class='menu-nav-content'>
<a class='menu-nav' href='/m/rnews/?'>
<?=lg('Новые')?>
</a>
<a class='menu-nav h' href='/m/rnews/categories/'>
<?=lg('Категории')?>
</a>
<a class='menu-nav' href='/m/rnews/rating/'>
<?=lg('Рейтинг')?>
</a>
</div>
<?
require_once (ROOT.'/modules/rnews/plugins/search.php');
require_once (ROOT.'/modules/rnews/plugins/settings.php');
$rnews_sql = null;
if ($news['RT'] != 1) { $rnews_sql .= ' AND `TYPE` != "https://russian.rt.com"'; }
if ($news['ABN'] != 1) { $rnews_sql .= ' AND `TYPE` != "https://abnews.ru"'; }
if ($news['KOMMERSANT'] != 1) { $rnews_sql .= ' AND `TYPE` != "https://www.kommersant.ru"'; }
if ($news['REN'] != 1) { $rnews_sql .= ' AND `TYPE` != "https://ren.tv"'; }
if ($news['REGNUM'] != 1) { $rnews_sql .= ' AND `TYPE` != "https://regnum.ru"'; }
if ($news['ANTIFASHIST'] != 1) { $rnews_sql .= ' AND `TYPE` != "https://antifashist.com"'; }
if ($news['AIF'] != 1) { $rnews_sql .= ' AND `TYPE` != "https://aif.ru"'; }
if ($news['EAD'] != 1) { $rnews_sql .= ' AND `TYPE` != "https://eadaily.com"'; }
if ($news['LENTA'] != 1) { $rnews_sql .= ' AND `TYPE` != "https://lenta.ru"'; }
if ($news['MOSLENTA'] != 1) { $rnews_sql .= ' AND `TYPE` != "https://moslenta.ru"'; }
if ($news['SE'] != 1) { $rnews_sql .= ' AND `TYPE` != "https://www.sport-express.ru"'; }
if ($news['TASS'] != 1) { $rnews_sql .= ' AND `TYPE` != "https://tass.ru"'; }
$id = intval(get('id'));
if ($id == 1){
$title = 'В России';
$column = db::get_column("SELECT COUNT(*) FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ? OR `CATEGORY` LIKE ?)", ['%Росси%', '%РФ%']);
$spage = spage($column, PAGE_SETTINGS);
$page = page($spage);
$limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
$data = db::get_string_all("SELECT * FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ? OR `CATEGORY` LIKE ?) ORDER BY `TIME` DESC LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Росси%', '%РФ%']);
}elseif ($id == 2){
$title = 'Главные новости';
$column = db::get_column("SELECT COUNT(*) FROM `RNEWS` WHERE `DELETE` = '0'");
$spage = spage($column, PAGE_SETTINGS);
$page = page($spage);
$limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
$data = db::get_string_all("SELECT * FROM `RNEWS` WHERE `DELETE` = '0' ORDER BY `TIME` DESC LIMIT ".$limit.", ".PAGE_SETTINGS);
}elseif ($id == 3){
$title = 'Политика';
$column = db::get_column("SELECT COUNT(*) FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ?)", ['%Политика%']);
$spage = spage($column, PAGE_SETTINGS);
$page = page($spage);
$limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
$data = db::get_string_all("SELECT * FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ?) ORDER BY `TIME` DESC LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Политика%']);
}elseif ($id == 4){
$title = 'Спорт';
$column = db::get_column("SELECT COUNT(*) FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ? OR `CATEGORY` LIKE ? OR `CATEGORY` LIKE ? OR `CATEGORY` LIKE ? OR `CATEGORY` LIKE ? OR `CATEGORY` LIKE ?)", ['%Спорт%', '%РПЛ%', '%Футбол%', '%Чемпионат%', '%Олимпиада%', '%Баскетбол%']);
$spage = spage($column, PAGE_SETTINGS);
$page = page($spage);
$limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
$data = db::get_string_all("SELECT * FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ? OR `CATEGORY` LIKE ? OR `CATEGORY` LIKE ? OR `CATEGORY` LIKE ? OR `CATEGORY` LIKE ? OR `CATEGORY` LIKE ?) ORDER BY `TIME` DESC LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Спорт%', '%РПЛ%', '%Футбол%', '%Чемпионат%', '%Олимпиада%', '%Баскетбол%']);
}elseif ($id == 5){
$title = 'Наука';
$column = db::get_column("SELECT COUNT(*) FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ? OR `CATEGORY` LIKE ?)", ['%Наука%', '%IT%']);
$spage = spage($column, PAGE_SETTINGS);
$page = page($spage);
$limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
$data = db::get_string_all("SELECT * FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ? OR `CATEGORY` LIKE ?) ORDER BY `TIME` DESC LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Наука%', '%IT%']);
}elseif ($id == 6){
$title = 'Бизнес';
$column = db::get_column("SELECT COUNT(*) FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ? OR `CATEGORY` LIKE ? OR `CATEGORY` LIKE ?)", ['%Бизнес%', '%Финансы%', '%Экономика%']);
$spage = spage($column, PAGE_SETTINGS);
$page = page($spage);
$limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
$data = db::get_string_all("SELECT * FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ? OR `CATEGORY` LIKE ? OR `CATEGORY` LIKE ?) ORDER BY `TIME` DESC LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Бизнес%', '%Финансы%', '%Экономика%']);
}elseif ($id == 7){
$title = 'Авто и мото';
$column = db::get_column("SELECT COUNT(*) FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ? OR `CATEGORY` LIKE ?)", ['%Авто%', '%Мото%']);
$spage = spage($column, PAGE_SETTINGS);
$page = page($spage);
$limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
$data = db::get_string_all("SELECT * FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ? OR `CATEGORY` LIKE ? ) ORDER BY `TIME` DESC LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Авто%', '%Мото%']);
}elseif ($id == 8){
$title = 'Технологии';
$column = db::get_column("SELECT COUNT(*) FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ?)", ['%Техно%']);
$spage = spage($column, PAGE_SETTINGS);
$page = page($spage);
$limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
$data = db::get_string_all("SELECT * FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ?) ORDER BY `TIME` DESC LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Техно%']);
}elseif ($id == 9){
$title = 'Шоу-бизнес';
$column = db::get_column("SELECT COUNT(*) FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ? OR `CATEGORY` LIKE ? OR `CATEGORY` LIKE ?)", ['%Звезды%', '%Актер%', '%Шоу-бизнес%']);
$spage = spage($column, PAGE_SETTINGS);
$page = page($spage);
$limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
$data = db::get_string_all("SELECT * FROM `RNEWS` WHERE `DELETE` = '0' AND (`CATEGORY` LIKE ? OR `CATEGORY` LIKE ? OR `CATEGORY` LIKE ?) ORDER BY `TIME` DESC LIMIT ".$limit.", ".PAGE_SETTINGS, ['%Звезды%', '%Актер%', '%Шоу-бизнес%']);
}
if ($id >= 1 && $id <= 9) {
?>
<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/rnews/plugins/list.php');
echo $rnews_list;
}
if ($column > 0){
?></div><?
}
get_page('/m/rnews/categories/?id='.$id.'&', $spage, $page, 'list');
back('/m/movies/categories/');
acms_footer();
}
?>
<div class='list-body'>
<b>
<a href='/m/rnews/categories/?id=1'>
<div class='list-menu hover'>
<?=icons('angle-double-right', 15, 'fa-fw')?> <?=lg('В России')?>
</div>
</a>
<a href='/m/rnews/categories/?id=2'>
<div class='list-menu hover'>
<?=icons('angle-double-right', 15, 'fa-fw')?> <?=lg('Главные новости')?>
</div>
</a>
<a href='/m/rnews/categories/?id=3'>
<div class='list-menu hover'>
<?=icons('angle-double-right', 15, 'fa-fw')?> <?=lg('Политика')?>
</div>
</a>
<a href='/m/rnews/categories/?id=4'>
<div class='list-menu hover'>
<?=icons('angle-double-right', 15, 'fa-fw')?> <?=lg('Спорт')?>
</div>
</a>
<a href='/m/rnews/categories/?id=5'>
<div class='list-menu hover'>
<?=icons('angle-double-right', 15, 'fa-fw')?> <?=lg('Наука')?>
</div>
</a>
<a href='/m/rnews/categories/?id=6'>
<div class='list-menu hover'>
<?=icons('angle-double-right', 15, 'fa-fw')?> <?=lg('Бизнес')?>
</div>
</a>
<a href='/m/rnews/categories/?id=7'>
<div class='list-menu hover'>
<?=icons('angle-double-right', 15, 'fa-fw')?> <?=lg('Авто и мото')?>
</div>
</a>
<a href='/m/rnews/categories/?id=8'>
<div class='list-menu hover'>
<?=icons('angle-double-right', 15, 'fa-fw')?> <?=lg('Технологии')?>
</div>
</a>
<a href='/m/rnews/categories/?id=9'>
<div class='list-menu hover'>
<?=icons('angle-double-right', 15, 'fa-fw')?> <?=lg('Шоу-бизнес')?>
</div>
</a>
</b>
</div>
<?
back('/', 'На главную');
acms_footer();