Difference between revisions of "SoundDriverList"

From Sega Retro

Line 2: Line 2:
 
tables=sound,releases
 
tables=sound,releases
 
|fields=releases.name,releases.date
 
|fields=releases.name,releases.date
|where=sound.driver LIKE '%{{{1}}}%' and releases.console="{{{2}}}"
+
|where=sound.driver LIKE '%{{FormatSQL|{{{1}}}}}%' and releases.console="{{{2}}}"
 
|join on=sound._pageName=releases._pageName
 
|join on=sound._pageName=releases._pageName
 
|order by=releases._pageName
 
|order by=releases._pageName
Line 9: Line 9:
 
|template=SoundDriverList/Cargo
 
|template=SoundDriverList/Cargo
 
|limit=1000
 
|limit=1000
 +
|default=
 
}}{{#cargo_query:
 
}}{{#cargo_query:
 
tables=sound,unreleased
 
tables=sound,unreleased
 
|fields=unreleased.name
 
|fields=unreleased.name
|where=sound.driver LIKE '%{{{1}}}%' and unreleased.format="{{Code2Format|{{{2}}}}}"
+
|where=sound.driver LIKE '%{{FormatSQL|{{{1}}}}}%' and unreleased.format="{{Code2Format|{{{2}}}}}"
 
|join on=sound._pageName=unreleased._pageName
 
|join on=sound._pageName=unreleased._pageName
 
|order by=unreleased._pageName
 
|order by=unreleased._pageName
Line 26: Line 27:
 
<pre>{{SoundDriverList|A.U.D.I.O.S. Wave Slave MD|MD}}</pre>
 
<pre>{{SoundDriverList|A.U.D.I.O.S. Wave Slave MD|MD}}</pre>
 
{{SoundDriverList|A.U.D.I.O.S. Wave Slave MD|MD}}
 
{{SoundDriverList|A.U.D.I.O.S. Wave Slave MD|MD}}
 +
 
[[Category:Templates]]</noinclude>
 
[[Category:Templates]]</noinclude>

Revision as of 16:47, 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}}