Файл: comm/index.php
Строк: 73
<?php
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.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']='Сообщества';
include_once '../sys/inc/thead.php';
title();
aut();
echo "<table class='post'>n";
$q=mysql_query("SELECT * FROM `community_razd` ORDER BY `sort`");
while($post = mysql_fetch_array($q)){
////////////////////////////////
if ($set['set_show_icon']==2){
echo " <td class='icon48' rowspan='2'>n";
echo '<img src="/style/comm/'.$post['id'].'.gif" alt="" />';
echo " </td>n";
}
elseif ($set['set_show_icon']==1)
{
echo " <td class='icon14'>n";
echo '<img src="/style/comm/'.$post['id'].'.gif" alt="" />';
echo " </td>n";
//////////////
}
echo " <td class='p_t'>n";
$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.' сегодня';
}
echo '<a href="razd.php?id_razd='.$post['id'].'">'.$post['name'].'</a><br />';
echo " </td>n";
echo " </tr>n";
echo " <tr>n";
if ($set['set_show_icon']==1)echo " <td class='p_m' colspan='2'>n"; else echo " <td class='p_m'>n";
if($post['opis']!=NULL){
echo output_text($post['opis']).'<br/>';
}
echo " </td>n";
echo " </tr>n";
}
echo "</table>n";
echo '</div>';
include_once '../sys/inc/tfoot.php';
?>