Advertisement
Guest User

Untitled

a guest
Sep 3rd, 2018
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.56 KB | None | 0 0
  1. ocmd:unban(playerid,params[])
  2. {
  3. new pname[128],preason[128],string[128];
  4. if(PlayerInfo[playerid][pAdmin] <=2) return SendClientMessage(playerid,COLOR_GRAD1,"Du bist nicht berechtigt, diesen Befehl auszuführen.");
  5. if(sscanf(params,"ss[128]",pname,preason))
  6. {
  7. return SendClientMessage(playerid,COLOR_GRAD1,"FEHLER: /unban [Exakter Spielername] [Grund]");
  8. }
  9. // GetPlayerName(playerid,pname,sizeof(pname))
  10. new query[128];
  11. mysql_format(handle, query, sizeof(query), "SELECT id FROM user WHERE Username = '%e'", pname);
  12. // mysql_pquery(handle, query, " ", "d", playerid);
  13. mysql_format(handle, query, sizeof(query), "UPDATE `user` SET `pBanned` = '0' WHERE `Username` = '%e'",PlayerInfo[playerid][pBanned], pname);
  14. mysql_pquery(handle, query, "", "d", pname);
  15. format(string,sizeof(string),"Du hast %s entbannt, grund %s",pname,preason);
  16. // format(string, sizeof(string), "Person: %s ID: %d Bezahlung: $%d", giveplayer, i, PlayerInfo[i][pHeadValue]);
  17. SendClientMessage(playerid,-1,string);
  18. return 1;
  19. }
  20. forward UnBanForPlayer(playerid);
  21. public UnBanForPlayer(playerid)
  22. {
  23. new rows;
  24. new query[128];
  25. new pname[128];
  26. cache_get_row_count(rows);
  27. if(rows == 0)
  28. {
  29. return SendClientMessage(playerid,COLOR_RED,"Der angegebene Name konnte in der Datenbank nicht gefunden werden!");
  30. }
  31. else
  32. {
  33. mysql_format(handle, query, sizeof(query), "UPDATE `user` SET `pBanned` = '0' WHERE `Username` = '%e'",PlayerInfo[playerid][pBanned], pname);
  34. mysql_pquery(handle, query, "OnSaveUserCheck9", "d", playerid);
  35. }
  36. return 1;
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement