public void ActivateQuestTasks(string choiceID)
{
QuestsController questsController = FindObjectOfType <QuestsController>();
int countTaskActivateResults = DbCommands.GetCountFromQry(DbQueries.GetTaskActivateCountFromChoiceIDqry(choiceID));
if (countTaskActivateResults > 0)
{
print("Task ACTIVATING!!!!");
List <string[]> tasksActivatedList;
DbCommands.GetDataStringsFromQry(DbQueries.GetCurrentActivateTasksPlayerChoiceResultQry(choiceID), out tasksActivatedList);
foreach (string[] activatedTask in tasksActivatedList)
{
questsUI.InsertActivatedTask(activatedTask[1], activatedTask[3], activatedTask[2]);
//a list of task parts in task that are prefab types are iterated over (if any) and instantiated.
List <string[]> prefabParts = new List <string[]>();
DbCommands.GetDataStringsFromQry(DbQueries.GetPrefabTaskPartsFromTaskIDqry(activatedTask[1]), out prefabParts);
foreach (string[] prefabPart in prefabParts)
{
string prefabPath = prefabPart[0];
string partID = prefabPart[1];
UnityEngine.Object prefabTaskPartObj = Resources.Load(prefabPath);
print(prefabPath);
GameObject prefabTaskPart = Instantiate(prefabTaskPartObj, new Vector2(0f, 0f), Quaternion.identity) as GameObject;
prefabTaskPart.GetComponent <QuestTaskPart>().InitialiseMe(partID, activatedTask[1], activatedTask[3]);
prefabTaskPart.transform.SetParent(questsController.transform, false);
}
}
}
}
public void ActivateNewVocab(string choiceID)
{
int countVocabActivateResults = DbCommands.GetCountFromQry(DbQueries.GetVocabActivateCountFromChoiceIDqry(choiceID));
if (countVocabActivateResults > 0)
{
print("Vocab ACTIVATING!!!!");
List <string[]> vocabActivatedList;
DbCommands.GetDataStringsFromQry(DbQueries.GetCurrentActivateVocabPlayerChoiceResultQry(choiceID), out vocabActivatedList);
foreach (string[] activatedVocab in vocabActivatedList)
{
newWelshLearnedUI.InsertDiscoveredVocab(activatedVocab[2], activatedVocab[3]);
}
}
}
public void ActivateNewGrammar(string choiceID)
{
int countGrammarActivateResults = DbCommands.GetCountFromQry(DbQueries.GetGrammarActivateCountFromChoiceIDqry(choiceID));
if (countGrammarActivateResults > 0)
{
print("Grammar ACTIVATING!!!!");
List <string[]> grammarActivatedList;
DbCommands.GetDataStringsFromQry(DbQueries.GetCurrentActivateGrammarPlayerChoiceResultQry(choiceID), out grammarActivatedList);
foreach (string[] activatedGrammar in grammarActivatedList)
{
newWelshLearnedUI.InsertDiscoveredGrammar(activatedGrammar[1]);
}
}
}
public void ActivateQuests(string choiceID)
{
int countQuestActivateResults = DbCommands.GetCountFromQry(DbQueries.GetQuestActivateCountFromChoiceIDqry(choiceID));
print(countQuestActivateResults);
if (countQuestActivateResults > 0)
{
List <string[]> questsActivatedList;
DbCommands.GetDataStringsFromQry(DbQueries.GetCurrentActivateQuestsPlayerChoiceResultQry(choiceID), out questsActivatedList);
print(questsActivatedList.Count);
foreach (string[] activatedQuest in questsActivatedList)
{
questsUI.InsertActivatedQuest(activatedQuest[1]);
}
}
}
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 ActivateNewDialogue(string choiceID)
{
Debugging.PrintDbTable("ActivatedDialogues");
int countDialogueActivateResults = DbCommands.GetCountFromQry(DbQueries.GetDialogueActivateCountFromChoiceIDqry(choiceID));
if (countDialogueActivateResults > 0)
{
print("Dialogue ACTIVATING!!!!");
List <string[]> dialogueActivatedList;
DbCommands.GetDataStringsFromQry(DbQueries.GetCurrentActivateDialoguePlayerChoiceResultQry(choiceID), out dialogueActivatedList);
foreach (string[] activatedDialogue in dialogueActivatedList)
{
//get characters related to activated dialogue. Set active dialogues related to each character to completed
List <string[]> charactersRelatedToDialogue;
DbCommands.GetDataStringsFromQry(DbQueries.GetCharsRelatedToDialogue(activatedDialogue[1]), out charactersRelatedToDialogue);
foreach (string[] characterName in charactersRelatedToDialogue)
{
List <string[]> activeDialoguesWithCharacter;
string charname = characterName[0];
DbCommands.GetDataStringsFromQry(DbQueries.GetActiveDialoguesWithCharacter(charname), out activeDialoguesWithCharacter, characterName[0]);
foreach (string[] dialogueWithChar in activeDialoguesWithCharacter)
{
string dialogueID = dialogueWithChar[0];
print("printing active dialogues with " + charname);
Debugging.PrintDbQryResults(DbQueries.GetActiveDialoguesWithCharacter(charname), charname);
DbCommands.UpdateTableField("ActivatedDialogues", "Completed", "1", "DialogueIDs = " + dialogueID + " AND SaveIDs = 0");
Debugging.PrintDbTable("ActivatedDialogues");
}
}
DbCommands.InsertTupleToTable("ActivatedDialogues", activatedDialogue[1], "0", "0");
//activate dialogues in dialogue activated list
}
}
}
public void DisplayResultsRelatedToChoices()
{
playerChoiceResultsPanel.SetActive(true);
EmptyDisplay(playerChoicesResultsList.transform);
print(playerChoicesListUI);
playerChoicesListUI = FindObjectOfType <PlayerChoicesListUI>();
string selectedChoiceID = (playerChoicesListUI.GetSelectedItemFromGroup(playerChoicesListUI.SelectedChoice) as PlayerChoice).MyID;
if (DbCommands.GetFieldValueFromTable("PlayerChoices", "MarkDialogueCompleted", " ChoiceIDs = " + selectedChoiceID) != "0")
{
AppendDisplayFromDb((DbQueries.GetChoiceCompleteDialogueQry(selectedChoiceID)), playerChoicesResultsList.transform, BuildExistingResultCompleteDialogue);
}
if (DbCommands.GetFieldValueFromTable("PlayerChoices", "NextNodes", " ChoiceIDs = " + selectedChoiceID) != "")
{
GameObject pChoiceResultsTitle = Instantiate(existingResultTitlePrefab, new Vector2(0f, 0f), Quaternion.identity) as GameObject;
AppendDisplayWithTitle(playerChoicesResultsList.transform, pChoiceResultsTitle.transform, "Goes to dialogue node... ");
PlayerChoice currentPlayerChoice = playerChoicesListUI.GetSelectedItemFromGroup(playerChoicesListUI.SelectedChoice) as PlayerChoice;
AppendDisplayFromDb(DbQueries.GetNextNodeResultQry(currentPlayerChoice.MyNextNode), playerChoicesResultsList.transform, BuildExistingResultNode);
}
int resultsCount = DbCommands.GetCountFromTable("PlayerChoiceResults", "ChoiceIDs = " + selectedChoiceID);
if (resultsCount > 0)
{
int questActivateCount = DbCommands.GetCountFromQry(DbQueries.GetQuestActivateCountFromChoiceIDqry(selectedChoiceID));
if (questActivateCount > 0)
{
GameObject existingResultsTitle = Instantiate(existingResultTitlePrefab, new Vector2(0f, 0f), Quaternion.identity) as GameObject;
AppendDisplayWithTitle(playerChoicesResultsList.transform, existingResultsTitle.transform, "Activates quest... ");
AppendDisplayFromDb(DbQueries.GetCurrentActivateQuestsPlayerChoiceResultQry(selectedChoiceID),
playerChoicesResultsList.transform,
BuildExistingResultActivateQuest);
}
int taskActivateCount = DbCommands.GetCountFromQry(DbQueries.GetTaskActivateCountFromChoiceIDqry(selectedChoiceID));
if (taskActivateCount > 0)
{
GameObject existingResultsTitle = Instantiate(existingResultTitlePrefab, new Vector2(0f, 0f), Quaternion.identity) as GameObject;
AppendDisplayWithTitle(playerChoicesResultsList.transform, existingResultsTitle.transform, "Activates tasks... ");
AppendDisplayFromDb(DbQueries.GetCurrentActivateTasksPlayerChoiceResultQry(selectedChoiceID),
playerChoicesResultsList.transform,
BuildExistingResultActivateTask);
}
int taskCompleteCount = DbCommands.GetCountFromQry(DbQueries.GetTaskCompleteCountFromChoiceIDqry(selectedChoiceID));
if (taskCompleteCount > 0)
{
GameObject existingResultsTitle = Instantiate(existingResultTitlePrefab, new Vector2(0f, 0f), Quaternion.identity) as GameObject;
AppendDisplayWithTitle(playerChoicesResultsList.transform, existingResultsTitle.transform, "Completes tasks... ");
AppendDisplayFromDb(DbQueries.GetCurrentCompleteTasksPlayerChoiceResultQry(selectedChoiceID),
playerChoicesResultsList.transform,
BuildExistingResultCompleteTask);
}
int grammarActivateCount = DbCommands.GetCountFromQry(DbQueries.GetGrammarActivateCountFromChoiceIDqry(selectedChoiceID));
if (grammarActivateCount > 0)
{
GameObject existingResultsTitle = Instantiate(existingResultTitlePrefab, new Vector2(0f, 0f), Quaternion.identity) as GameObject;
AppendDisplayWithTitle(playerChoicesResultsList.transform, existingResultsTitle.transform, "Activates new grammar... ");
AppendDisplayFromDb(DbQueries.GetCurrentActivateGrammarPlayerChoiceResultQry(selectedChoiceID),
playerChoicesResultsList.transform,
BuildExistingResultActivateGrammar);
}
int vocabActivateCount = DbCommands.GetCountFromQry(DbQueries.GetVocabActivateCountFromChoiceIDqry(selectedChoiceID));
if (vocabActivateCount > 0)
{
GameObject existingResultsTitle = Instantiate(existingResultTitlePrefab, new Vector2(0f, 0f), Quaternion.identity) as GameObject;
AppendDisplayWithTitle(playerChoicesResultsList.transform, existingResultsTitle.transform, "Activates new vocab... ");
AppendDisplayFromDb(DbQueries.GetCurrentActivateVocabPlayerChoiceResultQry(selectedChoiceID),
playerChoicesResultsList.transform,
BuildExistingResultActivateVocab);
}
int dialogueActivateCount = DbCommands.GetCountFromQry(DbQueries.GetDialogueActivateCountFromChoiceIDqry(selectedChoiceID));
if (dialogueActivateCount > 0)
{
GameObject existingResultsTitle = Instantiate(existingResultTitlePrefab, new Vector2(0f, 0f), Quaternion.identity) as GameObject;
AppendDisplayWithTitle(playerChoicesResultsList.transform, existingResultsTitle.transform, "Activates new dialogue(s)... ");
AppendDisplayFromDb(DbQueries.GetCurrentActivateDialoguePlayerChoiceResultQry(selectedChoiceID),
playerChoicesResultsList.transform,
BuildExistingResultActivateDialogue);
}
}
}
