Тема: Одинаковые запросы (WAP/WEB мастеру/Помощь мастерам)

vsHTP (9 Aug 2016 в 23:45)
ап

Zed (10 Aug 2016 в 09:24)
Ты б кусок кода дал бы хоть

vsHTP (10 Aug 2016 в 11:04)
Zed, 
<?
if(isset($_GET[\'payment\'])){
$id = abs(intval($_GET[\'payment\']));
$room = mysql_fetch_assoc(mysql_query(\"SELECT * FROM `rooms` WHERE `id_up` = \'\".$id.\"\'\"));
$k_room = mysql_fetch_assoc(mysql_query(\"SELECT * FROM `room_users` WHERE `id_user` = \'\".$myID.\"\'\"));
if($user[\'gold\'] < $user[\'gold_room\']){
$_SESSION[\'msg\'] = \"Не хватает <img width=\'20\' height=\'20\' src=\'/img/money_36.png\'> \".n_f(($user[\'gold_room\']-$user[\'gold\'])).\"\";
header(\'Location: /game/\');
exit();
}else{
mysql_query(\"INSERT INTO `room_users` SET `id_user` = \'\".$myID.\"\', `id_up` = \'\".$room[\'id_up\'].\"\', `name` = \'\".$room[\'name\'].\"\', `item` = \'\".$room[\'item\'].\"\', `money_sek` = \'\".$room[\'money_sek\'].\"\', `gold` = \'\".($room[\'gold\']*1).\"\', `up_gold` = \'\".$room[\'up_gold\'].\"\'\");
mysql_query(\"UPDATE `users` SET `gold` = \'\".($user[\'gold\']-$user[\'gold_room\']).\"\', `money_sek` = \'\".($user[\'money_sek\']+$room[\'money_sek\']).\"\', `room` = \'\".($user[\'room\']+1).\"\', `gold_room` = \'\".($user[\'gold_room\']*10).\"\' WHERE (`id` = \'\".$myID.\"\')\");
$_SESSION[\'msg\'] = \"\".$room[\'name\'].\" успешно куплен.\";
header(\'Location: /game/\');
exit();
}
}
?>
		[i]Добавлено:[/i]
		Zed, Там надо сделать 2 условия чтобы денег хватало и чтобы повторно комноты не покупать id_up - это ид комнаты например 1. если он есть то надо сделатб так чтобы писало типо вы уже купили эту комнату

vsHTP (12 Aug 2016 в 17:04)
up ^

Zed (14 Aug 2016 в 18:51)
--Цитата--
vsHTP (10 Aug 2016 в 11:04):
Zed, 
<?
if(isset($_GET[\'payment\'])){
$id = abs(intval($_GET[\'payment\']));
$room = mysql_fetch_assoc(mysql_query(\"SELECT * FROM `rooms` WHERE `id_up` = \'\".$id.\"\'\"));
$k_room = mysql_fetch_assoc(mysql_query(\"SELECT * FROM `room_users` WHERE `id_user` = \'\".$myID.\"\'\"));
if($user[\'gold\'] < $user[\'gold_room\']){
$_SESSION[\'msg\'] = \"Не хватает <img width=\'20\' height=\'20\' src=\'/img/money_36.png\'> \".n_f(($user[\'gold_room\']-$user[\'gold\'])).\"\";
header(\'Location: /game/\');
exit();
}else{
mysql_query(\"INSERT INTO `room_users` SET `id_user` = \'\".$myID.\"\', `id_up` = \'\".$room[\'id_up\'].\"\', `name` = \'\".$room[\'name\'].\"\', `item` = \'\".$room[\'item\'].\"\', `money_sek` = \'\".$room[\'money_sek\'].\"\', `gold` = \'\".($room[\'gold\']*1).\"\', `up_gold` = \'\".$room[\'up_gold\'].\"\'\");
mysql_query(\"UPDATE `users` SET `gold` = \'\".($user[\'gold\']-$user[\'gold_room\']).\"\', `money_sek` = \'\".($user[\'money_sek\']+$room[\'money_sek\']).\"\', `room` = \'\".($user[\'room\']+1).\"\', `gold_room` = \'\".($user[\'gold_room\']*10).\"\' WHERE (`id` = \'\".$myID.\"\')\");
$_SESSION[\'msg\'] = \"\".$room[\'name\'].\" успешно куплен.\";
header(\'Location: /game/\');
exit();
}
}
?>
		[i]Добавлено:[/i]
		Zed, Там надо сделать 2 условия чтобы денег хватало и чтобы повторно комноты не покупать id_up - это ид комнаты например 1. если он есть то надо сделатб так чтобы писало типо вы уже купили эту комнату
----------
vsHTP, 
<?
if(isset($_GET[\'payment\'])){
$id = abs(intval($_GET[\'payment\']));
$room = mysql_fetch_assoc(mysql_query(\"SELECT * FROM `rooms` WHERE `id_up` = \'\".$id.\"\'\"));
$k_room = mysql_fetch_assoc(mysql_query(\"SELECT * FROM `room_users` WHERE `id_user` = \'\".$myID.\"\'\"));
$is_exists = mysql_result(mysql_query(\"SELECT * FROM `rooms` WHERE `id_up` = \'\".$id.\"\'  AND `id_user` = \'\".$myID.\"\' \"),0);
if($user[\'gold\'] < $user[\'gold_room\']){
$_SESSION[\'msg\'] = \"Не хватает <img width=\'20\' height=\'20\' src=\'/img/money_36.png\'> \".n_f(($user[\'gold_room\']-$user[\'gold\'])).\"\";
header(\'Location: /game/\');
exit();
}esleif(is_exists == 1){
$_SESSION[\'msg\'] = \'Вы уже создали комнату!\';
}
}else{
mysql_query(\"INSERT INTO `room_users` SET `id_user` = \'\".$myID.\"\', `id_up` = \'\".$room[\'id_up\'].\"\', `name` = \'\".$room[\'name\'].\"\', `item` = \'\".$room[\'item\'].\"\', `money_sek` = \'\".$room[\'money_sek\'].\"\', `gold` = \'\".($room[\'gold\']*1).\"\', `up_gold` = \'\".$room[\'up_gold\'].\"\'\");
mysql_query(\"UPDATE `users` SET `gold` = \'\".($user[\'gold\']-$user[\'gold_room\']).\"\', `money_sek` = \'\".($user[\'money_sek\']+$room[\'money_sek\']).\"\', `room` = \'\".($user[\'room\']+1).\"\', `gold_room` = \'\".($user[\'gold_room\']*10).\"\' WHERE (`id` = \'\".$myID.\"\')\");
$_SESSION[\'msg\'] = \"\".$room[\'name\'].\" успешно куплен.\";
header(\'Location: /game/\');
exit();
}
}
?>

Zed (14 Aug 2016 в 18:53)
vsHTP, 
<?
if(isset($_GET[\'payment\'])){
$id = abs(intval($_GET[\'payment\']));
$room = mysql_fetch_assoc(mysql_query(\"SELECT * FROM `rooms` WHERE `id_up` = \'\".$id.\"\'\"));
$k_room = mysql_fetch_assoc(mysql_query(\"SELECT * FROM `room_users` WHERE `id_user` = \'\".$myID.\"\'\"));
$is_exists = mysql_result(mysql_query(\"SELECT * FROM `rooms` WHERE `id_up` = \'\".$id.\"\'  AND `id_user` = \'\".$myID.\"\' \"),0);
if($user[\'gold\'] < $user[\'gold_room\']){
$_SESSION[\'msg\'] = \"Не хватает <img width=\'20\' height=\'20\' src=\'/img/money_36.png\'> \".n_f(($user[\'gold_room\']-$user[\'gold\'])).\"\";
header(\'Location: /game/\');
exit();
}esleif(is_exists == 1){
$_SESSION[\'msg\'] = \'Вы уже создали комнату!\';
}
}else{
mysql_query(\"INSERT INTO `room_users` SET `id_user` = \'\".$myID.\"\', `id_up` = \'\".$room[\'id_up\'].\"\', `name` = \'\".$room[\'name\'].\"\', `item` = \'\".$room[\'item\'].\"\', `money_sek` = \'\".$room[\'money_sek\'].\"\', `gold` = \'\".($room[\'gold\']*1).\"\', `up_gold` = \'\".$room[\'up_gold\'].\"\'\");
mysql_query(\"UPDATE `users` SET `gold` = \'\".($user[\'gold\']-$user[\'gold_room\']).\"\', `money_sek` = \'\".($user[\'money_sek\']+$room[\'money_sek\']).\"\', `room` = \'\".($user[\'room\']+1).\"\', `gold_room` = \'\".($user[\'gold_room\']*10).\"\' WHERE (`id` = \'\".$myID.\"\')\");
$_SESSION[\'msg\'] = \"\".$room[\'name\'].\" успешно куплен.\";
header(\'Location: /game/\');
exit();
}
}
?>

Zed (14 Aug 2016 в 18:54)
vsHTP, 
<?
if(isset($_GET[\'payment\'])){
$id = abs(intval($_GET[\'payment\']));
$room = mysql_fetch_assoc(mysql_query(\"SELECT * FROM `rooms` WHERE `id_up` = \'\".$id.\"\'\"));
$k_room = mysql_fetch_assoc(mysql_query(\"SELECT * FROM `room_users` WHERE `id_user` = \'\".$myID.\"\'\"));
$is_exists = mysql_result(mysql_query(\"SELECT * FROM `rooms` WHERE `id_up` = \'\".$id.\"\'  AND `id_user` = \'\".$myID.\"\' \"),0);
if($user[\'gold\'] < $user[\'gold_room\']){
$_SESSION[\'msg\'] = \"Не хватает <img width=\'20\' height=\'20\' src=\'/img/money_36.png\'> \".n_f(($user[\'gold_room\']-$user[\'gold\'])).\"\";
header(\'Location: /game/\');
exit();
}esleif($is_exists == 1){
$_SESSION[\'msg\'] = \'Вы уже создали комнату!\';
}
}else{
mysql_query(\"INSERT INTO `room_users` SET `id_user` = \'\".$myID.\"\', `id_up` = \'\".$room[\'id_up\'].\"\', `name` = \'\".$room[\'name\'].\"\', `item` = \'\".$room[\'item\'].\"\', `money_sek` = \'\".$room[\'money_sek\'].\"\', `gold` = \'\".($room[\'gold\']*1).\"\', `up_gold` = \'\".$room[\'up_gold\'].\"\'\");
mysql_query(\"UPDATE `users` SET `gold` = \'\".($user[\'gold\']-$user[\'gold_room\']).\"\', `money_sek` = \'\".($user[\'money_sek\']+$room[\'money_sek\']).\"\', `room` = \'\".($user[\'room\']+1).\"\', `gold_room` = \'\".($user[\'gold_room\']*10).\"\' WHERE (`id` = \'\".$myID.\"\')\");
$_SESSION[\'msg\'] = \"\".$room[\'name\'].\" успешно куплен.\";
header(\'Location: /game/\');
exit();
}
}
?>

Источник: http://www.dcms-social.ru/forum/20/44/61800/