From 71cd4593136eeaf7612f6ca44e61172221d77b77 Mon Sep 17 00:00:00 2001 From: horchi Date: Sun, 15 Dec 2019 11:10:33 +0100 Subject: timer cleanup --- update.c | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/update.c b/update.c index 35fa2d8..986361f 100644 --- a/update.c +++ b/update.c @@ -1719,10 +1719,10 @@ void cEpgd::loop() " and from_unixtime(updsp) < (now() - interval 5 minute);"); -// connection->query("%s", "update timers set" -// " state = 'D' " -// " where state = 'R'" -// #todo " and from_unixtime(updsp) < (now() - interval 5 minute);"); + connection->query(" update timers set" + " state = 'F', action = 'A', info = 'cleanuped'" + " where (state = 'R' or state = 'P')" + " and from_unixtime(_endtime) < (now() - interval 5 minute);"); } if (!dbConnected()) -- cgit v1.2.3