Wiliam_Prado
Умник
Ошибка:
БД от мода
Сохранение:
PHP:
Ошибка в mysql:ID 1064 | Ошибка: 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 'WHERE `Name`='William_Prado'' at line 1 | Функция: OnQueryFinish | Запрос: WHERE `Name`='William_Prado'
PHP:
CREATE TABLE IF NOT EXISTS `Accounts` (
`Name` varchar(24) COLLATE cp1251_bin NOT NULL,
`Key` varchar(30) CHARACTER SET utf8 NOT NULL,
`Level` int(11) NOT NULL,
`Sex` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
PHP:
stock SavePlayer(playerid)
{
if(GetPVarInt(playerid,"Logged") > 0)
{
new str[128];
format(str,sizeof(str),"UPDATE `Accounts` SET `Level` = '%d', `Sex` = '%d',",
PlayerInfo[playerid][Level], PlayerInfo[playerid][Sex]);
format(str, sizeof(str),"%s WHERE `Name` = '%s'", str, Name(playerid));
mysql_query(str, -1, 0, connectionHandle);
}
return 1;
}
