[TwinkiDaBoss]

So there isnt much of an issue, but what I want to achieve is that, I check the SQL if that username exists.

Basically if there is anyone with that name in the SQL

PHP код:

YCMD:changename(playerid,params[],help) {
    if(help) return SendClientMessage(playerid,COLOR_RED,"This command is used to allow player to change their name");
    if(AccInfo[playerid][NameToken] <= 0) return SendClientMessage(playerid,COLOR_RED,"Seems like you dont have a name change token");
    new NewName[24];
    if(sscanf(params,"s[24]",NewName)) return SendClientMessage(playerid,COLOR_RED,"Usage: /changename [new name]");
    if(strlen(params) >= 24) return SendClientMessage(playerid,COLOR_RED,"Name cannot be above 24 characters");
    if(strfind(NewName, "_") == -1) return SendClientMessage(playerid,COLOR_RED,"Your name must contain underscore in it. Usage: FirstName_LastName");
    
    new query[128];
    mysql_format(mysql, query,sizeof(query),"UPDATE `players` SET `Username`='%s' WHERE `ID`=%d",NewName,AccInfo[playerid][ID]);
    mysql_tquery(mysql, query);
    
    new string[128];
    format(string,sizeof(string),"You have changed your name into %s. You will be disconnected within few seconds to apply updates",NewName);
    SendClientMessage(playerid,COLOR_RED,string);
    format(string,sizeof(string),"%s has changed their name into %s",GetName(playerid),NewName);
    NameChangeLog(string);
    return true;
}