void UpdateObjective(QuestsObjectivesData entry)
{
string query = "UPDATE quest_objectives";
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 InsertObjective(QuestsObjectivesData entry)
{
string query = "INSERT INTO quest_objectives";
query += " (questID, primaryObjective, objectiveType, target, targetCount, targetText) ";
query += "VALUES ";
query += " (" + entry.questID + ",1,'" + entry.objectiveType + "'," + entry.target + "," + entry.targetCount + ",'" + entry.targetText + "') ";
// 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;
}