14.08.2015, 20:30
pawn Код:
forward GetRecord(playerid);
public GetRecord(playerid)
{
new r_msg[500], dialogstring[500], Rows = cache_get_row_count( );
if(Rows < 1)return SendClientMessage(playerid, COLOUR_GREY, "No records found.");
for(new n = 0; n < Rows; n++)
{
cache_get_row(n, 0, r_msg);
sscanf(r_msg, "p<|>e<iiiis[24]iiii>", PlayerArrests[n]);
if(n == 0)
{
format(dialogstring, sizeof(dialogstring), ""#COL_WHITE"%s", PlayerArrests[n][ar_cr]);
}
else
{
format(dialogstring, sizeof(dialogstring), "%s\n"#COL_WHITE"%s", dialogstring, PlayerArrests[n][ar_cr]);
}
}
strcpy(Pdialogstring[playerid], dialogstring, 200);
ShowPlayerDialog(playerid, DIALOG_RECORDS, DIALOG_STYLE_LIST, "Showing 10 Latest Records.", dialogstring, "Select", "Back");
return 1;
}
pawn Код:
format(string, sizeof(string), "SELECT * FROM `arecords` WHERE `PSQLID` = %d ORDER BY `id` DESC LIMIT 10", psql[playerid]);
mysql_tquery(dbHandle, string, "GetRecord", "i", playerid);