diff options
Diffstat (limited to 'configs')
| -rw-r--r-- | configs/epg.dat | 1 | ||||
| -rw-r--r-- | configs/epgd.conf | 2 | ||||
| -rw-r--r-- | configs/eventsview-perlbo.sql | 64 |
3 files changed, 66 insertions, 1 deletions
diff --git a/configs/epg.dat b/configs/epg.dat index 0959093..b33e4a4 100644 --- a/configs/epg.dat +++ b/configs/epg.dat @@ -400,6 +400,7 @@ 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/epgd.conf b/configs/epgd.conf index 019c43f..7fbddc7 100644 --- a/configs/epgd.conf +++ b/configs/epgd.conf @@ -32,7 +32,7 @@ MaxImagesPerEvent = 1 SeriesEnabled = 1 SeriesPort = 2006 SeriesStoreToFs = 0 -SeriesUrl = eplists.constabel.net +SeriesUrl = www.eplists.de ScrapEpg = 1 ScrapRecordings = 1 diff --git a/configs/eventsview-perlbo.sql b/configs/eventsview-perlbo.sql new file mode 100644 index 0000000..03d6a2c --- /dev/null +++ b/configs/eventsview-perlbo.sql @@ -0,0 +1,64 @@ +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 + case when sub_genre is null then '' else concat(sub_genre,' (', sub_country, ' ',sub_year, ')') end + else + case when epi_season is null then + sub_shorttext + else + concat('(S', lpad(format(epi_season, 0), 2, '0'), 'E', lpad(format(epi_part, 0), 2, '0'), ') ', epi_partname) + end +end shorttext, +cnt_starttime starttime, cnt_duration duration, cnt_parentalrating parentalrating, cnt_vps vps, cnt_contents contents, replace( +concat( + TRIM(LEADING '|' FROM + concat( + case when sub_genre is Null then '' else concat('|','Genre: ',sub_genre) end, + case when sub_category is Null then '' else concat('|','Kategorie: ',sub_category) end, + 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 + ) + ), + concat( + case when sub_shortdescription is Null then '' else concat('||',sub_shortdescription) end, + case when sub_txtrating is Null and sub_shortreview is null then '' else '||' end, + case when sub_txtrating is null then '' else sub_txtrating end, + case when sub_txtrating is Null or sub_shortreview is null then '' else ', ' end, + case when sub_shortreview is Null then '' else sub_shortreview end, + case when sub_tipp is Null and sub_rating is Null then '' else '||' end, + case when sub_tipp is Null then '' else concat('|',sub_tipp) end, + case when sub_rating is Null then '' else concat('|',sub_rating) end, + case when sub_topic is Null then '' else concat('||','Thema: ',sub_topic) end, + case when sub_longdescription is Null then '' else concat('||',sub_longdescription) end, + case when sub_moderator is Null then '' else concat('||','Moderator: ',sub_moderator) end, + case when sub_commentator is Null then '' else concat('||','Kommentar: ',sub_commentator) end, + case when sub_guest is Null then '' else concat('|','Gäste: ',sub_guest) end, + case when cnt_parentalrating is Null or cnt_parentalrating = 0 then '' else concat('||','Altersempfehlung: ab ',cnt_parentalrating) end, + case when sub_actor is Null and sub_producer is Null and sub_other is Null then '' else '|' end, + case when sub_actor is Null then '' else concat('|','Darsteller: ',sub_actor) end, + case when sub_producer is Null then '' else concat('|','Produzent: ',sub_producer) end, + case when sub_other is Null then '' else concat('|','Sonstige: ',sub_other) end, + case when sub_director is Null and sub_screenplay is Null and sub_camera is Null and sub_music is Null and sub_audio is Null and sub_flags is Null then '' else '|' end, + case when sub_director is Null then '' else concat('|','Regie: ',sub_director) end, + case when sub_screenplay is Null then '' else concat('|','Drehbuch: ',sub_screenplay) end, + case when sub_camera is Null then '' else concat('|','Kamera: ',sub_camera) end, + case when sub_music is Null then '' else concat('|','Musik: ',sub_music) end, + case when sub_audio is Null then '' else concat('|','Audio: ',sub_audio) end, + case when sub_flags is Null then '' else concat('|','Flags: ',sub_flags) end, + case when epi_episodename is Null then '' else concat('||','Serie: ',epi_episodename) end, + case when epi_shortname is Null then '' else concat('|','Kurzname: ',epi_shortname) end, + case when epi_partname is Null then '' else concat('|','Episode: ',epi_partname) end, + case when epi_extracol1 is Null then '' else concat('|',epi_extracol1) end, + case when epi_extracol2 is Null then '' else concat('|',epi_extracol2) end, + case when epi_extracol3 is Null then '' else concat('|',epi_extracol3) end, + case when epi_season is Null then '' else concat('|','Staffel: ',cast(epi_season as char)) end, + case when epi_part is Null then '' else concat('|','Staffelfolge: ',cast(epi_part as char)) end, + case when epi_part is Null then '' else concat('|','Staffelfolgen: ',cast(epi_parts as char)) end, + case when epi_number is Null then '' else concat('|','Folge: ',cast(epi_number as char)) 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 + ) +) +,'|', ' +') as description +from + useevents; |