#!/usr/bin/php -q
<?php
$INSTALL_ROOT='/usr/share/openupload';
include($INSTALL_ROOT.'/www/config.inc.php');
$db = mysql_connect($CONFIG['database']['host'], $CONFIG['database']['user'], $CONFIG['database']['password']) or die(mysql_error());
mysql_select_db($CONFIG['database']['name'], $db) or die(mysql_error());

$query = "SELECT * FROM file_options WHERE name='expire' AND value<='" . date('Y-m-d',time()-(24 * 60 * 60))."' AND value!=''";
$result = mysql_query($query, $db);
if (mysql_num_rows($result)==0) {
 dolog('Nothing to clean');
} else {
 dolog('Expired files:');
 while ($row = mysql_fetch_array($result))
{
    dolog('   '.$row[file_id]);
    unlink($CONFIG['DATA_PATH'].'/'.$row[file_id]);
    mysql_query("DELETE FROM files WHERE id = '".$row[file_id]."'");
    mysql_query("DELETE FROM file_options WHERE file_id = '".$row[file_id]."'");
    }
}

mysql_close($db);

function dolog($text)
  {
  // open log file
  $filename = "/var/log/openupload.log";
  $fh = fopen($filename, "a") or die("Could not open log file.");
  fwrite($fh, date("M d H:i:s")." - $text\n") or die("Could not write file!");
  fclose($fh);
  }
?>
