X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=include.pl;h=a78acc9be229a5d335d6f0866efae0ebd91aeafe;hb=5af89dd22a075c6652b779ef471bf21cb9965cb6;hp=07bb9857984e1563d3a47f24c13dfee6f0715cf1;hpb=0c6242438cc218a6a6980c961484b8c74d547eee;p=ndwebbie.git diff --git a/include.pl b/include.pl index 07bb985..a78acc9 100644 --- a/include.pl +++ b/include.pl @@ -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}; }