Файл: Modules/category.php
Строк: 52
<?php
$title = 'Категории сайта';
require_once ('Sys/head.php');
switch($act)
{
default:
echo '<div id="st21">
';
$cats = $mysqli->query("SELECT `id`,`name`,`count`,`about` FROM `".$prefix."cat` WHERE `id` != '999' ORDER BY `position`");
while($cat = $cats->fetch_assoc())
{
echo '<div class="st2">
<h2 class="title">';
echo '<a href = "http://'.$_SERVER['HTTP_HOST'].'/category/view/'.$cat['id'].'">'.bbCodes(nl2br($cat['name'])).'</a> <span style="color:#DA7E88">('.$cat['count'].')</span></h2>
<div class="middle_back">';
if(!empty($cat['about']))
{
echo ''.bbCodes(nl2br($cat['about'])).'';
}
echo '</div></div>';
} echo '<br /></div>';
break;
case 'view':
$query = $mysqli->query("SELECT * FROM `".$prefix."cat` WHERE `id` = '".$id."'");
if($query->num_rows == 0)
{
echo '<div id="st21"><div class="st2">
<h2 class="titlev">Категории</h2>
</div>
<div class="st2">
<h2 class="title"></h2>
<div class="middle_back">';
echo 'Вы ошиблись категорией.<br/>';
echo '<a href="http://'.$_SERVER['HTTP_HOST'].'/category">Категории</a><br/>';
echo '</div></div><br /></div>';
require_once ('Sys/foot.php');
exit;
}
$cat = $query->fetch_array();
echo '<div id="st21">
<div class="st2">
<h2 class="titlev"><strong>'.bbCodes(nl2br($cat['name'])).'</strong></h2>
</div>';
$count = $mysqli->query("SELECT `id` FROM `".$prefix."zap` WHERE `cat` = '".$cat['id']."' AND `ZapSt` = '0' ORDER BY `time` DESC")->num_rows;
if($count == 0)
{
echo '<div class="st2">
<h2 class="title"></h2>
<div class="middle_back">';
echo 'Здесь еще не чего нет!<br/>';
echo '</div></div></div>';
require_once ('Sys/foot.php');
exit;
}
$total = intval(($count-1)/$pageZapCat)+1;
$page = (isset($_GET['page'])) ? abs(intval($_GET['page'])) : '';
if(empty($page) OR $page < 0)
{
$page = 1;
}
if($page > $total)
{
$page = $total;
}
$past = intval($count/$pageZapCat);
$start = $page*$pageZapCat-$pageZapCat;
$stati = $mysqli->query("SELECT * FROM `".$prefix."zap` WHERE `cat` = '".$cat['id']."' AND `ZapSt` = '0' ORDER BY `time` DESC LIMIT ".$start.",".$pageZapCat."");
echo'
';
while($row = $stati->fetch_assoc())
{
$start++;
echo '<div class="st2">
<h2 class="title">'.$start.'. <a href="http://'.$_SERVER['HTTP_HOST'].'/p'.$row['id'].'">'.bbCodes(nl2br($row['name'])).'</a>';
if($row['UserPower']==1){
echo'<div align="right"><span style="color:#000000" class="date"><big>'.data($row['time']).'</big></span> </div>';}
echo' </h2><div class="middle_back">';
echo bbCodes(nl2br($row['text'])).'<br/>';
echo '<br/>';
if(!isset($user_data) AND $set['powerCommGuest'] == 1 AND $set['powerComm'] == 1 AND $row['ComPower']==1 OR isset($user_data) AND $set['powerComm'] == 1 AND $row['ComPower']==1 ) //OR это ИЛИ AND это И
{
echo '<div align="left"><a href="http://'.$_SERVER['HTTP_HOST'].'/zap/comments/'.$row['id'].'">Комментарии</a>('.$row['comments'].')</div>';
}
echo'<div align="right">';
if($row['UserPower']==1){echo 'Добавил: <b>'.$row['user'].'</b><br/>';}
if(isset($user_data))
{
$EditStati = ($user_data['level'] == 2) ? '<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/ZapKomments/comments/'.$row['id'].'">Управление Комментариями</a> <b>('.$row['comments'].')</b> |
<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/zap/editZap/'.$row['id'].'">Редактировать</a> | <a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/zap/deleteZap/'.$row['id'].'">Удалить</a><br/> ' : '';
}
echo ' '.$EditStati.'';
echo'</div>';
echo '</div></div> ';
}
if($count > $pageZapCat)
{
navigation($total,$page,'http://'.$_SERVER['HTTP_HOST'].'/category/view/'.$id.'/');
}
echo'<br /></div>';
break;
}
?>