Файл: dnev/index.php
Строк: 132
<?
include '../sys/inc/start.php';
include '../sys/inc/compress.php';
include '../sys/inc/sess.php';
include '../sys/inc/home.php';
include '../sys/inc/settings.php';
include '../sys/inc/db_connect.php';
include '../sys/inc/ipua.php';
include '../sys/inc/fnc.php';
include '../sys/inc/user.php';
$set['title']='Дневники ';
include '../sys/inc/thead.php';
title();
err();
aut();
echo "<div class='foot'>";
echo "<img src='/style/img/90.png' alt='' class='icon'/> <a href='/top/top_blog.php'>Топ Блогеров</a> | n";
echo "<a href='/top/top_komm_blog.php'>Комментаторов</a>n";
echo "</div>";
echo "<div class='foot'>";
echo "Сорт:n";
if (!isset($_GET['time'])) echo "<a href='?time'>Время</a>n";
if (isset($_GET['time'])) echo "<font color='red'>Время</font>n";
echo "n|n";
if (!isset($_GET['komm'])) echo "<a href='?komm'>Комментарии</a>n";
if (isset($_GET['komm'])) echo "<font color='red'>Комментарии</font>n";
echo "n|n";
if (!isset($_GET['look'])) echo "<a href='?look'>Просмотры</a>n";
if (isset($_GET['look'])) echo "<font color='red'>Просмотры</font>n";
if (isset($user)) {
echo "<br/><img src='/style/img/88.png' alt='' class='icon'/>n";
echo "<a href='add.php'>Новая запись</a>";
}
echo "</div>";
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `dnev` WHERE `read` = '0'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
echo "<table class='post'>n";
$lim=" LIMIT $start, $set[p_str]";
$order='`time` DESC';
if (isset($_GET['time'])) $order='`time` DESC';
if (isset($_GET['komm'])) $order='`komm` DESC';
if (isset($_GET['look'])) $order='`look` DESC';
$q=mysql_query("SELECT * FROM `dnev` WHERE `read` = '0' ORDER BY $order $lim");
if (mysql_num_rows($q)==0) {
echo "Нет дневниковn";
}
while ($dnev = mysql_fetch_assoc($q))
{
echo " <tr>n";
echo " <td class='foot'>n";
echo "<img src='/style/img/86.png' alt='' class='icon'/>n";
echo "<a href='dnev.php?id=$dnev[id]'>$dnev[name]</a> <font color='#000'>(".vremja($dnev['time']).") </font><img src='/style/img/komm.png' alt='' class='icon'/> <font color='red'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `dnev_kom` WHERE `id_dnev` = '$dnev[id]'"),0)."</font><br />n";;
echo "<font color='#313431'>";echo "<div class='foot'>n";
echo output_text(cut_text(($dnev['msg'])))."...n";echo "</div>";
echo " <a href='dnev.php?id=$dnev[id]'></a></font>";
$ank=get_user($dnev['id_user']);
echo " ".online($ank['id'])." <a href='/user.profile.php?id=$ank[id]' title='Профиль "$ank[nick]"'><span style="color:$ank[ncolor]">$ank[nick]</span></a> ".online2($ank['id'])." n";
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `ban` WHERE `id_user` = '$ank[id]' AND `time` > '$time'"), 0)!=0)
echo "<font color='red'>[BAN]</font>n";
echo "<br/>n";
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `dnev_kom` WHERE `id_dnev` = '$dnev[id]'"),0)!=0) {
$post=mysql_fetch_assoc(mysql_query("SELECT * FROM `dnev_kom` WHERE `id_dnev` = '$dnev[id]' ORDER BY `time` DESC LIMIT 1"));
}
}
if ($k_page>1)str("?id=$dnev[id]&",$k_page,$page); // Вывод страниц
echo "</table>n";
echo "<div class='foot'>";
$all_dnev=mysql_result(mysql_query("SELECT COUNT(*) FROM `dnev` WHERE `read` = '0'"),0);
$new_d=mysql_result(mysql_query("SELECT COUNT(*) FROM `dnev` WHERE `time` > '".(time()-86400)."' AND `read` = '0'"), 0);
$all_dnev_k=mysql_result(mysql_query("SELECT COUNT(*) FROM `dnev_kom`"),0);
$new_d_k=mysql_result(mysql_query("SELECT COUNT(*) FROM `dnev_kom` WHERE `time` > '".(time()-86400)."' "), 0);
echo "Всего $all_dnev_k (<font color='red'>+$new_d_k Сегодня</font>) комментариев в $all_dnev (<font color='red'>+$new_d Сегодня</font>) дневниках";
echo "</div>";
include '../sys/inc/tfoot.php';
?>