Файл: users/jurnal/index.php
Строк: 182
<?
require_once ("../../core/cuctema/core.php");
only_reg();
$set['title'] = "".$user['nick']." | Журнал";
require_once ("../../core/cuctema/head.php");
title();
aut();
######### Informations
if(isset($_GET['info']) and $_GET['info']=='1'){
echo "<div class='main123 line_175'>";
$JI=mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal` WHERE `id_kont` = '$user[id]'"),0);
echo "Всего оповещений: $JI";
echo "</div>";
echo "<div class='menu123 line_175'><a href='?link_id=".$user['id']."&jsort=1&filter=0'>← Назад</a></div>";
require_once ("../../core/cuctema/foot.php");
exit;
}
######### Informations
echo "<div class='menu123 line_175'>";
//Разделы
//echo "<font color='green'><b>Разделы: </b></font>";
//Все уведомления
if($_GET['filter']!='0'){
echo "<a href='?link_id=".$user['id']."&jsort=1&filter=0'>Все</a>";
echo " | ";
}else{
echo "Все";
echo " | ";
}
//Форум
if($_GET['filter']!='1'){
echo "<a href='?link_id=".$user['id']."&jsort=1&filter=1'>Форум</a>";
echo " | ";
} else {
echo "Форум";
echo " | ";
}
if($_GET['filter']!='2'){
//Дневник
echo "<a href='?link_id=".$user['id']."&jsort=1&filter=2'>Дневник</a>";
echo " | ";
} else {
echo "Дневник";
echo " | ";
}
if($_GET['filter']!='3'){
//Фото
echo "<a href='?link_id=".$user['id']."&jsort=1&filter=3'>Фото</a>";
} else {
echo "Фото";
}
echo "</div>";
################################################################
//Очистка журнала
if(isset($_GET['del']))
{
if(isset($_GET['ok']))
{
mysql_query("DELETE FROM `jurnal` WHERE `id_kont`='".$user['id']."'");
msg('Журнал успешно очищен');
}
else
{
echo "<div class='err'>Вы уверены что хотите очистить Журнал? <a href='?r=jurnal/jsort=1&del&ok&filter=0'>Да</a> / <a href='?link_id=".$user['id']."&jsort=1&filter=0'>Нет</a></div>n";
}
}
############################################################
################################################################
//Очистка ERR
if(isset($_GET['del_err']) and $_GET['del_err'] && mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal` WHERE `id` = '".intval($_GET['del_err'])."' AND `id_kont` = '$user[id]'"),0)==1)
{
$post=mysql_fetch_assoc(mysql_query("SELECT * FROM `jurnal` WHERE `id` = '".intval($_GET['del_err'])."' LIMIT 1"));
mysql_query("DELETE FROM `jurnal` WHERE `id` = '$post[id]' AND `id_user` = '0'");
header("Location:?link_id=".$user['id']."&jsort=1&filter=0");
}
############################################################
############################################################
//Раздел форум
if($_GET['filter']=='1') {
mysql_query("UPDATE `jurnal` SET `read` = '1' WHERE `id_kont` = '".$user['id']."' AND `read` = '0'");
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal` WHERE `type` = 'forumm' AND `id_kont` = '".$user['id']."'"),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="main123">Нет новых событий!</div>';
}
$q=mysql_query("SELECT * FROM `jurnal` WHERE `type` = 'forumm' AND `id_kont` = '".$user['id']."' 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_object]'"));
$ank2=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_user]'"));
$them=mysql_fetch_array(mysql_query("SELECT * FROM `forum` WHERE `id` = '$post[id_object2]' LIMIT 1"));
$tc=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `id` = '$post[id_object2]' LIMIT 1"),0);
echo '<div class="main123">';
echo "<span style='float: right;'> <font color='gray'>".vremja($post['time'])."</font></span>";
if ($post['id_user']!=0){
echo "<a href='/users/forum/?id=$them[id]'>Форум | $ank[nick] | ".esc(stripcslashes(htmlspecialchars($them['name'])))."</a>";
echo "<br /><font color='gray'>$ank2[nick]</font>";
}else{
echo "Ошибка | <a href='?r=jurnal/jsort=1&del_err=$post[id]&filter=1'>Удалить</a>";
}
echo '</div>';
}
if($k_page>1){
str("?link_id=".$ank['id']."&jsort=1&filter=3&",$k_page,$page);
}
}
############################################################
//Раздел фото
elseif($_GET['filter']=='3') {
mysql_query("UPDATE `jurnal` SET `read` = '1' WHERE `id_kont` = '".$user['id']."' AND `type` = 'foto' AND `read` = '0'");
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal` WHERE `type` = 'foto' AND `id_kont` = '".$user['id']."'"),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="main123">Нет новых событий!</div>';
}
$q=mysql_query("SELECT * FROM `jurnal` WHERE `type` = 'foto' AND `id_kont` = '".$user['id']."' 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_object]'"));
$ank2=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_user]'"));
$foto=mysql_fetch_array(mysql_query("SELECT * FROM `gallery_foto` WHERE `id` = '$post[id_object2]'"));
$fc=mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_foto` WHERE `id` = '$post[id_object2]'"),0);
$gallery=mysql_fetch_array(mysql_query("SELECT * FROM `gallery` WHERE `id` = '$foto[id_gallery]'"));
echo '<div class="main123">';
echo "<span style='float: right;'> <font color='gray'>".vremja($post['time'])."</font></span>";
if ($post['id_user']!=0){
echo "<a href='/foto/$ank[id]/$gallery[id]/$post[id_object2]/?from=jurnal&jsort=1&link_id=".$user['id']."&read=$post[id_object2]'>$ank[nick] | Фото | ".esc(stripcslashes(htmlspecialchars($foto['name'])))."</a>";
echo "<br /><font color='gray'>$ank2[nick]</font>";
}else{
echo "Ошибка | <a href='?r=jurnal/jsort=1&del_err=$post[id]&filter=2'>Удалить</a>";
}
echo '</div>';
}
if($k_page>1){
str("?link_id=".$user['id']."&jsort=1&filter=2&",$k_page,$page);
}
}
#####################################################
//Раздел дневник
elseif($_GET['filter']=='2') {
mysql_query("UPDATE `jurnal` SET `read` = '1' WHERE `id_kont` = '".$user['id']."' AND `type` = 'blog' AND `read` = '0'");
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal` WHERE `type` = 'blog' AND `id_kont` = '".$user['id']."'"),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="main123">Нет новых событий!</div>';
}
$q=mysql_query("SELECT * FROM `jurnal` WHERE `type` = 'blog' AND `id_kont` = '".$user['id']."' 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_object]'"));
$ank2=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_user]'"));
$diary=mysql_fetch_array(mysql_query("SELECT * FROM `diary` WHERE `id` = '$post[id_object]' LIMIT 1"));
$dc=mysql_result(mysql_query("SELECT COUNT(*) FROM `diary` WHERE `id` = '$post[id_object]' LIMIT 1"),0);
$ank3=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$diary[id_user]'"));
echo '<div class="main123">';
echo "<span style='float: right;'> <font color='gray'>".vremja($post[time])."</font></span>";
if ($post['id_user']!=0){
echo "<a href='/users/diary/?from=jurnal&jsort=1&link_id=".$user['id']."&id=$ank3[id]&diary=$diary[id]'>$ank3[nick] | Дневник | ".esc(stripcslashes(htmlspecialchars($diary['name'])))."</a>";
echo "<br /><font color='gray'>$ank2[nick]</font>";
}else{
echo "Ошибка | <a href='?r=jurnal/jsort=1&del_err=$post[id]&filter=3'>Удалить</a>";
}
echo '</div>';
}
if($k_page>1){
str("?link_id=".$user['id']."&jsort=1&filter=3&",$k_page,$page);
}
}
############################################################
//Раздел все
else
{
mysql_query("UPDATE `jurnal` SET `read` = '1' WHERE `id_kont` = '".$user['id']."' AND `read` = '0'");
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal` WHERE `id_kont` = '".$user['id']."'"),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="main123">Нет новых событий!</div>';
}
$q=mysql_query("SELECT * FROM `jurnal` WHERE `id_kont` = '".$user['id']."' 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_object]'"));
$ank2=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_user]'"));
//echo '<div class="main123"><img src="/img/tor.png" alt="*"/> '.output_text($post['msg']).' <b>'.vremja($post['time']).'</b></div>';
echo '<div class="main123">';
echo "<span style='float: right;'> <font color='gray'>".vremja($post['time'])."</font></span>";
if ($post['id_user']!=0){
if ($post['type']=='guestbook'){
echo "<a href='/mysite/guestbook?id=$post[id_object]&from=jurnal&jsort=1&link_id=".$user['id']."'>$ank[nick] | Гостевая</a>";
}
if ($post['type']=='guestbook2'){
echo "<a href='/mysite/guestbook?id=$post[id_object]&from=jurnal&jsort=1&link_id=".$user['id']."'>$ank[nick] | Гостевая</a>";
}
if ($post['type']=='foto'){
$foto=mysql_fetch_array(mysql_query("SELECT * FROM `gallery_foto` WHERE `id` = '$post[id_object2]'"));
$fc=mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_foto` WHERE `id` = '$post[id_object2]'"),0);
$gallery=mysql_fetch_array(mysql_query("SELECT * FROM `gallery` WHERE `id` = '$foto[id_gallery]'"));
echo "<a href='/foto/$ank[id]/$gallery[id]/$post[id_object2]/?from=jurnal&jsort=1&link_id=".$user['id']."&read=$post[id_object2]'>$ank[nick] | Фото | ".esc(stripcslashes(htmlspecialchars($foto['name'])))."</a>";
}
if ($post['type']=='forumm'){
$them=mysql_fetch_array(mysql_query("SELECT * FROM `forum` WHERE `id` = '$post[id_object2]' LIMIT 1"));
$tc=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `id` = '$post[id_object2]' LIMIT 1"),0);
echo "<a href='/users/forum/?id=$them[id]'>Форум | $ank[nick] | ".esc(stripcslashes(htmlspecialchars($them['name'])))."</a>";
}
if ($post['type']=='blog'){
$diary=mysql_fetch_array(mysql_query("SELECT * FROM `diary` WHERE `id` = '$post[id_object]' LIMIT 1"));
$dc=mysql_result(mysql_query("SELECT COUNT(*) FROM `diary` WHERE `id` = '$post[id_object]' LIMIT 1"),0);
$ank3=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$diary[id_user]'"));
echo "<a href='/users/diary/?from=jurnal&jsort=1&link_id=".$user['id']."&id=$ank3[id]&diary=$diary[id]'>$ank3[nick] | Дневник | ".esc(stripcslashes(htmlspecialchars($diary['name'])))."</a>";
if($user['pol']==1)$pol='оставил'; else $pol='оставила';$jmsg="[url=/info.php?id=".$user['id']."]".$user['nick']."[/url] ".$pol." комментарий к дневнику [url=/users/diary/".$diary['id']."/read]".$diary_name."[/url]";
}
if ($post['type']=='files'){
$file=mysql_fetch_array(mysql_query("SELECT * FROM `files` WHERE `id` = '$post[id_object]' LIMIT 1"));
$dc=mysql_result(mysql_query("SELECT COUNT(*) FROM `files` WHERE `id` = '$post[id_object]' LIMIT 1"),0);
$ank3=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$file[id_user]'"));
echo "<a href='/mysite/files/?from=jurnal&jsort=1&link_id=".$user['id']."&user=$ank3[id]&file=$file[id]'>$ank3[nick] | Файлы | ".esc(stripcslashes(htmlspecialchars($file['name'])))."</a>";
}
if ($post['type']=='comm'){
echo output_text($post[msg]);
}
echo "<br /><font color='gray'>$ank2[nick]</font>";
}else{
echo "Ошибка | <a href='?r=jurnal/jsort=1&del_err=$post[id]&filter=0'>Удалить</a>";
}
echo '</div>';
}
if($k_page>1){
str("?link_id=".$user['id']."&jsort=1&filter=0&",$k_page,$page);
}
}
################################
//Функции журнала
echo "<div class='menu123 line_175'>";
echo "<a href='?r=jurnal/jsort=1&del&filter=0'><img src='/img/x.gif' alt='*'/> Очистить все</a><br />";
echo "<a href='?r=jurnal/jsort=1&info=1&filter=0'><img src='http://i.spaces.ru//speaker.gif' alt='*'/> Информация</a>";
echo '</div>';
require_once ("../../core/cuctema/foot.php");
?>