brusselopole / Worldopole

		return $gyms;

	}

	public function getGymData($gym_id) {

		$gym_id = $this->mysqli->real_escape_string($_GET['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

		return $data;

	}

	private function getTrainerActivePokemon($trainer_name){

		$req = "(SELECT DISTINCT gympokemon.pokemon_id, gympokemon.pokemon_uid, gympokemon.cp, DATEDIFF(UTC_TIMESTAMP(), gympokemon.last_seen) AS last_scanned, gympokemon.trainer_name, gympokemon.iv_defense, gympokemon.iv_stamina, gympokemon.iv_attack, filtered_gymmember.gym_id, CONVERT_TZ(filtered_gymmember.deployment_time, '+00:00', '".self::$time_offset."') as deployment_time, '1' AS active

					FROM gympokemon INNER JOIN

					(SELECT gymmember.pokemon_uid, gymmember.gym_id, gymmember.deployment_time FROM gymmember GROUP BY gymmember.pokemon_uid, gymmember.deployment_time, gymmember.gym_id HAVING gymmember.gym_id <> '') AS filtered_gymmember

					ON gympokemon.pokemon_uid = filtered_gymmember.pokemon_uid

					WHERE gympokemon.trainer_name='".$trainer_name."'

					ORDER BY gympokemon.cp DESC)";

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

		$pokemons = array();

		while ($data = $result->fetch_object()) {

			$pokemons[] = $data;

		}

		return $pokemons;

	}

	private function getTrainerInactivePokemon($trainer_name){

		$req = "(SELECT DISTINCT gympokemon.pokemon_id, gympokemon.pokemon_uid, gympokemon.cp, DATEDIFF(UTC_TIMESTAMP(), gympokemon.last_seen) AS last_scanned, gympokemon.trainer_name, gympokemon.iv_defense, gympokemon.iv_stamina, gympokemon.iv_attack, null AS gym_id, CONVERT_TZ(filtered_gymmember.deployment_time, '+00:00', '".self::$time_offset."') as deployment_time, '0' AS active

		return $pokemons;

	}

	private function getTrainerInactivePokemon($trainer_name){

		$req = "(SELECT DISTINCT gympokemon.pokemon_id, gympokemon.pokemon_uid, gympokemon.cp, DATEDIFF(UTC_TIMESTAMP(), gympokemon.last_seen) AS last_scanned, gympokemon.trainer_name, gympokemon.iv_defense, gympokemon.iv_stamina, gympokemon.iv_attack, null AS gym_id, CONVERT_TZ(filtered_gymmember.deployment_time, '+00:00', '".self::$time_offset."') as deployment_time, '0' AS active

					FROM gympokemon LEFT JOIN

					(SELECT * FROM gymmember HAVING gymmember.gym_id <> '') AS filtered_gymmember

					ON gympokemon.pokemon_uid = filtered_gymmember.pokemon_uid

					WHERE filtered_gymmember.pokemon_uid IS NULL AND gympokemon.trainer_name='".$trainer_name."'

					ORDER BY gympokemon.cp DESC)";

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

		$pokemons = array();

		while ($data = $result->fetch_object()) {

			$pokemons[] = $data;

		}

		return $pokemons;

	}

	/////////