[nezo2001]

PHP код:

format(query, sizeof(query), "INSERT INTO houses (id, EntranceX, EntranceY, EntranceZ, ExitX, ExitY, ExitZ, InsideInt, owner, owned, price, text) VALUES ('%i', '%f', '%f', '%f', '%f', '%f', '%f', '%i', None, false, '%i', '%s')", id, x, y, z, exitx, exity, exitz, interior, price, draw); 


log:

Код:

[14:03:34] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:03:35] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:03:35] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:03:35] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:20:06] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:20:07] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:20:07] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:20:07] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:30: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 ''1022.479980' at line 1

But it connected and loaded players' info from the other table?!

Server log (debugg):

Код:

[14:37:29] [Query]: '/INSERT INTO houses (id, EntranceX, EntranceY, EntranceZ, ExitX, ExitY, ExitZ, InsideInt, owner, owned, price, text) VALUES ('1', '1419.790649', '-1623.835815', '13.546875', '225.630996', '1022.479980/'

[nezo2001]

Bump!

[Sithis]

You have a forward slash in the syntax.

[mamorunl]

Also the words 'None' and 'false' are not between quotes.

[nezo2001]

Ok I've fixed all of these and the same error, the error is after ExitY ?!

[mamorunl]

Your query length is probably too short. Make the variable longer.

[nezo2001]

Worked Thank You