diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_06_06_world.sql | 154 |
1 files changed, 154 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_06_06_world.sql b/sql/updates/world/master/2022_12_06_06_world.sql new file mode 100644 index 00000000000..97f1e03047e --- /dev/null +++ b/sql/updates/world/master/2022_12_06_06_world.sql @@ -0,0 +1,154 @@ +SET @CGUID := 396513; +SET @OGUID := 248956; +SET @EVENT := 26; + +-- Creature templates +UPDATE `creature_template` SET `gossip_menu_id`=10569, `minlevel`=60, `maxlevel`=60 WHERE `entry`=34786; -- Alice Rigsdale +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=34787; -- John Rigsdale + +-- Equipments +UPDATE `creature_equip_template` SET `VerifiedBuild`=46741 WHERE (`ID`=1 AND `CreatureID` IN (50484,34786,19882,18951,16221,16192,15970)); + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE `DifficultyID`=0 AND `Entry` IN (34786, 34787); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(34786, 0, 0, 0, 389, 46741), +(34787, 0, 0, 0, 389, 46741); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=46741 WHERE (`DifficultyID`=0 AND `Entry` IN (118514,118510,50484,27946,19882,19169,18951,16221,16192,15971,15970,15649,13321)); + +-- Trainer +DELETE FROM `creature_trainer` WHERE `CreatureID`=34786; +INSERT INTO `creature_trainer` (`CreatureID`, `TrainerID`, `MenuID`, `OptionID`) VALUES +(34786, 136, 10569, 0); + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN 138374 AND 138377; +DELETE FROM `creature` WHERE `guid` BETWEEN 138398 AND 138401; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 138374 AND 138377; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 138398 AND 138401; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+6; +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, 32823, 530, 3430, 3470, '0', 0, 0, 0, 0, 9296.4033203125, -7226.96337890625, 16.6186065673828125, 4.729842185974121093, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Stillwhisper Pond - Difficulty: 0) (Auras: ) +(@CGUID+1, 32823, 530, 3430, 3470, '0', 0, 0, 0, 0, 9295.8486328125, -7211.7119140625, 16.3680877685546875, 2.042035102844238281, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Stillwhisper Pond - Difficulty: 0) (Auras: ) +(@CGUID+2, 32823, 530, 3430, 3470, '0', 0, 0, 0, 0, 9284.7724609375, -7226.8818359375, 16.1937103271484375, 2.042035102844238281, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Stillwhisper Pond - Difficulty: 0) +(@CGUID+3, 32823, 530, 3430, 3470, '0', 0, 0, 0, 0, 9280.703125, -7211.20849609375, 16.18792915344238281, 1.588249564170837402, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Stillwhisper Pond - Difficulty: 0) +(@CGUID+4, 34654, 530, 3430, 3470, '0', 0, 0, 0, 0, 9291.8466796875, -7219.40966796875, 16.43518829345703125, 5.969026088714599609, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Feast Hostess (Area: Stillwhisper Pond - Difficulty: 0) +(@CGUID+5, 34786, 530, 3430, 3470, '0', 0, 0, 0, 1, 9305.00390625, -7249.3974609375, 14.94988441467285156, 6.2657318115234375, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Alice Rigsdale (Area: Stillwhisper Pond - Difficulty: 0) +(@CGUID+6, 34787, 530, 3430, 3470, '0', 0, 0, 0, 0, 9304.75390625, -7259.36962890625, 15.04354286193847656, 6.126105785369873046, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- John Rigsdale (Area: Stillwhisper Pond - Difficulty: 0) (Auras: ) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 76560 AND 76646; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 76560 AND 76646; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+45; +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, 179968, 530, 3430, 3470, '0', 0, 0, 9305.0068359375, -7212.95166015625, 15.99479198455810546, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+1, 179968, 530, 3430, 3470, '0', 0, 0, 9305.26953125, -7210.56787109375, 15.97048664093017578, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+2, 179968, 530, 3430, 3470, '0', 0, 0, 9294.703125, -7203.7412109375, 16.54340362548828125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+3, 179968, 530, 3430, 3470, '0', 0, 0, 9289.634765625, -7236.01220703125, 17.17300033569335937, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+4, 179968, 530, 3430, 3470, '0', 0, 0, 9304.60546875, -7259.4443359375, 14.34722232818603515, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+5, 179968, 530, 3430, 3470, '0', 0, 0, 9304.48828125, -7261.2744140625, 14.31076431274414062, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+6, 179968, 530, 3430, 3470, '0', 0, 0, 9303.0126953125, -7234.57470703125, 15.75159931182861328, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+7, 179968, 530, 3430, 3470, '0', 0, 0, 9305.0673828125, -7249.5, 14.25955581665039062, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+8, 179968, 530, 3430, 3470, '0', 0, 0, 9297.099609375, -7203.484375, 16.41493034362792968, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+9, 179968, 530, 3430, 3470, '0', 0, 0, 9276.224609375, -7217.671875, 15.88194465637207031, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+10, 179968, 530, 3430, 3470, '0', 0, 0, 9276.4111328125, -7221.0556640625, 15.85069465637207031, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+11, 179968, 530, 3430, 3470, '0', 0, 0, 9287.59765625, -7235.8037109375, 17.13194465637207031, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+12, 179968, 530, 3430, 3470, '0', 0, 0, 9303.482421875, -7232.4443359375, 15.7602996826171875, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 46741), -- Haystack 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+13, 180353, 530, 3430, 3470, '0', 0, 0, 9305.0126953125, -7211.8505859375, 15.98958301544189453, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+14, 180353, 530, 3430, 3470, '0', 0, 0, 9301.486328125, -7251.3681640625, 15.19187641143798828, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+15, 180353, 530, 3430, 3470, '0', 0, 0, 9303.056640625, -7233.4443359375, 15.78819465637207031, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+16, 180353, 530, 3430, 3470, '0', 0, 0, 9304.5849609375, -7258.23095703125, 14.35193252563476562, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+17, 180353, 530, 3430, 3470, '0', 0, 0, 9301.3720703125, -7247.44091796875, 15.43840694427490234, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+18, 180353, 530, 3430, 3470, '0', 0, 0, 9295.822265625, -7203.51416015625, 16.49262237548828125, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+19, 180353, 530, 3430, 3470, '0', 0, 0, 9276.0595703125, -7219.19775390625, 15.84511280059814453, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+20, 180353, 530, 3430, 3470, '0', 0, 0, 9288.66015625, -7235.8505859375, 17.15571022033691406, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+21, 195164, 530, 3430, 3470, '0', 0, 0, 9305.1455078125, -7212.83154296875, 16.65938758850097656, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+22, 195164, 530, 3430, 3470, '0', 0, 0, 9305.1806640625, -7210.595703125, 16.65576171875, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+23, 195164, 530, 3430, 3470, '0', 0, 0, 9303.58203125, -7232.48974609375, 16.42238807678222656, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+24, 195164, 530, 3430, 3470, '0', 0, 0, 9304.6650390625, -7262.15966796875, 14.31762218475341796, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+25, 195164, 530, 3430, 3470, '0', 0, 0, 9296.9931640625, -7203.6494140625, 17.09404945373535156, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+26, 195164, 530, 3430, 3470, '0', 0, 0, 9287.6484375, -7235.7587890625, 17.80996131896972656, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+27, 195164, 530, 3430, 3470, '0', 0, 0, 9276.09765625, -7217.72412109375, 16.55504226684570312, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+28, 195164, 530, 3430, 3470, '0', 0, 0, 9302.9599609375, -7248.02783203125, 15.27427005767822265, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+29, 195164, 530, 3430, 3470, '0', 0, 0, 9304.4892578125, -7261.16845703125, 15.00296878814697265, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+30, 195164, 530, 3430, 3470, '0', 0, 0, 9303.107421875, -7234.61962890625, 16.4102325439453125, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+31, 195164, 530, 3430, 3470, '0', 0, 0, 9294.634765625, -7203.6806640625, 17.23141288757324218, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+32, 195164, 530, 3430, 3470, '0', 0, 0, 9289.572265625, -7236.0537109375, 17.85575103759765625, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+33, 195164, 530, 3430, 3470, '0', 0, 0, 9276.400390625, -7221.158203125, 16.53277015686035156, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 46741), -- Pumpkin (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+34, 195191, 530, 3430, 3470, '0', 0, 0, 9303.4970703125, -7249.4912109375, 14.3873138427734375, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Dwarven Table Simple 05 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+35, 195192, 530, 3430, 3470, '0', 0, 0, 9303.765625, -7247.81103515625, 15.29548168182373046, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 46741), -- Basket of Corn (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+36, 195194, 530, 3430, 3470, '0', 0, 0, 9303.9619140625, -7248.7255859375, 15.29372692108154296, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46741), -- Small Basket 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+37, 195195, 530, 3430, 3470, '0', 0, 0, 9303.9921875, -7250.970703125, 15.21642208099365234, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 46741), -- Cranberry Masher (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+38, 195196, 530, 3430, 3470, '0', 0, 0, 9303.05078125, -7246.0244140625, 15.05563735961914062, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46741), -- Large Basket 03 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+39, 195197, 530, 3430, 3470, '0', 0, 0, 9304.3134765625, -7246.58837890625, 14.63839435577392578, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46741), -- Grain Sack 02 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+40, 195198, 530, 3430, 3470, '0', 0, 0, 9305.7646484375, -7247.140625, 14.36336231231689453, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 46741), -- Crate 01 (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+41, 195200, 530, 3430, 3470, '0', 0, 0, 9303.623046875, -7252.99462890625, 14.25869560241699218, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pilgrim's Bounty Cooking Fire (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+42, 195664, 530, 3430, 3470, '0', 0, 0, 9296.4033203125, -7226.96337890625, 16.53528213500976562, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+43, 195664, 530, 3430, 3470, '0', 0, 0, 9295.8486328125, -7211.7119140625, 16.28475379943847656, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+44, 195664, 530, 3430, 3470, '0', 0, 0, 9280.703125, -7211.20849609375, 16.10459518432617187, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Stillwhisper Pond - Difficulty: 0) +(@OGUID+45, 195664, 530, 3430, 3470, '0', 0, 0, 9284.7705078125, -7226.8818359375, 16.11033821105957031, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Stillwhisper Pond - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+6; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(@EVENT, @CGUID+0), +(@EVENT, @CGUID+1), +(@EVENT, @CGUID+2), +(@EVENT, @CGUID+3), +(@EVENT, @CGUID+4), +(@EVENT, @CGUID+5), +(@EVENT, @CGUID+6); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+45; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(@EVENT, @OGUID+0), +(@EVENT, @OGUID+1), +(@EVENT, @OGUID+2), +(@EVENT, @OGUID+3), +(@EVENT, @OGUID+4), +(@EVENT, @OGUID+5), +(@EVENT, @OGUID+6), +(@EVENT, @OGUID+7), +(@EVENT, @OGUID+8), +(@EVENT, @OGUID+9), +(@EVENT, @OGUID+10), +(@EVENT, @OGUID+11), +(@EVENT, @OGUID+12), +(@EVENT, @OGUID+13), +(@EVENT, @OGUID+14), +(@EVENT, @OGUID+15), +(@EVENT, @OGUID+16), +(@EVENT, @OGUID+17), +(@EVENT, @OGUID+18), +(@EVENT, @OGUID+19), +(@EVENT, @OGUID+20), +(@EVENT, @OGUID+21), +(@EVENT, @OGUID+22), +(@EVENT, @OGUID+23), +(@EVENT, @OGUID+24), +(@EVENT, @OGUID+25), +(@EVENT, @OGUID+26), +(@EVENT, @OGUID+27), +(@EVENT, @OGUID+28), +(@EVENT, @OGUID+29), +(@EVENT, @OGUID+30), +(@EVENT, @OGUID+31), +(@EVENT, @OGUID+32), +(@EVENT, @OGUID+33), +(@EVENT, @OGUID+34), +(@EVENT, @OGUID+35), +(@EVENT, @OGUID+36), +(@EVENT, @OGUID+37), +(@EVENT, @OGUID+38), +(@EVENT, @OGUID+39), +(@EVENT, @OGUID+40), +(@EVENT, @OGUID+41), +(@EVENT, @OGUID+42), +(@EVENT, @OGUID+43), +(@EVENT, @OGUID+44), +(@EVENT, @OGUID+45); |