diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_08_05_world.sql | 134 |
1 files changed, 134 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_08_05_world.sql b/sql/updates/world/master/2022_12_08_05_world.sql new file mode 100644 index 00000000000..bdb2c579890 --- /dev/null +++ b/sql/updates/world/master/2022_12_08_05_world.sql @@ -0,0 +1,134 @@ +SET @CGUID := 396583; +SET @OGUID := 249724; +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 +-- Refuge Pointe +(@CGUID+0, 32823, 0, 45, 320, '0', 0, 0, 0, 0, -1237.4600830078125, -2522.73095703125, 21.688140869140625, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Refuge Pointe - Difficulty: 0) (Auras: ) +(@CGUID+1, 34653, 0, 45, 320, '0', 0, 0, 0, 0, -1242.1319580078125, -2525.114501953125, 21.12179374694824218, 3.246312379837036132, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table Hostess (Area: Refuge Pointe - Difficulty: 0) +-- Hammerfall +(@CGUID+2, 32823, 0, 45, 321, '0', 0, 0, 0, 0, -1020.401123046875, -3561.13720703125, 56.92013931274414062, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Hammerfall - Difficulty: 0) (Auras: ) +(@CGUID+3, 34654, 0, 45, 321, '0', 0, 0, 0, 0, -1018.70660400390625, -3554.52783203125, 56.4930419921875, 1.326450228691101074, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Feast Hostess (Area: Hammerfall - Difficulty: 0) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+51; +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 +-- Refuge Pointe +(@OGUID+0, 179968, 0, 45, 320, '0', 0, 0, -1236.3177490234375, -2528.40625, 21.77256965637207031, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46741), -- Haystack 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+1, 179968, 0, 45, 320, '0', 0, 0, -1241.154541015625, -2525.09716796875, 21.15277862548828125, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 46741), -- Haystack 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+2, 179968, 0, 45, 320, '0', 0, 0, -1239.8802490234375, -2526.935791015625, 21.28518104553222656, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 46741), -- Haystack 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+3, 179968, 0, 45, 320, '0', 0, 0, -1230.8853759765625, -2523.927001953125, 22.20486068725585937, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 46741), -- Haystack 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+4, 179968, 0, 45, 320, '0', 0, 0, -1230.9149169921875, -2521.5712890625, 22.13194465637207031, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Haystack 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+5, 179968, 0, 45, 320, '0', 0, 0, -1233.35595703125, -2517.875, 21.69270896911621093, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 46741), -- Haystack 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+6, 179968, 0, 45, 320, '0', 0, 0, -1240.19970703125, -2518.411376953125, 21.65690040588378906, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46741), -- Haystack 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+7, 179968, 0, 45, 320, '0', 0, 0, -1233.66845703125, -2527.960205078125, 22.07986068725585937, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 46741), -- Haystack 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+8, 179968, 0, 45, 320, '0', 0, 0, -1235.4461669921875, -2517.263916015625, 21.84027862548828125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+9, 179968, 0, 45, 320, '0', 0, 0, -1242.1146240234375, -2520.546875, 21.27444648742675781, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Haystack 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+10, 180353, 0, 45, 320, '0', 0, 0, -1240.7708740234375, -2526.022705078125, 21.19011878967285156, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+11, 180353, 0, 45, 320, '0', 0, 0, -1234.8680419921875, -2528.15283203125, 21.96006965637207031, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+12, 180353, 0, 45, 320, '0', 0, 0, -1230.8524169921875, -2522.6875, 22.18055534362792968, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+13, 180353, 0, 45, 320, '0', 0, 0, -1234.4427490234375, -2517.42529296875, 21.73611068725585937, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+14, 180353, 0, 45, 320, '0', 0, 0, -1241.4149169921875, -2519.319580078125, 21.46396827697753906, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+15, 195164, 0, 45, 320, '0', 0, 0, -1236.3699951171875, -2528.340087890625, 22.41620063781738281, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+16, 195164, 0, 45, 320, '0', 0, 0, -1239.949951171875, -2526.860107421875, 21.92679977416992187, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+17, 195164, 0, 45, 320, '0', 0, 0, -1235.489990234375, -2517.360107421875, 22.4925994873046875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+18, 195164, 0, 45, 320, '0', 0, 0, -1240.219970703125, -2518.4599609375, 22.30159950256347656, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+19, 195164, 0, 45, 320, '0', 0, 0, -1233.530029296875, -2527.840087890625, 22.73740005493164062, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+20, 195164, 0, 45, 320, '0', 0, 0, -1231.02001953125, -2524.070068359375, 22.84679985046386718, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+21, 195164, 0, 45, 320, '0', 0, 0, -1241.0999755859375, -2525.050048828125, 21.80570030212402343, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+22, 195164, 0, 45, 320, '0', 0, 0, -1233.489990234375, -2517.889892578125, 22.34499931335449218, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+23, 195164, 0, 45, 320, '0', 0, 0, -1242.02001953125, -2520.590087890625, 21.93470001220703125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+24, 195164, 0, 45, 320, '0', 0, 0, -1231.010009765625, -2521.60009765625, 22.77039909362792968, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Refuge Pointe - Difficulty: 0) +(@OGUID+25, 195664, 0, 45, 320, '0', 0, 0, -1237.4599609375, -2522.72998046875, 21.60479927062988281, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Refuge Pointe - Difficulty: 0) +-- Hammerfall +(@OGUID+26, 179968, 0, 45, 321, '0', 0, 0, -1018.3853759765625, -3555.66845703125, 56.5973358154296875, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+27, 179968, 0, 45, 321, '0', 0, 0, -1016.296875, -3556.27783203125, 56.76736068725585937, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 46741), -- Haystack 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+28, 179968, 0, 45, 321, '0', 0, 0, -1023.140625, -3556.81591796875, 56.57509231567382812, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46741), -- Haystack 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+29, 179968, 0, 45, 321, '0', 0, 0, -1025.0555419921875, -3558.94970703125, 56.84895706176757812, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Haystack 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+30, 179968, 0, 45, 321, '0', 0, 0, -1016.609375, -3566.364501953125, 56.89757156372070312, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 46741), -- Haystack 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+31, 179968, 0, 45, 321, '0', 0, 0, -1022.82122802734375, -3565.34033203125, 56.60069656372070312, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 46741), -- Haystack 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+32, 179968, 0, 45, 321, '0', 0, 0, -1013.85589599609375, -3559.975830078125, 56.8211822509765625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Haystack 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+33, 179968, 0, 45, 321, '0', 0, 0, -1024.092041015625, -3563.501708984375, 56.74995803833007812, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 46741), -- Haystack 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+34, 179968, 0, 45, 321, '0', 0, 0, -1019.2603759765625, -3566.80908203125, 56.6961822509765625, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46741), -- Haystack 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+35, 179968, 0, 45, 321, '0', 0, 0, -1013.828125, -3562.33154296875, 56.8211822509765625, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 46741), -- Haystack 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+36, 180353, 0, 45, 321, '0', 0, 0, -1017.38372802734375, -3555.829833984375, 56.679840087890625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+37, 180353, 0, 45, 321, '0', 0, 0, -1024.35595703125, -3557.723876953125, 56.73611068725585937, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+38, 180353, 0, 45, 321, '0', 0, 0, -1023.7117919921875, -3564.427001953125, 56.67013931274414062, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+39, 180353, 0, 45, 321, '0', 0, 0, -1017.80902099609375, -3566.55908203125, 56.81423568725585937, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+40, 180353, 0, 45, 321, '0', 0, 0, -1013.79168701171875, -3561.09033203125, 56.82465362548828125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Hammerfall - Difficulty: 0) +(@OGUID+41, 195164, 0, 45, 321, '0', 0, 0, -1023.15972900390625, -3556.861083984375, 57.26248550415039062, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Hammerfall - Difficulty: 0) +(@OGUID+42, 195164, 0, 45, 321, '0', 0, 0, -1018.4271240234375, -3555.76220703125, 57.2840118408203125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Hammerfall - Difficulty: 0) +(@OGUID+43, 195164, 0, 45, 321, '0', 0, 0, -1016.43402099609375, -3556.29345703125, 57.44196319580078125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Hammerfall - Difficulty: 0) +(@OGUID+44, 195164, 0, 45, 321, '0', 0, 0, -1013.96527099609375, -3562.475830078125, 57.50272750854492187, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Hammerfall - Difficulty: 0) +(@OGUID+45, 195164, 0, 45, 321, '0', 0, 0, -1022.888916015625, -3565.26904296875, 57.28397750854492187, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Hammerfall - Difficulty: 0) +(@OGUID+46, 195164, 0, 45, 321, '0', 0, 0, -1019.310791015625, -3566.739501953125, 57.36977005004882812, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Hammerfall - Difficulty: 0) +(@OGUID+47, 195164, 0, 45, 321, '0', 0, 0, -1013.9478759765625, -3560.00341796875, 57.5009918212890625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Hammerfall - Difficulty: 0) +(@OGUID+48, 195164, 0, 45, 321, '0', 0, 0, -1024.04345703125, -3563.458251953125, 57.43094253540039062, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Hammerfall - Difficulty: 0) +(@OGUID+49, 195164, 0, 45, 321, '0', 0, 0, -1024.9583740234375, -3558.99658203125, 57.52529525756835937, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Hammerfall - Difficulty: 0) +(@OGUID+50, 195164, 0, 45, 321, '0', 0, 0, -1016.46881103515625, -3566.24658203125, 57.57217025756835937, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Hammerfall - Difficulty: 0) +(@OGUID+51, 195664, 0, 45, 321, '0', 0, 0, -1020.4000244140625, -3561.139892578125, 56.83679962158203125, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Hammerfall - 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+51; +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), +(@EVENT, @OGUID+46), +(@EVENT, @OGUID+47), +(@EVENT, @OGUID+48), +(@EVENT, @OGUID+49), +(@EVENT, @OGUID+50), +(@EVENT, @OGUID+51); |