Error in your SQL syntax;

[MatheusRDS]

Could someone help me with this error?

Error line

if( getmapflag(.@Map$,mf_gvg) || getmapflag(.@Map$,mf_gvg_castle) )
		query_sql "INSERT INTO `pvp_flux_csd` (`char_id`, `type`, `kill`) VALUES (" + .@CID + ", 1, 1) ON DUPLICATE `KEY` kill=`kill`+1";

Error

: DB error - 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 'kill=`kill`+1' at line 1

	[Debug]: at script.cpp:16590 - INSERT INTO `pvp_flux_csd` (`char_id`, `type`, `kill`) VALUES (150015, 0, 1) ON DUPLICATE KEY kill=`kill`+1

[MatheusRDS]

Thank you for your attention, I did it that way and it worked.

query_sql "INSERT INTO `mvp_flux_csd` (`char_id`, `kill`) VALUES (" + .@CID + ", 1) ON DUPLICATE KEY UPDATE `kill`=`kill`+1";

 

[Start_]

query_sql ("SELECT `xxx` FROM `tableName` WHERE `variableName`=" + xxxxxx + "", .@kill);

.@kill++;

then
  
query_sql "INSERT INTO `pvp_flux_csd` (`char_id`, `type`, `kill`) VALUES (" + .@CID + ", 1, 1) ON DUPLICATE `KEY` kill="+.@kill+";

Not sure but you can try.