Difference between revisions of "Videorow"
From Sega Retro
| Line 1: | Line 1: | ||
| − | |- | + | <includeonly><span style="display:none;">{{#vardefine:videorowcode|{{{1|}}}}}{{#vardefine:videorowepisodeno|{{{2|}}}}}{{#vardefine:timestamp|{{{3|}}}}}{{#cargo_query: |
| − | |style="vertical-align:top | + | tables=issuenames,magnames |
| − | |style="vertical-align:top;"|{{{ | + | |fields=issuenames.name=issuename,issuenames.date,issuenames.pdf,magnames.name=magname,magnames.country,magnames.link |
| − | + | |where=issuenames.code="{{#var:videorowcode}}" and issuenames.num="{{#var:videorowepisodeno}}" | |
| + | |join on=issuenames.code=magnames.code | ||
| + | |limit=1 | ||
| + | |format=template | ||
| + | |template=magref/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}} | ||
| + | |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: {{{title|}}} | '''"{{{title}}}"'''<br> | }}{{{comment|}}} | ||
| + | {{#if:{{#var:ratingrow}}|{{ConvertRating|{{#if:{{{ratingsystem|}}}|{{{ratingsystem}}}|{{GetDefaultRatingSystem|{{#var:videorowcode}}|{{#var:videorowepisodeno}}}}}}|{{{rating|}}}|issue={{#var:videorowepisodeno}}}} | ||
| + | {{{!}} style="margin-bottom:0px;" | ||
| + | {{!}}+Review | ||
| + | !width="25%"{{!}}Version | ||
| + | !width="25%"{{!}}Rating | ||
| + | !width="25%"{{!}}Awards | ||
| + | !width="25%"{{!}}Calculated score | ||
| + | {{!}}- | ||
| + | {{!}}style="vertical-align:top; padding-bottom:0px;"{{!}}{{{version|}}}{{#if:{{{versioncomments|}}}| | ||
| + | <br /><small>{{{versioncomments|}}}</small>|}} | ||
| + | {{!}}style="vertical-align:top; padding-bottom:0px;"{{!}}{{#var:displayRating}}{{#if:{{{ratingcomments|}}}| | ||
| + | <br /><small>{{{ratingcomments|}}}</small>|}} | ||
| + | {{!}}style="vertical-align:top; padding-bottom:0px;"{{!}}{{#if:{{{awards|}}}|{{ | ||
| + | #vardefine:award1|{{#explode:{{{awards|}}}|,|0}}}}{{ | ||
| + | #vardefine:award2|{{#explode:{{{awards|}}}|,|1}}}}{{ | ||
| + | #if:{{#var:award1}}|{{AwardImage|{{#var:videorowcode}}|{{#var:award1}}|issue={{#var:videorowepisodeno}}}}|}}{{#if:{{#var:award2}}| {{AwardImage|{{#var:videorowcode}}|{{#var:award2}}|issue={{#var:videorowepisodeno}}}}|}}{{#if:{{{awardscomments|}}}| | ||
| + | <br /><small>{{{awardscomments|}}}</small>|}}}} | ||
| + | {{!}}style="vertical-align:top; padding-bottom:0px;"{{!}} | ||
| + | {{{!}} style="float:left; width:35px; margin-right:6px;" | ||
| + | {{!}}style="{{scoreColour|{{#var:score}}}} text-align:center; font-weight:bold;"{{!}}{{#if:{{#var:score}}|{{#expr:{{#var:score}} round 0}}|??}} | ||
| + | {{!}}}<sup>[[Sega Retro:Ratings|[Info]]]</sup> | ||
| + | {{!}}}{{#if:{{#var:score}}|{{#cargo_store: | ||
| + | _table = ratings | ||
| + | |code={{#var:videorowcode}} | ||
| + | |version={{{version|}}} | ||
| + | |name={{#titleparts:{{PAGENAME}}|-1}} | ||
| + | |format={{#var:format}} | ||
| + | |score={{#var:score}} | ||
| + | }}|}}|}} | ||
| + | |-{{#vardefine:date|}}{{#vardefine:filename|}}{{#vardefine:videoname|}}{{#vardefine:country|}}{{#vardefine:episodename|}}{{#vardefine:videorowcode|}}{{#vardefine:score|}}</includeonly><noinclude> | ||
| + | |||
| + | [[Category:Sega Retro templates]]</noinclude> | ||