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