CMD:rename(playerid, params[])
{
    if (PlayerData[playerid][Admin] < 4) return 0;
    new ID, name[24];
    if (sscanf(params, "us[24]", ID, name)) return SendClientMessage(playerid, COLOR_WHITE, "Usage: /rename [playerid] [newname]");
    if (strlen(name) < 3 || strlen(name) > 24) return SendClientMessage(playerid, COLOR_ORED,"Error: Invalid name length! (3-24 characters allowed)");
    if (!IsPlayerConnected(ID)) return 1;
    if (GetPVarInt(ID, "Spawned") == 0) return SendClientMessage(playerid, COLOR_ORED, "Error: That player ain't spawned!");
    if(strfind(name, " ", true) != -1) return SendClientMessage(playerid, COLOR_ORED, "Error: Spaces not allowed");
    if (strcmp(name, PlayerName(ID), false) == 0) return SendClientMessage(playerid, COLOR_ORED,"Error: The current name is same as the new name!");
    for (new i=0;i<MAX_PLAYERS;i++)
    {
        if (IsPlayerConnected(i))
        {
            if (strcmp(PlayerName(i), name, false) == 0) return SendClientMessage(playerid, COLOR_ORED,"Error: This name is already in use!");
        }
    }
    format(QueryString,sizeof(QueryString),"SELECT * FROM `PlayerData` WHERE `PlayerName` = '%s'",name);
    mysql_function_query(1,QueryString,true,"CheckNameExistance","iis",playerid,ID,name);
    return 1;
}

public CheckNameExistance(playerid,target,name)
{
    new rows,fields;
    cache_get_data(rows,fields);
    if(rows) return SendClientMessage(playerid, COLOR_ORED, "Error: This name is already in use!");
    SetPVarString(target, "Newname", name);
    SetPVarInt(target, "Newnamesender", playerid);
    new string[256];
    format(string,sizeof(string),"{FFFFFF}Do you wish to change your name to {00FF00}%s?\n\n{00FF00}Notice! This operation cannot be undone", name);
    ShowPlayerDialog(target, 38, DIALOG_STYLE_MSGBOX, "Name change", string, "Accept", "Decline");
    SendClientMessage(playerid, COLOR_YELLOW, "You have sent the request");
    return 1;
}