| @@ 32-34 (lines=3) @@ | ||
| 29 | if (isset($filter['airlines']) && !empty($filter['airlines'])) { |
|
| 30 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) so ON so.flightaware_id = spotter_live.flightaware_id"; |
|
| 31 | } |
|
| 32 | if (isset($filter['airlinestype']) && !empty($filter['airlinestype'])) { |
|
| 33 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_live.flightaware_id "; |
|
| 34 | } |
|
| 35 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
|
| 36 | $filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
|
| 37 | } |
|
| @@ 87-89 (lines=3) @@ | ||
| 84 | if (isset($filter['airlines']) && !empty($filter['airlines'])) { |
|
| 85 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) so ON so.flightaware_id = spotter_live.flightaware_id "; |
|
| 86 | } |
|
| 87 | if (isset($filter['airlinestype']) && !empty($filter['airlinestype'])) { |
|
| 88 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_live.flightaware_id "; |
|
| 89 | } |
|
| 90 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
|
| 91 | $filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
|
| 92 | } |
|
| @@ 145-147 (lines=3) @@ | ||
| 142 | if (isset($filter['airlines']) && !empty($filter['airlines'])) { |
|
| 143 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) so ON so.flightaware_id = spotter_live.flightaware_id"; |
|
| 144 | } |
|
| 145 | if (isset($filter['airlinestype']) && !empty($filter['airlinestype'])) { |
|
| 146 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_live.flightaware_id "; |
|
| 147 | } |
|
| 148 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
|
| 149 | $filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
|
| 150 | } |
|
| @@ 188-190 (lines=3) @@ | ||
| 185 | if (isset($filter['airlines'])) { |
|
| 186 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) so ON so.flightaware_id = spotter_live.flightaware_id"; |
|
| 187 | } |
|
| 188 | if (isset($filter['airlinestype']) && !empty($filter['airlinestype'])) { |
|
| 189 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_live.flightaware_id "; |
|
| 190 | } |
|
| 191 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
|
| 192 | $filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
|
| 193 | } |
|
| @@ 298-300 (lines=3) @@ | ||
| 295 | if (isset($filter['airlines']) && !empty($filter['airlines'])) { |
|
| 296 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) so ON so.flightaware_id = spotter_archive.flightaware_id "; |
|
| 297 | } |
|
| 298 | if (isset($filter['airlinestype']) && !empty($filter['airlinestype'])) { |
|
| 299 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_archive.flightaware_id "; |
|
| 300 | } |
|
| 301 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
|
| 302 | $filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
|
| 303 | } |
|
| @@ 353-355 (lines=3) @@ | ||
| 350 | if (isset($filter['airlines']) && !empty($filter['airlines'])) { |
|
| 351 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) so ON so.flightaware_id = spotter_archive.flightaware_id "; |
|
| 352 | } |
|
| 353 | if (isset($filter['airlinestype']) && !empty($filter['airlinestype'])) { |
|
| 354 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_archive.flightaware_id "; |
|
| 355 | } |
|
| 356 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
|
| 357 | $filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
|
| 358 | } |
|
| @@ 418-420 (lines=3) @@ | ||
| 415 | if (isset($filter['airlines']) && !empty($filter['airlines'])) { |
|
| 416 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) so ON so.flightaware_id = spotter_archive.flightaware_id "; |
|
| 417 | } |
|
| 418 | if (isset($filter['airlinestype']) && !empty($filter['airlinestype'])) { |
|
| 419 | $filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_archive.flightaware_id "; |
|
| 420 | } |
|
| 421 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
|
| 422 | $filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
|
| 423 | } |
|