View file user/jurnal.php

<?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();
if(!isset($user)){
echo '<div class="err">Доступ закрыт.</div>';
}else{
if(isset($_GET['name'])){
$razdel=my_esc($_GET['name']);
mysql_query("UPDATE `jurnal` SET `read` = '1' WHERE `id_kont` = '".$user['id']."' AND `read` = '0' AND `razdel` = '".$razdel."' AND `ok` = '1'");
if (isset($_GET['del'])){mysql_query("DELETE FROM `jurnal` WHERE `id_kont` = '".$user['id']."' AND `razdel` = '".$razdel."'");}
if (isset($_GET['dels'])){mysql_query("DELETE FROM `jurnal` WHERE `id` = '".intval($_GET['dels'])."'");}
echo "<div class='foot'>
<a href='jurnal.php'>Назад</a> | <a href='?name=$razdel'>Обновить</a> | <a href='?name=$razdel&amp;del'>Очистить раздел</a>
</div><table class='post'>";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal` WHERE `id_kont` = '".$user['id']."' AND `razdel` = '".$razdel."' AND `ok` = '1'"),0);
$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="p_m">Нет новых событий!</div>';}
$q=mysql_query("SELECT * FROM `jurnal` WHERE `id_kont` = '".$user['id']."' AND `razdel` = '".$razdel."' AND `ok` = '1' ORDER BY id DESC LIMIT $start, $set[p_str]");
while ($post = mysql_fetch_array($q)){
$ank=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_user]'"));
echo "<tr><td class='p_m'>";


echo ''.output_text($post['msg']).' <a href="?name='.$eazdel.'&amp;dels='.$post['id'].'" title="Удалить"><img src="/style/icons/delete.gif" alt="" /></a></td></tr>';
}
echo '</table>';
include_once '../sys/inc/tfoot.php';
exit;
}

echo '<div class="foot">Журнал слбытий</div><table class="post">';
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal` WHERE `id_kont` = '".$user['id']."' AND `ok` = '0'"),0);
$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="p_m">Нет новых событий!</div>';
}

$q=mysql_query("SELECT * FROM `jurnal` WHERE `id_kont` = '".$user['id']."' AND `ok` = '0' ORDER BY id DESC LIMIT $start, $set[p_str]");
while ($post = mysql_fetch_array($q)){
$ank=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_user]'"));
echo "<tr><td class='icon14'>";
		if (is_file(H.'/style/icons/jur/'.$post['razdel'].'.gif'))
			echo '<img src="/style/icons/jur/'.$post['razdel'].'.gif" alt="" />';
		elseif (is_file(H.'/style/icons/jur/'.$post['razdel'].'.jpg'))
			echo '<img src="/style/icons/jur/'.$post['razdel'].'.jpg" alt="" />';
		elseif (is_file(H.'/style/icons/jur/'.$post['razdel'].'.png'))
			echo '<img src="/style/icons/jur/'.$post['razdel'].'.png" alt="" />';

echo '</td><td class="p_t"><a href="?name='.$post['razdel'].'">'.$post['name'].'</a> ('.mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal` WHERE `id_kont` = '".$user['id']."' AND `razdel` = '".$post['razdel']."' AND `ok` = '1'"),0).')</td></tr>';
}
echo '</table>';

if($k_page>1){
	str("jurnal.php?id=".$user['id']."&amp;",$k_page,$page);
}


}
include_once '../sys/inc/tfoot.php';
?>