[AmigaBlizzard]

The maximum amount of rows in a dialog is 50 (tested it myself sometime ago).
Maximum amount of characters is 4096 characters for a dialog.

To get the top 10 players, you sort them in a descending order.

PHP код:

SELECT Vardas,Specialybe,Siandien,Dispejimai FROM vartotojai ORDER BY XP DESC LIMIT 10 


This will read only 10 players who have the highest XP.
You could have a page variable that increases by 10 every time you flip a page.

PHP код:

format(query, sizeof(query), "SELECT Vardas,Specialybe,Siandien,Dispejimai FROM vartotojai ORDER BY XP DESC LIMIT %i, 10", page); 


This would read 10 players at a time, according to the page requested.