Difference between revisions of "OmniPrereleases"
From Sega Retro
(Created page with "{{TODO}} I reckon I can automate the prereleases section of the omni templates. Maybe. {{#cargo_query: tables=prototypes,codeformat |fields=prototypes.name,codeformat.code |...") |
|||
| (20 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | {{ | + | <includeonly><div style="display:none;">{{#vardefine:gamename|{{{1|}}}}} |
| − | |||
| − | |||
| − | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=prototypes,codeformat | tables=prototypes,codeformat | ||
| Line 8: | Line 5: | ||
|join on=prototypes.format=codeformat.format | |join on=prototypes.format=codeformat.format | ||
|orderby=format,date | |orderby=format,date | ||
| − | |where=final=" | + | |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--> | ||
| + | {{#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}}}}}} | ||
| + | <!--loop through prototypes-->{{#vardefine:i|0}}{{ | ||
| + | #while: | ||
| + | | {{#if:{{#explode:{{#var:names_{{#var:currentsystem}}}}|¦|{{#var:i}}}}|true}} | ||
| + | | {{#vardefine:output|{{#explode:{{UnformatSQL|{{#var:names_{{#var:currentsystem}}}}}}|¦|{{#var:i}}}}}} | ||
| + | {{#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>|}} | ||
| + | {{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)}}