MySQL Problem - Printable Version

MySQL Problem - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Problem (/showthread.php?tid=641378)

MySQL Problem - XStormiest - 15.09.2017

Can you fiind what's wrong with this?

Код:

	new save_query[2500], string[512];
	strcat(save_query, "INSERT INTO `server_interiors` (`sInteriorName`, `sEnterPosX`, `sEnterPosY`, `sEnterPosZ`, `sExitPosX`, `sExitPosY`, `sExitPosZ`, `sEnterInterior`, `sExitInterior`, `sEnterVirtualWorld`, `sExitVirtualWorld`, `sInteriorExists`) ");
	strcat(save_query, " VALUES ( ");
	format(string, sizeof(string), "'%s',", S_Interiors[interiorid][sInteriorName]);
	strcat(save_query, string);
	format(string, sizeof(string), "'%f',", S_Interiors[interiorid][sEnterPosX]);
	strcat(save_query, string);
	format(string, sizeof(string), "'%f',", S_Interiors[interiorid][sEnterPosY]);
	strcat(save_query, string);
	format(string, sizeof(string), "'%f',", S_Interiors[interiorid][sEnterPosZ]);
	strcat(save_query, string);
	format(string, sizeof(string), "'%f',", S_Interiors[interiorid][sExitPosX]);
	strcat(save_query, string);
	format(string, sizeof(string), "'%f',", S_Interiors[interiorid][sExitPosY]);
	strcat(save_query, string);
	format(string, sizeof(string), "'%f',", S_Interiors[interiorid][sExitPosZ]);
	strcat(save_query, string);
	format(string, sizeof(string), "'%d',", S_Interiors[interiorid][sEnterInterior]);
	strcat(save_query, string);
	format(string, sizeof(string), "'%d',", S_Interiors[interiorid][sExitInterior]);
	strcat(save_query, string);
	format(string, sizeof(string), "`%d',", S_Interiors[interiorid][sEnterVirtualWorld]);
	strcat(save_query, string);
	format(string, sizeof(string), "'%d',", S_Interiors[interiorid][sExitVirtualWorld]);
	strcat(save_query, string);
	format(string, sizeof(string), "'%d' )", S_Interiors[interiorid][sInteriorExists]);
	strcat(save_query, string);
	mysql_format(MySQL_Handle, save_query, sizeof(save_query), save_query);
	mysql_query(MySQL_Handle, save_query);

I always seem to get this error:

Код:

[13:17:56] [ERROR] CMySQLQuery::Execute[()] - (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

Re: MySQL Problem - Kane - 15.09.2017

Yes.

Код:

`%d', 

'%d',

"'%f',"

Not exactly sure what you were doing.

' ' doesn't go around integers and floats.

Re: MySQL Problem - XStormiest - 15.09.2017

Thank you very much.

it was that `d' thing

)