/** * This function distributes items randomly amongst the dungeon * @param numberOfItems the number of items to scatter */ public void AddItems(int numberOfItems) { sqliteCommand command; Random r = new Random(); //populate item table with items for (int i = 0; i < numberOfItems; i++) { String room = "room"; room += r.Next(0, DungeonSize); Item item = gameObjectList.GetRandomItem(); command = new sqliteCommand("INSERT INTO " + itemTableName + " (name, itemID, uniqueID, owner) " + "VALUES (?,?,?,?) ", Database); command.Parameters.Add("@name", DbType.String).Value = item.itemName.ToLower(); command.Parameters.Add("@itemID", DbType.String).Value = item.ID; command.Parameters.Add("@uniqueID", DbType.String).Value = Guid.NewGuid().ToString(); command.Parameters.Add("@owner", DbType.String).Value = room; command.ExecuteNonQuery(); } }