PDA

Просмотр полной версии : [Вопрос] Как исправить?



Maksim97
03.06.2014, 00:52
Ребят помогите пожалуйста сделал систему смена ника через Doante пишу Имя_Фамилию не какого эффекта .


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;
}

DeimoS
03.06.2014, 06:35
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;
}
И после смены ника логи сюда

Maksim97
03.06.2014, 14:50
Не меняется ник но вот из лог


[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

- - - Добавлено - - -

Всё я разобрался проблема была в БД :)