From e2a48d8701f91b8e24fbe9e99e91eb72a87bb749 Mon Sep 17 00:00:00 2001
From: horchi <vdr@jwendel.de>
Date: Sun, 5 Mar 2017 16:39:28 +0100
Subject: git init

---
 scripts/epgd-showdones | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100755 scripts/epgd-showdones

(limited to 'scripts/epgd-showdones')

diff --git a/scripts/epgd-showdones b/scripts/epgd-showdones
new file mode 100755
index 0000000..13dad7d
--- /dev/null
+++ b/scripts/epgd-showdones
@@ -0,0 +1,5 @@
+
+export MYSQL_PWD=epg
+
+mysql -u epg2vdr -Depg2vdr -e " \
+  select from_unixtime(updsp, '%d.%m %H:%m') as upd, id, state as s, substr(title,1,35), shorttext, episodecompname, episodecomppartname, expression from timersdone where state != 'D';"
-- 
cgit v1.2.3