[ScottCFR]

I've been working on a house system, and I've made a command to add houses while in game. But, I seem to have messed something up. Here's my command:

Код:

COMMAND:createhouse(playerid, params[])
{
	new query[65],Float:x,Float:y,Float:z,name[64],cost;
    if(!sscanf(params, "si", name, cost))
    {
        GetPlayerPos(playerid, x, y, z);
		format(query,sizeof(query),"INSERT INTO [REMOVED] (Name, Cost, PosX, PosY, PosZ) VALUES ('%s', '%d', '%s', '%s', '%s')",name,cost,x,y,z);
		mysql_query(query);
		SendCommandToAdmins(playerid, 4, "/addhouse");
    }
	return 1;
}

Error:

Код:

[16:05:01] CMySQLHandler::Query(INSERT INTO [REMOVED] (Name, Cost, PosX, PosY, PosZ) VALUES ('Visag) - An error has occured. (Error ID: 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 ''Visag' at line 1)
[16:05:09] >> mysql_ping( Connection handle: 1 )

[Blowfish]

Make sure there is no single quote (') in your strings.

[[L3th4l]]

Increase the size of "query" and since when are floats strings?

[Blowfish]

Nvm, was too slow.
L3tha4 brought it to the point.

[ScottCFR]

Quote:

Originally Posted by [L3th4l] Increase the size of "query" and since when are floats strings?

Well, when I noticed something weird when I would format them into floats. So, if I set them to strings, then convert the string to a float while loading it works fine.