View file vclubewm.ru/bar/cook.php

<?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)){
  echo "Вы не зарегистрированы";
  include_once '../sys/inc/tfoot.php';
  break;
}

include_once 'inc/start.php';
$tmp=mysql_fetch_array(mysql_query("SELECT * FROM `bar_tmp` WHERE `id_u`='".$user_id."'"));



if(isset($_GET['id'])){
$id=abs(intval($_GET['id']));
	if(mysql_result(mysql_query("SELECT COUNT(*) FROM `bar_my_ingridient` WHERE `id_u`='".$user_id."' AND `id_i`='".$id."' AND `col`>'0'"),0)!=0){
	
		if($tmp['i1']==0){
		mysql_query("UPDATE `bar_tmp` SET `i1`='".$id."' WHERE `id_u`='".$user_id."'");
		mysql_query("UPDATE `bar_my_ingridient` SET `col`=`col`-1 WHERE `id_u`='".$user_id."' AND `id_i`='".$id."'");
		header("Location:cook.php");
		exit;
		}
		elseif($tmp['i2']==0){
		mysql_query("UPDATE `bar_tmp` SET `i2`='".$id."' WHERE `id_u`='".$user_id."'");
		mysql_query("UPDATE `bar_my_ingridient` SET `col`=`col`-1 WHERE `id_u`='".$user_id."' AND `id_i`='".$id."'");
		header("Location:cook.php");
		exit;
		}
		elseif($tmp['i3']==0){
		mysql_query("UPDATE `bar_tmp` SET `i3`='".$id."' WHERE `id_u`='".$user_id."'");
		mysql_query("UPDATE `bar_my_ingridient` SET `col`=`col`-1 WHERE `id_u`='".$user_id."' AND `id_i`='".$id."'");
		header("Location:cook.php");
		exit;
		}
		
	}
}

if(isset($_POST['sub'])){
		
		$recept=$tmp['i1']."".($tmp['i2']!=0 ? ";".$tmp['i2'] : "")."".($tmp['i3']!=0 ? ";".$tmp['i3'] : "");
		if(mysql_result(mysql_query("SELECT COUNT(*) FROM `bar_my_recept` WHERE `id_u`='".$user_id."' AND `in`='".$recept."'"),0)!=0){
			$arr=mysql_fetch_array(mysql_query("SELECT * FROM `bar_my_recept` WHERE `id_u`='".$user_id."' AND `in`='".$recept."'"));
			
			mysql_query("INSERT INTO `bar_coctails`(`name`,`id_u`,`id_r`) VALUES('".$arr['name']."','".$user_id."','".$arr['id_r']."')");		
			mysql_query("UPDATE `bar_tmp` SET `i1`='0',`i2`='0',`i3`='0' WHERE `id_u`='".$user_id."'");
		
		$dels=explode(';',$recept);
		
		if(mysql_result(mysql_query("SELECT COUNT(*) FROM `bar_my_ingridient` WHERE `id_u`='".$user_id."' AND `id_i`='".$dels[0]."' AND `col`='0'"),0)==1)
		mysql_query("DELETE FROM `bar_my_ingridient` WHERE `id_u`='".$user_id."' AND `id_i`='".$dels[0]."' AND `col`='0'");
		if(isset($dels[1])){
		if(mysql_result(mysql_query("SELECT COUNT(*) FROM `bar_my_ingridient` WHERE `id_u`='".$user_id."' AND `id_i`='".$dels[1]."' AND `col`='0'"),0)==1)
		mysql_query("DELETE FROM `bar_my_ingridient` WHERE `id_u`='".$user_id."' AND `id_i`='".$dels[1]."' AND `col`='0'");
		}
		if(isset($dels[2])){
		if(mysql_result(mysql_query("SELECT COUNT(*) FROM `bar_my_ingridient` WHERE `id_u`='".$user_id."' AND `id_i`='".$dels[2]."' AND `col`='0'"),0)==1)
		mysql_query("DELETE FROM `bar_my_ingridient` WHERE `id_u`='".$user_id."' AND `id_i`='".$dels[2]."' AND `col`='0'");
		}
		
		header("Location:cook.php?msg");
		exit;
		}
		else
			bar_msg($diz['msg'],'У вас нет такого рецепта!');
	}

	if(isset($_POST['del'])){
	mysql_query("UPDATE `bar_my_ingridient` SET `col`=`col`+1 WHERE `id_i`='".$tmp['i1']."' AND `id_u`='".$user_id."'");
	mysql_query("UPDATE `bar_my_ingridient` SET `col`=`col`+1 WHERE `id_i`='".$tmp['i2']."' AND `id_u`='".$user_id."'");
	mysql_query("UPDATE `bar_my_ingridient` SET `col`=`col`+1 WHERE `id_i`='".$tmp['i3']."' AND `id_u`='".$user_id."'");
	mysql_query("UPDATE `bar_tmp` SET `i1`='0',`i2`='0',`i3`='0' WHERE `id_u`='".$user_id."'");
	header("Location:cook.php");
		exit;
	}
	
	if(isset($_GET['msg'])){
	
		bar_msg($diz['msg'],'Коктейль успешно приготовлен');
	}
echo "
<div class='".$diz['main']."'>

<img src='i/4.png' /> ".$bar_user['level']."
<img src='i/exp.png' /> ".$bar_user['exp']."
<img src='i/d.png' /> ".$bar_user['money']."
<br/><img src='i/bottle.png' />".$bar_user['alc']." ".nap($bar_user['alc'])."
<div class='".$diz['title2']."'>Приготовить коктейль</div>
<center>
<table>
<tr>
<td style='border: 2px solid #0090C4;
background-color: #fff;
height:48px;
width:48px;' align='center'>
<img src='i/".($tmp['i1']!=0 ? "i_" : "")."".$tmp['i1'].".png' />
</td>
<td style='border: 2px solid #0090C4;
background-color: #fff;
height:48px;
width:48px;' align='center'>
<img src='i/".($tmp['i2']!=0 ? "i_" : "")."".$tmp['i2'].".png' />
</td>
<td style='border: 2px solid #0090C4;
background-color: #fff;
height:48px;
width:48px;' align='center'>
<img src='i/".($tmp['i3']!=0 ? "i_" : "")."".$tmp['i3'].".png' />
</td>
</tr>
</table>
<img src='i/bar.gif' /><br/>
<form method='post' action='cook.php?'>
<input type='submit' name='sub' value='Смешать'/><input type='submit' name='del' value='Убрать'/></form></center>


<div class='".$diz['title2']."'>Ингридиенты</div>";


if(mysql_result(mysql_query("SELECT COUNT(*) FROM `bar_my_ingridient` WHERE `id_u`='".$user_id."'"),0)!=0){
$total=mysql_result(mysql_query("SELECT COUNT(*) FROM `bar_my_ingridient` WHERE `id_u`='".$user_id."'"),0);
$quert=mysql_query("SELECT * FROM `bar_my_ingridient` WHERE `id_u`='".$user_id."' ORDER BY `id` ASC LIMIT ".$start.",5");


	while($array=mysql_fetch_array($quert)){

	echo '<table cellpadding="0">
<tr>
<td style="border: 2px solid #0090C4;
background-color: #fff;
height:48px;
width:48px;" align="center">
<img src="i/i_'.$array['id_i'].'.png" alt="." />
</td>
<td>

 '.mysql_result(mysql_query("SELECT `name` FROM `bar_ingridient` WHERE `id`='".$array['id_i']."'"),0).'
<br/>
 В баре: '.$array['col'].'<br/>
 <a href="cook.php?id='.$array['id_i'].'">Выбрать</a>
</td></tr></table>';
	
	}
if ($total > 5) {
    echo bar_pagenav('cook.php?', $start, $total, 5);
   }
}
else
echo "У вас нет ингридиентов!";
echo "</div>";
ret($diz['ret'],'Мой бар','index.php');
  include_once '../sys/inc/tfoot.php';
?>