Code Duplication    Length = 3-3 lines in 7 locations

require/class.SpotterLive.php 4 locations

@@ 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
		}

require/class.SpotterArchive.php 3 locations

@@ 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
                }