View file social/user/frends/create.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/user.php';



only_reg();











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`");



	



		/*



		==========================



		Уведомления друзьях



		==========================



		*/







		mysql_query("INSERT INTO `notification` (`avtor`, `id_user`, `id_object`, `type`, `time`) VALUES ('$user[id]', '$no', '$user[id]', 'no_frend', '$time')");



		



	$_SESSION['message']="Заявка отклонена";



	header("Location: new.php?".SID);



	exit;



}







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;}



    $a = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE `user`='$ok' AND `to`='$user[id]'"),0);



	$as = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '".$ok."' LIMIT 1"));



	if ($a==0)



	{



	die("Ошибка");



	}



	else{	



	



	



	/*----------------------Лента------------------------*/



	$q = mysql_query("SELECT * FROM `frends` WHERE `user` = '".$user['id']."' AND `i` = '1'"); 



	



	/* Список друзей принимающего заявку */



	while ($f = mysql_fetch_array($q)){



	



		$a=get_user($f['frend']);



		



		$lentaSet = mysql_fetch_array(mysql_query("SELECT * FROM `tape_set` WHERE `id_user` = '".$a['id']."' LIMIT 1")); // Общая настройка ленты



		



		if ($f['lenta_frends']==1 && $lenaSet['lenta_frends']==1) /* Фильтр рассылки */



		{	



			if (mysql_result(mysql_query("SELECT COUNT(*) FROM `tape` WHERE `id_user` = '$a[id]' AND `type` = 'frends' AND `id_file` = '$ok'"),0)==0)	{ 



			



				/* Отправляем друзьям принявшего дружбу в ленту нового друга */		



				mysql_query("INSERT INTO `tape` (`id_user`, `avtor`, `type`, `time`, `id_file`, `count`) values('$a[id]', '$user[id]', 'frends', '$time', '$ok', '1')");



			



			}



		}



	}



		



		$q = mysql_query("SELECT * FROM `frends` WHERE `user` = '$ok' AND `i` = '1'"); 



		



			/* Список друзей подавщего заявку */



			while ($f = mysql_fetch_array($q)){



			



			$a=get_user($f['frend']);



			



			$lentaSet = mysql_fetch_array(mysql_query("SELECT * FROM `tape_set` WHERE `id_user` = '".$a['id']."' LIMIT 1")); // Общая настройка ленты



			



				if ($f['lenta_frends']==1 && $lentaSet['lenta_frends']==1) /* Фильтр рассылки */



				{	



					if (mysql_result(mysql_query("SELECT COUNT(*) FROM `tape` WHERE `id_user` = '$a[id]' AND `type` = 'frends' AND `id_file` = '$user[id]'"),0)==0)	



					{ 		



						



						/* Отправляем друзьям отправившего заявку в ленту нового друга */	



						mysql_query("INSERT INTO `tape` (`id_user`, `avtor`, `type`, `time`, `id_file`, `count`) values('$a[id]', '$ok', 'frends', '$time', '$user[id]', '1')"); 	



					



					}



				}



			}



		



		/*-------------------alex-borisi--------------------*/	



		



	if (mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE (`user` = '$user[id]' AND `to` = '$ok') OR (`user` = '$ok' AND `to` = '$user[id]')"),0)==1)



	{



		/*



		==========================



		Уведомления друзьях



		==========================



		*/







		mysql_query("INSERT INTO `notification` (`avtor`, `id_user`, `id_object`, `type`, `time`) VALUES ('$user[id]', '$ok', '$user[id]', 'ok_frend', '$time')");



		



	mysql_query("INSERT INTO `frends` (`user`, `frend`, `time`, `i`) values('$user[id]', '$ok', '$time', '1')");



    mysql_query("INSERT INTO `frends` (`user`, `frend`, `time`, `i`) values('$ok', '$user[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`");



	}		



	$_SESSION['message']="Пользователь добавлен в список ваших друзей";



	header("Location: new.php?".SID);



	exit;



	}



}







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;}



  if (mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE (`user` = '$user[id]' AND `frend` = '$no') OR (`user` = '$no' AND `frend` = '$user[id]') LIMIT 1"),0)>0)



  {



  			/*



		==========================



		Уведомления друзьях



		==========================



		*/







		mysql_query("INSERT INTO `notification` (`avtor`, `id_user`, `id_object`, `type`, `time`) VALUES ('$user[id]', '$no', '$user[id]', 'del_frend', '$time')");



		



  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`");







	$_SESSION['message']="Пользователь удален из списка ваших друзей";



	header("location:  " . htmlspecialchars($_SERVER['HTTP_REFERER']) . "");



	}



exit;



}







if (isset($_GET['otm']))



{



  $no = intval($_GET['otm']);



  if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$no' LIMIT 1"),0)==0){header("Location: index.php?");exit;}



  if (mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE (`user` = '$user[id]' AND `to` = '$no') OR (`user` = '$no' AND `to` = '$user[id]') LIMIT 1"),0)>0)



  {



  		/*



		==========================



		Уведомления друзьях



		==========================



		*/







		mysql_query("INSERT INTO `notification` (`avtor`, `id_user`, `id_object`, `type`, `time`) VALUES ('$user[id]', '$no', '$user[id]', 'otm_frend', '$time')");



  



  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`");



	$_SESSION['message']="Заявка отклонена";



	header("location:  " . htmlspecialchars($_SERVER['HTTP_REFERER']) . "");



	}



exit;



}







if (isset($_GET['add']))



{



$ank['id']=intval($_GET['add']);



if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$ank[id]' LIMIT 1"),0)==0){header("Location: index.php?".SID);exit;}



if (mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE (`user` = '$user[id]' AND `frend` = '$ank[id]') OR (`user` = '$ank[id]' AND `frend` = '$user[id]') LIMIT 1"),0)==1){header("Location: index.php?".SID);exit;}



if (mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE (`user` = '$user[id]' AND `to` = '$ank[id]') OR (`user` = '$ank[id]' AND `to` = '$user[id]') LIMIT 1"),0)==1){header("Location: index.php?".SID);exit;}



if ($ank['id']==$user['id']){header("Location: index.php?".SID);exit;}







mysql_query("INSERT INTO `frends_new` (`user`, `to`, `time`) values('$user[id]', '$ank[id]', '$time')");



mysql_query("OPTIMIZE TABLE `frends_new`");







$_SESSION['message']="Заявка отправлена";



header("location:  " . htmlspecialchars($_SERVER['HTTP_REFERER']) . "");



exit;



}



include_once '../../sys/inc/tfoot.php';



?>