From 5f9ba6df6db7856102e987648d1a8eaef1b25bb6 Mon Sep 17 00:00:00 2001 From: Andreas Brachold Date: Sun, 20 Jan 2008 12:31:09 +0000 Subject: * EPG/TIMERS/RECORDS : SQL-Query improve --- skins/deltab/display.tmpl | 21 ++++++++++++--------- skins/deltab/now.tmpl | 16 ++++++++++------ skins/deltab/program.tmpl | 16 +++++++++------- skins/deltab/schema.tmpl | 11 +++++++---- skins/deltab/search.tmpl | 16 +++++++++------- skins/deltab/tlist.tmpl | 3 ++- skins/stone/display.tmpl | 19 +++++++++++-------- skins/stone/now.tmpl | 16 ++++++++++------ skins/stone/program.tmpl | 16 +++++++++------- skins/stone/schema.tmpl | 11 +++++++---- skins/stone/search.tmpl | 18 ++++++++++-------- skins/stone/tlist.tmpl | 3 ++- skins/stone/widgets/footer.tmpl | 25 +++++++++++++++++++++++++ skins/stone_flat/display.tmpl | 19 +++++++++++-------- skins/stone_flat/now.tmpl | 16 ++++++++++------ skins/stone_flat/program.tmpl | 16 +++++++++------- skins/stone_flat/schema.tmpl | 11 +++++++---- skins/stone_flat/search.tmpl | 18 ++++++++++-------- skins/stone_flat/tlist.tmpl | 3 ++- skins/xstyle/bloecke/event_links.tmpl | 22 +++++++++++----------- skins/xstyle/display.tmpl | 6 +++--- skins/xstyle/now.tmpl | 8 ++++---- skins/xstyle/program.tmpl | 4 ++-- skins/xstyle/schema.tmpl | 5 ++++- skins/xstyle/search.tmpl | 4 ++-- skins/xstyle/tlist.tmpl | 2 +- 26 files changed, 199 insertions(+), 126 deletions(-) diff --git a/skins/deltab/display.tmpl b/skins/deltab/display.tmpl index de3addb..954769e 100644 --- a/skins/deltab/display.tmpl +++ b/skins/deltab/display.tmpl @@ -12,12 +12,15 @@ stopp = data.last.4; channel = data.last.5; description = data.last.6; - bild = data.last.7; - d = data.last.8; - video = data.last.9; - audio = data.last.10; - pdc = data.last.11; - channelid = data.last.12; + video = data.last.7; + audio = data.last.8; + d = data.last.9; + timerid=data.last.10; + recording=data.last.11; + running=data.last.12; + bild = data.last.13; + pdc = data.last.14; + channelid = data.last.15; %?>
@@ -96,12 +99,12 @@ END %?>
- - + + " />   - +
diff --git a/skins/deltab/now.tmpl b/skins/deltab/now.tmpl index d67afc7..351679e 100644 --- a/skins/deltab/now.tmpl +++ b/skins/deltab/now.tmpl @@ -15,10 +15,10 @@ - + - - + + @@ -62,8 +62,8 @@ " /> - - + + " /> @@ -107,7 +107,11 @@ ";END %?> > - + diff --git a/skins/deltab/program.tmpl b/skins/deltab/program.tmpl index 1978892..b5da892 100644 --- a/skins/deltab/program.tmpl +++ b/skins/deltab/program.tmpl @@ -14,10 +14,10 @@ - + - - + + @@ -45,8 +45,8 @@ " /> - - + + " /> @@ -78,8 +78,10 @@ ";END %?> - - + diff --git a/skins/deltab/schema.tmpl b/skins/deltab/schema.tmpl index 2d80abf..280a803 100644 --- a/skins/deltab/schema.tmpl +++ b/skins/deltab/schema.tmpl @@ -114,6 +114,9 @@ video = event.11; audio = event.12; image = event.13; + timerid = event.14; + recording = event.15; + running = event.16; IF second_start > oldend; laenge = second_start - oldend; percent = (laenge / Duration) * width; @@ -141,7 +144,7 @@ - + ";END %?> - - + diff --git a/skins/stone_flat/program.tmpl b/skins/stone_flat/program.tmpl index f712998..c5e08ed 100644 --- a/skins/stone_flat/program.tmpl +++ b/skins/stone_flat/program.tmpl @@ -17,8 +17,8 @@ " /> - - + + " /> @@ -30,10 +30,10 @@ - + - - + + @@ -94,8 +94,10 @@ ";END %?> - - +
@@ -163,10 +166,10 @@ - + - - + + diff --git a/skins/deltab/search.tmpl b/skins/deltab/search.tmpl index 4ca1814..889fc09 100644 --- a/skins/deltab/search.tmpl +++ b/skins/deltab/search.tmpl @@ -14,10 +14,10 @@ - + - - + + @@ -50,8 +50,8 @@ " /> - - + + " /> @@ -76,8 +76,10 @@
diff --git a/skins/deltab/tlist.tmpl b/skins/deltab/tlist.tmpl index 7f724f1..a2583b7 100644 --- a/skins/deltab/tlist.tmpl +++ b/skins/deltab/tlist.tmpl @@ -52,7 +52,7 @@ - + @@ -157,6 +157,7 @@ autotimerid=zeile.12; duration=zeile.13; description=zeile.14; + running=zeile.15; t = zeile.7.split('~');IF t.size > 1;subtitle = t.pop;ELSE;subtitle="";END;title=t.join('~'); pdc= ( zeile.1 ? zeile.1 mod 8 div 4 : 0 ); day = date.format(zeile.9, "%A, %x", locale) %?> diff --git a/skins/stone/display.tmpl b/skins/stone/display.tmpl index d101948..594ab2c 100644 --- a/skins/stone/display.tmpl +++ b/skins/stone/display.tmpl @@ -16,12 +16,15 @@ stopp = data.last.4; channel = data.last.5; description = data.last.6; - bild = data.last.7; - d = data.last.8; - video = data.last.9; - audio = data.last.10; - pdc = data.last.11; - channelid = data.last.12; + video = data.last.7; + audio = data.last.8; + d = data.last.9; + timerid=data.last.10; + recording=data.last.11; + running=data.last.12; + bild = data.last.13; + pdc = data.last.14; + channelid = data.last.15; %?> @@ -58,8 +61,8 @@ END %?> " /> - - + + " /> diff --git a/skins/stone/now.tmpl b/skins/stone/now.tmpl index 3456bcc..6ab3650 100644 --- a/skins/stone/now.tmpl +++ b/skins/stone/now.tmpl @@ -19,8 +19,8 @@ " /> - - + + " /> @@ -32,10 +32,10 @@ - + - - + + @@ -134,7 +134,11 @@ ";END %?> - +

diff --git a/skins/stone/program.tmpl b/skins/stone/program.tmpl index 8d88ff3..9ed0c9d 100644 --- a/skins/stone/program.tmpl +++ b/skins/stone/program.tmpl @@ -17,8 +17,8 @@ " /> - - + + " /> @@ -30,10 +30,10 @@ - + - - + + @@ -119,8 +119,10 @@

  -

";END %?> - - +

diff --git a/skins/stone/schema.tmpl b/skins/stone/schema.tmpl index 76ab1af..a7fe955 100644 --- a/skins/stone/schema.tmpl +++ b/skins/stone/schema.tmpl @@ -131,6 +131,9 @@ video = event.11; audio = event.12; image = event.13; + timerid = event.14; + recording = event.15; + running = event.16; IF second_start > oldend; laenge = second_start - oldend; percent = (laenge / Duration) * width; @@ -158,7 +161,7 @@ - +
@@ -184,10 +187,10 @@ - + - - + + diff --git a/skins/stone/search.tmpl b/skins/stone/search.tmpl index 013b221..45f58f8 100644 --- a/skins/stone/search.tmpl +++ b/skins/stone/search.tmpl @@ -9,8 +9,8 @@ " /> - - + + " /> @@ -22,10 +22,10 @@ - + - - + + @@ -66,7 +66,7 @@ @@ -98,8 +98,10 @@ ";END %?> - - +

diff --git a/skins/stone/tlist.tmpl b/skins/stone/tlist.tmpl index 7d00c02..dbe918d 100644 --- a/skins/stone/tlist.tmpl +++ b/skins/stone/tlist.tmpl @@ -69,7 +69,7 @@ - + @@ -176,6 +176,7 @@ autotimerid=zeile.12; duration=zeile.13; description=zeile.14; + running=zeile.15; t = zeile.7.split('~');IF t.size > 1;subtitle = t.pop;ELSE;subtitle="";END;title=t.join('~'); pdc= ( zeile.1 ? zeile.1 mod 8 div 4 : 0 ); day = date.format(zeile.9, "%A, %x", locale) %?> diff --git a/skins/stone/widgets/footer.tmpl b/skins/stone/widgets/footer.tmpl index c9a3b3f..e0e3334 100644 --- a/skins/stone/widgets/footer.tmpl +++ b/skins/stone/widgets/footer.tmpl @@ -3,6 +3,31 @@ + + +
- + " />
+ + + + + +
Benchmark
+ + + 1000 %?> + + + + + + + + + + +
Summary:
+
+ ";END %?> - +
diff --git a/skins/stone_flat/schema.tmpl b/skins/stone_flat/schema.tmpl index 73714e6..b80cfc1 100644 --- a/skins/stone_flat/schema.tmpl +++ b/skins/stone_flat/schema.tmpl @@ -131,6 +131,9 @@ video = event.11; audio = event.12; image = event.13; + timerid = event.14; + recording = event.15; + running = event.16; IF second_start > oldend; laenge = second_start - oldend; percent = (laenge / Duration) * width; @@ -158,7 +161,7 @@ - + @@ -79,8 +79,10 @@ ";END %?> - - +
@@ -184,10 +187,10 @@ - + - - + + diff --git a/skins/stone_flat/search.tmpl b/skins/stone_flat/search.tmpl index 53adfeb..8174700 100644 --- a/skins/stone_flat/search.tmpl +++ b/skins/stone_flat/search.tmpl @@ -9,8 +9,8 @@ " /> - - + + " /> @@ -22,10 +22,10 @@ - + - - + + @@ -48,7 +48,7 @@ - + " />
diff --git a/skins/stone_flat/tlist.tmpl b/skins/stone_flat/tlist.tmpl index 4f591c5..584dec0 100644 --- a/skins/stone_flat/tlist.tmpl +++ b/skins/stone_flat/tlist.tmpl @@ -69,7 +69,7 @@ - + @@ -158,6 +158,7 @@ autotimerid=zeile.12; duration=zeile.13; description=zeile.14; + running=zeile.15; t = zeile.7.split('~');IF t.size > 1;subtitle = t.pop;ELSE;subtitle="";END;title=t.join('~'); pdc= ( zeile.1 ? zeile.1 mod 8 div 4 : 0 ); day = date.format(zeile.9, "%A, %x", locale) %?> diff --git a/skins/xstyle/bloecke/event_links.tmpl b/skins/xstyle/bloecke/event_links.tmpl index 26fe5a4..a3489ab 100644 --- a/skins/xstyle/bloecke/event_links.tmpl +++ b/skins/xstyle/bloecke/event_links.tmpl @@ -2,27 +2,27 @@ -]"> - -]" /> +"> + +" /> -]" name='recordlink' id='' /> +" name='recordlink' id='' /> - ]" /> +  " /> - - ]" /> + : " /> - 2 ? 'Dolby' : 'Stereo') %?> - ]" /> + : " />
diff --git a/skins/xstyle/display.tmpl b/skins/xstyle/display.tmpl index fe915a8..2e16e37 100644 --- a/skins/xstyle/display.tmpl +++ b/skins/xstyle/display.tmpl @@ -27,8 +27,8 @@ - - + + @@ -71,7 +71,7 @@ - - + + 100 OR duration <= 0 %?> diff --git a/skins/xstyle/schema.tmpl b/skins/xstyle/schema.tmpl index 04a5bbe..806ebce 100644 --- a/skins/xstyle/schema.tmpl +++ b/skins/xstyle/schema.tmpl @@ -177,6 +177,9 @@ sec_height = 0.1; video = e.11; audio = e.12; image = e.13; + timerid = e.14; + recording = e.15; + running = e.16; # Schon früher angefangende Sendung ... IF second_start < param.zeitvon; @@ -209,7 +212,7 @@ sec_height = 0.1; END; %?> -
border-color:#F00;border-color:#0F0;height: px; second_stop -%?>color : #777; top: 0px;border-top-style:dashed;border-top-color:green;border-top-width:2px; diff --git a/skins/xstyle/search.tmpl b/skins/xstyle/search.tmpl index b995310..6358ca6 100644 --- a/skins/xstyle/search.tmpl +++ b/skins/xstyle/search.tmpl @@ -118,7 +118,7 @@
@@ -129,7 +129,7 @@ bgcolor='#F5F5F5'> -- cgit v1.2.3
  -  ( ) +  ( ) diff --git a/skins/xstyle/now.tmpl b/skins/xstyle/now.tmpl index 2d0530b..460bc38 100644 --- a/skins/xstyle/now.tmpl +++ b/skins/xstyle/now.tmpl @@ -64,18 +64,18 @@ - +
- + 100 ? 100 : per) %?> diff --git a/skins/xstyle/program.tmpl b/skins/xstyle/program.tmpl index 048d252..3a739f4 100644 --- a/skins/xstyle/program.tmpl +++ b/skins/xstyle/program.tmpl @@ -56,7 +56,7 @@ - + @@ -73,7 +73,7 @@ = 7; # Desc Field %?> - + - + " /> - + diff --git a/skins/xstyle/tlist.tmpl b/skins/xstyle/tlist.tmpl index e290b48..d5e9fb8 100644 --- a/skins/xstyle/tlist.tmpl +++ b/skins/xstyle/tlist.tmpl @@ -57,7 +57,7 @@ - +