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