Difference between revisions of "Charts"

From Sega Retro

 
(3 intermediate revisions 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
 
|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. Game name is inferred unless specified.
  
Line 17: Line 17:
 
<pre>{{Charts|DC|name=Virtua Tennis}}</pre>
 
<pre>{{Charts|DC|name=Virtua Tennis}}</pre>
 
{{Charts|DC|name=Virtua Tennis}}
 
{{Charts|DC|name=Virtua Tennis}}
[[Category:Sega Retro templates]]</noinclude>
+
[[Category: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