brusselopole / Worldopole

	// 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 $gyms;

	}

	public function getGymData($gym_id) {

		$req = "SELECT gymdetails.name AS name, gymdetails.description AS description, gymdetails.url AS url, gym.team_id AS team,

					(CONVERT_TZ(gym.last_scanned, '+00:00', '".self::$time_offset."')) AS last_scanned, gym.guard_pokemon_id AS guard_pokemon_id, gym.total_cp AS total_cp, (6 - gym.slots_available) AS level

					FROM gymdetails

					LEFT JOIN gym ON gym.gym_id = gymdetails.gym_id

					WHERE gym.gym_id='".$gym_id."'";

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

		$data = $result->fetch_object();

		return $data;

	}

	public function getGymDefenders($gym_id) {

		$req = "SELECT DISTINCT gympokemon.pokemon_uid, pokemon_id, iv_attack, iv_defense, iv_stamina, MAX(cp) AS cp, gymmember.gym_id

	// Single Pokemon

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

	function getGymsProtectedByPokemon($pokemon_id) {

		$req = "SELECT COUNT(f.id) AS total

					FROM forts f

					LEFT JOIN fort_sightings fs ON (fs.fort_id = f.id AND fs.last_modified = (SELECT MAX(last_modified) FROM fort_sightings fs2 WHERE fs2.fort_id=f.id))

					WHERE guard_pokemon_id = '".$pokemon_id."'";

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

		$data = $result->fetch_object();

		return $data;

	}

		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) AS distime, pokemon_id as pokemon_id, FROM_UNIXTIME(expire_timestamp) as disappear_time, lat as latitude, lon as longitude,