Файл: ng1.php
Строк: 94
<?
include'dobavka/conf.php';
$sk1=date("H");$sk2=date("i");
$sql = mysql_query("SELECT DISTINCT * FROM `gos`WHERE login!='KLOP';");
while ($row = mysql_fetch_assoc($sql)) {$str=$row['strana'];
$p2=$row['rab']+$row['bot']+$row['rabmet']+$row['rabmin']+$row['rabdro']+$row['rabpro'];
$p5=$row['peh']+$row['peht'];
$p10=$row['kaz']+$row['kazt'];
$p15=$row['gva']+$row['gvat'];
$alr1=mysql_fetch_array(mysql_query("SELECT * FROM rynok WHERE strana='$str' and tovar='5'"));
$alr2=mysql_fetch_array(mysql_query("SELECT * FROM rynok WHERE strana='$str' and tovar='6'"));
$alr3=mysql_fetch_array(mysql_query("SELECT sum(peh)as t FROM voiny WHERE strana='$str'"));
$alr4=mysql_fetch_array(mysql_query("SELECT sum(kaz)as t FROM voiny WHERE strana='$str'"));
$alr5=mysql_fetch_array(mysql_query("SELECT sum(gva)as t FROM voiny WHERE strana='$str'"));
$p2=$p2+$alr1['kolvo']+$alr2['kolvo'];
$p5=$p5+$alr3['t'];$p10=$p10+$alr4['t'];$p15=$p15+$alr5['t'];
$pp=($p2*2)+($p5*5)+($p10*10)+($p15*15);
if($row['proviz']>=$pp){
$ost=$row['proviz']-$pp;
mysql_query("UPDATE gos SET proviz='$ost' WHERE strana='$str'");
mysql_query("INSERT INTO mess (data,chitat,pisat,mail) VALUE ('$sk1:$sk2','$str','@',' На еду для населения ушло $pp зерна!')");
}else{
$b=round(($row['proviz']*100)/$pp);
$b2=round(100-$b);
$rab=round(($row['rab']/100)*$b2);
$bot=round(($row['bot']/100)*$b2);
$rabmet=round(($row['rabmet']/100)*$b2);
$rabmin=round(($row['rabmin']/100)*$b2);
$rabdro=round(($row['rabdro']/100)*$b2);
$rabpro=round(($row['rabpro']/100)*$b2);
$peh=round(($row['peh']/100)*$b2);
$kaz=round(($row['kaz']/100)*$b2);
$gva=round(($row['gva']/100)*$b2);
$peht=round(($row['peht']/100)*$b2);
$kazt=round(($row['kazt']/100)*$b2);
$gvat=round(($row['gvat']/100)*$b2);
$rrab=round(($alr1['kolvo']/100)*$b2);
$rbot=round(($alr2['kolvo']/100)*$b2);
if($b2>30 and $b2 !=100){
if($rrab==0 and $alr1['kolvo']>0){$rrab=1;}else{$rrab=$rrab;}
if($rbot==0 and $alr2['kolvo']>0){$rbot=1;}else{$rbot=$rbot;}
mysql_query("UPDATE gos SET proviz='0',rab='$rab',bot='$bot',peh='$peh',kaz='$kaz',
gva='$gva',rabmet='$rabmet',rabmin='$rabmin',rabdro='$rabdro',rabpro='$rabpro',
peht='$peht',kazt='$kazt',gvat='$gvat' WHERE strana='$str'");
mysql_query("UPDATE rynok SET kolvo='$rrab' WHERE strana='$str' and tovar='5'");
mysql_query("UPDATE rynok SET kolvo='$rrab' WHERE strana='$str' and tovar='6'");
mysql_query("INSERT INTO mess (data,chitat,pisat,mail) VALUE ('$sk1:$sk2','$str','@',' На еду для населения не хватило зерна!погибло $b % населения!')");
///////////////////////////
$sum1 = 5; // число записей на странице
$result1 = mysql_query("SELECT count(*) as a from voiny where strana='$str'");
$arr1 = mysql_fetch_row($result1);$rec1= $arr1[0];
if(!isset($_GET['str'])){$str1 = 0;}else
{$str = $_GET['str'];}$start1 = $str1 * $sum1;
$r1 = mysql_query("SELECT * FROM voiny where strana='$str' LIMIT $start1, $sum1");
$n1 = mysql_num_rows($r1);for ($i1 = 0; $i1 < $n1; $i1++){
$m1= mysql_fetch_array($r1);$id=$m1['id'];
$d1=round(($m1['peh']/100)*$b2);$d2=round(($m1['kaz']/100)*$b2);$d3=round(($m1['gva']/100)*$b2);
if($d1==0 and $m1['peh']>0){$d1=1;}else{$d1=$d1;}
if($d2==0 and $m1['kaz']>0){$d2=1;}else{$d2=$d2;}
if($d3==0 and $m1['gva']>0){$d3=1;}else{$d3=$d3;}
mysql_query("UPDATE voiny SET peh='$d1',kaz='$d2',gva='$d3' WHERE id='$id'");}
}else{
//////////////////////////
mysql_query("DELETE FROM voiny WHERE strana1='$str'AND strana='$nik'");
mysql_query("DELETE FROM voiny WHERE strana='$str'");
mysql_query("DELETE FROM gos WHERE strana='$str'");
mysql_query("DELETE FROM rynok WHERE strana='$str'");
mysql_query("DELETE FROM kmb WHERE strana='$str'");
mysql_query("DELETE FROM nauka WHERE strana='$str'");
mysql_query("DELETE FROM soyuz WHERE strana1='$str' or strana2='$str'");
mysql_query("DELETE FROM mess WHERE chitat='$str'");
mysql_query("DELETE FROM stroyka WHERE strana='$str'");
mysql_query("DELETE FROM botan WHERE strana='$str'");
$soh1=mysql_fetch_array(mysql_query("SELECT id,vozrast FROM sohran WHERE strana='$str'"));
if($soh1['id']>0){
$tr=time();$dd=($soh1['vozrast']/5)+$tr;
mysql_query("UPDATE sohran SET data='$dd' WHERE strana='$str'");
}else{
mysql_query("DELETE FROM logzahv WHERE strana='$str'");
mysql_query("DELETE FROM logboy WHERE strana='$str'");
mysql_query("DELETE FROM logbir WHERE strana='$str'");
mysql_query("DELETE FROM logden WHERE strana='$str'");
mysql_query("DELETE FROM logmen WHERE strana='$str'");
mysql_query("DELETE FROM logver WHERE strana='$str'");
mysql_query("DELETE FROM logvor WHERE strana='$str'");
}
}}}
?>