Advertisement
Guest User

Untitled

a guest
Sep 20th, 2018
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. ocmd:setadmin(playerid,params[])
  2. {
  3. new number,level;
  4. if(sscanf(params,"dd", number, level)) return GameTextForPlayer(playerid,"~g~/setadmin ~w~[AccountID] [Level]",2500,1);
  5. if(level <0 || level>=10) return GameTextForPlayer(playerid,"~g~/setadmin ~w~ [AccountID] [Level]",2500,1); //Hier war ein ~ zu viel = Crash
  6. new query[256];
  7. mysql_format(handle, query, sizeof(query), "SELECT Name FROM user WHERE number = '%d'", number); //Du gibst die ID ein, dann nutze diese auch für die Abfrage
  8. mysql_pquery(handle, query, "SetAdminLevelForPlayer", "ddd", playerid, level, number);
  9. return 1;
  10. }
  11. forward SetAdminLevelForPlayer(playerid, level, number);
  12. public SetAdminLevelForPlayer(playerid, level, number)
  13. {
  14. new rows, string[145], name[MAX_PLAYER_NAME];
  15. cache_get_row_count(rows);
  16. if(rows == 0) return SendClientMessage(playerid,-1,"AccountID not found");
  17. else
  18. {
  19. cache_get_value_name(0, "Name", name); //Wir lesen noch den Name aus.
  20. format(string, sizeof(string), "ADMIN: %s has setted the Admin Level of %s <%d> to %d ", GetName(playerid),name,number,level);
  21. ABroadCast(0xFFFFA333,string);
  22. SendClientMessage(playerid,-1,string);
  23. mysql_format(handle, string, sizeof(string), "UPDATE user SET Adminlevel = '%d' WHERE number = '%d'", level,number); //Auch hier, die eingegebene ID nutzen
  24. mysql_pquery(handle, string);
  25. return 1;
  26. }
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement