public static List <GR5_AMM_GameDetail> GetAMMGameDetails() { List <GR5_AMM_GameDetail> result = new List <GR5_AMM_GameDetail>(); List <List <string> > results = GetQueryResults("SELECT * FROM amm_gamedetails"); foreach (List <string> entry in results) { GR5_AMM_GameDetail detail = new GR5_AMM_GameDetail(); detail.uiId = Convert.ToUInt32(entry[1]); detail.uiRootModifierId = Convert.ToUInt32(entry[2]); detail.uiOasisNameId = Convert.ToUInt32(entry[3]); detail.uiOasisDescriptionId = Convert.ToUInt32(entry[4]); detail.m_ModifierVector = new List <GR5_AMM_Modifier>(); List <List <string> > results2 = GetQueryResults("SELECT * FROM amm_modifiers WHERE listType=2 AND listID=" + detail.uiId); foreach (List <string> entry2 in results2) { GR5_AMM_Modifier mm = new GR5_AMM_Modifier(); mm.uiId = Convert.ToUInt32(entry2[3]); mm.uiParentId = Convert.ToUInt32(entry2[4]); mm.uiType = Convert.ToUInt32(entry2[5]); mm.uiValue = entry2[6]; detail.m_ModifierVector.Add(mm); } result.Add(detail); } return(result); }
public static List <GR5_AMM_Map> GetAMMMaps() { List <GR5_AMM_Map> result = new List <GR5_AMM_Map>(); List <List <string> > results = GetQueryResults("SELECT * FROM amm_maps"); foreach (List <string> entry in results) { GR5_AMM_Map map = new GR5_AMM_Map(); map.uiId = Convert.ToUInt32(entry[1]); map.uiRootModifierId = Convert.ToUInt32(entry[2]); map.uiMapKey = Convert.ToUInt32(entry[3]); map.uiOasisNameId = Convert.ToUInt32(entry[4]); map.uiOasisDescriptionId = Convert.ToUInt32(entry[5]); map.uiThumbnailId = Convert.ToUInt32(entry[6]); map.m_ModifierVector = new List <GR5_AMM_Modifier>(); List <List <string> > results2 = GetQueryResults("SELECT * FROM amm_modifiers WHERE listType=0 AND listID=" + map.uiId); foreach (List <string> entry2 in results2) { GR5_AMM_Modifier mm = new GR5_AMM_Modifier(); mm.uiId = Convert.ToUInt32(entry2[3]); mm.uiParentId = Convert.ToUInt32(entry2[4]); mm.uiType = Convert.ToUInt32(entry2[5]); mm.uiValue = entry2[6]; map.m_ModifierVector.Add(mm); } result.Add(map); } return(result); }