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