|
Huge Clucker
Join Date: Jan 2014
Location: Netherlands
Posts: 269
Reputation: 3
|
 Mysql /ChangeName Help
Hi I'v Made Change Name System For Mysql But Does Not Work ... Anyone Can Fix It Tnx
PHP Code:
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;
}
|
21/07/2016, 07:33 AM
Aucun commentaire:
Enregistrer un commentaire