Файл: comm/index.php
Строк: 98
<?php
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';
$set['title']='Список разделов & '.$_SERVER['HTTP_HOST'];
include_once '../sys/inc/thead.php';
top();
if($user['level']==10){
include_once 'inc/razd_act.php';
}
$q=mysql_query("SELECT * FROM `community_razd` ORDER BY `sort`");
while($post = mysql_fetch_array($q)){
$num=1;
echo "<div class='foot1'>";
$k_f=0;
$k_n=0;
$q3=mysql_query("SELECT * FROM `community_comm` WHERE `id_razd` = '$post[id]'");
while($post2 = mysql_fetch_array($q3)){
$k_f=$k_f+mysql_result(mysql_query("SELECT COUNT(*) FROM `community_user_incomm` WHERE `cid` = '$post2[id]'"),0);
$k_n=$k_n+mysql_result(mysql_query("SELECT COUNT(*) FROM `community_user_incomm` WHERE `cid` = '$post2[id]' AND `time` > '".(time()-86400)."'"),0);
}
if($k_n==0){
$k_n=NULL;
}else{
$k_n=' + '.$k_n.' чел сегодня';
}
if($user['level']==10){
echo "<span style='float : right;'>n";
echo "<a href='index.php?razd=edit&id_razd=$post[id]'>";icon_mini_set();echo "</a>";
echo "<a href='index.php?razd=delete&id_razd=$post[id]'>";icon_del();echo "</a>";
echo "</span>";
}
icon_folder();echo "<a href='razd.php?id_razd=$post[id]'>$post[name]</a> ";
$comm=mysql_result(mysql_query("SELECT COUNT(*) FROM `community_comm` WHERE `id_razd` = '$post[id]'"),0);
echo "<font color='blue'>+$comm</font> <font color='green'>+$k_f чел</font> <font color='red'>$k_n</font><br/>";
if($post['opis']!=NULL){
echo "<div style='border-bottom:1px dashed #99BCFF;'></div>n";
echo output_text($post['opis']).'<br/>';
}
echo '</div>';
}
if($user['level']==10){
if(isset($_GET['act']) && $_GET['act']=='add'){
echo "<form method="post" action="?act=add">";
echo "<textarea type="text" name="sort" cols="5" rows="2" style="width:5%"></textarea>Номер<br/>";
echo "<textarea type="text" name="name"></textarea>Название раздела<br/>";
echo "<textarea name="opis"></textarea>Описание раздела<br/>";
echo "<span style='float : right;'>n";
echo "<a href='?' title='Отмена'>";icon_del();echo "</a><br />n";
echo "</span>";
echo "<input value="Создать" type="submit"/>n";
echo "</form>";
}else{
echo "<div class='foot1'>n";
icon_plus();echo "<a href='?act=add'>Добавить раздел</a><br/>";
echo "</div>";
}
if(isset($_GET['razd']) && $_GET['razd']=='edit' && isset($_GET ['id_razd'])){
$id_razd = intval($_GET['id_razd']);
$razd = mysql_fetch_array(mysql_query("SELECT * FROM `community_razd` WHERE `id` = '".$id_razd."' LIMIT 1"));
echo "<form method='post' action='index.php?razd=edit&id_razd=$id_razd'>";
echo "<input type="text" name="sort" value='$razd[sort]' size='2'/>Номер<br/>";
echo "<input type="text" name="name" value='$razd[name]'/>Название раздела<br/>";
echo "<textarea name='opis'>$razd[opis]</textarea>Описание раздела<br/>";
echo "<span style='float : right;'>n";
echo "<a href='?' title='Отмена'>";icon_del();echo "</a><br />n";
echo " </span>";
echo "<input value="Изменить" type="submit" />n";
echo "</form>";
}
}
include_once '../sys/inc/tfoot.php';
?>