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