<?php
 
// Some starting stuff
header('Content-type: text/plain');
require('config.inc.php');
 
// In case of an error
function send_error($error = 'Fatal error') {
	die('CRONJOB ERROR: ' . $error . "\n");
}
 
// Connect to mysql
$mysql_connection = mysql_connect($config['mysql']['host'], $config['mysql']['user'], $config['mysql']['password']) or send_error('DB connection failed');
unset($config['mysql']['password']);
mysql_select_db($config['mysql']['database'], $mysql_connection) or send_error('DB connection failed');
 
// Delete old entries
mysql_query('DELETE FROM ' . $config['mysql']['table'] . ' WHERE last_seen < (NOW() - ' . $config['interval'] . ')', $mysql_connection) or send_error('DB delete failed');
 
// Of course we're proud that we change so many rows
echo 'Purged ' . mysql_affected_rows($mysql_connection) . ' old database entries';
 
// Close the connection
mysql_close($mysql_connection);