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._pageName
@@ Line 8: / Line 8: @@
 |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=
 }}
+}}}}{{multicol|
+{{#var:soundDriverlist}}
+|cols={{MulticolColumnCalc|{{#var:soundCount}}}}
 }}</includeonly><noinclude>Template for listing games which use a specific sound driver.
 e.g.
-<pre>{{SoundDriverList|SMPS Z80|MD}}</pre>
+<pre>{{SoundDriverList|A.U.D.I.O.S. Wave Slave MD|MD}}</pre>
-[[Category:Sega Retro templates]]</noinclude>
+{{SoundDriverList|A.U.D.I.O.S. Wave Slave MD|MD}}
+[[Category:Templates]]</noinclude>