Event trigger

Scheduler Javascript
#1

Hi,

Looking to use dhtmlxScheduler… and it looks great btw!!!

We are looking for a trigger to know when an event (either single or recurring) has started or about to start (user customisable notification … eg 10 mins before event). We’d like to use it to run an program on the server to perhaps send an SMS, email or other app.

Also, is there code somewhere to create all the initial tables for me for dhtmlxScheduler? I’m using MS SQL Server 2005 Express.

Sorry if this has been answered elsewhere… appreciate if you could point me to the correct forum topic.

Thanks,
Kevin.

#2

In case of plain events - you just need run sql query on the current date + n minutes, to check the events which will occur in nearest time. In case of recurring events - situation is a bit more complicated, there is a php helper class which may provide necessary info.

As for table structure - check
\samples\common\dump.sql
events_rec table is a minimal table which is enough for all scheduler’s functionality.