[NinjaChicken]

CMD:approvename(playerid, params[]) {
if(PlayerInfo[playerid][pAdmin] < 1)
return SendClientMessage(playerid, COLOR_GREY, "You're not authorised to use this command.");

new
iTarget,
szQuery[128];

if(sscanf(params, "u", iTarget))
return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /approvename [playerid/partOfName]");

if(iTarget == INVALID_PLAYER_ID)
return SendClientMessage(playerid, COLOR_GREY, "Invalid player specified.");

if(GetPVarInt(iTarget, "RequestingNameChange") == 0)
return SendClientMessage(playerid, COLOR_GREY, "The specified player isn't requesting a name change.");

new
szPlayerName[MAX_PLAYER_NAME];

GetPVarString(iTarget, "NewNameRequest", szPlayerName, MAX_PLAYER_NAME);
SetPVarInt(iTarget, "requestby", playerid);

mysql_real_escape_string(szPlayerName, szPlayerName, g_MySQLConnections[0]);

SetPVarString(iTarget, "requestedname", szPlayerName);

format(szQuery, sizeof(szQuery), "SELECT Username FROM players WHERE Username = '%s'", szPlayerName);
mysql_query(szQuery, THREAD_CHECK_NEW_NAME, iTarget, g_MySQLConnections[0]);
return 1;
}