public void UpdateProgress(QuestProgressData rpProgress)
{
using (var rCommand = Connection.CreateCommand())
{
rCommand.CommandText = "INSERT OR IGNORE INTO quest(id) VALUES (@id);" +
"UPDATE quest SET progress = @progress WHERE id = @id;" +
"UPDATE quest SET update_time = strftime('%s', 'now') WHERE id = @id;";
rCommand.Parameters.Add(new SQLiteParameter("@id", rpProgress.ID));
rCommand.Parameters.Add(new SQLiteParameter("@progress", rpProgress.Current));
rCommand.ExecuteNonQuery();
}
}
public void UpdateStatus(QuestProgressData rpProgress)
{
using (var rCommand = Connection.CreateCommand())
{
rCommand.CommandText = "INSERT OR IGNORE INTO quest(id) VALUES (@id);" +
"UPDATE quest SET state = @state WHERE id = @id;" +
"UPDATE quest SET progress = @startfrom WHERE id = @id AND state = 3;";
rCommand.Parameters.Add(new SQLiteParameter("@id", rpProgress.ID));
rCommand.Parameters.Add(new SQLiteParameter("@state", (int)rpProgress.State));
rCommand.Parameters.Add(new SQLiteParameter("@startfrom", (int)rpProgress.StartFrom));
rCommand.ExecuteNonQuery();
}
}