MySQL cuvanje u bazi

Započeo rizla
27. Sep. 2020.
2,441
pregleda
8
postova
Macas
4
Enforcer
27. Sep. 2020.
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;
    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;
}

Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):
Vaš odgovor
Macas
4
Enforcer
28. Sep. 2020.
neko nesto?
Chuffy
4
Made Man
28. Sep. 2020.
Ne može to tako, daj komandu da vidim šta si uradio.
Macas
4
Enforcer
28. Sep. 2020.
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;
}
Exnas.pwn
5
Godfather
Macas
4
Enforcer
28. Sep. 2020.
Isto se desava, sad sam proverao log i dobijam ovu gresku
[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)
Exnas.pwn
5
Godfather
28. Sep. 2020.
Brt ide ti `ProveraVlasnika` `Vlasnik` treba zarez izmedju toga ja sam ti poslao sa zarezom
Macas
4
Enforcer
28. Sep. 2020.
__vedran.xyz77 wrote on September 28, 2020, 9:05 pm:
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

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava

© 2026 SmartShark. All rights reserved.

Powered by Momentum|v2026.3.001 Alpha