View Single Post
  #2  
Old 13th January 2010, 17:26
elvira's Avatar
elvira elvira is offline
Senior Member
 
Join Date: Jan 2008
Slovenia
Posts: 172
Default
Try this one

Code:
////////auto-delete old torrents////////     
$days = 5;
$dt = sqlesc(get_date_time(gmtime() - ($days * 86400)));
$days_la = 7;
$dt_la = sqlesc(get_date_time(gmtime() - ($days_la * 86400)));
$res = sql_query("SELECT id, name FROM torrents WHERE added < $dt AND seeders=0 AND leechers=0 AND last_action < $dt_la ");
while ($arr = mysql_fetch_assoc($res))
{
@unlink("$torrent_dir/$arr[id].torrent");
sql_query("DELETE FROM torrents WHERE id=$arr[id]");
sql_query("DELETE FROM peers WHERE torrent=$arr[id]");
sql_query("DELETE FROM snatched WHERE torrent=$arr[id]");
sql_query("UPDATE avps SET value_d='0000-00-00 00:00:00', value_s='' WHERE arg='bestfilmofweek' AND value_s=".$arr["id"]);
sql_query("DELETE FROM comments WHERE torrent=$arr[id]");
sql_query("DELETE FROM files WHERE torrent=$arr[id]");
write_log("Torrent $arr[id] ($arr[name]) was deleted by system (older than $days days and no seeders or leechers in 7 day's)");
$message = "Torrent $arr[id] ($arr[name]) was deleted by system (older than $days days and no seeders or leechers in 7 day's)";
autoshout($message);
}
Reply With Quote