Файл: titwar.ru/zaxwat.php
Строк: 296
<?php
/////////////////////////////////основные файлы
include('inc/cfg.php');
include('inc/verh.php');
include('inc/lostblock.php');
/////////////////////////////////страница
echo B;
$nid = check_chislo($_GET['id']);
$sql = mysql_query("SELECT * FROM `wars` WHERE `id_cover`='$nid' AND `id_att`='$id'");
$count = mysql_num_rows($sql);
if($count != 0)
{
$war=mysql_fetch_array($sql);
if($time >= $war['time_in'])
{
$nuser=mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$nid'"));
$user=mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$id'"));
$army=mysql_fetch_array(mysql_query("SELECT * FROM `army` WHERE `id_user`='$id'"));
if($nuser['rank'] != 'lost')
{
///////////////////////////////////////////////////////Ресы!!!
$res_lumber = mysql_fetch_array(mysql_query("SELECT * FROM rinok WHERE id_user='$nuser[id]' and type='1'"));
$res_stone = mysql_fetch_array(mysql_query("SELECT * FROM rinok WHERE id_user='$nuser[id]' and type='2'"));
$res_steel = mysql_fetch_array(mysql_query("SELECT * FROM rinok WHERE id_user='$nuser[id]' and type='3'"));
$res_food = mysql_fetch_array(mysql_query("SELECT * FROM rinok WHERE id_user='$nuser[id]' and type='4'"));
$res_oil = mysql_fetch_array(mysql_query("SELECT * FROM rinok WHERE id_user='$nuser[id]' and type='5'"));
///////////////////////////////////////////////////////
$winm = ceil($nuser['money']); if ($winm >=15000){$winm =15000;}///деньги
$winl = ceil($nuser['lumber'] + $res_lumber['count']);if ($winl >=8000){$winl =8000;}///дерево
$wins = ceil($nuser['stone'] + $res_stone['count']);if ($wins >=5000){$wins =5000;}///камень
$winst = ceil($nuser['steel'] + $res_steel['count']);if ($winst >=3000){$winst =3000;}///железо
$winslfood = ceil($nuser['food'] + $res_food['count']);if ($winslfood >=25000){$winslfood =25000;}///зерно
$winoil = ceil($nuser['oil'] + $res_oil['count']);if ($winoil >=2000){$winoil =2000;}///нефть
//////////////////////////////////////////////////////конец
$train1 = mysql_fetch_array(mysql_query("SELECT * FROM train WHERE id='$nuser[id]'"));
if ($train1['obychenie'] == '1')
{
$trains1rab=$train1['kol'];///Рабочие
$trains1slav=$train1['slaves'];///Ученые
}
$train2 = mysql_fetch_array(mysql_query("SELECT * FROM train2 WHERE id='$nuser[id]'"));
if ($train2['obychenie'] == '1')
{
$trains2rab=$train2['kol'];///Рабочие
$trains2slav=$train2['slaves'];///Ученые
}
$train3 = mysql_fetch_array(mysql_query("SELECT * FROM train3 WHERE id='$nuser[id]'"));
if ($train3['obychenie'] == '1')
{
$trains3slav=$train3['slaves'];///Ученые
}
$pr = mysql_fetch_array(mysql_query("SELECT * FROM pr WHERE login='$nuser[login]'"));
$res = mysql_fetch_array(mysql_query("SELECT * FROM res WHERE id='$nuser[id]'"));
$sc = mysql_fetch_array(mysql_query("SELECT * FROM sc WHERE id='$nuser[id]'"));
///////////////////////////////////////////////////////Рабочие!!!
$winrb = ceil($nuser['rabochie']+$pr['men']+$res['men']+$trains1rab+$trains2rab);if ($winrb >5500){$winrb =5500;}
$winsl = ceil($nuser['slaves']+$train1['slaves']+$train2['slaves']+$train3['slaves']+$sc['kol']);if ($winsl >3000){$winsl =3000;}
//////////////////////////////////////////////////////конец
$ul = ceil($user['land']);
$randchis=mt_rand(50,100);
if ($ul >20000){$koefland =0.11;}
if ($ul <=20000){$koefland =1;}
$winsla = ceil($nuser['land']*$koefland+$randchis);if ($winsla >35000){$winsla =35000;}
//////////land
$razbros =0.09;
$kkk =$nuser['land']*$razbros;
$winslx = ceil($nuser['gori'] + $kkk);
if ($winslx >5000){$winslx =5000;}
if ($winslx <500){$winslx =500;}
/////////gori
$razbrles =0.07;
$kkkles =$nuser['land']*$razbrles;
$winsly = ceil($nuser['lesa'] + $kkkles);
if ($winsly >7000){$winsly =7000;}
if ($winsly <250){$winsly =250;}
////////les
$winer = ceil($user['wins'] + 1);
$wingold = ceil($user['GOLD'] + 5);
$sold1 = ceil($war['1'] + $army[1]);
$sold2 = ceil($war['2'] + $army[2]);
$sold3 = ceil($war['3'] + $army[3]);
$sold4 = ceil($war['4'] + $army[4]);
$sold5 = ceil($war['5'] + $army[5]);
$sold6 = ceil($war['6'] + $army[6]);
mysql_query("UPDATE `army` SET `1`='$sold1', `2`='$sold2', `3`='$sold3', `4`='$sold4', `5`='$sold5', `6`='$sold6' WHERE `id_user`='$id'");
mysql_query("UPDATE `users` SET
`war`='0',
`money`=money+'$winm',
`lumber`=lumber+'$winl',
`stone`=stone+'$wins',
`steel`=steel+'$winst',
`oil`=oil+'$winoil',
`food`=food+'$winslfood' ,
`rabochie`=rabochie+'$winrb',
`slaves`=slaves+'$winsl',
`wins`='$winer',
`GOLD`='$wingold',
`land`=land+'$winsla',
`gori`=gori+'$winslx',
`lesa`=lesa+'$winsly'
WHERE `id`='$id'");
if ($user['clan'] != '0')
{
$clansss=$user['clan'];
$skolk =1;
mysql_query("UPDATE `clans` SET `exp`=exp+'$skolk' WHERE `id`='$clansss'");
}
////////////////////////////сообщение соседям захваченного начало
$ctet = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$nuser[id]'"));
$ctetnomer = mysql_fetch_array(mysql_query("SELECT * FROM map WHERE name='$ctet[1]'"));
$ctetnomer2 = mysql_fetch_array(mysql_query("SELECT * FROM map WHERE name='$ctet[1]' ORDER BY `map`.`id` DESC"));
$sosed_zapad1 = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$ctetnomer[6]'"));
///////////////////////////
$a = mysql_query("SELECT * FROM map WHERE id < '$ctetnomer2[0]' ORDER BY id DESC, id asc LIMIT 0 , 5");
while ($east = mysql_fetch_array($a))
{
$userses1= mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$east[id_user]'"));
$userses111= $userses1['id'];
$text = 'Соседа '.$nuser['strana'].' больше нет.';
send_mess('Система', $userses111, $text);
}
$b = mysql_query("SELECT * FROM map WHERE id > '$ctetnomer[0]' LIMIT 0 , 5");
while ($west = mysql_fetch_array($b))
{
$userses2= mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$west[id_user]'"));
$userses222= $userses2['id'];
$text = 'Соседа '.$nuser['strana'].' больше нет.';
send_mess('Система', $userses222, $text);
}
/////////////////////////////////////////сообщение соседям захваченного конец
$otherwars = mysql_query("SELECT * FROM wars WHERE id_cover='$nid' AND id_att != '$id'");
while($others = mysql_fetch_array($otherwars))
{
$array = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$others[id_att]'"));
$solds1 = ceil($others[1]);
$solds2 = ceil($others[2]);
$solds3 = ceil($others[3]);
$solds4 = ceil($others[4]);
$solds5 = ceil($others[5]);
$solds6 = ceil($others[6]);
if ($solds1 >=1){$pexi = '<b>'.$others[1].'</b> пехотинцев. <br>';}
if ($solds2 >=1){$kavi = '<b>'.$others[2].'</b> кавалеристов. <br>';}
if ($solds3 >=1){$stri = '<b>'.$others[3].'</b> стрелков. <br>';}
if ($solds4 >=1){$sami = '<b>'.$others[4].'</b> пушек. <br>';}
if ($solds5 >=1){$tani = '<b>'.$others[5].'</b> подрывников.';}
if ($solds6 >=1){$zeni = '<b>'.$others[6].'</b> самолетов.';}
mysql_query("UPDATE `army` SET `1`=`1`+'$solds1', `2`=`2`+'$solds2', `3`=`3`+'$solds3', `4`=`4`+'$solds4', `5`=`5`+'$solds5', `6`=`6`+'$solds6' WHERE `id_user`='$array[id]'");
mysql_query("DELETE FROM `wars` WHERE `id_war` = '$others[id_war]'");
$id = $array['id'];
$_POST['by_whom'] = '5';
$_POST['what'] = "Ваш противник: <b>".$others['strana_cover']."</b> проиграл!
<br>
<u>Вернулось войска:</u> <br>
$pexi
$kavi
$stri
$sami
$tani";
send_mess($_POST['by_whom'], $id, $_POST['what']);
}
//////////////////////////////////////////////////////////////действия по удалению захваченной страны
mysql_query("DELETE FROM `general` WHERE `id_user` = '$nid'");///+
mysql_query("DELETE FROM `rinok` WHERE `id_user` = '$nid'");///+
mysql_query("DELETE FROM `logi` WHERE `user_id` = '$nid'");///+
mysql_query("DELETE FROM `msg` WHERE `to_whom` = '$nid'");///+
mysql_query("DELETE FROM `map` WHERE `id_user` = '$nid'");///+
mysql_query("DELETE FROM `wars` WHERE `id_att` = '$nid'");///+
mysql_query("DELETE FROM `wall` WHERE `id_user` = '$nid'");///+
mysql_query("DELETE FROM `pr` WHERE `login` = '$nuser[login]'");
mysql_query("UPDATE `army` SET `1`='5',`2`='0',`3`='0',`4`='0',`5`='0',`6`='0' WHERE `id_user` = '$nid'");///+
mysql_query("UPDATE `science` SET `doblumber`='10',`dobstone`='10',`dobsteel`='10',`dobfood`='10',`doboil`='10' WHERE `id` = '$nid'");///+
mysql_query("UPDATE `sc` SET `kol`='0',`food`='0',`lumber`='0',`stone`='0',`steel`='0',`oil`='0' WHERE `id` = '$nid'");///+
mysql_query("UPDATE `buildings` SET `1`='0',`2`='0',`3`='0',`4`='0',`5`='0',`6`='0',`7`='0',`8`='0',`9`='0',`10`='0' WHERE `id_user` = '$nid'");///+
mysql_query("UPDATE `weapon` SET `pexor`='1',`pexbr`='1',`kavor`='1',`kavbr`='1',`stror`='1', `strbr`='1',`samor`='1',`sambr`='1',`tanor`='1',`tanbr`='1',`zenor`='1',`zenbr`='1' WHERE `id` = '$nid'");///+
mysql_query("UPDATE `svvtime` SET `spy`='0',`vor`='0',`verb`='0',`sab`='0' WHERE `id` = '$nid'");///+
mysql_query("UPDATE `train` SET `kol`='0',`obychenie`='0',`time`='0',`tip`='',`money`='0',`lumber`='0' ,`stone`='0' ,`steel`='0' ,`oil`='0' ,`food`='0' ,`slaves`='0' WHERE `id` = '$nid'");///+
mysql_query("UPDATE `train2` SET `kol`='0',`obychenie`='0',`time`='0',`tip`='',`money`='0',`lumber`='0' ,`stone`='0' ,`steel`='0' ,`oil`='0' ,`food`='0' ,`slaves`='0' WHERE `id` = '$nid'");///+
mysql_query("UPDATE `train3` SET `kol`='0',`obychenie`='0',`time`='0',`tip`='',`money`='0',`lumber`='0' ,`stone`='0' ,`steel`='0' ,`oil`='0' ,`food`='0' ,`slaves`='0' WHERE `id` = '$nid'");///+
mysql_query("UPDATE `res` SET `money`='0',`lumber`='0',`alumber`='0',`men`='0',`stone`='0',`astone`='0',`steel`='0',`asteel`='0',`food`='0',`afood`='0' WHERE `id` = '$nid'");
mysql_query("UPDATE `users`
SET
`rank`='lost',
`strana`='',
`money`='8500',
`lumber`='1050',
`stone`='1050',
`steel`='800',
`oil`='0',
`food`='3000',
`stenobitki`='0',
`rabochie`='200',
`slaves`='50',
`spy`='10',
`sab`='10',
`vor`='10',
`verb`='10',
`land`='1500',
`gori`='0',
`lesa`='0'
WHERE `id`='$nid'");
mysql_query("DELETE FROM `wars` WHERE `id_war` = '$war[id_war]'");
////////////////////////////
//$ctet = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$user[id]'"));
//$ctetnomer = mysql_fetch_array(mysql_query("SELECT * FROM map WHERE name='$ctet[1]'"));
//$sosed_zapad1 = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$ctetnomer[6]'"));
///////////////////////////
echo '
Вы успешно захватили государство <b>'.$nuser['strana'].'</b>
<br>Захвачено:<br>
Денег: <b>'.$winm.'</b><br />
Дерева: <b>'.$winl.'</b><br />
Камня: <b>'.$wins.'</b><br />
Железа: <b>'.$winst.'</b><br />
Зерна: <b>'.$winslfood.'</b><br />
Нефти: <b>'.$winoil.'</b>
<br>
Рабочих: <b>'.$winrb.'</b><br />
Ученых: <b>'.$winsl.'</b>
<br>
Земли: <b>'.$winsla.'</b><br />
Гор: <b>'.$winslx.'</b><br />
Леса: <b>'.$winsly.'</b><br>';
///
$datas= date("y.m.d H:i:s");
$textlog = '
Вы успешно захватили государство <b>'.$nuser['strana'].'</b>:<br />
Денег: <b>'.$winm.'</b><br />
Дерева: <b>'.$winl.'</b><br />
Камня: <b>'.$wins.'</b><br />
Железа: <b>'.$winst.'</b><br />
Зерна: <b>'.$winslfood.'</b><br />
Нефти: <b>'.$winoil.'</b><br />
Рабочих: <b>'.$winrb.'</b><br />
Ученых: <b>'.$winsl.'</b><br />
Земли: <b>'.$winsla.'</b><br />
Гор: <b>'.$winslx.'</b><br />
Леса: <b>'.$winsly.'</b>';
$statuslog = 'захват';
mysql_query("INSERT INTO `logi` ( `id` , `user_id` , `login` , `data` , `text` , `status` )
VALUES ('', '$user[id]', '$user[login]', '$datas', '$textlog', '$statuslog')");
///
$date=date('Y:m:d H:i:s');
mysql_query("
INSERT INTO `zaxwati` (
`id` ,
`id_user` ,
`strana` ,
`strana_lost` ,
`by_whom` ,
`why` ,
`money` ,
`lumber` ,
`stone` ,
`steel` ,
`oil` ,
`food` ,
`rabochie`,
`slaves`,
`land`,
`gori`,
`lesa`,
`date`
)
VALUES (
NULL ,'$user[id]','$user[strana]', '$nuser[strana]', '$nuser[login]', 'захват',
'$winm', '$winl', '$wins', '$winst', '$winoil', '$winslfood', '$winrb', '$winsl', '$winsla', '$winslx', '$winsly', '$date'
);");
}
else
{
$sold1 = $war['1'] + $army[1];
$sold2 = $war['2'] + $army[2];
$sold3 = $war['3'] + $army[3];
$sold4 = $war['4'] + $army[4];
$sold5 = $war['5'] + $army[5];
$sold6 = $war['6'] + $army[6];
mysql_query("DELETE FROM `wars` WHERE `id_war` = '$war[id_war]'");
mysql_query("UPDATE `army` SET `1`='$sold1', `2`='$sold2', `3`='$sold3', `4`='$sold4', `5`='$sold5', `6`='$sold6' WHERE `id_user`='$id'");
echo 'Нет такого государства на карте мира.<br />';
}
}
else
{echo 'Вы еще не продержались 12 часов! <br />';
}
}
else
{echo 'Вы не воюете с этим государством!<br />';
}
echo D,F.'
<a href="game.php'.$ssilki1.'">Назад</a>
'.D;
include('inc/niz.php');
?>