Missing NPC Darkmoon Fair > Mola npc whack-a-mole event
Updated Darkmoon Greeter and information NPCs (they will also now give the Darkmoon Adventurers Guide)
*** WORK-A-ROUND ***
Most Darkmoon Fair events are not working (whack-a-mole,shotting rnage, cannon etc etc.)
So quick work-a-round to just auto-complete quests (for rep etc.) Not great I know, but the events will probably require a lot of work.
26/05/2021
-- https://www.wowhead.com/npc=14846/lhara - corrected sold items and subname (darkmoon pets & mounts)
SQL:
-- https://www.wowhead.com/npc=54601/mola missing npc whack-a-mole event
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 54601, 974, 5861, 5870, 1, 1, 0, 54601, -4003.23, 6279.01, 12.9572, 4.11392, 300, 0, 0, 77490, 0, 0, 0, 0, 0, 0, 0);
Updated Darkmoon Greeter and information NPCs (they will also now give the Darkmoon Adventurers Guide)
SQL:
UPDATE `creature_template` SET `gossip_menu_id`=13075, `AIName`='SmartAI' WHERE `entry` IN (55396,54345);
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=10445;
DELETE FROM `gossip_menu` WHERE `entry` IN (13075,13113,6577,6578,13083,8848,13076,13077,13078,13079,13080,13081,13082) AND `text_id` IN (18362,18444,7793,7794,7795,11472,18363,18364,18365,18366,18369,18370,18371);
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
(13075, 18362),
(13113, 18444),
(6577, 7793),
(6578, 7794),
(13083, 7795),
(8848, 11472),
(13076, 18363),
(13077, 18364),
(13078, 18365),
(13079, 18366),
(13080, 18369),
(13081, 18370),
(13082, 18371);
DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (13075,13076,13083,13113);
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES
(13075, 0, 0, 'Darkmoon Adventurer''s Guide?', 53755, 1, 1, 13113, 0, 0, 0, '', 0),
(13075, 1, 0, 'What can I purchase?', 10773, 1, 1, 6577, 0, 0, 0, '', 0),
(13075, 2, 0, 'Darkmoon Faire Prize Tickets?', 10775, 1, 1, 6578, 0, 0, 0, '', 0),
(13075, 3, 0, 'Darkmoon Cards?', 10777, 1, 1, 13083, 0, 0, 0, '', 0),
(13075, 4, 0, 'Attractions?', 10779, 1, 1, 13076, 0, 0, 0, '', 0),
(13076, 0, 0, 'Tonks?', 11934, 1, 1, 13077, 0, 0, 0, '', 0),
(13076, 1, 0, 'Cannon?', 11936, 1, 1, 13078, 0, 0, 0, '', 0),
(13076, 2, 0, 'Whack-a-Gnoll?', 53403, 1, 1, 13079, 0, 0, 0, '', 0),
(13076, 3, 0, 'Ring Toss?', 53415, 1, 1, 13080, 0, 0, 0, '', 0),
(13076, 4, 0, 'Shooting Gallery?', 53417, 1, 1, 13081, 0, 0, 0, '', 0),
(13076, 5, 0, 'Fortune teller?', 53419, 1, 1, 13082, 0, 0, 0, '', 0),
(13083, 0, 0, '<more>', 17471, 1, 1, 8848, 0, 0, 0, '', 0),
(13113, 0, 0, 'May I have another Darkmoon Adventurer''s Guide?', 53756, 1, 1, 0, 0, 0, 0, '', 0);
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (54345,55396,10445);
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
(54345, 0, 0, 0, 62, 0, 100, 0, 13113, 0, 0, 0, 11, 103413, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Darkmoon Faire Greeter - On Gossip Option 0 Selected - Cast ''Replace Darkmoon Adventurer''s Guide'''),
(54345, 0, 1, 0, 62, 0, 100, 0, 13113, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Darkmoon Faire Greeter - On Gossip Option 0 Selected - Close Gossip'),
(55396, 0, 0, 0, 62, 0, 100, 0, 13113, 0, 0, 0, 11, 103413, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Darkmoon Faire Greeter - On Gossip Option 0 Selected - Cast ''Replace Darkmoon Adventurer''s Guide'''),
(55396, 0, 1, 0, 62, 0, 100, 0, 13113, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Darkmoon Faire Greeter - On Gossip Option 0 Selected - Close Gossip'),
(10445, 0, 0, 0, 62, 0, 100, 0, 13113, 0, 0, 0, 11, 103413, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Selina Dourman - On Gossip Option 0 Selected - Cast ''Replace Darkmoon Adventurer''s Guide'''),
(10445, 0, 1, 0, 62, 0, 100, 0, 13113, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Selina Dourman - On Gossip Option 0 Selected - Close Gossip');
DELETE FROM `conditions` WHERE `SourceGroup`=13113 AND `ConditionValue1`=71634;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(15, 13113, 0, 0, 0, 2, 0, 71634, 1, 0, 1, 0, 0, '', 'Show gossip option if player does not have has Darkmoon Adventurer''s Guide');
*** WORK-A-ROUND ***
Most Darkmoon Fair events are not working (whack-a-mole,shotting rnage, cannon etc etc.)
So quick work-a-round to just auto-complete quests (for rep etc.) Not great I know, but the events will probably require a lot of work.
SQL:
-- https://www.wowhead.com/quest=29434/tonk-commander
UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=29434; -- value was 33081
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=29434; -- value was30
-- https://www.wowhead.com/quest=29438/he-shoots-he-scores
UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=29438; -- value was 54231
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=29438; -- value was 25
-- https://www.wowhead.com/quest=29436/the-humanoid-cannonball
UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=29436; -- value was 54224
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=29436; -- value was 5
-- https://www.wowhead.com/quest=29455/target-turtle
UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=29455; -- value was 54495
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=29455; -- value was 3
-- https://www.wowhead.com/quest=29463/its-hammer-time
UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=29463; -- value was 54505
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=29463; -- value was 30
26/05/2021
-- https://www.wowhead.com/npc=14846/lhara - corrected sold items and subname (darkmoon pets & mounts)
SQL:
-- https://www.wowhead.com/npc=14846/lhara
UPDATE creature_template SET subname = '<Pet & Mount Prizes>' WHERE entry=14846; -- correct subname title
DELETE FROM `npc_vendor` WHERE `entry`=14846; -- remove all npc_vendro items
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`) VALUES (14846, 0, 72140, 0, 0, 3701, 1); -- https://www.wowhead.com/item=72140/swift-forest-strider
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`) VALUES (14846, 0, 73766, 0, 0, 3701, 1); -- https://www.wowhead.com/item=73766/darkmoon-dancing-bear
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`) VALUES (14846, 0, 73762, 0, 0, 3700, 1); -- https://www.wowhead.com/item=73762/darkmoon-balloon
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`) VALUES (14846, 0, 73764, 0, 0, 3700, 1); -- https://www.wowhead.com/item=73764/darkmoon-monkey
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`) VALUES (14846, 0, 73765, 0, 0, 3700, 1); -- https://www.wowhead.com/item=73765/darkmoon-turtle
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`) VALUES (14846, 0, 73903, 0, 0, 3700, 1); -- https://www.wowhead.com/item=73903/darkmoon-tonk
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`) VALUES (14846, 0, 73905, 0, 0, 3700, 1); -- https://www.wowhead.com/item=73905/darkmoon-zeppelin
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`) VALUES (14846, 0, 74981, 0, 0, 3700, 1); -- https://www.wowhead.com/item=74981/darkmoon-cub
-- INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`) VALUES (14846, 0, 74981, 0, 3700, 0, 1); -- https://www.wowhead.com/item=91003/darkmoon-hatchling (not in 4.3.4)
-- INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`) VALUES (14846, 0, 153485, 0, 3813, 0, 1); -- https://www.wowhead.com/item=153485/darkmoon-dirigible (not in 4.3.4)
Last edited: