MySQL cuvanje u bazi

[rizla]

Problem(error/warning): Iz komande /kreirajkucu pozivam funkciju SacuvajKucu(idkuce); funkciju pozovem, ali mysql ne odradi cuvanje u pazi podataka, probao sam sa povecaavanjem stringa i nista, nemam bas neka iskustva sa mysql
Deo skripte:

forward SacuvajKucu(idkuce);
public SacuvajKucu(idkuce)
{
    new query[1200];
    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[idkuce][kID], KucaInfo[idkuce][kProveraVlasnika], KucaInfo[idkuce][kVlasnik], KucaInfo[idkuce][kCena], KucaInfo[idkuce][kLevel], KucaInfo[idkuce][kUlazX], KucaInfo[idkuce][kUlazY], KucaInfo[idkuce][kUlazZ], KucaInfo[idkuce][kIzlazX],\
	KucaInfo[idkuce][kIzlazY], KucaInfo[idkuce][kIzlazZ], KucaInfo[idkuce][kNovac], KucaInfo[idkuce][kInt], KucaInfo[idkuce][kZatvoreno], KucaInfo[idkuce][kVW], KucaInfo[idkuce][kOruzije], KucaInfo[idkuce][kMunicija], KucaInfo[idkuce][kRent],\
	KucaInfo[idkuce][kCenaRenta], KucaInfo[idkuce][kZvono], KucaInfo[idkuce][kHeal], KucaInfo[idkuce][kSkin], KucaInfo[idkuce][kPromenaIntKuce]);
    mysql_tquery(database, query);
	return 1;
}

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

Vaš odgovor

[rizla]

neko nesto?

[pokerface]

Ne može to tako, daj komandu da vidim šta si uradio.

[rizla]

forward SacuvajKucu(idkuce);
public SacuvajKucu(idkuce)
{
    new query[1200];
    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[idkuce][kID], KucaInfo[idkuce][kProveraVlasnika], KucaInfo[idkuce][kVlasnik], KucaInfo[idkuce][kCena], KucaInfo[idkuce][kLevel], KucaInfo[idkuce][kUlazX], KucaInfo[idkuce][kUlazY], KucaInfo[idkuce][kUlazZ], KucaInfo[idkuce][kIzlazX],\
	KucaInfo[idkuce][kIzlazY], KucaInfo[idkuce][kIzlazZ], KucaInfo[idkuce][kNovac], KucaInfo[idkuce][kInt], KucaInfo[idkuce][kZatvoreno], KucaInfo[idkuce][kVW], KucaInfo[idkuce][kOruzije], KucaInfo[idkuce][kMunicija], KucaInfo[idkuce][kRent],\
	KucaInfo[idkuce][kCenaRenta], KucaInfo[idkuce][kZvono], KucaInfo[idkuce][kHeal], KucaInfo[idkuce][kSkin], KucaInfo[idkuce][kPromenaIntKuce]);
    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 [ID] [Vrsta] [Level] [Cena]");
	if(idkuce <= TotalKuce) return SendClientMessage(playerid, COLOR_RED, "ID kuce vec postoji.");
	if(vrsta == 0) // MALA KUCA
	{
        KucaInfo[idkuce][kIzlazX] = 223.043991;
    	KucaInfo[idkuce][kIzlazY] = 1289.259888;
    	KucaInfo[idkuce][kIzlazZ] = 1082.199951;
    	KucaInfo[idkuce][kInt] = 1;
    	KucaInfo[idkuce][kPromenaIntKuce] = 1;
	}
	else if(vrsta == 1) // SREDNJA KUCA
	{
        KucaInfo[idkuce][kIzlazX] = 225.756989;
    	KucaInfo[idkuce][kIzlazY] = 1240.000000;
    	KucaInfo[idkuce][kIzlazZ] = 1082.149902;
    	KucaInfo[idkuce][kInt] = 2;
    	KucaInfo[idkuce][kPromenaIntKuce] = 2;
	}
	else if(vrsta == 2) // VELIKA KUCA
	{
        KucaInfo[idkuce][kIzlazX] = 235.508994;
    	KucaInfo[idkuce][kIzlazY] = 1189.169897;
    	KucaInfo[idkuce][kIzlazZ] = 1080.339966;
    	KucaInfo[idkuce][kInt] = 3;
    	KucaInfo[idkuce][kPromenaIntKuce] = 3;
	}
	else if(vrsta >= 3) return SendClientMessage(playerid, COLOR_RED, "Vrsta kuce od 0 do 2.");
	KucaInfo[idkuce][kID] = idkuce; KucaInfo[idkuce][kCena] = cena; KucaInfo[idkuce][kLevel] = level; KucaInfo[idkuce][kUlazX] = X; KucaInfo[idkuce][kSkin] = -1;
    KucaInfo[idkuce][kUlazY] = Y; KucaInfo[idkuce][kUlazZ] = Z; KucaInfo[idkuce][kProveraVlasnika] = 0; KucaInfo[idkuce][kHeal] = 0;
    KucaInfo[idkuce][kNovac] = 0; KucaInfo[idkuce][kZatvoreno] = 1; KucaInfo[idkuce][kVW] = idkuce; KucaInfo[idkuce][kZvono] = 0;
    KucaInfo[idkuce][kOruzije] = -1; KucaInfo[idkuce][kMunicija] = 0; KucaInfo[idkuce][kRent] = 0;
    strmid(KucaInfo[idkuce][kVlasnik],"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[idkuce][kCena],KucaInfo[idkuce][kLevel],idkuce);
	KucaLabel[idkuce] = 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[idkuce] = CreateDynamicPickup(1273, 1, KucaInfo[idkuce][kUlazX], KucaInfo[idkuce][kUlazY], KucaInfo[idkuce][kUlazZ]);
	SendClientMessage(playerid, COLOR_GREEN, "Kuca je uspesno kreirana."); SacuvajKucu(idkuce);
    TotalKuce++;
	return 1;
}

[__vedran.xyz77]

https://pastebin.com/awXdegRD

[rizla]

Isto se desava, sad sam proverao log i dobijam ovu gresku

[22:59:16] [ERROR] 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)

[__vedran.xyz77]

Brt ide ti `ProveraVlasnika` `Vlasnik` treba zarez izmedju toga ja sam ti poslao sa zarezom

[rizla]

Brt ide ti `ProveraVlasnika` `Vlasnik` treba zarez izmedju toga ja sam ti poslao sa zarezom

Izvini, nemam obicaj da kopiram gotove kodove, mogao si tako lepo reci  Hvala