internal List<SnowItems> GetSnowItems(int Level, DatabaseClient dbClient) { List<SnowItems> list = new List<SnowItems>(); DataTable table = dbClient.ReadDataTable("SELECT * FROM storm_items WHERE Snow_Level = '" + Level + "'"); foreach (DataRow row in table.Rows) { SnowItems item = new SnowItems { Id = (int)row["Id"], ItemId = (int)row["ItemId"], Name = (string)row["Name"], X = (int)row["X"], Y = (int)row["Y"], Rot = (int)row["Rot"], SpriteId = (int)row["SpriteId"], Extradata = (string)row["Extradata"], Level = (int)row["Snow_Level"] }; list.Add(item); } return list; }
internal List <SnowItems> GetSnowItems(int Level, DatabaseClient dbClient) { List <SnowItems> list = new List <SnowItems>(); DataTable table = dbClient.ReadDataTable("SELECT * FROM storm_items WHERE Snow_Level = '" + Level + "'"); foreach (DataRow row in table.Rows) { SnowItems item = new SnowItems { Id = (int)row["Id"], ItemId = (int)row["ItemId"], Name = (string)row["Name"], X = (int)row["X"], Y = (int)row["Y"], Rot = (int)row["Rot"], SpriteId = (int)row["SpriteId"], Extradata = (string)row["Extradata"], Level = (int)row["Snow_Level"] }; list.Add(item); } return(list); }