I'm building a CMS that has a requirement to allow users to store schedules. The interface is similar to MS Outlook, so the recurring schedules pretty much needs to mimic what that UI can support.
When the schedule is saved, we need to somehow be alerted when an event is supposed to happen. Right now, the plan is to have a cron job run every minute to check and see if an event is scheduled at that very minute.
Since our users will be from all over the world, we need this scheduling system to be time zone and DST aware.
Also, the ability to convert this schedule into human readable text (e.g. "Every day at 9am from Jan 1, 2010 to Feb 1, 2010") would be nice for our users.
Does anyone have any ideas how to implement this? I'm using PHP/MySQL.