Detailed Fleet mod

[RogerB]

I forget who created this mod, [don't feel like searching] "detailed Fleet info" but, it displays aircraft that are retired, would anyone mind post code to have this mod not show retired aircraft?

[Txmmy83]

I forget who created this mod, [don't feel like searching] "detailed Fleet info" but, it displays aircraft that are retired, would anyone mind post code to have this mod not show retired aircraft?

did you mean that mod?

http://forum.phpvms.net/topic/1522-fleet-table/

if it is that mod look at the "Where enabled = 1"

$sql = 'SELECT a.*, a.name AS aircraft,

     COUNT(p.pirepid) AS routesflown,
     SUM(p.distance) AS distance,
     SEC_TO_TIME(SUM(p.flighttime*60*60)) AS totaltime,
     AVG(p.distance) AS averagedistance,
     AVG(p.flighttime) as averagetime
     FROM   '.TABLE_PREFIX.'aircraft a
     LEFT OUTER JOIN '.TABLE_PREFIX.'pireps p ON (p.aircraft = a.id)
     WHERE enabled = 1
     GROUP BY a.name';

[RogerB]

WHERE enabled = 1

That helped. Thanks!!