public long InsertItem(DDO_Item item)
{
DataSet ds = new DataSet();
cmd = "insert into `item` values(null," + item.m_itemId + "," + item.m_characterId + "," + item.m_num + ",\"" + item.m_place.ToString() + "\"," + item.m_position + ");select last_insert_id();";
pool.ExecuteSql(database, cmd, ds);
if (ds.Tables[0].Rows.Count == 0)
{
return(-1);
}
return(long.Parse(ds.Tables[0].Rows[0]["last_insert_id()"].ToString()));
}
public void UpdateItem(DDO_Item item)
{
cmd = "update `item` set itemid=" + item.m_itemId + ",`charid`=" + item.m_characterId + ",`num`=" + item.m_num + ",`place`=\"" + item.m_place.ToString() + "\",`position`=" + item.m_position + " where realid=" + item.m_realId + ";";
pool.ExecuteSql(database, cmd);
}
