- Регистрация
- 13 Июл 2018
- Сообщения
- 50
- Лучшие ответы
- 0
- Репутация
- 1
Здоров, база данных для меня как взлом пентагона. Вроде все в коде правильно прописано, а почему не работает не понимаю. Help pls.
Сток:
Лог ошибок:
Надеюсь на вашу солидарность.
Сток:
HTML:
stock SaveAccounts(playerid)
{
static str_fmt[800+MAX_PLAYER_NAME];
mysql_format(connect, string, sizeof(string), "INSERT INTO `accounts` (`Name`, `Password`, `Level`, `Money`, `Admin`, `Bank`, `Email`, `Referal`, `Sex`, `Skin`, `RegIp`, `RegData`, `RegDataTime`) VALUES ('%e', '%e', '%d', '%d', '%d', '%d', '%e', '%e', '%d', '%d', '%e', '%e', '%e')",
Player[playerid][pLevel], Player[playerid][pMoney], Player[playerid][pAdmin],
Player[playerid][pBank], Player[playerid][pEmail], Player[playerid][pReferal],
Player[playerid][pSex], Player[playerid][pSkin], Player[playerid][pRegIp],
Player[playerid][pRegData], Player[playerid][pRegDataTime]);
printf("[SaveAccounts] %s", str_fmt);
return mysql_tquery(connect,str_fmt, "", "");
}
HTML:
[22:31:14] [plugins/mysql] error #1364 while executing query "INSERT INTO `accounts` (`Name`, `Password`, `Level`, `Money`, `Admin`, `Bank`, `Email`, `Referal`, `Sex`, `Skin`, `RegIp`, `RegData`, `RegDataTime`) VALUES ('mainFarmer1', '123123', '1', '120', '0', '0', 'None', 'None', '1', '161', '127.0.0.1', '10/11/2019', '22:31:14')": Field 'Exp' doesn't have a default value
[22:31:37] [plugins/mysql] mysql_format: no value for specifier '%e' passed
[22:31:37] [plugins/mysql] error #1054 while executing query "UPDATE `accounts` SET `Level` = '1', `Money` = '120', `Admin` = '0', `Bank` = '0', `Email` = 'None', `Referal` = 'None', `Sex` = '1', `Skin` = '161', `RegIp` = '127.0.0.1', `RegData` = '10/11/2019', `RegDataTime` = '22:31:14', `Exp` = '0', `Time` = '0', `LastIp` = '255.255.255.255', `Health` = '100', `Hunger` = '100', `Card` = '0', `Load` = '0', `SDPistol` = '0', `Deagle` = '0', `Shotgun` = '0', `MP5` = '0', `AK47` = '0', `M4` = '0', `Pistol` = '0', `MicroUSI` = '0', `Sniper` = '0', `Driver` = '0', `Password` = '123123' WHERE `Name` = 'mainFarmer1'": Unknown column 'Driver' in 'field list'
[22:31:37] [plugins/mysql] error #1065 while executing query "": Query was empty