#4 Getting rid of really old content.

open
nobody
None
5
2003-10-21
2003-10-21
Ernie Oporto
No

Add the following to the top of dump.php:

$sql = "delete from $ITEM_TABLE where link not like '%
sourceforge%' and timestamp <= DATE_ADD(CURDATE
(),INTERVAL - 45 DAY)"; // kill items older than 45 days
$result = fof_do_query($sql);

I filter out sourceforge RSS from this cleanup because
they tend to keep really old stuff around for a long time
and then you are just dropping that same old content
over and over. This filter should probably become a drop
box of some sort so that people have a choice through
the GUI or even so that more than one can be chosen.
Maybe this could be extended so that in addition, say, if
one were not interested in Cricket or Rugby in the BBC
feed, such an article would not display.

Discussion