Difference between revisions of "RatingsGraph"
From Sega Retro
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <includeonly>{{#vardefine:graphheight|{{{height|300}}}}}{{#vardefine:graphwidth|{{{width|600}}}}}{{#vardefine:starttime|{{#time: U | {{{startdate| | + | <includeonly><div style="display:none;">{{#vardefine:graphheight|{{{height|300}}}}} |
| + | {{#vardefine:graphwidth|{{{width|600}}}}} | ||
| + | {{RatingsGraph/FindDateRange}} | ||
| + | {{#vardefine:starttime|{{#time: U | {{{startdate|{{#var:lowestdate}}}}}}}}} | ||
| + | {{#vardefine:totaltime|{{#expr:{{#time: U | {{{enddate|{{#var:highestdate}}}}}}} - {{#var:starttime}}}}}} | ||
| + | </div><div style="display: block; width:{{#var:graphwidth}}px; height:{{#var:graphheight}}px;"> | ||
<div style="position:relative; left:0px; top:0px; width:{{#var:graphwidth}}px; height:{{#expr:{{#var:graphheight}}/5}}px; margin-right:-{{#var:graphwidth}}px; margin-bottom:-{{#expr:{{#var:graphheight}}/5}}px; background-color:rgba(80,240,80,0.10);"></div> | <div style="position:relative; left:0px; top:0px; width:{{#var:graphwidth}}px; height:{{#expr:{{#var:graphheight}}/5}}px; margin-right:-{{#var:graphwidth}}px; margin-bottom:-{{#expr:{{#var:graphheight}}/5}}px; background-color:rgba(80,240,80,0.10);"></div> | ||
<div style="position:relative; left:0px; top:{{#expr:{{#var:graphheight}}/5}}px; width:{{#var:graphwidth}}px; height:{{#expr:{{#var:graphheight}}/5}}px; margin-right:-{{#var:graphwidth}}px; margin-bottom:-{{#expr:{{#var:graphheight}}/5}}px; background-color:rgba(190,255,0,0.10);"></div> | <div style="position:relative; left:0px; top:{{#expr:{{#var:graphheight}}/5}}px; width:{{#var:graphwidth}}px; height:{{#expr:{{#var:graphheight}}/5}}px; margin-right:-{{#var:graphwidth}}px; margin-bottom:-{{#expr:{{#var:graphheight}}/5}}px; background-color:rgba(190,255,0,0.10);"></div> | ||
<div style="position:relative; left:0px; top:{{#expr:2*({{#var:graphheight}}/5)}}px; width:{{#var:graphwidth}}px; height:{{#expr:{{#var:graphheight}}/5}}px; margin-right:-{{#var:graphwidth}}px; margin-bottom:-{{#expr:{{#var:graphheight}}/5}}px; background-color:rgba(248,248,0,0.10);"></div> | <div style="position:relative; left:0px; top:{{#expr:2*({{#var:graphheight}}/5)}}px; width:{{#var:graphwidth}}px; height:{{#expr:{{#var:graphheight}}/5}}px; margin-right:-{{#var:graphwidth}}px; margin-bottom:-{{#expr:{{#var:graphheight}}/5}}px; background-color:rgba(248,248,0,0.10);"></div> | ||
<div style="position:relative; left:0px; top:{{#expr:3*({{#var:graphheight}}/5)}}px; width:{{#var:graphwidth}}px; height:{{#expr:{{#var:graphheight}}/5}}px; margin-right:-{{#var:graphwidth}}px; margin-bottom:-{{#expr:{{#var:graphheight}}/5}}px; background-color:rgba(248,197,0,0.10);"></div> | <div style="position:relative; left:0px; top:{{#expr:3*({{#var:graphheight}}/5)}}px; width:{{#var:graphwidth}}px; height:{{#expr:{{#var:graphheight}}/5}}px; margin-right:-{{#var:graphwidth}}px; margin-bottom:-{{#expr:{{#var:graphheight}}/5}}px; background-color:rgba(248,197,0,0.10);"></div> | ||
| − | <div style="position:relative; left:0px; top:{{#expr:4*({{#var:graphheight}}/5)}}px; width:{{#var:graphwidth}}px; height:{{#expr:{{#var:graphheight}}/5}}px; margin-right:-{{#var:graphwidth}}px; margin-bottom:-{{#expr:{{#var:graphheight}}/5}}px; background-color:rgba(230,0,0,0.05);"></div>{{#cargo_query: | + | <div style="position:relative; left:0px; top:{{#expr:4*({{#var:graphheight}}/5)}}px; width:{{#var:graphwidth}}px; height:{{#expr:{{#var:graphheight}}/5}}px; margin-right:-{{#var:graphwidth}}px; margin-bottom:-{{#expr:{{#var:graphheight}}/5}}px; background-color:rgba(230,0,0,0.05);"></div>{{RatingsGraph/DrawGridlines}}{{#cargo_query: |
tables=ratings,releases,magnames,videonames | tables=ratings,releases,magnames,videonames | ||
|fields=ratings.score,ratings.code,ratings.issue | |fields=ratings.score,ratings.code,ratings.issue | ||
| Line 14: | Line 19: | ||
|format=template | |format=template | ||
|template=RatingsGraph/Point | |template=RatingsGraph/Point | ||
| − | }}</div></includeonly><noinclude> | + | }}</div></includeonly><noinclude>{{TODO}} |
| − | {{TODO}} | ||
Stupid ideas approaching | Stupid ideas approaching | ||
{{#vardefine:name|Daytona USA}}{{#vardefine:format|SAT}}{{#vardefine:pointsize|5}} | {{#vardefine:name|Daytona USA}}{{#vardefine:format|SAT}}{{#vardefine:pointsize|5}} | ||
| − | {{RatingsGraph | + | {{RatingsGraph}} |
| + | {{#var:lowestdate}} {{#var:highestdate}} | ||
{{#cargo_query: | {{#cargo_query: | ||
Latest revision as of 14:03, 3 March 2024
 |
This task is unfinished This is a wiki task that requires more thought or peer review. An important issue that needs to be solved, which will appear at the top of Sega Retro:Todo until this message is removed. |
Stupid ideas approaching
1995-03-08 1996-12-29
| score | code | issue |
|---|---|---|
| 91.0 | alaabalc | 2 |
| 60.0 | cdconsoles | 7 |
| 93.0 | consolesplus | 43 |
| 96.0 | cvg | 163 |
| 96.0 | cvg | 165 |
| 90.0 | digitiser | 1995-07-12 |
| 80.0 | edge | 21 |
| 75.0 | ee | 1995-08 |
| 77.5 | egm | 72 |
| 75.0 | famitsu | 329 |
| 88.0 | gamefan | 0307 |
| 90.0 | gameplayers | 0808 |
| 82.5 | gamepro | 73 |
| 93.0 | gamesworld | 12 |
| 94.0 | gamesworld | 15 |
| 86.111111111111 | gi | 27 |
| 80.0 | hitech | 3 |
| 50.0 | leveltr | 5 |
| 85.0 | maniac | 1995-06 |
| 85.0 | maniac | 1995-08 |
| 100.0 | maximum | 1 |
| 95.0 | mega | 32 |
| 95.0 | megaforce | 39 |
| 87.0 | megafun | 1995-08 |
| 75.0 | migr | 2 |
| 92.0 | mms | 32 |
| 96.0 | mms | 35 |
| 75.0 | nextgeneration | 7 |
| 95.0 | playerone | 55 |
| 68.75 | playersbr | 2 |
| 85.0 | pu | 23 |
| 87.133333333333 | saturnfan | 1995-06 |
| 82.0 | saturnplus | 1 |
| 80.0 | secretservice | 35 |
| 90.0 | segamagazin | 21 |
| 94.0 | segamaguk | 20 |
| 88.0 | seganewscz | 1 |
| 87.0 | segapower | 67 |
| 94.0 | segapro | 45 |
| 92.0 | segapro | 49 |
| 75.0 | sgk | 45 |
| 88.0 | smz | 54 |
| 93.333333333333 | ssmjp | 1995-04 |
| 85.886 | ssmjp | readers |
| 60.0 | stranaigr | 1 |
| 89.0 | superjuegos | 40 |
| 93.0 | todosega | 29 |
| 80.0 | topconsoles | 2 |
| 63.0 | ts | 4 |
| 84.0 | ufg | 7 |
| 84.0 | ufg | 10 |
| 88.0 | ultimageneracion | 3 |
| 90.0 | videogames | 1995-08 |
| 80.0 | videogamesus | 77 |