diff options
| author | horchi <vdr@jwendel.de> | 2017-03-23 18:50:46 +0100 |
|---|---|---|
| committer | horchi <vdr@jwendel.de> | 2017-03-23 18:50:46 +0100 |
| commit | dcf081666c526b6c9d5f1992088a56ea50b4816d (patch) | |
| tree | 09a2f7be8d31e9a9e40c0ee42845939f9138a841 /configs/eventsview-uti.sql | |
| parent | dfdedfcafbca62a0a5a327b6ee1b453e0341a753 (diff) | |
| download | vdr-epg-daemon-dcf081666c526b6c9d5f1992088a56ea50b4816d.tar.gz vdr-epg-daemon-dcf081666c526b6c9d5f1992088a56ea50b4816d.tar.bz2 | |
2017-03-23: version 1.1.114 (horchi)\n - change: Minor view change for peding features\n\n1.1.114
Diffstat (limited to 'configs/eventsview-uti.sql')
| -rw-r--r-- | configs/eventsview-uti.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/configs/eventsview-uti.sql b/configs/eventsview-uti.sql index 2984707..e8960ec 100644 --- a/configs/eventsview-uti.sql +++ b/configs/eventsview-uti.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 |