[Bug]Demon trainers are missing flavor text #12559

Closed
Crysicle opened this Issue Jul 18, 2014 · 3 comments

Comments

Projects
None yet
5 participants

Bug:
Every demon trainer is missing their flavor text.

Links:
Matero Zeshuwal - http://www.wowhead.com/npc=23535
Martha Strain - http://www.wowhead.com/npc=5753
Gina Lang - http://www.wowhead.com/npc=5750
Kayla Smithe - http://www.wowhead.com/npc=5749
Torian - http://www.wowhead.com/npc=16649
Daestra - http://www.wowhead.com/npc=16267
Yasmine Teli'Larien - http://www.wowhead.com/npc=15494
Kurgul - http://www.wowhead.com/npc=5815
Kitha - http://www.wowhead.com/npc=6027
Hraug - http://www.wowhead.com/npc=12776
Cylina Darkheart - http://www.wowhead.com/npc=6374
Spackle Thornberry - http://www.wowhead.com/npc=5520
Jubahl Corpseseeker - http://www.wowhead.com/npc=6382
Dannie Fizzwizzle - http://www.wowhead.com/npc=6328
Dane Winslow - www.wowhead.com/npc=6373

Core revision: 0f0cea1

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Crysicle changed the title from [Bug]Dane Winslow missing flavor text to [Bug]Demon trainers are missing flavor text Jul 22, 2014

Contributor

dr-j commented Jul 22, 2014

Hmm have checked 3.3.5 sniffs for this and these have npcs have the usual gossip menu 0, these npcs still exist on retail but current gossip is not valid from retail either as now the gossip and option is to abandon a pet if a warlock which was not the case in wotlk this npcs where redundant in wotlk since was first patch where warlock pets learnt spells automatic rather than having to use these npcs.

Aokromes added this to the 3.3.5a cosmetic milestone Aug 28, 2014

Member

Killyana commented Feb 24, 2015

In this case we remove the npcflag=1 from this npcs or:

DELETE FROM `gossip_menu` WHERE `entry`=12670 AND `text_id` IN (12549, 17816); 
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12670,12549), (12670,17816);

UPDATE `creature_template` SET `gossip_menu_id`=12670 WHERE `entry`IN (23535, 5753, 5750, 5749, 16649, 16267, 15494, 5815, 6027, 12776, 6374, 5520, 6382, 6328, 6373, 6376);
UPDATE `creature_template` SET `npcflag`=3 WHERE `entry`=6376;

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=12670;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`, `NegativeCondition`, `ErrorTextId`,`ScriptName`,`Comment`) VALUES
(14,12670,12549,0,15,256,0,0,1,0,'','Show gossip menu if player is not a warlock'),
(14,12670,17816,0,15,256,0,0,0,0,'','Show gossip menu if player is a warlock');
Member

Killyana commented Jun 6, 2015

Remove gossips from demon trainer

UPDATE `creature_template` SET `gossip_menu_id`=0 WHERE `entry`IN (23535, 5753, 5750, 5749, 16649, 16267, 15494, 5815, 6027, 12776, 6374, 5520, 6382, 6328, 6373, 6376);
UPDATE `creature_template` SET `npcflag`=0 WHERE `entry`IN (16267, 6328, 6373, 15494, 6374);
UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`IN (6027, 5753, 5750, 5520, 6376, 6382, 12776, 5749, 5815, 16649, 23535);

@Aokromes Aokromes added a commit that referenced this issue Jun 6, 2015

@Aokromes Aokromes DB/Creature: Demon trainers
By Killyana, closes #12559
cac4f95
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment