20.08.2014, 21:13
I have a problem with my database , when I do this command
and restart the server it dose not updates in my database, can someone help me, find the problem or something?
pawn Код:
CMD:kupikucu(playerid, params[])
{
if(PI[playerid][Kuca] != -1) return SCM(playerid, GRAD2, " (greska) Vi vec posedujete kucu! Upisite /prodajkucu da je prodate.");
for(new i; i < sizeof(Kuce); i++)
{
if(IsPlayerInRangeOfPoint(playerid, 3.0, Kuce[i][UlazX], Kuce[i][UlazY], Kuce[i][UlazZ]))
{
if(!strcmp(Kuce[i][Vlasnik], "Niko", true) && Kuce[i][ImaVlasnika] == 0)
{
if(PI[playerid][Nivo] < Kuce[i][kNivo]) return SCMF(playerid, GRAD2, "(greska) Potreban Vam je nivo %d za ovu kucu!", Kuce[i][kNivo]);
if(PI[playerid][Novac] < Kuce[i][Cena]) return SCM(playerid, GRAD2, "(greska) Nemate dovoljno novca za ovu kucu!");
new hIme[MAX_PLAYER_NAME];
RPIme(playerid, hIme);
strmid(Kuce[i][Vlasnik], hIme, 0, strlen(hIme), 255);
Kuce[i][ImaVlasnika] = 1;
PI[playerid][Kuca] = i;
SetPlayerInterior(playerid, Kuce[i][Enterijer]);
SetPlayerVirtualWorld(playerid, Kuce[i][VW]);
SetPlayerPos_H(playerid, Kuce[i][IzlazX], Kuce[i][IzlazY], Kuce[i][IzlazZ]);
SetPlayerFacingAngle(playerid, Kuce[i][IzlazA]);
SCM(playerid, BELA, "Cestitamo, kupili ste kucu! Upisite /kuca za komande kuce.");
NovacMinus(playerid, Kuce[i][Cena]);
MayorInfo[1][Budzet] += Kuce[i][Cena];
EntID[playerid] = i;
PI[playerid][Spawn] = SPAWN_KUCA;
PI[playerid][Renta] = -1;
PI[playerid][RentaHotel] = -1;
UpdateLabels();
//SacuvajKucu(i);
new kkk[MAX_PLAYER_NAME], upit[128];
ImeIgraca(playerid, kkk);
format(upit, 128, "UPDATE `igraci` SET `Kuca` = '%d', `Spawn` = '0', `Renta` = '-1', `RentaHotel` = '-1' WHERE `Ime` = '%s'", PI[playerid][Kuca], kkk);
mysql_query(upit, THREAD_OSTALO);
format(CmdString, 100, "| KUPOVINA - KUCA | Igrac: %s | ID: %d", kkk, i);
UpisiLog(FAJL_PRIMOVINELOG, CmdString);
format(upit, 128, "UPDATE `kuce` SET `ImaVlasnika` = '1', `Vlasnik` = '%s' WHERE `ID` = '%d'", hIme, i);
mysql_query(upit, THREAD_OSTALO);
break;
}
else
{
SCM(playerid, GRAD2, " (greska) Ova kuca nije slobodna!");
}
}
}
return 1;
}