Difference between revisions of "GetEarliestRelease"

From Sega Retro
 
(13 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
<div style="display:none;">{{#cargo_query:table=releases
+
<includeonly><span style="display:none">{{let|formattedName={{FormatSQL|{{{1|}}}}}|lowestValue=9999|consolecommand={{#if:{{{command|}}}|{{{command}}}|{{#switch:{{{2|}}}
 +
|Digital=(console="Amazon" OR console="iTunes")
 +
|#default=console="{{{2|}}}" }}}}}}{{#cargo_query:table=releases
 
|fields=date
 
|fields=date
−
|where=game="{{{1}}}" AND console="{{{2}}}"
+
|where=name="{{#var:formattedName}}" {{#if:{{{2|}}}|AND {{#var:consolecommand}}|}}
 
|format=template
 
|format=template
−
|template=CargoResult
+
|template=CargoLowest
−
}}{{#vardefine:lowestValue|9999}}{{#vardefine:currentLine|NULL}}{{#vardefine:i|0}}{{#while:
+
}}</span>{{#ifeq:{{#var:lowestValue}}|9999|?|{{#var:lowestValue}}}}</includeonly><noinclude>{{GetEarliestRelease|18 Wheeler: American Pro Trucker|PS2}}
−
| {{#ifexpr:{{#len:{{#var:currentLine}}}} > 3|true|}}
+
 
−
| {{#vardefine:currentLine|{{#explode:{{#var:cargoResult}}| |{{#var:i}}}}}}{{incvar|i}}
+
{{GetEarliestRelease|Evander Holyfield's "Real Deal" Boxing|MD}}
−
{{#vardefine:valueToCheck|{{#sub:{{#var:currentLine}}|0|4}}}}
+
 
−
{{#ifexpr:{{#len:{{#var:valueToCheck}}}} = 4|
+
{{GetEarliestRelease|Airforce Delta Demo Disc}}
−
{{#ifexpr: {{#var:valueToCheck}} < {{#var:lowestValue}}|{{#vardefine:lowestValue|{{#var:valueToCheck}}}}|}}
+
 
−
|}}
+
{{ProductionHistory|Jun Senoue|JunJun|瀬上 純}}
−
|}}</div>{{#var:lowestValue}}{{#vardefine:cargoResult|9999}}<noinclude>{{GetEarliestRelease|18 Wheeler: American Pro Trucker|PS2}}[[Category:Sega Retro templates]]</noinclude>
+
 
 +
{{GetEarliestRelease|Manx TT Super Bike|PC}}
 +
 
 +
[[Category:Templates]]</noinclude>

Latest revision as of 09:50, 3 January 2024

2001

1992

1999

Games

Videos

Music

Hardware

1997

  1. ↑ 1.0 1.1 File:Heavenly Symphony MCD credits.pdf
  2. ↑ File:Sonic the Hedgehog 3 MD credits.pdf
  3. ↑ File:Sonic & Knuckles MD credits.pdf
  4. ↑ File:Metal Head 32X credits.pdf
  5. ↑ File:Chaotix 32X good ending credits.pdf
  6. ↑ File:IntheHunt Saturn JP SSEnding.pdf
  7. ↑ File:Sonic 3D Blast MD credits.pdf
  8. ↑ File:Daytona USA CCE credits.pdf
  9. ↑ File:SkyTarget Saturn JP SSEnding.pdf
  10. ↑ File:Sonic 3D Blast Saturn credits.pdf
  11. ↑ File:SonicRivals2 PSP US manual.pdf, page 23
  12. ↑ File:SegaRally2 CD JP Booklet.pdf, page 10
  13. ↑ File:SARemix CD JP booklet.pdf, page 9
  14. ↑ File:SADLCOST CD JP booklet1.pdf, page 2
  15. ↑ 15.0 15.1 15.2 File:ThrilloftheFeel CD JP booklet.pdf, page 10
  16. ↑ File:CutsUnleashed CD JP front.pdf, page 3
  17. ↑ File:MDSA2OST poster1.pdf, page 1
  18. ↑ 18.0 18.1 18.2 File:SA2OST CD US booklet.pdf, page 10
  19. ↑ 19.0 19.1 File:Crush40 CD US back.png
  20. ↑ File:TripleThreat CD JP booklet.pdf, page 2
  21. ↑ File:CompleteTrinity CD JP booklet.pdf, page 8
  22. ↑ 22.0 22.1 File:LostandFound CD JP booklet.pdf, page 6
  23. ↑ File:StHOriginalSoundtrax CD JP booklet.pdf, page 2
  24. ↑ 24.0 24.1 File:StHOST CD JP booklet.pdf, page 6
  25. ↑ File:SeveralWIlls CD JP booklet.pdf, page 15
  26. ↑ File:TrueBlue CD JP booklet.pdf, page 5
  27. ↑ File:PlanetaryPieces CD JP booklet.pdf, page 18
  28. ↑ File:LGATVGDUSAAB Music JP inlay back.jpg
  29. ↑ 29.0 29.1 File:TalesofKnighthood CD JP booklet.pdf, page 10
  30. ↑ 30.0 30.1 File:FacetoFaith CD JP booklet.pdf, page 11
  31. ↑ File:Crush40SuperSonicSongsTray.jpg
  32. ↑ File:TrueColorsTray.jpg
  33. ↑ File:Super32X15thAA Booklet.pdf, page 15
  34. ↑ File:SFROST CD JP booklet.pdf, page 3
  35. ↑ File:VividSound CD JP booklet.pdf, page 18
  36. ↑ File:MDLAH Music JP inlay front.png
  37. ↑ File:SonicCD OST Tray.jpg
  38. ↑ File:Sonic Generations Original Soundtrack Tray.jpg
  39. ↑ File:RiseAgainTray.jpg
  40. ↑ File:Live! CD JP booklet.pdf, page 15
  41. ↑ File:SLWOSTWB CD JP booklet.pdf, page 22
  42. ↑ 42.0 42.1 File:SonicAdventureMusicExperience CD JP Box Tokyo.jpg
  43. ↑ File:SMPOST CD JP booklet.pdf, page 3
  44. ↑ File:MaximumOverdrive CD JP inlay front.jpg
  45. ↑ File:Sega60th CD JP booklet.pdf
  46. ↑ File:GoSega60thAnniversaryAlbum CD JP Booklet.pdf, page 20
Retrieved from "https://segaretro.org/index.php?title=Template:GetEarliestRelease&oldid=948406"