MySQL cuvanje u bazi

forward SacuvajKucu(idkuce);
public SacuvajKucu(idkuce)
{
    new query;
    print("Upisano u bazu");
    mysql_format(database, query, sizeof(query), "INSERT INTO `kuce`\
	(`ID`, `ProveraVlasnika` `Vlasnik`, `Cena`, `Level`, `UlazX`,`UlazY`, `UlazZ`, `IzlazX`, `IzlazY`, `IzlazZ`, `Novac`, `Int`, `Zatvoreno`, `VW`, `Oruzije`, `Municija`, `Rent`, `CenaRenta`, `Zvono`, `Heal`, `Skin`, `PromenaIntKuce`)\
	VALUES (%d, %d, `%s`, %d, %d, %f, %f, %f, %f, %f, %f, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d)",\
	KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo,\
	KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo,\
	KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo);
    mysql_tquery(database, query);
	return 1;
}

Vaš odgovor

forward SacuvajKucu(idkuce);
public SacuvajKucu(idkuce)
{
    new query;
    print("Upisano u bazu");
    mysql_format(database, query, sizeof(query), "INSERT INTO `kuce`\
	(`ID`, `ProveraVlasnika` `Vlasnik`, `Cena`, `Level`, `UlazX`,`UlazY`, `UlazZ`, `IzlazX`, `IzlazY`, `IzlazZ`, `Novac`, `Int`, `Zatvoreno`, `VW`, `Oruzije`, `Municija`, `Rent`, `CenaRenta`, `Zvono`, `Heal`, `Skin`, `PromenaIntKuce`)\
	VALUES (%d, %d, `%s`, %d, %d, %f, %f, %f, %f, %f, %f, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d)",\
	KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo,\
	KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo,\
	KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo);
    mysql_tquery(database, query);
	return 1;
}

//======================================Kuca komande============================

CMD:kreirajkucu(playerid, params[])
{
	if(!IsPlayerAdmin(playerid)) return SendClientMessage(playerid, COLOR_RED, "Niste ovlasceni da koristite ovu komandu. Morate biti RCON admin.");
    if(TotalKuce >= MAX_KUCA) return SendClientMessage(playerid, COLOR_RED, "Iskoristili ste maksimalan broj kuca na serveru.");
	new idkuce, cena, vrsta, level, Float:X, Float:Y, Float:Z; GetPlayerPos(playerid, X, Y, Z);
	if(sscanf(params, "iiii",idkuce,vrsta,level,cena)) return SendClientMessage(playerid, COLOR_RED, "/kreirajkucu ");
	if(idkuce <= TotalKuce) return SendClientMessage(playerid, COLOR_RED, "ID kuce vec postoji.");
	if(vrsta == 0) // MALA KUCA
	{
        KucaInfo = 223.043991;
    	KucaInfo = 1289.259888;
    	KucaInfo = 1082.199951;
    	KucaInfo = 1;
    	KucaInfo = 1;
	}
	else if(vrsta == 1) // SREDNJA KUCA
	{
        KucaInfo = 225.756989;
    	KucaInfo = 1240.000000;
    	KucaInfo = 1082.149902;
    	KucaInfo = 2;
    	KucaInfo = 2;
	}
	else if(vrsta == 2) // VELIKA KUCA
	{
        KucaInfo = 235.508994;
    	KucaInfo = 1189.169897;
    	KucaInfo = 1080.339966;
    	KucaInfo = 3;
    	KucaInfo = 3;
	}
	else if(vrsta >= 3) return SendClientMessage(playerid, COLOR_RED, "Vrsta kuce od 0 do 2.");
	KucaInfo = idkuce; KucaInfo = cena; KucaInfo = level; KucaInfo = X; KucaInfo = -1;
    KucaInfo = Y; KucaInfo = Z; KucaInfo = 0; KucaInfo = 0;
    KucaInfo = 0; KucaInfo = 1; KucaInfo = idkuce; KucaInfo = 0;
    KucaInfo = -1; KucaInfo = 0; KucaInfo = 0;
    strmid(KucaInfo,"Niko",0,strlen("Niko"),255);
	new String:string = str_format("{e6ac00}[KUCA NA PRODAJU]\n{e6ac00}Cena: {ffffff}%d$\n{e6ac00}Level: {ffffff}%d\n{e6ac00}Broj kuce: {ffffff}%d\n{e6ac00}Za kupovinu /kupikucu",KucaInfo,KucaInfo,idkuce);
	KucaLabel = CreateDynamic3DTextLabel(string, 0x33CCFFAA, X, Y, Z, 25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, STREAMER_3D_TEXT_LABEL_SD, -1, 0);
	KucaPickup = CreateDynamicPickup(1273, 1, KucaInfo, KucaInfo, KucaInfo);
	SendClientMessage(playerid, COLOR_GREEN, "Kuca je uspesno kreirana."); SacuvajKucu(idkuce);
    TotalKuce++;
	return 1;
}

[22:59:16] error #1064 while executing query "INSERT INTO `kuce`(`ID`, `ProveraVlasnika` `Vlasnik`, `Cena`, `Level`, `UlazX`,`UlazY`, `UlazZ`, `IzlazX`, `IzlazY`, `IzlazZ`, `Novac`, `Int`, `Zatvoreno`, `VW`, `Oruzije`, `Municija`, `Rent`, `CenaRenta`, `Zvono`, `Heal`, `Skin`, `PromenaIntKuce`)VALUES (`1`, `0`, `Niko`, `1`, `1`, `132.000000`, `-67.291428`, `1.578125`, `225.756989`, `1240.000000`, `1082.149902`, `0`, `2`, `1`, `1`, `-1`, `0`, `0`, `0`, `0`, `0`, `-1`, `2`)": 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 '`Vlasnik`, `Cena`, `Level`, `UlazX`,`UlazY`, `UlazZ`, `IzlazX`, `IzlazY`, `Iz...' at line 1 (C:\Users\dsubo\Desktop\SAMP Server\gamemodes\gmod.pwn:322 -> C:\Users\dsubo\Desktop\SAMP Server\gamemodes\gmod.pwn:368)