public DB() { SQLiteDataReader tempReader = Load("terraria", "SELECT name, id FROM tiles"); while (tempReader.Read()) Tiles.Add(GetString(tempReader, 0), GetInt32(tempReader, 1)); tempReader = Load("terraria", "SELECT name, id FROM buffs"); while (tempReader.Read()) Buffs.Add(GetString(tempReader, 0), GetInt32(tempReader, 1)); tempReader = Load("terraria", "SELECT id, name_en, name_de, name_it, name_fr, name_es, damageMod, knockbackMod, speedMod, " + "sizeMod, velocityMod, manaCostMod, critStrikeMod, sellValueMod FROM item_prefix"); while(tempReader.Read()) { ItemPrefix prefix = new ItemPrefix(); prefix.name.Add(GetString(tempReader, 1)); prefix.name.Add(GetString(tempReader, 2)); prefix.name.Add(GetString(tempReader, 3)); prefix.name.Add(GetString(tempReader, 4)); prefix.name.Add(GetString(tempReader, 5)); prefix.damageMod = GetFloat(tempReader, 6); prefix.knockBackMod = GetFloat(tempReader, 7); prefix.speedMod = GetFloat(tempReader, 8); prefix.sizeMod = GetFloat(tempReader, 9); prefix.velocityMod = GetFloat(tempReader, 10); prefix.manaCostMod = GetFloat(tempReader, 11); prefix.critStrikeMod = GetInt32(tempReader, 12); prefix.sellValueMod = GetFloat(tempReader, 13); ItemPrefixes.Add(GetInt32(tempReader, 0), prefix); } if (!tempReader.IsClosed) tempReader.Close(); CloseConnections(); }