Difference between revisions of "Charts"
From Sega Retro
| (5 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 | + | |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. | ||
==Example== | ==Example== | ||
| − | <pre>{{Charts|DC|name= | + | <pre>{{Charts|DC|name=Virtua Tennis}}</pre> |
| − | {{Charts|DC|name= | + | {{Charts|DC|name=Virtua Tennis}} |
| − | [[Category: | + | [[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.
Contents
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 |