function nws_mark_read(&$user)
{
if (isset($user['id'])) {
db_user_set_by_id($user['id'], '`news_lastread` = ' . SN_TIME_NOW);
$user['news_lastread'] = SN_TIME_NOW;
}
return true;
}
function sn_user_birthday_celebrate()
{
global $config, $lang;
sn_db_transaction_start();
$query = db_user_list_to_celebrate($config->user_birthday_range);
while ($row = db_fetch($query)) {
$row['username'] = db_escape($row['username']);
rpg_points_change($row['id'], RPG_BIRTHDAY, $config->user_birthday_gift, "Birthday gift for user {$row['username']} ID {$row['id']} on his birthday on {$row['user_birthday']}. Gift last gaved at {$row['user_birthday_celebrated']}");
db_user_set_by_id($row['id'], "`user_birthday_celebrated` = '{$row['current_birthday']}'");
msg_send_simple_message($row['id'], 0, SN_TIME_NOW, MSG_TYPE_ADMIN, $lang['sys_administration'], $lang['sys_birthday'], sprintf($lang['sys_birthday_message'], $row['username'], $row['current_birthday'], $config->user_birthday_gift, $lang['sys_dark_matter_sh']), true, true);
}
$config->db_saveItem('user_birthday_celebrate', SN_TIME_NOW);
sn_db_transaction_commit();
}
$user = db_user_by_id($user['id'], true, '*');
$planetrow = db_planet_by_id($planetrow['id'], true, '*');
$result = array('STATUS' => ERR_NONE, 'MESSAGE' => $lang['ov_teleport_err_none']);
sys_redirect('overview.php?mode=manage');
} catch (exception $e) {
sn_db_transaction_rollback();
$result = array('STATUS' => $e->getCode(), 'MESSAGE' => $e->getMessage());
}
} elseif (sys_get_param_str('abandon')) {
//if(sec_password_encode(sys_get_param('abandon_confirm'), $user['salt']) == $user['password']) {
if (sec_password_check($user, sys_get_param('abandon_confirm'))) {
if ($user['id_planet'] != $user['current_planet'] && $user['current_planet'] == $planet_id) {
$destroyed = SN_TIME_NOW + 60 * 60 * 24;
db_planet_set_by_id($user['current_planet'], "`destruyed`='{$destroyed}', `id_owner`=0");
db_planet_set_by_parent($user['current_planet'], "`destruyed`='{$destroyed}', `id_owner`=0");
db_user_set_by_id($user['id'], '`current_planet` = `id_planet`');
message($lang['ov_delete_ok'], $lang['colony_abandon'], 'overview.php?mode=manage');
} else {
message($lang['ov_delete_wrong_planet'], $lang['colony_abandon'], 'overview.php?mode=manage');
}
} else {
message($lang['ov_delete_wrong_pass'], $lang['colony_abandon'], 'overview.php?mode=manage');
}
} elseif (($hire = sys_get_param_int('hire')) && in_array($hire, sn_get_groups('governors')) && (!get_unit_param($hire, P_MAX_STACK) || $planetrow['PLANET_GOVERNOR_ID'] != $hire || $planetrow['PLANET_GOVERNOR_ID'] == $hire && $planetrow['PLANET_GOVERNOR_LEVEL'] < get_unit_param($hire, P_MAX_STACK))) {
sn_db_transaction_start();
$user = db_user_by_id($user['id'], true);
$planetrow = db_planet_by_id($planetrow['id'], true);
$build_data = eco_get_build_data($user, $planetrow, $hire, $planetrow['PLANET_GOVERNOR_ID'] == $hire ? $planetrow['PLANET_GOVERNOR_LEVEL'] : 0);
if ($build_data['CAN'][BUILD_CREATE]) {
if ($planetrow['PLANET_GOVERNOR_ID'] == $hire) {
$planetrow['PLANET_GOVERNOR_LEVEL']++;
if (defined('IN_ADMIN') && IN_ADMIN === true) {
lng_include('admin');
} elseif ($sys_user_logged_in) {
sys_user_vacation($user);
$planet_id = SetSelectedPlanet($user);
// 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']['']) {
case 'apply':
require 'includes/alliance/ali_external_request.inc';
break;
case 'make':
require 'includes/alliance/ali_external_create_ally.inc';
break;
default:
display(parsetemplate(gettemplate('ali_external', true)), $lang['alliance']);
break;
}
}
}
sn_ali_fill_user_ally($user);
//$ally = doquery("SELECT * FROM {{alliance}} WHERE `id` ='{$user['ally_id']}'", '', true);
if (!isset($user['ally'])) {
db_user_set_by_id($user['id'], "`ally_id` = null, `ally_name` = null, `ally_register_time` = 0, `ally_rank_id` = 0");
message($lang['ali_sys_notFound'], $lang['your_alliance'], 'alliance.php');
}
$ally =& $user['ally'];
/*
$ally_rights = array(
0 => 'name',
1 => 'mail',
2 => 'online',
3 => 'invite',
4 => 'kick',
5 => 'admin',
6 => 'forum',
7 => 'diplomacy'
);
*/
function player_create($username_unsafe, $password_raw, $email_unsafe, $options)
{
global $config, $lang;
static $player_options_string = 'opt_mnl_spy^1|opt_email_mnl_spy^0|opt_email_mnl_joueur^0|opt_email_mnl_alliance^0|opt_mnl_attaque^1|opt_email_mnl_attaque^0|opt_mnl_exploit^1|opt_email_mnl_exploit^0|opt_mnl_transport^1|opt_email_mnl_transport^0|opt_email_msg_admin^1|opt_mnl_expedition^1|opt_email_mnl_expedition^0|opt_mnl_buildlist^1|opt_email_mnl_buildlist^0|opt_int_navbar_resource_force^1|';
empty($options['planet_options']) ? $options['planet_options'] = array() : false;
$field_set = array('server_name' => SN_ROOT_VIRTUAL, 'register_time' => SN_TIME_NOW, 'user_bot' => $options['user_bot'] = empty($options['user_bot']) ? USER_BOT_PLAYER : $options['total_points'], 'username' => $username_unsafe, 'email' => $email_unsafe, 'email_2' => $email_unsafe, 'lang' => $options['language_iso'] ? $options['language_iso'] : DEFAULT_LANG, 'dpath' => DEFAULT_SKINPATH, 'total_points' => $options['total_points'] = empty($options['total_points']) ? 0 : $options['total_points'], 'options' => (empty($options['options']) ? $player_options_string : $options['options']) . (empty($options['options_extra']) ? '' : $options['options_extra']), 'galaxy' => $options['galaxy'] = intval($options['galaxy'] ? $options['galaxy'] : 0), 'system' => $options['system'] = intval($options['system'] ? $options['system'] : 0), 'planet' => $options['planet'] = intval($options['planet'] ? $options['planet'] : 0));
$user_new = classSupernova::db_ins_field_set(LOC_USER, $field_set);
sec_password_change($user_new, $password_raw, false, $options['remember_me'] = intval(!empty($options['remember_me'])));
$username_safe = db_escape($username_unsafe);
// $options['language_iso'] = db_escape($options['language_iso'] ? $options['language_iso'] : DEFAULT_LANG);
// $options['remember_me'] = intval(!empty($options['remember_me']));
//
// $skin_safe = db_escape(DEFAULT_SKINPATH);
// $email_safe = db_escape($email_unsafe);
//
// // sn_db_field_set_make_safe($field_set, $serialize = false)
//
// $user_new = classSupernova::db_ins_record(LOC_USER, "`username` = '{$username_safe}', `email` = '{$email_safe}', `email_2` = '{$email_safe}', `dpath` = '{$skin_safe}',
// `lang` = '{$options['language_iso']}', `register_time` = " . SN_TIME_NOW . ", `server_name` = '" . db_escape(SN_ROOT_VIRTUAL) . "',
// `options` = 'opt_mnl_spy^1|opt_email_mnl_spy^0|opt_email_mnl_joueur^0|opt_email_mnl_alliance^0|opt_mnl_attaque^1|opt_email_mnl_attaque^0|opt_mnl_exploit^1|opt_email_mnl_exploit^0|opt_mnl_transport^1|opt_email_mnl_transport^0|opt_email_msg_admin^1|opt_mnl_expedition^1|opt_email_mnl_expedition^0|opt_mnl_buildlist^1|opt_email_mnl_buildlist^0|opt_int_navbar_resource_force^1|';");
doquery("REPLACE INTO {{player_name_history}} SET `player_id` = {$user_new['id']}, `player_name` = '{$username_safe}'");
if (!empty($options['partner_id']) && ($referral_row = db_user_by_id($options['partner_id'], true))) {
doquery("INSERT INTO {{referrals}} SET `id` = {$user_new['id']}, `id_partner` = {$options['partner_id']}");
}
if (!($options['galaxy'] && $options['system'] && $options['planet'])) {
$options['galaxy'] = $config->LastSettedGalaxyPos;
$options['system'] = $config->LastSettedSystemPos;
$segment_size = floor($config->game_maxPlanet / 3);
$segment = floor($config->LastSettedPlanetPos / $segment_size);
$segment++;
$options['planet'] = mt_rand(1 + $segment * $segment_size, ($segment + 1) * $segment_size);
// $new_planet_id = 0;
while (true) {
if ($options['planet'] > $config->game_maxPlanet) {
$options['planet'] = mt_rand(0, $segment_size - 1) + 1;
$options['system']++;
}
if ($options['system'] > $config->game_maxSystem) {
$options['system'] = 1;
$options['galaxy']++;
}
$options['galaxy'] > $config->game_maxGalaxy ? $options['galaxy'] = 1 : false;
$galaxy_row = db_planet_by_gspt($options['galaxy'], $options['system'], $options['planet'], PT_PLANET, true, 'id');
if (!$galaxy_row['id']) {
$config->db_saveItem(array('LastSettedGalaxyPos' => $options['galaxy'], 'LastSettedSystemPos' => $options['system'], 'LastSettedPlanetPos' => $options['planet']));
// $new_planet_id = uni_create_planet($options['galaxy'], $options['system'], $options['planet'], $user_new['id'], $username_unsafe . ' ' . $lang['sys_capital'], true, $options['planet_options']);
break;
}
$options['planet'] += 3;
}
}
$new_planet_id = uni_create_planet($options['galaxy'], $options['system'], $options['planet'], $user_new['id'], $username_unsafe . ' ' . $lang['sys_capital'], true, $options['planet_options']);
sys_player_new_adjust($user_new['id'], $new_planet_id);
db_user_set_by_id($user_new['id'], "`id_planet` = '{$new_planet_id}', `current_planet` = '{$new_planet_id}', `galaxy` = '{$options['galaxy']}', `system` = '{$options['$system']}', `planet` = '{$options['$planet']}'");
$config->db_saveItem('users_amount', $config->users_amount + 1);
return db_user_by_id($user_new['id']);
}
foreach(sn_get_groups('tech') as $Item)
{
$parse['adm_sub_form3'] .= "<tr><th>".$lang['tech'][$Item]."</th>";
$parse['adm_sub_form3'] .= "<th>".$SelUser[get_unit_param($Item, P_NAME)]."</th></tr>";
}
$parse['adm_sub_form3'] .= "</tbody></table>";
*/
break;
case 'usr_level':
# only for admins
if ($user['authlevel'] < 3 || $NewLevel >= $user['authlevel']) {
message($lang['sys_noalloaw'], $lang['sys_noaccess']);
die;
}
$selected_user = db_user_by_username($Pattern, false, 'id');
$QryUpdate = db_user_set_by_id($selected_user['id'], "`authlevel` = '{$NewLvl}'");
$Message = $lang['adm_mess_lvl1'] . " " . $Pattern . " " . $lang['adm_mess_lvl2'];
$Message .= "<font color=\"red\">" . $lang['adm_usr_level'][$NewLvl] . "</font>!";
AdminMessage($Message, $lang['adm_mod_level']);
break;
case 'ip_search':
$bloc = $lang;
$bloc['adm_this_ip'] = $ip;
$SelUser = db_user_list("`user_lastip` = '{$ip}'");
//while ( $Usr = db_fetch($SelUser) ) {
foreach ($SelUser as $Usr) {
$UsrMain = db_planet_by_id($Usr['id_planet'], false, 'name');
$bloc['adm_plyer_lst'] .= "<tr><th>" . $Usr['username'] . "</th><th>[" . $Usr['galaxy'] . ":" . $Usr['system'] . ":" . $Usr['planet'] . "] " . $UsrMain['name'] . "</th></tr>";
}
$SubPanelTPL = gettemplate('admin/admin_panel_asw2');
$parse['adm_sub_form2'] = parsetemplate($SubPanelTPL, $bloc);
function sn_options_model()
{
global $user, $user_option_list, $lang, $template_result, $config;
$language_new = sys_get_param_str('langer', $user['lang']);
if ($language_new != $user['lang']) {
$lang->lng_switch($language_new);
}
lng_include('options');
lng_include('messages');
$FMT_DATE = preg_replace(array('/d/', '/m/', '/Y/'), array('DD', 'MM', 'YYYY'), FMT_DATE);
if (sys_get_param_str('mode') == 'change') {
if ($user['authlevel'] > 0) {
$planet_protection = sys_get_param_int('adm_pl_prot') ? $user['authlevel'] : 0;
db_planet_set_by_owner($user['id'], "`id_level` = '{$planet_protection}'");
db_user_set_by_id($user['id'], "`admin_protection` = '{$planet_protection}'");
$user['admin_protection'] = $planet_protection;
}
if (sys_get_param_int('vacation') && !$config->user_vacation_disable) {
sn_db_transaction_start();
if ($user['authlevel'] < 3) {
if ($user['vacation_next'] > SN_TIME_NOW) {
message($lang['opt_vacation_err_timeout'], $lang['Error'], 'index.php?page=options', 5);
die;
}
$is_building = doquery("SELECT * FROM `{{fleets}}` WHERE `fleet_owner` = '{$user['id']}' LIMIT 1;", true);
if ($is_building) {
message($lang['opt_vacation_err_your_fleet'], $lang['Error'], 'index.php?page=options', 5);
die;
}
$que = que_get($user['id'], false);
if (!empty($que)) {
message($lang['opt_vacation_err_que'], $lang['Error'], 'index.php?page=options', 5);
die;
}
$query = classSupernova::db_get_record_list(LOC_PLANET, "`id_owner` = {$user['id']}");
foreach ($query as $planet) {
// $planet = sys_o_get_updated($user, $planet, SN_TIME_NOW);
// $planet = $planet['planet'];
db_planet_set_by_id($planet['id'], "last_update = " . SN_TIME_NOW . ", energy_used = '0', energy_max = '0',\n metal_perhour = '{$config->metal_basic_income}', crystal_perhour = '{$config->crystal_basic_income}', deuterium_perhour = '{$config->deuterium_basic_income}',\n metal_mine_porcent = '0', crystal_mine_porcent = '0', deuterium_sintetizer_porcent = '0', solar_plant_porcent = '0',\n fusion_plant_porcent = '0', solar_satelit_porcent = '0', ship_sattelite_sloth_porcent = 0");
}
$user['vacation'] = SN_TIME_NOW + $config->player_vacation_time;
} else {
$user['vacation'] = SN_TIME_NOW;
}
sn_db_transaction_commit();
}
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;
}
}
}
$options = sys_user_options_pack($user);
$player_options = sys_get_param('options');
if (!empty($player_options)) {
array_walk($player_options, function (&$value) {
// TODO - Когда будет больше параметров - сделать больше проверок
$value = intval($value);
});
classSupernova::$user_options->offsetSet($player_options);
// pdump($player_options);die();
// player_save_option_array($user, $player_options);
}
$username = substr(sys_get_param_str_unsafe('username'), 0, 32);
$username_safe = db_escape($username);
if ($username && $user['username'] != $username && $config->game_user_changename != SERVER_PLAYER_NAME_CHANGE_NONE && sys_get_param_int('username_confirm') && !strpbrk($username, LOGIN_REGISTER_CHARACTERS_PROHIBITED)) {
// проверка на корректность
sn_db_transaction_start();
$name_check = doquery("SELECT * FROM {{player_name_history}} WHERE `player_name` LIKE \"{$username_safe}\" LIMIT 1 FOR UPDATE;", true);
if (!$name_check || $name_check['player_id'] == $user['id']) {
$user = db_user_by_id($user['id'], true);
switch ($config->game_user_changename) {
case SERVER_PLAYER_NAME_CHANGE_PAY:
if (mrc_get_level($user, $planetrow, RES_DARK_MATTER) < $config->game_user_changename_cost) {
$template_result['.']['result'][] = array('STATUS' => ERR_ERROR, 'MESSAGE' => $lang['opt_msg_name_change_err_no_dm']);
break;
}
rpg_points_change($user['id'], RPG_NAME_CHANGE, -$config->game_user_changename_cost, sprintf('Пользователь ID %d сменил имя с "%s" на "%s"', $user['id'], $user['username'], $username));
case SERVER_PLAYER_NAME_CHANGE_FREE:
db_user_set_by_id($user['id'], "`username` = '{$username_safe}'");
doquery("REPLACE INTO {{player_name_history}} SET `player_id` = {$user['id']}, `player_name` = '{$username_safe}'");
// TODO: Change cookie to not force user relogin
// sn_setcookie(SN_COOKIE, '', time() - PERIOD_WEEK, SN_ROOT_RELATIVE);
$template_result['.']['result'][] = array('STATUS' => ERR_NONE, 'MESSAGE' => $lang['opt_msg_name_changed']);
$user['username'] = $username;
break;
}
} else {
$template_result['.']['result'][] = array('STATUS' => ERR_ERROR, 'MESSAGE' => $lang['opt_msg_name_change_err_used_name']);
}
sn_db_transaction_commit();
}
if ($new_password = sys_get_param('newpass1')) {
try {
if ($new_password != sys_get_param('newpass2')) {
throw new Exception($lang['opt_err_pass_unmatched'], ERR_WARNING);
}
if (!classSupernova::$auth->password_change(sys_get_param('db_password'), $new_password)) {
throw new Exception($lang['opt_err_pass_wrong'], ERR_WARNING);
}
throw new Exception($lang['opt_msg_pass_changed'], ERR_NONE);
} catch (Exception $e) {
$template_result['.']['result'][] = array('STATUS' => in_array($e->getCode(), array(ERR_NONE, ERR_WARNING, ERR_ERROR)) ? $e->getCode() : ERR_ERROR, 'MESSAGE' => $e->getMessage());
}
}
$user['email'] = sys_get_param_str('db_email');
// if(!$template_result[F_ACCOUNT]['account_email'] && ($email_2 = sys_get_param_str('db_email2'))) {
// core_auth::email_set($email_2);
// }
$user['dpath'] = sys_get_param_str('dpath');
$user['lang'] = sys_get_param_str('langer', $user['lang']);
// if($lang->lng_switch($user['lang'])) {
// lng_include('options');
// lng_include('messages');
// }
$user['design'] = sys_get_param_int('design');
$user['noipcheck'] = sys_get_param_int('noipcheck');
// $user['spio_anz'] = sys_get_param_int('spio_anz');
// $user['settings_fleetactions'] = sys_get_param_int('settings_fleetactions', 1);
// $user['settings_tooltiptime'] = sys_get_param_int('settings_tooltiptime');
// $user['settings_esp'] = sys_get_param_int('settings_esp');
// $user['settings_wri'] = sys_get_param_int('settings_wri');
// $user['settings_bud'] = sys_get_param_int('settings_bud');
// $user['settings_mis'] = sys_get_param_int('settings_mis');
// $user['settings_statistics'] = sys_get_param_int('settings_statistics');
// $user['settings_info'] = sys_get_param_int('settings_info');
// $user['settings_rep'] = sys_get_param_int('settings_rep');
// $user['planet_sort'] = sys_get_param_int('settings_sort');
// $user['planet_sort_order'] = sys_get_param_int('settings_order');
$user['deltime'] = !sys_get_param_int('deltime') ? 0 : ($user['deltime'] ? $user['deltime'] : SN_TIME_NOW + $config->player_delete_time);
$gender = sys_get_param_int('gender', $user['gender']);
!isset($lang['sys_gender_list'][$gender]) ? $gender = $user['gender'] : false;
$user['gender'] = $user['gender'] == GENDER_UNKNOWN ? $gender : $user['gender'];
try {
if ($user['birthday']) {
throw new exception();
}
$user_birthday = sys_get_param_str_unsafe('user_birthday');
if (!$user_birthday || $user_birthday == $FMT_DATE) {
throw new exception();
}
// Some black magic to parse any valid date format - those that contains all three "d", "m" and "Y" and any of the delimeters "\", "/", ".", "-"
$pos['d'] = strpos(FMT_DATE, 'd');
$pos['m'] = strpos(FMT_DATE, 'm');
$pos['Y'] = strpos(FMT_DATE, 'Y');
asort($pos);
$i = 0;
foreach ($pos as &$position) {
$position = ++$i;
}
$regexp = "/" . preg_replace(array('/\\\\/', '/\\//', '/\\./', '/\\-/', '/d/', '/m/', '/Y/'), array('\\\\\\', '\\/', '\\.', '\\-', '(\\d?\\d)', '(\\d?\\d)', '(\\d{4})'), FMT_DATE) . "/";
if (!preg_match($regexp, $user_birthday, $match)) {
throw new exception();
}
if (!checkdate($match[$pos['m']], $match[$pos['d']], $match[$pos['Y']])) {
throw new exception();
}
$user['user_birthday'] = db_escape("{$match[$pos['Y']]}-{$match[$pos['m']]}-{$match[$pos['d']]}");
// EOF black magic! Now we have valid SQL date in $user['user_birthday'] - independent of date format
$year = date('Y', SN_TIME_NOW);
if (mktime(0, 0, 0, $match[$pos['m']], $match[$pos['d']], $year) > SN_TIME_NOW) {
$year--;
}
$user['user_birthday_celebrated'] = db_escape("{$year}-{$match[$pos['m']]}-{$match[$pos['d']]}");
$user_birthday = ", `user_birthday` = '{$user['user_birthday']}', `user_birthday_celebrated` = '{$user['user_birthday_celebrated']}'";
} catch (exception $e) {
$user_birthday = '';
}
require_once 'includes/includes/sys_avatar.php';
$avatar_upload_result = sys_avatar_upload($user['id'], $user['avatar']);
$template_result['.']['result'][] = $avatar_upload_result;
$user_time_diff = playerTimeDiff::user_time_diff_get();
if (sys_get_param_int('PLAYER_OPTION_TIME_DIFF_FORCED')) {
playerTimeDiff::user_time_diff_set(array(PLAYER_OPTION_TIME_DIFF => sys_get_param_int('PLAYER_OPTION_TIME_DIFF'), PLAYER_OPTION_TIME_DIFF_UTC_OFFSET => 0, PLAYER_OPTION_TIME_DIFF_FORCED => 1, PLAYER_OPTION_TIME_DIFF_MEASURE_TIME => SN_TIME_SQL));
} elseif (sys_get_param_int('opt_time_diff_clear') || $user_time_diff[PLAYER_OPTION_TIME_DIFF_FORCED]) {
playerTimeDiff::user_time_diff_set(array(PLAYER_OPTION_TIME_DIFF => '', PLAYER_OPTION_TIME_DIFF_UTC_OFFSET => 0, PLAYER_OPTION_TIME_DIFF_FORCED => 0, PLAYER_OPTION_TIME_DIFF_MEASURE_TIME => SN_TIME_SQL));
}
$user_options_safe = db_escape($user['options']);
db_user_set_by_id($user['id'], "`email` = '{$user['email']}', `lang` = '{$user['lang']}', `avatar` = '{$user['avatar']}',\n `dpath` = '{$user['dpath']}', `design` = '{$user['design']}', `noipcheck` = '{$user['noipcheck']}',\n `deltime` = '{$user['deltime']}', `vacation` = '{$user['vacation']}', `options` = '{$user_options_safe}', `gender` = {$user['gender']}\n {$user_birthday}");
$template_result['.']['result'][] = array('STATUS' => ERR_NONE, 'MESSAGE' => $lang['opt_msg_saved']);
} elseif (sys_get_param_str('result') == 'ok') {
$template_result['.']['result'][] = array('STATUS' => ERR_NONE, 'MESSAGE' => $lang['opt_msg_saved']);
}
$user = db_user_by_id($user['id']);
$options = sys_user_options_unpack($user);
}
if ($current_class == MSG_TYPE_NEW) {
$SubUpdateQry = array();
foreach ($sn_message_class_list as $message_class_id => $message_class) {
if ($message_class_id != MSG_TYPE_OUTBOX) {
$SubUpdateQry[] = "`{$message_class['name']}` = '0'";
$user[$message_class['name']] = 0;
}
}
$SubUpdateQry = implode(',', $SubUpdateQry);
} else {
$SubUpdateQry = "`{$sn_message_class_list[$current_class]['name']}` = '0', `{$sn_message_class_list[MSG_TYPE_NEW]['name']}` = `{$sn_message_class_list[MSG_TYPE_NEW]['name']}` - '{$user[$sn_message_class_list[$current_class]['name']]}'";
$SubSelectQry = "AND `message_type` = '{$current_class}'";
$user[$sn_message_class_list[MSG_TYPE_NEW]['name']] -= $user[$sn_message_class_list[$current_class]['name']];
$user[$sn_message_class_list[$current_class]['name']] = 0;
}
db_user_set_by_id($user['id'], $SubUpdateQry);
$message_query = "SELECT * FROM {{messages}} WHERE `message_owner` = '{$user['id']}' {$SubSelectQry} ORDER BY `message_time` DESC;";
$message_query = doquery($message_query);
}
if (sys_get_param_int('return')) {
header('Location: messages.php');
die;
}
$template = gettemplate('msg_message_list', true);
while ($message_row = db_fetch($message_query)) {
$template->assign_block_vars('messages', array('ID' => $message_row['message_id'], 'DATE' => date(FMT_DATE_TIME, $message_row['message_time'] + SN_CLIENT_TIME_DIFF), 'FROM' => htmlspecialchars($message_row['message_from']), 'SUBJ' => htmlspecialchars($message_row['message_subject']), 'TEXT' => in_array($message_row['message_type'], array(MSG_TYPE_PLAYER, MSG_TYPE_ALLIANCE)) && $message_row['message_sender'] ? nl2br(htmlspecialchars($message_row['message_text'])) : nl2br($message_row['message_text']), 'FROM_ID' => $message_row['message_sender'], 'SUBJ_SANITIZED' => htmlspecialchars($message_row['message_subject']), 'STYLE' => $current_class == MSG_TYPE_OUTBOX ? $sn_message_class_list[MSG_TYPE_OUTBOX]['name'] : $sn_message_class_list[$message_row['message_type']]['name']));
}
$current_class_text = $lang['msg_class'][$current_class];
$template->assign_vars(array("MESSAGE_CLASS" => $current_class, "MESSAGE_CLASS_TEXT" => $current_class_text));
break;
}
function que_delete($que_type, $user = array(), $planet = array(), $clear = false)
{
$planets_locked = array();
// TODO: Some checks
sn_db_transaction_start();
$user = db_user_by_id($user['id'], true);
$planet['id'] = $planet['id'] && $que_type !== QUE_RESEARCH ? $planet['id'] : 0;
$global_que = que_get($user['id'], $planet['id'], $que_type, true);
//pdump($global_que);
//pdump($planet['id']);
//pdump($global_que[$que_type][$planet['id']]);
if (!empty($global_que['ques'][$que_type][$user['id']][$planet['id']])) {
$que = array_reverse($global_que['ques'][$que_type][$user['id']][$planet['id']]);
foreach ($que as $que_item) {
db_que_delete_by_id($que_item['que_id']);
if ($que_item['que_planet_id_origin']) {
$planet['id'] = $que_item['que_planet_id_origin'];
}
if (!isset($planets_locked[$planet['id']])) {
$planets_locked[$planet['id']] = $planet['id'] ? db_planet_by_id($planet['id'], true) : $planet;
}
$build_data = sys_unit_str2arr($que_item['que_unit_price']);
db_change_units($user, $planets_locked[$planet['id']], array(RES_METAL => $build_data[RES_METAL] * $que_item['que_unit_amount'], RES_CRYSTAL => $build_data[RES_CRYSTAL] * $que_item['que_unit_amount'], RES_DEUTERIUM => $build_data[RES_DEUTERIUM] * $que_item['que_unit_amount']));
if (!$clear) {
break;
}
}
if (is_numeric($planet['id'])) {
db_planet_set_by_id($planet['id'], "`que_processed` = UNIX_TIMESTAMP(NOW())");
} elseif (is_numeric($user['id'])) {
db_user_set_by_id($user['id'], '`que_processed` = UNIX_TIMESTAMP(NOW())');
}
sn_db_transaction_commit();
} else {
sn_db_transaction_rollback();
}
//die();
header("Location: {$_SERVER['PHP_SELF']}?mode={$que_type}" . "&ally_id=" . sys_get_param_id('ally_id'));
}
foreach ($ship_list as $ship_id => $ship_count) {
if (!in_array($ship_id, sn_get_groups('fleet'))) {
continue;
}
$ship_count = max(0, min(floor($ship_count), mrc_get_level($user, $planetrow, $ship_id)));
if ($ship_count) {
$db_changeset['unit'][] = sn_db_unit_changeset_prepare($ship_id, -$ship_count, $user, $planetrow['id']);
$db_changeset['unit'][] = sn_db_unit_changeset_prepare($ship_id, $ship_count, $user, $TargetGate['id']);
}
}
// Dit monsieur, y avait quelque chose a envoyer ???
if (!empty($db_changeset)) {
db_planet_set_by_id($TargetGate['id'], "`last_jump_time` = " . SN_TIME_NOW . "");
db_planet_set_by_id($planetrow['id'], "`last_jump_time` = " . SN_TIME_NOW . "");
db_changeset_apply($db_changeset);
db_user_set_by_id($user['id'], "`current_planet` = '{$TargetGate['id']}'");
$planetrow['last_jump_time'] = SN_TIME_NOW;
$RetMessage = $lang['gate_jump_done'] . " - " . pretty_time(uni_get_time_to_jump($planetrow));
} else {
$RetMessage = $lang['gate_wait_data'];
}
} else {
$RetMessage = $lang['gate_wait_dest'] . " - " . pretty_time($NextDestTime);
}
} else {
$RetMessage = $lang['gate_no_dest_g'];
}
} else {
$RetMessage = $lang['gate_wait_star'] . " - " . pretty_time($NextJumpTime);
}
sn_db_transaction_commit();
function sn_ube_combat_result_apply(&$combat_data)
{
// TODO: Поменять все отладки на запросы
$destination_user_id = $combat_data[UBE_FLEETS][0][UBE_OWNER];
$outcome =& $combat_data[UBE_OUTCOME];
$planet_info =& $outcome[UBE_PLANET];
$planet_id = $planet_info[PLANET_ID];
// Обновляем поле обломков на планете
if (!$combat_data[UBE_OPTIONS][UBE_COMBAT_ADMIN] && !empty($outcome[UBE_DEBRIS])) {
db_planet_set_by_gspt($planet_info[PLANET_GALAXY], $planet_info[PLANET_SYSTEM], $planet_info[PLANET_PLANET], PT_PLANET, "`debris_metal` = `debris_metal` + " . floor($outcome[UBE_DEBRIS][RES_METAL]) . ", `debris_crystal` = `debris_crystal` + " . floor($outcome[UBE_DEBRIS][RES_CRYSTAL]));
}
$db_save = array(UBE_FLEET_GROUP => array());
$fleets_outcome =& $outcome[UBE_FLEETS];
foreach ($combat_data[UBE_FLEETS] as $fleet_id => &$fleet_info) {
if ($fleet_info[UBE_FLEET_GROUP]) {
$db_save[UBE_FLEET_GROUP][$fleet_info[UBE_FLEET_GROUP]] = $fleet_info[UBE_FLEET_GROUP];
}
$fleet_info[UBE_COUNT] = $fleet_info[UBE_COUNT] ? $fleet_info[UBE_COUNT] : array();
$fleets_outcome[$fleet_id][UBE_UNITS_LOST] = $fleets_outcome[$fleet_id][UBE_UNITS_LOST] ? $fleets_outcome[$fleet_id][UBE_UNITS_LOST] : array();
$fleet_query = array();
$db_changeset = array();
$old_fleet_count = array_sum($fleet_info[UBE_COUNT]);
$new_fleet_count = $old_fleet_count - array_sum($fleets_outcome[$fleet_id][UBE_UNITS_LOST]);
// Перебираем юниты если во время боя количество юнитов изменилось и при этом во флоту остались юниты или это планета
if ($new_fleet_count != $old_fleet_count && (!$fleet_id || $new_fleet_count)) {
// Просматриваем результаты изменения флотов
foreach ($fleet_info[UBE_COUNT] as $unit_id => $unit_count) {
// Перебираем аутком на случай восстановления юнитов
$units_lost = (double) $fleets_outcome[$fleet_id][UBE_UNITS_LOST][$unit_id];
$units_left = $unit_count - $units_lost;
if ($fleet_id) {
// Не планета - всегда сразу записываем строку итогов флота
$fleet_query[$unit_id] = "{$unit_id},{$units_left}";
} elseif ($units_lost) {
// Планета - записываем в ИД юнита его потери только если есть потери
// $unit_db_name = get_unit_param($unit_id, P_NAME);
// $fleet_query[$unit_id] = "`{$unit_db_name}` = `{$unit_db_name}` - {$units_lost}";
// pdump($fleet_info);
// die();
$db_changeset['unit'][] = sn_db_unit_changeset_prepare($unit_id, -$units_lost, $combat_data[UBE_PLAYERS][$destination_user_id][UBE_PLAYER_DATA], $planet_id);
}
}
if ($fleet_id) {
// Для флотов перегенерируем массив как одно вхождение в SET SQL-запроса
$fleet_query = implode(';', $fleet_query);
$fleet_query = array("`fleet_array` = '{$fleet_query}'");
}
}
// Если во флоте остались юниты или это планета - генерируем изменение ресурсов
if ($new_fleet_count || !$fleet_id) {
foreach (sn_get_groups('resources_loot') as $resource_id) {
$resource_change = (double) $fleets_outcome[$fleet_id][UBE_RESOURCES_LOOTED][$resource_id] + (double) $fleets_outcome[$fleet_id][UBE_CARGO_DROPPED][$resource_id];
if ($resource_change) {
$resource_db_name = ($fleet_id ? 'fleet_resource_' : '') . pname_resource_name($resource_id);
$fleet_query[] = "`{$resource_db_name}` = `{$resource_db_name}` - ({$resource_change})";
}
}
}
/*
if(empty($fleet_query))
{
continue;
}
*/
if ($fleet_id && $new_fleet_count) {
// Если защитник и не РМФ - отправляем флот назад
if ($fleet_info[UBE_FLEET_TYPE] == UBE_DEFENDERS && !$outcome[UBE_SFR] || $fleet_info[UBE_FLEET_TYPE] == UBE_ATTACKERS) {
$fleet_query[] = '`fleet_mess` = 1';
}
// Если флот в группе - помечаем нулем
// if($fleet_info[UBE_FLEET_GROUP])
// {
// $fleet_query[] = '`fleet_group` = 0';
// }
}
//global $debug;
$fleet_query = implode(',', $fleet_query);
if ($fleet_id) {
if ($fleet_info[UBE_FLEET_TYPE] == UBE_ATTACKERS && $outcome[UBE_MOON_REAPERS] == UBE_MOON_REAPERS_DIED) {
$new_fleet_count = 0;
}
if ($new_fleet_count) {
if ($fleet_query) {
doquery("UPDATE {{fleets}} SET {$fleet_query}, `fleet_amount` = '{$new_fleet_count}' WHERE `fleet_id` = {$fleet_id} LIMIT 1");
}
} else {
// Удаляем пустые флоты
doquery("DELETE FROM {{fleets}} WHERE `fleet_id` = {$fleet_id} LIMIT 1");
db_unit_list_delete(0, LOC_FLEET, $fleet_id, 0);
}
} else {
// Сохраняем изменения ресурсов - если они есть
if ($fleet_query) {
db_planet_set_by_id($planet_id, $fleet_query);
}
if (!empty($db_changeset)) {
db_changeset_apply($db_changeset);
}
}
}
// TODO: Связать сабы с флотами констраинтами ON DELETE SET NULL
// $db_save[UBE_FLEET_GROUP][$fleet_info[UBE_FLEET_GROUP]] = $fleet_info[UBE_FLEET_GROUP];
if (!empty($db_save[UBE_FLEET_GROUP])) {
$db_save[UBE_FLEET_GROUP] = implode(',', $db_save[UBE_FLEET_GROUP]);
doquery("DELETE FROM {{aks}} WHERE `id` IN ({$db_save[UBE_FLEET_GROUP]})");
}
if ($outcome[UBE_MOON] == UBE_MOON_CREATE_SUCCESS) {
$moon_row = uni_create_moon($planet_info[PLANET_GALAXY], $planet_info[PLANET_SYSTEM], $planet_info[PLANET_PLANET], $destination_user_id, $outcome[UBE_MOON_SIZE], '', false);
$outcome[UBE_MOON_NAME] = $moon_row['name'];
unset($moon_row);
} elseif ($outcome[UBE_MOON] == UBE_MOON_DESTROY_SUCCESS) {
db_planet_delete_by_id($planet_id);
}
$bashing_list = array();
foreach ($combat_data[UBE_PLAYERS] as $player_id => $player_info) {
if ($player_info[UBE_ATTACKER]) {
if ($outcome[UBE_MOON] != UBE_MOON_DESTROY_SUCCESS) {
$bashing_list[] = "({$player_id}, {$planet_id}, {$combat_data[UBE_TIME]})";
}
if ($combat_data[UBE_OPTIONS][UBE_MISSION_TYPE] == MT_ATTACK && $combat_data[UBE_OPTIONS][UBE_DEFENDER_ACTIVE]) {
$str_loose_or_win = $outcome[UBE_COMBAT_RESULT] == UBE_COMBAT_RESULT_WIN ? 'raidswin' : 'raidsloose';
db_user_set_by_id($player_id, "`xpraid` = `xpraid` + 1, `raids` = `raids` + 1, `{$str_loose_or_win}` = `{$str_loose_or_win}` + 1");
}
}
}
$bashing_list = implode(',', $bashing_list);
if ($bashing_list) {
doquery("INSERT INTO {{bashing}} (bashing_user_id, bashing_planet_id, bashing_time) VALUES {$bashing_list};");
}
}
protected function make_return_array()
{
global $config;
$user_id = !empty(self::$user['id']) ? self::$user['id'] : 0;
// if(!empty($user_id) && !$user_impersonator) {
// $user_id не может быть пустым из-за констраинтов в таблице SPE
// self::db_security_entry_insert();
self::$device->db_security_entry_insert($user_id);
$result = array();
if ($user_id && empty($this->is_impersonating)) {
// self::db_counter_insert();
self::$device->db_counter_insert($user_id);
$user =& self::$user;
sys_user_options_unpack($user);
if ($user['banaday'] && $user['banaday'] <= SN_TIME_NOW) {
$user['banaday'] = 0;
$user['vacation'] = SN_TIME_NOW;
}
$user['user_lastip'] = self::$device->ip_v4_string;
// $ip['ip'];
$user['user_proxy'] = self::$device->ip_v4_proxy_chain;
//$ip['proxy_chain'];
$result[F_BANNED_STATUS] = $user['banaday'];
$result[F_VACATION_STATUS] = $user['vacation'];
$proxy_safe = static::$db->db_escape(self::$device->ip_v4_proxy_chain);
db_user_set_by_id($user['id'], "`onlinetime` = " . SN_TIME_NOW . ",\n `banaday` = " . static::$db->db_escape($user['banaday']) . ", `vacation` = " . static::$db->db_escape($user['vacation']) . ",\n `user_lastip` = '" . static::$db->db_escape($user['user_lastip']) . "', `user_last_proxy` = '{$proxy_safe}', `user_last_browser_id` = " . self::$device->browser_id);
}
if ($extra = $config->security_ban_extra) {
$extra = explode(',', $extra);
array_walk($extra, 'trim');
in_array(self::$device->device_id, $extra) and die;
}
$result[F_LOGIN_STATUS] = self::$login_status = empty($this->providers_authorised) ? self::$login_status : LOGIN_SUCCESS;
$result[F_PLAYER_REGISTER_STATUS] = $this->register_status;
$result[F_USER] = self::$user;
// $result[AUTH_LEVEL] = isset(self::$user['authlevel']) ? self::$user['authlevel'] : AUTH_LEVEL_ANONYMOUS;
$result[AUTH_LEVEL] = $this->auth_level_max_local;
$result[F_IMPERSONATE_STATUS] = $this->is_impersonating;
$result[F_IMPERSONATE_OPERATOR] = $this->impersonator_username;
// TODO
// self::$hidden[F_IMPERSONATE_OPERATOR] = $found_provider->data[F_IMPERSONATE_OPERATOR];
//TODO Сол и Парол тоже вкинуть в хидден
$result[F_ACCOUNTS_AUTHORISED] = $this->providers_authorised;
return $result;
}
/**
* @param $user_id
* @param $encoded_pass_safe
* @param $salt_safe
*
* @return array|bool|resource
*/
function sec_password_set($user_id, $encoded_pass_safe, $salt_safe)
{
return db_user_set_by_id($user_id, "`password` = '{$encoded_pass_safe}', `salt` = '{$salt_safe}'");
}
require '../common.' . substr(strrchr(__FILE__, '.'), 1);
// if ($user['authlevel'] < 2)
if ($user['authlevel'] < 3) {
AdminMessage($lang['adm_err_denied']);
}
$mode = $_POST['mode'];
$PageTpl = gettemplate("admin/add_research", true);
$parse = $lang;
if ($mode == 'addit') {
$id = $_POST['id'];
$spy_tech = $_POST['spy_tech'];
$computer_tech = $_POST['computer_tech'];
$military_tech = $_POST['military_tech'];
$defence_tech = $_POST['defence_tech'];
$shield_tech = $_POST['shield_tech'];
$energy_tech = $_POST['energy_tech'];
$hyperspace_tech = $_POST['hyperspace_tech'];
$combustion_tech = $_POST['combustion_tech'];
$impulse_motor_tech = $_POST['impulse_motor_tech'];
$hyperspace_motor_tech = $_POST['hyperspace_motor_tech'];
$laser_tech = $_POST['laser_tech'];
$ionic_tech = $_POST['ionic_tech'];
$buster_tech = $_POST['buster_tech'];
$intergalactic_tech = $_POST['intergalactic_tech'];
$expedition_tech = $_POST['expedition_tech'];
$graviton_tech = $_POST['graviton_tech'];
db_user_set_by_id($id, "`spy_tech` = `spy_tech` + '{$spy_tech}',`computer_tech` = `computer_tech` + '{$computer_tech}',`military_tech` = `military_tech` + '{$military_tech}',\n `defence_tech` = `defence_tech` + '{$defence_tech}',`shield_tech` = `shield_tech` + '{$shield_tech}',`energy_tech` = `energy_tech` + '{$energy_tech}',\n `hyperspace_tech` = `hyperspace_tech` + '{$hyperspace_tech}',`combustion_tech` = `combustion_tech` + '{$combustion_tech}',\n `impulse_motor_tech` = `impulse_motor_tech` + '{$impulse_motor_tech}',`hyperspace_motor_tech` = `hyperspace_motor_tech` + '{$hyperspace_motor_tech}',\n `laser_tech` = `laser_tech` + '{$laser_tech}',`ionic_tech` = `ionic_tech` + '{$ionic_tech}',`buster_tech` = `buster_tech` + '{$buster_tech}',\n `intergalactic_tech` = `intergalactic_tech` + '{$intergalactic_tech}',`expedition_tech` = `expedition_tech` + '{$expedition_tech}',\n `graviton_tech` = `graviton_tech` + '{$graviton_tech}'");
AdminMessage($lang['adm_addresearch2'], $lang['adm_addresearch1']);
}
$Page = parsetemplate($PageTpl, $parse);
display($Page, $lang['adm_am_ttle'], false, '', true);
function SetSelectedPlanet(&$user)
{
$planet_row['id'] = $user['current_planet'];
// Пытаемся переключить на новую планету
if (($selected_planet = sys_get_param_id('cp')) && $selected_planet != $user['current_planet']) {
$planet_row = db_planet_by_id_and_owner($selected_planet, $user['id'], false, 'id');
} else {
$planet_row = db_planet_by_id($planet_row['id']);
}
// Если новая планета не найдена или было переключения - проверяем текущую выбранную планету
if (!isset($planet_row['id'])) {
$planet_row = db_planet_by_id_and_owner($user['current_planet'], $user['id'], false, 'id');
// Если текущей планеты не существует - выставляем Столицу
if (!isset($planet_row['id'])) {
$planet_row = db_planet_by_id_and_owner($user['id_planet'], $user['id'], false, 'id');
// Если и столицы не существует - значит что-то очень не так с записью пользователя
if (!isset($planet_row['id'])) {
global $debug;
$debug->error("User ID {$user['id']} has Capital planet {$user['id_planet']} but this planet does not exists", 'User record error', 502);
}
}
}
// Если производилось переключение планеты - делаем запись в юзере
if ($user['current_planet'] != $planet_row['id']) {
db_user_set_by_id($user['id'], "`current_planet` = '{$planet_row['id']}'");
$user['current_planet'] = $planet_row['id'];
}
return $user['current_planet'];
}
function rpg_level_up(&$user, $type, $xp_to_add = 0)
{
$q = 1.03;
switch ($type) {
case RPG_STRUCTURE:
$field_level = 'lvl_minier';
$field_xp = 'xpminier';
$b1 = 50;
$comment = 'Level Up For Structure Building';
break;
case RPG_RAID:
$field_level = 'lvl_raid';
$field_xp = 'xpraid';
$b1 = 10;
$comment = 'Level Up For Raiding';
break;
case RPG_TECH:
$field_level = 'player_rpg_tech_level';
$field_xp = 'player_rpg_tech_xp';
$b1 = 50;
$comment = 'Level Up For Research';
break;
case RPG_EXPLORE:
$field_level = 'player_rpg_explore_level';
$field_xp = 'player_rpg_explore_xp';
$b1 = 10;
$comment = 'Level Up For Exploration';
$q = 1.05;
break;
default:
break;
}
$xp =& $user[$field_xp];
if ($xp_to_add) {
$xp += $xp_to_add;
db_user_set_by_id($user['id'], "`{$field_xp}` = `{$field_xp}` + '{$xp_to_add}'");
}
$level = $user[$field_level];
while ($xp > rpg_xp_for_level($level + 1, $b1, $q)) {
$level++;
}
$level -= $user[$field_level];
if ($level > 0) {
db_user_set_by_id($user['id'], "`{$field_level}` = `{$field_level}` + '{$level}'");
rpg_points_change($user['id'], $type, $level * 1000, $comment);
$user[$field_level] += $level;
}
}
function flt_mission_explore(&$mission_data)
{
if (!isset($mission_data['fleet_event']) || $mission_data['fleet_event'] != EVENT_FLT_ACOMPLISH) {
return CACHE_NONE;
}
global $lang, $config;
static $ship_data, $rates;
$result = array('$mission_data' => $mission_data, '$outcome_list' => array(), '$mission_outcome' => FLT_EXPEDITION_OUTCOME_NONE, '$outcome_value' => 0, '$outcome_percent' => 0, '$outcome_mission_sub' => -1, '$fleet' => array(), '$fleet_lost' => array(), '$found_dark_matter' => 0, '$fleet_metal_points' => 0);
$fleet =& $result['$fleet'];
// $fleet_left = &$result['$fleet_left'];
$fleet_lost =& $result['$fleet_lost'];
$outcome_mission_sub =& $result['$outcome_mission_sub'];
$outcome_percent =& $result['$outcome_percent'];
$found_dark_matter =& $result['$found_dark_matter'];
$mission_outcome =& $result['$mission_outcome'];
$outcome_value =& $result['$outcome_value'];
$outcome_list =& $result['$outcome_list'];
$fleet_metal_points =& $result['$fleet_metal_points'];
if (!$ship_data) {
foreach (sn_get_groups('fleet') as $unit_id) {
$unit_info = get_unit_param($unit_id);
if ($unit_info[P_UNIT_TYPE] != UNIT_SHIPS || !isset($unit_info['engine'][0]['speed']) || !$unit_info['engine'][0]['speed']) {
continue;
}
$ship_data[$unit_id][P_COST_METAL] = get_unit_cost_in($unit_info[P_COST]);
}
$rates = get_resource_exchange();
}
$fleet_row = $mission_data['fleet'];
$fleet = sys_unit_str2arr($fleet_row['fleet_array']);
$fleet_capacity = 0;
$fleet_metal_points = 0;
foreach ($fleet as $ship_id => $ship_amount) {
$unit_info = get_unit_param($ship_id);
$fleet_capacity += $ship_amount * $unit_info[P_CAPACITY];
$fleet_metal_points += $ship_amount * $ship_data[$ship_id][P_COST_METAL];
}
$fleet_capacity = max(0, $fleet_capacity - $fleet_row['fleet_resource_metal'] + $fleet_row['fleet_resource_crystal'] + $fleet_row['fleet_resource_deuterium']);
$flt_stay_hours = ($fleet_row['fleet_end_stay'] - $fleet_row['fleet_start_time']) / 3600 * ($config->game_speed_expedition ? $config->game_speed_expedition : 1);
$outcome_list = sn_get_groups('mission_explore_outcome_list');
$outcome_list[FLT_EXPEDITION_OUTCOME_NONE]['chance'] = ceil(200 / pow($flt_stay_hours, 1 / 1.7));
$chance_max = 0;
foreach ($outcome_list as $key => &$value) {
if (!$value['chance']) {
unset($outcome_list[$key]);
continue;
}
$value['value'] = $chance_max = $value['chance'] + $chance_max;
}
$outcome_value = mt_rand(0, $chance_max);
// $outcome_value = 409;
$outcome_description =& $outcome_list[$mission_outcome = FLT_EXPEDITION_OUTCOME_NONE];
foreach ($outcome_list as $key => &$value) {
if (!$value['chance']) {
continue;
}
$mission_outcome = $key;
$outcome_description = $value;
if ($outcome_value <= $outcome_description['value']) {
break;
}
}
// Вычисляем вероятность выпадения данного числа в общем пуле
$msg_sender = $lang['flt_mission_expedition']['msg_sender'];
$msg_title = $lang['flt_mission_expedition']['msg_title'];
$outcome_percent = ($outcome_description['value'] - $outcome_value) / $outcome_description['chance'];
$msg_text = '';
$msg_text_addon = '';
$found_dark_matter = 0;
// $outcome_mission_sub = -1;
switch ($mission_outcome) {
// switch(FLT_EXPEDITION_OUTCOME_LOST_FLEET) { // TODO DEBUG!
case FLT_EXPEDITION_OUTCOME_LOST_FLEET:
flt_mission_explore_outcome_lost_fleet($result);
// // $fleet_left = 1 - mt_rand(1, 3) * 0.25;// * 0.25;
// $fleet_left = 1 - mt_rand(1, 3) * mt_rand(200000, 300000) / 1000000;
// $fleet_lost = array();
// foreach($fleet as $unit_id => &$unit_amount) {
// $ships_left = floor($unit_amount * $fleet_left);
// $fleet_lost[$unit_id] = $unit_amount - $ships_left;
// $unit_amount = $ships_left;
// if(!$unit_amount) {
// unset($fleet[$unit_id]);
// }
// }
break;
case FLT_EXPEDITION_OUTCOME_LOST_FLEET_ALL:
flt_mission_explore_outcome_lost_fleet_all($result);
// $fleet_lost = $fleet;
// $fleet = array();
break;
case FLT_EXPEDITION_OUTCOME_FOUND_FLEET:
$outcome_mission_sub = $outcome_percent >= 0.99 ? 0 : ($outcome_percent >= 0.9 ? 1 : 2);
$outcome_percent = $outcome_description['percent'][$outcome_mission_sub];
// Рассчитываем эквивалент найденного флота в метале
// $found_in_metal = min($outcome_percent * $fleet_metal_points, $config->resource_multiplier * 10000000); // game_speed
$found_in_metal = min($outcome_percent * $fleet_metal_points, game_resource_multiplier(true) * 10000000);
// game_speed
// 13 243 754 000 g x1
// 60 762 247 000 a x10
// 308 389 499 488 000 b x500
// Рассчитываем стоимость самого дорого корабля в металле
$max_metal_cost = 0;
foreach ($fleet as $ship_id => $ship_amount) {
$max_metal_cost = max($max_metal_cost, $ship_data[$ship_id]['metal_cost']);
}
// Ограничиваем корабли только теми, чья стоимость в металле меньше или равно стоимости самого дорогого корабля
$can_be_found = array();
foreach ($ship_data as $ship_id => $ship_info) {
if ($ship_info['metal_cost'] < $max_metal_cost) {
$can_be_found[$ship_id] = $ship_info['metal_cost'];
}
}
// Убираем колонизаторы и шпионов - миллиарды шпионов и колонизаторов нам не нужны
unset($can_be_found[SHIP_COLONIZER]);
unset($can_be_found[SHIP_SPY]);
$fleet_found = array();
while (count($can_be_found) && $found_in_metal >= max($can_be_found)) {
$found_index = mt_rand(1, count($can_be_found)) - 1;
$found_ship = array_slice($can_be_found, $found_index, 1, true);
$found_ship_cost = reset($found_ship);
$found_ship_id = key($found_ship);
if ($found_ship_cost > $found_in_metal) {
unset($can_be_found[$found_ship_id]);
} else {
$found_ship_count = mt_rand(1, floor($found_in_metal / $found_ship_cost));
$fleet_found[$found_ship_id] += $found_ship_count;
$found_in_metal -= $found_ship_count * $found_ship_cost;
}
}
if (empty($fleet_found)) {
$msg_text_addon = $lang['flt_mission_expedition']['outcomes'][$mission_outcome]['no_result'];
} else {
foreach ($fleet_found as $unit_id => $unit_amount) {
$fleet[$unit_id] += $unit_amount;
}
}
break;
case FLT_EXPEDITION_OUTCOME_FOUND_RESOURCES:
$outcome_mission_sub = $outcome_percent >= 0.99 ? 0 : ($outcome_percent >= 0.9 ? 1 : 2);
$outcome_percent = $outcome_description['percent'][$outcome_mission_sub];
// Рассчитываем количество найденных ресурсов
$found_in_metal = ceil(min($outcome_percent * $fleet_metal_points, game_resource_multiplier(true) * 10000000, $fleet_capacity) * mt_rand(950000, 1050000) / 1000000);
// game_speed
$resources_found[RES_METAL] = floor(mt_rand(300000, 700000) / 1000000 * $found_in_metal);
$found_in_metal -= $resources_found[RES_METAL];
$found_in_metal = floor($found_in_metal * $rates[RES_METAL] / $rates[RES_CRYSTAL]);
$resources_found[RES_CRYSTAL] = floor(mt_rand(500000, 1000000) / 1000000 * $found_in_metal);
$found_in_metal -= $resources_found[RES_CRYSTAL];
$found_in_metal = floor($found_in_metal * $rates[RES_CRYSTAL] / $rates[RES_DEUTERIUM]);
$resources_found[RES_DEUTERIUM] = $found_in_metal;
$fleet_row['fleet_resource_metal'] += $resources_found[RES_METAL];
$fleet_row['fleet_resource_crystal'] += $resources_found[RES_CRYSTAL];
$fleet_row['fleet_resource_deuterium'] += $resources_found[RES_DEUTERIUM];
if (array_sum($resources_found) == 0) {
$msg_text_addon = $lang['flt_mission_expedition']['outcomes'][$mission_outcome]['no_result'];
}
break;
case FLT_EXPEDITION_OUTCOME_FOUND_DM:
$outcome_mission_sub = $outcome_percent >= 0.99 ? 0 : ($outcome_percent >= 0.9 ? 1 : 2);
$outcome_percent = $outcome_description['percent'][$outcome_mission_sub];
// Рассчитываем количество найденной ТМ
$found_dark_matter = floor(min($outcome_percent * $fleet_metal_points / $rates[RES_DARK_MATTER], 10000) * mt_rand(750000, 1000000) / 1000000);
if (!$found_dark_matter) {
$msg_text_addon = $lang['flt_mission_expedition']['outcomes'][$mission_outcome]['no_result'];
}
break;
case FLT_EXPEDITION_OUTCOME_FOUND_ARTIFACT:
break;
default:
break;
}
flt_mission_explore_addon($result);
$query_data = array();
if ($found_dark_matter) {
rpg_points_change($fleet_row['fleet_owner'], RPG_EXPEDITION, $found_dark_matter, 'Expedition Bonus');
$msg_text_addon = sprintf($lang['flt_mission_expedition']['found_dark_matter'], $found_dark_matter);
}
if (!empty($fleet_lost)) {
$msg_text_addon = $lang['flt_mission_expedition']['lost_fleet'];
foreach ($fleet_lost as $ship_id => $ship_amount) {
$msg_text_addon .= $lang['tech'][$ship_id] . ' - ' . $ship_amount . "\r\n";
}
}
$fleet_row['fleet_amount'] = array_sum($fleet);
if (!empty($fleet) && $fleet_row['fleet_amount']) {
if (!empty($fleet_found)) {
$msg_text_addon = $lang['flt_mission_expedition']['found_fleet'];
foreach ($fleet_found as $ship_id => $ship_amount) {
$msg_text_addon .= $lang['tech'][$ship_id] . ' - ' . $ship_amount . "\r\n";
}
}
if (!empty($resources_found) && array_sum($resources_found) > 0) {
$msg_text_addon = $lang['flt_mission_expedition']['found_resources'];
foreach ($resources_found as $ship_id => $ship_amount) {
$msg_text_addon .= $lang['tech'][$ship_id] . ' - ' . $ship_amount . "\r\n";
}
$query_data[] = "`fleet_resource_metal` = `fleet_resource_metal` + {$resources_found[RES_METAL]}";
$query_data[] = "`fleet_resource_crystal` = `fleet_resource_crystal` + {$resources_found[RES_CRYSTAL]}";
$query_data[] = "`fleet_resource_deuterium` = `fleet_resource_deuterium` + {$resources_found[RES_DEUTERIUM]}";
}
if (!empty($fleet_lost) || !empty($fleet_found)) {
$fleet_row['fleet_array'] = sys_unit_arr2str($fleet);
$query_data[] = "`fleet_amount` = {$fleet_row['fleet_amount']}";
$query_data[] = "`fleet_array` = '{$fleet_row['fleet_array']}'";
}
$query_data[] = '`fleet_mess` = 1';
$query_data = "UPDATE {{fleets}} SET " . implode(',', $query_data);
} else {
// Удалить флот
$query_data = "DELETE FROM {{fleets}}";
}
$query_data .= " WHERE `fleet_id` = {$fleet_row['fleet_id']} LIMIT 1";
doquery($query_data);
db_user_set_by_id($fleet_row['fleet_owner'], "`player_rpg_explore_xp` = `player_rpg_explore_xp` + 1");
if (!$msg_text) {
$messages =& $lang['flt_mission_expedition']['outcomes'][$mission_outcome]['messages'];
if ($outcome_mission_sub >= 0 && is_array($messages)) {
$messages =& $messages[$outcome_mission_sub];
}
$msg_text = is_string($messages) ? $messages : (is_array($messages) ? $messages[mt_rand(0, count($messages) - 1)] : '');
}
$msg_text = sprintf($msg_text, $fleet_row['fleet_id'], uni_render_coordinates($fleet_row, 'fleet_end_')) . ($msg_text_addon ? "\r\n" . $msg_text_addon : '');
msg_send_simple_message($fleet_row['fleet_owner'], '', $fleet_row['fleet_end_stay'], MSG_TYPE_EXPLORE, $msg_sender, $msg_title, $msg_text);
return CACHE_FLEET | CACHE_USER_SRC;
}
