Alex_Jemison
Умник
Возникает проблема с добавлением аккаунта в базу данных
PHP:
[13:52:03] [WARNING] mysql_connect: no password specified
[13:53:01] [ERROR] error #1064 while executing query "INSERT INTO `accounts` (`Name`, `Password`, `Email`, `Skin`, `Sex`, `Race`, `Referal`, `RegIP`, `RegData`) VALUES ('Alex_Jemison', '16072003', 'no@gmail.com', '22', '1, '1', '0', '127.0.0.1', '24/11/2018')": 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 '1', '0', '127.0.0.1', '24/11/2018')' at line 1
PHP:
static const fmt_query[] = "INSERT INTO `accounts` (`Name`, `Password`, `Email`, `Skin`, `Sex`, `Race`, `Referal`, `RegIP`, `RegData`) VALUES ('%s', '%s', '%s', '%d', '%d, '%d', '%d', '%s', '%s')";
new query[sizeof(fmt_query)+(-2+MAX_PLAYER_NAME)+(-2+30)+(-2+64)+(-2+3)+(-2+1)+(-2+1)+(-2+8)+(-2+15)+(-2+12)];
format(query, sizeof(query), fmt_query, PlayerInfo[playerid][pName], PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pRace],PlayerInfo[playerid][pReferal],ip , date);
mysql_query(mysql, query);
