'; if (isset($_POST['planets'])) { // delete planets > 15 and = 0 echo '\n"; } if (isset($_POST['galaxies']) && isset($_POST['galaxies_p1'])) { // delete galaxies > x $parameter = intval($_POST['galaxies_p1']); if ($parameter < 0) $parameter = 0; echo '\n"; } if (isset($_POST['players'])) { // delete players without playerid echo '\n"; } if (isset($_POST['reports'])) { // delete reports who have no planet echo '\n"; } if (isset($_POST['reset'])) { // Reset Galaxytool echo '\n"; } if (isset($_POST['old_players']) && isset($_POST['old_players_p1'])) { // delete player entries older than x days $parameter = intval($_POST['old_players_p1']); if ($parameter < 0) $parameter = 0; echo '\n"; } if (isset($_POST['unused_players'])) { // delete players which are not used in any galaxy view echo '\n"; } if (isset($_POST['old_reports']) && isset($_POST['old_reports_p1'])) { // delete reports older than x days $parameter = intval($_POST['old_reports_p1']); if ($parameter < 0) $parameter = 0; echo '\n"; } if (isset($_POST['old_galaxies']) && isset($_POST['old_galaxies_p1'])) { // delete galaxyviews older than x days $parameter = intval($_POST['old_galaxies_p1']); if ($parameter < 0) $parameter = 0; echo '\n"; } echo "
'.ADMIN_STATUS.'
'.ADMIN_PLANETS." : \n"; $query = "DELETE FROM $dbtablename WHERE planet = 0 OR planet > 15"; $res = mysql_query($query) or die(mysql_error()); $results = mysql_affected_rows(); if ($results > 0) { echo "".ADMIN_DONE." ($results)"; } else { echo "".ADMIN_NOTBD.""; } echo "
'.str_replace("&1",$parameter,ADMIN_GALAXIES)." : \n"; $query = "DELETE FROM $dbtablename WHERE galaxy = 0 OR galaxy > $parameter"; $res = mysql_query($query) or die(mysql_error()); $results = mysql_affected_rows(); if ($results > 0) { echo "".ADMIN_DONE." ($results)"; } else { echo "".ADMIN_NOTBD.""; } echo "
'.ADMIN_PLAYERS." : \n"; $query = "DELETE FROM $playertable WHERE ogame_playerid IS NULL or ogame_playerid=0"; // = 0 was a bug in a previous version $res = mysql_query($query) or die(mysql_error()); $results = mysql_affected_rows(); if ($results > 0) { echo "".ADMIN_DONE." ($results)"; } else { echo "".ADMIN_NOTBD.""; } echo "
'.str_replace("&1",$parameter,ADMIN_REPORTS)." : \n"; $query = "select r.id FROM $reporttable r LEFT JOIN $dbtablename g ON (r.galaxy = g.galaxy AND r.system = g.system AND r.planet = g.planet AND r.moon = g.moon) WHERE g.player_id = 0"; $res = mysql_query($query) or die(mysql_error()); $ids = array(); while ($line = mysql_fetch_object($res)) { array_push($ids,$line->id); } if (count($ids) > 1) { $query = "DELETE FROM $reporttable WHERE id IN (".implode(",",$ids).")"; mysql_query($query) or die(mysql_error()); $results = mysql_affected_rows(); } else { $results = 0; } if ($results > 0) { echo "".ADMIN_DONE." ($results)"; } else { echo "".ADMIN_NOTBD.""; } echo "
'.ADMIN_RESET." : \n"; $query = "TRUNCATE $dbtablename"; mysql_query($query) or die(mysql_error()); $query = "TRUNCATE $playertable"; mysql_query($query) or die(mysql_error()); $query = "TRUNCATE $allytable"; mysql_query($query) or die(mysql_error()); $query = "TRUNCATE $noticetable"; mysql_query($query) or die(mysql_error()); $query = "TRUNCATE $reporttable"; mysql_query($query) or die(mysql_error()); $query = "TRUNCATE $shouttable"; mysql_query($query) or die(mysql_error()); $query = "TRUNCATE $allyhistory"; mysql_query($query) or die(mysql_error()); $query = "TRUNCATE $playerhistory"; mysql_query($query) or die(mysql_error()); echo "done"; echo "
'.str_replace("&1",$parameter,ADMIN_OLD_PLAYERS)." : \n"; $timezone = explode(":",$_SESSION['s_timezone_offset']); if ($timezone[0] > 0) { $timezone = $timezone[0] * 3600 + $timezone[1] * 60; } else { $timezone = $timezone[0] * 3600 - $timezone[1] * 60; } $time = date("Y-m-d H:i:s",time() - 86400 * $parameter + $timezone); $query = "SELECT id FROM $playertable WHERE last_stats_update != '0000-00-00 00:00:00' AND last_stats_update < '2007-12-01 00:00:00'"; $res = mysql_query($query) or die(mysql_error()); $ids = array(); while ($line = mysql_fetch_object($res)) { array_push($ids,$line->id); } if (count($ids) > 0) { $query = "DELETE FROM $playertable WHERE id IN (".implode(",",$ids).")"; mysql_query($query) or die(mysql_error()); $results = mysql_affected_rows(); echo "".ADMIN_DONE." ($results)"; // delete referenced information $query = "DELETE FROM $playerhistory WHERE player_id IN (".implode(",",$ids).")"; mysql_query($query) or die(mysql_error()); $query = "DELETE FROM $noticetable WHERE player_id IN (".implode(",",$ids).")"; mysql_query($query) or die(mysql_error()); $query = "UPDATE $dbtablename SET player_id = 0, moon = 'false', planetname = '', moonsize = 0 WHERE player_id IN (".implode(",",$ids).")"; mysql_query($query) or die(mysql_error()); } else { echo "".ADMIN_NOTBD.""; } echo "
'.ADMIN_UNUSED_PLAYERS." : \n"; // select all players which are not used at galaxy views $query = "SELECT p.id FROM $playertable p LEFT JOIN $dbtablename g ON p.id = g.player_id WHERE g.player_id IS NULL"; $res = mysql_query($query) or die(mysql_error()); $ids = array(); while ($line = mysql_fetch_object($res)) { array_push($ids,$line->id); } if (count($ids) > 0) { $query = "DELETE FROM $playertable WHERE id IN (".implode(",",$ids).")"; mysql_query($query) or die(mysql_error()); $results = mysql_affected_rows(); echo "".ADMIN_DONE." ($results)"; // delete referenced information $query = "DELETE FROM $playerhistory WHERE player_id IN (".implode(",",$ids).")"; mysql_query($query) or die(mysql_error()); $query = "DELETE FROM $noticetable WHERE player_id IN (".implode(",",$ids).")"; mysql_query($query) or die(mysql_error()); } else { echo "".ADMIN_NOTBD.""; } echo "
'.str_replace("&1",$parameter,ADMIN_OLD_REPORTS)." : \n"; $timezone = explode(":",$_SESSION['s_timezone_offset']); if ($timezone[0] > 0) { $timezone = $timezone[0] * 3600 + $timezone[1] * 60; } else { $timezone = $timezone[0] * 3600 - $timezone[1] * 60; } $time = date("m-d",time() - 86400 * $parameter + $timezone); $time2 = date("m-d",time() + 86400); // just to make sure that every timezone would work = today + 1 $query = "DELETE FROM $reporttable WHERE scantime < '$time' AND scantime > '$time2' AND scantime != ''"; mysql_query($query) or die(mysql_error()); $results = mysql_affected_rows(); if ($results > 0) { echo "".ADMIN_DONE." (".floor($results / 15).")"; } else { echo "".ADMIN_NOTBD.""; } echo "
'.str_replace("&1",$parameter,ADMIN_OLD_GALAXIES)." : \n"; $timezone = explode(":",$_SESSION['s_timezone_offset']); if ($timezone[0] > 0) { $timezone = $timezone[0] * 3600 + $timezone[1] * 60; } else { $timezone = $timezone[0] * 3600 - $timezone[1] * 60; } $time = date("y-m-d H:i:s",time() - 86400 * $parameter + $timezone); $query = "DELETE FROM $dbtablename WHERE last_update < '$time'"; mysql_query($query) or die(mysql_error()); $results = mysql_affected_rows(); if ($results > 0) { echo "".ADMIN_DONE." ($results)"; } else { echo "".ADMIN_NOTBD.""; } echo "
\n"; echo "\n"; } else { $query = "SELECT count(*) as anzahl FROM $playertable WHERE ogame_playerid IS NULL"; $res = mysql_query($query) or die(mysql_error()); $line = mysql_fetch_object($res); $null_players = $line->anzahl; $query = "SELECT count(*) as anzahl FROM $playertable"; $res = mysql_query($query) or die(mysql_error()); $line = mysql_fetch_object($res); $all_players = $line->anzahl; ?>
',ADMIN_GALAXIES); ?>
',ADMIN_UNUSED_PLAYERS); ?>
',ADMIN_OLD_PLAYERS); ?>
',ADMIN_OLD_REPORTS); ?>
',ADMIN_OLD_GALAXIES); ?>