Difference between revisions of "Charts"

From Sega Retro

 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{{#vardefine:name|{{{name|{{#replace:{{#titleparts:{{PAGENAME}}}}|/Reception|}}}}}}}
+
<includeonly>{{#vardefine:name|{{FormatSQL|{{{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
Line 11: Line 11:
 
{{#var:results}}
 
{{#var:results}}
 
{{!}}}
 
{{!}}}
}}{{clearvar|results|oldchartname}}<noinclude>
+
}}{{clearvar|results|oldchartname}}</includeonly><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. Game name is inferred unless specified.
  

Latest revision as of 17: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