//======================:: SQL STAN BAZA !! KO ME NAVRATI JB ME DAN::=================================
stock SQLLoadStanSystem(DB:db)
{
new reload,string;
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;
sscanf(reload,
"p<,>d\
ffffff\
ss\
ddddddddddd",
StanStats,
StanStats,StanStats,StanStats,
StanStats,StanStats,StanStats,
data2,data2,
StanStats,StanStats,StanStats,
StanStats,StanStats,StanStats,
StanStats,StanStats,StanStats,
StanStats,StanStats);
strmid(StanStats, data2, 0, strlen(data2), 128);
strmid(StanStats, data2, 0, strlen(data2), 128);
if(StanStats == 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,Spliter;
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,
StanStats,StanStats,StanStats,
StanStats,StanStats,StanStats,
StanStats,StanStats,
StanStats,StanStats,StanStats,
StanStats,StanStats,StanStats,
StanStats,StanStats,StanStats,
StanStats,StanStats);
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 == 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 == 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,
StanStats,StanStats,StanStats,
StanStats,StanStats,StanStats,
StanStats,StanStats,
StanStats,StanStats,StanStats,
StanStats,StanStats,StanStats,
StanStats,StanStats,StanStats,
StanStats,StanStats);
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;
}
stock UpdatePlayerAccount(playerid)
{
if(IsPlayerConnected(playerid))
{
new Spliter;
SetPVarInt(playerid,"Novac",GetPlayerMoney(playerid));
format(Spliter,sizeof(Spliter),
"%d",
GetPVarInt(playerid, "SpawnChange"));
SQLUpdatePlayerAccount(GlavnaBaza, playerid, Spliter);
//printf(": Spremanje/Update accounta %s zavrseno!",name);
}
return 1;
}
//===============================fUNCIJE STANOVE BY NEDDA ============================================
stock MakeStanFnc(playerid,interior,cjena,Float:X,Float:Y,Float:Z)
{
for(new i = 0; i < sizeof(StanStats); i++ )
{
if(StanStats == 0)
{
new string;
BrojStanova++;
StanStats = 1;
StanStats = X;
StanStats = Y;
StanStats = Z;
StanStats = aUlazi;
StanStats = aUlazi;
StanStats = aUlazi;
StanStats = cjena;
strmid(StanStats, "Nitko", 0, strlen("Nitko"), 999);
strmid(StanStats, OpisKuca_Stanova, 0, strlen(OpisKuca_Stanova), 255);
StanStats = 0;
StanStats = 0;
StanStats = 500+BrojStanova;
StanStats = 1;
StanStats = aIntovi;
format(string, sizeof(string), ":Opis: %s ,ID stana: %d , Cjena stana:%d $ , Level: %d", OpisKuca_Stanova, BrojStanova, cjena, StanStats);
SCM(playerid, COLOR_LIGHTRED, string);
SQLUpdateStanSystem(GlavnaBaza,i);
break;
}
}
return 0;
}
stock RmStanFnc(playerid,ID)
{
if(StanStats == 1)
{
new string;
BrojStanova--;
StanStats = 0;
StanStats = 0;
StanStats = 0;
StanStats = 0;
StanStats = 0;
StanStats = 0;
StanStats = 0;
StanStats = 0;
strmid(StanStats, "0", 0, strlen("0"), 128);
strmid(StanStats, "0", 0, strlen("0"), 128);
StanStats = 0;
StanStats = 0;
StanStats = 0;
StanStats = 0;
StanStats = 0;
format(string, sizeof(string), "RM STAN %d <<", ID);
SCM(playerid, COLOR_GREEN, string);
SQLUpdateStanSystem(GlavnaBaza,ID);
}
else{ SCM(playerid, COLOR_LIGHTRED, "Nevazeci ID");}
return 0;
}
stock GetStanKey(playerid)
{
new ime;
GetPlayerName(playerid,ime,sizeof(ime));
for(new i = 0; i < sizeof(StanStats); i++)
{
if(StanStats == 1)
{
if (!strcmp(StanStats, ime)) return i;
}
}
return -1;
}
Eh samo mi malo pojasni sta da prilagodim !