[Scrillex]

Now it works but cant login.... Says wrong password.

Still at log same problem..

pawn Код:

[11:54:04] [DEBUG] CMySQLHandle::Create - creating new connection..
[11:54:04] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[11:54:04] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[11:54:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:54:06] [DEBUG] CMySQLConnection::Connect - connection was successful
[11:54:06] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[11:54:06] [DEBUG] mysql_errno - connection: 1
[11:54:06] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:54:06] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:54:06] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:54:06] [DEBUG] CMySQLConnection::Connect - connection was successful
[11:54:06] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[11:54:06] [DEBUG] CMySQLConnection::Connect - connection was successful
[11:54:06] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[11:54:06] [DEBUG] CMySQLConnection::Connect - connection was successful
[11:54:06] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[11:55:24] [DEBUG] mysql_format - connection: 1, len: 1200, format: "SELECT `Password`, `ID` FROM `playerdata` WHERE `Username` = '%e' LIMIT 1"
[11:55:24] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `playerdata` WHERE `Username` = 'Ja", callback: "OnAccountCheck", format: "i"
[11:55:24] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[11:55:27] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 3568.967 milliseconds
[11:55:27] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[11:55:27] [DEBUG] Calling callback "OnAccountCheck"..
[11:55:27] [DEBUG] cache_get_data - connection: 1
[11:55:27] [DEBUG] cache_get_field_content - row: 0, field_name: "PASS", connection: 1, max_len: 129
[11:55:27] [WARNING] CMySQLResult::GetRowDataByName - field not found ("PASS")
[11:55:27] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[11:55:27] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"
[11:55:27] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[11:56:21] [DEBUG] mysql_format - connection: 1, len: 1200, format: "UPDATE `playerdata` SET `Admin`=%d, `VIP`=%d, `Level`=%d, `Rank`=%d,`Group`=%d, `posX`=%f, `posY`=%f, `posZ`=%f, `Hours`=%d, `Mi..."
[11:56:21] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `playerdata` SET `Admin`=0, `VIP`=0, `Level`=0, `Rank`=0,", callback: "(null)", format: "(null)"
[11:56:21] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[11:56:22] [ERROR] CMySQLQuery::Execute[] - (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 'WHERE `ID`=0' at line 1
[11:57:29] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "roleplay", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[11:57:29] [DEBUG] CMySQLHandle::Create - creating new connection..
[11:57:29] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[11:57:29] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[11:57:29] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:57:29] [DEBUG] CMySQLConnection::Connect - connection was successful
[11:57:29] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[11:57:29] [DEBUG] mysql_errno - connection: 1
[11:57:29] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:57:29] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:57:29] [DEBUG] CMySQLConnection::Connect - connection was successful
[11:57:29] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[11:57:29] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:57:29] [DEBUG] CMySQLConnection::Connect - connection was successful
[11:57:29] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[11:57:29] [DEBUG] CMySQLConnection::Connect - connection was successful
[11:57:29] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[11:58:04] [DEBUG] mysql_format - connection: 1, len: 1200, format: "SELECT `Password`, `ID` FROM `playerdata` WHERE `Username` = '%e' LIMIT 1"
[11:58:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `playerdata` WHERE `Username` = 'Ja", callback: "OnAccountCheck", format: "i"
[11:58:04] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[11:58:04] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 2.84 milliseconds
[11:58:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[11:58:04] [DEBUG] Calling callback "OnAccountCheck"..
[11:58:04] [DEBUG] cache_get_data - connection: 1
[11:58:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[11:59:14] [DEBUG] mysql_format - connection: 1, len: 1200, format: "INSERT INTO `playerdata` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Level`, `Rank`, `Groupid`, `PosX` ,`PosY`, `PosZ`, `Hou..."
[11:59:14] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `playerdata` (`Username`, `Password`, `IP`, `Admin`,", callback: "OnAccountRegister", format: "i"
[11:59:14] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - starting query execution
[11:59:14] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - query was successfully executed within 68.332 milliseconds
[11:59:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[11:59:15] [DEBUG] Calling callback "OnAccountRegister"..
[11:59:15] [DEBUG] cache_insert_id - connection: 1
[11:59:15] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[11:59:25] [DEBUG] mysql_format - connection: 1, len: 1200, format: "UPDATE `playerdata` SET `Admin`=%d, `VIP`=%d, `Level`=%d, `Rank`=%d,`Group`=%d, `posX`=%f, `posY`=%f, `posZ`=%f, `Hours`=%d, `Mi..."
[11:59:25] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `playerdata` SET `Admin`=0, `VIP`=0, `Level`=0, `Rank`=11", callback: "(null)", format: "(null)"
[11:59:25] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[11:59:25] [ERROR] CMySQLQuery::Execute[] - (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 'WHERE `ID`=0' at line 1
[12:00:03] [DEBUG] mysql_format - connection: 1, len: 1200, format: "SELECT `Password`, `ID` FROM `playerdata` WHERE `Username` = '%e' LIMIT 1"
[12:00:03] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `playerdata` WHERE `Username` = 'Ja", callback: "OnAccountCheck", format: "i"
[12:00:03] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[12:00:03] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 22.244 milliseconds
[12:00:03] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[12:00:03] [DEBUG] Calling callback "OnAccountCheck"..
[12:00:03] [DEBUG] cache_get_data - connection: 1
[12:00:03] [DEBUG] cache_get_field_content - row: 0, field_name: "PASS", connection: 1, max_len: 129
[12:00:03] [WARNING] CMySQLResult::GetRowDataByName - field not found ("PASS")
[12:00:03] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[12:00:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "2"
[12:00:03] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[12:00:12] [DEBUG] mysql_format - connection: 1, len: 1200, format: "UPDATE `playerdata` SET `Admin`=%d, `VIP`=%d, `Level`=%d, `Rank`=%d,`Group`=%d, `posX`=%f, `posY`=%f, `posZ`=%f, `Hours`=%d, `Mi..."
[12:00:12] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `playerdata` SET `Admin`=0, `VIP`=0, `Level`=0, `Rank`=0,", callback: "(null)", format: "(null)"
[12:00:12] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:00:12] [ERROR] CMySQLQuery::Execute[] - (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 'WHERE `ID`=0' at line 1