View file ä󿪫¬/modules/groups/news/include.php

File size: 1.17Kb
<?

$count_news = $pdo->query(("SELECT COUNT(*) FROM `soo_news` WHERE `id_soo` = '$soo[id]'"),0)->fetchColumn();


echo "<div style='padding:7px; background-color: #FAFDFF;'>
<a href='/modules/groups/news/news.php?id=".$soo['id']."'><div class='link_p'>
<font color=#6E8394><b>БЛОГ ГРУППЫ <span class='count_p' style=' color: #D0DFEB;'>
$count_news</span> <span style='float: right;'><i class='fa fa-feed fa-lg'></i></span></font></b></div></a>";


$k_post=$pdo->query(("SELECT COUNT(*) FROM `soo_news` WHERE `id_soo`='$soo[id]'"),0)->fetchColumn();
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];

if ($k_post==0)
{
$doc->NoResult();
} 


$q = $pdo->query("SELECT * FROM `soo_news` WHERE `id_soo`='$soo[id]' ORDER BY `time` DESC LIMIT 3");
while ($news = $q->fetch(PDO::FETCH_ASSOC))
{
echo "<a href='/modules/groups/news/list.php?id=$soo[id]&id_news=$news[id]'><div class='list-group-item'>\n";
echo '<font color=black><i class="fa fa-book fa-fw"></i></font> <b>'.$news['name_blog'].'</b> <font color=gray><small>('.date::timek($news['time']).')</small></font><br>';
echo '</div></a>';
}
echo "</div>";
?>