From 93c59348304cb9ff046b986699d7bbbdae00be46 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Fri, 26 Jan 2007 11:55:27 +0000 Subject: [PATCH] better to sort by tick --- ND/Web/Pages/Graph.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/ND/Web/Pages/Graph.pm b/ND/Web/Pages/Graph.pm index 6881884..835ad86 100644 --- 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; -- 2.39.2