// Update existing entries in the table based on the iddemo_table void UpdateHealEntry(EffectsData effectData) { EffectsHealData healData = new EffectsHealData (); healData.LoadEffectData (effectData); // Setup the update query string query = "UPDATE heal_effects"; query += " SET "; query += healData.UpdateList (); query += " WHERE id=?id"; // Setup the register data List<Register> update = new List<Register> (); foreach (string field in healData.fields.Keys) { if (field != "id") update.Add (healData.fieldToRegister (field)); } update.Add (new Register ("id", "?id", MySqlDbType.Int32, healData.id.ToString (), Register.TypesOfField.Int)); // Update the database DatabasePack.Update (DatabasePack.contentDatabasePrefix, query, update); }
void InsertHealEffect(EffectsData effectData) { EffectsHealData healData = new EffectsHealData (); healData.LoadEffectData (effectData); // Setup the update query string query = "INSERT INTO heal_effects"; query += " (" + healData.FieldList ("", ", ") + ") "; query += "VALUES "; query += " (" + healData.FieldList ("?", ", ") + ") "; int itemID = -1; // Setup the register data List<Register> update = new List<Register> (); foreach (string field in healData.fields.Keys) { update.Add (healData.fieldToRegister (field)); } // Update the database itemID = DatabasePack.Insert (DatabasePack.contentDatabasePrefix, query, update); }