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
}
}
}
