Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: Delete "_OS-x" Timed Events Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
GadgetGuy
Super User
Super User
Avatar

Joined: June 01 2008
Location: United States
Online Status: Offline
Posts: 942
Posted: July 10 2022 at 15:08 | IP Logged Quote GadgetGuy

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 View GadgetGuy's Profile Search for other posts by GadgetGuy
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: July 10 2022 at 16:00 | IP Logged Quote dhoward

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 View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
GadgetGuy
Super User
Super User
Avatar

Joined: June 01 2008
Location: United States
Online Status: Offline
Posts: 942
Posted: July 10 2022 at 16:48 | IP Logged Quote GadgetGuy

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 View GadgetGuy's Profile Search for other posts by GadgetGuy
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum