X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=NDWeb%2FInclude.pm;fp=NDWeb%2FInclude.pm;h=2f062bc23fc9042859e93cc6a50ffe1a5b9ac317;hb=ea07b53d84cc3dbf401a4d5afe2cedaf55bb3e56;hp=5ef1dbae143a5330f86313ff3c14f8d1a1dc80ac;hpb=568cb31a5cc3b66a03e7f4861fce8592b5528822;p=ndwebbie.git diff --git a/NDWeb/Include.pm b/NDWeb/Include.pm index 5ef1dba..2f062bc 100644 --- a/NDWeb/Include.pm +++ b/NDWeb/Include.pm @@ -78,7 +78,7 @@ sub intelquery { my ($columns,$where) = @_; return qq{ SELECT $columns, i.mission, i.tick AS landingtick,MIN(i.eta) AS eta, i.amount, i.ingal, u.username -FROM (intel i NATURAL JOIN users u) +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