diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_12_17_07_world.sql | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_12_17_07_world.sql b/sql/updates/world/3.3.5/2024_12_17_07_world.sql new file mode 100644 index 00000000000..dcc928524d9 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_12_17_07_world.sql @@ -0,0 +1,43 @@ +-- +SET @OGUID := 60360; -- Need 34 +SET @EVENT := 8; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+33; +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, 181025, 571, 3537, 4032, 1, 1, 2293.540283203125, 5174.7177734375, 25.11964607238769531, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Large - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+1, 181060, 571, 3537, 4032, 1, 1, 2303.144287109375, 5193.45849609375, 18.77863883972167968, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+2, 181060, 571, 3537, 4032, 1, 1, 2304.0087890625, 5195.68896484375, 18.77863693237304687, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+3, 181060, 571, 3537, 4032, 1, 1, 2288.107666015625, 5203.8837890625, 13.63426113128662109, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+4, 181060, 571, 3537, 4032, 1, 1, 2276.773681640625, 5199.5341796875, 24.89459800720214843, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+5, 181060, 571, 3537, 4032, 1, 1, 2290.5908203125, 5201.154296875, 24.89418220520019531, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+6, 181060, 571, 3537, 4032, 1, 1, 2300.87109375, 5202.06591796875, 18.77513504028320312, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+7, 181060, 571, 3537, 4032, 1, 1, 2289.228515625, 5206.75927734375, 13.63449668884277343, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+8, 181060, 571, 3537, 4032, 1, 1, 2291.030517578125, 5196.255859375, 16.54580879211425781, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+9, 181060, 571, 3537, 4032, 1, 1, 2296.923095703125, 5193.869140625, 16.54580879211425781, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+10, 181025, 571, 3537, 4032, 1, 1, 2288.474365234375, 5160.943359375, 25.54812049865722656, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Large - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+11, 181060, 571, 3537, 4032, 1, 1, 2289.666259765625, 5198.8798828125, 24.89882850646972656, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+12, 181060, 571, 3537, 4032, 1, 1, 2278.044921875, 5202.72509765625, 24.89858818054199218, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+13, 181025, 571, 3537, 4032, 1, 1, 2330.237060546875, 5169.8720703125, 25.63700103759765625, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Large - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+14, 181025, 571, 3537, 4032, 1, 1, 2362.818603515625, 5195.90087890625, 19.76927375793457031, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Large - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+15, 181025, 571, 3537, 4032, 1, 1, 2373.8203125, 5235.90185546875, 20.25008392333984375, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Large - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+16, 181025, 571, 3537, 4032, 1, 1, 2293.540283203125, 5174.7177734375, 25.11964607238769531, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Large - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+17, 181060, 571, 3537, 4032, 1, 1, 2303.144287109375, 5193.45849609375, 18.77863883972167968, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+18, 181060, 571, 3537, 4032, 1, 1, 2304.0087890625, 5195.68896484375, 18.77863693237304687, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+19, 181060, 571, 3537, 4032, 1, 1, 2288.107666015625, 5203.8837890625, 13.63426113128662109, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+20, 181060, 571, 3537, 4032, 1, 1, 2276.773681640625, 5199.5341796875, 24.89459800720214843, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+21, 181060, 571, 3537, 4032, 1, 1, 2290.5908203125, 5201.154296875, 24.89418220520019531, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+22, 181060, 571, 3537, 4032, 1, 1, 2300.87109375, 5202.06591796875, 18.77513504028320312, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+23, 181060, 571, 3537, 4032, 1, 1, 2289.228515625, 5206.75927734375, 13.63449668884277343, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+24, 181060, 571, 3537, 4032, 1, 1, 2291.030517578125, 5196.255859375, 16.54580879211425781, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+25, 181060, 571, 3537, 4032, 1, 1, 2296.923095703125, 5193.869140625, 16.54580879211425781, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+26, 181025, 571, 3537, 4032, 1, 1, 2288.474365234375, 5160.943359375, 25.54812049865722656, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Large - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+27, 181060, 571, 3537, 4032, 1, 1, 2289.666259765625, 5198.8798828125, 24.89882850646972656, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+28, 181060, 571, 3537, 4032, 1, 1, 2278.044921875, 5202.72509765625, 24.89858818054199218, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+29, 181025, 571, 3537, 4032, 1, 1, 2330.237060546875, 5169.8720703125, 25.63700103759765625, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Large - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+30, 181025, 571, 3537, 4032, 1, 1, 2361.501708984375, 5274.708984375, 25.85167312622070312, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Large - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+31, 181025, 571, 3537, 4032, 1, 1, 2373.8203125, 5235.90185546875, 20.25008392333984375, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Large - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+32, 181025, 571, 3537, 4032, 1, 1, 2362.818603515625, 5195.90087890625, 19.76927375793457031, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Large - Val (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+33, 181016, 571, 3537, 4114, 1, 1, 3099.8447265625, 3831.98388671875, 23.01079750061035156, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 52237); -- Standing, Exterior, Medium - Val (Area: Death's Stand - Difficulty: 0) CreateObject1 + +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+33 AND `eventEntry`=@EVENT; +INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+33; |