X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FIntel.pm;h=4cc3b7e4bcd6871301f069b6c26551d8da0ba35d;hb=436af6a696e3488f5d25e027553ec356da4cde01;hp=0a683c0618a57caa1fbbace638eee97660ec652d;hpb=58fed91c3cf50e1d386bbea93ba41ced3e98414a;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/Intel.pm b/lib/NDWeb/Controller/Intel.pm index 0a683c0..4cc3b7e 100644 --- a/lib/NDWeb/Controller/Intel.pm +++ b/lib/NDWeb/Controller/Intel.pm @@ -294,8 +294,8 @@ sub naps : Local { ,(metal+crystal+eonium)/100 AS resvalue, planet_status,hit_us , alliance,relationship,nick FROM current_planet_stats p - LEFT OUTER JOIN planet_scans ps ON p.id = ps.planet - LEFT OUTER JOIN structure_scans ss ON p.id = ss.planet + LEFT OUTER JOIN current_planet_scans ps ON p.id = ps.planet + LEFT OUTER JOIN current_structure_scans ss ON p.id = ss.planet WHERE planet_status IN ('Friendly','NAP') order by x,y,z asc }); $query->execute;