PageRenderTime 59ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 1ms

/src/2.10.2/upload/includes/classes/class.FlyingFleetHandler.php

https://github.com/SantiHarry/XG-Proyect-v2.10.x
PHP | 2284 lines | 1976 code | 296 blank | 12 comment | 274 complexity | 6c07d6ba1b7b91b1ae72f1eb1191cebe MD5 | raw file
    

  1. <?php

    2. 

  2. 

    3. 

  3. /**

    4. 

  4.  * @project XG Proyect

    5. 

  5.  * @version 2.10.x build 0000

    6. 

  6.  * @copyright Copyright (C) 2008 - 2012

    7. 

  7.  */

    8. 

  8. 

    9. 

  9. if (!defined('INSIDE'))die(header("location:../../"));

    10. 

  10. 

    11. 

  11. class FlyingFleetHandler

    12. 

  12. {

    13. 

  13. 	public static function calculateAKSSteal($attackFleets, $defenderPlanet, $ForSim = FALSE)

    14. 

  14. 	{

    15. 

  15. 		//Steal-Math by Slaver for 2Moons(http://www.titanspace.org) based on http://www.owiki.de/Beute

    16. 

  16. 		global $pricelist, $db;

    17. 

  17. 

    18. 

  18. 		$SortFleets = array();

    19. 

  19. 

    20. 

  20. 		foreach ($attackFleets as $FleetID => $Attacker)

    21. 

  21. 		{

    22. 

  22. 			foreach($Attacker['detail'] as $Element => $amount)

    23. 

  23. 			{

    24. 

  24. 				if ($Element != 210) //fix probos capacity in attack by jstar

    25. 

  25. 					$SortFleets[$FleetID]        += $pricelist[$Element]['capacity'] * $amount;

    26. 

  26. 			}

    27. 

  27. 

    28. 

  28. 			$SortFleets[$FleetID]            -= $Attacker['fleet']['fleet_resource_metal'] - $Attacker['fleet']['fleet_resource_crystal'] - $Attacker['fleet']['fleet_resource_deuterium'];

    29. 

  29. 		}

    30. 

  30. 

    31. 

  31. 		$Sumcapacity              = array_sum($SortFleets);

    32. 

  32. 		//FIX JTSAMPER

    33. 

  33. 		$booty['deuterium']       = min($Sumcapacity / 3,  ($defenderPlanet['deuterium'] / 2));

    34. 

  34. 		$Sumcapacity             -= $booty['deuterium'];

    35. 

  35. 

    36. 

  36. 		$booty['crystal']         = min(($Sumcapacity / 2),  ($defenderPlanet['crystal'] / 2));

    37. 

  37. 		$Sumcapacity             -= $booty['crystal'];

    38. 

  38. 

    39. 

  39. 		$booty['metal']           = min(($Sumcapacity ),  ($defenderPlanet['metal'] / 2));

    40. 

  40. 		$Sumcapacity             -= $booty['metal'];

    41. 

  41. 

    42. 

  42. 

    43. 

  43. 		$oldMetalBooty            = $booty['crystal'] ;

    44. 

  44. 		$booty['crystal']         += min(($Sumcapacity /2 ),  max((($defenderPlanet['crystal']) / 2) - $booty['crystal'], 0));

    45. 

  45. 

    46. 

  46. 		$Sumcapacity             += $oldMetalBooty - $booty['crystal'] ;

    47. 

  47. 

    48. 

  48. 		$booty['metal']          += min(($Sumcapacity ),  max(($defenderPlanet['metal'] / 2) - $booty['metal'], 0));

    49. 

  49. 

    50. 

  50. 

    51. 

  51. 		$booty['metal']             = max($booty['metal'] ,0);

    52. 

  52. 		$booty['crystal']           = max($booty['crystal'] ,0);

    53. 

  53. 		$booty['deuterium']         = max($booty['deuterium'] ,0);

    54. 

  54. 		//END FIX

    55. 

  55. 

    56. 

  56. 		$steal                 = array_map('floor', $booty);

    57. 

  57. 		if($ForSim)

    58. 

  58. 			return $steal;

    59. 

  59. 

    60. 

  60. 		$AllCapacity    = array_sum($SortFleets);

    61. 

  61. 		$QryUpdateFleet    = "";

    62. 

  62. 		

    63. 

  63. 		if ( $AllCapacity != 0 )

    64. 

  64. 		{

    65. 

  65. 			foreach($SortFleets as $FleetID => $Capacity)

    66. 

  66. 			{

    67. 

  67. 				$QryUpdateFleet = 'UPDATE {{table}} SET ';

    68. 

  68. 				$QryUpdateFleet .= '`fleet_resource_metal` = `fleet_resource_metal` + '.Format::float_to_string($steal['metal'] * ($Capacity / $AllCapacity)).', ';

    69. 

  69. 				$QryUpdateFleet .= '`fleet_resource_crystal` = `fleet_resource_crystal` +'.Format::float_to_string($steal['crystal'] * ($Capacity / $AllCapacity)).', ';

    70. 

  70. 				$QryUpdateFleet .= '`fleet_resource_deuterium` = `fleet_resource_deuterium` +'.Format::float_to_string($steal['deuterium'] * ($Capacity / $AllCapacity)).' ';

    71. 

  71. 				$QryUpdateFleet .= 'WHERE fleet_id = '.$FleetID.' ';

    72. 

  72. 				$QryUpdateFleet .= 'LIMIT 1;';

    73. 

  73. 				doquery($QryUpdateFleet, 'fleets');

    74. 

  74. 	

    75. 

  75. 			}

    76. 

  76. 		}

    77. 

  77. 		else

    78. 

  78. 		{

    79. 

  79. 			$steal	= 0;

    80. 

  80. 		}

    81. 

  81. 

    82. 

  82. 		return $steal;

    83. 

  83. 	}

    84. 

  84. 

    85. 

  85. 	private function SpyTarget ($TargetPlanet, $Mode, $TitleString)

    86. 

  86. 	{

    87. 

  87. 		global $lang, $resource;

    88. 

  88. 

    89. 

  89. 		$LookAtLoop = TRUE;

    90. 

  90. 		if ($Mode == 0)

    91. 

  91. 		{

    92. 

  92. 			$String  = "<table width=\"440\"><tr><td class=\"c\" colspan=\"5\">";

    93. 

  93. 			$String .= $TitleString ." ". $TargetPlanet['name'];

    94. 

  94. 			$String .= " <a href=\"game.php?page=galaxy&mode=3&galaxy=". $TargetPlanet["galaxy"] ."&system=". $TargetPlanet["system"]. "\">";

    95. 

  95. 			$String .= "[". $TargetPlanet["galaxy"] .":". $TargetPlanet["system"] .":". $TargetPlanet["planet"] ."]</a>";

    96. 

  96. 			$String .= $lang['sys_the'] . date("d-m-Y H:i:s", time()) ."</td>";

    97. 

  97. 			$String .= "</tr><tr>";

    98. 

  98. 			$String .= "<td width=220>". $lang['Metal']     ."</td><td width=220 align=right>". Format::pretty_number($TargetPlanet['metal'])      ."</td><td>&nbsp;</td>";

    99. 

  99. 			$String .= "<td width=220>". $lang['Crystal']   ."</td></td><td width=220 align=right>". Format::pretty_number($TargetPlanet['crystal'])    ."</td>";

    100. 

  100. 			$String .= "</tr><tr>";

    101. 

  101. 			$String .= "<td width=220>". $lang['Deuterium'] ."</td><td width=220 align=right>". Format::pretty_number($TargetPlanet['deuterium'])  ."</td><td>&nbsp;</td>";

    102. 

  102. 			$String .= "<td width=220>". $lang['Energy']    ."</td><td width=220 align=right>". Format::pretty_number($TargetPlanet['energy_max']) ."</td>";

    103. 

  103. 			$String .= "</tr>";

    104. 

  104. 			$LookAtLoop = FALSE;

    105. 

  105. 		}

    106. 

  106. 		elseif ($Mode == 1)

    107. 

  107. 		{

    108. 

  108. 			$ResFrom[0] = 200;

    109. 

  109. 			$ResTo[0]   = 299;

    110. 

  110. 			$Loops      = 1;

    111. 

  111. 		}

    112. 

  112. 		elseif ($Mode == 2)

    113. 

  113. 		{

    114. 

  114. 			$ResFrom[0] = 400;

    115. 

  115. 			$ResTo[0]   = 499;

    116. 

  116. 			$ResFrom[1] = 500;

    117. 

  117. 			$ResTo[1]   = 599;

    118. 

  118. 			$Loops      = 2;

    119. 

  119. 		}

    120. 

  120. 		elseif ($Mode == 3)

    121. 

  121. 		{

    122. 

  122. 			$ResFrom[0] = 1;

    123. 

  123. 			$ResTo[0]   = 99;

    124. 

  124. 			$Loops      = 1;

    125. 

  125. 		}

    126. 

  126. 		elseif ($Mode == 4)

    127. 

  127. 		{

    128. 

  128. 			$ResFrom[0] = 100;

    129. 

  129. 			$ResTo[0]   = 199;

    130. 

  130. 			$Loops      = 1;

    131. 

  131. 		}

    132. 

  132. 

    133. 

  133. 		if ($LookAtLoop == TRUE)

    134. 

  134. 		{

    135. 

  135. 			$String  = "<table width=\"440\" cellspacing=\"1\"><tr><td class=\"c\" colspan=\"". ((2 * SPY_REPORT_ROW) + (SPY_REPORT_ROW - 1))."\">". $TitleString ."</td></tr>";

    136. 

  136. 			$Count       = 0;

    137. 

  137. 			$CurrentLook = 0;

    138. 

  138. 			while ($CurrentLook < $Loops)

    139. 

  139. 			{

    140. 

  140. 				$row     = 0;

    141. 

  141. 				for ($Item = $ResFrom[$CurrentLook]; $Item <= $ResTo[$CurrentLook]; $Item++)

    142. 

  142. 				{

    143. 

  143. 					if ( $TargetPlanet[$resource[$Item]] > 0)

    144. 

  144. 					{

    145. 

  145. 						if ($row == 0)

    146. 

  146. 							$String  .= "<tr>";

    147. 

  147. 

    148. 

  148. 						$String  .= "<td align=left>".$lang['tech'][$Item]."</td><td align=right>".$TargetPlanet[$resource[$Item]]."</td>";

    149. 

  149. 						if ($row < SPY_REPORT_ROW - 1)

    150. 

  150. 							$String  .= "<td>&nbsp;</td>";

    151. 

  151. 

    152. 

  152. 						$Count   += $TargetPlanet[$resource[$Item]];

    153. 

  153. 						$row++;

    154. 

  154. 						if ($row == SPY_REPORT_ROW)

    155. 

  155. 						{

    156. 

  156. 							$String  .= "</tr>";

    157. 

  157. 							$row      = 0;

    158. 

  158. 						}

    159. 

  159. 					}

    160. 

  160. 				}

    161. 

  161. 

    162. 

  162. 				while ($row != 0)

    163. 

  163. 				{

    164. 

  164. 					$String  .= "<td>&nbsp;</td><td>&nbsp;</td>";

    165. 

  165. 					$row++;

    166. 

  166. 					if ($row == SPY_REPORT_ROW)

    167. 

  167. 					{

    168. 

  168. 						$String  .= "</tr>";

    169. 

  169. 						$row      = 0;

    170. 

  170. 					}

    171. 

  171. 				}

    172. 

  172. 				$CurrentLook++;

    173. 

  173. 			}

    174. 

  174. 		}

    175. 

  175. 		$String .= "</table>";

    176. 

  176. 

    177. 

  177. 		$return['String'] = $String;

    178. 

  178. 		$return['Count']  = $Count;

    179. 

  179. 

    180. 

  180. 		return $return;

    181. 

  181. 	}

    182. 

  182. 

    183. 

  183. 	private function walka ($CurrentSet, $TargetSet, $CurrentTechno, $TargetTechno)

    184. 

  184. 	{

    185. 

  185. 		global $pricelist, $CombatCaps, $user;

    186. 

  186. 

    187. 

  187. 		$runda       = array();

    188. 

  188. 		$atakujacy_n = array();

    189. 

  189. 		$wrog_n      = array();

    190. 

  190. 

    191. 

  191. 		if (!is_null($CurrentSet))

    192. 

  192. 		{

    193. 

  193. 			$atakujacy_zlom_poczatek['metal']   = 0;

    194. 

  194. 			$atakujacy_zlom_poczatek['crystal'] = 0;

    195. 

  195. 			foreach($CurrentSet as $a => $b)

    196. 

  196. 			{

    197. 

  197. 				$atakujacy_zlom_poczatek['metal']   = $atakujacy_zlom_poczatek['metal']   + $CurrentSet[$a]['count'] * $pricelist[$a]['metal'];

    198. 

  198. 				$atakujacy_zlom_poczatek['crystal'] = $atakujacy_zlom_poczatek['crystal'] + $CurrentSet[$a]['count'] * $pricelist[$a]['crystal'];

    199. 

  199. 			}

    200. 

  200. 		}

    201. 

  201. 

    202. 

  202. 		$wrog_zlom_poczatek['metal']   	= 0;

    203. 

  203. 		$wrog_zlom_poczatek['crystal'] 	= 0;

    204. 

  204. 		$wrog_poczatek 					= $TargetSet;

    205. 

  205. 

    206. 

  206. 		if (!is_null($TargetSet))

    207. 

  207. 		{

    208. 

  208. 			foreach($TargetSet as $a => $b)

    209. 

  209. 			{

    210. 

  210. 				if ($a < 300)

    211. 

  211. 				{

    212. 

  212. 					$wrog_zlom_poczatek['metal']   = $wrog_zlom_poczatek['metal']   + $TargetSet[$a]['count'] * $pricelist[$a]['metal'];

    213. 

  213. 					$wrog_zlom_poczatek['crystal'] = $wrog_zlom_poczatek['crystal'] + $TargetSet[$a]['count'] * $pricelist[$a]['crystal'];

    214. 

  214. 				}

    215. 

  215. 				else

    216. 

  216. 				{

    217. 

  217. 					$wrog_zlom_poczatek_obrona['metal']   = $wrog_zlom_poczatek_obrona['metal']   + $TargetSet[$a]['count'] * $pricelist[$a]['metal'];

    218. 

  218. 					$wrog_zlom_poczatek_obrona['crystal'] = $wrog_zlom_poczatek_obrona['crystal'] + $TargetSet[$a]['count'] * $pricelist[$a]['crystal'];

    219. 

  219. 				}

    220. 

  220. 			}

    221. 

  221. 		}

    222. 

  222. 

    223. 

  223. 		for ($i = 1; $i <= 7; $i++)

    224. 

  224. 		{

    225. 

  225. 			$atakujacy_atak   = 0;

    226. 

  226. 			$wrog_atak        = 0;

    227. 

  227. 			$atakujacy_obrona = 0;

    228. 

  228. 			$wrog_obrona      = 0;

    229. 

  229. 			$atakujacy_ilosc  = 0;

    230. 

  230. 			$wrog_ilosc       = 0;

    231. 

  231. 			$wrog_tarcza      = 0;

    232. 

  232. 			$atakujacy_tarcza = 0;

    233. 

  233. 

    234. 

  234. 			if (!is_null($CurrentSet))

    235. 

  235. 			{

    236. 

  236. 				foreach($CurrentSet as $a => $b)

    237. 

  237. 				{

    238. 

  238. 					$CurrentSet[$a]["obrona"] 	= $CurrentSet[$a]['count'] * ($pricelist[$a]['metal'] + $pricelist[$a]['crystal']) / 10 * (1 + (0.1 * ($CurrentTechno["defence_tech"])));

    239. 

  239. 					$rand 						= rand(80, 120) / 100;

    240. 

  240. 					$CurrentSet[$a]["tarcza"] 	= $CurrentSet[$a]['count'] * $CombatCaps[$a]['shield'] * (1 + (0.1 * $CurrentTechno["shield_tech"])) * $rand;

    241. 

  241. 					$atak_statku 				= $CombatCaps[$a]['attack'];

    242. 

  242. 					$technologie 				= (1 + (0.1 * $CurrentTechno["military_tech"]));

    243. 

  243. 					$rand 						= rand(80, 120) / 100;

    244. 

  244. 					$ilosc 						= $CurrentSet[$a]['count'];

    245. 

  245. 					$CurrentSet[$a]["atak"] 	= $ilosc * $atak_statku * $technologie * $rand;

    246. 

  246. 					$atakujacy_atak			 	= $atakujacy_atak + $CurrentSet[$a]["atak"];

    247. 

  247. 					$atakujacy_obrona 			= $atakujacy_obrona + $CurrentSet[$a]["obrona"];

    248. 

  248. 					$atakujacy_ilosc 			= $atakujacy_ilosc + $CurrentSet[$a]['count'];

    249. 

  249. 				}

    250. 

  250. 			}

    251. 

  251. 			else

    252. 

  252. 			{

    253. 

  253. 				$atakujacy_ilosc = 0;

    254. 

  254. 				break;

    255. 

  255. 			}

    256. 

  256. 

    257. 

  257. 			if (!is_null($TargetSet))

    258. 

  258. 			{

    259. 

  259. 				foreach($TargetSet as $a => $b)

    260. 

  260. 				{

    261. 

  261. 					$TargetSet[$a]["obrona"] 	= $TargetSet[$a]['count'] * ($pricelist[$a]['metal'] + $pricelist[$a]['crystal']) / 10 * (1 + (0.1 * ($TargetTechno["defence_tech"])));

    262. 

  262. 					$rand 						= rand(80, 120) / 100;

    263. 

  263. 					$TargetSet[$a]["tarcza"] 	= $TargetSet[$a]['count'] * $CombatCaps[$a]['shield'] * (1 + (0.1 * $TargetTechno["shield_tech"])) * $rand;

    264. 

  264. 					$atak_statku 				= $CombatCaps[$a]['attack'];

    265. 

  265. 					$technologie 				= (1 + (0.1 * $TargetTechno["military_tech"]));

    266. 

  266. 					$rand 						= rand(80, 120) / 100;

    267. 

  267. 					$ilosc 						= $TargetSet[$a]['count'];

    268. 

  268. 					$TargetSet[$a]["atak"] 		= $ilosc * $atak_statku * $technologie * $rand;

    269. 

  269. 					$wrog_atak 					= $wrog_atak + $TargetSet[$a]["atak"];

    270. 

  270. 					$wrog_obrona 				= $wrog_obrona + $TargetSet[$a]["obrona"];

    271. 

  271. 					$wrog_ilosc 				= $wrog_ilosc + $TargetSet[$a]['count'];

    272. 

  272. 				}

    273. 

  273. 			}

    274. 

  274. 			else

    275. 

  275. 			{

    276. 

  276. 				$wrog_ilosc 						= 0;

    277. 

  277. 				$runda[$i]["atakujacy"] 			= $CurrentSet;

    278. 

  278. 				$runda[$i]["wrog"] 					= $TargetSet;

    279. 

  279. 				$runda[$i]["atakujacy"]["atak"] 	= $atakujacy_atak;

    280. 

  280. 				$runda[$i]["wrog"]["atak"] 			= $wrog_atak;

    281. 

  281. 				$runda[$i]["atakujacy"]['count'] 	= $atakujacy_ilosc;

    282. 

  282. 				$runda[$i]["wrog"]['count'] 		= $wrog_ilosc;

    283. 

  283. 				break;

    284. 

  284. 			}

    285. 

  285. 

    286. 

  286. 			$runda[$i]["atakujacy"] 			= $CurrentSet;

    287. 

  287. 			$runda[$i]["wrog"] 					= $TargetSet;

    288. 

  288. 			$runda[$i]["atakujacy"]["atak"] 	= $atakujacy_atak;

    289. 

  289. 			$runda[$i]["wrog"]["atak"] 			= $wrog_atak;

    290. 

  290. 			$runda[$i]["atakujacy"]['count']	= $atakujacy_ilosc;

    291. 

  291. 			$runda[$i]["wrog"]['count'] 		= $wrog_ilosc;

    292. 

  292. 

    293. 

  293. 			if (($atakujacy_ilosc == 0) or ($wrog_ilosc == 0))

    294. 

  294. 				break;

    295. 

  295. 

    296. 

  296. 			foreach($CurrentSet as $a => $b)

    297. 

  297. 			{

    298. 

  298. 				if ($atakujacy_ilosc > 0)

    299. 

  299. 				{

    300. 

  300. 					$wrog_moc = $CurrentSet[$a]['count'] * $wrog_atak / $atakujacy_ilosc;

    301. 

  301. 					if ($CurrentSet[$a]["tarcza"] < $wrog_moc)

    302. 

  302. 					{

    303. 

  303. 						$max_zdjac = floor($CurrentSet[$a]['count'] * $wrog_ilosc / $atakujacy_ilosc);

    304. 

  304. 						$wrog_moc = $wrog_moc - $CurrentSet[$a]["tarcza"];

    305. 

  305. 						$atakujacy_tarcza = $atakujacy_tarcza + $CurrentSet[$a]["tarcza"];

    306. 

  306. 						$ile_zdjac = floor(($wrog_moc / (($pricelist[$a]['metal'] + $pricelist[$a]['crystal']) / 10)));

    307. 

  307. 

    308. 

  308. 						if ($ile_zdjac > $max_zdjac)

    309. 

  309. 							$ile_zdjac = $max_zdjac;

    310. 

  310. 						$atakujacy_n[$a]['count'] = ceil($CurrentSet[$a]['count'] - $ile_zdjac);

    311. 

  311. 

    312. 

  312. 						if ($atakujacy_n[$a]['count'] <= 0)

    313. 

  313. 							$atakujacy_n[$a]['count'] = 0;

    314. 

  314. 					}

    315. 

  315. 					else

    316. 

  316. 					{

    317. 

  317. 						$atakujacy_n[$a]['count'] = $CurrentSet[$a]['count'];

    318. 

  318. 						$atakujacy_tarcza = $atakujacy_tarcza + $wrog_moc;

    319. 

  319. 					}

    320. 

  320. 				}

    321. 

  321. 				else

    322. 

  322. 				{

    323. 

  323. 					$atakujacy_n[$a]['count'] = $CurrentSet[$a]['count'];

    324. 

  324. 					$atakujacy_tarcza = $atakujacy_tarcza + $wrog_moc;

    325. 

  325. 				}

    326. 

  326. 			}

    327. 

  327. 

    328. 

  328. 			foreach($TargetSet as $a => $b)

    329. 

  329. 			{

    330. 

  330. 				if ($wrog_ilosc > 0)

    331. 

  331. 				{

    332. 

  332. 					$atakujacy_moc = $TargetSet[$a]['count'] * $atakujacy_atak / $wrog_ilosc;

    333. 

  333. 					if ($TargetSet[$a]["tarcza"] < $atakujacy_moc)

    334. 

  334. 					{

    335. 

  335. 						$max_zdjac = floor($TargetSet[$a]['count'] * $atakujacy_ilosc / $wrog_ilosc);

    336. 

  336. 						$atakujacy_moc = $atakujacy_moc - $TargetSet[$a]["tarcza"];

    337. 

  337. 						$wrog_tarcza = $wrog_tarcza + $TargetSet[$a]["tarcza"];

    338. 

  338. 

    339. 

  339. 						$ile_zdjac = floor(($atakujacy_moc / (($pricelist[$a]['metal'] + $pricelist[$a]['crystal']) / 10)));

    340. 

  340. 

    341. 

  341. 						if ($ile_zdjac > $max_zdjac)

    342. 

  342. 							$ile_zdjac = $max_zdjac;

    343. 

  343. 

    344. 

  344. 						$wrog_n[$a]['count'] = ceil($TargetSet[$a]['count'] - $ile_zdjac);

    345. 

  345. 

    346. 

  346. 						if ($wrog_n[$a]['count'] <= 0)

    347. 

  347. 							$wrog_n[$a]['count'] = 0;

    348. 

  348. 					}

    349. 

  349. 					else

    350. 

  350. 					{

    351. 

  351. 						$wrog_n[$a]['count'] = $TargetSet[$a]['count'];

    352. 

  352. 						$wrog_tarcza = $wrog_tarcza + $atakujacy_moc;

    353. 

  353. 					}

    354. 

  354. 				}

    355. 

  355. 				else

    356. 

  356. 				{

    357. 

  357. 					$wrog_n[$a]['count'] = $TargetSet[$a]['count'];

    358. 

  358. 					$wrog_tarcza = $wrog_tarcza + $atakujacy_moc;

    359. 

  359. 				}

    360. 

  360. 			}

    361. 

  361. 

    362. 

  362. 			foreach($CurrentSet as $a => $b)

    363. 

  363. 			{

    364. 

  364. 				foreach ($CombatCaps[$a]['sd'] as $c => $d)

    365. 

  365. 				{

    366. 

  366. 					if (isset($TargetSet[$c]))

    367. 

  367. 					{

    368. 

  368. 						$wrog_n[$c]['count'] = $wrog_n[$c]['count'] - floor($d * rand(50, 100) / 100);

    369. 

  369. 						if ($wrog_n[$c]['count'] <= 0)

    370. 

  370. 							$wrog_n[$c]['count'] = 0;

    371. 

  371. 					}

    372. 

  372. 				}

    373. 

  373. 			}

    374. 

  374. 

    375. 

  375. 			foreach($TargetSet as $a => $b)

    376. 

  376. 			{

    377. 

  377. 				foreach ($CombatCaps[$a]['sd'] as $c => $d)

    378. 

  378. 				{

    379. 

  379. 					if (isset($CurrentSet[$c]))

    380. 

  380. 					{

    381. 

  381. 						$atakujacy_n[$c]['count'] = $atakujacy_n[$c]['count'] - floor($d * rand(50, 100) / 100);

    382. 

  382. 						if ($atakujacy_n[$c]['count'] <= 0)

    383. 

  383. 							$atakujacy_n[$c]['count'] = 0;

    384. 

  384. 					}

    385. 

  385. 				}

    386. 

  386. 			}

    387. 

  387. 

    388. 

  388. 			$runda[$i]["atakujacy"]["tarcza"] 	= $atakujacy_tarcza;

    389. 

  389. 			$runda[$i]["wrog"]["tarcza"] 		= $wrog_tarcza;

    390. 

  390. 			$TargetSet 							= $wrog_n;

    391. 

  391. 			$CurrentSet 						= $atakujacy_n;

    392. 

  392. 		}

    393. 

  393. 

    394. 

  394. 		if (($atakujacy_ilosc == 0) or ($wrog_ilosc == 0))

    395. 

  395. 		{

    396. 

  396. 			if (($atakujacy_ilosc == 0) and ($wrog_ilosc == 0))

    397. 

  397. 				$wygrana = "r";

    398. 

  398. 			else

    399. 

  399. 			if ($atakujacy_ilosc == 0)

    400. 

  400. 				$wygrana = "w";

    401. 

  401. 			else

    402. 

  402. 				$wygrana = "a";

    403. 

  403. 		}

    404. 

  404. 		else

    405. 

  405. 		{

    406. 

  406. 			$i = sizeof($runda);

    407. 

  407. 			$runda[$i]["atakujacy"] = $CurrentSet;

    408. 

  408. 			$runda[$i]["wrog"] = $TargetSet;

    409. 

  409. 			$runda[$i]["atakujacy"]["atak"] = $atakujacy_atak;

    410. 

  410. 			$runda[$i]["wrog"]["atak"] = $wrog_atak;

    411. 

  411. 			$runda[$i]["atakujacy"]['count'] = $atakujacy_ilosc;

    412. 

  412. 			$runda[$i]["wrog"]['count'] = $wrog_ilosc;

    413. 

  413. 			$wygrana = "r";

    414. 

  414. 		}

    415. 

  415. 

    416. 

  416. 		$atakujacy_zlom_koniec['metal'] = 0;

    417. 

  417. 		$atakujacy_zlom_koniec['crystal'] = 0;

    418. 

  418. 		if (!is_null($CurrentSet))

    419. 

  419. 		{

    420. 

  420. 			foreach($CurrentSet as $a => $b)

    421. 

  421. 			{

    422. 

  422. 				$atakujacy_zlom_koniec['metal']   = $atakujacy_zlom_koniec['metal'] + $CurrentSet[$a]['count'] * $pricelist[$a]['metal'];

    423. 

  423. 				$atakujacy_zlom_koniec['crystal'] = $atakujacy_zlom_koniec['crystal'] + $CurrentSet[$a]['count'] * $pricelist[$a]['crystal'];

    424. 

  424. 			}

    425. 

  425. 		}

    426. 

  426. 

    427. 

  427. 		$wrog_zlom_koniec['metal'] = 0;

    428. 

  428. 		$wrog_zlom_koniec['crystal'] = 0;

    429. 

  429. 		if (!is_null($TargetSet))

    430. 

  430. 		{

    431. 

  431. 			foreach($TargetSet as $a => $b)

    432. 

  432. 			{

    433. 

  433. 				if ($a < 300)

    434. 

  434. 				{

    435. 

  435. 					$wrog_zlom_koniec['metal'] = $wrog_zlom_koniec['metal'] + $TargetSet[$a]['count'] * $pricelist[$a]['metal'];

    436. 

  436. 					$wrog_zlom_koniec['crystal'] = $wrog_zlom_koniec['crystal'] + $TargetSet[$a]['count'] * $pricelist[$a]['crystal'];

    437. 

  437. 				}

    438. 

  438. 				else

    439. 

  439. 				{

    440. 

  440. 					$wrog_zlom_koniec_obrona['metal'] = $wrog_zlom_koniec_obrona['metal'] + $TargetSet[$a]['count'] * $pricelist[$a]['metal'];

    441. 

  441. 					$wrog_zlom_koniec_obrona['crystal'] = $wrog_zlom_koniec_obrona['crystal'] + $TargetSet[$a]['count'] * $pricelist[$a]['crystal'];

    442. 

  442. 				}

    443. 

  443. 			}

    444. 

  444. 		}

    445. 

  445. 		$ilosc_wrog = 0;

    446. 

  446. 		$straty_obrona_wrog = 0;

    447. 

  447. 

    448. 

  448. 		if (!is_null($TargetSet))

    449. 

  449. 		{

    450. 

  450. 			foreach($TargetSet as $a => $b)

    451. 

  451. 			{

    452. 

  452. 				if ($a > 300)

    453. 

  453. 				{

    454. 

  454. 					$straty_obrona_wrog = $straty_obrona_wrog + (($wrog_poczatek[$a]['count'] - $TargetSet[$a]['count']) * ($pricelist[$a]['metal'] + $pricelist[$a]['crystal']));

    455. 

  455. 					$TargetSet[$a]['count'] = $TargetSet[$a]['count'] + (($wrog_poczatek[$a]['count'] - $TargetSet[$a]['count']) * rand(60, 80) / 100);

    456. 

  456. 					$ilosc_wrog = $ilosc_wrog + $TargetSet[$a]['count'];

    457. 

  457. 				}

    458. 

  458. 			}

    459. 

  459. 		}

    460. 

  460. 

    461. 

  461. 		if (($ilosc_wrog > 0) && ($atakujacy_ilosc == 0))

    462. 

  462. 			$wygrana = "w";

    463. 

  463. 

    464. 

  464. 		$game_fleet_cdr	=	read_config ( 'fleet_cdr' );

    465. 

  465. 		$game_def_cdr	=	read_config ( 'defs_cdr' );

    466. 

  466. 

    467. 

  467. 		$zlom['metal']    = ((($atakujacy_zlom_poczatek['metal']   - $atakujacy_zlom_koniec['metal'])   + ($wrog_zlom_poczatek['metal']   - $wrog_zlom_koniec['metal']))   * ($game_fleet_cdr / 100));

    468. 

  468. 		$zlom['crystal']  = ((($atakujacy_zlom_poczatek['crystal'] - $atakujacy_zlom_koniec['crystal']) + ($wrog_zlom_poczatek['crystal'] - $wrog_zlom_koniec['crystal'])) * ($game_fleet_cdr / 100));

    469. 

  469. 

    470. 

  470. 		$zlom['metal']   += ((($atakujacy_zlom_poczatek['metal']   - $atakujacy_zlom_koniec['metal'])   + ($wrog_zlom_poczatek['metal']   - $wrog_zlom_koniec['metal']))   * ($game_def_cdr / 100));

    471. 

  471. 		$zlom['crystal'] += ((($atakujacy_zlom_poczatek['crystal'] - $atakujacy_zlom_koniec['crystal']) + ($wrog_zlom_poczatek['crystal'] - $wrog_zlom_koniec['crystal'])) * ($game_def_cdr / 100));

    472. 

  472. 

    473. 

  473. 		$zlom["atakujacy"] = (($atakujacy_zlom_poczatek['metal'] - $atakujacy_zlom_koniec['metal']) + ($atakujacy_zlom_poczatek['crystal'] - $atakujacy_zlom_koniec['crystal']));

    474. 

  474. 		$zlom["wrog"]      = (($wrog_zlom_poczatek['metal']      - $wrog_zlom_koniec['metal'])      + ($wrog_zlom_poczatek['crystal']      - $wrog_zlom_koniec['crystal']) + $straty_obrona_wrog);

    475. 

  475. 

    476. 

  476. 		return array("atakujacy" => $CurrentSet, "wrog" => $TargetSet, "wygrana" => $wygrana, "dane_do_rw" => $runda, "zlom" => $zlom);

    477. 

  477. 	}

    478. 

  478. 

    479. 

  479. 	private function RestoreFleetToPlanet ($FleetRow, $Start = TRUE)

    480. 

  480. 	{

    481. 

  481. 		global $resource;

    482. 

  482. 

    483. 

  483. 		//fix resource by jstar

    484. 

  484. 		$targetPlanet = doquery("SELECT * FROM {{table}} WHERE `galaxy` = ". intval($FleetRow['fleet_start_galaxy']) ." AND `system` = ". intval($FleetRow['fleet_start_system']) ." AND `planet_type` = ". intval($FleetRow['fleet_start_type']) ." AND `planet` = ". intval($FleetRow['fleet_start_planet']) .";",'planets', TRUE);

    485. 

  485. 		$targetUser   = doquery('SELECT * FROM {{table}} WHERE id='.intval($targetPlanet['id_owner']),'users', TRUE);

    486. 

  486. 		PlanetResourceUpdate ( $targetUser, $targetPlanet, time() );

    487. 

  487. 		//

    488. 

  488. 

    489. 

  489. 		$FleetRecord         = explode(";", $FleetRow['fleet_array']);

    490. 

  490. 		$QryUpdFleet         = "";

    491. 

  491. 		foreach ($FleetRecord as $Item => $Group)

    492. 

  492. 		{

    493. 

  493. 			if ($Group != '')

    494. 

  494. 			{

    495. 

  495. 				$Class        = explode (",", $Group);

    496. 

  496. 				$QryUpdFleet .= "`". $resource[$Class[0]] ."` = `".$resource[$Class[0]]."` + '".$Class[1]."', \n";

    497. 

  497. 			}

    498. 

  498. 		}

    499. 

  499. 

    500. 

  500. 		$QryUpdatePlanet   = "UPDATE {{table}} SET ";

    501. 

  501. 		if ($QryUpdFleet != "")

    502. 

  502. 			$QryUpdatePlanet  .= $QryUpdFleet;

    503. 

  503. 

    504. 

  504. 		$QryUpdatePlanet  .= "`metal` = `metal` + '". $FleetRow['fleet_resource_metal'] ."', ";

    505. 

  505. 		$QryUpdatePlanet  .= "`crystal` = `crystal` + '". $FleetRow['fleet_resource_crystal'] ."', ";

    506. 

  506. 		$QryUpdatePlanet  .= "`deuterium` = `deuterium` + '". $FleetRow['fleet_resource_deuterium'] ."' ";

    507. 

  507. 		$QryUpdatePlanet  .= "WHERE ";

    508. 

  508. 

    509. 

  509. 		if ($Start == TRUE)

    510. 

  510. 		{

    511. 

  511. 			$QryUpdatePlanet  .= "`galaxy` = '". $FleetRow['fleet_start_galaxy'] ."' AND ";

    512. 

  512. 			$QryUpdatePlanet  .= "`system` = '". $FleetRow['fleet_start_system'] ."' AND ";

    513. 

  513. 			$QryUpdatePlanet  .= "`planet` = '". $FleetRow['fleet_start_planet'] ."' AND ";

    514. 

  514. 			$QryUpdatePlanet  .= "`planet_type` = '". $FleetRow['fleet_start_type'] ."' ";

    515. 

  515. 		}

    516. 

  516. 		else

    517. 

  517. 		{

    518. 

  518. 			$QryUpdatePlanet  .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    519. 

  519. 			$QryUpdatePlanet  .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    520. 

  520. 			$QryUpdatePlanet  .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' AND ";

    521. 

  521. 			$QryUpdatePlanet  .= "`planet_type` = '". $FleetRow['fleet_end_type'] ."' ";

    522. 

  522. 		}

    523. 

  523. 		$QryUpdatePlanet  .= "LIMIT 1;";

    524. 

  524. 		doquery( $QryUpdatePlanet, 'planets');

    525. 

  525. 	}

    526. 

  526. 

    527. 

  527. 	private function StoreGoodsToPlanet ($FleetRow, $Start = FALSE)

    528. 

  528. 	{

    529. 

  529. 

    530. 

  530. 		//fix resource by jstar

    531. 

  531. 		$targetPlanet = doquery("SELECT * FROM {{table}} WHERE `galaxy` = ". intval($FleetRow['fleet_start_galaxy']) ." AND `system` = ". intval($FleetRow['fleet_start_system']) ." AND `planet_type` = ". intval($FleetRow['fleet_start_type']) ." AND `planet` = ". intval($FleetRow['fleet_start_planet']) .";",'planets', TRUE);

    532. 

  532. 		$targetUser   = doquery('SELECT * FROM {{table}} WHERE id='.intval($targetPlanet['id_owner']),'users', TRUE);

    533. 

  533. 		PlanetResourceUpdate ( $targetUser, $targetPlanet, time() );

    534. 

  534. 		//

    535. 

  535. 

    536. 

  536. 		$QryUpdatePlanet   = "UPDATE {{table}} SET ";

    537. 

  537. 		$QryUpdatePlanet  .= "`metal` = `metal` + '". $FleetRow['fleet_resource_metal'] ."', ";

    538. 

  538. 		$QryUpdatePlanet  .= "`crystal` = `crystal` + '". $FleetRow['fleet_resource_crystal'] ."', ";

    539. 

  539. 		$QryUpdatePlanet  .= "`deuterium` = `deuterium` + '". $FleetRow['fleet_resource_deuterium'] ."' ";

    540. 

  540. 		$QryUpdatePlanet  .= "WHERE ";

    541. 

  541. 

    542. 

  542. 		if ($Start == TRUE)

    543. 

  543. 		{

    544. 

  544. 			$QryUpdatePlanet  .= "`galaxy` = '". $FleetRow['fleet_start_galaxy'] ."' AND ";

    545. 

  545. 			$QryUpdatePlanet  .= "`system` = '". $FleetRow['fleet_start_system'] ."' AND ";

    546. 

  546. 			$QryUpdatePlanet  .= "`planet` = '". $FleetRow['fleet_start_planet'] ."' AND ";

    547. 

  547. 			$QryUpdatePlanet  .= "`planet_type` = '". $FleetRow['fleet_start_type'] ."' ";

    548. 

  548. 		}

    549. 

  549. 		else

    550. 

  550. 		{

    551. 

  551. 			$QryUpdatePlanet  .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    552. 

  552. 			$QryUpdatePlanet  .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    553. 

  553. 			$QryUpdatePlanet  .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' AND ";

    554. 

  554. 			$QryUpdatePlanet  .= "`planet_type` = '". $FleetRow['fleet_end_type'] ."' ";

    555. 

  555. 		}

    556. 

  556. 

    557. 

  557. 		$QryUpdatePlanet  .= "LIMIT 1;";

    558. 

  558. 		doquery( $QryUpdatePlanet, 'planets');

    559. 

  559. 	}

    560. 

  560. 

    561. 

  561. 	private function MissionCaseAttack ($FleetRow)

    562. 

  562. 	{

    563. 

  563. 		global $pricelist, $lang, $resource, $CombatCaps, $user;

    564. 

  564. 

    565. 

  565. 		if ($FleetRow['fleet_mess'] == 0 && $FleetRow['fleet_start_time'] <= time())

    566. 

  566. 		{

    567. 

  567. 			$targetPlanet = doquery("SELECT * FROM {{table}} WHERE `galaxy` = ". intval($FleetRow['fleet_end_galaxy']) ." AND `system` = ". intval($FleetRow['fleet_end_system']) ." AND `planet_type` = ". intval($FleetRow['fleet_end_type']) ." AND `planet` = ". intval($FleetRow['fleet_end_planet']) .";",'planets', TRUE);

    568. 

  568. 

    569. 

  569. 			if ($FleetRow['fleet_group'] > 0)

    570. 

  570. 			{

    571. 

  571. 				doquery("DELETE FROM {{table}} WHERE id =".intval($FleetRow['fleet_group']),'aks');

    572. 

  572. 				doquery("UPDATE {{table}} SET fleet_mess=1 WHERE fleet_group=".$FleetRow['fleet_group'],'fleets');

    573. 

  573. 			}

    574. 

  574. 			else

    575. 

  575. 			{

    576. 

  576. 				doquery("UPDATE {{table}} SET fleet_mess=1 WHERE fleet_id=".intval($FleetRow['fleet_id']),'fleets');

    577. 

  577. 			}

    578. 

  578. 

    579. 

  579. 			$targetGalaxy = doquery('SELECT * FROM {{table}} WHERE `galaxy` = '. intval($FleetRow['fleet_end_galaxy']) .' AND `system` = '. intval($FleetRow['fleet_end_system']) .' AND `planet` = '. intval($FleetRow['fleet_end_planet']) .';','galaxy', TRUE);

    580. 

  580. 			$targetUser   = doquery('SELECT * FROM {{table}} WHERE id='.intval($targetPlanet['id_owner']),'users', TRUE);

    581. 

  581. 

    582. 

  582. 			PlanetResourceUpdate ( $targetUser, $targetPlanet, time() );

    583. 

  583. 

    584. 

  584. 			$targetGalaxy = doquery('SELECT * FROM {{table}} WHERE `galaxy` = '. intval($FleetRow['fleet_end_galaxy']) .' AND `system` = '. intval($FleetRow['fleet_end_system']) .' AND `planet` = '. intval($FleetRow['fleet_end_planet']) .';','galaxy', TRUE);

    585. 

  585. 			$targetUser   = doquery('SELECT * FROM {{table}} WHERE id='.intval($targetPlanet['id_owner']),'users', TRUE);

    586. 

  586. 

    587. 

  587. 			$TargetUserID = $targetUser['id'];

    588. 

  588. 			$attackFleets = array();

    589. 

  589. 

    590. 

  590. 			if ($FleetRow['fleet_group'] != 0)

    591. 

  591. 			{

    592. 

  592. 				$fleets = doquery('SELECT * FROM {{table}} WHERE fleet_group='.$FleetRow['fleet_group'],'fleets');

    593. 

  593. 				while ($fleet = mysql_fetch_assoc($fleets))

    594. 

  594. 				{

    595. 

  595. 					$attackFleets[$fleet['fleet_id']]['fleet'] = $fleet;

    596. 

  596. 					$attackFleets[$fleet['fleet_id']]['user'] = doquery('SELECT * FROM {{table}} WHERE id ='.intval($fleet['fleet_owner']),'users', TRUE);

    597. 

  597. 					$attackFleets[$fleet['fleet_id']]['detail'] = array();

    598. 

  598. 					$temp = explode(';', $fleet['fleet_array']);

    599. 

  599. 					foreach ($temp as $temp2)

    600. 

  600. 					{

    601. 

  601. 						$temp2 = explode(',', $temp2);

    602. 

  602. 

    603. 

  603. 						if ($temp2[0] < 100) continue;

    604. 

  604. 

    605. 

  605. 						if (!isset($attackFleets[$fleet['fleet_id']]['detail'][$temp2[0]]))

    606. 

  606. 							$attackFleets[$fleet['fleet_id']]['detail'][$temp2[0]] = 0;

    607. 

  607. 

    608. 

  608. 						$attackFleets[$fleet['fleet_id']]['detail'][$temp2[0]] += $temp2[1];

    609. 

  609. 					}

    610. 

  610. 				}

    611. 

  611. 

    612. 

  612. 			}

    613. 

  613. 			else

    614. 

  614. 			{

    615. 

  615. 				$attackFleets[$FleetRow['fleet_id']]['fleet'] = $FleetRow;

    616. 

  616. 				$attackFleets[$FleetRow['fleet_id']]['user'] = doquery('SELECT * FROM {{table}} WHERE id='.intval($FleetRow['fleet_owner']),'users', TRUE);

    617. 

  617. 				$attackFleets[$FleetRow['fleet_id']]['detail'] = array();

    618. 

  618. 				$temp = explode(';', $FleetRow['fleet_array']);

    619. 

  619. 				foreach ($temp as $temp2)

    620. 

  620. 				{

    621. 

  621. 					$temp2 = explode(',', $temp2);

    622. 

  622. 

    623. 

  623. 					if ($temp2[0] < 100) continue;

    624. 

  624. 

    625. 

  625. 					if (!isset($attackFleets[$FleetRow['fleet_id']]['detail'][$temp2[0]]))

    626. 

  626. 						$attackFleets[$FleetRow['fleet_id']]['detail'][$temp2[0]] = 0;

    627. 

  627. 

    628. 

  628. 					$attackFleets[$FleetRow['fleet_id']]['detail'][$temp2[0]] += $temp2[1];

    629. 

  629. 				}

    630. 

  630. 			}

    631. 

  631. 			$defense = array();

    632. 

  632. 

    633. 

  633. 			$def = doquery('SELECT * FROM {{table}} WHERE `fleet_end_galaxy` = '. intval($FleetRow['fleet_end_galaxy']) .' AND `fleet_end_system` = '. intval($FleetRow['fleet_end_system']) .' AND `fleet_end_type` = '. intval($FleetRow['fleet_end_type']) .' AND `fleet_end_planet` = '. intval($FleetRow['fleet_end_planet']) .' AND fleet_start_time<'.time().' AND fleet_end_stay>='.time(),'fleets');

    634. 

  634. 			while ($defRow = mysql_fetch_assoc($def))

    635. 

  635. 			{

    636. 

  636. 				$defRowDef = explode(';', $defRow['fleet_array']);

    637. 

  637. 				foreach ($defRowDef as $Element)

    638. 

  638. 				{

    639. 

  639. 					$Element = explode(',', $Element);

    640. 

  640. 

    641. 

  641. 					if ($Element[0] < 100) continue;

    642. 

  642. 

    643. 

  643. 					if (!isset($defense[$defRow['fleet_id']]['def'][$Element[0]]))

    644. 

  644. 						$defense[$defRow['fleet_id']][$Element[0]] = 0;

    645. 

  645. 

    646. 

  646. 					$defense[$defRow['fleet_id']]['def'][$Element[0]] += $Element[1];

    647. 

  647. 					$defense[$defRow['fleet_id']]['user'] = doquery('SELECT * FROM {{table}} WHERE id='.intval($defRow['fleet_owner']),'users', TRUE);

    648. 

  648. 				}

    649. 

  649. 			}

    650. 

  650. 

    651. 

  651. 			$defense[0]['def'] = array();

    652. 

  652. 			$defense[0]['user'] = $targetUser;

    653. 

  653. 			for ($i = 200; $i < 500; $i++)

    654. 

  654. 			{

    655. 

  655. 				if (isset($resource[$i]) && isset($targetPlanet[$resource[$i]]))

    656. 

  656. 				{

    657. 

  657. 					$defense[0]['def'][$i] = $targetPlanet[$resource[$i]];

    658. 

  658. 				}

    659. 

  659. 			}

    660. 

  660. 			$start 		= microtime(TRUE);

    661. 

  661. 			$result 	= calculateAttack($attackFleets, $defense);

    662. 

  662. 			$totaltime 	= microtime(TRUE) - $start;

    663. 

  663. 

    664. 

  664. 			$QryUpdateGalaxy = "UPDATE {{table}} SET ";

    665. 

  665. 			$QryUpdateGalaxy .= "`invisible_start_time` = '".time()."', ";

    666. 

  666. 			$QryUpdateGalaxy .= "`metal` = `metal` +'".($result['debree']['att'][0]+$result['debree']['def'][0]) . "', ";

    667. 

  667. 			$QryUpdateGalaxy .= "`crystal` = `crystal` + '" .($result['debree']['att'][1]+$result['debree']['def'][1]). "' ";

    668. 

  668. 			$QryUpdateGalaxy .= "WHERE ";

    669. 

  669. 			$QryUpdateGalaxy .= "`galaxy` = '" . intval($FleetRow['fleet_end_galaxy']) . "' AND ";

    670. 

  670. 			$QryUpdateGalaxy .= "`system` = '" . intval($FleetRow['fleet_end_system']) . "' AND ";

    671. 

  671. 			$QryUpdateGalaxy .= "`planet` = '" . intval($FleetRow['fleet_end_planet']) . "' ";

    672. 

  672. 			$QryUpdateGalaxy .= "LIMIT 1;";

    673. 

  673. 			doquery($QryUpdateGalaxy , 'galaxy');

    674. 

  674. 

    675. 

  675. 			$totalDebree = $result['debree']['def'][0] + $result['debree']['def'][1] + $result['debree']['att'][0] + $result['debree']['att'][1];

    676. 

  676. 

    677. 

  677. 			$steal = array('metal' => 0, 'crystal' => 0, 'deuterium' => 0);

    678. 

  678. 

    679. 

  679. 			if ($result['won'] == "a")

    680. 

  680. 			{

    681. 

  681. 				$steal = self::calculateAKSSteal($attackFleets, $targetPlanet);

    682. 

  682. 			}

    683. 

  683. 

    684. 

  684. 			foreach ($attackFleets as $fleetID => $attacker)

    685. 

  685. 			{

    686. 

  686. 				$fleetArray = '';

    687. 

  687. 				$totalCount = 0;

    688. 

  688. 				foreach ($attacker['detail'] as $element => $amount)

    689. 

  689. 				{

    690. 

  690. 					if ($amount)

    691. 

  691. 						$fleetArray .= $element.','.$amount.';';

    692. 

  692. 

    693. 

  693. 					$totalCount += $amount;

    694. 

  694. 				}

    695. 

  695. 

    696. 

  696. 				if ($totalCount <= 0)

    697. 

  697. 				{

    698. 

  698. 					doquery ('DELETE FROM {{table}} WHERE `fleet_id`='.intval($fleetID),'fleets');

    699. 

  699. 				}

    700. 

  700. 				else

    701. 

  701. 				{

    702. 

  702. 					doquery ('UPDATE {{table}} SET fleet_array="'.substr($fleetArray, 0, -1).'", fleet_amount='.$totalCount.', fleet_mess=1 WHERE fleet_id='.intval($fleetID),'fleets');

    703. 

  703. 				}

    704. 

  704. 			}

    705. 

  705. 

    706. 

  706. 			foreach ($defense as $fleetID => $defender)

    707. 

  707. 			{

    708. 

  708. 				if ($fleetID != 0)

    709. 

  709. 				{

    710. 

  710. 					$fleetArray = '';

    711. 

  711. 					$totalCount = 0;

    712. 

  712. 

    713. 

  713. 					foreach ($defender['def'] as $element => $amount)

    714. 

  714. 					{

    715. 

  715. 						if ($amount) $fleetArray .= $element.','.$amount.';';

    716. 

  716. 						$totalCount += $amount;

    717. 

  717. 					}

    718. 

  718. 

    719. 

  719. 					if ($totalCount <= 0)

    720. 

  720. 					{

    721. 

  721. 						doquery ('DELETE FROM {{table}} WHERE `fleet_id`='.intval($fleetID),'fleets');

    722. 

  722. 

    723. 

  723. 					}

    724. 

  724. 					else

    725. 

  725. 					{

    726. 

  726. 						doquery("UPDATE {{table}} SET fleet_array='$fleetArray', fleet_amount='$totalCount' WHERE fleet_id='$fleetID'",'fleets');

    727. 

  727. 					}

    728. 

  728. 

    729. 

  729. 				}

    730. 

  730. 				else

    731. 

  731. 				{

    732. 

  732. 					$fleetArray = '';

    733. 

  733. 					$totalCount = 0;

    734. 

  734. 

    735. 

  735. 					foreach ($defender['def'] as $element => $amount)

    736. 

  736. 					{

    737. 

  737. 						$fleetArray .= '`'.$resource[$element].'`='.$amount.', ';

    738. 

  738. 					}

    739. 

  739. 

    740. 

  740. 					$QryUpdateTarget  = "UPDATE {{table}} SET ";

    741. 

  741. 					$QryUpdateTarget .= $fleetArray;

    742. 

  742. 					$QryUpdateTarget .= "`metal` = `metal` - '". $steal['metal'] ."', ";

    743. 

  743. 					$QryUpdateTarget .= "`crystal` = `crystal` - '". $steal['crystal'] ."', ";

    744. 

  744. 					$QryUpdateTarget .= "`deuterium` = `deuterium` - '". $steal['deuterium'] ."' ";

    745. 

  745. 					$QryUpdateTarget .= "WHERE ";

    746. 

  746. 					$QryUpdateTarget .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    747. 

  747. 					$QryUpdateTarget .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    748. 

  748. 					$QryUpdateTarget .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' AND ";

    749. 

  749. 					$QryUpdateTarget .= "`planet_type` = '". $FleetRow['fleet_end_type'] ."' ";

    750. 

  750. 					$QryUpdateTarget .= "LIMIT 1;";

    751. 

  751. 					doquery( $QryUpdateTarget , 'planets');

    752. 

  752. 				}

    753. 

  753. 			}

    754. 

  754. 

    755. 

  755. 			$FleetDebris      = $result['debree']['att'][0] + $result['debree']['def'][0] + $result['debree']['att'][1] + $result['debree']['def'][1];

    756. 

  756. 			$StrAttackerUnits = sprintf ($lang['sys_attacker_lostunits'], $result['lost']['att']);

    757. 

  757. 			$StrDefenderUnits = sprintf ($lang['sys_defender_lostunits'], $result['lost']['def']);

    758. 

  758. 			$StrRuins         = sprintf ($lang['sys_gcdrunits'], $result['debree']['def'][0] + $result['debree']['att'][0], $lang['Metal'], $result['debree']['def'][1] + $result['debree']['att'][1], $lang['Crystal']);

    759. 

  759. 			$DebrisField      = $StrAttackerUnits ."<br />". $StrDefenderUnits ."<br />". $StrRuins;

    760. 

  760. 			$MoonChance       = $FleetDebris / 100000;

    761. 

  761. 

    762. 

  762. 			if($FleetDebris > 2000000)

    763. 

  763. 			{

    764. 

  764. 				$MoonChance = 20;

    765. 

  765. 				$UserChance = mt_rand(1, 100);

    766. 

  766. 				$ChanceMoon = sprintf ($lang['sys_moonproba'], $MoonChance);

    767. 

  767. 			}

    768. 

  768. 			elseif($FleetDebris < 100000)

    769. 

  769. 			{

    770. 

  770. 				$UserChance = 0;

    771. 

  771. 				$ChanceMoon = sprintf ($lang['sys_moonproba'], $MoonChance);

    772. 

  772. 			}

    773. 

  773. 			elseif($FleetDebris >= 100000)

    774. 

  774. 			{

    775. 

  775. 				$UserChance = mt_rand(1, 100);

    776. 

  776. 				$ChanceMoon = sprintf ($lang['sys_moonproba'], $MoonChance);

    777. 

  777. 			}

    778. 

  778. 

    779. 

  779. 			if (($UserChance > 0) && ($UserChance <= $MoonChance) && ($targetGalaxy['id_luna'] == 0))

    780. 

  780. 			{

    781. 

  781. 				$TargetPlanetName = CreateOneMoonRecord ( $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet'], $TargetUserID, $FleetRow['fleet_start_time'], '', $MoonChance );

    782. 

  782. 				$GottenMoon       = sprintf ($lang['sys_moonbuilt'], $TargetPlanetName, $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet']);

    783. 

  783. 				$GottenMoon .= "<br />";

    784. 

  784. 			}

    785. 

  785. 			elseif ($UserChance = 0 or $UserChance > $MoonChance)

    786. 

  786. 			{

    787. 

  787. 				$GottenMoon = "";

    788. 

  788. 			}

    789. 

  789. 

    790. 

  790. 			$formatted_cr 	= formatCR($result,$steal,$MoonChance,$GottenMoon,$totaltime);

    791. 

  791. 			$raport 		= $formatted_cr['html'];

    792. 

  792. 

    793. 

  793. 

    794. 

  794. 			$rid   = md5($raport);

    795. 

  795. 			$QryInsertRapport  = 'INSERT INTO {{table}} SET ';

    796. 

  796. 			$QryInsertRapport .= '`time` = UNIX_TIMESTAMP(), ';

    797. 

  797. 

    798. 

  798. 			foreach ($attackFleets as $fleetID => $attacker)

    799. 

  799. 			{

    800. 

  800. 				$users2[$attacker['user']['id']] = $attacker['user']['id'];

    801. 

  801. 			}

    802. 

  802. 

    803. 

  803. 			foreach ($defense as $fleetID => $defender)

    804. 

  804. 			{

    805. 

  805. 				$users2[$defender['user']['id']] = $defender['user']['id'];

    806. 

  806. 			}

    807. 

  807. 

    808. 

  808. 			$QryInsertRapport .= '`owners` = "'.implode(',', $users2).'", ';

    809. 

  809. 			$QryInsertRapport .= '`rid` = "'. $rid .'", ';

    810. 

  810. 			$QryInsertRapport .= '`a_zestrzelona` = "'.$formatted_cr['destroyed'].'", ';

    811. 

  811. 			$QryInsertRapport .= '`raport` = "'. mysql_escape_string( $raport ) .'"';

    812. 

  812. 			doquery($QryInsertRapport,'rw') or die("Error inserting CR to database".mysql_error()."<br /><br />Trying to execute:".mysql_query());

    813. 

  813. 

    814. 

  814. 			if($result['won'] == "a")

    815. 

  815. 			{

    816. 

  816. 				$style = "green";

    817. 

  817. 			}

    818. 

  818. 			elseif ($result['won'] == "w")

    819. 

  819. 			{

    820. 

  820. 				$style = "orange";

    821. 

  821. 			}

    822. 

  822. 			elseif ($result['won'] == "r")

    823. 

  823. 			{

    824. 

  824. 				$style = "red";

    825. 

  825. 			}

    826. 

  826. 

    827. 

  827. 			$raport  = "<a href=\"#\" style=\"color:".$style.";\" OnClick=\'f(\"CombatReport.php?raport=". $rid ."\", \"\");\' >" . $lang['sys_mess_attack_report'] ." [". $FleetRow['fleet_end_galaxy'] .":". $FleetRow['fleet_end_system'] .":". $FleetRow['fleet_end_planet'] ."]</a>";

    828. 

  828. 

    829. 

  829. 			SendSimpleMessage ( $FleetRow['fleet_owner'], '', $FleetRow['fleet_start_time'], 3, $lang['sys_mess_tower'], $raport, '' );

    830. 

  830. 

    831. 

  831. 			if($result['won'] == "a")

    832. 

  832. 			{

    833. 

  833. 				$style = "red";

    834. 

  834. 			}

    835. 

  835. 			elseif ($result['won'] == "w")

    836. 

  836. 			{

    837. 

  837. 				$style = "orange";

    838. 

  838. 			}

    839. 

  839. 			elseif ($result['won'] == "r")

    840. 

  840. 			{

    841. 

  841. 				$style = "green";

    842. 

  842. 			}

    843. 

  843. 

    844. 

  844. 			$raport2  = "<a href=\"#\" style=\"color:".$style.";\" OnClick=\'f(\"CombatReport.php?raport=". $rid ."\", \"\");\' >" . $lang['sys_mess_attack_report'] ." [". $FleetRow['fleet_end_galaxy'] .":". $FleetRow['fleet_end_system'] .":". $FleetRow['fleet_end_planet'] ."]</a>";

    845. 

  845. 

    846. 

  846. 			foreach ($users2 as $id)

    847. 

  847. 			{

    848. 

  848. 				if ($id != $FleetRow['fleet_owner'] && $id != 0)

    849. 

  849. 				{

    850. 

  850. 					SendSimpleMessage ( $id, '', $FleetRow['fleet_start_time'], 3, $lang['sys_mess_tower'], $raport2, '' );

    851. 

  851. 				}

    852. 

  852. 			}

    853. 

  853. 		}

    854. 

  854. 		elseif ($FleetRow['fleet_end_time'] <= time())

    855. 

  855. 		{

    856. 

  856. 			$Message         = sprintf( $lang['sys_fleet_won'],

    857. 

  857. 						$TargetName, GetTargetAdressLink($FleetRow, ''),

    858. 

  858. 						Format::pretty_number($FleetRow['fleet_resource_metal']), $lang['Metal'],

    859. 

  859. 						Format::pretty_number($FleetRow['fleet_resource_crystal']), $lang['Crystal'],

    860. 

  860. 						Format::pretty_number($FleetRow['fleet_resource_deuterium']), $lang['Deuterium'] );

    861. 

  861. 			SendSimpleMessage ( $FleetRow['fleet_owner'], '', $FleetRow['fleet_end_time'], 3, $lang['sys_mess_tower'], $lang['sys_mess_fleetback'], $Message);

    862. 

  862. 			$this->RestoreFleetToPlanet($FleetRow);

    863. 

  863. 			doquery ('DELETE FROM {{table}} WHERE `fleet_id`='.intval($FleetRow['fleet_id']),'fleets');

    864. 

  864. 		}

    865. 

  865. 	}

    866. 

  866. 

    867. 

  867. 	private function MissionCaseACS($FleetRow)

    868. 

  868. 	{

    869. 

  869. 		global $pricelist, $lang, $resource, $CombatCaps;

    870. 

  870. 

    871. 

  871. 		if ($FleetRow['fleet_mess'] == 0 && $FleetRow['fleet_start_time'] > time())

    872. 

  872. 		{

    873. 

  873. 			$QryUpdateFleet  = "UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = '". intval($FleetRow['fleet_id']) ."' LIMIT 1 ;";

    874. 

  874. 			doquery( $QryUpdateFleet, 'fleets');

    875. 

  875. 		}

    876. 

  876. 		elseif ($FleetRow['fleet_end_time'] <= time())

    877. 

  877. 		{

    878. 

  878. 			$this->RestoreFleetToPlanet($FleetRow);

    879. 

  879. 			doquery ('DELETE FROM {{table}} WHERE `fleet_id`='.intval($FleetRow['fleet_id']),'fleets');

    880. 

  880. 		}

    881. 

  881. 	}

    882. 

  882. 

    883. 

  883. 	private function MissionCaseTransport ( $FleetRow )

    884. 

  884. 	{

    885. 

  885. 		global $lang;

    886. 

  886. 

    887. 

  887. 		$QryStartPlanet   = "SELECT * FROM {{table}} ";

    888. 

  888. 		$QryStartPlanet  .= "WHERE ";

    889. 

  889. 		$QryStartPlanet  .= "`galaxy` = '". $FleetRow['fleet_start_galaxy'] ."' AND ";

    890. 

  890. 		$QryStartPlanet  .= "`system` = '". $FleetRow['fleet_start_system'] ."' AND ";

    891. 

  891. 		$QryStartPlanet  .= "`planet` = '". $FleetRow['fleet_start_planet'] ."' AND ";

    892. 

  892. 		$QryStartPlanet  .= "`planet_type` = '". $FleetRow['fleet_start_type'] ."';";

    893. 

  893. 		$StartPlanet      = doquery( $QryStartPlanet, 'planets', TRUE);

    894. 

  894. 		$StartName        = $StartPlanet['name'];

    895. 

  895. 		$StartOwner       = $StartPlanet['id_owner'];

    896. 

  896. 

    897. 

  897. 		$QryTargetPlanet  = "SELECT * FROM {{table}} ";

    898. 

  898. 		$QryTargetPlanet .= "WHERE ";

    899. 

  899. 		$QryTargetPlanet .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    900. 

  900. 		$QryTargetPlanet .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    901. 

  901. 		$QryTargetPlanet .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' AND ";

    902. 

  902. 		$QryTargetPlanet .= "`planet_type` = '". $FleetRow['fleet_end_type'] ."';";

    903. 

  903. 		$TargetPlanet     = doquery( $QryTargetPlanet, 'planets', TRUE);

    904. 

  904. 		$TargetName       = $TargetPlanet['name'];

    905. 

  905. 		$TargetOwner      = $TargetPlanet['id_owner'];

    906. 

  906. 

    907. 

  907. 		if ($FleetRow['fleet_mess'] == 0)

    908. 

  908. 		{

    909. 

  909. 			if ($FleetRow['fleet_start_time'] < time())

    910. 

  910. 			{

    911. 

  911. 				$this->StoreGoodsToPlanet ($FleetRow, FALSE);

    912. 

  912. 				$Message         = sprintf( $lang['sys_tran_mess_owner'],

    913. 

  913. 							$TargetName, GetTargetAdressLink($FleetRow, ''),

    914. 

  914. 							$FleetRow['fleet_resource_metal'], $lang['Metal'],

    915. 

  915. 							$FleetRow['fleet_resource_crystal'], $lang['Crystal'],

    916. 

  916. 							$FleetRow['fleet_resource_deuterium'], $lang['Deuterium'] );

    917. 

  917. 

    918. 

  918. 				SendSimpleMessage ( $StartOwner, '', $FleetRow['fleet_start_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_transport'], $Message);

    919. 

  919. 				if ($TargetOwner <> $StartOwner)

    920. 

  920. 				{

    921. 

  921. 					$Message         = sprintf( $lang['sys_tran_mess_user'],

    922. 

  922. 									$StartName, GetStartAdressLink($FleetRow, ''),

    923. 

  923. 									$TargetName, GetTargetAdressLink($FleetRow, ''),

    924. 

  924. 									$FleetRow['fleet_resource_metal'], $lang['Metal'],

    925. 

  925. 									$FleetRow['fleet_resource_crystal'], $lang['Crystal'],

    926. 

  926. 									$FleetRow['fleet_resource_deuterium'], $lang['Deuterium'] );

    927. 

  927. 					SendSimpleMessage ( $TargetOwner, '', $FleetRow['fleet_start_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_transport'], $Message);

    928. 

  928. 				}

    929. 

  929. 

    930. 

  930. 				$QryUpdateFleet  = "UPDATE {{table}} SET ";

    931. 

  931. 				$QryUpdateFleet .= "`fleet_resource_metal` = '0' , ";

    932. 

  932. 				$QryUpdateFleet .= "`fleet_resource_crystal` = '0' , ";

    933. 

  933. 				$QryUpdateFleet .= "`fleet_resource_deuterium` = '0' , ";

    934. 

  934. 				$QryUpdateFleet .= "`fleet_mess` = '1' ";

    935. 

  935. 				$QryUpdateFleet .= "WHERE `fleet_id` = '". intval($FleetRow['fleet_id']) ."' ";

    936. 

  936. 				$QryUpdateFleet .= "LIMIT 1 ;";

    937. 

  937. 				doquery( $QryUpdateFleet, 'fleets');

    938. 

  938. 			}

    939. 

  939. 		}

    940. 

  940. 		else

    941. 

  941. 		{

    942. 

  942. 			if ($FleetRow['fleet_end_time'] < time())

    943. 

  943. 			{

    944. 

  944. 				$Message             = sprintf ($lang['sys_tran_mess_back'], $StartName, GetStartAdressLink($FleetRow, ''));

    945. 

  945. 				SendSimpleMessage ( $StartOwner, '', $FleetRow['fleet_end_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_fleetback'], $Message);

    946. 

  946. 				$this->RestoreFleetToPlanet ( $FleetRow, TRUE );

    947. 

  947. 				doquery("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');

    948. 

  948. 			}

    949. 

  949. 		}

    950. 

  950. 	}

    951. 

  951. 

    952. 

  952. 	private function MissionCaseStay($FleetRow)

    953. 

  953. 	{

    954. 

  954. 		global $lang, $resource;

    955. 

  955. 

    956. 

  956. 		if ($FleetRow['fleet_mess'] == 0)

    957. 

  957. 		{

    958. 

  958. 			if ($FleetRow['fleet_start_time'] <= time())

    959. 

  959. 			{

    960. 

  960. 				$QryGetTargetPlanet   = "SELECT * FROM {{table}} ";

    961. 

  961. 				$QryGetTargetPlanet  .= "WHERE ";

    962. 

  962. 				$QryGetTargetPlanet  .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    963. 

  963. 				$QryGetTargetPlanet  .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    964. 

  964. 				$QryGetTargetPlanet  .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' AND ";

    965. 

  965. 				$QryGetTargetPlanet  .= "`planet_type` = '". $FleetRow['fleet_end_type'] ."';";

    966. 

  966. 				$TargetPlanet         = doquery( $QryGetTargetPlanet, 'planets', TRUE);

    967. 

  967. 				$TargetUserID         = $TargetPlanet['id_owner'];

    968. 

  968. 

    969. 

  969. 				$TargetAdress         = sprintf ($lang['sys_adress_planet'], $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet']);

    970. 

  970. 				$TargetAddedGoods     = sprintf ($lang['sys_stay_mess_goods'],

    971. 

  971. 				$lang['Metal'], Format::pretty_number($FleetRow['fleet_resource_metal']),

    972. 

  972. 				$lang['Crystal'], Format::pretty_number($FleetRow['fleet_resource_crystal']),

    973. 

  973. 				$lang['Deuterium'], Format::pretty_number($FleetRow['fleet_resource_deuterium']));

    974. 

  974. 

    975. 

  975. 				$TargetMessage        = $lang['sys_stay_mess_start'] ."<a href=\"game.php?page=galaxy&mode=3&galaxy=". $FleetRow['fleet_end_galaxy'] ."&system=". $FleetRow['fleet_end_system'] ."\">";

    976. 

  976. 				$TargetMessage       .= $TargetAdress. "</a>". $lang['sys_stay_mess_end'] ."<br />". $TargetAddedGoods;

    977. 

  977. 

    978. 

  978. 				SendSimpleMessage ( $TargetUserID, '', $FleetRow['fleet_start_time'], 5, $lang['sys_mess_qg'], $lang['sys_stay_mess_stay'], $TargetMessage);

    979. 

  979. 				$this->RestoreFleetToPlanet ( $FleetRow, FALSE );

    980. 

  980. 				doquery("DELETE FROM {{table}} WHERE `fleet_id` = '". $FleetRow["fleet_id"] ."';", 'fleets');

    981. 

  981. 			}

    982. 

  982. 		}

    983. 

  983. 		else

    984. 

  984. 		{

    985. 

  985. 			if ($FleetRow['fleet_end_time'] <= time())

    986. 

  986. 			{

    987. 

  987. 				$TargetAdress         = sprintf ($lang['sys_adress_planet'], $FleetRow['fleet_start_galaxy'], $FleetRow['fleet_start_system'], $FleetRow['fleet_start_planet']);

    988. 

  988. 				$TargetAddedGoods     = sprintf ($lang['sys_stay_mess_goods'],

    989. 

  989. 				$lang['Metal'], Format::pretty_number($FleetRow['fleet_resource_metal']),

    990. 

  990. 				$lang['Crystal'], Format::pretty_number($FleetRow['fleet_resource_crystal']),

    991. 

  991. 				$lang['Deuterium'], Format::pretty_number($FleetRow['fleet_resource_deuterium']));

    992. 

  992. 

    993. 

  993. 				$TargetMessage        = $lang['sys_stay_mess_back'] ."<a href=\"game.php?page=galaxy&mode=3&galaxy=". $FleetRow['fleet_start_galaxy'] ."&system=". $FleetRow['fleet_start_system'] ."\">";

    994. 

  994. 				$TargetMessage       .= $TargetAdress. "</a>". $lang['sys_stay_mess_bend'] ."<br />". $TargetAddedGoods;

    995. 

  995. 

    996. 

  996. 				SendSimpleMessage ( $FleetRow['fleet_owner'], '', $FleetRow['fleet_end_time'], 5, $lang['sys_mess_qg'], $lang['sys_mess_fleetback'], $TargetMessage);

    997. 

  997. 				$this->RestoreFleetToPlanet ( $FleetRow, TRUE );

    998. 

  998. 				doquery("DELETE FROM {{table}} WHERE `fleet_id` = '". $FleetRow["fleet_id"] ."';", 'fleets');

    999. 

  999. 			}

    1000. 

  1000. 		}

    1001. 

  1001. 	}

    1002. 

  1002. 

    1003. 

  1003. 	private function MissionCaseStayAlly($FleetRow)

    1004. 

  1004. 	{

    1005. 

  1005. 		global $lang;

    1006. 

  1006. 

    1007. 

  1007. 		$QryStartPlanet   = "SELECT * FROM {{table}} ";

    1008. 

  1008. 		$QryStartPlanet  .= "WHERE ";

    1009. 

  1009. 		$QryStartPlanet  .= "`galaxy` = '". $FleetRow['fleet_start_galaxy'] ."' AND ";

    1010. 

  1010. 		$QryStartPlanet  .= "`system` = '". $FleetRow['fleet_start_system'] ."' AND ";

    1011. 

  1011. 		$QryStartPlanet  .= "`planet` = '". $FleetRow['fleet_start_planet'] ."';";

    1012. 

  1012. 		$StartPlanet      = doquery( $QryStartPlanet, 'planets', TRUE);

    1013. 

  1013. 		$StartName        = $StartPlanet['name'];

    1014. 

  1014. 		$StartOwner       = $StartPlanet['id_owner'];

    1015. 

  1015. 

    1016. 

  1016. 		$QryTargetPlanet  = "SELECT * FROM {{table}} ";

    1017. 

  1017. 		$QryTargetPlanet .= "WHERE ";

    1018. 

  1018. 		$QryTargetPlanet .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    1019. 

  1019. 		$QryTargetPlanet .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    1020. 

  1020. 		$QryTargetPlanet .= "`planet` = '". $FleetRow['fleet_end_planet'] ."';";

    1021. 

  1021. 		$TargetPlanet     = doquery( $QryTargetPlanet, 'planets', TRUE);

    1022. 

  1022. 		$TargetName       = $TargetPlanet['name'];

    1023. 

  1023. 		$TargetOwner      = $TargetPlanet['id_owner'];

    1024. 

  1024. 

    1025. 

  1025. 		if ($FleetRow['fleet_mess'] == 0)

    1026. 

  1026. 		{

    1027. 

  1027. 			if ($FleetRow['fleet_start_time'] <= time())

    1028. 

  1028. 			{

    1029. 

  1029. 				$Message = sprintf($lang['sys_tran_mess_owner'], $TargetName, GetTargetAdressLink($FleetRow, ''),

    1030. 

  1030. 					$FleetRow['fleet_resource_metal'], $lang['Metal'],

    1031. 

  1031. 					$FleetRow['fleet_resource_crystal'], $lang['Crystal'],

    1032. 

  1032. 					$FleetRow['fleet_resource_deuterium'], $lang['Deuterium'] );

    1033. 

  1033. 

    1034. 

  1034. 				SendSimpleMessage ($StartOwner, '',$FleetRow['fleet_start_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_transport'], $Message);

    1035. 

  1035. 

    1036. 

  1036. 				$Message = sprintf( $lang['sys_tran_mess_user'], $StartName, GetStartAdressLink($FleetRow, ''),

    1037. 

  1037. 					$TargetName, GetTargetAdressLink($FleetRow, ''),

    1038. 

  1038. 					$FleetRow['fleet_resource_metal'], $lang['Metal'],

    1039. 

  1039. 					$FleetRow['fleet_resource_crystal'], $lang['Crystal'],

    1040. 

  1040. 					$FleetRow['fleet_resource_deuterium'], $lang['Deuterium'] );

    1041. 

  1041. 

    1042. 

  1042. 				SendSimpleMessage ($TargetOwner, '',$FleetRow['fleet_start_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_transport'], $Message);

    1043. 

  1043. 

    1044. 

  1044. 				$QryUpdateFleet  = "UPDATE {{table}} SET ";

    1045. 

  1045. 				$QryUpdateFleet .= "`fleet_mess` = 2 ";

    1046. 

  1046. 				$QryUpdateFleet .= "WHERE `fleet_id` = '". intval($FleetRow['fleet_id']) ."' ";

    1047. 

  1047. 				$QryUpdateFleet .= "LIMIT 1 ;";

    1048. 

  1048. 				doquery( $QryUpdateFleet, 'fleets');

    1049. 

  1049. 

    1050. 

  1050. 			}

    1051. 

  1051. 			elseif($FleetRow['fleet_end_stay'] <= time())

    1052. 

  1052. 			{

    1053. 

  1053. 				$QryUpdateFleet  = "UPDATE {{table}} SET ";

    1054. 

  1054. 				$QryUpdateFleet .= "`fleet_mess` = 1 ";

    1055. 

  1055. 				$QryUpdateFleet .= "WHERE `fleet_id` = '". intval($FleetRow['fleet_id']) ."' ";

    1056. 

  1056. 				$QryUpdateFleet .= "LIMIT 1 ;";

    1057. 

  1057. 				doquery( $QryUpdateFleet, 'fleets');

    1058. 

  1058. 			}

    1059. 

  1059. 		}

    1060. 

  1060. 		else

    1061. 

  1061. 		{

    1062. 

  1062. 			if ($FleetRow['fleet_end_time'] < time())

    1063. 

  1063. 			{

    1064. 

  1064. 				$Message         = sprintf ($lang['sys_tran_mess_back'], $StartName, GetStartAdressLink($FleetRow, ''));

    1065. 

  1065. 				SendSimpleMessage ( $StartOwner, '', $FleetRow['fleet_end_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_fleetback'], $Message);

    1066. 

  1066. 				$this->RestoreFleetToPlanet ( $FleetRow, TRUE );

    1067. 

  1067. 				doquery("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');

    1068. 

  1068. 			}

    1069. 

  1069. 		}

    1070. 

  1070. 	}

    1071. 

  1071. 

    1072. 

  1072. 	private function MissionCaseSpy($FleetRow)

    1073. 

  1073. 	{

    1074. 

  1074. 		global $lang, $resource;

    1075. 

  1075. 

    1076. 

  1076. 		if ($FleetRow['fleet_start_time'] <= time())

    1077. 

  1077. 		{

    1078. 

  1078. 			$CurrentUser         = doquery("SELECT * FROM {{table}} WHERE `id` = '".$FleetRow['fleet_owner']."';", 'users', TRUE);

    1079. 

  1079. 			$CurrentUserID       = $FleetRow['fleet_owner'];

    1080. 

  1080. 			$QryGetTargetPlanet  = "SELECT * FROM {{table}} ";

    1081. 

  1081. 			$QryGetTargetPlanet .= "WHERE ";

    1082. 

  1082. 			$QryGetTargetPlanet .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    1083. 

  1083. 			$QryGetTargetPlanet .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    1084. 

  1084. 			$QryGetTargetPlanet .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' AND ";

    1085. 

  1085. 			$QryGetTargetPlanet .= "`planet_type` = '". $FleetRow['fleet_end_type'] ."';";

    1086. 

  1086. 			$TargetPlanet        = doquery( $QryGetTargetPlanet, 'planets', TRUE);

    1087. 

  1087. 			$TargetUserID        = $TargetPlanet['id_owner'];

    1088. 

  1088. 			$CurrentPlanet       = doquery("SELECT * FROM {{table}} WHERE `galaxy` = '".$FleetRow['fleet_start_galaxy']."' AND `system` = '".$FleetRow['fleet_start_system']."' AND `planet` = '".$FleetRow['fleet_start_planet']."';", 'planets', TRUE);

    1089. 

  1089. 			$CurrentSpyLvl       = $CurrentUser['spy_tech'] + ($CurrentUser['rpg_technocrate'] * TECHNOCRATE_SPY);

    1090. 

  1090. 			$TargetUser          = doquery("SELECT * FROM {{table}} WHERE `id` = '".$TargetUserID."';", 'users', TRUE);

    1091. 

  1091. 			$TargetSpyLvl        = $TargetUser['spy_tech'] + ($TargetUser['rpg_technocrate'] * TECHNOCRATE_SPY);

    1092. 

  1092. 			$fleet               = explode(";", $FleetRow['fleet_array']);

    1093. 

  1093. 			$fquery              = "";

    1094. 

  1094. 

    1095. 

  1095. 			PlanetResourceUpdate ( $TargetUser, $TargetPlanet, time() );

    1096. 

  1096. 

    1097. 

  1097. 			foreach ($fleet as $a => $b)

    1098. 

  1098. 			{

    1099. 

  1099. 				if ($b != '')

    1100. 

  1100. 				{

    1101. 

  1101. 					$a = explode(",", $b);

    1102. 

  1102. 					$fquery .= "{$resource[$a[0]]}={$resource[$a[0]]} + {$a[1]}, \n";

    1103. 

  1103. 					if ($FleetRow["fleet_mess"] != "1" && $a[0] == "210")

    1104. 

  1104. 					{

    1105. 

  1105. 						$LS    = $a[1];

    1106. 

  1106. 						$QryTargetGalaxy  = "SELECT * FROM {{table}} WHERE ";

    1107. 

  1107. 						$QryTargetGalaxy .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    1108. 

  1108. 						$QryTargetGalaxy .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    1109. 

  1109. 						$QryTargetGalaxy .= "`planet` = '". $FleetRow['fleet_end_planet'] ."';";

    1110. 

  1110. 						$TargetGalaxy     = doquery( $QryTargetGalaxy, 'galaxy', TRUE);

    1111. 

  1111. 						$CristalDebris    = $TargetGalaxy['crystal'];

    1112. 

  1112. 						$SpyToolDebris    = $LS * 300;

    1113. 

  1113. 

    1114. 

  1114. 						$MaterialsInfo    = $this->SpyTarget ( $TargetPlanet, 0, $lang['sys_spy_maretials'] );

    1115. 

  1115. 						$Materials        = $MaterialsInfo['String'];

    1116. 

  1116. 

    1117. 

  1117. 						$PlanetFleetInfo  = $this->SpyTarget ( $TargetPlanet, 1, $lang['sys_spy_fleet'] );

    1118. 

  1118. 						$PlanetFleet      = $Materials;

    1119. 

  1119. 						$PlanetFleet     .= $PlanetFleetInfo['String'];

    1120. 

  1120. 

    1121. 

  1121. 						$PlanetDefenInfo  = $this->SpyTarget ( $TargetPlanet, 2, $lang['sys_spy_defenses'] );

    1122. 

  1122. 						$PlanetDefense    = $PlanetFleet;

    1123. 

  1123. 						$PlanetDefense   .= $PlanetDefenInfo['String'];

    1124. 

  1124. 

    1125. 

  1125. 						$PlanetBuildInfo  = $this->SpyTarget ( $TargetPlanet, 3, $lang['tech'][0] );

    1126. 

  1126. 						$PlanetBuildings  = $PlanetDefense;

    1127. 

  1127. 						$PlanetBuildings .= $PlanetBuildInfo['String'];

    1128. 

  1128. 

    1129. 

  1129. 						$TargetTechnInfo  = $this->SpyTarget ( $TargetUser, 4, $lang['tech'][100] );

    1130. 

  1130. 						$TargetTechnos    = $PlanetBuildings;

    1131. 

  1131. 						$TargetTechnos   .= $TargetTechnInfo['String'];

    1132. 

  1132. 

    1133. 

  1133. 						$TargetForce      = ($PlanetFleetInfo['Count'] * $LS) / 4;

    1134. 

  1134. 

    1135. 

  1135. 						if ($TargetForce > 100)

    1136. 

  1136. 							$TargetForce = 100;

    1137. 

  1137. 

    1138. 

  1138. 						$TargetChances = rand(0, $TargetForce);

    1139. 

  1139. 						$SpyerChances  = rand(0, 100);

    1140. 

  1140. 

    1141. 

  1141. 						if ($TargetChances >= $SpyerChances)

    1142. 

  1142. 							$DestProba = "<font color=\"red\">".$lang['sys_mess_spy_destroyed']."</font>";

    1143. 

  1143. 						elseif ($TargetChances < $SpyerChances)

    1144. 

  1144. 							$DestProba = sprintf( $lang['sys_mess_spy_lostproba'], $TargetChances);

    1145. 

  1145. 

    1146. 

  1146. 						$AttackLink = "<center>";

    1147. 

  1147. 						$AttackLink .= "<a href=\"game.php?page=fleet&galaxy=". $FleetRow['fleet_end_galaxy'] ."&system=". $FleetRow['fleet_end_system'] ."";

    1148. 

  1148. 						$AttackLink .= "&planet=".$FleetRow['fleet_end_planet']."&planettype=".$FleetRow['fleet_end_type']."";

    1149. 

  1149. 						$AttackLink .= "&target_mission=1";

    1150. 

  1150. 						$AttackLink .= " \">". $lang['type_mission'][1] ."";

    1151. 

  1151. 						$AttackLink .= "</a></center>";

    1152. 

  1152. 						$MessageEnd  = "<center>".$DestProba."</center>";

    1153. 

  1153. 

    1154. 

  1154. 						$pT = ($TargetSpyLvl - $CurrentSpyLvl);

    1155. 

  1155. 						$pW = ($CurrentSpyLvl - $TargetSpyLvl);

    1156. 

  1156. 						if ($TargetSpyLvl > $CurrentSpyLvl)

    1157. 

  1157. 							$ST = ($LS - pow($pT, 2));

    1158. 

  1158. 						if ($CurrentSpyLvl > $TargetSpyLvl)

    1159. 

  1159. 							$ST = ($LS + pow($pW, 2));

    1160. 

  1160. 						if ($TargetSpyLvl == $CurrentSpyLvl)

    1161. 

  1161. 							$ST = $CurrentSpyLvl;

    1162. 

  1162. 						if ($ST <= "1")

    1163. 

  1163. 							$SpyMessage = $Materials."<br />".$AttackLink.$MessageEnd;

    1164. 

  1164. 						if ($ST == "2")

    1165. 

  1165. 							$SpyMessage = $PlanetFleet."<br />".$AttackLink.$MessageEnd;

    1166. 

  1166. 						if ($ST == "4" or $ST == "3")

    1167. 

  1167. 							$SpyMessage = $PlanetDefense."<br />".$AttackLink.$MessageEnd;

    1168. 

  1168. 						if ($ST == "5" or $ST == "6")

    1169. 

  1169. 							$SpyMessage = $PlanetBuildings."<br />".$AttackLink.$MessageEnd;

    1170. 

  1170. 						if ($ST >= "7")

    1171. 

  1171. 							$SpyMessage = $TargetTechnos."<br />".$AttackLink.$MessageEnd;

    1172. 

  1172. 

    1173. 

  1173. 						SendSimpleMessage ( $CurrentUserID, '', $FleetRow['fleet_start_time'], 0, $lang['sys_mess_qg'], $lang['sys_mess_spy_report'], $SpyMessage);

    1174. 

  1174. 

    1175. 

  1175. 						$TargetMessage  = $lang['sys_mess_spy_ennemyfleet'] ." ". $CurrentPlanet['name'];

    1176. 

  1176. 

    1177. 

  1177. 						if($FleetRow['fleet_start_type'] == 3)

    1178. 

  1178. 							$TargetMessage .= $lang['sys_mess_spy_report_moon'] . " ";

    1179. 

  1179. 

    1180. 

  1180. 						$TargetMessage .= "<a href=\"game.php?page=galaxy&mode=3&galaxy=". $CurrentPlanet["galaxy"] ."&system=". $CurrentPlanet["system"] ."\">";

    1181. 

  1181. 						$TargetMessage .= "[". $CurrentPlanet["galaxy"] .":". $CurrentPlanet["system"] .":". $CurrentPlanet["planet"] ."]</a> ";

    1182. 

  1182. 						$TargetMessage .= $lang['sys_mess_spy_seen_at'] ." ". $TargetPlanet['name'];

    1183. 

  1183. 						$TargetMessage .= " [". $TargetPlanet["galaxy"] .":". $TargetPlanet["system"] .":". $TargetPlanet["planet"] ."].";

    1184. 

  1184. 

    1185. 

  1185. 						SendSimpleMessage ( $TargetUserID, '', $FleetRow['fleet_start_time'], 0, $lang['sys_mess_spy_control'], $lang['sys_mess_spy_activity'], $TargetMessage);

    1186. 

  1186. 

    1187. 

  1187. 						if ($TargetChances >= $SpyerChances)

    1188. 

  1188. 						{

    1189. 

  1189. 							$QryUpdateGalaxy  = "UPDATE {{table}} SET ";

    1190. 

  1190. 							$QryUpdateGalaxy .= "`invisible_start_time` = '".time()."', ";

    1191. 

  1191. 							$QryUpdateGalaxy .= "`crystal` = `crystal` + '". (0 + $SpyToolDebris) ."' ";

    1192. 

  1192. 							$QryUpdateGalaxy .= "WHERE `id_planet` = '". $TargetPlanet['id'] ."';";

    1193. 

  1193. 							doquery( $QryUpdateGalaxy, 'galaxy');

    1194. 

  1194. 							doquery("DELETE FROM {{table}} WHERE `fleet_id` = '". $FleetRow["fleet_id"] ."';", 'fleets');

    1195. 

  1195. 						}

    1196. 

  1196. 						else

    1197. 

  1197. 							doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = '". $FleetRow["fleet_id"] ."';", 'fleets');

    1198. 

  1198. 					}

    1199. 

  1199. 				}

    1200. 

  1200. 				else

    1201. 

  1201. 				{

    1202. 

  1202. 					if ($FleetRow['fleet_end_time'] <= time())

    1203. 

  1203. 					{

    1204. 

  1204. 						$this->RestoreFleetToPlanet ( $FleetRow, TRUE );

    1205. 

  1205. 						doquery("DELETE FROM {{table}} WHERE `fleet_id` = ". $FleetRow["fleet_id"], 'fleets');

    1206. 

  1206. 					}

    1207. 

  1207. 				}

    1208. 

  1208. 			}

    1209. 

  1209. 		}

    1210. 

  1210. 	}

    1211. 

  1211. 

    1212. 

  1212. 	private function MissionCaseRecycling ($FleetRow)

    1213. 

  1213. 	{

    1214. 

  1214. 		global $pricelist, $lang;

    1215. 

  1215. 

    1216. 

  1216. 		if ($FleetRow["fleet_mess"] == "0")

    1217. 

  1217. 		{

    1218. 

  1218. 			if ($FleetRow['fleet_start_time'] <= time())

    1219. 

  1219. 			{

    1220. 

  1220. 				$QrySelectGalaxy  = "SELECT * FROM {{table}} ";

    1221. 

  1221. 				$QrySelectGalaxy .= "WHERE ";

    1222. 

  1222. 				$QrySelectGalaxy .= "`galaxy` = '".$FleetRow['fleet_end_galaxy']."' AND ";

    1223. 

  1223. 				$QrySelectGalaxy .= "`system` = '".$FleetRow['fleet_end_system']."' AND ";

    1224. 

  1224. 				$QrySelectGalaxy .= "`planet` = '".$FleetRow['fleet_end_planet']."' ";

    1225. 

  1225. 				$QrySelectGalaxy .= "LIMIT 1;";

    1226. 

  1226. 				$TargetGalaxy     = doquery( $QrySelectGalaxy, 'galaxy', TRUE);

    1227. 

  1227. 

    1228. 

  1228. 				$FleetRecord         = explode(";", $FleetRow['fleet_array']);

    1229. 

  1229. 				$RecyclerCapacity    = 0;

    1230. 

  1230. 				$OtherFleetCapacity  = 0;

    1231. 

  1231. 				foreach ($FleetRecord as $Item => $Group)

    1232. 

  1232. 				{

    1233. 

  1233. 					if ($Group != '')

    1234. 

  1234. 					{

    1235. 

  1235. 						$Class        = explode (",", $Group);

    1236. 

  1236. 						if ($Class[0] == 209)

    1237. 

  1237. 							$RecyclerCapacity   += $pricelist[$Class[0]]["capacity"] * $Class[1];

    1238. 

  1238. 						else

    1239. 

  1239. 							$OtherFleetCapacity += $pricelist[$Class[0]]["capacity"] * $Class[1];

    1240. 

  1240. 					}

    1241. 

  1241. 				}

    1242. 

  1242. 

    1243. 

  1243. 				$IncomingFleetGoods = $FleetRow["fleet_resource_metal"] + $FleetRow["fleet_resource_crystal"] + $FleetRow["fleet_resource_deuterium"];

    1244. 

  1244. 				if ($IncomingFleetGoods > $OtherFleetCapacity)

    1245. 

  1245. 					$RecyclerCapacity -= ($IncomingFleetGoods - $OtherFleetCapacity);

    1246. 

  1246. 

    1247. 

  1247. 				if (($TargetGalaxy["metal"] + $TargetGalaxy["crystal"]) <= $RecyclerCapacity)

    1248. 

  1248. 				{

    1249. 

  1249. 					$RecycledGoods["metal"]   = $TargetGalaxy["metal"];

    1250. 

  1250. 					$RecycledGoods["crystal"] = $TargetGalaxy["crystal"];

    1251. 

  1251. 				}

    1252. 

  1252. 				else

    1253. 

  1253. 				{

    1254. 

  1254. 					if (($TargetGalaxy["metal"]   > $RecyclerCapacity / 2) && ($TargetGalaxy["crystal"] > $RecyclerCapacity / 2))

    1255. 

  1255. 					{

    1256. 

  1256. 						$RecycledGoods["metal"]   = $RecyclerCapacity / 2;

    1257. 

  1257. 						$RecycledGoods["crystal"] = $RecyclerCapacity / 2;

    1258. 

  1258. 					}

    1259. 

  1259. 					else

    1260. 

  1260. 					{

    1261. 

  1261. 						if ($TargetGalaxy["metal"] > $TargetGalaxy["crystal"])

    1262. 

  1262. 						{

    1263. 

  1263. 							$RecycledGoods["crystal"] = $TargetGalaxy["crystal"];

    1264. 

  1264. 							if ($TargetGalaxy["metal"] > ($RecyclerCapacity - $RecycledGoods["crystal"]))

    1265. 

  1265. 								$RecycledGoods["metal"] = $RecyclerCapacity - $RecycledGoods["crystal"];

    1266. 

  1266. 							else

    1267. 

  1267. 								$RecycledGoods["metal"] = $TargetGalaxy["metal"];

    1268. 

  1268. 						}

    1269. 

  1269. 						else

    1270. 

  1270. 						{

    1271. 

  1271. 							$RecycledGoods["metal"] = $TargetGalaxy["metal"];

    1272. 

  1272. 							if ($TargetGalaxy["crystal"] > ($RecyclerCapacity - $RecycledGoods["metal"]))

    1273. 

  1273. 								$RecycledGoods["crystal"] = $RecyclerCapacity - $RecycledGoods["metal"];

    1274. 

  1274. 							else

    1275. 

  1275. 								$RecycledGoods["crystal"] = $TargetGalaxy["crystal"];

    1276. 

  1276. 						}

    1277. 

  1277. 					}

    1278. 

  1278. 				}

    1279. 

  1279. 

    1280. 

  1280. 				$QryUpdateGalaxy  = "UPDATE {{table}} SET ";

    1281. 

  1281. 				$QryUpdateGalaxy .= "`metal` = `metal` - '".$RecycledGoods["metal"]."', ";

    1282. 

  1282. 				$QryUpdateGalaxy .= "`crystal` = `crystal` - '".$RecycledGoods["crystal"]."' ";

    1283. 

  1283. 				$QryUpdateGalaxy .= "WHERE ";

    1284. 

  1284. 				$QryUpdateGalaxy .= "`galaxy` = '".$FleetRow['fleet_end_galaxy']."' AND ";

    1285. 

  1285. 				$QryUpdateGalaxy .= "`system` = '".$FleetRow['fleet_end_system']."' AND ";

    1286. 

  1286. 				$QryUpdateGalaxy .= "`planet` = '".$FleetRow['fleet_end_planet']."' ";

    1287. 

  1287. 				$QryUpdateGalaxy .= "LIMIT 1;";

    1288. 

  1288. 				doquery( $QryUpdateGalaxy, 'galaxy');

    1289. 

  1289. 

    1290. 

  1290. 				$Message = sprintf($lang['sys_recy_gotten'], Format::pretty_number($RecycledGoods["metal"]), $lang['Metal'], Format::pretty_number($RecycledGoods["crystal"]), $lang['Crystal']);

    1291. 

  1291. 				SendSimpleMessage ( $FleetRow['fleet_owner'], '', $FleetRow['fleet_start_time'], 4, $lang['sys_mess_spy_control'], $lang['sys_recy_report'], $Message);

    1292. 

  1292. 

    1293. 

  1293. 				$QryUpdateFleet  = "UPDATE {{table}} SET ";

    1294. 

  1294. 				$QryUpdateFleet .= "`fleet_resource_metal` = `fleet_resource_metal` + '".$RecycledGoods["metal"]."', ";

    1295. 

  1295. 				$QryUpdateFleet .= "`fleet_resource_crystal` = `fleet_resource_crystal` + '".$RecycledGoods["crystal"]."', ";

    1296. 

  1296. 				$QryUpdateFleet .= "`fleet_mess` = '1' ";

    1297. 

  1297. 				$QryUpdateFleet .= "WHERE ";

    1298. 

  1298. 				$QryUpdateFleet .= "`fleet_id` = '".intval($FleetRow['fleet_id'])."' ";

    1299. 

  1299. 				$QryUpdateFleet .= "LIMIT 1;";

    1300. 

  1300. 				doquery( $QryUpdateFleet, 'fleets');

    1301. 

  1301. 			}

    1302. 

  1302. 		}

    1303. 

  1303. 		else

    1304. 

  1304. 		{

    1305. 

  1305. 			if ($FleetRow['fleet_end_time'] <= time())

    1306. 

  1306. 			{

    1307. 

  1307. 				$Message         = sprintf( $lang['sys_tran_mess_owner'],

    1308. 

  1308. 				$TargetName, GetTargetAdressLink($FleetRow, ''),

    1309. 

  1309. 				Format::pretty_number($FleetRow['fleet_resource_metal']), $lang['Metal'],

    1310. 

  1310. 				Format::pretty_number($FleetRow['fleet_resource_crystal']), $lang['Crystal'],

    1311. 

  1311. 				Format::pretty_number($FleetRow['fleet_resource_deuterium']), $lang['Deuterium'] );

    1312. 

  1312. 				SendSimpleMessage ( $FleetRow['fleet_owner'], '', $FleetRow['fleet_end_time'], 4, $lang['sys_mess_spy_control'], $lang['sys_mess_fleetback'], $Message);

    1313. 

  1313. 				$this->RestoreFleetToPlanet ( $FleetRow, TRUE );

    1314. 

  1314. 				doquery("DELETE FROM {{table}} WHERE `fleet_id` = '". $FleetRow["fleet_id"] ."';", 'fleets');

    1315. 

  1315. 			}

    1316. 

  1316. 		}

    1317. 

  1317. 	}

    1318. 

  1318. 

    1319. 

  1319. 	private function MissionCaseColonisation($FleetRow)

    1320. 

  1320. 	{

    1321. 

  1321. 		global $lang, $resource;

    1322. 

  1322. 

    1323. 

  1323. 		$iPlanetCount = mysql_result(doquery ("SELECT count(*) FROM {{table}} WHERE `id_owner` = '". $FleetRow['fleet_owner'] ."' AND `planet_type` = '1' AND `destruyed` = '0'", 'planets'), 0);

    1324. 

  1324. 

    1325. 

  1325. 		if ($FleetRow['fleet_mess'] == 0)

    1326. 

  1326. 		{

    1327. 

  1327. 			$iGalaxyPlace = mysql_result(doquery ("SELECT count(*) FROM {{table}} WHERE `galaxy` = '". $FleetRow['fleet_end_galaxy']."' AND `system` = '". $FleetRow['fleet_end_system']."' AND `planet` = '". $FleetRow['fleet_end_planet']."';", 'galaxy'), 0);

    1328. 

  1328. 			$TargetAdress = sprintf ($lang['sys_adress_planet'], $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet']);

    1329. 

  1329. 			if ($iGalaxyPlace == 0)

    1330. 

  1330. 			{

    1331. 

  1331. 				if ($iPlanetCount >= MAX_PLAYER_PLANETS)

    1332. 

  1332. 				{

    1333. 

  1333. 					$TheMessage = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_maxcolo'] . MAX_PLAYER_PLANETS . $lang['sys_colo_planet'];

    1334. 

  1334. 					SendSimpleMessage ( $FleetRow['fleet_owner'], '', $FleetRow['fleet_start_time'], 0, $lang['sys_colo_mess_from'], $lang['sys_colo_mess_report'], $TheMessage);

    1335. 

  1335. 					doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = ". $FleetRow["fleet_id"], 'fleets');

    1336. 

  1336. 				}

    1337. 

  1337. 				else

    1338. 

  1338. 				{

    1339. 

  1339. 					$NewOwnerPlanet = CreateOnePlanetRecord($FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet'], $FleetRow['fleet_owner'], $lang['sys_colo_defaultname'], FALSE);

    1340. 

  1340. 					if ( $NewOwnerPlanet == TRUE )

    1341. 

  1341. 					{

    1342. 

  1342. 						$TheMessage = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_allisok'];

    1343. 

  1343. 						SendSimpleMessage ( $FleetRow['fleet_owner'], '', $FleetRow['fleet_start_time'], 0, $lang['sys_colo_mess_from'], $lang['sys_colo_mess_report'], $TheMessage);

    1344. 

  1344. 						if ($FleetRow['fleet_amount'] == 1)

    1345. 

  1345. 						{

    1346. 

  1346. 							$this->StoreGoodsToPlanet ($FleetRow);

    1347. 

  1347. 							doquery("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');

    1348. 

  1348. 						}

    1349. 

  1349. 						else

    1350. 

  1350. 						{

    1351. 

  1351. 							$this->StoreGoodsToPlanet ($FleetRow);

    1352. 

  1352. 							$CurrentFleet = explode(";", $FleetRow['fleet_array']);

    1353. 

  1353. 							$NewFleet     = "";

    1354. 

  1354. 							foreach ($CurrentFleet as $Item => $Group)

    1355. 

  1355. 							{

    1356. 

  1356. 								if ($Group != '')

    1357. 

  1357. 								{

    1358. 

  1358. 									$Class = explode (",", $Group);

    1359. 

  1359. 									if ($Class[0] == 208)

    1360. 

  1360. 									{

    1361. 

  1361. 										if ($Class[1] > 1)

    1362. 

  1362. 										{

    1363. 

  1363. 											$NewFleet  .= $Class[0].",".($Class[1] - 1).";";

    1364. 

  1364. 										}

    1365. 

  1365. 									}

    1366. 

  1366. 									else

    1367. 

  1367. 									{

    1368. 

  1368. 										if ($Class[1] <> 0)

    1369. 

  1369. 										{

    1370. 

  1370. 											$NewFleet  .= $Class[0].",".$Class[1].";";

    1371. 

  1371. 										}

    1372. 

  1372. 									}

    1373. 

  1373. 								}

    1374. 

  1374. 							}

    1375. 

  1375. 							$QryUpdateFleet  = "UPDATE {{table}} SET ";

    1376. 

  1376. 							$QryUpdateFleet .= "`fleet_array` = '". $NewFleet ."', ";

    1377. 

  1377. 							$QryUpdateFleet .= "`fleet_amount` = `fleet_amount` - 1, ";

    1378. 

  1378. 							$QryUpdateFleet .= "`fleet_resource_metal` = '0' , ";

    1379. 

  1379. 							$QryUpdateFleet .= "`fleet_resource_crystal` = '0' , ";

    1380. 

  1380. 							$QryUpdateFleet .= "`fleet_resource_deuterium` = '0' , ";

    1381. 

  1381. 							$QryUpdateFleet .= "`fleet_mess` = '1' ";

    1382. 

  1382. 							$QryUpdateFleet .= "WHERE `fleet_id` = '". $FleetRow["fleet_id"] ."';";

    1383. 

  1383. 							doquery( $QryUpdateFleet, 'fleets');

    1384. 

  1384. 						}

    1385. 

  1385. 					}

    1386. 

  1386. 					else

    1387. 

  1387. 					{

    1388. 

  1388. 						$TheMessage = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_badpos'];

    1389. 

  1389. 						SendSimpleMessage ( $FleetRow['fleet_owner'], '', $FleetRow['fleet_start_time'], 0, $lang['sys_colo_mess_from'], $lang['sys_colo_mess_report'], $TheMessage);

    1390. 

  1390. 						doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = ". $FleetRow["fleet_id"], 'fleets');

    1391. 

  1391. 					}

    1392. 

  1392. 				}

    1393. 

  1393. 			}

    1394. 

  1394. 			else

    1395. 

  1395. 			{

    1396. 

  1396. 				$TheMessage = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_notfree'];

    1397. 

  1397. 				SendSimpleMessage ( $FleetRow['fleet_owner'], '', $FleetRow['fleet_end_time'], 0, $lang['sys_colo_mess_from'], $lang['sys_colo_mess_report'], $TheMessage);

    1398. 

  1398. 				doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = ". $FleetRow["fleet_id"], 'fleets');

    1399. 

  1399. 			}

    1400. 

  1400. 		}

    1401. 

  1401. 		elseif ($FleetRow['fleet_end_time'] < time())

    1402. 

  1402. 		{

    1403. 

  1403. 			$this->RestoreFleetToPlanet ( $FleetRow, TRUE );

    1404. 

  1404. 			doquery("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');

    1405. 

  1405. 		}

    1406. 

  1406. 	}

    1407. 

  1407. 

    1408. 

  1408. 	private function MissionCaseDestruction($FleetRow)

    1409. 

  1409. 	{

    1410. 

  1410. 		global $user, $pricelist, $lang, $resource, $CombatCaps;

    1411. 

  1411. 

    1412. 

  1412. 		if ($FleetRow['fleet_start_time'] <= time())

    1413. 

  1413. 		{

    1414. 

  1414. 			if ($FleetRow['fleet_mess'] == 0)

    1415. 

  1415. 			{

    1416. 

  1416. 				if (!isset($CombatCaps[202]['sd']))

    1417. 

  1417. 					header("location:game.php?page=fleet");

    1418. 

  1418. 

    1419. 

  1419. 				$QryTargetPlanet  = "SELECT * FROM {{table}} ";

    1420. 

  1420. 				$QryTargetPlanet .= "WHERE ";

    1421. 

  1421. 				$QryTargetPlanet .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    1422. 

  1422. 				$QryTargetPlanet .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    1423. 

  1423. 				$QryTargetPlanet .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' AND ";

    1424. 

  1424. 				$QryTargetPlanet .= "`planet_type` = '". $FleetRow['fleet_end_type'] ."';";

    1425. 

  1425. 				$TargetPlanet     = doquery( $QryTargetPlanet, 'planets', TRUE);

    1426. 

  1426. 				$TargetUserID     = $TargetPlanet['id_owner'];

    1427. 

  1427. 

    1428. 

  1428. 				$QryDepPlanet  = "SELECT * FROM {{table}} ";

    1429. 

  1429. 				$QryDepPlanet .= "WHERE ";

    1430. 

  1430. 				$QryDepPlanet .= "`galaxy` = '". $FleetRow['fleet_start_galaxy'] ."' AND ";

    1431. 

  1431. 				$QryDepPlanet .= "`system` = '". $FleetRow['fleet_start_system'] ."' AND ";

    1432. 

  1432. 				$QryDepPlanet .= "`planet` = '". $FleetRow['fleet_start_planet'] ."' AND ";

    1433. 

  1433. 				$QryDepPlanet .= "`planet_type` = '". $FleetRow['fleet_start_type'] ."';";

    1434. 

  1434. 				$DepPlanet     = doquery( $QryDepPlanet, 'planets', TRUE);

    1435. 

  1435. 				$DepName       = $DepPlanet['name'];

    1436. 

  1436. 

    1437. 

  1437. 				$QryCurrentUser   = "SELECT * FROM {{table}} ";

    1438. 

  1438. 				$QryCurrentUser  .= "WHERE ";

    1439. 

  1439. 				$QryCurrentUser  .= "`id` = '". $FleetRow['fleet_owner'] ."';";

    1440. 

  1440. 				$CurrentUser      = doquery($QryCurrentUser , 'users', TRUE);

    1441. 

  1441. 				$CurrentUserID    = $CurrentUser['id'];

    1442. 

  1442. 

    1443. 

  1443. 				$QryTargetUser    = "SELECT * FROM {{table}} ";

    1444. 

  1444. 				$QryTargetUser   .= "WHERE ";

    1445. 

  1445. 				$QryTargetUser   .= "`id` = '". $TargetUserID ."';";

    1446. 

  1446. 				$TargetUser       = doquery($QryTargetUser, 'users', TRUE);

    1447. 

  1447. 

    1448. 

  1448. 				for ($SetItem = 200; $SetItem < 500; $SetItem++)

    1449. 

  1449. 				{

    1450. 

  1450. 					if ($TargetPlanet[$resource[$SetItem]] > 0)

    1451. 

  1451. 						$TargetSet[$SetItem]['count'] = $TargetPlanet[$resource[$SetItem]];

    1452. 

  1452. 				}

    1453. 

  1453. 

    1454. 

  1454. 				$TheFleet = explode(";", $FleetRow['fleet_array']);

    1455. 

  1455. 

    1456. 

  1456. 				foreach($TheFleet as $a => $b)

    1457. 

  1457. 				{

    1458. 

  1458. 					if ($b != '')

    1459. 

  1459. 					{

    1460. 

  1460. 						$a = explode(",", $b);

    1461. 

  1461. 						$CurrentSet[$a[0]]['count'] = $a[1];

    1462. 

  1462. 					}

    1463. 

  1463. 				}

    1464. 

  1464. 

    1465. 

  1465. 

    1466. 

  1466. 				$walka        = $this->walka($CurrentSet, $TargetSet, $CurrentUser, $TargetUser);

    1467. 

  1467. 				$CurrentSet   = $walka["atakujacy"];

    1468. 

  1468. 				$TargetSet    = $walka["wrog"];

    1469. 

  1469. 				$FleetResult  = $walka["wygrana"];

    1470. 

  1470. 				$dane_do_rw   = $walka["dane_do_rw"];

    1471. 

  1471. 				$zlom         = $walka["zlom"];

    1472. 

  1472. 				$FleetArray   = "";

    1473. 

  1473. 				$FleetAmount  = 0;

    1474. 

  1474. 				$FleetStorage = 0;

    1475. 

  1475. 

    1476. 

  1476. 				foreach ($CurrentSet as $Ship => $Count)

    1477. 

  1477. 				{

    1478. 

  1478. 

    1479. 

  1479. 					$FleetStorage += $pricelist[$Ship]["capacity"] * $Count['count'];

    1480. 

  1480. 					$FleetArray   .= $Ship.",".$Count['count'].";";

    1481. 

  1481. 					$FleetAmount  += $Count['count'];

    1482. 

  1482. 				}

    1483. 

  1483. 

    1484. 

  1484. 				$TargetPlanetUpd = "";

    1485. 

  1485. 

    1486. 

  1486. 				if (!is_null($TargetSet))

    1487. 

  1487. 				{

    1488. 

  1488. 					foreach($TargetSet as $Ship => $Count)

    1489. 

  1489. 					{

    1490. 

  1490. 						$TargetPlanetUpd .= "`". $resource[$Ship] ."` = '". $Count['count'] ."', ";

    1491. 

  1491. 					}

    1492. 

  1492. 				}

    1493. 

  1493. 

    1494. 

  1494. 				if ($FleetResult == "a")

    1495. 

  1495. 				{

    1496. 

  1496. 					$destructionl1 	= 100-sqrt($TargetPlanet['diameter']);

    1497. 

  1497. 					$destructionl21 = $destructionl1*sqrt($CurrentSet['214']['count']);

    1498. 

  1498. 					$destructionl2 	= $destructionl21/1;

    1499. 

  1499. 

    1500. 

  1500. 					if ($destructionl2 > 100)

    1501. 

  1501. 						$chance = '100';

    1502. 

  1502. 					else

    1503. 

  1503. 						$chance = round($destructionl2);

    1504. 

  1504. 

    1505. 

  1505. 					$tirage 	= mt_rand(0, 100);

    1506. 

  1506. 					$probalune	= sprintf ($lang['sys_destruc_lune'], $chance);

    1507. 

  1507. 

    1508. 

  1508. 					if($tirage <= $chance)

    1509. 

  1509. 					{

    1510. 

  1510. 						$resultat 	= '1';

    1511. 

  1511. 						$finmess 	= $lang['sys_destruc_reussi'];

    1512. 

  1512. 

    1513. 

  1513. 						doquery("DELETE FROM {{table}} WHERE `id` = '". $TargetPlanet['id'] ."';", 'planets');

    1514. 

  1514. 

    1515. 

  1515. 						$Qrydestructionlune  = "UPDATE {{table}} SET ";

    1516. 

  1516. 						$Qrydestructionlune .= "`id_luna` = '0' ";

    1517. 

  1517. 						$Qrydestructionlune .= "WHERE ";

    1518. 

  1518. 						$Qrydestructionlune .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    1519. 

  1519. 						$Qrydestructionlune .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    1520. 

  1520. 						$Qrydestructionlune .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' ";

    1521. 

  1521. 						$Qrydestructionlune .= "LIMIT 1 ;";

    1522. 

  1522. 						doquery( $Qrydestructionlune , 'galaxy');

    1523. 

  1523. 

    1524. 

  1524. 						$QryDetFleets1  = "UPDATE {{table}} SET ";

    1525. 

  1525. 						$QryDetFleets1 .= "`fleet_start_type` = '1' ";

    1526. 

  1526. 						$QryDetFleets1 .= "WHERE ";

    1527. 

  1527. 						$QryDetFleets1 .= "`fleet_start_galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    1528. 

  1528. 						$QryDetFleets1 .= "`fleet_start_system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    1529. 

  1529. 						$QryDetFleets1 .= "`fleet_start_planet` = '". $FleetRow['fleet_end_planet'] ."' ";

    1530. 

  1530. 						$QryDetFleets1 .= ";";

    1531. 

  1531. 						doquery( $QryDetFleets1 , 'fleets');

    1532. 

  1532. 

    1533. 

  1533. 						$QryDetFleets2  = "UPDATE {{table}} SET ";

    1534. 

  1534. 						$QryDetFleets2 .= "`fleet_end_type` = '1' ";

    1535. 

  1535. 						$QryDetFleets2 .= "WHERE ";

    1536. 

  1536. 						$QryDetFleets2 .= "`fleet_end_galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    1537. 

  1537. 						$QryDetFleets2 .= "`fleet_end_system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    1538. 

  1538. 						$QryDetFleets2 .= "`fleet_end_planet` = '". $FleetRow['fleet_end_planet'] ."' ";

    1539. 

  1539. 						$QryDetFleets2 .= ";";

    1540. 

  1540. 						doquery( $QryDetFleets2 , 'fleets');

    1541. 

  1541. 

    1542. 

  1542. 						if ($TargetUser['current_planet'] == $TargetPlanet['id'])

    1543. 

  1543. 						{

    1544. 

  1544. 							$QryPlanet  = "SELECT * FROM {{table}} ";

    1545. 

  1545. 							$QryPlanet .= "WHERE ";

    1546. 

  1546. 							$QryPlanet .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    1547. 

  1547. 							$QryPlanet .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    1548. 

  1548. 							$QryPlanet .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' AND ";

    1549. 

  1549. 							$QryPlanet .= "`planet_type` = '1';";

    1550. 

  1550. 							$Planet     = doquery( $QryPlanet, 'planets', TRUE);

    1551. 

  1551. 							$IDPlanet     = $Planet['id'];

    1552. 

  1552. 

    1553. 

  1553. 							$Qryvue  = "UPDATE {{table}} SET ";

    1554. 

  1554. 							$Qryvue .= "`current_planet` = '". $IDPlanet ."' ";

    1555. 

  1555. 							$Qryvue .= "WHERE ";

    1556. 

  1556. 							$Qryvue .= "`id` = '". $TargetUserID ."' ";

    1557. 

  1557. 							$Qryvue .= ";";

    1558. 

  1558. 							doquery( $Qryvue , 'users');

    1559. 

  1559. 						}

    1560. 

  1560. 					}

    1561. 

  1561. 					else

    1562. 

  1562. 						$resultat = '0';

    1563. 

  1563. 

    1564. 

  1564. 					$destructionrip = sqrt($TargetPlanet['diameter'])/2;

    1565. 

  1565. 					$chance2		= round($destructionrip);

    1566. 

  1566. 

    1567. 

  1567. 					if ($resultat == 0)

    1568. 

  1568. 					{

    1569. 

  1569. 						$tirage2 	= mt_rand(0, 100);

    1570. 

  1570. 						$probarip	= sprintf ($lang['sys_destruc_rip'], $chance2);

    1571. 

  1571. 						if($tirage2 <= $chance2)

    1572. 

  1572. 						{

    1573. 

  1573. 							$resultat2 = ' detruite 1';

    1574. 

  1574. 							$finmess = $lang['sys_destruc_echec'];

    1575. 

  1575. 							doquery("DELETE FROM {{table}} WHERE `fleet_id` = '". $FleetRow["fleet_id"] ."';", 'fleets');

    1576. 

  1576. 						}

    1577. 

  1577. 						else

    1578. 

  1578. 						{

    1579. 

  1579. 							$resultat2 = 'sauvees 0';

    1580. 

  1580. 							$finmess = $lang['sys_destruc_null'];

    1581. 

  1581. 						}

    1582. 

  1582. 					}

    1583. 

  1583. 				}

    1584. 

  1584. 

    1585. 

  1585. 				$introdestruc       = sprintf ($lang['sys_destruc_mess'], $DepName , $FleetRow['fleet_start_galaxy'], $FleetRow['fleet_start_system'], $FleetRow['fleet_start_planet'], $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet']);

    1586. 

  1586. 

    1587. 

  1587. 				$QryUpdateTarget  = "UPDATE {{table}} SET ";

    1588. 

  1588. 				$QryUpdateTarget .= $TargetPlanetUpd;

    1589. 

  1589. 				$QryUpdateTarget .= "`metal` = `metal` - '". $Mining['metal'] ."', ";

    1590. 

  1590. 				$QryUpdateTarget .= "`crystal` = `crystal` - '". $Mining['crystal'] ."', ";

    1591. 

  1591. 				$QryUpdateTarget .= "`deuterium` = `deuterium` - '". $Mining['deuter'] ."' ";

    1592. 

  1592. 				$QryUpdateTarget .= "WHERE ";

    1593. 

  1593. 				$QryUpdateTarget .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    1594. 

  1594. 				$QryUpdateTarget .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    1595. 

  1595. 				$QryUpdateTarget .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' AND ";

    1596. 

  1596. 				$QryUpdateTarget .= "`planet_type` = '". $FleetRow['fleet_end_type'] ."' ";

    1597. 

  1597. 				$QryUpdateTarget .= "LIMIT 1;";

    1598. 

  1598. 				doquery( $QryUpdateTarget , 'planets');

    1599. 

  1599. 

    1600. 

  1600. 				$QryUpdateGalaxy  = "UPDATE {{table}} SET ";

    1601. 

  1601. 				$QryUpdateGalaxy .= "`invisible_start_time` = '".time()."', ";

    1602. 

  1602. 				$QryUpdateGalaxy .= "`metal` = `metal` + '". $zlom['metal'] ."', ";

    1603. 

  1603. 				$QryUpdateGalaxy .= "`crystal` = `crystal` + '". $zlom['crystal'] ."' ";

    1604. 

  1604. 				$QryUpdateGalaxy .= "WHERE ";

    1605. 

  1605. 				$QryUpdateGalaxy .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";

    1606. 

  1606. 				$QryUpdateGalaxy .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";

    1607. 

  1607. 				$QryUpdateGalaxy .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' ";

    1608. 

  1608. 				$QryUpdateGalaxy .= "LIMIT 1;";

    1609. 

  1609. 				doquery( $QryUpdateGalaxy , 'galaxy');

    1610. 

  1610. 

    1611. 

  1611. 				$FleetDebris      = $zlom['metal'] + $zlom['crystal'];

    1612. 

  1612. 				$StrAttackerUnits = sprintf ($lang['sys_attacker_lostunits'], $zlom["atakujacy"]);

    1613. 

  1613. 				$StrDefenderUnits = sprintf ($lang['sys_defender_lostunits'], $zlom["wrog"]);

    1614. 

  1614. 				$StrRuins         = sprintf ($lang['sys_gcdrunits'], $zlom["metal"], $lang['Metal'], $zlom['crystal'], $lang['Crystal']);

    1615. 

  1615. 				$DebrisField      = $StrAttackerUnits ."<br />". $StrDefenderUnits ."<br />". $StrRuins;

    1616. 

  1616. 				$MoonChance       = $FleetDebris / 100000;

    1617. 

  1617. 

    1618. 

  1618. 				if ($FleetDebris > 2000000)

    1619. 

  1619. 				{

    1620. 

  1620. 					$MoonChance = 20;

    1621. 

  1621. 					$ChanceMoon = sprintf ($lang['sys_moonproba'], $MoonChance);

    1622. 

  1622. 				}

    1623. 

  1623. 				elseif ($FleetDebris < 100000)

    1624. 

  1624. 				{

    1625. 

  1625. 					$UserChance = 0;

    1626. 

  1626. 					$ChanceMoon = sprintf ($lang['sys_moonproba'], $MoonChance);

    1627. 

  1627. 				}

    1628. 

  1628. 				elseif ($FleetDebris >= 100000)

    1629. 

  1629. 				{

    1630. 

  1630. 					$UserChance = mt_rand(1, 100);

    1631. 

  1631. 					$ChanceMoon = sprintf ($lang['sys_moonproba'], $MoonChance);

    1632. 

  1632. 				}

    1633. 

  1633. 

    1634. 

  1634. 				if (($UserChance > 0) and ($UserChance <= $MoonChance) and $galenemyrow['id_luna'] == 0)

    1635. 

  1635. 				{

    1636. 

  1636. 					$TargetPlanetName = CreateOneMoonRecord ( $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet'], $TargetUserID, $FleetRow['fleet_start_time'], '', $MoonChance );

    1637. 

  1637. 					$GottenMoon       = sprintf ($lang['sys_moonbuilt'], $TargetPlanetName, $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet']);

    1638. 

  1638. 				}

    1639. 

  1639. 				elseif ($UserChance = 0 or $UserChance > $MoonChance)

    1640. 

  1640. 					$GottenMoon = "";

    1641. 

  1641. 

    1642. 

  1642. 				$AttackDate        = date("r", $FleetRow["fleet_start_time"]);

    1643. 

  1643. 				$title             = sprintf ($lang['sys_destruc_title'], $AttackDate);

    1644. 

  1644. 				$raport            = "<center><table><tr><td>". $title ."<br />";

    1645. 

  1645. 				$zniszczony        = FALSE;

    1646. 

  1646. 				$a_zestrzelona     = 0;

    1647. 

  1647. 				$AttackTechon['A'] = $CurrentUser["military_tech"] * 10;

    1648. 

  1648. 				$AttackTechon['B'] = $CurrentUser["defence_tech"] * 10;

    1649. 

  1649. 				$AttackTechon['C'] = $CurrentUser["shield_tech"] * 10;

    1650. 

  1650. 				$AttackerData      = sprintf ($lang['sys_attack_attacker_pos'], $CurrentUser["username"], $FleetRow['fleet_start_galaxy'], $FleetRow['fleet_start_system'], $FleetRow['fleet_start_planet'] );

    1651. 

  1651. 				$AttackerTech      = sprintf ($lang['sys_attack_techologies'], $AttackTechon['A'], $AttackTechon['B'], $AttackTechon['C']);

    1652. 

  1652. 				$DefendTechon['A'] = $TargetUser["military_tech"] * 10;

    1653. 

  1653. 				$DefendTechon['B'] = $TargetUser["defence_tech"] * 10;

    1654. 

  1654. 				$DefendTechon['C'] = $TargetUser["shield_tech"] * 10;

    1655. 

  1655. 				$DefenderData      = sprintf ($lang['sys_attack_defender_pos'], $TargetUser["username"], $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet'] );

    1656. 

  1656. 				$DefenderTech      = sprintf ($lang['sys_attack_techologies'], $DefendTechon['A'], $DefendTechon['B'], $DefendTechon['C']);

    1657. 

  1657. 

    1658. 

  1658. 				foreach ($dane_do_rw as $a => $b)

    1659. 

  1659. 				{

    1660. 

  1660. 					$raport .= "<table border=1 width=100%><tr><th><br /><center>".$AttackerData."<br />".$AttackerTech."<table border=1>";

    1661. 

  1661. 

    1662. 

  1662. 					if ($b["atakujacy"]['count'] > 0)

    1663. 

  1663. 					{

    1664. 

  1664. 						$raport1 = "<tr><th>".$lang['sys_ship_type']."</th>";

    1665. 

  1665. 						$raport2 = "<tr><th>".$lang['sys_ship_count']."</th>";

    1666. 

  1666. 						$raport3 = "<tr><th>".$lang['sys_ship_weapon']."</th>";

    1667. 

  1667. 						$raport4 = "<tr><th>".$lang['sys_ship_shield']."</th>";

    1668. 

  1668. 						$raport5 = "<tr><th>".$lang['sys_ship_armour']."</th>";

    1669. 

  1669. 

    1670. 

  1670. 						foreach ($b["atakujacy"] as $Ship => $Data)

    1671. 

  1671. 						{

    1672. 

  1672. 							if (is_numeric($Ship))

    1673. 

  1673. 							{

    1674. 

  1674. 								if ($Data['count'] > 0)

    1675. 

  1675. 								{

    1676. 

  1676. 									$raport1 .= "<th>". $lang["tech_rc"][$Ship] ."</th>";

    1677. 

  1677. 									$raport2 .= "<th>". $Data['count'] ."</th>";

    1678. 

  1678. 									$raport3 .= "<th>". round($Data["atak"]   / $Data['count']) ."</th>";

    1679. 

  1679. 									$raport4 .= "<th>". round($Data["tarcza"] / $Data['count']) ."</th>";

    1680. 

  1680. 									$raport5 .= "<th>". round($Data["obrona"] / $Data['count']) ."</th>";

    1681. 

  1681. 								}

    1682. 

  1682. 							}

    1683. 

  1683. 						}

    1684. 

  1684. 

    1685. 

  1685. 						$raport1 .= "</tr>";

    1686. 

  1686. 						$raport2 .= "</tr>";

    1687. 

  1687. 						$raport3 .= "</tr>";

    1688. 

  1688. 						$raport4 .= "</tr>";

    1689. 

  1689. 						$raport5 .= "</tr>";

    1690. 

  1690. 						$raport  .= $raport1 . $raport2 . $raport3 . $raport4 . $raport5;

    1691. 

  1691. 

    1692. 

  1692. 					}

    1693. 

  1693. 					else

    1694. 

  1694. 					{

    1695. 

  1695. 						if ($a == 2)

    1696. 

  1696. 							$a_zestrzelona = 1;

    1697. 

  1697. 

    1698. 

  1698. 						$zniszczony = TRUE;

    1699. 

  1699. 						$raport .= "<br />". $lang['sys_destroyed'];

    1700. 

  1700. 					}

    1701. 

  1701. 

    1702. 

  1702. 					$raport .= "</table></center></th></tr></table>";

    1703. 

  1703. 					$raport .= "<table border=1 width=100%><tr><th><br /><center>".$DefenderData."<br />".$DefenderTech."<table border=1>";

    1704. 

  1704. 

    1705. 

  1705. 					if ($b["wrog"]['count'] > 0)

    1706. 

  1706. 					{

    1707. 

  1707. 						$raport1 = "<tr><th>".$lang['sys_ship_type']."</th>";

    1708. 

  1708. 						$raport2 = "<tr><th>".$lang['sys_ship_count']."</th>";

    1709. 

  1709. 						$raport3 = "<tr><th>".$lang['sys_ship_weapon']."</th>";

    1710. 

  1710. 						$raport4 = "<tr><th>".$lang['sys_ship_shield']."</th>";

    1711. 

  1711. 						$raport5 = "<tr><th>".$lang['sys_ship_armour']."</th>";

    1712. 

  1712. 

    1713. 

  1713. 						foreach ($b["wrog"] as $Ship => $Data)

    1714. 

  1714. 						{

    1715. 

  1715. 							if (is_numeric($Ship))

    1716. 

  1716. 							{

    1717. 

  1717. 								if ($Data['count'] > 0)

    1718. 

  1718. 								{

    1719. 

  1719. 									$raport1 .= "<th>". $lang["tech_rc"][$Ship] ."</th>";

    1720. 

  1720. 									$raport2 .= "<th>". $Data['count'] ."</th>";

    1721. 

  1721. 									$raport3 .= "<th>". round($Data["atak"]   / $Data['count']) ."</th>";

    1722. 

  1722. 									$raport4 .= "<th>". round($Data["tarcza"] / $Data['count']) ."</th>";

    1723. 

  1723. 									$raport5 .= "<th>". round($Data["obrona"] / $Data['count']) ."</th>";

    1724. 

  1724. 								}

    1725. 

  1725. 							}

    1726. 

  1726. 						}

    1727. 

  1727. 

    1728. 

  1728. 						$raport1 .= "</tr>";

    1729. 

  1729. 						$raport2 .= "</tr>";

    1730. 

  1730. 						$raport3 .= "</tr>";

    1731. 

  1731. 						$raport4 .= "</tr>";

    1732. 

  1732. 						$raport5 .= "</tr>";

    1733. 

  1733. 						$raport  .= $raport1 . $raport2 . $raport3 . $raport4 . $raport5;

    1734. 

  1734. 

    1735. 

  1735. 					}

    1736. 

  1736. 					else

    1737. 

  1737. 					{

    1738. 

  1738. 						$zniszczony = TRUE;

    1739. 

  1739. 						$raport .= "<br />". $lang['sys_destroyed'];

    1740. 

  1740. 					}

    1741. 

  1741. 

    1742. 

  1742. 					$raport .= "</table></center></th></tr></table>";

    1743. 

  1743. 

    1744. 

  1744. 

    1745. 

  1745. 

    1746. 

  1746. 					if (($zniszczony == FALSE) and !($a == 8))

    1747. 

  1747. 					{

    1748. 

  1748. 						$AttackWaveStat    = sprintf ($lang['sys_attack_attack_wave'], floor($b["atakujacy"]["atak"]), floor($b["wrog"]["tarcza"]));

    1749. 

  1749. 						$DefendWavaStat    = sprintf ($lang['sys_attack_defend_wave'], floor($b["wrog"]["atak"]), floor($b["atakujacy"]["tarcza"]));

    1750. 

  1750. 						$raport           .= "<br /><center>".$AttackWaveStat."<br />".$DefendWavaStat."</center>";

    1751. 

  1751. 					}

    1752. 

  1752. 				}

    1753. 

  1753. 

    1754. 

  1754. 				switch ($FleetResult)

    1755. 

  1755. 				{

    1756. 

  1756. 					case "a":

    1757. 

  1757. 						$raport           .= $lang['sys_attacker_won'] ."<br />";

    1758. 

  1758. 						$raport           .= $DebrisField ."<br />";

    1759. 

  1759. 						$raport           .= $introdestruc ."<br />";

    1760. 

  1760. 						$raport           .= $lang['sys_destruc_mess1'];

    1761. 

  1761. 						$raport           .= $finmess ."<br />";

    1762. 

  1762. 						$raport           .= $probalune ."<br />";

    1763. 

  1763. 						$raport           .= $probarip ."<br />";

    1764. 

  1764. 						break;

    1765. 

  1765. 

    1766. 

  1766. 					case "r":

    1767. 

  1767. 						$raport           .= $lang['sys_both_won'] ."<br />";

    1768. 

  1768. 						$raport           .= $DebrisField ."<br />";

    1769. 

  1769. 						$raport           .= $introdestruc ."<br />";

    1770. 

  1770. 						$raport           .= $lang['sys_destruc_stop'] ."<br />";

    1771. 

  1771. 						break;

    1772. 

  1772. 

    1773. 

  1773. 					case "w":

    1774. 

  1774. 						$raport           .= $lang['sys_defender_won'] ."<br />";

    1775. 

  1775. 						$raport           .= $DebrisField ."<br />";

    1776. 

  1776. 						$raport           .= $introdestruc ."<br />";

    1777. 

  1777. 						$raport           .= $lang['sys_destruc_stop'] ."<br />";

    1778. 

  1778. 						doquery("DELETE FROM {{table}} WHERE `fleet_id` = '". $FleetRow["fleet_id"] ."';", 'fleets');

    1779. 

  1779. 						break;

    1780. 

  1780. 				}

    1781. 

  1781. 

    1782. 

  1782. 				$raport           .= "</table>";

    1783. 

  1783. 				$rid   			   = md5($raport);

    1784. 

  1784. 

    1785. 

  1785. 				$owners 			 = $FleetRow['fleet_owner'].",".$TargetUserID;

    1786. 

  1786. 				$QryInsertRapport  	 = "INSERT INTO {{table}} SET ";

    1787. 

  1787. 				$QryInsertRapport 	.= "`time` = UNIX_TIMESTAMP(), ";

    1788. 

  1788. 				$QryInsertRapport 	.= "`owners` = '". $owners ."', ";

    1789. 

  1789. 				$QryInsertRapport 	.= "`rid` = '". $rid ."', ";

    1790. 

  1790. 				$QryInsertRapport 	.= "`a_zestrzelona` = '". $a_zestrzelona ."', ";

    1791. 

  1791. 				$QryInsertRapport 	.= "`raport` = '". addslashes ( $raport ) ."';";

    1792. 

  1792. 				doquery( $QryInsertRapport , 'rw');

    1793. 

  1793. 

    1794. 

  1794. 				$raport  = "<a href=\"#\" OnClick=\'f(\"CombatReport.php?raport=". $rid ."\", \"\");\' >";

    1795. 

  1795. 				$raport .= "<center>";

    1796. 

  1796. 

    1797. 

  1797. 				if($FleetResult == "a")

    1798. 

  1798. 					$raport .= "<font color=\"green\">";

    1799. 

  1799. 				elseif ($FleetResult == "r")

    1800. 

  1800. 					$raport .= "<font color=\"orange\">";

    1801. 

  1801. 				elseif ($FleetResult == "w")

    1802. 

  1802. 					$raport .= "<font color=\"red\">";

    1803. 

  1803. 

    1804. 

  1804. 				$raport .= $lang['sys_mess_destruc_report'] ." [". $FleetRow['fleet_end_galaxy'] .":". $FleetRow['fleet_end_system'] .":". $FleetRow['fleet_end_planet'] ."] </font></a><br /><br />";

    1805. 

  1805. 				$raport .= "<font color=\"red\">". $lang['sys_perte_attaquant'] .": ". $zlom["atakujacy"] ."</font>";

    1806. 

  1806. 				$raport .= "<font color=\"green\">   ". $lang['sys_perte_defenseur'] .":". $zlom["wrog"] ."</font><br />" ;

    1807. 

  1807. 				$raport .= $lang['sys_debris'] ." ". $lang['Metal'] .":<font color=\"#adaead\">". $zlom['metal'] ."</font>   ". $lang['Crystal'] .":<font color=\"#ef51ef\">". $zlom['crystal'] ."</font><br /></center>";

    1808. 

  1808. 

    1809. 

  1809. 				$QryUpdateFleet  = "UPDATE {{table}} SET ";

    1810. 

  1810. 				$QryUpdateFleet .= "`fleet_amount` = '". $FleetAmount ."', ";

    1811. 

  1811. 				$QryUpdateFleet .= "`fleet_array` = '". $FleetArray ."', ";

    1812. 

  1812. 				$QryUpdateFleet .= "`fleet_mess` = '1' ";

    1813. 

  1813. 				$QryUpdateFleet .= "WHERE fleet_id = '". intval($FleetRow['fleet_id']) ."' ";

    1814. 

  1814. 				$QryUpdateFleet .= "LIMIT 1 ;";

    1815. 

  1815. 				doquery( $QryUpdateFleet , 'fleets');

    1816. 

  1816. 

    1817. 

  1817. 				SendSimpleMessage ( $CurrentUserID, '', $FleetRow['fleet_start_time'], 3, $lang['sys_mess_tower'], $lang['sys_mess_destruc_report'], $raport );

    1818. 

  1818. 

    1819. 

  1819. 				$raport2  = "<a href=\"#\" OnClick=\'f(\"CombatReport.php?raport=". $rid ."\", \"\");\' >";

    1820. 

  1820. 				$raport2 .= "<center>";

    1821. 

  1821. 

    1822. 

  1822. 				if($FleetResult == "a")

    1823. 

  1823. 					$raport2 .= "<font color=\"red\">";

    1824. 

  1824. 				elseif ($FleetResult == "r")

    1825. 

  1825. 					$raport2 .= "<font color=\"orange\">";

    1826. 

  1826. 				elseif ($FleetResult == "w")

    1827. 

  1827. 					$raport2 .= "<font color=\"green\">";

    1828. 

  1828. 

    1829. 

  1829. 				$raport2 .= $lang['sys_mess_destruc_report'] ." [". $FleetRow['fleet_end_galaxy'] .":". $FleetRow['fleet_end_system'] .":". $FleetRow['fleet_end_planet'] ."] </font></a><br /><br />";

    1830. 

  1830. 

    1831. 

  1831. 				SendSimpleMessage ( $TargetUserID, '', $FleetRow['fleet_start_time'], 3, $lang['sys_mess_tower'], $lang['sys_mess_destruc_report'], $raport2 );

    1832. 

  1832. 			}

    1833. 

  1833. 

    1834. 

  1834. 			$fquery = "";

    1835. 

  1835. 

    1836. 

  1836. 			if ($FleetRow['fleet_end_time'] <= time())

    1837. 

  1837. 			{

    1838. 

  1838. 				if (!is_null($CurrentSet))

    1839. 

  1839. 				{

    1840. 

  1840. 					foreach($CurrentSet as $Ship => $Count)

    1841. 

  1841. 					{

    1842. 

  1842. 						$fquery .= "`". $resource[$Ship] ."` = `". $resource[$Ship] ."` + '". $Count['count'] ."', ";

    1843. 

  1843. 					}

    1844. 

  1844. 				}

    1845. 

  1845. 				else

    1846. 

  1846. 				{

    1847. 

  1847. 					$fleet = explode(";", $FleetRow['fleet_array']);

    1848. 

  1848. 					foreach($fleet as $a => $b)

    1849. 

  1849. 					{

    1850. 

  1850. 						if ($b != '')

    1851. 

  1851. 						{

    1852. 

  1852. 							$a = explode(",", $b);

    1853. 

  1853. 							$fquery .= "{$resource[$a[0]]}={$resource[$a[0]]} + {$a[1]}, \n";

    1854. 

  1854. 						}

    1855. 

  1855. 					}

    1856. 

  1856. 				}

    1857. 

  1857. 

    1858. 

  1858. 				doquery ("DELETE FROM {{table}} WHERE `fleet_id` = " . $FleetRow["fleet_id"], 'fleets');

    1859. 

  1859. 

    1860. 

  1860. 				if (!($FleetResult == "w"))

    1861. 

  1861. 				{

    1862. 

  1862. 					$QryUpdatePlanet  = "UPDATE {{table}} SET ";

    1863. 

  1863. 					$QryUpdatePlanet .= $fquery;

    1864. 

  1864. 					$QryUpdatePlanet .= "`metal` = `metal` + ". $FleetRow['fleet_resource_metal'] .", ";

    1865. 

  1865. 					$QryUpdatePlanet .= "`crystal` = `crystal` + ". $FleetRow['fleet_resource_crystal'] .", ";

    1866. 

  1866. 					$QryUpdatePlanet .= "`deuterium` = `deuterium` + ". $FleetRow['fleet_resource_deuterium'] ." ";

    1867. 

  1867. 					$QryUpdatePlanet .= "WHERE ";

    1868. 

  1868. 					$QryUpdatePlanet .= "`galaxy` = ".$FleetRow['fleet_start_galaxy']." AND ";

    1869. 

  1869. 					$QryUpdatePlanet .= "`system` = ".$FleetRow['fleet_start_system']." AND ";

    1870. 

  1870. 					$QryUpdatePlanet .= "`planet` = ".$FleetRow['fleet_start_planet']." AND ";

    1871. 

  1871. 					$QryUpdatePlanet .= "`planet_type` = ".$FleetRow['fleet_start_type']." LIMIT 1 ;";

    1872. 

  1872. 					doquery( $QryUpdatePlanet, 'planets' );

    1873. 

  1873. 				}

    1874. 

  1874. 			}

    1875. 

  1875. 		}

    1876. 

  1876. 	}

    1877. 

  1877. 

    1878. 

  1878. 	private function MissionCaseMIP ($FleetRow)

    1879. 

  1879. 	{

    1880. 

  1880. 		global $user, $pricelist, $lang, $resource, $CombatCaps;

    1881. 

  1881. 

    1882. 

  1882. 		if ($FleetRow['fleet_start_time'] <= time())

    1883. 

  1883. 		{

    1884. 

  1884. 			if ($FleetRow['fleet_mess'] == 0)

    1885. 

  1885. 			{

    1886. 

  1886. 				$planet = doquery('SELECT * FROM {{table}} WHERE `galaxy` = '.$FleetRow['fleet_end_galaxy'].' AND `system` = '.$FleetRow['fleet_end_system'].' AND `planet` = '.$FleetRow['fleet_end_planet'].' AND `planet_type` = '.$FleetRow['fleet_end_type'], 'planets', TRUE);

    1887. 

  1887. 				$Target = doquery('SELECT id, defence_tech FROM  {{table}} WHERE `galaxy` = '.$FleetRow['fleet_end_galaxy'].' AND  `system` = '.$FleetRow['fleet_end_system'].' AND `planet` =  '.$FleetRow['fleet_end_planet'], 'users', TRUE);

    1888. 

  1888. 

    1889. 

  1889. 				if ($planet['interceptor_misil'] >= $FleetRow['fleet_amount'])

    1890. 

  1890. 				{

    1891. 

  1891. 					$message = $lang["ma_all_destroyed"] . '<br>';

    1892. 

  1892. 					doquery("UPDATE {{table}} SET ".$resource[502]." = ".$resource[502]." - ".$FleetRow['fleet_amount']." WHERE id = ".$planet['id'],  'planets');

    1893. 

  1893. 				}

    1894. 

  1894. 				else

    1895. 

  1895. 				{

    1896. 

  1896. 					doquery("UPDATE {{table}} SET ".$resource[502]." = '0' WHERE id = ".$planet['id'], 'planets');

    1897. 

  1897. 

    1898. 

  1898. 					if ($planet['interceptor_misil'] > 0)

    1899. 

  1899. 						$message .= $planet['interceptor_misil'].$lang['ma_some_destroyed']." <br>";

    1900. 

  1900. 

    1901. 

  1901. 					$attack = floor(($FleetRow['fleet_amount'] - $planet['interceptor_misil']) * ($CombatCaps[503]['attack'] * (1 + ($user["military_tech"] / 10))));

    1902. 

  1902. 

    1903. 

  1903. 					switch ($FleetRow['fleet_target_obj'])

    1904. 

  1904. 					{

    1905. 

  1905. 						case 0:

    1906. 

  1906. 							$attack_order = Array(401, 402, 403, 404, 405, 406, 407, 408, 503);

    1907. 

  1907. 							break;

    1908. 

  1908. 						case 1:

    1909. 

  1909. 							$attack_order = Array(402, 401, 403, 404, 405, 406, 407, 408, 503);

    1910. 

  1910. 							break;

    1911. 

  1911. 						case 2:

    1912. 

  1912. 							$attack_order = Array(403, 401, 402, 404, 405, 406, 407, 408, 503);

    1913. 

  1913. 							break;

    1914. 

  1914. 						case 3:

    1915. 

  1915. 							$attack_order = Array(404, 401, 402, 403, 405, 406, 407, 408, 503);

    1916. 

  1916. 							break;

    1917. 

  1917. 						case 4:

    1918. 

  1918. 							$attack_order = Array(405, 401, 402, 403, 404, 406, 407, 408, 503);

    1919. 

  1919. 							break;

    1920. 

  1920. 						case 5:

    1921. 

  1921. 							$attack_order = Array(406, 401, 402, 403, 404, 405, 407, 408, 503);

    1922. 

  1922. 							break;

    1923. 

  1923. 						case 6:

    1924. 

  1924. 							$attack_order = Array(407, 401, 402, 403, 404, 405, 406, 408, 503);

    1925. 

  1925. 							break;

    1926. 

  1926. 						case 7:

    1927. 

  1927. 							$attack_order = Array(408, 401, 402, 403, 404, 405, 406, 407, 503);

    1928. 

  1928. 							break;

    1929. 

  1929. 						case 8:

    1930. 

  1930. 							$attack_order = Array(401, 402, 403, 404, 405, 406, 407, 408, 503);

    1931. 

  1931. 							break;

    1932. 

  1932. 					}

    1933. 

  1933. 

    1934. 

  1934. 					for ($t = 0; $t < 10; $t++)

    1935. 

  1935. 					{

    1936. 

  1936. 						$n = $attack_order[$t];

    1937. 

  1937. 

    1938. 

  1938. 						if ($planet[$resource[$n]])

    1939. 

  1939. 						{

    1940. 

  1940. 							$defense = (($pricelist[$n]['metal'] + $pricelist[$n]['crystal']) / 10) * (1 + ($Target['defence_tech'] / 10));

    1941. 

  1941. 

    1942. 

  1942. 							if ($attack >= ($defense * $planet[$resource[$n]]))

    1943. 

  1943. 							{

    1944. 

  1944. 								$destroyed = $planet[$resource[$n]];

    1945. 

  1945. 							}

    1946. 

  1946. 							else

    1947. 

  1947. 							{

    1948. 

  1948. 								$destroyed = floor($attack / $defense);

    1949. 

  1949. 							}

    1950. 

  1950. 

    1951. 

  1951. 							$attack -= $destroyed * $defense;

    1952. 

  1952. 

    1953. 

  1953. 							if ($destroyed != 0)

    1954. 

  1954. 							{

    1955. 

  1955. 								$message .= $lang['tech'][$n] . " (-" . $destroyed . ")<br>";

    1956. 

  1956. 								doquery("UPDATE {{table}} SET ".$resource[$n]."  = ".$resource[$n]." - ".$destroyed." WHERE id = ".$planet['id'], 'planets');

    1957. 

  1957. 							}

    1958. 

  1958. 						}

    1959. 

  1959. 					}

    1960. 

  1960. 				}

    1961. 

  1961. 

    1962. 

  1962. 				$UserPlanet = doquery('SELECT name FROM {{table}} WHERE `galaxy` = '.$FleetRow['fleet_start_galaxy'].' AND `system` = '.$FleetRow['fleet_start_system'].' AND `planet` = '.$FleetRow['fleet_start_planet'].' AND `planet_type` = '.$FleetRow['fleet_start_type'], 'planets', TRUE);

    1963. 

  1963. 

    1964. 

  1964. 				$search=array('%1%','%2%','%3%');

    1965. 

  1965. 				$replace=array($FleetRow['fleet_amount'], $UserPlanet['name'].' ['.  $FleetRow['fleet_start_galaxy'] .':'. $FleetRow['fleet_start_system']  .':'. $FleetRow['fleet_start_planet'].'] ', $planet['name']. ' ['.  $FleetRow['fleet_end_galaxy'] .':'. $FleetRow['fleet_end_system'] .':'.  $FleetRow['fleet_end_planet'].'] ');

    1966. 

  1966. 				$message_vorlage=str_replace($search,$replace,$lang['ma_missile_string']);

    1967. 

  1967. 

    1968. 

  1968. 				if (empty($message))

    1969. 

  1969. 					$message = $lang['ma_planet_without_defens'];

    1970. 

  1970. 

    1971. 

  1971. 				SendSimpleMessage($Target['id'], '', $FleetRow['fleet_end_time'], 3, $lang['sys_mess_tower'], $lang['gl_missile_attack'], $message_vorlage . $message);

    1972. 

  1972. 

    1973. 

  1973. 				doquery("DELETE FROM {{table}} WHERE fleet_id = '" . intval($FleetRow['fleet_id']) . "'", 'fleets');

    1974. 

  1974. 			}

    1975. 

  1975. 		}

    1976. 

  1976. 	}

    1977. 

  1977. 

    1978. 

  1978. 	private function MissionCaseExpedition($FleetRow)

    1979. 

  1979. 	{

    1980. 

  1980. 		global $lang, $resource, $pricelist;

    1981. 

  1981. 

    1982. 

  1982. 		$FleetOwner = $FleetRow['fleet_owner'];

    1983. 

  1983. 		$MessSender = $lang['sys_mess_qg'];

    1984. 

  1984. 		$MessTitle  = $lang['sys_expe_report'];

    1985. 

  1985. 

    1986. 

  1986. 		if ($FleetRow['fleet_mess'] == 0)

    1987. 

  1987. 		{

    1988. 

  1988. 			if ($FleetRow['fleet_end_stay'] < time())

    1989. 

  1989. 			{

    1990. 

  1990. 				$PointsFlotte = array	(

    1991. 

  1991. 											202 => 1.0,

    1992. 

  1992. 											203 => 1.5,

    1993. 

  1993. 											204 => 0.5,

    1994. 

  1994. 											205 => 1.5,

    1995. 

  1995. 											206 => 2.0,

    1996. 

  1996. 											207 => 2.5,

    1997. 

  1997. 											208 => 0.5,

    1998. 

  1998. 											209 => 1.0,

    1999. 

  1999. 											210 => 0.01,

    2000. 

  2000. 											211 => 3.0,

    2001. 

  2001. 											212 => 0.0,

    2002. 

  2002. 											213 => 3.5,

    2003. 

  2003. 											214 => 5.0,

    2004. 

  2004. 											215 => 3.2,

    2005. 

  2005. 										);

    2006. 

  2006. 

    2007. 

  2007. 				$RatioGain = array	(

    2008. 

  2008. 										202 => 0.1,

    2009. 

  2009. 										203 => 0.1,

    2010. 

  2010. 										204 => 0.1,

    2011. 

  2011. 										205 => 0.5,

    2012. 

  2012. 										206 => 0.25,

    2013. 

  2013. 										207 => 0.125,

    2014. 

  2014. 										208 => 0.5,

    2015. 

  2015. 										209 => 0.1,

    2016. 

  2016. 										210 => 0.1,

    2017. 

  2017. 										211 => 0.0625,

    2018. 

  2018. 										212 => 0.0,

    2019. 

  2019. 										213 => 0.0625,

    2020. 

  2020. 										214 => 0.03125,

    2021. 

  2021. 										215 => 0.0625,

    2022. 

  2022. 									);

    2023. 

  2023. 

    2024. 

  2024. 				$FleetStayDuration 	= ($FleetRow['fleet_end_stay'] - $FleetRow['fleet_start_time']) / 3600;

    2025. 

  2025. 				$farray 			= explode(";", $FleetRow['fleet_array']);

    2026. 

  2026. 

    2027. 

  2027. 				foreach ($farray as $Item => $Group)

    2028. 

  2028. 				{

    2029. 

  2029. 					if ($Group != '')

    2030. 

  2030. 					{

    2031. 

  2031. 						$Class 						= explode (",", $Group);

    2032. 

  2032. 						$TypeVaisseau 				= $Class[0];

    2033. 

  2033. 						$NbreVaisseau 				= $Class[1];

    2034. 

  2034. 						$LaFlotte[$TypeVaisseau]	= $NbreVaisseau;

    2035. 

  2035. 						$FleetCapacity             += $pricelist[$TypeVaisseau]['capacity'] * $NbreVaisseau;

    2036. 

  2036. 						$FleetPoints   			   += ($NbreVaisseau * $PointsFlotte[$TypeVaisseau]);

    2037. 

  2037. 					}

    2038. 

  2038. 				}

    2039. 

  2039. 

    2040. 

  2040. 				$FleetUsedCapacity  = $FleetRow['fleet_resource_metal'] + $FleetRow['fleet_resource_crystal'] + $FleetRow['fleet_resource_deuterium'] + $FleetRow['fleet_resource_darkmatter'];

    2041. 

  2041. 				$FleetCapacity     -= $FleetUsedCapacity;

    2042. 

  2042. 				$FleetCount 		= $FleetRow['fleet_amount'];

    2043. 

  2043. 				$Hasard 			= rand(0, 10);

    2044. 

  2044. 				$MessSender 		= $lang['sys_mess_qg']. "(".$Hasard.")";

    2045. 

  2045. 

    2046. 

  2046. 				if ($Hasard < 3)

    2047. 

  2047. 				{

    2048. 

  2048. 					$Hasard     += 1;

    2049. 

  2049. 					$LostAmount  = (($Hasard * 33) + 1) / 100;

    2050. 

  2050. 

    2051. 

  2051. 					if ($LostAmount == 1)

    2052. 

  2052. 					{

    2053. 

  2053. 						SendSimpleMessage ( $FleetOwner, '', $FleetRow['fleet_end_stay'], 15, $MessSender, $MessTitle, $lang['sys_expe_blackholl_2'] );

    2054. 

  2054. 						doquery ("DELETE FROM {{table}} WHERE `fleet_id` = ". $FleetRow["fleet_id"], 'fleets');

    2055. 

  2055. 					}

    2056. 

  2056. 					else

    2057. 

  2057. 					{

    2058. 

  2058. 						$all_destroyed = TRUE;

    2059. 

  2059. 						foreach ($LaFlotte as $Ship => $Count)

    2060. 

  2060. 						{

    2061. 

  2061. 							if(floor($Count * $LostAmount)!=0)

    2062. 

  2062. 							{

    2063. 

  2063. 								$LostShips[$Ship] 	= floor($Count * $LostAmount);

    2064. 

  2064. 								$NewFleetArray     .= $Ship.",". ($Count - $LostShips[$Ship]) .";";

    2065. 

  2065. 								$all_destroyed 		= FALSE;

    2066. 

  2066. 							}

    2067. 

  2067. 						}

    2068. 

  2068. 						if(!$all_destroyed)

    2069. 

  2069. 						{

    2070. 

  2070. 							$QryUpdateFleet  = "UPDATE {{table}} SET ";

    2071. 

  2071. 							$QryUpdateFleet .= "`fleet_array` = '". $NewFleetArray ."', ";

    2072. 

  2072. 							$QryUpdateFleet .= "`fleet_mess` = '1'  ";

    2073. 

  2073. 							$QryUpdateFleet .= "WHERE ";

    2074. 

  2074. 							$QryUpdateFleet .= "`fleet_id` = '". $FleetRow["fleet_id"] ."';";

    2075. 

  2075. 							doquery( $QryUpdateFleet, 'fleets');

    2076. 

  2076. 							SendSimpleMessage ( $FleetOwner, '', $FleetRow['fleet_end_stay'], 15, $MessSender, $MessTitle, $lang['sys_expe_blackholl_1'] );

    2077. 

  2077. 						}

    2078. 

  2078. 						else

    2079. 

  2079. 						{

    2080. 

  2080. 							SendSimpleMessage ( $FleetOwner, '', $FleetRow['fleet_end_stay'], 15, $MessSender, $MessTitle, $lang['sys_expe_blackholl_2'] );

    2081. 

  2081. 							doquery ("DELETE FROM {{table}} WHERE `fleet_id` = ". $FleetRow["fleet_id"], 'fleets');

    2082. 

  2082. 						}

    2083. 

  2083. 					}

    2084. 

  2084. 				}

    2085. 

  2085. 				elseif ($Hasard == 3)

    2086. 

  2086. 				{

    2087. 

  2087. 					doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = ". $FleetRow["fleet_id"], 'fleets');

    2088. 

  2088. 					SendSimpleMessage ( $FleetOwner, '', $FleetRow['fleet_end_stay'], 15, $MessSender, $MessTitle, $lang['sys_expe_nothing_1'] );

    2089. 

  2089. 				}

    2090. 

  2090. 				elseif ($Hasard >= 4 && $Hasard < 7)

    2091. 

  2091. 				{

    2092. 

  2092. 					if ($FleetCapacity > 5000)

    2093. 

  2093. 					{

    2094. 

  2094. 						$MinCapacity	= $FleetCapacity - 5000;

    2095. 

  2095. 						$MaxCapacity 	= $FleetCapacity;

    2096. 

  2096. 						$FoundGoods  	= rand($MinCapacity, $MaxCapacity);

    2097. 

  2097. 						$FoundMetal  	= intval($FoundGoods / 2);

    2098. 

  2098. 						$FoundCrist  	= intval($FoundGoods / 4);

    2099. 

  2099. 						$FoundDeute  	= intval($FoundGoods / 6);

    2100. 

  2100. 						$FoundDark	 	= ( $FleetCapacity > 10000 ) ? intval ( 3 * log ( $FleetCapacity / 10000 ) * 100 ) : 0;

    2101. 

  2101. 						$FoundDark		= mt_rand ( $FoundDark / 2 , $FoundDark );

    2102. 

  2102. 

    2103. 

  2103. 						$QryUpdateFleet  = "UPDATE {{table}} SET ";

    2104. 

  2104. 						$QryUpdateFleet .= "`fleet_resource_metal` = `fleet_resource_metal` + '". $FoundMetal ."', ";

    2105. 

  2105. 						$QryUpdateFleet .= "`fleet_resource_crystal` = `fleet_resource_crystal` + '". $FoundCrist."', ";

    2106. 

  2106. 						$QryUpdateFleet .= "`fleet_resource_deuterium` = `fleet_resource_deuterium` + '". $FoundDeute ."', ";

    2107. 

  2107. 						$QryUpdateFleet .= "`fleet_resource_darkmatter` = `fleet_resource_darkmatter` + '". $FoundDark ."', ";

    2108. 

  2108. 						$QryUpdateFleet .= "`fleet_mess` = '1'  ";

    2109. 

  2109. 						$QryUpdateFleet .= "WHERE ";

    2110. 

  2110. 						$QryUpdateFleet .= "`fleet_id` = '". $FleetRow["fleet_id"] ."';";

    2111. 

  2111. 						doquery( $QryUpdateFleet, 'fleets');

    2112. 

  2112. 

    2113. 

  2113. 						$Message = sprintf($lang['sys_expe_found_goods'],

    2114. 

  2114. 						Format::pretty_number($FoundMetal), $lang['Metal'],

    2115. 

  2115. 						Format::pretty_number($FoundCrist), $lang['Crystal'],

    2116. 

  2116. 						Format::pretty_number($FoundDeute), $lang['Deuterium'],

    2117. 

  2117. 						Format::pretty_number($FoundDark), $lang['Darkmatter']);

    2118. 

  2118. 

    2119. 

  2119. 						SendSimpleMessage ( $FleetOwner, '', $FleetRow['fleet_end_stay'], 15, $MessSender, $MessTitle, $Message );

    2120. 

  2120. 					}

    2121. 

  2121. 				}

    2122. 

  2122. 				elseif ($Hasard == 7)

    2123. 

  2123. 				{

    2124. 

  2124. 					doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = ". $FleetRow["fleet_id"], 'fleets');

    2125. 

  2125. 					SendSimpleMessage ( $FleetOwner, '', $FleetRow['fleet_end_stay'], 15, $MessSender, $MessTitle, $lang['sys_expe_nothing_2'] );

    2126. 

  2126. 				}

    2127. 

  2127. 				elseif ($Hasard >= 8 && $Hasard < 11)

    2128. 

  2128. 				{

    2129. 

  2129. 					$FoundChance = $FleetPoints / $FleetCount;

    2130. 

  2130. 					for ($Ship = 202; $Ship <= 215; $Ship++)

    2131. 

  2131. 					{

    2132. 

  2132. 						if ($LaFlotte[$Ship] != 0)

    2133. 

  2133. 						{

    2134. 

  2134. 							$FoundShip[$Ship] = round($LaFlotte[$Ship] * $RatioGain[$Ship]) + 1;

    2135. 

  2135. 							if ($FoundShip[$Ship] > 0)

    2136. 

  2136. 								$LaFlotte[$Ship] += $FoundShip[$Ship];

    2137. 

  2137. 						}

    2138. 

  2138. 					}

    2139. 

  2139. 					$NewFleetArray = "";

    2140. 

  2140. 					$FoundShipMess = "";

    2141. 

  2141. 

    2142. 

  2142. 					foreach ($LaFlotte as $Ship => $Count)

    2143. 

  2143. 					{

    2144. 

  2144. 						if ($Count > 0)

    2145. 

  2145. 							$NewFleetArray   .= $Ship.",". $Count .";";

    2146. 

  2146. 					}

    2147. 

  2147. 

    2148. 

  2148. 					if ( $FoundShip != NULL )

    2149. 

  2149. 					{

    2150. 

  2150. 						foreach ($FoundShip as $Ship => $Count)

    2151. 

  2151. 						{

    2152. 

  2152. 							if ($Count != 0)

    2153. 

  2153. 								$FoundShipMess   .= $Count." ".$lang['tech'][$Ship].",";

    2154. 

  2154. 						}

    2155. 

  2155. 					}

    2156. 

  2156. 

    2157. 

  2157. 					$QryUpdateFleet  = "UPDATE {{table}} SET ";

    2158. 

  2158. 					$QryUpdateFleet .= "`fleet_array` = '". $NewFleetArray ."', ";

    2159. 

  2159. 					$QryUpdateFleet .= "`fleet_mess` = '1'  ";

    2160. 

  2160. 					$QryUpdateFleet .= "WHERE ";

    2161. 

  2161. 					$QryUpdateFleet .= "`fleet_id` = '". $FleetRow["fleet_id"] ."';";

    2162. 

  2162. 					doquery( $QryUpdateFleet, 'fleets');

    2163. 

  2163. 

    2164. 

  2164. 					$Message = $lang['sys_expe_found_ships']. $FoundShipMess . "";

    2165. 

  2165. 					SendSimpleMessage ( $FleetOwner, '', $FleetRow['fleet_end_stay'], 15, $MessSender, $MessTitle, $Message);

    2166. 

  2166. 				}

    2167. 

  2167. 			}

    2168. 

  2168. 		}

    2169. 

  2169. 		else

    2170. 

  2170. 		{

    2171. 

  2171. 			if ($FleetRow['fleet_end_time'] < time())

    2172. 

  2172. 			{

    2173. 

  2173. 				$farray = explode(";", $FleetRow['fleet_array']);

    2174. 

  2174. 				foreach ($farray as $Item => $Group)

    2175. 

  2175. 				{

    2176. 

  2176. 					if ($Group != '')

    2177. 

  2177. 					{

    2178. 

  2178. 						$Class = explode (",", $Group);

    2179. 

  2179. 						$FleetAutoQuery .= "`". $resource[$Class[0]]. "` = `". $resource[$Class[0]] ."` + ". $Class[1] .", ";

    2180. 

  2180. 					}

    2181. 

  2181. 				}

    2182. 

  2182. 				$QryUpdatePlanet  = "UPDATE {{table}} SET ";

    2183. 

  2183. 				$QryUpdatePlanet .= $FleetAutoQuery;

    2184. 

  2184. 				$QryUpdatePlanet .= "`metal` = `metal` + ". $FleetRow['fleet_resource_metal'] .", ";

    2185. 

  2185. 				$QryUpdatePlanet .= "`crystal` = `crystal` + ". $FleetRow['fleet_resource_crystal'] .", ";

    2186. 

  2186. 				$QryUpdatePlanet .= "`deuterium` = `deuterium` + ". $FleetRow['fleet_resource_deuterium'] ." ";

    2187. 

  2187. 

    2188. 

  2188. 				$QryUpdatePlanet .= "WHERE ";

    2189. 

  2189. 				$QryUpdatePlanet .= "`galaxy` = '". $FleetRow['fleet_start_galaxy'] ."' AND ";

    2190. 

  2190. 				$QryUpdatePlanet .= "`system` = '". $FleetRow['fleet_start_system'] ."' AND ";

    2191. 

  2191. 				$QryUpdatePlanet .= "`planet` = '". $FleetRow['fleet_start_planet'] ."' AND ";

    2192. 

  2192. 				$QryUpdatePlanet .= "`planet_type` = '". $FleetRow['fleet_start_type'] ."' ";

    2193. 

  2193. 				$QryUpdatePlanet .= "LIMIT 1 ;";

    2194. 

  2194. 				doquery( $QryUpdatePlanet, 'planets');

    2195. 

  2195. 

    2196. 

  2196. 				doquery("UPDATE `{{table}}` SET `darkmatter` = `darkmatter` + '".$FleetRow['fleet_resource_darkmatter']."' WHERE `id` =".$FleetRow['fleet_owner']." LIMIT 1 ;", 'users');

    2197. 

  2197. 				doquery ("DELETE FROM {{table}} WHERE `fleet_id` = ". intval($FleetRow["fleet_id"]), 'fleets');

    2198. 

  2198. 

    2199. 

  2199. 				SendSimpleMessage ( $FleetOwner, '', $FleetRow['fleet_end_time'], 15, $MessSender, $MessTitle, $lang['sys_expe_back_home'] );

    2200. 

  2200. 			}

    2201. 

  2201. 		}

    2202. 

  2202. 	}

    2203. 

  2203. 

    2204. 

  2204. 	public function __construct (&$planet)

    2205. 

  2205. 	{

    2206. 

  2206. 		global $resource;

    2207. 

  2207. 

    2208. 

  2208. 		doquery("LOCK TABLE {{table}}aks WRITE, {{table}}rw WRITE, {{table}}errors WRITE, {{table}}messages WRITE, {{table}}fleets WRITE,  {{table}}planets WRITE, {{table}}galaxy WRITE ,{{table}}users WRITE", "");

    2209. 

  2209. 

    2210. 

  2210. 		$QryFleet   = "SELECT * FROM {{table}} ";

    2211. 

  2211. 		$QryFleet  .= "WHERE (";

    2212. 

  2212. 		$QryFleet  .= "( ";

    2213. 

  2213. 		$QryFleet  .= "`fleet_start_galaxy` = ". $planet['galaxy']      ." AND ";

    2214. 

  2214. 		$QryFleet  .= "`fleet_start_system` = ". $planet['system']      ." AND ";

    2215. 

  2215. 		$QryFleet  .= "`fleet_start_planet` = ". $planet['planet']      ." AND ";

    2216. 

  2216. 		$QryFleet  .= "`fleet_start_type` = ".   $planet['planet_type'] ." ";

    2217. 

  2217. 		$QryFleet  .= ") OR ( ";

    2218. 

  2218. 		$QryFleet  .= "`fleet_end_galaxy` = ".   $planet['galaxy']      ." AND ";

    2219. 

  2219. 		$QryFleet  .= "`fleet_end_system` = ".   $planet['system']      ." AND ";

    2220. 

  2220. 		$QryFleet  .= "`fleet_end_planet` = ".   $planet['planet']      ." ) AND ";

    2221. 

  2221. 		$QryFleet  .= "`fleet_end_type`= ".      $planet['planet_type'] ." ) AND ";

    2222. 

  2222. 		$QryFleet  .= "( `fleet_start_time` < '". time() ."' OR `fleet_end_time` < '". time() ."' );";

    2223. 

  2223. 		$fleetquery = doquery( $QryFleet, 'fleets' );

    2224. 

  2224. 

    2225. 

  2225. 

    2226. 

  2226. 		while ($CurrentFleet = mysql_fetch_array($fleetquery))

    2227. 

  2227. 		{

    2228. 

  2228. 			switch ($CurrentFleet["fleet_mission"])

    2229. 

  2229. 			{

    2230. 

  2230. 				case 1:

    2231. 

  2231. 					$this->MissionCaseAttack($CurrentFleet);

    2232. 

  2232. 					break;

    2233. 

  2233. 

    2234. 

  2234. 				case 2:

    2235. 

  2235. 					$this->MissionCaseACS($CurrentFleet);

    2236. 

  2236. 					break;

    2237. 

  2237. 

    2238. 

  2238. 				case 3:

    2239. 

  2239. 					$this->MissionCaseTransport($CurrentFleet);

    2240. 

  2240. 					break;

    2241. 

  2241. 

    2242. 

  2242. 				case 4:

    2243. 

  2243. 					$this->MissionCaseStay($CurrentFleet);

    2244. 

  2244. 					break;

    2245. 

  2245. 

    2246. 

  2246. 				case 5:

    2247. 

  2247. 					$this->MissionCaseStayAlly($CurrentFleet);

    2248. 

  2248. 					break;

    2249. 

  2249. 

    2250. 

  2250. 				case 6:

    2251. 

  2251. 					$this->MissionCaseSpy($CurrentFleet);

    2252. 

  2252. 					break;

    2253. 

  2253. 

    2254. 

  2254. 				case 7:

    2255. 

  2255. 					$this->MissionCaseColonisation($CurrentFleet);

    2256. 

  2256. 					break;

    2257. 

  2257. 

    2258. 

  2258. 				case 8:

    2259. 

  2259. 					$this->MissionCaseRecycling($CurrentFleet);

    2260. 

  2260. 					break;

    2261. 

  2261. 

    2262. 

  2262. 				case 9:

    2263. 

  2263. 					$this->MissionCaseDestruction($CurrentFleet);

    2264. 

  2264. 					break;

    2265. 

  2265. 

    2266. 

  2266. 				case 10:

    2267. 

  2267. 					$this->MissionCaseMIP($CurrentFleet);

    2268. 

  2268. 					break;

    2269. 

  2269. 

    2270. 

  2270. 				case 15:

    2271. 

  2271. 					$this->MissionCaseExpedition($CurrentFleet);

    2272. 

  2272. 					break;

    2273. 

  2273. 

    2274. 

  2274. 				default:

    2275. 

  2275. 					doquery("DELETE FROM {{table}} WHERE `fleet_id` = '". $CurrentFleet['fleet_id'] ."';", 'fleets');

    2276. 

  2276. 

    2277. 

  2277. 			}

    2278. 

  2278. 		}

    2279. 

  2279. 

    2280. 

  2280. 		doquery("UNLOCK TABLES", "");

    2281. 

  2281. 

    2282. 

  2282. 	}

    2283. 

  2283. }

    2284. 

  2284. ?>
    2285.