View file social/user/discussions/index.php

<?
/*
=======================================
Обсуждения для Dcms-Social
Автор: Искатель
---------------------------------------
Этот скрипт распостроняется по лицензии
движка Dcms-Social. 
При использовании указывать ссылку на
оф. сайт http://dcms-social.ru
---------------------------------------
Контакты
ICQ: 587863132
http://dcms-social.ru
=======================================
*/
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/adm_check.php';
include_once '../../sys/inc/user.php';
only_reg();

$my = null;
$frend = null;
$all = null;

if (isset($_GET['read']) && $_GET['read'] == 'all')
{
	if (isset($user))
	{
		mysql_query("UPDATE `discussions` SET `count` = '0' WHERE `id_user` = '$user[id]'");
		$_SESSION['message'] = __('Список непрочитанных очищен');
		header("Location: ?");
		exit;
	}
}

if (isset($_GET['delete']) && $_GET['delete']=='all')
{
	if (isset($user))
	{
		mysql_query("DELETE FROM `discussions` WHERE `id_user` = '$user[id]'");
		$_SESSION['message'] = __('Список обсуждений очищен');
		header("Location: ?");
		exit;
	}
}

//------------------------like к статусу-------------------------//
if (isset($_GET['likestatus']))
{
	$status = mysql_fetch_assoc(mysql_query("SELECT * FROM `status` WHERE `id` = '".intval($_GET['likestatus'])."' LIMIT 1"));
	$ank = get_user(intval($_GET['likestatus']));
	
	if (isset($user) && $user['id'] != $ank['id'] && 
	mysql_result(mysql_query("SELECT COUNT(*) FROM `status_like` WHERE `id_status` = '$status[id]' AND `id_user` = '$user[id]' LIMIT 1"),0) == 0)
	{
		mysql_query("INSERT INTO `status_like` (`id_user`, `time`, `id_status`) values('$user[id]', '$time', '$status[id]')");

		$q = mysql_query("SELECT * FROM `frends` WHERE `user` = '".$user['id']."' AND `i` = '1'");
		
		while ($f = mysql_fetch_array($q))
		{
			$a = get_user($f['frend']);
			mysql_query("INSERT INTO `tape` (`id_user`,`ot_kogo`,  `avtor`, `type`, `time`, `id_file`) 
			values('$a[id]', '$user[id]', '$status[id_user]', 'status_like', '$time', '$status[id]')"); 
		}

		header("Location: ?page=".intval($_GET['page']));
		exit;
	}
}

if (mysql_result(mysql_query("SELECT COUNT(*) FROM `discussions`  WHERE `id_user` = '$user[id]' AND `count` > '0' AND `avtor` = '$user[id]'"),0) > 0)
$count_my = " <img src='/style/icons/tochka.png' alt='*'/>";
else
$count_my = null;

if (mysql_result(mysql_query("SELECT COUNT(*) FROM `discussions`  WHERE `id_user` = '$user[id]' AND `count` > '0' AND `avtor` <> '$user[id]'"),0) > 0)
$count_f = " <img src='/style/icons/tochka.png' alt='*'/>";
else
$count_f = null;

$set['title'] = __('Обсуждения');
include_once '../../sys/inc/thead.php';
title();
err();
aut();


if (isset($_GET['order']) && $_GET['order']=='my')
{
	$order = "AND `avtor` = '$user[id]'";
	$sort = "order=my&amp;";
	$my = 'activ';
}
else if (isset($_GET['order']) && $_GET['order']=='frends')
{
	$order = "AND `avtor` != '$user[id]'";
	$sort = "order=frends&amp;";
	$frend = 'activ';
}
else
{
	$order = null;
	$sort = null;
	$all = 'activ';
}

// Уведомления
$k_notif = mysql_result(mysql_query("SELECT COUNT(`read`) FROM `notification` WHERE `id_user` = '$user[id]' AND `read` = '0'"), 0); 

if ($k_notif > 0)$k_notif = '<font color=red>(' . $k_notif . ')</font>';
else $k_notif = null;

// Обсуждения
$discuss = mysql_result(mysql_query("SELECT COUNT(`count`) FROM `discussions` WHERE `id_user` = '$user[id]' AND `count` > '0' "),0); 

if ($discuss > 0)$discuss = '<font color=red>(' . $discuss . ')</font>';
else $discuss = null;

// Лента
$lenta = mysql_result(mysql_query("SELECT COUNT(`read`) FROM `tape` WHERE `id_user` = '$user[id]' AND `read` = '0' "),0); 

if ($lenta > 0)$lenta = '<font color=red>(' . $lenta . ')</font>';
else $lenta = null;

?>
<div id="comments" class="menus">
<div class="webmenu">
<a href="/user/tape/"><?= __('Лента')?> <?= $lenta?></a>
</div>
<div class="webmenu">
<a href="/user/discussions/" class="activ"><?= __('Обсуждения')?> <?= $discuss?></a>
</div>
<div class="webmenu">
<a href="/user/notification/"><?= __('Уведомления')?> <?= $k_notif?></a>
</div>
</div>

<div class="foot">
<?= __('Сортировать')?>: 
<a href="?"> <?= __('Все')?> </a>  | 
<a href="?order=my"> <?= __('Мои')?><?= $count_my?> </a>  | 
<a href="?order=frends"> <?= __('Друзья')?><?= $count_f?> </a> 
</div>
<?
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `discussions`  WHERE `id_user` = '$user[id]' $order"),0);
$k_page = k_page($k_post, $set['p_str']);
$page = page($k_page);
$start = $set['p_str'] * $page - $set['p_str'];

$q = mysql_query("SELECT * FROM `discussions` WHERE `id_user` = '$user[id]' $order ORDER BY `time` DESC LIMIT $start, $set[p_str]");

if ($k_post == 0)
{
	?>
	<div class="mess">
	<?= __('Нет новых обсуждений')?>
	</div>
	<?
}

while ($post = mysql_fetch_assoc($q))
{
	$type = $post['type'];
	$avtor = user::get_user($post['avtor']);
	
	if ($post['count'] > 0)
	{
		$s1 = '<font color="red">';
		$s2 = '</font>';
	}
	else
	{
		$s1 = null;
		$s2 = null;
	}

	// Подгружаем типы обсуждений
	$d = opendir('inc/');

	while($dname = readdir($d))
	{
		if ($dname != '.' && $dname != '..')
		{
			include 'inc/' . $dname;
		}
	}
}

// Вывод страниц
if ($k_page > 1)str('?' . $sort, $k_page, $page); 

?>
<div class='foot'>
<a href='?read=all'><img src='/style/icons/ok.gif'> Отметить всё как прочитанное</a>
</div>
<div class='foot'>
<a href='?delete=all'><img src='/style/icons/delete.gif'> Удалить все обсуждения</a> | <a href='settings.php'>Настройки</a>
</div>
<?
include_once '../../sys/inc/tfoot.php';
?>