$sql = "SELECT ind_sec_status, ind_all_id, ind_crp_id,
            ind_shp_id, ind_wep_id, ind_order, ind_dmgdone, plt_id, plt_name,
            plt_externalid, crp_name, crp_external_id,
            shp_externalid FROM kb3_inv_detail
                JOIN kb3_pilots ON (plt_id = ind_plt_id)
                JOIN kb3_corps ON (crp_id = ind_crp_id)
                JOIN kb3_ships ON (shp_id = ind_shp_id)
                WHERE ind_kll_id = ".$kill->getID();
        $qry->execute($sql);

        while ($inv = $qry->getRow())
        {