brusselopole / Worldopole

		return $array;

	}

	public function getPokemonLive($pokemon_id, $ivMin, $ivMax, $inmap_pokemons) {

		$inmap_pkms_filter = "";

		$where = " WHERE disappear_time >= UTC_TIMESTAMP() AND pokemon_id = ".$pokemon_id;

		$reqTestIv = "SELECT MAX(individual_attack) AS iv FROM pokemon ".$where;

		$resultTestIv = $this->mysqli->query($reqTestIv);

		$testIv = $resultTestIv->fetch_object();

		if (!is_null($inmap_pokemons) && ($inmap_pokemons != "")) {

			foreach ($inmap_pokemons as $inmap) {

				$inmap_pkms_filter .= "'".$inmap."',";

			}

			$inmap_pkms_filter = rtrim($inmap_pkms_filter, ",");

			$where .= " AND encounter_id NOT IN (".$inmap_pkms_filter.") ";

		}

		if ($testIv->iv != null && !is_null($ivMin) && ($ivMin != "")) {

			$where .= " AND ((100/45)*(individual_attack+individual_defense+individual_stamina)) >= (".$ivMin.") ";

		}

		if ($testIv->iv != null && !is_null($ivMax) && ($ivMax != "")) {

			$where .= " AND ((100/45)*(individual_attack+individual_defense+individual_stamina)) <= (".$ivMax.") ";

		}

		$req = "SELECT pokemon_id, encounter_id, latitude, longitude, disappear_time,

						(CONVERT_TZ(disappear_time, '+00:00', '".self::$time_offset."')) AS disappear_time_real,

						individual_attack, individual_defense, individual_stamina, move_1, move_2

						FROM pokemon ".$where."

						ORDER BY disappear_time DESC

						LIMIT 5000";

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

		$spawns = array();

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

			$spawns[] = $data;

		}

		return $spawns;

	}

	public function getPokemonSliderMinMax() {

		$req = "SELECT MIN(disappear_time) AS min, MAX(disappear_time) AS max FROM pokemon";

		return $array;

	}

	public function getPokemonLive($pokemon_id, $ivMin, $ivMax, $inmap_pokemons) {

		$inmap_pkms_filter = "";

		$where = " WHERE expire_timestamp >= UNIX_TIMESTAMP() AND pokemon_id = " . $pokemon_id;

		$reqTestIv = "SELECT MAX(atk_iv) AS iv FROM sightings " . $where;

		$resultTestIv = $this->mysqli->query($reqTestIv);

		$testIv = $resultTestIv->fetch_object();

		if (!is_null($inmap_pokemons) && ($inmap_pokemons != "")) {

			foreach ($inmap_pokemons as $inmap) {

				$inmap_pkms_filter .= "'".$inmap."',";

			}

			$inmap_pkms_filter = rtrim($inmap_pkms_filter, ",");

			$where .= " AND encounter_id NOT IN (" . $inmap_pkms_filter . ") ";

		}

		if ($testIv->iv != null && !is_null($ivMin) && ($ivMin != "")) {

			$where .= " AND ((100/45)*(atk_iv + def_iv + sta_iv)) >= (" . $ivMin . ") ";

		}

		if ($testIv->iv != null && !is_null($ivMax) && ($ivMax != "")) {

			$where .= " AND ((100/45)*(atk_iv + def_iv + sta_iv)) <= (" . $ivMax . ") ";

		}

		$req = "SELECT pokemon_id, lat AS latitude, lon AS longitude,

    					FROM_UNIXTIME(expire_timestamp) AS disappear_time,

    					FROM_UNIXTIME(expire_timestamp) AS disappear_time_real,

    					atk_iv AS individual_attack, def_iv AS individual_defense, sta_iv AS individual_stamina,

   						move_1, move_2

					FROM sightings " . $where . "

					ORDER BY disappear_time DESC

					LIMIT 5000";

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

		$spawns = array();

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

			$spawns[] = $data;

		}

		return $spawns;

	}

	public function getPokemonSliderMinMax() {

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