diff options
| -rw-r--r-- | sql/updates/world/master/2022_11_10_10_world_dalaran.sql | 167 |
1 files changed, 167 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_11_10_10_world_dalaran.sql b/sql/updates/world/master/2022_11_10_10_world_dalaran.sql new file mode 100644 index 00000000000..b57969de5bc --- /dev/null +++ b/sql/updates/world/master/2022_11_10_10_world_dalaran.sql @@ -0,0 +1,167 @@ +SET @CGUID := 222686; +SET @OGUID := 166274; + +-- Creature templates +UPDATE `creature_template` SET `gossip_menu_id`=10518, `minlevel`=60, `maxlevel`=60, `unit_flags`=768 WHERE `entry`=35256; -- Cheerful Dalaran Spirit +UPDATE `creature_template` SET `gossip_menu_id`=10518, `minlevel`=60, `maxlevel`=60, `unit_flags`=768 WHERE `entry`=35254; -- Ghostly Dalaran Celebrant + +UPDATE `creature_template_addon` SET `bytes1`=0, `emote`=0, `auras`='4986 33900' WHERE `entry`=35256; -- 35256 (Cheerful Dalaran Spirit) +UPDATE `creature_template_addon` SET `bytes1`=0, `emote`=10, `auras`='4986 33900' WHERE `entry`=35254; -- 35254 (Ghostly Dalaran Celebrant) + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (35256,35254)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(35256, 0, 0, 0, 414, 46366), +(35254, 0, 0, 0, 414, 46366); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=46366 WHERE (`DifficultyID`=0 AND `Entry` IN (96773,96772,93432,73517,73516,69973,69971,69321,69318,62822,62821,61081,61080,51512,50174,50171,50163,50160,50158,50157,50156,50155,50153,50152,50150,50149,50148,50147,50144,50142,49748,47581,47579,40212,40160,37942,37941,37780,37776,36856,36851,36776,36774,36670,36669,35826,35790,35607,35594,35500,35498,35497,35496,35495,35494,34984,34953,34952,34330,34252,34244,33964,33963,33778,33422,33031,33027,33026,32844,32843,32749,32745,32744,32743,32741,32738,32737,32735,32734,32733,32732,32731,32729,32728,32727,32726,32724,32722,32717,32704,32693,32692,32691,32690,32689,32688,32687,32686,32685,32684,32683,32681,32680,32679,32678,32677,32676,32675,32669,32668,32664,32653,32652,32651,32650,32631,32606,32602,32600,32597,32516,32515,32514,32470,32466,32451,32450,32441,32435,32428,32426,32424,32421,32420,32419,32418,32416,32415,32413,32412,32411,32403,32339,32337,32335,32334,32328,32287,32286,32265,32253,32252,32251,32249,32216,32206,32172,32170,32169,31886,31885,31851,31796,31795,31769,31768,31758,31757,31756,31755,31742,31741,31740,31735,31733,31732,31730,31729,31728,31719,31714,31711,31710,31709,31689,31643,31582,31581,31580,31579,31557,31517,31400,31238,31236,31233,31229,31228,31136,31085,31081,31032,31031,30885,30755,30726,30608,30607,30606,30605,30604,30490,30352,30137,30117,30116,30115,30104,30095,30094,29812,29807,29802,29785,29784,29783,29782,29781,29780,29777,29766,29765,29764,29763,29716,29715,29714,29703,29702,29675,29674,29673,29672,29665,29660,29657,29641,29640,29636,29631,29628,29548,29547,29538,29537,29535,29532,29530,29529,29528,29527,29523,29514,29513,29512,29511,29510,29509,29508,29507,29506,29505,29499,29497,29496,29495,29494,29493,29491,29478,29476,29282,29261,29255,29254,29156,29049,28997,28995,28994,28993,28992,28991,28990,28989,28958,28956,28951,28776,28774,28742,28728,28727,28726,28725,28723,28722,28721,28718,28716,28715,28714,28708,28707,28706,28705,28704,28703,28702,28701,28700,28699,28698,28697,28696,28694,28693,28692,28691,28690,28687,28686,28685,28682,28677,28676,28675,28674,28332,28160,27047,26043,25171,25058,23472,23033,20735,20102,19481,19169,18927,17213,16128,6271)); + +-- Models +UPDATE `creature_template_model` SET `VerifiedBuild`=46366 WHERE (`Idx`=3 AND `CreatureID` IN (35254,31755,30755,31758,30352,31769,31728,31757,32597,31730,31768,31741,32470,31756,31729,29255,29254,32600,32602)) OR (`Idx`=2 AND `CreatureID` IN (35254,31755,30755,31758,31732,30352,31769,31740,31728,31757,32597,31730,31735,31719,31768,31741,32470,31756,32451,31729,29255,29254,32600,32602)) OR (`Idx`=1 AND `CreatureID` IN (35254,31755,30755,31517,31400,31758,31732,31643,32249,30352,18927,61080,31769,19169,31740,27047,32328,20102,31728,31757,32339,32606,32597,31730,31735,32265,31719,31768,29812,23472,31741,25171,32470,34984,26043,31796,33031,23033,36774,28332,36776,31756,6271,32451,31729,29255,29254,32600,32602)) OR (`Idx`=0 AND `CreatureID` IN (35254,32287,31582,31755,28696,31709,29548,30755,31711,33027,32216,32411,69321,69973,28995,61081,33422,29496,49748,31517,31400,32631,32738,32724,28989,31085,31758,50149,73517,29510,31732,33778,28704,31643,32745,32731,51512,29547,29764,32416,35256,32732,32249,37780,40160,34252,29628,17213,28714,32678,28958,28956,30352,29716,50156,32704,30606,50158,18927,61080,32418,25058,31769,19169,31740,32680,27047,34330,32749,32328,32675,20102,37942,30605,31032,28685,29261,30607,31228,32741,96772,32251,32419,31886,29657,50148,28700,29514,28699,28706,31728,28721,30885,31580,35494,29478,36856,30094,29523,28994,29494,28682,16128,32169,30117,32253,35495,31757,50150,31795,29505,34244,29476,29641,93432,32844,32339,32743,32685,29807,29703,36851,29527,32683,37850,35500,35497,28691,29507,32722,31238,32687,31581,31714,28675,29509,29640,32441,29493,32335,32606,62822,32597,32334,69318,31579,29636,29802,29785,29529,50157,29499,29765,36670,31730,29537,29511,31735,28701,29715,32717,35790,29784,28991,36669,29532,50174,32265,29508,19481,32412,31719,29282,31768,50142,28694,28716,32466,28160,32676,30104,29156,29812,32668,28774,30608,37776,23472,50171,32686,32737,29631,28690,28677,50153,28697,32651,31741,165189,32172,25171,29049,32744,32470,34984,28707,28992,31233,32428,32735,31031,31885,29673,28718,28728,28990,26043,28708,31796,28993,30137,32729,33031,28705,32424,32413,30115,23033,32692,31557,32420,34953,29665,29675,29513,32286,32652,32206,32688,32727,62821,32691,29781,33964,28715,29495,28776,29763,36774,50155,31236,32734,30116,32415,33963,32664,50144,32515,32650,28997,35498,47581,28727,31733,28687,29530,32689,35496,28332,28686,50160,28692,29497,28742,35607,31742,36776,31756,50152,32677,73516,28726,28951,29506,28703,31689,31851,32435,28702,32726,32403,69971,35594,29702,32450,32669,29491,20735,6271,32426,30604,31229,32728,29672,31081,37941,28676,29538,32170,32451,28698,32653,31729,29714,28725,32516,32514,32679,29255,32681,29777,29780,32690,33026,30095,50163,32421,29254,29660,34952,32733,96773,28674,32252,32600,35826,32602,29674,29535,31710,50147,28722,32684,29512,32337,28693,28723,32693,47579,32843,40212,30490,29782,29783,30726,29766,31136,29528)); + +UPDATE `creature_model_info` SET `VerifiedBuild`=46366 WHERE `DisplayID` IN (23337, 24916, 61133, 51414, 46947, 26465, 26464, 47456, 47453, 37403, 36894, 36893, 36756, 36880, 36882, 36881, 36879, 36883, 36906, 36907, 36904, 36898, 36905, 36903, 36900, 36899, 36597, 35705, 35704, 29076, 31713, 30842, 30841, 30800, 30686, 30764, 30358, 30415, 30438, 30311, 28680, 28755, 30042, 29921, 29834, 29833, 29835, 29836, 29831, 29832, 29719, 29744, 29743, 29145, 29132, 28987, 28986, 22471, 28618, 24607, 28433, 28432, 52602, 28317, 28207, 28202, 28199, 28194, 28177, 28178, 28174, 28172, 28173, 28171, 28170, 28169, 28167, 28166, 28165, 28164, 27944, 27949, 28193, 28188, 28163, 28162, 28161, 28160, 28159, 28156, 28155, 28154, 28153, 28152, 28150, 28149, 28148, 28147, 28146, 28145, 28144, 28143, 338, 80, 12200, 5966, 28125, 28124, 28123, 28119, 23167, 26847, 28006, 28000, 27999, 6295, 27972, 28158, 5556, 833, 20763, 27965, 27963, 27962, 27961, 27960, 27959, 27958, 27957, 27956, 27955, 27954, 27952, 26440, 27913, 27912, 27766, 27886, 25870, 17200, 27854, 27853, 27852, 9572, 27822, 27820, 27799, 27801, 27800, 22003, 27019, 27243, 27720, 27718, 23516, 1338, 2710, 837, 23519, 27883, 3233, 1924, 9990, 1004, 2954, 2957, 1206, 2955, 27657, 27557, 27560, 27556, 27559, 27616, 17612, 27524, 10957, 24235, 8811, 1988, 27509, 27585, 27587, 27449, 27448, 27398, 27329, 27334, 27287, 27161, 27160, 27159, 27158, 27157, 27068, 26997, 27332, 26998, 26779, 26771, 26770, 28222, 26766, 26759, 26570, 26557, 26531, 26530, 26547, 26526, 26532, 7920, 26524, 26521, 26519, 26518, 26517, 26442, 26441, 27915, 26437, 26438, 26501, 26494, 26496, 26503, 26417, 26414, 26413, 27782, 26398, 26397, 26394, 26390, 26330, 27211, 26444, 26443, 26445, 26373, 26372, 26347, 26396, 26395, 26321, 26374, 26375, 26376, 26378, 26377, 26335, 26336, 26337, 26338, 26339, 26313, 26312, 26311, 26310, 26309, 26307, 25879, 26300, 26299, 26103, 26078, 26074, 26071, 26073, 26072, 26068, 26067, 26069, 26070, 25947, 25882, 25881, 25594, 25880, 25983, 25878, 25877, 25876, 25875, 25807, 25806, 25791, 25674, 25673, 25655, 25651, 25650, 25649, 25648, 25647, 25646, 25645, 25644, 25637, 25636, 25635, 25955, 25623, 25622, 25621, 25620, 25619, 25618, 26075, 25616, 25615, 25614, 25613, 25612, 25611, 25610, 25609, 25608, 25607, 25605, 25604, 25603, 25602, 25598, 25597, 25596, 25595, 25166, 23501, 17188, 5585, 19744, 19284, 16910, 16024); +UPDATE `creature_model_info` SET `DisplayID_Other_Gender`=0, `VerifiedBuild`=46366 WHERE `DisplayID` IN (29718, 29721, 29717, 21270); + +-- Quests +DELETE FROM `creature_queststarter` WHERE `id`=35256; +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(35256, 14166, 46366); + +DELETE FROM `game_event_creature_quest` WHERE `id`=35256; + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN 144845 AND 144854; +DELETE FROM `creature` WHERE `guid` IN (145023, 145031); +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 144845 AND 144854; +DELETE FROM `game_event_creature` WHERE `guid` IN (145023, 145031); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+11; +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, 34382, 571, 4395, 0, '0', 0, 0, 0, 1, 5850.04931640625, 766.30731201171875, 640.9990234375, 4.468042850494384765, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Chapman (Area: 0 - Difficulty: 0) +(@CGUID+1, 34383, 571, 4395, 0, '0', 0, 0, 0, 1, 5852.19775390625, 763.51214599609375, 641.49072265625, 3.909537553787231445, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Catrina (Area: 0 - Difficulty: 0) +(@CGUID+2, 35254, 571, 4395, 0, '0', 0, 0, 0, 0, 5850.15283203125, 769.9913330078125, 640.817626953125, 3.106686115264892578, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+3, 35254, 571, 4395, 0, '0', 0, 0, 0, 0, 5856.31591796875, 764, 641.2667236328125, 6.038839340209960937, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+4, 35254, 571, 4395, 0, '0', 0, 0, 0, 0, 5854.5625, 769.9375, 641.3104248046875, 4.15388345718383789, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+5, 35254, 571, 4395, 0, '0', 0, 0, 0, 0, 5847.70751953125, 772.88543701171875, 640.46234130859375, 4.939281940460205078, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+6, 35254, 571, 4395, 0, '0', 0, 0, 0, 0, 5848.58056640625, 770.54339599609375, 640.6075439453125, 5.445427417755126953, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+7, 35254, 571, 4395, 0, '0', 0, 0, 0, 0, 5858.05126953125, 763.140625, 640.97076416015625, 2.548180580139160156, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+8, 35254, 571, 4395, 0, '0', 0, 0, 0, 0, 5860.416015625, 765.40802001953125, 640.8057861328125, 4.066617012023925781, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+9, 35254, 571, 4395, 0, '0', 0, 0, 0, 0, 5850.7265625, 774.95831298828125, 640.53619384765625, 4.590215682983398437, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+10, 35254, 571, 4395, 0, '0', 0, 0, 0, 0, 5854.24462890625, 762.48089599609375, 641.18548583984375, 3.31612563133239746, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Ghostly Dalaran Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+11, 35256, 571, 4395, 0, '0', 0, 0, 0, 0, 5855.5380859375, 766.54864501953125, 641.56671142578125, 3.787364482879638671, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366); -- Cheerful Dalaran Spirit (Area: 0 - Difficulty: 0) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 76259 AND 76263; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 76329 AND 76343; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 78420 AND 78425; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 78487 AND 78489; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 78770 AND 78786; +DELETE FROM `gameobject` WHERE `guid` IN (76251, 78409, 78515, 78516, 78589, 78600, 78601, 78638, 78672, 78673, 78718, 78719, 78975); +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 76259 AND 76263; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 76329 AND 76343; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78420 AND 78425; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78487 AND 78489; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78770 AND 78786; +DELETE FROM `game_event_gameobject` WHERE `guid` IN (76251, 78409, 78515, 78516, 78589, 78600, 78601, 78638, 78672, 78673, 78718, 78719, 78975); + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+38; +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, 180338, 571, 4395, 0, '0', 0, 0, 5855.42724609375, 763.232666015625, 640.9249267578125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+1, 180338, 571, 4395, 0, '0', 0, 0, 5855.96533203125, 762.60418701171875, 642.00323486328125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+2, 180338, 571, 4395, 0, '0', 0, 0, 5857.9619140625, 764.84027099609375, 642.32403564453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+3, 180338, 571, 4395, 0, '0', 0, 0, 5857.6650390625, 766.70489501953125, 642.3126220703125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+4, 180338, 571, 4395, 0, '0', 0, 0, 5855.041015625, 767.1180419921875, 641.4462890625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+5, 180338, 571, 4395, 0, '0', 0, 0, 5856.6650390625, 766.63543701171875, 641.3419189453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+6, 180338, 571, 4395, 0, '0', 0, 0, 5852.54931640625, 767.795166015625, 640.99774169921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+7, 180338, 571, 4395, 0, '0', 0, 0, 5852.080078125, 768.3819580078125, 641.0565185546875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+8, 180338, 571, 4395, 0, '0', 0, 0, 5851.49853515625, 770.91143798828125, 640.81756591796875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+9, 180338, 571, 4395, 0, '0', 0, 0, 5854.48193359375, 768.01214599609375, 641.1102294921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+10, 180338, 571, 4395, 0, '0', 0, 0, 5849.52001953125, 771.920166015625, 640.53155517578125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+11, 180338, 571, 4395, 0, '0', 0, 0, 5852.02001953125, 770.60418701171875, 640.667724609375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+12, 180339, 571, 4395, 0, '0', 0, 0, 5855.4619140625, 762.79168701171875, 641.02093505859375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 02 (Area: 0 - Difficulty: 0) +(@OGUID+13, 180339, 571, 4395, 0, '0', 0, 0, 5851.6630859375, 770.52606201171875, 640.8624267578125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 02 (Area: 0 - Difficulty: 0) +(@OGUID+14, 180340, 571, 4395, 0, '0', 0, 0, 5856.37744140625, 764.81597900390625, 641.312255859375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 03 (Area: 0 - Difficulty: 0) +(@OGUID+15, 180340, 571, 4395, 0, '0', 0, 0, 5856.033203125, 763, 642.14874267578125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 03 (Area: 0 - Difficulty: 0) +(@OGUID+16, 180340, 571, 4395, 0, '0', 0, 0, 5851.8662109375, 767.75347900390625, 641.07684326171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 03 (Area: 0 - Difficulty: 0) +(@OGUID+17, 180885, 571, 4395, 0, '0', 0, 0, 5848.79345703125, 767.888916015625, 640.4781494140625, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 46366), -- InnTableTiny (Area: 0 - Difficulty: 0) +(@OGUID+18, 182807, 571, 4395, 0, '0', 0, 0, 5855.94873046875, 765.8055419921875, 641.4307861328125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bottle (Area: 0 - Difficulty: 0) +(@OGUID+19, 182807, 571, 4395, 0, '0', 0, 0, 5849.689453125, 771.4617919921875, 640.58172607421875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bottle (Area: 0 - Difficulty: 0) +(@OGUID+20, 195063, 571, 4395, 0, '0', 0, 0, 5857.072265625, 765.01214599609375, 641.21575927734375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+21, 195063, 571, 4395, 0, '0', 0, 0, 5856.7666015625, 766.2274169921875, 641.3299560546875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+22, 195063, 571, 4395, 0, '0', 0, 0, 5852.234375, 767.95489501953125, 641.10302734375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+23, 195063, 571, 4395, 0, '0', 0, 0, 5848.71435546875, 768.390625, 641.6309814453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+24, 195063, 571, 4395, 0, '0', 0, 0, 5849.20166015625, 772.20660400390625, 640.47674560546875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+25, 195063, 571, 4395, 0, '0', 0, 0, 5850.00537109375, 771.921875, 640.58428955078125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+26, 195066, 571, 4395, 0, '0', 0, 0, 5856.6416015625, 765.55731201171875, 641.31524658203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bread of the Dead (Area: 0 - Difficulty: 0) +(@OGUID+27, 195066, 571, 4395, 0, '0', 0, 0, 5851.9697265625, 771.310791015625, 641.49603271484375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bread of the Dead (Area: 0 - Difficulty: 0) +(@OGUID+28, 195067, 571, 4395, 0, '0', 0, 0, 5854.46533203125, 767.34027099609375, 641.37200927734375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Mixed Fruit Bowl (Area: 0 - Difficulty: 0) +(@OGUID+29, 195068, 571, 4395, 0, '0', 0, 0, 5856.6162109375, 765.54339599609375, 641.33111572265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Offering Bowl (Area: 0 - Difficulty: 0) +(@OGUID+30, 195068, 571, 4395, 0, '0', 0, 0, 5851.962890625, 771.29864501953125, 641.49884033203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Offering Bowl (Area: 0 - Difficulty: 0) +(@OGUID+31, 195069, 571, 4395, 0, '0', 0, 0, 5849.25634765625, 767.81597900390625, 641.60101318359375, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 46366), -- Candy Skulls (Area: 0 - Difficulty: 0) +(@OGUID+32, 195069, 571, 4395, 0, '0', 0, 0, 5848.759765625, 767.34722900390625, 641.61102294921875, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 46366), -- Candy Skulls (Area: 0 - Difficulty: 0) +(@OGUID+33, 195069, 571, 4395, 0, '0', 0, 0, 5848.22900390625, 767.94097900390625, 641.64593505859375, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 46366), -- Candy Skulls (Area: 0 - Difficulty: 0) +(@OGUID+34, 195087, 571, 4395, 0, '0', 0, 0, 5851.900390625, 765.91668701171875, 641.065185546875, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 46366), -- Ghostly Cooking Fire (Area: 0 - Difficulty: 0) +(@OGUID+35, 195090, 571, 4395, 0, '0', 0, 0, 5857.65283203125, 765.75, 642.55218505859375, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 46366), -- Spirit Candle (Area: 0 - Difficulty: 0) +(@OGUID+36, 195090, 571, 4395, 0, '0', 0, 0, 5852.61962890625, 768.34027099609375, 642.14642333984375, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46366), -- Spirit Candle (Area: 0 - Difficulty: 0) +(@OGUID+37, 195307, 571, 4395, 0, '0', 0, 0, 5849.15869140625, 767.48089599609375, 641.58538818359375, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+38, 195307, 571, 4395, 0, '0', 0, 0, 5852.81884765625, 768.201416015625, 642.14239501953125, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 46366); -- Orange Marigolds (Area: 0 - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=51 AND `guid` BETWEEN @CGUID+0 AND @CGUID+11; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(51, @CGUID+0), +(51, @CGUID+1), +(51, @CGUID+2), +(51, @CGUID+3), +(51, @CGUID+4), +(51, @CGUID+5), +(51, @CGUID+6), +(51, @CGUID+7), +(51, @CGUID+8), +(51, @CGUID+9), +(51, @CGUID+10), +(51, @CGUID+11); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=51 AND `guid` BETWEEN @OGUID+0 AND @OGUID+38; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(51, @OGUID+0), +(51, @OGUID+1), +(51, @OGUID+2), +(51, @OGUID+3), +(51, @OGUID+4), +(51, @OGUID+5), +(51, @OGUID+6), +(51, @OGUID+7), +(51, @OGUID+8), +(51, @OGUID+9), +(51, @OGUID+10), +(51, @OGUID+11), +(51, @OGUID+12), +(51, @OGUID+13), +(51, @OGUID+14), +(51, @OGUID+15), +(51, @OGUID+16), +(51, @OGUID+17), +(51, @OGUID+18), +(51, @OGUID+19), +(51, @OGUID+20), +(51, @OGUID+21), +(51, @OGUID+22), +(51, @OGUID+23), +(51, @OGUID+24), +(51, @OGUID+25), +(51, @OGUID+26), +(51, @OGUID+27), +(51, @OGUID+28), +(51, @OGUID+29), +(51, @OGUID+30), +(51, @OGUID+31), +(51, @OGUID+32), +(51, @OGUID+33), +(51, @OGUID+34), +(51, @OGUID+35), +(51, @OGUID+36), +(51, @OGUID+37), +(51, @OGUID+38); |