/**
* method make_stats
* param
* return builds the statistics
*/
public static function make_stats()
{
// INITIAL TIME
$mtime = microtime();
$mtime = explode(" ", $mtime);
$mtime = $mtime[1] + $mtime[0];
$starttime = $mtime;
self::$time = time();
// INITIAL MEMORY
$result['initial_memory'] = array(round(memory_get_usage() / 1024, 1), round(memory_get_usage(1) / 1024, 1));
// MAKE STATISTICS FOR USERS
self::make_user_rank();
// MAKE STATISTICS FOR ALLIANCE
self::make_ally_rank();
// END STATISTICS BUILD
$mtime = microtime();
$mtime = explode(" ", $mtime);
$mtime = $mtime[1] + $mtime[0];
$endtime = $mtime;
$result['stats_time'] = self::$time;
$result['totaltime'] = $endtime - $starttime;
$result['memory_peak'] = array(round(memory_get_peak_usage() / 1024, 1), round(memory_get_peak_usage(1) / 1024, 1));
$result['end_memory'] = array(round(memory_get_usage() / 1024, 1), round(memory_get_usage(1) / 1024, 1));
return $result;
}
/**
* method build_page
* param
* return main method, loads everything
*/
private function build_page()
{
// RUN STATISTICS SCRIPT AND THE SET THE RESULT
$result = Statistics_Lib::make_stats();
// PREPARE DATA TO PARSE
$parse = $this->_lang;
$parse['memory_p'] = str_replace(array("%p", "%m"), $result['memory_peak'], $this->_lang['sb_top_memory']);
$parse['memory_e'] = str_replace(array("%e", "%m"), $result['end_memory'], $this->_lang['sb_final_memory']);
$parse['memory_i'] = str_replace(array("%i", "%m"), $result['initial_memory'], $this->_lang['sb_start_memory']);
$parse['alert'] = Administration_Lib::save_message('ok', str_replace("%t", $result['totaltime'], $this->_lang['sb_stats_update']));
// UPDATE STATISTICS LAST UPDATE
Functions_Lib::update_config('stat_last_update', $result['stats_time']);
// SHOW TEMPLATE
parent::$page->display(parent::$page->parse_template(parent::$page->get_template('adm/buildstats_view'), $parse));
}
/**
* method colonize_mission
* param $fleet_row
* return the colonization result
*/
public function colonize_mission($fleet_row)
{
if ($fleet_row['fleet_mess'] == 0) {
$colonization_check = parent::$db->query_fetch("SELECT\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(SELECT COUNT(*)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . PLANETS . " AS pc1\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE pc1.`planet_user_id` = '" . $fleet_row['fleet_owner'] . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc1.`planet_type` = '1' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc1.`planet_destroyed` = '0') AS planet_count,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(SELECT COUNT(*)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . PLANETS . " AS pc2\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE pc2.`planet_galaxy` = '" . $fleet_row['fleet_end_galaxy'] . "' AND\n\t\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\n\t\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\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpc2.`planet_type` = 1') AS galaxy_count,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(SELECT `research_astrophysics`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . RESEARCH . "\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE `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 = Fleets_Lib::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\t\t\t\t\t\t\t\t\t\t\t\t\tus.`user_statistic_ships_points` = us.`user_statistic_ships_points` - " . Statistics_Lib::calculate_points(208, 1) . "\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE us.`user_statistic_user_id` = (SELECT p.planet_user_id FROM " . PLANETS . " AS p\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE p.planet_galaxy = '" . $fleet_row['fleet_start_galaxy'] . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tp.planet_system = '" . $fleet_row['fleet_start_system'] . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tp.planet_planet = '" . $fleet_row['fleet_start_planet'] . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tp.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\t\t\t\t\t\t\t\t\t\t\t\t\t`fleet_array` = '" . $this->build_new_fleet($fleet_row['fleet_array']) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t`fleet_amount` = `fleet_amount` - 1,\n\t\t\t\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\t\t\t`fleet_resource_crystal` = '0',\n\t\t\t\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\t\t\t`fleet_mess` = '1',\n\t\t\t\t\t\t\t\t\t\t\t\t\t`user_statistic_ships_points` = `user_statistic_ships_points` - " . Statistics_Lib::calculate_points(208, 1) . "\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE `fleet_id` = '" . $fleet_row['fleet_id'] . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`user_statistic_user_id` = (SELECT planet_user_id FROM " . PLANETS . "\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE planet_galaxy = '" . $fleet_row['fleet_start_galaxy'] . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tplanet_system = '" . $fleet_row['fleet_start_system'] . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tplanet_planet = '" . $fleet_row['fleet_start_planet'] . "' AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tplanet_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']);
}
}
public static function update_resource(&$current_user, &$current_planet, $UpdateTime, $Simul = FALSE)
{
$resource = parent::$objects->get_objects();
$ProdGrid = parent::$objects->get_production();
$reslist = parent::$objects->get_objects_list();
$game_resource_multiplier = Functions_Lib::read_config('resource_multiplier');
$game_metal_basic_income = Functions_Lib::read_config('metal_basic_income');
$game_crystal_basic_income = Functions_Lib::read_config('crystal_basic_income');
$game_deuterium_basic_income = Functions_Lib::read_config('deuterium_basic_income');
$CurrentPlanet['planet_metal_max'] = Production_Lib::max_storable($current_planet[$resource[22]]);
$current_planet['planet_crystal_max'] = Production_Lib::max_storable($current_planet[$resource[23]]);
$current_planet['planet_deuterium_max'] = Production_Lib::max_storable($current_planet[$resource[24]]);
$MaxMetalStorage = $current_planet['planet_metal_max'];
$MaxCristalStorage = $current_planet['planet_crystal_max'];
$MaxDeuteriumStorage = $current_planet['planet_deuterium_max'];
$Caps = array();
$BuildTemp = $current_planet['planet_temp_max'];
$sub_query = '';
$parse['production_level'] = 100;
$post_porcent = Production_Lib::max_production($current_planet['planet_energy_max'], $current_planet['planet_energy_used']);
$Caps['planet_metal_perhour'] = 0;
$Caps['planet_crystal_perhour'] = 0;
$Caps['planet_deuterium_perhour'] = 0;
$Caps['planet_energy_max'] = 0;
$Caps['planet_energy_used'] = 0;
foreach ($ProdGrid as $ProdID => $formula) {
$BuildLevelFactor = $current_planet['planet_' . $resource[$ProdID] . '_porcent'];
$BuildLevel = $current_planet[$resource[$ProdID]];
$BuildEnergy = $current_user['research_energy_technology'];
// BOOST
$geologe_boost = 1 + 1 * (Officiers_Lib::is_officier_active($current_user['premium_officier_geologist']) ? GEOLOGUE : 0);
$engineer_boost = 1 + 1 * (Officiers_Lib::is_officier_active($current_user['premium_officier_engineer']) ? ENGINEER_ENERGY : 0);
// PRODUCTION FORMULAS
$metal_prod = eval($ProdGrid[$ProdID]['formule']['metal']);
$crystal_prod = eval($ProdGrid[$ProdID]['formule']['crystal']);
$deuterium_prod = eval($ProdGrid[$ProdID]['formule']['deuterium']);
$energy_prod = eval($ProdGrid[$ProdID]['formule']['energy']);
// PRODUCTION
$Caps['planet_metal_perhour'] += Production_Lib::current_production(Production_Lib::production_amount($metal_prod, $geologe_boost), $post_porcent);
$Caps['planet_crystal_perhour'] += Production_Lib::current_production(Production_Lib::production_amount($crystal_prod, $geologe_boost), $post_porcent);
$Caps['planet_deuterium_perhour'] += Production_Lib::current_production(Production_Lib::production_amount($deuterium_prod, $geologe_boost), $post_porcent);
if ($ProdID >= 4) {
if ($ProdID == 12 && $current_planet['planet_deuterium'] == 0) {
continue;
}
$Caps['planet_energy_max'] += Production_Lib::production_amount($energy_prod, $engineer_boost, TRUE);
} else {
$Caps['planet_energy_used'] += Production_Lib::production_amount($energy_prod, 1, TRUE);
}
}
if ($current_planet['planet_type'] == 3) {
$game_metal_basic_income = 0;
$game_crystal_basic_income = 0;
$game_deuterium_basic_income = 0;
$current_planet['planet_metal_perhour'] = 0;
$current_planet['planet_crystal_perhour'] = 0;
$current_planet['planet_deuterium_perhour'] = 0;
$current_planet['planet_energy_used'] = 0;
$current_planet['planet_energy_max'] = 0;
} else {
$current_planet['planet_metal_perhour'] = $Caps['planet_metal_perhour'];
$current_planet['planet_crystal_perhour'] = $Caps['planet_crystal_perhour'];
$current_planet['planet_deuterium_perhour'] = $Caps['planet_deuterium_perhour'];
$current_planet['planet_energy_used'] = $Caps['planet_energy_used'];
$current_planet['planet_energy_max'] = $Caps['planet_energy_max'];
}
$ProductionTime = $UpdateTime - $current_planet['planet_last_update'];
$current_planet['planet_last_update'] = $UpdateTime;
if ($current_planet['planet_energy_max'] == 0) {
$current_planet['planet_metal_perhour'] = $game_metal_basic_income;
$current_planet['planet_crystal_perhour'] = $game_crystal_basic_income;
$current_planet['planet_deuterium_perhour'] = $game_deuterium_basic_income;
$production_level = 100;
} elseif ($current_planet['planet_energy_max'] >= $current_planet['planet_energy_used']) {
$production_level = 100;
} else {
$production_level = floor($current_planet['planet_energy_max'] / $current_planet['planet_energy_used'] * 100);
}
if ($production_level > 100) {
$production_level = 100;
} elseif ($production_level < 0) {
$production_level = 0;
}
if ($current_planet['planet_metal'] <= $MaxMetalStorage) {
$MetalProduction = $ProductionTime * ($current_planet['planet_metal_perhour'] / 3600) * (0.01 * $production_level);
$MetalBaseProduc = $ProductionTime * ($game_metal_basic_income / 3600);
$MetalTheorical = $current_planet['planet_metal'] + $MetalProduction + $MetalBaseProduc;
if ($MetalTheorical <= $MaxMetalStorage) {
$current_planet['planet_metal'] = $MetalTheorical;
} else {
$current_planet['planet_metal'] = $MaxMetalStorage;
}
}
if ($current_planet['planet_crystal'] <= $MaxCristalStorage) {
$CristalProduction = $ProductionTime * ($current_planet['planet_crystal_perhour'] / 3600) * (0.01 * $production_level);
$CristalBaseProduc = $ProductionTime * ($game_crystal_basic_income / 3600);
$CristalTheorical = $current_planet['planet_crystal'] + $CristalProduction + $CristalBaseProduc;
if ($CristalTheorical <= $MaxCristalStorage) {
$current_planet['planet_crystal'] = $CristalTheorical;
} else {
$current_planet['planet_crystal'] = $MaxCristalStorage;
}
}
if ($current_planet['planet_deuterium'] <= $MaxDeuteriumStorage) {
$DeuteriumProduction = $ProductionTime * ($current_planet['planet_deuterium_perhour'] / 3600) * (0.01 * $production_level);
$DeuteriumBaseProduc = $ProductionTime * ($game_deuterium_basic_income / 3600);
$DeuteriumTheorical = $current_planet['planet_deuterium'] + $DeuteriumProduction + $DeuteriumBaseProduc;
if ($DeuteriumTheorical <= $MaxDeuteriumStorage) {
$current_planet['planet_deuterium'] = $DeuteriumTheorical;
} else {
$current_planet['planet_deuterium'] = $MaxDeuteriumStorage;
}
}
if ($current_planet['planet_metal'] < 0) {
$current_planet['planet_metal'] = 0;
}
if ($current_planet['planet_crystal'] < 0) {
$current_planet['planet_crystal'] = 0;
}
if ($current_planet['planet_deuterium'] < 0) {
$current_planet['planet_deuterium'] = 0;
}
if ($Simul == FALSE) {
// SHIPS AND DEFENSES UPDATE
$builded = self::building_queue($current_user, $current_planet, $ProductionTime);
$ship_points = 0;
$defense_points = 0;
if ($builded != '') {
foreach ($builded as $element => $count) {
if ($element != '') {
// POINTS
switch ($element) {
case $element >= 202 && $element <= 215:
$ship_points += Statistics_Lib::calculate_points($element, $count) * $count;
break;
case $element >= 401 && $element <= 503:
$defense_points += Statistics_Lib::calculate_points($element, $count) * $count;
break;
default:
break;
}
$sub_query .= "`" . $resource[$element] . "` = '" . $current_planet[$resource[$element]] . "', ";
}
}
}
// RESEARCH UPDATE
if ($current_planet['planet_b_tech'] <= time() && $current_planet['planet_b_tech_id'] != 0) {
$current_user['research_points'] = Statistics_Lib::calculate_points($current_planet['planet_b_tech_id'], $current_user[$resource[$current_planet['planet_b_tech_id']]], 'tech');
$current_user[$resource[$current_planet['planet_b_tech_id']]]++;
$tech_query = "`planet_b_tech` = '0',";
$tech_query .= "`planet_b_tech_id` = '0',";
$tech_query .= "`" . $resource[$current_planet['planet_b_tech_id']] . "` = '" . $current_user[$resource[$current_planet['planet_b_tech_id']]] . "',";
$tech_query .= "`user_statistic_technology_points` = `user_statistic_technology_points` + '" . $current_user['research_points'] . "',";
$tech_query .= "`research_current_research` = '0',";
} else {
$tech_query = "";
}
parent::$db->query("UPDATE " . PLANETS . " AS p\r\n\t\t\t\t\t\t\t\t\tINNER JOIN " . USERS_STATISTICS . " AS us ON us.user_statistic_user_id = p.planet_user_id\r\n\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\tINNER JOIN " . SHIPS . " AS s ON s.ship_planet_id = p.`planet_id`\r\n\t\t\t\t\t\t\t\t\tINNER JOIN " . RESEARCH . " AS r ON r.research_user_id = p.planet_user_id SET\r\n\t\t\t\t\t\t\t\t\t`planet_metal` = '" . $current_planet['planet_metal'] . "',\r\n\t\t\t\t\t\t\t\t\t`planet_crystal` = '" . $current_planet['planet_crystal'] . "',\r\n\t\t\t\t\t\t\t\t\t`planet_deuterium` = '" . $current_planet['planet_deuterium'] . "',\r\n\t\t\t\t\t\t\t\t\t`planet_last_update` = '" . $current_planet['planet_last_update'] . "',\r\n\t\t\t\t\t\t\t\t\t`planet_b_hangar_id` = '" . $current_planet['planet_b_hangar_id'] . "',\r\n\t\t\t\t\t\t\t\t\t`planet_metal_perhour` = '" . $current_planet['planet_metal_perhour'] . "',\r\n\t\t\t\t\t\t\t\t\t`planet_crystal_perhour` = '" . $current_planet['planet_crystal_perhour'] . "',\r\n\t\t\t\t\t\t\t\t\t`planet_deuterium_perhour` = '" . $current_planet['planet_deuterium_perhour'] . "',\r\n\t\t\t\t\t\t\t\t\t`planet_energy_used` = '" . $current_planet['planet_energy_used'] . "',\r\n\t\t\t\t\t\t\t\t\t`planet_energy_max` = '" . $current_planet['planet_energy_max'] . "',\r\n\t\t\t\t\t\t\t\t\t`user_statistic_ships_points` = `user_statistic_ships_points` + '" . $ship_points . "',\r\n\t\t\t\t\t\t\t\t\t`user_statistic_defenses_points` = `user_statistic_defenses_points` + '" . $defense_points . "',\r\n\t\t\t\t\t\t\t\t\t{$sub_query}\r\n\t\t\t\t\t\t\t\t\t{$tech_query}\r\n\t\t\t\t\t\t\t\t\t`planet_b_hangar` = '" . $current_planet['planet_b_hangar'] . "'\r\n\t\t\t\t\t\t\t\t\tWHERE `planet_id` = '" . $current_planet['planet_id'] . "';");
}
}
/**
* checkBuildingQueue
*
* @param array $current_planet Current planet
* @param array $current_user Current user
*
* @return boolean
*/
private static function checkBuildingQueue(&$current_planet, &$current_user)
{
$resource = parent::$objects->get_objects();
$ret_value = false;
if ($current_planet['planet_b_building_id'] != 0) {
$current_queue = $current_planet['planet_b_building_id'];
if ($current_queue != 0) {
$queue_array = explode(";", $current_queue);
}
$build_array = explode(",", $queue_array[0]);
$build_end_time = floor($build_array[3]);
$build_mode = $build_array[4];
$element = $build_array[0];
array_shift($queue_array);
if ($build_mode == 'destroy') {
$for_destroy = true;
} else {
$for_destroy = false;
}
if ($build_end_time <= time()) {
$needed = Developments_Lib::development_price($current_user, $current_planet, $element, true, $for_destroy);
$units = $needed['metal'] + $needed['crystal'] + $needed['deuterium'];
$current = (int) $current_planet['planet_field_current'];
$max = (int) $current_planet['planet_field_max'];
if ($current_planet['planet_type'] == 3) {
if ($element == 41) {
$current += 1;
$max += FIELDS_BY_MOONBASIS_LEVEL;
$current_planet[$resource[$element]]++;
} elseif ($element != 0) {
if ($for_destroy == false) {
$current += 1;
$current_planet[$resource[$element]]++;
} else {
$current -= 1;
$current_planet[$resource[$element]]--;
}
}
} elseif ($current_planet['planet_type'] == 1) {
if ($for_destroy == false) {
$current += 1;
$current_planet[$resource[$element]]++;
} else {
$current -= 1;
$current_planet[$resource[$element]]--;
}
}
if (count($queue_array) == 0) {
$new_queue = 0;
} else {
$new_queue = implode(';', $queue_array);
}
$current_planet['planet_b_building'] = 0;
$current_planet['planet_b_building_id'] = $new_queue;
$current_planet['planet_field_current'] = $current;
$current_planet['planet_field_max'] = $max;
$current_planet['building_points'] = Statistics_Lib::calculate_points($element, $current_planet[$resource[$element]]);
parent::$db->query("\nUPDATE " . PLANETS . " AS p\nINNER JOIN " . USERS_STATISTICS . " AS s ON s.user_statistic_user_id = p.planet_user_id\nINNER JOIN " . BUILDINGS . " AS b ON b.building_planet_id = p.`planet_id` SET\n`" . $resource[$element] . "` = '" . $current_planet[$resource[$element]] . "',\n`user_statistic_buildings_points` = `user_statistic_buildings_points` + '" . $current_planet['building_points'] . "',\n`planet_b_building` = '" . $current_planet['planet_b_building'] . "',\n`planet_b_building_id` = '" . $current_planet['planet_b_building_id'] . "',\n`planet_field_current` = '" . $current_planet['planet_field_current'] . "',\n`planet_field_max` = '" . $current_planet['planet_field_max'] . "'\nWHERE `planet_id` = '" . $current_planet['planet_id'] . "';\n");
$ret_value = true;
} else {
$ret_value = false;
}
} else {
$current_planet['planet_b_building'] = 0;
$current_planet['planet_b_building_id'] = 0;
parent::$db->query("UPDATE " . PLANETS . " SET\n`planet_b_building` = '" . $current_planet['planet_b_building'] . "',\n`planet_b_building_id` = '" . $current_planet['planet_b_building_id'] . "'\nWHERE `planet_id` = '" . $current_planet['planet_id'] . "';");
$ret_value = false;
}
return $ret_value;
}
