Difference between revisions of "OnThisDayRelease/Cargo"
From Sega Retro
(7 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | {{#vardefine: | + | <div style="display:none;"> |
− | * | + | <!-- variable set-up and debugging --> |
− | + | *go: (PREVIOUS: {{#var:prevname}} {{!}} {{#var:prevconsole}} {{!}} {{#var:prevregion}} {{!}} {{#var:prevyear}}) | |
+ | **name: {{#vardefine:name|{{FormatSQL|{{{1|}}}}}}} | ||
+ | **type: {{#vardefine:type|{{{2|}}}}} | ||
+ | **console: {{#vardefine:console|{{{3|}}}}} | ||
+ | **region: {{#vardefine:region|{{{4|}}}}} | ||
+ | **date: {{#vardefine:date|{{{5|}}}}} | ||
+ | **year: {{#vardefine:year|{{#sub:{{{5|}}}|0|4)}}}} | ||
+ | **localname: {{#vardefine:localname|{{GetLocalisedName|{{#var:name}}|{{{4|}}}}}}} | ||
+ | **link: {{#vardefine:link|{{UnformatSQL|{{#var:name}}}}}} | ||
+ | **displayname: {{#vardefine:displayname|{{UnformatSQL|{{#if:{{#var:localname}}|{{#var:localname}}|{{#explode:{{#var:name}}|(|0}}}}}}}} | ||
+ | |||
+ | |||
+ | <!--We are iterating through things released on this day | ||
+ | check to see if the previous year/console/region is the same, so we can combine results and reduce bullet points --> | ||
+ | {{ | ||
+ | #if:{{#var:name}}|{{ | ||
+ | #ifeq:{{#var:year}}|{{#var:prevyear}}|{{ | ||
+ | #ifeq:{{#var:console}}|{{#var:prevconsole}}|{{ | ||
+ | #ifeq:{{#var:region}}|{{#var:prevregion}} | ||
+ | |{{#vardefine:currentresult|, }} | ||
+ | |{{#vardefine:currentresult|{{#if:{{#var:prevconsole}}{{#var:prevregion}}| {{OnThisDayReleaseFormatBrackets|{{#var:prevtype|}}|{{#var:prevconsole}}|{{#var:prevregion}}}} | ||
}} | }} | ||
+ | *<!--NEW REGION-->'''{{#var:year}}:''' }} | ||
+ | }} | ||
+ | |||
+ | |{{#vardefine:currentresult|{{#if:{{#var:prevconsole}}{{#var:prevregion}}| {{OnThisDayReleaseFormatBrackets|{{#var:prevtype|}}|{{#var:prevconsole}}|{{#var:prevregion}}}} | ||
+ | }} | ||
+ | *<!--NEW CONSOLE-->'''{{#var:year}}:''' }} | ||
+ | }} | ||
+ | |||
+ | |{{#vardefine:currentresult|{{#if:{{#var:prevconsole}}{{#var:prevregion}}| {{OnThisDayReleaseFormatBrackets|{{#var:prevtype|}}|{{#var:prevconsole}}|{{#var:prevregion}}}} | ||
+ | }} | ||
+ | *<!--NEW YEAR-->'''{{#var:year}}:''' }} | ||
+ | }} | ||
+ | |||
+ | {{#switch:{{#var:type}} | ||
+ | |1={{#vardefine:currentresult|{{#var:currentresult}} [[{{#var:link}}|{{#var:displayname}}]]}} | ||
+ | |2={{#vardefine:currentresult|{{#var:currentresult}} '''[[{{#var:link}}|{{#var:displayname}}]]'''}} | ||
+ | |#default={{#vardefine:currentresult|{{#var:currentresult}} ''[[{{#var:link}}|{{#var:displayname}}]]''}} | ||
+ | }} | ||
+ | |||
+ | <!-- update result, reset variables | ||
+ | note: because this template doesn't know when we're on the last row, the last result will be finished by template:OnThisDay | ||
+ | --> | ||
+ | {{ | ||
+ | #vardefine:result|{{#var:result}}{{#var:currentresult}}}}{{clearvar|currentresult}}}}{{ | ||
+ | #vardefine:prevname|{{#var:name}}}}{{ | ||
+ | #vardefine:prevconsole|{{#var:console}}}}{{ | ||
+ | #vardefine:prevregion|{{#var:region}}}}{{ | ||
+ | #vardefine:prevyear|{{#var:year}}}} | ||
+ | </div><noinclude>{{OnThisDayRelease}} | ||
+ | |||
+ | [[Category:Cargo templates]]</noinclude> |
Latest revision as of 03:23, 8 July 2021
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `name` AS `name`,`type` AS `type`,`console` AS `console`,`region` AS `region`,`date` AS `date` FROM `cargo__releases` WHERE SUBSTRING(date,6,5)='10-04' GROUP BY `name` ORDER BY `date`,`console`,`region`,`type` DESC,`name` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-25b5eaa-4214.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)