diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_12_17_00_world.sql | 71 |
1 files changed, 71 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_12_17_00_world.sql b/sql/updates/world/3.3.5/2024_12_17_00_world.sql new file mode 100644 index 00000000000..234470d4125 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_12_17_00_world.sql @@ -0,0 +1,71 @@ +-- +SET @OGUID := 79897; -- Need 62 +SET @EVENT := 12; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+61; +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, 180405, 595, 4100, 4100, 3, 1, 1560.671875, 625.26910400390625, 99.86887359619140625, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 0) CreateObject1 +(@OGUID+1, 180523, 595, 4100, 4100, 3, 1, 1569.0103759765625, 606.97918701171875, 100.1761093139648437, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 7200, 255, 1, 56713), -- Apple Bob (Area: The Culling of Stratholme - Difficulty: 0) CreateObject1 +(@OGUID+2, 180407, 595, 4100, 4100, 3, 1, 1587.65625, 667.14410400390625, 103.0442886352539062, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 0) CreateObject1 +(@OGUID+3, 180431, 595, 4100, 4100, 3, 1, 2003.513916015625, 1287.404541015625, 145.7567901611328125, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 7200, 255, 1, 56713), -- G_Pumpkin_01 scale 4.0 (Area: The Culling of Stratholme - Difficulty: 0) CreateObject1 +(@OGUID+4, 180405, 595, 4100, 4100, 3, 1, 1564.8853759765625, 586.18927001953125, 100.9324264526367187, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 0) CreateObject1 +(@OGUID+5, 180406, 595, 4100, 4100, 3, 1, 1605.2899169921875, 676.4375, 105.4878463745117187, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 0) CreateObject1 +(@OGUID+6, 180405, 595, 4100, 4100, 3, 1, 1592.717041015625, 681.19793701171875, 104.5380325317382812, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 0) CreateObject1 +(@OGUID+7, 180411, 595, 4100, 4100, 3, 1, 1596.4461669921875, 671.19793701171875, 112.6099319458007812, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 7200, 255, 1, 56713), -- G_Ghost_01 (Area: The Culling of Stratholme - Difficulty: 0) CreateObject1 +(@OGUID+8, 180406, 595, 4100, 4100, 3, 1, 1599.9947509765625, 662.05206298828125, 103.3326873779296875, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+9, 180406, 595, 4100, 4100, 3, 1, 1616.7847900390625, 754.013916015625, 115.2821731567382812, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+10, 180411, 595, 4100, 4100, 3, 1, 1549.6754150390625, 594.638916015625, 107.3046875, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 7200, 255, 1, 56713), -- G_Ghost_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+11, 180406, 595, 4100, 4100, 3, 1, 1557.5069580078125, 615.64239501953125, 99.77874755859375, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+12, 180407, 595, 4100, 4100, 3, 1, 1635.720458984375, 816.5399169921875, 120.1334075927734375, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+13, 180405, 595, 4100, 4100, 3, 1, 1916.109375, 1298.60595703125, 142.4672393798828125, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+14, 180405, 595, 4100, 4100, 3, 1, 1936.9791259765625, 1275.8853759765625, 145.9156951904296875, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+15, 180407, 595, 4100, 4100, 3, 1, 2157.3369140625, 1260.6649169921875, 134.7227020263671875, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+16, 180406, 595, 4100, 4100, 3, 1, 2155.27783203125, 1293.34375, 134.35076904296875, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+17, 180405, 595, 4100, 4100, 3, 1, 2228.895751953125, 1336.8853759765625, 127.61419677734375, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+18, 180411, 595, 4100, 4100, 3, 1, 2196.697998046875, 1223.44970703125, 143.6862335205078125, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 7200, 255, 1, 56713), -- G_Ghost_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+19, 180406, 595, 4100, 4100, 3, 1, 1984.8785400390625, 1332.2708740234375, 143.2194976806640625, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+20, 180405, 595, 4100, 4100, 3, 1, 1980.78125, 1298.75, 146.1199188232421875, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+21, 180407, 595, 4100, 4100, 3, 1, 1958.548583984375, 1276.079833984375, 146.206695556640625, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+22, 180407, 595, 4100, 4100, 3, 1, 1958.78125, 1298.8316650390625, 146.205108642578125, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+23, 180407, 595, 4100, 4100, 3, 1, 2332.64404296875, 1254.0069580078125, 133.479217529296875, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+24, 180405, 595, 4100, 4100, 3, 1, 1984.5035400390625, 1244.8021240234375, 143.2156219482421875, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+25, 180406, 595, 4100, 4100, 3, 1, 1937.171875, 1298.9410400390625, 145.9352874755859375, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+26, 180406, 595, 4100, 4100, 3, 1, 2187.157958984375, 1243.6163330078125, 137.33526611328125, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+27, 180405, 595, 4100, 4100, 3, 1, 1830.954833984375, 1287.44970703125, 143.5936431884765625, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+28, 180407, 595, 4100, 4100, 3, 1, 2178.020751953125, 1233.69970703125, 137.325775146484375, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+29, 180406, 595, 4100, 4100, 3, 1, 1980.1007080078125, 1276.0538330078125, 146.1192779541015625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+30, 180405, 595, 4100, 4100, 3, 1, 2077.151123046875, 1280.6336669921875, 141.5343017578125, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+31, 180407, 595, 4100, 4100, 3, 1, 2267.9375, 1337.4322509765625, 124.4153900146484375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+32, 180406, 595, 4100, 4100, 3, 1, 2228.81591796875, 1326.123291015625, 127.8727188110351562, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+33, 180407, 595, 4100, 4100, 3, 1, 2232.302001953125, 1145.795166015625, 139.8232421875, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+34, 180406, 595, 4100, 4100, 3, 1, 2205.111083984375, 1203.8958740234375, 136.977691650390625, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+35, 180407, 595, 4100, 4100, 3, 1, 2214.72216796875, 1212.6441650390625, 137.13104248046875, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+36, 180406, 595, 4100, 4100, 3, 1, 2267.947998046875, 1323.4305419921875, 125.920806884765625, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+37, 180407, 595, 4100, 4100, 3, 1, 2076.864501953125, 1294.8211669921875, 141.652618408203125, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+38, 180406, 595, 4100, 4100, 3, 1, 1915.73095703125, 1276.0035400390625, 142.3786163330078125, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+39, 180406, 595, 4100, 4100, 3, 1, 2315.975830078125, 1410.767333984375, 128.2122955322265625, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+40, 180411, 595, 4100, 4100, 3, 1, 2025.5382080078125, 1287.295166015625, 150.1963043212890625, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 56713), -- G_Ghost_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+41, 180405, 595, 4100, 4100, 3, 1, 2369.345458984375, 1190.0035400390625, 132.0498809814453125, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+42, 180406, 595, 4100, 4100, 3, 1, 2365.678955078125, 1206.09033203125, 131.5900726318359375, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+43, 180405, 595, 4100, 4100, 3, 1, 2338.741455078125, 1423.5347900390625, 128.133087158203125, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+44, 180411, 595, 4100, 4100, 3, 1, 2398.38720703125, 1206.93408203125, 150.74884033203125, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 7200, 255, 1, 56713), -- G_Ghost_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+45, 180406, 595, 4100, 4100, 3, 1, 2399.6494140625, 1172.5260009765625, 148.0749053955078125, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+46, 180411, 595, 4100, 4100, 3, 1, 2417.494873046875, 1209.1197509765625, 150.519256591796875, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 7200, 255, 1, 56713), -- G_Ghost_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+47, 180407, 595, 4100, 4100, 3, 1, 2411.182373046875, 1174.939208984375, 148.074951171875, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+48, 180411, 595, 4100, 4100, 3, 1, 2435.392333984375, 1214.0364990234375, 150.6657257080078125, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 7200, 255, 1, 56713), -- G_Ghost_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+49, 180405, 595, 4100, 4100, 3, 1, 2412.885498046875, 1094.3038330078125, 148.0759124755859375, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+50, 180407, 595, 4100, 4100, 3, 1, 2418.798583984375, 1140.7569580078125, 148.075897216796875, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+51, 180406, 595, 4100, 4100, 3, 1, 2407.296875, 1138.248291015625, 148.0759124755859375, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+52, 180405, 595, 4100, 4100, 3, 1, 2408.685791015625, 1113.015625, 148.0759124755859375, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+53, 180407, 595, 4100, 4100, 3, 1, 2438.479248046875, 1206.1146240234375, 149.1508941650390625, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+54, 180406, 595, 4100, 4100, 3, 1, 2467.420166015625, 1130.220458984375, 158.0266876220703125, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+55, 180407, 595, 4100, 4100, 3, 1, 2472.703125, 1105.9149169921875, 157.9708251953125, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 7200, 255, 1, 56713), -- G_Pumpkin_03 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+56, 180405, 595, 4100, 4100, 3, 1, 1664.904541015625, 890.26910400390625, 119.99566650390625, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+57, 180405, 595, 4100, 4100, 3, 1, 1691.451416015625, 954.13714599609375, 120.3690032958984375, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+58, 180406, 595, 4100, 4100, 3, 1, 1669.29345703125, 1017.84722900390625, 125.0198974609375, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 7200, 255, 1, 56713), -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+59, 180405, 595, 4100, 4100, 3, 1, 1670.0416259765625, 1097.859375, 127.4366989135742187, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+60, 180405, 595, 4100, 4100, 3, 1, 1688.498291015625, 1185.3211669921875, 132.57257080078125, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 7200, 255, 1, 56713), -- G_Pumpkin_01 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+61, 180406, 595, 4100, 4100, 3, 1, 1739.0399169921875, 1249.2760009765625, 137.710540771484375, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 7200, 255, 1, 56713); -- G_Pumpkin_02 (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 + +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+61 AND `eventEntry`=@EVENT; +INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+61; |