View file ä󿪫¬/modules/news/index.php

<?php


foreach (array('start', 'compress', 'sess', 'settings', 'db_connect', 'ipua', 'fnc', 'user') as $inc) {
    require_once "../../sys/inc/$inc.php";
}

$doc->Title('Новости');

require_once H . 'sys/inc/thead.php';

#Заголовок
aut();

#Путь папки новостей
define('DIR_NEWS', "/modules/news/");

#Сокращаем пути
if (isset($_GET['edit'])) {
    require_once H . DIR_NEWS . 'edit.php';
} elseif (isset($_GET['delete'])) {
    require_once H . DIR_NEWS . 'delete.php';
} elseif (isset($_GET['add'])) {
    require_once H . DIR_NEWS . 'add.php';
} elseif (isset($_GET['settings'])) {
    require_once H . DIR_NEWS . 'settings.php';
} elseif (isset($_GET['edit_komm'])) {
    require_once H . DIR_NEWS . 'edit_komm.php';
} elseif (isset($_GET['news'])) {
    require_once H . DIR_NEWS . 'news.php';
} elseif (isset($_GET['new_komm'])) {
    require_once H . DIR_NEWS . 'komm.php';
} elseif (isset($_GET['add'])) {
    require_once H . DIR_NEWS . 'add.php';
} else {
    $k_post = $pdo->query(("SELECT COUNT(*) FROM `news`"), 0)->fetchColumn();
    $k_page = k_page($k_post, $set['p_str']);
    $page = page($k_page);
    $start = $set['p_str'] * $page - $set['p_str'];
    $q = $pdo->query("SELECT * FROM `news` ORDER BY `id` DESC LIMIT $start, $set[p_str]");

    #Навигация
    echo "<div class='card-header'>";
    echo "<a href='/' class='hint--right' data-hint='" . lang('На главную') . "'><i class='fa fa-home fa-lg'></i></a> <i class='fa fa-angle-right fa-fw'></i> ";
    echo lang('Новости');
    echo "</div>";
echo "<div class='list-group-item-komm'>";     
echo "<table style='width: 100%; text-align: center;'><tr>
<td class='fn-lefti-o'><a style='display: block;$padding_menu' href='/modules/news/'><font color=#587C94><b>НОВОСТИ</b></font></a></td>
<td class='fn-righti'><a style='display: block;$padding_menu' href='/modules/news/journal/'><b><font color=#587C94>ЖУРНАЛ ОБНОВЛЕНИЙ</font></b></a></td>
</tr></table>";    
echo "</div>";     
    
 if (access('adm_news_add') && isset($user)) {    
echo "<div class='list-group-item'>"; 
echo "<a href='?add' class='btn btn-primary btn-sm'><i class='fa fa-plus fa-fw'></i> Создать новость</a> ";
echo "</div>";    
}
    #Выводим список новостей
    while ($post = $q->fetch(PDO::FETCH_ASSOC)) {
        $like = $pdo->query(("SELECT COUNT(*) FROM `news_like` WHERE `id_news` = '" . $post['id'] . "'"), 0)->fetchColumn();

        echo "<div class='list-group-item'>";

       
echo "<i class='fa fa-bullhorn fa-fw'></i> <a href='?news=$post[id]'>" . text($post['title']) . "</a>";

echo "<span style='float: right;'>";
echo "<small><span title='" . date::time($post['time']) . "'>" . date::timek($post['time']) . "</span></small>";
echo "</span><br /><br />";

$files = $pdo->query("SELECT * FROM `news_files` WHERE `id_post` = '$post[id]' LIMIT 3");

while ($posti = $files->fetch(PDO::FETCH_ASSOC))
{

if($posti['type']=='foto'){
$file_id = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$posti[id_user]' AND `id` = '".$posti['id_file']."'")->fetch(PDO::FETCH_BOTH);	
if(isset($file_id['id'])){
$ras = htmlspecialchars(text($file_id['ras']));
		
if (IS_WEB == 1) {

	echo "<img class='avatar' src='/modules/foto/foto128/".$file_id['id'].".".$file_id['ras']."' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 85px; height:85px;'>\n";
}else{
	echo "<img class='avatar' src='/modules/foto/foto128/".$file_id['id'].".".$file_id['ras']."' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 70px; height: 70px;'>\n";
}}
}

if($posti['type']=='files'){
if(is_file(H.'modules/news/img/'.$posti['id'].'.jpg')){
if (IS_WEB == 1) {
echo "<img class='avatar' src='/modules/news/img/" . $posti['id'] . ".jpg' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 85px; height:85px;'>\n";
}else{
echo "<img class='avatar' src='/modules/news/img/" . $posti['id'] . ".jpg' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 70px; height: 70px;'>\n";
} 
}
}
}
echo "<br />\n";        
        
        
        
        
        #Текст новости
        echo toOutput(cutStr($post['msg'], 80)) . "<br /><br />";



        if (isset($user)) {


            if ($post['link'] != NULL) {
                echo "<a href='" . htmlentities($post['link'], ENT_QUOTES, 'UTF-8') . "' class='btn btn-info-outline btn-sm hint--right' data-hint='" . lang('Перейти, чтобы узнать подробности') . "'><i class='fa fa-link fa-fw'></i> " . lang('Источник') . "</a> ";
            }
           
                $l = $pdo->query(("SELECT COUNT(*) FROM `news_like` WHERE `id_news` = '$post[id]'"), 0)->fetchColumn();
            

            if ($pdo->query(("SELECT COUNT(*) FROM `news_like` WHERE `id_news` = '$post[id]' AND `id_user` = '$user[id]' LIMIT 1"), 0)->fetchColumn() == 0) {
                echo "<a href='?news=$post[id]&amp;likes' class='btn btn-info-outline btn-sm hint--right' data-hint='" . lang('Мне нравится') . "'><i class='fa fa-heart-o fa-fw'></i> $l</a> ";
            } else {
                echo "<a href='?news=$post[id]&amp;unlikes' class='btn btn-info-outline btn-sm hint--right' data-hint='" . lang('Вам понравилась новость') . "'><i class='fa fa-heart fa-fw'></i> $l</a> ";
            }
            
$pod=$pdo->query(("SELECT COUNT(*)FROM `notes` WHERE `share_id`='$post[id]' AND `share_type`='news'"),0)->fetchColumn();

echo "<a href='/modules/news/share.php?id=$post[id]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Поделиться') . "'>";
echo "<i class='fa fa-mail-forward fa-fw'></i> $pod</span></a> ";
            
$comm=$pdo->query(("SELECT COUNT(*) FROM `news_komm` WHERE `id_news`='$post[id]'"),0)->fetchColumn();
echo "<a href='?news=$post[id]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Комментарии') . "'>";
echo "<i class='fa fa-comments fa-fw'></i> $comm</span></a>";            
            
            
            
$count7 = $pdo->query(("SELECT COUNT(*) FROM `news_count` WHERE `id_news` = '".$post['id']."' LIMIT 1"),0)->fetchColumn();
            
            #Просмотры
            echo "<span style='float: right;' class='hint--right btn btn-info-outline btn-sm' data-hint='" . lang('Просмотрели') . " " . sklon_text($count7, array(lang('раз'), lang('раза'), lang('раз'))) . "'><i class='fa fa-eye fa-fw'></i> $count7</span>";

         
        }
echo "</div>";
        
    }

    #Если нет новостей
    if ($k_post == 0) {
        $doc->NoResult();
    }

    if ($k_page > 1) {
        echo "<div class='list-group-item'>";
        str('index.php?', $k_page, $page);
        echo "</div>";
    }
}

require_once H . 'sys/inc/tfoot.php';