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