[Calisthenics]

MySQL provides LIMIT clause. Have a variable that holds the total number of bans. Then you can use offset and items per page.

pawn Код:

SELECT ... LIMIT 20, 10

it will select 10 items starting from rowid 20. So basically you have a variable that stores page.

pawn Код:

..., "SELECT ... LIMIT %d,%d", page * ITEMS_PER_PAGE, ITEMS_PER_PAGE);

to determinate if there is "Next Page":

pawn Код:

if (page * ITEMS_PER_PAGE > total_bans)
{
    strcat(dialog_string_here, "Next Page");
}