View file ä󿪫¬/modules/groups/forum/new_t.php

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

only_reg('/reg.php');

if(isset($_GET['id']) && $pdo->query(("SELECT COUNT(*) FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"),0)->fetchColumn()==1)
{


$s=intval($_GET['id']);
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '$s' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);

include_once H. '/modules/groups/inc/ban.php';

$set['title']='Новые темы в форуме группы'; // заголовок страницы
include_once '../../../sys/inc/thead.php';
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);

#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltipecho' data-placement='right' title='" . lang('На главную') . "'><i class='fa fa-home fa-lg'></i></a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='/modules/groups/group.php?id=$soo[id]'>$soo[name]</a> <i class='fa fa-angle-right fa-fw'></i> Форум";
echo "</div>";

echo "<div style='padding: 4px; background-color: white;'>";
echo "<table style='width: 100%; text-align: center;'><tr>
<td class='fn-lefti'><a style='display: block;padding: 10px;' href='index.php?id=".intval($_GET['id'])."'><font color=#587C94><b>ВСЕ</b></font></a></td>
<td class='fn-righti-o'><a style='display: block;padding: 10px;' href='new_t.php?id=".intval($_GET['id'])."'><b><font color=#587C94>НОВЫЕ ТЕМЫ</font></b></a></td>
</tr></table></div>";


$k_post = $pdo->query(("SELECT COUNT(*) FROM `soo_forum_thems` WHERE `id_soo`='$s'"),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 `soo_forum_thems` WHERE `id_soo`='$s' ORDER BY `time_create` DESC  LIMIT $start, $set[p_str]");
if ($k_post==0) {
$doc->NoResult();
}

while ($them = $q->fetch(PDO::FETCH_ASSOC))
{


$forum = $pdo->query(("SELECT * FROM `soo_forums` WHERE `id` = '$them[id_forum]' AND `id_soo`='$s' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);

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

echo "<a href='?id=$soo[id]&id_forum=$forum[id]&id_them=$them[id]'><i class='fa fa-pencil fa-fw'></i> <b>$them[name]</b></a> ";

if (isset($user) && $them['zak']==1){
echo '<font color="#ADA026"><i class="fa fa-lock fa-fw"></i></font>';
}

echo "<a href='?id=$soo[id]&id_forum=$forum[id]&id_them=$them[id]&page=end'><span class='badge'>".$pdo->query(("SELECT COUNT(*) FROM `soo_forum_comm` WHERE `id_post` = '$them[id]'"),0)->fetchColumn()."</span></a>\n";

$post1 = $pdo->query(("SELECT * FROM `user` WHERE `id` = '$them[id_user]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);


$ank=get_user($post1['id']);
echo "<br/>";
echo "<i class='fa fa-user fa-fw'></i> <font color=gray><small>Автор: <a href='/info.php?id=$ank[id]' title='Анкета \"$ank[nick]\"'>$ank[nick]</a> (".date::timek($them['time_create']).")</small></font><br />\n";



$post2=$pdo->query(("SELECT * FROM `soo_forum_comm` WHERE `id_post` = '$them[id]' ORDER BY `time` DESC LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$ank2=get_user($post2['id_user']);

if ($post2) {

echo "<i class='fa fa-comment fa-fw'></i> <font color=gray><small>Посл.: <a href='/info.php?id=$ank2[id]' title='Анкета \"$ank2[nick]\"'>$ank2[nick]</a> (".date::timek($post2['time']).")</small></font><br />\n";

}else{
    
echo "<i class='fa fa-comment fa-fw'></i> <font color=gray><small>Посл.: нет комментариев</small></font><br />\n";

}
echo "</div>\n";


}

if ($k_page>1)str("?id=$s&",$k_page,$page); // Вывод страниц




}
else
{
$set['title']='Ошибка 404'; // заголовок страницы
include_once '../../../sys/inc/thead.php';    
    
err404();
}
include_once '../../../sys/inc/tfoot.php';
?>