public void CreateCharacterQuest(SqliteTransaction transaction, int idx, string characterId, CharacterQuest characterQuest)
{
ExecuteNonQuery(transaction, "INSERT INTO characterquest (id, idx, characterId, dataId, isComplete, killedMonsters, completedTasks) VALUES (@id, @idx, @characterId, @dataId, @isComplete, @killedMonsters, @completedTasks)",
new SqliteParameter("@id", characterId + "_" + idx),
new SqliteParameter("@idx", idx),
new SqliteParameter("@characterId", characterId),
new SqliteParameter("@dataId", characterQuest.dataId),
new SqliteParameter("@isComplete", characterQuest.isComplete),
new SqliteParameter("@killedMonsters", characterQuest.WriteKilledMonsters()),
new SqliteParameter("@completedTasks", characterQuest.WriteCompletedTasks()));
}
public async UniTask CreateCharacterQuest(MySqlConnection connection, MySqlTransaction transaction, int idx, string characterId, CharacterQuest characterQuest)
{
await ExecuteNonQuery(connection, transaction, "INSERT INTO characterquest (id, idx, characterId, dataId, isComplete, killedMonsters, completedTasks) VALUES (@id, @idx, @characterId, @dataId, @isComplete, @killedMonsters, @completedTasks)",
new MySqlParameter("@id", characterId + "_" + idx),
new MySqlParameter("@idx", idx),
new MySqlParameter("@characterId", characterId),
new MySqlParameter("@dataId", characterQuest.dataId),
new MySqlParameter("@isComplete", characterQuest.isComplete),
new MySqlParameter("@killedMonsters", characterQuest.WriteKilledMonsters()),
new MySqlParameter("@completedTasks", characterQuest.WriteCompletedTasks()));
}