internal static void InitGroups() { BaseBadges = new List<GuildsPartsData>(); SymbolBadges = new List<GuildsPartsData>(); ColorBadges1 = new List<GuildsPartsData>(); ColorBadges2 = new List<GuildsPartsData>(); ColorBadges3 = new List<GuildsPartsData>(); using (IQueryAdapter adapter = FirewindEnvironment.GetDatabaseManager().getQueryreactor()) { adapter.setQuery("SELECT * FROM groups_elements"); DataTable table = adapter.getTable(); foreach (DataRow row in table.Rows) { GuildsPartsData data; if (row["Type"].ToString() == "Base") { data = new GuildsPartsData { Id = (int)row["Id"], ExtraData1 = (string)row["ExtraData1"], ExtraData2 = (string)row["ExtraData2"] }; BaseBadges.Add(data); } else if (row["ExtraData1"].ToString().StartsWith("symbol_")) { data = new GuildsPartsData { Id = (int)row["Id"], ExtraData1 = (string)row["ExtraData1"], ExtraData2 = (string)row["ExtraData2"] }; SymbolBadges.Add(data); } else if (row["Type"].ToString() == "Color1") { data = new GuildsPartsData { Id = (int)row["Id"], ExtraData1 = (string)row["ExtraData1"] }; ColorBadges1.Add(data); } else if (row["Type"].ToString() == "Color2") { data = new GuildsPartsData { Id = (int)row["Id"], ExtraData1 = (string)row["ExtraData1"] }; ColorBadges2.Add(data); } else if (row["Type"].ToString() == "Color3") { data = new GuildsPartsData { Id = (int)row["Id"], ExtraData1 = (string)row["ExtraData1"] }; ColorBadges3.Add(data); } } } }
internal static void InitGroups() { BaseBadges = new List <GuildsPartsData>(); SymbolBadges = new List <GuildsPartsData>(); ColorBadges1 = new List <GuildsPartsData>(); ColorBadges2 = new List <GuildsPartsData>(); ColorBadges3 = new List <GuildsPartsData>(); using (IQueryAdapter adapter = FirewindEnvironment.GetDatabaseManager().getQueryreactor()) { adapter.setQuery("SELECT * FROM groups_elements"); DataTable table = adapter.getTable(); foreach (DataRow row in table.Rows) { GuildsPartsData data; if (row["Type"].ToString().ToLower() == "base") { data = new GuildsPartsData { Id = (int)row["Id"], ExtraData1 = (string)row["ExtraData1"], ExtraData2 = (string)row["ExtraData2"] }; BaseBadges.Add(data); } else if (row["ExtraData1"].ToString().StartsWith("symbol_")) { data = new GuildsPartsData { Id = (int)row["Id"], ExtraData1 = (string)row["ExtraData1"], ExtraData2 = (string)row["ExtraData2"] }; SymbolBadges.Add(data); } else if (row["Type"].ToString().ToLower() == "color") { data = new GuildsPartsData { Id = (int)row["Id"], ExtraData1 = (string)row["ExtraData1"] }; ColorBadges1.Add(data); } else if (row["Type"].ToString().ToLower() == "color2") { data = new GuildsPartsData { Id = (int)row["Id"], ExtraData1 = (string)row["ExtraData1"] }; ColorBadges2.Add(data); } else if (row["Type"].ToString().ToLower() == "color3") { data = new GuildsPartsData { Id = (int)row["Id"], ExtraData1 = (string)row["ExtraData1"] }; ColorBadges3.Add(data); } } } }