Просмотр архива Новый колхоз


<?
if(isset($_GET['mysellar']) && isset($_GET['seat']) && intval($_GET['seat'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar` WHERE `id` = '".intval($_GET['seat'])."' AND `id_user` = '$ku[id]' AND `id_rec` = '0'"),0)!=0 && $ku['last_recept']){


$rec=mysql_fetch_array(mysql_query("SELECT * FROM `farm_history_recept` WHERE `id_user` = '$ku[id]' AND `id` = '".($ku['last_recept'])."'"));


if($rec['p1']>0){if($pw1['count']>=$rec['pc1']){$err1=1;}}
if($rec['p2']>0){if($pw2['count']>=$rec['pc2']){$err2=1;}}
if($rec['p3']>0){if($pw3['count']>=$rec['pc3']){$err3=1;}}
if($rec['p4']>0){if($pw4['count']>=$rec['pc4']){$err4=1;}}
if($rec['p5']>0){if($pw5['count']>=$rec['pc5']){$err5=1;}}
if($rec['s1']>0){if($sw1['count']>=$rec['sc1']){$err6=1;}}
if($rec['s2']>0){if($sw2['count']>=$rec['sc2']){$err7=1;}}
if($rec['s3']>0){if($sw3['count']>=$rec['sc3']){$err8=1;}}
if($rec['s4']>0){if($sw4['count']>=$rec['sc4']){$err9=1;}}
if($rec['s5']>0){if($sw5['count']>=$rec['sc5']){$err10=1;}}


$r1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($rec['p1'])."'"));
$r2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($rec['p2'])."'"));
$r3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($rec['p3'])."'"));
$r4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($rec['p4'])."'"));
$r5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '".($rec['p5'])."'"));
$u1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($rec['s1'])."'"));
$u2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($rec['s2'])."'"));
$u3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($rec['s3'])."'"));
$u4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($rec['s4'])."'"));
$u5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_speci` WHERE `id` = '".($rec['s5'])."'"));
///start
///plant start
if($rec['p1']>0){$rpw1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_warehouse` WHERE `id_user` = '".($ku['id'])."' AND `id_plant` = '".($rec['p1'])."'"),0);}
if($rec['p2']>0){$rpw2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_warehouse` WHERE `id_user` = '".($ku['id'])."' AND `id_plant` = '".($rec['p2'])."'"),0);}
if($rec['p3']>0){$rpw3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_warehouse` WHERE `id_user` = '".($ku['id'])."' AND `id_plant` = '".($rec['p3'])."'"),0);}
if($rec['p4']>0){$rpw4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_warehouse` WHERE `id_user` = '".($ku['id'])."' AND `id_plant` = '".($rec['p4'])."'"),0);}
if($rec['p5']>0){$rpw5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_warehouse` WHERE `id_user` = '".($ku['id'])."' AND `id_plant` = '".($rec['p5'])."'"),0);}
///plant end
////speci start
if($rec['s1']>0){$rsw1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_my_speci` WHERE `id_user` = '".($ku['id'])."' AND `id_spec` = '".($rec['s1'])."'"),0);}

if($rec['s2']>0){$rsw2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_my_speci` WHERE `id_user` = '".($ku['id'])."' AND `id_spec` = '".($rec['s2'])."'"),0);}

if($rec['s3']>0){$rsw3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_my_speci` WHERE `id_user` = '".($ku['id'])."' AND `id_spec` = '".($rec['s3'])."'"),0);}

if($rec['s4']>0){$rsw4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_my_speci` WHERE `id_user` = '".($ku['id'])."' AND `id_spec` = '".($rec['s4'])."'"),0);}

if($rec['s5']>0){$rsw5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_my_speci` WHERE `id_user` = '".($ku['id'])."' AND `id_spec` = '".($rec['s5'])."'"),0);}
////speci end
if($rec['p1']>0){if(!isset($err1)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
////buy 2
if($rec['p2']>0){if(!isset($err2)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
////buy3
if($rec['p3']>0){if(!isset($err3)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
////buy4
if($rec['p4']>0){if(!isset($err4)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
////buy5
if($rec['p5']>0){if(!isset($err5)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
///buy6
if($rec['s1']>0){if(!isset($err6)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
///buy7
if($rec['s2']>0){if(!isset($err7)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
///buy8
if($rec['s3']>0){if(!isset($err8)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
///buy9
if($rec['s4']>0){if(!isset($err9)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}
///buy10
if($rec['s5']>0){if(!isset($err1)){$_SESSION['msg']="В амбаре не хватает составляющих для этого рецепта.";$err_z=1;}else{}}

if(!isset($err_z)){
//if($rec['id']==0){
if($rec['p1']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($rpw1['count']-$rec['pc1'])."' WHERE `id` = '".($rpw1['id'])."'");}
////buy 2
if($rec['p2']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($rpw2['count']-$rec['pc2'])."' WHERE `id` = '".($rpw2['id'])."'");}
////buy3
if($rec['p3']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($rpw3['count']-$rec['pc3'])."' WHERE `id` = '".($rpw3['id'])."'");}
////buy
if($rec['p4']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($rpw4['count']-$rec['pc4'])."' WHERE `id` = '".($rpw4['id'])."'");}
////buy5
if($rec['p5']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($rpw5['count']-$rec['pc5'])."' WHERE `id` = '".($rpw5['id'])."'");}
///buy6
if($rec['s1']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($rsw1['count']-$rec['sc1'])."' WHERE `id` = '".($rsw1['id'])."'");}
///buy7
if($rec['s2']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($rsw2['count']-$rec['sc2'])."' WHERE `id` = '".($rsw2['id'])."'");}
///buy8
if($rec['s3']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($rsw3['count']-$rec['sc3'])."' WHERE `id` = '".($rsw3['id'])."'");}
///buy9
if($rec['s4']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($rsw4['count']-$rec['sc4'])."' WHERE `id` = '".($rsw4['id'])."'");}
///buy10
if($rec['s5']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($rsw5['count']-$rec['sc5'])."' WHERE `id` = '".($rsw5['id'])."'");}
$skoro=0;
$puper=$ku['cooker']*3;
if($ku['cooker']>0)$skoro=$rec['time']/100*$puper;
$left=$rec['time']-$skoro;
mysql_query("UPDATE `farm_sellar` SET `id_rec` = '".($rec['id'])."',`time` = '".($left+$time)."' WHERE `id` = '".($polka['id'])."' LIMIT 1");
}
header("Location:/mysellar");exit;}
?>