X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FWeb%2FPages%2FGraph.pm;fp=ND%2FWeb%2FPages%2FGraph.pm;h=c0b49cafddbdea55920abfcecc1a2813b9c51d3b;hb=cd896f47e0e96a37914612efcdf8a7c32cd26eb6;hp=93308f9edf1553416b99bbbf83ad37ce282f14ad;hpb=48fe29b3ca075822a14c62d82fa99e35ed820120;p=ndwebbie.git diff --git a/ND/Web/Pages/Graph.pm b/ND/Web/Pages/Graph.pm index 93308f9..c0b49ca 100644 --- a/ND/Web/Pages/Graph.pm +++ b/ND/Web/Pages/Graph.pm @@ -137,10 +137,10 @@ WHERE a.id = $1 ORDER BY tick}); }elsif ($type eq 'planetvsnd'){ $graph_settings{title} = 'You vs ND AVG'; $graph_settings{two_axes} = 1; - $graph_settings{use_axis} = [1,2,1,2]; + $graph_settings{use_axis} = [2,1,1,2]; $graph_settings{y2_label} = 'score'; - my $query = $DBH->prepare(q{SELECT a.tick,a.size/members as NDsize,a.score/members AS NDscore,memsize, memscore FROM (SELECT tick,size AS memsize,score AS memscore FROM planets p JOIN planet_stats ps USING (id) WHERE p.id = $1) p JOIN alliance_stats a ON a.tick = p.tick + my $query = $DBH->prepare(q{SELECT a.tick,a.score/members AS NDscore,a.size/members as NDsize,memsize, memscore FROM (SELECT tick,size AS memsize,score AS memscore FROM planets p JOIN planet_stats ps USING (id) WHERE p.id = $1) p JOIN alliance_stats a ON a.tick = p.tick WHERE a.id = 1 ORDER BY tick}); $query->execute($req{id}) or die $DBH->errstr;