diff options
| author | Andreas Brachold <vdr07@deltab.de> | 2011-03-04 18:17:38 +0000 |
|---|---|---|
| committer | Andreas Brachold <vdr07@deltab.de> | 2011-03-04 18:17:38 +0000 |
| commit | 53f47bc8ee57938047e49967583369dca4189117 (patch) | |
| tree | 1c1888c3362c41e87ea38b1b8eceeb754947ef48 /lib | |
| parent | 0ff8721a0025fe799ff7c01d786a6de9f5cfb304 (diff) | |
| download | xxv-53f47bc8ee57938047e49967583369dca4189117.tar.gz xxv-53f47bc8ee57938047e49967583369dca4189117.tar.bz2 | |
Improve epg handling
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/XXV/MODULES/RECORDS.pm | 4 | ||||
| -rw-r--r-- | lib/XXV/MODULES/TIMERS.pm | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/lib/XXV/MODULES/RECORDS.pm b/lib/XXV/MODULES/RECORDS.pm index c9e0a65..87724f3 100644 --- a/lib/XXV/MODULES/RECORDS.pm +++ b/lib/XXV/MODULES/RECORDS.pm @@ -2046,7 +2046,7 @@ SELECT SQL_CACHE COUNT(*) as __Group, SUBSTRING_INDEX(CONCAT_WS('~',e.title,e.subtitle), '~', $deep) as __fulltitle, IF(COUNT(*)>1,0,1) as __IsRecording, - e.description as __description, + IF(CHAR_LENGTH(e.description)>77,RPAD(LEFT(e.description,77),80,'.'),e.description) as __description, preview as __preview, SUM(cutlength) as __cutlength FROM @@ -2188,7 +2188,7 @@ SELECT SQL_CACHE 0 as __Group, CONCAT_WS('~',e.title,e.subtitle) as __fulltitle, 1 as __IsRecording, - e.description as __description, + IF(CHAR_LENGTH(e.description)>77,RPAD(LEFT(e.description,77),80,'.'),e.description) as __description, preview as __preview, cutlength as __cutlength FROM diff --git a/lib/XXV/MODULES/TIMERS.pm b/lib/XXV/MODULES/TIMERS.pm index d8754fb..6c87dc7 100644 --- a/lib/XXV/MODULES/TIMERS.pm +++ b/lib/XXV/MODULES/TIMERS.pm @@ -1268,7 +1268,7 @@ SELECT SQL_CACHE t.eventid as __eventid, t.autotimerid as __autotimerid, UNIX_TIMESTAMP(t.stoptime) - UNIX_TIMESTAMP(t.starttime) as __duration, - (SELECT description + (SELECT IF(CHAR_LENGTH(e.description)>77,RPAD(LEFT(e.description,77),80,'.'),e.description) FROM EPG as e WHERE t.eventid = e.eventid LIMIT 1) as __description, |