diff options
| -rw-r--r-- | sql/updates/world/cata_classic/2024_11_19_01_world.sql | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_11_19_01_world.sql b/sql/updates/world/cata_classic/2024_11_19_01_world.sql new file mode 100644 index 00000000000..46fa416b713 --- /dev/null +++ b/sql/updates/world/cata_classic/2024_11_19_01_world.sql @@ -0,0 +1,34 @@ +SET @CGUID := 3990055; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+26; +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`, `curHealthPct`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 28596, 0, 1519, 5149, '0', '0', 0, 0, 1, -8873.216796875, 513.265625, 138.9873809814453125, 2.0245819091796875, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Old Town - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+1, 28569, 0, 1519, 5149, '0', '0', 0, 0, 1, -8890.4658203125, 510.907989501953125, 111.06097412109375, 1.239183783531188964, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Old Town - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+2, 28596, 0, 1519, 5149, '0', '0', 0, 0, 1, -8889.9462890625, 511.045135498046875, 118.5446243286132812, 1.274090290069580078, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Old Town - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+3, 28569, 0, 1519, 5149, '0', '0', 0, 0, 1, -8870.986328125, 510.67535400390625, 156.72705078125, 1.850049018859863281, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Old Town - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+4, 28596, 0, 1519, 5149, '0', '0', 0, 0, 1, -8867.9326171875, 512.85418701171875, 156.8819732666015625, 2.251474618911743164, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Old Town - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+5, 28569, 0, 1519, 5149, '0', '0', 0, 0, 1, -8892.595703125, 512.19097900390625, 125.690948486328125, 1.029744267463684082, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Old Town - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+6, 28596, 0, 1519, 5149, '0', '0', 0, 0, 1, -8895.845703125, 514.5625, 118.3676376342773437, 0.645771801471710205, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Old Town - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+7, 28569, 0, 1519, 5149, '0', '0', 0, 0, 1, -8900.5068359375, 520.53125, 116.60943603515625, 0.628318548202514648, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Old Town - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+8, 28569, 0, 1519, 1617, '0', '0', 0, 0, 1, -8926.86328125, 565.38543701171875, 144.0575103759765625, 1.850049018859863281, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Valley of Heroes - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+9, 28569, 0, 1519, 5148, '0', '0', 0, 0, 1, -8942.861328125, 574.21527099609375, 124.74554443359375, 0.767944872379302978, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+10, 28596, 0, 1519, 5148, '0', '0', 0, 0, 1, -8942.015625, 573.38714599609375, 133.677093505859375, 0.645771801471710205, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+11, 28596, 0, 1519, 5148, '0', '0', 0, 0, 1, -8909.0869140625, 590.81768798828125, 158.6290740966796875, 5.131268024444580078, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+12, 28569, 0, 1519, 5148, '0', '0', 0, 0, 1, -8949.451171875, 587.7725830078125, 127.78521728515625, 6.143558979034423828, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+13, 28596, 0, 1519, 5148, '0', '0', 0, 0, 1, -8946.359375, 579.0242919921875, 133.6439056396484375, 0.645771801471710205, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+14, 28569, 0, 1519, 5148, '0', '0', 0, 0, 1, -8945.763671875, 577.6336669921875, 115.4397125244140625, 0.628318548202514648, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+15, 28596, 0, 1519, 5148, '0', '0', 0, 0, 1, -8914.7099609375, 605.22393798828125, 162.284423828125, 1.710422635078430175, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 (Auras: 42716 - Self Root Forever (No Visual)) +(@CGUID+16, 28569, 0, 1519, 5148, '0', '0', 0, 0, 0, -8990.65625, 398.78125, 73.34175872802734375, 5.078907966613769531, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 +(@CGUID+17, 28596, 0, 1519, 5148, '0', '0', 0, 0, 0, -9013.83203125, 404.17535400390625, 74.7145233154296875, 1.832595705986022949, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 +(@CGUID+18, 28596, 0, 1519, 5148, '0', '0', 0, 0, 0, -8971.8125, 389.57464599609375, 74.51572418212890625, 5.462880611419677734, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 +(@CGUID+19, 28569, 0, 1519, 5148, '0', '0', 0, 0, 0, -9014.9775390625, 408.079864501953125, 76.56749725341796875, 5.096361160278320312, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 +(@CGUID+20, 28569, 0, 1519, 5148, '0', '0', 0, 0, 0, -9016.173828125, 406.192718505859375, 76.207855224609375, 0.069813169538974761, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 +(@CGUID+21, 28596, 0, 1519, 5148, '0', '0', 0, 0, 0, -9012.6298828125, 406.810760498046875, 75.36008453369140625, 3.246312379837036132, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 +(@CGUID+22, 28569, 0, 1519, 5148, '0', '0', 0, 0, 0, -8991.439453125, 410.49652099609375, 73.68466949462890625, 5.078907966613769531, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 +(@CGUID+23, 28569, 0, 1519, 5148, '0', '0', 0, 0, 0, -8992.361328125, 396.994781494140625, 73.07769775390625, 5.811946392059326171, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 +(@CGUID+24, 28596, 0, 1519, 5148, '0', '0', 0, 0, 0, -8989.923828125, 396.067718505859375, 73.33507537841796875, 2.181661605834960937, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 +(@CGUID+25, 28596, 0, 1519, 5148, '0', '0', 0, 0, 0, -8990.70703125, 407.782989501953125, 73.48921966552734375, 1.902408838272094726, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564), -- Dwarven Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 +(@CGUID+26, 28569, 0, 1519, 5148, '0', '0', 0, 0, 0, -8982.5693359375, 377.298614501953125, 75.49970245361328125, 3.647738218307495117, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 57564); -- Construction Worker (Area: Trade District - Difficulty: 0) CreateObject1 (Auras: 84186 - Cosmetic - Sleep Zzz) + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+26; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+26, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '84186'); -- Construction Worker - 84186 - Cosmetic - Sleep Zzz |