Difference between revisions of "OmniPrereleases"
From Sega Retro
| (18 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | <includeonly><div style="display:none;">{{#vardefine:gamename|{{{1|}}}}} | |
| − | |||
| − | |||
| − | {{#vardefine:gamename| | ||
| − | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=prototypes,codeformat | tables=prototypes,codeformat | ||
| Line 9: | Line 5: | ||
|join on=prototypes.format=codeformat.format | |join on=prototypes.format=codeformat.format | ||
|orderby=format,date | |orderby=format,date | ||
| − | |where=final="{{#var:gamename}}" | + | |group by=prototypes.name |
| + | |where=final="{{FormatSQL|{{#var:gamename}}}}" | ||
|format=template | |format=template | ||
|template=OmniPrereleases/Cargo | |template=OmniPrereleases/Cargo | ||
}} | }} | ||
| − | + | </div> | |
| − | + | {{#vardefine:output|<!--loop through systems--> | |
| − | {{#var:systems}} | + | {{#vardefine:j|0}}{{#while: |
| − | + | | {{#if:{{#explode:{{#var:systems}}|,|{{#var:j}}}}|true}} | |
| − | + | | <div style="display:inline;">{{#vardefine:newsystem|yes}}{{#vardefine:currentsystem|{{#explode:{{#var:systems}}|,|{{#var:j}}}}}} | |
| − | {{#var: | + | <!--loop through prototypes-->{{#vardefine:i|0}}{{ |
| − | + | #while: | |
| − | {{#vardefine:i|0}} | + | | {{#if:{{#explode:{{#var:names_{{#var:currentsystem}}}}|¦|{{#var:i}}}}|true}} |
| − | {{#while: | + | | {{#vardefine:output|{{#explode:{{UnformatSQL|{{#var:names_{{#var:currentsystem}}}}}}|¦|{{#var:i}}}}}} |
| − | | {{#if:{{#explode:{{#var: | + | {{#if:{{#var:newsystem}}|{{#ifexpr:{{#var:j}}>0|<br/>}}{{#vardefine:lastyear|aaaa}}{{#vardefine:currentyear|bbbb}}{{ {{#var:currentsystem}} }} '''Prototypes:'''{{#vardefine:newsystem|}}}} [[{{#var:gamename}} ({{#var:output}})|{{OmniPrereleases/FormatName|{{#var:output}}}}]] {{#if:{{#explode:{{#var:names_{{#var:currentsystem}}}}|¦|{{#expr:{{#var:i}}+1}}}}|{{!}}<nowiki> </nowiki>|}} |
| − | | {{#vardefine:output|{{#explode:{{#var: | ||
| − | |||
| − | |||
| − | |||
{{incvar|i}} | {{incvar|i}} | ||
| + | }}</div>{{incvar|j}}{{clearvar|names_{{#var:currentsystem}}}} | ||
| + | }}}}{{#if:{{#var:output}}|{{#var:output}}|}}{{clearvar|output}}</includeonly><noinclude> | ||
| + | (Partially) automated section of [[Template:Omni]] used to display prototypes. Information comes from [[Template:Rom]]. | ||
| − | }} | + | ==Examples== |
| − | + | <pre>{{OmniPrereleases|Taz in Escape from Mars}}</pre> | |
| − | {{ | + | {{OmniPrereleases|Taz in Escape from Mars}} |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | <pre>{{OmniPrereleases|World Series Baseball '95 (Mega Drive)}}</pre> | |
| − | {{ | + | {{OmniPrereleases|World Series Baseball '95 (Mega Drive)}} |
| − | }} | ||
| − | [[Category:Templates]] | + | [[Category:Templates]]</noinclude> |
Latest revision as of 07:28, 2 January 2023
(Partially) automated section of Template:Omni used to display prototypes. Information comes from Template:Rom.
Examples
{{OmniPrereleases|Taz in Escape from Mars}}
{{OmniPrereleases|World Series Baseball '95 (Mega Drive)}}