brusselopole / Worldopole

	// Single Pokemon

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

	function getGymsProtectedByPokemon($pokemon_id) {

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

		$result = $this->mysqli->query($req);

		$data = $result->fetch_object();

		return $data;

	}

	function getPokemonLastSeen($pokemon_id) {

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

		return $data;

	}

	function getPokemonLastSeen($pokemon_id) {

		$req = "SELECT FROM_UNIXTIME(expire_timestamp) AS expire_timestamp, FROM_UNIXTIME(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 0,1";

		$result = $this->mysqli->query($req);

		$data = $result->fetch_object();

		return $data;

	}

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

		$req = "SELECT FROM_UNIXTIME(expire_timestamp+0) AS distime, pokemon_id+0 as pokemon_id, FROM_UNIXTIME(expire_timestamp+0) as disappear_time, lat as latitude, lon as longitude,

		return $counts;

	}

	public function getPokemonSinceLastUpdate($pokemon_id, $last_update) {

		$req = "SELECT COUNT(*) AS count, MAX(expire_timestamp) AS last_timestamp, (FROM_UNIXTIME(MAX(expire_timestamp))) AS disappear_time_real, lat as latitude, lon as longitude

					FROM sightings

					WHERE pokemon_id = '".$pokemon_id."' && expire_timestamp > '".$last_update."'";

		$result = $this->mysqli->query($req);

		$data = $result->fetch_object();

		return $data;

	}

	public function getRaidsSinceLastUpdate($pokemon_id, $last_update) {

		$where = "WHERE pokemon_id = '".$pokemon_id."' && time_battle > '".$last_update."'";

	// Single Pokemon

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

	function getGymsProtectedByPokemon($pokemon_id) {

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

		$result = $this->mysqli->query($req);

		$data = $result->fetch_object();

		return $data;

	}

	function getPokemonLastSeen($pokemon_id) {

		$req = "SELECT disappear_time, (CONVERT_TZ(disappear_time, '+00:00', '".self::$time_offset."')) AS disappear_time_real, latitude, longitude

		return $data;

	}

	function getPokemonLastSeen($pokemon_id) {

		$req = "SELECT disappear_time, (CONVERT_TZ(disappear_time, '+00:00', '".self::$time_offset."')) AS disappear_time_real, latitude, longitude

							FROM pokemon

							WHERE pokemon_id = '".$pokemon_id."'

							ORDER BY disappear_time DESC

							LIMIT 0,1";

		$result = $this->mysqli->query($req);

		$data = $result->fetch_object();

		return $data;

	}

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

		$req = "SELECT (CONVERT_TZ(disappear_time, '+00:00', '".self::$time_offset."')) AS distime, pokemon_id, disappear_time, latitude, longitude,

		return $counts;

	}

	public function getPokemonSinceLastUpdate($pokemon_id, $last_update) {

		$req = "SELECT COUNT(*) as count, UNIX_TIMESTAMP(MAX(disappear_time)) as last_timestamp, (CONVERT_TZ(MAX(disappear_time), '+00:00', '".self::$time_offset."')) AS disappear_time_real, latitude, longitude 

				FROM pokemon 

				WHERE pokemon_id = '".$pokemon_id."' && UNIX_TIMESTAMP(disappear_time) > '".$last_update."'";

		$result = $this->mysqli->query($req);

		$data = $result->fetch_object();

		return $data;

	}

	public function getRaidsSinceLastUpdate($pokemon_id, $last_update) {

		$where = "WHERE pokemon_id = '".$pokemon_id."' && UNIX_TIMESTAMP(start) > '".$last_update."'";