Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- forward OnBanHistoryLoad(playerid,bhPID);
- public OnBanHistoryLoad(playerid, bhPID)
- {
- new rows = cache_num_rows();
- static
- bannedby[50],
- reason[500],
- date[40],
- string2[2048],
- string[500];
- new bhmsg[250];
- if (rows)
- {
- format(string,sizeof(string),"Ban History:\n");
- for(new i=0; i < rows; i++)
- {
- cache_get_field_content(i, "reason", reason, dbHandle);
- cache_get_field_content(i, "date", date, dbHandle);
- cache_get_field_content(i, "bannedby", bannedby, dbHandle);
- format(string, sizeof(string), "%s* (%s) %s (%s)\n", string, bannedby, reason, date);
- strcpy(string2, string, sizeof(string2));
- format(bhmsg, sizeof(bhmsg), "* [%s]{FFFFFF} has been banned [{AA3333}%d{FFFFFF}] times.", GetName(bhPID), i);
- SCMEx(playerid, COLOR_YELLOWG, bhmsg);
- }
- return Dialog_Show(playerid, BanHistory, DIALOG_STYLE_LIST, "Player Ban History", string2, "O", "K");
- }
- SendClientMessage(playerid,-1,"No Ban History Found");
- return 1;
- }
- Dialog:BanSearch(playerid, response, listitem, inputtext[])
- {
- if(response)
- {
- new bhPID;
- if(sscanf(inputtext, "u", bhPID)) return Dialog_Show(playerid, BanSearch, DIALOG_STYLE_INPUT, "Player Ban History - Name Search", "NAME SEARCH\n\nInsert name\n\nFormat: Firstname_Lastname", "Enter", "Exit");
- mysql_format(dbHandle, query, sizeof(query),"SELECT `bannedby`, `reason`, `date` FROM `bans` WHERE `name` = %s", GetName(bhPID));
- mysql_tquery(dbHandle, query, "OnBanHistoryLoad", "ii", playerid,bhPID);
- }
- return 1;
- }
- CMD:banhistory(playerid)
- {
- if(!CheckAdmin(playerid, ADMIN_LEVEL_1)) return NotAuthMSG(playerid);
- Dialog_Show(playerid, BanSearch, DIALOG_STYLE_INPUT, "Player Ban History - Name Search", "NAME SEARCH\n\nInsert name\n\nFormat: Firstname_Lastname", "Enter", "Exit");
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement