Difference between revisions of "ReleaseTest2"

From Sega Retro

 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
<includeonly>{{#vardefine:name|{{#if:{{{name|}}}|{{{name|}}}|{{PAGENAME}}}}}}{{#vardefine:localname|{{GetLocalisedName|{{#var:name}}|{{{2|}}}}}}}{{#vardefine:localname2|{{GetLocalisedName|{{#var:name}}|{{{2|}}}|name2=yes}}}}{{#cargo_query:
+
<includeonly>{{#vardefine:name|{{#if:{{{name|}}}|{{{name|}}}|{{PAGENAME}}}}}}{{incvar|releaseID}}{{#vardefine:region|{{#explode:{{{2|}}}|_|0}}}}{{#vardefine:regionextra|{{#explode:{{{2|}}}|_|1}}}}{{#vardefine:localname|{{GetLocalisedName|{{#var:name}}|{{{2|}}}}}}}{{#vardefine:localname2|{{GetLocalisedName|{{#var:name}}|{{{2|}}}|name2=yes}}}}{{#cargo_query:
 
table=releases
 
table=releases
 
|fields=date,rrp,code,code2,rating
 
|fields=date,rrp,code,code2,rating
Line 9: Line 9:
 
{| class="breakout" style="width:auto; min-width:600px;"
 
{| class="breakout" style="width:auto; min-width:600px;"
 
|style="vertical-align:top; width:25%"|'''Region:'''
 
|style="vertical-align:top; width:25%"|'''Region:'''
|{{flag|{{{2|}}}|border=silver}} {{CountryCode2Country|{{{2|}}}}}
+
|style="vertical-align:top;"|{{flag|{{#var:region}}|border=silver}} {{CountryCode2Country|{{#var:region}}}}
|rowspan="100" style="vertical-align:top; width:190px;"|{{#if:{{{image|}}}|{{#vardefine:image|{{{image|}}}}}|{{#vardefine:image|{{GetCoverScan|{{#var:name}}|{{Code2Format|{{{1|}}}}}|{{{2|}}}}}}}|}}{{
+
|rowspan="100" style="vertical-align:top; width:190px;"|{{#if:{{{image|}}}|{{#vardefine:image|{{{image|}}}}}|{{#vardefine:image|{{GetCoverScan|{{#var:name}}|{{Code2Format|{{{1|}}}}}|{{#var:region}} {{#if:{{#var:regionextra}}|({{#var:regionextra}})|}} }}}}|}}{{
 
#if:{{#var:image}}|{{#ifexpr:{{#mediawidth:{{#var:image}}}} > {{#mediaheight:{{#var:image}}}}|{{#vardefine:ratio|{{#expr:{{#mediawidth:{{#var:image}}}}/{{#mediaheight:{{#var:image}}}}}}}}<div style="width:{{#expr:200 * {{#var:ratio}}}}px; clip-path: inset(0px 0px 0px 170px); margin-left:-150px; margin-bottom:-200px;">[[File:{{#var:image}}|x200px]]</div>|[[File:{{#var:image}}|x200px]]}}|[[File:Notavailable.svg|200px]]}}
 
#if:{{#var:image}}|{{#ifexpr:{{#mediawidth:{{#var:image}}}} > {{#mediaheight:{{#var:image}}}}|{{#vardefine:ratio|{{#expr:{{#mediawidth:{{#var:image}}}}/{{#mediaheight:{{#var:image}}}}}}}}<div style="width:{{#expr:200 * {{#var:ratio}}}}px; clip-path: inset(0px 0px 0px 170px); margin-left:-150px; margin-bottom:-200px;">[[File:{{#var:image}}|x200px]]</div>|[[File:{{#var:image}}|x200px]]}}|[[File:Notavailable.svg|200px]]}}
 
|-
 
|-
|style="vertical-align:top;"|'''Name:'''
+
|style="vertical-align:top;"|'''Name:'''{{
|''[[{{#var:name}}|{{#if:{{{nameoverride|}}}|{{{nameoverride|}}}|{{#if:{{#var:localname}}|{{#var:localname}}|{{#var:name}}}}}}]]''{{#if:{{{name2|}}}{{#var:localname2}}|<br/>{{#if:{{{name2|}}}|{{{name2}}}|{{#var:localname2}}}}|}}{{
+
#vardefine:releasename|{{#if:{{{nameoverride|}}}|{{{nameoverride|}}}|{{#if:{{#var:localname}}|{{#var:localname}}|{{#var:name}}}}}}}}{{
 +
#vardefine:releasename2|{{#if:{{{name2|}}}|{{{name2}}}|{{#var:localname2}}}}}}
 +
|style="vertical-align:top;"|''[[{{#var:name}}|{{#var:releasename}}]]''{{#if:{{#var:releasename2}}|<br/>{{#var:releasename2}}|}}{{
 
#if:{{{distributor|}}}|
 
#if:{{{distributor|}}}|
 
<nowiki></nowiki>
 
<nowiki></nowiki>
 
{{!}}-
 
{{!}}-
 
{{!}}style="vertical-align:top;"{{!}}'''Distributor:'''
 
{{!}}style="vertical-align:top;"{{!}}'''Distributor:'''
{{!}}[[{{{distributor|}}}]]
+
{{!}}style="vertical-align:top;"{{!}}[[{{{distributor|}}}]]
 +
}}{{
 +
#if:{{{label|}}}|
 +
<nowiki></nowiki>
 +
{{!}}-
 +
{{!}}style="vertical-align:top;"{{!}}'''Publishing label:'''
 +
{{!}}style="vertical-align:top;"{{!}}[[{{{label|}}}]]
 
}}
 
}}
 
|-
 
|-
 
|style="vertical-align:top;"|'''Dates and RRPs:'''
 
|style="vertical-align:top;"|'''Dates and RRPs:'''
|{{DatePrice|{{{2|}}}|{{#var:cargoRRP}}|{{#var:cargoDate}}|nocountry=yes}}
+
|style="vertical-align:top;"|{{DatePrice|{{{2|}}}|{{#var:cargoRRP}}|{{#var:cargoDate}}|nocountry=yes}}
 
|-
 
|-
 
|style="vertical-align:top;"|'''Product codes:'''
 
|style="vertical-align:top;"|'''Product codes:'''
|{{#var:cargoCode}}{{#if:{{#var:cargoCode2}}|<br/>{{#var:cargoCode2}}|}}{{
+
|style="vertical-align:top;"|{{#var:cargoCode}}{{#if:{{#var:cargoCode2}}|<br/>{{#var:cargoCode2}}|}}{{
 
#if:{{#var:cargoRating}}|
 
#if:{{#var:cargoRating}}|
<nowiki></nowiki>
+
<nowiki></nowiki><!--yes this is a terrible way to get information-->{{#vardefine:ratingimg|{{minirating|region={{{2|}}}|rating={{#var:cargoRating}}|date={{#var:cargoDate}}|size=50}}}}{{
 +
#vardefine:imgposstart|{{#pos:{{#var:ratingimg}}|[}}}}{{
 +
#vardefine:imgposend|{{#pos:{{#var:ratingimg}}|]}}}}{{
 +
#vardefine:imgcontents|{{#sub:{{#var:ratingimg}}|{{#expr:{{#var:imgposstart}}+2}}|{{#expr:{{#var:imgposend}}-({{#var:imgposstart}}+2)}}}}}}{{
 +
#vardefine:imgcontents|{{#explode:{{#var:imgcontents}}|{{!}}|2}}}}
 
{{!}}-
 
{{!}}-
{{!}}style="vertical-align:top;"{{!}}'''[[ESRB]] Rating:'''
+
{{!}}style="vertical-align:top;"{{!}}'''[[{{#explode:{{#var:imgcontents}}|:|0}}]] Rating:'''
{{!}}{{float|{{minirating|region={{{2|}}}|rating={{#var:cargoRating}}|date={{#var:cargoDate}}|size=50}}|direction=left}}&nbsp;'''Everyone 10+'''<br/>{{{ratingdesc|}}}
+
{{!}}style="vertical-align:top;"{{!}}{{float|{{#var:ratingimg}}|direction=left}}&nbsp;'''{{#explode:{{#var:imgcontents}}|:|1}}'''<br/>{{{ratingdesc|}}}
 
}}{{
 
}}{{
#if:{{{upc|}}}|
+
#if:{{{barcode|}}}|
 
<nowiki></nowiki>
 
<nowiki></nowiki>
 
{{!}}-
 
{{!}}-
{{!}}style="vertical-align:top;"{{!}}'''UPC:'''
+
{{!}}style="vertical-align:top;"{{!}}'''Barcode:'''
{{!}}{{{upc|}}}
+
{{!}}style="vertical-align:top;"{{!}}{{Barcode|{{{barcode|}}}|size=1.5|height=70}}
 
}}{{
 
}}{{
 
#if:{{{comments|}}}|
 
#if:{{{comments|}}}|
Line 43: Line 55:
 
{{!}}-
 
{{!}}-
 
{{!}}style="vertical-align:top;"{{!}}'''Comments:'''
 
{{!}}style="vertical-align:top;"{{!}}'''Comments:'''
{{!}}{{{comments|}}}
+
{{!}}style="vertical-align:top;"{{!}}{{{comments|}}}
 +
}}
 +
|}{{StoreReleasesExtra|region|{{#var:region}}}}{{
 +
StoreReleasesExtra|image|{{#var:image}}}}{{
 +
StoreReleasesExtra|releasename|{{#var:releasename}}}}{{
 +
StoreReleasesExtra|releasename2|{{#var:releasename2}}}}{{
 +
StoreReleasesExtra|distributor|{{{distributor|}}}}}{{
 +
StoreReleasesExtra|label|{{{label|}}}}}{{
 +
StoreReleasesExtra|format|{{{1|}}}}}{{
 +
StoreReleasesExtra|rrp|{{#var:cargoRRP}}}}{{
 +
StoreReleasesExtra|date|{{#var:cargoDate}}}}{{
 +
StoreReleasesExtra|rating|{{#var:cargoRating}}}}{{
 +
StoreReleasesExtra|ratingdesc|{{{ratingdesc|}}}}}{{
 +
StoreReleasesExtra|barcode|{{{barcode|}}}}}{{
 +
StoreReleasesExtra|comments|{{{comments|}}}}}{{
 +
clear}}{{clearvar|name|releasename|releasename2|localname|cargoRRP|cargoDate|cargoRating|image}}</includeonly><noinclude>
 +
{{#cargo_declare:
 +
_table=releasesextra
 +
|name=Text
 +
|releaseid=Text
 +
|type=Text
 +
|value=Text
 
}}
 
}}
|}{{clear}}{{clearvar|name|localname|image}}
+
 
</includeonly><noinclude>
 
 
Sergei it's all automated.
 
Sergei it's all automated.
 
{{ReleaseTest2|name=James "Buster" Douglas Knockout Boxing (Mega Drive)|MD|JP|
 
{{ReleaseTest2|name=James "Buster" Douglas Knockout Boxing (Mega Drive)|MD|JP|
 
| distributor=Sega of America
 
| distributor=Sega of America
 +
| label=Kixx
 
| ratingdesc=Mild peril. Extreme violence.
 
| ratingdesc=Mild peril. Extreme violence.
| upc=1-2345-6789-0
+
| barcode=123456789012
 
| comments=Only sold in Toys 'R' Us. Cursed by the gods.
 
| comments=Only sold in Toys 'R' Us. Cursed by the gods.
 
}}
 
}}
Line 65: Line 98:
 
{{ReleaseTest2|name=Comix Zone|MD|US}}
 
{{ReleaseTest2|name=Comix Zone|MD|US}}
 
{{ReleaseTest2|name=Comix Zone|MD|UK}}
 
{{ReleaseTest2|name=Comix Zone|MD|UK}}
 +
 +
 +
{{ReleaseTest2|name=Action Fighter|C64|UK_Kixx}}
  
 
[[Category:Templates]]</noinclude>
 
[[Category:Templates]]</noinclude>

Latest revision as of 13:11, 1 July 2023

This template defines the table "releasesextra". View table.

Sergei it's all automated. No results

Region: Japan Japan
JBDKOB MD JP Box.jpg
Name: James "Buster" Douglas Knockout Boxing (Mega Drive)
Distributor: Sega of America
Publishing label: Kixx
Dates and RRPs:
()
Product codes:
Barcode:




}}

1 2 3 4 5 6 7 8 9 0 1 2
Comments: Only sold in Toys 'R' Us. Cursed by the gods.



Region: Japan Japan
VirtuaTennis3 PS3 JP cover.jpg
Name: Power Smash 3
パワースマッシュ3
Dates and RRPs:
¥6,980 (7,329)6,980 (7,329) (2007-03-08)
Product codes: BLJM-60017
CERO Rating:
CERO: A
  A


Region: United States of America United States of America
VT3 PS3 US Box.jpg
Name: Virtua Tennis 3
Dates and RRPs:
(2007-03-20)
Product codes: BLUS-30021
ESRB Rating:
ESRB: Everyone
  Everyone


Region: United Kingdom United Kingdom
VirtuaTennis3 PS3 UK Box Back.jpg
Name: Virtua Tennis 3
Dates and RRPs:
(2007-03-23)
Product codes: BLES-00027
PEGI Rating:
PEGI: 3+
  3+


Region: Germany Germany VirtuaTennis3 PS3 DE Box.jpg
Name: Virtua Tennis 3
Dates and RRPs:
(2007-03-23)
Product codes: BLES-00027
USK Rating:
USK: 0
  0


Region: Australia Australia VirtuaTennis3 PS3 AU Box.jpg
Name: Virtua Tennis 3
Dates and RRPs:
(2007-03-23)
Product codes: BLES-00027
OFLC Rating:
OFLC: General (G)
  General (G)



Region: United States of America United States of America ComixZone MD US Box Front.jpg
Name: Comix Zone
Dates and RRPs:
$69.9969.99 (1995-07)
Product codes: 1569
ESRB Rating:
ESRB: Kids to Adults
  Kids to Adults


Region: United Kingdom United Kingdom
ComixZone MD UK cover.jpg
Name: Comix Zone
Dates and RRPs:
£44.9944.99 (1995-10-06)
Product codes: 1569-50
ELSPA Rating:
ELSPA: 3+ OK
  3+ OK



Region: United Kingdom United Kingdom ActionFighter C64 UK Box Kixx.jpg
Name: Action Fighter
Dates and RRPs:
(19xx)
Product codes: