DB/DarkmoonFaire: Added Cauldron of Rock spawns

1 files changed, 86 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_12_10_00_world.sql b/sql/updates/world/master/2022_12_10_00_world.sql
new file mode 100644
index 00000000000..0435ba945e7
--- /dev/null
+++ b/sql/updates/world/master/2022_12_10_00_world.sql
@@ -0,0 +1,86 @@
+SET @CGUID := 651841;
+SET @OGUID := 400523;
+
+-- Creature
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+23;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 174035, 974, 5861, 5861, '0', 0, 0, 0, 0, -4195.15087890625, 6012.06689453125, 5.971547603607177734, 5.066993236541748046, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Dro Seminario (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+1, 121535, 974, 5861, 5861, '0', 0, 0, 0, 0, -4169.1806640625, 5998.3505859375, 16.86725425720214843, 2.198547601699829101, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+2, 121543, 974, 5861, 5861, '0', 0, 0, 0, 0, -4140.88916015625, 6093.861328125, 8.608447074890136718, 6.231745719909667968, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Khan Nabul (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+3, 123691, 974, 5861, 5861, '0', 0, 0, 0, 0, -4165.09716796875, 6079.41943359375, 8.650113105773925781, 2.538732767105102539, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+4, 121537, 974, 5861, 5861, '0', 0, 0, 0, 0, -4151.75537109375, 6093.87939453125, 8.650113105773925781, 3.807008981704711914, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+5, 121535, 974, 5861, 5861, '0', 0, 0, 0, 0, -4180.63720703125, 6085.783203125, 15.98054981231689453, 6.082070827484130859, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+6, 121542, 974, 5861, 5861, '0', 0, 0, 0, 0, -4147.767578125, 6078.2109375, 8.608447074890136718, 5.422368049621582031, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Nick Arse (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+7, 121535, 974, 5861, 5861, '0', 0, 0, 0, 0, -4164.47216796875, 6094.2099609375, 8.608446121215820312, 3.639302730560302734, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+8, 121537, 974, 5861, 5861, '0', 0, 0, 0, 0, -4145.8525390625, 6094.6318359375, 8.650113105773925781, 0.442834675312042236, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+9, 121537, 974, 5861, 5861, '0', 0, 0, 0, 0, -4150.220703125, 6083.3349609375, 8.608446121215820312, 5.956604957580566406, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+10, 121535, 974, 5861, 5861, '0', 0, 0, 0, 0, -4151.5625, 6082.181640625, 8.650113105773925781, 5.956604957580566406, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+11, 14849, 974, 5861, 5861, '0', 0, 0, 0, 0, -4152.30029296875, 6076.02880859375, 8.608447074890136718, 0, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Darkmoon Carnie (Area: Darkmoon Island - Difficulty: 0) (Auras: )
+(@CGUID+12, 123691, 974, 5861, 5861, '0', 0, 0, 0, 0, -4158.26025390625, 6099.98876953125, 8.650113105773925781, 4.275885581970214843, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+13, 121535, 974, 5861, 5861, '0', 0, 0, 0, 0, -4173.1494140625, 6012.26904296875, 24.90544509887695312, 4.570530891418457031, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+14, 121535, 974, 5861, 5861, '0', 0, 0, 0, 0, -4154.39404296875, 6092.3046875, 8.650113105773925781, 1.266721487045288085, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+15, 120928, 974, 5861, 5861, '0', 0, 0, 0, 0, -4155.22216796875, 6067.3662109375, 8.650113105773925781, 2.198677778244018554, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Jay Maguire (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+16, 123755, 974, 5861, 5861, '0', 0, 0, 0, 0, -4179.6494140625, 6084.34033203125, 11.09845924377441406, 2.017403602600097656, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Darkmoon Carnie (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+17, 123735, 974, 5861, 5861, '0', 0, 0, 0, 0, -4146.8974609375, 6087.81103515625, 8.608446121215820312, 2.716170787811279296, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Henry Gust (Area: Darkmoon Island - Difficulty: 0) (Auras: 246218 - Purple Dance Sticks)
+(@CGUID+18, 123691, 974, 5861, 5861, '0', 0, 0, 0, 0, -4147.34375, 6095.08349609375, 8.650113105773925781, 0.442834675312042236, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+19, 121537, 974, 5861, 5861, '0', 0, 0, 0, 0, -4166.03125, 6082.12939453125, 8.650113105773925781, 4.615591049194335937, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+20, 121537, 974, 5861, 5861, '0', 0, 0, 0, 0, -4166.984375, 6093.2421875, 8.608446121215820312, 0.224299952387809753, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+21, 14849, 974, 5861, 5861, '0', 0, 0, 0, 0, -4153.96728515625, 6107.06787109375, 9.470907211303710937, 1.005135536193847656, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Darkmoon Carnie (Area: Darkmoon Island - Difficulty: 0) (Auras: )
+(@CGUID+22, 121535, 974, 5861, 5861, '0', 0, 0, 0, 0, -4160.7431640625, 6098.947265625, 8.650113105773925781, 0.919635295867919921, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924), -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+(@CGUID+23, 121535, 974, 5861, 5861, '0', 0, 0, 0, 0, -4201.34375, 6009.7431640625, 18.66161918640136718, 0.240572929382324218, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 46924); -- Metal Fan (Area: Darkmoon Island - Difficulty: 0)
+
+-- GameObject
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+18;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 267850, 974, 5861, 5861, '0', 0, 0, -4166.88916015625, 6093.3427734375, 8.525113105773925781, 0.20071132481098175, 0, 0, 0.100187301635742187, 0.994968593120574951, 120, 255, 1, 46924), -- Chair (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+1, 270925, 974, 5861, 5861, '0', 0, 0, -4189.1787109375, 5987.779296875, 5.955767631530761718, 1.49004065990447998, -0.05763673782348632, 0.001698493957519531, 0.678081512451171875, 0.732721388339996337, 120, 255, 1, 46924), -- Spare Drummer (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+2, 267836, 974, 5861, 5861, '0', 0, 0, -4139.2119140625, 6090.640625, 8.525116920471191406, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 46924), -- Stove (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+3, 267847, 974, 5861, 5861, '0', 0, 0, -4163.58154296875, 6091.2041015625, 8.525113105773925781, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 120, 255, 1, 46924), -- Chair (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+4, 267849, 974, 5861, 5861, '0', 0, 0, -4166.064453125, 6089.65966796875, 8.526848793029785156, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 46924), -- Chair (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+5, 270926, 974, 5861, 5861, '0', 0, 0, -4191.3291015625, 5987.3427734375, 6.734367847442626953, 1.713305830955505371, -0.03200197219848632, 0.011264801025390625, 0.755476951599121093, 0.65429621934890747, 120, 255, 1, 46924), -- Spare Drummer (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+6, 267848, 974, 5861, 5861, '0', 0, 0, -4164.46875, 6094.1962890625, 8.525113105773925781, 3.831001043319702148, 0, 0, -0.94117546081542968, 0.337918221950531005, 120, 255, 1, 46924), -- Chair (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+7, 269654, 974, 5861, 5861, '0', 0, 0, -4190.140625, 6014.09716796875, 5.780077934265136718, 1.094468116760253906, -0.01186704635620117, -0.032623291015625, 0.519511222839355468, 0.853758096694946289, 120, 255, 1, 46924), -- Stage Grave (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+8, 269654, 974, 5861, 5861, '0', 0, 0, -4183.017578125, 6011.02099609375, 5.750340938568115234, 1.216641187667846679, -0.00700855255126953, 0.000658035278320312, 0.571496009826660156, 0.820574641227722167, 120, 255, 1, 46924), -- Stage Grave (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+9, 270926, 974, 5861, 5861, '0', 0, 0, -4191.3291015625, 5987.3427734375, 6.734367847442626953, 1.713305830955505371, -0.03200197219848632, 0.011264801025390625, 0.755476951599121093, 0.65429621934890747, 120, 255, 1, 46924), -- Spare Drummer (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+10, 269654, 974, 5861, 5861, '0', 0, 0, -4180.63916015625, 6009.91748046875, 5.603321075439453125, 1.234094858169555664, -0.00701427459716796, 0.000597000122070312, 0.578635215759277343, 0.815556049346923828, 120, 255, 1, 46924), -- Stage Grave (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+11, 269654, 974, 5861, 5861, '0', 0, 0, -4165.80712890625, 6002.39404296875, 6.943933963775634765, 3.115356206893920898, -0.06281280517578125, 0.096017837524414062, 0.993210792541503906, 0.019169315695762634, 120, 255, 1, 46924), -- Stage Grave (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+12, 269654, 974, 5861, 5861, '0', 0, 0, -4189.54541015625, 6037.1005859375, 6.592328071594238281, 5.198109626770019531, 0.063930511474609375, 0.079247474670410156, -0.51482868194580078, 0.851225078105926513, 120, 255, 1, 46924), -- Stage Grave (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+13, 269654, 974, 5861, 5861, '0', 0, 0, -4186.57275390625, 6012.40966796875, 5.764399051666259765, 1.164282083511352539, 0.013566017150878906, -0.04933357238769531, 0.548450469970703125, 0.83461618423461914, 120, 255, 1, 46924), -- Stage Grave (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+14, 269654, 974, 5861, 5861, '0', 0, 0, -4165.23291015625, 6019.9921875, 6.801020145416259765, 2.67398691177368164, -0.1113433837890625, -0.02062416076660156, 0.967631340026855468, 0.225536912679672241, 120, 255, 1, 46924), -- Stage Grave (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+15, 267836, 974, 5861, 5861, '0', 0, 0, -4139.2119140625, 6090.640625, 8.525116920471191406, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 46924), -- Stove (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+16, 269654, 974, 5861, 5861, '0', 0, 0, -4166.16845703125, 6014.87255859375, 6.8605499267578125, 3.049898147583007812, -0.11169719696044921, 0.008564949035644531, 0.992643356323242187, 0.045929592102766036, 120, 255, 1, 46924), -- Stage Grave (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+17, 269654, 974, 5861, 5861, '0', 0, 0, -4193.40478515625, 6034.8056640625, 6.682002067565917968, 5.219549179077148437, 0.030477523803710937, 0.138102531433105468, -0.49687099456787109, 0.856223106384277343, 120, 255, 1, 46924), -- Stage Grave (Area: Darkmoon Island - Difficulty: 0)
+(@OGUID+18, 270925, 974, 5861, 5861, '0', 0, 0, -4189.1787109375, 5987.779296875, 5.955767631530761718, 1.49004065990447998, -0.05763673782348632, 0.001698493957519531, 0.678081512451171875, 0.732721388339996337, 120, 255, 1, 46924); -- Spare Drummer (Area: Darkmoon Island - Difficulty: 0)
+
+-- Creature Addon
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+23;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(@CGUID+0, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Dro Seminario
+(@CGUID+1, 0, 0, 0, 1, 10, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+2, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Khan Nabul
+(@CGUID+3, 0, 0, 0, 1, 10, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+4, 0, 0, 0, 1, 10, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+5, 0, 0, 0, 1, 10, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+6, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Nick Arse
+(@CGUID+7, 0, 0, 0, 1, 415, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+8, 0, 0, 0, 1, 10, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+10, 0, 0, 0, 1, 10, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+11, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Darkmoon Carnie
+(@CGUID+12, 0, 0, 0, 1, 10, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+13, 0, 0, 0, 1, 10, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+14, 0, 0, 0, 1, 10, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+15, 0, 0, 0, 1, 483, 0, 0, 0, 0, ''), -- Jay Maguire
+(@CGUID+17, 0, 0, 0, 1, 0, 0, 0, 0, 0, '246218'), -- Henry Gust - 246218 - Purple Dance Sticks
+(@CGUID+18, 0, 0, 0, 1, 10, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+19, 0, 0, 0, 1, 10, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+20, 0, 0, 0, 1, 415, 0, 0, 0, 0, ''), -- Metal Fan
+(@CGUID+21, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Darkmoon Carnie
+(@CGUID+22, 0, 0, 0, 1, 10, 0, 0, 0, 0, ''); -- Metal Fan
+
+-- Creature Template
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=1555, `npcflag`=128, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=123735; -- Henry Gust
+UPDATE `creature_template` SET `gossip_menu_id`=21057, `minlevel`=60, `maxlevel`=60, `faction`=1555, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=120928; -- Jay Maguire
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=1555, `npcflag`=128, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=121542; -- Nick Arse
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=1555, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry` IN (121537, 123691, 121535); -- Metal Fan
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=1555, `npcflag`=128, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=121543; -- Khan Nabul
+UPDATE `creature_template` SET `gossip_menu_id`=26433, `minlevel`=60, `maxlevel`=60, `faction`=1555, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=174035; -- Dro Seminario