clan

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



				case 7: {
					mysql_format(SQL, var100, sizeof(var100), "SELECT * FROM `clans`");
					mysql_tquery(SQL, var100, "LoadClanInfo", "");
					foreach(new ids : Player)
					{
						if(IsPlayerConnected(ids))
						{
							if(PlayerInfo[ids][pSQLID] == playerid)
							{
								PlayerInfo[ids][pClan] = complaint;
								PlayerInfo[ids][pCRank] = 7;
								PlayerInfo[ids][pPremiumPoints] -= 100;
							}
						}
					}
					mysql_format(SQL, var100, sizeof(var100), "INSERT INTO `emails` (`playerid`,`Message`) VALUES('%d','Felicitari! Ai cumparat un clan cu numele %s, foloseste /clan pentru a deschide meniul acestuia.')",playerid,playername);
					mysql_tquery(SQL,var100,"","");
				}