Mysql checkuser

Problem(error/warning): Nece da sacuva mysql fajl i da spawna.
Dio skripte:

            new query[ 2000 ];
	    format( query, sizeof( query ), "INSERT INFO `users` (`name`, `novac`, `lozinka`, `level`, `admin_level`, `gamemaster_level`, `drzava`, `godine`, `pol`, `skin`," );
	    format( query, sizeof( query ), "%s`posx`, `posy`, `posz`, `interior`, `vw`, `novacbanka`, `exp`, `ubistva`, `smrti`, `glad`, `zlato`)", query );
	    format( query, sizeof( query ), "%s VALUES ('%s', '%d', '%d', 1, 0, 0, 0, 0, '%d', 0, 0, 0, 0, 0, '%d', 0, 0, 0, '%d'",
	    query, GetName( playerid ), 5000, GetPVarInt( playerid, "reglozinka" ), SetRegisterSkin( GetPVarInt( playerid, "pol" ) ), GetPVarInt( playerid, "pol" ), GetPVarInt( playerid, "regdrzava" ), strval(inputtext), 100 , GetPVarInt( playerid, "posx" ), GetPVarInt( playerid, "posy" ), GetPVarInt( playerid, "posz" ), GetPVarInt( playerid, "posa" ), GetPVarInt( playerid, "interior" ), GetPVarInt( playerid, "vw" ) );
	    mysql_tquery( sqlBase, query, "ContinueRegister", "i", playerid );

Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):

[12:17:38] [plugins/mysql] error #1064 while executing query "INSERT INFO `users` (`name`, `novac`, `lozinka`, `level`, `admin_level`, `gamemaster_level`, `drzava`, `godine`, `pol`, `skin`,`posx`, `posy`, `posz`, `interior`, `vw`, `novacbanka`, `exp`, `ubistva`, `smrti`, `glad`, `zlato`) VALUES ('Bojan_Colic', '5000', '294126354', 1, 0, 0, 0, 0, '21', 0, 0, 0, 0, 0, '1', 0, 0, 0, '0'": 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 '`users` (`name`, `novac`, `lozinka`, `level`, `admin_level`, `gamemaster_level`,' at line 1

Slika/video ingame problema(obavezno ako je ingame problem): //

aaa ne znas, propo si 😄 <3

Fali ti zagrada na kraju

format( query, sizeof( query ), "%s VALUES (`%s`, `%d`, `%d`, 1, 0, 0, 0, 0, `%d`, 0, 0, 0, 0, 0, `%d`, 0, 0, 0, `%d`",

format( query, sizeof( query ), "%s VALUES (`%s`, `%d`, `%d`, 1, 0, 0, 0, 0, `%d`, 0, 0, 0, 0, 0, `%d`, 0, 0, 0, `%d`)",

.ксундер wrote on March 27, 2018, 12:36 pm:

Fali ti zagrada na kraju

format( query, sizeof( query ), "%s VALUES (`%s`, `%d`, `%d`, 1, 0, 0, 0, 0, `%d`, 0, 0, 0, 0, 0, `%d`, 0, 0, 0, `%d`",

format( query, sizeof( query ), "%s VALUES (`%s`, `%d`, `%d`, 1, 0, 0, 0, 0, `%d`, 0, 0, 0, 0, 0, `%d`, 0, 0, 0, `%d`)",

Sredio sam, lock 😄

Hvala ipak.

pravila