private void UpdateReadTally() { readTally = int.Parse(DbCommands.GetFieldValueFromTable( "DiscoveredVocab", "ReadCorrectTallies", "SaveIDs = 0 " + "AND EnglishText = " + DbCommands.GetParameterNameFromValue(vocab[0]) + " " + "AND WelshText = " + DbCommands.GetParameterNameFromValue(vocab[1]), vocab[0], vocab[1] )); readTally += tallyModifier; tallyShiftTotal += tallyModifier; if (readTally >= 0) { if (readTally <= highestTallyPossible) { DbCommands.UpdateTableField( "DiscoveredVocab", "ReadCorrectTallies", readTally.ToString(), "SaveIDs = 0 " + "AND EnglishText = " + DbCommands.GetParameterNameFromValue(vocab[0]) + " " + "AND WelshText = " + DbCommands.GetParameterNameFromValue(vocab[1]), vocab[0], vocab[1] ); } } else { readTally = 0; } }
/*player prefs is used to store the selected save id and then the database is accessed to load the saved scene from the * game, other details are loaded using the loadSave function from the Start method. */ public void LoadFromGameID() { print(selectedSave); saveID = selectedSave.ID; print("ready to load game from id: " + saveID); PlayerPrefsManager.SetSaveGame(saveID); string sceneName = DbCommands.GetFieldValueFromTable("PlayerGames", "LocationName", "SaveIDs = " + saveID); sceneLoader.LoadSceneByName(sceneName); }
private bool IsDialogueComplete() { string dialogueComplete = DbCommands.GetFieldValueFromTable("ActivatedDialogues", "Completed", "DialogueIDs = " + currentDialogueID + " AND SaveIDs = 0"); //no character dialogue so return true if (dialogueComplete == "") { return(true); } else { return(Convert.ToBoolean(int.Parse(dialogueComplete))); } }
public void StartNewDialogue(string dialogueID) { //print("ready for new dialogue = " + IsReadyForNewDialogue()); if (IsReadyForNewDialogue()) { currentCharID = DbCommands.GetFieldValueFromTable("CharacterDialogues", "CharacterNames", "DialogueIDs = " + dialogueID); //print("DIALOGUE ID = " + dialogueID); currentChar = npcs.GetCharacterFromName(currentCharID); currentDialogueID = dialogueID; DisplayFirstDialogueNode(); } else { QueueNewDialogue(dialogueID); } }
private string GetSpeakersName(string nodeID) { string overrideName = DbCommands.GetFieldValueFromTable("DialogueNodes", "CharacterSpeaking", "NodeIDs = " + nodeID); if (overrideName == "") { return(currentChar.CharacterName); } else if (overrideName == "!Player") { return(playerCharacter.GetMyName()); } else { return(overrideName); } }
public Transform BuildQuestTask(string[] taskData) { string taskID = taskData[0]; string taskDesc = taskData[1]; print(DbCommands.GetFieldValueFromTable("QuestTasksActivated", "Completed", "TaskIDs = " + taskID + " AND SaveIDs = 0")); bool completed = Convert.ToBoolean(int.Parse(DbCommands.GetFieldValueFromTable("QuestTasksActivated", "Completed", "TaskIDs = " + taskID + " AND SaveIDs = 0"))); GameObject task = Instantiate(taskPrefab, new Vector3(0f, 0f, 0f), Quaternion.identity) as GameObject; //print(quest); if (completed) { task.GetComponent <QuestTask>().SetCompleted(); } task.GetComponent <QuestTask>().SetDescription(taskDesc); task.GetComponent <QuestTask>().MyID = taskID; return(task.transform); }
private void DisplayNodeChoices(string nodeID) { InsertSpacer(); //check if player is node character override, if not then the name can be inserted if (GetSpeakersName(nodeID) != playerCharacter.GetMyName()) { InsertCharName(playerCharacter.GetMyName()); } string nodeChoiceQry = "SELECT * FROM PlayerChoices WHERE NodeIDs = " + nodeID + ";"; AppendDisplayFromDb(nodeChoiceQry, dialogueHolder.transform, BuildPlayerChoice); string displayEndDialogueIndicator = (DbCommands.GetFieldValueFromTable("DialogueNodes", "EndDialogueOption", "DialogueIDs = " + nodeID)); int choicesInt = DbCommands.GetCountFromTable("PlayerChoices", "NodeIDs = " + nodeID); if (displayEndDialogueIndicator == "1" || choicesInt == 0) { InsertEndDialogue(); } }
private void UpdateGrammarTallies() { if (relatedGrammarList != null) { foreach (string[] grammarArray in relatedGrammarList) { int grammarID = int.Parse(grammarArray[0]); int currentTally = int.Parse(DbCommands.GetFieldValueFromTable( "DiscoveredVocabGrammar", "CorrectTallies", "SaveIDs = 0 " + "AND RuleIDs = " + grammarID.ToString() )); currentTally += tallyModifier; tallyShiftTotal += tallyModifier; if (currentTally >= 0) { if (currentTally <= highestTallyPossible) { DbCommands.UpdateTableField( "DiscoveredVocabGrammar", "CorrectTallies", currentTally.ToString(), "SaveIDs = 0 " + "AND RuleIDs = " + grammarID.ToString() ); } } else { currentTally = 0; } if (!grammarDetailsDict.ContainsKey(grammarID)) { string[] details = new string[2]; details[0] = currentTally.ToString(); grammarDetailsDict.Add(grammarID, details); } } } }
private void UpdateWriteTally() { Debug.Log(vocab[0]); Debug.Log(vocab[1]); string tallyStr = (DbCommands.GetFieldValueFromTable( "DiscoveredVocab", "WriteCorrectTallies", "SaveIDs = 0 " + "AND EnglishText = " + DbCommands.GetParameterNameFromValue(vocab[0]) + " " + "AND WelshText = " + DbCommands.GetParameterNameFromValue(vocab[1]), vocab[0], vocab[1] )); Debug.Log(tallyStr); writeTally = int.Parse(tallyStr); writeTally += tallyModifier; tallyShiftTotal += tallyModifier; if (writeTally >= 0) { if (writeTally <= highestTallyPossible) { DbCommands.UpdateTableField( "DiscoveredVocab", "WriteCorrectTallies", writeTally.ToString(), "SaveIDs = 0 " + "AND EnglishText = " + DbCommands.GetParameterNameFromValue(vocab[0]) + " " + "AND WelshText = " + DbCommands.GetParameterNameFromValue(vocab[1]), vocab[0], vocab[1] ); } } else { writeTally = 0; } }
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); } } }