summaryrefslogtreecommitdiff
path: root/scripts/epgd-showdones
diff options
context:
space:
mode:
authorhorchi <vdr@jwendel.de>2017-03-05 16:39:28 +0100
committerhorchi <vdr@jwendel.de>2017-03-05 16:39:28 +0100
commite2a48d8701f91b8e24fbe9e99e91eb72a87bb749 (patch)
tree726f70554b4ca985a09ef6e30a7fdc8df089993c /scripts/epgd-showdones
downloadvdr-epg-daemon-e2a48d8701f91b8e24fbe9e99e91eb72a87bb749.tar.gz
vdr-epg-daemon-e2a48d8701f91b8e24fbe9e99e91eb72a87bb749.tar.bz2
git init1.1.103
Diffstat (limited to 'scripts/epgd-showdones')
-rwxr-xr-xscripts/epgd-showdones5
1 files changed, 5 insertions, 0 deletions
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';"