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');
}
