[Antonio [G-RP]]

I am having a problem here, most likely to do with the floats. Does anybody know the problem?

Код:

format(Query, sizeof(Query), "INSERT INTO `accounts` (username, password, level, cash, pos_x, pos_y, pos_z) VALUES('%s', '%s', '%d', '%f', '%f', '%f')", EscapedName, EscapedPassword, 1, 2500, 1742.9363, -1861.8215, 13.5770);

[Antonio [G-RP]]

Anybody?

[Carlton]

pawn Код:

format(Query, sizeof(Query), "INSERT INTO `accounts` (username, password, level, cash, pos_x, pos_y, pos_z) VALUES('%s', '%s', 1, 2500, '1742.9363', '-1861.8215', '13.5770')", EscapedName, EscapedPassword);

[Antonio [G-RP]]

Hmm still didn't work.. Check this...

Код:

[02:55:15] MySQL Error (0): Could not execute query. 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 ''17' at line 1.
[02:55:15] MySQL Error (0): Could not execute query. Unknown column 'biskey' in 'field list'.
[02:55:15] MySQL Error (0): Could not execute query. 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 '0' WHERE `SQLid` = '0'' at line 1.
[02:55:16] MySQL Error (0): Could not execute query. Unknown column 'biskey' in 'field list'.
[02:55:16] MySQL Error (0): Could not execute query. 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 '0' WHERE `SQLid` = '0'' at line 1.
[02:55:18] MySQL Error (0): Could not execute query. Unknown column 'biskey' in 'field list'.
[02:55:18] MySQL Error (0): Could not execute query. 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 '0' WHERE `SQLid` = '0'' at line 1.

[Carlton]

Quote:

Originally Posted by Antonio [G-RP] Hmm still didn't work.. Check this... Код: [02:55:15] MySQL Error (0): Could not execute query. 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 ''17' at line 1. [02:55:15] MySQL Error (0): Could not execute query. Unknown column 'biskey' in 'field list'. [02:55:15] MySQL Error (0): Could not execute query. 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 '0' WHERE `SQLid` = '0'' at line 1. [02:55:16] MySQL Error (0): Could not execute query. Unknown column 'biskey' in 'field list'. [02:55:16] MySQL Error (0): Could not execute query. 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 '0' WHERE `SQLid` = '0'' at line 1. [02:55:18] MySQL Error (0): Could not execute query. Unknown column 'biskey' in 'field list'. [02:55:18] MySQL Error (0): Could not execute query. 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 '0' WHERE `SQLid` = '0'' at line 1.

That's your problem, you need to add a biskey named field. I didn't even fix anything related to biskey you're directing me to the wrong query

[Antonio [G-RP]]

Ah my apologies, I spelt it wrong from what it really is. Here is the MAIN errors.

Код:

[02:58:42] MySQL Error (0): Could not execute query. 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 ''17' at line 1.
[02:58:42] MySQL Error (0): Could not execute query. 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 '0' WHERE `SQLid` = '0'' at line 1.
[02:58:43] MySQL Error (0): Could not execute query. 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 '0' WHERE `SQLid` = '0'' at line 1.
[02:58:47] MySQL Error (0): Could not execute query. 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 '0' WHERE `SQLid` = '0'' at line 1.

[Carlton]

There's no SQLid in the query you posted. I can't fix a query that hasn't been posted.

[Antonio [G-RP]]

Must be this.. but because of these errors, I cannot register / create a character.

Код:

format(Query, sizeof(Query), "SELECT `SQLid` FROM `accounts` WHERE `username` = '%s'", EscapedName);

[Antonio [G-RP]]

Any idea's?

[Carlton]

You're still posting the wrong query.