diff options
| -rw-r--r-- | sql/updates/world/master/2022_11_10_04_world_exodar.sql | 273 |
1 files changed, 273 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_11_10_04_world_exodar.sql b/sql/updates/world/master/2022_11_10_04_world_exodar.sql new file mode 100644 index 00000000000..9dc3687b35f --- /dev/null +++ b/sql/updates/world/master/2022_11_10_04_world_exodar.sql @@ -0,0 +1,273 @@ +SET @CGUID := 396326; +SET @OGUID := 245533; + +-- Creature templates +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=34484; -- Cheerful Draenei Spirit +UPDATE `creature_template` SET `gossip_menu_id`=10518, `minlevel`=60, `maxlevel`=60, `unit_flags`=768 WHERE `entry`=35246; -- Ghostly Draenei Celebrant + +UPDATE `creature_template_addon` SET `bytes1`=0, `emote`=0, `auras`='4986 33900' WHERE `entry`=34484; -- 34484 (Cheerful Draenei Spirit) +UPDATE `creature_template_addon` SET `bytes1`=0, `emote`=10, `auras`='4986 33900' WHERE `entry`=35246; -- 35246 (Ghostly Draenei Celebrant) + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE `DifficultyID`=0 AND `Entry` IN (35246,34484); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(35246, 0, 0, 0, 414, 46366), +(34484, 0, 0, 0, 414, 46366); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=46366 WHERE (`DifficultyID`=0 AND `Entry` IN (141904,118895,118892,62464,62050,61255,61143,51501,47431,21376,20914,20847,20846,20121,19658,19171,19073,18955,18815,18810,18800,18038,17983,17930,17614,17584,17530,17509,17505,17504,17467,17373,17372,17228,17216,17202,17201,17200,17196,17122,17121,17120,17116,16771,16767,16766,16765,16763,16761,16752,16751,16748,16746,16745,16743,16740,16738,16735,16734,16733,16729,16728,16726,16724,16721,16715,16713,16712,16657,15384,6145)); + +-- Models +UPDATE `creature_template_model` SET `VerifiedBuild`=46366 WHERE (`Idx`=0 AND `CreatureID` IN (17530,16743,35246,17930,20847,16724,61255,16735,17196,20914,17504,17201,16712,17509,118895,18038,16728,16766,62050,34484,20846,16748,62464,16657,17228,17116,16726,17373,17202,16761,19073,16729,16752,21376,17983,18815,18800,17120,20121,17467,19658,16763,16751,16771,16733,17614,18810,16713,61143,15384,6145,16746,16715,17122,16721,17216,17372,16765,16740,18955,17200,19171,17584,17121,34770,47431,16745,51501,17505,118892,16767,16734,16738,141904)) OR (`Idx`=1 AND `CreatureID` IN (35246,18038,17228,18815,18800,16733,61143,15384,18955,19171)) OR (`Idx`=3 AND `CreatureID` IN (18038,17228,18815,16733)) OR (`Idx`=2 AND `CreatureID` IN (18038,17228,18815,18800,16733)); + +UPDATE `creature_model_info` SET `VerifiedBuild`=46366 WHERE `DisplayID` IN (87511, 19301, 74942, 42481, 42343, 4960, 4959, 37399, 35616, 29236, 16259, 16726, 19870, 19869, 19351, 16925, 19233, 19234, 18214, 18195, 18341, 17385, 17333, 17124, 17110, 17063, 17226, 17488, 17214, 178, 1042, 16921, 6805, 16873, 16872, 17009, 17511, 17227, 17213, 16862, 17212, 17499, 17486, 17483, 17508, 17225, 17494, 17492, 17440, 17487, 17485, 17436, 17481, 17434, 17495, 17437, 17375, 17373, 17372, 17374, 17507, 17219, 17502, 17493, 16858, 17223, 17221, 17344, 17484, 4878); +UPDATE `creature_model_info` SET `DisplayID_Other_Gender`=0, `VerifiedBuild`=46366 WHERE `DisplayID` IN (29702, 29701); + +-- Quests +DELETE FROM `creature_queststarter` WHERE `id`=34484; +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(34484, 14169, 46366); + +DELETE FROM `game_event_creature_quest` WHERE `id`=34484; + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN 144918 AND 144927; +DELETE FROM `creature` WHERE `guid` IN (145028, 145036); +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 144918 AND 144927; +DELETE FROM `game_event_creature` WHERE `guid` IN (145028, 145036); + +-- 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, 530, 3524, 0, '0', 0, 0, 0, 1, -4312.234375, -12449.03515625, 17.73958396911621093, 5.654866695404052734, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Chapman (Area: 0 - Difficulty: 0) +(@CGUID+1, 34383, 530, 3524, 0, '0', 0, 0, 0, 1, -4314.36474609375, -12451.16015625, 17.92534828186035156, 5.724679946899414062, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366), -- Catrina (Area: 0 - Difficulty: 0) +(@CGUID+2, 34484, 530, 3524, 0, '0', 0, 0, 0, 0, -4306.759765625, -12437.7001953125, 17.64093399047851562, 4.921828269958496093, 120, 0, 0, 18771, 2434, 0, 0, 0, 0, 46366), -- Cheerful Draenei Spirit (Area: 0 - Difficulty: 0) +(@CGUID+3, 35246, 530, 3524, 0, '0', 0, 0, 0, 0, -4322.423828125, -12449.6181640625, 16.97788047790527343, 6.2657318115234375, 120, 0, 0, 18771, 2434, 0, 0, 0, 0, 46366), -- Ghostly Draenei Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+4, 35246, 530, 3524, 0, '0', 0, 0, 0, 0, -4314.90625, -12430.2880859375, 17.558502197265625, 3.438298702239990234, 120, 0, 0, 18771, 2434, 0, 0, 0, 0, 46366), -- Ghostly Draenei Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+5, 35246, 530, 3524, 0, '0', 0, 0, 0, 0, -4320.296875, -12438.9267578125, 17.69791793823242187, 5.410520553588867187, 120, 0, 0, 18771, 2434, 0, 0, 0, 0, 46366), -- Ghostly Draenei Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+6, 35246, 530, 3524, 0, '0', 0, 0, 0, 0, -4322.69970703125, -12456.544921875, 17.44094657897949218, 6.0737457275390625, 120, 0, 0, 18771, 2434, 0, 0, 0, 0, 46366), -- Ghostly Draenei Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+7, 35246, 530, 3524, 0, '0', 0, 0, 0, 0, -4324.26416015625, -12444.34375, 17.27714729309082031, 4.398229598999023437, 120, 0, 0, 18771, 2434, 0, 0, 0, 0, 46366), -- Ghostly Draenei Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+8, 35246, 530, 3524, 0, '0', 0, 0, 0, 0, -4329.2119140625, -12448.7431640625, 17.27162742614746093, 0.506145477294921875, 120, 0, 0, 18771, 2434, 0, 0, 0, 0, 46366), -- Ghostly Draenei Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+9, 35246, 530, 3524, 0, '0', 0, 0, 0, 0, -4313.64013671875, -12442.5, 17.29663467407226562, 4.537856101989746093, 120, 0, 0, 18771, 2434, 0, 0, 0, 0, 46366), -- Ghostly Draenei Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+10, 35246, 530, 3524, 0, '0', 0, 0, 0, 0, -4312.236328125, -12434.603515625, 17.15652656555175781, 3.31612563133239746, 120, 0, 0, 18771, 2434, 0, 0, 0, 0, 46366), -- Ghostly Draenei Celebrant (Area: 0 - Difficulty: 0) +(@CGUID+11, 35246, 530, 3524, 0, '0', 0, 0, 0, 0, -4308.39404296875, -12429.40625, 17.04607200622558593, 4.206243515014648437, 120, 0, 0, 18771, 2434, 0, 0, 0, 0, 46366); -- Ghostly Draenei Celebrant (Area: 0 - Difficulty: 0) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 76284 AND 76290; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 76383 AND 76394; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 78449 AND 78453; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 78503 AND 78505; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 78526 AND 78532; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 78571 AND 78576; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 78611 AND 78613; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 78647 AND 78651; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 78683 AND 78686; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 78729 AND 78732; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 78907 AND 78954; +DELETE FROM `gameobject` WHERE `guid` IN (76256, 78414); +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 76284 AND 76290; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 76383 AND 76394; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78449 AND 78453; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78503 AND 78505; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78526 AND 78532; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78571 AND 78576; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78611 AND 78613; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78647 AND 78651; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78683 AND 78686; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78729 AND 78732; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 78907 AND 78954; +DELETE FROM `game_event_gameobject` WHERE `guid` IN (76256, 78414); + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+85; +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, 530, 3524, 0, '0', 0, 0, -4309.85791015625, -12416.4306640625, 20.66073417663574218, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+1, 180338, 530, 3524, 0, '0', 0, 0, -4308.205078125, -12421.5517578125, 17.49691581726074218, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+2, 180338, 530, 3524, 0, '0', 0, 0, -4308.07666015625, -12420.59375, 17.54628944396972656, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+3, 180338, 530, 3524, 0, '0', 0, 0, -4311.29345703125, -12421.767578125, 17.49123001098632812, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+4, 180338, 530, 3524, 0, '0', 0, 0, -4312.6162109375, -12419.576171875, 19.46298789978027343, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+5, 180338, 530, 3524, 0, '0', 0, 0, -4312.10400390625, -12418.41015625, 20.58255958557128906, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+6, 180338, 530, 3524, 0, '0', 0, 0, -4310.421875, -12422.125, 17.46414756774902343, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+7, 180338, 530, 3524, 0, '0', 0, 0, -4310.05908203125, -12417.6357421875, 20.57457733154296875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+8, 180338, 530, 3524, 0, '0', 0, 0, -4308.7900390625, -12417.271484375, 20.00327682495117187, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+9, 180338, 530, 3524, 0, '0', 0, 0, -4311.8525390625, -12419.1767578125, 20.15025520324707031, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+10, 180338, 530, 3524, 0, '0', 0, 0, -4313.0087890625, -12418.0283203125, 20.47431373596191406, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+11, 180338, 530, 3524, 0, '0', 0, 0, -4312.517578125, -12416.923828125, 20.90093421936035156, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+12, 180338, 530, 3524, 0, '0', 0, 0, -4308.60595703125, -12418.1357421875, 19.15999412536621093, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+13, 180338, 530, 3524, 0, '0', 0, 0, -4309.6005859375, -12418.798828125, 19.92153167724609375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+14, 180338, 530, 3524, 0, '0', 0, 0, -4313.97900390625, -12445.830078125, 17.23384857177734375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+15, 180338, 530, 3524, 0, '0', 0, 0, -4322.17529296875, -12438.732421875, 17.56374549865722656, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+16, 180338, 530, 3524, 0, '0', 0, 0, -4313.41650390625, -12447.03125, 17.36579322814941406, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+17, 180338, 530, 3524, 0, '0', 0, 0, -4310.421875, -12445.5595703125, 17.44871711730957031, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+18, 180338, 530, 3524, 0, '0', 0, 0, -4310.94970703125, -12444.8193359375, 17.38944244384765625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+19, 180338, 530, 3524, 0, '0', 0, 0, -4313.2099609375, -12446.544921875, 17.32340621948242187, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+20, 180338, 530, 3524, 0, '0', 0, 0, -4309.89404296875, -12439.97265625, 17.22673797607421875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+21, 180338, 530, 3524, 0, '0', 0, 0, -4314.8193359375, -12443.4267578125, 17.22012710571289062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+22, 180338, 530, 3524, 0, '0', 0, 0, -4314.50341796875, -12446.0419921875, 17.23437309265136718, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+23, 180338, 530, 3524, 0, '0', 0, 0, -4315.3193359375, -12442.5419921875, 17.24292564392089843, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+24, 180338, 530, 3524, 0, '0', 0, 0, -4323.88720703125, -12437.0419921875, 18.70215034484863281, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+25, 180338, 530, 3524, 0, '0', 0, 0, -4322.8349609375, -12438.40625, 17.56154441833496093, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+26, 180338, 530, 3524, 0, '0', 0, 0, -4325.65283203125, -12438.646484375, 19.28592872619628906, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+27, 180338, 530, 3524, 0, '0', 0, 0, -4324.65283203125, -12441.0517578125, 17.42333030700683593, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+28, 180338, 530, 3524, 0, '0', 0, 0, -4319.65283203125, -12448.138671875, 17.09421539306640625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+29, 180338, 530, 3524, 0, '0', 0, 0, -4325.1318359375, -12436.396484375, 19.81980133056640625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+30, 180338, 530, 3524, 0, '0', 0, 0, -4326.51904296875, -12438.9482421875, 18.94418907165527343, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+31, 180338, 530, 3524, 0, '0', 0, 0, -4326.47412109375, -12437.6767578125, 19.88735580444335937, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+32, 180338, 530, 3524, 0, '0', 0, 0, -4325.1787109375, -12440.21875, 17.47205352783203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+33, 180338, 530, 3524, 0, '0', 0, 0, -4324.63525390625, -12436.892578125, 19.43099021911621093, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+34, 180338, 530, 3524, 0, '0', 0, 0, -4326.96337890625, -12438.201171875, 19.36826705932617187, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+35, 180338, 530, 3524, 0, '0', 0, 0, -4325.11279296875, -12436.9658203125, 19.78217697143554687, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+36, 180338, 530, 3524, 0, '0', 0, 0, -4326.09912109375, -12438.25, 19.56963348388671875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+37, 180338, 530, 3524, 0, '0', 0, 0, -4324.32666015625, -12437.4970703125, 19.13780975341796875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+38, 180338, 530, 3524, 0, '0', 0, 0, -4324.39404296875, -12453.4931640625, 16.81945037841796875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+39, 180338, 530, 3524, 0, '0', 0, 0, -4325.24658203125, -12450.3017578125, 16.65173149108886718, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+40, 180338, 530, 3524, 0, '0', 0, 0, -4324.34228515625, -12454.451171875, 16.90607833862304687, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+41, 180338, 530, 3524, 0, '0', 0, 0, -4325.28662109375, -12453.732421875, 16.75984764099121093, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+42, 180338, 530, 3524, 0, '0', 0, 0, -4324.80712890625, -12450.669921875, 16.69210052490234375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+43, 180338, 530, 3524, 0, '0', 0, 0, -4325.12158203125, -12454.392578125, 16.82210540771484375, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46366), -- Candle 01 (Area: 0 - Difficulty: 0) +(@OGUID+44, 180339, 530, 3524, 0, '0', 0, 0, -4319.11962890625, -12456.25, 17.3489227294921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 02 (Area: 0 - Difficulty: 0) +(@OGUID+45, 180340, 530, 3524, 0, '0', 0, 0, -4318.69287109375, -12448.9580078125, 17.16887855529785156, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Candle 03 (Area: 0 - Difficulty: 0) +(@OGUID+46, 180340, 530, 3524, 0, '0', 0, 0, -4320.8212890625, -12452.9443359375, 17.18122291564941406, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 46366), -- Candle 03 (Area: 0 - Difficulty: 0) +(@OGUID+47, 180885, 530, 3524, 0, '0', 0, 0, -4318.9775390625, -12442.326171875, 17.2803955078125, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 46366), -- InnTableTiny (Area: 0 - Difficulty: 0) +(@OGUID+48, 182807, 530, 3524, 0, '0', 0, 0, -4309.3369140625, -12420.2744140625, 17.54578399658203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bottle (Area: 0 - Difficulty: 0) +(@OGUID+49, 182807, 530, 3524, 0, '0', 0, 0, -4314.44287109375, -12446.46875, 17.27439308166503906, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bottle (Area: 0 - Difficulty: 0) +(@OGUID+50, 182807, 530, 3524, 0, '0', 0, 0, -4325.0087890625, -12439.8818359375, 17.46257972717285156, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bottle (Area: 0 - Difficulty: 0) +(@OGUID+51, 182807, 530, 3524, 0, '0', 0, 0, -4323.4375, -12438.888671875, 17.51183891296386718, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bottle (Area: 0 - Difficulty: 0) +(@OGUID+52, 182807, 530, 3524, 0, '0', 0, 0, -4320.0224609375, -12455.6806640625, 17.30128669738769531, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bottle (Area: 0 - Difficulty: 0) +(@OGUID+53, 182807, 530, 3524, 0, '0', 0, 0, -4320.51904296875, -12453.1630859375, 17.25063705444335937, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bottle (Area: 0 - Difficulty: 0) +(@OGUID+54, 195063, 530, 3524, 0, '0', 0, 0, -4310.8837890625, -12445.173828125, 17.40244865417480468, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+55, 195063, 530, 3524, 0, '0', 0, 0, -4315.609375, -12442.861328125, 17.24088859558105468, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+56, 195063, 530, 3524, 0, '0', 0, 0, -4318.97216796875, -12441.6318359375, 18.41204261779785156, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+57, 195063, 530, 3524, 0, '0', 0, 0, -4323.720703125, -12439.263671875, 17.49479103088378906, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+58, 195063, 530, 3524, 0, '0', 0, 0, -4325.501953125, -12449.763671875, 16.71574592590332031, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+59, 195066, 530, 3524, 0, '0', 0, 0, -4310.30224609375, -12439.513671875, 17.13646507263183593, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bread of the Dead (Area: 0 - Difficulty: 0) +(@OGUID+60, 195066, 530, 3524, 0, '0', 0, 0, -4322.93212890625, -12439.4658203125, 17.49305534362792968, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bread of the Dead (Area: 0 - Difficulty: 0) +(@OGUID+61, 195066, 530, 3524, 0, '0', 0, 0, -4318.94775390625, -12448.236328125, 17.12119102478027343, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bread of the Dead (Area: 0 - Difficulty: 0) +(@OGUID+62, 195066, 530, 3524, 0, '0', 0, 0, -4319.33837890625, -12455.673828125, 17.32951545715332031, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bread of the Dead (Area: 0 - Difficulty: 0) +(@OGUID+63, 195067, 530, 3524, 0, '0', 0, 0, -4309.53125, -12421.048828125, 17.52263069152832031, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Mixed Fruit Bowl (Area: 0 - Difficulty: 0) +(@OGUID+64, 195067, 530, 3524, 0, '0', 0, 0, -4313.84716796875, -12446.4931640625, 17.29690933227539062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Mixed Fruit Bowl (Area: 0 - Difficulty: 0) +(@OGUID+65, 195067, 530, 3524, 0, '0', 0, 0, -4314.91162109375, -12442.8330078125, 17.23089027404785156, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Mixed Fruit Bowl (Area: 0 - Difficulty: 0) +(@OGUID+66, 195067, 530, 3524, 0, '0', 0, 0, -4324.767578125, -12454.0107421875, 16.80428314208984375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Mixed Fruit Bowl (Area: 0 - Difficulty: 0) +(@OGUID+67, 195067, 530, 3524, 0, '0', 0, 0, -4324.51025390625, -12450.021484375, 16.69842720031738281, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Mixed Fruit Bowl (Area: 0 - Difficulty: 0) +(@OGUID+68, 195068, 530, 3524, 0, '0', 0, 0, -4310.3369140625, -12439.53515625, 17.13308906555175781, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Offering Bowl (Area: 0 - Difficulty: 0) +(@OGUID+69, 195068, 530, 3524, 0, '0', 0, 0, -4318.94775390625, -12448.236328125, 17.12119102478027343, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Offering Bowl (Area: 0 - Difficulty: 0) +(@OGUID+70, 195068, 530, 3524, 0, '0', 0, 0, -4322.97216796875, -12439.4619140625, 17.49305534362792968, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Offering Bowl (Area: 0 - Difficulty: 0) +(@OGUID+71, 195068, 530, 3524, 0, '0', 0, 0, -4319.37353515625, -12455.69140625, 17.32845878601074218, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Offering Bowl (Area: 0 - Difficulty: 0) +(@OGUID+72, 195069, 530, 3524, 0, '0', 0, 0, -4318.515625, -12442.3994140625, 18.40369224548339843, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 46366), -- Candy Skulls (Area: 0 - Difficulty: 0) +(@OGUID+73, 195069, 530, 3524, 0, '0', 0, 0, -4319.01416015625, -12442.8681640625, 18.41169166564941406, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 46366), -- Candy Skulls (Area: 0 - Difficulty: 0) +(@OGUID+74, 195069, 530, 3524, 0, '0', 0, 0, -4319.54345703125, -12442.2744140625, 18.39897918701171875, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 46366), -- Candy Skulls (Area: 0 - Difficulty: 0) +(@OGUID+75, 195087, 530, 3524, 0, '0', 0, 0, -4323.8974609375, -12446.646484375, 17.00409698486328125, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 46366), -- Ghostly Cooking Fire (Area: 0 - Difficulty: 0) +(@OGUID+76, 195090, 530, 3524, 0, '0', 0, 0, -4311.05908203125, -12439.4658203125, 17.12792778015136718, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 46366), -- Spirit Candle (Area: 0 - Difficulty: 0) +(@OGUID+77, 195090, 530, 3524, 0, '0', 0, 0, -4323.68212890625, -12439.642578125, 17.47939491271972656, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 46366), -- Spirit Candle (Area: 0 - Difficulty: 0) +(@OGUID+78, 195090, 530, 3524, 0, '0', 0, 0, -4325.02099609375, -12437.486328125, 17.54513931274414062, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46366), -- Spirit Candle (Area: 0 - Difficulty: 0) +(@OGUID+79, 195307, 530, 3524, 0, '0', 0, 0, -4319.09375, -12442, 18.40237808227539062, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+80, 195307, 530, 3524, 0, '0', 0, 0, -4310.455078125, -12444.986328125, 17.43355751037597656, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+81, 195307, 530, 3524, 0, '0', 0, 0, -4322.37841796875, -12439.0595703125, 17.53725242614746093, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+82, 195307, 530, 3524, 0, '0', 0, 0, -4324.6181640625, -12440.138671875, 17.45537567138671875, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+83, 195307, 530, 3524, 0, '0', 0, 0, -4319.51904296875, -12455.021484375, 17.36684608459472656, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+84, 195307, 530, 3524, 0, '0', 0, 0, -4320.1962890625, -12452.8134765625, 17.29529380798339843, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46366), -- Orange Marigolds (Area: 0 - Difficulty: 0) +(@OGUID+85, 195307, 530, 3524, 0, '0', 0, 0, -4324.97216796875, -12449.4482421875, 16.71002388000488281, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 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+85; +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), +(51, @OGUID+39), +(51, @OGUID+40), +(51, @OGUID+41), +(51, @OGUID+42), +(51, @OGUID+43), +(51, @OGUID+44), +(51, @OGUID+45), +(51, @OGUID+46), +(51, @OGUID+47), +(51, @OGUID+48), +(51, @OGUID+49), +(51, @OGUID+50), +(51, @OGUID+51), +(51, @OGUID+52), +(51, @OGUID+53), +(51, @OGUID+54), +(51, @OGUID+55), +(51, @OGUID+56), +(51, @OGUID+57), +(51, @OGUID+58), +(51, @OGUID+59), +(51, @OGUID+60), +(51, @OGUID+61), +(51, @OGUID+62), +(51, @OGUID+63), +(51, @OGUID+64), +(51, @OGUID+65), +(51, @OGUID+66), +(51, @OGUID+67), +(51, @OGUID+68), +(51, @OGUID+69), +(51, @OGUID+70), +(51, @OGUID+71), +(51, @OGUID+72), +(51, @OGUID+73), +(51, @OGUID+74), +(51, @OGUID+75), +(51, @OGUID+76), +(51, @OGUID+77), +(51, @OGUID+78), +(51, @OGUID+79), +(51, @OGUID+80), +(51, @OGUID+81), +(51, @OGUID+82), +(51, @OGUID+83), +(51, @OGUID+84), +(51, @OGUID+85); |