X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FInclude.pm;h=1974724f7951ad1f3694efcfd8d301d86f00f2a0;hb=2c69d5fa71e2b4ddf7c9f5fa1880a9c69f70e43a;hp=5bea31bec699e2ee55594cd271935118ac824116;hpb=57f880656c4486f68583058121a5bcb3b316199c;p=ndwebbie.git diff --git a/lib/NDWeb/Include.pm b/lib/NDWeb/Include.pm index 5bea31b..1974724 100644 --- a/lib/NDWeb/Include.pm +++ b/lib/NDWeb/Include.pm @@ -79,7 +79,7 @@ FROM (fleets 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,t.nick,o.nick +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,i.sender,i.target ORDER BY i.tick DESC, i.mission}; }