/**
* method transport_mission
* param $fleet_row
* return the transport result
*/
public function transportMission($fleet_row)
{
$transport_check = parent::$db->queryFetch("SELECT pc1.`planet_user_id` AS start_id,\n pc1.`planet_name` AS start_name,\n pc2.`planet_user_id` AS target_id,\n pc2.`planet_name` AS target_name\n FROM " . PLANETS . " AS pc1, " . PLANETS . " AS pc2\n WHERE pc1.planet_galaxy = '" . $fleet_row['fleet_start_galaxy'] . "' AND\n pc1.`planet_system` = '" . $fleet_row['fleet_start_system'] . "' AND\n pc1.`planet_planet` = '" . $fleet_row['fleet_start_planet'] . "' AND\n pc1.`planet_type` = '" . $fleet_row['fleet_start_type'] . "' AND\n pc2.`planet_galaxy` = '" . $fleet_row['fleet_end_galaxy'] . "' AND\n pc2.`planet_system` = '" . $fleet_row['fleet_end_system'] . "' AND\n pc2.`planet_planet` = '" . $fleet_row['fleet_end_planet'] . "' AND\n pc2.`planet_type` = '" . $fleet_row['fleet_end_type'] . "'");
// SOME REQUIRED VALUES
$start_name = $transport_check['start_name'];
$start_owner_id = $transport_check['start_id'];
$target_name = $transport_check['target_name'];
$target_owner_id = $transport_check['target_id'];
// DIFFERENT TYPES OF MESSAGES
$message[1] = sprintf($this->_lang['sys_tran_mess_owner'], $target_name, FleetsLib::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, FleetsLib::start_link($fleet_row, ''), $target_name, FleetsLib::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, FleetsLib::start_link($fleet_row, ''));
if ($fleet_row['fleet_mess'] == 0) {
if ($fleet_row['fleet_start_time'] < time()) {
parent::store_resources($fleet_row, FALSE);
$this->transport_message($start_owner_id, $message[1], $fleet_row['fleet_start_time'], $this->_lang['sys_mess_transport']);
if ($target_owner_id != $start_owner_id) {
$this->transport_message($target_owner_id, $message[2], $fleet_row['fleet_start_time'], $this->_lang['sys_mess_transport']);
}
parent::$db->query("UPDATE " . FLEETS . " SET\n\t\t\t\t\t\t\t\t\t\t`fleet_resource_metal` = '0' ,\n\t\t\t\t\t\t\t\t\t\t`fleet_resource_crystal` = '0' ,\n\t\t\t\t\t\t\t\t\t\t`fleet_resource_deuterium` = '0' ,\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_id` = '" . (int) $fleet_row['fleet_id'] . "'\n\t\t\t\t\t\t\t\t\t\tLIMIT 1 ;");
}
} elseif ($fleet_row['fleet_end_time'] < time()) {
$this->transport_message($start_owner_id, $message[3], $fleet_row['fleet_end_time'], $this->_lang['sys_mess_fleetback']);
parent::restore_fleet($fleet_row, TRUE);
parent::remove_fleet($fleet_row['fleet_id']);
}
}
/**
* method colonize_mission
* param $fleet_row
* return the colonization result
*/
public function colonizeMission($fleet_row)
{
if ($fleet_row['fleet_mess'] == 0) {
$colonization_check = parent::$db->queryFetch("SELECT\n (SELECT COUNT(*)\n FROM " . PLANETS . " AS pc1\n WHERE pc1.`planet_user_id` = '" . $fleet_row['fleet_owner'] . "' AND\n pc1.`planet_type` = '1' AND\n pc1.`planet_destroyed` = '0') AS planet_count,\n (SELECT COUNT(*)\n FROM " . PLANETS . " AS pc2\n WHERE pc2.`planet_galaxy` = '" . $fleet_row['fleet_end_galaxy'] . "' AND\n pc2.`planet_system` = '" . $fleet_row['fleet_end_system'] . "' AND\n pc2.`planet_planet` = '" . $fleet_row['fleet_end_planet'] . " AND\n pc2.`planet_type` = 1') AS galaxy_count,\n (SELECT `research_astrophysics`\n FROM " . RESEARCH . "\n WHERE `research_user_id` = '" . $fleet_row['fleet_owner'] . "') AS astro_level");
// SOME REQUIRED VALUES
$target_coords = sprintf($this->_lang['sys_adress_planet'], $fleet_row['fleet_end_galaxy'], $fleet_row['fleet_end_system'], $fleet_row['fleet_end_planet']);
$max_colonies = FleetsLib::get_max_colonies($colonization_check['astro_level']);
$planet_count = $colonization_check['planet_count'] - 1;
// THE TOTAL AMOUNT OF PLANETS MINUS 1 (BECAUSE THE MAIN PLANET IT'S NOT CONSIDERED)
// DIFFERENT TYPES OF MESSAGES
$message[1] = $this->_lang['sys_colo_arrival'] . $target_coords . $this->_lang['sys_colo_maxcolo'] . ($max_colonies + 1) . $this->_lang['sys_colo_planet'];
$message[2] = $this->_lang['sys_colo_arrival'] . $target_coords . $this->_lang['sys_colo_allisok'];
$message[3] = $this->_lang['sys_colo_arrival'] . $target_coords . $this->_lang['sys_colo_notfree'];
$message[4] = $this->_lang['sys_colo_arrival'] . $target_coords . $this->_lang['sys_colo_astro_level'];
if ($colonization_check['galaxy_count'] == 0) {
if ($planet_count >= $max_colonies) {
$this->colonize_message($fleet_row['fleet_owner'], $message[1], $fleet_row['fleet_start_time']);
parent::return_fleet($fleet_row['fleet_id']);
} elseif (!$this->position_allowed($fleet_row['fleet_end_planet'], $colonization_check['astro_level'])) {
$this->colonize_message($fleet_row['fleet_owner'], $message[4], $fleet_row['fleet_start_time']);
parent::return_fleet($fleet_row['fleet_id']);
} else {
if ($this->start_creation($fleet_row)) {
$this->colonize_message($fleet_row['fleet_owner'], $message[2], $fleet_row['fleet_start_time']);
if ($fleet_row['fleet_amount'] == 1) {
parent::$db->query("UPDATE " . USERS_STATISTICS . " AS us SET\n us.`user_statistic_ships_points` = us.`user_statistic_ships_points` - " . StatisticsLib::calculate_points(208, 1) . "\n WHERE us.`user_statistic_user_id` = (SELECT p.planet_user_id FROM " . PLANETS . " AS p\n WHERE p.planet_galaxy = '" . $fleet_row['fleet_start_galaxy'] . "' AND\n p.planet_system = '" . $fleet_row['fleet_start_system'] . "' AND\n p.planet_planet = '" . $fleet_row['fleet_start_planet'] . "' AND\n p.planet_type = '" . $fleet_row['fleet_start_type'] . "');");
parent::store_resources($fleet_row);
parent::remove_fleet($fleet_row['fleet_id']);
} else {
parent::store_resources($fleet_row);
parent::$db->query("UPDATE " . FLEETS . ", " . USERS_STATISTICS . " SET\n `fleet_array` = '" . $this->build_new_fleet($fleet_row['fleet_array']) . "',\n `fleet_amount` = `fleet_amount` - 1,\n `fleet_resource_metal` = '0',\n `fleet_resource_crystal` = '0',\n `fleet_resource_deuterium` = '0',\n `fleet_mess` = '1',\n `user_statistic_ships_points` = `user_statistic_ships_points` - " . StatisticsLib::calculate_points(208, 1) . "\n WHERE `fleet_id` = '" . $fleet_row['fleet_id'] . "' AND\n `user_statistic_user_id` = (SELECT planet_user_id FROM " . PLANETS . "\n WHERE planet_galaxy = '" . $fleet_row['fleet_start_galaxy'] . "' AND\n planet_system = '" . $fleet_row['fleet_start_system'] . "' AND\n planet_planet = '" . $fleet_row['fleet_start_planet'] . "' AND\n planet_type = '" . $fleet_row['fleet_start_type'] . "');");
}
} else {
$this->colonize_message($fleet_row['fleet_owner'], $message[3], $fleet_row['fleet_end_time']);
parent::return_fleet($fleet_row['fleet_id']);
}
}
} else {
$this->colonize_message($fleet_row['fleet_owner'], $message[3], $fleet_row['fleet_end_time']);
parent::return_fleet($fleet_row['fleet_id']);
}
}
if ($fleet_row['fleet_end_time'] < time()) {
parent::restore_fleet($fleet_row, TRUE);
parent::remove_fleet($fleet_row['fleet_id']);
}
}
