brusselopole / Worldopole

		return $counts;

	}

	public function getPokemonSinceLastUpdate($pokemon_id, $last_update) {

		$where = "WHERE pokemon_id = '".$pokemon_id."' AND id > '".$last_update."'";

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

					FROM sightings

					JOIN (SELECT COUNT(*) AS count

						FROM sightings

                    	" . $where. "

                    ) count ON 1 = 1

					" . $where . "

					ORDER BY expire_timestamp DESC

					LIMIT 1 OFFSET 0";

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

		$data = pg_fetch_object($result);

		return $data;

	}

	public function getRaidsSinceLastUpdate($pokemon_id, $last_update) {

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

		return $data;

	}

	public function getRaidsSinceLastUpdate($pokemon_id, $last_update) {

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

		$req = "SELECT time_battle AS start_timestamp, time_end as end, (TO_TIMESTAMP(time_end)) AS end_time_real, lat as latitude, lon as longitude, count

					FROM raids r

					JOIN forts g ON r.fort_id = g.id

					JOIN (SELECT COUNT(*) AS count

						FROM raids

                    	" . $where."

                    ) count ON 1 = 1 

	                " . $where."

	                ORDER BY time_battle DESC

					LIMIT 1 OFFSET 0";

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

		$data = pg_fetch_object($result);

		return $data;

	}

	public function getCaptchaCount() {

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