if ($_POST['errors'] == 'on') { doquery("TRUNCATE TABLE {{table}}", 'errors'); $Log .= $lang['log_errors'] . "\n"; } if ($_POST['banneds'] == 'on') { doquery("TRUNCATE TABLE {{table}}", 'banned'); doquery("UPDATE {{table}} SET `bana` = '0', `banaday` = '0' WHERE `id` > '1'", "users"); $Log .= $lang['log_banneds'] . "\n"; } if ($_POST['messages'] == 'on') { doquery("TRUNCATE TABLE {{table}}", 'messages'); doquery("UPDATE {{table}} SET `new_message` = '0'", "users"); $Log .= $lang['log_messages'] . "\n"; } if ($_POST['statpoints'] == 'on') { doquery("TRUNCATE TABLE {{table}}", 'statpoints'); $Log .= $lang['log_statpoints'] . "\n"; } if ($_POST['moons'] == 'on') { doquery("DELETE FROM {{table}} WHERE `planet_type` = '3'", 'planets'); doquery("UPDATE {{table}} SET `id_luna` = '0'", 'galaxy'); $Log .= $lang['log_moons'] . "\n"; } } else { ResetUniverse($user); $Log .= $lang['log_all_uni'] . "\n"; } LogFunction($Log, "ResetLog", $LogCanWork); $parse['good'] = '<tr><th colspan="2"><center><font color=lime>' . $lang['re_reset_excess'] . '</font></center></th></tr>'; } display(parsetemplate(gettemplate('adm/ResetBody'), $parse), false, '', true, false);
function ShowResetPage() { global $db, $LNG, $reslist, $resource; $template = new template(); $template->page_header(); if ($_POST) { if ($_POST['resetall'] == 'on') { ResetUniverse(); $template->message($LNG['re_reset_excess'], '?page=reset&sid=' . session_id(), 3); exit; } foreach ($reslist['build'] as $ID) { $dbcol['build'][$ID] = "`" . $resource[$ID] . "` = '0'"; } foreach ($reslist['tech'] as $ID) { $dbcol['tech'][$ID] = "`" . $resource[$ID] . "` = '0'"; } foreach ($reslist['fleet'] as $ID) { $dbcol['fleet'][$ID] = "`" . $resource[$ID] . "` = '0'"; } foreach ($reslist['defense'] as $ID) { $dbcol['defense'][$ID] = "`" . $resource[$ID] . "` = '0'"; } foreach ($reslist['officier'] as $ID) { $dbcol['officier'][$ID] = "`" . $resource[$ID] . "` = '0'"; } // HANGARES Y DEFENSAS if ($_POST['defenses'] == 'on') { $db->query("UPDATE " . PLANETS . " SET " . implode(", ", $dbcol['defense']) . ";"); } if ($_POST['ships'] == 'on') { $db->query("UPDATE " . PLANETS . " SET " . implode(", ", $dbcol['fleet']) . ";"); } if ($_POST['h_d'] == 'on') { $db->query("UPDATE " . PLANETS . " SET `b_hangar` = '0', `b_hangar_plus` = '0', `b_hangar_id` = ''"); } // EDIFICIOS if ($_POST['edif_p'] == 'on') { $db->query("UPDATE " . PLANETS . " SET " . implode(", ", $dbcol['build']) . " WHERE `planet_type` = '1';"); } if ($_POST['edif_l'] == 'on') { $db->query("UPDATE " . PLANETS . " SET " . implode(", ", $dbcol['build']) . " WHERE `planet_type` = '3';"); } if ($_POST['edif'] == 'on') { $db->query("UPDATE " . PLANETS . " SET `b_building` = '0', `b_building_id` = '';"); } // INVESTIGACIONES Y OFICIALES if ($_POST['inves'] == 'on') { $db->query("UPDATE " . USERS . " SET " . implode(", ", $dbcol['tech']) . ";"); } if ($_POST['ofis'] == 'on') { $db->query("UPDATE " . USERS . " SET " . implode(", ", $dbcol['officier']) . ";"); } if ($_POST['inves_c'] == 'on') { $db->query("UPDATE " . USERS . " SET `b_tech_planet` = '0', `b_tech` = '0', `b_tech_id` = '0';"); } // RECURSOS if ($_POST['dark'] == 'on') { $db->query("UPDATE " . USERS . " SET `darkmatter` = '0';"); } if ($_POST['resources'] == 'on') { $db->query("UPDATE " . PLANETS . " SET `metal` = '0', `crystal` = '0', `deuterium` = '0';"); } // GENERAL if ($_POST['notes'] == 'on') { $db->query("TRUNCATE TABLE " . NOTES . ";"); } if ($_POST['rw'] == 'on') { $TKBRW = $db->query("SELECT `rid` FROM " . TOPKB . ";"); if (isset($TKBRW)) { while ($RID = $db->fetch_array($TKBRW)) { @unlink(ROOT_PATH . 'raports/topkb_' . $RID['rid'] . '.php'); } $db->query("TRUNCATE TABLE " . RW . ";"); } } if ($_POST['friends'] == 'on') { $db->query("TRUNCATE TABLE " . BUDDY . ";"); } if ($_POST['alliances'] == 'on') { $db->query("TRUNCATE TABLE " . ALLIANCE . ";"); $db->query("UPDATE " . USERS . " SET `ally_id` = '0', `ally_name` = '', `ally_request` = '0', `ally_request_text` = 'NULL', `ally_register_time` = '0', `ally_rank_id` = '0';"); } if ($_POST['fleets'] == 'on') { $db->query("TRUNCATE TABLE " . FLEETS . ";"); } if ($_POST['errors'] == 'on') { $db->query("TRUNCATE TABLE " . ERRORS . ";"); } if ($_POST['banneds'] == 'on') { $db->query("TRUNCATE TABLE " . BANNED . ";"); $db->query("UPDATE " . USERS . " SET `bana` = '0', `banaday` = '0';"); } if ($_POST['messages'] == 'on') { $db->query("TRUNCATE TABLE " . MESSAGES . ";"); $db->query("UPDATE " . USERS . " SET `new_message` = '0';"); } if ($_POST['statpoints'] == 'on') { $db->query("TRUNCATE TABLE " . STATPOINTS . ";"); } if ($_POST['moons'] == 'on') { $db->query("DELETE FROM " . PLANETS . " WHERE `planet_type` = '3';"); $db->query("UPDATE " . PLANETS . " SET `id_luna` = '0';"); } $template->message($LNG['re_reset_excess'], '?page=reset&sid=' . session_id(), 3); exit; } $template->assign_vars(array('button_submit' => $LNG['button_submit'], 're_reset_all' => $LNG['re_reset_all'], 're_defenses_and_ships' => $LNG['re_defenses_and_ships'], 're_reset_buldings' => $LNG['re_reset_buldings'], 're_buildings_lu' => $LNG['re_buildings_lu'], 're_buildings_pl' => $LNG['re_buildings_pl'], 're_buldings' => $LNG['re_buldings'], 're_reset_hangar' => $LNG['re_reset_hangar'], 're_ships' => $LNG['re_ships'], 're_defenses' => $LNG['re_defenses'], 're_resources_met_cry' => $LNG['re_resources_met_cry'], 're_resources_dark' => $LNG['re_resources_dark'], 're_resources' => $LNG['re_resources'], 're_reset_invest' => $LNG['re_reset_invest'], 're_investigations' => $LNG['re_investigations'], 're_ofici' => $LNG['re_ofici'], 're_inve_ofis' => $LNG['re_inve_ofis'], 're_reset_statpoints' => $LNG['re_reset_statpoints'], 're_reset_messages' => $LNG['re_reset_messages'], 're_reset_banned' => $LNG['re_reset_banned'], 're_reset_errors' => $LNG['re_reset_errors'], 're_reset_fleets' => $LNG['re_reset_fleets'], 're_reset_allys' => $LNG['re_reset_allys'], 're_reset_buddies' => $LNG['re_reset_buddies'], 're_reset_rw' => $LNG['re_reset_rw'], 're_reset_notes' => $LNG['re_reset_notes'], 're_reset_moons' => $LNG['re_reset_moons'], 're_general' => $LNG['re_general'])); $template->show('adm/ResetPage.tpl'); }