brusselopole / Worldopole

        return $trainers;

    }

    public function getTrainerLevelRanking()

    {

        $exclue = '';

        if (!empty(self::$config->system->trainer_blacklist)) {

            $exclue .= " AND owner_name NOT IN ('".implode("','", self::$config->system->trainer_blacklist)."')";

        }

        $req = 'SELECT COUNT(*) AS count, level FROM (SELECT MAX(owner_level) as level FROM gym_defenders WHERE owner_level IS NOT NULL '.$exclue.' GROUP BY owner_level, owner_name) x GROUP BY level';

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

        $levelData = array();

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

            $levelData[$data->level] = $data->count;

        }

        for ($i = 5; $i <= 40; ++$i) {

            if (!isset($levelData[$i])) {

                $levelData[$i] = 0;

            }

        }

        // sort array again

        ksort($levelData);

        return $levelData;

    }

    public function getActivePokemon($trainer_name)

    {

        return $pokemon;

    }

    public function getTrainerLevelCount($team_id)

    {

        $exclue = '';

        if (!empty(self::$config->system->trainer_blacklist)) {

            $exclue .= " AND owner_name NOT IN ('".implode("','", self::$config->system->trainer_blacklist)."')";

        }

        $req = "SELECT COUNT(*) AS count, level FROM (SELECT MAX(owner_level) as level FROM gym_defenders WHERE owner_level IS NOT NULL AND team = '".$team_id."' ".$exclue.' GROUP BY owner_level, owner_name) x GROUP BY level';

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

        $levelData = array();

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

            $levelData[$data->level] = $data->count;

        }

        for ($i = 5; $i <= 40; ++$i) {

            if (!isset($levelData[$i])) {

                $levelData[$i] = 0;

            }

        }

        // sort array again

        ksort($levelData);

        return $levelData;

    }

    /////////

    // Cron