Файл: vfermu.ru/sys/sellar/seat_buy_ingridient.php
Строк: 144
<?
$coll = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_sellar` WHERE `id_user` = '$ku[id]'"),0);
$count1 = "".($tmp['p1']>0?"".($pw1['count']/$tmp['pc1'])."":"10000")."";
$count2 = "".($tmp['p2']>0?"".($pw2['count']/$tmp['pc2'])."":"10000")."";
$count3 = "".($tmp['p3']>0?"".($pw3['count']/$tmp['pc3'])."":"10000")."";
$count4 = "".($tmp['p4']>0?"".($pw4['count']/$tmp['pc4'])."":"10000")."";
$count5 = "".($tmp['p5']>0?"".($pw5['count']/$tmp['pc5'])."":"10000")."";
$count6 = "".($tmp['s1']>0?"".($sw1['count']/$tmp['sc1'])."":"10000")."";
$count7 = "".($tmp['s2']>0?"".($sw2['count']/$tmp['sc2'])."":"10000")."";
$count8 = "".($tmp['s3']>0?"".($sw3['count']/$tmp['sc3'])."":"10000")."";
$count9 = "".($tmp['s4']>0?"".($sw4['count']/$tmp['sc4'])."":"10000")."";
$count10 = "".($tmp['s5']>0?"".($sw5['count']/$tmp['sc5'])."":"10000")."";
$coun = floor(min($count1,$count2,$count3,$count4,$count5,$count6,$count7,$count8,$count9,$count10));
///start cena
///start cena
$cena1 = "".($tmp['p1']>0?"".($p1_name['cena']*$tmp['pc1'])."":"0")."";
$cena2 = "".($tmp['p2']>0?"".($p2_name['cena']*$tmp['pc2'])."":"0")."";
$cena3 = "".($tmp['p3']>0?"".($p3_name['cena']*$tmp['pc3'])."":"0")."";
$cena4 = "".($tmp['p4']>0?"".($p4_name['cena']*$tmp['pc4'])."":"0")."";
$cena5 = "".($tmp['p5']>0?"".($p5_name['cena']*$tmp['pc5'])."":"0")."";
$cena6 = "".($tmp['s1']>0?"".(($s1_name['money']/100)*$tmp['sc1'])."":"0")."";
$cena7 = "".($tmp['s2']>0?"".(($s2_name['money']/100)*$tmp['sc2'])."":"0")."";
$cena8 = "".($tmp['s3']>0?"".(($s3_name['money']/100)*$tmp['sc3'])."":"0")."";
$cena9 = "".($tmp['s4']>0?"".(($s4_name['money']/100)*$tmp['sc4'])."":"0")."";
$cena10 = "".($tmp['s5']>0?"".(($s5_name['money']/100)*$tmp['sc5'])."":"0")."";
$obc = $cena1+$cena2+$cena3+$cena4+$cena5+$cena6+$cena7+$cena8+$cena9+$cena10;
$cen1 = "".($tmp['s1']>0?"".(($s1_name['rubies']/100)*$tmp['sc1'])."":"0")."";
$cen2 = "".($tmp['s2']>0?"".(($s2_name['rubies']/100)*$tmp['sc2'])."":"0")."";
$cen3 = "".($tmp['s3']>0?"".(($s3_name['rubies']/100)*$tmp['sc3'])."":"0")."";
$cen4 = "".($tmp['s4']>0?"".(($s4_name['rubies']/100)*$tmp['sc4'])."":"0")."";
$cen5 = "".($tmp['s5']>0?"".(($s5_name['rubies']/100)*$tmp['sc5'])."":"0")."";
$obc2 = $cen1+$cen2+$cen3+$cen4+$cen5;
////end cena
if($obc<=$ku['money']){
if($obc2<=$ku['rubies']){
if($coun<$coll){
////buy1
if($tmp['p1']>0){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_warehouse` WHERE `id_user` = '$ku[id]' AND `id_plant` = '".($tmp['p1'])."'"),0)!=0){
mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw1['count']+$tmp['pc1'])."' WHERE `id` = '".($pw1['id'])."'");}else{mysql_query("INSERT INTO `farm_warehouse` SET `id_plant` = '".($tmp['p1'])."', `id_user` = '$ku[id]', `count` = '".($tmp['pc1'])."'");}}
////buy 2
if($tmp['p2']>0){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_warehouse` WHERE `id_user` = '$ku[id]' AND `id_plant` = '".($tmp['p2'])."'"),0)!=0){
mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw2['count']+$tmp['pc2'])."' WHERE `id` = '".($pw2['id'])."'");}else{mysql_query("INSERT INTO `farm_warehouse` SET `id_plant` = '".($tmp['p2'])."', `id_user` = '$ku[id]', `count` = '".($tmp['pc2'])."'");}}
////buy3
if($tmp['p3']>0){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_warehouse` WHERE `id_user` = '$ku[id]' AND `id_plant` = '".($tmp['p3'])."'"),0)!=0){
mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw3['count']+$tmp['pc3'])."' WHERE `id` = '".($pw3['id'])."'");
}else{mysql_query("INSERT INTO `farm_warehouse` SET `id_plant` = '".($tmp['p3'])."', `id_user` = '$ku[id]', `count` = '".($tmp['pc3'])."'");}}
////buy4
if($tmp['p4']>0){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_warehouse` WHERE `id_user` = '$ku[id]' AND `id_plant` = '".($tmp['p4'])."'"),0)!=0){
mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw4['count']+$tmp['pc4'])."' WHERE `id` = '".($pw4['id'])."'");
}else{mysql_query("INSERT INTO `farm_warehouse` SET `id_plant` = '".($tmp['p4'])."', `id_user` = '$ku[id]', `count` = '".($tmp['pc4'])."'");}}
////buy5
if($tmp['p5']>0){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_warehouse` WHERE `id_user` = '$ku[id]' AND `id_plant` = '".($tmp['p5'])."'"),0)!=0){
mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw5['count']+$tmp['pc5'])."' WHERE `id` = '".($pw5['id'])."'");
}else{mysql_query("INSERT INTO `farm_warehouse` SET `id_plant` = '".($tmp['p5'])."', `id_user` = '$ku[id]', `count` = '".($tmp['pc5'])."'");}}
///buy6
if($tmp['s1']>0){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_my_speci` WHERE `id_user` = '".($ku['id'])."' AND `id_spec` = '".($tmp['s1'])."'"),0)!=0){
mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw1['count']+$tmp['sc1'])."' WHERE `id` = '".($sw1['id'])."'");
}else{mysql_query("INSERT INTO `farm_my_speci` SET `id_spec` = '".($tmp['s1'])."', `id_user` = '".($ku['id'])."', `count` = '".($tmp['sc1'])."'");}}
///buy7
if($tmp['s2']>0){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_my_speci` WHERE `id_user` = '$ku[id]' AND `id_spec` = '".($tmp['s2'])."'"),0)!=0){
mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw2['count']+$tmp['sc2'])."' WHERE `id` = '".($sw2['id'])."'");
}else{mysql_query("INSERT INTO `farm_my_speci` SET `id_spec` = '".($tmp['s2'])."', `id_user` = '$ku[id]', `count` = '".($tmp['sc2'])."'");}}
///buy8
if($tmp['s3']>0){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_my_speci` WHERE `id_user` = '$ku[id]' AND `id_spec` = '".($tmp['s3'])."'"),0)!=0){
mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw3['count']+$tmp['sc3'])."' WHERE `id` = '".($sw3['id'])."'");
}else{mysql_query("INSERT INTO `farm_my_speci` SET `id_spec` = '".($tmp['s3'])."', `id_user` = '$ku[id]', `count` = '".($tmp['sc3'])."'");}}
///buy9
if($tmp['s4']>0){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_my_speci` WHERE `id_user` = '$ku[id]' AND `id_spec` = '".($tmp['s4'])."'"),0)!=0){
mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw4['count']+$tmp['sc4'])."' WHERE `id` = '".($sw4['id'])."'");
}else{mysql_query("INSERT INTO `farm_my_speci` SET `id_spec` = '".($tmp['s4'])."', `id_user` = '$ku[id]', `count` = '".($tmp['sc4'])."'");}}
///buy10
if($tmp['s5']>0){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_my_speci` WHERE `id_user` = '$ku[id]' AND `id_spec` = '".($tmp['s5'])."'"),0)!=0){
mysql_query("UPDATE `farm_my_speci` SET `count` = '".($sw5['count']+$tmp['sc5'])."' WHERE `id` = '".($sw5['id'])."'");
}else{mysql_query("INSERT INTO `farm_my_speci` SET `id_spec` = '".($tmp['s5'])."', `id_user` = '$ku[id]', `count` = '".($tmp['sc5'])."'");}}
$ku['money']=minus_money($obc);
$ku['rubies']=minus_rubies($obc2);
header("Location:/?mysellar&seat=".($polka['id'])."");exit;
}
}else no_rubies($obc2-$ku['rubies']);
}else no_money($obc-$ku['money']);//end buy
?>