diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_12_17_01_world.sql | 82 |
1 files changed, 82 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_12_17_01_world.sql b/sql/updates/world/3.3.5/2024_12_17_01_world.sql new file mode 100644 index 00000000000..f2b7da2922d --- /dev/null +++ b/sql/updates/world/3.3.5/2024_12_17_01_world.sql @@ -0,0 +1,82 @@ +-- +SET @OGUID := 93806; -- Need 73 +SET @EVENT := 2; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+72; +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, 187235, 595, 4100, 4100, 3, 1, 1587.892333984375, 667.3992919921875, 103.0756301879882812, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+1, 187191, 595, 4100, 4100, 3, 1, 1573.171875, 622.828125, 99.63867950439453125, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+2, 187235, 595, 4100, 4100, 3, 1, 1560.3992919921875, 577.02606201171875, 106.6330337524414062, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+3, 187235, 595, 4100, 4100, 3, 1, 1606.8975830078125, 677.27081298828125, 105.852813720703125, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+4, 187235, 595, 4100, 4100, 3, 1, 1593.1632080078125, 681.8524169921875, 104.6160125732421875, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+5, 187235, 595, 4100, 4100, 3, 1, 1555.8038330078125, 601.5711669921875, 99.15207672119140625, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+6, 187235, 595, 4100, 4100, 3, 1, 1616.62158203125, 754.20660400390625, 115.3078079223632812, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+7, 187567, 595, 4100, 4100, 3, 1, 1575.0347900390625, 618.4757080078125, 104.6546630859375, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 7200, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+8, 187235, 595, 4100, 4100, 3, 1, 1599.44970703125, 661.5625, 103.2282791137695312, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+9, 187567, 595, 4100, 4100, 3, 1, 1569.8316650390625, 597.65277099609375, 103.2068328857421875, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 7200, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+10, 187235, 595, 4100, 4100, 3, 1, 1635.25, 816.97222900390625, 120.2372894287109375, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+11, 187235, 595, 4100, 4100, 3, 1, 1664.5660400390625, 890.685791015625, 120.117706298828125, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+12, 187235, 595, 4100, 4100, 3, 1, 1691.2239990234375, 954.69964599609375, 120.3922805786132812, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+13, 187235, 595, 4100, 4100, 3, 1, 1669.0660400390625, 1018.2603759765625, 125.0752334594726562, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+14, 187235, 595, 4100, 4100, 3, 1, 1669.842041015625, 1098.0364990234375, 127.4882278442382812, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+15, 187235, 595, 4100, 4100, 3, 1, 1688.30908203125, 1185.3697509765625, 132.57421875, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+16, 187235, 595, 4100, 4100, 3, 1, 1739.0538330078125, 1249.53125, 137.72503662109375, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+17, 187235, 595, 4100, 4100, 3, 1, 1830.8524169921875, 1287.626708984375, 143.58587646484375, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+18, 187235, 595, 4100, 4100, 3, 1, 1916.1285400390625, 1275.9288330078125, 142.4715576171875, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+19, 187235, 595, 4100, 4100, 3, 1, 1915.9947509765625, 1298.732666015625, 142.4404754638671875, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+20, 187235, 595, 4100, 4100, 3, 1, 1937.0538330078125, 1275.6927490234375, 145.923309326171875, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+21, 187235, 595, 4100, 4100, 3, 1, 1937.1944580078125, 1298.96875, 145.9376373291015625, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+22, 187235, 595, 4100, 4100, 3, 1, 1958.6754150390625, 1275.9444580078125, 146.2058258056640625, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+23, 187235, 595, 4100, 4100, 3, 1, 1958.76220703125, 1299.123291015625, 146.205230712890625, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+24, 187235, 595, 4100, 4100, 3, 1, 1984.2742919921875, 1244.0191650390625, 143.217498779296875, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+25, 187235, 595, 4100, 4100, 3, 1, 1980.185791015625, 1276.2708740234375, 146.119354248046875, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+26, 187235, 595, 4100, 4100, 3, 1, 1980.545166015625, 1298.796875, 146.1197052001953125, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+27, 187235, 595, 4100, 4100, 3, 1, 1984.6771240234375, 1332.60595703125, 143.220458984375, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+28, 187235, 595, 4100, 4100, 3, 1, 2017.642333984375, 1261.329833984375, 142.9531097412109375, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+29, 187235, 595, 4100, 4100, 3, 1, 2033.34033203125, 1281.6285400390625, 143.624755859375, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+30, 187235, 595, 4100, 4100, 3, 1, 2033.7569580078125, 1293.685791015625, 143.4059295654296875, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+31, 187235, 595, 4100, 4100, 3, 1, 2017.4617919921875, 1313.5625, 142.949127197265625, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+32, 187235, 595, 4100, 4100, 3, 1, 2067.348876953125, 1293.375, 141.9972686767578125, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+33, 187235, 595, 4100, 4100, 3, 1, 2067.857666015625, 1281.2413330078125, 141.9698333740234375, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+34, 187567, 595, 4100, 4100, 3, 1, 2104.20654296875, 1306.1927490234375, 144.4675750732421875, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 7200, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+35, 187567, 595, 4100, 4100, 3, 1, 2106.89404296875, 1380.51220703125, 139.30267333984375, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 7200, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+36, 187235, 595, 4100, 4100, 3, 1, 2154.65625, 1293.204833984375, 134.4106597900390625, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+37, 187235, 595, 4100, 4100, 3, 1, 2194.291748046875, 1288.751708984375, 134.5957794189453125, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+38, 187235, 595, 4100, 4100, 3, 1, 2187.078125, 1243.5625, 137.3231964111328125, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+39, 187235, 595, 4100, 4100, 3, 1, 2177.614501953125, 1234.0035400390625, 137.313629150390625, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+40, 187235, 595, 4100, 4100, 3, 1, 2204.904541015625, 1204.0086669921875, 136.990386962890625, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+41, 187235, 595, 4100, 4100, 3, 1, 2214.890625, 1212.2586669921875, 137.1099395751953125, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+42, 187235, 595, 4100, 4100, 3, 1, 2228.6806640625, 1326.1197509765625, 127.8867874145507812, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+43, 187235, 595, 4100, 4100, 3, 1, 2228.91845703125, 1337.0347900390625, 127.625213623046875, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+44, 187235, 595, 4100, 4100, 3, 1, 2267.93408203125, 1323.55908203125, 125.9082565307617187, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+45, 187235, 595, 4100, 4100, 3, 1, 2231.807373046875, 1145.2222900390625, 139.6356353759765625, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+46, 187235, 595, 4100, 4100, 3, 1, 2267.907958984375, 1337.30908203125, 124.4250564575195312, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+47, 187235, 595, 4100, 4100, 3, 1, 2332.710205078125, 1253.6978759765625, 133.481353759765625, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+48, 187235, 595, 4100, 4100, 3, 1, 2316.064208984375, 1410.5867919921875, 128.1347808837890625, 0, 0, 0, 0, 1, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+49, 187235, 595, 4100, 4100, 3, 1, 2316.713623046875, 1157.361083984375, 135.58953857421875, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+50, 187235, 595, 4100, 4100, 3, 1, 2344.272705078125, 1216.18408203125, 131.106964111328125, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+51, 187235, 595, 4100, 4100, 3, 1, 2369.5087890625, 1189.9566650390625, 132.0734100341796875, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+52, 187235, 595, 4100, 4100, 3, 1, 2338.635498046875, 1423.48095703125, 128.1294097900390625, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+53, 187235, 595, 4100, 4100, 3, 1, 2365.51220703125, 1206.0208740234375, 131.530059814453125, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+54, 187567, 595, 4100, 4100, 3, 1, 2371.5, 1199.4288330078125, 140.5843963623046875, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 7200, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+55, 187235, 595, 4100, 4100, 3, 1, 2400.90966796875, 1219.62158203125, 134.0390167236328125, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+56, 187194, 595, 4100, 4100, 3, 1, 2395.723876953125, 1194.1319580078125, 142.4735870361328125, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 7200, 255, 1, 57916), -- Hanging, Streamer x3 - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+57, 187235, 595, 4100, 4100, 3, 1, 2389.998291015625, 1194.26220703125, 148.0759124755859375, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+58, 187235, 595, 4100, 4100, 3, 1, 2395.064208984375, 1176.1875, 133.93292236328125, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+59, 187235, 595, 4100, 4100, 3, 1, 2399.833251953125, 1172.3489990234375, 148.0749053955078125, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+60, 187235, 595, 4100, 4100, 3, 1, 2418.4775390625, 1223.9947509765625, 134.0390167236328125, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+61, 187194, 595, 4100, 4100, 3, 1, 2407.859375, 1196.763916015625, 142.53497314453125, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 7200, 255, 1, 57916), -- Hanging, Streamer x3 - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+62, 187194, 595, 4100, 4100, 3, 1, 2421.213623046875, 1200.0069580078125, 142.5443267822265625, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 7200, 255, 1, 57916), -- Hanging, Streamer x3 - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+63, 187235, 595, 4100, 4100, 3, 1, 2411.060791015625, 1175.234375, 148.074920654296875, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+64, 187235, 595, 4100, 4100, 3, 1, 2407.21533203125, 1138.1649169921875, 148.0759124755859375, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+65, 187194, 595, 4100, 4100, 3, 1, 2433.482666015625, 1202.951416015625, 142.5956878662109375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 7200, 255, 1, 57916), -- Hanging, Streamer x3 - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+66, 187235, 595, 4100, 4100, 3, 1, 2418.864501953125, 1141.2552490234375, 148.075897216796875, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+67, 187235, 595, 4100, 4100, 3, 1, 2408.55029296875, 1113.0538330078125, 148.0759124755859375, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+68, 187194, 595, 4100, 4100, 3, 1, 2412.736083984375, 1103.907958984375, 154.756591796875, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 7200, 255, 1, 57916), -- Hanging, Streamer x3 - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+69, 187235, 595, 4100, 4100, 3, 1, 2412.786376953125, 1094.19970703125, 148.0759124755859375, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+70, 187235, 595, 4100, 4100, 3, 1, 2452.13720703125, 1122.0504150390625, 148.075897216796875, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+71, 187235, 595, 4100, 4100, 3, 1, 2455.65625, 1104.7725830078125, 148.075897216796875, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 7200, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 +(@OGUID+72, 187235, 595, 4100, 4100, 3, 1, 2520.549560546875, 1138.0416259765625, 132.076507568359375, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 7200, 255, 1, 57916); -- Standing, Exterior, Medium - Xmas (Area: The Culling of Stratholme - Difficulty: 1) CreateObject1 + +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+72 AND `eventEntry`=@EVENT; +INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+72; |