Difference between revisions of "SoundDriverList"
From Sega Retro
(8 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | <includeonly>{{#if:{{{1|}}}|{{#cargo_query: | + | <includeonly>{{#vardefine:soundCount|0}}{{#vardefine:soundDriverlist|{{#if:{{{1|}}}|{{#cargo_query: |
tables=sound,releases | tables=sound,releases | ||
|fields=releases.name,releases.date | |fields=releases.name,releases.date | ||
− | |where=sound.driver | + | |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. | + | |order by=releases._pageName |
|group by=releases._pageName | |group by=releases._pageName | ||
|format=template | |format=template | ||
|template=SoundDriverList/Cargo | |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. | }}</includeonly><noinclude>Template for listing games which use a specific sound driver. | ||
e.g. | e.g. | ||
− | <pre>{{SoundDriverList| | + | <pre>{{SoundDriverList|A.U.D.I.O.S. Wave Slave MD|MD}}</pre> |
− | [[Category: | + | {{SoundDriverList|A.U.D.I.O.S. Wave Slave MD|MD}} |
+ | |||
+ | [[Category:Templates]]</noinclude> |
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}}
- Jim Power: The Lost Dimension in 3-D (2021)
- Mega Turrican (1994)
- Jim Power: The Arcade Game (unreleased)
- Mega Bomberman: Special 8 Player Demo (unreleased)
- Mr. Nutz: Hoppin' Mad (unreleased)