X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=NDWeb%2FInclude.pm;h=2f062bc23fc9042859e93cc6a50ffe1a5b9ac317;hb=2a86de01949110d5f64e38ca2f95e83d16555874;hp=5ef1dbae143a5330f86313ff3c14f8d1a1dc80ac;hpb=9d5814b742ee4fae0209ae238bcea9db11137fdf;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