brusselopole / Worldopole

	// Homepage

	/////////////

	function getTotalPokemon() {

		$req = "SELECT COUNT(*) AS total FROM sightings WHERE expire_timestamp >= EXTRACT(EPOCH FROM NOW())";

		$result = pg_query($this->db, $req);

		$data = pg_fetch_object($result);

		return $data;

	}

	function getTotalLures() {

		$data = (object) array("total" => 0);

		return $data;

	}

	function getTotalGyms() {

		$req = "SELECT COUNT(*) AS total FROM forts";

		$result = pg_query($this->db, $req);

		$data = pg_fetch_object($result);

		return $data;

	}

	function getTotalRaids() {

		$req = "SELECT COUNT(*) AS total FROM raids WHERE time_battle <= EXTRACT(EPOCH FROM NOW()) AND time_end >= EXTRACT(EPOCH FROM NOW())";

		return $data;

	}

	function getTotalRaids() {

		$req = "SELECT COUNT(*) AS total FROM raids WHERE time_battle <= EXTRACT(EPOCH FROM NOW()) AND time_end >= EXTRACT(EPOCH FROM NOW())";

		$result = pg_query($this->db, $req);

		$data = pg_fetch_object($result);

		return $data;

	}

	function getTotalGymsForTeam($team_id) {

	}

	function getTotalGymsForTeam($team_id) {

		$req = "SELECT COUNT(*) AS total FROM fort_sightings WHERE team = '$team_id'";

		$result = pg_query($this->db, $req);

		$data = pg_fetch_object($result);

		return $data;

	}

	function getRecentAll() {

		$req = "SELECT DISTINCT pokemon_id, encounter_id, TO_TIMESTAMP(expire_timestamp) AS disappear_time, TO_TIMESTAMP(updated) AS last_modified, TO_TIMESTAMP(expire_timestamp) AS disappear_time_real,

	// Single Pokemon

	///////////////////

	function getGymsProtectedByPokemon($pokemon_id) {

		$req = "SELECT COUNT(DISTINCT(fort_id)) AS total FROM fort_sightings WHERE guard_pokemon_id = '".$pokemon_id."'";

		$result = pg_query($this->db, $req);

		$data = pg_fetch_object($result);

		return $data;

	}

	function getPokemonLastSeen($pokemon_id) {

		$req = "SELECT TO_TIMESTAMP(expire_timestamp) AS expire_timestamp, TO_TIMESTAMP(expire_timestamp) AS disappear_time_real, lat AS latitude, lon AS longitude

		return $data;

	}

	function getPokemonLastSeen($pokemon_id) {

		$req = "SELECT TO_TIMESTAMP(expire_timestamp) AS expire_timestamp, TO_TIMESTAMP(expire_timestamp) AS disappear_time_real, lat AS latitude, lon AS longitude

                FROM sightings

                WHERE pokemon_id = '".$pokemon_id."'

                ORDER BY expire_timestamp DESC

                LIMIT 1 OFFSET 0";

		$result = pg_query($this->db, $req);

		$data = pg_fetch_object($result);

		return $data;

	}

	function getTop50Pokemon($pokemon_id, $top_order_by, $top_direction) {

		$req = "SELECT DISTINCT encounter_id, expire_timestamp, TO_TIMESTAMP(expire_timestamp) AS distime, pokemon_id as pokemon_id, TO_TIMESTAMP(expire_timestamp) as disappear_time, lat as latitude, lon as longitude,

		return $spawns;

	}

	public function getPokemonSliederMinMax() {

		$req = "SELECT TO_TIMESTAMP(MIN(expire_timestamp)) AS min, TO_TIMESTAMP(MAX(expire_timestamp)) AS max FROM sightings";

		$result = pg_query($this->db, $req);

		$data = pg_fetch_object($result);

		return $data;

	}

	public function getMapsCoords() {

		$req = "SELECT MAX(lat) AS max_latitude, MIN(lat) AS min_latitude, MAX(lon) AS max_longitude, MIN(lon) as min_longitude FROM spawnpoints";

		return $data;

	}

	public function getMapsCoords() {

		$req = "SELECT MAX(lat) AS max_latitude, MIN(lat) AS min_latitude, MAX(lon) AS max_longitude, MIN(lon) as min_longitude FROM spawnpoints";

		$result = pg_query($this->db, $req);

		$data = pg_fetch_object($result);

		return $data;

	}

	///////////////

	//////////////

	function getTotalPokestops() {

		$req = "SELECT COUNT(*) as total FROM pokestops";

		$result = pg_query($this->db, $req);

		$data = pg_fetch_object($result);

		return $data;

	}

	public function getAllPokestops() {

		$req = "SELECT lat as latitude, lon as longitude, null AS lure_expiration, EXTRACT(EPOCH FROM NOW()) AS now, null AS lure_expiration_real FROM pokestops";

		return $datas;

	}

	function getOwnedAndPoints($team_id) {

		$req = "SELECT COUNT(DISTINCT(fs.fort_id)) AS total, ROUND((SUM(gd.cp)) / COUNT(DISTINCT(fs.fort_id)),0) AS average_points

        			FROM fort_sightings fs

        			JOIN gym_defenders gd ON fs.fort_id = gd.fort_id

        			WHERE fs.team = '" . $team_id . "'";

		$result = pg_query($this->db, $req);

		$data = pg_fetch_object($result);

		return $data;

	}

	function getAllGyms() {

		$req = "SELECT f.id as gym_id, team as team_id, f.lat as latitude, f.lon as longitude, updated as last_scanned, (6 - fs.slots_available) AS level FROM forts f LEFT JOIN fort_sightings fs ON f.id = fs.fort_id;";

		return $gyms;

	}

	public function getGymData($gym_id) {

		$req = "SELECT f.name AS name, null AS description, f.url AS url, fs.team AS team, TO_TIMESTAMP(fs.updated) AS last_scanned, fs.guard_pokemon_id AS guard_pokemon_id, (6 - fs.slots_available) AS level, SUM(gd.cp) as total_cp	

			FROM fort_sightings fs

			LEFT JOIN forts f ON f.id = fs.fort_id

			LEFT JOIN gym_defenders gd ON f.id = gd.fort_id

			WHERE f.id ='".$gym_id."'

			GROUP BY f.name, f.url, fs.team, fs.updated, fs.guard_pokemon_id, fs.slots_available, gd.cp";

		$result = pg_query($this->db, $req);

		$data = pg_fetch_object($result);

		return $data;

	}

	public function getGymDefenders($gym_id) {

		$req = "SELECT DISTINCT external_id as pokemon_uid, pokemon_id, atk_iv as iv_attack, def_iv as iv_defense, sta_iv as iv_stamina, cp, fort_id as gym_id

		return $data;

	}

	public function getCaptchaCount() {

		$req = " SELECT COUNT(*) as total FROM accounts WHERE captchaed IS NOT NULL AND reason IS NULL";

		$result = pg_query($this->db, $req);

		$data = pg_fetch_object($result);

		return $data;

	}

	public function getNestData() {

		$pokemon_exclude_sql = "";