Hi,

I need to write a CRON job to turn categories on and off each day (Daily Specials).

I think I can figure out how to set the cron on the server, but I need some direction on how to write/where to put the php script.

The logic is pretty simple, (in english)

select categories with categories_id = '1','2','3','4','5','6','7'
set categories_status = "0" (turn off all specials)
select categories with categories-id = day_of_the_week
set categories_status = "1"

I could probably figure out the correct syntax/logic for the sql, but I don't know what other initilize stuff is needed to open/access the tables.

I also have no idea where this file should be put.

If someone can provide a sample file, or point me to an existing ZC file I can hack through, it would be a big help.

Thanks,
Jeff