[trapstar2020]

Quote:

[20:51:29] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "newage", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [20:51:29] [DEBUG] CMySQLHandle::Create - creating new connection.. [20:51:29] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [20:51:29] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [20:51:29] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:51:29] [DEBUG] CMySQLConnection::Connect - connection was successful [20:51:29] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:51:29] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:51:29] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:51:29] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:51:29] [DEBUG] CMySQLConnection::Connect - connection was successful [20:51:29] [DEBUG] CMySQLConnection::Connect - connection was successful [20:51:29] [DEBUG] CMySQLConnection::Connect - connection was successful [20:51:29] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:51:29] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:51:29] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:51:50] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `accounts` WHERE `Username` = '%s' LIMIT 1" [20:51:50] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `accounts` WHERE `Username` = 'Nao_", callback: "OnAccountCheck", format: "i" [20:51:50] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution [20:51:50] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.434 milliseconds [20:51:50] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:51:50] [DEBUG] Calling callback "OnAccountCheck".. [20:51:50] [DEBUG] cache_get_data - connection: 1 [20:51:50] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [20:51:56] [DEBUG] mysql_format - connection: 1, len: 1000, format: "INSERT INTO `accounts` (`Username`, `Password`, `IP`, `Skin`, `Cash`, `Bank`, `Gold` ,`Level`, `Respect`, `Admin`, `Helper`, `VI..." [20:51:56] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `accounts` (`Username`, `Password`, `IP`, `Skin`, `C", callback: "OnAccountRegister", format: "i" [20:51:56] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - starting query execution [20:51:56] [ERROR] CMySQLQuery::Execute[OnAccountRegister] - (error #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 ''No', '')' at line 1 [20:51:56] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - error will be triggered in OnQueryError [20:51:56] [DEBUG] Calling callback "OnQueryError".. [20:51:57] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `accounts` SET `Admin`=%d, `VIP`=%d, `Cash`=%d, `X`=%f, `Y`=%f, `Z`=%f WHERE `ID`=%d" [20:51:57] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `Admin`=5, `VIP`=0, `Cash`=0, `X`=0.0, `Y`", callback: "(null)", format: "(null)" [20:51:57] [DEBUG] CMySQLQuery::Execute[] - starting query execution [20:51:57] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.473 milliseconds [20:51:57] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

pawn Код:

format(query, sizeof(query), "INSERT INTO `accounts` (`Username`, `Password`, `IP`, `Skin`, `Cash`, `Bank`, `Gold` ,`Level`, `Respect`, `Admin`, `Helper`, `VIP`, `Tutorial`, `X`, `Y`, `Z`, `A`, `INT`, `VW`, `Health`,");
                format(query, sizeof(query), "%s `Armour`, `Weapon1`, `Ammo1`, `Weapon2`, `Ammo2`, `Weapon3`, `Ammo3`, `Weapon4`, `Ammo4`, `Weapon5`, `Ammo5`, `Weapon6`, `Ammo6`, `Weapon7`, `Ammo7`, `Weapon8`, `Ammo8`, `Weapon9`, `Ammo9`, `Weapon10`, `Ammo10`, `Weapon11`, `Ammo11`,", query);
                format(query, sizeof(query), "%s `Weapon12`, `Ammo12`, `Weapon13`, `Ammo13`, `Seconds`, `Minutes`, `Hours`, `Kills`, `Deaths`, `Banned`, `BanReason`) VALUES ('%s', '%s', '%s', 26, 5000, 10000, 1, 1, 0, 0, 0, 0,0, 0.0, 0.0, 0.0, 0.0, 0, 0, 100.0, 0.0, 0,0, 0,0, 0,0, 0,0,", query);
                format(query, sizeof(query),"%s 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,0,0,0,0,0 'No', '')", query, RPNU(playerid), hashpass, PlayerInfo[playerid][pIP]);

                mysql_format(mysql, query, sizeof(query), query);