Capabilities
LIST_RANKINGS
Return PvP, PK, and level leaderboard rows
The leaderboards on the player portal. Offline characters count — a ranking that only listed who happens to be online right now would not be a ranking. Staff characters are excluded, because a public board topped by GMs tells players nothing.
Rows use the same character object as
LIST_ACCOUNT_CHARACTERS.
| Metric | Primary order | Tie-breaker |
|---|---|---|
pvp | PvP kills descending | Level descending |
pk | PK kills descending | Level descending |
level | Level descending | PvP kills descending |
limit is clamped to 1–100.
Implementing it
JsonArray listRankings(String metric, int limit) throws Exception;Both reference implementations filter accesslevel = 0 to drop staff. They differ only in the
character identifier column: aCis reads obj_Id, Mobius reads charId.
Verification
Connector check asks for the first PvP row. An empty ranking passes: on a fresh server there is genuinely nothing to rank, and that is not a fault in the query.