View file ä󿪫¬/modules/support/pr.php

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

$set['title']='Прочие запросы';
include_once '../../sys/inc/thead.php';

err();
aut();

if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `promotion_blacklist` WHERE `id_user` = '".$user['id']."' LIMIT 1"),0)->fetchColumn()){    
header('location: index.php'); 
}

#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltip' 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/support/'>" . lang('Тех.поддержка') . "</a> <i class='fa fa-angle-right fa-fw'></i> " . lang('Прочие запросы') . "";
echo "</div>";


$k_post=$pdo->query(("SELECT COUNT(*) FROM `promotion` WHERE `all` = '6'"),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)
{
echo "  <div class='list-group-item'>\n";
echo "В этом разделе еще нет запросов";
echo "  </div>\n";
}

$q = $pdo->query("select * from `promotion`WHERE `all`= '6' ORDER BY `time` DESC LIMIT $start, $set[p_str];");
while ($post = $q->fetch(PDO::FETCH_ASSOC)){


$ank=get_user($post['id_user']);

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

echo " <i class='fa fa-comments fa-fw'></i> <a href='show.php?id=".$post['id']."'><b>".text($post['name'])."</b></a>";
if ($post['off']==1){echo " <font color=gray><i class='fa fa-lock fa-fw'></i></font>\n";}

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

echo text(mb_substr($post['msg'],0,80, 'UTF-8'))."\n";

 echo"<br/><br>";
echo"<font color='gray'>Комментариев: ".$pdo->query(("SELECT COUNT(*) FROM `otvet_tiket` WHERE `id_tiket` = '$post[id]'"),0)->fetchColumn()."<br>";


$q1 = $pdo->query("select * from `otvet_tiket` WHERE `id_tiket` = '$post[id]' ORDER BY `time` DESC LIMIT 1");
while ($post2 = $q1->fetch(PDO::FETCH_ASSOC)){
echo "Последний от: ";
echo "".user($post2['id_user'])."";
}


echo "</font>\n";

echo "  </div>\n";

}

if ($k_page>1){
echo "  <div class='list-group-item'>\n";    
str('?',$k_page,$page); // Вывод страниц
echo "</div>";
}


include_once '../../sys/inc/tfoot.php';

?>