Ysurac / FlightAirMap

                $all = $sth->fetchAll(PDO::FETCH_ASSOC);

                return $all;

        }

	public function getSumStats($type,$year) {

    		global $globalArchiveMonths, $globalDBdriver;

    		if ($globalDBdriver == 'mysql') {

	                $query = "SELECT SUM(cnt) as total FROM stats WHERE stats_type = :type AND YEAR(stats_date) = :year";

	        } else {

            		$query = "SELECT SUM(cnt) as total FROM stats WHERE stats_type = :type AND EXTRACT(YEAR FROM stats_date) = :year";

                }

                $query_values = array(':type' => $type, ':year' => $year);

                 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) {

    		global $globalArchiveMonths, $globalDBdriver;

    		if ($globalDBdriver == 'mysql') {

                        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";

			$query_values = array(':date' => $date);

		} else {

			$query = "SELECT * FROM stats_source WHERE stats_date = :date AND stats_type = :stats_type ORDER BY source_name";

			$query_values = array(':date' => $date,':stats_type' => $stats_type);

		}

                 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 addStatSource($data,$source_name,$stats_type,$date) {

		global $globalDBdriver;