public void DeleteTag() { string[,] fields = { { "Tags", tagText } }; DbCommands.DeleteTupleInTable("TranslationTags", fields); Destroy(gameObject); }
public void DeleteProficiency() { string[,] fields = { { "ProficiencyNames", CurrentProficiencyName } }; DbCommands.DeleteTupleInTable("Proficiencies", fields); Destroy(gameObject); }
public void DeleteCharacterDialogue() { string[,] fields = { { "CharacterNames", characterName }, { "DialogueIDs", dialogueID } }; DbCommands.DeleteTupleInTable("CharacterDialogues", fields); Destroy(gameObject); }
private void SaveWorldItems() { string saveIDstr = saveID.ToString(); string[,] delFields = new string[, ] { { "SaveIDs", saveIDstr } }; DbCommands.DeleteTupleInTable("SavedWorldItems", delFields); WorldItems worldItems = FindObjectOfType <WorldItems>(); worldItems.SetWorldItemsList(); List <string[]> worldItemsList = worldItems.WorldItemList; foreach (string[] worldItemData in worldItemsList) { DbCommands.InsertTupleToTable("SavedWorldItems", saveIDstr, worldItemData[0], worldItemData[1], worldItemData[2], worldItemData[3], sceneLoader.GetCurrentSceneName(), worldItemData[4], worldItemData[5]); } }
public void DeleteRule() { string[,] fields = { { "RuleIDs", RuleNumber } }; DbCommands.DeleteTupleInTable("VocabGrammar", fields); Destroy(gameObject); }
public void DeleteChoice() { string[,] fields = { { "ChoiceIDs", myID } }; DbCommands.DeleteTupleInTable("PlayerChoices", fields); Destroy(gameObject); }
public void DeletePlayerChoiceResultGeneric(string resultID) { string[,] fields = { { "ResultIDs", resultID }, { "ChoiceIDs", (playerChoicesListUI.GetSelectedItemFromGroup(playerChoicesListUI.SelectedChoice) as PlayerChoice).MyID } }; DbCommands.DeleteTupleInTable( "PlayerChoiceResults", fields); }
public void DeleteNode() { string[,] fields = { { "NodeIDs", myID } }; DbCommands.DeleteTupleInTable("DialogueNodes", fields); playerChoicesListUI.HidePlayerChoices(); Destroy(gameObject); }
public void DeleteDialogue() { string[,] fields = { { "DialogueIDs", myID } }; DbCommands.DeleteTupleInTable("Dialogues", fields); Destroy(gameObject); dialogueUI.HideCharsRelatedToDialogue(); dialogueUI.HideNodesRelatedToDialogue(); }
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 DeleteSave() { int id = selectedSave.ID; Destroy(selectedSave.gameObject); string[,] ruleFields = new string[, ] { { "SaveIDs", id.ToString() } }; DbCommands.DeleteTupleInTable("PlayerGames", ruleFields); }
public void DeleteSelf() { string[,] fields = { { "QuestNames", myName } }; DbCommands.DeleteTupleInTable("Quests", fields); Destroy(gameObject); //TODO: ? possibly needs to utilise a function from UI // controller to clear selection questsUI.HideTasksListUI(); //dialogueUI.HideNodesRelatedToDialogue(); }
public void DeleteFromRuleList() { Translation currentTranslation = (Translation)vocabTranslationListUI.GetSelectedItemFromGroup(vocabTranslationListUI.VocabTranslationSelected); string[,] ruleFields = new string[, ] { { "WelshText", currentTranslation.CurrentWelsh }, { "RuleIDs", RuleNumber } }; DbCommands.DeleteTupleInTable("VocabRuleList", ruleFields); addRuleBtn.GetComponent <Text>().text = "Add rule"; Image btnImg = gameObject.transform.Find("DescriptionInput").GetComponent <Image>(); btnImg.color = Color.white; IsAssignedToSelectedTranslation = false; }
public void DeleteFromTagList() { Translation currentTranslation = (Translation)vocabTranslationListUI.GetSelectedItemFromGroup(vocabTranslationListUI.VocabTranslationSelected); string[,] tagFields = new string[, ] { { "Tags", tagText }, { "EnglishText", currentTranslation.CurrentEnglish }, { "WelshText", currentTranslation.CurrentWelsh } }; DbCommands.DeleteTupleInTable("VocabTagged", tagFields); addTagBtn.GetComponent <Text>().text = "Add tag"; Image btnImg = textInput.GetComponent <Image>(); btnImg.color = Color.white; IsAssignedToSelectedTranslation = false; }
public void UpdateTaskInDb(string taskID, string taskDescription, bool activeAtStart) { string[,] fields = new string[, ] { { "TaskDescriptions", taskDescription } }; DbCommands.UpdateTableTuple("QuestTasks", "TaskIDs = " + taskID, fields); if (activeAtStart) { DbCommands.InsertTupleToTable("QuestTasksActivated", taskID, "-1", "0"); } else { string[,] activeTaskfields = { { "TaskIDs", taskID }, { "SaveIDs", "-1" } }; DbCommands.DeleteTupleInTable("QuestTasksActivated", activeTaskfields); //Removes the task in activated tasks if it is marked as inactive. } }
/* */ public void DeleteTranslation() { string[,] translationFields = new string[, ] { { "EnglishText", CurrentEnglish }, { "WelshText", CurrentWelsh } }; string[,] englishFields = new string[, ] { { "EnglishText", CurrentEnglish } }; string[,] welshFields = new string[, ] { { "WelshText", CurrentWelsh } }; int translationsWithEnglish = DbCommands.GetCountFromTable("VocabTranslations", "EnglishText = " + DbCommands.GetParameterNameFromValue(CurrentEnglish), CurrentEnglish); int translationsWithWelsh = DbCommands.GetCountFromTable("VocabTranslations", "WelshText = " + DbCommands.GetParameterNameFromValue(CurrentWelsh), CurrentWelsh); if (translationsWithEnglish <= 1 && translationsWithWelsh <= 1) { DbCommands.DeleteTupleInTable("EnglishVocab", englishFields); DbCommands.DeleteTupleInTable("WelshVocab", welshFields); } else if (translationsWithEnglish > 1 && translationsWithWelsh <= 1) { DbCommands.DeleteTupleInTable("VocabTranslations", translationFields); DbCommands.DeleteTupleInTable("WelshVocab", welshFields); } else if (translationsWithEnglish <= 1 && translationsWithWelsh > 1) { DbCommands.DeleteTupleInTable("VocabTranslations", translationFields); DbCommands.DeleteTupleInTable("EnglishVocab", englishFields); } else if (translationsWithEnglish > 1 && translationsWithWelsh > 1) { DbCommands.DeleteTupleInTable("VocabTranslations", translationFields); } Destroy(gameObject); grammarListUI.FillRulesNotSelected(); }
public void SaveEdits() { string[,] fields = new string[, ] { { "DialogueDescriptions", GetInputField().text }, }; DbCommands.UpdateTableTuple("Dialogues", "DialogueIDs = " + myID, fields); print("updated Dialogues tuple"); if (activeToggle.isOn) { DbCommands.InsertTupleToTable("ActivatedDialogues", myID, "-1", "0"); //Puts the dialgoue in activated dialogues under the "New game" save ref. } else { string[,] activeDialoguefields = { { "DialogueIDs", myID }, { "SaveIDs", "-1" } }; DbCommands.DeleteTupleInTable("ActivatedDialogues", activeDialoguefields); //Removes the dialgoue in activated dialogues if it is marked as inactive. } MyDescription = GetInputField().text; StopEditing(); dialogueUI.ToggleSelectionTo(GetComponent <Dialogue>(), dialogueUI.selectedDialogue); }
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" }); }
public void Delete() { string[,] fields = { { "CharacterNames", characterName }, { "Scenes", "null" } }; DbCommands.DeleteTupleInTable("Characters", fields); Destroy(gameObject); }
public void DeleteTaskPartFromDb(string taskPartID) { string[,] fields = { { "PartIDs", taskPartID } }; DbCommands.DeleteTupleInTable("QuestTaskParts", fields); }
public void DeleteTaskResultFromDB(string resultID) { string[,] fields = { { "ResultIDs", resultID } }; DbCommands.DeleteTupleInTable("QuestTaskResults", fields); }