void UpdateItem(MerchantTableItemEntry entry) { string query = "UPDATE merchant_item"; query += " SET "; query += entry.UpdateList (); query += " WHERE id=?id"; // Setup the register data List<Register> update = new List<Register> (); foreach (string field in entry.fields.Keys) { update.Add (entry.fieldToRegister (field)); } DatabasePack.Update (DatabasePack.contentDatabasePrefix, query, update); }
void InsertItem(MerchantTableItemEntry entry) { string query = "INSERT INTO merchant_item"; query += " (tableID, count, itemID, refreshTime) "; query += "VALUES "; query += " (" + entry.tableID + "," + entry.count + "," + entry.itemID + "," + entry.refreshTime + ") "; // Setup the register data List<Register> update = new List<Register> (); foreach (string field in entry.fields.Keys) { update.Add (entry.fieldToRegister (field)); } int itemID = -1; itemID = DatabasePack.Insert (DatabasePack.contentDatabasePrefix, query, update); entry.id = itemID; }