Difference between revisions of "GetDefaultRatingSystem"
From Sega Retro
(give it a few hours, and this might start working) |
m (Text replacement - "Category:Sega Retro templates" to "Category:Templates") |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
table=magdefaultratingsystems | table=magdefaultratingsystems | ||
|fields=system | |fields=system | ||
| − | |where=code="{{{1|}}}" {{#if:{{{2|}}}|AND firstissue <= "{{{2}}}"|}} | + | |where=code="{{{1|}}}" {{#if:{{{2|}}}|AND firstissue <= "{{padleft:{{#replace:{{{2}}}|s|}}|8|0}}"|}} |
|order by={{#if:{{{2|}}}|firstissue DESC}} | |order by={{#if:{{{2|}}}|firstissue DESC}} | ||
|limit=1 | |limit=1 | ||
| Line 22: | Line 22: | ||
<pre>{{GetDefaultRatingSystem|cvg|174}}</pre> | <pre>{{GetDefaultRatingSystem|cvg|174}}</pre> | ||
{{GetDefaultRatingSystem|cvg|174}} | {{GetDefaultRatingSystem|cvg|174}} | ||
| − | [[Category: | + | |
| + | <pre>{{GetDefaultRatingSystem|score|26}}</pre> | ||
| + | {{GetDefaultRatingSystem|score|20}} | ||
| + | |||
| + | <pre>{{GetDefaultRatingSystem|score|2}}</pre> | ||
| + | {{GetDefaultRatingSystem|score|2}} | ||
| + | |||
| + | <pre>{{GetDefaultRatingSystem|joypad|44s}}</pre> | ||
| + | {{GetDefaultRatingSystem|joypad|44s}} | ||
| + | |||
| + | <pre>{{GetDefaultRatingSystem|digitiser|1993-01-01}}</pre> | ||
| + | {{GetDefaultRatingSystem|digitiser|1993-01-01}} | ||
| + | |||
| + | <pre>{{GetDefaultRatingSystem|digitiser|1995-01-01}}</pre> | ||
| + | {{GetDefaultRatingSystem|digitiser|1995-01-01}} | ||
| + | [[Category:Templates]]</noinclude> | ||
Latest revision as of 12:59, 1 January 2022
Quick templates to get the default rating system of a magazine.
e.g.
{{GetDefaultRatingSystem|cvg}}
0-10
{{GetDefaultRatingSystem|cvg|173}}
0-100,0-100
{{GetDefaultRatingSystem|cvg|174}}
1-5s
{{GetDefaultRatingSystem|score|26}}
0-10
{{GetDefaultRatingSystem|score|2}}
0-100
{{GetDefaultRatingSystem|joypad|44s}}
0-100,0-100
{{GetDefaultRatingSystem|digitiser|1993-01-01}}
0-5s
{{GetDefaultRatingSystem|digitiser|1995-01-01}}
0-100