Minor fixes v14 (Darkmoon Fair) > Updated 26/05/2021

Stiga

Gold Supporter
Veteran Member
66
2020
123
Location
France
Missing NPC Darkmoon Fair > Mola npc whack-a-mole event

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:

Jenniy

I collect profile flairs.
Silver Supporter
Senior User
351
2020
70
I love the Darkmoon Faire! Thank you for the updates moving it a little closer to 'actually' working!
 

JakeSpeed

Verified Member
26
2021
3
.event stop (ID)
Seems this did not work I have alot of Darkmoon events going on haha thought it was ID 479 but no go looking for another way. Did an event lookup found some 114 115 etc with dark moon but they wont disable either.
 
Last edited:
Top