Difference between revisions of "OnThisDayRelease/Cargo"
From Sega Retro
| (15 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{# | + | <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)='09-22' GROUP BY `name` ORDER BY `date`,`console`,`region`,`type` DESC,`name` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-e8e75-964.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)