From 9b45b1f47809dec598214f52eeb1f3a73edc6ce9 Mon Sep 17 00:00:00 2001 From: anbr Date: Sun, 6 Sep 2015 17:36:45 +0200 Subject: CHRONICLE: Update duration after recording complete --- lib/XXV/MODULES/CHRONICLE.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'lib') diff --git a/lib/XXV/MODULES/CHRONICLE.pm b/lib/XXV/MODULES/CHRONICLE.pm index 18db980..44d1539 100644 --- a/lib/XXV/MODULES/CHRONICLE.pm +++ b/lib/XXV/MODULES/CHRONICLE.pm @@ -143,7 +143,7 @@ sub _insertData { my $self = shift || return error('No object defined!'); my $sql = qq| -INSERT IGNORE INTO CHRONICLE +REPLACE INTO CHRONICLE SELECT SQL_CACHE 0, MD5(CONCAT(e.channel_id,FLOOR(UNIX_TIMESTAMP(e.starttime) / 900),REPLACE(IF(ISNULL(e.subtitle) OR Length(e.subtitle)<=0, IF(left(e.title,1) = "%",SUBSTR(e.title FROM 2),e.title), CONCAT_WS("~",e.title,e.subtitle)),"~%","~"))), REPLACE(IF(ISNULL(e.subtitle) OR Length(e.subtitle)<=0, IF(left(e.title,1) = "%",SUBSTR(e.title FROM 2),e.title), CONCAT_WS("~",e.title,e.subtitle)),"~%","~") as title, @@ -228,7 +228,7 @@ ORDER BY starttime unless($console->typ eq 'AJAX') { map { - $_->[3] = datum($_->[3],'weekday'); + $_->[3] = datum($_->[3],'weekday'); } @$erg; unshift(@$erg, $fields); } -- cgit v1.2.3