[Pawn] /top online

[Pinch]

You don't need YSI if you're using sqlite

Code:

SELECT
   online_time
FROM
   Players
WHERE
    is_online = 1
ORDER BY
    online_time DESC
LIMIT 10;

EDIT: If you want to have command like /top [from] [to], edit the LIMIT to [to] and add OFFSET [from] after LIMIT [to] in the query, example:

Code:

SELECT
   online_time
FROM
   Players
WHERE
    is_online = 1
ORDER BY
    online_time DESC
LIMIT 5 OFFSET 10;

That will show 5 players from 11th to 15th place