X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FWeb%2FPages%2FGraph.pm;fp=ND%2FWeb%2FPages%2FGraph.pm;h=605c60774cbfc4ef707c2740aa4f3221164963de;hb=e6092ad0fb25a41adf027e65e661f64c5304d010;hp=7b20efe97ebf34bd9a5564d72d9c1931a1cfb1ef;hpb=6fe6edd0f7b5e12d88ec0549252104e5a287888c;p=ndwebbie.git

diff --git a/ND/Web/Pages/Graph.pm b/ND/Web/Pages/Graph.pm
index 7b20efe..605c607 100644
--- a/ND/Web/Pages/Graph.pm
+++ b/ND/Web/Pages/Graph.pm
@@ -72,20 +72,21 @@ sub render {
 			if ($type eq 'stats'){
 				$query = $DBH->prepare(q{SELECT tick,score,size,value,xp*60 AS "xp*60" FROM planets natural join planet_stats WHERE id = planetid($1,$2,$3,$4) ORDER BY tick ASC});
 			}elsif($type eq 'ranks'){
-				$query = $DBH->prepare(q{SELECT tick,scorerank,sizerank,valuerank,xprank FROM planets natural join planet_stats WHERE id = planetid($1,$2,$3,$4) ORDER BY tick ASC});
+				$query = $DBH->prepare(q{SELECT tick,-scorerank AS score,-sizerank AS size,-valuerank AS value,-xprank AS xp FROM planets natural join planet_stats WHERE id = planetid($1,$2,$3,$4) ORDER BY tick ASC});
 			}
 			$query->execute($x,$y,$z,$ND::TICK) or die $DBH->errstr;
 		}else{
 			if ($type eq 'stats'){
 				$query = $DBH->prepare(q{SELECT tick,score,size,value,xp*60 AS "xp*60" FROM galaxies WHERE x = $1 AND y = $2 ORDER BY tick ASC});
 			}elsif($type eq 'ranks'){
-				$query = $DBH->prepare(q{SELECT tick,scorerank,sizerank,valuerank,xprank FROM galaxies WHERE x = $1 AND y = $2  ORDER BY tick ASC});
+				$query = $DBH->prepare(q{SELECT tick,-scorerank AS score,-sizerank AS size,-valuerank AS value,-xprank AS xp FROM galaxies WHERE x = $1 AND y = $2  ORDER BY tick ASC});
 			}
 			$query->execute($x,$y) or die $DBH->errstr;
 		}
 		
 		$graph_settings{two_axes} = 1;
 		$graph_settings{use_axis} = [2,1,2,2];
+		$graph_settings{y_max_value} = 0 if $type eq 'ranks';
 		$img = graphFromQuery 500,300,\%graph_settings,$query;
 	}