- Регистрация
- 13 Апр 2018
- Сообщения
- 202
- Лучшие ответы
- 0
- Репутация
- 0
PHP:
[16:09:33] [ERROR] error #1064 while executing query "UPDATE `accounts` SET `Skin`= 26, `Sex`= 1, `Lvl`= 1, `Exp`= 5, `Money`= 250, `Mute`= 0, `Race`= 1, `Time`= 47, `Admin`= 8, `Donate`= 250, `BankCard`= 0, `LastIP`= 194.44.145.222 WHERE `id` = '4'": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.145.222 WHERE `id` = '4'' at line 1 (D:\SAMP\New Mode\gamemodes\new.pwn:1945 -> D:\SAMP\New Mode\gamemodes\new.pwn:548 -> D:\SAMP\New Mode\pawno\include\nex-ac.inc:3305)
PHP:
stock SaveAccount(playerid)
{
if(GetPVarInt(playerid, "Logged") == 1)
{
static const fmt_query[] = "UPDATE `accounts` SET `Skin`= %d, `Sex`= %d, `Lvl`= %d, `Exp`= %d, `Money`= %d, `Bank`= %d,`Mute`= %d, `Race`= %d, `Time`= %d, `Admin`= %d, `Donate`= %d, `BankCard`= %d, `LastIP`= %s WHERE `id` = '%d'";
new query[sizeof(fmt_query)+(-2+3)+(-2+1)+(-2+11)+(-2+11)+(-2+11)+(-2+10)+(-2+11)+(-2+1)+(-2+11)+(-2+1)+(-2+11)+(-2+10)+(-2+15)+(-2+8)];
format(query, sizeof(query), fmt_query, PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pLvl], PlayerInfo[playerid][pExp], PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pMute], PlayerInfo[playerid][pRace], PlayerInfo[playerid][pTime], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pDonate], PlayerInfo[playerid][pBankCard], PlayerInfo[playerid][pLastIP], PlayerInfo[playerid][pID]);
mysql_tquery(mysql, query);
return printf("Аккаунт %s успешно сохранен", GetName(playerid));
}
return 1;
}
Последнее редактирование: