Файл: titwar.ru/func/game_army.php
Строк: 73
<?php
$army = mysql_fetch_array(mysql_query("SELECT * FROM army WHERE id_user='$id'"));
$train1 = mysql_fetch_array(mysql_query("SELECT * FROM train WHERE id='$user[id]'"));
if ($train1['obychenie'] == '1'){
$trains11=$train1['kol']+$train1['slaves'];
$trains1=$train1['kol']*2+$train1['slaves']*3;///Рабочие*2+Ученые*3
}
$train2 = mysql_fetch_array(mysql_query("SELECT * FROM train2 WHERE id='$user[id]'"));
if ($train2['obychenie'] == '1'){
$trains22=$train2['kol']+$train2['slaves'];
$trains2=$train2['kol']*2+$train2['slaves']*3;///Рабочие*2+Ученые*3
}
$train3 = mysql_fetch_array(mysql_query("SELECT * FROM train3 WHERE id='$user[id]'"));
if ($train3['obychenie'] == '1'){
$trains33=$train3['slaves'];
$trains3=$train3['slaves']*3;///Ученые*3
}
$pr = mysql_fetch_array(mysql_query("SELECT * FROM pr WHERE login='$user[login]'"));
$res = mysql_fetch_array(mysql_query("SELECT * FROM res WHERE id='$user[id]'"));
$sc = mysql_fetch_array(mysql_query("SELECT * FROM sc WHERE id='$user[id]'"));
$vid1 = "select sum(`1`) as sum from wars where id_att = '$user[id]'";
$sum=mysql_query($vid1);
$result1 = mysql_fetch_array($sum);
$vid2 = "select sum(`2`) as sum from wars where id_att = '$user[id]'";
$sum=mysql_query($vid2);
$result2 = mysql_fetch_array($sum);
$vid3 = "select sum(`3`) as sum from wars where id_att = '$user[id]'";
$sum=mysql_query($vid3);
$result3 = mysql_fetch_array($sum);
$vid4 = "select sum(`4`) as sum from wars where id_att = '$user[id]'";
$sum=mysql_query($vid4);
$result4 = mysql_fetch_array($sum);
$vid5 = "select sum(`5`) as sum from wars where id_att = '$user[id]'";
$sum=mysql_query($vid5);
$result5 = mysql_fetch_array($sum);
$vid6 = "select sum(`6`) as sum from wars where id_att = '$user[id]'";
$sum=mysql_query($vid6);
$result6 = mysql_fetch_array($sum);
$armyall=$army[1]+$army[2]+$army[3]+$army[4]+$army[5]+$army[6];///вся армия
$narabotax=$trains11+$trains22+$trains33+$pr['men']+$res['men']+$sc['kol'];///все на работах
$nasall=$armyall+$trains11+$trains2+$trains33+$pr['men']+$res['men']+$sc['kol']+$user['rabochie']+$user['slaves']+$result1['sum']+$result2['sum']+$result3['sum']+$result4['sum']+$result5['sum']+$result6['sum'];///все население гос
$armyazerno=$army[1]*2+$army[2]*3+$army[3]*2;///зерно для армии в гос
$skokzerna=$armyazerno+$trains1+$trains2+$trains3+$pr['men']*2+$res['men']*2+$sc['kol']*3
+$user['rabochie']*2+$user['slaves']*3+$result1['sum']*2+$result2['sum']*3+$result3['sum']*2;
include('inc/verh_builgings.php');
echo TIT.'
<b><u>Население Вашего государства:</u></b>'.D,B.'
<img src="i/ppl.png" alt="" /><b>Общее население: '.$nasall.'</b><br />
<img src="i/ppl.png" alt="" />Свободные рабочие: <b>',$user[rabochie],'</b><br />
<img src="i/ppl.png" alt="" />Свободные ученые: <b>',$user[slaves],'</b><br />
<img src="i/ppl.png" alt="" />Занятых рабочих и ученых: <b>'.$narabotax.'</b>'.D,TIT.'
<b><u>Количество свободных войск:</u></b>'.D;
echo B.'
<img src="i/u1_sm.gif" alt="" /><a href="help.php?inf=8&unit=1'.$ssilki2.'">Пехотинцы</a>: <b>',$army[1],'</b><br />
<img src="i/u2_sm.gif" alt="" /><a href="help.php?inf=8&unit=2'.$ssilki2.'">Кавалеристы</a>: <b>',$army[2],'</b><br />
<img src="i/u3_sm.gif" alt="" /><a href="help.php?inf=8&unit=3'.$ssilki2.'">Стрелки</a>: <b>',$army[3],'</b><br />
<img src="i/u4_sm.gif" alt="" /><a href="help.php?inf=8&unit=4'.$ssilki2.'">Пушки</a>: <b>',$army[4],'</b><br />
<img src="i/u5_sm.gif" alt="" /><a href="help.php?inf=8&unit=5'.$ssilki2.'">Подрывники</a>: <b>',$army[5],'</b><br />
<img src="i/u6_sm.gif" alt="" /><a href="help.php?inf=8&unit=6'.$ssilki2.'">Самолеты</a>: <b>',$army[6],'</b><br />'.D;
echo B.'<br>
Ежегодно все население съедает: <b>'.$skokzerna.'</b> зерна
'.D.'<br />'.F.'
<a href="game.php'.$ssilki1.'">Назад</a>'.D;
?>