diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_12_05_00_world.sql | 75 |
1 files changed, 75 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_12_05_00_world.sql b/sql/updates/world/3.3.5/2024_12_05_00_world.sql new file mode 100644 index 00000000000..af0ae9f53a3 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_12_05_00_world.sql @@ -0,0 +1,75 @@ +-- +SET @OGUID := 93658; -- Need 66 +SET @EVENT := 24; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+65; +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, 195273, 530, 3522, 3951, 1, 1, 2945.66259765625, 5412.689453125, 150.0002593994140625, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+1, 195273, 530, 3522, 3951, 1, 1, 2935.668212890625, 5418.9306640625, 149.9498291015625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+2, 195253, 530, 3522, 3951, 1, 1, 2940.299072265625, 5415.8017578125, 165.9381561279296875, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+3, 195264, 530, 3522, 3951, 1, 1, 3016.26220703125, 5430.1806640625, 148.0060577392578125, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+4, 195259, 530, 3522, 3951, 1, 1, 3013.2666015625, 5429.97119140625, 148.0764007568359375, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+5, 195259, 530, 3522, 3951, 1, 1, 2944.679443359375, 5466.7021484375, 150.6358184814453125, 0, 0, 0, 0, 1, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+6, 195256, 530, 3522, 3951, 1, 1, 2969.010498046875, 5459.72509765625, 144.69720458984375, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+7, 195260, 530, 3522, 3951, 1, 1, 3017.862548828125, 5435.4111328125, 147.436614990234375, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+8, 195266, 530, 3522, 3951, 1, 1, 3016.6123046875, 5445.06884765625, 151.876983642578125, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+9, 195260, 530, 3522, 3951, 1, 1, 3026.326904296875, 5430.9189453125, 148.449310302734375, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+10, 195260, 530, 3522, 3951, 1, 1, 3027.364990234375, 5431.576171875, 148.4505157470703125, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+11, 195256, 530, 3522, 3951, 1, 1, 2950.8291015625, 5486.53076171875, 144.1426544189453125, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+12, 195253, 530, 3522, 3951, 1, 1, 2944.295654296875, 5533.42822265625, 163.8209686279296875, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+13, 195273, 530, 3522, 3951, 1, 1, 2941.7880859375, 5528.2353515625, 149.5076751708984375, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+14, 195266, 530, 3522, 3951, 1, 1, 3026.51025390625, 5497.439453125, 151.5306549072265625, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+15, 195256, 530, 3522, 3951, 1, 1, 3011.184814453125, 5493.75, 145.0009307861328125, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+16, 195273, 530, 3522, 3951, 1, 1, 2947.150634765625, 5538.0439453125, 149.5360260009765625, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+17, 195273, 530, 3522, 3951, 1, 1, 3083.156982421875, 5479.302734375, 146.721160888671875, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+18, 195253, 530, 3522, 3951, 1, 1, 3085.63330078125, 5473.6279296875, 162.5823516845703125, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Evergrove - Difficulty: 0) CreateObject1 +(@OGUID+19, 195259, 530, 3522, 3844, 1, 1, 2188.35693359375, 4795.171875, 158.6740264892578125, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+20, 195260, 530, 3522, 3844, 1, 1, 2173.998779296875, 4726.61572265625, 157.7523651123046875, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+21, 195259, 530, 3522, 3844, 1, 1, 2181.06591796875, 4706.8447265625, 159.597625732421875, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+22, 195259, 530, 3522, 3844, 1, 1, 2165.545654296875, 4727.486328125, 159.5631103515625, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+23, 195273, 530, 3522, 3844, 1, 1, 2148.1455078125, 4823.4619140625, 153.2520599365234375, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+24, 195266, 530, 3522, 3844, 1, 1, 2154.755859375, 4716.65576171875, 160.954681396484375, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+25, 195266, 530, 3522, 3844, 1, 1, 2155.24951171875, 4720.380859375, 160.944915771484375, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+26, 195273, 530, 3522, 3844, 1, 1, 2137.6142578125, 4828.30615234375, 155.2135772705078125, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+27, 195253, 530, 3522, 3844, 1, 1, 2092.12744140625, 4792.1640625, 175.636199951171875, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+28, 195253, 530, 3522, 3844, 1, 1, 2098.94580078125, 4779.43212890625, 175.532470703125, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+29, 195253, 530, 3522, 3844, 1, 1, 2090.407470703125, 4769.77099609375, 175.6497344970703125, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+30, 195256, 530, 3522, 3844, 1, 1, 2087.610595703125, 4782.98876953125, 157.7813568115234375, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+31, 195253, 530, 3522, 3844, 1, 1, 2078.7470703125, 4789.83056640625, 175.6967620849609375, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+32, 195260, 530, 3522, 3844, 1, 1, 2045.7447509765625, 4731.15478515625, 151.848724365234375, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+33, 195259, 530, 3522, 3844, 1, 1, 2045.4296875, 4686.2568359375, 153.3060150146484375, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+34, 195266, 530, 3522, 3844, 1, 1, 2035.0504150390625, 4693.1162109375, 154.721710205078125, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+35, 195266, 530, 3522, 3844, 1, 1, 2031.4676513671875, 4692.1103515625, 154.7591094970703125, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+36, 195256, 530, 3522, 3844, 1, 1, 2019.060791015625, 4700.48193359375, 150.237762451171875, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+37, 195259, 530, 3522, 3844, 1, 1, 2032.304443359375, 4663.9609375, 153.4190826416015625, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+38, 195264, 530, 3522, 3844, 1, 1, 2042.164306640625, 4667.0546875, 151.262664794921875, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Mok'Nathal Village - Difficulty: 0) CreateObject1 +(@OGUID+39, 195253, 530, 3522, 3772, 1, 1, 2066.2578125, 6730.63916015625, 181.51666259765625, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+40, 195253, 530, 3522, 3772, 1, 1, 2066.148193359375, 6726.275390625, 181.5531158447265625, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+41, 195253, 530, 3522, 3772, 1, 1, 2070.802978515625, 6759.6708984375, 173.274200439453125, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+42, 195253, 530, 3522, 3772, 1, 1, 2055.8271484375, 6759.79150390625, 173.274200439453125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+43, 195266, 530, 3522, 3772, 1, 1, 2063.30517578125, 6759.89794921875, 173.2681427001953125, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+44, 195266, 530, 3522, 3772, 1, 1, 2163.69384765625, 6745.07666015625, 172.408538818359375, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+45, 195259, 530, 3522, 3772, 1, 1, 1989.3138427734375, 6784.46484375, 167.9163970947265625, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+46, 195266, 530, 3522, 3772, 1, 1, 2162.736572265625, 6751.21435546875, 172.43853759765625, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+47, 195266, 530, 3522, 3772, 1, 1, 2031.962646484375, 6825.552734375, 181.533294677734375, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+48, 195266, 530, 3522, 3772, 1, 1, 2038.027099609375, 6826.09423828125, 181.4816436767578125, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+49, 195266, 530, 3522, 3772, 1, 1, 2038.5650634765625, 6819.837890625, 181.4885406494140625, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+50, 195260, 530, 3522, 3772, 1, 1, 1989.5538330078125, 6785.7109375, 165.7517242431640625, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+51, 195266, 530, 3522, 3772, 1, 1, 2032.2135009765625, 6819.36962890625, 181.5124969482421875, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+52, 195266, 530, 3522, 3772, 1, 1, 2062.016357421875, 6825.853515625, 184.783203125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+53, 195273, 530, 3522, 3772, 1, 1, 2051.89013671875, 6831.6376953125, 177.0355377197265625, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+54, 195266, 530, 3522, 3772, 1, 1, 2169.92529296875, 6745.9697265625, 172.43658447265625, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+55, 195256, 530, 3522, 3772, 1, 1, 2161.681640625, 6783.0478515625, 183.453582763671875, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+56, 195266, 530, 3522, 3772, 1, 1, 2168.956298828125, 6752.18212890625, 172.4386749267578125, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+57, 195253, 530, 3522, 3772, 1, 1, 2095.052490234375, 6899.6201171875, 190.438201904296875, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+58, 195253, 530, 3522, 3772, 1, 1, 2085.431396484375, 6890.10400390625, 190.465667724609375, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+59, 195256, 530, 3522, 3772, 1, 1, 2007.013427734375, 6878.82177734375, 178.9834442138671875, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+60, 195266, 530, 3522, 3772, 1, 1, 2009.812744140625, 6871.4130859375, 188.180755615234375, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+61, 195256, 530, 3522, 3772, 1, 1, 2017.318603515625, 6873.4814453125, 178.9829864501953125, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+62, 195259, 530, 3522, 3772, 1, 1, 2016.857421875, 6885.0546875, 182.8495941162109375, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 0), -- Hanging, Square, Small - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+63, 195266, 530, 3522, 3772, 1, 1, 1955.62548828125, 6885.82080078125, 167.1296234130859375, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+64, 195253, 530, 3522, 3772, 1, 1, 1937.43359375, 6838.64013671875, 177.4421844482421875, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 +(@OGUID+65, 195253, 530, 3522, 3772, 1, 1, 1941.3951416015625, 6838.6572265625, 177.4772491455078125, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 0); -- Hanging, Streamer x3 - Brewfest (Area: Sylvanaar - Difficulty: 0) CreateObject1 + +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+65 AND `eventEntry`=@EVENT; +INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+65; |