public void UpdateInsertNewTextOnlyNode() { if (inputNodeText.text != null) { string endDialogueStr = endDialogueOptionToggle.isOn ? "1" : "0"; SetCharOverrideDetails(); if (editing) { string[,] fieldVals = new string[, ] { { "NodeText", inputNodeText.text }, { "EndDialogueOption", endDialogueStr }, { "CharacterSpeaking", overrideName }, { "Scenes", overrideScene } }; DbCommands.UpdateTableTuple("DialogueNodes", "NodeIDs = " + (dialogueNodesListUI.GetSelectedItemFromGroup(dialogueNodesListUI.SelectedNode) as DialogueNode).MyID, fieldVals); DialogueNodeTextOnly selectedNode = (dialogueNodesListUI.GetSelectedItemFromGroup(dialogueNodesListUI.SelectedNode) as DialogueNode).GetComponent <DialogueNodeTextOnly>(); print(selectedNode); selectedNode.UpdateNodeDisplay(inputNodeText.text); } else { string nodeID = DbCommands.GenerateUniqueID("DialogueNodes", "NodeIDs", "NodeID"); InsertDialogueNode(inputNodeText.text, nodeID, endDialogueStr); dialogueNodesListUI.DisplayNodesRelatedToDialogue(); playerChoicesListUI.HidePlayerChoices(); } } }
public void InsertChoice() { string choiceID = DbCommands.GenerateUniqueID("PlayerChoices", "ChoiceIDs", "ChoiceID"); playerChoiceDetailsUI.InsertPlayerChoice(english, choiceID); InsertNewPlayerChoiceVocabTest(choiceID); playerChoiceListUI.DisplayChoicesRelatedToNode(); }
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 InsertNode() { string nodeID = DbCommands.GenerateUniqueID("DialogueNodes", "NodeIDs", "NodeID"); string endDialogueStr = dialogueNodeDetailsUI.EndDialogueOptionToggle.isOn ? "1" : "0"; dialogueNodeDetailsUI.SetCharOverrideDetails(); dialogueNodeDetailsUI.InsertDialogueNode(english, nodeID, endDialogueStr); InsertNewDialogueNodeVocabTest(nodeID); dialogueNodesListUI.DisplayNodesRelatedToDialogue(); }
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 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 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 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); }
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(); } }
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 UpdateInsertNewTextOnlyPlayerChoice() { if (inputChoiceText.text != null) { if (editingChoice) { string[,] fieldVals = new string[, ] { { "ChoiceText", inputChoiceText.text }, }; DbCommands.UpdateTableTuple("PlayerChoices", "ChoiceIDs = " + (playerChoicesListUI.GetSelectedItemFromGroup(playerChoicesListUI.SelectedChoice) as PlayerChoice).MyID, fieldVals); PlayerChoiceTextOnly selectedPlayerChoice = (playerChoicesListUI.GetSelectedItemFromGroup(playerChoicesListUI.SelectedChoice) as PlayerChoice).GetComponent <PlayerChoiceTextOnly>(); selectedPlayerChoice.UpdateChoiceDisplay(inputChoiceText.text); } else { string choiceID = DbCommands.GenerateUniqueID("PlayerChoices", "ChoiceIDs", "ChoiceID"); InsertPlayerChoice(inputChoiceText.text, choiceID); playerChoicesListUI.DisplayChoicesRelatedToNode(); } } }
public void UpdateInsertRule() { if ((inputRuleSdescTxt.text != null) && (inputRuleSdescTxt.text != "")) { if (editingRule) { string[,] fieldVals = new string[, ] { { "ShortDescriptions", inputRuleSdescTxt.text }, { "LongDescriptions", inputRuleLdescTxt.text }, }; GrammarRule selectedRule = (GrammarRule)(GetSelectedItemFromGroup(selectedGrammarRule)); DbCommands.UpdateTableTuple("VocabGrammar", "RuleIDs = " + selectedRule.RuleNumber, fieldVals); selectedRule.UpdateRuleDisplay(inputRuleSdescTxt.text); } else { string ruleID = DbCommands.GenerateUniqueID("VocabGrammar", "RuleIDs", "RuleID"); DbCommands.InsertTupleToTable("VocabGrammar", ruleID, inputRuleSdescTxt.text, inputRuleLdescTxt.text); FillDisplayFromDb(DbQueries.GetGrammarRuleDisplayQry(), grammarList.transform, BuildRule); } } }
public void SaveNew() { SkillsMenuUI skillsMenuUI = FindObjectOfType <SkillsMenuUI>(); SetSaveID(DbCommands.GenerateUniqueID("PlayerGames", "SaveIDs", "SaveID")); string saveRef = FindObjectOfType <GameMenuUI>().transform .Find("Panel") .Find("SaveGameUI") .Find("SaveInput").GetComponent <InputField>().text; if (saveRef != "") { DbCommands.InsertTupleToTable("PlayerGames", saveID.ToString(), saveRef, playerName, playerPortraitPath, DateTime.Now.ToString(), sceneLoader.GetCurrentSceneName(), player.GetComponent <Transform>().position.x.ToString(), player.GetComponent <Transform>().position.y.ToString(), skillsMenuUI.GetSkillPointsSpent().ToString()); } }
protected void InsertNewPlayerChoiceResultID() { playerChoiceResultID = DbCommands.GenerateUniqueID("PlayerChoiceResults", "ResultIDs", "ResultID"); DbCommands.InsertTupleToTable("PlayerChoiceResults", playerChoiceResultID, PlayerChoiceID); }