summaryrefslogtreecommitdiff
path: root/scripts/epgd-showdones
diff options
context:
space:
mode:
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';"