diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_12_17_08_world.sql | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_12_17_08_world.sql b/sql/updates/world/3.3.5/2024_12_17_08_world.sql new file mode 100644 index 00000000000..a0d85247025 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_12_17_08_world.sql @@ -0,0 +1,25 @@ +-- +SET @OGUID := 13684; -- Need 16 +SET @EVENT := 8; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+15; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 181060, 571, 495, 4379, 1, 1, 593.67724609375, -4929.41357421875, 31.07939338684082031, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valgarde - Difficulty: 0) CreateObject1 +(@OGUID+1, 181060, 571, 495, 4379, 1, 1, 589.42169189453125, -4926.30126953125, 19.81484222412109375, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valgarde - Difficulty: 0) CreateObject1 +(@OGUID+2, 181060, 571, 495, 4379, 1, 1, 588.70184326171875, -4923.255859375, 19.81484222412109375, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valgarde - Difficulty: 0) CreateObject1 +(@OGUID+3, 181060, 571, 495, 4379, 1, 1, 582.01080322265625, -4933.2568359375, 31.07901382446289062, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valgarde - Difficulty: 0) CreateObject1 +(@OGUID+4, 181016, 571, 495, 3997, 1, 1, 493.364593505859375, -5904.35595703125, 308.904937744140625, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 52237), -- Standing, Exterior, Medium - Val (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1 +(@OGUID+5, 181019, 571, 495, 3997, 1, 1, 491.35296630859375, -5933.67138671875, 310.585845947265625, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 52237), -- Standing, Interior, Medium - Val (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1 +(@OGUID+6, 181019, 571, 495, 3997, 1, 1, 491.8101806640625, -5927.2802734375, 309.67877197265625, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 52237), -- Standing, Interior, Medium - Val (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1 +(@OGUID+7, 181060, 571, 495, 3997, 1, 1, 492.902740478515625, -5928.03076171875, 309.63958740234375, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1 +(@OGUID+8, 181060, 571, 495, 3997, 1, 1, 490.626617431640625, -5934.06298828125, 309.60113525390625, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1 +(@OGUID+9, 181016, 571, 495, 3997, 1, 1, 469.700531005859375, -5927.3427734375, 308.720245361328125, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 52237), -- Standing, Exterior, Medium - Val (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1 +(@OGUID+10, 181016, 571, 495, 3997, 1, 1, 499.0128173828125, -5932.87744140625, 308.70391845703125, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 52237), -- Standing, Exterior, Medium - Val (Area: Explorers' League Outpost - Difficulty: 0) CreateObject1 +(@OGUID+11, 181018, 571, 495, 4532, 1, 1, 1900.7137451171875, -6182.30615234375, 31.16156959533691406, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1 +(@OGUID+12, 181018, 571, 495, 4532, 1, 1, 1892.77783203125, -6183.73583984375, 25.80629158020019531, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1 +(@OGUID+13, 181018, 571, 495, 4532, 1, 1, 1869.909912109375, -6225.537109375, 14.98772907257080078, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: Vengeance Landing Inn - Difficulty: 0) CreateObject1 +(@OGUID+14, 181060, 571, 495, 4018, 1, 1, 2688.802001953125, -4390.22998046875, 285.700103759765625, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Camp Winterhoof - Difficulty: 0) CreateObject1 +(@OGUID+15, 181060, 571, 495, 4018, 1, 1, 2676.61669921875, -4381.39453125, 285.759613037109375, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 52237); -- Standing, Interior, Small - Val (Area: Camp Winterhoof - Difficulty: 0) CreateObject1 + +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+15 AND `eventEntry`=@EVENT; +INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+15; |