public void StartNewGame(string name, string portraitPath) { string[,] pgFields = new string[, ] { { "PlayerNames", name }, { "PortraitImages", portraitPath }, { "Dates", DateTime.Now.ToString() }, { "LocationName", "Start" }, { "LocationX", "-2" }, { "LocationY", "0" }, { "SkillPointsSpent", "0" } }; DbCommands.UpdateTableTuple("PlayerGames", "SaveIDs = 0", pgFields); //Dialogues activated string[,] delFields = new string[, ] { { "SaveIDs", "0" } }; DbCommands.DeleteTupleInTable("ActivatedDialogues", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("ActivatedDialogues", new string[] { "SaveIDs" }, new string[] { "0" }, new string[] { "-1" }); //Quests activated DbCommands.DeleteTupleInTable("QuestsActivated", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("QuestsActivated", new string[] { "SaveIDs" }, new string[] { "0" }, new string[] { "-1" }); //Quests tasks completed DbCommands.DeleteTupleInTable("QuestTasksActivated", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("QuestTasksActivated", new string[] { "SaveIDs" }, new string[] { "0" }, new string[] { "-1" }); //Task parts completed DbCommands.DeleteTupleInTable("CompletedQuestTaskParts", delFields); //discovered vocabulary DbCommands.DeleteTupleInTable("DiscoveredVocab", delFields); //discovered vocabulary DbCommands.DeleteTupleInTable("DiscoveredVocabGrammar", delFields); //acquired vocabulary read proficiencies DbCommands.DeleteTupleInTable("AcquiredVocabReadSkills", delFields); //acquired vocabulary write proficiencies DbCommands.DeleteTupleInTable("AcquiredVocabWriteSkills", delFields); //acquired grammar proficiencies DbCommands.DeleteTupleInTable("AcquiredGrammarSkills", delFields); PlayerPrefsManager.SetSaveGame(0); sceneLoader.LoadSceneByName("Demo"); }
public void CopyPlayerSaveToCurrentGame(string[] playerGameData) { string saveID = playerGameData[0]; if (saveID != "0") { //PlayerGames tbl string[,] pgFields = new string[, ] { { "PlayerNames", playerGameData[2] }, { "PortraitImages", playerGameData[3] }, { "LocationName", playerGameData[5] } }; DbCommands.UpdateTableTuple("PlayerGames", "SaveIDs = 0", pgFields); string[,] delFields = new string[, ] { { "SaveIDs", "0" } }; //Dialogues activated DbCommands.DeleteTupleInTable("ActivatedDialogues", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("ActivatedDialogues", new string[] { "SaveIDs" }, new string[] { "0" }, new string[] { playerGameData[0] }); //Quests activated DbCommands.DeleteTupleInTable("QuestsActivated", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("QuestsActivated", new string[] { "SaveIDs" }, new string[] { "0" }, new string[] { playerGameData[0] }); //Quests tasks completed DbCommands.DeleteTupleInTable("QuestTasksActivated", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("QuestTasksActivated", new string[] { "SaveIDs" }, new string[] { "0" }, new string[] { playerGameData[0] }); //Task parts completed DbCommands.DeleteTupleInTable("CompletedQuestTaskParts", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("CompletedQuestTaskParts", new string[] { "SaveIDs" }, new string[] { "0" }, new string[] { playerGameData[0] }); //discovered vocab DbCommands.DeleteTupleInTable("DiscoveredVocab", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("DiscoveredVocab", new string[] { "SaveIDs" }, new string[] { "0" }, new string[] { playerGameData[0] }); //discovered grammar DbCommands.DeleteTupleInTable("DiscoveredVocabGrammar", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("DiscoveredVocabGrammar", new string[] { "SaveIDs" }, new string[] { "0" }, new string[] { playerGameData[0] }); //acquired vocabulary read proficiencies DbCommands.DeleteTupleInTable("AcquiredVocabReadSkills", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("AcquiredVocabReadSkills", new string[] { "SaveIDs" }, new string[] { "0" }, new string[] { playerGameData[0] }); //acquired vocabulary write proficiencies DbCommands.DeleteTupleInTable("AcquiredVocabWriteSkills", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("AcquiredVocabWriteSkills", new string[] { "SaveIDs" }, new string[] { "0" }, new string[] { playerGameData[0] }); //acquired grammar proficiencies DbCommands.DeleteTupleInTable("AcquiredGrammarSkills", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("AcquiredGrammarSkills", new string[] { "SaveIDs" }, new string[] { "0" }, new string[] { playerGameData[0] }); } }
public void CopyCurrentGameToPlayerSave(int saveID) { string saveIDstr = saveID.ToString(); //Dialogues activated string[,] delFields = new string[, ] { { "SaveIDs", saveIDstr } }; DbCommands.DeleteTupleInTable("ActivatedDialogues", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("ActivatedDialogues", new string[] { "SaveIDs" }, new string[] { saveIDstr }, new string[] { "0" }); //Quests activated DbCommands.DeleteTupleInTable("QuestsActivated", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("QuestsActivated", new string[] { "SaveIDs" }, new string[] { saveIDstr }, new string[] { "0" }); //Quests tasks completed DbCommands.DeleteTupleInTable("QuestTasksActivated", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("QuestTasksActivated", new string[] { "SaveIDs" }, new string[] { saveIDstr }, new string[] { "0" }); //Task parts completed DbCommands.DeleteTupleInTable("CompletedQuestTaskParts", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("CompletedQuestTaskParts", new string[] { "SaveIDs" }, new string[] { saveIDstr }, new string[] { "0" }); //Discovered vocab DbCommands.DeleteTupleInTable("DiscoveredVocab", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("DiscoveredVocab", new string[] { "SaveIDs" }, new string[] { saveIDstr }, new string[] { "0" }); //Discovered grammar DbCommands.DeleteTupleInTable("DiscoveredVocabGrammar", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("DiscoveredVocabGrammar", new string[] { "SaveIDs" }, new string[] { saveIDstr }, new string[] { "0" }); //acquired vocabulary read proficiencies DbCommands.DeleteTupleInTable("AcquiredVocabReadSkills", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("AcquiredVocabReadSkills", new string[] { "SaveIDs" }, new string[] { saveIDstr }, new string[] { "0" }); //acquired vocabulary write proficiencies DbCommands.DeleteTupleInTable("AcquiredVocabWriteSkills", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("AcquiredVocabWriteSkills", new string[] { "SaveIDs" }, new string[] { saveIDstr }, new string[] { "0" }); //acquired grammar proficiencies DbCommands.DeleteTupleInTable("AcquiredGrammarSkills", delFields); DbCommands.InsertExistingValuesInSameTableWithNewPK("AcquiredGrammarSkills", new string[] { "SaveIDs" }, new string[] { saveIDstr }, new string[] { "0" }); }