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


<?
$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]'"));

$colls = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar` WHERE `id_user` = '$ku[id]' AND `id_rec` = '0'"),0);
$count1 = "".($tmp['p1']>0?"".($pw1['count']/$tmp['pc1'])."":"1000000")."";
$count2 = "".($tmp['p2']>0?"".($pw2['count']/$tmp['pc2'])."":"1000000")."";
$count3 = "".($tmp['p3']>0?"".($pw3['count']/$tmp['pc3'])."":"1000000")."";
$count4 = "".($tmp['p4']>0?"".($pw4['count']/$tmp['pc4'])."":"1000000")."";
$count5 = "".($tmp['p5']>0?"".($pw5['count']/$tmp['pc5'])."":"1000000")."";
$count6 = "".($tmp['s1']>0?"".($sw1['count']/$tmp['sc1'])."":"1000000")."";
$count7 = "".($tmp['s2']>0?"".($sw2['count']/$tmp['sc2'])."":"1000000")."";
$count8 = "".($tmp['s3']>0?"".($sw3['count']/$tmp['sc3'])."":"1000000")."";
$count9 = "".($tmp['s4']>0?"".($sw4['count']/$tmp['sc4'])."":"1000000")."";
$count10 = "".($tmp['s5']>0?"".($sw5['count']/$tmp['sc5'])."":"1000000")."";
$cols = min($count1,$count2,$count3,$count4,$count5,$count6,$count7,$count8,$count9,$count10);
if($cols>$colls){$coll = $colls;}else{$coll=$cols;}


if($tmp['p1']>0){if($pw1['count']>=$tmp['pc1']*$coll){$err1=1;}}
if($tmp['p2']>0){if($pw2['count']>=$tmp['pc2']*$coll){$err2=1;}}
if($tmp['p3']>0){if($pw3['count']>=$tmp['pc3']*$coll){$err3=1;}}
if($tmp['p4']>0){if($pw4['count']>=$tmp['pc4']*$coll){$err4=1;}}
if($tmp['p5']>0){if($pw5['count']>=$tmp['pc5']*$coll){$err5=1;}}
if($tmp['s1']>0){if($sw1['count']>=$tmp['sc1']*$coll){$err6=1;}}
if($tmp['s2']>0){if($sw2['count']>=$tmp['sc2']*$coll){$err7=1;}}
if($tmp['s3']>0){if($sw3['count']>=$tmp['sc3']*$coll){$err8=1;}}
if($tmp['s4']>0){if($sw4['count']>=$tmp['sc4']*$coll){$err9=1;}}
if($tmp['s5']>0){if($sw5['count']>=$tmp['sc5']*$coll){$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)){
$pl1=$tmp['pc1'];
$pl2=$tmp['pc2'];
$pl3=0;
$pl4=0;
$pl5=0;
$sl1=0;
$sl2=0;
$sl3=0;
$sl4=0;
$sl5=0;
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];}
$q=mysql_query("SELECT * FROM `farm_sellar` WHERE `id_user` = '$ku[id]' AND `id_rec` = '0' LIMIT $coll");
while($post=mysql_fetch_array($q)){
$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` = '".($post['id'])."' LIMIT 1");

if($tmp['p1']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw1['count']-$tmp['pc1']*$coll)."' WHERE `id` = '".($pw1['id'])."'LIMIT 1");}

if($tmp['p2']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw2['count']-$tmp['pc2']*$coll)."' WHERE `id` = '".($pw2['id'])."' LIMIT 1");}

if($tmp['p3']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw3['count']-$tmp['pc3']*$coll)."' WHERE `id` = '".($pw3['id'])."' LIMIT 1");}

if($tmp['p4']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw4['count']-$tmp['pc4']*$coll)."' WHERE `id` = '".($pw4['id'])."' LIMIT 1");}

if($tmp['p5']>0){mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw5['count']-$tmp['pc5']*$coll)."' WHERE `id` = '".($pw5['id'])."' LIMIT 1");}

if($tmp['s1']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw1['count']-$tmp['sc1']*$coll)."' WHERE `id` = '".($sw1['id'])."' LIMIT 1");}

if($tmp['s2']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw2['count']-$tmp['sc2']*$coll)."' WHERE `id` = '".($sw2['id'])."' LIMIT 1");}

if($tmp['s3']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw3['count']-$tmp['sc3']*$coll)."' WHERE `id` = '".($sw3['id'])."' LIMIT 1");}

if($tmp['s4']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw4['count']-$tmp['sc4']*$coll)."' WHERE `id` = '".($sw4['id'])."' LIMIT 1");}

if($tmp['s5']>0){mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw5['count']-$tmp['sc5']*$coll)."' WHERE `id` = '".($sw5['id'])."' LIMIT 1");}
}



mysql_query("UPDATE `farm_user` SET `last_recept` = '".($id)."' WHERE `id` = '$ku[id]' LIMIT 1");}


header("Location:/?mysellar");exit;

?>