diff options
| author | anbr <vdr07@deltab.de> | 2015-09-06 17:36:45 +0200 |
|---|---|---|
| committer | anbr <vdr07@deltab.de> | 2015-09-06 17:36:45 +0200 |
| commit | 9b45b1f47809dec598214f52eeb1f3a73edc6ce9 (patch) | |
| tree | 90c934658e52a61836ba11b3415b17b8a6b1a907 | |
| parent | d036005d73407887872b9321ae51fe8f7ee6f9a5 (diff) | |
| download | xxv-9b45b1f47809dec598214f52eeb1f3a73edc6ce9.tar.gz xxv-9b45b1f47809dec598214f52eeb1f3a73edc6ce9.tar.bz2 | |
CHRONICLE: Update duration after recording complete
| -rw-r--r-- | lib/XXV/MODULES/CHRONICLE.pm | 4 |
1 files changed, 2 insertions, 2 deletions
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); } |