Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 1.80 KB | None | 0 0
  1. forward OnBanHistoryLoad(playerid,bhPID);
  2.  
  3. public OnBanHistoryLoad(playerid, bhPID)
  4. {
  5.     new rows = cache_num_rows();
  6.     static
  7.     bannedby[50],
  8.     reason[500],
  9.     date[40],
  10.     string2[2048],
  11.     string[500];
  12.     new bhmsg[250];
  13.     if (rows)
  14.     {
  15.         format(string,sizeof(string),"Ban History:\n");
  16.         for(new i=0; i < rows; i++)
  17.         {
  18.             cache_get_field_content(i, "reason", reason, dbHandle);
  19.             cache_get_field_content(i, "date", date, dbHandle);
  20.             cache_get_field_content(i, "bannedby", bannedby, dbHandle);
  21.             format(string, sizeof(string), "%s* (%s) %s (%s)\n", string, bannedby, reason, date);
  22.             strcpy(string2, string, sizeof(string2));
  23.             format(bhmsg, sizeof(bhmsg), "* [%s]{FFFFFF} has been banned [{AA3333}%d{FFFFFF}] times.", GetName(bhPID), i);
  24.             SCMEx(playerid, COLOR_YELLOWG, bhmsg);
  25.         }
  26.         return Dialog_Show(playerid, BanHistory, DIALOG_STYLE_LIST, "Player Ban History", string2, "O", "K");
  27.     }
  28.     SendClientMessage(playerid,-1,"No Ban History Found");
  29.     return 1;
  30. }
  31.  
  32.  
  33. Dialog:BanSearch(playerid, response, listitem, inputtext[])
  34. {
  35.     if(response)
  36.     {
  37.         new bhPID;
  38.         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");
  39.         mysql_format(dbHandle, query, sizeof(query),"SELECT `bannedby`, `reason`, `date` FROM `bans` WHERE `name` = %s", GetName(bhPID));
  40.         mysql_tquery(dbHandle, query, "OnBanHistoryLoad", "ii", playerid,bhPID);
  41.     }
  42.     return 1;
  43. }
  44.  
  45. CMD:banhistory(playerid)
  46. {
  47.     if(!CheckAdmin(playerid, ADMIN_LEVEL_1)) return NotAuthMSG(playerid);
  48.     Dialog_Show(playerid, BanSearch, DIALOG_STYLE_INPUT, "Player Ban History - Name Search", "NAME SEARCH\n\nInsert name\n\nFormat: Firstname_Lastname", "Enter", "Exit");
  49.     return 1;
  50. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement