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