brusselopole / Worldopole

				  	GROUP BY gd.owner_name'.$order.$limit;

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

        $trainers = array();

        while ($data = $result->fetch_object()) {

            $data->last_seen = date('Y-m-d', strtotime($data->last_seen));

            if (is_null($data->active)) {

                $data->active = 0;

            }

            $trainers[$data->name] = $data;

            $pokemon = array_merge($this->getActivePokemon($data->name), $this->getInactivePokemon($data->name));

            $trainers[$data->name]->gyms = $data->active;

            $trainers[$data->name]->pokemons = $pokemon;

            $trainers[$data->name]->rank = $ranking[$data->level];

        }

        return $trainers;

    }

				  	GROUP BY gd.owner_name'.$order.$limit;

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

        $trainers = array();

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

            $data->last_seen = date('Y-m-d', strtotime($data->last_seen));

            if (is_null($data->active)) {

                $data->active = 0;

            }

            $trainers[$data->name] = $data;

            $pokemon = array_merge($this->getActivePokemon($data->name), $this->getInactivePokemon($data->name));

            $trainers[$data->name]->gyms = $data->active;

            $trainers[$data->name]->pokemons = $pokemon;

            $trainers[$data->name]->rank = $ranking[$data->level];

        }

        return $trainers;

    }