From dcf081666c526b6c9d5f1992088a56ea50b4816d Mon Sep 17 00:00:00 2001 From: horchi Date: Thu, 23 Mar 2017 18:50:46 +0100 Subject: 2017-03-23: version 1.1.114 (horchi)\n - change: Minor view change for peding features\n\n --- configs/eventsview.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'configs/eventsview.sql') diff --git a/configs/eventsview.sql b/configs/eventsview.sql index 6cee8af..62397d2 100644 --- a/configs/eventsview.sql +++ b/configs/eventsview.sql @@ -11,6 +11,16 @@ case when sub_shorttext is null then else sub_shorttext end shorttext, +case when sub_longdescription is Null or (sub_category not in ('Serie','Spielfilm') and length(cnt_longdescription) / (length(sub_longdescription)/100) > 20) then + concat('sub_longdescription','|DVB: ',cnt_longdescription) +else + sub_longdescription +end longdescription, +case when cnt_source <> sub_source then + concat(upper(replace(cnt_source,'vdr','dvb')),'/',upper(sub_source)) +else + upper(replace(cnt_source,'vdr','dvb')) +end mergesource, cnt_starttime starttime, cnt_duration duration, cnt_parentalrating parentalrating, cnt_vps vps, cnt_contents contents, replace( concat( TRIM(LEADING '|' FROM -- cgit v1.2.3