Difference between revisions of "BulletPointBootlegList"

From Sega Retro

(Created page with "<includeonly>{{#vardefine:i|0}}{{#vardefine:contents|{{#cargo_query: table=bootlegs |fields=pagename,name,name2 |where=distributor="{{FormatSQL|{{{1|{{PAGENAME}}}}}}}" |limit=...")
 
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
<includeonly>{{#vardefine:i|0}}{{#vardefine:contents|{{#cargo_query:
+
<includeonly>{{#vardefine:i|0}}{{#if:{{{multicarts|}}}|{{#vardefine:multicarts|yes}}|{{clearvar|multicarts}}}}{{#vardefine:contents|{{#cargo_query:
−
table=bootlegs
+
table={{#if:{{#var:multicarts}}|multicarts|bootlegs}}
−
|fields=pagename,name,name2
+
|fields=pagename,name,name2,code
−
|where=distributor="{{FormatSQL|{{{1|{{PAGENAME}}}}}}}"
+
|where=distributor="{{FormatSQL|{{{1|{{PAGENAME}}}}}}}" and name != ""
 
|limit=10000
 
|limit=10000
 
|order by=name
 
|order by=name
−
|group by=pagename
+
|group by={{#if:{{#var:multicarts}}|name,code|pagename}}
 
|format=template
 
|format=template
 
|template=BulletPointBootlegList/Cargo
 
|template=BulletPointBootlegList/Cargo
Line 11: Line 11:
 
{{#var:contents}}
 
{{#var:contents}}
 
|cols={{MulticolColumnCalc|{{#var:i}}}}
 
|cols={{MulticolColumnCalc|{{#var:i}}}}
−
}}</includeonly><noinclude>
+
}}{{clearvar|multicarts}}</includeonly><noinclude>
 +
 
 +
==Examples==
 
<pre>{{BulletPointBootlegList|New Game}}</pre>
 
<pre>{{BulletPointBootlegList|New Game}}</pre>
 
{{BulletPointBootlegList|New Game}}
 
{{BulletPointBootlegList|New Game}}
 +
 +
<pre>{{BulletPointBootlegList|RGR Studio|multicarts=yes}}</pre>
 +
{{BulletPointBootlegList|RGR Studio|multicarts=yes}}
  
 
[[Category:Cargo templates]]</noinclude>
 
[[Category:Cargo templates]]</noinclude>

Latest revision as of 06:26, 8 June 2023


Examples

{{BulletPointBootlegList|New Game}}
{{BulletPointBootlegList|RGR Studio|multicarts=yes}}
Retrieved from "https://segaretro.org/index.php?title=Template:BulletPointBootlegList&oldid=893973"