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