[alishvasis]

Hi I'v Made Change Name System For Mysql But Does Not Work ... Anyone Can Fix It Tnx

PHP код:

CMD:changename(playerid, params[]) {
    if(isnull(params)) {
        return SendClientMessage(playerid, -1, "/changename [newname]");
    }
    if(strlen(params) > MAX_PLAYER_NAME) {
        return SendClientMessage(playerid, -1, "Your name must contain a maximum of 24 characters.");
    }
    new current[MAX_PLAYER_NAME];
    GetPlayerName(playerid, current, sizeof current);
    if(!strcmp(current, params, false)) {
        return SendClientMessage(playerid, -1, "That's already your name!");
    }
    new query[128];
    mysql_format(koneksi, query, sizeof query, "SELECT * FROM `players` WHERE `Username` = '%s'", params);
    mysql_tquery(koneksi, query, "ChangeName", "is", playerid, params);
    return 1;
}
forward ChangeName(playerid, newname[]);
public ChangeName(playerid, newname[]) {
    if(cache_get_row_count(koneksi)) {
        return SendClientMessage(playerid, -1, "This name is already in use!");
    }
    new current[MAX_PLAYER_NAME];
    GetPlayerName(playerid, current, sizeof current);
    new query[128];
    mysql_format(koneksi, query, sizeof query, "UPDATE `players` SET `Username` = '%s' WHERE `Username` = '%s'", newname, current);
    mysql_tquery(koneksi, query);
    SetPlayerName(playerid, newname);
    return 1;
} 


[DRIFT_HUNTER]

I dont see anything wrong with code...Query is fine and everything else...
Check your mysql log...

[alishvasis]

Quote:

Originally Posted by DRIFT_HUNTER I dont see anything wrong with code...Query is fine and everything else... Check your mysql log...

Wow ! TnX + Rep And CanYou Give Me MySql Change PAssword Command?

[Sjn]

The error itself says Unknown column 'Username' in 'where clause'

Check your table properly for the correct column name. It's better if you use unique IDs if you have it assigned to their account.

[alishvasis]

TnX + Rep You Too
Can You Give Me MySql Change PAssword Command?

[Sjn]

The way of making changepassword command is basically the same as changing the username. You just hash the password and update it in the table.

[alishvasis]

Quote:

Originally Posted by Sjn The way of making changepassword command is basically the same as changing the username. You just hash the password and update it in the table.

Ok So Tnx