better to sort by tick

[ndwebbie.git] / ND / Web / Pages / Graph.pm

diff --git a/ND/Web/Pages/Graph.pm b/ND/Web/Pages/Graph.pm
index 688188498d7b9e04e637459a3bde1554dbb43a43..835ad86b4c2cd9ae6be6df85efd5f2bc3a3d1018 100644 (file)
--- a/ND/Web/Pages/Graph.pm
+++ b/ND/Web/Pages/Graph.pm
@@ -105,7 +105,7 @@ WHERE a.id = $1 ORDER BY tick});
                $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
-WHERE a.id = 1});
+WHERE a.id = 1 ORDER BY tick});
                $query->execute($1) or die $DBH->errstr;
 
                $img = graphFromQuery 500,300,\%graph_settings,$query;