| Author |
|
GadgetGuy
Super User
Joined: June 01 2008
Location: United States
Online Status: Offline
Posts: 942
|
| Posted: July 10 2022 at 15:08 | IP Logged
|
|
|
I am making use of ph_createtimedevent() quite a bit but if things go astray I end up with multiple such events in the Timed Events queue.
I thought there was a way to clear these out (in mass) which I want to do in my Initialization routine but can't find the ph command I thought I had previously used to clear out all the "_OS-n" system events.
Is there such a bulk delete and if so what is it?
 gadgetGuy
__________________
Ken B - Live every day like it's your last. Eventually, you'll get it right!
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: July 10 2022 at 16:00 | IP Logged
|
|
|
Ken,
There isnt a function directly designed for this but you can easily do it with a database function.
ph_directsql("delete from timedevents where id like '_OS-%'")
The above formula will delete any Timed Event that starts with "_OS-".
Dave.
|
| Back to Top |
|
| |
GadgetGuy
Super User
Joined: June 01 2008
Location: United States
Online Status: Offline
Posts: 942
|
| Posted: July 10 2022 at 16:48 | IP Logged
|
|
|
Cool Beans!
I never would have thought of that!
Woops didn't work!! But I found the issue... the
"_OS"Timed Events are actually "__OS" events. That is,
there are TWO (2) "_" characters prefixed onto the "OS"
Edited by GadgetGuy - July 10 2022 at 17:37
__________________
Ken B - Live every day like it's your last. Eventually, you'll get it right!
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome General
Topic: Delete "_OS-x" Timed Events
