mod;gf
opis problema:nemogu nikako da prebacim sa pvara na enumatore ovaj sistem kuca stvarno je nemoguce ! SVe uradim ali nakon restarta nece ucita vlasnika kuce! Pa dali ima neko ko bi mi pomogao oko toga ili mi rekao koji sistem kuca je koristio ivex u XDRIVE modu !
cod
stock SQLLoadStanSystem(DB:db)
{
new reload[256],string[256];
new red = 0;
new DBResult:rezultat = db_query(db, "SELECT * FROM `stan`");
red = db_num_rows(rezultat);
printf("Broj Stanova u bazi : %d",red);
if(red != 0)
{
for(new i = 0; i < red; i++)
{
if(red >= 0 && red <= sizeof(StanStats))
{
db_get_field_assoc(rezultat, "string", string, sizeof(string));
strmid(reload,string,0,256,256);
new data2[2][128];
sscanf(reload,
"p<,>d\
ffffff\
s[24]s[64]\
ddddddddddd",
StanStats[i][StanSlot],
StanStats[i][StanUlaz][0],StanStats[i][StanUlaz][1],StanStats[i][StanUlaz][2],
StanStats[i][StanIzlaz][0],StanStats[i][StanIzlaz][1],StanStats[i][StanIzlaz][2],
data2[0],data2[1],
StanStats[i][StanCjena],StanStats[i][StanLock],StanStats[i][StanKupljen],
StanStats[i][StanInt],StanStats[i][StanVWorld],StanStats[i][StanRent],
StanStats[i][StanLevel],StanStats[i][StanHealthUp],StanStats[i][StanArmorUp],
StanStats[i][StanOrmarUp],StanStats[i][StanOrmar]);
strmid(StanStats[i][StanVlasnik], data2[0], 0, strlen(data2[0]), 128);
strmid(StanStats[i][StanOpis], data2[1], 0, strlen(data2[1]), 128);
if(StanStats[i][StanSlot] == 1){BrojStanova++;}
db_next_row(rezultat);
}
}
}else{print("SQL STAN: Nema stanova u bazi!");}
db_free_result(rezultat);
return 1;
}
stock SQLUpdateStanSystem(DB:db,id)
{
new string[256],Spliter[256];
format(string, sizeof(string), "SELECT `string` FROM `stan` WHERE ( `ID` = '%d')", id);
new DBResult:rezultat = db_query(db, string);
if(db_num_rows(rezultat))
{
format(Spliter,sizeof(Spliter),
"%d,\
%f,%f,%f,%f,%f,%f,\
%s,%s,\
%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
StanStats[id][StanSlot],
StanStats[id][StanUlaz][0],StanStats[id][StanUlaz][1],StanStats[id][StanUlaz][2],
StanStats[id][StanIzlaz][0],StanStats[id][StanIzlaz][1],StanStats[id][StanIzlaz][2],
StanStats[id][StanVlasnik],StanStats[id][StanOpis],
StanStats[id][StanCjena],StanStats[id][StanLock],StanStats[id][StanKupljen],
StanStats[id][StanInt],StanStats[id][StanVWorld],StanStats[id][StanRent],
StanStats[id][StanLevel],StanStats[id][StanHealthUp],StanStats[id][StanArmorUp],
StanStats[id][StanOrmarUp],StanStats[id][StanOrmar]);
format(string, sizeof(string), "UPDATE `stan` SET `string` = '%s' WHERE ( `ID` = '%d')",Spliter,id);
db_free_result(db_query(db, string));
printf("UPDATE: %d", id);
if(StanStats[id][StanSlot] == 0)
{
format(string, sizeof(string), "DELETE FROM `stan` WHERE (`ID` = '%d')", id);
db_free_result(db_query(db,string));
printf("DELETE: %d", id);
}
}
else
{
if(StanStats[id][StanSlot] == 1)
{
format(Spliter,sizeof(Spliter),
"%d,\
%f,%f,%f,%f,%f,%f,\
%s,%s,\
%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
StanStats[id][StanSlot],
StanStats[id][StanUlaz][0],StanStats[id][StanUlaz][1],StanStats[id][StanUlaz][2],
StanStats[id][StanIzlaz][0],StanStats[id][StanIzlaz][1],StanStats[id][StanIzlaz][2],
StanStats[id][StanVlasnik],StanStats[id][StanOpis],
StanStats[id][StanCjena],StanStats[id][StanLock],StanStats[id][StanKupljen],
StanStats[id][StanInt],StanStats[id][StanVWorld],StanStats[id][StanRent],
StanStats[id][StanLevel],StanStats[id][StanHealthUp],StanStats[id][StanArmorUp],
StanStats[id][StanOrmarUp],StanStats[id][StanOrmar]);
format(string, sizeof(string), "INSERT INTO `stan` ( `ID`, `string`) VALUES ( '%d','%s')", id,Spliter);
db_free_result(db_query(db, string));
printf("INSERT: %d", id);
}
}
db_free_result(rezultat);
return 1;
}
public UpdateAccountSettings(playerid)// 10 sec timer- ponavljanje
{
if(GetPVarInt(playerid, "PaySec") == 6)
{
SetPVarInt(playerid, "PayBodovi", GetPVarInt(playerid,"PayBodovi")+1);
SetPVarInt(playerid, "PaySec", 0);
if(PlayerInfo[playerid][pStan] );
SetPVarInt(playerid,"KucaKljuc",GetKucaKey(playerid));// kuca
}
SetPVarInt(playerid, "PaySec", GetPVarInt(playerid,"PaySec")+1);
UpdatePlayerAccount(playerid);
}