/**
* method stay_mission
* param $fleet_row
* return the stay result
*/
public function stay_mission($fleet_row)
{
if ($fleet_row['fleet_mess'] == 0) {
if ($fleet_row['fleet_start_time'] <= time()) {
$transport_check = parent::$db->query_fetch("SELECT pc1.`planet_user_id` AS start_id,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc1.`planet_name` AS start_name,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc2.`planet_user_id` AS target_id,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc2.`planet_name` AS target_name\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . PLANETS . " AS pc1, " . PLANETS . " AS pc2\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE pc1.planet_ = '" . $fleet_row['fleet_start_galaxy'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc1.`planet_system` = '" . $fleet_row['fleet_start_system'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc1.`planet_planet` = '" . $fleet_row['fleet_start_planet'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc1.`planet_type` = '" . $fleet_row['fleet_start_type'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc2.`planet_galaxy` = '" . $fleet_row['fleet_end_galaxy'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc2.`planet_system` = '" . $fleet_row['fleet_end_system'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc2.`planet_planet` = '" . $fleet_row['fleet_end_planet'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc2.`planet_type` = '" . $fleet_row['fleet_end_type'] . "'");
// SOME REQUIRED VALUES
$start_name = $transport_check['start_id'];
$start_owner_id = $transport_check['start_name'];
$target_name = $transport_check['target_id'];
$target_owner_id = $transport_check['target_name'];
// DIFFERENT TYPES OF MESSAGES
$message[1] = sprintf($this->_lang['sys_tran_mess_owner'], $target_name, Fleets_Lib::target_link($fleet_row, ''), $fleet_row['fleet_resource_metal'], $this->_lang['Metal'], $fleet_row['fleet_resource_crystal'], $this->_lang['Crystal'], $fleet_row['fleet_resource_deuterium'], $this->_lang['Deuterium']);
$message[2] = sprintf($this->_lang['sys_tran_mess_user'], $start_name, Fleets_Lib::start_link($fleet_row, ''), $target_name, Fleets_Lib::target_link($fleet_row, ''), $fleet_row['fleet_resource_metal'], $this->_lang['Metal'], $fleet_row['fleet_resource_crystal'], $this->_lang['Crystal'], $fleet_row['fleet_resource_deuterium'], $this->_lang['Deuterium']);
$message[3] = sprintf($this->_lang['sys_tran_mess_back'], $start_name, Fleets_Lib::start_link($fleet_row, ''));
$this->stay_message($start_owner_id, $message[1], $fleet_row['fleet_start_time'], $this->_lang['sys_mess_transport']);
$this->stay_message($target_owner_id, $message[2], $fleet_row['fleet_start_time'], $this->_lang['sys_mess_transport']);
$this->start_stay($fleet_row['fleet_id']);
}
if ($fleet_row['fleet_end_stay'] <= time()) {
parent::return_fleet($fleet_row['fleet_id']);
}
}
if ($fleet_row['fleet_end_time'] < time()) {
$this->stay_message($start_owner_id, $message, $fleet_row['fleet_end_time'], $this->_lang['sys_mess_fleetback']);
parent::restore_fleet($fleet_row, TRUE);
parent::remove_fleet($fleet_row['fleet_id']);
}
}
/**
* method recycle_mission
* param $fleet_row
* return the recycle result
*/
public function recycle_mission($fleet_row)
{
if ($fleet_row['fleet_mess'] == '0') {
if ($fleet_row['fleet_start_time'] <= time()) {
$recycled_resources = $this->calculate_capacity($fleet_row);
parent::$db->query("UPDATE " . PLANETS . ", " . FLEETS . " SET\r\n\t\t\t\t\t\t\t\t\t\t`planet_debris_metal` = `planet_debris_metal` - '" . $recycled_resources['metal'] . "',\r\n\t\t\t\t\t\t\t\t\t\t`planet_debris_crystal` = `planet_debris_crystal` - '" . $recycled_resources['crystal'] . "',\r\n\t\t\t\t\t\t\t\t\t\t`fleet_resource_metal` = `fleet_resource_metal` + '" . $recycled_resources['metal'] . "',\r\n\t\t\t\t\t\t\t\t\t\t`fleet_resource_crystal` = `fleet_resource_crystal` + '" . $recycled_resources['crystal'] . "',\r\n\t\t\t\t\t\t\t\t\t\t`fleet_mess` = '1'\r\n\t\t\t\t\t\t\t\t\t\tWHERE `planet_galaxy` = '" . $fleet_row['fleet_end_galaxy'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t`planet_system` = '" . $fleet_row['fleet_end_system'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t`planet_planet` = '" . $fleet_row['fleet_end_planet'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t`planet_type` = 1 AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t`fleet_id` = '" . (int) $fleet_row['fleet_id'] . "'");
$message = sprintf($this->_lang['sys_recy_gotten'], Format_Lib::pretty_number($recycled_resources['metal']), $this->_lang['Metal'], Format_Lib::pretty_number($recycled_resources['crystal']), $this->_lang['Crystal']);
$this->recycle_message($fleet_row['fleet_owner'], $message, $fleet_row['fleet_start_time'], $this->_lang['sys_recy_report']);
}
} elseif ($fleet_row['fleet_end_time'] <= time()) {
$message = sprintf($this->_lang['sys_tran_mess_owner'], $TargetName, Fleets_Lib::target_link($fleet_row, ''), Format_Lib::pretty_number($fleet_row['fleet_resource_metal']), $this->_lang['Metal'], Format_Lib::pretty_number($fleet_row['fleet_resource_crystal']), $this->_lang['Crystal'], Format_Lib::pretty_number($fleet_row['fleet_resource_deuterium']), $this->_lang['Deuterium']);
$this->recycle_message($fleet_row['fleet_owner'], $message, $fleet_row['fleet_end_time'], $this->_lang['sys_mess_fleetback']);
parent::restore_fleet($fleet_row, TRUE);
parent::remove_fleet($fleet_row['fleet_id']);
}
}
/**
* method attack_mission
* param $fleet_row
* return the attack result
*/
public function attack_mission($fleet_row)
{
$targetPlanet = parent::$db->query_fetch("SELECT *\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . PLANETS . " AS p\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . BUILDINGS . " AS b ON b.building_planet_id = p.`planet_id`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . SHIPS . " AS s ON s.ship_planet_id = p.`planet_id`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . DEFENSES . " AS d ON d.defense_planet_id = p.`planet_id`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE `planet_galaxy` = " . (int) $fleet_row['fleet_end_galaxy'] . " AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_system` = " . (int) $fleet_row['fleet_end_system'] . " AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_type` = " . (int) $fleet_row['fleet_end_type'] . " AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_planet` = " . (int) $fleet_row['fleet_end_planet'] . ";");
if ($fleet_row['fleet_mess'] == 0 && $fleet_row['fleet_start_time'] <= time()) {
if ($fleet_row['fleet_group'] > 0) {
parent::$db->query("DELETE FROM " . ACS_FLEETS . "\r\n\t\t\t\t\t\t\t\t\t\tWHERE acs_fleet_id =" . intval($fleet_row['fleet_group']));
parent::$db->query("UPDATE `" . FLEETS . "` SET\r\n\t\t\t\t\t\t\t\t\t\t`fleet_mess` = '1'\r\n\t\t\t\t\t\t\t\t\t\tWHERE `fleet_group` = " . $fleet_row['fleet_group']);
} else {
parent::return_fleet($fleet_row['fleet_id']);
}
$targetUser = parent::$db->query_fetch('SELECT u.*,
r.research_energy_technology,
pr.premium_officier_geologist,
pr.premium_officier_engineer
FROM ' . USERS . ' AS u
INNER JOIN ' . RESEARCH . ' AS r ON r.research_user_id = u.user_id
INNER JOIN ' . PREMIUM . ' AS pr ON pr.premium_user_id = u.user_id
WHERE u.user_id = ' . intval($targetPlanet['planet_user_id']));
UpdateResources_Lib::update_resource($targetUser, $targetPlanet, time());
$targetGalaxy = parent::$db->query_fetch('SELECT `planet_id`
FROM ' . PLANETS . '
WHERE `planet_galaxy` = ' . intval($fleet_row['fleet_end_galaxy']) . ' AND
`planet_system` = ' . intval($fleet_row['fleet_end_system']) . ' AND
`planet_planet` = ' . intval($fleet_row['fleet_end_planet']) . ' AND
`planet_type` = 3;');
$targetUser = parent::$db->query_fetch('SELECT u.*,
r.research_weapons_technology,
r.research_shielding_technology,
r.research_armour_technology,
pr.premium_officier_technocrat
FROM ' . USERS . ' AS u
INNER JOIN ' . RESEARCH . ' AS r ON r.research_user_id = u.user_id
INNER JOIN ' . PREMIUM . ' AS pr ON pr.premium_user_id = u.user_id
WHERE u.user_id = ' . intval($targetPlanet['planet_user_id']));
$TargetUserID = $targetUser['user_id'];
$attackFleets = array();
if ($fleet_row['fleet_group'] != 0) {
$fleets = parent::$db->query('SELECT *
FROM ' . FLEETS . '
WHERE fleet_group=' . $fleet_row['fleet_group']);
if ($fleets != NULL) {
while ($fleet = parent::$db->fetch_assoc($fleets)) {
$attackFleets[$fleet['fleet_id']]['fleet'] = $fleet;
$attackFleets[$fleet['fleet_id']]['user'] = parent::$db->query_fetch('SELECT u.*,
r.research_weapons_technology,
r.research_shielding_technology,
r.research_armour_technology
FROM ' . USERS . ' AS u
INNER JOIN ' . RESEARCH . ' AS r ON r.research_user_id = u.user_id
WHERE user_id=' . intval($fleet_row['fleet_owner']));
$attackFleets[$fleet['fleet_id']]['detail'] = array();
$temp = explode(';', $fleet['fleet_array']);
foreach ($temp as $temp2) {
$temp2 = explode(',', $temp2);
if ($temp2[0] < 100) {
continue;
}
if (!isset($attackFleets[$fleet['fleet_id']]['detail'][$temp2[0]])) {
$attackFleets[$fleet['fleet_id']]['detail'][$temp2[0]] = 0;
}
$attackFleets[$fleet['fleet_id']]['detail'][$temp2[0]] += $temp2[1];
}
}
}
} else {
$attackFleets[$fleet_row['fleet_id']]['fleet'] = $fleet_row;
$attackFleets[$fleet_row['fleet_id']]['user'] = parent::$db->query_fetch('SELECT u.*,
r.research_weapons_technology,
r.research_shielding_technology,
r.research_armour_technology
FROM ' . USERS . ' AS u
INNER JOIN ' . RESEARCH . ' AS r ON r.research_user_id = u.user_id
WHERE user_id=' . intval($fleet_row['fleet_owner']));
$attackFleets[$fleet_row['fleet_id']]['detail'] = array();
$temp = explode(';', $fleet_row['fleet_array']);
foreach ($temp as $temp2) {
$temp2 = explode(',', $temp2);
if ($temp2[0] < 100) {
continue;
}
if (!isset($attackFleets[$fleet_row['fleet_id']]['detail'][$temp2[0]])) {
$attackFleets[$fleet_row['fleet_id']]['detail'][$temp2[0]] = 0;
}
$attackFleets[$fleet_row['fleet_id']]['detail'][$temp2[0]] += $temp2[1];
}
}
$defense = array();
$def = parent::$db->query_fetch('SELECT *
FROM ' . FLEETS . '
WHERE `fleet_end_galaxy` = ' . intval($fleet_row['fleet_end_galaxy']) . ' AND
`fleet_end_system` = ' . intval($fleet_row['fleet_end_system']) . ' AND
`fleet_end_type` = ' . intval($fleet_row['fleet_end_type']) . ' AND
`fleet_end_planet` = ' . intval($fleet_row['fleet_end_planet']) . ' AND
fleet_start_time<' . time() . ' AND
fleet_end_stay>=' . time());
if ($def != NULL) {
while ($defRow = parent::$db->fetch_assoc($def)) {
$defRowDef = explode(';', $defRow['fleet_array']);
foreach ($defRowDef as $Element) {
$Element = explode(',', $Element);
if ($Element[0] < 100) {
continue;
}
if (!isset($defense[$defRow['fleet_id']]['def'][$Element[0]])) {
$defense[$defRow['fleet_id']][$Element[0]] = 0;
}
$defense[$defRow['fleet_id']]['def'][$Element[0]] += $Element[1];
$defense[$defRow['fleet_id']]['user'] = parent::$db->query_fetch('SELECT *
FROM ' . USERS . '
WHERE user_id = ' . intval($defRow['fleet_owner']));
}
}
}
$defense[0]['def'] = array();
$defense[0]['user'] = $targetUser;
for ($i = 200; $i < 500; $i++) {
if (isset($this->_resource[$i]) && isset($targetPlanet[$this->_resource[$i]])) {
$defense[0]['def'][$i] = $targetPlanet[$this->_resource[$i]];
}
}
$start = microtime(TRUE);
$result = $this->acs_attack($attackFleets, $defense);
$totaltime = microtime(TRUE) - $start;
parent::$db->query("UPDATE " . PLANETS . " SET\r\n\t\t\t\t\t\t\t\t\t`planet_invisible_start_time` = '" . time() . "',\r\n\t\t\t\t\t\t\t\t\t`planet_debris_metal` = `planet_debris_metal` +'" . ($result['debree']['att'][0] + $result['debree']['def'][0]) . "',\r\n\t\t\t\t\t\t\t\t\t`planet_debris_crystal` = `planet_debris_crystal` + '" . ($result['debree']['att'][1] + $result['debree']['def'][1]) . "'\r\n\t\t\t\t\t\t\t\t\tWHERE `planet_galaxy` = '" . $fleet_row['fleet_end_galaxy'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t`planet_system` = '" . $fleet_row['fleet_end_system'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t`planet_planet` = '" . $fleet_row['fleet_end_planet'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t`planet_type` = 1\r\n\t\t\t\t\t\t\t\t\tLIMIT 1;");
$totalDebree = $result['debree']['def'][0] + $result['debree']['def'][1] + $result['debree']['att'][0] + $result['debree']['att'][1];
$steal = array('metal' => 0, 'crystal' => 0, 'deuterium' => 0);
if ($result['won'] == "a") {
$steal = $this->acs_steal($attackFleets, $targetPlanet);
}
foreach ($attackFleets as $fleetID => $attacker) {
$fleetArray = '';
$totalCount = 0;
foreach ($attacker['detail'] as $element => $amount) {
if ($amount) {
$fleetArray .= $element . ',' . $amount . ';';
}
$totalCount += $amount;
}
if ($totalCount <= 0) {
parent::remove_fleet($fleetID);
} else {
parent::$db->query('UPDATE ' . FLEETS . ' SET
fleet_array="' . substr($fleetArray, 0, -1) . '",
fleet_amount=' . $totalCount . ',
fleet_mess=1
WHERE fleet_id=' . intval($fleetID));
}
}
foreach ($defense as $fleetID => $defender) {
if ($fleetID != 0) {
$fleetArray = '';
$totalCount = 0;
foreach ($defender['def'] as $element => $amount) {
if ($amount) {
$fleetArray .= $element . ',' . $amount . ';';
}
$totalCount += $amount;
}
if ($totalCount <= 0) {
parent::remove_fleet($fleetID);
} else {
parent::$db->query("UPDATE " . FLEETS . " SET\r\n\t\t\t\t\t\t\t\t\t\t\t\tfleet_array='{$fleetArray}',\r\n\t\t\t\t\t\t\t\t\t\t\t\tfleet_amount='{$totalCount}'\r\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE fleet_id='{$fleetID}'");
}
} else {
$fleetArray = '';
$totalCount = 0;
foreach ($defender['def'] as $element => $amount) {
$fleetArray .= '`' . $this->_resource[$element] . '`=' . $amount . ', ';
}
parent::$db->query("UPDATE " . PLANETS . " AS p\r\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . SHIPS . " AS s ON s.ship_planet_id = p.`planet_id`\r\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . DEFENSES . " AS d ON d.defense_planet_id = p.`planet_id` SET\r\n\t\t\t\t\t\t\t\t\t\t\t{$fleetArray}\r\n\t\t\t\t\t\t\t\t\t\t\t`planet_metal` = `planet_metal` - '" . $steal['metal'] . "',\r\n\t\t\t\t\t\t\t\t\t\t\t`planet_crystal` = `planet_crystal` - '" . $steal['crystal'] . "',\r\n\t\t\t\t\t\t\t\t\t\t\t`planet_deuterium` = `planet_deuterium` - '" . $steal['deuterium'] . "'\r\n\t\t\t\t\t\t\t\t\t\t\tWHERE `planet_galaxy` = '" . $fleet_row['fleet_end_galaxy'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_system` = '" . $fleet_row['fleet_end_system'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_planet` = '" . $fleet_row['fleet_end_planet'] . "' AND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_type` = '" . $fleet_row['fleet_end_type'] . "';");
}
}
$FleetDebris = $result['debree']['att'][0] + $result['debree']['def'][0] + $result['debree']['att'][1] + $result['debree']['def'][1];
$StrAttackerUnits = sprintf($this->_lang['sys_attacker_lostunits'], $result['lost']['att']);
$StrDefenderUnits = sprintf($this->_lang['sys_defender_lostunits'], $result['lost']['def']);
$StrRuins = sprintf($this->_lang['sys_gcdrunits'], $result['debree']['def'][0] + $result['debree']['att'][0], $this->_lang['Metal'], $result['debree']['def'][1] + $result['debree']['att'][1], $this->_lang['Crystal']);
$DebrisField = $StrAttackerUnits . "<br />" . $StrDefenderUnits . "<br />" . $StrRuins;
$MoonChance = $FleetDebris / 100000;
if ($FleetDebris > 2000000) {
$MoonChance = 20;
$UserChance = mt_rand(1, 100);
$ChanceMoon = sprintf($this->_lang['sys_moonproba'], $MoonChance);
} elseif ($FleetDebris < 100000) {
$UserChance = 0;
$ChanceMoon = sprintf($this->_lang['sys_moonproba'], $MoonChance);
} elseif ($FleetDebris >= 100000) {
$UserChance = mt_rand(1, 100);
$ChanceMoon = sprintf($this->_lang['sys_moonproba'], $MoonChance);
}
if ($UserChance > 0 && $UserChance <= $MoonChance && $targetGalaxy['id'] == 0) {
include_once XGP_ROOT . 'application/libraries/Creator_Lib.php';
$creator = new Creator_Lib();
$TargetPlanetName = $creator->create_moon($fleet_row['fleet_end_galaxy'], $fleet_row['fleet_end_system'], $fleet_row['fleet_end_planet'], $TargetUserID, $fleet_row['fleet_start_time'], '', $MoonChance);
$GottenMoon = sprintf($this->_lang['sys_moonbuilt'], $TargetPlanetName, $fleet_row['fleet_end_galaxy'], $fleet_row['fleet_end_system'], $fleet_row['fleet_end_planet']);
$GottenMoon .= "<br />";
} elseif ($UserChance = 0 or $UserChance > $MoonChance) {
$GottenMoon = "";
}
$formatted_cr = $this->build_report($result, $steal, $MoonChance, $GottenMoon, $totaltime);
$raport = $formatted_cr['html'];
$rid = md5($raport);
$QryInsertRapport = 'INSERT INTO ' . REPORTS . ' SET ';
$QryInsertRapport .= '`report_time` = UNIX_TIMESTAMP(), ';
foreach ($attackFleets as $fleetID => $attacker) {
$users2[$attacker['user']['user_id']] = $attacker['user']['user_id'];
}
foreach ($defense as $fleetID => $defender) {
$users2[$defender['user']['user_id']] = $defender['user']['user_id'];
}
$QryInsertRapport .= '`report_owners` = "' . implode(',', $users2) . '", ';
$QryInsertRapport .= '`report_rid` = "' . $rid . '", ';
$QryInsertRapport .= '`report_destroyed` = "' . $formatted_cr['destroyed'] . '", ';
$QryInsertRapport .= '`report_content` = "' . parent::$db->escape_value($raport) . '"';
parent::$db->query($QryInsertRapport);
if ($result['won'] == "a") {
$style = "green";
} elseif ($result['won'] == "w") {
$style = "orange";
} elseif ($result['won'] == "r") {
$style = "red";
}
$raport = "<a href=\"#\" style=\"color:" . $style . ";\" OnClick=\\'f(\"game.php?page=CombatReport&report=" . $rid . "\", \"\");\\' >" . $this->_lang['sys_mess_attack_report'] . " [" . $fleet_row['fleet_end_galaxy'] . ":" . $fleet_row['fleet_end_system'] . ":" . $fleet_row['fleet_end_planet'] . "]</a>";
Functions_Lib::send_message($fleet_row['fleet_owner'], '', $fleet_row['fleet_start_time'], 1, $this->_lang['sys_mess_tower'], $raport, '');
if ($result['won'] == "a") {
$style = "red";
} elseif ($result['won'] == "w") {
$style = "orange";
} elseif ($result['won'] == "r") {
$style = "lime";
}
$raport2 = "<a href=\"#\" style=\"color:" . $style . ";\" OnClick=\\'f(\"game.php?page=CombatReport&report=" . $rid . "\", \"\");\\' >" . $this->_lang['sys_mess_attack_report'] . " [" . $fleet_row['fleet_end_galaxy'] . ":" . $fleet_row['fleet_end_system'] . ":" . $fleet_row['fleet_end_planet'] . "]</a>";
foreach ($users2 as $id) {
if ($id != $fleet_row['fleet_owner'] && $id != 0) {
Functions_Lib::send_message($id, '', $fleet_row['fleet_start_time'], 1, $this->_lang['sys_mess_tower'], $raport2, '');
}
}
} elseif ($fleet_row['fleet_end_time'] <= time()) {
$Message = sprintf($this->_lang['sys_fleet_won'], $targetPlanet['planet_name'], Fleets_Lib::target_link($fleet_row, ''), Format_Lib::pretty_number($fleet_row['fleet_resource_metal']), $this->_lang['Metal'], Format_Lib::pretty_number($fleet_row['fleet_resource_crystal']), $this->_lang['Crystal'], Format_Lib::pretty_number($fleet_row['fleet_resource_deuterium']), $this->_lang['Deuterium']);
Functions_Lib::send_message($fleet_row['fleet_owner'], '', $fleet_row['fleet_end_time'], 1, $this->_lang['sys_mess_tower'], $this->_lang['sys_mess_fleetback'], $Message);
parent::restore_fleet($fleet_row);
parent::remove_fleet($fleet_row['fleet_id']);
}
}
/**
* method attack_mission
* param $fleet_row
* return the attack result
*/
public function attack_mission($fleet_row)
{
// null == use default handlers
$errorHandler = null;
$exceptionHandler = null;
if ($fleet_row['fleet_mess'] == 0 && $fleet_row['fleet_start_time'] <= time()) {
$base = dirname(dirname(__DIR__)) . DIRECTORY_SEPARATOR;
require $base . 'utils' . DIRECTORY_SEPARATOR . 'includer.php';
$target_planet = parent::$db->query_fetch("SELECT *\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . PLANETS . " AS p\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . BUILDINGS . " AS b ON b.building_planet_id = p.`planet_id`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . SHIPS . " AS s ON s.ship_planet_id = p.`planet_id`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . DEFENSES . " AS d ON d.defense_planet_id = p.`planet_id`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE `planet_galaxy` = " . (int) $fleet_row['fleet_end_galaxy'] . " AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_system` = " . (int) $fleet_row['fleet_end_system'] . " AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_type` = " . (int) $fleet_row['fleet_end_type'] . " AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_planet` = " . (int) $fleet_row['fleet_end_planet'] . ";");
if ($fleet_row['fleet_group'] > 0) {
parent::$db->query("DELETE FROM `" . ACS_FLEETS . "`\n\t\t\t\t\t\t\t\t\t\tWHERE `acs_fleet_id` = '" . (int) $fleet_row['fleet_group'] . "'");
parent::$db->query("UPDATE `" . FLEETS . "` SET\n\t\t\t\t\t\t\t\t\t\t`fleet_mess` = '1'\n\t\t\t\t\t\t\t\t\t\tWHERE `fleet_group` = '" . $fleet_row['fleet_group'] . "'");
} else {
parent::return_fleet($fleet_row['fleet_id']);
}
$target_user = doquery('SELECT * FROM {{table}} WHERE id=' . $target_planet['id_owner'], 'users', true);
$target_userID = $target_user['id'];
PlanetResourceUpdate($target_user, $target_planet, time());
// attackers fleet sum
$attackers = new PlayerGroup();
if ($fleet_row['fleet_group'] != 0) {
$fleets = doquery('SELECT * FROM {{table}} WHERE fleet_group=' . $fleet_row['fleet_group'], 'fleets');
$attackers = get_player_group_from_query($fleets);
} else {
$attackers = get_player_group($fleet_row);
}
//defenders fleet sum
$def = doquery('SELECT * FROM {{table}} WHERE `fleet_end_galaxy` = ' . $fleet_row['fleet_end_galaxy'] . ' AND `fleet_end_system` = ' . $fleet_row['fleet_end_system'] . ' AND `fleet_end_type` = ' . $fleet_row['fleet_end_type'] . ' AND `fleet_end_planet` = ' . $fleet_row['fleet_end_planet'] . ' AND fleet_start_time<' . time() . ' AND fleet_end_stay>=' . time(), 'fleets');
$defenders = get_player_group_from_query($def, true, $target_user);
//defenses sum
$homeFleet = new HomeFleet(0);
for ($i = self::DEFENSE_MIN_ID; $i < self::DEFENSE_MAX_ID; $i++) {
if (isset($this->_resource[$i]) && isset($target_planet[$this->_resource[$i]])) {
if ($target_planet[$this->_resource[$i]] != 0) {
$homeFleet->add(get_ship_type($i, $target_planet[$this->_resource[$i]]));
}
}
}
for ($i = self::SHIP_MIN_ID; $i < self::SHIP_MAX_ID; $i++) {
if (isset($this->_resource[$i]) && isset($target_planet[$this->_resource[$i]])) {
if ($target_planet[$this->_resource[$i]] != 0) {
$homeFleet->add(get_ship_type($i, $target_planet[$this->_resource[$i]]));
}
}
}
if (!$defenders->existPlayer($target_userID)) {
$player = new Player($target_userID, array($homeFleet));
$player->setTech($target_user['military_tech'], $target_user['shield_tech'], $target_user['defence_tech']);
$defenders->addPlayer($player);
} else {
$defenders->getPlayer($target_userID)->addDefense($homeFleet);
}
//start of battle
$battle = new Battle($attackers, $defenders);
$startBattle = DebugManager::runDebugged(array($battle, 'startBattle'), $errorHandler, $exceptionHandler);
$startBattle();
//end of battle
$report = $battle->getReport();
$steal = $this->update_attackers($report->getPresentationAttackersFleetOnRound('START'), $report->getAfterBattleAttackers(), $target_planet);
$this->update_defenders($report->getPresentationDefendersFleetOnRound('START'), $report->getAfterBattleDefenders(), $target_planet, $steal);
$this->updateDebris($fleet_row, $report);
$this->update_moon($fleet_row, $report, '', $target_userID, $target_planet);
$this->send_message($fleet_row, $report);
} elseif ($fleet_row['fleet_end_time'] <= time()) {
$message = sprintf($this->_lang['sys_fleet_won'], $target_planet['planet_name'], Fleets_Lib::target_link($fleet_row, ''), Format_Lib::pretty_number($fleet_row['fleet_resource_metal']), $this->_lang['Metal'], Format_Lib::pretty_number($fleet_row['fleet_resource_crystal']), $this->_lang['Crystal'], Format_Lib::pretty_number($fleet_row['fleet_resource_deuterium']), $this->_lang['Deuterium']);
Functions_Lib::send_message($fleet_row['fleet_owner'], '', $fleet_row['fleet_end_time'], 1, $this->_lang['sys_mess_tower'], $this->_lang['sys_mess_fleetback'], $message);
parent::restore_fleet($fleet_row);
parent::remove_fleet($fleet_row['fleet_id']);
}
}
/**
* method flying_fleets_table
* param $fleet_row
* param $Status
* param $Owner
* param $Label
* param $Record
* param $current_user
* return the fleet table for the overview and phalanx
*/
public static function flying_fleets_table($fleet_row, $Status, $Owner, $Label, $Record, $current_user)
{
$FleetStyle = array(1 => 'attack', 2 => 'federation', 3 => 'transport', 4 => 'deploy', 5 => 'hold', 6 => 'espionage', 7 => 'colony', 8 => 'harvest', 9 => 'destroy', 10 => 'missile', 15 => 'transport');
$FleetStatus = array(0 => 'flight', 1 => 'holding', 2 => 'return');
$FleetPrefix = $Owner ? 'own' : '';
$RowsTPL = parent::$page->get_template('overview/overview_fleet_event');
$MissionType = $fleet_row['fleet_mission'];
$FleetContent = self::fleet_ships_popup($fleet_row, parent::$lang['cff_flotte'], $FleetPrefix . $FleetStyle[$MissionType], $current_user);
$FleetCapacity = self::fleet_resources_popup($fleet_row, parent::$lang['type_mission'][$MissionType], $FleetPrefix . $FleetStyle[$MissionType]);
$planet_name = parent::$db->query_fetch("SELECT\t(SELECT `planet_name`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . PLANETS . "\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE `planet_galaxy` = '" . intval($fleet_row['fleet_start_galaxy']) . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_system` = '" . intval($fleet_row['fleet_start_system']) . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_planet` = '" . intval($fleet_row['fleet_start_planet']) . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_type` = '" . intval($fleet_row['fleet_start_type']) . "') AS start_planet_name,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(SELECT `planet_name`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . PLANETS . "\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE `planet_galaxy` = '" . intval($fleet_row['fleet_end_galaxy']) . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_system` = '" . intval($fleet_row['fleet_end_system']) . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_planet` = '" . intval($fleet_row['fleet_end_planet']) . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`planet_type` = '" . intval($fleet_row['fleet_end_type']) . "') AS target_planet_name");
$StartType = $fleet_row['fleet_start_type'];
$TargetType = $fleet_row['fleet_end_type'];
if ($Status != 2) {
if ($StartType == 1) {
$StartID = parent::$lang['cff_from_the_planet'];
} elseif ($StartType == 3) {
$StartID = parent::$lang['cff_from_the_moon'];
}
$StartID .= $planet_name['start_planet_name'] . " ";
$StartID .= Fleets_Lib::start_link($fleet_row, $FleetPrefix . $FleetStyle[$MissionType]);
if ($MissionType != 15) {
switch ($TargetType) {
case 1:
$TargetID = parent::$lang['cff_the_planet'];
break;
case 2:
$TargetID = parent::$lang['cff_debris_field'];
break;
case 3:
$TargetID = parent::$lang['cff_to_the_moon'];
break;
}
} else {
$TargetID = parent::$lang['cff_the_position'];
}
$TargetID .= $planet_name['target_planet_name'] . " ";
$TargetID .= Fleets_Lib::target_link($fleet_row, $FleetPrefix . $FleetStyle[$MissionType]);
} else {
if ($StartType == 1) {
$StartID = parent::$lang['cff_to_the_planet'];
} elseif ($StartType == 3) {
$StartID = parent::$lang['cff_the_moon'];
}
$StartID .= $planet_name['start_planet_name'] . " ";
$StartID .= Fleets_Lib::start_link($fleet_row, $FleetPrefix . $FleetStyle[$MissionType]);
if ($MissionType != 15) {
switch ($TargetType) {
case 1:
$TargetID = parent::$lang['cff_from_planet'];
break;
case 2:
$TargetID = parent::$lang['cff_from_debris_field'];
break;
case 3:
$TargetID = parent::$lang['cff_from_the_moon'];
break;
}
} else {
$TargetID = parent::$lang['cff_from_position'];
}
$TargetID .= $planet_name['target_planet_name'] . " ";
$TargetID .= Fleets_Lib::target_link($fleet_row, $FleetPrefix . $FleetStyle[$MissionType]);
}
if ($MissionType == 10) {
$EventString = parent::$lang['cff_missile_attack'] . " ( " . preg_replace("(503,)i", "", $fleet_row['fleet_array']) . " ) ";
$Time = $fleet_row['fleet_start_time'];
$Rest = $Time - time();
$EventString .= $StartID;
$EventString .= parent::$lang['cff_to'];
$EventString .= $TargetID;
$EventString .= ".";
} else {
if ($Owner == TRUE) {
$EventString = parent::$lang['cff_one_of_your'];
$EventString .= $FleetContent;
} else {
$EventString = parent::$lang['cff_a'];
$EventString .= $FleetContent;
$EventString .= parent::$lang['cff_of'];
$EventString .= self::enemy_link($fleet_row);
}
switch ($Status) {
case 0:
$Time = $fleet_row['fleet_start_time'];
$Rest = $Time - time();
$EventString .= parent::$lang['cff_goes'];
$EventString .= $StartID;
$EventString .= parent::$lang['cff_toward'];
$EventString .= $TargetID;
$EventString .= parent::$lang['cff_with_the_mission_of'];
break;
case 1:
$Time = $fleet_row['fleet_end_stay'];
$Rest = $Time - time();
$EventString .= parent::$lang['cff_goes'];
$EventString .= $StartID;
$EventString .= parent::$lang['cff_to_explore'];
$EventString .= $TargetID;
$EventString .= parent::$lang['cff_with_the_mission_of'];
break;
case 2:
$Time = $fleet_row['fleet_end_time'];
$Rest = $Time - time();
$EventString .= parent::$lang['cff_comming_back'];
$EventString .= $TargetID;
$EventString .= $StartID;
$EventString .= parent::$lang['cff_with_the_mission_of'];
break;
}
$EventString .= $FleetCapacity;
}
$bloc['fleet_status'] = $FleetStatus[$Status];
$bloc['fleet_prefix'] = $FleetPrefix;
$bloc['fleet_style'] = $FleetStyle[$MissionType];
$bloc['fleet_javai'] = Functions_Lib::chrono_applet($Label, $Record, $Rest, TRUE);
$bloc['fleet_order'] = $Label . $Record;
$bloc['fleet_descr'] = $EventString;
$bloc['fleet_javas'] = Functions_Lib::chrono_applet($Label, $Record, $Rest, FALSE);
return parent::$page->parse_template($RowsTPL, $bloc);
}
/**
* attackMission
*
* @param array $fleet_row Fleet row
*
* @return void
*/
public function attackMission($fleet_row)
{
// null == use default handlers
$errorHandler = null;
$exceptionHandler = null;
$target_planet = parent::$db->query_fetch("SELECT *\n FROM " . PLANETS . " AS p\n INNER JOIN " . BUILDINGS . " AS b ON b.building_planet_id = p.`planet_id`\n INNER JOIN " . SHIPS . " AS s ON s.ship_planet_id = p.`planet_id`\n INNER JOIN " . DEFENSES . " AS d ON d.defense_planet_id = p.`planet_id`\n WHERE `planet_galaxy` = " . (int) $fleet_row['fleet_end_galaxy'] . " AND\n `planet_system` = " . (int) $fleet_row['fleet_end_system'] . " AND\n `planet_type` = " . (int) $fleet_row['fleet_end_type'] . " AND\n `planet_planet` = " . (int) $fleet_row['fleet_end_planet'] . ";");
if ($fleet_row['fleet_mess'] == 0 && $fleet_row['fleet_start_time'] <= time()) {
$base = dirname(dirname(__DIR__)) . DIRECTORY_SEPARATOR;
// require several stuff
require $base . 'libraries' . DIRECTORY_SEPARATOR . 'battle_engine' . DIRECTORY_SEPARATOR . 'utils' . DIRECTORY_SEPARATOR . 'includer.php';
// require language implementation
require $base . 'libraries' . DIRECTORY_SEPARATOR . 'missions' . DIRECTORY_SEPARATOR . 'attackLang.php';
// set language for the reports
LangManager::getInstance()->setImplementation(new AttackLang($this->_lang));
if ($fleet_row['fleet_group'] > 0) {
parent::$db->query("DELETE FROM `" . ACS_FLEETS . "`\n WHERE `acs_fleet_id` = '" . (int) $fleet_row['fleet_group'] . "'");
parent::$db->query("UPDATE `" . FLEETS . "` SET\n `fleet_mess` = '1'\n WHERE `fleet_group` = '" . $fleet_row['fleet_group'] . "'");
} else {
parent::return_fleet($fleet_row['fleet_id']);
}
$targetUser = parent::$db->query_fetch("SELECT u.*,\n r.*,\n pr.*\n FROM " . USERS . " AS u\n INNER JOIN " . RESEARCH . " AS r ON r.research_user_id = u.user_id\n INNER JOIN " . PREMIUM . " AS pr ON pr.premium_user_id = u.user_id\n WHERE u.user_id = '" . intval($target_planet['planet_user_id']) . "';");
$target_userID = $targetUser['user_id'];
UpdateResourcesLib::updateResource($targetUser, $target_planet, time());
//----------------------- prepare players for battle ----------------------
// attackers fleet sum
$attackers = new PlayerGroup();
// If we have a ACS attack
if ($fleet_row['fleet_group'] != 0) {
$fleets = parent::$db->query_fetch("SELECT * FROM `" . FLEETS . "` WHERE `fleet_group` = '" . $fleet_row['fleet_group'] . "';");
$attackers = $this->getPlayerGroupFromQuery($fleets);
} else {
$attackers = $this->getPlayerGroup($fleet_row);
}
// defenders fleet sum
$def = parent::$db->query("SELECT * FROM `" . FLEETS . "` \n WHERE `fleet_end_galaxy` = '" . $fleet_row['fleet_end_galaxy'] . "' AND \n `fleet_end_system` = '" . $fleet_row['fleet_end_system'] . "' AND \n `fleet_end_type` = '" . $fleet_row['fleet_end_type'] . "' AND \n `fleet_end_planet` = '" . $fleet_row['fleet_end_planet'] . "' AND\n `fleet_start_time` < '" . time() . "' AND \n `fleet_end_stay` >= '" . time() . "';");
$defenders = $this->getPlayerGroupFromQuery($def, $targetUser);
//defenses sum
$homeFleet = new HomeFleet(0);
for ($i = self::DEFENSE_MIN_ID; $i < self::DEFENSE_MAX_ID; $i++) {
if (isset($this->_resource[$i]) && isset($target_planet[$this->_resource[$i]])) {
if ($target_planet[$this->_resource[$i]] != 0) {
$homeFleet->addShipType($this->getShipType($i, $target_planet[$this->_resource[$i]]));
}
}
}
for ($i = self::SHIP_MIN_ID; $i < self::SHIP_MAX_ID; $i++) {
if (isset($this->_resource[$i]) && isset($target_planet[$this->_resource[$i]])) {
if ($target_planet[$this->_resource[$i]] != 0) {
$homeFleet->addShipType($this->getShipType($i, $target_planet[$this->_resource[$i]]));
}
}
}
if (!$defenders->existPlayer($target_userID)) {
$player = new Player($target_userID, array($homeFleet));
$player->setTech($targetUser['research_weapons_technology'], $targetUser['research_shielding_technology'], $targetUser['research_armour_technology']);
$player->setName($targetUser['user_name']);
$defenders->addPlayer($player);
} else {
$defenders->getPlayer($target_userID)->addDefense($homeFleet);
}
//-------------------------------------------------------------------------
//------------------------------ battle -----------------------------------
$battle = new Battle($attackers, $defenders);
$startBattle = DebugManager::runDebugged(array($battle, 'startBattle'), $errorHandler, $exceptionHandler);
$startBattle();
//-------------------------------------------------------------------------
//-------------------------- after battle stuff ---------------------------
$report = $battle->getReport();
$steal = $this->updateAttackers($report->getPresentationAttackersFleetOnRound('START'), $report->getAfterBattleAttackers(), $target_planet);
$report->setSteal($steal);
$this->updateDefenders($report->getPresentationDefendersFleetOnRound('START'), $report->getAfterBattleDefenders(), $target_planet, $steal);
$this->updateDebris($fleet_row, $report);
$this->updateMoon($fleet_row, $report, '', $target_userID, $target_planet);
$this->sendMessage($fleet_row, $report);
} elseif ($fleet_row['fleet_end_time'] <= time()) {
$message = sprintf($this->_lang['sys_fleet_won'], $target_planet['planet_name'], Fleets_Lib::target_link($fleet_row, ''), Format_Lib::pretty_number($fleet_row['fleet_resource_metal']), $this->_lang['Metal'], Format_Lib::pretty_number($fleet_row['fleet_resource_crystal']), $this->_lang['Crystal'], Format_Lib::pretty_number($fleet_row['fleet_resource_deuterium']), $this->_lang['Deuterium']);
Functions_Lib::send_message($fleet_row['fleet_owner'], '', $fleet_row['fleet_end_time'], 1, $this->_lang['sys_mess_tower'], $this->_lang['sys_mess_fleetback'], $message);
parent::restore_fleet($fleet_row);
parent::remove_fleet($fleet_row['fleet_id']);
}
}
