#!/usr/bin/php -f

<?php

$link = mysql_connect("","user","pass")
or die("Mysql Server Connect Error!");

mysql_select_db("your_db")
or die("Select_Db Error!");

# Optional - remove old offline messages
#$query="delete from spool where created_at < NOW() - INTERVAL 30 DAY";
#$result=mysql_query($query) or die(mysql_error());
$query="delete from archive where created_at < NOW() - INTERVAL 30 DAY";
$result=mysql_query($query) or die(mysql_error());
?>