Advertisement
Guest User

Untitled

a guest
Jan 16th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. publics:GiveAdmPlayerMySQL(nickname[], level, name[])
  2. {
  3. new r, f, playerid = GetPlayerID(nickname);
  4. cache_get_data(r, f);
  5. if(r)
  6. {
  7. if(level == 0)
  8. {
  9. mysql_format(DATABASE, QUERY, 128, "DELETE FROM "TABLE_ADMIN" WHERE `Name`= '%s'", nickname);
  10. mysql_function_query(DATABASE, QUERY ,false, "", "");
  11.  
  12. if(IsPlayerConnected(playerid)) Kick(playerid);
  13. }
  14. else
  15. {
  16. mysql_format(DATABASE,QUERY,256, "UPDATE "TABLE_ADMIN" SET `level` = '%i' WHERE `Name` = '%s' LIMIT 1",level, nickname);
  17. mysql_function_query(DATABASE,QUERY,false,"","");
  18.  
  19. mysql_format(DATABASE,QUERY,256, "UPDATE `accounts` SET `AdmName` = '%i' WHERE `Name` = '%s' LIMIT 1", name, nickname);
  20. mysql_function_query(DATABASE,QUERY,false,"","");
  21.  
  22. PTEMP[playerid][AdmName][0] = EOS;
  23. strcat(PTEMP[playerid][AdmName], name, MAX_PLAYER_NAME);
  24. }
  25. }
  26. else
  27. {
  28. mysql_format(DATABASE,QUERY, 512, "INSERT INTO "TABLE_ADMIN" (`Name`, `level`, `AdmName`) VALUES ('%s', %i, CURDATE(), '%s')", nickname, level, name);
  29. mysql_function_query(DATABASE, QUERY, false, "", "");
  30. }
  31. return 1;
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement