File size: 2.13Kb
<?
err();
$k_post = $pdo->query(("SELECT COUNT(*) FROM `soo_forum_thems` WHERE `id_forum` = '$forum[id]' AND `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'];
$q = $pdo->query("SELECT * FROM `soo_forum_thems` WHERE `id_forum` = '$forum[id]' AND `id_soo` = '$soo[id]' ORDER BY `up` DESC,`time` DESC LIMIT $start, $set[p_str]");
if ($k_post==0) {
$doc->NoResult();
}
while ($them = $q->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 `soo_forum_mess` WHERE `id_them` = '$them[id]' AND `id_soo` = '$soo[id]' ORDER BY `time` ASC LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$ank=get_user($post1['id_user']);
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=$soo[id]&id_forum=$forum[id]&",$k_page,$page); // Вывод страниц
?>