diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_06_05_world.sql | 112 |
1 files changed, 112 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_06_05_world.sql b/sql/updates/world/master/2022_12_06_05_world.sql new file mode 100644 index 00000000000..bbfca291d9d --- /dev/null +++ b/sql/updates/world/master/2022_12_06_05_world.sql @@ -0,0 +1,112 @@ +SET @CGUID := 396509; +SET @OGUID := 248913; +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, 0, 85, 159, '0', 0, 0, 0, 0, 2293.982666015625, 361.97222900390625, 34.36455154418945312, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Brill - Difficulty: 0) (Auras: ) +(@CGUID+1, 32823, 0, 85, 159, '0', 0, 0, 0, 0, 2292.44970703125, 349.951385498046875, 33.85086441040039062, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Brill - Difficulty: 0) (Auras: ) +(@CGUID+2, 32823, 0, 85, 159, '0', 0, 0, 0, 0, 2294.838623046875, 375.8819580078125, 34.56729888916015625, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Brill - Difficulty: 0) +(@CGUID+3, 34654, 0, 85, 159, '0', 0, 0, 0, 0, 2287.913330078125, 382.56597900390625, 34.3078460693359375, 2.827433347702026367, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Feast Hostess (Area: Brill - Difficulty: 0) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+42; +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, 0, 85, 159, '0', 0, 0, 2288.4150390625, 359.59027099609375, 33.86261367797851562, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+1, 179968, 0, 85, 159, '0', 0, 0, 2288.28125, 357.52777099609375, 33.86959457397460937, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+2, 179968, 0, 85, 159, '0', 0, 0, 2301.053955078125, 358.5694580078125, 34.22692489624023437, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+3, 179968, 0, 85, 159, '0', 0, 0, 2288.944580078125, 369.154510498046875, 34.29419708251953125, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+4, 179968, 0, 85, 159, '0', 0, 0, 2300.119873046875, 347.177093505859375, 34.94915008544921875, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+5, 179968, 0, 85, 159, '0', 0, 0, 2300.81591796875, 356.142364501953125, 34.36153411865234375, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+6, 179968, 0, 85, 159, '0', 0, 0, 2289.182373046875, 371.58160400390625, 34.24504470825195312, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+7, 179968, 0, 85, 159, '0', 0, 0, 2298.78466796875, 344.916656494140625, 34.8040618896484375, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+8, 179968, 0, 85, 159, '0', 0, 0, 2299.911376953125, 383.348968505859375, 34.33384323120117187, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+9, 179968, 0, 85, 159, '0', 0, 0, 2291.901123046875, 383.59375, 34.67378616333007812, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+10, 179968, 0, 85, 159, '0', 0, 0, 2301.741455078125, 371.81597900390625, 34.18433761596679687, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+11, 179968, 0, 85, 159, '0', 0, 0, 2301.6806640625, 380.69097900390625, 34.23750686645507812, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+12, 179968, 0, 85, 159, '0', 0, 0, 2289.984375, 381.458343505859375, 34.46272659301757812, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+13, 179968, 0, 85, 159, '0', 0, 0, 2288.895751953125, 345.3975830078125, 33.69190597534179687, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+14, 179968, 0, 85, 159, '0', 0, 0, 2301.50341796875, 369.388885498046875, 34.13194656372070312, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+15, 179968, 0, 85, 159, '0', 0, 0, 2287.16845703125, 347.572906494140625, 33.71104049682617187, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 46741), -- Haystack 01 (Area: Brill - Difficulty: 0) +(@OGUID+16, 180353, 0, 85, 159, '0', 0, 0, 2288.41845703125, 358.6632080078125, 33.8912811279296875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Brill - Difficulty: 0) +(@OGUID+17, 180353, 0, 85, 159, '0', 0, 0, 2287.704833984375, 346.008697509765625, 33.66175079345703125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Brill - Difficulty: 0) +(@OGUID+18, 180353, 0, 85, 159, '0', 0, 0, 2299.8212890625, 345.776031494140625, 35.00998306274414062, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Brill - Difficulty: 0) +(@OGUID+19, 180353, 0, 85, 159, '0', 0, 0, 2301.07470703125, 382.375, 34.26987075805664062, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Brill - Difficulty: 0) +(@OGUID+20, 180353, 0, 85, 159, '0', 0, 0, 2300.986083984375, 357.49652099609375, 34.297515869140625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Brill - Difficulty: 0) +(@OGUID+21, 180353, 0, 85, 159, '0', 0, 0, 2301.673583984375, 370.743072509765625, 34.1649322509765625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Brill - Difficulty: 0) +(@OGUID+22, 180353, 0, 85, 159, '0', 0, 0, 2289.114501953125, 370.5069580078125, 34.24508285522460937, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Brill - Difficulty: 0) +(@OGUID+23, 180353, 0, 85, 159, '0', 0, 0, 2290.685791015625, 382.68402099609375, 34.5560760498046875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Brill - Difficulty: 0) +(@OGUID+24, 195164, 0, 85, 159, '0', 0, 0, 2288.421875, 357.645843505859375, 34.57043838500976562, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+25, 195164, 0, 85, 159, '0', 0, 0, 2288.364501953125, 359.65972900390625, 34.55441665649414062, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+26, 195164, 0, 85, 159, '0', 0, 0, 2301.619873046875, 380.70660400390625, 34.9311981201171875, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+27, 195164, 0, 85, 159, '0', 0, 0, 2290.083251953125, 381.4132080078125, 35.16243362426757812, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+28, 195164, 0, 85, 159, '0', 0, 0, 2289.23095703125, 371.626739501953125, 34.93951797485351562, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+29, 195164, 0, 85, 159, '0', 0, 0, 2288.994873046875, 345.352447509765625, 34.38866424560546875, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+30, 195164, 0, 85, 159, '0', 0, 0, 2301.435791015625, 369.458343505859375, 34.8280181884765625, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+31, 195164, 0, 85, 159, '0', 0, 0, 2300.02783203125, 347.149322509765625, 35.63222885131835937, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+32, 195164, 0, 85, 159, '0', 0, 0, 2298.647705078125, 344.774322509765625, 35.46854019165039062, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+33, 195164, 0, 85, 159, '0', 0, 0, 2287.1494140625, 347.52777099609375, 34.40044021606445312, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+34, 195164, 0, 85, 159, '0', 0, 0, 2291.882080078125, 383.548614501953125, 35.36870956420898437, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+35, 195164, 0, 85, 159, '0', 0, 0, 2288.876708984375, 369.223968505859375, 34.9853515625, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+36, 195164, 0, 85, 159, '0', 0, 0, 2301.1025390625, 358.614593505859375, 34.91568756103515625, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+37, 195164, 0, 85, 159, '0', 0, 0, 2300.748291015625, 356.211822509765625, 35.05194091796875, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+38, 195164, 0, 85, 159, '0', 0, 0, 2301.7900390625, 371.861114501953125, 34.87445068359375, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+39, 195164, 0, 85, 159, '0', 0, 0, 2299.869873046875, 383.255218505859375, 35.0262298583984375, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 46741), -- Pumpkin (Area: Brill - Difficulty: 0) +(@OGUID+40, 195664, 0, 85, 159, '0', 0, 0, 2294.90283203125, 375.9444580078125, 34.48655319213867187, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Brill - Difficulty: 0) +(@OGUID+41, 195664, 0, 85, 159, '0', 0, 0, 2292.44970703125, 349.951385498046875, 33.7675323486328125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Brill - Difficulty: 0) +(@OGUID+42, 195664, 0, 85, 159, '0', 0, 0, 2293.982666015625, 361.97222900390625, 34.281219482421875, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Brill - 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+42; +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); |