Код HTML:
Здравствуйте, у меня проблема с сохранением аккаунта, прохожу регистрацию, всё нормально, выдается деньги лвл и всё такое, но в БД не сохраняется.
PHP код:
stock CreateAccount(playerid)
{
if(!PlayerRegistered[playerid]) return SKick(playerid,4128);
PlayerRegistered[playerid] = false;
pInfo[playerid][pLevel] = 1;
pInfo[playerid][pCash] = 400;
pInfo[playerid][pBank] = 250;
mysql_query_string[0] = EOS;
format(mysql_query_string, 1100, "\
INSERT INTO "T_ACCOUNTS" (name,password,regip,datareg,sex,age,model,mail,referal,searchserv) \
VALUES \
('%s','%s','%s',CURDATE(),%i,%i,%i,'%s','%s','%s')",
GetName(playerid), pInfo[playerid][pPassword], pInfo[playerid][pIP], pInfo[playerid][pSex], pInfo[playerid][pAge], pInfo[playerid][pModel], pInfo[playerid][pMail], pInfo[playerid][pReferal], pInfo[playerid][pSearchServ]);
mysql_tquery(huseyn, mysql_query_string, "@OnPlayerRegisterMysql", "d", playerid);
gPlayerLogged[playerid] = true;
SetHunger(playerid, pInfo[playerid][pHunger]);
Hunger(playerid, 0);
SendClientMessage(playerid, COLOR_VITYA5, !"[Помощь] {FFFFFF}Требуется помощь по серверу? Рядом находится пикап, с полезной для Вас информацией");
MysqlUpdatePlayerInt(playerid, "cash", pInfo[playerid][pCash]);
MysqlUpdatePlayerInt(playerid, "bank", pInfo[playerid][pBank]);
new string[128];
foreach(new i : Player)
{
if(!gAdminLogged[i]) continue;
if(!AdminInfo[i][admInfoNewPlayer]) continue;
format(string, sizeof(string), "Приветствуем нового игрока нашего сервера {63BD4E}%s [%i]", GetName(playerid), playerid);
SendClientMessage(i, COLOR_WHITE, string);
}
return 1;
}
А тут Select скина..
PHP код:
if (newkeys == KEY_SPRINT)
{
if(pTemp[playerid][pChoosingSkin] == true) //Выбор скина
{
new skinid = GetPVarInt(playerid,"skinid");
new cat = 0;
if(pInfo[playerid][pSex] == 2) cat = 1;
DeletePVar(playerid,"skinid");
new skin = gRegSkins[cat][skinid];
pInfo[playerid][pModel] = skin;
pTemp[playerid][pChoosingSkin] = false;
TextDrawHideForPlayer(playerid,TD[tdNextSkin]);
TextDrawHideForPlayer(playerid,TD[tdBackSkin]);
TextDrawHideForPlayer(playerid,TD[tdSelSkin]);
TogglePlayerControllable(playerid, 1);
PlayerRegistered[playerid] = true;
SpawnPlayer(playerid);
CreateAccount(playerid); // Вот тут
}
}
Лог с БД
Код HTML:
[13:05:34] [ERROR] error #1064 while executing query "INSERT INTO accounts (name,password,regip,datareg,sex,age,model,mail,referal,searchserv) VALUES ('Test_Test','huseyn','127.0.0.1',CURDATE(),1,0,79,'[email protected]','e','па/у": You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''па/у' at line 1