TrinityCore/TrinityCore — Issue #4754: Quest 11082 Seeker of Truth
Author: malcrom
Created: 2012-01-09 23:14:46+00:00
State: open
Labels: Database-Conditions, Database-Miscellaneous, Database-Quests, Database-SmartAI

Gossip Text Missing 10941 to 10946. Can someone check to see if another db may have these text.

```SQL
-- Quest 11082 Seeker of Truth
-- Gossip Menu insert from sniff
DELETE FROM `gossip_menu` WHERE `entry`=8695 AND `text_id`=10941;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8695,10941);
DELETE FROM `gossip_menu` WHERE `entry`=8700 AND `text_id`=10942;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8700,10942);
DELETE FROM `gossip_menu` WHERE `entry`=8699 AND `text_id`=10943;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8699,10943);
DELETE FROM `gossip_menu` WHERE `entry`=8698 AND `text_id`=10944;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8698,10944);
DELETE FROM `gossip_menu` WHERE `entry`=8697 AND `text_id`=10945;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8697,10945);
DELETE FROM `gossip_menu` WHERE `entry`=8696 AND `text_id`=10946;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8696,10946);
-- Creature Gossip_menu_id Update from sniff
UPDATE `creature_template` SET `gossip_menu_id`=8695 WHERE `entry`=23309;
-- Creature Gossip_menu_option Update from sniff
DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (8695,8700,8699,8698,8697) AND `id` IN (0);
INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES
(8695,0,0, 'How dare you question an overseer of the Dragonmaw!',1,1,8700,0,0,0, ''),
(8700,0,0, 'Who speaks of me? What are you talking about, broken?',1,1,8699,0,0,0, ''),
(8699,0,0, 'Continue please.',1,1,8698,0,0,0, ''),
(8698,0,0, 'Who are these bidders?',1,1,8697,0,0,0, ''),
(8697,0,0, 'Well... yes.',1,1,8696,0,0,0, '');
-- Gossip conditions
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8695;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(15,8695,0,0,9,11082,0,0,0,'','Show gossip option if player has Quest 11082 Seeker of Truth');
-- Gossip Text Missing 10941 to 10946

-- SAI for Murkblood Overseer
SET @ENTRY := 23309; -- NPC entry
SET @SPELL := 41121; -- Giving a Hand
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(@ENTRY,0,0,0,62,0,100,0,8697,0,0,0,11,@SPELL,0,0,0,0,0,7,0,0,0,0,0,0,0,'Murkblood Overseer - On gossip Option select - cast spell');
```