X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FWeb%2FPages%2FGraph.pm;fp=ND%2FWeb%2FPages%2FGraph.pm;h=93308f9edf1553416b99bbbf83ad37ce282f14ad;hb=bc5fe76561eec517ebefad912f82aa5c6e4d84cd;hp=4f0ff62b5a5985878f57dcfb30393d76bd997483;hpb=37607373bbe268cc5dc741378dc51d878e8f8a9a;p=ndwebbie.git diff --git a/ND/Web/Pages/Graph.pm b/ND/Web/Pages/Graph.pm index 4f0ff62..93308f9 100644 --- a/ND/Web/Pages/Graph.pm +++ b/ND/Web/Pages/Graph.pm @@ -89,28 +89,30 @@ sub render_body { my $query; 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}); + $graph_settings{y_min_value} = 0; }elsif($type eq 'ranks'){ $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}); + $graph_settings{y_max_value} = 0; } $query->execute($x,$y,$z,$ND::TICK) or die $DBH->errstr; $graph_settings{title} = $type; $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; }elsif ($type eq 'galstats' || $type eq 'galranks'){ my $query; my ($x,$y) = ($req{x},$req{y}); if ($type eq 'galstats'){ $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}); + $graph_settings{y_min_value} = 0; }elsif($type eq 'galranks'){ $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}); + $graph_settings{y_max_value} = 0; } $query->execute($x,$y) or die $DBH->errstr; $graph_settings{title} = $type; $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; }elsif ($type eq 'alliance' || $type eq 'allianceavg'){