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())); }