Файл: vfermu.ru/sys/sellar/seat_add_ingridient.php
Строк: 53
<?
if(isset($_GET['select']) && intval($_GET['select'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_warehouse` WHERE `id` = '".intval($_GET['select'])."'"),0)==1){
$pl=mysql_fetch_array(mysql_query("SELECT * FROM `farm_warehouse` WHERE `id` = '".intval($_GET['select'])."' AND `id_user` = '".($ku['id'])."'"));
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($pl['id_plant'])."'"));
$query = mysql_real_escape_string($plant['id']);
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar_tmp` WHERE `id_user` = '".($ku['id'])."' AND (`p1` like '%".($query)."%' OR `p2` like '%".($query)."%' OR `p3` like '%".($query)."%' OR `p4` like '%".($query)."%' OR `p5` like '%".($query)."%')"),0);
if ($k_post==0){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar_tmp` WHERE `id_user` = '$ku[id]' AND `p1` = '0'"),0)==1){mysql_query("UPDATE `farm_sellar_tmp` SET `p1` = '".($plant['id'])."',`pc1` = '1' WHERE `id_user` = '".($ku['id'])."' LIMIT 1");}
elseif(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar_tmp` WHERE `id_user` = '$ku[id]' AND `p2` = '0'"),0)==1){mysql_query("UPDATE `farm_sellar_tmp` SET `p2` = '".($plant['id'])."',`pc2` = '1' WHERE `id_user` = '".($ku['id'])."' LIMIT 1");}
elseif(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar_tmp` WHERE `id_user` = '$ku[id]' AND `p3` = '0'"),0)==1){mysql_query("UPDATE `farm_sellar_tmp` SET `p3` = '".($plant['id'])."',`pc3` = '1' WHERE `id_user` = '".($ku['id'])."' LIMIT 1");}
elseif(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar_tmp` WHERE `id_user` = '$ku[id]' AND `p4` = '0'"),0)==1){mysql_query("UPDATE `farm_sellar_tmp` SET `p4` = '".($plant['id'])."',`pc4` = '1' WHERE `id_user` = '".($ku['id'])."' LIMIT 1");}
elseif(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar_tmp` WHERE `id_user` = '$ku[id]' AND `p5` = '0'"),0)==1){mysql_query("UPDATE `farm_sellar_tmp` SET `p5` = '".($plant['id'])."',`pc5` = '1' WHERE `id_user` = '".($ku['id'])."' LIMIT 1");}}
header("Location:/?mysellar&seat=$polka[id]");exit;}
if(isset($_GET['select2']) && intval($_GET['select2'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_my_speci` WHERE `id` = '".intval($_GET['select2'])."' AND `id_user` = '".($ku['id'])."'"),0)==1){
$sp=mysql_fetch_array(mysql_query("SELECT * FROM `farm_my_speci` WHERE `id` = '".intval($_GET['select2'])."'"));
$speci=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($sp['id_spec'])."'"));
$query = mysql_real_escape_string($speci[id]);
$k_post2=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar_tmp` WHERE `id_user` = '".($ku['id'])."' AND (`s1` like '%".($query)."%' OR `s2` like '%".($query)."%' OR `s3` like '%".($query)."%' OR `s4` like '%".($query)."%' OR`s5` like '%".($query)."%')"),0);
if ($k_post2==0){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar_tmp` WHERE `id_user` = '$ku[id]' AND `s1` = '0'"),0)==1){
mysql_query("UPDATE `farm_sellar_tmp` SET `s1` = '".($speci['id'])."',`sc1` = '1' WHERE `id_user` = '".($ku['id'])."' LIMIT 1");}
elseif(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar_tmp` WHERE `id_user` = '$ku[id]' AND `s2` = '0'"),0)==1){
mysql_query("UPDATE `farm_sellar_tmp` SET `s2` = '".($speci['id'])."',`sc2` = '1' WHERE `id_user` = '".($ku['id'])."' LIMIT 1");}
elseif(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar_tmp` WHERE `id_user` = '$ku[id]' AND `s3` = '0'"),0)==1){
mysql_query("UPDATE `farm_sellar_tmp` SET `s3` = '".($speci['id'])."',`sc3` = '1' WHERE `id_user` = '".($ku['id'])."' LIMIT 1");}
elseif(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar_tmp` WHERE `id_user` = '$ku[id]' AND `s4` = '0'"),0)==1){
mysql_query("UPDATE `farm_sellar_tmp` SET `s4` = '".($speci['id'])."',`sc4` = '1' WHERE `id_user` = '".($ku['id'])."' LIMIT 1");}
elseif(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar_tmp` WHERE `id_user` = '$ku[id]' AND `s5` = '0'"),0)==1){
mysql_query("UPDATE `farm_sellar_tmp` SET `s5` = '".($speci['id'])."',`sc5` = '1' WHERE `id_user` = '".($ku['id'])."' LIMIT 1");}}
header("Location:/?mysellar&seat=$polka[id]");exit;}
echo"<div class='event'><h1><a href='/?mysellar&seat=$polka[id]'>Состав рецепта</a> / Амбар</h1></div>";
echo "<div class='content'>";
echo "<div class='block'>";
echo "<div><h3>Овощи</h3>";
echo "<ul class='ptm'>";
$q=mysql_query("SELECT * FROM `farm_warehouse` WHERE `id_user` = '$ku[id]' AND `count` > '0'");
if(mysql_num_rows($q)==0)echo "<li>В амбаре нету овощей</li>";
$cm=0;
while($post=mysql_fetch_array($q))
{
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id_collective` = '0' AND `type` = '0' AND `id` = '$post[id_plant]'"));
echo "<li><div><img width='16' height='16' src='images/icons/tomato.png' alt='o'><span class='title'>".hsc($plant['name'])."</span> (<span>$post[count]</span>): <a href='/?mysellar&seat=$polka[id]&add_ingridient&select=$post[id]'>В рецепт</a></div></li>";
}
echo "</ul></div>";
echo "<div><h3>Добавки</h3>";
echo "<ul class='ptm'>";
$q=mysql_query("SELECT * FROM `farm_my_speci` WHERE `id_user` = '".($ku['id'])."' AND `count` > '0'");
if(mysql_num_rows($q)==0)echo "<li>В амбаре нету Специй</li>";
$cm=0;
while($post=mysql_fetch_array($q))
{
$speci=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($post['id_spec'])."'"));
echo "<li><div><img width='16' height='16' src='images/icons/tomato.png' alt='o'><span class='title'>".hsc($speci['name'])."</span> (<span>$post[count]</span>): <a href='/?mysellar&seat=$polka[id]&add_ingridient&select2=$post[id]'>В рецепт</a></div></li>";
}
echo "</ul></div>";
echo "</div>";
include_once 'sys/other/foot.php';
?>