private void InsertWorldItemsNotInDbFromScene(string scene) { WorldItems worldItems = FindObjectOfType <WorldItems>(); foreach (string[] worldItemDetailsArray in worldItems.WorldItemList) { bool itemExists = DbCommands.IsRecordInTable("PremadeWorldItems", "StartingLocationX = " + DbCommands.GetParameterNameFromValue(worldItemDetailsArray[0]) + " AND " + "StartingLocationY = " + DbCommands.GetParameterNameFromValue(worldItemDetailsArray[1]) + " AND " + "StartingLocationZ = " + DbCommands.GetParameterNameFromValue(worldItemDetailsArray[2]) + " AND " + "StartingParentPath = " + DbCommands.GetParameterNameFromValue(worldItemDetailsArray[3]) + " AND " + "StartingSceneNames = " + DbCommands.GetParameterNameFromValue(scene), worldItemDetailsArray[0], worldItemDetailsArray[1], worldItemDetailsArray[2], worldItemDetailsArray[3], scene ); if (!itemExists) { DbCommands.InsertTupleToTable("PremadeWorldItems", worldItemDetailsArray[0], //x worldItemDetailsArray[1], //y worldItemDetailsArray[2], //z worldItemDetailsArray[3], //parent scene, worldItemDetailsArray[4]); //item name } } }