private string GetDialogueID(Character character)
{
string qry = "SELECT CharacterDialogues.DialogueIDs FROM CharacterDialogues "
+ "INNER JOIN ActivatedDialogues ON CharacterDialogues.DialogueIDs = ActivatedDialogues.DialogueIDs "
+ "WHERE CharacterDialogues.CharacterNames = " + DbCommands.GetParameterNameFromValue(character.CharacterName)
+ " AND ActivatedDialogues.Completed = 0"
+ " AND ActivatedDialogues.SaveIDs = 0";
string dialogueID = DbCommands.GetFieldValueFromQry(qry, "DialogueIDs", character.CharacterName);
Debugging.PrintDbQryResults(qry, character.CharacterName);
//Debugging.PrintDbTable("ActivatedDialogues");
return(dialogueID);
}
