Файл: user/frend_new.php
Строк: 234
<?
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.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';
only_reg();
$ank['id']=$user['id'];
$set['title'] = 'Предложения дружбы';
include_once '../sys/inc/thead.php';
$set['title'] = 'Список друзей';
include_once '../sys/inc/thead.php';
title();
aut();
if (isset($_GET['ok']))
{
$ok = intval($_GET['ok']);
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$ok' LIMIT 1"),0)==0){header("Location: index.php?");exit;}
mysql_query("INSERT INTO `frends` (`user`, `frend`, `time`, `i`) values('$ank[id]', '$ok', '$time', '1')");
mysql_query("INSERT INTO `frends` (`user`, `frend`, `time`, `i`) values('$ok', '$ank[id]', '$time', '1')");
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$ok' AND `to` = '$user[id]' LIMIT 1");
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$user[id]' AND `to` = '$ok' LIMIT 1");
mysql_query("OPTIMIZE TABLE `frends`");
mysql_query("OPTIMIZE TABLE `frends_new`");
$msgok="Поздравляем! обитатель [b]$user[nick][/b] принял ваше предложение дружбы";
mysql_query("INSERT INTO `jurnal` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$ok', '$msgok', '$time')");
msg ('Предложение дружбы успешно принято');
}
if (isset($_GET['no']))
{
$no = intval($_GET['no']);
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$no' LIMIT 1"),0)==0){header("Location: index.php?");exit;}
mysql_query("DELETE FROM `frends` WHERE `user` = '$user[id]' AND `frend` = '$no' LIMIT 1");
mysql_query("DELETE FROM `frends` WHERE `user` = '$no' AND `frend` = '$user[id]' LIMIT 1");
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$no' AND `to` = '$user[id]' LIMIT 1");
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$user[id]' AND `to` = '$no' LIMIT 1");
mysql_query("OPTIMIZE TABLE `frends`");
mysql_query("OPTIMIZE TABLE `frends_new`");
$msgno="К сожалению,обитатель [b]$user[nick][/b] отклонил ваше предложение дружбы!";
mysql_query("INSERT INTO `jurnal` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$no', '$msgno', '$time')");
msg ('Предложение отклонено');
}
if (isset($_GET['del']))
{
$no = intval($_GET['del']);
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$no' LIMIT 1"),0)==0){header("Location: index.php?");exit;}
mysql_query("DELETE FROM `frends` WHERE `user` = '$user[id]' AND `frend` = '$no' LIMIT 1");
mysql_query("DELETE FROM `frends` WHERE `user` = '$no' AND `frend` = '$user[id]' LIMIT 1");
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$no' AND `to` = '$user[id]' LIMIT 1");
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$user[id]' AND `to` = '$no' LIMIT 1");
mysql_query("OPTIMIZE TABLE `frends`");
mysql_query("OPTIMIZE TABLE `frends_new`");
$msgno="К сожалению,[b]$user[nick][/b] удалил вас из списка друзей!";
mysql_query("INSERT INTO `jurnal` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$no', '$msgno', '$time')");
msg ('Дружба закончена');
}
$k_post1 = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` INNER JOIN `user` ON `frends`.`frend`=`user`.`id` WHERE `frends`.`user` = '$ank[id]' AND `frends`.`i` = '1' AND `user`.`date_last`>'".(time()-300)."'"), 0);
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE `user` = '$ank[id]' AND `i` = '1'"), 0);
echo "<div class='foot'>";
echo "<a href='/user/frend.php'>Друзья </a>[$k_post] | <font color='red'>Заявки</font> [";
echo ''.mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$ank[id]'"), 0);
echo "] | <a href='/user/frendon.php'>Онлайн</a> [$k_post1]";
echo "</div>";
$m = date('m', $time);
if (substr($m, 0, 1) == 0)$m = str_replace('0', '', $m);
$d = date('d', $time);
$k_f = mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$user[id]' LIMIT 1"), 0);
echo '<div class="menu_razd"> Заявки </div>';
echo '<table class="post">'."n";
if ($k_f==0)echo '<div class="post"> Нет заявок на дружбу </div>';
$q = mysql_query("SELECT * FROM `frends_new` WHERE `to` = '$user[id]' ORDER BY time DESC");
while ($f = mysql_fetch_array($q))
{
$ank = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '".$f['user']."' LIMIT 1"));
echo "<td class='icon15' rowspan='2' title='$ank[p_avatar]'>";
avatar_little($ank['id']);
echo "</td>";
echo "<td class='p_t1'>";
online($ank['id']);
echo "<a href='/user/profile.php?id=$ank[id]' title='$ank[p_nick]'>n";
echo GradientText("$ank[nick]", "$ank[ncolor]", "$ank[ncolor2]");
echo "</a>n";
echo "<a href='/user/ank.php?id=$ank[id]' title='Анкета $ank[nick]'>";
icon_info_ank();echo "</a> ";
medals($ank['id']);
strana($ank['id']);
admin($ank['id']);
echo "<span style='float : right;'>n";
echo "<font color='red'>".vremja($f['time'])."</font>";
echo "</span>";
echo "</td>";
echo "<tr>";
echo "<td class='p_m' colspan='2'>";
echo "<a href='frend_new.php?ok=$ank[id]'>";
icon_thumb_up();echo "Принять</a> | ";
echo "<a href='frend_new.php?no=$ank[id]'>Отклонить";
icon_thumb_down();echo "</a>";
echo "</td>n";
echo "</tr>n";
}
echo "</table>";
$k_t = mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `user` = '$user[id]' LIMIT 1"), 0);
echo '<div class="menu_razd"> Мои предложения </div>';
echo '<table class="post">'."n";
if ($k_t==0)echo '<div class="post">Нет заявок на дружбу</div>';
$q = mysql_query("SELECT * FROM `frends_new` WHERE `user` = '$user[id]' ORDER BY time DESC");
while ($f = mysql_fetch_array($q))
{
$ank = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '".$f['to']."' LIMIT 1"));
echo "<td class='icon15' rowspan='2' title='$ank[p_avatar]'>";
avatar_little($ank['id']);
echo "</td>";
echo "<td class='p_t1'>";
online($ank['id']);
echo "<a href='/user/profile.php?id=$ank[id]' title='$ank[p_nick]'>n";
echo GradientText("$ank[nick]", "$ank[ncolor]", "$ank[ncolor2]");
echo "</a>n";
echo "<a href='/user/ank.php?id=$ank[id]' title='Анкета $ank[nick]'>";
icon_info_ank();echo "</a> ";
medals($ank['id']);
strana($ank['id']);
admin($ank['id']);
echo "<span style='float : right;'>n";
echo "<font color='red'>".vremja($f['time'])."</font>";
echo "</span>";
echo "</td>";
echo "<tr>";
echo "<td class='p_m' colspan='2'>";
echo "<b>x</b> <a href='frend_new.php?no=$ank[id]'>Отменить предложение</a>";
echo "</td>n";
echo "</tr>n";
}
echo "</table>";
echo "<div class='foot1'>n";
echo "Куда: <a href='/user/office.php'>Кабинет</a> | n";
echo ' <a href="/users.php">Все пользователи</a>';
echo "</div>";
include_once '../sys/inc/tfoot.php';
?>