Файл: titwar.ru/sometimecron/happy2008new_year/food.php
Строк: 71
<?php
$army = mysql_fetch_array(mysql_query("SELECT * FROM army WHERE id_user='$east[id]'"));
$train1 = mysql_fetch_array(mysql_query("SELECT * FROM train WHERE id='$east[id]'"));
if ($train1['obychenie'] == '1'){
$trains11=ceil($train1['kol']+$train1['slaves']);
$trains1=ceil($train1['kol']*2+$train1['slaves']*3);///Рабочие*2+Ученые*3
}
$train2 = mysql_fetch_array(mysql_query("SELECT * FROM train2 WHERE id='$east[id]'"));
if ($train2['obychenie'] == '1'){
$trains22=ceil($train2['kol']+$train2['slaves']);
$trains2=ceil($train2['kol']*2+$train2['slaves']*3);///Рабочие*2+Ученые*3
}
$train3 = mysql_fetch_array(mysql_query("SELECT * FROM train3 WHERE id='$east[id]'"));
if ($train3['obychenie'] == '1'){
$trains33=ceil($train3['slaves']);
$trains3=ceil($train3['slaves']*3);///Ученые*3
}
$pr = mysql_fetch_array(mysql_query("SELECT * FROM pr WHERE login='$east[login]'"));
$res = mysql_fetch_array(mysql_query("SELECT * FROM res WHERE id='$east[id]'"));
$sc = mysql_fetch_array(mysql_query("SELECT * FROM sc WHERE id='$east[id]'"));
$vid1 = "select sum(`1`) as sum from wars where id_att = '$east[id]'";
$sum=mysql_query($vid1);
$result1 = mysql_fetch_array($sum);
$vid2 = "select sum(`2`) as sum from wars where id_att = '$east[id]'";
$sum=mysql_query($vid2);
$result2 = mysql_fetch_array($sum);
$vid3 = "select sum(`3`) as sum from wars where id_att = '$east[id]'";
$sum=mysql_query($vid3);
$result3 = mysql_fetch_array($sum);
$armyall=ceil($army[1]+$army[2]+$army[3]+$army[4]+$army[5]+$army[6]);///вся армия
$narabotax=ceil($trains11+$trains22+$trains3+$pr['men']+$res['men']+$sc['kol']);///все на работах
$nasall=ceil($armyall+$trains1+$trains2+$trains3+$pr['men']+$res['men']+$sc['kol']+$east['rabochie']+$east['slaves']+$result1['sum']+$result2['sum']+$result3['sum']);///все население гос
$armyazerno=ceil($army[1]*2+$army[2]*3+$army[3]*2);///зерно для армии в гос
$skokzerna=ceil($armyazerno+$trains1+$trains2+$trains3+$pr['men']*2+$res['men']*2+$sc['kol']*3
+$east['rabochie']*2+$east['slaves']*3+$result1['sum']*2+$result2['sum']*3+$result3['sum']*2);
//////////////////////////////////////////////////////Подсчет
////$zdan = mysql_fetch_array(mysql_query("SELECT * FROM buildings WHERE id_user='$east[id]'"));
////if ($zdan['1'] !='0')
////{
if($east['food'] >= $skokzerna)
{
$lost = ceil($east['food'] - $skokzerna);
mysql_query("UPDATE users SET food='$lost' where id='$east[id]'");
mysql_query("set names 'cp1251'");
send_mess('Новый год',$east['id'],'На еду для населения ушло <b>'.$skokzerna.'</b> зерна!');
}
else
{
$ostmoney=ceil($east['money']-($east['money']*90)/100);
$ostlumber=ceil($east['lumber']-($east['lumber']*75)/100);
$oststone=ceil($east['stone']-($east['stone']*75)/100);
$oststeel=ceil($east['steel']-($east['steel']*75)/100);
$ostoil=ceil($east['oil']-($east['oil']*75)/100);
mysql_query("UPDATE users SET food='0', money='$ostmoney',lumber='$ostlumber',stone='$oststone',steel='$oststeel',oil='$ostoil' WHERE id='$east[id]'");
mysql_query("set names 'cp1251'");
send_mess('Новый год',$east['id'],'Запасов зерна нехватило. Население Вашего государства подняло бунт. При этом было разграблено <b>90%</b> денег и <b>75%</b> остальных ресурсов!<br>') ;
}
////}
///О
?>