public void Init() { try { string path = Path.Combine(Program.Config.LauncherDir, "cards.cdb"); m_cards = new Dictionary<int, CardInfos>(); if (!File.Exists(path)) return; SQLiteConnection connection = new SQLiteConnection("Data Source=" + path); connection.Open(); SQLiteDataReader reader = new SQLiteCommand("SELECT id, alias, type, level, race, attribute, atk, def FROM datas", connection).ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); CardInfos infos = new CardInfos(id) { AliasId = reader.GetInt32(1), Type = reader.GetInt32(2), Level = reader.GetInt32(3), Race = reader.GetInt32(4), Attribute = reader.GetInt32(5), Atk = reader.GetInt32(6), Def = reader.GetInt32(7) }; m_cards.Add(id, infos); } reader.Close(); reader = new SQLiteCommand("SELECT id, name, desc FROM texts", connection).ExecuteReader(); while (reader.Read()) { int key = reader.GetInt32(0); if (m_cards.ContainsKey(key)) { m_cards[key].Name = reader.GetString(1); m_cards[key].CleanedName = m_cards[key].Name.Trim().ToLower().Replace("-", " ").Replace("'", " ").Replace(" ", " ").Replace(" ", " "); m_cards[key].Description = reader.GetString(2); } } connection.Close(); } catch (Exception) { } }
public void Init() { try { m_cards = new Dictionary <int, CardInfos>(); string str2 = Path.Combine(Program.Config.LauncherDir, "cards.cdb"); if (!File.Exists(str2)) { return; } var connection = new SQLiteConnection("Data Source=" + str2); connection.Open(); SQLiteDataReader reader = new SQLiteCommand("SELECT id, alias, type, level, race, attribute, atk, def FROM datas", connection).ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); var infos = new CardInfos(id) { AliasId = reader.GetInt32(1), Type = reader.GetInt32(2), Level = reader.GetInt32(3), Race = reader.GetInt32(4), Attribute = reader.GetInt32(5), Atk = reader.GetInt32(6), Def = reader.GetInt32(7) }; m_cards.Add(id, infos); } reader.Close(); reader = new SQLiteCommand("SELECT id, name, desc FROM texts", connection).ExecuteReader(); while (reader.Read()) { int key = reader.GetInt32(0); if (m_cards.ContainsKey(key)) { m_cards[key].Name = reader.GetString(1); m_cards[key].CleanedName = m_cards[key].Name.Trim().ToLower().Replace("-", " ").Replace("'", " ").Replace(" ", " ").Replace(" ", " "); m_cards[key].Description = reader.GetString(2); } } connection.Close(); Loaded = true; } catch (Exception) { } }