[maikons]

Ty guys

I changed

This function is called

Код:

SetTimer("HoraSave",59000,1); // 59 segs

Код:

forward HoraSave();
public HoraSave() {
	new Hour, Minute, Second;
	gettime(Hour, Minute, Second);
	if (Minute == 30) {
		SalvarCasas();
		SalvarFactions();
		SalvarServer();
		SendClientMessageToAll(COLOR_LIGHTRED, "SERVER SAVE!");
    }
    return 1;
}

And to check if have this factions i put rows (i saw it on web i think its right), now just will save if have a faction on this ID

Код:

stock SalvarFactions()
{
	for(new factionid; factionid < MAX_FACTIONS; factionid++) {
		new rows, fields;
		cache_get_data(rows, fields);
		if(rows) {
			new query[1030];
			format(query, sizeof(query), "UPDATE `factions` SET `facname` = '%s', `HQposX` = '%f', `HQposY` = '%f', `HQposZ` = '%f', `pistolSPAWNfac` = '%d', `shotgunSPAWNfac` = '%d', `submachineSPAWNfac` = '%d', `assaultSPAWNfac` = '%d', `sniperSPAWNfac` = '%d', `meleeSPAWNfac` = '%d', `cofredinheiro` = '%d', `cofresalario` = '%d', `cofrematerial` = '%d', `cofremaconha` = '%d', `hq` = '%d' WHERE `ID` = '%i' ",
				FactionInfo[factionid][facname],
				FactionInfo[factionid][HQposX],
				FactionInfo[factionid][HQposY],
				FactionInfo[factionid][HQposZ],
				FactionInfo[factionid][pistolSPAWNfac],
				FactionInfo[factionid][shotgunSPAWNfac],
				FactionInfo[factionid][submachineSPAWNfac],
				FactionInfo[factionid][assaultSPAWNfac],
				FactionInfo[factionid][sniperSPAWNfac],
				FactionInfo[factionid][meleeSPAWNfac],
				FactionInfo[factionid][cofredinheiro],
				FactionInfo[factionid][cofresalario],
				FactionInfo[factionid][cofrematerial],
				FactionInfo[factionid][cofremaconha],
				FactionInfo[factionid][hq],
				factionid);
			mysql_pquery(ConnectMYSQL, query);

			format(query, sizeof(query), "UPDATE `factions` SET `membro1` = '%s', `membro2` = '%s', `membro3` = '%s', `membro4` = '%s', `membro5` = '%s', `membro6` = '%s', `membro7` = '%s', `membro8` = '%s', `membro9` = '%s', `membro10` = '%s', `membro11` = '%s', `membro12` = '%s', `membro13` = '%s', `membro14` = '%s', `membro15` = '%s' WHERE `ID` = '%i' ",
				FactionInfo[factionid][membro1],
				FactionInfo[factionid][membro2],
				FactionInfo[factionid][membro3],
				FactionInfo[factionid][membro4],
				FactionInfo[factionid][membro5],
				FactionInfo[factionid][membro6],
				FactionInfo[factionid][membro7],
				FactionInfo[factionid][membro8],
				FactionInfo[factionid][membro9],
				FactionInfo[factionid][membro10],
				FactionInfo[factionid][membro11],
				FactionInfo[factionid][membro12],
				FactionInfo[factionid][membro13],
				FactionInfo[factionid][membro14],
				FactionInfo[factionid][membro15],
				factionid);
			mysql_pquery(ConnectMYSQL, query);

			format(query, sizeof(query), "UPDATE `factions` SET `cargo1` = '%d', `cargo2` = '%d', `cargo3` = '%d', `cargo4` = '%d', `cargo5` = '%d', `cargo6` = '%d', `cargo7` = '%d', `cargo8` = '%d', `cargo9` = '%d', `cargo10` = '%d', `cargo11` = '%d', `cargo12` = '%d', `cargo13` = '%d', `cargo14` = '%d', `cargo15` = '%d' WHERE `ID` = '%i' ",
				FactionInfo[factionid][cargo1],
				FactionInfo[factionid][cargo2],
				FactionInfo[factionid][cargo3],
				FactionInfo[factionid][cargo4],
				FactionInfo[factionid][cargo5],
				FactionInfo[factionid][cargo6],
				FactionInfo[factionid][cargo7],
				FactionInfo[factionid][cargo8],
				FactionInfo[factionid][cargo9],
				FactionInfo[factionid][cargo10],
				FactionInfo[factionid][cargo11],
				FactionInfo[factionid][cargo12],
				FactionInfo[factionid][cargo13],
				FactionInfo[factionid][cargo14],
				FactionInfo[factionid][cargo15],
				factionid);
			mysql_pquery(ConnectMYSQL, query);
		}
	}

	return 1;
}

Код:

stock SalvarCasas()
{
	for(new houseid; houseid < MAX_HOUSES; houseid++) {
		new rows, fields;
		cache_get_data(rows, fields);
		if(rows) {	
			new query[1030];
			format(query, sizeof(query), "UPDATE `houses` SET `OutPosX` = '%f', `OutPosY` = '%f', `OutPosZ` = '%f', `InPosX` = '%f', `InPosY` = '%f', `InPosZ` = '%f', `World` = '%d', `Price` = '%d', `Interior` = '%d', `Locked` = '%d', `Dono` = '%s', `FHQ` = '%d', `Money` = '%d', `Maconha` = '%d', `Material` = '%d', `Owner` = '%d', `hlastlogin` = '%d' WHERE `ID` = '%i' ",
				HouseInfo[houseid][OutPosX],
				HouseInfo[houseid][OutPosY],
				HouseInfo[houseid][OutPosZ],
				HouseInfo[houseid][InPosX],
				HouseInfo[houseid][InPosY],
				HouseInfo[houseid][InPosZ],
				HouseInfo[houseid][World],
				HouseInfo[houseid][Price],
				HouseInfo[houseid][Interior],
				HouseInfo[houseid][Locked],
				HouseInfo[houseid][Dono],
				HouseInfo[houseid][FHQ],
				HouseInfo[houseid][Money],
				HouseInfo[houseid][Maconha],
				HouseInfo[houseid][Material],
				HouseInfo[houseid][Owner],
				HouseInfo[houseid][hlastlogin],
				houseid);
			mysql_pquery(ConnectMYSQL, query);
		}
	}
	return 1;
}

Now all is good? Or i need change more things?