diff options
| author | horchi <vdr@jwendel.de> | 2018-02-16 18:59:40 +0100 |
|---|---|---|
| committer | horchi <vdr@jwendel.de> | 2018-02-16 18:59:40 +0100 |
| commit | b2fb1c3c3b33ce7d7e4e88e02f29bb6aabad5d00 (patch) | |
| tree | a5f36fe231022a7954f2edbd7cf0eec37ddac19b /configs/eventsview-ck.sql | |
| parent | f91afbf2343fb96ce30628243e97c4a99bfee6da (diff) | |
| parent | 53d4aa03a6190d5fd9e055c9814374edae0fafe7 (diff) | |
| download | vdr-epg-daemon-b2fb1c3c3b33ce7d7e4e88e02f29bb6aabad5d00.tar.gz vdr-epg-daemon-b2fb1c3c3b33ce7d7e4e88e02f29bb6aabad5d00.tar.bz2 | |
Merge branch 'master' of projects.vdr-developer.org:vdr-epg-daemon
* 'master' of projects.vdr-developer.org:vdr-epg-daemon:
updated configs/eventsview-ck.sql
2018-02-14: version 1.1.134 (horchi)\n - bugfix: Fixed handling of timer type change by WEBIF\n\n
2018-02-14: version 1.1.133 (horchi)\n - bugfix: Fixed display of external timer in WEBIF lists\n\n
2018-02-10: version 1.1.132 (rechner)\n - chanhed: text for swichtimer and highlight recIcon on success\n\n
Diffstat (limited to 'configs/eventsview-ck.sql')
| -rw-r--r-- | configs/eventsview-ck.sql | 13 |
1 files changed, 1 insertions, 12 deletions
diff --git a/configs/eventsview-ck.sql b/configs/eventsview-ck.sql index 89debde..2bb3800 100644 --- a/configs/eventsview-ck.sql +++ b/configs/eventsview-ck.sql @@ -1,16 +1,5 @@ CREATE VIEW eventsview as select cnt_useid useid, cnt_eventid eventid, cnt_channelid channelid, cnt_source source, all_updsp updsp, cnt_updflg updflg, cnt_delflg delflg, cnt_fileref fileref, cnt_tableid tableid, cnt_version version, sub_title title, -case when sub_shorttext is null then - concat( - case when length(ifnull(sub_genre,'')) > 0 then sub_genre else '' end, - case when length(ifnull(sub_genre,'')) > 0 and length(ifnull(sub_country,'')) + length(ifnull(sub_year,'')) > 0 then ' (' else '' end, - case when length(ifnull(sub_country,'')) > 0 then sub_country else '' end, - case when length(ifnull(sub_country,'')) > 0 and length(ifnull(sub_year,'')) > 0 then ' ' else '' end, - case when length(ifnull(sub_year,'')) > 0 then sub_year else '' end, - case when length(ifnull(sub_genre,'')) > 0 and length(ifnull(sub_country,'')) + length(ifnull(sub_year,'')) > 0 then ')' else '' end - ) -else - sub_shorttext -end shorttext, +case when sub_shorttext is null or sub_compshorttext = sub_comptitle then '' else sub_shorttext end shorttext, case when sub_longdescription is Null then cnt_longdescription else |