brusselopole / Worldopole

		return $counts;

	}

	public function getPokemonSinceLastUpdate($pokemon_id, $last_update) {

		$where = "WHERE p.pokemon_id = '".$pokemon_id."' AND p.expire_timestamp - (coalesce(CASE WHEN duration = 0 THEN NULL ELSE duration END ,30)*60) > '".$last_update."'";

		$req = "SELECT count, p.expire_timestamp - (coalesce(CASE WHEN duration = 0 THEN NULL ELSE duration END ,30)*60) AS last_timestamp, (FROM_UNIXTIME(p.expire_timestamp)) AS disappear_time_real, p.lat as latitude, p.lon as longitude

					FROM sightings p

					LEFT JOIN spawnpoints s ON p.spawn_id = s.spawn_id

					JOIN (SELECT COUNT(*) AS count

						FROM sightings p

						LEFT JOIN spawnpoints s ON p.spawn_id = s.spawn_id

                    	" . $where."

                    ) x

					" . $where . "

					ORDER BY last_timestamp DESC

					LIMIT 0 , 1";

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

		$data = $result->fetch_object();

		return $data;

	}

		return $data;

	}

	public function getRaidsSinceLastUpdate($pokemon_id, $last_update) {

		$where = "WHERE pokemon_id = '".$pokemon_id."AND".$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 $counts;

	}

	public function getPokemonSinceLastUpdate($pokemon_id, $last_update) {

		$where = "WHERE p.pokemon_id = '".$pokemon_id."' AND (UNIX_TIMESTAMP(p.disappear_time) - (LENGTH(s.kind) - LENGTH( REPLACE ( kind, \"s\", \"\") )) * 900) > '".$last_update."'";

		$req = "SELECT count, (UNIX_TIMESTAMP(p.disappear_time) - (LENGTH(s.kind) - LENGTH( REPLACE ( kind, \"s\", \"\") )) * 900) as last_timestamp, (CONVERT_TZ(p.disappear_time, '+00:00', '".self::$time_offset."')) AS disappear_time_real, p.latitude, p.longitude

				FROM pokemon p

				JOIN spawnpoint s ON p.spawnpoint_id = s.id

				JOIN (SELECT count(*) as count

                    FROM pokemon p

                    JOIN spawnpoint s ON p.spawnpoint_id = s.id

                    " . $where."

                ) x

				" . $where . "

				ORDER BY last_timestamp DESC

                LIMIT 0,1";

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

		$data = $result->fetch_object();

		return $data;

	}

		return $data;

	}

	public function getRaidsSinceLastUpdate($pokemon_id, $last_update) {

		$where = "WHERE pokemon_id = '".$pokemon_id."' AND 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";