public List <DDO_EnchantmentInfo> GetAllEnchantmentByCharacterId(int charId)
{
List <DDO_EnchantmentInfo> res = new List <DDO_EnchantmentInfo> ();
cmd = "select * from `enchantment` where `charid`=" + charId + ";";
DataSet ds = new DataSet();
pool.ExecuteSql(database, cmd, ds);
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
DDO_EnchantmentInfo e = new DDO_EnchantmentInfo();
e.m_realId = long.Parse(dt.Rows[i]["realid"].ToString());
e.m_characterId = int.Parse(dt.Rows[i]["charid"].ToString());
e.m_attrArr = GetAttr(dt.Rows[i]["enchant_attr"].ToString());
res.Add(e);
}
return(res);
}
//ENCHANTMENT
public void UpdateEnchantmentInfo(DDO_EnchantmentInfo e)
{
cmd = "update `enchantment` set `enchant_attr`=\"" + GetString(e.m_attrArr) + "\" where `realid`=" + e.m_realId + ";";
pool.ExecuteSql(database, cmd);
}
public void InsertEnchantmentInfo(DDO_EnchantmentInfo enchantmentInfo)
{
cmd = "insert into `enchantment` values(null," + enchantmentInfo.m_characterId + ",\"" + GetString(enchantmentInfo.m_attrArr) + "\");";
pool.ExecuteSql(database, cmd);
}
public bool TryGetEnchantment(long realId, out DDO_EnchantmentInfo resInfo)
{
return(m_ecmtInfoDict.TryGetValue(realId, out resInfo));
}
