Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CMD:setdblevel(playerid, params[])
- {
- new account[24], Query[300], bString[128], level, Cache:GetCache;
- if(pData[playerid][Admin] == 10)
- {
- if(sscanf(params, "s[24]i", account,level)) return SendClientMessage(playerid, COLOR_RED, "USAGE: /Setdblevel [Account] [Level]");
- if(strlen(account) > 24) return SendClientMessage(playerid, COLOR_RED, "ERROR: Player name cannot exceed 24 characters!");
- if(level > 10) return SendClientMessage(playerid,red,"ERROR: Invalid Level");
- format(Query, sizeof(Query), "SELECT `Username` FROM `players` WHERE `Username` = '%s' LIMIT 1", account);
- mysql_query(Query);
- if(cache_get_row_count() == 1)
- {
- format(Query, sizeof(Query), "UPDATE `players` SET Admin=%d WHERE `user` = '%s'", level, account);
- GetCache = mysql_query(Query);
- format(bString, sizeof(bString), "* You have succesfully set %s's level to %d.", account, level);
- SendClientMessage(playerid, -1, bString);
- }
- else
- {
- format(bString, sizeof(bString), "ERROR: Name %s doesn't exists in the database!", account);
- return SendClientMessage(playerid, red, bString);
- }
- cache_delete(GetCache);
- }
- else return SendClientMessage(playerid, yellow, "Sorry, you are not high enough level to use this command.");
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement