Thread

I need to find a way to automatically expire my entries that have been open for X days (in Y weblog and Z categories).

I’ve heard of a “Auto-Expire Extension” but can’t find it in the add-on list.

So I figured I could run a query off a cron to auto-expire entries that have been open X days… problem is I’m an SQL newbie.

I’d like to modify this script in the wiki - Automatically Close Expired Entries

Does anyone know how to modify the query below to expire entries that are:

1. X days old or older

2. In a certain weblog (I assume doing “WHERE weblog_id = X”)

3. In a certain category

Here’s the query to modify:

UPDATE `exp_weblog_titles` 
SET expiration_date = 'UNIX_TIMESTAMP()' 
WHERE expiration_date = '0' 
AND entry_date < UNIX_TIMESTAMP()

Thanks for any ideas!

http://devot-ee.com/add-ons/auto-expire

Thanks for the assist, Lee.

Carlyn, will that add-on work for you?