Файл: region_clean/friends.php
Строк: 828
<?php
#######################################
## Mod By KoT (borispol) [76-75-072] ##
#######################################
require_once "start.php";
require_once "sid.php";
header("Cache-Control: no-cache");
if ($ver == "wml") header ("Content-type:text/vnd.wap.wml; charset=utf-8");
else header("Content-Type:text/html; charset=UTF-8");
require_once "inc.php";
$link = connect_db();
list($row, $id, $ps, $fsize1, $fsize2) = check_login($link);
require_once "version.php";
if (isset($rm)) $takep2="&rm=$rm&ref=$ref";
else $takep2="&ref=$ref";
$us = $row['user'];
$mod = isset($_GET['mod']) ? $_GET['mod'] : NULL;
switch($mod) {
/////////////////////////////////////////////
default:
$us = $row['user'];
if (isset($go)) {
mysql_query("DELETE FROM `friends` WHERE `usid`='".(int)$nk."' AND `id`='".(int)$id."'");
mysql_query("DELETE FROM `friends` WHERE `usid`='".(int)$id."' AND `id`='".(int)$nk."'");
$friendnick = mysql_fetch_array(mysql_query("Select user from users where id='".(int)$nk."' LIMIT 1"));
//-------------------------//
$fromid = mysql_fetch_array(mysql_query("SELECT `user` FROM `users` WHERE `id`='".(int)$id."'"));
$fromus = $fromid['user'];
$adm = mysql_query ("Select * from users where user='".(int)$nk."'");
$z = mysql_fetch_array ($adm);
$data = date("d-M-Y [H:i]");
$kol = rand(0,99999999);
$time = time();
$topic = "Контакты.";
$message = "Пользователь <b>" . $fromus . "</b> удалился из твоих контактов.";
mysql_query("Insert into zapiski set klu4='".$kol."', idwho ='1', message = '".$message."', towhom = '".(int)$id."', idtowhom = '".(int)$nk."', time = '".$time."', readd = '0', topic = '".$topic."', date='".$data."'");
//-------------------------//
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n
<card id="Ок" title="Ok" ontimer="friends.php?$ses&ref=$ref"><timer value="10"/>n
<p align="center">n";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Ок</title>
<META HTTP-EQUIV="Refresh" CONTENT="2; URL=friends.php?$ses&ref=$ref">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="center">";
}
echo $fsize1;
echo 'Пользователь <b>'.col_n($friendnick[0]).'</b> удален из твоих контактов!<br/>';
echo $fsize2;
include_once "foot.php";
mysql_close($link);
exit;
}
/////////////////////////////////////////////
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n
<card id="friendslist" title="Мои контакты">n
<p align="left">n";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Мои контакты</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="left">";
}
$mdruz = mysql_num_rows(mysql_query("SELECT `id` FROM `friends` WHERE `id`='".(int)$id."'"));
echo '<div class="c4">Мои контакты: ('.$mdruz.')</div>';
$myzaj = mysql_result(mysql_query("SELECT count(`zajavka`) FROM `friends` WHERE `whozajavka`!='' AND `usid`='".(int)$id."'"), 0);
echo '<a href="friends.php?'.$ses.'&mod=zajavki">Предложения дружбы</a> ('.$myzaj.')<br/>';
$userm = mysql_query("select count(klu4) as num from friends where id='".(int)$id."'");
echo $divide;
$usm = mysql_fetch_array($userm);
$num = $usm['num'];
if ($num == 0) {
echo 'Контактов нету!<br/>';
} else {
if (!isset($s)) $s = 0;
$mx = round(($num/10) + 0.45);
if ($s > $mx) $s = $mx;
if ($s == 0) $s = 1;
$ot = (($s-1) * 10) + 1;
$do = $s * 10;
if ($do > $num) $do = $num;
$o = $ot - 1;
$n = $ot;
if ($do == 0) $n = $o;
$o = intval($o);
$do = intval($do);
$r = mysql_query ("select usid from friends where id='".(int)$id."' order by klu4 desc limit $o,$do");
for ($i = $ot; $i <= $do; $i++) {
$arr = mysql_fetch_array($r);
$nk = $arr['usid'];
$selus = mysql_fetch_array(mysql_query('SELECT `id`,`sex`,`birth` FROM `users` WHERE `id`='.$nk.''));
$sex = $selus['sex'];
$birth = $selus['birth'];
########################
$birth = explode("-",$birth);
$d = $birth[0];
$m = $birth[1];
$g = $birth[2];
if ($d != NULL and $m != NULL and $g != NULL) {
if ($m == 1);
elseif ($m == 2);
elseif ($m == 3);
elseif ($m == 4);
elseif ($m == 5);
elseif ($m == 6);
elseif ($m == 7);
elseif ($m == 8);
elseif ($m == 9);
elseif ($m == 10);
elseif ($m == 11);
elseif ($m == 12);
$birth = date("Y")-$g;
if (date("n") < $m) $birth = $birth-1;
elseif (date("n") == $m and date("j") < $d) $birth = $birth-1;
}
########################
$select = mysql_query("Select `id` from users where id='".(int)$nk."'");
$inf = mysql_fetch_array($select);
$nick = $inf['id'];
$friendnick = mysql_fetch_array(mysql_query ("Select `user` from users where id='".(int)$nk."' LIMIT 1;"));
echo ($i).") <a href="send.php?$ses&to=$nick&ref=$ref"><img src="icon/r.png" alt="."/></a>|<a href="friends.php?$ses&go=del&nk=$nk&ref=$ref"><img src="icon/d.png" alt="."/></a><a href="info.php?$ses&nk=$nk&ref=$ref"> ".col_n($friendnick[0])."</a> <b>(".$sex ."</b>/<b>".$birth.")</b><br/>";
}
$next = $s + 1;
$prev = $s - 1;
if ($num > $do) {
$ot = (($next - 1) * 10) + 1;
$do = $next * 10;
if ($do > $num) $do = $num;
echo $divide;
echo "<a href="friends.php?$ses&s=$next&ref=$ref">>>$ot-$do>></a><br/>n";
}
if ($s > 1) {
$ot = (($prev - 1) * 10) + 1;
$do = $prev * 10;
echo "<a href="friends.php?$ses&s=$prev&ref=$ref"><<$ot-$do<<</a><br/>n";
}
}
echo $divide;
echo "<div class = 'd1'><a href="friends.php?$ses&mod=add&ref=$ref">Добавить юзверя</a><br/>n
<a href ="cabinet.php?$ses&ref=$ref">Личный кабинет</a><br/>n
<a href ="enter.php?$ses&ref=$ref">Прихожая</a></div>n";
echo $fsize2;
include_once "foot.php";
mysql_close($link);
exit;
break;
//===========================================//
case 'zajavki':
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n
<card id="friendslist" title="Предложения дружбы">n
<p align="left">n";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Предложения дружбы</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="left">";
}
echo '<div class="c4">Предложения дружбы</div><br/>';
$num = mysql_result(mysql_query("SELECT count(`zajavka`) FROM `friends` WHERE `whozajavka`!='' AND `usid`='".(int)$id."'"), 0);
if (!isset($s)) $s = 0;
$mx = round(($num/10) + 0.45);
if ($s > $mx) $s = $mx;
if ($s == 0) $s = 1;
$ot = (($s - 1) * 10) + 1;
$do = $s * 10;
if ($do > $num) $do = $num;
$o = $ot - 1;
$n = $ot;
if ($do == 0) $n = $o;
$o = intval($o);
$do = intval($do);
$view = mysql_query("SELECT `id`,`usid`,`zajavka`,`whozajavka` FROM `friends` WHERE `usid`='".(int)$id."' AND `zajavka`='1' ORDER BY `whozajavka` DESC LIMIT $o,$do");
$refresh = mysql_num_rows(mysql_query("SELECT zajavka FROM `friends` WHERE `usid`='".(int)$id."' AND `zajavka`='1'"));
if ($refresh == 0) {
echo 'Заявки отсутствуют...<br/>';
echo '<br/>
<div class="d1"><a href="friends.php?'.$ses.$takep2.'">Список контактов</a><br/>
<a href="enter.php?'.$ses.$takep2.'">Прихожая</a></div>';
include_once 'foot.php';
exit;
}
for ($i = $ot; $i <= $do; $i++) {
$who = mysql_fetch_assoc($view);
$kTo = $who['whozajavka'];
$select = mysql_fetch_array(mysql_query("SELECT `id`,`user` FROM `users` WHERE `user`='".mysql_real_escape_string($kTo)."'"));
echo $i.'. <a href="info.php?'.$ses.'&nk='.$select['id'].'">'.col_n($kTo).'</a> <small>[<a href="friends.php?'.$ses.'&nick='.$select['id'].'&mod=add_ok">Прн</a>|<a href="friends.php?'.$ses.'&nk='.$select['id'].'&mod=add_no">Откл</a>]</small><br/>';
}
echo '<br/>';
$next = $s + 1;
$prev = $s - 1;
if ($num > $do) {
$ot = (($next - 1) * 10) + 1;
$do = $next * 10;
if ($do > $num) $do = $num;
echo $fsize1;
echo "<a href="friends.php?$ses&s=$next&mod=zajavki">>>$ot-$do>></a><br/>n";
echo $fsize2;
}
if ($s > 1) {
$ot = (($prev - 1) * 10) + 1;
$do = $prev * 10;
echo $fsize1;
echo "<a href="friends.php?$ses&s=$prev&mod=zajavki"><<$ot-$do<<</a><br/>n";
echo $fsize2;
}
echo '<br/>
<div class="d1"><a href="friends.php?'.$ses.$takep2.'">Список контактов</a><br/>
<a href="enter.php?'.$ses.$takep2.'">Прихожая</a></div>';
include_once 'foot.php';
exit;
break;
//===========================================//
case 'ob';
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n
<card id="friendslist" title="Контакты">n
<p align="left">n";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Контакты</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="left">";
}
echo $fsize1;
if (!is_numeric($nk)) { header("Location: index.php?isset=403"); die; }
$selnick = mysql_fetch_array(mysql_query("SELECT `id`,`user`,`drug` FROM `users` WHERE `id`='".(int)$nk."'"));
$ak = $selnick['user'];
$prv = $selnick['drug'];
$idus = $selnick['id'];
if ($prv == 0) {
echo '<div class = "c4">Общие друзья с '.$ak.'</div><br/>';
$count_ob = mysql_result(mysql_query("SELECT COUNT(*) FROM `friends` WHERE `id`='".(int)$nk."' AND usid IN(SELECT `usid` FROM `friends` WHERE `id`='".$row['id']."')"), 0);
echo $divide;
if ($count_ob == 0) {
echo 'Общих контактов нету!<br/>';
} else {
if (!isset($s)) $s = 0;
$mx = round(($count_ob/50) + 0.45);
if ($s > $mx) $s = $mx;
if ($s == 0) $s = 1;
$ot = (($s-1) * 50) + 1;
$do = $s * 50;
if ($do > $count_ob) $do = $count_ob;
$o = $ot - 1;
$n = $ot;
if ($do == 0) $n = $o;
$o = intval($o);
$do = intval($do);
$r = mysql_query("SELECT `usid` FROM `friends` WHERE `id`='".(int)$nk."' AND usid IN(SELECT `usid` FROM `friends` WHERE `id`='".$row['id']."') ORDER BY `usid` DESC LIMIT $o,$do");
for ($i = $ot; $i <= $do; $i++) {
$arr = mysql_fetch_array($r);
$nk = $arr['usid'];
$selus = mysql_fetch_array(mysql_query("SELECT `id`,`sex`,`birth` FROM `users` WHERE `id`='".(int)$nk."'"));
$sex = $selus['sex'];
$birth = $selus['birth'];
########################
$birth = explode("-",$birth);
$d = $birth[0];
$m = $birth[1];
$g = $birth[2];
if ($d != NULL and $m != NULL and $g != NULL) {
if ($m == 1);
elseif ($m == 2);
elseif ($m == 3);
elseif ($m == 4);
elseif ($m == 5);
elseif ($m == 6);
elseif ($m == 7);
elseif ($m == 8);
elseif ($m == 9);
elseif ($m == 10);
elseif ($m == 11);
elseif ($m == 12);
$birth = date("Y")-$g;
if (date("n") < $m) $birth = $birth-1;
elseif (date("n") == $m and date("j") < $d) $birth = $birth-1;
}
########################
$friendnick = mysql_fetch_array(mysql_query("SELECT `user` FROM `users` WHERE `id`='".(int)$nk."' LIMIT 1"));
echo ($i).") <a href="info.php?$ses&nk=$nk&ref=$ref"> ".col_n($friendnick[0])."</a> <b>(".$sex ."</b>/<b>".$birth.")</b><br/>";
}
$next = $s + 1;
$prev = $s - 1;
if ($count_ob > $do) {
$ot = (($next - 1) * 50) + 1;
$do = $next * 50;
if ($do > $count_ob) $do = $count_ob;
echo $divide;
echo "<a href="friends.php?$ses&s=$next&mod=view&nk=$idus">>>$ot-$do>></a><br/>n";
}
if ($s > 1) {
$ot = (($prev - 1) * 50) + 1;
$do = $prev * 50;
echo "<a href="friends.php?$ses&s=$prev&mod=view&nk=$idus"><<$ot-$do<<</a><br/>n";
}
}
echo $divide;
echo '<div class="d1"><a href="enter.php?'.$ses.$takep2.'">Прихожая</a></div>';
echo $fsize2;
include_once "foot.php";
mysql_close($link);
exit;
} else {
echo 'Пользователь <b>'.col_n($ak).'</b> предпочел скрыть контакты!<br/>';
echo '<br/>
<div class="d1"><a href="friends.php?'.$ses.$takep2.'">Список контактов</a><br/>
<a href="enter.php?'.$ses.$takep2.'">Прихожая</a></div>';
}
break;
//===========================================//
case 'view':
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n
<card id="friendslist" title="Контакты">n
<p align="left">n";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Контакты</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="left">";
}
if (!is_numeric($nk)) { header("Location: index.php?isset=403"); die; }
echo $fsize1;
$selnick = mysql_fetch_array(mysql_query("SELECT `id`,`user`,`drug` FROM `users` WHERE `id`='".(int)$nk."'"));
$ak = $selnick['user'];
$prv = $selnick['drug'];
$idus = $selnick['id'];
if ($prv == 0) {
$num = mysql_num_rows(mysql_query("SELECT `id`,`usid` FROM `friends` WHERE `id`='".(int)$nk."'"));
echo '<div class = "c4">Контакты '.$ak.'</div><br/>';
$count_ob = mysql_result(mysql_query("SELECT COUNT(*) FROM `friends` WHERE `id`='".(int)$nk."' AND usid IN(SELECT `usid` FROM `friends` WHERE `id`='".$row['id']."')"), 0);
echo 'Общих друзей: <a href="friends.php?'.$ses.'&nk='.$nk.'&mod=ob">'.$count_ob.'</a><br/>';
echo $divide;
if ($num == 0) {
echo 'У юзера <b>'.col_n($ak).'</b> нет контактов!<br/>';
} else {
if (!isset($s)) $s = 0;
$mx = round(($num/50) + 0.45);
if ($s > $mx) $s = $mx;
if ($s == 0) $s = 1;
$ot = (($s-1) * 50) + 1;
$do = $s * 50;
if ($do > $num) $do = $num;
$o = $ot - 1;
$n = $ot;
if ($do == 0) $n = $o;
$o = intval($o);
$do = intval($do);
$r = mysql_query("SELECT `usid` FROM `friends` WHERE `id`='".(int)$nk."' ORDER BY `klu4` DESC LIMIT $o,$do");
for ($i = $ot; $i <= $do; $i++) {
$arr = mysql_fetch_array($r);
$nk = $arr['usid'];
$selus = mysql_fetch_array(mysql_query("SELECT `id`,`sex`,`birth` FROM `users` WHERE `id`='".(int)$nk."'"));
$sex = $selus['sex'];
$birth = $selus['birth'];
########################
$birth = explode("-",$birth);
$d = $birth[0];
$m = $birth[1];
$g = $birth[2];
if ($d != NULL and $m != NULL and $g != NULL) {
if ($m == 1);
elseif ($m == 2);
elseif ($m == 3);
elseif ($m == 4);
elseif ($m == 5);
elseif ($m == 6);
elseif ($m == 7);
elseif ($m == 8);
elseif ($m == 9);
elseif ($m == 10);
elseif ($m == 11);
elseif ($m == 12);
$birth = date("Y")-$g;
if (date("n") < $m) $birth = $birth-1;
elseif (date("n") == $m and date("j") < $d) $birth = $birth-1;
}
########################
$friendnick = mysql_fetch_array(mysql_query ("SELECT `user` FROM `users` WHERE `id`='".(int)$nk."' LIMIT 1"));
echo ($i).") <a href="info.php?$ses&nk=$nk&ref=$ref"> ".col_n($friendnick[0])."</a> <b>(".$sex ."</b>/<b>".$birth.")</b><br/>";
}
$next = $s + 1;
$prev = $s - 1;
if ($num > $do) {
$ot = (($next - 1) * 50) + 1;
$do = $next * 50;
if ($do > $num) $do = $num;
echo $divide;
echo "<a href="friends.php?$ses&s=$next&mod=view&nk=$idus">>>$ot-$do>></a><br/>n";
}
if ($s > 1) {
$ot = (($prev - 1) * 50) + 1;
$do = $prev * 50;
echo "<a href="friends.php?$ses&s=$prev&mod=view&nk=$idus"><<$ot-$do<<</a><br/>n";
}
}
echo $divide;
echo '<div class="d1"><a href="enter.php?'.$ses.$takep2.'">Прихожая</a></div>';
echo $fsize2;
include_once "foot.php";
mysql_close($link);
exit;
} else {
echo 'Пользователь <b>'.col_n($ak).'</b> предпочел скрыть контакты!<br/>';
echo '<br/>
<div class="d1"><a href="friends.php?'.$ses.$takep2.'">Список контактов</a><br/>
<a href="enter.php?'.$ses.$takep2.'">Прихожая</a></div>';
}
break;
//----------------------------------------//
case 'add':
if (!isset($nick)) {
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n
<card id="add" title="Добавить контакт">n
<p align="left" mode="wrap">n";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Добавить контакт</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="left">
<form method="POST" action="friends.php?mod=addz&$ses$takep2" name="auth">n";
}
echo $fsize1;
echo 'Ник или ID юзера:<br/>';
echo $fsize2;
echo '<input name="nick" maxlength="20" title="Text"/><br/>';
echo $fsize1;
echo 'Транслит ника:<br/>';
echo $fsize2;
echo '<select name="trun">
<option value="0">Нет</option>
<option value="1">Да</option>
</select><br/>';
if ($ver == "wml") {
echo $fsize1;
echo "<anchor title="send">Добавить<go href="friends.php?mod=addz&$ses$takep2" method="post">n
<postfield name="nick" value="$(nick)"/>n
<postfield name="trun" value="$(trun)"/>n
</go></anchor>n";
echo $fsize2;
echo '<br/>';
} else {
echo "<input type="submit" class="ibutton" value="Добавить" name="enter"><br/>n";
}
echo $fsize1;
echo $divide;
echo "<div class = 'd1'><a href="friends.php?$ses$takep2">Список контактов</a></div>n";
if (isset($rm)) echo "<div class = 'd1'><a href="chat.php?$ses&rm=$rm$takep">В чат</a></div>";
echo $fsize2;
include_once "foot.php";
mysql_close($link);
exit;
}
break;
//======================================//
case 'addz':
$nick = mysql_real_escape_string(check($nick));
if (!is_numeric($nick)) {
if ($_POST['trun'] == 1) $nick = trun_to_rus($nick);
$nick = trim($nick);
if ($nick == '') $nick = 0;
$latuser = strtolower($nick);
$ruser = rus_to_k($nick);
if ($ruser == $nick) {
$select = mysql_query("Select user,id from users where latuser = '".$latuser."'");
} else {
$select = mysql_query ("select user,id from users where ruser = '".$ruser."'");
}
} else {
$select = mysql_query ("select user,id from users where id = '".$nick."'");
}
if (mysql_affected_rows() == 0) {
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n
<card id="error" title="error" ontimer="friends.php?$ses$takep2"><timer value="10" />n
<p align="left">n";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Ок</title>
<META HTTP-EQUIV="Refresh" CONTENT="2; URL=friends.php?$ses$takep2">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="left">";
}
echo $fsize1;
echo 'Пользователя <b>'.col_n($nick).'</b> невозможно добавить<br/> в контакты т.к. его не существует!<br/>';
echo $fsize2;
include_once "foot.php";
mysql_close ($link);
exit;
}
$frdob = mysql_fetch_array(mysql_query("Select `id`,`user`,`razr` from users where id='".(int)$nk."'"));
$dobfr = $frdob['razr'];
$kto = $frdob['user'];
if ($dobfr == 1) {
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n
<card id="ok" title="Ошибка" ontimer="friends.php?$ses$takep2"><timer value="5"/>n
<p align="center">";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Ошибка</title>
<META HTTP-EQUIV="Refresh" CONTENT="2; URL=friends.php?$ses$takep2">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="center">";
}
echo $fsize1;
echo 'Пользователь '.col_n($kto).' запретил добавлять его в контакты!<br/>';
echo $fsize2;
include_once "foot.php";
mysql_close($link);
break;
}
$inf = mysql_fetch_array($select);
$nk = $inf['id'];
mysql_query ("SELECT * FROM `friends` WHERE `usid`='".(int)$nk."' AND `id`='".(int)$id."'");
if (mysql_affected_rows() != 0) {
$friendnick = mysql_fetch_array(mysql_query ("SELECT `user` FROM `users` WHERE `id`='".(int)$nk."' LIMIT 1"));
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n";
if (isset($rm)) echo "<card id="error" title="error" ontimer="chat.php?$ses&rm=$rm&ref=$ref"><timer value="10" />n";
else echo "<card id="error" title="error" ontimer="friends.php?$ses&ref=$ref"><timer value="10" />n";
echo "<p align="left">n";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Ок</title>";
if (isset($rm)) echo "<META HTTP-EQUIV="Refresh" CONTENT="2; URL=chat.php?$ses&rm=$rm&ref=$ref">";
else echo "<META HTTP-EQUIV="Refresh" CONTENT="2; URL=friends.php?$ses&ref=$ref">";
echo "<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>";
echo "<div align="left">";
}
echo $fsize1;
echo "<b>".col_n($friendnick[0])."</b> уже давно у тебя в контактах!<br/>";
echo $fsize2;
include_once "foot.php";
mysql_close($link);
exit;
break;
}
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n
<p align="left">n";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Ок</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="left">";
}
echo $fsize1;
$prov = mysql_fetch_array(mysql_query("SELECT `zajavka`,`whozajavka` FROM `friends` WHERE `usid`='".(int)$nk."'"));
if ($prov['zajavka'] == 1 and $prov['whozajavka'] == $us) {
echo 'Ошибка! Заявка уже была подана, дождись подтверждения.<br/>';
echo '<br/>
<div class="d1"><a href="friends.php?'.$ses.$takep2.'">Список контактов</a><br/>
<a href="enter.php?'.$ses.$takep2.'">Прихожая</a></div>';
include_once "foot.php";
mysql_close ($link);
exit;
}
$us = mysql_real_escape_string(check($us));
if (mysql_query("INSERT INTO `friends` SET `zajavka`='1', `whozajavka`='$us', `usid`='".(int)$nk."'"))
{
echo 'Заявка на добавление в контакты успешно оставлена!<br/>';
} else {
echo 'Произошла ошибка...<br/>';
}
//-------------------------//
$fromid = mysql_fetch_array(mysql_query("SELECT `user` FROM `users` WHERE `id`='".(int)$id."'"));
$fromus = $fromid['user'];
$adm = mysql_query("Select * from users where user='".(int)$nk."'");
$z = mysql_fetch_array($adm);
$data = date("d-M-Y [H:i]");
$kol = rand(0,99999999);
$time = time();
$topic = "Контакты.";
$message = "Пользователь <b>" . $fromus . "</b> подал тебе заявку на добавление в контакты.";
mysql_query("Insert into zapiski set klu4='".$kol."', idwho ='1', message = '".$message."', towhom = '".(int)$id."', idtowhom = '".(int)$nk."', time = '".$time."', readd = '0', topic = '".$topic."', date='".$data."'");
//-------------------------//
echo $fsize2;
echo '<br/>
<div class="d1"><a href="friends.php?'.$ses.$takep2.'">Список контактов</a><br/>
<a href="enter.php?'.$ses.$takep2.'">Прихожая</a></div>';
include_once "foot.php";
mysql_close ($link);
exit;
break;
//======================================//
case 'add_no':
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n
<p align="left">n";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Ок</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="left">";
}
echo $fsize1;
$otkaz = mysql_query("DELETE FROM `friends` WHERE `usid`='".(int)$id."' LIMIT 1");
//-------------------------//
$fromid = mysql_fetch_array(mysql_query("SELECT `user` FROM `users` WHERE `id`='".(int)$id."'"));
$fromus = $fromid['user'];
$what = mysql_fetch_array(mysql_query("SELECT `id`,`user` FROM `users` WHERE `id`='".(int)$nk."'"));
mysql_query("UPDATE `friends` SET `whozajavka`='', `zajavka`='0' WHERE `usid`='".(int)$id."' AND `whozajavka`='".mysql_real_escape_string($what['user'])."'");
mysql_query("DELETE FROM `friends` WHERE `id`='0' AND `zajavka`='0' AND `usid`='".(int)$id."'");
$adm = mysql_query("Select * from users where user='".(int)$nk."'");
$z = mysql_fetch_array($adm);
$data = date("d-M-Y [H:i]");
$kol = rand(0,99999999);
$time = time();
$topic = "Контакты.";
$message = "Пользователь <b>" . $fromus . "</b> отклонил твою заявку на добавление в контакты.";
mysql_query("Insert into zapiski set klu4='".$kol."', idwho ='1', message = '".$message."', towhom = '".(int)$id."', idtowhom = '".(int)$nk."', time = '".$time."', readd = '0', topic = '".$topic."', date='".$data."'");
//-------------------------//
if (isset($otkaz)) {
echo 'Заявка отклонена!<br/>';
} else {
echo 'Произошла ошибка...<br/>';
}
echo $fsize2;
echo '<br/>
<div class="d1"><a href="friends.php?'.$ses.$takep2.'">Список контактов</a><br/>
<a href="enter.php?'.$ses.$takep2.'">Прихожая</a></div>';
include_once "foot.php";
mysql_close ($link);
exit;
break;
//======================================//
case 'add_ok':
$nick = mysql_real_escape_string(check($nick));
if (!is_numeric($nick)) {
if ($_POST['trun'] == 1) $nick = trun_to_rus($nick);
$nick = trim($nick);
if ($nick == '') $nick = 0;
$latuser = strtolower($nick);
$ruser = rus_to_k($nick);
if ($ruser == $nick) {
$select = mysql_query("Select user,id from users where latuser = '".$latuser."'");
} else {
$select = mysql_query("select user,id from users where ruser = '".$ruser."'");
}
} else {
$select = mysql_query("select user,id from users where id = '".$nick."'");
}
if (mysql_affected_rows() == 0) {
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n
<card id="error" title="error" ontimer="friends.php?$ses$takep2"><timer value="10" />n
<p align="left">n";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Ок</title>
<META HTTP-EQUIV="Refresh" CONTENT="2; URL=friends.php?$ses$takep2">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="left">";
}
echo $fsize1;
echo 'Пользователя <b>'.col_n($nick).'</b> невозможно добавить<br/> в контакты т.к. его не существует!<br/>';
echo $fsize2;
include_once "foot.php";
mysql_close ($link);
exit;
}
$inf = mysql_fetch_array ($select);
$nk = $inf['id'];
mysql_query("SELECT * FROM `friends` WHERE `usid`='".(int)$nk."' AND `id`='".(int)$id."'");
if (mysql_affected_rows() != 0) {
$friendnick = mysql_fetch_array(mysql_query ("SELECT `user` FROM `users` WHERE `id`='".(int)$nk."' LIMIT 1"));
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n";
if (isset($rm)) echo "<card id="error" title="error" ontimer="chat.php?$ses&rm=$rm&ref=$ref"><timer value="10" />n";
else echo "<card id="error" title="error" ontimer="friends.php?$ses&ref=$ref"><timer value="10" />n";
echo "<p align="left">n";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Ок</title>";
if (isset($rm)) echo "<META HTTP-EQUIV="Refresh" CONTENT="2; URL=chat.php?$ses&rm=$rm&ref=$ref">";
else echo "<META HTTP-EQUIV="Refresh" CONTENT="2; URL=friends.php?$ses&ref=$ref">";
echo "<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>";
echo "<div align="left">";
}
echo $fsize1;
echo "<b>".col_n($friendnick[0])."</b> уже давно у тебя в контактах!<br/>";
echo $fsize2;
include_once "foot.php";
mysql_close ($link);
exit;
break;
}
$addus = $inf['user'];
if (!ctype_digit($nk)) { header("Location: index.php?isset=403"); die; }
mysql_query("INSERT INTO `friends` SET `usid`='".(int)$nk."', `id`='".(int)$id."'");
mysql_query("INSERT INTO `friends` SET `usid`='".(int)$id."', `id`='".(int)$nk."'");
$what = mysql_fetch_array(mysql_query("SELECT `id`,`user` FROM `users` WHERE `id`='".(int)$nk."'"));
mysql_query("UPDATE `friends` SET `whozajavka`='', `zajavka`='0' WHERE `usid`='".(int)$id."' AND `whozajavka`='".mysql_real_escape_string($what['user'])."'");
mysql_query("DELETE FROM `friends` WHERE `id`='0' AND `zajavka`='0' AND `usid`='".(int)$id."'");
$friendnick = mysql_fetch_array(mysql_query("Select user from users where id='".(int)$nk."' LIMIT 1"));
//-------------------------//
$fromid = mysql_fetch_array(mysql_query("SELECT `user` FROM `users` WHERE `id`='".(int)$id."'"));
$fromus = $fromid['user'];
$adm = mysql_query ("Select * from users where user='".(int)$nk."'");
$z = mysql_fetch_array ($adm);
$data = date("d-M-Y [H:i]");
$kol = rand(0,99999999);
$time = time();
$topic = "Контакты.";
$message = "Пользователь <b>" . $fromus . "</b> принял твою заявку на добавление в друзья.";
mysql_query("Insert into zapiski set klu4='".$kol."', idwho ='1', message = '".$message."', towhom = '".(int)$id."', idtowhom = '".(int)$nk."', time = '".$time."', readd = '0', topic = '".$topic."', date='".$data."'");
//-------------------------//
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>n
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>n
<card id="ok" title="Ok" ontimer="friends.php?$ses$takep2"><timer value="5"/>n
<p align="center">";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Ок</title>
<META HTTP-EQUIV="Refresh" CONTENT="2; URL=friends.php?$ses$takep2">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="center">";
}
echo $fsize1;
echo "Пользователь <b>".col_n($addus)."</b> добавлен в контакты и оповещен!<br/>n";
echo $fsize2;
include_once "foot.php";
break;
//////////////////////////////////////////
}
?>