<?php

 /*
  _    _                                      _                   _                 
 | |  | |                                    | |                 | |                
 | |  | |   __ _    __ _   _ __ ___     ___  | |   __ _   _ __   | |   __ _   _   _  © 2008-2009
 | |  | |  / _  |  / _  | |  _   _ \   / _ \ | |  / _  | |  _ \  | |  / _  | | | | |
 | |__| | | (_| | | (_| | | | | | | | |  __/ | | | (_| | | |_) | | | | (_| | | |_| |
  \____/   \__  |  \____| |_| |_| |_|  \___| |_|  \____| |  __/  |_|  \____|  \__  |
            __/ |                                        | |                   __/ |
           |___/                                         |_|                  |___/ 

 * @author http://www.ugamelaplay.net/
 * @copyright 2008-2009 Ugamelaplay
 * @package Ugamelaplay
 * @author http://www.ugamelaplay.net
 
 */
function MissionCaseBattle ( $FleetRow ) {
	global $user, $phpEx, $ugamelaplay_root_dir, $pricelist, $lang, $resource, $CombatCaps;
	if ($FleetRow['fleet_start_time'] <= time()) {
		if ($FleetRow['fleet_mess'] == 0) {
			if (!isset($CombatCaps[202]['sd'])) {
				message("<font color=\"red\">". $lang['sys_no_vars'] ."</font>", $lang['sys_error'], "fleet." . $phpEx, 2);
			}
			if ($FleetRow['fleet_group'] != "0") {
              doquery("UPDATE {{table}} SET fleet_mess=1 WHERE fleet_group = '".$FleetRow['fleet_group']."';",'fleets');
				//doquery("DELETE FROM {{table}} WHERE id = '".$FleetRow['fleet_group']."';",'aks');
            } else {
                doquery("UPDATE {{table}} SET fleet_mess=1 WHERE fleet_id=".$FleetRow['fleet_id'],'fleets');
			}
			$Attackers = array();
			$Defenders = array();
			$AttackersArray = array();
			$DefendersArray = array();
			$total_ships = 0;
			if ($FleetRow['fleet_group'] != "0") { // Si c'est une AG
				$fleets = doquery('SELECT * FROM {{table}} WHERE fleet_group = "'.$FleetRow['fleet_group'].'";','fleets'); // Selection de toute les flottes composant l'AG
				$Count = 0;
				while ($fleet =  $GLOBALS['db_fetch_assoc']($fleets)) {
					$Attackers[$Count] = array();
					$CurrentUser = doquery('SELECT * FROM {{table}} WHERE id ='.$fleet['fleet_owner'],'users', true);
					$AttackersArray[$Count]['user'] = $CurrentUser;
					$AttackersArray[$Count]['fleet'] = $fleet;
					$Attackers[$Count][0] = $CurrentUser['id'];
					if($CurrentUser['strat_center'] == 1){
						$CurrentUser['military_tech'] += 3;
					}					
					$Attackers[$Count][1] = array('military_tech' => $CurrentUser['military_tech'], 'defence_tech' => $CurrentUser['defence_tech'], 'shield_tech' => $CurrentUser['shield_tech']);
					$Attackers[$Count][2] = array('rpg_amiral' => $CurrentUser['rpg_amiral']);
					
					
					$temp = explode(';', $fleet['fleet_array']);
					$NowFleets = array();
					foreach ($temp as $temp2) {
						$temp2 = explode(',', $temp2);
						
						if ($temp2[0] < 100) continue;
						
						if (!isset($NowFleets[$temp2[0]])) $NowFleets[$temp2[0]] = 0;
						$NowFleets[$temp2[0]] += $temp2[1];
						$total_ships += $temp2[1];
					}
					$Attackers[$Count][3] = $NowFleets;
					$Count++;
				}		
			}else{
				$QryCurrentUser   = "SELECT * FROM {{table}} ";
				$QryCurrentUser  .= "WHERE ";
				$QryCurrentUser  .= "`id` = '". $FleetRow['fleet_owner'] ."';";
				$CurrentUser      = doquery($QryCurrentUser , 'users', true);
				$CurrentUserID    = $CurrentUser['id'];
					$AttackersArray[0]['user'] = $CurrentUser;
					$AttackersArray[0]['fleet'] = $FleetRow;
					$Attackers[0] = array();
					$Attackers[0][0] = $CurrentUser['id'];
					if($CurrentUser['strat_center'] == 1){
						$CurrentUser['military_tech'] += 3;
					}					
					$Attackers[0][1] = array('military_tech' => $CurrentUser['military_tech'], 'defence_tech' => $CurrentUser['defence_tech'], 'shield_tech' => $CurrentUser['shield_tech']);
					$Attackers[0][2] = array('rpg_amiral' => $CurrentUser['rpg_amiral']);
					$temp = explode(';',$FleetRow['fleet_array']);
					$NowFleets = array();
					foreach ($temp as $temp2) {
						$temp2 = explode(',', $temp2);
						
						if ($temp2[0] < 100) continue;
						
						if (!isset($NowFleets[$temp2[0]])) $NowFleets[$temp2[0]] = 0;
						$NowFleets[$temp2[0]] += $temp2[1];
						$total_ships += $temp2[1];
					}
					$Attackers[0][3] = $NowFleets;
			}
				$QryTargetPlanet  = "SELECT * FROM {{table}} ";
				$QryTargetPlanet .= "WHERE ";
				$QryTargetPlanet .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";
				$QryTargetPlanet .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";
				$QryTargetPlanet .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' AND ";
				$QryTargetPlanet .= "`planet_type` = '". $FleetRow['fleet_end_type'] ."';";
				$TargetPlanet     = doquery( $QryTargetPlanet, 'planets', true);
				$TargetUserID     = $TargetPlanet['id_owner'];
				
				$QryTargetPlanet  = "SELECT * FROM {{table}} ";
				$QryTargetPlanet .= "WHERE ";
				$QryTargetPlanet .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";
				$QryTargetPlanet .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";
				$QryTargetPlanet .= "`planet` = '". $FleetRow['fleet_end_planet'] ."';";
				$TargetGalaxy     = doquery( $QryTargetPlanet, 'galaxy', true);
				$TargetMoon       = $TargetGalaxy['luna'];	
				
				$QryTargetUser    = "SELECT * FROM {{table}} ";
				$QryTargetUser   .= "WHERE ";
				$QryTargetUser   .= "`id` = '". $TargetUserID ."';";
				$TargetUser       = doquery($QryTargetUser, 'users', true);

				if($TargetUser['strat_center'] == 1){
					$TargetUser['military_tech'] += 3;
				}
				$reg_defense = 70;
				if($TargetUser['def_core'] == 1){
					$reg_defense = 80;
				}
				if($TargetPlanet['emp_block'] >= time()){
					$emp_block = true;
				}else{
					$emp_block = false;
				}				
				UpdatePlanet($TargetPlanet, $TargetUser, time());
				$TargetPlanet     = doquery( $QryTargetPlanet, 'planets', true);
				$TargetSet = array();
				for ($SetItem = 200; $SetItem < 500; $SetItem++) {
					if ($TargetPlanet[$resource[$SetItem]] > 0) {
						$TargetSet[$SetItem] = $TargetPlanet[$resource[$SetItem]];
					}
				}
					$DefendersArray[0]['user'] = $TargetUser;
					$DefendersArray[0]['fleet'] = array('fleet_end_galaxy' => $TargetUser['galaxy'],'fleet_end_system' => $TargetUser['system'],'fleet_end_planet' => $TargetUser['planet'] );
					$Defenders[0] = array();
					$Defenders[0][0] = $TargetUser['id'];
					if($TargetUser['strat_center'] == 1){
						$TargetUser['military_tech'] += 3;
					}					
					$Defenders[0][1] = array('military_tech' => $TargetUser['military_tech'], 'defence_tech' => $TargetUser['defence_tech'], 'shield_tech' => $TargetUser['shield_tech']);
					$Defenders[0][2] = array('rpg_amiral' => $TargetUser['rpg_amiral']);
					$temp = explode(';',$FleetRow['fleet_array']);
					$NowFleets = array();
					$Defenders[0][3] = $TargetSet;

					
				$def = doquery('SELECT * FROM {{table}} WHERE `fleet_end_galaxy` = '. $FleetRow['fleet_end_galaxy'] .' AND `fleet_end_system` = '. $FleetRow['fleet_end_system'] .' AND `fleet_end_type` = '. $FleetRow['fleet_end_type'] .' AND `fleet_end_planet` = '. $FleetRow['fleet_end_planet'] .' AND fleet_start_time < '.time().' AND fleet_end_stay >= '.time().' AND fleet_id != '.$FleetRow['fleet_id'].' AND `fleet_mission` = 5','fleets');
				$Count = 1;
				while ($fleet =  $GLOBALS['db_fetch_assoc']($def)) {
					$Defenders[$Count] = array();
					$DefendersArray[$Count]['user'] = $TargetUser;
					$DefendersArray[$Count]['fleet'] = $fleet;
					$TargetUser = doquery('SELECT * FROM {{table}} WHERE id ='.$fleet['fleet_owner'],'users', true);
					$Defenders[$Count][0] = $TargetUser['id'];
					if($TargetUser['strat_center'] == 1){
						$TargetUser['military_tech'] += 3;
					}					
					$Defenders[$Count][1] = array('military_tech' => $TargetUser['military_tech'], 'defence_tech' => $TargetUser['defence_tech'], 'shield_tech' => $TargetUser['shield_tech']);
					$Defenders[$Count][2] = array('rpg_amiral' => $TargetUser['rpg_amiral']);
					
					
					$temp = explode(';', $fleet['fleet_array']);
					$NowFleets = array();
					foreach ($temp as $temp2) {
						$temp2 = explode(',', $temp2);
						
						if ($temp2[0] < 100) continue;
						
						if (!isset($NowFleets[$temp2[0]])) $NowFleets[$temp2[0]] = 0;
						$NowFleets[$temp2[0]] += $temp2[1];
						$total_ships += $temp2[1];
					}
					$Defenders[$Count][3] = $NowFleets;
					$Count++;
				}		
			include_once($ugamelaplay_root_dir . 'includes/BattleEngine.' . $phpEx);
			$StartRound = array();
			$StartRound['attackers'] = $Attackers;
			$StartRound['defenders'] = $Defenders;
			$Battle = Battle($Attackers, $Defenders, MAX_ROUNDS, $reg_defense, $emp_block, $total_ships);
			$FleetResult  = $Battle['won'];
			$dane_do_rw   = $Battle["rounds"];
			$FleetArray2   = array();
			$FleetAmount  = array();
			$FleetStorage = array();
			$FleetStorage2 = array();
			$StoragePerFleet = array('metal' => 0, 'crystal' => 0, 'deuterium' => 0, 'hidrogeno' => 0);
			foreach($Battle['attackers'] as $Order => $Array){
				$FleetStorage[$Order] = 0;
				$FleetStorage2[$Order] = 0;
				$FleetArray2[$Order] = array();
				$FleetAmount[$Order] = 0;
				foreach($Array as $Pass){
					if($Pass['ship'] == 201 or $Pass['ship'] == 220){
						$FleetStorage[$Order] += $pricelist[$Pass['ship']]["capacity"] * $Pass['count'];
						$FleetStorage2[$Order] += $pricelist[$Pass['ship']]["capacity"] * $Pass['count'];
					}else{
						$FleetStorage[$Order] += $pricelist[$Pass['ship']]["capacity"] * $Pass['count'];					
					}
					$FleetStorage[$Order] -= $AttackersArray[$Order]['fleet']["fleet_resource_metal"];
					$FleetStorage[$Order] -= $AttackersArray[$Order]['fleet']["fleet_resource_crystal"];
					$FleetStorage[$Order] -= $AttackersArray[$Order]['fleet']["fleet_resource_deuterium"];
					$FleetStorage2[$Order] -= $AttackersArray[$Order]['fleet']["fleet_resource_hidrogeno"];
					$FleetAmount[$Order] + $Pass['count'];
					$FleetArray2[$Order][$Pass['ship']] + $Pass['count'];
				}	
			}

			

					$TargetPlanetUpd = "";
					if(is_array($Battle['last_round']['defenders'][0]['Ships'])){
						foreach($Battle['last_round']['defenders'][0]['Ships'] as $Ship => $Details){
							$TargetPlanetUpd .= "`". $resource[$Ship] ."` = '". $Details['count'] ."', ";
						}
					}

			// Determination des ressources pillées
			$Mining['metal']   = 0;
			$Mining['crystal'] = 0;
			$Mining['deuter']  = 0;
			$Mining['hidrogeno']  = 0;
			$AttackersResources = array();
			if ($FleetResult == "a") {
				$TotalAtt = count($Battle['attackers']);
				foreach($Battle['attackers'] as $Order => $Array){
					$AttackersResources[$Order] = array('metal' => 0, 'crystal' => 0, 'deuterium' => 0, 'hidrogeno' => 0);
					if ($FleetStorage[$Order] > 0) {
						$resources_divider = 0.5;
						if($AttackersArray[$Order]['user']['link_center'] == 1){
							$resources_divider = 0.65;
						}
						$metal   = ($TargetPlanet['metal'] * $resources_divider) / $TotalAtt;
						$crystal = ($TargetPlanet['crystal'] * $resources_divider) / $TotalAtt ;
						$deuter  = ($TargetPlanet["deuterium"] * $resources_divider) / $TotalAtt ;
						$hidrogeno  = ($TargetPlanet["hidrogeno"] * $resources_divider) / $TotalAtt;
						if (($hidrogeno) > $FleetStorage2[$Order] / 4) {
							$Mining['hidrogeno']  += $FleetStorage2[$Order] / 4;
							$AttackersResources[$Order]['hidrogeno'] = $FleetStorage2[$Order] / 4;
							$FleetStorage2[$Order]      = $FleetStorage2[$Order] - $FleetStorage2[$Order] / 4;
						} else {
							$Mining['hidrogeno']  += $hidrogeno;
							$AttackersResources[$Order]['hidrogeno'] = $hidrogeno;
							$FleetStorage2[$Order]      = $FleetStorage2[$Order] - $hidrogeno;
						}						
						if (($metal) > $FleetStorage[$Order] / 3) {
							$Mining['metal']   += $FleetStorage[$Order] / 3;
							$AttackersResources[$Order]['metal'] = $FleetStorage[$Order] / 3;
							$FleetStorage[$Order]      = $FleetStorage[$Order] - $FleetStorage[$Order] / 3;
						} else {
							$Mining['metal']   += $metal;
							$AttackersResources[$Order]['metal'] = $metal;
							$FleetStorage[$Order]      = $FleetStorage[$Order] - $metal;
						}

						if (($crystal) > $FleetStorage[$Order] / 2) {
							$Mining['crystal'] += $FleetStorage[$Order] / 2;
							$AttackersResources[$Order]['crystal'] = $FleetStorage[$Order] / 2;
							$FleetStorage[$Order]      = $FleetStorage[$Order] - $FleetStorage[$Order] / 2;
						} else {
							$Mining['crystal'] += $crystal;
							$AttackersResources[$Order]['crystal'] = $crystal;
							$FleetStorage[$Order]      = $FleetStorage[$Order] - $crystal;
						}

						if (($deuter) > $FleetStorage[$Order]) {
							$Mining['deuter']  += $FleetStorage[$Order];
							$AttackersResources[$Order]['deuterium'] = $FleetStorage[$Order];
							$FleetStorage[$Order]      = $FleetStorage[$Order] - $FleetStorage[$Order];
						} else {
							$Mining['deuter']  += $deuter;
							$AttackersResources[$Order]['deuterium'] = $FleetStorage[$Order] / 4;
							$FleetStorage[$Order]      = $FleetStorage[$Order] - $deuter;
						}
					}
				}
			}
			$Mining['metal']   = pretty_number($Mining['metal']);
			$Mining['crystal'] = pretty_number($Mining['crystal']);
			$Mining['deuter']  = pretty_number($Mining['deuter']);
			$Mining['hidrogeno']  = pretty_number($Mining['hidrogeno']);

			// Mise a jour de l'enregistrement de la planete attaquée
			$QryUpdateTarget  = "UPDATE {{table}} SET ";
			$QryUpdateTarget .= $TargetPlanetUpd;
			$QryUpdateTarget .= "`metal` = `metal` - '". $Mining['metal'] ."', ";
			$QryUpdateTarget .= "`crystal` = `crystal` - '". $Mining['crystal'] ."', ";
			$QryUpdateTarget .= "`hidrogeno` = `hidrogeno` - '". $Mining['hidrogeno'] ."', ";
			$QryUpdateTarget .= "`deuterium` = `deuterium` - '". $Mining['deuter'] ."' ";
			$QryUpdateTarget .= "WHERE ";
			$QryUpdateTarget .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";
			$QryUpdateTarget .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";
			$QryUpdateTarget .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' AND ";
			$QryUpdateTarget .= "`planet_type` = '". $FleetRow['fleet_end_type'] ."' ";
			$QryUpdateTarget .= "LIMIT 1;";
			doquery( $QryUpdateTarget , 'planets');

			// Mise a jour du champ de ruine devant la planete attaquée
			$QryUpdateGalaxy  = "UPDATE {{table}} SET ";
			$QryUpdateGalaxy .= "`metal` = `metal` + '". abs($Battle['debris']['metal']) ."', ";
			$QryUpdateGalaxy .= "`crystal` = `crystal` + '". abs($Battle['debris']['crystal']) ."' ";
			$QryUpdateGalaxy .= "WHERE ";
			$QryUpdateGalaxy .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";
			$QryUpdateGalaxy .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";
			$QryUpdateGalaxy .= "`planet` = '". $FleetRow['fleet_end_planet'] ."' ";
			$QryUpdateGalaxy .= "LIMIT 1;";
			doquery( $QryUpdateGalaxy , 'galaxy');

			// Là on va discuter le bout de gras pour voir s'il y a moyen d'avoir une Lune !

			$AttackDate        = date("D M d H:i:s", $FleetRow["fleet_start_time"]);
			$title             = sprintf ($lang['sys_attack_title'], $AttackDate);
			$raport            = "<center><table><tr><td class='c'>". $title ."<br></td></tr><tr height='50'><td>&nbsp;</td></tr>";
			$zniszczony        = false;
			$a_zestrzelona     = 0;
			$DefendTechon['A'] = $TargetTechno["military_tech"] * 10;
			$DefendTechon['B'] = $TargetTechno["defence_tech"] * 10;
			$DefendTechon['C'] = $TargetTechno["shield_tech"] * 10;
			$DefenderData      = sprintf ($lang['sys_attack_defender_pos'], $TargetUser["username"], $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet'] );
			$DefenderTech      = sprintf ($lang['sys_attack_techologies'], $DefendTechon['A'], $DefendTechon['B'], $DefendTechon['C']);
			// mod TOP KB
			$angreifer     = $CurrentUser["username"];
			$defender      = $TargetUser["username"];
			// mod TOP KB
			$roundas = 0;
			$TotalAttack = array('attackers' => 0, 'defenders' => 0);
			foreach ($dane_do_rw as $a => $b) {
				$roundas++;
				$raport .= "<tr><th><center><table border=1 width=80%><div style=\"border-top: 1px dashed rgb(102, 102, 102); border-right: 1px dashed rgb(102, 102, 102); width: 100%; height: 22px; text-align: right; font-size: 21px; color: rgb(153, 153, 153);\"><span style='border-left: 1px dashed rgb(102, 102, 102);border-bottom: 1px dashed rgb(102, 102, 102);'>Ronda $roundas</span></div>";
				foreach($b['attackers'] as $Attacker => $Array){
				$Ships = $Array['Ships'];
				$AttackTechon['A'] = $AttackersArray[$Attacker]['user']["military_tech"] * 10;
				$AttackTechon['B'] = $AttackersArray[$Attacker]['user']["defence_tech"] * 10;
				$AttackTechon['C'] = $AttackersArray[$Attacker]['user']["shield_tech"] * 10;
				$AttackerData      = sprintf ($lang['sys_attack_attacker_pos'], $AttackersArray[$Attacker]['user']["username"], $AttackersArray[$Attacker]['fleet']['fleet_start_galaxy'], $AttackersArray[$Attacker]['fleet']['fleet_start_system'], $AttackersArray[$Attacker]['fleet']['fleet_start_planet'] );
				$AttackerTech      = sprintf ($lang['sys_attack_techologies'], $AttackTechon['A'], $AttackTechon['B'], $AttackTechon['C']);

				$raport .= "<tr><td class='c'><center>".$AttackerData."<br />".$AttackerTech."</center></td></tr><tr><th><center><table border=1>";
					
					if (is_array($Ships)) {
						$raport1 = "<tr><th>".$lang['sys_ship_type']."</th>";
						$raport2 = "<tr><th>".$lang['sys_ship_count']."</th>";
						$raport3 = "<tr><th>".$lang['sys_ship_weapon']."</th>";
						$raport4 = "<tr><th>".$lang['sys_ship_shield']."</th>";
						$raport5 = "<tr><th>".$lang['sys_ship_armour']."</th>";
						foreach ($Ships as $Ship => $Data) {
							if (is_numeric($Ship)) {
								if ($Data['count'] > 0) {
									$raport1 .= "<th>". $lang["tech"][$Ship] ."</th>";
									$raport2 .= "<th>". pretty_number($Data['count']) ."</th>";
									$raport3 .= "<th>". pretty_number(round($Data["attack"])) ."</th>";
									$raport4 .= "<th>". pretty_number(round($Data["shield"])) ."</th>";
									$raport5 .= "<th>". pretty_number(round($Data["integrity"])) ."</th>";
								}
							}
						}
						$raport1 .= "</tr>";
						$raport2 .= "</tr>";
						$raport3 .= "</tr>";
						$raport4 .= "</tr>";
						$raport5 .= "</tr>";
						$raport .= $raport1 . $raport2 . $raport3 . $raport4 . $raport5;
					} else {
						$raport .= "<br />". $lang['sys_destroyed'];
					}
					$raport .= "</table></center></th></tr>";
				}
				$raport .= "<tr><th><center>VS</center></th></tr>";
				foreach($b['defenders'] as $Defender => $Array){
				$Ships = $Array['Ships'];
				$DefendTechon['A'] = $DefendersArray[$Defender]['user']["military_tech"] * 10;
				$DefendTechon['B'] = $DefendersArray[$Defender]['user']["defence_tech"] * 10;
				$DefendTechon['C'] = $DefendersArray[$Defender]['user']["shield_tech"] * 10;
				$DefenderData      = sprintf ($lang['sys_attack_defender_pos'], $DefendersArray[$Defender]['user']["username"], $DefendersArray[$Defender]['fleet']['fleet_end_galaxy'], $DefendersArray[$Defender]['fleet']['fleet_end_system'], $DefendersArray[$Defender]['fleet']['fleet_end_planet'] );
				$DefenderTech      = sprintf ($lang['sys_attack_techologies'], $DefendTechon['A'], $DefendTechon['B'], $DefendTechon['C']);
					
				$raport .= "<tr><td class='c'><center>".$DefenderData."<br />".$DefenderTech."</center></td></tr><tr><th><br /><center><table border=1>";

					if (is_array($Ships)) {
						$raport1 = "<tr><th>".$lang['sys_ship_type']."</th>";
						$raport2 = "<tr><th>".$lang['sys_ship_count']."</th>";
						$raport3 = "<tr><th>".$lang['sys_ship_weapon']."</th>";
						$raport4 = "<tr><th>".$lang['sys_ship_shield']."</th>";
						$raport5 = "<tr><th>".$lang['sys_ship_armour']."</th>";
						foreach ($Ships as $Ship => $Data) {
							if (is_numeric($Ship)) {
								if ($Data['count'] > 0) {
									$raport1 .= "<th>". $lang["tech"][$Ship] ."</th>";
									$raport2 .= "<th>". pretty_number($Data['count']) ."</th>";
									$raport3 .= "<th>". pretty_number(round($Data["attack"])) ."</th>";
									$raport4 .= "<th>". pretty_number(round($Data["shield"])) ."</th>";
									$raport5 .= "<th>". pretty_number(round($Data["integrity"])) ."</th>";
								}
							}
						}
						$raport1 .= "</tr>";
						$raport2 .= "</tr>";
						$raport3 .= "</tr>";
						$raport4 .= "</tr>";
						$raport5 .= "</tr>";
						$raport .= $raport1 . $raport2 . $raport3 . $raport4 . $raport5;
					} else {
						$raport .= "<br />". $lang['sys_destroyed'];
					}
					$raport .= "</table></center>";
				}
				$raport .= "</th></tr></table>";
					$TotalAttack['defenders'] += floor($b["Materials"]["attack_a"] - floor($b["Materials"]["shield_b"]));
					$TotalAttack['attackers'] += floor($b["Materials"]["attack_b"] - floor($b["Materials"]["shield_a"]));
					$AttackWaveStat    = sprintf ($lang['sys_attack_attack_wave'], pretty_number(floor($b["Materials"]["attack_a"])), pretty_number(floor($b["Materials"]["shield_b"])))/*. ' Destruyo un total de '.pretty_number($b["Materials"]["destroyed_b"]).' unidades de combate.'*/;
					$DefendWavaStat    = sprintf ($lang['sys_attack_defend_wave'], pretty_number(floor($b["Materials"]["attack_b"])), pretty_number(floor($b["Materials"]["shield_a"])))/*. ' Destruyo un total de '.pretty_number($b["Materials"]["destroyed_a"]).' unidades de combate.'*/;
					$raport           .= "<br />".$AttackWaveStat."<br />".$DefendWavaStat."</center></th></tr><tr height='10'><td>&nbsp;</td></tr>";
			}
			$raport .= "<tr height='10'><td>&nbsp;</td></tr><tr><td class='c'>Resultado de la batalla:</td></tr><tr><th><center>";
				$raport .= "<table border=1 width=80%><div style=\"border-top: 1px dashed rgb(102, 102, 102); border-right: 1px dashed rgb(102, 102, 102); width: 100%; height: 22px; text-align: right; font-size: 21px; color: rgb(153, 153, 153);\"><span style='border-left: 1px dashed rgb(102, 102, 102);border-bottom: 1px dashed rgb(102, 102, 102);'>Resultado</span></div><center>";
				foreach($Battle['last_round']['attackers'] as $Attacker => $Array){
				$Ships = $Array['Ships'];
				$AttackTechon['A'] = $AttackersArray[$Attacker]['user']["military_tech"] * 10;
				$AttackTechon['B'] = $AttackersArray[$Attacker]['user']["defence_tech"] * 10;
				$AttackTechon['C'] = $AttackersArray[$Attacker]['user']["shield_tech"] * 10;
				$AttackerData      = sprintf ($lang['sys_attack_attacker_pos'], $AttackersArray[$Attacker]['user']["username"], $AttackersArray[$Attacker]['fleet']['fleet_start_galaxy'], $AttackersArray[$Attacker]['fleet']['fleet_start_system'], $AttackersArray[$Attacker]['fleet']['fleet_start_planet'] );
				$AttackerTech      = sprintf ($lang['sys_attack_techologies'], $AttackTechon['A'], $AttackTechon['B'], $AttackTechon['C']);

				$raport .= "<tr><td class='c'><center>".$AttackerData."<br />".$AttackerTech."</center></td></tr><tr><th><center><table border=1>";
					
					if (is_array($Ships)) {
						$raport1 = "<tr><th>".$lang['sys_ship_type']."</th>";
						$raport2 = "<tr><th>".$lang['sys_ship_count']."</th>";
						$raport3 = "<tr><th>".$lang['sys_ship_weapon']."</th>";
						$raport4 = "<tr><th>".$lang['sys_ship_shield']."</th>";
						$raport5 = "<tr><th>".$lang['sys_ship_armour']."</th>";
						foreach ($Ships as $Ship => $Data) {
							if (is_numeric($Ship)) {
								if ($Data['count'] > 0) {
									$raport1 .= "<th>". $lang["tech"][$Ship] ."</th>";
									$raport2 .= "<th>". pretty_number($Data['count']) ."</th>";
									$raport3 .= "<th>". pretty_number(round($Data["attack"])) ."</th>";
									$raport4 .= "<th>". pretty_number(round($Data["shield"])) ."</th>";
									$raport5 .= "<th>". pretty_number(round($Data["integrity"])) ."</th>";
								}
							}
						}
						$raport1 .= "</tr>";
						$raport2 .= "</tr>";
						$raport3 .= "</tr>";
						$raport4 .= "</tr>";
						$raport5 .= "</tr>";
						$raport .= $raport1 . $raport2 . $raport3 . $raport4 . $raport5;
					} else {
						$raport .= "<br />". $lang['sys_destroyed'];
					}
					$raport .= "</table></center></th></tr>";
				}
				$raport .= "<tr><th><center>VS</center></th></tr>";
				foreach($Battle['last_round']['defenders'] as $Defender => $Array){
				$Ships = $Array['Ships'];
				$DefendTechon['A'] = $DefendersArray[$Defender]['user']["military_tech"] * 10;
				$DefendTechon['B'] = $DefendersArray[$Defender]['user']["defence_tech"] * 10;
				$DefendTechon['C'] = $DefendersArray[$Defender]['user']["shield_tech"] * 10;
				$DefenderData      = sprintf ($lang['sys_attack_defender_pos'], $DefendersArray[$Defender]['user']["username"], $DefendersArray[$Defender]['fleet']['fleet_end_galaxy'], $DefendersArray[$Defender]['fleet']['fleet_end_system'], $DefendersArray[$Defender]['fleet']['fleet_end_planet'] );
				$DefenderTech      = sprintf ($lang['sys_attack_techologies'], $DefendTechon['A'], $DefendTechon['B'], $DefendTechon['C']);
					
				$raport .= "<center><tr><td class='c'><center>".$DefenderData."<br />".$DefenderTech."</center></td></tr><tr><th><br /><center><table border=1>";

					if (is_array($Ships)) {
						$raport1 = "<tr><th>".$lang['sys_ship_type']."</th>";
						$raport2 = "<tr><th>".$lang['sys_ship_count']."</th>";
						$raport3 = "<tr><th>".$lang['sys_ship_weapon']."</th>";
						$raport4 = "<tr><th>".$lang['sys_ship_shield']."</th>";
						$raport5 = "<tr><th>".$lang['sys_ship_armour']."</th>";
						foreach ($Ships as $Ship => $Data) {
							if (is_numeric($Ship)) {
								if ($Data['count'] > 0) {
									$raport1 .= "<th>". $lang["tech"][$Ship] ."</th>";
									$raport2 .= "<th>". pretty_number($Data['count']) ."</th>";
									$raport3 .= "<th>". pretty_number(round($Data["attack"])) ."</th>";
									$raport4 .= "<th>". pretty_number(round($Data["shield"])) ."</th>";
									$raport5 .= "<th>". pretty_number(round($Data["integrity"])) ."</th>";
								}
							}
						}
						$raport1 .= "</tr>";
						$raport2 .= "</tr>";
						$raport3 .= "</tr>";
						$raport4 .= "</tr>";
						$raport5 .= "</tr>";
						$raport .= $raport1 . $raport2 . $raport3 . $raport4 . $raport5;
					} else {
						$raport .= "<br />". $lang['sys_destroyed'];
					}
					$raport .= "</table></center>";
				}
				$raport .= "</th></tr></center></table></center>";			
			$FleetDebris      = abs($Battle['debris']['metal']) + abs($Battle['debris']['crystal']);
			$StrAttackerUnits = sprintf ($lang['sys_attacker_lostunits'], pretty_number(abs($TotalAttack['attackers'])));
			$StrDefenderUnits = sprintf ($lang['sys_defender_lostunits'], pretty_number(abs($TotalAttack['defenders'])));
			$StrRuins         = sprintf ($lang['sys_gcdrunits'], pretty_number(abs($Battle['debris']['metal'])), $lang['Metal'], pretty_number(abs($Battle['debris']['crystal'])), $lang['Crystal']);
			// mod TOP KB
			$strunitsgesamt      = $Battle['lostunits']['attackers'] + $Battle['lostunits']['defenders'];
			$user1lostunits      = $Battle['lostunits']['attackers'];
			$user1shotunits      = $Battle['lostunits']['defenders'];
			$user2lostunits      = $Battle['lostunits']['defenders'];
			$user2shotunits      = $Battle['lostunits']['attackers'];
			$strtruemmerfeld     = $Battle['debris']['metal'] + $Battle['debris']['crystal'];
			$strtruemmermetal    = $Battle['debris']['metal'];
			$strtruemmercrystal  = $Battle['debris']['crystal'];
			// mod TOP KB
			
			//raiders
			$unidades  = floor($Mining['metal']+$Mining['crystal']+$Mining['deuter']+$Mining['hidrogeno']);
			$unidades =  $unidades/1500000;

			
			$DebrisField      = $StrAttackerUnits ."<br />". $StrDefenderUnits ."<br />". $StrRuins;
			$MoonChance       = $FleetDebris / 1000000;
			$lunita = 0;
			if ($FleetDebris > 25000000) {
				$MoonChance = 25;
			}
			if ($FleetDebris < 1000000) {
				$UserChance = 0;
				$ChanceMoon = "";
			} elseif ($FleetDebris >= 1000000) {
				$UserChance = rand(1, 100);
				$ChanceMoon = sprintf ($lang['sys_moonproba'], $MoonChance);
			}

			if (($UserChance > 0) and ($UserChance <= $MoonChance) and $TargetMoon == 0){
				$TargetPlanetName = CreateOneMoonRecord ( $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet'], $TargetUserID, time(), 'Luna', $MoonChance );
				$GottenMoon       = sprintf ($lang['sys_moonbuilt'], $TargetPlanetName, $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet']);
				$lunita = 1;
			} elseif ($UserChance = 0 or $UserChance > $MoonChance) {
				$GottenMoon = "";
				$lunita = 0;
			}			
			
			switch ($FleetResult) {
				case "a":
					$Pillage           = sprintf ($lang['sys_stealed_ressources'], $Mining['metal'], $lang['metal'], $Mining['crystal'], $lang['crystal'], $Mining['deuter'], $lang['Deuterium'], $Mining['hidrogeno'], $lang['Hidrogeno']);
					$raport           .= $lang['sys_attacker_won'] ."<br />";
					$raport			  .= $Pillage ."<br />";
					$raport           .= $DebrisField ."<br />";
					$raport           .= $ChanceMoon ."<br />";
					$raport           .= $GottenMoon ."<br />";
					break;
				case "r":
					$raport           .= $lang['sys_both_won'] ."<br />";
					$raport           .= $DebrisField ."<br />";
					$raport           .= $ChanceMoon ."<br />";
					$raport           .= $GottenMoon ."<br />";
					break;
				case "w":
					$raport           .= $lang['sys_defender_won'] ."<br />";
					$raport           .= $DebrisField ."<br />";
					$raport           .= $ChanceMoon ."<br />";
					$raport           .= $GottenMoon ."<br />";
					//doquery("DELETE FROM {{table}} WHERE `fleet_id` = '". $FleetRow["fleet_id"] ."';", 'fleets');
					break;
				default:
					break;
			}
			$image = "<a href=\"rw_img.php?win=".$FleetResult."&per_def=".$Battle['lostunits']['defenders']."&per_atc=".$Battle['lostunits']['attackers']."&dbr_met=".$Battle['debris']['metal']."&dbr_cri=".$Battle['debris']['crystal']."&luna=".$MoonChance."&luna_si=".$lunita."\" title='Imagen de la batalla'><img src=\"rw_img.php?win=".$FleetResult."&per_def=".$zlom['wrog']."&per_atc=".$zlom['atakujacy']."&dbr_met=".$Battle['debris']['metal']."&dbr_cri=".$Battle['debris']['crystal']."&luna=".$MoonChance."&luna_si=".$lunita."\" width='200' height='100'></a>";
			$raport .= "Las siguientes defensas han sido reparadas: ";
			foreach($Battle['repair'] as $Ship => $Count){
				$raport .= $lang['tech'][$Ship] .": ".pretty_number($Count).",";
			}
			$raport .= "<br/><br/>";
			$report = $image ."</center></th></tr></table>";
			$Resources = array('metal' => $Battle['debris']['metal'], 'crystal' => $Battle['debris']['crystal'], 'steal_metal' => $Mining['metal'], 'steal_crystal' => $Mining['crystal'], 'steal_deuterium' => $Mining['deuterium']);
			//$raport = ParseCombatReport($CurrentUser, $TargetUser, $StartFleet, $EndFleet, $Resources, $raport, $roundas, $FleetResult);
			$rid   = md5($report);
			$QryInsertRapport  = "INSERT INTO {{table}} SET ";
			$QryInsertRapport .= "`time` = UNIX_TIMESTAMP(), ";
			$QryInsertRapport .= "`id_owner1` = '". $FleetRow['fleet_owner'] ."', ";
			$QryInsertRapport .= "`id_owner2` = '". $TargetUserID ."', ";
			$QryInsertRapport .= "`rid` = '". $rid ."', ";
			$QryInsertRapport .= "`a_zestrzelona` = '". $a_zestrzelona ."', ";
			$QryInsertRapport .= "`raport` = '". addslashes ( $raport ) ."';";
			doquery( $QryInsertRapport , 'rw');
			
			// mod TOP KB     
			$user1stat = $FleetRow['fleet_owner'];
			$user2stat = $TargetUserID;
			// mod TOP KB

			// Colorisation du résumé de rapport pour l'attaquant
            $raport  = "<a href='#' OnClick=\"f( 'rw.php?raport=". $rid ."', '');\" >";
			$raport .= "<center>";
            if       ($FleetResult == "a") {
				$raport .= "<font color=\"green\">";
            } elseif ($FleetResult == "r") {
				$raport .= "<font color=\"orange\">";
            } elseif ($FleetResult == "w") {
				$raport .= "<font color=\"red\">";
			}
			$raport .= $lang['sys_mess_attack_report'] ." [". $FleetRow['fleet_end_galaxy'] .":". $FleetRow['fleet_end_system'] .":". $FleetRow['fleet_end_planet'] ."] </font></a><br /><br />";
			$raport .= "<font color=\"red\">". $lang['sys_perte_attaquant'] .": ". pretty_number($TotalAttack['attackers']) ."</font>";
			$raport .= "<font color=\"green\">   ". $lang['sys_perte_defenseur'] .":". pretty_number($TotalAttack['defenders']) ."</font><br />" ;
            $raport .= $lang['sys_gain'] ." ". $lang['Metal'] .":<font color=\"#adaead\">". $Mining['metal'] ."</font>   ". $lang['Crystal'] .":<font color=\"#ef51ef\">". $Mining['crystal'] ."</font>   ". $lang['Deuterium'] .":<font color=\"#f77542\">". $Mining['deuter'] ."</font>";
			$raport .= "   ". $lang['Hidrogeno'] .":<font color=\"skyblue\">". $Mining['hidrogeno'] ."</font>";
			
            $raport .= "<br/>".$lang['sys_debris'] ." ". $lang['Metal'] .":<br><font color=\"#adaead\">". $Battle['debris']['metal'] ."</font>   ". $lang['Crystal'] .":<font color=\"#ef51ef\">". $Battle['debris']['crystal'] ."</font><br></center>";

			foreach($AttackersArray as $Order => $Array){
				$FleetArray = "";
				$FleetCount = 0;
					if(is_array($Battle['last_round']['attackers'][$Order]['Ships'])){
					foreach($Battle['last_round']['attackers'][$Order]['Ships'] as $Ship => $Count){
						$FleetArray .= ''.$Ship.','.$Count['count'].';';
						$FleetCount += $Count['count'];
					}
					$QryUpdateFleet  = "UPDATE {{table}} SET ";
					$QryUpdateFleet .= "`fleet_amount` = '". $FleetAmount ."', ";
					$QryUpdateFleet .= "`fleet_array` = '". $FleetArray ."', ";
					$QryUpdateFleet .= "`fleet_resource_metal` = '". $AttackersResources[$Order]['metal'] ."', ";
					$QryUpdateFleet .= "`fleet_resource_crystal` = '". $AttackersResources[$Order]['crystal'] ."', ";
					$QryUpdateFleet .= "`fleet_resource_hidrogeno` = '". $AttackersResources[$Order]['hidrogeno'] ."', ";
					$QryUpdateFleet .= "`fleet_resource_deuterium` = '". $AttackersResources[$Order]['deuterium'] ."' ";
					$QryUpdateFleet .= "WHERE fleet_id = '". $Array['fleet']['fleet_id'] ."' ";
					$QryUpdateFleet .= "LIMIT 1 ;";
					doquery( $QryUpdateFleet , 'fleets');
				}else{
					doquery("DELETE FROM {{table}} WHERE `fleet_id` = '".$Array['fleet']['fleet_id']."';", 'fleets');
				}
			$nuevoxm = $Array['user']['xpraid'] + $unidades;
			
			$QryUpdateUser    = "UPDATE {{table}} SET ";
			$QryUpdateUser   .= "`xpraid` = '{$nuevoxm}' ";
			$QryUpdateUser   .= "WHERE ";
			$QryUpdateUser   .= "`id` = '{$Array['user']['id']}';";
			doquery( $QryUpdateUser, 'users');
				
				SendSimpleMessage (  $Array['user']['id'], '', $FleetRow['fleet_start_time'], 3, $lang['sys_mess_tower'], $lang['sys_mess_attack_report'], $raport );
				if(!isset($AttName)){
					$AttName = $Array['user']['username'];
				}else{
					$AttName .= ', '.$Array['user']['username'];
				}
			}
			foreach($DefendersArray as $Order => $Array){
				if($Order > 0){
					$FleetArray = "";
					$FleetCount = 0;
					if(is_array($Battle['last_round']['defenders'][$Order]['Ships'])){
					foreach($Battle['last_round']['defenders'][$Order]['Ships'] as $Ship => $Count){
						$FleetArray .= ''.$Ship.','.$Count['count'].';';
						$FleetCount += $Count['count'];
					}
					$QryUpdateFleet  = "UPDATE {{table}} SET ";
					$QryUpdateFleet .= "`fleet_amount` = '". $FleetAmount ."', ";
					$QryUpdateFleet .= "`fleet_array` = '". $FleetArray ."' ";
					$QryUpdateFleet .= "WHERE fleet_id = '". $Array['fleet']['fleet_id'] ."' ";
					$QryUpdateFleet .= "LIMIT 1 ;";
					doquery( $QryUpdateFleet , 'fleets');
					}else{
						doquery("DELETE FROM {{table}} WHERE `fleet_id` = '".$Array['fleet']['fleet_id']."';", 'fleets');
					}
				}
				if(!isset($DefName)){
					$DefName = $Array['user']['username'];
				}else{
					$DefName .= ', '.$Array['user']['username'];
				}
			}
			$rid   = md5($report);
			$QryInserttopkb  = "INSERT INTO {{table}} SET ";
			$QryInserttopkb .= "`time` = UNIX_TIMESTAMP(), ";
			$QryInserttopkb .= "`id_owner1` = '". $FleetRow['fleet_owner'] ."', ";
			$QryInserttopkb .= "`angreifer` = '". $AttName ."', ";
			$QryInserttopkb .= "`id_owner2` = '". $TargetUserID ."', ";
			$QryInserttopkb .= "`defender` = '". $TargetUser["username"] ."', ";
			$QryInserttopkb .= "`gesamtunits` = '". $strunitsgesamt ."', ";
			$QryInserttopkb .= "`gesamttruemmer` = '". $strtruemmerfeld ."', ";
			$QryInserttopkb .= "`rid` = '". $rid ."', ";
			$QryInserttopkb .= "`a_zestrzelona` = '". $a_zestrzelona ."', ";
			$QryInserttopkb .= "`raport` = '',";//". addslashes ( $report ) ."
			$QryInserttopkb .= "`fleetresult` = '". $FleetResult ."';";
					doquery("LOCK TABLE {{table}} WRITE", 'topkb');
					doquery( $QryInserttopkb , 'topkb');
					doquery("UNLOCK TABLES", '');          
			// Colorisation du résumé de rapport pour l'attaquant
			$raport2  = "<a href='#' OnClick=\"f( 'rw.php?raport=". $rid ."', '');\" >";
			$raport2 .= "<center>";
			if       ($FleetResult == "a") {
				$raport2 .= "<font color=\"green\">";
			} elseif ($FleetResult == "r") {
				$raport2 .= "<font color=\"orange\">";
			} elseif ($FleetResult == "w") {
				$raport2 .= "<font color=\"red\">";
			}
			$raport2 .= $lang['sys_mess_attack_report'] ." [". $FleetRow['fleet_end_galaxy'] .":". $FleetRow['fleet_end_system'] .":". $FleetRow['fleet_end_planet'] ."] </font></a><br /><br />";
			foreach($DefendersArray as $Order => $Array){			
				SendSimpleMessage ( $Array['user']['id'], '', $FleetRow['fleet_start_time'], 3, $lang['sys_mess_tower'], $lang['sys_mess_attack_report'], $raport2 );
			}
		}
// Updaten Spieler Datenbank
      /*$user1   = doquery("SELECT * FROM {{table}} WHERE `id` = '". $user1stat ."';", 'users');
      while($user1data =  $GLOBALS['db_fetch_assoc']($user1))
       {
             $strtruemmermetaluser1    = $strtruemmermetal + $user1data['kbmetal'];
             $strtruemmercrystaluser1  = $strtruemmercrystal + $user1data['kbcrystal'];
             $user1lostunits           = $user1lostunits + $user1data['lostunits'];
             $user1shotunits           = $user1shotunits + $user1data['desunits'];
             $user1wons                = $user1data['wons'];
             $user1loos                = $user1data['loos'];
             $user1draws               = $user1data['draws'];
             }
      $user2   = doquery("SELECT * FROM {{table}} WHERE `id` = '". $user2stat ."';", 'users');
      while($user2data =  $GLOBALS['db_fetch_assoc']($user2))
       {
             $strtruemmermetaluser2    = $strtruemmermetal + $user2data['kbmetal'];
             $strtruemmercrystaluser2  = $strtruemmercrystal + $user2data['kbcrystal'];
             $user2lostunits           = $user2lostunits + $user2data['lostunits'];
             $user2shotunits           = $user2shotunits + $user2data['desunits'];
             $user2wons                = $user2data['wons'];
             $user2loos                = $user2data['loos'];
             $user2draws               = $user2data['draws'];
              }
*/
   if   ($FleetResult == "a") {
             $user1wons++;
             $user2loos++;
         } elseif ($FleetResult == "r") {
             $user1draws++;
             $user2draws++;
        } elseif ($FleetResult == "w") {
			//SendSimpleMessage ( $CurrentUserID, '', $FleetRow['fleet_start_time'], 0, $lang['sys_mess_tower'], 'Flota', 'Se ha perdido el contacto con la flota' );
             $user1loos++;
             $user2wons++;
        }
//Update Angreifer Truemerfeld, Kampfergebniss und Units
/*   $userstat   = doquery("SELECT * FROM {{table}} WHERE `id` = '". $user1stat ."';", 'users');
   while($userwrite =  $GLOBALS['db_fetch_assoc']($userstat))
{

                    $QryUpdateuserstat  = "UPDATE {{table}} SET ";
                    $QryUpdateuserstat .= "`wons` = '". $user1wons ."', ";
                    $QryUpdateuserstat .= "`loos` = '". $user1loos ."', ";
                    $QryUpdateuserstat .= "`draws` = '". $user1draws  ."', ";
                    $QryUpdateuserstat .= "`kbmetal` = '". $strtruemmermetaluser1 ."', ";
                    $QryUpdateuserstat .= "`kbcrystal` = '". $strtruemmercrystaluser1 ."', ";
                    $QryUpdateuserstat .= "`lostunits` = '". $user1lostunits ."', ";
                    $QryUpdateuserstat .= "`desunits` = '". $user1shotunits ."' ";
                    $QryUpdateuserstat .= "WHERE ";
                    $QryUpdateuserstat .= "`id` = '". $user1stat ."';";
                    doquery ( $QryUpdateuserstat , 'users');
//Update Verteidiger Truemerfeld, Kampfergebniss und Units
                    $QryUpdateuserstat  = "UPDATE {{table}} SET ";
                    $QryUpdateuserstat .= "`wons` = '". $user2wons ."', ";
                    $QryUpdateuserstat .= "`loos` = '". $user2loos ."', ";
                    $QryUpdateuserstat .= "`draws` = '". $user2draws  ."', ";
                    $QryUpdateuserstat .= "`kbmetal` = '". $strtruemmermetaluser2 ."', ";
                       $QryUpdateuserstat .= "`kbcrystal` = '". $strtruemmercrystaluser2 ."', ";
                    $QryUpdateuserstat .= "`lostunits` = '". $user2lostunits ."', ";
                    $QryUpdateuserstat .= "`desunits` = '". $user2shotunits ."' ";
                    $QryUpdateuserstat .= "WHERE ";
                    $QryUpdateuserstat .= "`id` = '". $user2stat ."';";
                    doquery ( $QryUpdateuserstat , 'users');

}*/

  // Ende schreiben in datenbank
		// Retour de flotte (s'il en reste)
	}
	if($FleetRow['fleet_mess'] == "1"){
		$fquery = "";
		if ($FleetRow['fleet_end_time'] <= time()) {
			/**if (!is_null($CurrentSet)) {
				foreach($CurrentSet as $Ship => $Count) {
					$fquery .= "`". $resource[$Ship] ."` = `". $resource[$Ship] ."` + '". $Count['count'] ."', ";
				}
			} else {*/
				$fleet = explode(";", $FleetRow['fleet_array']);
				foreach($fleet as $a => $b) {
					if ($b != '') {
						$a = explode(",", $b);
						$fquery .= "{$resource[$a[0]]}={$resource[$a[0]]} + {$a[1]}, \n";
					}
				}
			//}

			RestoreFleetToPlanet($FleetRow, true);
			doquery("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');
		}
	}
}
?>