brusselopole / Worldopole

        return $data;

    }

    public function getTop50Pokemon($pokemon_id, $top_order_by, $top_direction)

    {

        $req = "SELECT expire_timestamp, TO_TIMESTAMP(expire_timestamp) AS distime, pokemon_id as pokemon_id, TO_TIMESTAMP(expire_timestamp) as disappear_time, lat as latitude, lon as longitude,

                cp, atk_iv as individual_attack, def_iv as individual_defense, sta_iv as individual_stamina,

                ROUND(100*(atk_iv+def_iv+sta_iv)/45,1) AS \"IV\", move_1 as move_1, move_2, form

                FROM sightings

	            WHERE pokemon_id = '".$pokemon_id."' AND move_1 IS NOT NULL AND move_1 <> '0'

	            ORDER BY $top_order_by $top_direction, expire_timestamp DESC

	            LIMIT 50 OFFSET 0";

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

        $top = array();

        while ($data = pg_fetch_object($result)) {

            $top[] = $data;

        }

        return $top;

    }

        return array('last_page' => $last_page, 'data' => $history);

    }

    private function getHistoryForGymPokemon($gym_id, $last_modified)

    {

        $req = "SELECT ghd.defender_id, gd.pokemon_id, ghd.cp, gd.owner_name as trainer_name

					FROM gym_history_defenders ghd

					JOIN gym_defenders gd ON ghd.defender_id = gd.external_id

					WHERE ghd.fort_id = '".$gym_id."' AND date = '".$last_modified."'

					ORDER BY gd.deployment_time";

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

        $pokemons = array();

        while ($data = pg_fetch_object($result)) {

            $pokemons[$data->defender_id] = $data;

        }

        return $pokemons;

    }

    ///////////

    // Raids

    ///////////

    public function getAllRaids($page)

    {

        $limit = ' LIMIT 10 OFFSET '.($page * 10);

        $req = 'SELECT r.fort_id AS gym_id, r.level AS level, r.pokemon_id AS pokemon_id, r.cp AS cp, r.move_1 AS move_1, r.move_2 AS move_2, TO_TIMESTAMP(r.time_spawn) AS spawn, TO_TIMESTAMP(r.time_battle) AS start, TO_TIMESTAMP(r.time_end) AS end, TO_TIMESTAMP(fs.updated) AS last_scanned, f.name, f.lat AS latitude, f.lon as longitude

					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))

				 	LEFT JOIN raids r ON (r.fort_id = f.id AND r.time_end >= UNIX_TIMESTAMP())

					WHERE r.time_end > EXTRACT(EPOCH FROM NOW())

					ORDER BY r.level DESC, r.time_battle'.$limit;

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

        $raids = array();

        while ($data = pg_fetch_object($result)) {

            $raids[] = $data;

        }

        return $raids;

    }