[pomoc]sistem kuca

[Aldin Begovic]

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);
}