[DerickClark]

Quote:

Originally Posted by Antonio144 The error is pretty self explanatory. CMySQLQuery::Execute[OnAccountRegister] - (error #1054) Unknown column 'PosX' in 'field list' You don't have PosX, PosY, PosZ columns in your table. Don't just copy and paste the code. Write it line by line, understand it, modify it. That is the only way to learn.

Yeah i removed posX, PosY,PosZ

Код:

[10:04:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = 'Test.", callback: "OnAccountCheck", format: "i"
[10:04:13] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution

Код:

[10:04:13] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[10:04:15] [DEBUG] mysql_format - connection: 1, len: 300, format: "INSERT INTO `Players` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Money`)"
[10:04:15] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `Players` (`Username`, `Password`, `IP`, `Admin`, `V", callback: "OnAccountRegister", format: "i"
[10:04:15] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - starting query execution
[10:04:15] [ERROR] CMySQLQuery::Execute[OnAccountRegister] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
[10:04:15] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - error will be triggered in OnQueryError

Код:

	mysql_format(mysql, query, sizeof(query),"SELECT `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1", Name[playerid]);
	mysql_tquery(mysql, query, "OnAccountCheck", "i", playerid);