pawn Code:
CMD:osetadminname(playerid, params[])
{
if(!PermissionCheck(playerid, 7)) return SendClientMessageEx(playerid, COLOR_GREY, "You are not authourized to use this command.");
new szName[MAX_PLAYER_NAME], szQuery[256], DBResult:szResult, szString[128], AdminName[24];
GetPlayerName(playerid, szName, MAX_PLAYER_NAME);
if(sscanf(params, "s[24]s[128]", szName, AdminName)) return SendClientMessage(playerid, -1, "USAGE: /osetadminname [Name] [AdminName]");
format(szQuery, sizeof(szQuery), "SELECT Username FROM Accounts WHERE Username = '%s'", szName);
szResult = db_query(Database, szQuery);
if(!db_num_rows(szResult))
{
SendClientMessage(playerid, -1, "That name doesnt Exist in the database.");
}
else {
format(PlayerInfo[playerid][pAdminName], 24, "%s", AdminName);
format(szQuery, sizeof(szQuery), "UPDATE `Accounts` SET `pAdminName`='%s' WHERE `Username`='%s'", AdminName, szName);
db_free_result(db_query(Database, szQuery));
format(szString, sizeof(szString), "You have set %s's to admin name to %s.", szName, AdminName);
SendClientMessage(playerid, -1, szString);
print(szQuery);
return 1;
}
return 1;
}