Difference between revisions of "Charts"

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.

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

Date	Position
2001-07	4

Date	Position
2001-02	3

@@ 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:
-{{#cargo_query:
 table=salescharts
 |fields=date,chartname,position
-|where=gamename="{{#var:name}}" and format="{{{1}}}"
+|where=({{SQLAllNames|gamename|{{#var:name}}}}) and format="{{{1}}}"
 |order by=chartname,date
-}}
+|format=template
-<noinclude>
+|template=Charts/Cargo
-An automatically generated record of how a game charted in the 3249802343 software charts across the globe.
+|default=
+}}}}{{#if:{{#var:results}}|
+{{#var:results}}
+{{!}}}
+}}{{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.
-Not sure how to handle this yet -[[User:Black Squirrel|Black Squirrel]] ([[User talk:Black Squirrel|talk]]) 04:02, 20 August 2020 (EDT)
+==Example==
-[[Category:Sega Retro templates]]</noinclude>
+<pre>{{Charts|DC|name=Virtua Tennis}}</pre>
+{{Charts|DC|name=Virtua Tennis}}
+[[Category:Templates]]</noinclude>