brusselopole / Worldopole

    // Single Pokemon

    ///////////////////

    public function getGymsProtectedByPokemon($pokemon_id)

    {

        $req = "SELECT COUNT(f.id) AS total

					FROM forts f

					LEFT JOIN fort_sightings fs ON (fs.fort_id = f.id AND fs.last_modified = (SELECT MAX(last_modified) FROM fort_sightings fs2 WHERE fs2.fort_id=f.id))

					WHERE guard_pokemon_id = '".$pokemon_id."'";

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

        $data = $result->fetch_object();

        return $data;

    }

    public function getPokemonLastSeen($pokemon_id)

    {

        $req = "SELECT FROM_UNIXTIME(expire_timestamp) AS expire_timestamp, FROM_UNIXTIME(expire_timestamp) AS disappear_time_real, lat AS latitude, lon AS longitude

                FROM sightings

                WHERE pokemon_id = '".$pokemon_id."'

                ORDER BY expire_timestamp DESC

                LIMIT 0,1";

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

        $data = $result->fetch_object();

        return $data;

    }

    // Single Pokemon

    ///////////////////

    public function getGymsProtectedByPokemon($pokemon_id)

    {

        $req = "SELECT COUNT(DISTINCT(gym_id)) AS total FROM gym WHERE guard_pokemon_id = '".$pokemon_id."'";

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

        $data = $result->fetch_object();

        return $data;

    }

        return $data;

    }

    public function getPokemonLastSeen($pokemon_id)

    {

        $req = "SELECT disappear_time,

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

				latitude, longitude

				FROM pokemon

				WHERE pokemon_id = '".$pokemon_id."'

				ORDER BY disappear_time DESC

				LIMIT 0,1";

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

        $data = $result->fetch_object();

        return $data;

        return $gyms;

    }

    public function getGymData($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();