public static function ShowFleet3Page()
{
global $USER, $PLANET, $resource, $pricelist, $reslist, $CONF, $db, $LNG;
include_once ROOT_PATH . 'includes/functions/IsVacationMode.' . PHP_EXT;
$template = new template();
$template->loadscript('flotten.js');
$template->gotoside('?page=fleet');
$template->page_header();
$template->page_topnav();
$template->page_leftmenu();
$template->page_planetmenu();
$template->page_footer();
$mission = request_var('mission', 3);
$galaxy = request_var('galaxy', 0);
$system = request_var('system', 0);
$planet = request_var('planet', 0);
$planettype = request_var('planettype', 0);
$fleet_group = request_var('fleet_group', 0);
$GenFleetSpeed = request_var('speed', 0);
$TransportMetal = round(request_var('metal', 0.0), 0);
$TransportCrystal = round(request_var('crystal', 0.0), 0);
$TransportDeuterium = round(request_var('deuterium', 0.0), 0);
$holdingtime = request_var('holdingtime', 0);
$rawfleetarray = request_var('usedfleet', '', true);
$thisgalaxy = $PLANET['galaxy'];
$thissystem = $PLANET['system'];
$thisplanet = $PLANET['planet'];
$thisplanettype = $PLANET['planet_type'];
if (IsVacationMode($USER)) {
exit($template->message($LNG['fl_vacation_mode_active'], 'game.php?page=overview', 2));
}
if ($_SESSION['db']['user_side'] != 'game.php?page=fleet2') {
parent::GotoFleetPage();
}
if (!($planettype >= 1 || $planettype <= 3)) {
parent::GotoFleetPage();
}
if ($PLANET['galaxy'] == $galaxy && $PLANET['system'] == $system && $PLANET['planet'] == $planet && $PLANET['planet_type'] == $planettype) {
parent::GotoFleetPage();
}
if ($galaxy > MAX_GALAXY_IN_WORLD || $galaxy < 1 || $system > MAX_SYSTEM_IN_GALAXY || $system < 1 || $planet > MAX_PLANET_IN_SYSTEM + 1 || $planet < 1) {
parent::GotoFleetPage();
}
if (empty($mission)) {
parent::GotoFleetPage();
}
if (!is_numeric($TransportMetal) || !is_numeric($TransportCrystal) || !is_numeric($TransportDeuterium)) {
parent::GotoFleetPage();
}
if ($TransportMetal + $TransportCrystal + $TransportDeuterium < 1 && $mission == 3) {
$template->message("<font color=\"lime\"><b>" . $LNG['fl_empty_transport'] . "</b></font>", "game." . PHP_EXT . "?page=fleet", 1);
exit;
}
$ActualFleets = parent::GetCurrentFleets($USER['id']);
if (parent::GetMaxFleetSlots($USER) <= $ActualFleets) {
$template->message($LNG['fl_no_slots'], "game." . PHP_EXT . "?page=fleet", 1);
exit;
}
$fleet_group_mr = 0;
if (!empty($fleet_group) && $mission == 2) {
$aks_count_mr = $db->uniquequery("SELECT COUNT(*) as state FROM " . AKS . " WHERE `id` = '" . $fleet_group . "' AND `eingeladen` LIKE '%" . $USER['id'] . "%';");
if ($aks_count_mr['state'] > 0) {
$fleet_group_mr = $fleet_group;
} else {
$mission = 1;
}
}
$ActualFleets = parent::GetCurrentFleets($USER['id']);
$TargetPlanet = $db->uniquequery("SELECT `id_owner`,`id_level`,`destruyed`,`ally_deposit` FROM " . PLANETS . " WHERE `galaxy` = '" . $db->sql_escape($galaxy) . "' AND `system` = '" . $db->sql_escape($system) . "' AND `planet` = '" . $db->sql_escape($planet) . "' AND `planet_type` = '" . $db->sql_escape($planettype) . "';");
if ($mission != 15 && $mission != 8 && $TargetPlanet["destruyed"] != 0 || $mission != 15 && $mission != 7 && $mission != 8 && empty($TargetPlanet['id_owner'])) {
parent::GotoFleetPage();
}
$MyDBRec = $USER;
$FleetArray = parent::GetFleetArray($rawfleetarray);
if (!is_array($FleetArray)) {
parent::GotoFleetPage();
}
$FleetStorage = 0;
$FleetShipCount = 0;
$fleet_array = "";
$FleetSubQRY = "";
foreach ($FleetArray as $Ship => $Count) {
if ($Count > $PLANET[$resource[$Ship]] || $Count < 0) {
parent::GotoFleetPage();
}
$FleetStorage += $pricelist[$Ship]["capacity"] * $Count;
$FleetShipCount += $Count;
$fleet_array .= $Ship . "," . $Count . ";";
$FleetSubQRY .= "`" . $resource[$Ship] . "` = `" . $resource[$Ship] . "` - '" . floattostring($Count) . "', ";
}
$error = 0;
$fleetmission = $mission;
$YourPlanet = false;
$UsedPlanet = false;
if ($mission == 11) {
$maxexpde = parent::GetCurrentFleets($USER['id'], 11);
if ($maxexpde >= MAX_DM_MISSIONS) {
$template->message("<font color=\"red\"><b>" . $LNG['fl_expedition_fleets_limit'] . "</b></font>", "game." . PHP_EXT . "?page=fleet", 2);
exit;
}
} elseif ($mission == 15) {
$MaxExpedition = $USER[$resource[124]];
if ($MaxExpedition == 0) {
$template->message("<font color=\"red\"><b>" . $LNG['fl_expedition_tech_required'] . "</b></font>", "game." . PHP_EXT . "?page=fleet", 2);
exit;
}
$ExpeditionEnCours = parent::GetCurrentFleets($USER['id'], 15);
$EnvoiMaxExpedition = floor(sqrt($MaxExpedition));
if ($ExpeditionEnCours >= $EnvoiMaxExpedition) {
$template->message("<font color=\"red\"><b>" . $LNG['fl_expedition_fleets_limit'] . "</b></font>", "game." . PHP_EXT . "?page=fleet", 2);
exit;
}
}
$YourPlanet = isset($TargetPlanet['id_owner']) && $TargetPlanet['id_owner'] == $USER['id'] ? true : false;
$UsedPlanet = isset($TargetPlanet['id_owner']) ? true : false;
$HeDBRec = $YourPlanet ? $MyDBRec : GetUserByID($TargetPlanet['id_owner'], array('id', 'onlinetime', 'ally_id', 'urlaubs_modus'));
if ($HeDBRec['urlaubs_modus'] && $mission != 8) {
$template->message("<font color=\"lime\"><b>" . $LNG['fl_in_vacation_player'] . "</b></font>", "game." . PHP_EXT . "?page=fleet", 2);
exit;
}
if (!$YourPlanet && ($mission == 1 || $mission == 2 || $mission == 5 || $mission == 6 || $mission == 9)) {
if ($TargetPlanet['id_level'] > $USER['authlevel'] && $CONF['adm_attack'] == 0) {
$template->message("<font color=\"red\"><b>" . $LNG['fl_admins_cannot_be_attacked'] . "</b></font>", "game." . PHP_EXT . "?page=fleet", 2);
exit;
}
$UserPoints = $USER;
$User2Points = $db->uniquequery("SELECT `total_points` FROM " . STATPOINTS . " WHERE `stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '" . $HeDBRec['id'] . "';");
$IsNoobProtec = CheckNoobProtec($UserPoints, $User2Points, $HeDBRec['onlinetime']);
if ($IsNoobProtec['NoobPlayer']) {
$template->message("<font color=\"lime\"><b>" . $LNG['fl_week_player'] . "</b></font>", "game." . PHP_EXT . "?page=fleet", 2);
exit;
} elseif ($IsNoobProtec['StrongPlayer']) {
$template->message("<font color=\"red\"><b>" . $LNG['fl_strong_player'] . "</b></font>", "game." . PHP_EXT . "?page=fleet", 2);
exit;
}
}
if ($mission == 5) {
if ($TargetPlanet['ally_deposit'] < 1) {
$template->message("<font color=\"red\"><b>" . $LNG['fl_not_ally_deposit'] . "</b></font>", "game." . PHP_EXT . "?page=fleet", 2);
exit;
}
$buddy = $db->uniquequery("SELECT COUNT(*) as state FROM " . BUDDY . " WHERE `active` = '1' AND (`owner` = '" . $HeDBRec['id'] . "' AND `sender` = '" . $MyDBRec['id'] . "') OR (`owner` = '" . $MyDBRec['id'] . "' AND `sender` = '" . $HeDBRec['id'] . "');");
if ($HeDBRec['ally_id'] != $MyDBRec['ally_id'] && $buddy['state'] == 0) {
$template->message("<font color=\"red\"><b>" . $LNG['fl_no_same_alliance'] . "</b></font>", "game." . PHP_EXT . "?page=fleet", 2);
exit;
}
}
if (parent::CheckUserSpeed() || !array_key_exists($mission, parent::GetAvailableMissions(array('CurrentUser' => $USER, 'galaxy' => $galaxy, 'system' => $system, 'planet' => $planet, 'planettype' => $planettype, 'IsAKS' => $fleet_group, 'Ship' => $FleetArray)))) {
parent::GotoFleetPage();
}
$MaxFleetSpeed = parent::GetFleetMaxSpeed($FleetArray, $USER);
$SpeedFactor = parent::GetGameSpeedFactor();
$distance = parent::GetTargetDistance($thisgalaxy, $galaxy, $thissystem, $system, $thisplanet, $planet);
$duration = parent::GetMissionDuration($GenFleetSpeed, $MaxFleetSpeed, $distance, $SpeedFactor, $USER);
$consumption = parent::GetFleetConsumption($FleetArray, $duration, $distance, $MaxFleetSpeed, $USER, $SpeedFactor);
$fleet['start_time'] = $duration + TIMESTAMP;
if ($mission == 15) {
$StayDuration = max($holdingtime, 1) * 3600 / $CONF['halt_speed'];
$StayTime = $fleet['start_time'] + $StayDuration;
} elseif ($mission == 5) {
$StayDuration = $holdingtime * 3600;
$StayTime = $fleet['start_time'] + $StayDuration;
} elseif ($mission == 11) {
$StayDuration = 3600 / $CONF['halt_speed'];
$StayTime = $fleet['start_time'] + $StayDuration;
} else {
$StayDuration = 0;
$StayTime = 0;
}
$fleet['end_time'] = $StayDuration + 2 * $duration + TIMESTAMP;
$FleetStorage -= $consumption;
$PlanetRess = new ResourceUpdate();
$PlanetRess->CalcResource();
$TransportMetal = min($TransportMetal, $PLANET['metal']);
$TransportCrystal = min($TransportCrystal, $PLANET['crystal']);
$TransportDeuterium = min($TransportDeuterium, $PLANET['deuterium'] - $consumption);
$StorageNeeded = $TransportMetal + $TransportCrystal + $TransportDeuterium;
$StockMetal = $PLANET['metal'];
$StockCrystal = $PLANET['crystal'];
$StockDeuterium = $PLANET['deuterium'];
$StockDeuterium -= $consumption;
if ($PLANET['deuterium'] < $consumption) {
$template->message("<font color=\"red\"><b>" . sprintf($LNG['fl_no_enought_deuterium'], $LNG['Deuterium'], pretty_number($consumption - $PLANET['deuterium']), $LNG['Deuterium']) . "</b></font>", "game." . PHP_EXT . "?page=fleet", 2);
exit;
}
if ($StorageNeeded > $FleetStorage) {
$template->message("<font color=\"red\"><b>" . $LNG['fl_no_enought_cargo_capacity'] . pretty_number($StorageNeeded - $FleetStorage) . "</b></font>", "game." . PHP_EXT . "?page=fleet", 2);
exit;
}
if ($TargetPlanet['id_level'] > $USER['authlevel'] && $CONF['adm_attack'] == 0) {
$template->message($LNG['fl_admins_cannot_be_attacked'], "game." . PHP_EXT . "?page=fleet", 2);
exit;
}
$PLANET['metal'] -= $TransportMetal;
$PLANET['crystal'] -= $TransportCrystal;
$PLANET['deuterium'] -= $TransportDeuterium + $consumption;
$PlanetRess->SavePlanetToDB();
if (connection_aborted()) {
exit;
}
if ($fleet_group_mr != 0) {
$AksStartTime = $db->uniquequery("SELECT MAX(`fleet_start_time`) AS Start FROM " . FLEETS . " WHERE `fleet_group` = '" . $fleet_group_mr . "' AND '" . MAX_FLEETS_PER_ACS . "' > (SELECT COUNT(*) FROM " . FLEETS . " WHERE `fleet_group` = '" . $fleet_group_mr . "');");
if (isset($AksStartTime)) {
if ($AksStartTime['Start'] >= $fleet['start_time']) {
$fleet['end_time'] += $AksStartTime['Start'] - $fleet['start_time'];
$fleet['start_time'] = $AksStartTime['Start'];
} else {
$QryUpdateFleets = "UPDATE " . FLEETS . " SET ";
$QryUpdateFleets .= "`fleet_start_time` = '" . $fleet['start_time'] . "', ";
$QryUpdateFleets .= "`fleet_end_time` = fleet_end_time + '" . ($fleet['start_time'] - $AksStartTime['Start']) . "' ";
$QryUpdateFleets .= "WHERE ";
$QryUpdateFleets .= "`fleet_group` = '" . $fleet_group_mr . "';";
$db->query($QryUpdateFleets);
$fleet['end_time'] += $fleet['start_time'] - $AksStartTime['Start'];
}
} else {
$mission = 1;
}
}
$QryInsertFleet = "LOCK TABLE " . FLEETS . " WRITE, " . PLANETS . " WRITE;\r\n\t\t\t\t\t\t\tINSERT INTO " . FLEETS . " SET \r\n\t\t\t\t\t\t\t`fleet_owner` = '" . $USER['id'] . "', \r\n\t\t\t\t\t\t\t`fleet_mission` = '" . $mission . "',\r\n\t\t\t\t\t\t\t`fleet_amount` = '" . $FleetShipCount . "',\r\n\t\t\t\t\t\t `fleet_array` = '" . $fleet_array . "',\r\n\t\t\t\t\t\t\t`fleet_start_time` = '" . $fleet['start_time'] . "',\r\n\t\t\t\t\t\t\t`fleet_start_galaxy` = '" . $thisgalaxy . "',\r\n\t\t\t\t\t\t\t`fleet_start_system` = '" . $thissystem . "',\r\n\t\t\t\t\t\t\t`fleet_start_planet` = '" . $thisplanet . "',\r\n\t\t\t\t\t\t\t`fleet_start_type` = '" . $thisplanettype . "',\r\n\t\t\t\t\t\t\t`fleet_end_time` = '" . $fleet['end_time'] . "',\r\n\t\t\t\t\t\t\t`fleet_end_stay` = '" . $StayTime . "',\r\n\t\t\t\t\t\t\t`fleet_end_galaxy` = '" . $galaxy . "',\r\n\t\t\t\t\t\t\t`fleet_end_system` = '" . $system . "',\r\n\t\t\t\t\t\t\t`fleet_end_planet` = '" . $planet . "',\r\n\t\t\t\t\t\t\t`fleet_end_type` = '" . $planettype . "',\r\n\t\t\t\t\t\t\t`fleet_resource_metal` = '" . floattostring($TransportMetal) . "',\r\n\t\t\t\t\t\t\t`fleet_resource_crystal` = '" . floattostring($TransportCrystal) . "',\r\n\t\t\t\t\t\t\t`fleet_resource_deuterium` = '" . floattostring($TransportDeuterium) . "',\r\n\t\t\t\t\t\t\t`fleet_target_owner` = '" . $TargetPlanet['id_owner'] . "',\r\n\t\t\t\t\t\t\t`fleet_group` = '" . $fleet_group_mr . "',\r\n\t\t\t\t\t\t\t`start_time` = '" . TIMESTAMP . "';\r\n\t\t\t\t\t\t\tUPDATE `" . PLANETS . "` SET\r\n\t\t\t\t\t\t\t" . substr($FleetSubQRY, 0, -2) . "\r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t`id` = " . $PLANET['id'] . " LIMIT 1;\r\n\t\t\t\t\t\t\tUNLOCK TABLES;";
$db->multi_query($QryInsertFleet);
foreach ($FleetArray as $Ship => $Count) {
$FleetList[$LNG['tech'][$Ship]] = pretty_number($Count);
}
$template->assign_vars(array('mission' => $LNG['type_mission'][$mission], 'distance' => pretty_number($distance), 'consumption' => pretty_number($consumption), 'from' => $thisgalaxy . ":" . $thissystem . ":" . $thisplanet, 'destination' => $galaxy . ":" . $system . ":" . $planet, 'start_time' => date("M D d H:i:s", $fleet['start_time']), 'end_time' => date("M D d H:i:s", $fleet['end_time']), 'speedallsmin' => $MaxFleetSpeed, 'FleetList' => $FleetList, 'fl_fleet_sended' => $LNG['fl_fleet_sended'], 'fl_mission' => $LNG['fl_mission'], 'fl_from' => $LNG['fl_from'], 'fl_destiny' => $LNG['fl_destiny'], 'fl_distance' => $LNG['fl_distance'], 'fl_fleet_speed' => $LNG['fl_fleet_speed'], 'fl_fuel_consumption' => $LNG['fl_fuel_consumption'], 'fl_fromfl_destiny' => $LNG['fl_fromfl_destiny'], 'fl_arrival_time' => $LNG['fl_arrival_time'], 'fl_return_time' => $LNG['fl_return_time'], 'fl_fleet' => $LNG['fl_fleet']));
$template->show('fleet3_table.tpl');
}
