Difference between revisions of "Videorow"

From Sega Retro
 
(47 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
<includeonly><span style="display:none;">{{#vardefine:videorowcode|{{{1|}}}}}{{#vardefine:videorowepisodeno|{{{2|}}}}}{{#vardefine:timestamp|{{{3|}}}}}{{#cargo_query:
+
<includeonly><span style="display:none;">{{#vardefine:teletextmode|}}
−
tables=issuenames,magnames
+
 
−
|fields=issuenames.name=issuename,issuenames.date,issuenames.pdf,magnames.name=magname,magnames.country,magnames.link
+
{{#switch:{{{1|}}}
−
|where=issuenames.code="{{#var:videorowcode}}" and issuenames.num="{{#var:videorowepisodeno}}"
+
|digitiser={{#vardefine:teletextmode|true}}
−
|join on=issuenames.code=magnames.code
+
{{#vardefine:videorowcode|digitiser}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{DigitiserThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[Digitiser]]'' (UK), page {{{3|}}}}}
 +
 
 +
|gamecentral={{#vardefine:teletextmode|true}}
 +
{{#vardefine:videorowcode|gamecentral}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{GameCentralThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[GameCentral]]'' (UK), page {{{3|}}}}}
 +
 
 +
|buzz={{#vardefine:teletextmode|true}}
 +
{{#vardefine:videorowcode|buzz}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{BuzzThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[Buzz! Computers]]'' (UK), page {{{3|}}}}}
 +
 
 +
|fx={{#vardefine:teletextmode|true}}
 +
{{#vardefine:videorowcode|fx}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{FXThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[FX]]'' (UK), page {{{3|}}}}}
 +
 
 +
|gamezine={{#vardefine:teletextmode|true}}
 +
{{#vardefine:videorowcode|gamezine}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{GameZineThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[GameZine]]'', page {{{3|}}}}}
 +
 
 +
|gamestationuk={{#vardefine:teletextmode|true}}
 +
{{#vardefine:videorowcode|gamestationuk}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{GameStationThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[Game Station (UK)|Game Station]]'', page {{{3|}}}}}
 +
 
 +
|entsextra={{#vardefine:teletextmode|true}}
 +
{{#vardefine:videorowcode|entsextra}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{EntsExtraThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[Ents Extra]]'', page {{{3|}}}}}
 +
 
 +
|gamesworldtt={{#vardefine:teletextmode|true}}
 +
{{#vardefine:videorowcode|gamesworldtt}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{GamesWorldTeletextThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[Games World (Teletext)]]'', page {{{3|}}}}}
 +
 
 +
|megabytett={{#vardefine:teletextmode|true}}
 +
{{#vardefine:videorowcode|megabytett}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{MegaByteThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[Mega Byte (Teletext)]]'', page {{{3|}}}}}
 +
 
 +
|thescene={{#vardefine:teletextmode|true}}
 +
{{#vardefine:videorowcode|thescene}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{TheSceneThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[The Scene]]'', page {{{3|}}}}}
 +
 
 +
|techno={{#vardefine:teletextmode|true}}
 +
{{#vardefine:videorowcode|techno}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{TechnoThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[Techno]]'', page {{{3|}}}}}
 +
 
 +
|randomaccess={{#vardefine:teletextmode|true}}
 +
{{#vardefine:videorowcode|randomaccess}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{RandomAccessThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[Random Access]]'', page {{{3|}}}}}
 +
 
 +
|formattt={{#vardefine:teletextmode|true}}
 +
{{#vardefine:videorowcode|formattt}}
 +
{{#vardefine:videorowepisodeno|{{{2|}}}}}
 +
{{#vardefine:teletextThumb|{{Form@tThumbnail|{{{2|}}}|{{{3|}}}}}}}
 +
{{#vardefine:teletextName|''[[Form@t]]'', page {{{3|}}}}}
 +
 
 +
|#default={{#vardefine:videorowcode|{{{1|}}}}}{{#vardefine:videorowepisodeno|{{{2|}}}}}{{#vardefine:timestamp|{{{3|}}}}}{{#cargo_query:
 +
tables=episodenames,videonames
 +
|fields=episodenames.name=episodename,episodenames.date,episodenames.time,videonames.name=videoname,videonames.country,videonames.link,episodenames.video
 +
|where=episodenames.code="{{#var:videorowcode}}" and episodenames.num="{{#var:videorowepisodeno}}"
 +
|join on=episodenames.code=videonames.code
 
|limit=1
 
|limit=1
 
|format=template
 
|format=template
−
|template=magref/Cargo
+
|template=Videorow/Cargo
−
}}</span>
+
}}}}
−
{{#if:{{{version|}}}{{{rating|}}}{{{awards|}}}|{{#vardefine:ratingrow|true}}|{{#vardefine:ratingrow|}}}}{{#ifeq:{{#var:filename}}||{{#vardefine:filename|{{{file|}}}}}|}}
+
 
−
|style="vertical-align:top"|{{#if: {{#var:filename}} | CONTENT HERE }}
+
 
−
|style="vertical-align:top"|{{#var:date}}
+
</span>{{#if:{{{version|}}}{{{rating|}}}{{{awards|}}}|{{#vardefine:ratingrow|true}}|{{#vardefine:ratingrow|}}}}{{#ifeq:{{#var:filename}}||{{#vardefine:filename|{{{file|}}}}}|}}
−
|style="vertical-align:top"|{{#if:{{#var:pubname}}|''{{#if:{{#var:publink}}|[[{{#sub:{{#var:publink}}|5}}|{{#var:pubname}}]]|{{#var:pubname}}}}'' ({{#var:country}}), "{{#var:issuename}}"|{{#if:{{#var:issuename}}||[[Category:Bad video reference]]}}}}
+
|style="vertical-align:top"|{{#if:{{#var:teletextmode}}|{{#var:teletextThumb}}|{{#if: {{#var:cargovideo}} | [[File:Video Placeholder.svg|200px|link=cdn:File:{{#var:cargovideo}}]]||}}}}
 +
|style="vertical-align:top"|{{#if:{{#var:teletextmode}}|{{{2|}}}|{{#var:cargodate}}, {{#var:cargotime}} {{#if:{{#var:timestamp}}|(+ {{#var:timestamp}})|}}}}
 +
|style="vertical-align:top"|{{#if:{{#var:teletextmode}}|{{#var:teletextName}}|{{#if:{{#var:cargovideoname}}|''{{#if:{{#var:cargolink}}|[[{{#sub:{{#var:cargolink}}|5}}|{{#var:cargovideoname}}]]|{{#var:cargovideoname}}}}'' ({{#var:cargocountry}}), {{#if:{{#var:cargoepisodename}}|"{{#var:cargoepisodename}}"||[[Category:Bad video reference]]}}|{{#if:{{#var:videorowcode}}|{{VideoName|{{#var:videorowcode}}}}|}}}}|}}
 
|style="vertical-align:top"}}|{{#if: {{{title|}}} | '''"{{{title}}}"'''<br> | }}{{{comment|}}}
 
|style="vertical-align:top"}}|{{#if: {{{title|}}} | '''"{{{title}}}"'''<br> | }}{{{comment|}}}
 
{{#if:{{#var:ratingrow}}|{{ConvertRating|{{#if:{{{ratingsystem|}}}|{{{ratingsystem}}}|{{GetDefaultRatingSystem|{{#var:videorowcode}}|{{#var:videorowepisodeno}}}}}}|{{{rating|}}}|issue={{#var:videorowepisodeno}}}}
 
{{#if:{{#var:ratingrow}}|{{ConvertRating|{{#if:{{{ratingsystem|}}}|{{{ratingsystem}}}|{{GetDefaultRatingSystem|{{#var:videorowcode}}|{{#var:videorowepisodeno}}}}}}|{{{rating|}}}|issue={{#var:videorowepisodeno}}}}
Line 37: Line 120:
 
_table = ratings
 
_table = ratings
 
|code={{#var:videorowcode}}
 
|code={{#var:videorowcode}}
 +
|issue={{#var:videorowepisodeno}}
 +
|pdfpage={{#replace:{{#var:timestamp}}|:|}}
 
|version={{{version|}}}
 
|version={{{version|}}}
−
|name={{#titleparts:{{PAGENAME}}|-1}}
+
|name={{FormatSQL|{{#titleparts:{{PAGENAME}}|-1}}}}
 
|format={{#var:format}}
 
|format={{#var:format}}
 
|score={{#var:score}}
 
|score={{#var:score}}
 
}}|}}|}}
 
}}|}}|}}
−
|-{{#vardefine:date|}}{{#vardefine:filename|}}{{#vardefine:videoname|}}{{#vardefine:country|}}{{#vardefine:episodename|}}{{#vardefine:videorowcode|}}{{#vardefine:score|}}</includeonly><noinclude>
+
|-{{#vardefine:cargodate|}}{{#vardefine:cargotime|}}{{#vardefine:cargofilename|}}{{#vardefine:cargovideoname|}}{{#vardefine:cargocountry|}}{{#vardefine:cargoepisodename|}}{{#vardefine:videorowcode|}}{{#vardefine:score|}}{{#vardefine:cargovideo|}}</includeonly><noinclude>
 +
 
  
−
[[Category:Sega Retro templates]]</noinclude>
+
{{Videotable|format=MD|
 +
{{videorow|gamesmastertv|1x01|33:33
 +
| title=
 +
| comment=
 +
| rating=51
 +
}}
 +
{{videorow|digitiser|1995-12-20|x72
 +
| title=
 +
| comment=
 +
| rating=51
 +
}}
 +
{{videorow|thezone|1x03|6:53
 +
| title=
 +
| comment=
 +
| version=
 +
| rating=72
 +
}}
 +
{{videorow|buzz|1990-06-29|5683
 +
| title=
 +
| comment=
 +
| version=
 +
| rating=69
 +
}}
 +
{{videorow|FX|1992-01-24|5683
 +
| title=
 +
| comment=
 +
| version=
 +
| rating=69
 +
}}
 +
}}
 +
[[Category:Templates]]</noinclude>

Latest revision as of 08:37, 27 January 2024



Back to: [[]].
episodenamesMore... episodenamesMore... No results
File Date and time Source Title and comments
Video Placeholder.svg 1992-01-07, 24:00 (+ 33:33) GamesMaster (UK), "Series 1, episode 1"
Review
Version Rating Awards Calculated score
51%
51
[Info]
  • 1
  • 2
Digitiser Madden96 MD Review Page1.png
Digitiser Madden96 MD Review Page2.png
 1995-12-20 Digitiser (UK), page x72
Review
Version Rating Awards Calculated score
51%
51
[Info]
Video Placeholder.svg 1994-05-14, (+ 6:53) The Zone (AU), "Season 1, episode 3"

Review
Version Rating Awards Calculated score
72%
72
[Info]
  • 1
  • 2
  • 3
Buzz UK 1990-06-29 568 3.png
Buzz UK 1990-06-29 568 4.png
Buzz UK 1990-06-29 568 5.png
 1990-06-29 Buzz! Computers (UK), page 5683
Review
Version Rating Awards Calculated score
69%
69
[Info]
, (+ 5683) FX (UK)
Review
Version Rating Awards Calculated score
69%
69
[Info]
Retrieved from "https://segaretro.org/index.php?title=Template:Videorow&oldid=955680"