Файл: vfermu.ru/sys/sellar/seat_vivod.php
Строк: 38
<?
$rec=mysql_fetch_array(mysql_query("SELECT * FROM `farm_history_recept` WHERE `p1`='".($tmp['p1'])."' AND `p2` = '".($tmp['p2'])."' AND `p3` = '".($tmp['p3'])."' AND `p4` = '".($tmp['p4'])."' AND `p5` = '".($tmp['p5'])."' AND `pc1` = '".($tmp['pc1'])."' AND `pc2` = '".($tmp['pc2'])."' AND `pc3` = '".($tmp['pc3'])."' AND `pc4` = '".($tmp['pc4'])."' AND `pc5` = '".($tmp['pc5'])."' AND `s1` = '".($tmp['s1'])."' AND `s2` = '".($tmp['s2'])."' AND `s3` = '".($tmp['s3'])."' AND `s4` = '".($tmp['s4'])."' AND `s5` = '".($tmp['s5'])."' AND `sc1` = '".($tmp['sc1'])."' AND `sc2` = '".($tmp['sc2'])."' AND `sc3` = '".($tmp['sc3'])."' AND `sc4` = '".($tmp['sc4'])."' AND `sc5` = '".($tmp['sc5'])."' AND `time` = '".($tmp['time'])."' AND `id_user` = '$ku[id]'"));
if($tmp['p1']>0){if($pw1['count']>=$tmp['pc1']){$err1=1;}}
if($tmp['p2']>0){if($pw2['count']>=$tmp['pc2']){$err2=1;}}
if($tmp['p3']>0){if($pw3['count']>=$tmp['pc3']){$err3=1;}}
if($tmp['p4']>0){if($pw4['count']>=$tmp['pc4']){$err4=1;}}
if($tmp['p5']>0){if($pw5['count']>=$tmp['pc5']){$err5=1;}}
if($tmp['s1']>0){if($sw1['count']>=$tmp['sc1']){$err6=1;}}
if($tmp['s2']>0){if($sw2['count']>=$tmp['sc2']){$err7=1;}}
if($tmp['s3']>0){if($sw3['count']>=$tmp['sc3']){$err8=1;}}
if($tmp['s4']>0){if($sw4['count']>=$tmp['sc4']){$err9=1;}}
if($tmp['s5']>0){if($sw5['count']>=$tmp['sc5']){$err10=1;}}
$r1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($tmp['p1'])."'"));
$r2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($tmp['p2'])."'"));
$r3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($tmp['p3'])."'"));
$r4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($tmp['p4'])."'"));
$r5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($tmp['p5'])."'"));
$u1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($tmp['s1'])."'"));
$u2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($tmp['s2'])."'"));
$u3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($tmp['s3'])."'"));
$u4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($tmp['s4'])."'"));
$u5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($tmp['s5'])."'"));
if($tmp['p1']>0){if(!isset($err1)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
////buy 2
if($tmp['p2']>0){if(!isset($err2)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
////buy3
if($tmp['p3']>0){if(!isset($err3)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
////buy4
if($tmp['p4']>0){if(!isset($err4)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
////buy5
if($tmp['p5']>0){if(!isset($err5)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
///buy6
if($tmp['s1']>0){if(!isset($err6)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
///buy7
if($tmp['s2']>0){if(!isset($err7)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
///buy8
if($tmp['s3']>0){if(!isset($err8)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
///buy9
if($tmp['s4']>0){if(!isset($err9)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
///buy10
if($tmp['s5']>0){if(!isset($err1)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
if(!isset($err_z)){
if($rec['id']==0){mysql_query("INSERT INTO `farm_history_recept` SET `id_user` = '$ku[id]',`time` = '".($tmp['time'])."',`p1` = '".($tmp['p1'])."',`p2` = '".($tmp['p2'])."', `p3` = '".($tmp['p3'])."', `p4` = '".($tmp['p4'])."', `p5` = '".($tmp['p5'])."', `pc1` = '".($tmp['pc1'])."', `pc2` = '".($tmp['pc2'])."',`pc3` = '".($tmp['pc3'])."',`pc4` = '".($tmp['pc4'])."',`pc5`='".($tmp['pc5'])."',`s1` = '".($tmp['s1'])."',`s2` = '".($tmp['s2'])."',`s3` = '".($tmp['s3'])."',`s4` = '".($tmp['s4'])."',`s5` = '".($tmp[s5])."',`sc1` = '".($tmp['sc1'])."',`sc2` = '".($tmp['sc2'])."',`sc3` = '".($tmp['sc3'])."',`sc4` = '".($tmp['sc4'])."',`sc5` = '".($tmp['sc5'])."'");
$id=mysql_insert_id();}else{$id = $rec[id];}
if($tmp['p1']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw1['count']-$tmp['pc1'])."' WHERE `id` = '".($pw1['id'])."'");}////buy 2
if($tmp['p2']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw2['count']-$tmp['pc2'])."' WHERE `id` = '".($pw2['id'])."'");}
////buy3
if($tmp['p3']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw3['count']-$tmp['pc3'])."' WHERE `id` = '".($pw3['id'])."'");}
////buy4
if($tmp['p4']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw4['count']-$tmp['pc4'])."' WHERE `id` = '".($pw4['id'])."'");}
////buy5
if($tmp['p5']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw5['count']-$tmp['pc5'])."' WHERE `id` = '".($pw5['id'])."'");}
///buy6
if($tmp['s1']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw1['count']-$tmp['sc1'])."' WHERE `id` = '".($sw1['id'])."'");}
///buy7
if($tmp['s2']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw2['count']-$tmp['sc2'])."' WHERE `id` = '".($sw2['id'])."'");}///buy8
if($tmp['s3']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw3['count']-$tmp['sc3'])."' WHERE `id` = '".($sw3['id'])."'");}///buy9
if($tmp['s4']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw4['count']-$tmp['sc4'])."' WHERE `id` = '".($sw4['id'])."'");}//buy10
if($tmp['s5']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw5['count']-$tmp['sc5'])."' WHERE `id` = '".($sw5['id'])."'");}
$skoro=0;
$puper=$ku['cooker']*3;
if($ku['cooker']>0)$skoro=$tmp['time']/100*$puper;
$left=$tmp['time']-$skoro;
mysql_query("UPDATE `farm_sellar` SET `id_rec` = '".($id)."',`time` = '".($left+$time)."' WHERE `id` = '".($polka['id'])."' LIMIT 1");
mysql_query("UPDATE `farm_user` SET `last_recept` = '".($id)."' WHERE `id` = '$ku[id]' LIMIT 1");}
header("Location:/?mysellar");exit;
?>