Файл: konts.php
Строк: 352
<?
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';
only_reg();
switch (@$_GET['type']) {
case 'favorite':$type='favorite';$type_name='Друзья';break;
case 'ignor':$type='ignor';$type_name='Игнор';break;
case 'deleted':$type='deleted';$type_name='Корзина';break;
default:$type='common';$type_name='Общие';break;
}
$set['title']=$type_name.' контакты';
include_once 'sys/inc/thead.php';
title();
if (isset($_GET['id']))
{
$ank=get_user($_GET['id']);
if ($ank)
{
if (isset($_GET['act']))
{
switch ($_GET['act']) {
case 'add':
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `users_konts` WHERE `id_user` = '$user[id]' AND `id_kont` = '$ank[id]'"), 0)==1)
$err[]='Этот пользователь уже есть в вашем списке контактов';
else
{
mysql_query("INSERT INTO `users_konts` (`id_user`, `id_kont`, `time`) VALUES ('$user[id]', '$ank[id]', '$time')");
msg ('Контакт успешно добавлен');
}
break;
case 'del':
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `users_konts` WHERE `id_user` = '$user[id]' AND `id_kont` = '$ank[id]'"), 0)==0)
$warn[]='Этого пользователя нет в вашем списке контактов';
else
{
mysql_query("DELETE FROM `users_konts` WHERE `id_user` = '$user[id]' AND `id_kont` = '$ank[id]' LIMIT 1");
msg ('Контакт успешно удален');
}
break;
}
}
}
else
$err[]='Пользователь не найден';
}
if (isset($_GET['act']) && $_GET['act']==='edit_ok' && isset($_GET['id']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"),0)==1)
{
$ank=get_user(intval($_GET['id']));
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `users_konts` WHERE `id_user` = '$user[id]' AND `id_kont` = '$ank[id]'"), 0)==1)
{
$kont=mysql_fetch_array(mysql_query("SELECT * FROM `users_konts` WHERE `id_user` = '$user[id]' AND `id_kont` = '$ank[id]'"));
if (isset($_POST['name']) && $_POST['name']!=($kont['name']!=null?$kont['name']:$ank['nick']))
{
if (preg_match('#[^A-zА-я0-9-_.,[]() ]#i', $_POST['name']))$err[]='В названии контакта присутствуют запрещенные символы';
if (strlen($_POST['name'])>64)$err[]='Название контакта длиннее 64-х символов';
if (!isset($err))
{
mysql_query("UPDATE `users_konts` SET `name` = '".mysql_real_escape_string(htmlspecialchars($_POST['name']))."' WHERE `id_user` = '$user[id]' AND `id_kont` = '$ank[id]' LIMIT 1");
msg ('Контакт успешно переименован');
}
}
if (isset($_POST['type']) && preg_match('#^(common|ignor|favorite|deleted)$#',$_POST['type']) && $_POST['type']!=$type)
{
mysql_query("UPDATE `users_konts` SET `type` = '$_POST[type]', `time` = '$time' WHERE `id_user` = '$user[id]' AND `id_kont` = '$ank[id]' LIMIT 1");
msg ('Контакт успешно перенесен');
}
}
else
$err[]='Контакт не найден';
}
aut();
err();
if ($type=='deleted')echo "Контакты из этой группы удаляются через 30 дней<br />n";
if ($type=='ignor')echo "Уведомления о сообщениях от этих контактов не появляются<br />n";
if ($type=='favorite')echo "Уведомления о сообщениях от этих контактов выделяются<br />n";
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `users_konts` WHERE `id_user` = '$user[id]' AND `type` = '$type'"), 0);
echo "Контактов: $k_post<br />n";
if ($k_post){
$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";
$q=mysql_query("SELECT * FROM `users_konts` WHERE `id_user` = '$user[id]' AND `type` = '$type' ORDER BY `time` DESC, `new_msg` DESC LIMIT $start, $set[p_str]");
while ($post = mysql_fetch_array($q))
{
$ank_kont=get_user($post['id_kont']);
$ank_kont2=get_user($post['id_user']);
$k_new=mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` WHERE `user`='$ank_kont[id]' AND `id_user` = '$ank_kont[id]' AND `id_kont` = '$user[id]' AND `read` = '0'"), 0);
$k_new_mess2=mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` WHERE `user`='$user[id]' AND `id_kont` = '$ank_kont[id]'"), 0);
$k_new_mess=mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` WHERE `user`='$user[id]' AND `id_user` = '$ank_kont[id]'"), 0);
echo " <tr>n";
if ($set['set_show_icon']==2){
echo " <td class='icon14' rowspan='2'>n";
avatar4($ank_kont['id']);
echo " </td>n";
}
elseif ($set['set_show_icon']==1)
{
echo " <td class='icon14'>n";
avatar4($ank_kont['id']);
echo " </td>n";
}
echo " <td class='p_t1'>n";
echo ($k_new_mess!=0?'<span class="off">[new]</span> ':null)."<a href="/mail.php?id=$ank_kont[id]">".($post['name']!=null?$post['name']:$ank_kont['nick'])."</a>".online($ank_kont['id'])."n";
echo ($k_new_mess!=0?'<b>':null)."(".($k_new_mess!=0?'+'.$k_new_mess:$k_mess).")".($k_new_mess!=0?'</b>':null);
echo " </td>n";
echo " </tr>n";
echo " <tr>n";
if ($set['set_show_icon']==1)echo " <td class='p_m' colspan='2'>n"; else echo " <td class='p_m'>n";
echo "<a href="/info.php?id=$ank_kont[id]">Анкета</a> | n";
if ($type!='deleted')echo "<a href='/konts.php?type=$type&act=del&id=$ank_kont[id]'>Удалить контакт из списка</a> | n";
if (isset($_GET['act']) && $_GET['act']==='edit' && isset($_GET['id']) && $_GET['id']==$ank_kont['id'])
{
echo "<form method='post' action='?type=$type&act=edit_ok&id=$ank_kont[id]&page=$page'>n";
echo "Отображать как:<br />n";
echo "<input type='text' maxlenght='64' name='name' value='".($post['name']!=null?$post['name']:$ank_kont['nick'])."' /><br />n";
echo "Группа:<br />n";
echo "<select name='type'>n";
echo "<option value='common'".($type=='common'?" selected='selected'":null).">Общая</option>n";
echo "<option value='favorite'".($type=='favorite'?" selected='selected'":null).">Друзья</option>n";
echo "<option value='ignor'".($type=='ignor'?" selected='selected'":null).">Игнор</option>n";
echo "<option value='deleted'".($type=='deleted'?" selected='selected'":null).">Удаленные</option>n";
echo "</select><br />n";
echo "<input type='submit' name='apply' value='Применить' /><br />n";
echo "</form>n";
echo "<a href='?type=$type&id=$ank_kont[id]&page=$page'>Отмена</a><br />n";
}
else
{
echo "<a href='?type=$type&act=edit&id=$ank_kont[id]&page=$page'>Редактировать</a><br />n";
}
echo " </td>n";
echo " </tr>n";
}
echo "</table>n";
if ($k_page>1)str("?type=$type&",$k_page,$page); // Вывод страниц
}
echo "<div class='menu'>";
//echo "<b>Группа:</b><br />n";
echo ($type=='common'?'<b>':null)."<a href='?type=common'>Общие</a>".($type=='common'?'</b>':null)." (".mysql_result(mysql_query("SELECT COUNT(*) FROM `users_konts` WHERE `id_user` = '$user[id]' AND `type` = 'common'"), 0).")<br />n";
echo ($type=='favorite'?'<b>':null)."<a href='?type=favorite'>Друзья</a>".($type=='favorite'?'</b>':null)." (".mysql_result(mysql_query("SELECT COUNT(*) FROM `users_konts` WHERE `id_user` = '$user[id]' AND `type` = 'favorite'"), 0).")<br />n";
echo ($type=='ignor'?'<b>':null)."<a href='?type=ignor'>Игнорируемые</a>".($type=='ignor'?'</b>':null)." (".mysql_result(mysql_query("SELECT COUNT(*) FROM `users_konts` WHERE `id_user` = '$user[id]' AND `type` = 'ignor'"), 0).")<br />n";
echo ($type=='deleted'?'<b>':null)."<a href='?type=deleted'>Удаленные</a>".($type=='deleted'?'</b>':null)." (".mysql_result(mysql_query("SELECT COUNT(*) FROM `users_konts` WHERE `id_user` = '$user[id]' AND `type` = 'deleted'"), 0).")<br />n";
echo "</div>n";
#############################
$usearch=NULL;
if (isset($_SESSION['usearch']))$usearch=$_SESSION['usearch'];
if (isset($_POST['usearch']))$usearch=$_POST['usearch'];
if ($usearch==NULL)
unset($_SESSION['usearch']);
else
$_SESSION['usearch']=$usearch;
$usearch=preg_replace("#( ){1,}#","",$usearch);
if (isset ($_GET['go']) && $usearch!=NULL)
{
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `users_konts` WHERE `id_user` = '$user[id]' AND (`name` like '%".mysql_escape_string($usearch)."%' OR `id_kont` = '".intval($usearch)."')"),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";
if ($k_post==0)
{
echo " <tr>n";
echo " <td class='p_t'>n";
echo "Нет результатовn";
echo " </td>n";
echo " </tr>n";
}
$q=mysql_query("SELECT * FROM `users_konts` WHERE `id_user` = '$user[id]' AND (`name` like '%".mysql_escape_string($usearch)."%' OR `id_kont` = '".intval($usearch)."') ORDER BY `time` DESC LIMIT $start, $set[p_str]");
while ($ank = mysql_fetch_assoc($q))
{
$ank=get_user($ank['id_kont']);
echo " <tr>n";
echo " <td class='p_t'>n";
echo "<a href='/mail.php?id=$ank[id]'>$ank[nick]</a>".online($ank['id'])."<br />n";
if (isset($_GET['act']) && $_GET['act']==='edit' && isset($_GET['id']) && $_GET['id']==$ank['id'])
{
echo "<form method='post' action='?go&type=$type&act=edit_ok&id=$ank[id]&page=$page'>n";
echo "Отображать как:<br />n";
echo "<input type='text' maxlenght='64' name='name' value='".($post['name']!=null?$post['name']:$ank['nick'])."' /><br />n";
echo "Группа:<br />n";
echo "<select name='type'>n";
echo "<option value='common'".($type=='common'?" selected='selected'":null).">Общая</option>n";
echo "<option value='favorite'".($type=='favorite'?" selected='selected'":null).">Избранные</option>n";
echo "<option value='ignor'".($type=='ignor'?" selected='selected'":null).">Игнор</option>n";
echo "<option value='deleted'".($type=='deleted'?" selected='selected'":null).">Удаленные</option>n";
echo "</select><br />n";
echo "<input type='submit' name='apply' value='Применить' /><br />n";
echo "</form>n";
echo "<a href='?go&type=$type&id=$ank[id]&page=$page'>Отмена</a><br />n";
}
else
{
echo "<a href='?go&type=$type&act=edit&id=$ank[id]&page=$page'>Редактировать</a><br />n";
}
echo " </td>n";
echo " </tr>n";
}
echo "</table>n";
if ($k_page>1)str("konts.php?go&",$k_page,$page); // Вывод страниц
}
echo "<div class="post">nID или НИК контакта</div>n";
echo "<form method="post" action="/konts.php?go">";
$usearch=stripcslashes(htmlspecialchars($usearch));
echo "<input type="text" name="usearch" maxlength="16" value="$usearch" /><br />n";
echo "<input type="submit" value="Найти" />";
echo "</form>n";
############################
echo "<div class='foot'>n";
if(isset($_SESSION['refer']) && $_SESSION['refer']!=NULL && otkuda($_SESSION['refer']))
echo "«<a href='$_SESSION[refer]'>".otkuda($_SESSION['refer'])."</a><br />n";
echo "</div>n";
include_once 'sys/inc/tfoot.php';
?>