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