diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_07_10_world.sql | 90 |
1 files changed, 90 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_07_10_world.sql b/sql/updates/world/master/2022_12_07_10_world.sql new file mode 100644 index 00000000000..bd2a218834f --- /dev/null +++ b/sql/updates/world/master/2022_12_07_10_world.sql @@ -0,0 +1,90 @@ +SET @CGUID := 396562; +SET @OGUID := 249484; +SET @EVENT := 26; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+3; +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, 1, 440, 976, '0', 0, 0, 0, 0, -7070.2099609375, -3826.169921875, 9.26917266845703125, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Gadgetzan - Difficulty: 0) +(@CGUID+1, 32823, 1, 440, 976, '0', 0, 0, 0, 0, -7203.52001953125, -3765.3798828125, 8.921873092651367187, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Gadgetzan - Difficulty: 0) +(@CGUID+2, 34653, 1, 440, 976, '0', 0, 0, 0, 0, -7196.68994140625, -3764.31005859375, 8.851963043212890625, 5.777040004730224609, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table Hostess (Area: Gadgetzan - Difficulty: 0) +(@CGUID+3, 34654, 1, 440, 976, '0', 0, 0, 0, 0, -7075.240234375, -3821.580078125, 9.161672592163085937, 2.460914134979248046, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Feast Hostess (Area: Gadgetzan - Difficulty: 0) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+31; +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, 1, 440, 976, '0', 0, 0, -7072.81982421875, -3823.419921875, 9.185839653015136718, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 46741), -- Haystack 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+1, 179968, 1, 440, 976, '0', 0, 0, -7072.740234375, -3828.139892578125, 9.185850143432617187, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 46741), -- Haystack 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+2, 179968, 1, 440, 976, '0', 0, 0, -7065.3798828125, -3826.070068359375, 9.185839653015136718, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46741), -- Haystack 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+3, 179968, 1, 440, 976, '0', 0, 0, -7068.259765625, -3829.760009765625, 9.185839653015136718, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 46741), -- Haystack 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+4, 179968, 1, 440, 976, '0', 0, 0, -7067.97021484375, -3822.1298828125, 9.159720420837402343, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 46741), -- Haystack 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+5, 179968, 1, 440, 976, '0', 0, 0, -7198.33984375, -3765.639892578125, 8.810009956359863281, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46741), -- Haystack 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+6, 179968, 1, 440, 976, '0', 0, 0, -7201.06005859375, -3761.27001953125, 8.987850189208984375, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 46741), -- Haystack 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+7, 179968, 1, 440, 976, '0', 0, 0, -7205.77978515625, -3767.580078125, 8.535389900207519531, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 46741), -- Haystack 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+8, 179968, 1, 440, 976, '0', 0, 0, -7201.4599609375, -3769.260009765625, 8.711529731750488281, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 46741), -- Haystack 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+9, 179968, 1, 440, 976, '0', 0, 0, -7206.33984375, -3762.449951171875, 8.859379768371582031, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 46741), -- Haystack 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+10, 180353, 1, 440, 976, '0', 0, 0, -7073.77001953125, -3822.570068359375, 9.152779579162597656, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+11, 180353, 1, 440, 976, '0', 0, 0, -7073.669921875, -3828.5400390625, 9.185850143432617187, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+12, 180353, 1, 440, 976, '0', 0, 0, -7067.81005859375, -3830.85009765625, 9.185839653015136718, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+13, 180353, 1, 440, 976, '0', 0, 0, -7067.7001953125, -3821.090087890625, 9.099229812622070312, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+14, 180353, 1, 440, 976, '0', 0, 0, -7064.1201171875, -3826, 9.185839653015136718, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+15, 180353, 1, 440, 976, '0', 0, 0, -7197.43994140625, -3765.679931640625, 8.788129806518554687, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+16, 180353, 1, 440, 976, '0', 0, 0, -7206.669921875, -3768.2900390625, 8.401160240173339843, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+17, 180353, 1, 440, 976, '0', 0, 0, -7201.009765625, -3770.60009765625, 8.586810111999511718, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+18, 180353, 1, 440, 976, '0', 0, 0, -7207.10986328125, -3761.669921875, 8.904509544372558593, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+19, 180353, 1, 440, 976, '0', 0, 0, -7200.580078125, -3760.449951171875, 8.96875, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Gadgetzan - Difficulty: 0) +(@OGUID+20, 195164, 1, 440, 976, '0', 0, 0, -7072.919921875, -3823.449951171875, 9.89134979248046875, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 46741), -- Pumpkin (Area: Gadgetzan - Difficulty: 0) +(@OGUID+21, 195164, 1, 440, 976, '0', 0, 0, -7068.06005859375, -3822.159912109375, 9.865229606628417968, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 46741), -- Pumpkin (Area: Gadgetzan - Difficulty: 0) +(@OGUID+22, 195164, 1, 440, 976, '0', 0, 0, -7068.2998046875, -3829.85009765625, 9.89134979248046875, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 46741), -- Pumpkin (Area: Gadgetzan - Difficulty: 0) +(@OGUID+23, 195164, 1, 440, 976, '0', 0, 0, -7072.8798828125, -3828.2900390625, 9.89134979248046875, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 46741), -- Pumpkin (Area: Gadgetzan - Difficulty: 0) +(@OGUID+24, 195164, 1, 440, 976, '0', 0, 0, -7065.52001953125, -3826.219970703125, 9.89134979248046875, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46741), -- Pumpkin (Area: Gadgetzan - Difficulty: 0) +(@OGUID+25, 195164, 1, 440, 976, '0', 0, 0, -7198.39013671875, -3765.570068359375, 9.516889572143554687, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46741), -- Pumpkin (Area: Gadgetzan - Difficulty: 0) +(@OGUID+26, 195164, 1, 440, 976, '0', 0, 0, -7206.25, -3762.5, 9.564889907836914062, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 46741), -- Pumpkin (Area: Gadgetzan - Difficulty: 0) +(@OGUID+27, 195164, 1, 440, 976, '0', 0, 0, -7205.85009765625, -3767.510009765625, 9.247170448303222656, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 46741), -- Pumpkin (Area: Gadgetzan - Difficulty: 0) +(@OGUID+28, 195164, 1, 440, 976, '0', 0, 0, -7201.35986328125, -3769.31005859375, 9.414119720458984375, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 46741), -- Pumpkin (Area: Gadgetzan - Difficulty: 0) +(@OGUID+29, 195164, 1, 440, 976, '0', 0, 0, -7201.080078125, -3761.31005859375, 9.693360328674316406, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 46741), -- Pumpkin (Area: Gadgetzan - Difficulty: 0) +(@OGUID+30, 195664, 1, 440, 976, '0', 0, 0, -7070.2099609375, -3826.169921875, 9.185839653015136718, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Gadgetzan - Difficulty: 0) +(@OGUID+31, 195664, 1, 440, 976, '0', 0, 0, -7203.52001953125, -3765.3798828125, 8.838540077209472656, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Gadgetzan - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+3; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(@EVENT, @CGUID+0), +(@EVENT, @CGUID+1), +(@EVENT, @CGUID+2), +(@EVENT, @CGUID+3); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+31; +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); |