Ysurac / FlightAirMap

statistics-owner.php

Indentation +7 added lines, -7 removed lines

@@ -8,13 +8,13 @@ 
 if (!isset($filter_name)) $filter_name = '';
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
 if ($airline_icao == 'all') {
-    unset($_COOKIE['stats_airline_icao']);
-    setcookie('stats_airline_icao', '', time()-3600);
-    $airline_icao = '';
+	unset($_COOKIE['stats_airline_icao']);
+	setcookie('stats_airline_icao', '', time()-3600);
+	$airline_icao = '';
 } elseif ($airline_icao == '' && isset($_COOKIE['stats_airline_icao'])) {
-    $airline_icao = $_COOKIE['stats_airline_icao'];
+	$airline_icao = $_COOKIE['stats_airline_icao'];
 } elseif ($airline_icao == '' && isset($globalFilter)) {
-    if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
+	if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
 }
 setcookie('stats_airline_icao',$airline_icao);
 $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT);
@@ -35,14 +35,14 @@ 
           function drawChart() {
             var data = google.visualization.arrayToDataTable([
             	["'._("Owner").'", "'._("# of times").'"], ';
-            	$owner_data = '';
+				$owner_data = '';
 		foreach($owner_array as $owner_item)
 		{
 			$owner_data .= '[ "'.$owner_item['owner_name'].'",'.$owner_item['owner_count'].'],';
 		}
 		$owner_data = substr($owner_data, 0, -1);
 		print $owner_data;
-            print ']);
+			print ']);
     
             var options = {
             	chartArea: {"width": "80%", "height": "60%"},

statistics-pilot.php

Indentation +7 added lines, -7 removed lines

@@ -8,13 +8,13 @@ 
 if (!isset($filter_name)) $filter_name = '';
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
 if ($airline_icao == 'all') {
-    unset($_COOKIE['stats_airline_icao']);
-    setcookie('stats_airline_icao', '', time()-3600);
-    $airline_icao = '';
+	unset($_COOKIE['stats_airline_icao']);
+	setcookie('stats_airline_icao', '', time()-3600);
+	$airline_icao = '';
 } elseif ($airline_icao == '' && isset($_COOKIE['stats_airline_icao'])) {
-    $airline_icao = $_COOKIE['stats_airline_icao'];
+	$airline_icao = $_COOKIE['stats_airline_icao'];
 } elseif ($airline_icao == '' && isset($globalFilter)) {
-    if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
+	if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
 }
 setcookie('stats_airline_icao',$airline_icao);
 $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT);
@@ -36,14 +36,14 @@ 
           function drawChart() {
             var data = google.visualization.arrayToDataTable([
             	["'._("Pilot").'", "'._("# of times").'"], ';
-            	$pilot_data = '';
+				$pilot_data = '';
 		foreach($pilot_array as $pilot_item)
 		{
 			$pilot_data .= '[ "'.$pilot_item['pilot_name'].' ('.$pilot_item['pilot_id'].')",'.$pilot_item['pilot_count'].'],';
 		}
 		$pilot_data = substr($pilot_data, 0, -1);
 		print $pilot_data;
-            print ']);
+			print ']);
     
             var options = {
             	chartArea: {"width": "80%", "height": "60%"},

require/class.Stats.php

Indentation +737 added lines, -737 removed lines

@@ -15,33 +15,33 @@ 
 		if (isset($globalFilterName)) $this->filter_name = $globalFilterName;
 		$Connection = new Connection($dbc);
 		$this->db = $Connection->db();
-        }
+		}
               
 	public function addLastStatsUpdate($type,$stats_date) {
-                $query = "DELETE FROM config WHERE name = :type;
+				$query = "DELETE FROM config WHERE name = :type;
             		INSERT INTO config (name,value) VALUES (:type,:stats_date);";
-                $query_values = array('type' => $type,':stats_date' => $stats_date);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				$query_values = array('type' => $type,':stats_date' => $stats_date);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 
 	public function getLastStatsUpdate($type = 'last_update_stats') {
-                $query = "SELECT value FROM config WHERE name = :type";
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':type' => $type));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all;
-        }
-        public function deleteStats($filter_name = '') {
-        	/*
+				$query = "SELECT value FROM config WHERE name = :type";
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':type' => $type));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all;
+		}
+		public function deleteStats($filter_name = '') {
+			/*
         	$query = "DELETE FROM config WHERE name = 'last_update_stats'";
                  try {
                         $sth = $this->db->prepare($query);
@@ -50,80 +50,80 @@ 
                         return "error : ".$e->getMessage();
                 }
                 */
-        	$query = "DELETE FROM stats WHERE filter_name = :filter_name;DELETE FROM stats_aircraft WHERE filter_name = :filter_name;DELETE FROM stats_airline WHERE filter_name = :filter_name;DELETE FROM stats_airport WHERE filter_name = :filter_name;DELETE FROM stats_callsign WHERE filter_name = :filter_name;DELETE FROM stats_country WHERE filter_name = :filter_name;DELETE FROM stats_flight WHERE filter_name = :filter_name;DELETE FROM stats_owner WHERE filter_name = :filter_name;DELETE FROM stats_pilot WHERE filter_name = :filter_name;DELETE FROM stats_registration WHERE filter_name = :filter_name;";
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
-        public function deleteOldStats($filter_name = '') {
+			$query = "DELETE FROM stats WHERE filter_name = :filter_name;DELETE FROM stats_aircraft WHERE filter_name = :filter_name;DELETE FROM stats_airline WHERE filter_name = :filter_name;DELETE FROM stats_airport WHERE filter_name = :filter_name;DELETE FROM stats_callsign WHERE filter_name = :filter_name;DELETE FROM stats_country WHERE filter_name = :filter_name;DELETE FROM stats_flight WHERE filter_name = :filter_name;DELETE FROM stats_owner WHERE filter_name = :filter_name;DELETE FROM stats_pilot WHERE filter_name = :filter_name;DELETE FROM stats_registration WHERE filter_name = :filter_name;";
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
+		public function deleteOldStats($filter_name = '') {
         	
-        	$query = "DELETE FROM config WHERE name = 'last_update_stats'";
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute();
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
+			$query = "DELETE FROM config WHERE name = 'last_update_stats'";
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute();
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
                 
-        	$query = "DELETE FROM stats_aircraft WHERE filter_name = :filter_name;DELETE FROM stats_airline WHERE filter_name = :filter_name;DELETE FROM stats_callsign WHERE filter_name = :filter_name;DELETE FROM stats_country WHERE filter_name = :filter_name;DELETE FROM stats_owner WHERE filter_name = :filter_name;DELETE FROM stats_pilot WHERE filter_name = :filter_name;DELETE FROM stats_registration WHERE filter_name = :filter_name;";
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+			$query = "DELETE FROM stats_aircraft WHERE filter_name = :filter_name;DELETE FROM stats_airline WHERE filter_name = :filter_name;DELETE FROM stats_callsign WHERE filter_name = :filter_name;DELETE FROM stats_country WHERE filter_name = :filter_name;DELETE FROM stats_owner WHERE filter_name = :filter_name;DELETE FROM stats_pilot WHERE filter_name = :filter_name;DELETE FROM stats_registration WHERE filter_name = :filter_name;";
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 	public function getAllAirlineNames($filter_name = '') {
 		if ($filter_name == '') $filter_name = $this->filter_name;
-                $query = "SELECT * FROM stats_airline WHERE filter_name = :filter_name ORDER BY airline_name ASC";
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all;
-        }
+				$query = "SELECT * FROM stats_airline WHERE filter_name = :filter_name ORDER BY airline_name ASC";
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all;
+		}
 	public function getAllAircraftTypes($stats_airline = '',$filter_name = '') {
 		if ($filter_name == '') $filter_name = $this->filter_name;
-                $query = "SELECT * FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_manufacturer ASC";
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all;
-        }
+				$query = "SELECT * FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_manufacturer ASC";
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all;
+		}
 	public function getAllManufacturers($stats_airline = '',$filter_name = '') {
 		if ($filter_name == '') $filter_name = $this->filter_name;
-                $query = "SELECT DISTINCT(aircraft_manufacturer) FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name AND aircraft_manufacturer <> '' ORDER BY aircraft_manufacturer ASC";
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all;
-        }
+				$query = "SELECT DISTINCT(aircraft_manufacturer) FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name AND aircraft_manufacturer <> '' ORDER BY aircraft_manufacturer ASC";
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all;
+		}
 	public function getAllAirportNames($stats_airline = '',$filter_name = '') {
 		if ($filter_name == '') $filter_name = $this->filter_name;
-                $query = "SELECT airport_icao, airport_name,airport_city,airport_country FROM stats_airport WHERE stats_airline = :stats_airline AND filter_name = :filter_name AND stats_type = 'daily' GROUP BY airport_icao,airport_name,airport_city,airport_country ORDER BY airport_city ASC";
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all;
-        }
+				$query = "SELECT airport_icao, airport_name,airport_city,airport_country FROM stats_airport WHERE stats_airline = :stats_airline AND filter_name = :filter_name AND stats_type = 'daily' GROUP BY airport_icao,airport_name,airport_city,airport_country ORDER BY airport_city ASC";
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all;
+		}
 
 
 	public function countAllAircraftTypes($limit = true, $stats_airline = '', $filter_name = '',$year = '', $month = '') {
@@ -140,15 +140,15 @@ 
 			}
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
 		} else $all = array();
-                if (empty($all)) {
-            	    $filters = array('airlines' => array($stats_airline));
-            	    if ($filter_name != '') {
-            		    $filters = array_merge($filters,$globalStatsFilters[$filter_name]);
-            	    }
-            	    $Spotter = new Spotter($this->db);
-            	    $all = $Spotter->countAllAircraftTypes($limit,0,'',$filters,$year,$month);
-                }
-                return $all;
+				if (empty($all)) {
+					$filters = array('airlines' => array($stats_airline));
+					if ($filter_name != '') {
+						$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
+					}
+					$Spotter = new Spotter($this->db);
+					$all = $Spotter->countAllAircraftTypes($limit,0,'',$filters,$year,$month);
+				}
+				return $all;
 	}
 	public function countAllAirlineCountries($limit = true,$filter_name = '',$year = '',$month = '') {
 		global $globalStatsFilters;
@@ -164,15 +164,15 @@ 
 			}
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
 		} else $all = array();
-                if (empty($all)) {
-            		$Spotter = new Spotter($this->db);
-            		$filters = array();
-            		if ($filter_name != '') {
-            			$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
+				if (empty($all)) {
+					$Spotter = new Spotter($this->db);
+					$filters = array();
+					if ($filter_name != '') {
+						$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
-            		$all = $Spotter->countAllAirlineCountries($limit,$filters,$year,$month);
-                }
-                return $all;
+					$all = $Spotter->countAllAirlineCountries($limit,$filters,$year,$month);
+				}
+				return $all;
 	}
 	public function countAllAircraftManufacturers($limit = true,$stats_airline = '', $filter_name = '',$year = '', $month = '') {
 		global $globalStatsFilters;
@@ -213,37 +213,37 @@ 
 			}
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
 		} else $all = array();
-                if (empty($all)) {
+				if (empty($all)) {
 			$filters = array('airlines' => array($stats_airline));
 			if ($filter_name != '') {
-            			$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
+						$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
 			$Spotter = new Spotter($this->db);
 			$all = $Spotter->countAllArrivalCountries($limit,$filters,$year,$month);
-                }
-                return $all;
+				}
+				return $all;
 	}
 	public function countAllDepartureCountries($limit = true, $stats_airline = '', $filter_name = '', $year = '', $month = '') {
 		global $globalStatsFilters;
 		if ($filter_name == '') $filter_name = $this->filter_name;
 		if ($limit) $query = "SELECT airport_country AS airport_departure_country, SUM(departure) as airport_departure_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_departure_country ORDER BY airport_departure_country_count DESC LIMIT 10 OFFSET 0";
 		else $query = "SELECT airport_country AS airport_departure_country, SUM(departure) as airport_departure_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_departure_country ORDER BY airport_departure_country_count DESC";
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                if (empty($all)) {
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				if (empty($all)) {
 			$filters = array('airlines' => array($stats_airline));
 			if ($filter_name != '') {
-            			$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
+						$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
 			$Spotter = new Spotter($this->db);
 			$all = $Spotter->countAllDepartureCountries($filters,$year,$month);
-                }
-                return $all;
+				}
+				return $all;
 	}
 
 	public function countAllAirlines($limit = true,$filter_name = '',$year = '',$month = '') {
@@ -260,16 +260,16 @@ 
 			}
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
 		} else $all = array();
-                if (empty($all)) {
-	                $Spotter = new Spotter($this->db);
-            		$filters = array();
-            		if ($filter_name != '') {
-            			$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
+				if (empty($all)) {
+					$Spotter = new Spotter($this->db);
+					$filters = array();
+					if ($filter_name != '') {
+						$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
 
-    		        $all = $Spotter->countAllAirlines($limit,0,'',$filters,$year,$month);
-                }
-                return $all;
+					$all = $Spotter->countAllAirlines($limit,0,'',$filters,$year,$month);
+				}
+				return $all;
 	}
 	public function countAllAircraftRegistrations($limit = true,$stats_airline = '',$filter_name = '',$year = '',$month = '') {
 		global $globalStatsFilters;
@@ -285,15 +285,15 @@ 
 			}
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
 		} else $all = array();
-                if (empty($all)) {
+				if (empty($all)) {
 			$filters = array('airlines' => array($stats_airline));
 			if ($filter_name != '') {
 				$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
-	                $Spotter = new Spotter($this->db);
-    		        $all = $Spotter->countAllAircraftRegistrations($limit,0,'',$filters,$year,$month);
-                }
-                return $all;
+					$Spotter = new Spotter($this->db);
+					$all = $Spotter->countAllAircraftRegistrations($limit,0,'',$filters,$year,$month);
+				}
+				return $all;
 	}
 	public function countAllCallsigns($limit = true,$stats_airline = '',$filter_name = '',$year = '',$month = '') {
 		global $globalStatsFilters;
@@ -333,7 +333,7 @@ 
 					echo "error : ".$e->getMessage();
 				}
 				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                /*
+				/*
                 if (empty($all)) {
 	                $Spotter = new Spotter($this->db);
     		        $all = $Spotter->countAllFlightOverCountries($limit);
@@ -384,15 +384,15 @@ 
 			}
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
 		} else $all = array();
-                if (empty($all)) {
+				if (empty($all)) {
 			$filters = array('airlines' => array($stats_airline));
 			if ($filter_name != '') {
 				$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
-            		$Spotter = new Spotter($this->db);
-            		$all = $Spotter->countAllOwners($limit,0,'',$filters,$year,$month);
-                }
-                return $all;
+					$Spotter = new Spotter($this->db);
+					$all = $Spotter->countAllOwners($limit,0,'',$filters,$year,$month);
+				}
+				return $all;
 	}
 	public function countAllDepartureAirports($limit = true,$stats_airline = '',$filter_name = '',$year = '',$month = '') {
 		global $globalStatsFilters;
@@ -408,33 +408,33 @@ 
 			}
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
 		} else $all = array();
-                if (empty($all)) {
+				if (empty($all)) {
 			$filters = array('airlines' => array($stats_airline));
-            		if ($filter_name != '') {
-            			$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
-			}
-            		$Spotter = new Spotter($this->db);
-            		$pall = $Spotter->countAllDepartureAirports($limit,0,'',$filters,$year,$month);
-        		$dall = $Spotter->countAllDetectedDepartureAirports($limit,0,'',$filters,$year,$month);
-        		$all = array();
-        		foreach ($pall as $value) {
-        			$icao = $value['airport_departure_icao'];
-        			$all[$icao] = $value;
-        		}
+					if ($filter_name != '') {
+						$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
+			}
+					$Spotter = new Spotter($this->db);
+					$pall = $Spotter->countAllDepartureAirports($limit,0,'',$filters,$year,$month);
+				$dall = $Spotter->countAllDetectedDepartureAirports($limit,0,'',$filters,$year,$month);
+				$all = array();
+				foreach ($pall as $value) {
+					$icao = $value['airport_departure_icao'];
+					$all[$icao] = $value;
+				}
         		
-        		foreach ($dall as $value) {
-        			$icao = $value['airport_departure_icao'];
-        			if (isset($all[$icao])) {
-        				$all[$icao]['airport_departure_icao_count'] = $all[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
-        			} else $all[$icao] = $value;
-        		}
-        		$count = array();
-        		foreach ($all as $key => $row) {
-        			$count[$key] = $row['airport_departure_icao_count'];
-        		}
-        		array_multisort($count,SORT_DESC,$all);
-                }
-                return $all;
+				foreach ($dall as $value) {
+					$icao = $value['airport_departure_icao'];
+					if (isset($all[$icao])) {
+						$all[$icao]['airport_departure_icao_count'] = $all[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
+					} else $all[$icao] = $value;
+				}
+				$count = array();
+				foreach ($all as $key => $row) {
+					$count[$key] = $row['airport_departure_icao_count'];
+				}
+				array_multisort($count,SORT_DESC,$all);
+				}
+				return $all;
 	}
 	public function countAllArrivalAirports($limit = true,$stats_airline = '',$filter_name = '',$year = '',$month = '') {
 		global $globalStatsFilters;
@@ -458,26 +458,26 @@ 
 			$Spotter = new Spotter($this->db);
 			$pall = $Spotter->countAllArrivalAirports($limit,0,'',false,$filters,$year,$month);
 			$dall = $Spotter->countAllDetectedArrivalAirports($limit,0,'',false,$filters,$year,$month);
-        		$all = array();
-        		foreach ($pall as $value) {
-        			$icao = $value['airport_arrival_icao'];
-        			$all[$icao] = $value;
-        		}
+				$all = array();
+				foreach ($pall as $value) {
+					$icao = $value['airport_arrival_icao'];
+					$all[$icao] = $value;
+				}
         		
-        		foreach ($dall as $value) {
-        			$icao = $value['airport_arrival_icao'];
-        			if (isset($all[$icao])) {
-        				$all[$icao]['airport_arrival_icao_count'] = $all[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
-        			} else $all[$icao] = $value;
-        		}
-        		$count = array();
-        		foreach ($all as $key => $row) {
-        			$count[$key] = $row['airport_arrival_icao_count'];
-        		}
-        		array_multisort($count,SORT_DESC,$all);
-                }
+				foreach ($dall as $value) {
+					$icao = $value['airport_arrival_icao'];
+					if (isset($all[$icao])) {
+						$all[$icao]['airport_arrival_icao_count'] = $all[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
+					} else $all[$icao] = $value;
+				}
+				$count = array();
+				foreach ($all as $key => $row) {
+					$count[$key] = $row['airport_arrival_icao_count'];
+				}
+				array_multisort($count,SORT_DESC,$all);
+				}
  
-                return $all;
+				return $all;
 	}
 	public function countAllMonthsLastYear($limit = true,$stats_airline = '',$filter_name = '') {
 		global $globalDBdriver, $globalStatsFilters;
@@ -490,23 +490,23 @@ 
 			else $query = "SELECT EXTRACT(MONTH FROM stats_date) as month_name, EXTRACT(YEAR FROM stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
 		}
 		$query_data = array(':stats_airline' => $stats_airline,':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_data);
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                if (empty($all)) {
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_data);
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				if (empty($all)) {
 			$filters = array('airlines' => array($stats_airline));
 			if ($filter_name != '') {
 				$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
-            		$Spotter = new Spotter($this->db);
-            		$all = $Spotter->countAllMonthsLastYear($filters);
-                }
+					$Spotter = new Spotter($this->db);
+					$all = $Spotter->countAllMonthsLastYear($filters);
+				}
                 
-                return $all;
+				return $all;
 	}
 	
 	public function countAllDatesLastMonth($stats_airline = '',$filter_name = '') {
@@ -514,22 +514,22 @@ 
 		if ($filter_name == '') $filter_name = $this->filter_name;
 		$query = "SELECT flight_date as date_name, cnt as date_count FROM stats_flight WHERE stats_type = 'month' AND stats_airline = :stats_airline AND filter_name = :filter_name";
 		$query_data = array(':stats_airline' => $stats_airline,':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_data);
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                if (empty($all)) {
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_data);
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				if (empty($all)) {
 			$filters = array('airlines' => array($stats_airline));
 			if ($filter_name != '') {
 				$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
-            		$Spotter = new Spotter($this->db);
-            		$all = $Spotter->countAllDatesLastMonth($filters);
-                }
-                return $all;
+					$Spotter = new Spotter($this->db);
+					$all = $Spotter->countAllDatesLastMonth($filters);
+				}
+				return $all;
 	}
 	public function countAllDatesLast7Days($stats_airline = '',$filter_name = '') {
 		global $globalDBdriver, $globalStatsFilters;
@@ -540,108 +540,108 @@ 
 			$query = "SELECT flight_date as date_name, cnt as date_count FROM stats_flight WHERE stats_type = 'month' AND flight_date::timestamp >= CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '7 DAYS' AND stats_airline = :stats_airline AND filter_name = :filter_name";
 		}
 		$query_data = array(':stats_airline' => $stats_airline,':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_data);
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                if (empty($all)) {
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_data);
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				if (empty($all)) {
 			$filters = array('airlines' => array($stats_airline));
 			if ($filter_name != '') {
 				$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
-            		$Spotter = new Spotter($this->db);
-            		$all = $Spotter->countAllDatesLast7Days($filters);
-                }
-                return $all;
+					$Spotter = new Spotter($this->db);
+					$all = $Spotter->countAllDatesLast7Days($filters);
+				}
+				return $all;
 	}
 	public function countAllDates($stats_airline = '',$filter_name = '') {
 		global $globalStatsFilters;
 		if ($filter_name == '') $filter_name = $this->filter_name;
 		$query = "SELECT flight_date as date_name, cnt as date_count FROM stats_flight WHERE stats_type = 'date' AND stats_airline = :stats_airline AND filter_name = :filter_name";
 		$query_data = array(':stats_airline' => $stats_airline,':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_data);
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                if (empty($all)) {
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_data);
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				if (empty($all)) {
 			$filters = array('airlines' => array($stats_airline));
 			if ($filter_name != '') {
-            			$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
+						$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
-            		$Spotter = new Spotter($this->db);
-            		$all = $Spotter->countAllDates($filters);
-                }
-                return $all;
+					$Spotter = new Spotter($this->db);
+					$all = $Spotter->countAllDates($filters);
+				}
+				return $all;
 	}
 	public function countAllDatesByAirlines($filter_name = '') {
 		global $globalStatsFilters;
 		if ($filter_name == '') $filter_name = $this->filter_name;
 		$query = "SELECT stats_airline as airline_icao, flight_date as date_name, cnt as date_count FROM stats_flight WHERE stats_type = 'date' AND filter_name = :filter_name";
 		$query_data = array('filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_data);
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                if (empty($all)) {
-            		$filters = array();
-            		if ($filter_name != '') {
-            			$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_data);
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				if (empty($all)) {
+					$filters = array();
+					if ($filter_name != '') {
+						$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
-            		$Spotter = new Spotter($this->db);
-            		$all = $Spotter->countAllDatesByAirlines($filters);
-                }
-                return $all;
+					$Spotter = new Spotter($this->db);
+					$all = $Spotter->countAllDatesByAirlines($filters);
+				}
+				return $all;
 	}
 	public function countAllMonths($stats_airline = '',$filter_name = '') {
 		global $globalStatsFilters;
 		if ($filter_name == '') $filter_name = $this->filter_name;
-	    	$query = "SELECT YEAR(stats_date) AS year_name,MONTH(stats_date) AS month_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':stats_airline' => $stats_airline, ':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                if (empty($all)) {
+			$query = "SELECT YEAR(stats_date) AS year_name,MONTH(stats_date) AS month_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':stats_airline' => $stats_airline, ':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				if (empty($all)) {
 			$filters = array('airlines' => array($stats_airline));
 			if ($filter_name != '') {
 				$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
-            		$Spotter = new Spotter($this->db);
-            		$all = $Spotter->countAllMonths($filters);
-                }
-                return $all;
+					$Spotter = new Spotter($this->db);
+					$all = $Spotter->countAllMonths($filters);
+				}
+				return $all;
 	}
 	public function countAllMilitaryMonths($filter_name = '') {
 		global $globalStatsFilters;
 		if ($filter_name == '') $filter_name = $this->filter_name;
-	    	$query = "SELECT YEAR(stats_date) AS year_name,MONTH(stats_date) AS month_name, cnt as date_count FROM stats WHERE stats_type = 'military_flights_bymonth' AND filter_name = :filter_name";
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                if (empty($all)) {
-            		$filters = array();
-            		if ($filter_name != '') {
-            			$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
+			$query = "SELECT YEAR(stats_date) AS year_name,MONTH(stats_date) AS month_name, cnt as date_count FROM stats WHERE stats_type = 'military_flights_bymonth' AND filter_name = :filter_name";
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				if (empty($all)) {
+					$filters = array();
+					if ($filter_name != '') {
+						$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
-            		$Spotter = new Spotter($this->db);
-            		$all = $Spotter->countAllMilitaryMonths($filters);
-                }
-                return $all;
+					$Spotter = new Spotter($this->db);
+					$all = $Spotter->countAllMilitaryMonths($filters);
+				}
+				return $all;
 	}
 	public function countAllHours($orderby = 'hour',$limit = true,$stats_airline = '',$filter_name = '') {
 		global $globalTimezone, $globalDBdriver, $globalStatsFilters;
@@ -657,22 +657,22 @@ 
 			$query .= " ORDER BY CAST(flight_date AS integer) ASC";
 		}
 		if ($orderby == 'count') $query .= " ORDER BY hour_count DESC";
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':stats_airline' => $stats_airline, ':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                if (empty($all)) {
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':stats_airline' => $stats_airline, ':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				if (empty($all)) {
 			$filters = array('airlines' => array($stats_airline));
 			if ($filter_name != '') {
-            			$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
+						$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
-            		$Spotter = new Spotter($this->db);
-            		$all = $Spotter->countAllHours($orderby,$filters);
-                }
-                return $all;
+					$Spotter = new Spotter($this->db);
+					$all = $Spotter->countAllHours($orderby,$filters);
+				}
+				return $all;
 	}
 	
 	public function countOverallFlights($stats_airline = '', $filter_name = '',$year = '',$month = '') {
@@ -696,9 +696,9 @@ 
 		if ($year == '') $year = date('Y');
 		$all = $this->getSumStats('military_flights_bymonth',$year,'',$filter_name,$month);
 		if (empty($all)) {
-		        $filters = array();
-            		if ($filter_name != '') {
-            			$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
+				$filters = array();
+					if ($filter_name != '') {
+						$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
 			$Spotter = new Spotter($this->db);
 			$all = $Spotter->countOverallMilitaryFlights($filters,$year,$month);
@@ -750,9 +750,9 @@ 
 			$all = $result[0]['nb_airline'];
 		} else $all = $this->getSumStats('airlines_bymonth',$year,'',$filter_name,$month);
 		if (empty($all)) {
-            		$filters = array();
-            		if ($filter_name != '') {
-            			$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
+					$filters = array();
+					if ($filter_name != '') {
+						$filters = array_merge($filters,$globalStatsFilters[$filter_name]);
 			}
 			$Spotter = new Spotter($this->db);
 			$all = $Spotter->countOverallAirlines($filters,$year,$month);
@@ -805,33 +805,33 @@ 
 		if ($filter_name == '') $filter_name = $this->filter_name;
 		$query = "SELECT * FROM stats_airport WHERE stats_type = 'daily' AND airport_icao = :airport_icao AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY date";
 		$query_values = array(':airport_icao' => $airport_icao,':stats_airline' => $stats_airline, ':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all;
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all;
 	}
 	public function getStats($type,$stats_airline = '', $filter_name = '') {
 		if ($filter_name == '') $filter_name = $this->filter_name;
-                $query = "SELECT * FROM stats WHERE stats_type = :type AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY stats_date";
-                $query_values = array(':type' => $type,':stats_airline' => $stats_airline,':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all;
-        }
+				$query = "SELECT * FROM stats WHERE stats_type = :type AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY stats_date";
+				$query_values = array(':type' => $type,':stats_airline' => $stats_airline,':filter_name' => $filter_name);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all;
+		}
 	public function getSumStats($type,$year,$stats_airline = '',$filter_name = '',$month = '') {
 		if ($filter_name == '') $filter_name = $this->filter_name;
-    		global $globalArchiveMonths, $globalDBdriver;
-    		if ($globalDBdriver == 'mysql') {
-    			if ($month == '') {
+			global $globalArchiveMonths, $globalDBdriver;
+			if ($globalDBdriver == 'mysql') {
+				if ($month == '') {
 				$query = "SELECT SUM(cnt) as total FROM stats WHERE stats_type = :type AND YEAR(stats_date) = :year AND stats_airline = :stats_airline AND filter_name = :filter_name";
 				$query_values = array(':type' => $type, ':year' => $year, ':stats_airline' => $stats_airline,':filter_name' => $filter_name);
 			} else {
@@ -846,137 +846,137 @@ 
 				$query = "SELECT SUM(cnt) as total FROM stats WHERE stats_type = :type AND EXTRACT(YEAR FROM stats_date) = :year AND EXTRACT(MONTH FROM stats_date) = :month AND stats_airline = :stats_airline AND filter_name = :filter_name";
 				$query_values = array(':type' => $type, ':year' => $year, ':stats_airline' => $stats_airline,':filter_name' => $filter_name,':month' => $month);
 			}
-                }
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all[0]['total'];
-        }
+				}
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all[0]['total'];
+		}
 	public function getStatsTotal($type, $stats_airline = '', $filter_name = '') {
-    		global $globalArchiveMonths, $globalDBdriver;
+			global $globalArchiveMonths, $globalDBdriver;
 		if ($filter_name == '') $filter_name = $this->filter_name;
-    		if ($globalDBdriver == 'mysql') {
+			if ($globalDBdriver == 'mysql') {
 			$query = "SELECT SUM(cnt) as total FROM stats WHERE stats_type = :type AND stats_date < DATE_SUB(UTC_TIMESTAMP(), INTERVAL ".$globalArchiveMonths." MONTH) AND stats_airline = :stats_airline AND filter_name = :filter_name";
 		} else {
 			$query = "SELECT SUM(cnt) as total FROM stats WHERE stats_type = :type AND stats_date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalArchiveMonths." MONTHS' AND stats_airline = :stats_airline AND filter_name = :filter_name";
-                }
-                $query_values = array(':type' => $type, ':stats_airline' => $stats_airline, ':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all[0]['total'];
-        }
+				}
+				$query_values = array(':type' => $type, ':stats_airline' => $stats_airline, ':filter_name' => $filter_name);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all[0]['total'];
+		}
 	public function getStatsAircraftTotal($stats_airline = '', $filter_name = '') {
-    		global $globalArchiveMonths, $globalDBdriver;
+			global $globalArchiveMonths, $globalDBdriver;
 		if ($filter_name == '') $filter_name = $this->filter_name;
-    		if ($globalDBdriver == 'mysql') {
+			if ($globalDBdriver == 'mysql') {
 			$query = "SELECT SUM(cnt) as total FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name";
-                } else {
+				} else {
 			$query = "SELECT SUM(cnt) as total FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name";
-                }
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':stats_airline' => $stats_airline, ':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all[0]['total'];
-        }
+				}
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':stats_airline' => $stats_airline, ':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all[0]['total'];
+		}
 	public function getStatsAirlineTotal($filter_name = '') {
-    		global $globalArchiveMonths, $globalDBdriver;
+			global $globalArchiveMonths, $globalDBdriver;
 		if ($filter_name == '') $filter_name = $this->filter_name;
-    		if ($globalDBdriver == 'mysql') {
+			if ($globalDBdriver == 'mysql') {
 			$query = "SELECT SUM(cnt) as total FROM stats_airline WHERE filter_name = :filter_name";
-                } else {
+				} else {
 			$query = "SELECT SUM(cnt) as total FROM stats_airline WHERE filter_name = :filter_name";
-                }
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all[0]['total'];
-        }
+				}
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all[0]['total'];
+		}
 	public function getStatsOwnerTotal($filter_name = '') {
-    		global $globalArchiveMonths, $globalDBdriver;
+			global $globalArchiveMonths, $globalDBdriver;
 		if ($filter_name == '') $filter_name = $this->filter_name;
-    		if ($globalDBdriver == 'mysql') {
+			if ($globalDBdriver == 'mysql') {
 			$query = "SELECT SUM(cnt) as total FROM stats_owner WHERE filter_name = :filter_name";
 		} else {
 			$query = "SELECT SUM(cnt) as total FROM stats_owner WHERE filter_name = :filter_name";
-                }
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all[0]['total'];
-        }
+				}
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all[0]['total'];
+		}
 	public function getStatsPilotTotal($filter_name = '') {
-    		global $globalArchiveMonths, $globalDBdriver;
+			global $globalArchiveMonths, $globalDBdriver;
 		if ($filter_name == '') $filter_name = $this->filter_name;
-    		if ($globalDBdriver == 'mysql') {
-            		$query = "SELECT SUM(cnt) as total FROM stats_pilot WHERE filter_name = :filter_name";
-            	} else {
-            		$query = "SELECT SUM(cnt) as total FROM stats_pilot WHERE filter_name = :filter_name";
-            	}
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute(array(':filter_name' => $filter_name));
-                } catch(PDOException $e) {
-                        echo "error : ".$e->getMessage();
-                }
-                $all = $sth->fetchAll(PDO::FETCH_ASSOC);
-                return $all[0]['total'];
-        }
+			if ($globalDBdriver == 'mysql') {
+					$query = "SELECT SUM(cnt) as total FROM stats_pilot WHERE filter_name = :filter_name";
+				} else {
+					$query = "SELECT SUM(cnt) as total FROM stats_pilot WHERE filter_name = :filter_name";
+				}
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute(array(':filter_name' => $filter_name));
+				} catch(PDOException $e) {
+						echo "error : ".$e->getMessage();
+				}
+				$all = $sth->fetchAll(PDO::FETCH_ASSOC);
+				return $all[0]['total'];
+		}
 
 	public function addStat($type,$cnt,$stats_date,$stats_airline = '',$filter_name = '') {
 		global $globalDBdriver;
 		if ($filter_name == '') $filter_name = $this->filter_name;
 		if ($globalDBdriver == 'mysql') {
 			$query = "INSERT INTO stats (stats_type,cnt,stats_date,stats_airline,filter_name) VALUES (:type,:cnt,:stats_date,:stats_airline,:filter_name) ON DUPLICATE KEY UPDATE cnt = :cnt";
-                } else {
+				} else {
 			$query = "UPDATE stats SET cnt = :cnt WHERE stats_type = :type AND stats_date = :stats_date AND stats_airline = :stats_airline AND filter_name = :filter_name; INSERT INTO stats (stats_type,cnt,stats_date,stats_airline,filter_name) SELECT :type,:cnt,:stats_date,:stats_airline,:filter_name WHERE NOT EXISTS (SELECT 1 FROM stats WHERE  stats_type = :type AND stats_date = :stats_date AND stats_airline = :stats_airline AND filter_name = :filter_name);"; 
 		}
-                $query_values = array(':type' => $type,':cnt' => $cnt,':stats_date' => $stats_date, ':stats_airline' => $stats_airline,':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				$query_values = array(':type' => $type,':cnt' => $cnt,':stats_date' => $stats_date, ':stats_airline' => $stats_airline,':filter_name' => $filter_name);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 	public function updateStat($type,$cnt,$stats_date,$stats_airline = '',$filter_name = '') {
 		global $globalDBdriver;
 		if ($filter_name == '') $filter_name = $this->filter_name;
 		if ($globalDBdriver == 'mysql') {
 			$query = "INSERT INTO stats (stats_type,cnt,stats_date,stats_airline,filter_name) VALUES (:type,:cnt,:stats_date,:stats_airline,:filter_name) ON DUPLICATE KEY UPDATE cnt = cnt+:cnt, stats_date = :date";
 		} else {
-            		//$query = "INSERT INTO stats (stats_type,cnt,stats_date) VALUES (:type,:cnt,:stats_date) ON DUPLICATE KEY UPDATE cnt = cnt+:cnt, stats_date = :date";
+					//$query = "INSERT INTO stats (stats_type,cnt,stats_date) VALUES (:type,:cnt,:stats_date) ON DUPLICATE KEY UPDATE cnt = cnt+:cnt, stats_date = :date";
 			$query = "UPDATE stats SET cnt = cnt+:cnt WHERE stats_type = :type AND stats_date = :stats_date AND stats_airline = :stats_airline AND filter_name = :filter_name; INSERT INTO stats (stats_type,cnt,stats_date,stats_airline,filter_name) SELECT :type,:cnt,:stats_date,:stats_airline,:filter_name WHERE NOT EXISTS (SELECT 1 FROM stats WHERE  stats_type = :type AND stats_date = :stats_date AND stats_airline = :stats_airline AND filter_name = :filter_name);"; 
-                }
-                $query_values = array(':type' => $type,':cnt' => $cnt,':stats_date' => $stats_date,':stats_airline' => $stats_airline,':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
-        /*
+				}
+				$query_values = array(':type' => $type,':cnt' => $cnt,':stats_date' => $stats_date,':stats_airline' => $stats_airline,':filter_name' => $filter_name);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
+		/*
 	public function getStatsSource($date,$stats_type = '') {
 		if ($stats_type == '') {
 			$query = "SELECT * FROM stats_source WHERE stats_date = :date ORDER BY source_name";
@@ -1045,25 +1045,25 @@ 
 			$query = "INSERT INTO stats_source (source_data,source_name,stats_type,stats_date) VALUES (:data,:source_name,:stats_type,:stats_date) ON DUPLICATE KEY UPDATE source_data = :data";
 		} else {
 			$query = "UPDATE stats_source SET source_data = :data WHERE stats_date = :stats_date AND source_name = :source_name AND stats_type = :stats_type; INSERT INTO stats_source (source_data,source_name,stats_type,stats_date) SELECT :data,:source_name,:stats_type,:stats_date WHERE NOT EXISTS (SELECT 1 FROM stats_source WHERE stats_date = :stats_date AND source_name = :source_name AND stats_type = :stats_type);"; 
-                }
-                $query_values = array(':data' => $data,':stats_date' => $date,':source_name' => $source_name,':stats_type' => $stats_type);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
-	public function addStatFlight($type,$date_name,$cnt,$stats_airline = '',$filter_name = '') {
-                $query = "INSERT INTO stats_flight (stats_type,flight_date,cnt,stats_airline,filter_name) VALUES (:type,:flight_date,:cnt,:stats_airline,:filter_name)";
-                $query_values = array(':type' => $type,':flight_date' => $date_name,':cnt' => $cnt, ':stats_airline' => $stats_airline,':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				}
+				$query_values = array(':data' => $data,':stats_date' => $date,':source_name' => $source_name,':stats_type' => $stats_type);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
+	public function addStatFlight($type,$date_name,$cnt,$stats_airline = '',$filter_name = '') {
+				$query = "INSERT INTO stats_flight (stats_type,flight_date,cnt,stats_airline,filter_name) VALUES (:type,:flight_date,:cnt,:stats_airline,:filter_name)";
+				$query_values = array(':type' => $type,':flight_date' => $date_name,':cnt' => $cnt, ':stats_airline' => $stats_airline,':filter_name' => $filter_name);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 	public function addStatAircraftRegistration($registration,$cnt,$aircraft_icao = '',$airline_icao = '',$filter_name = '',$reset = false) {
 		global $globalDBdriver;
 		if ($globalDBdriver == 'mysql') {
@@ -1079,14 +1079,14 @@ 
 				$query = "UPDATE stats_registration SET cnt = cnt+:cnt WHERE registration = :registration AND stats_airline = :stats_airline AND filter_name = :filter_name; INSERT INTO stats_registration (aircraft_icao,registration,cnt,stats_airline,filter_name) SELECT :aircraft_icao,:registration,:cnt,:stats_airline,:filter_name WHERE NOT EXISTS (SELECT 1 FROM stats_registration WHERE registration = :registration AND stats_airline = :stats_airline AND filter_name = :filter_name);"; 
 			}
 		}
-                $query_values = array(':aircraft_icao' => $aircraft_icao,':registration' => $registration,':cnt' => $cnt,':stats_airline' => $airline_icao, ':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				$query_values = array(':aircraft_icao' => $aircraft_icao,':registration' => $registration,':cnt' => $cnt,':stats_airline' => $airline_icao, ':filter_name' => $filter_name);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 	public function addStatCallsign($callsign_icao,$cnt,$airline_icao = '', $filter_name = '', $reset = false) {
 		global $globalDBdriver;
 		if ($globalDBdriver == 'mysql') {
@@ -1102,14 +1102,14 @@ 
 				$query = "UPDATE stats_callsign SET cnt = cnt+:cnt WHERE callsign_icao = :callsign_icao AND filter_name = :filter_name; INSERT INTO stats_callsign (callsign_icao,airline_icao,cnt,filter_name) SELECT :callsign_icao,:airline_icao,:cnt,:filter_name WHERE NOT EXISTS (SELECT 1 FROM stats_callsign WHERE callsign_icao = :callsign_icao AND filter_name = :filter_name);"; 
 			}
 		}
-                $query_values = array(':callsign_icao' => $callsign_icao,':airline_icao' => $airline_icao,':cnt' => $cnt, ':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				$query_values = array(':callsign_icao' => $callsign_icao,':airline_icao' => $airline_icao,':cnt' => $cnt, ':filter_name' => $filter_name);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 	public function addStatCountry($iso2,$iso3,$name,$cnt,$filter_name = '',$reset = false) {
 		global $globalDBdriver;
 		if ($globalDBdriver == 'mysql') {
@@ -1125,14 +1125,14 @@ 
 				$query = "UPDATE stats_country SET cnt = cnt+:cnt WHERE iso2 = :iso2 AND filter_name = :filter_name; INSERT INTO stats_country (iso2,iso3,name,cnt,filter_name) SELECT :iso2,:iso3,:name,:cnt,:filter_name WHERE NOT EXISTS (SELECT 1 FROM stats_country WHERE iso2 = :iso2 AND filter_name = :filter_name);"; 
 			}
 		}
-                $query_values = array(':iso2' => $iso2,':iso3' => $iso3,':name' => $name,':cnt' => $cnt,':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				$query_values = array(':iso2' => $iso2,':iso3' => $iso3,':name' => $name,':cnt' => $cnt,':filter_name' => $filter_name);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 	public function addStatAircraft($aircraft_icao,$cnt,$aircraft_name = '',$aircraft_manufacturer = '', $airline_icao = '', $filter_name = '', $reset = false) {
 		global $globalDBdriver;
 		if ($globalDBdriver == 'mysql') {
@@ -1148,14 +1148,14 @@ 
 				$query = "UPDATE stats_aircraft SET cnt = cnt+:cnt, aircraft_name = :aircraft_name, aircraft_manufacturer = :aircraft_manufacturer, filter_name = :filter_name WHERE aircraft_icao = :aircraft_icao AND stats_airline = :stats_airline AND filter_name = :filter_name; INSERT INTO stats_aircraft (aircraft_icao,aircraft_name,aircraft_manufacturer,cnt,stats_airline,filter_name) SELECT :aircraft_icao,:aircraft_name,:aircraft_manufacturer,:cnt,:stats_airline,:filter_name WHERE NOT EXISTS (SELECT 1 FROM stats_aircraft WHERE aircraft_icao = :aircraft_icao AND stats_airline = :stats_airline AND filter_name = :filter_name);"; 
 			}
 		}
-                $query_values = array(':aircraft_icao' => $aircraft_icao,':aircraft_name' => $aircraft_name,':cnt' => $cnt, ':aircraft_manufacturer' => $aircraft_manufacturer,':stats_airline' => $airline_icao, ':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				$query_values = array(':aircraft_icao' => $aircraft_icao,':aircraft_name' => $aircraft_name,':cnt' => $cnt, ':aircraft_manufacturer' => $aircraft_manufacturer,':stats_airline' => $airline_icao, ':filter_name' => $filter_name);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 	public function addStatAirline($airline_icao,$cnt,$airline_name = '',$filter_name = '', $reset = false) {
 		global $globalDBdriver;
 		if ($globalDBdriver == 'mysql') {
@@ -1171,14 +1171,14 @@ 
 				$query = "UPDATE stats_airline SET cnt = cnt+:cnt WHERE airline_icao = :airline_icao AND filter_name = :filter_name; INSERT INTO stats_airline (airline_icao,airline_name,cnt,filter_name) SELECT :airline_icao,:airline_name,:cnt,:filter_name WHERE NOT EXISTS (SELECT 1 FROM stats_airline WHERE airline_icao = :airline_icao AND filter_name = :filter_name);"; 
 			}
 		}
-                $query_values = array(':airline_icao' => $airline_icao,':airline_name' => $airline_name,':cnt' => $cnt,':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				$query_values = array(':airline_icao' => $airline_icao,':airline_name' => $airline_name,':cnt' => $cnt,':filter_name' => $filter_name);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 	public function addStatOwner($owner_name,$cnt,$stats_airline = '', $filter_name = '', $reset = false) {
 		global $globalDBdriver;
 		if ($globalDBdriver == 'mysql') {
@@ -1194,14 +1194,14 @@ 
 				$query = "UPDATE stats_owner SET cnt = cnt+:cnt WHERE owner_name = :owner_name AND stats_airline = :stats_airline AND filter_name = :filter_name; INSERT INTO stats_owner (owner_name,cnt,stats_airline,filter_name) SELECT :owner_name,:cnt,:stats_airline,:filter_name WHERE NOT EXISTS (SELECT 1 FROM stats_owner WHERE owner_name = :owner_name AND stats_airline = :stats_airline AND filter_name = :filter_name);"; 
 			}
 		}
-                $query_values = array(':owner_name' => $owner_name,':cnt' => $cnt,':stats_airline' => $stats_airline,':filter_name' => $filter_name);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				$query_values = array(':owner_name' => $owner_name,':cnt' => $cnt,':stats_airline' => $stats_airline,':filter_name' => $filter_name);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 	public function addStatPilot($pilot_id,$cnt,$pilot_name,$stats_airline = '',$filter_name = '',$format_source = '',$reset = false) {
 		global $globalDBdriver;
 		if ($globalDBdriver == 'mysql') {
@@ -1217,14 +1217,14 @@ 
 				$query = "UPDATE stats_pilot SET cnt = cnt+:cnt, pilot_name = :pilot_name WHERE pilot_id = :pilot_id AND stats_airline = :stats_airline AND filter_name = :filter_name AND format_source = :format_source; INSERT INTO stats_pilot (pilot_id,cnt,pilot_name,stats_airline,filter_name,format_source) SELECT :pilot_id,:cnt,:pilot_name,:stats_airline,:filter_name,:format_source WHERE NOT EXISTS (SELECT 1 FROM stats_pilot WHERE pilot_id = :pilot_id AND stats_airline = :stats_airline AND filter_name = :filter_name AND format_source = :format_source);"; 
 			}
 		}
-                $query_values = array(':pilot_id' => $pilot_id,':cnt' => $cnt,':pilot_name' => $pilot_name,':stats_airline' => $stats_airline,':filter_name' => $filter_name,':format_source' => $format_source);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				$query_values = array(':pilot_id' => $pilot_id,':cnt' => $cnt,':pilot_name' => $pilot_name,':stats_airline' => $stats_airline,':filter_name' => $filter_name,':format_source' => $format_source);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 	public function addStatDepartureAirports($airport_icao,$airport_name,$airport_city,$airport_country,$departure,$airline_icao = '',$filter_name = '',$reset = false) {
 		global $globalDBdriver;
 		if ($airport_icao != '') {
@@ -1248,8 +1248,8 @@ 
 			} catch(PDOException $e) {
 				return "error : ".$e->getMessage();
 			}
-                }
-        }
+				}
+		}
 	public function addStatDepartureAirportsDaily($date,$airport_icao,$airport_name,$airport_city,$airport_country,$departure,$airline_icao = '',$filter_name = '') {
 		global $globalDBdriver;
 		if ($airport_icao != '') {
@@ -1265,8 +1265,8 @@ 
 			} catch(PDOException $e) {
 				return "error : ".$e->getMessage();
 			}
-                }
-        }
+				}
+		}
 	public function addStatArrivalAirports($airport_icao,$airport_name,$airport_city,$airport_country,$arrival,$airline_icao = '',$filter_name = '',$reset = false) {
 		global $globalDBdriver;
 		if ($airport_icao != '') {
@@ -1283,15 +1283,15 @@ 
 					$query = "UPDATE stats_airport SET arrival = arrival+:arrival WHERE airport_icao = :airport_icao AND stats_type = 'yearly' AND stats_airline = :stats_airline AND date = :date AND filter_name = :filter_name; INSERT INTO stats_airport (airport_icao,airport_name,airport_city,airport_country,arrival,stats_type,date,stats_airline,filter_name) SELECT :airport_icao,:airport_name,:airport_city,:airport_country,:arrival,'yearly',:date,:stats_airline,:filter_name WHERE NOT EXISTS (SELECT 1 FROM stats_airport WHERE airport_icao = :airport_icao AND stats_type = 'yearly' AND stats_airline = :stats_airline AND date = :date AND filter_name = :filter_name);"; 
 				}
 			}
-	                $query_values = array(':airport_icao' => $airport_icao,':airport_name' => $airport_name,':airport_city' => $airport_city,':airport_country' => $airport_country,':arrival' => $arrival,':date' => date('Y').'-01-01 00:00:00',':stats_airline' => $airline_icao,':filter_name' => $filter_name);
+					$query_values = array(':airport_icao' => $airport_icao,':airport_name' => $airport_name,':airport_city' => $airport_city,':airport_country' => $airport_country,':arrival' => $arrival,':date' => date('Y').'-01-01 00:00:00',':stats_airline' => $airline_icao,':filter_name' => $filter_name);
 			 try {
-                    		$sth = $this->db->prepare($query);
-	                        $sth->execute($query_values);
-    		        } catch(PDOException $e) {
-            		        return "error : ".$e->getMessage();
-	                }
-	        }
-        }
+							$sth = $this->db->prepare($query);
+							$sth->execute($query_values);
+					} catch(PDOException $e) {
+							return "error : ".$e->getMessage();
+					}
+			}
+		}
 	public function addStatArrivalAirportsDaily($date,$airport_icao,$airport_name,$airport_city,$airport_country,$arrival,$airline_icao = '',$filter_name = '') {
 		global $globalDBdriver;
 		if ($airport_icao != '') {
@@ -1307,46 +1307,46 @@ 
 			} catch(PDOException $e) {
 				return "error : ".$e->getMessage();
 			}
-                }
-        }
+				}
+		}
 
 	public function deleteStat($id) {
-                $query = "DELETE FROM stats WHERE stats_id = :id";
-                $query_values = array(':id' => $id);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				$query = "DELETE FROM stats WHERE stats_id = :id";
+				$query_values = array(':id' => $id);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 	public function deleteStatFlight($type) {
-                $query = "DELETE FROM stats_flight WHERE stats_type = :type";
-                $query_values = array(':type' => $type);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				$query = "DELETE FROM stats_flight WHERE stats_type = :type";
+				$query_values = array(':type' => $type);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
 	public function deleteStatAirport($type) {
-                $query = "DELETE FROM stats_airport WHERE stats_type = :type";
-                $query_values = array(':type' => $type);
-                 try {
-                        $sth = $this->db->prepare($query);
-                        $sth->execute($query_values);
-                } catch(PDOException $e) {
-                        return "error : ".$e->getMessage();
-                }
-        }
+				$query = "DELETE FROM stats_airport WHERE stats_type = :type";
+				$query_values = array(':type' => $type);
+				 try {
+						$sth = $this->db->prepare($query);
+						$sth->execute($query_values);
+				} catch(PDOException $e) {
+						return "error : ".$e->getMessage();
+				}
+		}
         
-        public function addOldStats() {
-    		global $globalDebug, $globalArchiveMonths, $globalArchive, $globalArchiveYear, $globalDBdriver, $globalStatsFilters,$globalDeleteLastYearStats,$globalStatsReset,$globalStatsResetYear;
-    		$Common = new Common();
-    		$Connection = new Connection();
-    		date_default_timezone_set('UTC');
-    		$last_update = $this->getLastStatsUpdate('last_update_stats');
+		public function addOldStats() {
+			global $globalDebug, $globalArchiveMonths, $globalArchive, $globalArchiveYear, $globalDBdriver, $globalStatsFilters,$globalDeleteLastYearStats,$globalStatsReset,$globalStatsResetYear;
+			$Common = new Common();
+			$Connection = new Connection();
+			date_default_timezone_set('UTC');
+			$last_update = $this->getLastStatsUpdate('last_update_stats');
 			if ($globalDebug) echo 'Update stats !'."\n";
 			if (isset($last_update[0]['value'])) {
 				$last_update_day = $last_update[0]['value'];
@@ -1392,24 +1392,24 @@ 
 			if ($globalDebug) echo 'Count all departure airports...'."\n";
 			$pall = $Spotter->countAllDepartureAirports(false,0,$last_update_day);
 			if ($globalDebug) echo 'Count all detected departure airports...'."\n";
-        		$dall = $Spotter->countAllDetectedDepartureAirports(false,0,$last_update_day);
+				$dall = $Spotter->countAllDetectedDepartureAirports(false,0,$last_update_day);
 			if ($globalDebug) echo 'Order departure airports...'."\n";
-	        	$alldata = array();
+				$alldata = array();
 	        	
-    			foreach ($pall as $value) {
-	        		$icao = $value['airport_departure_icao'];
-    				$alldata[$icao] = $value;
-	        	}
-	        	foreach ($dall as $value) {
-    				$icao = $value['airport_departure_icao'];
-        			if (isset($alldata[$icao])) {
-    					$alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
-        			} else $alldata[$icao] = $value;
-			}
-    			$count = array();
-    			foreach ($alldata as $key => $row) {
-    				$count[$key] = $row['airport_departure_icao_count'];
-        		}
+				foreach ($pall as $value) {
+					$icao = $value['airport_departure_icao'];
+					$alldata[$icao] = $value;
+				}
+				foreach ($dall as $value) {
+					$icao = $value['airport_departure_icao'];
+					if (isset($alldata[$icao])) {
+						$alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
+					} else $alldata[$icao] = $value;
+			}
+				$count = array();
+				foreach ($alldata as $key => $row) {
+					$count[$key] = $row['airport_departure_icao_count'];
+				}
 			array_multisort($count,SORT_DESC,$alldata);
 			foreach ($alldata as $number) {
 				echo $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count'],'','',$reset);
@@ -1417,25 +1417,25 @@ 
 			if ($globalDebug) echo 'Count all arrival airports...'."\n";
 			$pall = $Spotter->countAllArrivalAirports(false,0,$last_update_day);
 			if ($globalDebug) echo 'Count all detected arrival airports...'."\n";
-        		$dall = $Spotter->countAllDetectedArrivalAirports(false,0,$last_update_day);
+				$dall = $Spotter->countAllDetectedArrivalAirports(false,0,$last_update_day);
 			if ($globalDebug) echo 'Order arrival airports...'."\n";
-	        	$alldata = array();
-    			foreach ($pall as $value) {
-	        		$icao = $value['airport_arrival_icao'];
-    				$alldata[$icao] = $value;
-	        	}
-	        	foreach ($dall as $value) {
-    				$icao = $value['airport_arrival_icao'];
-        			if (isset($alldata[$icao])) {
-        				$alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
-	        		} else $alldata[$icao] = $value;
-    			}
-        		$count = array();
-        		foreach ($alldata as $key => $row) {
-        			$count[$key] = $row['airport_arrival_icao_count'];
-	        	}
-    			array_multisort($count,SORT_DESC,$alldata);
-                        foreach ($alldata as $number) {
+				$alldata = array();
+				foreach ($pall as $value) {
+					$icao = $value['airport_arrival_icao'];
+					$alldata[$icao] = $value;
+				}
+				foreach ($dall as $value) {
+					$icao = $value['airport_arrival_icao'];
+					if (isset($alldata[$icao])) {
+						$alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
+					} else $alldata[$icao] = $value;
+				}
+				$count = array();
+				foreach ($alldata as $key => $row) {
+					$count[$key] = $row['airport_arrival_icao_count'];
+				}
+				array_multisort($count,SORT_DESC,$alldata);
+						foreach ($alldata as $number) {
 				echo $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count'],'','',$reset);
 			}
 			if ($Connection->tableExists('countries')) {
@@ -1495,8 +1495,8 @@ 
 //			$pall = $Spotter->getLast7DaysAirportsDeparture();
   //      		$dall = $Spotter->getLast7DaysDetectedAirportsDeparture();
 			$pall = $Spotter->getLast7DaysAirportsDeparture();
-        		$dall = $Spotter->getLast7DaysDetectedAirportsDeparture();
-        		/*
+				$dall = $Spotter->getLast7DaysDetectedAirportsDeparture();
+				/*
 	        	$alldata = array();
     			foreach ($pall as $value) {
 	        		$icao = $value['departure_airport_icao'];
@@ -1515,29 +1515,29 @@ 
 	        	}
     			array_multisort($count,SORT_DESC,$alldata);
     			*/
-    			foreach ($dall as $value) {
-    				$icao = $value['departure_airport_icao'];
-    				$ddate = $value['date'];
-    				$find = false;
-    				foreach ($pall as $pvalue) {
-    					if ($pvalue['departure_airport_icao'] == $icao && $pvalue['date'] == $ddate) {
-    						$pvalue['departure_airport_count'] = $pvalue['departure_airport_count'] + $value['departure_airport_count'];
-    						$find = true;
-    						break;
-    					}
-    				}
-    				if ($find === false) {
-    					$pall[] = $value;
-    				}
-    			}
-    			$alldata = $pall;
+				foreach ($dall as $value) {
+					$icao = $value['departure_airport_icao'];
+					$ddate = $value['date'];
+					$find = false;
+					foreach ($pall as $pvalue) {
+						if ($pvalue['departure_airport_icao'] == $icao && $pvalue['date'] == $ddate) {
+							$pvalue['departure_airport_count'] = $pvalue['departure_airport_count'] + $value['departure_airport_count'];
+							$find = true;
+							break;
+						}
+					}
+					if ($find === false) {
+						$pall[] = $value;
+					}
+				}
+				$alldata = $pall;
 			foreach ($alldata as $number) {
 				$this->addStatDepartureAirportsDaily($number['date'],$number['departure_airport_icao'],$number['departure_airport_name'],$number['departure_airport_city'],$number['departure_airport_country'],$number['departure_airport_count']);
 			}
 			echo '...Arrival'."\n";
 			$pall = $Spotter->getLast7DaysAirportsArrival();
-        		$dall = $Spotter->getLast7DaysDetectedAirportsArrival();
-        		/*
+				$dall = $Spotter->getLast7DaysDetectedAirportsArrival();
+				/*
 	        	$alldata = array();
     			foreach ($pall as $value) {
 	        		$icao = $value['arrival_airport_icao'];
@@ -1557,22 +1557,22 @@ 
     			*/
 
 
-    			foreach ($dall as $value) {
-    				$icao = $value['arrival_airport_icao'];
-    				$ddate = $value['date'];
-    				$find = false;
-    				foreach ($pall as $pvalue) {
-    					if ($pvalue['arrival_airport_icao'] == $icao && $pvalue['date'] == $ddate) {
-    						$pvalue['arrival_airport_count'] = $pvalue['arrival_airport_count'] + $value['arrival_airport_count'];
-    						$find = true;
-    						break;
-    					}
-    				}
-    				if ($find === false) {
-    					$pall[] = $value;
-    				}
-    			}
-    			$alldata = $pall;
+				foreach ($dall as $value) {
+					$icao = $value['arrival_airport_icao'];
+					$ddate = $value['date'];
+					$find = false;
+					foreach ($pall as $pvalue) {
+						if ($pvalue['arrival_airport_icao'] == $icao && $pvalue['date'] == $ddate) {
+							$pvalue['arrival_airport_count'] = $pvalue['arrival_airport_count'] + $value['arrival_airport_count'];
+							$find = true;
+							break;
+						}
+					}
+					if ($find === false) {
+						$pall[] = $value;
+					}
+				}
+				$alldata = $pall;
 			foreach ($alldata as $number) {
 				$this->addStatArrivalAirportsDaily($number['date'],$number['arrival_airport_icao'],$number['arrival_airport_name'],$number['arrival_airport_city'],$number['arrival_airport_country'],$number['arrival_airport_count']);
 			}
@@ -1639,51 +1639,51 @@ 
 			if ($globalDebug) echo 'Count all departure airports by airlines...'."\n";
 			$pall = $Spotter->countAllDepartureAirportsByAirlines(false,0,$last_update_day);
 			if ($globalDebug) echo 'Count all detected departure airports by airlines...'."\n";
-       			$dall = $Spotter->countAllDetectedDepartureAirportsByAirlines(false,0,$last_update_day);
+	   			$dall = $Spotter->countAllDetectedDepartureAirportsByAirlines(false,0,$last_update_day);
 			if ($globalDebug) echo 'Order detected departure airports by airlines...'."\n";
-	        	//$alldata = array();
-    			foreach ($dall as $value) {
-    				$icao = $value['airport_departure_icao'];
-    				$dicao = $value['airline_icao'];
-    				$find = false;
-    				foreach ($pall as $pvalue) {
-    					if ($pvalue['airport_departure_icao'] == $icao && $pvalue['airline_icao'] = $dicao) {
-    						$pvalue['airport_departure_icao_count'] = $pvalue['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
-    						$find = true;
-    						break;
-    					}
-    				}
-    				if ($find === false) {
-    					$pall[] = $value;
-    				}
-    			}
-    			$alldata = $pall;
+				//$alldata = array();
+				foreach ($dall as $value) {
+					$icao = $value['airport_departure_icao'];
+					$dicao = $value['airline_icao'];
+					$find = false;
+					foreach ($pall as $pvalue) {
+						if ($pvalue['airport_departure_icao'] == $icao && $pvalue['airline_icao'] = $dicao) {
+							$pvalue['airport_departure_icao_count'] = $pvalue['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
+							$find = true;
+							break;
+						}
+					}
+					if ($find === false) {
+						$pall[] = $value;
+					}
+				}
+				$alldata = $pall;
 			foreach ($alldata as $number) {
 				echo $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count'],$number['airline_icao'],'',$reset);
 			}
 			if ($globalDebug) echo 'Count all arrival airports by airlines...'."\n";
 			$pall = $Spotter->countAllArrivalAirportsByAirlines(false,0,$last_update_day);
 			if ($globalDebug) echo 'Count all detected arrival airports by airlines...'."\n";
-        		$dall = $Spotter->countAllDetectedArrivalAirportsByAirlines(false,0,$last_update_day);
+				$dall = $Spotter->countAllDetectedArrivalAirportsByAirlines(false,0,$last_update_day);
 			if ($globalDebug) echo 'Order arrival airports by airlines...'."\n";
-	        	//$alldata = array();
-    			foreach ($dall as $value) {
-    				$icao = $value['airport_arrival_icao'];
-    				$dicao = $value['airline_icao'];
-    				$find = false;
-    				foreach ($pall as $pvalue) {
-    					if ($pvalue['airport_arrival_icao'] == $icao && $pvalue['airline_icao'] = $dicao) {
-    						$pvalue['airport_arrival_icao_count'] = $pvalue['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
-    						$find = true;
-    						break;
-    					}
-    				}
-    				if ($find === false) {
-    					$pall[] = $value;
-    				}
-    			}
-    			$alldata = $pall;
-                        foreach ($alldata as $number) {
+				//$alldata = array();
+				foreach ($dall as $value) {
+					$icao = $value['airport_arrival_icao'];
+					$dicao = $value['airline_icao'];
+					$find = false;
+					foreach ($pall as $pvalue) {
+						if ($pvalue['airport_arrival_icao'] == $icao && $pvalue['airline_icao'] = $dicao) {
+							$pvalue['airport_arrival_icao_count'] = $pvalue['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
+							$find = true;
+							break;
+						}
+					}
+					if ($find === false) {
+						$pall[] = $value;
+					}
+				}
+				$alldata = $pall;
+						foreach ($alldata as $number) {
 				if ($number['airline_icao'] != '') echo $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count'],$number['airline_icao'],'',$reset);
 			}
 			if ($globalDebug) echo 'Count all flights by months by airlines...'."\n";
@@ -1716,47 +1716,47 @@ 
 			}
 			if ($globalDebug) echo '...Departure'."\n";
 			$pall = $Spotter->getLast7DaysAirportsDepartureByAirlines();
-        		$dall = $Spotter->getLast7DaysDetectedAirportsDepartureByAirlines();
-    			foreach ($dall as $value) {
-    				$icao = $value['departure_airport_icao'];
-    				$airline = $value['airline_icao'];
-    				$ddate = $value['date'];
-    				$find = false;
-    				foreach ($pall as $pvalue) {
-    					if ($pvalue['departure_airport_icao'] == $icao && $pvalue['date'] == $ddate && $pvalue['airline_icao'] = $airline) {
-    						$pvalue['departure_airport_count'] = $pvalue['departure_airport_count'] + $value['departure_airport_count'];
-    						$find = true;
-    						break;
-    					}
-    				}
-    				if ($find === false) {
-    					$pall[] = $value;
-    				}
-    			}
-    			$alldata = $pall;
+				$dall = $Spotter->getLast7DaysDetectedAirportsDepartureByAirlines();
+				foreach ($dall as $value) {
+					$icao = $value['departure_airport_icao'];
+					$airline = $value['airline_icao'];
+					$ddate = $value['date'];
+					$find = false;
+					foreach ($pall as $pvalue) {
+						if ($pvalue['departure_airport_icao'] == $icao && $pvalue['date'] == $ddate && $pvalue['airline_icao'] = $airline) {
+							$pvalue['departure_airport_count'] = $pvalue['departure_airport_count'] + $value['departure_airport_count'];
+							$find = true;
+							break;
+						}
+					}
+					if ($find === false) {
+						$pall[] = $value;
+					}
+				}
+				$alldata = $pall;
 			foreach ($alldata as $number) {
 				$this->addStatDepartureAirportsDaily($number['date'],$number['departure_airport_icao'],$number['departure_airport_name'],$number['departure_airport_city'],$number['departure_airport_country'],$number['departure_airport_count'],$number['airline_icao']);
 			}
 			if ($globalDebug) echo '...Arrival'."\n";
 			$pall = $Spotter->getLast7DaysAirportsArrivalByAirlines();
-        		$dall = $Spotter->getLast7DaysDetectedAirportsArrivalByAirlines();
-    			foreach ($dall as $value) {
-    				$icao = $value['arrival_airport_icao'];
-    				$airline = $value['airline_icao'];
-    				$ddate = $value['date'];
-    				$find = false;
-    				foreach ($pall as $pvalue) {
-    					if ($pvalue['arrival_airport_icao'] == $icao && $pvalue['date'] == $ddate && $pvalue['airline_icao'] == $airline) {
-    						$pvalue['arrival_airport_count'] = $pvalue['arrival_airport_count'] + $value['arrival_airport_count'];
-    						$find = true;
-    						break;
-    					}
-    				}
-    				if ($find === false) {
-    					$pall[] = $value;
-    				}
-    			}
-    			$alldata = $pall;
+				$dall = $Spotter->getLast7DaysDetectedAirportsArrivalByAirlines();
+				foreach ($dall as $value) {
+					$icao = $value['arrival_airport_icao'];
+					$airline = $value['airline_icao'];
+					$ddate = $value['date'];
+					$find = false;
+					foreach ($pall as $pvalue) {
+						if ($pvalue['arrival_airport_icao'] == $icao && $pvalue['date'] == $ddate && $pvalue['airline_icao'] == $airline) {
+							$pvalue['arrival_airport_count'] = $pvalue['arrival_airport_count'] + $value['arrival_airport_count'];
+							$find = true;
+							break;
+						}
+					}
+					if ($find === false) {
+						$pall[] = $value;
+					}
+				}
+				$alldata = $pall;
 			foreach ($alldata as $number) {
 				$this->addStatArrivalAirportsDaily($number['date'],$number['arrival_airport_icao'],$number['arrival_airport_name'],$number['arrival_airport_city'],$number['arrival_airport_country'],$number['arrival_airport_count'],$number['airline_icao']);
 			}
@@ -1827,44 +1827,44 @@ 
 					$this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name'],'',$filter_name,$number['format_source'],$reset);
 				}
 				$pall = $Spotter->countAllDepartureAirports(false,0,$last_update_day,$filter);
-	       			$dall = $Spotter->countAllDetectedDepartureAirports(false,0,$last_update_day,$filter);
-		        	$alldata = array();
-	    			foreach ($pall as $value) {
-		        		$icao = $value['airport_departure_icao'];
-    					$alldata[$icao] = $value;
-	    			}
-		        	foreach ($dall as $value) {
-	    				$icao = $value['airport_departure_icao'];
-        				if (isset($alldata[$icao])) {
-    						$alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
-        				} else $alldata[$icao] = $value;
-				}
-	    			$count = array();
-    				foreach ($alldata as $key => $row) {
-    					$count[$key] = $row['airport_departure_icao_count'];
-    				}
+		   			$dall = $Spotter->countAllDetectedDepartureAirports(false,0,$last_update_day,$filter);
+					$alldata = array();
+					foreach ($pall as $value) {
+						$icao = $value['airport_departure_icao'];
+						$alldata[$icao] = $value;
+					}
+					foreach ($dall as $value) {
+						$icao = $value['airport_departure_icao'];
+						if (isset($alldata[$icao])) {
+							$alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
+						} else $alldata[$icao] = $value;
+				}
+					$count = array();
+					foreach ($alldata as $key => $row) {
+						$count[$key] = $row['airport_departure_icao_count'];
+					}
 				array_multisort($count,SORT_DESC,$alldata);
 				foreach ($alldata as $number) {
-    					echo $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count'],'',$filter_name,$reset);
+						echo $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count'],'',$filter_name,$reset);
 				}
 				$pall = $Spotter->countAllArrivalAirports(false,0,$last_update_day,false,$filter);
-    				$dall = $Spotter->countAllDetectedArrivalAirports(false,0,$last_update_day,false,$filter);
+					$dall = $Spotter->countAllDetectedArrivalAirports(false,0,$last_update_day,false,$filter);
 				$alldata = array();
-    				foreach ($pall as $value) {
-		        		$icao = $value['airport_arrival_icao'];
-    					$alldata[$icao] = $value;
-	    			}
-		        	foreach ($dall as $value) {
-	    				$icao = $value['airport_arrival_icao'];
-        				if (isset($alldata[$icao])) {
-        					$alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
-		        		} else $alldata[$icao] = $value;
-	    			}
-        			$count = array();
-        			foreach ($alldata as $key => $row) {
-    					$count[$key] = $row['airport_arrival_icao_count'];
-		        	}
-        			array_multisort($count,SORT_DESC,$alldata);
+					foreach ($pall as $value) {
+						$icao = $value['airport_arrival_icao'];
+						$alldata[$icao] = $value;
+					}
+					foreach ($dall as $value) {
+						$icao = $value['airport_arrival_icao'];
+						if (isset($alldata[$icao])) {
+							$alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
+						} else $alldata[$icao] = $value;
+					}
+					$count = array();
+					foreach ($alldata as $key => $row) {
+						$count[$key] = $row['airport_arrival_icao_count'];
+					}
+					array_multisort($count,SORT_DESC,$alldata);
 				foreach ($alldata as $number) {
 					echo $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count'],'',$filter_name,$reset);
 				}
@@ -1897,45 +1897,45 @@ 
 				}
 				echo '...Departure'."\n";
 				$pall = $Spotter->getLast7DaysAirportsDeparture('',$filter);
-        			$dall = $Spotter->getLast7DaysDetectedAirportsDeparture('',$filter);
+					$dall = $Spotter->getLast7DaysDetectedAirportsDeparture('',$filter);
 				foreach ($dall as $value) {
-    					$icao = $value['departure_airport_icao'];
-    					$ddate = $value['date'];
-    					$find = false;
-    					foreach ($pall as $pvalue) {
-    						if ($pvalue['departure_airport_icao'] == $icao && $pvalue['date'] == $ddate) {
-    							$pvalue['departure_airport_count'] = $pvalue['departure_airport_count'] + $value['departure_airport_count'];
-	    						$find = true;
-    							break;
-    						}
-    					}
-    					if ($find === false) {
-    						$pall[] = $value;
-	    				}
-    				}
-	    			$alldata = $pall;
+						$icao = $value['departure_airport_icao'];
+						$ddate = $value['date'];
+						$find = false;
+						foreach ($pall as $pvalue) {
+							if ($pvalue['departure_airport_icao'] == $icao && $pvalue['date'] == $ddate) {
+								$pvalue['departure_airport_count'] = $pvalue['departure_airport_count'] + $value['departure_airport_count'];
+								$find = true;
+								break;
+							}
+						}
+						if ($find === false) {
+							$pall[] = $value;
+						}
+					}
+					$alldata = $pall;
 				foreach ($alldata as $number) {
 					$this->addStatDepartureAirportsDaily($number['date'],$number['departure_airport_icao'],$number['departure_airport_name'],$number['departure_airport_city'],$number['departure_airport_country'],$number['departure_airport_count'],'',$filter_name);
 				}
 				echo '...Arrival'."\n";
 				$pall = $Spotter->getLast7DaysAirportsArrival('',$filter);
-    				$dall = $Spotter->getLast7DaysDetectedAirportsArrival('',$filter);
+					$dall = $Spotter->getLast7DaysDetectedAirportsArrival('',$filter);
 				foreach ($dall as $value) {
 					$icao = $value['arrival_airport_icao'];
 					$ddate = $value['date'];
-    					$find = false;
+						$find = false;
 					foreach ($pall as $pvalue) {
-    						if ($pvalue['arrival_airport_icao'] == $icao && $pvalue['date'] == $ddate) {
-    							$pvalue['arrival_airport_count'] = $pvalue['arrival_airport_count'] + $value['arrival_airport_count'];
-    							$find = true;
-    							break;
-	    					}
-    					}
-    					if ($find === false) {
-    						$pall[] = $value;
-	    				}
-    				}
-    				$alldata = $pall;
+							if ($pvalue['arrival_airport_icao'] == $icao && $pvalue['date'] == $ddate) {
+								$pvalue['arrival_airport_count'] = $pvalue['arrival_airport_count'] + $value['arrival_airport_count'];
+								$find = true;
+								break;
+							}
+						}
+						if ($find === false) {
+							$pall[] = $value;
+						}
+					}
+					$alldata = $pall;
 				foreach ($alldata as $number) {
 					$this->addStatArrivalAirportsDaily($number['date'],$number['arrival_airport_icao'],$number['arrival_airport_name'],$number['arrival_airport_city'],$number['arrival_airport_country'],$number['arrival_airport_count'],'',$filter_name);
 				}

statistics-airport-departure-country.php

Indentation +5 added lines, -5 removed lines

@@ -8,13 +8,13 @@
 if (!isset($filter_name)) $filter_name = '';
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
 if ($airline_icao == 'all') {
-    unset($_COOKIE['stats_airline_icao']);
-    setcookie('stats_airline_icao', '', time()-3600);
-    $airline_icao = '';
+	unset($_COOKIE['stats_airline_icao']);
+	setcookie('stats_airline_icao', '', time()-3600);
+	$airline_icao = '';
 } elseif ($airline_icao == '' && isset($_COOKIE['stats_airline_icao'])) {
-    $airline_icao = $_COOKIE['stats_airline_icao'];
+	$airline_icao = $_COOKIE['stats_airline_icao'];
 } elseif ($airline_icao == '' && isset($globalFilter)) {
-    if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
+	if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
 }
 setcookie('stats_airline_icao',$airline_icao);
 $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT);

statistics-sub-menu.php

Indentation +7 added lines, -7 removed lines

@@ -31,7 +31,7 @@ 
 		</form>
 	</div>
 <?php 
-    if (isset($year) && $year == '' && isset($month) && $month == '') {
+	if (isset($year) && $year == '' && isset($month) && $month == '') {
 ?>
 <div class="sub-menu sub-menu-container">
 	<ul class="nav">
@@ -86,7 +86,7 @@ 
 		    </ul>
 		</li>
 		<?php
-		    if (isset($globalAccidents) && $globalAccidents) {
+			if (isset($globalAccidents) && $globalAccidents) {
 		?>
 		<li class="dropdown">
 		    <a class="dropdown-toggle <?php if(strtolower($current_page) == "statistics-fatalities-year" || strtolower($current_page) == "statistics-fatalities-month"){ print 'active'; } ?>" data-toggle="dropdown" href="#">
@@ -98,12 +98,12 @@ 
 		    </ul>
 		</li>
 		<?php
-		    }
+			}
 		?>
 	</ul>
 </div>
 <?php
-    } else {
+	} else {
 ?>
 <div class="sub-menu sub-menu-container">
 	<ul class="nav">
@@ -162,7 +162,7 @@ 
 		</li>
 		-->
 		<?php
-		    if (isset($globalAccidents) && $globalAccidents) {
+			if (isset($globalAccidents) && $globalAccidents) {
 		?>
 		<!--
 		<li class="dropdown">
@@ -176,10 +176,10 @@ 
 		</li>
 		-->
 		<?php
-		    }
+			}
 		?>
 	</ul>
 </div>
 <?php
-    }
+	}
 ?>
\ No newline at end of file

statistics.php

Indentation +233 added lines, -233 removed lines

@@ -43,7 +43,7 @@ 
 		if (isset($globalTimezone) && $globalTimezone != '') date_default_timezone_set($globalTimezone);
 		print '<i>Last update: '.date('Y-m-d G:i:s',$lastupdate).'</i>';
 	}
-    ?>
+	?>
     </div>
     <?php include('statistics-sub-menu.php'); ?>
     <p class="global-stats">
@@ -52,23 +52,23 @@ 
         <span><span class="badge"><?php print number_format($Stats->countOverallArrival($airline_icao,$filter_name,$year,$month)); ?></span> <?php echo _("Arrivals seen"); ?></span>
         <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
 	<?php
-	    if ((isset($globalIVAO) && $globalIVAO) || (isset($globalVATSIM) && $globalVATSIM) || (isset($globalphpVMS) && $globalphpVMS)) {
+		if ((isset($globalIVAO) && $globalIVAO) || (isset($globalVATSIM) && $globalVATSIM) || (isset($globalphpVMS) && $globalphpVMS)) {
 	?>
     	    <span><span class="badge"><?php print number_format($Stats->countOverallPilots($airline_icao,$filter_name,$year,$month)); ?></span> <?php echo _("Pilots"); ?></span>
 	    <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
         <?php
-    	    } else {
-    	?>
+			} else {
+		?>
     	    <span><span class="badge"><?php print number_format($Stats->countOverallOwners($airline_icao,$filter_name,$year,$month)); ?></span> <?php echo _("Owners"); ?></span>
 	    <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
     	<?php
-    	    }
-    	?>
+			}
+		?>
         <span><span class="badge"><?php print number_format($Stats->countOverallAircrafts($airline_icao,$filter_name,$year,$month)); ?></span> <?php echo _("Aircrafts types"); ?></span>
         <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
         <?php
-    		if ($airline_icao == '') {
-    	?>
+			if ($airline_icao == '') {
+		?>
         <span><span class="badge"><?php print number_format($Stats->countOverallAirlines($filter_name,$year,$month)); ?></span> <?php echo _("Airlines"); ?></span>
 	<!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
 	<?php
@@ -89,25 +89,25 @@ 
             <div class="col-md-6">
                 <h2><?php echo _("Top 10 Most Common Aircraft Type"); ?></h2>
                  <?php
-                  $aircraft_array = $Stats->countAllAircraftTypes(true,$airline_icao,$filter_name,$year,$month);
-		    if (count($aircraft_array) == 0) print _("No data available");
-		    else {
+				  $aircraft_array = $Stats->countAllAircraftTypes(true,$airline_icao,$filter_name,$year,$month);
+			if (count($aircraft_array) == 0) print _("No data available");
+			else {
 
-                    print '<div id="chart1" class="chart" width="100%"></div>
+					print '<div id="chart1" class="chart" width="100%"></div>
                     <script> 
                         google.load("visualization", "1", {packages:["corechart"]});
                       google.setOnLoadCallback(drawChart1);
                       function drawChart1() {
                         var data = google.visualization.arrayToDataTable([
                             ["'._("Aircraft").'", "'._("# of times").'"], ';
-                            $aircraft_data = '';
-                          foreach($aircraft_array as $aircraft_item)
-                                    {
-                                            $aircraft_data .= '[ "'.$aircraft_item['aircraft_manufacturer'].' '.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')",'.$aircraft_item['aircraft_icao_count'].'],';
-                                    }
-                                    $aircraft_data = substr($aircraft_data, 0, -1);
-                                    print $aircraft_data;
-                        print ']);
+							$aircraft_data = '';
+						  foreach($aircraft_array as $aircraft_item)
+									{
+											$aircraft_data .= '[ "'.$aircraft_item['aircraft_manufacturer'].' '.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')",'.$aircraft_item['aircraft_icao_count'].'],';
+									}
+									$aircraft_data = substr($aircraft_data, 0, -1);
+									print $aircraft_data;
+						print ']);
 
                         var options = {
                             chartArea: {"width": "80%", "height": "60%"},
@@ -122,45 +122,45 @@ 
                               drawChart1();
                             });
                   </script>';
-                  }
-                  ?>
+				  }
+				  ?>
                 <div class="more">
             	    <?php
-            		if ($year != '' && $month != '') {
-            	    ?>
+					if ($year != '' && $month != '') {
+					?>
             	    <a href="<?php print $globalURL; ?>/statistics/aircraft/<?php echo $year; ?>/<?php echo $month ?>/" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
             	    <?php
-            		} else {
-            	    ?>
+					} else {
+					?>
             	    <a href="<?php print $globalURL; ?>/statistics/aircraft" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
             	    <?php
-            		}
-            	    ?>
+					}
+					?>
                 </div>
             </div>
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
 <?php
 //    echo $airline_icao;
-    if ($airline_icao == '' || $airline_icao == 'all') {
+	if ($airline_icao == '' || $airline_icao == 'all') {
 	$airline_array = $Stats->countAllAirlines(true,$filter_name,$year,$month);
 	if (count($airline_array) > 0) {
-            print '<div class="col-md-6">';
-	    print '<h2>'._("Top 10 Most Common Airline").'</h2>';
-	    print '<div id="chart2" class="chart" width="100%"></div>
+			print '<div class="col-md-6">';
+		print '<h2>'._("Top 10 Most Common Airline").'</h2>';
+		print '<div id="chart2" class="chart" width="100%"></div>
                     <script> 
                         google.load("visualization", "1", {packages:["corechart"]});
                       google.setOnLoadCallback(drawChart2);
                       function drawChart2() {
                         var data = google.visualization.arrayToDataTable([
                             ["'._("Airline").'", "'._("# of times").'"], ';
-	    $airline_data = '';
-	    foreach($airline_array as $airline_item)
-	    {
+		$airline_data = '';
+		foreach($airline_array as $airline_item)
+		{
 		$airline_data .= '[ "'.$airline_item['airline_name'].' ('.$airline_item['airline_icao'].')",'.$airline_item['airline_count'].'],';
-	    }
-	    $airline_data = substr($airline_data, 0, -1);
-	    print $airline_data;
-	    print ']);
+		}
+		$airline_data = substr($airline_data, 0, -1);
+		print $airline_data;
+		print ']);
 
                         var options = {
                             chartArea: {"width": "80%", "height": "60%"},
@@ -175,27 +175,27 @@ 
                               drawChart2();
                             });
                   </script>';
-	    if ($year != '' && $month != '') {
+		if ($year != '' && $month != '') {
 		print '<div class="more"><a href="'.$globalURL.'/statistics/airline/'.$year.'/'.$month.'/" class="btn btn-default btn" role="button">'._("See full statistic").'&raquo;</a></div>';
-	    } else {
+		} else {
 		print '<div class="more"><a href="'.$globalURL.'/statistics/airline" class="btn btn-default btn" role="button">'._("See full statistic").'&raquo;</a></div>';
-	    }
-    	    print '</div>';
+		}
+			print '</div>';
 	}
 ?>
         </div>
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
 <?php
-    }
+	}
 ?>
         <div class="row column">
 <?php
-    $flightover_array = $Stats->countAllFlightOverCountries($airline_icao,$filter_name,$year,$month);
-    if ((isset($globalIVAO) && $globalIVAO) || (isset($globalVATSIM) && $globalVATSIM) || (isset($globalphpVMS) && $globalphpVMS)) {
+	$flightover_array = $Stats->countAllFlightOverCountries($airline_icao,$filter_name,$year,$month);
+	if ((isset($globalIVAO) && $globalIVAO) || (isset($globalVATSIM) && $globalVATSIM) || (isset($globalphpVMS) && $globalphpVMS)) {
 	if (empty($flightover_array)) {
-	    print '<div class="col-md-12">';
+		print '<div class="col-md-12">';
 	} else {
-            print '<div class="col-md-6">';
+			print '<div class="col-md-6">';
 	}
 ?>
                 <h2><?php echo _("Top 10 Most Common Pilots"); ?></h2>
@@ -203,21 +203,21 @@ 
 	$pilot_array = $Stats->countAllPilots(true,$airline_icao,$filter_name,$year,$month);
 	if (count($pilot_array) == 0) print _("No data available");
 	else {
-	    print '<div id="chart7" class="chart" width="100%"></div>
+		print '<div id="chart7" class="chart" width="100%"></div>
                     <script> 
                         google.load("visualization", "1", {packages:["corechart"]});
                       google.setOnLoadCallback(drawChart7);
                       function drawChart7() {
                         var data = google.visualization.arrayToDataTable([
                             ["'._("Pilots").'", "'._("# of times").'"], ';
-	    $pilot_data = '';
-	    foreach($pilot_array as $pilot_item)
-	    {
+		$pilot_data = '';
+		foreach($pilot_array as $pilot_item)
+		{
 		$pilot_data .= '[ "'.$pilot_item['pilot_name'].' ('.$pilot_item['pilot_id'].')",'.$pilot_item['pilot_count'].'],';
-	    }
-	    $pilot_data = substr($pilot_data, 0, -1);
-	    print $pilot_data;
-	    print ']);
+		}
+		$pilot_data = substr($pilot_data, 0, -1);
+		print $pilot_data;
+		print ']);
 
                         var options = {
                             chartArea: {"width": "80%", "height": "60%"},
@@ -232,8 +232,8 @@ 
                               drawChart7();
                             });
                   </script>';
-        }
-        print '<div class="more">';
+		}
+		print '<div class="more">';
 	print '<a href="'.$globalURL.'/statistics/pilot" class="btn btn-default btn" role="button">'._("See full statistic").'&raquo;</a>';
 	print '</div>';
 ?>
@@ -241,7 +241,7 @@ 
         
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
 <?php
-    } else {
+	} else {
 ?>
             <div class="col-md-6">
                 <h2><?php echo _("Top 10 Most Common Owners"); ?></h2>
@@ -249,21 +249,21 @@ 
 	$owner_array = $Stats->countAllOwners(true,$airline_icao,$filter_name,$year,$month);
 	if (count($owner_array) == 0) print _("No data available");
 	else {
-	    print '<div id="chart7" class="chart" width="100%"></div>
+		print '<div id="chart7" class="chart" width="100%"></div>
                     <script> 
                         google.load("visualization", "1", {packages:["corechart"]});
                       google.setOnLoadCallback(drawChart7);
                       function drawChart7() {
                         var data = google.visualization.arrayToDataTable([
                             ["'._("Owner").'", "'._("# of times").'"], ';
-                            $owner_data = '';
-	    foreach($owner_array as $owner_item)
-	    {
+							$owner_data = '';
+		foreach($owner_array as $owner_item)
+		{
 		$owner_data .= '[ "'.$owner_item['owner_name'].'",'.$owner_item['owner_count'].'],';
-	    }
-	    $owner_data = substr($owner_data, 0, -1);
-	    print $owner_data;
-	    print ']);
+		}
+		$owner_data = substr($owner_data, 0, -1);
+		print $owner_data;
+		print ']);
 
                         var options = {
                             chartArea: {"width": "80%", "height": "60%"},
@@ -287,8 +287,8 @@ 
         
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
 <?php
-    }
-    if (!empty($flightover_array)) {
+	}
+	if (!empty($flightover_array)) {
 ?>
             <div class="col-md-6">
                 <h2><?php echo _("Top 20 Most Common Country a Flight was Over"); ?></h2>
@@ -296,21 +296,21 @@ 
 	 //$flightover_array = $Stats->countAllFlightOverCountries();
 	if (count($flightover_array) == 0) print _("No data available");
 	else {
-	    print '<div id="chart10" class="chart" width="100%"></div>
+		print '<div id="chart10" class="chart" width="100%"></div>
                     <script> 
                         google.load("visualization", "1", {packages:["corechart"]});
                       google.setOnLoadCallback(drawChart10);
                       function drawChart10() {
                         var data = google.visualization.arrayToDataTable([
                             ["'._("Country").'", "'._("# of times").'"], ';
-                            $flightover_data = '';
-	    foreach($flightover_array as $flightover_item)
-	    {
+							$flightover_data = '';
+		foreach($flightover_array as $flightover_item)
+		{
 		$flightover_data .= '[ "'.$flightover_item['flight_country'].' ('.$flightover_item['flight_country_iso2'].')",'.$flightover_item['flight_count'].'],';
-	    }
-	    $flightover_data = substr($flightover_data, 0, -1);
-	    print $flightover_data;
-	    print ']);
+		}
+		$flightover_data = substr($flightover_data, 0, -1);
+		print $flightover_data;
+		print ']);
 
                         var options = {
                             chartArea: {"width": "80%", "height": "60%"},
@@ -334,7 +334,7 @@ 
                 </div>
             </div>
 <?php
-    }
+	}
 ?>
         </div>
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
@@ -344,8 +344,8 @@ 
         <div class="row column">
             <div class="col-md-6">
 <?php
-    $airport_airport_array = $Stats->countAllDepartureAirports(true,$airline_icao,$filter_name,$year,$month);
-    if (count($airport_airport_array) > 0) {
+	$airport_airport_array = $Stats->countAllDepartureAirports(true,$airline_icao,$filter_name,$year,$month);
+	if (count($airport_airport_array) > 0) {
 	print '<h2>'._("Top 10 Most Common Departure Airports").'</h2>';
 	print '<div id="chart3" class="chart" width="100%"></div>
                 <script>
@@ -358,13 +358,13 @@ 
 
                 var data = google.visualization.arrayToDataTable([ 
                     ["'._("Airport").'", "'._("# of times").'"],';
-                    $airport_data = '';
+					$airport_data = '';
 	foreach($airport_airport_array as $airport_item)
 	{
-	    $name = $airport_item['airport_departure_city'].', '.$airport_item['airport_departure_country'].' ('.$airport_item['airport_departure_icao'].')';
-	    $name = str_replace("'", "", $name);
-	    $name = str_replace('"', "", $name);
-	    $airport_data .= '[ "'.$name.'",'.$airport_item['airport_departure_icao_count'].'],';
+		$name = $airport_item['airport_departure_city'].', '.$airport_item['airport_departure_country'].' ('.$airport_item['airport_departure_icao'].')';
+		$name = str_replace("'", "", $name);
+		$name = str_replace('"', "", $name);
+		$airport_data .= '[ "'.$name.'",'.$airport_item['airport_departure_icao_count'].'],';
 	}
 	$airport_data = substr($airport_data, 0, -1);
 	print $airport_data;
@@ -383,15 +383,15 @@ 
               }
                 </script>';
 	print '<div class="more"><a href="'.$globalURL.'/statistics/airport-departure" class="btn btn-default btn" role="button">'._("See full statistic").'&raquo;</a></div>';
-    }
+	}
 ?>
             </div>
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
 
             <div class="col-md-6">
 <?php
-    $airport_airport_array2 = $Stats->countAllArrivalAirports(true,$airline_icao,$filter_name,$year,$month);
-    if (count($airport_airport_array2) > 0) {
+	$airport_airport_array2 = $Stats->countAllArrivalAirports(true,$airline_icao,$filter_name,$year,$month);
+	if (count($airport_airport_array2) > 0) {
 	print '<h2>'._("Top 10 Most Common Arrival Airports").'</h2>';
 	print '<div id="chart4" class="chart" width="100%"></div>
                 <script>
@@ -407,9 +407,9 @@ 
 	$airport_data2 = '';
 	foreach($airport_airport_array2 as $airport_item2)
 	{
-	    $name2 = $airport_item2['airport_arrival_city'].', '.$airport_item2['airport_arrival_country'].' ('.$airport_item2['airport_arrival_icao'].')';
-	    $name2 = str_replace(array("'",'"'), '', $name2);
-	    $airport_data2 .= '[ "'.$name2.'",'.$airport_item2['airport_arrival_icao_count'].'],';
+		$name2 = $airport_item2['airport_arrival_city'].', '.$airport_item2['airport_arrival_country'].' ('.$airport_item2['airport_arrival_icao'].')';
+		$name2 = str_replace(array("'",'"'), '', $name2);
+		$airport_data2 .= '[ "'.$name2.'",'.$airport_item2['airport_arrival_icao_count'].'],';
 	}
 	$airport_data2 = substr($airport_data2, 0, -1);
 	print $airport_data2;
@@ -428,36 +428,36 @@ 
               }
                 </script>';
 	print '<div class="more"><a href="'.$globalURL.'/statistics/airport-arrival" class="btn btn-default btn" role="button">'._("See full statistic").'&raquo;</a></div>';
-    }
+	}
 ?>
             </div>
         </div>
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
 <?php
-    if ($year == '' && $month == '') {
+	if ($year == '' && $month == '') {
 ?>
         <div class="row column">
             <div class="col-md-6">
                 <h2><?php echo _("Busiest Months of the last 12 Months"); ?></h2>
                 <?php
-                  $year_array = $Stats->countAllMonthsLastYear(true,$airline_icao,$filter_name);
-		    if (count($year_array) == 0) print _("No data available");
-		    else {
-                  print '<div id="chart8" class="chart" width="100%"></div>
+				  $year_array = $Stats->countAllMonthsLastYear(true,$airline_icao,$filter_name);
+			if (count($year_array) == 0) print _("No data available");
+			else {
+				  print '<div id="chart8" class="chart" width="100%"></div>
                     <script> 
                         google.load("visualization", "1", {packages:["corechart"]});
                       google.setOnLoadCallback(drawChart8);
                       function drawChart8() {
                         var data = google.visualization.arrayToDataTable([
                             ["'._("Month").'", "'._("# of Flights").'"], ';
-                            $year_data = '';
-                          foreach($year_array as $year_item)
-                                    {
-                                        $year_data .= '[ "'.date('F, Y',strtotime($year_item['year_name'].'-'.$year_item['month_name'].'-01')).'",'.$year_item['date_count'].'],';
-                                    }
-                                    $year_data = substr($year_data, 0, -1);
-                                    print $year_data;
-                        print ']);
+							$year_data = '';
+						  foreach($year_array as $year_item)
+									{
+										$year_data .= '[ "'.date('F, Y',strtotime($year_item['year_name'].'-'.$year_item['month_name'].'-01')).'",'.$year_item['date_count'].'],';
+									}
+									$year_data = substr($year_data, 0, -1);
+									print $year_data;
+						print ']);
 
                         var options = {
                             legend: {position: "none"},
@@ -475,8 +475,8 @@ 
                               drawChart8();
                             });
                   </script>';
-                  }
-                  ?>
+				  }
+				  ?>
                 <div class="more">
                     <a href="<?php print $globalURL; ?>/statistics/year" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
                 </div>
@@ -485,24 +485,24 @@ 
             <div class="col-md-6">
                 <h2><?php echo _("Busiest Day in the last Month"); ?></h2>
                 <?php
-                  $month_array = $Stats->countAllDatesLastMonth($airline_icao,$filter_name);
-		    if (count($month_array) == 0) print _("No data available");
-		    else {
-                  print '<div id="chart9" class="chart" width="100%"></div>
+				  $month_array = $Stats->countAllDatesLastMonth($airline_icao,$filter_name);
+			if (count($month_array) == 0) print _("No data available");
+			else {
+				  print '<div id="chart9" class="chart" width="100%"></div>
                     <script> 
                         google.load("visualization", "1", {packages:["corechart"]});
                       google.setOnLoadCallback(drawChart9);
                       function drawChart9() {
                         var data = google.visualization.arrayToDataTable([
                             ["'._("Day").'", "'._("# of Flights").'"], ';
-                            $month_data = '';
-                          foreach($month_array as $month_item)
-                                    {
-                                        $month_data .= '[ "'.date('F j, Y',strtotime($month_item['date_name'])).'",'.$month_item['date_count'].'],';
-                                    }
-                                    $month_data = substr($month_data, 0, -1);
-                                    print $month_data;
-                        print ']);
+							$month_data = '';
+						  foreach($month_array as $month_item)
+									{
+										$month_data .= '[ "'.date('F j, Y',strtotime($month_item['date_name'])).'",'.$month_item['date_count'].'],';
+									}
+									$month_data = substr($month_data, 0, -1);
+									print $month_data;
+						print ']);
 
                         var options = {
                             legend: {position: "none"},
@@ -520,8 +520,8 @@ 
                               drawChart9();
                             });
                   </script>';
-                  }
-                  ?>
+				  }
+				  ?>
                 <div class="more">
                     <a href="<?php print $globalURL; ?>/statistics/month" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
                 </div>
@@ -531,25 +531,25 @@ 
             <div class="col-md-6">
                 <h2><?php echo _("Busiest Day in the last 7 Days"); ?></h2>
                 <?php
-                    $date_array = $Stats->countAllDatesLast7Days($airline_icao,$filter_name);
-		    if (empty($date_array)) print _("No data available");
-		    else {
-                  print '<div id="chart5" class="chart" width="100%"></div>
+					$date_array = $Stats->countAllDatesLast7Days($airline_icao,$filter_name);
+			if (empty($date_array)) print _("No data available");
+			else {
+				  print '<div id="chart5" class="chart" width="100%"></div>
                     <script> 
                         google.load("visualization", "1", {packages:["corechart"]});
                       google.setOnLoadCallback(drawChart5);
                       function drawChart5() {
                         var data = google.visualization.arrayToDataTable([
                             ["'._("Date").'", "'._("# of Flights").'"], ';
-                            $date_data = '';
+							$date_data = '';
                         
-                          foreach($date_array as $date_item)
-                                    {
-                                        $date_data .= '[ "'.date("F j, Y", strtotime($date_item['date_name'])).'",'.$date_item['date_count'].'],';
-                                    }
-                                    $date_data = substr($date_data, 0, -1);
-                                    print $date_data;
-                        print ']);
+						  foreach($date_array as $date_item)
+									{
+										$date_data .= '[ "'.date("F j, Y", strtotime($date_item['date_name'])).'",'.$date_item['date_count'].'],';
+									}
+									$date_data = substr($date_data, 0, -1);
+									print $date_data;
+						print ']);
 
                         var options = {
                             legend: {position: "none"},
@@ -567,8 +567,8 @@ 
                               drawChart5();
                             });
                   </script>';
-                  }
-                  ?>
+				  }
+				  ?>
                 <div class="more">
                     <a href="<?php print $globalURL; ?>/statistics/date" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
                 </div>
@@ -577,25 +577,25 @@ 
             <div class="col-md-6">
                 <h2><?php echo _("Busiest Time of the Day"); ?></h2>
                 <?php
-                  $hour_array = $Stats->countAllHours('hour',true,$airline_icao,$filter_name);
-		    if (empty($hour_array)) print _("No data available");
-		    else {
+				  $hour_array = $Stats->countAllHours('hour',true,$airline_icao,$filter_name);
+			if (empty($hour_array)) print _("No data available");
+			else {
 
-                  print '<div id="chart6" class="chart" width="100%"></div>
+				  print '<div id="chart6" class="chart" width="100%"></div>
                     <script> 
                         google.load("visualization", "1", {packages:["corechart"]});
                       google.setOnLoadCallback(drawChart6);
                       function drawChart6() {
                         var data = google.visualization.arrayToDataTable([
                             ["'._("Hour").'", "'._("# of Flights").'"], ';
-                            $hour_data = '';
-                          foreach($hour_array as $hour_item)
-                                    {
-                                        $hour_data .= '[ "'.$hour_item['hour_name'].':00",'.$hour_item['hour_count'].'],';
-                                    }
-                                    $hour_data = substr($hour_data, 0, -1);
-                                    print $hour_data;
-                        print ']);
+							$hour_data = '';
+						  foreach($hour_array as $hour_item)
+									{
+										$hour_data .= '[ "'.$hour_item['hour_name'].':00",'.$hour_item['hour_count'].'],';
+									}
+									$hour_data = substr($hour_data, 0, -1);
+									print $hour_data;
+						print ']);
 
                         var options = {
                             legend: {position: "none"},
@@ -613,8 +613,8 @@ 
                               drawChart6();
                             });
                   </script>';
-                  }
-                ?>
+				  }
+				?>
                 <div class="more">
                     <a href="<?php print $globalURL; ?>/statistics/time" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
                 </div>
@@ -622,36 +622,36 @@ 
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
         </div>
 <?php
-    }
+	}
 ?>
 
 <?php
-    if ($year == '' && $month == '' && isset($globalAccidents) && $globalAccidents) {
+	if ($year == '' && $month == '' && isset($globalAccidents) && $globalAccidents) {
 ?>
         <div class="row column">
             <div class="col-md-6">
                 <h2><?php echo _("Fatalities by Years"); ?></h2>
                 <?php
-		    require_once('require/class.Accident.php');
-            	    $Accident = new Accident();
-                  $year_array = $Accident->countFatalitiesByYear($filter_name);
-		    if (count($year_array) == 0) print _("No data available");
-		    else {
-                  print '<div id="chart32" class="chart" width="100%"></div>
+			require_once('require/class.Accident.php');
+					$Accident = new Accident();
+				  $year_array = $Accident->countFatalitiesByYear($filter_name);
+			if (count($year_array) == 0) print _("No data available");
+			else {
+				  print '<div id="chart32" class="chart" width="100%"></div>
                     <script> 
                         google.load("visualization", "1", {packages:["corechart"]});
                       google.setOnLoadCallback(drawChart32);
                       function drawChart32() {
                         var data = google.visualization.arrayToDataTable([
                             ["'._("Year").'", "'._("# of Fatalities").'"], ';
-                            $year_data = '';
-                          foreach($year_array as $year_item)
-                                    {
-                                        $year_data .= '[ "'.$year_item['year'].'",'.$year_item['count'].'],';
-                                    }
-                                    $year_data = substr($year_data, 0, -1);
-                                    print $year_data;
-                        print ']);
+							$year_data = '';
+						  foreach($year_array as $year_item)
+									{
+										$year_data .= '[ "'.$year_item['year'].'",'.$year_item['count'].'],';
+									}
+									$year_data = substr($year_data, 0, -1);
+									print $year_data;
+						print ']);
 
                         var options = {
                             legend: {position: "none"},
@@ -669,8 +669,8 @@ 
                               drawChart32();
                             });
                   </script>';
-                  }
-                  ?>
+				  }
+				  ?>
                 <div class="more">
                     <a href="<?php print $globalURL; ?>/statistics/fatalities/year" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
                 </div>
@@ -681,26 +681,26 @@ 
             <div class="col-md-6">
                 <h2><?php echo _("Fatalities last 12 Months"); ?></h2>
                 <?php
-		    require_once('require/class.Accident.php');
-            	    $Accident = new Accident();
-                  $year_array = $Accident->countFatalitiesLast12Months($filter_name);
-		    if (count($year_array) == 0) print _("No data available");
-		    else {
-                  print '<div id="chart33" class="chart" width="100%"></div>
+			require_once('require/class.Accident.php');
+					$Accident = new Accident();
+				  $year_array = $Accident->countFatalitiesLast12Months($filter_name);
+			if (count($year_array) == 0) print _("No data available");
+			else {
+				  print '<div id="chart33" class="chart" width="100%"></div>
                     <script> 
                         google.load("visualization", "1", {packages:["corechart"]});
                       google.setOnLoadCallback(drawChart33);
                       function drawChart33() {
                         var data = google.visualization.arrayToDataTable([
                             ["'._("Month").'", "'._("# of Fatalities").'"], ';
-                            $year_data = '';
-                          foreach($year_array as $year_item)
-                                    {
-                                        $year_data .= '[ "'.date('F, Y',strtotime($year_item['year'].'-'.$year_item['month'].'-01')).'",'.$year_item['count'].'],';
-                                    }
-                                    $year_data = substr($year_data, 0, -1);
-                                    print $year_data;
-                        print ']);
+							$year_data = '';
+						  foreach($year_array as $year_item)
+									{
+										$year_data .= '[ "'.date('F, Y',strtotime($year_item['year'].'-'.$year_item['month'].'-01')).'",'.$year_item['count'].'],';
+									}
+									$year_data = substr($year_data, 0, -1);
+									print $year_data;
+						print ']);
 
                         var options = {
                             legend: {position: "none"},
@@ -718,8 +718,8 @@ 
                               drawChart33();
                             });
                   </script>';
-                  }
-                  ?>
+				  }
+				  ?>
                 <div class="more">
                     <a href="<?php print $globalURL; ?>/statistics/fatalities/month" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>&raquo;</a>
                 </div>
@@ -727,30 +727,30 @@ 
     <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
 <br/>
 <?php
-    }
+	}
 ?>
 
 <?php
-    if (($airline_icao == '' || $airline_icao == 'all') && $filter_name == '' && $year == '' && $month == '') {
+	if (($airline_icao == '' || $airline_icao == 'all') && $filter_name == '' && $year == '' && $month == '') {
 ?>
         <div class="row column">
         	<?php
-        	    //$polar = $Stats->getStatsSource(date('Y-m-d'),'polar');
-        	    if ($year == '' && $month == '') {
-		        $polar = $Stats->getStatsSource('polar',date('Y'),date('m'),date('d'));
-		    } else {
-        		$polar = $Stats->getStatsSource('polar',$year,$month);
-        	    }
-        	    if (!empty($polar)) {
-            		print '<h2>'._("Coverage pattern").'</h2>';
-        		foreach ($polar as $eachpolar) {
-        		    unset($polar_data);
-	        	    $Spotter = new Spotter();
-        		    $data = json_decode($eachpolar['source_data']);
-        		    foreach($data as $value => $key) {
-        			$direction = $Spotter->parseDirection(($value*22.5));
-        			$distance = $key;
-        			$unit = 'km';
+				//$polar = $Stats->getStatsSource(date('Y-m-d'),'polar');
+				if ($year == '' && $month == '') {
+				$polar = $Stats->getStatsSource('polar',date('Y'),date('m'),date('d'));
+			} else {
+				$polar = $Stats->getStatsSource('polar',$year,$month);
+				}
+				if (!empty($polar)) {
+					print '<h2>'._("Coverage pattern").'</h2>';
+				foreach ($polar as $eachpolar) {
+					unset($polar_data);
+					$Spotter = new Spotter();
+					$data = json_decode($eachpolar['source_data']);
+					foreach($data as $value => $key) {
+					$direction = $Spotter->parseDirection(($value*22.5));
+					$distance = $key;
+					$unit = 'km';
 				if ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'nm') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'nm')) {
 					$distance = round($distance*0.539957);
 					$unit = 'nm';
@@ -761,10 +761,10 @@ 
 					$distance = $distance;
 					$unit = 'km';
 				}
-        			if (!isset($polar_data)) $polar_data = '{axis:"'.$direction[0]['direction_shortname'].'",value:'.$key.'}';
-        	    		else $polar_data = $polar_data.',{axis:"'.$direction[0]['direction_shortname'].'",value:'.$key.'}';
-        		    }
-        	?>
+					if (!isset($polar_data)) $polar_data = '{axis:"'.$direction[0]['direction_shortname'].'",value:'.$key.'}';
+						else $polar_data = $polar_data.',{axis:"'.$direction[0]['direction_shortname'].'",value:'.$key.'}';
+					}
+			?>
             <div class="col-md-6">
                 <h4><?php print $eachpolar['source_name']; ?></h4>
         	<div id="polar-<?php print str_replace(' ','_',strtolower($eachpolar['source_name'])); ?>" class="chart" width="100%"></div>
@@ -796,27 +796,27 @@ 
 		</script>
             </div>
             <?php
-        	    }
-        	}
-            ?>
+				}
+			}
+			?>
         </div>
         <div class="row column">
             <div class="col-md-6">
         	<?php
-        	    //$msg = $Stats->getStatsSource(date('Y-m-d'),'msg');
-        	    if ($year == '' && $month == '') {
-        		$msg = $Stats->getStatsSource('msg',date('Y'),date('m'),date('d'));
-        	    } else {
-        		$msg = $Stats->getStatsSource('msg',$year,$month);
-        	    }
-        	    if (!empty($msg)) {
-            		print '<h2>'._("Messages received").'</h2>';
-        		foreach ($msg as $eachmsg) {
-        		    //$eachmsg = $msg[0];
-        		    $data = $eachmsg['source_data'];
-        		    if ($data > 500) $max = (round(($data+100)/100))*100;
-        		    else $max = 500;
-        	?>
+				//$msg = $Stats->getStatsSource(date('Y-m-d'),'msg');
+				if ($year == '' && $month == '') {
+				$msg = $Stats->getStatsSource('msg',date('Y'),date('m'),date('d'));
+				} else {
+				$msg = $Stats->getStatsSource('msg',$year,$month);
+				}
+				if (!empty($msg)) {
+					print '<h2>'._("Messages received").'</h2>';
+				foreach ($msg as $eachmsg) {
+					//$eachmsg = $msg[0];
+					$data = $eachmsg['source_data'];
+					if ($data > 500) $max = (round(($data+100)/100))*100;
+					else $max = 500;
+			?>
         	<div id="msg-<?php print str_replace(' ','_',strtolower($eachmsg['source_name'])); ?>" class="col-md-4"></div>
         	<script>
 		      var g = new JustGage({
@@ -832,9 +832,9 @@ 
 			  });
 		</script>
             <?php
-        	   }
-        	}
-            ?>
+			   }
+			}
+			?>
             </div>
         </div>
         <div class="row column">
@@ -866,19 +866,19 @@ 
 				$hist_data .= '[ "'.$distance.'",'.$nb.'],';
 			}
 			$hist_data = substr($hist_data, 0, -1);
-            ?>
+			?>
             <div class="col-md-6">
                 <h2><?php echo sprintf(_("Flights Distance for %s"),$source); ?></h2>
                 <?php
-                  print '<div id="charthist-'.str_replace(' ','_',strtolower($source)).'" class="chart" width="100%"></div>
+				  print '<div id="charthist-'.str_replace(' ','_',strtolower($source)).'" class="chart" width="100%"></div>
                     <script> 
                         google.load("visualization", "1", {packages:["corechart"]});
                       google.setOnLoadCallback(drawCharthist_'.str_replace(' ','_',strtolower($source)).');
                       function drawCharthist_'.str_replace(' ','_',strtolower($source)).'() {
                         var data = google.visualization.arrayToDataTable([
                             ["'._("Distance").'", "'._("# of Flights").'"], ';
-                            print $hist_data;
-                        print ']);
+							print $hist_data;
+						print ']);
 
                         var options = {
                             legend: {position: "none"},
@@ -896,15 +896,15 @@ 
                               drawCharthist_'.str_replace(' ','_',strtolower($source)).'();
                             });
                   </script>';
-        	?>
+			?>
     	    </div>
 	    <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> -->
         	<?php
-                  }
-                ?>
+				  }
+				?>
         </div>
 <?php
-    }
+	}
 ?>
     </div>
 </div>  

statistics-registration.php

Indentation +6 added lines, -6 removed lines

@@ -8,13 +8,13 @@ 
 if (!isset($filter_name)) $filter_name = '';
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
 if ($airline_icao == 'all') {
-    unset($_COOKIE['stats_airline_icao']);
-    setcookie('stats_airline_icao', '', time()-3600);
-    $airline_icao = '';
+	unset($_COOKIE['stats_airline_icao']);
+	setcookie('stats_airline_icao', '', time()-3600);
+	$airline_icao = '';
 } elseif ($airline_icao == '' && isset($_COOKIE['stats_airline_icao'])) {
-    $airline_icao = $_COOKIE['stats_airline_icao'];
+	$airline_icao = $_COOKIE['stats_airline_icao'];
 } elseif ($airline_icao == '' && isset($globalFilter)) {
-    if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
+	if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
 }
 setcookie('stats_airline_icao',$airline_icao);
 $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT);
@@ -37,7 +37,7 @@ 
           function drawChart() {
             var data = google.visualization.arrayToDataTable([
             	["'._("Aircraft Manufacturer").'", "'._("# of times").'"], ';
-            	$registration_data = '';
+				$registration_data = '';
 foreach($registration_array as $registration_item)
 {
 	$registration_data .= '[ "'.$registration_item['registration'].' - '.$registration_item['aircraft_name'].' ('.$registration_item['aircraft_icao'].')",'.$registration_item['aircraft_registration_count'].'],';

statistics-callsign.php

Indentation +5 added lines, -5 removed lines

@@ -8,13 +8,13 @@
 if (!isset($filter_name)) $filter_name = '';
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
 if ($airline_icao == 'all') {
-    unset($_COOKIE['stats_airline_icao']);
-    setcookie('stats_airline_icao', '', time()-3600);
-    $airline_icao = '';
+	unset($_COOKIE['stats_airline_icao']);
+	setcookie('stats_airline_icao', '', time()-3600);
+	$airline_icao = '';
 } elseif ($airline_icao == '' && isset($_COOKIE['stats_airline_icao'])) {
-    $airline_icao = $_COOKIE['stats_airline_icao'];
+	$airline_icao = $_COOKIE['stats_airline_icao'];
 } elseif ($airline_icao == '' && isset($globalFilter)) {
-    if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
+	if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
 }
 setcookie('stats_airline_icao',$airline_icao);
 $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT);

statistics-airport-arrival.php

Indentation +5 added lines, -5 removed lines

@@ -8,13 +8,13 @@
 if (!isset($filter_name)) $filter_name = '';
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
 if ($airline_icao == 'all') {
-    unset($_COOKIE['stats_airline_icao']);
-    setcookie('stats_airline_icao', '', time()-3600);
-    $airline_icao = '';
+	unset($_COOKIE['stats_airline_icao']);
+	setcookie('stats_airline_icao', '', time()-3600);
+	$airline_icao = '';
 } elseif ($airline_icao == '' && isset($_COOKIE['stats_airline_icao'])) {
-    $airline_icao = $_COOKIE['stats_airline_icao'];
+	$airline_icao = $_COOKIE['stats_airline_icao'];
 } elseif ($airline_icao == '' && isset($globalFilter)) {
-    if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
+	if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
 }
 setcookie('stats_airline_icao',$airline_icao);
 $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT);