Alex_Jemison
Умник
Код:
[00:14:57] [plugins/mysql] error #1064 while executing query "INSERT INTO `accounts` (`Name`, `Password`, `Email`, `Skin`, `Sex`, `Race`, `Referal`, `RegIP`, `RegData`) VALUES ('Alex_Jemison', '31072003', 'no@gmail.com": 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 ''no@gmail.com' at line 1
Код:
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)];
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);