diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_12_05_02_world.sql | 91 |
1 files changed, 91 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_12_05_02_world.sql b/sql/updates/world/3.3.5/2024_12_05_02_world.sql new file mode 100644 index 00000000000..184b6c29905 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_12_05_02_world.sql @@ -0,0 +1,91 @@ +-- +SET @OGUID := 93724; -- Need 82 +SET @EVENT := 24; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+81; +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, 195256, 530, 3518, 3626, 1, 1, -2571.461181640625, 7378.0302734375, 11.0595703125, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+1, 195256, 530, 3518, 3626, 1, 1, -2561.666259765625, 7378.9599609375, 10.57090091705322265, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+2, 195256, 530, 3518, 3626, 1, 1, -2611.333984375, 7343.45654296875, 23.60636329650878906, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+3, 195256, 530, 3518, 3626, 1, 1, -2573.72021484375, 7300.3046875, 13.90452003479003906, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+4, 195256, 530, 3518, 3626, 1, 1, -2614.57177734375, 7330.8759765625, 24.21088790893554687, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+5, 195256, 530, 3518, 3626, 1, 1, -2618.060791015625, 7338.908203125, 23.65935897827148437, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+6, 195256, 530, 3518, 3626, 1, 1, -2624.407958984375, 7331.68603515625, 24.46343994140625, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+7, 195256, 530, 3518, 3626, 1, 1, -2625.709716796875, 7298.20947265625, 21.14083099365234375, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+8, 195256, 530, 3518, 3626, 1, 1, -2570.704833984375, 7291.2900390625, 14.81432628631591796, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+9, 195256, 530, 3518, 3626, 1, 1, -2614.920166015625, 7297.7255859375, 20.74479866027832031, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+10, 195256, 530, 3518, 3626, 1, 1, -2605.266357421875, 7291.26318359375, 19.81580162048339843, 3.647741317749023437, 0, 0, -0.96814727783203125, 0.250381410121917724, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+11, 195256, 530, 3518, 3626, 1, 1, -2602.271240234375, 7282.345703125, 19.39945030212402343, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+12, 195256, 530, 3518, 3626, 1, 1, -2528.43505859375, 7266.2861328125, 16.2702484130859375, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+13, 195256, 530, 3518, 3626, 1, 1, -2534.46826171875, 7256.74951171875, 16.26636314392089843, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+14, 195256, 530, 3518, 3626, 1, 1, -2600.8056640625, 7237.7109375, 12.91721916198730468, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+15, 195256, 530, 3518, 3626, 1, 1, -2692.655517578125, 7296.978515625, 42.78501129150390625, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+16, 195266, 530, 3518, 3626, 1, 1, -2698.241455078125, 7291.55224609375, 49.91637039184570312, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+17, 195256, 530, 3518, 3626, 1, 1, -2720.993896484375, 7355.89599609375, 39.75893783569335937, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+18, 195256, 530, 3518, 3626, 1, 1, -2702.840576171875, 7293.720703125, 88.6365509033203125, 2.827429771423339843, 0, 0, 0.987688064575195312, 0.156436234712600708, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+19, 195266, 530, 3518, 3626, 1, 1, -2713.3603515625, 7298.4453125, 51.91501235961914062, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+20, 195256, 530, 3518, 3626, 1, 1, -2721.76171875, 7343.4541015625, 39.4463348388671875, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+21, 195256, 530, 3518, 3626, 1, 1, -2697.950439453125, 7284.06103515625, 42.72089385986328125, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+22, 195256, 530, 3518, 3626, 1, 1, -2596.802490234375, 7228.939453125, 13.47050762176513671, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+23, 195256, 530, 3518, 3626, 1, 1, -2626.202392578125, 7216.5498046875, 20.35766029357910156, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+24, 195256, 530, 3518, 3626, 1, 1, -2630.0986328125, 7224.42529296875, 19.74051475524902343, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+25, 195256, 530, 3518, 3626, 1, 1, -2755.32421875, 7317.08056640625, 56.35858535766601562, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+26, 195264, 530, 3518, 3626, 1, 1, -2760.96923828125, 7304.01025390625, 44.88897705078125, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+27, 195273, 530, 3518, 3626, 1, 1, -2738.57080078125, 7309.4521484375, 63.32978057861328125, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+28, 195256, 530, 3518, 3626, 1, 1, -2752.12109375, 7315.080078125, 43.48479461669921875, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+29, 195264, 530, 3518, 3626, 1, 1, -2765.62548828125, 7302.78564453125, 44.92822265625, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+30, 195266, 530, 3518, 3626, 1, 1, -2730.688720703125, 7306.02099609375, 51.77650070190429687, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+31, 195273, 530, 3518, 3626, 1, 1, -2742.36865234375, 7297.82568359375, 47.8856353759765625, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+32, 195266, 530, 3518, 3626, 1, 1, -2775.22607421875, 7326.033203125, 51.77103042602539062, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+33, 195256, 530, 3518, 3626, 1, 1, -2755.533935546875, 7275.69091796875, 40.2712554931640625, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+34, 195273, 530, 3518, 3626, 1, 1, -2732.494140625, 7320.93212890625, 47.57973098754882812, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+35, 195264, 530, 3518, 3626, 1, 1, -2756.8896484375, 7304.197265625, 44.86130905151367187, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 0), -- Standing, Interior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+36, 195273, 530, 3518, 3626, 1, 1, -2772.80078125, 7324.94873046875, 63.32421875, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+37, 195256, 530, 3518, 3626, 1, 1, -2762.166259765625, 7267.40087890625, 40.26733779907226562, 5.724681377410888671, 0, 0, -0.27563667297363281, 0.961261868476867675, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+38, 195256, 530, 3518, 3626, 1, 1, -2670.031005859375, 7211.86328125, 23.66940689086914062, 0.994837164878845214, 0, 0, 0.477158546447753906, 0.878817260265350341, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+39, 195266, 530, 3518, 3626, 1, 1, -2677.658447265625, 7203.91943359375, 32.99669265747070312, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 0), -- Hanging, Streamer - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+40, 195256, 530, 3518, 3626, 1, 1, -2678.9892578125, 7214.02978515625, 23.95701217651367187, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Telaar - Difficulty: 0) CreateObject1 +(@OGUID+41, 195256, 530, 3518, 3613, 1, 1, -1296.558349609375, 6953.97314453125, 33.24512863159179687, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+42, 195256, 530, 3518, 3613, 1, 1, -1307.796630859375, 6960.4736328125, 32.2698211669921875, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+43, 195256, 530, 3518, 3613, 1, 1, -1254.381103515625, 7007.265625, 36.6230010986328125, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+44, 195256, 530, 3518, 3613, 1, 1, -1241.7535400390625, 7003.59423828125, 36.79386138916015625, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+45, 195256, 530, 3518, 3613, 1, 1, -1387.220703125, 7134.828125, 34.03578948974609375, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+46, 195256, 530, 3518, 3613, 1, 1, -1364.81298828125, 7156.56494140625, 34.00505447387695312, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+47, 195256, 530, 3518, 3613, 1, 1, -1392.475830078125, 7140.16845703125, 33.73893356323242187, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+48, 195256, 530, 3518, 3613, 1, 1, -1371.6705322265625, 7162.8037109375, 33.253997802734375, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+49, 195256, 530, 3518, 3613, 1, 1, -1454.1597900390625, 7165.0458984375, 44.56573486328125, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+50, 195256, 530, 3518, 3613, 1, 1, -1283.425537109375, 7130.822265625, 59.73568344116210937, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+51, 195256, 530, 3518, 3613, 1, 1, -1282.8367919921875, 7187.43017578125, 58.00640869140625, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+52, 195256, 530, 3518, 3613, 1, 1, -1262.0758056640625, 7107.591796875, 58.8874664306640625, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+53, 195253, 530, 3518, 3613, 1, 1, -1260.942626953125, 7180.6337890625, 63.39373779296875, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 0), -- Hanging, Streamer x3 - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+54, 195256, 530, 3518, 3613, 1, 1, -1271.8828125, 7197.9970703125, 57.898193359375, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+55, 195273, 530, 3518, 3613, 1, 1, -1253.0084228515625, 7158.91064453125, 61.71668243408203125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+56, 195256, 530, 3518, 3613, 1, 1, -1247.80078125, 7101.98095703125, 58.06834030151367187, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+57, 195273, 530, 3518, 3613, 1, 1, -1240.11376953125, 7134.3564453125, 61.81643295288085937, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+58, 195256, 530, 3518, 3613, 1, 1, -1209.607666015625, 7103.7080078125, 57.44921112060546875, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+59, 195273, 530, 3518, 3613, 1, 1, -1212.329833984375, 7133.37646484375, 61.55224609375, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+60, 195256, 530, 3518, 3613, 1, 1, -1194.7515869140625, 7110.27880859375, 58.06450271606445312, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+61, 195260, 530, 3518, 3613, 1, 1, -1229.2685546875, 7157.3984375, 58.4376373291015625, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+62, 195256, 530, 3518, 3613, 1, 1, -1173.5557861328125, 7134.2314453125, 58.114990234375, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+63, 195260, 530, 3518, 3613, 1, 1, -1224.0504150390625, 7154.1015625, 58.44301223754882812, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+64, 195273, 530, 3518, 3613, 1, 1, -1237.7955322265625, 7183.27978515625, 61.05430984497070312, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+65, 195273, 530, 3518, 3613, 1, 1, -1197.399658203125, 7157.67041015625, 61.52597427368164062, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+66, 195260, 530, 3518, 3613, 1, 1, -1226.032958984375, 7162.578125, 58.451416015625, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+67, 195260, 530, 3518, 3613, 1, 1, -1220.8184814453125, 7159.2900390625, 58.4534912109375, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 0), -- Standing, Interior, Small - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+68, 195273, 530, 3518, 3613, 1, 1, -1210.0084228515625, 7182.3271484375, 61.39197540283203125, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 0), -- Hanging, Tall/Thin, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+69, 195256, 530, 3518, 3613, 1, 1, -1249.8062744140625, 7217.7626953125, 58.32961654663085937, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+70, 195256, 530, 3518, 3613, 1, 1, -1221.3048095703125, 7222.46337890625, 59.25885772705078125, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+71, 195256, 530, 3518, 3613, 1, 1, -1201.7222900390625, 7206.6494140625, 58.5518798828125, 0.994837164878845214, 0, 0, 0.477158546447753906, 0.878817260265350341, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+72, 195256, 530, 3518, 3613, 1, 1, -1296.4398193359375, 7267.44384765625, 34.6165313720703125, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+73, 195256, 530, 3518, 3613, 1, 1, -1302.7530517578125, 7271.98974609375, 34.41438674926757812, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+74, 195256, 530, 3518, 3613, 1, 1, -1176.2156982421875, 7200.08447265625, 58.2138214111328125, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+75, 195256, 530, 3518, 3613, 1, 1, -1184.83349609375, 7207.80712890625, 57.92132568359375, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+76, 195256, 530, 3518, 3613, 1, 1, -1198.806640625, 7250.10986328125, 35.1543426513671875, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+77, 195256, 530, 3518, 3613, 1, 1, -1184.6793212890625, 7246.919921875, 35.14312744140625, 2.827429771423339843, 0, 0, 0.987688064575195312, 0.156436234712600708, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+78, 195256, 530, 3518, 3613, 1, 1, -1273.8309326171875, 7316.6728515625, 33.7790985107421875, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+79, 195256, 530, 3518, 3613, 1, 1, -1265.5079345703125, 7313.12939453125, 34.21532440185546875, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+80, 195256, 530, 3518, 3613, 1, 1, -1220.26416015625, 7388.15966796875, 30.789276123046875, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 0), -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 +(@OGUID+81, 195256, 530, 3518, 3613, 1, 1, -1207.9671630859375, 7386.6630859375, 31.42566871643066406, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 0); -- Standing, Exterior, Medium - Brewfest (Area: Garadar - Difficulty: 0) CreateObject1 + +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+81 AND `eventEntry`=@EVENT; +INSERT INTO `game_event_gameobject` SELECT @EVENT, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+81; |