Difference between revisions of "RatingsGraph"

From Sega Retro
 
(8 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|0}}}}}}}{{#vardefine:totaltime|{{#expr:{{#time: U | {{{enddate|0}}}}} - {{#var:starttime}}}}}}<div style="display: block; width: 8px; width:{{#var:graphwidth}}px; height:{{#var:graphheight}}px; background-color:#EEFFEE;">{{{annotations|}}}
+
<includeonly><div style="display:none;">{{#vardefine:graphheight|{{{height|300}}}}}
−
{{#vardefine:i|1}}
+
{{#vardefine:graphwidth|{{{width|600}}}}}
−
{{#while:
+
{{RatingsGraph/FindDateRange}}
−
| {{#if:{{#explode:{{#var:annotationlist}}|,|{{#var:i}}}}|true}}
+
{{#vardefine:starttime|{{#time: U | {{{startdate|{{#var:lowestdate}}}}}}}}}
−
| {{#vardefine:output|{{#explode:{{#var:annotationlist}}|,|{{#var:i}}}}}}{{VTimelineDrawAnnotation|{{#var:output}}|{{#var:annotation_{{#var:output}}}}}}{{clearvar|annotation_{{#var:output}}}}{{incvar|i}}
+
{{#vardefine:totaltime|{{#expr:{{#time: U | {{{enddate|{{#var:highestdate}}}}}}} - {{#var:starttime}}}}}}
−
}}{{clearvar|annotationlist}}</div>
+
</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>
−
{{#cargo_query:
+
<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>
−
tables=ratings,releases,magnames,videonames,issuenames
+
<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>
−
|fields=ratings.score,ratings.code,magnames.name,magnames.link,magnames.country,videonames.name=vidname,videonames.link=vidlink,videonames.country=vidcountry,releases.name=releasesname
+
<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>{{RatingsGraph/DrawGridlines}}{{#cargo_query:
 +
tables=ratings,releases,magnames,videonames
 +
|fields=ratings.score,ratings.code,ratings.issue
 
|where=ratings.name="{{#var:name}}" and ratings.format="{{#var:format}}"
 
|where=ratings.name="{{#var:name}}" and ratings.format="{{#var:format}}"
−
|join on=ratings.name=releases.name,ratings.code=magnames.code,ratings.code=videonames.code,ratings.code=issuenames.code,ratings.issue=issuenames.num
+
|join on=ratings.name=releases.name,ratings.code=magnames.code,ratings.code=videonames.code
 
|order by=ratings.code,magnames.country,ratings.version
 
|order by=ratings.code,magnames.country,ratings.version
 
|group by=ratings.code,ratings.version,ratings.issue
 
|group by=ratings.code,ratings.version,ratings.issue
Line 16: Line 19:
 
|format=template
 
|format=template
 
|template=RatingsGraph/Point
 
|template=RatingsGraph/Point
−
}}
+
}}</div></includeonly><noinclude>{{TODO}}
−
</includeonly><noinclude>
 
−
{{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:
−
tables=ratings,releases,magnames,videonames,issuenames
+
tables=ratings,releases,magnames,videonames
−
|fields=ratings.score,ratings.code,magnames.name,magnames.link,magnames.country,videonames.name=vidname,videonames.link=vidlink,videonames.country=vidcountry,releases.name=releasesname,issuenames.num,issuenames.date
+
|fields=ratings.score,ratings.code,ratings.issue
 
|where=ratings.name="{{#var:name}}" and ratings.format="{{#var:format}}"
 
|where=ratings.name="{{#var:name}}" and ratings.format="{{#var:format}}"
−
|join on=ratings.name=releases.name,ratings.code=magnames.code,ratings.code=videonames.code,ratings.code=issuenames.code,ratings.issue=issuenames.num
+
|join on=ratings.name=releases.name,ratings.code=magnames.code,ratings.code=videonames.code
 
|order by=ratings.code,magnames.country,ratings.version
 
|order by=ratings.code,magnames.country,ratings.version
 
|group by=ratings.code,ratings.version,ratings.issue
 
|group by=ratings.code,ratings.version,ratings.issue

Latest revision as of 14:03, 3 March 2024

Clock.svg
 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
Retrieved from "https://segaretro.org/index.php?title=Template:RatingsGraph&oldid=964658"