diff options
| author | horchi <vdr@jwendel.de> | 2018-05-24 08:13:55 +0200 |
|---|---|---|
| committer | horchi <vdr@jwendel.de> | 2018-05-24 08:13:55 +0200 |
| commit | 1cbab41a38411ded875924d8b3cdaba68bafd574 (patch) | |
| tree | 51c6f435007cb36369f660330e68b28771b9a853 /scripts/epgd-showtimerat | |
| parent | c8bd1c70a8d10ee13fd8d0b12adf9655dcaa8634 (diff) | |
| download | vdr-epg-daemon-1cbab41a38411ded875924d8b3cdaba68bafd574.tar.gz vdr-epg-daemon-1cbab41a38411ded875924d8b3cdaba68bafd574.tar.bz2 | |
2018-05-14: version 1.1.141 (horchi)\n added: Compatibility for newer MariaBD librarys (patch by provided by marco)\n added: execution shell to scripts\n\n1.1.141
Diffstat (limited to 'scripts/epgd-showtimerat')
| -rwxr-xr-x | scripts/epgd-showtimerat | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/scripts/epgd-showtimerat b/scripts/epgd-showtimerat index de1d8f3..bdc6d1d 100755 --- a/scripts/epgd-showtimerat +++ b/scripts/epgd-showtimerat @@ -1,3 +1,4 @@ +#!/bin/bash export MYSQL_PWD=epg @@ -11,4 +12,4 @@ select t.id, SUBSTRING_INDEX(t.channelid, '-', 3) as transponder, v.name, t.sour v.uuid = t.vdruuid and t.active = 1 and t.state in ('P','R') \ and ('$1' between from_unixtime(t.day + t.starttime div 100 * 60 * 60 + t.starttime % 100 * 60) and from_unixtime(t.day + t.endtime div 100 * 60 * 60 + t.endtime % 100 * 60)) \ and v.name = '$2' \ - order by t.day, start;" + order by t.day, start;" |