From 1cbab41a38411ded875924d8b3cdaba68bafd574 Mon Sep 17 00:00:00 2001 From: horchi Date: Thu, 24 May 2018 08:13:55 +0200 Subject: 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\n --- scripts/epgd-showtimerat | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'scripts/epgd-showtimerat') 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;" -- cgit v1.2.3