[jlalt]

PHP код:

mysql_tquery(mysql_db, query, "ChangeName", "is", playerid, params); 


I don't think can do that with MySQL cause I've tried it before ;c instead do that:

Код:

new myname[MAX_PLAYERS][32];

then on change name command:

Код:

dcmd_changename(playerid, params[])
                    {
                        if(PlayerToPoint(3.0,playerid,358.5789,166.3685,1008.3828))
                        {
                            if(ChangedName[playerid] == 1) return SendClientMessage(playerid, COLOR_GREY, "testt");
                            if(isnull(params))
                            {
                                return SendClientMessage(playerid, -1, "/changename [new name]");
                            }
                            if(strlen(params) > MAX_PLAYER_NAME)
                            {
                                return SendClientMessage(playerid, -1, "Name has to have 24 caracters.");
                            }
                            new current[MAX_PLAYER_NAME];
                            GetPlayerName(playerid, current, sizeof current);
                            if(!strcmp(current, params, false))
                            {
                                return SendClientMessage(playerid, -1, "This is already your name!");
                            }
                            new housekey = PlayerInfo[playerid][pPhousekey];
                            if(PlayerInfo[playerid][pPhousekey] != 255)
                            {
                                new query[100];
                                format(query, sizeof(query), "UPDATE houseid SET Owner='%s' WHERE Name='%s'", params, current);
                                mysql_tquery(mysql_db, query, "", "");

                                strmid(HouseInfo[housekey][hOwner],query,0,strlen(query),255);
                                OnPropTextdrawUpdate(1, housekey);
                                SCM(playerid, TEAM_GROVE_COLOR," test");
                            }
                            format(myname[playerid],32,"%s",params);
                            new query[128];
                            mysql_format(mysql_db, query, sizeof query, "SELECT * FROM `players` WHERE `Name` = '%s'", params);
                            mysql_tquery(mysql_db, query, "ChangeName", "i", playerid);
                            //return 1;
                        }
                        return 1;
                    }

then on the call back:

Код:

forward ChangeName(playerid, newname[]);
public ChangeName(playerid, newname[]) {
    new rows, fields;
	cache_get_data(rows, fields, mysql);
	if(!rows) return SendClientMessage(playerid, -1, "This name doesn't exist!");
    new current[MAX_PLAYER_NAME];
    GetPlayerName(playerid, current, sizeof current);
    new query[128];
    mysql_format(mysql_db, query, sizeof query, "UPDATE `players` SET `Name` = '%s' WHERE `Name` = '%s'", myname[playerid], current);
    mysql_tquery(mysql_db, query);

    SetPlayerName(playerid, myname[playerid]);
    return 1;
}