/**
* Copyright (c) 2009-2010 by Gorlum for http://supernova.ws
* OpenSource as long as you don't remove this Copyright
* V3 2009-11-13
* V2 2009-10-10
*/
function coe_o_missile_calculate()
{
global $time_now, $sn_data, $lang;
$iraks = doquery("SELECT * FROM {{iraks}} WHERE `zeit` <= '{$time_now}';");
while ($fleetRow = mysql_fetch_assoc($iraks)) {
$targetUser = doquery('SELECT * FROM {{users}} WHERE `id` = ' . $fleetRow['zielid'], '', true);
$target_planet_row = sys_o_get_updated($targetUser, array('galaxy' => $fleetRow['galaxy'], 'system' => $fleetRow['system'], 'planet' => $fleetRow['planet'], 'planet_type' => PT_PLANET), $time_now);
$target_planet_row = $target_planet_row['planet'];
$rowAttacker = doquery("SELECT `military_tech` FROM `{{users}}` WHERE `id` = '{$fleetRow['owner']}' LIMIT 1;", '', true);
if ($target_planet_row['id']) {
$planetDefense = array(400 => array(0, 'shield' => 0, 'structure' => 0), 401 => array($target_planet_row[$sn_data[401]['name']], 'shield' => 0, 'structure' => 0), 402 => array($target_planet_row[$sn_data[402]['name']], 'shield' => 0, 'structure' => 0), 403 => array($target_planet_row[$sn_data[403]['name']], 'shield' => 0, 'structure' => 0), 404 => array($target_planet_row[$sn_data[404]['name']], 'shield' => 0, 'structure' => 0), 405 => array($target_planet_row[$sn_data[405]['name']], 'shield' => 0, 'structure' => 0), 406 => array($target_planet_row[$sn_data[406]['name']], 'shield' => 0, 'structure' => 0), 407 => array($target_planet_row[$sn_data[407]['name']], 'shield' => 0, 'structure' => 0), 408 => array($target_planet_row[$sn_data[408]['name']], 'shield' => 0, 'structure' => 0), 409 => array($target_planet_row[$sn_data[409]['name']], 'shield' => 0, 'structure' => 0));
$message = '';
$interceptor_db_name = $sn_data[502]['name'];
$interceptors = $target_planet_row[$interceptor_db_name];
// Number of interceptors
$missiles = $fleetRow['anzahl'];
// Number of MIP
$qUpdate = "UPDATE `{{planets}}` SET {$interceptor_db_name} = ";
if ($interceptors >= $missiles) {
$message = $lang['mip_all_destroyed'];
$qUpdate .= "{$interceptor_db_name} - {$missiles} ";
} else {
if ($interceptors) {
$message = sprintf($lang['mip_destroyed'], $interceptors);
}
$qUpdate .= "0";
$message .= $lang['mip_defense_destroyed'];
$attackResult = COE_missileAttack($targetUser, $rowAttacker, $missiles - $interceptors, $planetDefense, $fleetRow['primaer']);
foreach ($attackResult['structures'] as $key => $structure) {
$destroyed = $planetDefense[$key][0] - $structure[0];
if ($key > 400 && $destroyed) {
$message .= " {$lang['tech'][$key]} - {$destroyed} {$lang['quantity']}<br>";
$qUpdate .= ", `{$sn_data[$key]['name']}` = {$structure[0]}";
}
}
$qUpdate .= ", `metal`=`metal`+" . $attackResult['metal'] . ", `crystal`=`crystal`+" . $attackResult['crystal'];
$message .= "{$lang['mip_recycled']}{$lang['Metal']}: {$attackResult['metal']}, {$lang['Crystal']}: {$attackResult['crystal']}<br>";
}
$qUpdate .= " WHERE `id` = " . $target_planet_row['id'] . ";";
doquery($qUpdate);
$sourcePlanet = doquery("SELECT `name` FROM `{{planets}}` WHERE `galaxy` = '{$fleetRow['galaxy_angreifer']}' AND `system` = '{$fleetRow['system_angreifer']}' AND `planet` = '{$fleetRow['planet_angreifer']}' and planet_type = " . PT_PLANET, '', true);
$message_vorlage = sprintf($lang['mip_body_attack'], $fleetRow['anzahl'], addslashes($sourcePlanet['name']), $fleetRow['galaxy_angreifer'], $fleetRow['system_angreifer'], $fleetRow['planet_angreifer'], addslashes($target_planet_row['name']), $fleetRow['galaxy'], $fleetRow['system'], $fleetRow['planet']);
if (empty($message)) {
$message = $lang['mip_no_defense'];
}
msg_send_simple_message($fleetRow['owner'], '', $time_now, MSG_TYPE_SPY, $lang['mip_sender_amd'], $lang['mip_subject_amd'], $message_vorlage . $message);
msg_send_simple_message($fleetRow['zielid'], '', $time_now, MSG_TYPE_SPY, $lang['mip_sender_amd'], $lang['mip_subject_amd'], $message_vorlage . $message);
}
doquery("DELETE FROM {{iraks}} WHERE id = '{$fleetRow['id']}';");
}
}
default:
sn_sys_sector_buy();
$template = gettemplate('planet_overview', true);
rpg_level_up($user, RPG_STRUCTURE);
rpg_level_up($user, RPG_RAID);
rpg_level_up($user, RPG_TECH);
rpg_level_up($user, RPG_EXPLORE);
$fleet_id = 1;
$fleet_list = flt_get_fleets($user['id']);
$fleets = flt_parse_fleets_to_events($fleet_list);
// int_get_missile_to_planet("SELECT * FROM `{{iraks}}` WHERE `fleet_owner` = '{$user['id']}'");
$planet_count = 0;
sn_db_transaction_start();
$planets_query = db_planet_list_sorted($user, false, '*');
foreach ($planets_query as $an_id => $UserPlanet) {
$UserPlanet = sys_o_get_updated($user, $UserPlanet['id'], SN_TIME_NOW, false, true);
$list_planet_que = $UserPlanet['que'];
$UserPlanet = $UserPlanet['planet'];
$template_planet = tpl_parse_planet($UserPlanet);
$planet_fleet_id = 0;
$fleet_list = $template_planet['fleet_list'];
if ($fleet_list['own']['count']) {
$planet_fleet_id = "p{$UserPlanet['id']}";
$fleets_to_planet[$UserPlanet['id']] = tpl_parse_fleet_sn($fleet_list['own']['total'], $planet_fleet_id);
// $fleet_id++;tpl_parse_fleet_sn
}
if ($UserPlanet['planet_type'] == PT_MOON) {
continue;
}
$moon = db_planet_by_parent($UserPlanet['id']);
if ($moon) {
// TODO НЕ НУЖНО АЛЬЯНС КАЖДЫЙ РАЗ ОБНОВЛЯТЬ!!!
if ($user['ally_id']) {
sn_db_transaction_start();
sn_ali_fill_user_ally($user);
if (!$user['ally']['player']['id']) {
sn_sys_logout(false, true);
$debug->error("User ID {$user['id']} has ally ID {$user['ally_id']} but no ally info", 'User record error', 502);
}
// TODO UNCOMMENT
que_process($user['ally']['player']);
db_user_set_by_id($user['ally']['player']['id'], '`onlinetime` = ' . SN_TIME_NOW);
sn_db_transaction_commit();
}
// TODO - в режиме эмуляции, на самом деле!
sn_db_transaction_start();
$global_data = sys_o_get_updated($user['id'], $planet_id, SN_TIME_NOW);
sn_db_transaction_commit();
$planetrow = $global_data['planet'];
if (!($planetrow && isset($planetrow['id']) && $planetrow['id'])) {
sn_sys_logout(false, true);
$debug->error("User ID {$user['id']} has no current planet and no homeworld", 'User record error', 502);
}
$que = $global_data['que'];
}
require_once 'includes/vars_menu.php';
if ($sn_mvc['model']['']) {
foreach ($sn_mvc['model'][''] as $hook) {
if (is_callable($hook_call = is_string($hook) ? $hook : (is_array($hook) ? $hook['callable'] : $hook->callable))) {
call_user_func($hook_call);
}
}
function sn_imperium_view($template = null)
{
global $user, $lang;
$planets = array();
$ques = array();
$sn_group_factories = sn_get_groups('factories');
$planet_density = sn_get_groups('planet_density');
if (sys_get_param('save_production')) {
$production = sys_get_param('percent');
if (is_array($production) && !empty($production)) {
// sn_db_transaction_start();
$query = array();
$planet_row_list = db_planet_list_sorted($user, false, '*');
// while($planet = db_fetch($planet_row_list))
foreach ($planet_row_list as $planet) {
foreach ($sn_group_factories as $factory_unit_id) {
$unit_db_name_porcent = pname_factory_production_field_name($factory_unit_id);
if (get_unit_param($factory_unit_id, P_MINING_IS_MANAGED) && isset($production[$factory_unit_id][$planet['id']]) && ($actual_porcent = intval($production[$factory_unit_id][$planet['id']] / 10)) >= 0 && $actual_porcent <= 10 && $actual_porcent != $planet[$unit_db_name_porcent]) {
$query[$planet['id']][] = "{$unit_db_name_porcent} = {$actual_porcent}";
}
}
}
foreach ($query as $planet_id => $query_data) {
db_planet_set_by_id($planet_id, implode(',', $query_data));
}
// sn_db_transaction_commit();
}
}
$planet_row_list = db_planet_list_sorted($user);
// while ($planet = db_fetch($planet_row_list))
foreach ($planet_row_list as $planet) {
sn_db_transaction_start();
$global_data = sys_o_get_updated($user, $planet['id'], SN_TIME_NOW, false, true);
$planets[$planet['id']] = $global_data['planet'];
// $ques[$planet['id']] = que_get($user['id'], $planet['id'], false);
$ques[$planet['id']] = $global_data['que'];
sn_db_transaction_commit();
}
$template = gettemplate('imperium', $template);
$template->assign_var('amount', count($planets) + 2);
for ($i = 100; $i >= 0; $i -= 10) {
$template->assign_block_vars('percent', array('PERCENT' => $i));
}
$fleet_id = 1;
$fleets = array();
$total['temp_min'] = 1000;
$total['temp_max'] = -999;
foreach ($planets as $planet_index => &$planet) {
$list_planet_que = $ques[$planet_index];
$planet_template = tpl_parse_planet($planet);
$planet_fleet_id = 0;
$fleet_list = $planet_template['fleet_list'];
//flt_get_fleets_to_planet($planet);
if ($fleet_list['own']['count']) {
$planet_fleet_id = "p{$fleet_id}";
$fleets[] = tpl_parse_fleet_sn($fleet_list['own']['total'], $planet_fleet_id);
$fleet_id++;
}
$template->assign_block_vars('planet', array_merge($planet_template, array('PLANET_FLEET_ID' => $planet_fleet_id, 'METAL_CUR' => pretty_number($planet['metal'], true, $planet['caps']['total_storage'][RES_METAL]), 'METAL_PROD' => pretty_number($planet['caps']['total'][RES_METAL]), 'CRYSTAL_CUR' => pretty_number($planet['crystal'], true, $planet['caps']['total_storage'][RES_CRYSTAL]), 'CRYSTAL_PROD' => pretty_number($planet['caps']['total'][RES_CRYSTAL]), 'DEUTERIUM_CUR' => pretty_number($planet['deuterium'], true, $planet['caps']['total_storage'][RES_DEUTERIUM]), 'DEUTERIUM_PROD' => pretty_number($planet['caps']['total'][RES_DEUTERIUM]), 'ENERGY_CUR' => pretty_number($planet['caps'][RES_ENERGY][BUILD_CREATE] - $planet['caps'][RES_ENERGY][BUILD_DESTROY], true, true), 'ENERGY_MAX' => pretty_number($planet['caps'][RES_ENERGY][BUILD_CREATE]), 'TEMP_MIN' => $planet['temp_min'], 'TEMP_MAX' => $planet['temp_max'], 'DENSITY_CLASS' => $planet['density_index'], 'DENSITY_RICHNESS' => $planet_density[$planet['density_index']][UNIT_PLANET_DENSITY_RICHNESS], 'DENSITY_CLASS_TEXT' => $lang['uni_planet_density_types'][$planet['density_index']])));
$planet['fleet_list'] = $planet_template['fleet_list'];
$planet['BUILDING_ID'] = $planet_template['BUILDING_ID'];
$planet['hangar_que'] = $planet_template['hangar_que'];
$planet['full_que'] = $list_planet_que;
$total['fields'] += $planet['field_current'];
$total['metal'] += $planet['metal'];
$total['crystal'] += $planet['crystal'];
$total['deuterium'] += $planet['deuterium'];
$total['energy'] += $planet['energy_max'] - $planet['energy_used'];
$total['fields_max'] += eco_planet_fields_max($planet);
$total['metal_perhour'] += $planet['caps']['total'][RES_METAL];
$total['crystal_perhour'] += $planet['caps']['total'][RES_CRYSTAL];
$total['deuterium_perhour'] += $planet['caps']['total'][RES_DEUTERIUM];
$total['energy_max'] += $planet['caps'][RES_ENERGY][BUILD_CREATE];
$total['temp_min'] = min($planet['temp_min'], $total['temp_min']);
$total['temp_max'] = max($planet['temp_max'], $total['temp_max']);
}
tpl_assign_fleet($template, $fleets);
unset($planet);
$show_groups = array(UNIT_STRUCTURES => 'structures', UNIT_STRUCTURES_SPECIAL => 'structures', UNIT_SHIPS => 'fleet', UNIT_DEFENCE => 'defense');
foreach ($show_groups as $unit_group_id => $mode) {
$template->assign_block_vars('prods', array('NAME' => $lang['tech'][$unit_group_id]));
$unit_group = get_unit_param('techtree', $unit_group_id);
foreach ($unit_group as $unit_id) {
$unit_count = $unit_count_abs = 0;
$block_vars = array();
$unit_is_factory = in_array($unit_id, $sn_group_factories) && get_unit_param($unit_id, P_MINING_IS_MANAGED);
// $unit_db_name = pname_resource_name($unit_id);
foreach ($planets as $planet) {
$unit_level_plain = mrc_get_level($user, $planet, $unit_id, false, true);
$level_plus['FACTORY'] = $unit_is_factory;
$level_plus['LEVEL_PLUS_YELLOW'] = 0;
$level_plus['LEVEL_PLUS_GREEN'] = 0;
$level_plus['PERCENT'] = $unit_is_factory ? $unit_level_plain ? $planet[pname_factory_production_field_name($unit_id)] * 10 : -1 : -1;
switch ($mode) {
/*
case 'structures':
$level_plus_build = $ques[$planet['id']]['in_que'][que_get_unit_que($unit_id)][$user['id']][$planet['id']][$unit_id];
if($level_plus_build)
{
$level_plus['LEVEL_PLUS_GREEN'] = $level_plus_build < 0 ? $level_plus_build : "+{$level_plus_build}";
$total['units'][$unit_id]['LEVEL_PLUS_GREEN'] += $level_plus['LEVEL_PLUS_GREEN'];
}
break;
*/
/** @noinspection PhpMissingBreakStatementInspection */
case 'fleet':
$level_plus['LEVEL_PLUS_YELLOW'] = $planet['fleet_list']['own']['total'][$unit_id] <= 0 ? $planet['fleet_list']['own']['total'][$unit_id] : "+{$planet['fleet_list']['own']['total'][$unit_id]}";
$total['units'][$unit_id]['LEVEL_PLUS_YELLOW'] += $level_plus['LEVEL_PLUS_YELLOW'];
case 'structures':
case 'defense':
$level_plus_build = $ques[$planet['id']]['in_que'][que_get_unit_que($unit_id)][$user['id']][$planet['id']][$unit_id];
if ($level_plus_build) {
$level_plus['LEVEL_PLUS_GREEN'] = $level_plus_build < 0 ? $level_plus_build : "+{$level_plus_build}";
// $level_plus['LEVEL_PLUS_GREEN'] = "+{$level_plus_build}";
$total['units'][$unit_id]['LEVEL_PLUS_GREEN'] += $level_plus['LEVEL_PLUS_GREEN'];
}
break;
default:
break;
}
$block_vars[] = array_merge($level_plus, array('ID' => $planet['id'], 'TYPE' => $planet['planet_type'], 'LEVEL' => $unit_level_plain == 0 && !$level_plus['LEVEL_PLUS_YELLOW'] && !$level_plus['LEVEL_PLUS_GREEN'] ? '-' : $unit_level_plain));
$unit_count += $unit_level_plain;
$unit_count_abs += $unit_level_plain + abs($level_plus['LEVEL_PLUS_YELLOW']) + abs($level_plus['LEVEL_PLUS_GREEN']);
}
if ($unit_count_abs) {
$template->assign_block_vars('prods', array('ID' => $unit_id, 'FIELD' => 'unit_' . $unit_id, 'NAME' => $lang['tech'][$unit_id], 'MODE' => $mode));
foreach ($block_vars as $block_var) {
$template->assign_block_vars('prods.planet', $block_var);
}
$unit_green = $total['units'][$unit_id]['LEVEL_PLUS_GREEN'];
$unit_yellow = $total['units'][$unit_id]['LEVEL_PLUS_YELLOW'];
$template->assign_block_vars('prods.planet', array('ID' => 0, 'LEVEL' => $unit_count, 'LEVEL_PLUS_GREEN' => $unit_green == 0 ? '' : ($unit_green > 0 ? "+{$unit_green}" : $unit_green), 'LEVEL_PLUS_YELLOW' => $unit_yellow == 0 ? '' : ($unit_yellow > 0 ? "+{$unit_yellow}" : $unit_yellow), 'PERCENT' => $unit_is_factory ? '' : -1, 'FACTORY' => $unit_is_factory));
}
}
}
$template->assign_block_vars('planet', array_merge(array('ID' => 0, 'NAME' => $lang['sys_total'], 'FIELDS_CUR' => $total['fields'], 'FIELDS_MAX' => $total['fields_max'], 'METAL_CUR' => pretty_number($total['metal']), 'METAL_PROD' => pretty_number($total['metal_perhour']), 'CRYSTAL_CUR' => pretty_number($total['crystal']), 'CRYSTAL_PROD' => pretty_number($total['crystal_perhour']), 'DEUTERIUM_CUR' => pretty_number($total['deuterium']), 'DEUTERIUM_PROD' => pretty_number($total['deuterium_perhour']), 'ENERGY_CUR' => pretty_number($total['energy']), 'ENERGY_MAX' => pretty_number($total['energy_max']), 'TEMP_MIN' => $total['temp_min'], 'TEMP_MAX' => $total['temp_max'])));
$template->assign_vars(array('COLONIES_CURRENT' => get_player_current_colonies($user), 'COLONIES_MAX' => get_player_max_colonies($user), 'EXPEDITIONS_CURRENT' => get_player_current_expeditions($user), 'EXPEDITIONS_MAX' => get_player_max_expeditons($user), 'PLANET_DENSITY_RICHNESS_NORMAL' => PLANET_DENSITY_RICHNESS_NORMAL, 'PLANET_DENSITY_RICHNESS_AVERAGE' => PLANET_DENSITY_RICHNESS_AVERAGE, 'PLANET_DENSITY_RICHNESS_GOOD' => PLANET_DENSITY_RICHNESS_GOOD, 'PLANET_DENSITY_RICHNESS_PERFECT' => PLANET_DENSITY_RICHNESS_PERFECT));
//$template->assign_recursive($template_result);
return $template;
}
} else {
$dpath = "../" . $user["dpath"];
}
} else {
$dpath = $UserSkin;
}
lng_include('admin');
} elseif ($sys_user_logged_in) {
$dpath = $user["dpath"] ? $user["dpath"] : DEFAULT_SKINPATH;
flt_flying_fleet_handler($config, $skip_fleet_update);
$planet_id = SetSelectedPlanet($user);
doquery('START TRANSACTION;');
$global_data = sys_o_get_updated($user, $planet_id, $time_now);
if (!$global_data['planet']) {
doquery("UPDATE {{users}} SET `current_planet` = '{$user['id_planet']}' WHERE `id` = '{$user['id']}' LIMIT 1;");
$global_data = sys_o_get_updated($user, $user['id_planet'], $time_now);
}
doquery('COMMIT;');
if (!$global_data) {
$debug->error("User ID {$user['id']} has no current planet and no homeworld", 'User record error', 502);
}
$planetrow = $global_data['planet'];
if (!($planetrow && isset($planetrow['id']) && $planetrow['id'])) {
header('Location: login.php');
ob_end_flush();
die;
}
$que = $global_data['que'];
CheckPlanetUsedFields($planetrow);
HandleTechnologieBuild($user, $planetrow);
if (!$allow_anonymous) {
function flt_t_send_fleet($user, &$from, $to, $fleet, $mission, $options = array())
{
//ini_set('error_reporting', E_ALL);
//doquery('SET autocommit = 0;');
//doquery('LOCK TABLES {{users}} READ, {{planets}} WRITE, {{fleet}} WRITE, {{aks}} WRITE, {{statpoints}} READ;');
doquery('START TRANSACTION;');
$from = sys_o_get_updated($user, $from['id'], $GLOBALS['time_now']);
$from = $from['planet'];
$speed_factor = get_fleet_speed();
$distance = GetTargetDistance($from['galaxy'], $to['galaxy'], $from['system'], $to['system'], $from['planet'], $to['planet']);
$fleet_speed = min(GetFleetMaxSpeed($fleet, 0, $user));
$duration = GetMissionDuration(10, $fleet_speed, $distance, $speed_factor);
$consumption = GetFleetConsumption($fleet, $speed_factor, $duration, $distance, $fleet_speed, $user);
//!!
$fleet_group = 0;
//!!
$options = array();
$can_attack = flt_can_attack($from, $to, $fleet, $mission, $options);
if ($can_attack != ATTACK_ALLOWED) {
doquery('ROLLBACK');
return $can_attack;
}
global $time_now, $sn_data;
$fleet_start_time = $time_now + $duration;
if ($mission == MT_EXPLORE or $mission == MT_HOLD) {
$stay_duration = $options['stay_time'] * 3600;
$stay_time = $fleet_start_time + $stay_duration;
} else {
$stay_duration = 0;
$stay_time = 0;
}
$fleet_end_time = $fleet_start_time + $duration + $stay_duration;
$fleet_ship_count = 0;
$fleet_string = '';
$planet_sub_query = '';
foreach ($fleet as $unit_id => $amount) {
if (!$amount || !$unit_id) {
continue;
}
if (in_array($unit_id, $sn_data['groups']['fleet'])) {
$fleet_ship_count += $amount;
$fleet_string .= "{$unit_id},{$amount};";
}
$planet_sub_query .= "`{$sn_data[$unit_id]['name']}` = `{$sn_data[$unit_id]['name']}` - {$amount},";
}
$to['id_owner'] = intval($to['id_owner']);
$QryInsertFleet = "INSERT INTO {{fleets}} SET ";
$QryInsertFleet .= "`fleet_owner` = '{$user['id']}', ";
$QryInsertFleet .= "`fleet_mission` = '{$mission}', ";
$QryInsertFleet .= "`fleet_amount` = '{$fleet_ship_count}', ";
$QryInsertFleet .= "`fleet_array` = '{$fleet_string}', ";
$QryInsertFleet .= "`fleet_start_time` = '{$fleet_start_time}', ";
$QryInsertFleet .= "`fleet_start_galaxy` = '{$from['galaxy']}', ";
$QryInsertFleet .= "`fleet_start_system` = '{$from['system']}', ";
$QryInsertFleet .= "`fleet_start_planet` = '{$from['planet']}', ";
$QryInsertFleet .= "`fleet_start_type` = '{$from['planet_type']}', ";
$QryInsertFleet .= "`fleet_end_time` = '{$fleet_end_time}', ";
$QryInsertFleet .= "`fleet_end_stay` = '{$stay_time}', ";
$QryInsertFleet .= "`fleet_end_galaxy` = '{$to['galaxy']}', ";
$QryInsertFleet .= "`fleet_end_system` = '{$to['system']}', ";
$QryInsertFleet .= "`fleet_end_planet` = '{$to['planet']}', ";
$QryInsertFleet .= "`fleet_end_type` = '{$to['planet_type']}', ";
$QryInsertFleet .= "`fleet_resource_metal` = '{$fleet[RES_METAL]}', ";
$QryInsertFleet .= "`fleet_resource_crystal` = '{$fleet[RES_CRYSTAL]}', ";
$QryInsertFleet .= "`fleet_resource_deuterium` = '{$fleet[RES_DEUTERIUM]}', ";
$QryInsertFleet .= "`fleet_target_owner` = '{$to['id_owner']}', ";
$QryInsertFleet .= "`fleet_group` = '{$fleet_group}', ";
$QryInsertFleet .= "`start_time` = '{$time_now}';";
doquery($QryInsertFleet);
$QryUpdatePlanet = "UPDATE {{planets}} SET {$planet_sub_query} `deuterium` = `deuterium` - '{$consumption}' WHERE `id` = '{$from['id']}' LIMIT 1;";
doquery($QryUpdatePlanet);
if (BE_DEBUG) {
debug($QryInsertFleet);
debug($QryUpdatePlanet);
}
doquery("COMMIT;");
// doquery('SET autocommit = 1;');
$from = doquery("SELECT * FROM {{planets}} WHERE `id` = '{$from['id']}' LIMIT 1;", '', true);
return ATTACK_ALLOWED;
//ini_set('error_reporting', E_ALL ^ E_NOTICE);
}
if ($planet['id'] == $destination['id']) {
$errors[] = $lang['adm_pl_comp_err_5'];
}
if ($planet['id_owner'] != $destination['id_owner']) {
$errors[] = $lang['adm_pl_comp_err_3'];
}
if (!empty($errors)) {
foreach ($errors as $error) {
$template->assign_block_vars('error', array('TEXT' => $error));
}
} else {
$template->assign_var('CHECK', 1);
killer_add_planet($planet);
$moon = db_planet_by_gspt($galaxy_src, $system_src, $planet_src, PT_MOON, true);
if ($moon) {
$moon = sys_o_get_updated($owner, $moon, SN_TIME_NOW);
$moon = $moon['planet'];
killer_add_planet($moon);
}
foreach (sn_get_groups('resources_loot') as $resource_id) {
$resource_name = pname_resource_name($resource_id);
$template->assign_var("{$resource_name}_cost", $final_cost[$resource_id]);
$final_cost[$resource_id] = floor($final_cost[$resource_id] * $bonus);
$template->assign_var("{$resource_name}_bonus", $final_cost[$resource_id]);
}
if ($_GET['btn_confirm']) {
$time = SN_TIME_NOW + PERIOD_DAY;
db_unit_list_delete($planet['id_owner'], LOC_PLANET, $planet['id']);
db_planet_set_by_id($planet['id'], "id_owner = 0, destruyed = {$time}");
if ($moon) {
db_unit_list_delete($planet['id_owner'], LOC_PLANET, $moon['id']);
function flt_cache_planet($planet_vector, &$flt_user_cache, &$flt_planet_cache)
{
if (!$planet_vector) {
return;
}
$planet_hash = flt_planet_hash($planet_vector);
//"g{$planet_vector['galaxy']}s{$planet_vector['system']}p{$planet_vector['planet']}t{$planet_vector['planet_type']}";
if (!isset($flt_planet_cache[$planet_hash])) {
$global_data = sys_o_get_updated(false, $planet_vector, $GLOBALS['time_now']);
$flt_planet_cache[$planet_hash] = $global_data['planet'];
if ($flt_planet_cache[$planet_hash]) {
$flt_user_row_id = flt_cache_user($global_data['user'], $flt_user_cache);
} else {
$flt_user_row_id = 0;
}
} else {
$flt_user_row_id = flt_cache_user($flt_planet_cache[$planet_hash]['id_owner'], $flt_user_cache);
}
return array('planet_hash' => $planet_hash, 'user_id' => $flt_user_row_id);
}
function flt_flying_fleet_handler($skip_fleet_update = false)
{
/*
[*] Нужно ли заворачивать ВСЕ в одну транзакцию?
С одной стороны - да, что бы данные были гарантированно на момент снапшота
С другой стороны - нет, потому что при большой активности это все будет блокировать слишком много рядов, да и таймаут будет большой для ожидания всего разлоченного
Стоит завернуть каждую миссию отдельно? Это сильно увеличит количество запросов, зато так же сильно снизит количество блокировок.
Resume: НЕТ! Надо оставить все в одной транзакции! Так можно будет поддерживать consistency кэша. Там буквально сантисекунды блокировки
[*] Убрать кэшированние данных о пользователях и планета. Офигенно освободит память - проследить!
НЕТ! Считать, скольким флотам нужна будет инфа и кэшировать только то, что используется больше раза!
Заодно можно будет исключить перересчет очередей/ресурсов - сильно ускорит дело!
Особенно будет актуально, когда все бонусы будут в одной таблице
Ну и никто не заставляет как сейчас брать ВСЕ из таблицы - только по полям. Гемор, но не сильный - сделать запрос по группам sn_data
И писать в БД только один раз результат
[*] Нужно ли на этом этапе знать полную информацию о флотах?
Заблокировать флоты можно и неполным запросом. Блокировка флотов - это не страшно. Ну, не пройдет одна-две отмены - так никто и не гарантировал реалтайма!
С одной стороны - да, уменьшит количество запросов
С другой стооны - расход памяти
Все равно надо будет знать полную инфу о флоте в момент обработки
[*] Сделать тестовую БД для расчетов
[*] Но не раньше, чем переписать все миссии
*/
global $config, $debug;
if ($config->game_disable != GAME_DISABLE_NONE || $skip_fleet_update) {
return;
}
sn_db_transaction_start();
if ($config->db_loadItem('game_disable') != GAME_DISABLE_NONE || SN_TIME_NOW - strtotime($config->db_loadItem('fleet_update_last')) <= $config->fleet_update_interval) {
sn_db_transaction_rollback();
return;
}
// Watchdog timer
if ($config->db_loadItem('fleet_update_lock')) {
if (SN_TIME_NOW - strtotime($config->fleet_update_lock) <= mt_rand(240, 300)) {
sn_db_transaction_rollback();
return;
} else {
$debug->warning('Flying fleet handler was locked too long - watchdog unlocked', 'FFH Error', 504);
}
}
$config->db_saveItem('fleet_update_lock', SN_TIME_SQL);
$config->db_saveItem('fleet_update_last', SN_TIME_SQL);
sn_db_transaction_commit();
//log_file('Начинаем обсчёт флотов');
//log_file('Обсчёт ракет');
sn_db_transaction_start();
coe_o_missile_calculate();
sn_db_transaction_commit();
$fleet_list = array();
$fleet_event_list = array();
$missions_used = array();
sn_db_transaction_start();
//log_file('Запрос на флоты');
$_fleets = doquery("SELECT * FROM `{{fleets}}` WHERE\n (`fleet_start_time` <= " . SN_TIME_NOW . " AND `fleet_mess` = 0)\n OR (`fleet_end_stay` <= " . SN_TIME_NOW . " AND fleet_end_stay > 0 AND `fleet_mess` = 0)\n OR (`fleet_end_time` <= " . SN_TIME_NOW . ")\n FOR UPDATE;");
//log_file('Выборка флотов');
while ($fleet_row = db_fetch($_fleets)) {
set_time_limit(15);
// Унифицировать код с темплейтным разбором эвентов на планете!
$fleet_list[$fleet_row['fleet_id']] = $fleet_row;
$missions_used[$fleet_row['fleet_mission']] = 1;
if ($fleet_row['fleet_start_time'] <= SN_TIME_NOW && $fleet_row['fleet_mess'] == 0) {
$fleet_event_list[] = array('fleet_row' => &$fleet_list[$fleet_row['fleet_id']], 'fleet_time' => $fleet_list[$fleet_row['fleet_id']]['fleet_start_time'], 'fleet_event' => EVENT_FLT_ARRIVE);
}
if ($fleet_row['fleet_end_stay'] > 0 && $fleet_row['fleet_end_stay'] <= SN_TIME_NOW && $fleet_row['fleet_mess'] == 0) {
$fleet_event_list[] = array('fleet_row' => &$fleet_list[$fleet_row['fleet_id']], 'fleet_time' => $fleet_list[$fleet_row['fleet_id']]['fleet_end_stay'], 'fleet_event' => EVENT_FLT_ACOMPLISH);
}
if ($fleet_row['fleet_end_time'] <= SN_TIME_NOW) {
$fleet_event_list[] = array('fleet_row' => &$fleet_list[$fleet_row['fleet_id']], 'fleet_time' => $fleet_list[$fleet_row['fleet_id']]['fleet_end_time'], 'fleet_event' => EVENT_FLT_RETURN);
}
}
sn_db_transaction_commit();
//log_file('Сортировка и подгрузка модулей');
uasort($fleet_event_list, 'flt_flyingFleetsSort');
unset($_fleets);
// TODO: Грузить только используемые модули из $missions_used
$mission_files = array(MT_ATTACK => 'flt_mission_attack', MT_AKS => 'flt_mission_attack', MT_DESTROY => 'flt_mission_attack', MT_TRANSPORT => 'flt_mission_transport', MT_RELOCATE => 'flt_mission_relocate', MT_HOLD => 'flt_mission_hold', MT_SPY => 'flt_mission_spy', MT_COLONIZE => 'flt_mission_colonize', MT_RECYCLE => 'flt_mission_recycle', MT_EXPLORE => 'flt_mission_explore');
foreach ($missions_used as $mission_id => $cork) {
require_once SN_ROOT_PHYSICAL . "includes/includes/{$mission_files[$mission_id]}" . DOT_PHP_EX;
}
//log_file('Обработка миссий');
$sn_groups_mission = sn_get_groups('missions');
foreach ($fleet_event_list as $fleet_event) {
// TODO: Указатель тут потом сделать
// TODO: СЕЙЧАС НАДО ПРОВЕРЯТЬ ПО БАЗЕ - А ЖИВОЙ ЛИ ФЛОТ?!
$fleet_row = $fleet_event['fleet_row'];
if (!$fleet_row) {
// Fleet was destroyed in course of previous actions
continue;
}
//log_file('Миссия');
// TODO Обернуть всё в транзакции. Начинать надо заранее, блокируя все таблицы внутренним локом SELECT 1 FROM {{users}}
sn_db_transaction_start();
$config->db_saveItem('fleet_update_last', SN_TIME_SQL);
$mission_data = $sn_groups_mission[$fleet_row['fleet_mission']];
// Формируем запрос, блокирующий сразу все нужные записи
db_flying_fleet_lock($mission_data, $fleet_row);
$fleet_row = doquery("SELECT * FROM {{fleets}} WHERE fleet_id = {$fleet_row['fleet_id']} FOR UPDATE", true);
if (!$fleet_row || empty($fleet_row)) {
// Fleet was destroyed in course of previous actions
sn_db_transaction_commit();
continue;
}
if ($fleet_event['fleet_event'] == EVENT_FLT_RETURN) {
// Fleet returns to planet
RestoreFleetToPlanet($fleet_row, true, false, true);
sn_db_transaction_commit();
continue;
}
if ($fleet_event['fleet_event'] == EVENT_FLT_ARRIVE && $fleet_row['fleet_mess'] != 0) {
// При событии EVENT_FLT_ARRIVE флот всегда должен иметь fleet_mess == 0
// В противном случае это означает, что флот уже был обработан ранее - например, при САБе
sn_db_transaction_commit();
continue;
}
// TODO: Здесь тоже указатели
// TODO: Кэширование
// TODO: Выбирать только нужные поля
// шпионаж не дает нормальный ID fleet_end_planet_id 'dst_planet'
$mission_data = array('fleet' => &$fleet_row, 'dst_user' => $mission_data['dst_user'] || $mission_data['dst_planet'] ? db_user_by_id($fleet_row['fleet_target_owner'], true) : null, 'dst_planet' => $mission_data['dst_planet'] ? db_planet_by_vector($fleet_row, 'fleet_end_', true, '`id`, `id_owner`, `name`') : null, 'src_user' => $mission_data['src_user'] || $mission_data['src_planet'] ? db_user_by_id($fleet_row['fleet_owner'], true) : null, 'src_planet' => $mission_data['src_planet'] ? db_planet_by_vector($fleet_row, 'fleet_start_', true, '`id`, `id_owner`, `name`') : null, 'fleet_event' => $fleet_event['fleet_event']);
if ($mission_data['dst_planet']) {
// $mission_data['dst_planet'] = sys_o_get_updated($mission_data['dst_user'], $mission_data['dst_planet']['id'], $fleet_row['fleet_start_time']);
if ($mission_data['dst_planet']['id_owner']) {
$mission_data['dst_planet'] = sys_o_get_updated($mission_data['dst_planet']['id_owner'], $mission_data['dst_planet']['id'], $fleet_row['fleet_start_time']);
}
$mission_data['dst_user'] = $mission_data['dst_user'] ? $mission_data['dst_planet']['user'] : null;
$mission_data['dst_planet'] = $mission_data['dst_planet']['planet'];
}
switch ($fleet_row['fleet_mission']) {
// Для боевых атак нужно обновлять по САБу и по холду - таки надо возвращать данные из обработчика миссий!
case MT_AKS:
case MT_ATTACK:
case MT_DESTROY:
$attack_result = flt_mission_attack($mission_data);
$mission_result = CACHE_COMBAT;
break;
/*
case MT_DESTROY:
$attack_result = flt_mission_destroy($mission_data);
$mission_result = CACHE_COMBAT;
break;
*/
/*
case MT_DESTROY:
$attack_result = flt_mission_destroy($mission_data);
$mission_result = CACHE_COMBAT;
break;
*/
case MT_TRANSPORT:
$mission_result = flt_mission_transport($mission_data);
break;
case MT_HOLD:
$mission_result = flt_mission_hold($mission_data);
break;
case MT_RELOCATE:
$mission_result = flt_mission_relocate($mission_data);
break;
case MT_EXPLORE:
$mission_result = flt_mission_explore($mission_data);
break;
case MT_RECYCLE:
$mission_result = flt_mission_recycle($mission_data);
break;
case MT_COLONIZE:
$mission_result = flt_mission_colonize($mission_data);
break;
case MT_SPY:
$mission_result = flt_mission_spy($mission_data);
break;
case MT_MISSILE:
// Missiles !!
break;
// default:
// doquery("DELETE FROM `{{fleets}}` WHERE `fleet_id` = '{$fleet_row['fleet_id']}' LIMIT 1;");
// break;
}
sn_db_transaction_commit();
}
sn_db_transaction_start();
$config->db_saveItem('fleet_update_last', SN_TIME_SQL);
$config->db_saveItem('fleet_update_lock', '');
sn_db_transaction_commit();
// log_file('Закончили обсчёт флотов');
}
/**
* Copyright (c) 2009-2010 by Gorlum for http://supernova.ws
* OpenSource as long as you don't remove this Copyright
* V3 2009-11-13
* V2 2009-10-10
*/
function coe_o_missile_calculate()
{
sn_db_transaction_check(true);
global $lang;
$iraks = doquery("SELECT * FROM {{iraks}} WHERE `fleet_end_time` <= " . SN_TIME_NOW . " FOR UPDATE;");
while ($fleetRow = db_fetch($iraks)) {
set_time_limit(15);
$db_changeset = array();
$targetUser = db_user_by_id($fleetRow['fleet_target_owner'], true);
$target_planet_row = sys_o_get_updated($targetUser, array('galaxy' => $fleetRow['fleet_end_galaxy'], 'system' => $fleetRow['fleet_end_system'], 'planet' => $fleetRow['fleet_end_planet'], 'planet_type' => PT_PLANET), SN_TIME_NOW);
$target_planet_row = $target_planet_row['planet'];
$rowAttacker = db_user_by_id($fleetRow['fleet_owner'], true);
if ($target_planet_row['id']) {
$planetDefense = array();
foreach (sn_get_groups('defense_active') as $unit_id) {
$planetDefense[$unit_id] = array(mrc_get_level($targetUser, $target_planet_row, $unit_id, true, true));
}
$message = '';
$interceptors = mrc_get_level($targetUser, $target_planet_row, UNIT_DEF_MISSILE_INTERCEPTOR, true, true);
//$target_planet_row[$interceptor_db_name]; // Number of interceptors
$missiles = $fleetRow['fleet_amount'];
// Number of MIP
if ($interceptors >= $missiles) {
$message = $lang['mip_all_destroyed'];
$db_changeset['unit'][] = sn_db_unit_changeset_prepare(UNIT_DEF_MISSILE_INTERCEPTOR, -$missiles, $targetUser, $target_planet_row['id']);
} else {
if ($interceptors) {
$message = sprintf($lang['mip_destroyed'], $interceptors);
$db_changeset['unit'][] = sn_db_unit_changeset_prepare(UNIT_DEF_MISSILE_INTERCEPTOR, -$interceptors, $targetUser, $target_planet_row['id']);
}
// $message .= $lang['mip_defense_destroyed'];
$attackResult = COE_missileAttack($targetUser, $rowAttacker, $missiles - $interceptors, $planetDefense, $fleetRow['primaer']);
foreach ($attackResult['structures'] as $key => $structure) {
$destroyed = $planetDefense[$key][0] - $structure[0];
if ($destroyed) {
$db_changeset['unit'][] = sn_db_unit_changeset_prepare($key, -$destroyed, $targetUser, $target_planet_row['id']);
$message .= " {$lang['tech'][$key]} - {$destroyed} {$lang['quantity']}<br>";
}
}
if (!empty($message)) {
$message = $lang['mip_defense_destroyed'] . $message . "{$lang['mip_recycled']}{$lang['Metal']}: {$attackResult['metal']}, {$lang['Crystal']}: {$attackResult['crystal']}<br>";
db_planet_set_by_id($target_planet_row['id'], "`metal` = `metal` + {$attackResult['metal']}, `crystal` = `crystal` + {$attackResult['crystal']}");
}
// $message .= "{$lang['mip_recycled']}{$lang['Metal']}: {$attackResult['metal']}, {$lang['Crystal']}: {$attackResult['crystal']}<br>";
}
db_changeset_apply($db_changeset);
$fleetRow['fleet_start_type'] = PT_PLANET;
$sourcePlanet = db_planet_by_vector($fleetRow, 'fleet_start_', false, 'name');
$message_vorlage = sprintf($lang['mip_body_attack'], $fleetRow['fleet_amount'], addslashes($sourcePlanet['name']), $fleetRow['fleet_start_galaxy'], $fleetRow['fleet_start_system'], $fleetRow['fleet_start_planet'], addslashes($target_planet_row['name']), $fleetRow['fleet_end_galaxy'], $fleetRow['fleet_end_system'], $fleetRow['fleet_end_planet']);
empty($message) ? $message = $lang['mip_no_defense'] : false;
// empty($message) && ($message = $lang['mip_no_defense']);
msg_send_simple_message($fleetRow['fleet_owner'], '', SN_TIME_NOW, MSG_TYPE_SPY, $lang['mip_sender_amd'], $lang['mip_subject_amd'], $message_vorlage . $message);
msg_send_simple_message($fleetRow['fleet_target_owner'], '', SN_TIME_NOW, MSG_TYPE_SPY, $lang['mip_sender_amd'], $lang['mip_subject_amd'], $message_vorlage . $message);
}
doquery("DELETE FROM {{iraks}} WHERE id = '{$fleetRow['id']}';");
}
}
function flt_t_send_fleet($user, &$from, $to, $fleet, $mission, $options = array())
{
//ini_set('error_reporting', E_ALL);
$internal_transaction = !sn_db_transaction_check(false) ? sn_db_transaction_start() : false;
//pdump($internal_transaction);
// TODO Потенциальный дедлок - если успела залочится запись пользователя - хозяина планеты
$user = db_user_by_id($user['id'], true);
$from = sys_o_get_updated($user, $from['id'], SN_TIME_NOW);
$from = $from['planet'];
$can_attack = flt_can_attack($from, $to, $fleet, $mission, $options);
if ($can_attack != ATTACK_ALLOWED) {
$internal_transaction ? sn_db_transaction_rollback() : false;
return $can_attack;
}
$fleet_group = isset($options['fleet_group']) ? floatval($options['fleet_group']) : 0;
$travel_data = flt_travel_data($user, $from, $to, $fleet, $options['fleet_speed_percent']);
$fleet_start_time = SN_TIME_NOW + $travel_data['duration'];
if ($mission == MT_EXPLORE || $mission == MT_HOLD) {
$stay_duration = $options['stay_time'] * 3600;
$stay_time = $fleet_start_time + $stay_duration;
} else {
$stay_duration = 0;
$stay_time = 0;
}
$fleet_end_time = $fleet_start_time + $travel_data['duration'] + $stay_duration;
$fleet_ship_count = 0;
$fleet_string = '';
$db_changeset = array();
$planet_fields = array();
foreach ($fleet as $unit_id => $amount) {
if (!$amount || !$unit_id) {
continue;
}
if (in_array($unit_id, sn_get_groups('fleet'))) {
$fleet_ship_count += $amount;
$fleet_string .= "{$unit_id},{$amount};";
$db_changeset['unit'][] = sn_db_unit_changeset_prepare($unit_id, -$amount, $user, $from['id']);
} elseif (in_array($unit_id, sn_get_groups('resources_loot'))) {
$planet_fields[pname_resource_name($unit_id)]['delta'] -= $amount;
}
}
$to['id_owner'] = intval($to['id_owner']);
$QryInsertFleet = "INSERT INTO {{fleets}} SET ";
$QryInsertFleet .= "`fleet_owner` = '{$user['id']}', ";
$QryInsertFleet .= "`fleet_mission` = '{$mission}', ";
$QryInsertFleet .= "`fleet_amount` = '{$fleet_ship_count}', ";
$QryInsertFleet .= "`fleet_array` = '{$fleet_string}', ";
$QryInsertFleet .= "`fleet_start_time` = '{$fleet_start_time}', ";
if ($from['id']) {
$QryInsertFleet .= "`fleet_start_planet_id` = '{$from['id']}', ";
}
$QryInsertFleet .= "`fleet_start_galaxy` = '{$from['galaxy']}', ";
$QryInsertFleet .= "`fleet_start_system` = '{$from['system']}', ";
$QryInsertFleet .= "`fleet_start_planet` = '{$from['planet']}', ";
$QryInsertFleet .= "`fleet_start_type` = '{$from['planet_type']}', ";
$QryInsertFleet .= "`fleet_end_time` = '{$fleet_end_time}', ";
$QryInsertFleet .= "`fleet_end_stay` = '{$stay_time}', ";
if ($to['id']) {
$QryInsertFleet .= "`fleet_end_planet_id` = '{$to['id']}', ";
}
$QryInsertFleet .= "`fleet_end_galaxy` = '{$to['galaxy']}', ";
$QryInsertFleet .= "`fleet_end_system` = '{$to['system']}', ";
$QryInsertFleet .= "`fleet_end_planet` = '{$to['planet']}', ";
$QryInsertFleet .= "`fleet_end_type` = '{$to['planet_type']}', ";
$QryInsertFleet .= "`fleet_resource_metal` = " . floatval($fleet[RES_METAL]) . ", ";
$QryInsertFleet .= "`fleet_resource_crystal` = " . floatval($fleet[RES_CRYSTAL]) . ", ";
$QryInsertFleet .= "`fleet_resource_deuterium` = " . floatval($fleet[RES_DEUTERIUM]) . ", ";
$QryInsertFleet .= "`fleet_target_owner` = '{$to['id_owner']}', ";
$QryInsertFleet .= "`fleet_group` = '{$fleet_group}', ";
$QryInsertFleet .= "`start_time` = " . SN_TIME_NOW . ";";
doquery($QryInsertFleet);
$planet_fields[pname_resource_name(RES_DEUTERIUM)]['delta'] -= $travel_data['consumption'];
$db_changeset['planets'][] = array('action' => SQL_OP_UPDATE, P_VERSION => 1, 'where' => array('id' => $from['id']), 'fields' => $planet_fields);
db_changeset_apply($db_changeset);
$internal_transaction ? sn_db_transaction_commit() : false;
$from = db_planet_by_id($from['id']);
return ATTACK_ALLOWED;
//ini_set('error_reporting', E_ALL ^ E_NOTICE);
}
}
display(parsetemplate($template), $lang['rename_and_abandon_planet']);
break;
default:
$template = gettemplate('planet_overview', true);
rpg_level_up($user, RPG_STRUCTURE);
rpg_level_up($user, RPG_RAID);
$fleet_id = 1;
int_get_fleet_to_planet("SELECT DISTINCT * FROM {{fleets}} WHERE `fleet_owner` = '{$user['id']}' OR `fleet_target_owner` = '{$user['id']}';");
int_get_missile_to_planet("SELECT * FROM `{{iraks}}` WHERE `owner` = '{$user['id']}'");
$planets_query = SortUserPlanets($user, false, '*');
while ($UserPlanet = mysql_fetch_assoc($planets_query)) {
if ($UserPlanet['planet_type'] == PT_MOON) {
continue;
}
$UserPlanet = sys_o_get_updated($user, $UserPlanet, $time_now, true);
$list_planet_que = $UserPlanet['que'];
$UserPlanet = $UserPlanet['planet'];
$template_planet = tpl_parse_planet($UserPlanet, $list_planet_que);
$planet_fleet_id = 0;
$fleet_list = $template_planet['fleet_list'];
if ($fleet_list['own']['count']) {
$planet_fleet_id = "p{$fleet_id}";
$fleets[] = tpl_parse_fleet_sn($fleet_list['own']['total'], $planet_fleet_id);
$fleet_id++;
}
$moon = doquery("SELECT * FROM {{planets}} WHERE `parent_planet` = '{$UserPlanet['id']}' AND `planet_type` = 3 LIMIT 1;", '', true);
if ($moon) {
$moon_fill = min(100, floor($moon['field_current'] / eco_planet_fields_max($moon) * 100));
} else {
$moon_fill = 0;
message($lang['opt_vacation_err_your_fleet'], $lang['Error'], 'options.php', 5);
die;
} else {
$query = doquery("SELECT * FROM `{{planets}}` WHERE `id_owner` = '{$user['id']}';");
while ($planet = mysql_fetch_assoc($query)) {
$global_data = sys_o_get_updated($user, $planet, $time_now, true);
$planet = $global_data['planet'];
if ($planet['que'] || ($planet['b_tech'] || $planet['b_tech_id']) || ($planet['b_hangar'] || $planet['b_hangar_id'])) {
message(sprintf($lang['opt_vacation_err_building'], $planet['name']), $lang['Error'], 'options.php', 5);
die;
}
}
}
$query = doquery("SELECT * FROM {{planets}} WHERE id_owner = '{$user['id']}' FOR UPDATE;");
while ($planet = mysql_fetch_assoc($query)) {
$planet = sys_o_get_updated($user, $planet, $time_now);
$planet = $planet['planet'];
doquery("UPDATE {{planets}} SET\r\n last_update = '{$time_now}',\r\n metal_perhour = '{$config->metal_basic_income}',\r\n crystal_perhour = '{$config->crystal_basic_income}',\r\n deuterium_perhour = '{$config->deuterium_basic_income}',\r\n energy_used = '0',\r\n energy_max = '0',\r\n metal_mine_porcent = '0',\r\n crystal_mine_porcent = '0',\r\n deuterium_sintetizer_porcent = '0',\r\n solar_plant_porcent = '0',\r\n fusion_plant_porcent = '0',\r\n solar_satelit_porcent = '0'\r\n WHERE id = '{$planet['id']}' LIMIT 1;");
}
$user['vacation'] = $time_now + $config->player_vacation_time;
} else {
$user['vacation'] = $time_now;
}
// doquery("UPDATE {{users}} SET `vacation` = '{$user['vacation']}' WHERE `id` = '{$user['id']}' LIMIT 1;");
}
foreach ($user_option_list as $option_group_id => $option_group) {
foreach ($option_group as $option_name => $option_value) {
if ($user[$option_name] !== null) {
$user[$option_name] = sys_get_param_str($option_name);
} else {
$user[$option_name] = $option_value;
if ($planet['id'] == $destination['id']) {
$errors[] = $lang['adm_pl_comp_err_5'];
}
if ($planet['id_owner'] != $destination['id_owner']) {
$errors[] = $lang['adm_pl_comp_err_3'];
}
if (!empty($errors)) {
foreach ($errors as $error) {
$template->assign_block_vars('error', array('TEXT' => $error));
}
} else {
$template->assign_var('CHECK', 1);
killer_add_planet($planet);
$moon = doquery("SELECT * FROM {{planets}} WHERE galaxy = '{$galaxy_src}' AND system = '{$system_src}' AND planet = '{$planet_src}' AND planet_type = 3;", '', true);
if ($moon) {
$moon = sys_o_get_updated($owner, $moon, time());
$moon = $moon['planet'];
killer_add_planet($moon);
}
foreach ($sn_data['groups']['resources_loot'] as $resource_id) {
$resource_name = $sn_data[$resource_id]['name'];
$template->assign_var("{$resource_name}_cost", $final_cost[$resource_id]);
$final_cost[$resource_id] = floor($final_cost[$resource_id] * $bonus);
$template->assign_var("{$resource_name}_bonus", $final_cost[$resource_id]);
}
if ($_GET['btn_confirm']) {
doquery("UPDATE {{planets}} SET metal = metal + '{$final_cost[RES_METAL]}', crystal = crystal + '{$final_cost[RES_CRYSTAL]}', deuterium = deuterium + '{$final_cost[RES_DEUTERIUM]}' WHERE id = {$destination['id']};");
$time = time() + 24 * 60 * 60;
doquery("UPDATE {{planets}} SET id_owner = 0, destruyed = '{$time}' WHERE id = {$planet['id']};");
if ($moon) {
doquery("UPDATE {{planets}} SET id_owner = 0, destruyed = '{$time}' WHERE id = {$moon['id']};");
function ShowTopNavigationBar($user, $planetrow)
{
if (!is_array($user)) {
return '';
}
global $time_now, $lang, $config, $sn_data;
$GET_mode = sys_get_param_str('mode');
$template = gettemplate('topnav', true);
$planetrow = $planetrow ? $planetrow : $user['current_planet'];
$planetrow = sys_o_get_updated($user, $planetrow, $time_now, true);
$planetrow = $planetrow['planet'];
$ThisUsersPlanets = SortUserPlanets($user);
while ($CurPlanet = mysql_fetch_assoc($ThisUsersPlanets)) {
if (!$CurPlanet['destruyed']) {
$template->assign_block_vars('topnav_planets', array('ID' => $CurPlanet['id'], 'NAME' => $CurPlanet['name'], 'COORDS' => uni_render_coordinates($CurPlanet), 'SELECTED' => $CurPlanet['id'] == $user['current_planet'] ? ' selected' : ''));
}
}
$day_of_week = $lang['weekdays'][date('w')];
$day = date('d');
$month = $lang['months'][date('m')];
$year = date('Y');
$hour = date('H');
$min = date('i');
$sec = date('s');
// Количество флотов и экспедиций, а так же события флотов
$fleet_flying_list = flt_get_fleets_flying($user);
tpl_topnav_event_build($template, $fleet_flying_list[0]);
tpl_topnav_event_build($template, $fleet_flying_list[MT_EXPLORE], 'expedition');
// Подсчет кол-ва онлайн и кто онлайн
$time = $time_now - 15 * 60;
$online_count = doquery("SELECT COUNT(*) AS users_online FROM {{users}} WHERE `onlinetime`>'{$time}';", '', true);
$template->assign_vars(array('TIME_NOW' => $time_now, 'DATE_TEXT' => "{$day_of_week}, {$day} {$month} {$year} {$lang['top_of_year']},", 'TIME_TEXT' => "{$hour}:{$min}:{$sec}", 'USERS_ONLINE' => $online_count['users_online'], 'USERS_TOTAL' => $config->users_amount, 'TOPNAV_CURRENT_PLANET' => $user['current_planet'], 'TOPNAV_MODE' => $GET_mode, 'TOPNAV_METAL' => round($planetrow["metal"], 2), 'TOPNAV_METAL_MAX' => round($planetrow["metal_max"]), 'TOPNAV_METAL_PERHOUR' => round($planetrow["metal_perhour"], 5), 'TOPNAV_METAL_TEXT' => pretty_number($planetrow["metal"], 2), 'TOPNAV_METAL_MAX_TEXT' => pretty_number($planetrow["metal_max"], 2, -$planetrow["metal"]), 'TOPNAV_CRYSTAL' => round($planetrow["crystal"], 2), 'TOPNAV_CRYSTAL_MAX' => round($planetrow["crystal_max"]), 'TOPNAV_CRYSTAL_PERHOUR' => round($planetrow["crystal_perhour"], 5), 'TOPNAV_CRYSTAL_TEXT' => pretty_number($planetrow["crystal"], 2), 'TOPNAV_CRYSTAL_MAX_TEXT' => pretty_number($planetrow["crystal_max"], 2, -$planetrow["crystal"]), 'TOPNAV_DEUTERIUM' => round($planetrow["deuterium"], 2), 'TOPNAV_DEUTERIUM_MAX' => round($planetrow["deuterium_max"]), 'TOPNAV_DEUTERIUM_PERHOUR' => round($planetrow["deuterium_perhour"], 5), 'TOPNAV_DEUTERIUM_TEXT' => pretty_number($planetrow["deuterium"], 2), 'TOPNAV_DEUTERIUM_MAX_TEXT' => pretty_number($planetrow["deuterium_max"], 2, -$planetrow["deuterium"]), 'TOPNAV_DARK_MATTER' => pretty_number($user[$sn_data[RES_DARK_MATTER]['name']]), 'ENERGY_BALANCE' => pretty_number($planetrow['energy_max'] - $planetrow['energy_used'], true, 0), 'ENERGY_MAX' => pretty_number($planetrow['energy_max']), 'TOPNAV_MESSAGES_ADMIN' => $user['msg_admin'], 'TOPNAV_MESSAGES_PLAYER' => $user['mnl_joueur'], 'TOPNAV_MESSAGES_ALLIANCE' => $user['mnl_alliance'], 'TOPNAV_MESSAGES_ALL' => $user['new_message'], 'TOPNAV_FLEETS_FLYING' => count($fleet_flying_list[0]), 'TOPNAV_FLEETS_TOTAL' => GetMaxFleets($user), 'TOPNAV_EXPEDITIONS_FLYING' => count($fleet_flying_list[MT_EXPLORE]), 'TOPNAV_EXPEDITIONS_TOTAL' => GetMaxExpeditions($user), 'TOPNAV_QUEST_COMPLETE' => get_quest_amount_complete($user['id'])));
return $template;
}
/**
* imperium.php
*
* Overview you empire
*
* @version 1.0
* @copyright 2008 by Chlorel for XNova
// Created by Perberos. All rights reserved (C) 2006
*/
include 'common.' . substr(strrchr(__FILE__, '.'), 1);
$planets = array();
$ques = array();
//$planet_row_list = doquery("SELECT `id` FROM {{planets}} WHERE `id_owner` = '{$user['id']}';");
$planet_row_list = SortUserPlanets($user);
while ($planet = mysql_fetch_assoc($planet_row_list)) {
$global_data = sys_o_get_updated($user, $planet['id'], $time_now);
$planets[$planet['id']] = $global_data['planet'];
$ques[$planet['id']] = $global_data['que'];
}
$template = gettemplate('imperium', true);
$template->assign_var('amount', count($planets) + 2);
$fleet_id = 1;
$fleets = array();
$total['temp_min'] = 1000;
$total['temp_max'] = -999;
foreach ($planets as $planet_index => &$planet) {
$list_planet_que = $ques[$planet_index];
$planet_template = tpl_parse_planet($planet, $list_planet_que);
$planet_fleet_id = 0;
$fleet_list = $planet_template['fleet_list'];
//flt_get_fleets_to_planet($planet);
