@@ -7,7 +7,9 @@ discard block |
||
| 7 | 7 | public function __construct($dbc = null) { |
| 8 | 8 | $Connection = new Connection($dbc); |
| 9 | 9 | $this->db = $Connection->db; |
| 10 | - if ($this->db === null) die('Error: No DB connection. (Source)'); |
|
| 10 | + if ($this->db === null) { |
|
| 11 | + die('Error: No DB connection. (Source)'); |
|
| 12 | + } |
|
| 11 | 13 | } |
| 12 | 14 | |
| 13 | 15 | public function getAllLocationInfo() { |
@@ -72,7 +74,9 @@ discard block |
||
| 72 | 74 | $query .= " AND source_location.latitude BETWEEN ".$minlat." AND ".$maxlat." AND source_location.longitude BETWEEN ".$minlong." AND ".$maxlong." AND source_location.latitude <> 0 AND source_location.longitude <> 0"; |
| 73 | 75 | } |
| 74 | 76 | $query .= " ORDER BY last_seen DESC"; |
| 75 | - if ($limit) $query .= " LIMIT 400"; |
|
| 77 | + if ($limit) { |
|
| 78 | + $query .= " LIMIT 400"; |
|
| 79 | + } |
|
| 76 | 80 | $query_values = array(':type' => $type); |
| 77 | 81 | try { |
| 78 | 82 | $sth = $this->db->prepare($query); |
@@ -111,7 +115,9 @@ discard block |
||
| 111 | 115 | } |
| 112 | 116 | |
| 113 | 117 | public function addLocation($name,$latitude,$longitude,$altitude,$city,$country,$source,$logo = 'antenna.png',$type = '',$source_id = 0,$location_id = 0,$last_seen = '', $description = '') { |
| 114 | - if ($last_seen == '') $last_seen = date('Y-m-d H:i:s'); |
|
| 118 | + if ($last_seen == '') { |
|
| 119 | + $last_seen = date('Y-m-d H:i:s'); |
|
| 120 | + } |
|
| 115 | 121 | $query = "INSERT INTO source_location (name,latitude,longitude,altitude,country,city,logo,source,type,source_id,last_seen,location_id,description) VALUES (:name,:latitude,:longitude,:altitude,:country,:city,:logo,:source,:type,:source_id,:last_seen,:location_id,:description)"; |
| 116 | 122 | $query_values = array(':name' => $name,':latitude' => $latitude, ':longitude' => $longitude,':altitude' => $altitude,':city' => $city,':country' => $country,':logo' => $logo,':source' => $source,':type' => $type,':source_id' => $source_id,':last_seen' => $last_seen,':location_id' => $location_id,':description' => $description); |
| 117 | 123 | try { |
@@ -123,7 +129,9 @@ discard block |
||
| 123 | 129 | } |
| 124 | 130 | |
| 125 | 131 | public function updateLocation($name,$latitude,$longitude,$altitude,$city,$country,$source,$logo = 'antenna.png',$type = '',$source_id = 0,$location_id = 0,$last_seen = '',$description = '') { |
| 126 | - if ($last_seen == '') $last_seen = date('Y-m-d H:i:s'); |
|
| 132 | + if ($last_seen == '') { |
|
| 133 | + $last_seen = date('Y-m-d H:i:s'); |
|
| 134 | + } |
|
| 127 | 135 | $query = "UPDATE source_location SET latitude = :latitude,longitude = :longitude,altitude = :altitude,country = :country,city = :city,logo = :logo,type = :type, source_id = :source_id, last_seen = :last_seen,location_id = :location_id, description = :description WHERE name = :name AND source = :source"; |
| 128 | 136 | $query_values = array(':name' => $name,':latitude' => $latitude, ':longitude' => $longitude,':altitude' => $altitude,':city' => $city,':country' => $country,':logo' => $logo,':source' => $source,':type' => $type,':source_id' => $source_id,':last_seen' => $last_seen,':location_id' => $location_id,':description' => $description); |
| 129 | 137 | try { |
@@ -146,7 +154,9 @@ discard block |
||
| 146 | 154 | } |
| 147 | 155 | |
| 148 | 156 | public function updateLocationByLocationID($name,$latitude,$longitude,$altitude,$city,$country,$source,$logo = 'antenna.png',$type = '',$source_id = 0, $location_id,$last_seen = '',$description = '') { |
| 149 | - if ($last_seen == '') $last_seen = date('Y-m-d H:i:s'); |
|
| 157 | + if ($last_seen == '') { |
|
| 158 | + $last_seen = date('Y-m-d H:i:s'); |
|
| 159 | + } |
|
| 150 | 160 | $query = "UPDATE source_location SET latitude = :latitude,longitude = :longitude,altitude = :altitude,country = :country,city = :city,logo = :logo,type = :type, last_seen = :last_seen, description = :description WHERE location_id = :location_id AND source = :source AND source_id = :source_id"; |
| 151 | 161 | $query_values = array(':source_id' => $source_id,':latitude' => $latitude, ':longitude' => $longitude,':altitude' => $altitude,':city' => $city,':country' => $country,':logo' => $logo,':source' => $source,':type' => $type,':last_seen' => $last_seen,':location_id' => $location_id,':description' => $description); |
| 152 | 162 | try { |
@@ -6,7 +6,9 @@ discard block |
||
| 6 | 6 | public function __construct($dbc = null) { |
| 7 | 7 | $Connection = new Connection($dbc); |
| 8 | 8 | $this->db = $Connection->db; |
| 9 | - if ($this->db === null) die('Error: No DB connection. (MarineArchive)'); |
|
| 9 | + if ($this->db === null) { |
|
| 10 | + die('Error: No DB connection. (MarineArchive)'); |
|
| 11 | + } |
|
| 10 | 12 | } |
| 11 | 13 | |
| 12 | 14 | /** |
@@ -27,7 +29,9 @@ discard block |
||
| 27 | 29 | if (isset($filter[0]['source'])) { |
| 28 | 30 | $filters = array_merge($filters,$filter); |
| 29 | 31 | } |
| 30 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
| 32 | + if (is_array($globalFilter)) { |
|
| 33 | + $filter = array_merge($filter,$globalFilter); |
|
| 34 | + } |
|
| 31 | 35 | $filter_query_join = ''; |
| 32 | 36 | $filter_query_where = ''; |
| 33 | 37 | foreach($filters as $flt) { |
@@ -73,8 +77,11 @@ discard block |
||
| 73 | 77 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
| 74 | 78 | $filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
| 75 | 79 | } |
| 76 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
| 77 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
| 80 | + if ($filter_query_where == '' && $where) { |
|
| 81 | + $filter_query_where = ' WHERE'; |
|
| 82 | + } elseif ($filter_query_where != '' && $and) { |
|
| 83 | + $filter_query_where .= ' AND'; |
|
| 84 | + } |
|
| 78 | 85 | if ($filter_query_where != '') { |
| 79 | 86 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
| 80 | 87 | } |
@@ -88,9 +95,14 @@ discard block |
||
| 88 | 95 | if ($over_country == '') { |
| 89 | 96 | $Marine = new Marine($this->db); |
| 90 | 97 | $data_country = $Marine->getCountryFromLatitudeLongitude($latitude,$longitude); |
| 91 | - if (!empty($data_country)) $country = $data_country['iso2']; |
|
| 92 | - else $country = ''; |
|
| 93 | - } else $country = $over_country; |
|
| 98 | + if (!empty($data_country)) { |
|
| 99 | + $country = $data_country['iso2']; |
|
| 100 | + } else { |
|
| 101 | + $country = ''; |
|
| 102 | + } |
|
| 103 | + } else { |
|
| 104 | + $country = $over_country; |
|
| 105 | + } |
|
| 94 | 106 | |
| 95 | 107 | //$country = $over_country; |
| 96 | 108 | // Route is not added in marine_archive |
@@ -598,7 +610,9 @@ discard block |
||
| 598 | 610 | $additional_query .= "(marine_archive_output.pilot_name like '%".$q_item."%') OR "; |
| 599 | 611 | $additional_query .= "(marine_archive_output.ident like '%".$q_item."%') OR "; |
| 600 | 612 | $translate = $Translation->ident2icao($q_item); |
| 601 | - if ($translate != $q_item) $additional_query .= "(marine_archive_output.ident like '%".$translate."%') OR "; |
|
| 613 | + if ($translate != $q_item) { |
|
| 614 | + $additional_query .= "(marine_archive_output.ident like '%".$translate."%') OR "; |
|
| 615 | + } |
|
| 602 | 616 | $additional_query .= "(marine_archive_output.highlight like '%".$q_item."%')"; |
| 603 | 617 | $additional_query .= ")"; |
| 604 | 618 | } |
@@ -816,7 +830,9 @@ discard block |
||
| 816 | 830 | date_default_timezone_set($globalTimezone); |
| 817 | 831 | $datetime = new DateTime(); |
| 818 | 832 | $offset = $datetime->format('P'); |
| 819 | - } else $offset = '+00:00'; |
|
| 833 | + } else { |
|
| 834 | + $offset = '+00:00'; |
|
| 835 | + } |
|
| 820 | 836 | |
| 821 | 837 | |
| 822 | 838 | if ($date_array[1] != "") |
@@ -1092,9 +1108,13 @@ discard block |
||
| 1092 | 1108 | $query .= "AND date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
| 1093 | 1109 | } |
| 1094 | 1110 | } |
| 1095 | - if ($sincedate != '') $query .= "AND date > '".$sincedate."' "; |
|
| 1111 | + if ($sincedate != '') { |
|
| 1112 | + $query .= "AND date > '".$sincedate."' "; |
|
| 1113 | + } |
|
| 1096 | 1114 | $query .= "GROUP BY c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
| 1097 | - if ($limit) $query .= " LIMIT 0,10"; |
|
| 1115 | + if ($limit) { |
|
| 1116 | + $query .= " LIMIT 0,10"; |
|
| 1117 | + } |
|
| 1098 | 1118 | |
| 1099 | 1119 | |
| 1100 | 1120 | $sth = $this->db->prepare($query); |
@@ -1138,9 +1158,13 @@ discard block |
||
| 1138 | 1158 | $query .= "AND s.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
| 1139 | 1159 | } |
| 1140 | 1160 | } |
| 1141 | - if ($sincedate != '') $query .= "AND s.date > '".$sincedate."' "; |
|
| 1161 | + if ($sincedate != '') { |
|
| 1162 | + $query .= "AND s.date > '".$sincedate."' "; |
|
| 1163 | + } |
|
| 1142 | 1164 | $query .= "GROUP BY o.airline_icao,c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
| 1143 | - if ($limit) $query .= " LIMIT 0,10"; |
|
| 1165 | + if ($limit) { |
|
| 1166 | + $query .= " LIMIT 0,10"; |
|
| 1167 | + } |
|
| 1144 | 1168 | |
| 1145 | 1169 | |
| 1146 | 1170 | $sth = $this->db->prepare($query); |
@@ -7,7 +7,9 @@ discard block |
||
| 7 | 7 | public function __construct($dbc = null) { |
| 8 | 8 | $Connection = new Connection($dbc); |
| 9 | 9 | $this->db = $Connection->db; |
| 10 | - if ($this->db === null) die('Error: No DB connection. (ATC)'); |
|
| 10 | + if ($this->db === null) { |
|
| 11 | + die('Error: No DB connection. (ATC)'); |
|
| 12 | + } |
|
| 11 | 13 | } |
| 12 | 14 | |
| 13 | 15 | /** |
@@ -20,20 +22,27 @@ discard block |
||
| 20 | 22 | if (is_array($globalStatsFilters) && isset($globalStatsFilters[$globalFilterName])) { |
| 21 | 23 | if (isset($globalStatsFilters[$globalFilterName][0]['source'])) { |
| 22 | 24 | foreach($globalStatsFilters[$globalFilterName] as $source) { |
| 23 | - if (isset($source['source'])) $filter['source'][] = $source['source']; |
|
| 25 | + if (isset($source['source'])) { |
|
| 26 | + $filter['source'][] = $source['source']; |
|
| 27 | + } |
|
| 24 | 28 | } |
| 25 | 29 | } else { |
| 26 | 30 | $filter = $globalStatsFilters[$globalFilterName]; |
| 27 | 31 | } |
| 28 | 32 | } |
| 29 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
| 33 | + if (is_array($globalFilter)) { |
|
| 34 | + $filter = array_merge($filter,$globalFilter); |
|
| 35 | + } |
|
| 30 | 36 | $filter_query_join = ''; |
| 31 | 37 | $filter_query_where = ''; |
| 32 | 38 | if (isset($filter['source']) && !empty($filter['source'])) { |
| 33 | 39 | $filter_query_where = " WHERE format_source IN ('".implode("','",$filter['source'])."')"; |
| 34 | 40 | } |
| 35 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
| 36 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
| 41 | + if ($filter_query_where == '' && $where) { |
|
| 42 | + $filter_query_where = ' WHERE'; |
|
| 43 | + } elseif ($filter_query_where != '' && $and) { |
|
| 44 | + $filter_query_where .= ' AND'; |
|
| 45 | + } |
|
| 37 | 46 | $filter_query = $filter_query_join.$filter_query_where; |
| 38 | 47 | return $filter_query; |
| 39 | 48 | } |
@@ -90,7 +99,9 @@ discard block |
||
| 90 | 99 | $info = str_replace('^','<br />',$info); |
| 91 | 100 | $info = str_replace('&sect;','',$info); |
| 92 | 101 | $info = str_replace('"','',$info); |
| 93 | - if ($type == '') $type = NULL; |
|
| 102 | + if ($type == '') { |
|
| 103 | + $type = NULL; |
|
| 104 | + } |
|
| 94 | 105 | $query = "INSERT INTO atc (ident,frequency,latitude,longitude,atc_range,info,atc_lastseen,type,ivao_id,ivao_name,format_source,source_name) VALUES (:ident,:frequency,:latitude,:longitude,:range,:info,:date,:type,:ivao_id,:ivao_name,:format_source,:source_name)"; |
| 95 | 106 | $query_values = array(':ident' => $ident,':frequency' => $frequency,':latitude' => $latitude,':longitude' => $longitude,':range' => $range,':info' => $info,':date' => $date,':ivao_id' => $ivao_id,':ivao_name' => $ivao_name, ':type' => $type,':format_source' => $format_source,':source_name' => $source_name); |
| 96 | 107 | try { |
@@ -106,7 +117,9 @@ discard block |
||
| 106 | 117 | $info = str_replace('^','<br />',$info); |
| 107 | 118 | $info = str_replace('&sect;','',$info); |
| 108 | 119 | $info = str_replace('"','',$info); |
| 109 | - if ($type == '') $type = NULL; |
|
| 120 | + if ($type == '') { |
|
| 121 | + $type = NULL; |
|
| 122 | + } |
|
| 110 | 123 | $query = "UPDATE atc SET frequency = :frequency,latitude = :latitude,longitude = :longitude,atc_range = :range,info = :info,atc_lastseen = :date,type = :type,ivao_id = :ivao_id,ivao_name = :ivao_name WHERE ident = :ident AND format_source = :format_source AND source_name = :source_name"; |
| 111 | 124 | $query_values = array(':ident' => $ident,':frequency' => $frequency,':latitude' => $latitude,':longitude' => $longitude,':range' => $range,':info' => $info,':date' => $date,':ivao_id' => $ivao_id,':ivao_name' => $ivao_name, ':type' => $type,':format_source' => $format_source,':source_name' => $source_name); |
| 112 | 125 | try { |
@@ -34,7 +34,9 @@ discard block |
||
| 34 | 34 | $output .= '<?xml version="1.0" encoding="UTF-8"?>'; |
| 35 | 35 | $output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">'; |
| 36 | 36 | $aircraft_types = $Stats->getAllAircraftTypes(); |
| 37 | - if (empty($aircraft_types)) $aircraft_types = $Spotter->getAllAircraftTypes(); |
|
| 37 | + if (empty($aircraft_types)) { |
|
| 38 | + $aircraft_types = $Spotter->getAllAircraftTypes(); |
|
| 39 | + } |
|
| 38 | 40 | foreach($aircraft_types as $aircraft_item) |
| 39 | 41 | { |
| 40 | 42 | $output .= '<url>'; |
@@ -84,7 +86,9 @@ discard block |
||
| 84 | 86 | $output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">'; |
| 85 | 87 | |
| 86 | 88 | $airport_names = $Stats->getAllAirportNames(); |
| 87 | - if (empty($airport_names)) $airport_names = $Spotter->getAllAirportNames(); |
|
| 89 | + if (empty($airport_names)) { |
|
| 90 | + $airport_names = $Spotter->getAllAirportNames(); |
|
| 91 | + } |
|
| 88 | 92 | foreach($airport_names as $airport_item) |
| 89 | 93 | { |
| 90 | 94 | $output .= '<url>'; |
@@ -99,7 +103,9 @@ discard block |
||
| 99 | 103 | $output .= '<?xml version="1.0" encoding="UTF-8"?>'; |
| 100 | 104 | $output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">'; |
| 101 | 105 | $manufacturer_names = $Stats->getAllManufacturers(); |
| 102 | - if (empty($manufacturer_names)) $manufacturer_names = $Spotter->getAllManufacturers(); |
|
| 106 | + if (empty($manufacturer_names)) { |
|
| 107 | + $manufacturer_names = $Spotter->getAllManufacturers(); |
|
| 108 | + } |
|
| 103 | 109 | foreach($manufacturer_names as $manufacturer_item) |
| 104 | 110 | { |
| 105 | 111 | $output .= '<url>'; |
@@ -4,7 +4,9 @@ discard block |
||
| 4 | 4 | require_once('require/class.Language.php'); |
| 5 | 5 | $Stats = new Stats(); |
| 6 | 6 | |
| 7 | -if (!isset($filter_name)) $filter_name = ''; |
|
| 7 | +if (!isset($filter_name)) { |
|
| 8 | + $filter_name = ''; |
|
| 9 | +} |
|
| 8 | 10 | $type = 'aircraft'; |
| 9 | 11 | if (isset($_GET['marine'])) { |
| 10 | 12 | $type = 'marine'; |
@@ -21,8 +23,10 @@ discard block |
||
| 21 | 23 | } |
| 22 | 24 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
| 23 | 25 | if ($airline_icao == '' && isset($globalFilter)) { |
| 24 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
| 25 | -} |
|
| 26 | + if (isset($globalFilter['airline'])) { |
|
| 27 | + $airline_icao = $globalFilter['airline'][0]; |
|
| 28 | + } |
|
| 29 | + } |
|
| 26 | 30 | |
| 27 | 31 | require_once('header.php'); |
| 28 | 32 | include('statistics-sub-menu.php'); |
@@ -64,10 +68,14 @@ discard block |
||
| 64 | 68 | $flightover_data = ''; |
| 65 | 69 | foreach($flightover_array as $flightover_item) |
| 66 | 70 | { |
| 67 | - if ($type == 'aircraft') $flightover_data .= '[ "'.$flightover_item['flight_country_iso3'].'",'.$flightover_item['flight_count'].'],'; |
|
| 68 | - elseif ($type == 'marine') $flightover_data .= '[ "'.$flightover_item['marine_country_iso3'].'",'.$flightover_item['marine_count'].'],'; |
|
| 69 | - elseif ($type == 'tracker') $flightover_data .= '[ "'.$flightover_item['tracker_country_iso3'].'",'.$flightover_item['tracker_count'].'],'; |
|
| 70 | -} |
|
| 71 | + if ($type == 'aircraft') { |
|
| 72 | + $flightover_data .= '[ "'.$flightover_item['flight_country_iso3'].'",'.$flightover_item['flight_count'].'],'; |
|
| 73 | + } elseif ($type == 'marine') { |
|
| 74 | + $flightover_data .= '[ "'.$flightover_item['marine_country_iso3'].'",'.$flightover_item['marine_count'].'],'; |
|
| 75 | + } elseif ($type == 'tracker') { |
|
| 76 | + $flightover_data .= '[ "'.$flightover_item['tracker_country_iso3'].'",'.$flightover_item['tracker_count'].'],'; |
|
| 77 | + } |
|
| 78 | + } |
|
| 71 | 79 | $flightover_data = substr($flightover_data, 0, -1); |
| 72 | 80 | print $flightover_data; |
| 73 | 81 | print '];'; |
@@ -10,7 +10,9 @@ discard block |
||
| 10 | 10 | public function __construct($dbc = null) { |
| 11 | 11 | $Connection = new Connection($dbc); |
| 12 | 12 | $this->db = $Connection->db(); |
| 13 | - if ($this->db === null) die('Error: No DB connection. (Tracker)'); |
|
| 13 | + if ($this->db === null) { |
|
| 14 | + die('Error: No DB connection. (Tracker)'); |
|
| 15 | + } |
|
| 14 | 16 | } |
| 15 | 17 | |
| 16 | 18 | /** |
@@ -32,7 +34,9 @@ discard block |
||
| 32 | 34 | if (isset($filter[0]['source'])) { |
| 33 | 35 | $filters = array_merge($filters,$filter); |
| 34 | 36 | } |
| 35 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
| 37 | + if (is_array($globalFilter)) { |
|
| 38 | + $filter = array_merge($filter,$globalFilter); |
|
| 39 | + } |
|
| 36 | 40 | $filter_query_join = ''; |
| 37 | 41 | $filter_query_where = ''; |
| 38 | 42 | foreach($filters as $flt) { |
@@ -71,8 +75,11 @@ discard block |
||
| 71 | 75 | $filter_query_where .= " AND EXTRACT(DAY FROM tracker_output.date) = '".$filter['day']."'"; |
| 72 | 76 | } |
| 73 | 77 | } |
| 74 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
| 75 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
| 78 | + if ($filter_query_where == '' && $where) { |
|
| 79 | + $filter_query_where = ' WHERE'; |
|
| 80 | + } elseif ($filter_query_where != '' && $and) { |
|
| 81 | + $filter_query_where .= ' AND'; |
|
| 82 | + } |
|
| 76 | 83 | if ($filter_query_where != '') { |
| 77 | 84 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
| 78 | 85 | } |
@@ -126,26 +133,43 @@ discard block |
||
| 126 | 133 | $temp_array['tracker_id'] = $row['tracker_archive_id']; |
| 127 | 134 | } elseif (isset($row['tracker_archive_output_id'])) { |
| 128 | 135 | $temp_array['tracker_id'] = $row['tracker_archive_output_id']; |
| 129 | - */} |
|
| 130 | - elseif (isset($row['trackerid'])) { |
|
| 136 | + */} elseif (isset($row['trackerid'])) { |
|
| 131 | 137 | $temp_array['trackerid'] = $row['trackerid']; |
| 132 | 138 | } else { |
| 133 | 139 | $temp_array['trackerid'] = ''; |
| 134 | 140 | } |
| 135 | - if (isset($row['famtrackid'])) $temp_array['famtrackid'] = $row['famtrackid']; |
|
| 136 | - if (isset($row['type'])) $temp_array['type'] = $row['type']; |
|
| 137 | - if (isset($row['comment'])) $temp_array['comment'] = $row['comment']; |
|
| 141 | + if (isset($row['famtrackid'])) { |
|
| 142 | + $temp_array['famtrackid'] = $row['famtrackid']; |
|
| 143 | + } |
|
| 144 | + if (isset($row['type'])) { |
|
| 145 | + $temp_array['type'] = $row['type']; |
|
| 146 | + } |
|
| 147 | + if (isset($row['comment'])) { |
|
| 148 | + $temp_array['comment'] = $row['comment']; |
|
| 149 | + } |
|
| 138 | 150 | $temp_array['ident'] = $row['ident']; |
| 139 | - if (isset($row['latitude'])) $temp_array['latitude'] = $row['latitude']; |
|
| 140 | - if (isset($row['longitude'])) $temp_array['longitude'] = $row['longitude']; |
|
| 141 | - if (isset($row['format_source'])) $temp_array['format_source'] = $row['format_source']; |
|
| 142 | - if (isset($row['altitude'])) $temp_array['altitude'] = $row['altitude']; |
|
| 151 | + if (isset($row['latitude'])) { |
|
| 152 | + $temp_array['latitude'] = $row['latitude']; |
|
| 153 | + } |
|
| 154 | + if (isset($row['longitude'])) { |
|
| 155 | + $temp_array['longitude'] = $row['longitude']; |
|
| 156 | + } |
|
| 157 | + if (isset($row['format_source'])) { |
|
| 158 | + $temp_array['format_source'] = $row['format_source']; |
|
| 159 | + } |
|
| 160 | + if (isset($row['altitude'])) { |
|
| 161 | + $temp_array['altitude'] = $row['altitude']; |
|
| 162 | + } |
|
| 143 | 163 | if (isset($row['heading'])) { |
| 144 | 164 | $temp_array['heading'] = $row['heading']; |
| 145 | 165 | $heading_direction = $this->parseDirection($row['heading']); |
| 146 | - if (isset($heading_direction[0]['direction_fullname'])) $temp_array['heading_name'] = $heading_direction[0]['direction_fullname']; |
|
| 166 | + if (isset($heading_direction[0]['direction_fullname'])) { |
|
| 167 | + $temp_array['heading_name'] = $heading_direction[0]['direction_fullname']; |
|
| 168 | + } |
|
| 169 | + } |
|
| 170 | + if (isset($row['ground_speed'])) { |
|
| 171 | + $temp_array['ground_speed'] = $row['ground_speed']; |
|
| 147 | 172 | } |
| 148 | - if (isset($row['ground_speed'])) $temp_array['ground_speed'] = $row['ground_speed']; |
|
| 149 | 173 | |
| 150 | 174 | if (isset($row['date'])) { |
| 151 | 175 | $dateArray = $this->parseDateString($row['date']); |
@@ -188,13 +212,21 @@ discard block |
||
| 188 | 212 | } |
| 189 | 213 | |
| 190 | 214 | $fromsource = NULL; |
| 191 | - if (isset($row['source_name']) && $row['source_name'] != '') $temp_array['source_name'] = $row['source_name']; |
|
| 192 | - if (isset($row['over_country']) && $row['over_country'] != '') $temp_array['over_country'] = $row['over_country']; |
|
| 193 | - if (isset($row['distance']) && $row['distance'] != '') $temp_array['distance'] = $row['distance']; |
|
| 215 | + if (isset($row['source_name']) && $row['source_name'] != '') { |
|
| 216 | + $temp_array['source_name'] = $row['source_name']; |
|
| 217 | + } |
|
| 218 | + if (isset($row['over_country']) && $row['over_country'] != '') { |
|
| 219 | + $temp_array['over_country'] = $row['over_country']; |
|
| 220 | + } |
|
| 221 | + if (isset($row['distance']) && $row['distance'] != '') { |
|
| 222 | + $temp_array['distance'] = $row['distance']; |
|
| 223 | + } |
|
| 194 | 224 | $temp_array['query_number_rows'] = $num_rows; |
| 195 | 225 | $tracker_array[] = $temp_array; |
| 196 | 226 | } |
| 197 | - if ($num_rows == 0) return array(); |
|
| 227 | + if ($num_rows == 0) { |
|
| 228 | + return array(); |
|
| 229 | + } |
|
| 198 | 230 | $tracker_array[0]['query_number_rows'] = $num_rows; |
| 199 | 231 | return $tracker_array; |
| 200 | 232 | } |
@@ -225,8 +257,12 @@ discard block |
||
| 225 | 257 | { |
| 226 | 258 | //$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1]; |
| 227 | 259 | $limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
| 228 | - } else $limit_query = ""; |
|
| 229 | - } else $limit_query = ""; |
|
| 260 | + } else { |
|
| 261 | + $limit_query = ""; |
|
| 262 | + } |
|
| 263 | + } else { |
|
| 264 | + $limit_query = ""; |
|
| 265 | + } |
|
| 230 | 266 | |
| 231 | 267 | if ($sort != "") |
| 232 | 268 | { |
@@ -254,7 +290,9 @@ discard block |
||
| 254 | 290 | global $global_query; |
| 255 | 291 | |
| 256 | 292 | date_default_timezone_set('UTC'); |
| 257 | - if ($id == '') return array(); |
|
| 293 | + if ($id == '') { |
|
| 294 | + return array(); |
|
| 295 | + } |
|
| 258 | 296 | $additional_query = "tracker_output.famtrackid = :id"; |
| 259 | 297 | $query_values = array(':id' => $id); |
| 260 | 298 | $query = $global_query." WHERE ".$additional_query." "; |
@@ -397,8 +435,11 @@ discard block |
||
| 397 | 435 | $query .= " ORDER BY tracker_output.source_name ASC"; |
| 398 | 436 | |
| 399 | 437 | $sth = $this->db->prepare($query); |
| 400 | - if (!empty($query_values)) $sth->execute($query_values); |
|
| 401 | - else $sth->execute(); |
|
| 438 | + if (!empty($query_values)) { |
|
| 439 | + $sth->execute($query_values); |
|
| 440 | + } else { |
|
| 441 | + $sth->execute(); |
|
| 442 | + } |
|
| 402 | 443 | |
| 403 | 444 | $source_array = array(); |
| 404 | 445 | $temp_array = array(); |
@@ -453,7 +494,9 @@ discard block |
||
| 453 | 494 | date_default_timezone_set($globalTimezone); |
| 454 | 495 | $datetime = new DateTime(); |
| 455 | 496 | $offset = $datetime->format('P'); |
| 456 | - } else $offset = '+00:00'; |
|
| 497 | + } else { |
|
| 498 | + $offset = '+00:00'; |
|
| 499 | + } |
|
| 457 | 500 | |
| 458 | 501 | if ($globalDBdriver == 'mysql') { |
| 459 | 502 | $query = "SELECT DISTINCT DATE(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) as date |
@@ -609,7 +652,9 @@ discard block |
||
| 609 | 652 | { |
| 610 | 653 | return false; |
| 611 | 654 | } |
| 612 | - } else $altitude = 0; |
|
| 655 | + } else { |
|
| 656 | + $altitude = 0; |
|
| 657 | + } |
|
| 613 | 658 | |
| 614 | 659 | if ($heading != "") |
| 615 | 660 | { |
@@ -648,8 +693,12 @@ discard block |
||
| 648 | 693 | $latitude = 0; |
| 649 | 694 | $longitude = 0; |
| 650 | 695 | } |
| 651 | - if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0; |
|
| 652 | - if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0; |
|
| 696 | + if ($heading == '' || $Common->isInteger($heading) === false) { |
|
| 697 | + $heading = 0; |
|
| 698 | + } |
|
| 699 | + if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) { |
|
| 700 | + $groundspeed = 0; |
|
| 701 | + } |
|
| 653 | 702 | $query = "INSERT INTO tracker_output (famtrackid, ident, latitude, longitude, altitude, heading, ground_speed, date, format_source, source_name, comment, type) |
| 654 | 703 | VALUES (:famtrackid,:ident,:latitude,:longitude,:altitude,:heading,:speed,:date,:format_source, :source_name,:comment,:type)"; |
| 655 | 704 | |
@@ -753,7 +802,9 @@ discard block |
||
| 753 | 802 | global $globalDBdriver, $globalArchive; |
| 754 | 803 | //$filter_query = $this->getFilter($filters,true,true); |
| 755 | 804 | $Connection= new Connection($this->db); |
| 756 | - if (!$Connection->tableExists('countries')) return array(); |
|
| 805 | + if (!$Connection->tableExists('countries')) { |
|
| 806 | + return array(); |
|
| 807 | + } |
|
| 757 | 808 | if (!isset($globalArchive) || $globalArchive !== TRUE) { |
| 758 | 809 | require_once('class.TrackerLive.php'); |
| 759 | 810 | $TrackerLive = new TrackerLive($this->db); |
@@ -796,7 +847,9 @@ discard block |
||
| 796 | 847 | $query = "SELECT c.name, c.iso3, c.iso2, count(c.name) as nb FROM countries c INNER JOIN (SELECT DISTINCT famtrackid,over_country FROM tracker_archive".$filter_query.") l ON c.iso2 = l.over_country "; |
| 797 | 848 | } |
| 798 | 849 | $query .= "GROUP BY c.name,c.iso3,c.iso2 ORDER BY nb DESC"; |
| 799 | - if ($limit) $query .= " LIMIT 10 OFFSET 0"; |
|
| 850 | + if ($limit) { |
|
| 851 | + $query .= " LIMIT 10 OFFSET 0"; |
|
| 852 | + } |
|
| 800 | 853 | |
| 801 | 854 | |
| 802 | 855 | $sth = $this->db->prepare($query); |
@@ -829,12 +882,18 @@ discard block |
||
| 829 | 882 | $query = "SELECT DISTINCT tracker_output.ident, COUNT(tracker_output.ident) AS callsign_icao_count |
| 830 | 883 | FROM tracker_output".$filter_query." tracker_output.ident <> ''"; |
| 831 | 884 | if ($olderthanmonths > 0) { |
| 832 | - if ($globalDBdriver == 'mysql') $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)'; |
|
| 833 | - else $query .= " AND tracker_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
|
| 885 | + if ($globalDBdriver == 'mysql') { |
|
| 886 | + $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)'; |
|
| 887 | + } else { |
|
| 888 | + $query .= " AND tracker_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
|
| 889 | + } |
|
| 834 | 890 | } |
| 835 | 891 | if ($sincedate != '') { |
| 836 | - if ($globalDBdriver == 'mysql') $query .= " AND tracker_output.date > '".$sincedate."'"; |
|
| 837 | - else $query .= " AND tracker_output.date > CAST('".$sincedate."' AS TIMESTAMP)"; |
|
| 892 | + if ($globalDBdriver == 'mysql') { |
|
| 893 | + $query .= " AND tracker_output.date > '".$sincedate."'"; |
|
| 894 | + } else { |
|
| 895 | + $query .= " AND tracker_output.date > CAST('".$sincedate."' AS TIMESTAMP)"; |
|
| 896 | + } |
|
| 838 | 897 | } |
| 839 | 898 | $query_values = array(); |
| 840 | 899 | if ($year != '') { |
@@ -865,7 +924,9 @@ discard block |
||
| 865 | 924 | } |
| 866 | 925 | } |
| 867 | 926 | $query .= " GROUP BY tracker_output.ident ORDER BY callsign_icao_count DESC"; |
| 868 | - if ($limit) $query .= " LIMIT 10 OFFSET 0"; |
|
| 927 | + if ($limit) { |
|
| 928 | + $query .= " LIMIT 10 OFFSET 0"; |
|
| 929 | + } |
|
| 869 | 930 | |
| 870 | 931 | $sth = $this->db->prepare($query); |
| 871 | 932 | $sth->execute($query_values); |
@@ -900,7 +961,9 @@ discard block |
||
| 900 | 961 | date_default_timezone_set($globalTimezone); |
| 901 | 962 | $datetime = new DateTime(); |
| 902 | 963 | $offset = $datetime->format('P'); |
| 903 | - } else $offset = '+00:00'; |
|
| 964 | + } else { |
|
| 965 | + $offset = '+00:00'; |
|
| 966 | + } |
|
| 904 | 967 | |
| 905 | 968 | if ($globalDBdriver == 'mysql') { |
| 906 | 969 | $query = "SELECT DATE(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count |
@@ -950,7 +1013,9 @@ discard block |
||
| 950 | 1013 | date_default_timezone_set($globalTimezone); |
| 951 | 1014 | $datetime = new DateTime(); |
| 952 | 1015 | $offset = $datetime->format('P'); |
| 953 | - } else $offset = '+00:00'; |
|
| 1016 | + } else { |
|
| 1017 | + $offset = '+00:00'; |
|
| 1018 | + } |
|
| 954 | 1019 | $filter_query = $this->getFilter($filters,true,true); |
| 955 | 1020 | if ($globalDBdriver == 'mysql') { |
| 956 | 1021 | $query = "SELECT DATE(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count |
@@ -996,7 +1061,9 @@ discard block |
||
| 996 | 1061 | date_default_timezone_set($globalTimezone); |
| 997 | 1062 | $datetime = new DateTime(); |
| 998 | 1063 | $offset = $datetime->format('P'); |
| 999 | - } else $offset = '+00:00'; |
|
| 1064 | + } else { |
|
| 1065 | + $offset = '+00:00'; |
|
| 1066 | + } |
|
| 1000 | 1067 | $filter_query = $this->getFilter($filters,true,true); |
| 1001 | 1068 | if ($globalDBdriver == 'mysql') { |
| 1002 | 1069 | $query = "SELECT DATE(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count |
@@ -1044,7 +1111,9 @@ discard block |
||
| 1044 | 1111 | date_default_timezone_set($globalTimezone); |
| 1045 | 1112 | $datetime = new DateTime(); |
| 1046 | 1113 | $offset = $datetime->format('P'); |
| 1047 | - } else $offset = '+00:00'; |
|
| 1114 | + } else { |
|
| 1115 | + $offset = '+00:00'; |
|
| 1116 | + } |
|
| 1048 | 1117 | |
| 1049 | 1118 | if ($globalDBdriver == 'mysql') { |
| 1050 | 1119 | $query = "SELECT YEAR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS year_name,MONTH(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS month_name, count(*) as date_count |
@@ -1093,7 +1162,9 @@ discard block |
||
| 1093 | 1162 | date_default_timezone_set($globalTimezone); |
| 1094 | 1163 | $datetime = new DateTime(); |
| 1095 | 1164 | $offset = $datetime->format('P'); |
| 1096 | - } else $offset = '+00:00'; |
|
| 1165 | + } else { |
|
| 1166 | + $offset = '+00:00'; |
|
| 1167 | + } |
|
| 1097 | 1168 | $filter_query = $this->getFilter($filters,true,true); |
| 1098 | 1169 | if ($globalDBdriver == 'mysql') { |
| 1099 | 1170 | $query = "SELECT MONTH(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS month_name, YEAR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS year_name, count(*) as date_count |
@@ -1142,7 +1213,9 @@ discard block |
||
| 1142 | 1213 | date_default_timezone_set($globalTimezone); |
| 1143 | 1214 | $datetime = new DateTime(); |
| 1144 | 1215 | $offset = $datetime->format('P'); |
| 1145 | - } else $offset = '+00:00'; |
|
| 1216 | + } else { |
|
| 1217 | + $offset = '+00:00'; |
|
| 1218 | + } |
|
| 1146 | 1219 | |
| 1147 | 1220 | $orderby_sql = ''; |
| 1148 | 1221 | if ($orderby == "hour") |
@@ -1211,7 +1284,9 @@ discard block |
||
| 1211 | 1284 | date_default_timezone_set($globalTimezone); |
| 1212 | 1285 | $datetime = new DateTime($date); |
| 1213 | 1286 | $offset = $datetime->format('P'); |
| 1214 | - } else $offset = '+00:00'; |
|
| 1287 | + } else { |
|
| 1288 | + $offset = '+00:00'; |
|
| 1289 | + } |
|
| 1215 | 1290 | |
| 1216 | 1291 | if ($globalDBdriver == 'mysql') { |
| 1217 | 1292 | $query = "SELECT HOUR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count |
@@ -1259,7 +1334,9 @@ discard block |
||
| 1259 | 1334 | date_default_timezone_set($globalTimezone); |
| 1260 | 1335 | $datetime = new DateTime(); |
| 1261 | 1336 | $offset = $datetime->format('P'); |
| 1262 | - } else $offset = '+00:00'; |
|
| 1337 | + } else { |
|
| 1338 | + $offset = '+00:00'; |
|
| 1339 | + } |
|
| 1263 | 1340 | |
| 1264 | 1341 | if ($globalDBdriver == 'mysql') { |
| 1265 | 1342 | $query = "SELECT HOUR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count |
@@ -1324,8 +1401,11 @@ discard block |
||
| 1324 | 1401 | $query_values = array_merge($query_values,array(':month' => $month)); |
| 1325 | 1402 | } |
| 1326 | 1403 | } |
| 1327 | - if (empty($query_values)) $queryi .= $this->getFilter($filters); |
|
| 1328 | - else $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
| 1404 | + if (empty($query_values)) { |
|
| 1405 | + $queryi .= $this->getFilter($filters); |
|
| 1406 | + } else { |
|
| 1407 | + $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
| 1408 | + } |
|
| 1329 | 1409 | |
| 1330 | 1410 | $sth = $this->db->prepare($queryi); |
| 1331 | 1411 | $sth->execute($query_values); |
@@ -1362,8 +1442,11 @@ discard block |
||
| 1362 | 1442 | $query_values = array_merge($query_values,array(':month' => $month)); |
| 1363 | 1443 | } |
| 1364 | 1444 | } |
| 1365 | - if (empty($query_values)) $queryi .= $this->getFilter($filters); |
|
| 1366 | - else $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
| 1445 | + if (empty($query_values)) { |
|
| 1446 | + $queryi .= $this->getFilter($filters); |
|
| 1447 | + } else { |
|
| 1448 | + $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
| 1449 | + } |
|
| 1367 | 1450 | |
| 1368 | 1451 | $sth = $this->db->prepare($queryi); |
| 1369 | 1452 | $sth->execute($query_values); |
@@ -1385,7 +1468,9 @@ discard block |
||
| 1385 | 1468 | date_default_timezone_set($globalTimezone); |
| 1386 | 1469 | $datetime = new DateTime(); |
| 1387 | 1470 | $offset = $datetime->format('P'); |
| 1388 | - } else $offset = '+00:00'; |
|
| 1471 | + } else { |
|
| 1472 | + $offset = '+00:00'; |
|
| 1473 | + } |
|
| 1389 | 1474 | |
| 1390 | 1475 | if ($globalDBdriver == 'mysql') { |
| 1391 | 1476 | $query = "SELECT HOUR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count |
@@ -1489,7 +1574,9 @@ discard block |
||
| 1489 | 1574 | */ |
| 1490 | 1575 | public function parseDirection($direction = 0) |
| 1491 | 1576 | { |
| 1492 | - if ($direction == '') $direction = 0; |
|
| 1577 | + if ($direction == '') { |
|
| 1578 | + $direction = 0; |
|
| 1579 | + } |
|
| 1493 | 1580 | $direction_array = array(); |
| 1494 | 1581 | $temp_array = array(); |
| 1495 | 1582 | |
@@ -1578,7 +1665,9 @@ discard block |
||
| 1578 | 1665 | $longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
| 1579 | 1666 | |
| 1580 | 1667 | $Connection = new Connection($this->db); |
| 1581 | - if (!$Connection->tableExists('countries')) return ''; |
|
| 1668 | + if (!$Connection->tableExists('countries')) { |
|
| 1669 | + return ''; |
|
| 1670 | + } |
|
| 1582 | 1671 | |
| 1583 | 1672 | try { |
| 1584 | 1673 | /* |
@@ -1598,9 +1687,13 @@ discard block |
||
| 1598 | 1687 | $sth->closeCursor(); |
| 1599 | 1688 | if (count($row) > 0) { |
| 1600 | 1689 | return $row; |
| 1601 | - } else return ''; |
|
| 1690 | + } else { |
|
| 1691 | + return ''; |
|
| 1692 | + } |
|
| 1602 | 1693 | } catch (PDOException $e) { |
| 1603 | - if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n"; |
|
| 1694 | + if (isset($globalDebug) && $globalDebug) { |
|
| 1695 | + echo 'Error : '.$e->getMessage()."\n"; |
|
| 1696 | + } |
|
| 1604 | 1697 | return ''; |
| 1605 | 1698 | } |
| 1606 | 1699 | |
@@ -1618,7 +1711,9 @@ discard block |
||
| 1618 | 1711 | $iso2 = filter_var($iso2,FILTER_SANITIZE_STRING); |
| 1619 | 1712 | |
| 1620 | 1713 | $Connection = new Connection($this->db); |
| 1621 | - if (!$Connection->tableExists('countries')) return ''; |
|
| 1714 | + if (!$Connection->tableExists('countries')) { |
|
| 1715 | + return ''; |
|
| 1716 | + } |
|
| 1622 | 1717 | |
| 1623 | 1718 | try { |
| 1624 | 1719 | $query = "SELECT name,iso2,iso3 FROM countries WHERE iso2 = :iso2 LIMIT 1"; |
@@ -1630,9 +1725,13 @@ discard block |
||
| 1630 | 1725 | $sth->closeCursor(); |
| 1631 | 1726 | if (count($row) > 0) { |
| 1632 | 1727 | return $row; |
| 1633 | - } else return ''; |
|
| 1728 | + } else { |
|
| 1729 | + return ''; |
|
| 1730 | + } |
|
| 1634 | 1731 | } catch (PDOException $e) { |
| 1635 | - if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n"; |
|
| 1732 | + if (isset($globalDebug) && $globalDebug) { |
|
| 1733 | + echo 'Error : '.$e->getMessage()."\n"; |
|
| 1734 | + } |
|
| 1636 | 1735 | return ''; |
| 1637 | 1736 | } |
| 1638 | 1737 | |
@@ -1693,7 +1792,9 @@ discard block |
||
| 1693 | 1792 | } |
| 1694 | 1793 | } |
| 1695 | 1794 | $query .= " GROUP BY tracker_output.type ORDER BY tracker_type_count DESC"; |
| 1696 | - if ($limit) $query .= " LIMIT 10 OFFSET 0"; |
|
| 1795 | + if ($limit) { |
|
| 1796 | + $query .= " LIMIT 10 OFFSET 0"; |
|
| 1797 | + } |
|
| 1697 | 1798 | $sth = $this->db->prepare($query); |
| 1698 | 1799 | $sth->execute($query_values); |
| 1699 | 1800 | $tracker_array = array(); |
@@ -1730,7 +1831,9 @@ discard block |
||
| 1730 | 1831 | foreach ($q_array as $q_item){ |
| 1731 | 1832 | $q_item = filter_var($q_item,FILTER_SANITIZE_STRING); |
| 1732 | 1833 | $additional_query .= " AND ("; |
| 1733 | - if (is_int($q_item)) $additional_query .= "(tracker_output.tracker_id = '".$q_item."') OR "; |
|
| 1834 | + if (is_int($q_item)) { |
|
| 1835 | + $additional_query .= "(tracker_output.tracker_id = '".$q_item."') OR "; |
|
| 1836 | + } |
|
| 1734 | 1837 | $additional_query .= "(tracker_output.ident like '%".$q_item."%') OR "; |
| 1735 | 1838 | $additional_query .= ")"; |
| 1736 | 1839 | } |
@@ -1756,7 +1859,9 @@ discard block |
||
| 1756 | 1859 | date_default_timezone_set($globalTimezone); |
| 1757 | 1860 | $datetime = new DateTime(); |
| 1758 | 1861 | $offset = $datetime->format('P'); |
| 1759 | - } else $offset = '+00:00'; |
|
| 1862 | + } else { |
|
| 1863 | + $offset = '+00:00'; |
|
| 1864 | + } |
|
| 1760 | 1865 | if ($date_array[1] != "") |
| 1761 | 1866 | { |
| 1762 | 1867 | $date_array[0] = date("Y-m-d H:i:s", strtotime($date_array[0])); |
@@ -1783,8 +1888,12 @@ discard block |
||
| 1783 | 1888 | if ($limit_array[0] >= 0 && $limit_array[1] >= 0) |
| 1784 | 1889 | { |
| 1785 | 1890 | $limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
| 1786 | - } else $limit_query = ""; |
|
| 1787 | - } else $limit_query = ""; |
|
| 1891 | + } else { |
|
| 1892 | + $limit_query = ""; |
|
| 1893 | + } |
|
| 1894 | + } else { |
|
| 1895 | + $limit_query = ""; |
|
| 1896 | + } |
|
| 1788 | 1897 | if ($sort != "") |
| 1789 | 1898 | { |
| 1790 | 1899 | $search_orderby_array = $this->getOrderBy(); |
@@ -1827,7 +1936,9 @@ discard block |
||
| 1827 | 1936 | { |
| 1828 | 1937 | global $globalBitlyAccessToken; |
| 1829 | 1938 | |
| 1830 | - if ($globalBitlyAccessToken == '') return $url; |
|
| 1939 | + if ($globalBitlyAccessToken == '') { |
|
| 1940 | + return $url; |
|
| 1941 | + } |
|
| 1831 | 1942 | $google_url = 'https://api-ssl.bitly.com/v3/shorten?access_token='.$globalBitlyAccessToken.'&longUrl='.$url; |
| 1832 | 1943 | $ch = curl_init(); |
| 1833 | 1944 | curl_setopt($ch, CURLOPT_HEADER, 0); |
@@ -22,7 +22,9 @@ |
||
| 22 | 22 | print '<select name="aircraft_manufacturer" class="selectpicker" data-live-search="true">'; |
| 23 | 23 | $Stats = new Stats(); |
| 24 | 24 | $all_manufacturers = $Stats->getAllManufacturers(); |
| 25 | - if (empty($all_manufacturers)) $all_manufacturers = $Spotter->getAllManufacturers(); |
|
| 25 | + if (empty($all_manufacturers)) { |
|
| 26 | + $all_manufacturers = $Spotter->getAllManufacturers(); |
|
| 27 | + } |
|
| 26 | 28 | foreach($all_manufacturers as $all_manufacturer) |
| 27 | 29 | { |
| 28 | 30 | if($manufacturer == ucwords($all_manufacturer['aircraft_manufacturer'])) |
@@ -22,7 +22,9 @@ |
||
| 22 | 22 | print '<select name="aircraft_manufacturer" class="selectpicker" data-live-search="true">'; |
| 23 | 23 | $Stats = new Stats(); |
| 24 | 24 | $all_manufacturers = $Stats->getAllManufacturers(); |
| 25 | - if (empty($all_manufacturers)) $all_manufacturers = $Spotter->getAllManufacturers(); |
|
| 25 | + if (empty($all_manufacturers)) { |
|
| 26 | + $all_manufacturers = $Spotter->getAllManufacturers(); |
|
| 27 | + } |
|
| 26 | 28 | foreach($all_manufacturers as $all_manufacturer) |
| 27 | 29 | { |
| 28 | 30 | if($manufacturer == ucwords($all_manufacturer['aircraft_manufacturer'])) |
@@ -1,13 +1,20 @@ |
||
| 1 | 1 | <?php |
| 2 | 2 | require_once(dirname(__FILE__).'/require/settings.php'); |
| 3 | 3 | $ident = ''; |
| 4 | -if (isset($_POST['ident'])) $ident = filter_input(INPUT_POST,'ident',FILTER_SANITIZE_STRING); |
|
| 5 | -if (isset($_GET['ident'])) $ident = filter_input(INPUT_GET,'ident',FILTER_SANITIZE_STRING); |
|
| 4 | +if (isset($_POST['ident'])) { |
|
| 5 | + $ident = filter_input(INPUT_POST,'ident',FILTER_SANITIZE_STRING); |
|
| 6 | +} |
|
| 7 | +if (isset($_GET['ident'])) { |
|
| 8 | + $ident = filter_input(INPUT_GET,'ident',FILTER_SANITIZE_STRING); |
|
| 9 | +} |
|
| 6 | 10 | if ($ident != '') |
| 7 | 11 | { |
| 8 | - if (isset($_GET['marine'])) header('Location: '.$globalURL.'/marine/ident/'.$ident); |
|
| 9 | - else header('Location: '.$globalURL.'/ident/'.$ident); |
|
| 10 | -} else { |
|
| 12 | + if (isset($_GET['marine'])) { |
|
| 13 | + header('Location: '.$globalURL.'/marine/ident/'.$ident); |
|
| 14 | + } else { |
|
| 15 | + header('Location: '.$globalURL.'/ident/'.$ident); |
|
| 16 | + } |
|
| 17 | + } else { |
|
| 11 | 18 | if ($globalURL == '') { |
| 12 | 19 | header('Location: /'); |
| 13 | 20 | } else { |