]> ruin.nu Git - ndwebbie.git/blobdiff - include.pl
member intel, shows all incoming and outgoing fleets for member planets
[ndwebbie.git] / include.pl
index 07bb9857984e1563d3a47f24c13dfee6f0715cf1..a78acc9be229a5d335d6f0866efae0ebd91aeafe 100644 (file)
@@ -107,7 +107,7 @@ FROM (intel i NATURAL JOIN users u)
        JOIN current_planet_stats t ON i.target = t.id
        JOIN current_planet_stats o ON i.sender = o.id
 WHERE $where 
-GROUP BY i.tick,i.mission,t.x,t.y,t.z,o.x,o.y,o.z,i.amount,i.ingal,u.username,t.alliance,o.alliance 
+GROUP BY i.tick,i.mission,t.x,t.y,t.z,o.x,o.y,o.z,i.amount,i.ingal,u.username,t.alliance,o.alliance,t.nick,o.nick
 ORDER BY i.tick DESC, i.mission};
 }