-
Как исправить?
Ребят помогите пожалуйста сделал систему смена ника через Doante пишу Имя_Фамилию не какого эффекта .
PHP код:
publics: ChangeName(playerid,string[])
{
SendClientMessage(playerid,COLOR_GREEN,"Пропишите новый ник в окне SA-MP");
new mysql_query[200],stringer[126];
mysql_format(connects,mysql_query,sizeof(mysql_query), "UPDATE `accounts` SET `Name`='%s' WHERE `Name` = '%s'",WantNickChange[playerid],PlayerInfo[playerid][pNames]);
mysql_function_query(connects, mysql_query, true, "", "d", playerid);
PlayerInfo[playerid][pDonatemoney2] -= 300;
new key = PlayerInfo[playerid][pPhousekey];
if(PlayerInfo[playerid][pPhousekey] != 799 && strcmp(PlayerInfo[playerid][pNames], HouseInfo[PlayerInfo[playerid][pPhousekey]][hOwner], true) == 0)
{
strmid(HouseInfo[key][hOwner], WantNickChange[playerid], 0, strlen(WantNickChange[playerid]), 255);
}
format(stringer,sizeof(stringer), "[Смена ника] %s сменил имя на: %s.",PlayerInfo[playerid][pNames],WantNickChange[playerid]);
SendClientMessageToAll(COLOR_LIGHTRED,stringer);
SetPlayerName(playerid, WantNickChange[playerid]);
Kick(playerid);
return true;
}
-
PHP код:
publics: ChangeName(playerid,string[])
{
printf("\n\n%i) WantNickChange = %d", playerid, WantNickChange[playerid]);
printf("%i) pNames = %d", playerid, PlayerInfo[playerid][pNames]);
SendClientMessage(playerid,COLOR_GREEN,"Пропишите новый ник в окне SA-MP");
new mysql_query[53+(MAX_PLAYER_NAME*2)];
mysql_format(connects,mysql_query,sizeof(mysql_query), "UPDATE `accounts` SET `Name`='%s' WHERE `Name` = '%s'",WantNickChange[playerid],PlayerInfo[playerid][pNames]);
mysql_function_query(connects, mysql_query, true, "", "d", playerid);
printf("%i) |%s|\n\n", playerid, mysql_query);
PlayerInfo[playerid][pDonatemoney2] -= 300;
new key = PlayerInfo[playerid][pPhousekey];
if(PlayerInfo[playerid][pPhousekey] != 799 && strcmp(PlayerInfo[playerid][pNames], HouseInfo[PlayerInfo[playerid][pPhousekey]][hOwner], true) == 0)
{
strmid(HouseInfo[key][hOwner], WantNickChange[playerid], 0, strlen(WantNickChange[playerid]), 255);
}
format(mysql_query,sizeof(mysql_query), "[Смена ника] %s сменил имя на: %s.", PlayerInfo[playerid][pNames], WantNickChange[playerid]);
SendClientMessageToAll(COLOR_LIGHTRED, mysql_query);
SetPlayerName(playerid, WantNickChange[playerid]);
Kick(playerid);
return true;
}
И после смены ника логи сюда
-
Не меняется ник но вот из лог
PHP код:
[13:40:42] 1146, Table 'optimum-rp.accounts' doesn't exist, OnPlayerCheckSetName, SELECT * FROM `accounts` WHERE `Name` = 'Maksim_Torentino', 1
[13:40:48] 1146, Table 'optimum-rp.accounts' doesn't exist, OnPlayerCheckSetName, SELECT * FROM `accounts` WHERE `Name` = 'Maka_Maka', 1
- - - Добавлено - - -
Всё я разобрался проблема была в БД :)