function sn_sn_powerup_get_price_matrix($powerup_id, $powerup_unit = false, $level_max = null, $plain = false, &$result) { global $sn_powerup_buy_discounts; $result = array(); $powerup_data = get_unit_param($powerup_id); //pdump($powerup_data, '$powerup_data'); $is_upgrade = !empty($powerup_unit) && $powerup_unit; // pdump($powerup_unit, '$powerup_unit'); $level_current = $term_original = $time_left = 0; if ($is_upgrade) { $time_finish = strtotime($powerup_unit['unit_time_finish']); $time_left = max(0, $time_finish - SN_TIME_NOW); if ($time_left > 0) { $term_original = $time_finish - strtotime($powerup_unit['unit_time_start']); $level_current = $powerup_unit['unit_level']; } } $level_max = $level_max > $powerup_data[P_MAX_STACK] ? $level_max : $powerup_data[P_MAX_STACK]; $original_cost = 0; for ($i = 1; $i <= $level_max; $i++) { $base_cost = eco_get_total_cost($powerup_id, $i); $base_cost = $base_cost[BUILD_CREATE][RES_DARK_MATTER]; foreach ($sn_powerup_buy_discounts as $period => $discount) { $upgrade_price = floor($base_cost * $discount * $period / PERIOD_MONTH); $result[$i][$period] = $upgrade_price; $original_cost = $is_upgrade && $i == $level_current && $period <= $term_original ? $upgrade_price : $original_cost; } } if ($is_upgrade && $time_left) { $term_original = round($term_original / PERIOD_DAY); $time_left = min(floor($time_left / PERIOD_DAY), $term_original); $cost_left = $term_original > 0 ? ceil($time_left / $term_original * $original_cost) : 0; array_walk_recursive($result, function (&$value) use($cost_left) { $value -= $cost_left; }); } return $result; }
function sys_stat_calculate() { global $config, $sta_update_step; ini_set('memory_limit', $config->stats_php_memory ? $config->stats_php_memory : '1024M'); $user_skip_list = sys_stat_get_user_skip_list(); // $sn_groups_resources_loot = sn_get_groups('resources_loot'); $rate[RES_METAL] = $config->rpg_exchange_metal; $rate[RES_CRYSTAL] = $config->rpg_exchange_crystal / $config->rpg_exchange_metal; $rate[RES_DEUTERIUM] = $config->rpg_exchange_deuterium / $config->rpg_exchange_metal; $rate[RES_DARK_MATTER] = $config->rpg_exchange_darkMatter / $config->rpg_exchange_metal; $sta_update_step = -1; sta_set_time_limit('starting update'); $counts = $points = $unit_cost_cache = $user_allies = array(); sn_db_transaction_start(); sta_set_time_limit('calculating players stats'); $i = 0; // Блокируем всех пользователей classSupernova::db_lock_tables('users'); $user_list = db_user_list('', true, 'id, dark_matter, metal, crystal, deuterium, user_as_ally, ally_id'); $row_num = count($user_list); // while($player = db_fetch($query)) foreach ($user_list as $player) { if ($i++ % 100 == 0) { sta_set_time_limit("calculating players stats (player {$i}/{$row_num})", false); } if (array_key_exists($user_id = $player['id'], $user_skip_list)) { continue; } $resources = $player['metal'] * $rate[RES_METAL] + $player['crystal'] * $rate[RES_CRYSTAL] + $player['deuterium'] * $rate[RES_DEUTERIUM] + $player['dark_matter'] * $rate[RES_DARK_MATTER]; $counts[$user_id][UNIT_RESOURCES] += $resources; // $points[$user_id][UNIT_RESOURCES] += $resources; // А здесь мы фильтруем пользователей по $user_skip_list - далее не нужно этого делать, потому что if (!isset($user_skip_list[$user_id])) { $user_allies[$user_id] = $player['ally_id']; } } unset($user_list); classSupernova::cache_clear(LOC_USER, true); //pdump(classSupernova::$data[LOC_USER]); //pdump(classSupernova::$locks[LOC_USER]); sta_set_time_limit('calculating planets stats'); $i = 0; $query = db_planet_list_resources_by_owner(); $row_num = db_num_rows($query); while ($planet = db_fetch($query)) { if ($i++ % 100 == 0) { sta_set_time_limit("calculating planets stats (planet {$i}/{$row_num})", false); } if (array_key_exists($user_id = $planet['id_owner'], $user_skip_list)) { continue; } $resources = $planet['metal'] * $rate[RES_METAL] + $planet['crystal'] * $rate[RES_CRYSTAL] + $planet['deuterium'] * $rate[RES_DEUTERIUM]; $counts[$user_id][UNIT_RESOURCES] += $resources; // $points[$user_id][UNIT_RESOURCES] += $resources; } // Calculation of Fleet-In-Flight sta_set_time_limit('calculating flying fleets stats'); $i = 0; $query = doquery("SELECT fleet_owner, fleet_array, fleet_resource_metal, fleet_resource_crystal, fleet_resource_deuterium FROM {{fleets}};"); $row_num = db_num_rows($query); while ($fleet_row = db_fetch($query)) { if ($i++ % 100 == 0) { sta_set_time_limit("calculating flying fleets stats (fleet {$i}/{$row_num})", false); } if (array_key_exists($user_id = $fleet_row['fleet_owner'], $user_skip_list)) { continue; } $fleet = sys_unit_str2arr($fleet_row['fleet_array']); foreach ($fleet as $unit_id => $unit_amount) { $counts[$user_id][UNIT_SHIPS] += $unit_amount; if (!isset($unit_cost_cache[$unit_id][0])) { $unit_cost_cache[$unit_id][0] = get_unit_param($unit_id, P_COST); } $unit_cost_data =& $unit_cost_cache[$unit_id][0]; $points[$user_id][UNIT_SHIPS] += ($unit_cost_data[RES_METAL] * $rate[RES_METAL] + $unit_cost_data[RES_CRYSTAL] * $rate[RES_CRYSTAL] + $unit_cost_data[RES_DEUTERIUM] * $rate[RES_DEUTERIUM]) * $unit_amount; } $resources = $fleet_row['fleet_resource_metal'] * $rate[RES_METAL] + $fleet_row['fleet_resource_crystal'] * $rate[RES_CRYSTAL] + $fleet_row['fleet_resource_deuterium'] * $rate[RES_DEUTERIUM]; $counts[$user_id][UNIT_RESOURCES] += $resources; // $points[$user_id][UNIT_RESOURCES] += $resources; } sta_set_time_limit('calculating unit stats'); $i = 0; $query = db_unit_list_stat_calculate(); $row_num = db_num_rows($query); while ($unit = db_fetch($query)) { if ($i++ % 100 == 0) { sta_set_time_limit("calculating unit stats (unit {$i}/{$row_num})", false); } if (array_key_exists($user_id = $unit['unit_player_id'], $user_skip_list)) { continue; } $counts[$user_id][$unit['unit_type']] += $unit['unit_level'] * $unit['unit_amount']; $total_cost = eco_get_total_cost($unit['unit_snid'], $unit['unit_level']); $points[$user_id][$unit['unit_type']] += (isset($total_cost['total']) ? $total_cost['total'] : 0) * $unit['unit_amount']; } sta_set_time_limit('calculating ques stats'); $i = 0; $query = db_que_list_stat(); $row_num = db_num_rows($query); while ($que_item = db_fetch($query)) { if ($i++ % 100 == 0) { sta_set_time_limit("calculating ques stats (que item {$i}/{$row_num})", false); } if (array_key_exists($user_id = $que_item['que_player_id'], $user_skip_list)) { continue; } $que_unit_amount = $que_item['que_unit_amount']; $que_item = sys_unit_str2arr($que_item['que_unit_price']); $resources = ($que_item[RES_METAL] * $rate[RES_METAL] + $que_item[RES_CRYSTAL] * $rate[RES_CRYSTAL] + $que_item[RES_DEUTERIUM] * $rate[RES_DEUTERIUM]) * $que_unit_amount; $counts[$user_id][UNIT_RESOURCES] += $resources; // $points[$user_id][UNIT_RESOURCES] += $resources; } sta_set_time_limit('archiving old statistic'); // Statistic rotation // doquery("DELETE FROM {{statpoints}} WHERE `stat_code` >= 14;"); doquery("DELETE FROM {{statpoints}} WHERE `stat_date` < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL {$config->stats_history_days} DAY));"); doquery("UPDATE {{statpoints}} SET `stat_code` = `stat_code` + 1;"); sta_set_time_limit('posting new user stats to DB'); $data = array(); foreach ($user_allies as $user_id => $ally_id) { // $counts[UNIT_RESOURCES] дублирует $points[UNIT_RESOURCES], поэтому $points не заполняем, а берем $counts и делим на 1000 $points[$user_id][UNIT_RESOURCES] = $counts[$user_id][UNIT_RESOURCES] / 1000; $points[$user_id] = array_map('floor', $points[$user_id]); $counts[$user_id] = array_map('floor', $counts[$user_id]); $ally_id = $ally_id ? $ally_id : 'NULL'; $user_defence_points = $points[$user_id][UNIT_DEFENCE] + $points[$user_id][UNIT_DEF_MISSILES]; $user_defence_counts = $counts[$user_id][UNIT_DEFENCE] + $counts[$user_id][UNIT_DEF_MISSILES]; $user_points = array_sum($points[$user_id]); $user_counts = array_sum($counts[$user_id]); $data[] = $q = "({$user_id},{$ally_id},1,1,'{$points[$user_id][UNIT_TECHNOLOGIES]}','{$counts[$user_id][UNIT_TECHNOLOGIES]}'," . "'{$points[$user_id][UNIT_STRUCTURES]}','{$counts[$user_id][UNIT_STRUCTURES]}','{$user_defence_points}','{$user_defence_counts}'," . "'{$points[$user_id][UNIT_SHIPS]}','{$counts[$user_id][UNIT_SHIPS]}','{$points[$user_id][UNIT_RESOURCES]}','{$counts[$user_id][UNIT_RESOURCES]}'," . "{$user_points},{$user_counts}," . SN_TIME_NOW . ")"; sys_stat_calculate_flush($data); } sys_stat_calculate_flush($data, true); // Updating Allie's stats sta_set_time_limit('posting new Alliance stats to DB'); doquery("INSERT INTO {{statpoints}}\n (`tech_points`, `tech_count`, `build_points`, `build_count`, `defs_points`, `defs_count`,\n `fleet_points`, `fleet_count`, `res_points`, `res_count`, `total_points`, `total_count`,\n `stat_date`, `id_owner`, `id_ally`, `stat_type`, `stat_code`,\n `tech_old_rank`, `build_old_rank`, `defs_old_rank`, `fleet_old_rank`, `res_old_rank`, `total_old_rank`\n )\n SELECT\n SUM(u.`tech_points`)+aus.`tech_points`, SUM(u.`tech_count`)+aus.`tech_count`, SUM(u.`build_points`)+aus.`build_points`, SUM(u.`build_count`)+aus.`build_count`,\n SUM(u.`defs_points`)+aus.`defs_points`, SUM(u.`defs_count`)+aus.`defs_count`, SUM(u.`fleet_points`)+aus.`fleet_points`, SUM(u.`fleet_count`)+aus.`fleet_count`,\n SUM(u.`res_points`)+aus.`res_points`, SUM(u.`res_count`)+aus.`res_count`, SUM(u.`total_points`)+aus.`total_points`, SUM(u.`total_count`)+aus.`total_count`,\n " . SN_TIME_NOW . ", NULL, u.`id_ally`, 2, 1,\n a.tech_rank, a.build_rank, a.defs_rank, a.fleet_rank, a.res_rank, a.total_rank\n FROM {{statpoints}} as u\n join {{alliance}} as al on al.id = u.id_ally\n left join {{statpoints}} as aus on aus.id_owner = al.ally_user_id and aus.stat_type = 1 AND aus.stat_code = 1\n LEFT JOIN {{statpoints}} as a ON a.id_ally = u.id_ally AND a.stat_code = 2 AND a.stat_type = 2\n WHERE u.`stat_type` = 1 AND u.stat_code = 1 AND u.id_ally<>0\n GROUP BY u.`id_ally`"); // Удаляем больше не нужные записи о достижении игрока-альянса db_stat_list_delete_ally_player(); // Some variables we need to update ranks $qryResetRowNum = 'SET @rownum=0;'; $qryFormat = 'UPDATE {{statpoints}} SET `%1$s_rank` = (SELECT @rownum:=@rownum+1) WHERE `stat_type` = %2$d AND `stat_code` = 1 ORDER BY `%1$s_points` DESC, `id_owner` ASC, `id_ally` ASC;'; $rankNames = array('tech', 'build', 'defs', 'fleet', 'res', 'total'); // Updating player's ranks sta_set_time_limit("updating ranks for players"); foreach ($rankNames as $rankName) { sta_set_time_limit("updating player rank '{$rankName}'", false); doquery($qryResetRowNum); doquery(sprintf($qryFormat, $rankName, 1)); } sta_set_time_limit("updating ranks for Alliances"); // --- Updating Allie's ranks foreach ($rankNames as $rankName) { sta_set_time_limit("updating Alliances rank '{$rankName}'", false); doquery($qryResetRowNum); doquery(sprintf($qryFormat, $rankName, 2)); } sta_set_time_limit('setting previous user stats from archive'); doquery("UPDATE {{statpoints}} as new\n LEFT JOIN {{statpoints}} as old ON old.id_owner = new.id_owner AND old.stat_code = 2 AND old.stat_type = new.stat_type\n SET\n new.tech_old_rank = old.tech_rank,\n new.build_old_rank = old.build_rank,\n new.defs_old_rank = old.defs_rank ,\n new.fleet_old_rank = old.fleet_rank,\n new.res_old_rank = old.res_rank,\n new.total_old_rank = old.total_rank\n WHERE\n new.stat_type = 1 AND new.stat_code = 1;"); sta_set_time_limit('setting previous allies stats from archive'); doquery("UPDATE {{statpoints}} as new\n LEFT JOIN {{statpoints}} as old ON old.id_ally = new.id_ally AND old.stat_code = 2 AND old.stat_type = new.stat_type\n SET\n new.tech_old_rank = old.tech_rank,\n new.build_old_rank = old.build_rank,\n new.defs_old_rank = old.defs_rank ,\n new.fleet_old_rank = old.fleet_rank,\n new.res_old_rank = old.res_rank,\n new.total_old_rank = old.total_rank\n WHERE\n new.stat_type = 2 AND new.stat_code = 1;"); sta_set_time_limit('updating players current rank and points'); db_stat_list_update_user_stats(); sta_set_time_limit('updating Allys current rank and points'); db_stat_list_update_ally_stats(); // Counting real user count and updating values $config->db_saveItem('users_amount', db_user_count()); sn_db_transaction_commit(); }
function mrc_mercenary_render($user) { global $config, $lang, $sn_powerup_buy_discounts; $mode = sys_get_param_int('mode', UNIT_MERCENARIES); $mode = in_array($mode, array(UNIT_MERCENARIES, UNIT_PLANS)) ? $mode : UNIT_MERCENARIES; $is_permanent = $mode == UNIT_PLANS || !$config->empire_mercenary_temporary; if ($mercenary_id = sys_get_param_int('mercenary_id')) { $operation_result = mrc_mercenary_hire($mode, $user, $mercenary_id); } lng_include('infos'); $template = gettemplate('mrc_mercenary_hire', true); if (!empty($operation_result)) { $template->assign_block_vars('result', $operation_result); } foreach ($sn_powerup_buy_discounts as $hire_period => $hire_discount) { $template->assign_block_vars('period', array('LENGTH' => $hire_period, 'TEXT' => $lang['mrc_period_list'][$hire_period], 'DISCOUNT' => $hire_period / $config->empire_mercenary_base_period * $hire_discount, 'SELECTED' => $hire_period == $config->empire_mercenary_base_period)); } $user_dark_matter = mrc_get_level($user, '', RES_DARK_MATTER); $cost_alliance_multiplyer = SN_IN_ALLY === true && $mode == UNIT_PLANS ? $config->ali_bonus_members : 1; $cost_alliance_multiplyer = $cost_alliance_multiplyer >= 1 ? $cost_alliance_multiplyer : 1; foreach (sn_get_groups($mode == UNIT_PLANS ? 'plans' : 'mercenaries') as $mercenary_id) { $mercenary = get_unit_param($mercenary_id); $mercenary_bonus = $mercenary['bonus']; $mercenary_bonus = $mercenary_bonus >= 0 ? "+{$mercenary_bonus}" : "{$mercenary_bonus}"; switch ($mercenary['bonus_type']) { case BONUS_PERCENT: $mercenary_bonus = "{$mercenary_bonus}% "; break; case BONUS_ABILITY: $mercenary_bonus = ''; break; case BONUS_ADD: default: break; } $mercenary_level = mrc_get_level($user, null, $mercenary_id, false, true); $mercenary_level_bonus = max(0, mrc_get_level($user, null, $mercenary_id) - $mercenary_level); $total_cost_old = 0; if ($is_permanent) { $total_cost_old = eco_get_total_cost($mercenary_id, $mercenary_level); $total_cost_old = $total_cost_old[BUILD_CREATE][RES_DARK_MATTER] * $cost_alliance_multiplyer; } $total_cost = eco_get_total_cost($mercenary_id, $mercenary_level + 1); $total_cost[BUILD_CREATE][RES_DARK_MATTER] *= $cost_alliance_multiplyer; $mercenary_unit = classSupernova::db_get_unit_by_location($user['id'], LOC_USER, $user['id'], $mercenary_id); $mercenary_time_finish = strtotime($mercenary_unit['unit_time_finish']); $template->assign_block_vars('officer', array('ID' => $mercenary_id, 'NAME' => $lang['tech'][$mercenary_id], 'DESCRIPTION' => $lang['info'][$mercenary_id]['description'], 'EFFECT' => $lang['info'][$mercenary_id]['effect'], 'COST' => $total_cost[BUILD_CREATE][RES_DARK_MATTER] - $total_cost_old, 'COST_TEXT' => pretty_number($total_cost[BUILD_CREATE][RES_DARK_MATTER] - $total_cost_old, 0, $user_dark_matter), 'LEVEL' => $mercenary_level, 'LEVEL_BONUS' => $mercenary_level_bonus, 'LEVEL_MAX' => $mercenary['max'], 'BONUS' => $mercenary_bonus, 'BONUS_TYPE' => $mercenary['bonus_type'], 'HIRE_END' => $mercenary_time_finish && $mercenary_time_finish >= SN_TIME_NOW ? date(FMT_DATE_TIME, $mercenary_time_finish) : '', 'CAN_BUY' => mrc_officer_accessible($user, $mercenary_id))); $upgrade_cost = 1; for ($i = $config->empire_mercenary_temporary ? 1 : $mercenary_level + 1; $mercenary['max'] ? $i <= $mercenary['max'] : $upgrade_cost <= $user_dark_matter; $i++) { $total_cost = eco_get_total_cost($mercenary_id, $i); $total_cost[BUILD_CREATE][RES_DARK_MATTER] *= $cost_alliance_multiplyer; $upgrade_cost = $total_cost[BUILD_CREATE][RES_DARK_MATTER] - $total_cost_old; $template->assign_block_vars('officer.level', array('VALUE' => $i, 'PRICE' => $upgrade_cost)); } } $template->assign_vars(array('PAGE_HEADER' => $lang['tech'][$mode], 'MODE' => $mode, 'IS_PERMANENT' => intval($is_permanent), 'EMPIRE_MERCENARY_TEMPORARY' => $config->empire_mercenary_temporary, 'DARK_MATTER' => $user_dark_matter)); display(parsetemplate($template), $lang['tech'][$mode]); }