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()));
 }
Exemple #2
0
 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()));
 }