View file collection/predlog_obmen.php

<?
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';

$set['title'] = 'Коллекции | Предложения обмена';

include_once '../sys/inc/thead.php';
title();
aut();



if (isset($user))$ank['id']=$user['id'];
if (isset($_GET['id']))$ank['id']=intval($_GET['id']);
$ank = get_user($ank['id']);


$act = isset ($_GET['act']) ? $_GET['act'] : '';
switch ($act) {

	case 'no':
$ska = "".intval($_GET['id'])."";
$obm = mysql_fetch_assoc(mysql_query("SELECT * FROM `collection_obmen_pooh` WHERE `id` = '$ska' limit 1"));
$user113 = mysql_fetch_assoc(mysql_query("SELECT * FROM `collection_obmen_pooh` WHERE `id` = $ska LIMIT 1"));
$user3 = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $user113[id_kto] LIMIT 1"));
$okayy = 'Пользователь '.$user['nick'].' не согласился на Ваше предложение обмена жетонами';
mysql_query("INSERT INTO `mail` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$user3[id]', '$okayy', '$time')");
if ($obm['nomer_coll'] == 1) {
	$akaya = 'pooh';
}
if ($obm['nomer_coll'] == 2) {
	$akaya = 'smesh';
}
if ($obm['nomer_coll'] == 3) {
	$akaya = 'ddak';
}
if ($obm['nomer_coll'] == 4) {
	$akaya = 'gerk';
}
////
mysql_query("UPDATE `user` SET `collection_".$akaya."` = '".($user3['collection_'.$akaya.'']+1)."' WHERE `id` = '$user3[id]' LIMIT 1",$db);
////
mysql_query("UPDATE `user` SET `collection_".$akaya."_nomer_".$obm["nomer_jett"]."` = '".($user3['collection_'.$akaya.'_nomer_'.$obm['nomer_jett'].'']+1)."' WHERE `id` = '$user3[id]' LIMIT 1",$db);
mysql_query("DELETE FROM `collection_obmen_pooh` WHERE `id` = '".intval($_GET['id'])."'");
	$_SESSION['message'] = 'Предложение отклонено!';
header ("Location: /collection/predlog_obmen.php" . SID);
exit;
break;
////////////////////////////////////////////////////////////////////////////////////////


case 'ok':


$ska = "".intval($_GET['id'])."";
$obm = mysql_fetch_assoc(mysql_query("SELECT * FROM `collection_obmen_pooh` WHERE `id` = '$ska' limit 1"));
$user113 = mysql_fetch_assoc(mysql_query("SELECT * FROM `collection_obmen_pooh` WHERE `id` = '$ska' LIMIT 1"));
$user3 = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $user113[id_kto] LIMIT 1"));
if ($obm['nomer_coll'] == 1) {
	$akaya11 = 'pooh';
}
if ($obm['nomer_coll'] == 2) {
	$akaya11 = 'smesh';
}
if ($obm['nomer_coll'] == 3) {
	$akaya11 = 'ddak';
}
if ($obm['nomer_coll'] == 4) {
	$akaya11 = 'gerk';
}
if ($user['collection_'.$akaya11.'_nomer_'.$obm['na_kakoi'].''] == 0) {
	$_SESSION['message'] = 'У Вас уже нету жетона № '.$obm['na_kakoi'].'!';
	////
mysql_query("UPDATE `user` SET `collection_".$akaya."` = '".($user3['collection_'.$akaya.'']+1)."' WHERE `id` = '$user3[id]' LIMIT 1",$db);
////
mysql_query("UPDATE `user` SET `collection_".$akaya."_nomer_".$obm["nomer_jett"]."` = '".($user3['collection_'.$akaya.'_nomer_'.$obm['nomer_jett'].'']+1)."' WHERE `id` = '$user3[id]' LIMIT 1",$db);
	mysql_query("DELETE FROM `collection_obmen_pooh` WHERE `id` = '".intval($_GET['id'])."'");
header ("Location: /collection/index.php" . SID);
exit;
}else{

if ($obm['nomer_coll'] == 1) {
	$akaya1 = 'pooh';
}
if ($obm['nomer_coll'] == 2) {
	$akaya1 = 'smesh';
}
if ($obm['nomer_coll'] == 3) {
	$akaya1 = 'ddak';
}
if ($obm['nomer_coll'] == 4) {
	$akaya1 = 'gerk';
}
///
mysql_query("UPDATE `user` SET `collection_".$akaya1."` = '".($user3['collection_'.$akaya1.'']+1)."' WHERE `id` = '$user3[id]' LIMIT 1",$db);
///
mysql_query("UPDATE `user` SET `collection_".$akaya1."_nomer_".$obm["nomer_jett"]."` = '".($user['collection_'.$akaya1.'_nomer_'.$obm['nomer_jett'].'']+1)."' WHERE `id` = '$user[id]' LIMIT 1",$db);
mysql_query("UPDATE `user` SET `collection_".$akaya1."_nomer_".$obm["na_kakoi"]."` = '".($user['collection_'.$akaya1.'_nomer_'.$obm['na_kakoi'].'']-1)."' WHERE `id` = '$user[id]' LIMIT 1",$db);
mysql_query("UPDATE `user` SET `collection_".$akaya1."_nomer_".$obm["na_kakoi"]."` = '".($user3['collection_'.$akaya1.'_nomer_'.$obm['na_kakoi'].'']+1)."' WHERE `id` = '$user3[id]' LIMIT 1",$db);
$okayy = 'Пользователь '.$user['nick'].' принял Ваше предложение обмена жетонами';
mysql_query("INSERT INTO `mail` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$user3[id]', '$okayy', '$time')");
$_SESSION['message'] = 'Обмен жетонами успешно произведен!';
mysql_query("DELETE FROM `collection_obmen_pooh` WHERE `id` = '".intval($_GET['id'])."'");

header ("Location: /collection/index.php" . SID);
exit;
}
break;
///////////////////////////////////////////////////////////////////////////


default:
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `collection_obmen_pooh` WHERE `id_skem` = '$user[id]'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];

if ($k_post==0) {

echo " <div class='mess'>";
echo "Нет предложений...";
echo "  </div>";

}

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

while ($post = mysql_fetch_array($q))
{
if ($num==0) {
echo "  <div class='nav1'>";
$num=1;
}elseif ($num==1) {
echo "  <div class='nav2'>";
$num=0;
}

if ($post['nomer_coll'] == 1) {
	$kakaya = 'n';
}
if ($post['nomer_coll'] == 2) {
	$kakaya = 'n_1';
}
if ($post['nomer_coll'] == 3) {
	$kakaya = 'n_2';
}
if ($post['nomer_coll'] == 4) {
	$kakaya = 'n_3';
}
	$user11 = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $post[id_kto] LIMIT 1"));
	echo ''.group($user11['id']).' <a href="/id'.$user11['id'].'">'.$user11['nick'].'</a> предлогает вам: жетон <b>№ '.$post['nomer_jett'].'</b> в замен на <b>№ '.$post['na_kakoi'].'</b><hr /><center><img src="/collection/img_collectio'.$kakaya.'/'.$post['nomer_jett'].'.gif" width="70" height="70" alt="" /> <font color="red"><b>&raquo;</b></font><font color="green"><b>&raquo;</b></font><img src="/collection/img_collectio'.$kakaya.'/'.$post['na_kakoi'].'.gif" width="80" height="80" alt="" /></center><div align="right">[<img src="/collection/img/ok.gif" alt="" /> <a href="?id='.$post['id'].'&act=ok">Согласиться на обмен</a> | <img src="/collection/img/delete.gif" alt="" /> <a href="?id='.$post['id'].'&act=no">Отказ</a>]</div>* Коллекция';
	if ($post['nomer_coll'] == 1) {
		echo " <font color='orange'>POOH</font>";
	}
	if ($post['nomer_coll'] == 2) {
		echo " <font color='blue'>СмеШаРиКи</font>";
	}
	if ($post['nomer_coll'] == 3) {
		echo " <font color='pink'>Дональд Дак</font>";
	}
		if ($post['nomer_coll'] == 4) {
		echo " <font color='brown'>Геркулес</font>";
	}
	echo '</div>';

}



}
echo "<div class='nav1'><img src='/collection/img/b.gif' alt='' /> <a href='/collection/'>К коллекциям</a></div>";
include_once '../sys/inc/tfoot.php';
?>