private void CompleteApplicableTaskParts() { DbCommands.GetDataStringsFromQry( "SELECT QuestTaskPartsActivateDialogueNode.PartIDs, QuestTaskParts.TaskIDs, QuestsActivated.QuestNames " + "FROM QuestTaskPartsActivateDialogueNode " + "INNER JOIN QuestTaskParts ON QuestTaskParts.PartIDs = QuestTaskPartsActivateDialogueNode.PartIDs " + "INNER JOIN QuestTasks ON QuestTasks.TaskIDs = QuestTaskParts.TaskIDs " + "INNER JOIN QuestsActivated ON QuestTasks.QuestNames = QuestsActivated.QuestNames " + "WHERE NodeIDs = " + myID + " " + "AND QuestsActivated.SaveIDs = 0 " + "AND QuestTaskPartsActivateDialogueNode.PartIDs NOT IN (SELECT CompletedQuestTaskParts.PartIDs FROM CompletedQuestTaskParts WHERE CompletedQuestTaskParts.SaveIDs = 0);", out nodeCompletePartList); foreach (string[] partTuple in nodeCompletePartList) { questsUI.CompleteTaskPart(partTuple[0], partTuple[1], partTuple[2]); } }
public void SetQuestTaskPartComplete() { print(questsUI); questsUI.CompleteTaskPart(partID, taskID, questName); }