Difference between revisions of "SoundDriverList"

Latest revision as of 16:58, 3 May 2023

Template for listing games which use a specific sound driver.

e.g.

{{SoundDriverList|A.U.D.I.O.S. Wave Slave MD|MD}}

@@ Line 1: / Line 1: @@
-<includeonly>{{#if:{{{1|}}}|{{#cargo_query:
+<includeonly>{{#vardefine:soundCount|0}}{{#vardefine:soundDriverlist|{{#if:{{{1|}}}|{{#cargo_query:
 tables=sound,releases
 |fields=releases.name,releases.date
-|where=sound.driver="{{{1}}}" and releases.console="{{{2}}}"
+|where=sound.driver LIKE '%{{FormatSQL|{{{1}}}}}%' and releases.console="{{{2}}}"
 |join on=sound._pageName=releases._pageName
-|order by=releases.date
+|order by=releases._pageName
 |group by=releases._pageName
 |format=template
 |template=SoundDriverList/Cargo
+|limit=1000
+|default=
+}}{{#cargo_query:
+tables=sound,unreleased
+|fields=unreleased.name
+|where=sound.driver LIKE '%{{FormatSQL|{{{1}}}}}%' and unreleased.format="{{Code2Format|{{{2}}}}}"
+|join on=sound._pageName=unreleased._pageName
+|order by=unreleased._pageName
+|group by=unreleased._pageName
+|format=template
+|template=SoundDriverList/Cargo2
+|limit=1000
+|default=
 }}
-}}</includeonly><noinclude>
+}}}}{{multicol|
-{{SoundDriverList|SMPS Z80|MD}}
+{{#var:soundDriverlist}}
-[[Category:Sega Retro templates]]
+|cols={{MulticolColumnCalc|{{#var:soundCount}}}}
-</noinclude>
+}}</includeonly><noinclude>Template for listing games which use a specific sound driver.
+e.g.
+<pre>{{SoundDriverList|A.U.D.I.O.S. Wave Slave MD|MD}}</pre>
+{{SoundDriverList|A.U.D.I.O.S. Wave Slave MD|MD}}
+[[Category:Templates]]</noinclude>