Difference between revisions of "OmniPrereleases"

From Sega Retro

 
(16 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{TODO}}
+
<includeonly><div style="display:none;">{{#vardefine:gamename|{{{1|}}}}}
I reckon I can automate the prereleases section of the omni templates. Maybe.
 
 
 
{{#vardefine:gamename|Taz in Escape from Mars}}
 
 
 
 
{{#cargo_query:
 
{{#cargo_query:
 
tables=prototypes,codeformat
 
tables=prototypes,codeformat
Line 10: Line 6:
 
|orderby=format,date
 
|orderby=format,date
 
|group by=prototypes.name
 
|group by=prototypes.name
|where=final="{{#var:gamename}}"
+
|where=final="{{FormatSQL|{{#var:gamename}}}}"
 
|format=template
 
|format=template
 
|template=OmniPrereleases/Cargo
 
|template=OmniPrereleases/Cargo
 
}}
 
}}
 
+
</div>
<!--loop through systems-->
+
{{#vardefine:output|<!--loop through systems-->
{{#vardefine:j|0}}
+
{{#vardefine:j|0}}{{#while:
{{#while:
 
 
| {{#if:{{#explode:{{#var:systems}}|,|{{#var:j}}}}|true}}
 
| {{#if:{{#explode:{{#var:systems}}|,|{{#var:j}}}}|true}}
| {{#vardefine:newsystem|yes}}{{#vardefine:currentsystem|{{#explode:{{#var:systems}}|,|{{#var:j}}}}}}  
+
| <div style="display:inline;">{{#vardefine:newsystem|yes}}{{#vardefine:currentsystem|{{#explode:{{#var:systems}}|,|{{#var:j}}}}}}
 
+
<!--loop through prototypes-->{{#vardefine:i|0}}{{
<!--loop through prototypes-->
+
#while:
<div style="display:inline;">
 
{{#vardefine:i|0}}
 
{{#while:
 
 
| {{#if:{{#explode:{{#var:names_{{#var:currentsystem}}}}|¦|{{#var:i}}}}|true}}
 
| {{#if:{{#explode:{{#var:names_{{#var:currentsystem}}}}|¦|{{#var:i}}}}|true}}
| {{#vardefine:output|{{#explode:{{#var:names_{{#var:currentsystem}}}}|¦|{{#var:i}}}}}}
+
| {{#vardefine:output|{{#explode:{{UnformatSQL|{{#var:names_{{#var:currentsystem}}}}}}|¦|{{#var:i}}}}}}
{{#if:{{#var:newsystem}}|<br/>{{ {{#var:currentsystem}} }} Prototypes:{{#vardefine:newsystem|}}}} [[{{#var:gamename}} ({{#var:output}})|{{#var:output}}]] {{!}}<nowiki> </nowiki>
+
{{#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}}
 
{{incvar|i}}
}}
+
}}</div>{{incvar|j}}{{clearvar|names_{{#var:currentsystem}}}}
</div>
+
}}}}{{#if:{{#var:output}}|{{#var:output}}|}}{{clearvar|output}}</includeonly><noinclude>
{{incvar|j}}
+
(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}}

Sega Mega Drive
Prototypes: 1994-03-09 | 04-18 | 05-09 | 05-18 | 05-23 | 06-02 | 06-07 | 06-10 | 06-14 | 06-18 A | 06-20 | 06-24 | 07-06


{{OmniPrereleases|World Series Baseball '95 (Mega Drive)}}