<?php
###############
#  Prune.php  #
###############
error_reporting(E_ALL ^ E_NOTICE ^ E_DEPRECATED); // FUCK THE ERRORS

//Variables
$dbhost = "localhost"; //host name
$dbuser = "admin"; // username for db
$dbname = "test"; // database name
$dbpass = "password"; //password for db
$error = "There was a problem connecting to the database"; // error statement
$lastlogin = "2592000000";
$query = "SELECT id FROM accounts WHERE lastlogin < CURRENT_TIMESTAMP() - $lastlogin";
$result = mysql_query($query);

//connect to db
mysql_connect ($dbhost, $dbuser, $dbpass) or die ($error);
mysql_select_db($dbname);

while ($ar = mysql_fetch_array($result)){
mysql_query("DELETE * FROM characters,buddies,inventoryitems,keymap,skills WHERE characterid = $ar");
}
?>