Difference between revisions of "GetEarliestRelease"
From Sega Retro
(8 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | <div style="display:none;"> | + | <div style="display:none;">{{#vardefine:formattedName|{{#replace:{{{1}}}|"|""}}}}{{#cargo_query:table=releases |
− | {{#cargo_query:table=releases | ||
|fields=date | |fields=date | ||
− | |where=name="{{ | + | |where=name="{{#var:formattedName}}" AND console="{{{2}}}" |
|format=template | |format=template | ||
|template=CargoResult | |template=CargoResult | ||
− | }} | + | }}{{#vardefine:lowestValue|9999}}{{#vardefine:currentLine|NULL}}{{#vardefine:i|0}}{{#while: |
− | {{#vardefine:lowestValue|9999}} | ||
− | {{#vardefine:currentLine|NULL}}{{#vardefine:i|0}} | ||
− | {{#while: | ||
| {{#ifexpr:{{#len:{{#var:currentLine}}}} > 3|true|}} | | {{#ifexpr:{{#len:{{#var:currentLine}}}} > 3|true|}} | ||
| {{#vardefine:currentLine|{{#explode:{{#var:cargoResult}}| |{{#var:i}}}}}}{{incvar|i}} | | {{#vardefine:currentLine|{{#explode:{{#var:cargoResult}}| |{{#var:i}}}}}}{{incvar|i}} | ||
{{#vardefine:valueToCheck|{{#sub:{{#var:currentLine}}|0|4}}}} | {{#vardefine:valueToCheck|{{#sub:{{#var:currentLine}}|0|4}}}} | ||
− | {{#ifexpr:{{#len:{{#var:valueToCheck}}}} | + | {{#ifexpr:{{#len:{{#var:valueToCheck}}}} = 4| |
{{#ifexpr: {{#var:valueToCheck}} < {{#var:lowestValue}}|{{#vardefine:lowestValue|{{#var:valueToCheck}}}}|}} | {{#ifexpr: {{#var:valueToCheck}} < {{#var:lowestValue}}|{{#vardefine:lowestValue|{{#var:valueToCheck}}}}|}} | ||
|}} | |}} | ||
− | |}}</div>{{#var:lowestValue}} | + | |}}</div>{{#var:lowestValue}}{{#vardefine:cargoResult|9999}}<noinclude>{{GetEarliestRelease|18 Wheeler: American Pro Trucker|PS2}} |
− | <noinclude>{{GetEarliestRelease|18 Wheeler: American Pro Trucker|PS2}}[[Category:Sega Retro templates]]</noinclude> | + | |
+ | {{GetEarliestRelease|Evander Holyfield's "Real Deal" Boxing|MD}}[[Category:Sega Retro templates]]</noinclude> |
Revision as of 13:50, 17 December 2017
9999
9999
9999