Pruneterrain.php

#!/usr/bin/php
<?php
//First do some basic parameter checking
if (sizeof($argv)!=6) {
echo "\nInvalid amount of parameters!\nUsage:".$argv[0]." host user pw db limit\n";
die;
}
else {
	foreach($argv as $arg){
		if(empty($arg)){
		echo "\nInvalid parameter input!\nUsage:".$argv[0]." host user pw db limit\n";
		die;
		}
	}
$host = $argv[1];
$username = $argv[2];
$password = $argv[3];
$database = $argv[4];
	if(intval($argv[5]) > 0) {
	$prunelimit = $argv[5];
	}
	else {
	echo "Enter a valid Prune-limit!(> 1). You don't want to loose your work do you?\n";
	die;
	}
}
 
$connect = mysql_connect($host, $username, $password);
	if (!$connect) {
	die('Could not connect: ' . mysql_error());
	}
	mysql_select_db($database);
	//Get unique regions from terrain table
	$query = "SELECT uuid,regionName from regions";
	$result = mysql_query($query);
	if(!$result) die("Query Failed.");
	//For every unique Region
	$tempspace = 0;
	$space = 0;
	while ($row = mysql_fetch_assoc($result)) {
	$query = "SELECT RegionUUID,Revision from terrain WHERE RegionUUID = '".ereg_replace("-", "", $row['uuid'])."' ORDER BY Revision DESC";
	$nextresult = mysql_query($query);
	//Get the amount of revisions
	$revnum = mysql_num_rows($nextresult);
		//If revision amount exceeds the prune-limit
		if($revnum > $prunelimit) {
		$tempspace = (($revnum - $prunelimit) / 2);
		echo "Freeing ".$tempspace."MB of data from ".$row['regionName']."\n";
		mysql_data_seek($nextresult, ($prunelimit));
			if($lastrow = mysql_fetch_assoc($nextresult)) {
			$query = "DELETE FROM terrain WHERE Revision <= '".$lastrow['Revision']."'";
			mysql_query($query) or die (mysql_error());
			$space += $tempspace;
			}
		}
 
	}
	echo "Totally removed ".$space."MB of terrain-revision data...\n";
	mysql_close($connect);
?>