diff options
Diffstat (limited to 'configs')
| -rw-r--r-- | configs/epg.dat | 1 | ||||
| -rw-r--r-- | configs/eventsview-3po.sql | 10 | ||||
| -rw-r--r-- | configs/eventsview-ck.sql | 10 | ||||
| -rw-r--r-- | configs/eventsview-horchi.sql | 14 | ||||
| -rw-r--r-- | configs/eventsview-perlbo.sql | 10 | ||||
| -rw-r--r-- | configs/eventsview-uti.sql | 10 | ||||
| -rw-r--r-- | configs/eventsview.sql | 10 |
7 files changed, 62 insertions, 3 deletions
diff --git a/configs/epg.dat b/configs/epg.dat index b33e4a4..0959093 100644 --- a/configs/epg.dat +++ b/configs/epg.dat @@ -400,7 +400,6 @@ Table useevents MASTERID "" cnt_masterid UInt 0 Data|Meta, USEID "" cnt_useid UInt 0 Data, -// SOURCE "" source Ascii 25 Data SUBSOURCE "" sub_source Ascii 10 Data|Meta, SUBEVENTID "" sub_eventid UBigInt 0 Data|Meta, diff --git a/configs/eventsview-3po.sql b/configs/eventsview-3po.sql index 3f9d167..39ba49e 100644 --- a/configs/eventsview-3po.sql +++ b/configs/eventsview-3po.sql @@ -20,6 +20,16 @@ else case when length(ifnull(sub_genre,'')) + length(ifnull(sub_country,'')) + length(ifnull(sub_year,'')) > 0 then ')' else '' end ) 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 diff --git a/configs/eventsview-ck.sql b/configs/eventsview-ck.sql index 62e54e8..1a8c506 100644 --- a/configs/eventsview-ck.sql +++ b/configs/eventsview-ck.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 diff --git a/configs/eventsview-horchi.sql b/configs/eventsview-horchi.sql index 3e9debf..e137594 100644 --- a/configs/eventsview-horchi.sql +++ b/configs/eventsview-horchi.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 @@ -20,13 +30,13 @@ concat( case when sub_country is Null then '' else concat('|','Land: ',sub_country) end, case when sub_year is Null then '' else concat('|','Jahr: ',substring(sub_year,1,4)) end, case when epi_episodename is Null then '' else concat('|Serie: ',epi_episodename,' - Staffel: ',epi_season,' / Folge: ',epi_part) end, + case when cnt_source <> sub_source then concat('|','Quelle: ',upper(replace(cnt_source,'vdr','dvb')),'/',upper(sub_source)) else concat('|','Quelle: ',upper(replace(cnt_source,'vdr','dvb'))) end, case when sub_flags is Null then '' else concat('|',sub_flags) end, case when sub_flags is Null or sub_audio is Null then '' else ' ' end, case when sub_audio is Null then '' else concat('[', replace(sub_audio, ' ', '] ['), ']') end, case when sub_flags is Null and sub_audio is Null then '|' else '' end, case when sub_flags is Null or sub_audio is Null then '' else ' ' end, - case when cnt_parentalrating is Null then '' else concat('[FSK ',cnt_parentalrating,']') end, - case when cnt_source <> sub_source then concat(' [EPG: ',upper(replace(cnt_source,'vdr','dvb')),'/',upper(sub_source),']') else concat(' [EPG: ',upper(replace(cnt_source,'vdr','dvb')),']') end + case when cnt_parentalrating is Null then '' else concat('[FSK ',cnt_parentalrating,']') end ) ), case when sub_tipp is Null then '' else concat('||',sub_tipp) end, diff --git a/configs/eventsview-perlbo.sql b/configs/eventsview-perlbo.sql index 03d6a2c..44dddcc 100644 --- a/configs/eventsview-perlbo.sql +++ b/configs/eventsview-perlbo.sql @@ -9,6 +9,16 @@ case concat('(S', lpad(format(epi_season, 0), 2, '0'), 'E', lpad(format(epi_part, 0), 2, '0'), ') ', epi_partname) end 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 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 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 |