diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2025_11_24_02_world.sql | 98 |
1 files changed, 98 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2025_11_24_02_world.sql b/sql/updates/world/3.3.5/2025_11_24_02_world.sql new file mode 100644 index 00000000000..4cee48935a0 --- /dev/null +++ b/sql/updates/world/3.3.5/2025_11_24_02_world.sql @@ -0,0 +1,98 @@ +SET @OGUID := 94047; -- Set by TDB team (91) +SET @EVENT := 2; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+90; +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, 571, 3537, 4032, 1, 1, 2238.3603515625, 5132.744140625, 5.344913959503173828, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+1, 187567, 571, 3537, 4032, 1, 1, 2288.640625, 5214.3359375, 27.50825309753417968, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+2, 187567, 571, 3537, 4032, 1, 1, 2270.001708984375, 5197.173828125, 17.32867622375488281, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+3, 187567, 571, 3537, 4032, 1, 1, 2270.87890625, 5210.54248046875, 28.94805908203125, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+4, 187235, 571, 3537, 4032, 1, 1, 2226.790771484375, 5136.91455078125, 5.344574928283691406, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+5, 187235, 571, 3537, 4032, 1, 1, 2238.516845703125, 5180.17626953125, 14.71352958679199218, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+6, 187567, 571, 3537, 4032, 1, 1, 2274.93408203125, 5189.16943359375, 26.13615226745605468, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+7, 187235, 571, 3537, 4032, 1, 1, 2255.3095703125, 5225.85595703125, 14.71352863311767578, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+8, 187235, 571, 3537, 4032, 1, 1, 2248.404052734375, 5206.861328125, 14.71352863311767578, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+9, 187567, 571, 3537, 4032, 1, 1, 2314.89404296875, 5185.27587890625, 23.48017692565917968, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+10, 187235, 571, 3537, 4032, 1, 1, 2207.053466796875, 5222.54248046875, 14.10004520416259765, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+11, 187567, 571, 3537, 4032, 1, 1, 2320.046875, 5198.4697265625, 23.7144622802734375, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+12, 187567, 571, 3537, 4032, 1, 1, 2303.013916015625, 5208.548828125, 27.68203544616699218, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+13, 187235, 571, 3537, 4032, 1, 1, 2352.74169921875, 5196.42041015625, 7.632044792175292968, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+14, 187235, 571, 3537, 4032, 1, 1, 2302.697509765625, 5237.80029296875, 11.33970260620117187, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+15, 187235, 571, 3537, 4032, 1, 1, 2214.6953125, 5241.33349609375, 14.10004520416259765, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+16, 187235, 571, 3537, 4032, 1, 1, 2366.833251953125, 5211.396484375, 7.632043838500976562, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+17, 187235, 571, 3537, 4032, 1, 1, 2276.3203125, 5282.166015625, 15.66974735260009765, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+18, 187235, 571, 3537, 4032, 1, 1, 2234.98681640625, 5298.37890625, 15.05626106262207031, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+19, 187235, 571, 3537, 4032, 1, 1, 2187.26904296875, 5257.0966796875, 23.37514686584472656, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+20, 187235, 571, 3537, 4032, 1, 1, 2192.25537109375, 5270.982421875, 24.4593658447265625, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+21, 187235, 571, 3537, 4032, 1, 1, 2197.986083984375, 5288.5576171875, 24.45936393737792968, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+22, 187235, 571, 3537, 4032, 1, 1, 2288.013427734375, 5313.14697265625, 14.71353340148925781, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+23, 187235, 571, 3537, 4032, 1, 1, 2208.510009765625, 5319.640625, 23.37514686584472656, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+24, 187235, 571, 3537, 4032, 1, 1, 2202.939453125, 5302.73291015625, 23.37514686584472656, 2.827429771423339843, 0, 0, 0.987688064575195312, 0.156436234712600708, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+25, 187235, 571, 3537, 4032, 1, 1, 2213.9501953125, 5333.77783203125, 23.37514877319335937, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+26, 187235, 571, 3537, 4032, 1, 1, 2151.34326171875, 5284.07080078125, 24.66521263122558593, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+27, 187235, 571, 3537, 4032, 1, 1, 2157.4755859375, 5301.4140625, 24.66485023498535156, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+28, 187235, 571, 3537, 4032, 1, 1, 2122.561279296875, 5320.2626953125, 32.77589035034179687, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+29, 187235, 571, 3537, 4032, 1, 1, 2112.849853515625, 5291.52392578125, 32.77573776245117187, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Valiance Keep - Difficulty: 0) CreateObject1 +(@OGUID+30, 187567, 571, 3537, 4129, 1, 1, 2769.889892578125, 6123.314453125, 96.68723297119140625, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+31, 187235, 571, 3537, 4129, 1, 1, 2805.133544921875, 6135.2744140625, 84.6513214111328125, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+32, 187235, 571, 3537, 4129, 1, 1, 2788.65966796875, 6162.68017578125, 84.8553009033203125, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+33, 187235, 571, 3537, 4129, 1, 1, 2876.30810546875, 6204.3359375, 208.739349365234375, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+34, 187235, 571, 3537, 4129, 1, 1, 2899.378173828125, 6242.91259765625, 208.8885040283203125, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+35, 187235, 571, 3537, 4129, 1, 1, 2902.970458984375, 6231.560546875, 208.8656158447265625, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+36, 187235, 571, 3537, 4129, 1, 1, 2922.967529296875, 6238.52978515625, 208.905548095703125, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+37, 187235, 571, 3537, 4129, 1, 1, 2888.891357421875, 6247.6015625, 208.8507232666015625, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+38, 187235, 571, 3537, 4129, 1, 1, 2861.186279296875, 6199.25244140625, 208.7365570068359375, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+39, 187235, 571, 3537, 4129, 1, 1, 2892.68212890625, 6263.138671875, 209.03607177734375, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+40, 187235, 571, 3537, 4129, 1, 1, 2860.568603515625, 6221.08056640625, 208.737518310546875, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+41, 187235, 571, 3537, 4129, 1, 1, 2853.403564453125, 6207.33447265625, 208.7359161376953125, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+42, 187235, 571, 3537, 4129, 1, 1, 2799.83544921875, 6186.32763671875, 84.08406829833984375, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+43, 187567, 571, 3537, 4129, 1, 1, 2815.302978515625, 6165.52587890625, 90.96311187744140625, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+44, 187235, 571, 3537, 4129, 1, 1, 2815.3046875, 6174.10107421875, 121.9517669677734375, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+45, 187235, 571, 3537, 4129, 1, 1, 2823.608642578125, 6165.09228515625, 121.9373092651367187, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Warsong Hold - Difficulty: 0) CreateObject1 +(@OGUID+46, 187235, 571, 3537, 4121, 1, 1, 3578.23046875, 6633.5537109375, 195.177947998046875, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Transitus Shield - Difficulty: 0) CreateObject1 +(@OGUID+47, 187567, 571, 3537, 4121, 1, 1, 3569.432373046875, 6650.1806640625, 201.2050933837890625, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: Transitus Shield - Difficulty: 0) CreateObject1 +(@OGUID+48, 187235, 571, 3537, 4121, 1, 1, 3585.120361328125, 6674.99072265625, 195.1798858642578125, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Transitus Shield - Difficulty: 0) CreateObject1 +(@OGUID+49, 187567, 571, 3537, 4121, 1, 1, 3578.572998046875, 6669.5009765625, 200.2971343994140625, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: Transitus Shield - Difficulty: 0) CreateObject1 +(@OGUID+50, 187235, 571, 3537, 4023, 1, 1, 3521.80224609375, 5957.62744140625, 134.07440185546875, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Amber Ledge - Difficulty: 0) CreateObject1 +(@OGUID+51, 187235, 571, 3537, 4023, 1, 1, 3519.408935546875, 5943.52685546875, 134.4015960693359375, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Amber Ledge - Difficulty: 0) CreateObject1 +(@OGUID+52, 187235, 571, 3537, 4023, 1, 1, 3584.385498046875, 5975.64404296875, 136.21575927734375, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Amber Ledge - Difficulty: 0) CreateObject1 +(@OGUID+53, 187235, 571, 3537, 4023, 1, 1, 3612.380126953125, 5919.876953125, 136.0995330810546875, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Amber Ledge - Difficulty: 0) CreateObject1 +(@OGUID+54, 187235, 571, 3537, 4023, 1, 1, 3605.88623046875, 5989.13623046875, 136.2162322998046875, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Amber Ledge - Difficulty: 0) CreateObject1 +(@OGUID+55, 187235, 571, 3537, 4023, 1, 1, 3624.637451171875, 5926.56884765625, 136.21624755859375, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Amber Ledge - Difficulty: 0) CreateObject1 +(@OGUID+56, 187235, 571, 3537, 4023, 1, 1, 3623.188232421875, 5947.21337890625, 136.2162322998046875, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Amber Ledge - Difficulty: 0) CreateObject1 +(@OGUID+57, 187567, 571, 3537, 4023, 1, 1, 3624.583251953125, 5913.43603515625, 144.8048858642578125, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 57916), -- Hanging, Streamer - Xmas (Area: Amber Ledge - Difficulty: 0) CreateObject1 +(@OGUID+58, 187235, 571, 3537, 4023, 1, 1, 3633.384521484375, 5887.4833984375, 140.0764923095703125, 0.994837164878845214, 0, 0, 0.477158546447753906, 0.878817260265350341, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Amber Ledge - Difficulty: 0) CreateObject1 +(@OGUID+59, 187235, 571, 3537, 4023, 1, 1, 3647.803466796875, 5882.2255859375, 174.494293212890625, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Amber Ledge - Difficulty: 0) CreateObject1 +(@OGUID+60, 187235, 571, 3537, 4113, 1, 1, 2998.711181640625, 4070.604248046875, 26.91522789001464843, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Unu'pe - Difficulty: 0) CreateObject1 +(@OGUID+61, 187235, 571, 3537, 4113, 1, 1, 2997.856689453125, 4049.579345703125, 26.61824226379394531, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Unu'pe - Difficulty: 0) CreateObject1 +(@OGUID+62, 187235, 571, 3537, 4113, 1, 1, 3017.189453125, 4065.65185546875, 26.77532768249511718, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Unu'pe - Difficulty: 0) CreateObject1 +(@OGUID+63, 187235, 571, 3537, 4113, 1, 1, 3008.4267578125, 4048.362548828125, 26.36823272705078125, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Unu'pe - Difficulty: 0) CreateObject1 +(@OGUID+64, 187235, 571, 3537, 4113, 1, 1, 2927.11669921875, 4077.87158203125, 2.141782999038696289, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Unu'pe - Difficulty: 0) CreateObject1 +(@OGUID+65, 187235, 571, 3537, 4113, 1, 1, 2899.83154296875, 4067.15625, 1.792299985885620117, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Unu'pe - Difficulty: 0) CreateObject1 +(@OGUID+66, 187235, 571, 3537, 4113, 1, 1, 2904.64013671875, 4073.700439453125, 1.964231014251708984, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Unu'pe - Difficulty: 0) CreateObject1 +(@OGUID+67, 187235, 571, 3537, 4113, 1, 1, 2922.883056640625, 4037.387939453125, 1.768460988998413085, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Unu'pe - Difficulty: 0) CreateObject1 +(@OGUID+68, 187235, 571, 3537, 4113, 1, 1, 2959.033935546875, 3995.015625, 1.87953805923461914, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Unu'pe - Difficulty: 0) CreateObject1 +(@OGUID+69, 187235, 571, 3537, 4113, 1, 1, 2875.32763671875, 4035.009033203125, 5.44103097915649414, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Unu'pe - Difficulty: 0) CreateObject1 +(@OGUID+70, 187235, 571, 3537, 4113, 1, 1, 2872.568603515625, 4041.227783203125, 5.269433975219726562, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Unu'pe - Difficulty: 0) CreateObject1 +(@OGUID+71, 187235, 571, 3537, 4113, 1, 1, 2910.1943359375, 4046.255615234375, 1.670829057693481445, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Unu'pe - Difficulty: 0) CreateObject1 +(@OGUID+72, 187235, 571, 3537, 4114, 1, 1, 3099.8447265625, 3831.98388671875, 23.01079750061035156, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Death's Stand - Difficulty: 0) CreateObject1 +(@OGUID+73, 187235, 571, 3537, 4108, 1, 1, 4116.859375, 5260.4541015625, 24.72841644287109375, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Fizzcrank Airstrip - Difficulty: 0) CreateObject1 +(@OGUID+74, 187235, 571, 3537, 4108, 1, 1, 4124.85400390625, 5302.79833984375, 29.5003662109375, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Fizzcrank Airstrip - Difficulty: 0) CreateObject1 +(@OGUID+75, 187235, 571, 3537, 4108, 1, 1, 4079.892333984375, 5272.37060546875, 27.84728622436523437, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Fizzcrank Airstrip - Difficulty: 0) CreateObject1 +(@OGUID+76, 187235, 571, 3537, 4108, 1, 1, 4064.177001953125, 5287.177734375, 28.33382987976074218, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Fizzcrank Airstrip - Difficulty: 0) CreateObject1 +(@OGUID+77, 187235, 571, 3537, 4108, 1, 1, 4038.372802734375, 5295.92822265625, 24.80444717407226562, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Fizzcrank Airstrip - Difficulty: 0) CreateObject1 +(@OGUID+78, 187235, 571, 3537, 4108, 1, 1, 4047.685302734375, 5298.59326171875, 24.65438461303710937, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Fizzcrank Airstrip - Difficulty: 0) CreateObject1 +(@OGUID+79, 187235, 571, 3537, 4122, 1, 1, 4474.953125, 5701.2958984375, 81.268310546875, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Bor'gorok Outpost - Difficulty: 0) CreateObject1 +(@OGUID+80, 187235, 571, 3537, 4122, 1, 1, 4496.20556640625, 5716.17431640625, 81.43398284912109375, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Bor'gorok Outpost - Difficulty: 0) CreateObject1 +(@OGUID+81, 187194, 571, 3537, 4122, 1, 1, 4502.59375, 5701.0087890625, 86.93270111083984375, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 57916), -- Hanging, Streamer x3 - Xmas (Area: Bor'gorok Outpost - Difficulty: 0) CreateObject1 +(@OGUID+82, 187235, 571, 3537, 4122, 1, 1, 4464.80078125, 5710.1494140625, 81.19541168212890625, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Bor'gorok Outpost - Difficulty: 0) CreateObject1 +(@OGUID+83, 187235, 571, 3537, 4122, 1, 1, 4504.060546875, 5681.630859375, 81.4865570068359375, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Bor'gorok Outpost - Difficulty: 0) CreateObject1 +(@OGUID+85, 187235, 571, 3537, 4122, 1, 1, 4503.0888671875, 5725.7080078125, 81.2832489013671875, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Bor'gorok Outpost - Difficulty: 0) CreateObject1 +(@OGUID+86, 187194, 571, 3537, 4122, 1, 1, 4522.38671875, 5716.76220703125, 86.95365142822265625, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 57916), -- Hanging, Streamer x3 - Xmas (Area: Bor'gorok Outpost - Difficulty: 0) CreateObject1 +(@OGUID+87, 187194, 571, 3537, 4122, 1, 1, 4520.1025390625, 5699.3740234375, 86.9876251220703125, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 57916), -- Hanging, Streamer x3 - Xmas (Area: Bor'gorok Outpost - Difficulty: 0) CreateObject1 +(@OGUID+88, 187235, 571, 3537, 4122, 1, 1, 4509.7333984375, 5758.8916015625, 81.67447662353515625, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Bor'gorok Outpost - Difficulty: 0) CreateObject1 +(@OGUID+89, 187235, 571, 3537, 4122, 1, 1, 4518.92626953125, 5710.13525390625, 81.47955322265625, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 57916), -- Standing, Exterior, Medium - Xmas (Area: Bor'gorok Outpost - Difficulty: 0) CreateObject1 +(@OGUID+90, 187194, 571, 3537, 4122, 1, 1, 4505.32763671875, 5718.3759765625, 87.04782867431640625, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 57916); -- Hanging, Streamer x3 - Xmas (Area: Bor'gorok Outpost - Difficulty: 0) CreateObject1 + +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+90 AND `eventEntry`=@EVENT; +INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+90; |