optimise and repair database from tracker

[rickandmary]

save as optimise.php or whatever you like and upload to root directory.

Code Select Expand

<?
//---------------------------------------------------------
//---- Optimize & Repair Database from Tracker by D3SI
//---------------------------------------------------------
require "include/bittorrent.php";
dbconn(false);
loggedinorreturn();
if (get_user_class() < UC_SYSOP)
stderr("Error", "Permission denied.");
$tables = "";
$tablesshow = mysql_query("SHOW TABLES FROM `".$mysql_db."`");
while (list($table) = mysql_fetch_row($tablesshow)){
$tables .= "`".mysql_real_escape_string($table)."`,";
}
$tables .= "...";
$tables = str_replace(",...", "", $tables);
mysql_query("OPTIMIZE TABLE ".$tables);
//mysql_query("REPAIR TABLE ".$tables);

stderr("Optimize & Repair Database", "Database OPTIMIZED & Repaired!");
//---------------------------------------------
//---- END
//---------------------------------------------
?>

Thanks to D3SI for this handy script