CMD:banlist( playerid, params[] )
{
	new strt[226];
	format(strt, sizeof(strt), "SELECT * FROM `bans` WHERE `ID` > 0");
	mysql_tquery(SQL, strt, "BanList", "d", playerid);
	return 1;
}

stock BanList( playerid )
{
    new szDialog[MAX_STRING], szDialog2[1024];
	new liRows, liFields, OnName[ MAX_PLAYER_NAME ], OnName2[ MAX_PLAYER_NAME ], BBanDate[200];
	cache_get_data( liRows, liFields );

	strcat(szDialog2, "{FFFF00}ID\t{FFFF00}BanName\t{FFFF00}Admin\t{FFFF00}Ban Date\n");
	for( new i = 0; i < liRows; i ++ )
	{
		cache_get_field_content( i, "PlayerName", OnName );
		cache_get_field_content( i, "AdminName", OnName2 );
		cache_get_field_content( i, "BanTimeDate", BBanDate, 1, 200 );

		format(szDialog, sizeof(szDialog), "%d\t%s\t%s\t%s\n", i + 1, OnName, OnName2, BBanDate);
		strcat(szDialog2, szDialog);
		strmid(UniversalVar[i + 1][vNameBanList], OnName, 0, strlen(OnName), 255);
	}
	ShowPlayerDialog(playerid, DIALOG_BANLISTX, 5, "{6699FF}The List Of Players Banned:", szDialog2, "Select", "Exit");
	return ( 1 );
}



OnDialogResponse

	if(dialogid == DIALOG_BANLISTX)
	{
		if(response)
		{
			if(listitem >= 0)
			{
   				new IdBanList = listitem+1;
				new qstr[256];

			    new cont = MySQLCheckAccount(UniversalVar[IdBanList][vNameBanList]);
			    if(cont == 0) return SCM(playerid,COLOR_WHITE,"{FFB870}Nu exista nici un jucator cu acest nume, banat.");
		        format(qstr,sizeof(qstr),"SELECT * FROM bans WHERE `PlayerName`='%s' AND `Active`='1'", UniversalVar[IdBanList][vNameBanList]);
	    		new Cache: banuri = mysql_query(SQL, qstr);
	    		if(cache_get_row_count() > 0)
	    		{
					new Security1[24];
					new query22[256];
				    mysql_real_escape_string(UniversalVar[IdBanList][vNameBanList], Security1);
				    format(query22, sizeof(query22), "SELECT * FROM `bans` WHERE `PlayerName` = '%s'", Security1);
				    mysql_tquery(SQL, query22, "OnInfoBanCalled", "ds", playerid, UniversalVar[IdBanList][vNameBanList]);
					return 1;
				}
				else
				{
				    SendClientMessage(playerid, COLOR_LIGHTRED, "This player is not banned.");
				}
				cache_delete(banuri);
			}
		}
		return 1;
	}

SELECT ... LIMIT 20, 10

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

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

new gTotalBans;

//OnGameModeInit
mysql_tquery(SQL, "SELECT COUNT(*) FROM bans;", "OnTotalBansNumberLoad", "");

forward OnTotalBansNumberLoad();
public OnTotalBansNumberLoad()
{
    gTotalBans = cache_get_row_int(0, 0, SQL);
}

#define MAX_RESULTS 3

...

//command /banlist:
format(strt, sizeof(strt), "SELECT * FROM `bans` WHERE `ID` > 0 LIMIT 0,%d", MAX_RESULTS); 
mysql_tquery(SQL, strt, "ShowBanList", "d", playerid);

//OnPlayerConnect:
pLastPage[playerid] = 0;

//ShowBanList:
pLastPage[playerid] = 1; //set first page at top

new OnName[ MAX_PLAYER_NAME ], OnName2[ MAX_PLAYER_NAME ], BBanDate[200]; 
new title[128], string[300];

string = "ID\tName\tAName\tDate"; 

for(new i = 0, j = cache_num_rows(); i < j; i ++) 
{ 
    cache_get_field_content( i, "PlayerName", OnName ); 
    cache_get_field_content( i, "AdminName", OnName2 ); 
    cache_get_field_content( i, "BanTimeDate", BBanDate, 1, 200 );

    format(string, sizeof(string), "%s\n%d\t%s\t%s\t%s", string, i + 1, OnName, OnName2, BBanDate); 
}

if (gTotalBans > pLastPage[playerid] * MAX_RESULTS) //Total bans 5 > 3 (page 1 * 3 items per page) so last option is "Next Page"
{
    strcat(string, "Next Page");
}

format(title, sizeof(title), "{FFFF00}Bans - Page %d of %d", pLastPage[playerid], floatround(float(gTotalBans) / float(MAX_RESULTS), floatround_ceil));

if (response)
{
    if (MAX_RESULTS + 1 == listitem)
    {
        // player selected "Next Page");

        new strt[226];
        format(strt, sizeof(strt), "SELECT * FROM `bans` WHERE `ID` > 0 LIMIT %d,%d", pLastPage[playerid] * MAX_RESULTS, MAX_RESULTS); 
        mysql_tquery(SQL, strt, "ShowBanList", "d", playerid);

        pLastPage[playerid]++;
    }
}
else pLastPage[playerid] = 0;