Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- publics:GiveAdmPlayerMySQL(nickname[], level, name[])
- {
- new r, f, playerid = GetPlayerID(nickname);
- cache_get_data(r, f);
- if(r)
- {
- if(level == 0)
- {
- mysql_format(DATABASE, QUERY, 128, "DELETE FROM "TABLE_ADMIN" WHERE `Name`= '%s'", nickname);
- mysql_function_query(DATABASE, QUERY ,false, "", "");
- if(IsPlayerConnected(playerid)) Kick(playerid);
- }
- else
- {
- mysql_format(DATABASE,QUERY,256, "UPDATE "TABLE_ADMIN" SET `level` = '%i' WHERE `Name` = '%s' LIMIT 1",level, nickname);
- mysql_function_query(DATABASE,QUERY,false,"","");
- mysql_format(DATABASE,QUERY,256, "UPDATE `accounts` SET `AdmName` = '%i' WHERE `Name` = '%s' LIMIT 1", name, nickname);
- mysql_function_query(DATABASE,QUERY,false,"","");
- PTEMP[playerid][AdmName][0] = EOS;
- strcat(PTEMP[playerid][AdmName], name, MAX_PLAYER_NAME);
- }
- }
- else
- {
- mysql_format(DATABASE,QUERY, 512, "INSERT INTO "TABLE_ADMIN" (`Name`, `level`, `AdmName`) VALUES ('%s', %i, CURDATE(), '%s')", nickname, level, name);
- mysql_function_query(DATABASE, QUERY, false, "", "");
- }
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement