diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2024_11_12_00_world.sql | 137 |
1 files changed, 137 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_11_12_00_world.sql b/sql/updates/world/3.3.5/2024_11_12_00_world.sql new file mode 100644 index 00000000000..0dbb4e44082 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_11_12_00_world.sql @@ -0,0 +1,137 @@ +-- +SET @OGUID := 92657; -- Need 128 +SET @EVENT := 8; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+127; +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, 181016, 595, 4100, 4100, 3, 1, 1560.3992919921875, 577.02606201171875, 106.6330337524414062, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+1, 181019, 595, 4100, 4100, 3, 1, 1558.921875, 589.404541015625, 100.94000244140625, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 7200, 255, 1, 0), -- Standing, Interior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+2, 181060, 595, 4100, 4100, 3, 1, 1556.5103759765625, 607.83856201171875, 99.869842529296875, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+3, 181060, 595, 4100, 4100, 3, 1, 1555.2725830078125, 608.5069580078125, 99.8471221923828125, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+4, 181017, 595, 4100, 4100, 3, 1, 1569.8316650390625, 597.65277099609375, 103.2068328857421875, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 7200, 255, 1, 0), -- Hanging, Streamer - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+5, 181016, 595, 4100, 4100, 3, 1, 1555.8038330078125, 601.5711669921875, 99.15207672119140625, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+6, 181016, 595, 4100, 4100, 3, 1, 1573.171875, 622.828125, 99.63867950439453125, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+7, 181017, 595, 4100, 4100, 3, 1, 1575.0347900390625, 618.4757080078125, 104.6546630859375, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 7200, 255, 1, 0), -- Hanging, Streamer - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+8, 181025, 595, 4100, 4100, 3, 1, 1580.1197509765625, 668.140625, 117.7477493286132812, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Large - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+9, 181016, 595, 4100, 4100, 3, 1, 1587.892333984375, 667.3992919921875, 103.0756301879882812, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+10, 181016, 595, 4100, 4100, 3, 1, 1599.44970703125, 661.5625, 103.2282791137695312, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+11, 181025, 595, 4100, 4100, 3, 1, 1605.654541015625, 657.39410400390625, 118.0041275024414062, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Large - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+12, 181016, 595, 4100, 4100, 3, 1, 1593.1632080078125, 681.8524169921875, 104.6160125732421875, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+13, 181016, 595, 4100, 4100, 3, 1, 1606.8975830078125, 677.27081298828125, 105.852813720703125, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+14, 181025, 595, 4100, 4100, 3, 1, 1613.7396240234375, 674.62152099609375, 117.991363525390625, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Large - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+15, 181025, 595, 4100, 4100, 3, 1, 1587.7569580078125, 686.79168701171875, 117.908416748046875, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Large - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+16, 181016, 595, 4100, 4100, 3, 1, 1616.62158203125, 754.20660400390625, 115.3078079223632812, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+17, 181016, 595, 4100, 4100, 3, 1, 1635.25, 816.97222900390625, 120.2372894287109375, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+18, 181016, 595, 4100, 4100, 3, 1, 1664.5660400390625, 890.685791015625, 120.117706298828125, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+19, 181016, 595, 4100, 4100, 3, 1, 1691.2239990234375, 954.69964599609375, 120.3922805786132812, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+20, 181016, 595, 4100, 4100, 3, 1, 1669.0660400390625, 1018.2603759765625, 125.0752334594726562, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+21, 181016, 595, 4100, 4100, 3, 1, 1669.842041015625, 1098.0364990234375, 127.4882278442382812, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+22, 181016, 595, 4100, 4100, 3, 1, 1688.30908203125, 1185.3697509765625, 132.57421875, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+23, 181016, 595, 4100, 4100, 3, 1, 1739.0538330078125, 1249.53125, 137.72503662109375, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+24, 181016, 595, 4100, 4100, 3, 1, 1830.8524169921875, 1287.626708984375, 143.58587646484375, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+25, 181016, 595, 4100, 4100, 3, 1, 1915.9947509765625, 1298.732666015625, 142.4404754638671875, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+26, 181016, 595, 4100, 4100, 3, 1, 1916.1285400390625, 1275.9288330078125, 142.4715576171875, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+27, 181016, 595, 4100, 4100, 3, 1, 1937.1944580078125, 1298.96875, 145.9376373291015625, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+28, 181016, 595, 4100, 4100, 3, 1, 1937.0538330078125, 1275.6927490234375, 145.923309326171875, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+29, 181016, 595, 4100, 4100, 3, 1, 1958.76220703125, 1299.123291015625, 146.205230712890625, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+30, 181016, 595, 4100, 4100, 3, 1, 1958.6754150390625, 1275.9444580078125, 146.2058258056640625, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+31, 181016, 595, 4100, 4100, 3, 1, 1980.545166015625, 1298.796875, 146.1197052001953125, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+32, 181016, 595, 4100, 4100, 3, 1, 1980.185791015625, 1276.2708740234375, 146.119354248046875, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+33, 181016, 595, 4100, 4100, 3, 1, 1984.2742919921875, 1244.0191650390625, 143.217498779296875, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+34, 181016, 595, 4100, 4100, 3, 1, 1984.6771240234375, 1332.60595703125, 143.220458984375, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+35, 181025, 595, 4100, 4100, 3, 1, 2009.1771240234375, 1273.814208984375, 147.477203369140625, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Large - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+36, 181025, 595, 4100, 4100, 3, 1, 2009.1910400390625, 1299.392333984375, 147.3836212158203125, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Large - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+37, 181016, 595, 4100, 4100, 3, 1, 2017.4617919921875, 1313.5625, 142.949127197265625, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+38, 181016, 595, 4100, 4100, 3, 1, 2017.642333984375, 1261.329833984375, 142.9531097412109375, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+39, 181016, 595, 4100, 4100, 3, 1, 2033.34033203125, 1281.6285400390625, 143.624755859375, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+40, 181016, 595, 4100, 4100, 3, 1, 2033.7569580078125, 1293.685791015625, 143.4059295654296875, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+41, 181016, 595, 4100, 4100, 3, 1, 2067.857666015625, 1281.2413330078125, 141.9698333740234375, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+42, 181016, 595, 4100, 4100, 3, 1, 2067.348876953125, 1293.375, 141.9972686767578125, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+43, 181018, 595, 4100, 4100, 3, 1, 2092.87841796875, 1309.795166015625, 148.9744415283203125, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+44, 181017, 595, 4100, 4100, 3, 1, 2104.20654296875, 1306.1927490234375, 144.4675750732421875, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 7200, 255, 1, 0), -- Hanging, Streamer - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+45, 181018, 595, 4100, 4100, 3, 1, 2109.835205078125, 1266.607666015625, 142.9143218994140625, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+46, 181060, 595, 4100, 4100, 3, 1, 2123.31591796875, 1350.734375, 132.9212188720703125, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+47, 181018, 595, 4100, 4100, 3, 1, 2139.3681640625, 1271.6614990234375, 139.33447265625, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+48, 181060, 595, 4100, 4100, 3, 1, 2120.295166015625, 1351.359375, 132.89581298828125, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+49, 181060, 595, 4100, 4100, 3, 1, 2118.611083984375, 1353.998291015625, 132.7572174072265625, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+50, 181018, 595, 4100, 4100, 3, 1, 2153.6806640625, 1264.5660400390625, 139.2888641357421875, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+51, 181060, 595, 4100, 4100, 3, 1, 2126.51904296875, 1355.3941650390625, 132.9130706787109375, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+52, 181016, 595, 4100, 4100, 3, 1, 2154.65625, 1293.204833984375, 134.4106597900390625, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+53, 181060, 595, 4100, 4100, 3, 1, 2124.921875, 1357.8853759765625, 132.658203125, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+54, 181060, 595, 4100, 4100, 3, 1, 2119.279541015625, 1356.9461669921875, 132.63006591796875, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+55, 181060, 595, 4100, 4100, 3, 1, 2125.8681640625, 1352.4132080078125, 132.9042205810546875, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+56, 181060, 595, 4100, 4100, 3, 1, 2121.8525390625, 1358.5867919921875, 132.593780517578125, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+57, 181017, 595, 4100, 4100, 3, 1, 2106.89404296875, 1380.51220703125, 139.30267333984375, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 7200, 255, 1, 0), -- Hanging, Streamer - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+58, 181018, 595, 4100, 4100, 3, 1, 2143.01220703125, 1371.3541259765625, 138.8475799560546875, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+59, 181018, 595, 4100, 4100, 3, 1, 2151.5, 1370.189208984375, 139.0308074951171875, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+60, 181016, 595, 4100, 4100, 3, 1, 2194.291748046875, 1288.751708984375, 134.5957794189453125, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+61, 181016, 595, 4100, 4100, 3, 1, 2177.614501953125, 1234.0035400390625, 137.313629150390625, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+62, 181020, 595, 4100, 4100, 3, 1, 2185.94091796875, 1235.0260009765625, 147.9004974365234375, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 0), -- Hanging, Square, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+63, 181016, 595, 4100, 4100, 3, 1, 2187.078125, 1243.5625, 137.3231964111328125, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+64, 181016, 595, 4100, 4100, 3, 1, 2267.93408203125, 1323.55908203125, 125.9082565307617187, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+65, 181016, 595, 4100, 4100, 3, 1, 2228.91845703125, 1337.0347900390625, 127.625213623046875, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+66, 181016, 595, 4100, 4100, 3, 1, 2228.6806640625, 1326.1197509765625, 127.8867874145507812, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+67, 181016, 595, 4100, 4100, 3, 1, 2214.890625, 1212.2586669921875, 137.1099395751953125, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+68, 181020, 595, 4100, 4100, 3, 1, 2231.80908203125, 1331.7899169921875, 134.8952178955078125, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 7200, 255, 1, 0), -- Hanging, Square, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+69, 181020, 595, 4100, 4100, 3, 1, 2262.826416015625, 1330.9305419921875, 134.6929931640625, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 7200, 255, 1, 0), -- Hanging, Square, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+70, 181016, 595, 4100, 4100, 3, 1, 2267.907958984375, 1337.30908203125, 124.4250564575195312, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+71, 181020, 595, 4100, 4100, 3, 1, 2310.739501953125, 1326.7847900390625, 129.516876220703125, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 7200, 255, 1, 0), -- Hanging, Square, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+72, 181020, 595, 4100, 4100, 3, 1, 2309.182373046875, 1341.0816650390625, 129.5749053955078125, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 7200, 255, 1, 0), -- Hanging, Square, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+73, 181016, 595, 4100, 4100, 3, 1, 2204.904541015625, 1204.0086669921875, 136.990386962890625, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+74, 181016, 595, 4100, 4100, 3, 1, 2231.807373046875, 1145.2222900390625, 139.6356353759765625, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+75, 181060, 595, 4100, 4100, 3, 1, 2271.588623046875, 1159.736083984375, 139.2359161376953125, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+76, 181060, 595, 4100, 4100, 3, 1, 2278.616455078125, 1162.15283203125, 139.49664306640625, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+77, 181060, 595, 4100, 4100, 3, 1, 2274.322998046875, 1158.34375, 139.2575836181640625, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+78, 181060, 595, 4100, 4100, 3, 1, 2271.869873046875, 1165.2864990234375, 139.429107666015625, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+79, 181060, 595, 4100, 4100, 3, 1, 2274.772705078125, 1166.314208984375, 139.54522705078125, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+80, 181060, 595, 4100, 4100, 3, 1, 2277.48095703125, 1165.0521240234375, 139.55718994140625, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+81, 181060, 595, 4100, 4100, 3, 1, 2270.616455078125, 1162.486083984375, 139.2928314208984375, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+82, 181060, 595, 4100, 4100, 3, 1, 2277.26220703125, 1159.328125, 139.402099609375, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 7200, 255, 1, 0), -- Standing, Interior, Small - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+83, 181020, 595, 4100, 4100, 3, 1, 2282.592041015625, 1133.670166015625, 146.3243408203125, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 7200, 255, 1, 0), -- Hanging, Square, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+84, 181018, 595, 4100, 4100, 3, 1, 2306.2275390625, 1157.298583984375, 139.9674530029296875, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+85, 181018, 595, 4100, 4100, 3, 1, 2318.600830078125, 1166.8646240234375, 140.214630126953125, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+86, 181016, 595, 4100, 4100, 3, 1, 2316.713623046875, 1157.361083984375, 135.58953857421875, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+87, 181016, 595, 4100, 4100, 3, 1, 2344.272705078125, 1216.18408203125, 131.106964111328125, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+88, 181016, 595, 4100, 4100, 3, 1, 2369.5087890625, 1189.9566650390625, 132.0734100341796875, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+89, 181017, 595, 4100, 4100, 3, 1, 2371.5, 1199.4288330078125, 140.5843963623046875, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 7200, 255, 1, 0), -- Hanging, Streamer - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+90, 181018, 595, 4100, 4100, 3, 1, 2373.557373046875, 1193.4774169921875, 137.450439453125, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+91, 181016, 595, 4100, 4100, 3, 1, 2365.51220703125, 1206.0208740234375, 131.530059814453125, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+92, 181018, 595, 4100, 4100, 3, 1, 2370.361083984375, 1204.6910400390625, 137.312408447265625, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+93, 181016, 595, 4100, 4100, 3, 1, 2332.710205078125, 1253.6978759765625, 133.481353759765625, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+94, 181016, 595, 4100, 4100, 3, 1, 2389.998291015625, 1194.26220703125, 148.0759124755859375, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+95, 181055, 595, 4100, 4100, 3, 1, 2395.723876953125, 1194.1319580078125, 142.4735870361328125, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 7200, 255, 1, 0), -- Hanging, Streamer x3 - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+96, 181016, 595, 4100, 4100, 3, 1, 2395.064208984375, 1176.1875, 133.93292236328125, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+97, 181018, 595, 4100, 4100, 3, 1, 2384.97216796875, 1211.7396240234375, 136.561065673828125, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+98, 181018, 595, 4100, 4100, 3, 1, 2389.04345703125, 1194.34033203125, 136.4981231689453125, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 7200, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+99, 181019, 595, 4100, 4100, 3, 1, 2403.560791015625, 1186.376708984375, 134.8163299560546875, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 7200, 255, 1, 0), -- Standing, Interior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+100, 181016, 595, 4100, 4100, 3, 1, 2399.833251953125, 1172.3489990234375, 148.0749053955078125, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+101, 181019, 595, 4100, 4100, 3, 1, 2398.585205078125, 1213.4879150390625, 134.9222564697265625, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 7200, 255, 1, 0), -- Standing, Interior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+102, 181016, 595, 4100, 4100, 3, 1, 2400.90966796875, 1219.62158203125, 134.0390167236328125, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+103, 181055, 595, 4100, 4100, 3, 1, 2407.859375, 1196.763916015625, 142.53497314453125, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 7200, 255, 1, 0), -- Hanging, Streamer x3 - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+104, 181016, 595, 4100, 4100, 3, 1, 2411.060791015625, 1175.234375, 148.074920654296875, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+105, 181016, 595, 4100, 4100, 3, 1, 2407.21533203125, 1138.1649169921875, 148.0759124755859375, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+106, 181016, 595, 4100, 4100, 3, 1, 2408.55029296875, 1113.0538330078125, 148.0759124755859375, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+107, 181019, 595, 4100, 4100, 3, 1, 2408.90966796875, 1202.2379150390625, 134.9315948486328125, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 7200, 255, 1, 0), -- Standing, Interior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+108, 181019, 595, 4100, 4100, 3, 1, 2416.3681640625, 1188.4583740234375, 134.820526123046875, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 7200, 255, 1, 0), -- Standing, Interior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+109, 181016, 595, 4100, 4100, 3, 1, 2418.864501953125, 1141.2552490234375, 148.075897216796875, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+110, 181019, 595, 4100, 4100, 3, 1, 2420.16845703125, 1205.138916015625, 134.9156036376953125, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 7200, 255, 1, 0), -- Standing, Interior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+111, 181016, 595, 4100, 4100, 3, 1, 2418.4775390625, 1223.9947509765625, 134.0390167236328125, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+112, 181055, 595, 4100, 4100, 3, 1, 2421.213623046875, 1200.0069580078125, 142.5443267822265625, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 7200, 255, 1, 0), -- Hanging, Streamer x3 - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+113, 181055, 595, 4100, 4100, 3, 1, 2433.482666015625, 1202.951416015625, 142.5956878662109375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 7200, 255, 1, 0), -- Hanging, Streamer x3 - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+114, 181019, 595, 4100, 4100, 3, 1, 2434.3125, 1201.4600830078125, 135.110137939453125, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 7200, 255, 1, 0), -- Standing, Interior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+115, 181019, 595, 4100, 4100, 3, 1, 2428.33154296875, 1219.71533203125, 134.9208984375, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 7200, 255, 1, 0), -- Standing, Interior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+116, 181019, 595, 4100, 4100, 3, 1, 2434.413330078125, 1194.01220703125, 135.109893798828125, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 7200, 255, 1, 0), -- Standing, Interior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+117, 181020, 595, 4100, 4100, 3, 1, 2443.84716796875, 1227.2117919921875, 135.6902618408203125, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 7200, 255, 1, 0), -- Hanging, Square, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+118, 181016, 595, 4100, 4100, 3, 1, 2452.13720703125, 1122.0504150390625, 148.075897216796875, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+119, 181020, 595, 4100, 4100, 3, 1, 2469.7587890625, 1127.2882080078125, 155.570281982421875, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 7200, 255, 1, 0), -- Hanging, Square, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+120, 181055, 595, 4100, 4100, 3, 1, 2412.736083984375, 1103.907958984375, 154.756591796875, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 7200, 255, 1, 0), -- Hanging, Streamer x3 - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+121, 181016, 595, 4100, 4100, 3, 1, 2455.65625, 1104.7725830078125, 148.075897216796875, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+122, 181016, 595, 4100, 4100, 3, 1, 2412.786376953125, 1094.19970703125, 148.0759124755859375, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+123, 181020, 595, 4100, 4100, 3, 1, 2473.532958984375, 1110.1285400390625, 155.2871856689453125, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 0), -- Hanging, Square, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+124, 181016, 595, 4100, 4100, 3, 1, 2520.549560546875, 1138.0416259765625, 132.076507568359375, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+125, 181016, 595, 4100, 4100, 3, 1, 2338.635498046875, 1423.48095703125, 128.1294097900390625, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 7200, 255, 1, 0), -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+126, 181020, 595, 4100, 4100, 3, 1, 2326.923583984375, 1420.046875, 135.85186767578125, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 7200, 255, 1, 0), -- Hanging, Square, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+127, 181016, 595, 4100, 4100, 3, 1, 2316.064208984375, 1410.5867919921875, 128.1347808837890625, 0, 0, 0, 0, 1, 7200, 255, 1, 0); -- Standing, Exterior, Medium - Val (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 + +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+127 AND `eventEntry`=@EVENT; +INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+127; |