[armyoftwo]

Код:

[15:30:44] Error in mysql_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,0,0,0)' at line 1

How can i fix this?

[Carlton]

Post your query.

[armyoftwo]

Quote:

Originally Posted by Carlton Post your query.

Код:

	format(query, sizeof(query), "SELECT playerid, adminlevel, playername, password, x, y, z, o, interior, model, money, health, armor, factionid, factionrank, jailed, jailedtime, jobid, paycheck, premium, beenpaid, badge, bomb, wtchannel, paydaytime, jobrank, worldid, dl, pl, cdl, cl, pp, wl FROM players WHERE playername='%s'",playername);

This one?

[armyoftwo]

anyone?

[FabianoC]

Doesn't seem like it, but line 1 in your thingy would be easy to find...

wl FROM players WHERE playername='%s'",playername); <<< At that part maybe?

[mprofitt]

More than likely, in your format statement, the number or type of variables do not match.

Quote:

Originally Posted by armyoftwo Код: [15:30:44] Error in mysql_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,0,0,0)' at line 1 How can i fix this?

[armyoftwo]

most likely variable types doesn't match...

[mprofitt]

Why do you have to repeat exactly what I just said?

Quote:

Originally Posted by armyoftwo most likely variable types doesn't match...

[FabianoC]

Yes, that means you forgot some words in the line, maybe added too much, or misplaced the: ,
It's all possible, so check the template.

[armyoftwo]

Quote:

Originally Posted by mprofitt Why do you have to repeat exactly what I just said? Quote: Originally Posted by armyoftwo most likely variable types doesn't match...

I'm not repeating you, i'm just saying what's the problem exactly. o_0