Файл: vfermu.ru/sess_cron_ua/sadovnik_cron.php
Строк: 408
<?php
$t=microtime(1);
$time=time();
require_once '../sys/db/conect.php';
$user_select=mysql_query("SELECT `id` FROM `farm_user` WHERE `garden_time` > '$time' ");
WHILE($ku=mysql_fetch_array($user_select)){
$ku=mysql_fetch_array(mysql_query("SELECT * FROM `farm_user` WHERE `id` = '$ku[id]'"));
echo "$ku[id] d";
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND (`id_plant` = '0' OR `time_water` = '$time' OR `time` = '$time' OR `time_water` < '$time' OR `time` < '$time' OR (`time_soil` = '$time' AND `soil` = '0') OR (`time_soil` < '$time' AND `soil` = '0'))"),0)>0
){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_user` WHERE `id_user` = '$ku[id]'"),0)!=0)
{
$mcu=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_user` WHERE `id_user` = '$ku[id]'"));
$mc=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective` WHERE `id` = '$mcu[id_collective]'"));
$mc['users']=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_user` WHERE `id_collective` = '$mc[id]'"),0);
}
require_once'../sys/fnc/fnc.php';
//require_once'/var/www/test/data/www/vferme.com/sys/start.php';
include '../sys/fnc/teh.php';
if($ku['expdouble']==date("D"))$dexp=1;
$gos=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_gos` WHERE `active` = '1' ORDER BY `time` DESC LIMIT 1"));
if($ku['gardener']==1)$water=1;$name='Молчан';$harvest=0;$cultivate=0;$seat=0;$soil=0;
if($ku['gardener']==2){$water=1;$name='Казимир';
$harvest=1;
$cultivate=1;
$seat=1;
$soil=0;}
if($ku['gardener']==3){$water=1;$name='Ярило';
$harvest=1;
$cultivate=1;
$seat=1;
$soil=1;
$vert=1;
}
if($water==1 AND mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND `id_plant` != '0' AND (`time_water` = '$time' OR `time_water` < '$time') AND `time` > '$time' AND (`soil` = '0' AND `time_soil` > '$time' OR `soil` = '1')LIMIT 1"),0)!=0){
$nt=1800;
$rat=ir($ku['level']);
$rat_hp_act=0; //гидра
$rat_mc_hp_act=0; //ороситель
$rat_sc_act=0; //пугало
$rat_dog_act=0;
$rat_drakon_act=0; //дракон
$rat_irregate_act=0; //оПроситель
$rat_school_act=0; //школа
$rat_lib_act=0;
$arena_rat=0; //арена
if(isset($hp_act))$rat_hp_act=(($rat/100)*$hp_ps);
if(isset($mc_hp_act))$rat_mc_hp_act=(($rat/100)*$mc_hp_ps);
if(isset($sc_act))$rat_sc_act=$rat*2;
if(isset($dog_type))$rat_dog_act=(($rat/100)*$dog_type);
if(isset($irregate_act))$rat_irregate_act=(($rat/100)*$irregate_act);
if(isset($drakon_act))$rat_drakon_act=(($rat/100)*300);
$collection=(($rat/100)*$daysa);
$liga=(($rat/100)*$vidsotok);
$doma_cnf_vidsotok=(($rat/100)*$cnf_bonus_doma);
$tuk=(($rat/100)*$tut);
if($ku['blatnoy_time']>$time)
{
$blat=(($rat/100)*120);
}
if(isset($school_act))$rat_school_act=$rat*2;
if(isset($lib_act))$rat_lib_act=$rat/2;
if(isset($shmel_act))$rat_irregate_act=$rat_irregate_act*2;
if(isset($shmel_act))$rat_hp_act=$rat_hp_act*2;
if($ku['arena_rating']>1000)$arena_rat=floor(($rat/100)*(($ku['arena_rating']-1000)/20));
$ratt=$rat+$rat_hp_act+$rat_sc_act+$rat_drakon_act+$rat_irregate_act+$rat_mc_hp_act+$rat_school_act+$rat_lib_act+$rat_dog_act+$arena_rat;
if($ratt==0)$rat=$rat;
else $rat=$ratt;
if(isset($dexp) AND !isset($dexp3))$rat=$rat*2; elseif(isset($dexp3))$rat=$rat*3;
$ntt=15*60;
$ntt_hp_act=0;
$ntt_mc_hp_act=0;
if(isset($hp_act))$ntt_hp_act=(($ntt/100)*$hp_ps);
if(isset($mc_hp_act))$ntt_mc_hp_act=(($ntt/100)*$mc_hp_ps);
$ntt=$ntt_hp_act+$ntt_mc_hp_act;
if(isset($irregate_act))
{
$nt=$nt-(round($irregate_act_mnp*60));
$ntt=$ntt+($irregate_act_m*60);
}
$orat=0;
$q=mysql_query("SELECT * FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND `id_plant` != '0' AND (`time_water` = '".time()."' OR `time_water` < '".time()."') AND `time` > '".time()."' AND (`soil` = '0' AND `time_soil` > '".time()."' OR `soil` = '1')");
$vc=0;
while($post=mysql_fetch_array($q))
{
$vc=$vc+1;
mysql_query("UPDATE `farm_ground` SET `time_water` = '".(time()+$nt)."', `time` = '".($post['time']-$ntt)."' WHERE `id` = '$post[id]' LIMIT 1");
$orat=$rat+$orat;
}
$ku['rating']=$ku['rating']+$orat;
mysql_query("UPDATE `farm_user` SET `rating` = '$ku[rating]' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_user` SET `vodoley` = '".($ku['vodoley']+$vc)."' WHERE `id` = '$ku[id]'");
update_mc($orat);
}
if($soil==1 AND mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND `soil` = '0' AND (`time_soil` = '$time' OR `time_soil` < '$time') AND `id_plant` != '0' AND `time` > '$time' LIMIT 1"),0)!=0){
if($ku['last_soil']!=0)
{
$soil=mysql_fetch_array(mysql_query("SELECT * FROM `farm_soil` WHERE `id` = '$ku[last_soil]'"));
$cg=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND `soil` = '0' AND (`time_soil` = '$time' OR `time_soil` < '$time') AND `id_plant` != '0' AND `time` > '$time'"),0);
$sc=$cg*$soil['cena'];
if($ku['money']>=$sc)
{
$rat=$soil['rating'];
$rat_sc_act=0;
$rat_dog_act=0;
$rat_hp_act=0;
$rat_mc_hp_act=0;
$rat_drakon_act=0;
$rat_soiler_act=0;
$rat_school_act=0;
$rat_lib_act=0;
$arena_rat=0;
if(isset($hp_act))$rat_hp_act=(($rat/100)*$hp_ps);
if(isset($mc_hp_act))$rat_mc_hp_act=(($rat/100)*$mc_hp_ps);
if(isset($sc_act))$rat_sc_act=$rat*2;
if(isset($dog_type))$rat_dog_act=(($rat/100)*$dog_type);
if(isset($drakon_act))$rat_drakon_act=(($rat/100)*300);
$collection=(($rat/100)*$daysa);
$liga=(($rat/100)*$vidsotok);
$doma_cnf_vidsotok=(($rat/100)*$cnf_bonus_doma);
$tuk=(($rat/100)*$tut);
if($ku['blatnoy_time']>$time)
{
$blat=(($rat/100)*120);
}
if(isset($soiler_act))$rat_soiler_act=(($rat/100)*$soiler_act);
if(isset($school_act))$rat_school_act=$rat*2;
if(isset($lib_act))$rat_lib_act=$rat/2;
if(isset($shmel_act))$rat_soiler_act=$rat_soiler_act*2;
if(isset($shmel_act))$rat_hp_act=$rat_hp_act*2;
if($ku['arena_rating']>1000){$arena_rat=floor(($rat/100)*(($ku['arena_rating']-1000)/20));}
$ratt=$rat_mc_hp_act+$rat_sc_act+$rat_hp_act+$rat_drakon_act+$rat_soiler_act+$rat_school_act+$rat_lib_act+$rat_dog_act+$arena_rat;
if($ratt==0)$rat=$rat;
else $rat=$ratt;
if(isset($dexp) AND !isset($dexp3))$rat=$rat*2; elseif(isset($dexp3))$rat=$rat*3;
$st=$soil['time'];
$st_hp_act=0;
$st_mc_hp_act=0;
$st_soiler_act=0;
if(isset($hp_act))$st_hp_act=($st/100)*$hp_ps;
if(isset($mc_hp_act))$st_mc_hp_act=($st/100)*$mc_hp_ps;
if($soiler_act)$st_soiler_act=($st/100)*$soiler_act;
$st=$st_hp_act+$st_soiler_act+$st+$st_mc_hp_act;
$q=mysql_query("SELECT * FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND `soil` = '0' AND (`time_soil` = '$time' OR `time_soil` < '$time') AND `id_plant` != '0' AND `time` > '$time'");
$orat=0;
$vc=0;
while($post=mysql_fetch_array($q))
{
$orat=$orat+$rat;
mysql_query("UPDATE `farm_ground` SET `time` = '".($post['time']-$st)."', `soil` = '1' WHERE `id` = '$post[id]' LIMIT 1");
$vc=$vc+1;
}
$ku['rating'] = $ku['rating']+$orat;
mysql_query("UPDATE `farm_user` SET `agronom` = '".($ku['agronom']+$vc)."',`money` = '".($ku['money']-$sc)."',`rating` = '$ku[rating]' WHERE `id` = '$ku[id]'");
update_mc($orat);
}
}
}
if($harvest==1 AND mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND (`time` < '$time' OR `time` = '$time') AND `id_plant` != '0' LIMIT 1"),0)!=0){
$q=mysql_query("SELECT * FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND (`time` < '$time' OR `time` = '$time') AND `id_plant` != '0'");
$ohv=0;
$expa=0;
while($post=mysql_fetch_array($q))
{
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '$post[id_plant]'"));
if($plant['id']==$gos['id_plant'] && $mc)
{
$harv=(isset($harvester_act)?$harvester_act/100:0);
$hawk=(isset($yastreb_act)?3:0);
$exp=$plant['time_soil']+($plant['time_soil']*$harv)+($plant['time_soil']*$hawk);
if($gos['type']=='harvest')$exp=$exp*2;
$expa=$expa+$exp;
}
$count=$plant['count'];
$count_harvester_act=0;
$count_yastreb_act=0;
$count_greenhouse_act=0;
if(isset($harvester_act))$count_harvester_act=floor(($count/100)*$harvester_act);
if(isset($yastreb_act))$count_yastreb_act=(($count/100)*300);
if(isset($greenhouse_act))$count_greenhouse_act=(($count/100)*$greenhouse_ps);
$count=$count_harvester_act+$count_yastreb_act+$count+$count_greenhouse_act;
$count=floor($count);
if($pw=mysql_fetch_array(mysql_query("SELECT * FROM `farm_warehouse` WHERE `id_user` = '$ku[id]' AND `id_plant` = '$plant[id]' AND `arena` = '0'")))
{
mysql_query("UPDATE `farm_warehouse` SET `count` = '".($pw['count']+$count)."' WHERE `id` = '$pw[id]'");
}
else mysql_query("INSERT INTO `farm_warehouse` SET `id_plant` = '$plant[id]', `id_user` = '$ku[id]', `count` = '$count', `arena` = '0'");
$ohv=$ohv+$count;
$lab=mysql_fetch_array(mysql_query("SELECT * FROM `farm_lab_collective_vivod` WHERE `id_collective` = '$mc[id]'"));
$oder=$lab['sobrano_plant']/$plant['time']*2;
if($oder<100)
{
if($mc['id']==$lab['id_collective'])
{
if($plant['id']==$lab['id_plant'])
{
mysql_query("UPDATE `farm_lab_collective_vivod` SET `sobrano_plant` = '".($lab['sobrano_plant']+$count)."' WHERE `id_collective` = '$mc[id]'");
}
}
}
}
if($expa>0){
mysql_query("UPDATE `farm_collective` SET `rating_gos` = '$mc[rating_gos]'+'$expa' WHERE `id`='$mc[id]'");
mysql_query("UPDATE `farm_collective_user` SET `rating_gos` = '$mcu[rating_gos]'+'$expa' WHERE `id_user`='$ku[id]'");
}
mysql_query("UPDATE `farm_ground` SET `id_plant` = '0', `soil` = '0', `cultivator` = '0' WHERE `id_user` = '$ku[id]' AND (`time` < '$time' OR `time` = '$time') AND `id_plant` != '0'");
mysql_query("INSERT INTO `farm_joirnal` SET `gardener` = '$ku[gardener]', `id_user` = '$ku[id]', `time` = '$time', `count` = '$ohv'");
mysql_query("UPDATE `farm_user` SET `sadovod` = '".($ku['sadovod']+$ohv)."' WHERE `id` = '$ku[id]'");
$ohv = 0;
}
if($cultivate==1 AND mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND `id_plant` = '0' AND (`time` = '$time' OR `time` < '$time') AND `cultivator` = '0' LIMIT 1"),0)!=0){
$level = $ku['level'];
if($level>=0 && $level<=10)$rat = 2;
else if($level>=11 && $level<=20)$rat = 5;
else if($level>=21 && $level<=30)$rat = 15;
else if($level>=31 && $level<=40)$rat = 40;
else if($level>=41 && $level<=50)$rat = 100;
else if($level>=51 && $level<=60)$rat = 500;
else if($level>=61)$rat = 1000;
unset($level);
$rat_drakon_act=0;
$rat_sc_act=0;
$rat_dog_act=0;
$rat_lib_act=0;
if(!isset($cultivator_act))$cultivator_act=0;
if(isset($sc_act))$rat_sc_act=$rat*2;
if(isset($dog_type))$rat_dog_act=(($rat/100)*$dog_type);
$rat_cultivator_act=(($rat/100)*$cultivator_act);
if(isset($drakon_act))$rat_drakon_act=((2/100)*300);
if(isset($lib_act))$rat_lib_act=$rat/2;
if(isset($shmel_act))$rat_cultivator_act=$rat_cultivator_act*2;
$ratt=$rat_drakon_act+$rat_sc_act+$rat_cultivator_act+$rat_lib_act+$rat_dog_act;
if($ratt==0)$rat=$rat;
else $rat=$ratt;
if(isset($dexp) AND !isset($dexp3))$rat=$rat*2; elseif(isset($dexp3))$rat=$rat*3;
$orat=0;
$q=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND `id_plant` = '0' AND (`time` = '$time' OR `time` < '$time') AND `cultivator` = '0'"),0);
$orat=$rat*$q;
$ku['rating'] = $ku['rating']+$orat;
mysql_query("UPDATE `farm_user` SET `rating` = '$ku[rating]' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_ground` SET `cultivator` = '1' WHERE `id_user` = '$ku[id]' AND `id_plant` = '0' AND (`time` = '$time' OR `time` < '$time') AND `cultivator` = '0'");
update_mc($orat);
}
if($seat==1 AND mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND `id_plant` = '0' AND `cultivator` = '1' LIMIT 1"),0)!=0 AND $ku['last_plant']!=0){
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `farm_plant` WHERE `id` = '$ku[last_plant]'"));
$cg=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND `id_plant` = '0' AND `cultivator` = '1'"),0);
$mon=($plant['cena']/100)*$seeder_act_skid;
$money=floor($plant['cena']-$mon);
$sc=$money*$cg;
$rat=$plant['rating'];
$rat_sc_act=0;
$rat_dog_act=0;
$rat_drakon_act=0;
$rat_seeder_act=0;
$rat_cultivator_seat_soil=0;
$rat_school_act=0;
$arena_rat=0;
if(isset($sc_act))$rat_sc_act=$rat*2;
if(isset($dog_type))$rat_dog_act=(($rat/100)*$dog_type);
if(isset($drakon_act))$rat_drakon_act=(($plant['rating']/100)*300);
if(isset($seeder_act))$rat_seeder_act=(($rat/100)*$seeder_act);
if(isset($school_act))$rat_school_act=$rat/2;
if(isset($shmel_act))$rat_seeder_act=$rat_seeder_act*2;
if(isset($cultivator_seat_soil))$rat_cultivator_seat_soil=(($rat/100)*$cultivator_seat_soil);
if($ku['arena_rating']>1000){$arena_rat=floor(($rat/100)*(($ku['arena_rating']-1000)/20));}
$ratt=$rat+$rat_drakon_act+$rat_sc_act+$rat_seeder_act+$rat_school_act+$rat_cultivator_seat_soil+$rat_dog_act+$arena_rat;
if($ratt==0)$rat=$rat;
else $rat=$ratt;
if(isset($dexp) AND !isset($dexp3))$rat=$rat*2; elseif(isset($dexp3))$rat=$rat*3;
if($gos['id_plant']==$plant['id'] && $gos['type']=='rating' && isset($mc))$rat=$rat*2;
if($ku['money']>=$sc)
{
$q=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_ground` WHERE `id_user` = '$ku[id]' AND `id_plant` = '0' AND `cultivator` = '1'"),0);
$orat=$rat*$q;
mysql_query("UPDATE `farm_ground` SET `id_plant` = '$plant[id]', `time_soil` = '".(time()+$plant['time_soil'])."', `time_water` = '".(time()+120)."', `soil` = '0', `time` = '".($plant['time']+time())."' WHERE `id_user` = '$ku[id]' AND `id_plant` = '0' AND `cultivator` = '1'");
mysql_query("UPDATE `farm_user` SET `money` = '".($ku['money']-$sc)."',`rating` = '".($ku['rating']+$orat)."' WHERE `id` = '$ku[id]'");
update_mc($orat);
}
}
/////////////////////////////////////////////////////ВЕРТЫ////////////////////
if($vert==2){
$smelhel=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_heli` WHERE `id_collective` = '$mc[id]' AND `heli` = '1' AND `gaz` >= '10'"));
$arendsmel=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_ahlist` WHERE `id_user` = '$ku[id]' AND `heli` = '1'"));
if($smelhel['id'] AND (!$arendsmel || $arendsmel['time']<$time) AND $ku['time_shmel']<$time)
{//Вызов шмеля
$heli=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_heli` WHERE `id_collective` = '$mc[id]' AND `heli` != '0' AND `id` = '$smelhel[id]'"));
$type=7;$gaz=10;
$arend=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_ahlist` WHERE `id_user` = '$ku[id]' AND `heli` = '1'"));
$count_tt=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_heli` WHERE `id_collective` = '$mc[id]' AND `heli` = '1'"),0);
$tl=round($mc['users']/($type*$count_tt),2);
$t2=0;
if($tl2=explode('.',$tl))
{
if(!isset($tl2[1]))$tl2[1]='0';
if(strlen2($tl2[1])<2)$tl2[1]=$tl2[1]."0";
$t1=$tl2[0];
$tl2=$tl2[1];
$dil=100/60;
$t2=floor($tl2/$dil);
}
$nt=$time+($t1*3600)+($t2*60);
if(!$arend)mysql_query("INSERT INTO `farm_collective_ahlist` SET `id_user` = '$ku[id]', `heli` = '1', `time` = '$nt'");
else mysql_query("UPDATE `farm_collective_ahlist` SET `time` = '$nt' WHERE `id` = '$arend[id]'");
$timee=3600;
mysql_query("UPDATE `farm_user` SET `time_shmel` = '".($ku["time_shmel"]>$time?"".($ku["time_shmel"]+$timee)."":"".($time+$timee)."")."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_collective_heli` SET `gaz` = '".($heli['gaz']-$gaz)."' WHERE `id` = '$heli[id]'");
}
$smelhel=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_heli` WHERE `id_collective` = '$mc[id]' AND `heli` = '2' AND `gaz` >= '10'"));
$arendsmel=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_ahlist` WHERE `id_user` = '$ku[id]' AND `heli` = '2'"));
if($smelhel['id'] AND (!$arendsmel || $arendsmel['time']<$time) AND $ku['time_yastreb']<$time)
{//Вызов ястреба
$heli=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_heli` WHERE `id_collective` = '$mc[id]' AND `heli` != '0' AND `id` = '$smelhel[id]'"));
$type=7;$gaz=10;
$arend=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_ahlist` WHERE `id_user` = '$ku[id]' AND `heli` = '2'"));
$count_tt=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_heli` WHERE `id_collective` = '$mc[id]' AND `heli` = '2'"),0);
$tl=round($mc['users']/($type*$count_tt),2);
$t2=0;
if($tl2=explode('.',$tl))
{
if(!isset($tl2[1]))$tl2[1]='0';
if(strlen2($tl2[1])<2)$tl2[1]=$tl2[1]."0";
$t1=$tl2[0];
$tl2=$tl2[1];
$dil=100/60;
$t2=floor($tl2/$dil);
}
$nt=$time+($t1*3600)+($t2*60);
if(!$arend)mysql_query("INSERT INTO `farm_collective_ahlist` SET `id_user` = '$ku[id]', `heli` = '2', `time` = '$nt'");
else mysql_query("UPDATE `farm_collective_ahlist` SET `time` = '$nt' WHERE `id` = '$arend[id]'");
$timee=3600;
mysql_query("UPDATE `farm_user` SET `time_yastreb` = '".($ku["time_yastreb"]>$time?"".($ku["time_yastreb"]+$timee)."":"".($time+$timee)."")."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_collective_heli` SET `gaz` = '".($heli['gaz']-$gaz)."' WHERE `id` = '$heli[id]'");
}
$smelhel=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_heli` WHERE `id_collective` = '$mc[id]' AND `heli` = '3' AND `gaz` >= '10'"));
$arendsmel=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_ahlist` WHERE `id_user` = '$ku[id]' AND `heli` = '3'"));
if($smelhel['id'] AND (!$arendsmel || $arendsmel['time']<$time) AND $ku['time_drakon']<$time)
{//Вызов дракона
$heli=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_heli` WHERE `id_collective` = '$mc[id]' AND `heli` != '0' AND `id` = '$smelhel[id]'"));
$type=7;$gaz=10;
$arend=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_ahlist` WHERE `id_user` = '$ku[id]' AND `heli` = '3'"));
$count_tt=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_heli` WHERE `id_collective` = '$mc[id]' AND `heli` = '3'"),0);
$tl=round($mc['users']/($type*$count_tt),2);
$t2=0;
if($tl2=explode('.',$tl))
{
if(!isset($tl2[1]))$tl2[1]='0';
if(strlen2($tl2[1])<2)$tl2[1]=$tl2[1]."0";
$t1=$tl2[0];
$tl2=$tl2[1];
$dil=100/60;
$t2=floor($tl2/$dil);
}
$nt=$time+($t1*3600)+($t2*60);
if(!$arend)mysql_query("INSERT INTO `farm_collective_ahlist` SET `id_user` = '$ku[id]', `heli` = '3', `time` = '$nt'");
else mysql_query("UPDATE `farm_collective_ahlist` SET `time` = '$nt' WHERE `id` = '$arend[id]'");
$timee=3600;
mysql_query("UPDATE `farm_user` SET `time_drakon` = '".($ku["time_drakon"]>$time?"".($ku["time_drakon"]+$timee)."":"".($time+$timee)."")."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_collective_heli` SET `gaz` = '".($heli['gaz']-$gaz)."' WHERE `id` = '$heli[id]'");
}
$smelhel=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_heli` WHERE `id_collective` = '$mc[id]' AND `heli` = '4' AND `gaz` >= '25'"));
$arendsmel=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_ahlist` WHERE `id_user` = '$ku[id]' AND `heli` = '4'"));
if($smelhel['id'] AND (!$arendsmel || $arendsmel['time']<$time) AND ($ku['time_shmel']<$time OR $ku['time_yastreb']<$time OR $ku['time_drakon']<$time))
{//Вызов грома
$heli=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_heli` WHERE `id_collective` = '$mc[id]' AND `heli` != '0' AND `id` = '$smelhel[id]'"));
$type=9;$gaz=25;
$arend=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_ahlist` WHERE `id_user` = '$ku[id]' AND `heli` = '4'"));
$count_tt=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_heli` WHERE `id_collective` = '$mc[id]' AND `heli` = '4'"),0);
$tl=round($mc['users']/($type*$count_tt),2);
$t2=0;
if($tl2=explode('.',$tl))
{
if(!isset($tl2[1]))$tl2[1]='0';
if(strlen2($tl2[1])<2)$tl2[1]=$tl2[1]."0";
$t1=$tl2[0];
$tl2=$tl2[1];
$dil=100/60;
$t2=floor($tl2/$dil);
}
$nt=$time+($t1*3600)+($t2*60);
if(!$arend)mysql_query("INSERT INTO `farm_collective_ahlist` SET `id_user` = '$ku[id]', `heli` = '4', `time` = '$nt'");
else mysql_query("UPDATE `farm_collective_ahlist` SET `time` = '$nt' WHERE `id` = '$arend[id]'");
$timee=3600;
mysql_query("UPDATE `farm_user` SET `time_shmel` = '".($ku["time_shmel"]>$time?"".($ku["time_shmel"]+$timee)."":"".($time+$timee)."")."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_user` SET `time_yastreb` = '".($ku["time_yastreb"]>$time?"".($ku["time_yastreb"]+$timee)."":"".($time+$timee)."")."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_user` SET `time_drakon` = '".($ku["time_drakon"]>$time?"".($ku["time_drakon"]+$timee)."":"".($time+$timee)."")."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_collective_heli` SET `gaz` = '".($heli['gaz']-$gaz)."' WHERE `id` = '$heli[id]'");
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////
}
}
$user_select=mysql_query("SELECT `id` FROM `farm_user` WHERE `trofim_time` > '$time'");
WHILE($ku=mysql_fetch_array($user_select)){
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_pool` WHERE `id_user` = '$ku[id]' AND (`id_fish` = '0' OR `time` = '$time' OR `time` < '$time' OR `time_soil` = '$time' OR `time_soil` < '$time')"),0)>0){
$ku=mysql_fetch_array(mysql_query("SELECT * FROM `farm_user` WHERE `id` = '$ku[id]'"));
$conf = mysql_fetch_array(mysql_query("SELECT * FROM `farm_setting` WHERE `id_user`='$ku[id]'"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_user` WHERE `id_user` = '$ku[id]'"),0)!=0)
{
$mcu=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective_user` WHERE `id_user` = '$ku[id]'"));
$mc=mysql_fetch_array(mysql_query("SELECT * FROM `farm_collective` WHERE `id` = '$mcu[id_collective]'"));
}
if($ku['expdouble']==date("D"))$dexp=1;
////////////////////////////Покормить все////////////
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_pool` WHERE `id_user` = '$ku[id]' AND (`time_soil` = '$time' OR `time_soil` < '$time' ) AND `time`>'$time'"),0)!=0)
{
if($ku['fishfooder']>0)$proc=$ku['fishfooder']*10; else $proc=0;
$q = mysql_query("SELECT * FROM `farm_pool` WHERE `id_user` = '$ku[id]' AND (`time_soil` = '$time' OR `time_soil` < '$time' ) AND `time`>'$time'");
$orat=0;
While($ground=mysql_fetch_array($q))
{
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `farm_pool_plant` WHERE `id` = '".intval($ground['id_fish'])."'"));
$rat=$plant['soil_rating'];
$rat_sc_act=0;
$rat_dog_act=0;
$rat_drakon_act=0;
$rat_school_act=0;
$rat_lib_act=0;
$arena_rat=0;
$rat_fishfooder_act=0;
if(isset($sc_act))$rat_sc_act=$rat*2;
if(isset($dog_type))$rat_dog_act=(($rat/100)*$dog_type);
if(isset($drakon_act))$rat_drakon_act=(($rat/100)*300);
$collection=(($rat/100)*$daysa);
$liga=(($rat/100)*$vidsotok);
$doma_cnf_vidsotok=(($rat/100)*$cnf_bonus_doma);
$tuk=(($rat/100)*$tut);
if($ku['blatnoy_time']>$time)
{
$blat=(($rat/100)*120);
}
if(isset($school_act))$rat_school_act=$rat*2;
if(isset($lib_act))$rat_lib_act=$rat/2;
if($proc>0)$rat_fishfooder_act=($rat/100)*$proc;
if($ku['arena_rating']>1000){$arena_rat=floor(($rat/100)*(($ku['arena_rating']-1000)/20));}
$ratt=$rat+$rat_drakon_act+$rat_school_act+$rat_lib_act+$rat_sc_act+$rat_fishfooder_act+$rat_dog_act+$arena_rat;
if($ratt==0)$rat=$rat;
else $rat=$ratt;
if(isset($dexp) AND !isset($dexp3))$rat=$rat*2; elseif(isset($dexp3))$rat=$rat*3;
$orat = $orat + $rat;
mysql_query("UPDATE `farm_pool` SET `time_soil` = '".($plant['time_soil']*$incubator_timesoil_act+$time)."', `time` = '".($ground['time']-$plant['time_soil_minus'])."' WHERE `id` = '$ground[id]' LIMIT 1")or die (mysql_error());
}
mysql_query("UPDATE `farm_user` SET `rating` = '".($ku['rating']+$orat)."' WHERE `id` = '$ku[id]'");
update_mc($orat);
}
////////////////////////////Продать всё
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_pool` WHERE `id_user` = '$ku[id]' AND `id_fish`>'0' AND (`time` = '$time' OR `time` < '$time' )"),0)!=0)
{
$q = mysql_query("SELECT * FROM `farm_pool` WHERE `id_user` = '$ku[id]' AND `id_fish`>'0' AND (`time` = '$time' OR `time` < '$time' )");
$orat=0;
$odohod=0;
$c_fish=0;
While($ground=mysql_fetch_array($q))
{
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `farm_pool_plant` WHERE `id` = '$ground[id_fish]'"));
if($ku['autocrane']>0)$proc=$ku['autocrane']*10; else $proc=0;
$rat=$plant['rating'];
$rat_sc_act=0;
$rat_dog_act=0;
$rat_drakon_act=0;
$rat_school_act=0;
$rat_lib_act=0;
$arena_rat=0;
$rat_autocrane_act=0;
$rat_trofim_act=$rat/2;
if(isset($sc_act))$rat_sc_act=$rat*2;
if(isset($dog_type))$rat_dog_act=(($rat/100)*$dog_type);
if(isset($drakon_act))$rat_drakon_act=(($rat/100)*300);
$collection=(($rat/100)*$daysa);
$liga=(($rat/100)*$vidsotok);
$doma_cnf_vidsotok=(($rat/100)*$cnf_bonus_doma);
$tuk=(($rat/100)*$tut);
if($ku['blatnoy_time']>$time)
{
$blat=(($rat/100)*120);
}
if(isset($school_act))$rat_school_act=$rat*2;
if(isset($lib_act))$rat_lib_act=$rat/2;
if($ku['arena_rating']>1000){$arena_rat=floor(($rat/100)*(($ku['arena_rating']-1000)/20));}
if($proc>0)$rat_autocrane_act=($rat/100)*$proc;
$ratt=$rat+$rat_drakon_act+$rat_school_act+$rat_lib_act+$rat_sc_act+$rat_trofim_act+$rat_autocrane_act+$rat_dog_act+$arena_rat;
if($ratt==0)$rat=$rat;
else $rat=$ratt;
if(isset($dexp) AND !isset($dexp3))$rat=$rat*2; elseif(isset($dexp3))$rat=$rat*3;
$dohod=floor($plant['dohod']+(($plant['dohod']/100)*$proc));
$odohod=$odohod+$dohod;
$orat=$orat+$rat;
$c_fish++;
mysql_query("UPDATE `farm_pool` SET `time_soil` = '0', `time` = '0',`id_fish`='0' WHERE `id` = '$ground[id]' LIMIT 1")or die (mysql_error());
}
mysql_query("UPDATE `farm_setting` SET `pool_fish_count` = '".($conf['pool_fish_count']+$c_fish)."' WHERE `id_user` = '$ku[id]'");
mysql_query("UPDATE `farm_user` SET `rating` = '".($ku['rating']+$orat)."',`money`='".($ku['money']+$odohod)."' WHERE `id` = '$ku[id]'");
mysql_query("INSERT INTO `farm_joirnal` SET `worker` = '2', `id_user` = '$ku[id]', `time` = '$time', `count` = '$c_fish'");
$ku['money'] = round($ku['money']+$odohod);
if(isset($mc) && $mc['nalog']>0)
{
$cm = $odohod;
$nmoney=floor(($cm/100)*$mc['nalog']);
mysql_query("UPDATE `farm_user` SET `money` = '".($ku['money']+$cm-$nmoney)."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_collective_user` SET `money` = '".($mcu['money']+$nmoney)."' WHERE `id_user` = '$ku[id]'");
mysql_query("UPDATE `farm_collective` SET `money` = '".($mc['money']+$nmoney)."' WHERE `id` = '$mc[id]'");
}
update_mc($orat);
}
///////////////////////////Разводить все
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_pool` WHERE `id_user` = '$ku[id]' AND `id_fish` = '0'"),0)!=0)
{
if(!empty($ku['last_pool'])){
$plant=mysql_fetch_array(mysql_query("SELECT * FROM `farm_pool_plant` WHERE `id` = '".intval($ku['last_pool'])."'"));
$times=$plant['time']*$incubator_time_act;
$stime=$plant['time_soil']*$incubator_timesoil_act;
$count_gg = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_pool` WHERE `id_user` = '$ku[id]' AND `id_fish` = '0'"),0);
if(!empty($plant['rcena'])){
if($ku['rubies']>=$plant['rcena']*$count_gg)
{
mysql_query("UPDATE `farm_user` SET `rubies` = '".($ku['rubies']-$plant['rcena']*$count_gg)."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_pool` SET `id_fish` = '$plant[id]', `time_soil` = '".($plant['time_soil']+$time)."', `time` = '".($times+$time)."' WHERE `id_user` = '$ku[id]' AND `id_fish` = '0' ")or die (mysql_error());
}
}elseif($ku['money']>=$plant['mcena']*$count_gg)
{
mysql_query("UPDATE `farm_user` SET `money` = '".($ku['money']-$plant['mcena']*$count_gg)."' WHERE `id` = '$ku[id]'");
mysql_query("UPDATE `farm_pool` SET `id_fish` = '$plant[id]', `time_soil` = '".($stime+$time)."', `time` = '".($times+$time)."' WHERE `id_user` = '$ku[id]' AND `id_fish` = '0' ")or die (mysql_error());
}
}
}
}
}
echo '<br/> '.number_format(microtime(1)-$t,3).' сек.';
?>