11 réponses à ce sujet

[huldu]

Is there any way to search *all* conversations for specific phrases? It seems I have to open one by one and do a search in that conversation which is very time consuming. There has to be a way to search for a phrase in all of the conversations, right?

[Mike3207]

I think you can only search by the first phrase, and go through all of them. i don't think it has a proper search function, but things may be different on PC.

[huldu]

Yeah, it seems very hard to look for specific phrases said by a character when you have no idea in what dialog they are in.

[theskymoves]

Yeah, it seems very hard to look for specific phrases said by a character when you have no idea in what dialog they are in.

 

I've poked a bunch at the dialogue files in the toolset putting together a modder's resource spreadsheet of every line of dialogue uttered by Alistair, and I never found any way to do a global search of the contents of all DLG files. There's a way to search file names in the assets palette, and a way to search within an individual dialogue file, but if it is possible search across all or multiple files, it's very elusive.

[huldu]

Yeah, it's really hard to find some phrases and some just elude me completely. I've spent hours going through the files and still haven't found where some phrases are even mentioned. Maybe there is a way to do this using another sql viewer, to view the database?

[theskymoves]

Yeah, it's really hard to find some phrases and some just elude me completely. I've spent hours going through the files and still haven't found where some phrases are even mentioned. Maybe there is a way to do this using another sql viewer, to view the database?

 

Hmmm. Depending on what you are looking for, there might not be a DLG for it in the toolset. Fer instance, off the top of my head, the DLG that is supposed to hold the Rumor Man dialogue (from Bodahn and the bartenders who so cleverly speak with his voice) is empty. 

[Sunjammer]

You can query the database: all you need is SSMSE (SQL Server Management Studio Express) and a query like this:

SELECT     m.Name AS Module, mrrv.Name AS Conversation, cl.TextStringID AS StringId, st.Text
FROM         t_Conversation AS c INNER JOIN
                      t_ConversationLine AS cl ON c.ModuleResRefVersionID = cl.ModuleResRefVersionID INNER JOIN
                      t_ModuleResRefVersion AS mrrv ON c.ModuleResRefVersionID = mrrv.ID INNER JOIN
                      t_Module AS m ON mrrv.OwnerModuleID = m.ID INNER JOIN
                      t_StringText AS st ON cl.TextStringID = st.StringID
WHERE     (st.Text LIKE '%help me%')

Which will produce results like:



Man, 220 conversation lines containing "help me" ... who knew the people of Ferelden were quite so needy?

[Yara C.]

In case SSME is not installed - the string editor (menu tools) supports a search by filters.

 

 

The use of an apostrophe should be avoided because it will be misinterpreted and lead to no matches. Additional filters can be added to refine the search.

[Sunjammer]

Try doubling up apostrophes as that is what you'd (you''d) do in a query.

[Yara C.]

Yeah, you are right, Sunjammer. The reason was clear. But somehow didn´t thought of that.

[theskymoves]

In case SSME is not installed - the string editor (menu tools) supports a search by filters.

 

 

The use of an apostrophe should be avoided because it will be misinterpreted and lead to no matches. Additional filters can be added to refine the search.

 

Maker... where was this when I was going through every single DLG file? *kills self repeatedly*

[huldu]

Holy cow... that is exactly what I was looking for! Thank you so much! Finally being able to search all the files for specific phrases instead of going through one by one.