Advertisement
Guest User

Untitled

a guest
Sep 6th, 2017
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.62 KB | None | 0 0
  1. /*
  2. CMD:oban(playerid, params[]) {
  3.  
  4. new playerName[MAX_PLAYER_NAME], banReason[84];
  5. if(sscanf(params, "s["MAX_PLAYER_NAME"]s[84]")) return SendClientMessage(playerid, -1, "Offline ban: /oban <PlayerName> <Reason>");
  6. if(!strcmp(playerName, GetName(playerid))) return SendClientMessage(playerid, red, "You can't ban yourself");
  7. foreach(new i : Player)
  8. {
  9. new playersNames[MAX_PLAYER_NAME];
  10. GetPlayerName(i, playersNames, MAX_PLAYER_NAME);
  11. if(!strcmp(playerName, playersNames, false)) return SendClientMessage(playerid, red, "The specified username is online");
  12. }
  13.  
  14. new adminName[MAX_PLAYER_NAME];
  15. GetPlayerName(playerid, adminName, MAX_PLAYER_NAME);
  16. case MYSQL_ADD_BAN:
  17. {
  18. return 1;
  19. }
  20. new query[128];
  21. mysql_format(connection, query, sizeof(query), "SELECT `IP` FROM `playerdata` WHERE `playerName` = '%e'", playerName);
  22. mysql_query(connection, query, "OnOfflineBan", "sisi", adminName, banReason, playerName);
  23. return 1;
  24. }
  25.  
  26. forward OnOfflineBan(banned_by, ban_reason, player_name);
  27. public OnOfflineBan(banned_by, ban_reason, player_name) {
  28.  
  29. new rows = cache_num_rows();
  30. if(rows) {
  31.  
  32. new ip[17];
  33. cache_get_field_content(0, "playerIP", ip);
  34.  
  35. new query[304];
  36. mysql_format(connection, query, sizeof qury,
  37. "INSERT INTO `playerbans` (banned_by, banned_for, player_banned, player_ip) VALUES ('%e', '%e', '%e', '%e')", banned_by, ban_reason, player_name, ip);
  38. mysql_tquery(connection, query);
  39.  
  40. SendClientMessage(playerid, -1, "You have successfully banend that player");
  41. return 1;
  42. }
  43. else return SendClientMessage(playerid, -1, "This name doesn't exist");
  44. }*/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement