Difference between revisions of "GetDefaultRatingSystem"

From Sega Retro

(what a mess)
Line 2: Line 2:
 
table=magdefaultratingsystems
 
table=magdefaultratingsystems
 
|fields=system
 
|fields=system
|where=code="{{{1|}}}" {{#if:{{{2|}}}|AND firstissue <= "{{padleft:{{{2}}}|8|0}}"|}}
+
|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 28: Line 28:
 
<pre>{{GetDefaultRatingSystem|score|2}}</pre>
 
<pre>{{GetDefaultRatingSystem|score|2}}</pre>
 
{{GetDefaultRatingSystem|score|2}}
 
{{GetDefaultRatingSystem|score|2}}
 +
 +
<pre>{{GetDefaultRatingSystem|joypad|44s}}</pre>
 +
{{GetDefaultRatingSystem|joypad|44s}}
 
[[Category:Sega Retro templates]]</noinclude>
 
[[Category:Sega Retro templates]]</noinclude>

Revision as of 11:46, 10 August 2020


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