Changing Schedule time via script for visulation page

[admin]

First, you need to get ID of each event you want to change:

Code:

log(db:getall('SELECT * FROM scheduler_events'))

Then you can use this function to change event time:

Code:

hour = 12 -- event time / start hour
min = 30 -- event time / minute
id = 42 -- event DB id

db:update('scheduler_events', {
  start_hour = hour,
  start_min = min
}, { id = id })

You can change active state of schedulers by name:

Code:

name = 'My scheduler'
active = 1 -- 1 = active, 0 = inactive
db:update('schedulers', { active = active }, { name = name })

After each change you need to clear schedulers cache:
http://forum.logicmachine.net/showthread...04#pid2804