Difference between revisions of "Charts"

From Sega Retro

 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{IncompleteTemplate}}
+
<includeonly>{{#vardefine:name|{{FormatSQL|{{{name|{{#replace:{{#titleparts:{{PAGENAME}}}}|/Reception|}}}}}}}}}
{{#vardefine:name|{{{name|{{#replace:{{#titleparts:{{PAGENAME}}}}|/Reception|}}}}}}}
 
 
{{#vardefine:results|{{#cargo_query:
 
{{#vardefine:results|{{#cargo_query:
 
table=salescharts
 
table=salescharts
 
|fields=date,chartname,position
 
|fields=date,chartname,position
|where=gamename="{{#var:name}}" and format="{{{1}}}"
+
|where=({{SQLAllNames|gamename|{{#var:name}}}}) and format="{{{1}}}"
 
|order by=chartname,date
 
|order by=chartname,date
 
|format=template
 
|format=template
 
|template=Charts/Cargo
 
|template=Charts/Cargo
 +
|default=
 
}}}}{{#if:{{#var:results}}|
 
}}}}{{#if:{{#var:results}}|
 
{{#var:results}}
 
{{#var:results}}
|}
+
{{!}}}
}}{{clearvar|results|oldchartname}}
+
}}{{clearvar|results|oldchartname}}</includeonly><noinclude>
<noinclude>
+
An automatically generated record of how a game charted in the 3249802343 software charts across the globe. Game name is inferred unless specified.
An automatically generated record of how a game charted in the 3249802343 software charts across the globe.
 
  
Not sure how to handle this yet -[[User:Black Squirrel|Black Squirrel]] ([[User talk:Black Squirrel|talk]]) 04:02, 20 August 2020 (EDT)
+
==Example==
 
+
<pre>{{Charts|DC|name=Virtua Tennis}}</pre>
 
+
{{Charts|DC|name=Virtua Tennis}}
 
+
[[Category:Templates]]</noinclude>
{{Charts|DC|name=Crazy Taxi 2}}
 
[[Category:Sega Retro templates]]</noinclude>
 

Latest revision as of 16:09, 22 May 2022

An automatically generated record of how a game charted in the 3249802343 software charts across the globe. Game name is inferred unless specified.

Example

{{Charts|DC|name=Virtua Tennis}}

Dreamcast French charts

Date Position

2001-07

4

Dreamcast German charts

Date Position

2000-09

1

2000-10

2

2000-11

2

2000-12

5

2001-01

2

2001-02

4

2001-03

8

Dreamcast Spanish charts

Date Position

2001-02

3

Dreamcast Spanish charts (units)

Date Position

2001-03

4

2001-04

2

2001-05

2

2001-06

3

Dreamcast Spanish charts (value)

Date Position

2001-03

3

2001-04

5

2001-05

2

2001-06

3