public override void InsertResult() { InsertNewPlayerChoiceResultID(); DbCommands.InsertTupleToTable("WelshVocabActivatedByDialogueChoices", playerChoiceResultID, PlayerChoiceID, englishText, welshText); dialogueUI.DisplayResultsRelatedToChoices(); dialogueUI.DeactivateNewChoiceResult(); }
private void InsertQuest() { DbCommands.InsertTupleToTable("Quests", inputQuestDetailsName.text, inputQuestDetailsDesc.text); FillDisplayFromDb(DbQueries.GetQuestsDisplayQry(), questsList.transform, BuildQuest); }
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 } } }
public override void InsertResult() { InsertNewPlayerChoiceResultID(); DbCommands.InsertTupleToTable("DialoguesActivatedByDialogueChoices", playerChoiceResultID, PlayerChoiceID, dialogueID); dialogueUI.DisplayResultsRelatedToChoices(); dialogueUI.DeactivateNewChoiceResult(); }
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 InsertNewCharLink() { DbCommands.InsertTupleToTable("CharacterDialogues", selectedCharLink.GetComponent <AddCharDialogueBtn>().CharacterName, selectedCharLink.GetComponent <AddCharDialogueBtn>().SceneName, (GetSelectedItemFromGroup(selectedDialogue) as Dialogue).MyID); }
//protected void OnMouseUpAsButton() { // InsertChoice(); //} protected void InsertNewPlayerChoiceVocabTest(string choiceID) { DbCommands.InsertTupleToTable("PlayerChoicesVocabTests", choiceID, english, welsh); playerChoiceDetailsUI.DeactivateChoiceDetails(); }
//protected void OnMouseUpAsButton() { // InsertChoice(); //} protected void InsertNewDialogueNodeVocabTest(string nodeID) { DbCommands.InsertTupleToTable("DialogueNodesVocabTests", nodeID, english, welsh); dialogueNodeDetailsUI.DeactivateNodeDetails(); }
public void InsertPart(string partID) { string currentTaskID = (questsUI.GetSelectedItemFromGroup(questsUI.selectedTask) as Task).MyID; DbCommands.InsertTupleToTable("QuestTaskParts", partID, currentTaskID ); }
public void InsertPlayerChoice(string choiceText, string choiceID) { DbCommands.InsertTupleToTable("PlayerChoices", choiceID, choiceText, (dialogueNodesListUI.GetSelectedItemFromGroup(dialogueNodesListUI.SelectedNode) as DialogueNode).MyID, null, "0"); }
public void UpdateTranslation() { string newEn = englishText.GetComponent <InputField>().text; string newCy = welshText.GetComponent <InputField>().text; /* We need to check if we are updating a value with more than one entry in translations. If so, a new value needs to be inserted * to English / Welsh tables to avoid changing all of the translation entry values to the same value. This results in the translation * needing to be updated rather than the English / Welsh as would otherwise be updated and the update cascaded.*/ if (DbCommands.GetCountFromTable("VocabTranslations", "EnglishText = " + DbCommands.GetParameterNameFromValue(CurrentEnglish), CurrentEnglish) > 1) { DbCommands.InsertTupleToTable("EnglishVocab", newEn); DbCommands.UpdateTableField("VocabTranslations", "EnglishText", newEn, "EnglishText = " + DbCommands.GetParameterNameFromValue(CurrentEnglish) + " AND " + "WelshText = " + DbCommands.GetParameterNameFromValue(CurrentWelsh), CurrentEnglish, CurrentWelsh); } else { print("Updating English tbl"); DbCommands.UpdateTableField("EnglishVocab", "EnglishText", newEn, "EnglishText = " + DbCommands.GetParameterNameFromValue(CurrentEnglish), CurrentEnglish); print("success"); } if (DbCommands.GetCountFromTable("VocabTranslations", "WelshText = " + DbCommands.GetParameterNameFromValue(CurrentWelsh), CurrentWelsh) > 1) { DbCommands.InsertTupleToTable("Welsh", newCy); DbCommands.UpdateTableField("VocabTranslations", "WelshText", newCy, "EnglishText = " + DbCommands.GetParameterNameFromValue(newEn) + " AND " + //newEn must be used since it will have been update before, rather than simultaneously. "WelshText = " + DbCommands.GetParameterNameFromValue(CurrentWelsh), CurrentEnglish, CurrentWelsh); } else { DbCommands.UpdateTableField("WelshVocab", "WelshText", newCy, "WelshText = " + DbCommands.GetParameterNameFromValue(CurrentWelsh), CurrentWelsh); } CurrentEnglish = newEn; CurrentWelsh = newCy; grammarListUI.FillRulesNotSelected(); }
/// <summary> /// Inserts any character in the scene that is not yet in the characters table. /// </summary> private void InsertCharsNotInDbFromScene(string currentScene) { NPCs npcs = FindObjectOfType <NPCs>(); foreach (string npcName in npcs.GetCharNamesList()) { DbCommands.InsertTupleToTable("Characters", npcName, currentScene); } }
public override void InsertResult() { string newResultID = DbCommands.GenerateUniqueID("PlayerChoiceResults", "ResultIDs", "ResultID"); DbCommands.InsertTupleToTable("PlayerChoiceResults", newResultID, PlayerChoiceID); DbCommands.InsertTupleToTable("TasksActivatedByDialogueChoices", newResultID, PlayerChoiceID, taskID); dialogueUI.DisplayResultsRelatedToChoices(); dialogueUI.DeactivateNewChoiceResult(); }
public void InsertTaskResult(string resultID) { string currentTaskID = (GetSelectedItemFromGroup(selectedTask) as Task).MyID; DbCommands.InsertTupleToTable("QuestTaskResults", resultID, currentTaskID ); }
public void InsertActivateQuestResult(string questName) { string playerChoiceID = (playerChoicesListUI.GetSelectedItemFromGroup(playerChoicesListUI.SelectedChoice) as PlayerChoice).MyID; string newResultID = DbCommands.GenerateUniqueID("PlayerChoiceResults", "ResultIDs", "ResultID"); DbCommands.InsertTupleToTable("PlayerChoiceResults", newResultID, playerChoiceID); DbCommands.InsertTupleToTable("QuestActivateResults", newResultID, playerChoiceID, questName); DisplayResultsRelatedToChoices(); DeactivateNewChoiceResult(); }
public void InsertProficiency() { if ((inputProficiencyTxt.text != null) && (inputProficiencyTxt.text != "")) { DbCommands.InsertTupleToTable("Proficiencies", inputProficiencyTxt.text, inputThresholdTxt.text); FillDisplayFromDb(DbQueries.GetProficienciesDisplayQry(), proficienciesList.transform, BuildProficiency); inputProficiencyTxt.text = ""; inputThresholdTxt.text = ""; } }
public void InsertDialogueNode(string nodeText, string nodeID, string endDialogueStr) { DbCommands.InsertTupleToTable("DialogueNodes", nodeID, nodeText, (dialogueUI.GetSelectedItemFromGroup(dialogueUI.selectedDialogue) as Dialogue).MyID, overrideName, overrideScene, endDialogueStr); }
public void InsertTranslation() { DbCommands.InsertTupleToTable("EnglishVocab", inputTranslationEnTxt.text); DbCommands.InsertTupleToTable("WelshVocab", inputTranslationCyTxt.text); DbCommands.InsertTupleToTable("VocabTranslations", inputTranslationEnTxt.text, inputTranslationCyTxt.text); FillDisplayFromDb(vocabListInfo.GetMyDefaultQuery(), vocabTranslationList.transform, vocabListInfo.GetMyBuildMethod()); searchTranslations.text = inputTranslationEnTxt.text; GetComponentInChildren <ListSearcher>().Search(); inputTranslationEnTxt.text = ""; inputTranslationCyTxt.text = ""; }
public void InsertPartEquipItem(string itemName) { string currentTaskID = (questsUI.GetSelectedItemFromGroup(questsUI.selectedTask) as Task).MyID; string partID = DbCommands.GenerateUniqueID("QuestTaskParts", "PartIDs", "PartID"); InsertPart(partID); DbCommands.InsertTupleToTable("QuestTaskPartsEquipItem", itemName, partID ); DisplayPartsRelatedToTask(currentTaskID); }
public void InsertMe() { string currentTaskID = FindObjectOfType <QuestsUI>().GetCurrentTaskID(); string partID = DbCommands.GenerateUniqueID("QuestTaskParts", "PartIDs", "PartID"); taskPartsListUI.InsertPart(partID); DbCommands.InsertTupleToTable("QuestTaskPartsCompleteQuest", myQuestName, partID ); taskPartsListUI.DisplayPartsRelatedToTask(currentTaskID); taskPartsListUI.HideNewPartPanel(); }
public void InsertActivatedQuest(string questName) { DbCommands.InsertTupleToTable("QuestsActivated", questName, "0", "0"); notificationQueue.QueueNewQuestNotifier(questName); string[] questData = new string[3]; questData[0] = questName; questData[1] = "0"; //current game questData[2] = "0"; //uncompleted GameObject newQuest = BuildQuest(questData).gameObject; newQuest.transform.SetParent(questsList.transform, false); AddQuestToDictionary(newQuest); }
public void InsertToRuleList() { Translation currentTranslation = (Translation)vocabTranslationListUI.GetSelectedItemFromGroup(vocabTranslationListUI.VocabTranslationSelected); string english = currentTranslation.CurrentEnglish; string welsh = currentTranslation.CurrentWelsh; DbCommands.InsertTupleToTable("VocabRuleList", english, welsh, ruleNumber); addRuleBtn.GetComponent <Text>().text = "Remove"; Image btnImg = gameObject.transform.Find("DescriptionInput").GetComponent <Image>(); btnImg.color = Color.green; IsAssignedToSelectedTranslation = true; }
public void InsertToTagList() { print(vocabTranslationListUI); Translation currentTranslation = (Translation)vocabTranslationListUI.GetSelectedItemFromGroup(vocabTranslationListUI.VocabTranslationSelected); string welsh = currentTranslation.CurrentWelsh; string english = currentTranslation.CurrentEnglish; DbCommands.InsertTupleToTable("VocabTagged", tagText, english, welsh); addTagBtn.GetComponent <Text>().text = "Remove"; Image btnImg = textInput.GetComponent <Image>(); btnImg.color = Color.green; IsAssignedToSelectedTranslation = true; }
public void InsertTaskResultActivateDialogue(string dialogueID) { string resultID = DbCommands.GenerateUniqueID("QuestTaskResults", "ResultIDs", "ResultID"); InsertTaskResult(resultID); string currentTaskID = (GetSelectedItemFromGroup(selectedTask) as Task).MyID; DbCommands.InsertTupleToTable("QuestTaskActivateDialogueResults", resultID, currentTaskID, dialogueID ); DisplayResultsRelatedToTaskCompletion(currentTaskID); HideNewTaskResultPanel(); }
public void InsertNewDialogue() { if ((inputShortDescriptionText.text != null) && (inputShortDescriptionText.text != "")) { string dialogueID = DbCommands.GenerateUniqueID("Dialogues", "DialogueIDs", "DialogueID"); DbCommands.InsertTupleToTable("Dialogues", dialogueID, inputShortDescriptionText.text); if (dialogueActive.isOn) { DbCommands.InsertTupleToTable("ActivatedDialogues", dialogueID, "0", "0"); //Puts the dialgoue in activated dialogues under the "New game" save ref as uncompleted. } FillDisplayFromDb(DbQueries.GetDialogueDisplayQry(), dialogueList.transform, BuildDialogue); HideCharsRelatedToDialogue(); HideNodesRelatedToDialogue(); } }
public void InsertTask() { string currentQuestName = (GetSelectedItemFromGroup(selectedQuest) as Quest).MyName; string taskID = DbCommands.GenerateUniqueID("QuestTasks", "TaskIDs", "TaskID"); DbCommands.InsertTupleToTable("QuestTasks", taskID, inputTaskDescription.text, currentQuestName); if (taskActiveAtStart.isOn) { DbCommands.InsertTupleToTable("QuestTasksActivated", taskID, "-1", "0"); } DisplayTasksRelatedToDialogue(currentQuestName); }
void OnMouseUpAsButton() { Debugging.PrintDbTable("QuestTaskEndCombatWithCharResults"); string resultID = DbCommands.GenerateUniqueID("QuestTaskResults", "ResultIDs", "ResultID"); questsUI.InsertTaskResult(resultID); string selectedTaskID = (questsUI.GetSelectedItemFromGroup(questsUI.selectedTask) as Task).MyID; DbCommands.InsertTupleToTable("QuestTaskEndCombatWithCharResults", resultID, selectedTaskID, characterName, scene ); questsUI.DisplayResultsRelatedToTaskCompletion(selectedTaskID); questsUI.HideNewTaskResultPanel(); }
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 CompleteTaskPart(string partID, string taskID, string questName) { DbCommands.InsertTupleToTable("CompletedQuestTaskParts", partID, "0"); //print("inserted tuple to completed task parts"); int taskPartsCount = DbCommands.GetCountFromTable("QuestTaskParts", "TaskIDs = " + taskID); //print("task parts with id " + taskID + " = " + taskPartsCount); int taskPartsCompletedCount = DbCommands.GetCountFromQry(DbQueries.GetTaskPartsCompleteFromTaskID(taskID, "0")); //print("task parts completed with id " + taskID + " = " + taskPartsCompletedCount); //Debugging.PrintDbTable("CompletedQuestTaskParts"); if (taskPartsCount == taskPartsCompletedCount) { DbCommands.UpdateTableField("QuestTasksActivated", "Completed", "1", "TaskIDs = " + taskID + " AND SaveIDs = 0"); int tasksCount = DbCommands.GetCountFromTable( "QuestTasks", "QuestNames = " + DbCommands.GetParameterNameFromValue(questName), questName); string[] taskResults = DbCommands.GetTupleFromQry(DbQueries.GetAllTaskResultsQry(taskID)); //string startDialogueID = DbCommands.GetFieldValueFromTable("QuestTaskStartDialogueResults", "DialogueIDs", "TaskIDs = " + taskID); string endCombatWithCharName = taskResults[0]; string startDialogueID = taskResults[1]; if (endCombatWithCharName != "") { combatUI.EndCombatWithCharacter(endCombatWithCharName); } if (startDialogueID != "") { print(startDialogueID); DbCommands.InsertTupleToTable("ActivatedDialogues", startDialogueID, "0", "0"); dialogueUI.StartNewDialogue(startDialogueID); } int tasksCompletedCount = DbCommands.GetCountFromQry( DbQueries.GetTasksCompleteFromQuestName(questName, "0"), questName); if (tasksCount == tasksCompletedCount) { DbCommands.UpdateTableField("QuestsActivated", "Completed", "1", "SaveIDs = 0 AND QuestNames = " + DbCommands.GetParameterNameFromValue(questName), questName); } } SetQuestDetails(questName); }
public void UpdateInsertTag() { if (tagDetailsInput.text != null) { if (editingTag) { string[,] fieldVals = new string[, ] { { "Tags", tagDetailsInput.text }, }; TranslationTag tt = GetSelectedItemFromGroup(SelectedTag) as TranslationTag; string tagTxt = tt.GetComponent <TranslationTag>().TagText; DbCommands.UpdateTableTuple("TranslationTags", "Tags = " + DbCommands.GetParameterNameFromValue(tagTxt), fieldVals, tagTxt); tt.GetComponent <TranslationTag>().UpdateTagDisplay(tagDetailsInput.text); } else { DbCommands.InsertTupleToTable("TranslationTags", tagDetailsInput.text); FillDisplayFromDb(DbQueries.GetTaggedVocabDisplayQry(), tagsList.transform, BuildTag); } } }