Ok, this guy is annoying me
As I can't remember the last time I pulled down a WMV file to watch, I've decided to delete all WMV files every day. Before I do this though, I just wanted to check the process in case I cause some issues for myself
1. Run SQL:
DELETE FROM releases where id in
(SELECT DISTINCT r.ID FROM releasefiles rf
INNER JOIN releases r ON (rf.releaseID = r.id)
WHERE rf.name REGEXP 'x264.*\.wmv$'
AND rf.createddate > DATE_SUB(NOW(), INTERVAL 1 WEEK);2. Not sure if the above will cascade delete the files from "releasefiles" but if not, delete the same records from there too, I.E.
DELETE FROM releasefiles
WHERE name REGEXP 'x264.*\.wmv$'
AND createddate > DATE_SUB(NOW(), INTERVAL 1 WEEK);
3. Clean up the NZBs:
/var/www/nZEDb/misc/testing/Dev/clean_nzbs.php true
Does this sound like it would work?
NB. The above would do the last week's worth - I'd probably run that for the last couple of weeks tbh - can't quite remember when he started posting cr*p ......
[Update: The above was based on dizant's post - thanks dizant!]
