public bool UpdateCharacterWallet(DDO_CharacterWallet w) { cmd = "update `wallet` set `virtual`=" + w.m_virtualCy + ",`charge`=" + w.m_chargeCy + " where charid=" + w.m_characterId + ";"; try { pool.ExecuteSql(database, cmd); } catch { return(false); } return(true); }
//WALLET public bool InsertCharacterWallet(DDO_CharacterWallet w) { cmd = "insert into `wallet` values(" + w.m_characterId + "," + w.m_virtualCy + "," + w.m_chargeCy + ");"; try { pool.ExecuteSql(database, cmd); } catch { return(false); } return(true); }
public bool GetCharacterWalletByCharacterId(int id, out DDO_CharacterWallet w) { cmd = "select * from `wallet` where charid=" + id + ";"; DataSet ds = new DataSet(); try { pool.ExecuteSql(database, cmd, ds); w = new DDO_CharacterWallet(id, int.Parse(ds.Tables[0].Rows[0]["virtual"].ToString()), int.Parse(ds.Tables[0].Rows[0]["charge"].ToString())); return(true); } catch { w = default(DDO_CharacterWallet); return(false); } }