public List <MarginAbilityItem> loadAbilities(int charId)
{
conn.Open();
string sqlQuery = "SELECT slot, ability_id,level, is_loaded FROM char_abilities WHERE char_id = '" + charId.ToString() + "' ORDER BY slot ASC ";
queryExecuter = conn.CreateCommand();
queryExecuter.CommandText = sqlQuery;
dr = queryExecuter.ExecuteReader();
List <MarginAbilityItem> Abilities = new List <MarginAbilityItem>();
while (dr.Read())
{
MarginAbilityItem ability = new MarginAbilityItem();
ability.setSlot((UInt16)dr.GetInt16(0));
ability.setAbilityID((Int32)dr.GetInt64(1));
ability.setLevel((UInt16)dr.GetInt16(2));
ability.setLoaded(dr.GetBoolean(3));
Abilities.Add(ability);
}
conn.Close();
return(Abilities);
}
public List<MarginAbilityItem> loadAbilities(int charId)
{
conn.Open();
string sqlQuery = "SELECT slot, ability_id,level, is_loaded FROM char_abilities WHERE char_id = '" + charId.ToString() + "' ORDER BY slot ASC ";
queryExecuter = conn.CreateCommand();
queryExecuter.CommandText = sqlQuery;
dr = queryExecuter.ExecuteReader();
List<MarginAbilityItem> Abilities = new List<MarginAbilityItem>();
while (dr.Read())
{
MarginAbilityItem ability = new MarginAbilityItem();
ability.setSlot((UInt16)dr.GetInt16(0));
ability.setAbilityID((Int32)dr.GetInt64(1));
ability.setLevel((UInt16)dr.GetInt16(2));
ability.setLoaded(dr.GetBoolean(3));
Abilities.Add(ability);
}
conn.Close();
return Abilities;
}
