diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_12_17_05_world.sql | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_12_17_05_world.sql b/sql/updates/world/3.3.5/2024_12_17_05_world.sql new file mode 100644 index 00000000000..401e0b8b0d6 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_12_17_05_world.sql @@ -0,0 +1,32 @@ +-- +SET @OGUID := 49863; -- Need 23 +SET @EVENT := 8; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+22; +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, 181018, 571, 210, 4504, 1, 1, 6283.17333984375, 71.0634765625, 391.978668212890625, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: Valley of Echoes - Difficulty: 0) CreateObject1 +(@OGUID+1, 181018, 571, 210, 4504, 1, 1, 6299.56103515625, 55.87326431274414062, 394.769744873046875, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: Valley of Echoes - Difficulty: 0) CreateObject1 +(@OGUID+2, 181018, 571, 210, 4504, 1, 1, 6258.50244140625, 95.34896087646484375, 395.153106689453125, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: Valley of Echoes - Difficulty: 0) CreateObject1 +(@OGUID+3, 181018, 571, 210, 4504, 1, 1, 6274.251953125, 79.741973876953125, 391.81329345703125, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: Valley of Echoes - Difficulty: 0) CreateObject1 +(@OGUID+4, 181016, 571, 210, 4504, 1, 1, 6251.80712890625, 1.444553017616271972, 409.33984375, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 52237), -- Standing, Exterior, Medium - Val (Area: Valley of Echoes - Difficulty: 0) CreateObject1 +(@OGUID+5, 181018, 571, 210, 4504, 1, 1, 6197.2724609375, 63.93402862548828125, 381.164825439453125, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: Valley of Echoes - Difficulty: 0) CreateObject1 +(@OGUID+6, 181016, 571, 210, 4504, 1, 1, 6241.6943359375, 68.83843231201171875, 388.5811767578125, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 52237), -- Standing, Exterior, Medium - Val (Area: Valley of Echoes - Difficulty: 0) CreateObject1 +(@OGUID+7, 181016, 571, 210, 4501, 1, 1, 6198.2890625, -0.38237801194190979, 409.916168212890625, 5.724681377410888671, 0, 0, -0.27563667297363281, 0.961261868476867675, 120, 255, 1, 52237), -- Standing, Exterior, Medium - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+8, 181018, 571, 210, 4501, 1, 1, 6185.263671875, 63.80685806274414062, 381.187469482421875, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+9, 181016, 571, 210, 4501, 1, 1, 6193.05712890625, 28.86382484436035156, 380.5521240234375, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 52237), -- Standing, Exterior, Medium - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+10, 181016, 571, 210, 4501, 1, 1, 6232.294921875, -5.16493082046508789, 410.164642333984375, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 52237), -- Standing, Exterior, Medium - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+11, 181060, 571, 210, 4501, 1, 1, 6259.2744140625, -27.9760208129882812, 410.822052001953125, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+12, 181016, 571, 210, 4501, 1, 1, 6212.54052734375, 10.8203134536743164, 410.164093017578125, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 52237), -- Standing, Exterior, Medium - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+13, 181060, 571, 210, 4501, 1, 1, 6249.42822265625, -27.5517578125, 410.8948974609375, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+14, 181060, 571, 210, 4501, 1, 1, 6242.62060546875, -48.8146705627441406, 422.644927978515625, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+15, 181016, 571, 210, 4501, 1, 1, 6166.5849609375, -67.562286376953125, 388.179901123046875, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 52237), -- Standing, Exterior, Medium - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+16, 187575, 571, 210, 4501, 1, 1, 6161.72998046875, -60.3888893127441406, 388.70074462890625, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 52237), -- Hanging, Square, Small - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+17, 181060, 571, 210, 4501, 1, 1, 6170.07275390625, -68.9854583740234375, 390.381256103515625, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 52237), -- Standing, Interior, Small - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+18, 181016, 571, 210, 4501, 1, 1, 6127.73681640625, -26.387369155883789, 383.51031494140625, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 52237), -- Standing, Exterior, Medium - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+19, 181018, 571, 210, 4501, 1, 1, 6162.23291015625, -74.4932708740234375, 391.39105224609375, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+20, 181018, 571, 210, 4501, 1, 1, 6150.57958984375, -58.6980247497558593, 390.6942138671875, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+21, 181018, 571, 210, 4501, 1, 1, 6156.791015625, -57.0425338745117187, 390.897674560546875, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 52237), -- Hanging, Tall/Thin, Medium - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 +(@OGUID+22, 181018, 571, 210, 4501, 1, 1, 6156.5029296875, -76.918731689453125, 391.327484130859375, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 52237); -- Hanging, Tall/Thin, Medium - Val (Area: The Argent Vanguard - Difficulty: 0) CreateObject1 + +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+22 AND `eventEntry`=@EVENT; +INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+22; |