ads

public LoadClanInfo()
{
    clanss = cache_num_rows();
    for(new i = 1; i <= clanss; i++)
    {
		new x = i - 1;
		ClanInfo[i][cClanID]              		= cache_get_field_content_int(x, "clanID");
		ClanInfo[i][cClanExpire]              	= cache_get_field_content_int(x, "clanExpire");
		ClanInfo[i][cClanActive]              	= cache_get_field_content_int(x, "clanActive");
		ClanInfo[i][cClanSlots]              	= cache_get_field_content_int(x, "clanSlots");
		ClanInfo[i][cClanSeif]              	= cache_get_field_content_int(x, "clanSeif");
        cache_get_field_content(x, "clanName", ClanInfo[i][cClanName], SQL, 130);
		cache_get_field_content(x, "clanColor", ClanInfo[i][cClanColor], SQL, 130);
		cache_get_field_content(x, "clanMOTD", ClanInfo[i][cClanMOTD], SQL, 130);
   	    cache_get_field_content(x, "clanTag", ClanInfo[i][cClanTag], SQL, 130);
    	cache_get_field_content(x, "clanRankName7", ClanInfo[i][cClanRankName7], SQL, 130);
    	cache_get_field_content(x, "clanRankName6", ClanInfo[i][cClanRankName6], SQL, 130);
    	cache_get_field_content(x, "clanRankName5", ClanInfo[i][cClanRankName5], SQL, 130);
    	cache_get_field_content(x, "clanRankName4", ClanInfo[i][cClanRankName4], SQL, 130);
    	cache_get_field_content(x, "clanRankName3", ClanInfo[i][cClanRankName3], SQL, 130);
    	cache_get_field_content(x, "clanRankName2", ClanInfo[i][cClanRankName2], SQL, 130);
    	cache_get_field_content(x, "clanRankName1", ClanInfo[i][cClanRankName1], SQL, 130);
    	LoadClanCar(i);
	}
	printf("[LOADING] %d clans loaded.", clanss);
}

public LoadDynamicFactions()
{
	factionss = cache_num_rows();
	new string[310];
    for(new i = 1; i <= factionss; i++)
    {
		new f = i - 1;
		DynamicFactions[i][fID]                 = cache_get_field_content_int(f, "ID");
        cache_get_field_content(f, "Name", DynamicFactions[i][fName], SQL, 130);
		DynamicFactions[i][fcX]                 = cache_get_field_content_float(f, "X");
   	    DynamicFactions[i][fcY]                 = cache_get_field_content_float(f, "Y");
    	DynamicFactions[i][fcZ]                 = cache_get_field_content_float(f, "Z");
    	DynamicFactions[i][fceX]                = cache_get_field_content_float(f, "eX");
   	    DynamicFactions[i][fceY]                = cache_get_field_content_float(f, "eY");
    	DynamicFactions[i][fceZ]                = cache_get_field_content_float(f, "eZ");
    	DynamicFactions[i][fSafePos][0]			= cache_get_field_content_float(f, "SafePos1");
    	DynamicFactions[i][fSafePos][1]			= cache_get_field_content_float(f, "SafePos2");
    	DynamicFactions[i][fSafePos][2]			= cache_get_field_content_float(f, "SafePos3");
    	DynamicFactions[i][fMats]               = cache_get_field_content_int(f, "Mats");
    	DynamicFactions[i][fInterior]           = cache_get_field_content_int(f, "Interior");
    	DynamicFactions[i][fVirtual]            = cache_get_field_content_int(f, "Virtual");
    	DynamicFactions[i][fMapIcon]            = cache_get_field_content_int(f, "MapIcon");
    	DynamicFactions[i][fLocked]            	= cache_get_field_content_int(f, "Locked");
    	DynamicFactions[i][fDrugs]              = cache_get_field_content_int(f, "Drugs");
    	DynamicFactions[i][fBank]               = cache_get_field_content_int(f, "Bank");
    	DynamicFactions[i][fPickupIDD]          = cache_get_field_content_int(f, "PickupID");
        cache_get_field_content(f, "Anunt", DynamicFactions[i][fAnn], SQL, 130);
    	DynamicFactions[i][fWin]                = cache_get_field_content_int(f, "Win");
    	DynamicFactions[i][fLost]               = cache_get_field_content_int(f, "Lost");
    	DynamicFactions[i][fMaxMembers]         = cache_get_field_content_int(f, "MaxMembers");
		DynamicFactions[i][fMinLevel]         	= cache_get_field_content_int(f, "MinLevel");
    	DynamicFactions[i][fApplication]        = cache_get_field_content_int(f, "Application");
		cache_get_field_content(f, "Rank1", DynamicFactions[i][fRankName1], SQL, 130);
		cache_get_field_content(f, "Rank2", DynamicFactions[i][fRankName2], SQL, 130);
		cache_get_field_content(f, "Rank3", DynamicFactions[i][fRankName3], SQL, 130);
		cache_get_field_content(f, "Rank4", DynamicFactions[i][fRankName4], SQL, 130);
		cache_get_field_content(f, "Rank5", DynamicFactions[i][fRankName5], SQL, 130);
		cache_get_field_content(f, "Rank6", DynamicFactions[i][fRankName6], SQL, 130);
		cache_get_field_content(f, "Rank7", DynamicFactions[i][fRankName7], SQL, 130);
		for(new c; c < 10; c++)
		{
			new s[10];
			format(s, sizeof(s),"Skin%d",c);
			FactionSkin[i][c] = cache_get_field_content_int(f, s);
		}
		switch(DynamicFactions[i][fLocked]) {
	    	case 0: format(string, sizeof(string), "%s's HQ", DynamicFactions[i][fName]);
	    	case 1: format(string, sizeof(string), "%s's HQ\n\n(locked)", DynamicFactions[i][fName]);
	    }
	   	DynamicFactions[i][fPickupID] = CreateDynamicPickup(DynamicFactions[i][fPickupIDD], 23, DynamicFactions[i][fceX], DynamicFactions[i][fceY], DynamicFactions[i][fceZ], 0, -1, -1, 10);
		DynamicFactions[i][fLabelID] = CreateDynamic3DTextLabel(string, COLOR_COOLBLUE, DynamicFactions[i][fceX], DynamicFactions[i][fceY], DynamicFactions[i][fceZ], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 25.0);
		if(DynamicFactions[i][fMapIcon] != 0) CreateDynamicMapIcon(DynamicFactions[i][fceX],DynamicFactions[i][fceY],DynamicFactions[i][fceZ],DynamicFactions[i][fMapIcon],0,-1,-1,-1,750.0); //Bank
		format(string, sizeof(string), "%s\nGroup Safe", DynamicFactions[i][fName]);
		DynamicFactions[i][fSafePickupID] = CreateDynamicPickup(1274, 23, DynamicFactions[i][fSafePos][0], DynamicFactions[i][fSafePos][1], DynamicFactions[i][fSafePos][2], DynamicFactions[i][fVirtual], DynamicFactions[i][fInterior], -1, 50);
		DynamicFactions[i][fSafeLabelID] = CreateDynamic3DTextLabel(string, COLOR_YELLOW, DynamicFactions[i][fSafePos][0], DynamicFactions[i][fSafePos][1], DynamicFactions[i][fSafePos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, DynamicFactions[i][fVirtual], DynamicFactions[i][fInterior], -1, 20.0);
	}
	printf("[LOADING] %d groups loaded.", factionss);
	return 1;
}