diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_12_17_04_world.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_12_17_04_world.sql b/sql/updates/world/3.3.5/2024_12_17_04_world.sql new file mode 100644 index 00000000000..87bd037c975 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_12_17_04_world.sql @@ -0,0 +1,21 @@ +-- +SET @OGUID := 13570; -- Need 12 +SET @EVENT := 8; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+11; +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, 65, 4161, 1, 1, 3572.83935546875, 265.182342529296875, 45.70560073852539062, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Wyrmrest Temple - Difficulty: 0) CreateObject1 +(@OGUID+1, 181060, 571, 65, 4161, 1, 1, 3564.302734375, 294.137481689453125, 45.70593643188476562, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Wyrmrest Temple - Difficulty: 0) CreateObject1 +(@OGUID+2, 181060, 571, 65, 4161, 1, 1, 3549.798583984375, 245.620880126953125, 45.7057647705078125, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Wyrmrest Temple - Difficulty: 0) CreateObject1 +(@OGUID+3, 181019, 571, 65, 4161, 1, 1, 3555.038330078125, 299.092620849609375, 45.70467758178710937, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 52237), -- Standing, Interior, Medium - Val (Area: Wyrmrest Temple - Difficulty: 0) CreateObject1 +(@OGUID+4, 181060, 571, 65, 4161, 1, 1, 3522.945068359375, 260.23529052734375, 45.71449661254882812, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Wyrmrest Temple - Difficulty: 0) CreateObject1 +(@OGUID+5, 181060, 571, 65, 4161, 1, 1, 3526.265625, 290.728240966796875, 45.74524307250976562, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Wyrmrest Temple - Difficulty: 0) CreateObject1 +(@OGUID+6, 181018, 571, 65, 4158, 1, 1, 3519.55029296875, 2023.3880615234375, 67.93622589111328125, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: Stars' Rest - Difficulty: 0) CreateObject1 +(@OGUID+7, 181018, 571, 65, 4158, 1, 1, 3505.42236328125, 2014.634521484375, 68.2199554443359375, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: Stars' Rest - Difficulty: 0) CreateObject1 +(@OGUID+8, 181018, 571, 65, 4158, 1, 1, 3518.782958984375, 1993.7606201171875, 67.3443603515625, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: Stars' Rest - Difficulty: 0) CreateObject1 +(@OGUID+9, 181060, 571, 65, 4158, 1, 1, 3499.606689453125, 1984.6790771484375, 66.1546783447265625, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Stars' Rest - Difficulty: 0) CreateObject1 +(@OGUID+10, 181018, 571, 65, 4158, 1, 1, 3500.45654296875, 1971.029541015625, 67.74578857421875, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: Stars' Rest - Difficulty: 0) CreateObject1 +(@OGUID+11, 187575, 571, 65, 65, 1, 1, 3612.02685546875, 1412.470458984375, 92.6059722900390625, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 52237); -- Hanging, Square, Small - Val (Area: Dragonblight - Difficulty: 0) CreateObject1 + +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+11 AND `eventEntry`=@EVENT; +INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+11; |