Difference between revisions of "GetEarliestRelease"

From Sega Retro

(years aren't displaying but credits actually work now; will fix later)
Line 1: Line 1:
<div style="display:none;">{{#vardefine:formattedName|{{#replace:{{{1}}}|"|""}}}}{{#cargo_query:table=releases
+
<includeonly><div style="display:none;">{{#vardefine:formattedName|{{#replace:{{{1}}}|"|""}}}}{{#vardefine:cargoResult|{{#cargo_query:table=releases
 
|fields=date
 
|fields=date
 
|where=name="{{#var:formattedName}}" AND console="{{{2}}}"
 
|where=name="{{#var:formattedName}}" AND console="{{{2}}}"
|format=template
+
|format=list
|template=CargoResult
+
|delimiter=
}}{{#vardefine:lowestValue|9999}}{{#vardefine:currentLine|NULL}}{{#vardefine:i|0}}{{#while:
+
}}}}</div>{{#vardefine:lowestValue|9999}}{{#vardefine:i|0}}{{#while:
| {{#ifexpr:{{#len:{{#var:currentLine}}}} > 3|true|}}
+
| {{#vardefine:xyz|{{#explode:{{#var:cargoResult}}| |{{#var:i}}}}}}{{#var:xyz}}
| {{#vardefine:currentLine|{{#explode:{{#var:cargoResult}}| |{{#var:i}}}}}}{{incvar|i}}
+
| {{incvar|i}}
{{#vardefine:valueToCheck|{{#sub:{{#var:currentLine}}|0|4}}}}
+
{{lowest|{{#var:lowestValue}}|{{year|{{#var:xyz}}}}|var=lowestValue}}
{{#ifexpr:{{#len:{{#var:valueToCheck}}}} = 4|
+
}}{{#var:lowestValue}}<!-- {{#var:i}} {{#var:cargoResult}}--></includeonly><noinclude>{{GetEarliestRelease|18 Wheeler: American Pro Trucker|PS2}}
{{#ifexpr: {{#var:valueToCheck}} < {{#var:lowestValue}}|{{#vardefine:lowestValue|{{#var:valueToCheck}}}}|}}
 
|}}
 
|}}</div>{{#var:lowestValue}}{{#vardefine:cargoResult|9999}}<noinclude>{{GetEarliestRelease|18 Wheeler: American Pro Trucker|PS2}}
 
  
{{GetEarliestRelease|Evander Holyfield's "Real Deal" Boxing|MD}}[[Category:Sega Retro templates]]</noinclude>
+
{{GetEarliestRelease|Evander Holyfield's "Real Deal" Boxing|MD}}
 +
 
 +
{{ProductionHistory|Yoshitaka Tamaki|玉木 美孝}}
 +
 
 +
{{ProductionHistory|Jun Senoue|JunJun|瀬上 純}}
 +
 
 +
[[Category:Sega Retro templates]]</noinclude>

Revision as of 02:07, 1 December 2019

9999

9999



  • Sega TV Game Genga Gallery, Graphic Sha, page 35
  • Sega TV Game Genga Gallery, Graphic Sha, page 30
  • File:SkyTarget Saturn JP SSEnding.pdf
  • File:IntheHunt_Saturn_JP_SSEnding.pdf
  • File:SARemix CD JP booklet.pdf, page 9
  • File:SADLCOST CD JP booklet1.pdf, page 2
  • File:ThrilloftheFeel CD JP booklet.pdf, page 10
  • File:CutsUnleashed CD JP front.pdf, page 3
  • File:MDSA2OST poster1.pdf, page 1
  • 10.0 10.1 10.2 File:SA2OST CD US booklet.pdf, page 10
  • 11.0 11.1 File:Crush40 CD US back.png
  • File:TripleThreat CD JP booklet.pdf, page 2
  • File:CompleteTrinity CD JP booklet.pdf, page 8
  • File:StHOriginalSoundtrax CD JP booklet.pdf, page 2
  • 15.0 15.1 File:LostandFound CD JP booklet.pdf, page 6
  • 16.0 16.1 File:StHOST CD JP booklet.pdf, page 6
  • File:SeveralWIlls CD JP booklet.pdf, page 15
  • File:TrueBlue CD JP booklet.pdf, page 5
  • File:PlanetaryPieces CD JP booklet.pdf, page 10
  • File:LGATVGDUSAAB Music JP inlay back.jpg
  • 21.0 21.1 File:TalesofKnighthood CD JP booklet.pdf, page 10
  • 22.0 22.1 File:FacetoFaith CD JP booklet.pdf, page 11
  • File:Crush40SuperSonicSongsTray.jpg
  • File:TrueColorsTray.jpg
  • File:SFROST CD JP booklet.pdf, page 3
  • File:VividSound CD JP booklet.pdf, page 18
  • File:MDLAH Music JP inlay front.png
  • File:SonicCD OST Tray.jpg
  • File:Sonic Generations Original Soundtrack Tray.jpg
  • File:RiseAgainTray.jpg
  • File:Live! CD JP booklet.pdf, page 15
  • File:SLWOSTWB CD JP booklet.pdf, page 22
  • 33.0 33.1 File:SonicAdventureMusicExperience CD JP Box Tokyo.jpg
  • File:SMPOST CD JP booklet.pdf, page 3
  • File:MaximumOverdrive CD JP inlay front.jpg