Quest 541 missing text..

It is the normal greeting text that is at fault here.

The creature: High Executor Darthalia, is linked to the Missing US Text in the npc_text table. This is the only entry in that table for Darthalia, so it needs to be replaced with the correct text, unlike a previous issue, which had 2 entries for the creature: [url]https://www.getmangos.eu/issue.php?issueid=522[/url]

I'll see if I can locate the correct text.

EDIT: Unable to locate the text, other than what they have on the private server: TrueWoW
[IMG]http://s17.postimg.org/qklbdcwtb/High_Executionor_Darthalia.jpg[/IMG]

I'll PR a fix that includes that text - "Greetings "

UPDATE npc_text SET `text0_0`='Greetings $N' WHERE `ID`='16667';

Pull Request has now been made with the above fix :)

[SIZE=3][COLOR="#800080"][B]This thread can be closed[/B][/COLOR][/SIZE] or NOT

I believe she says other things when not on that quest, though I may be wrong. I will do some research today and see what I can find.

[quote=Xenithar]I believe she says other things when not on that quest, though I may be wrong. I will do some research today and see what I can find.[/quote]

I'm pretty certain you are right. The text TrueWow is using is the same as the guards in the area. Very likely that she would say more than a simple greeting :)

Good luck :)

I cannot seem to find anything on her. She was added in 1.10 or 1.11 if my memory serves me, but I cannot remember what she said. This is a suitable temporary fix however.

I just pulled your fix down. She still says "Missing US Text". Something is odd here. I just cloned the DB and server, built the server, updated my DB, and still this. Your fix has been applied.

That's odd, because the fix overwrites that text, and I tested it in game. I'll clone the DB and take a look.

That's odd, because the fix overwrites that text, and I tested it in-game. I'll clone the DB and take a look.

EDIT: Nuts, that did not fix it. Odd, I could have sworn I checked in-game; very unusual for me not to.
Plus, the relevant tables and records used are correct, at least as far as normal chat/gossip is concerned.

Balls!

EDIT again: This is really weird; I changed all the fields that have "Missing US text" to Chuck_01, 02, 03, etc. and still the little says "Missing US text" !!!!
Gonna check the server core for that text.

Ahhhhhh, not there, ahhhhhhhhh, but it's not searching all the files in VS. Gonna use grep on my Linux machine to search for the text in all files. It makes more sense that it is in the database, but.... AHHHHHHHHHHHHHHHHHHHHHHHHHHHH

Ah ha, I know what it is, it's Xenithar; he's jinxed it after what I said about using Eluna! ;) :D

Okay, I managed to fend off Xenithar's pet gremlin, and get this to work. It required setting the gossipMenuId in the [B]creature_template [/B]to 0. Which seems a bit odd, but made the NPC use that altered text in the [B]npc_text [/B]table, thus:

[IMG]http://chuckyworld.co.uk/MaNGOS/Issues/Database/MissingQuestText/HighExecutionorDarthaliaPartDeux.jpg[/IMG]

So, the following SQL script needs to be applied:

UPDATE `creature_template` SET `GossipMenuId`='0' WHERE `Entry`='2215';

I'll add that to the existing update file and PR it.

[B]EDIT:[/B] Corrected update file has now been PR'd

I was going to dig into the gossip table but did not. I have been going all day. Good job, quick fix!

Thanks, Xenithar :)

Will need to look at that one again, though. That field I placed a 0 in should hold the ID number that will lead to the npc_text record that the original script added the Greetings $N to.

Something is not working as it should, it seems.

It is working (seemingly), so good, but I'll be back!