brusselopole / Worldopole

		return $data;

	}

	public function getRaidsSinceLastUpdate($pokemon_id, $last_update) {

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

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

					FROM raids r

					JOIN forts g

					JOIN (SELECT COUNT(*) AS count

					FROM raids

                    " . $where."

                ) x 

				ON r.fort_id = g.id

                " . $where."

                ORDER BY time_battle DESC

				LIMIT 0 , 1";

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

		$data = $result->fetch_object();

		return $data;

	}

	public function getCaptchaCount() {

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

		return $data;

	}

	public function getRaidsSinceLastUpdate($pokemon_id, $last_update) {

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

		$req = "SELECT UNIX_TIMESTAMP(start) as start_timestamp, end, (CONVERT_TZ(end, '+00:00', '".self::$time_offset."')) AS end_time_real, latitude, longitude, count

                FROM raid r

                JOIN gym g

                JOIN (SELECT count(*) as count

                    FROM raid

                    " . $where."

                ) x

                ON r.gym_id = g.gym_id

                " . $where."

                ORDER BY start DESC

                LIMIT 0,1";

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

		$data = $result->fetch_object();

		return $data;

	}

	public function getCaptchaCount() {

		$req = "SELECT SUM(accounts_captcha) AS total FROM mainworker";