diff options
| -rw-r--r-- | sql/updates/world/master/2024_04_07_05_world.sql | 208 |
1 files changed, 208 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_04_07_05_world.sql b/sql/updates/world/master/2024_04_07_05_world.sql new file mode 100644 index 00000000000..51693a7d30a --- /dev/null +++ b/sql/updates/world/master/2024_04_07_05_world.sql @@ -0,0 +1,208 @@ +SET @CGUID := 9800107; +SET @OGUID := 9804779; +SET @POOL := 5701; +SET @EVENT := 9; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+1; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curHealthPct`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 32799, 1, 141, 186, '0', 0, 0, 0, 0, 9846.1318359375, 949.09375, 1307.9688720703125, 5.730176448822021484, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 53989), -- Spring Collector (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@CGUID+1, 32836, 1, 141, 186, '0', 0, 0, 0, 1, 9844.9892578125, 947.98785400390625, 1307.8519287109375, 5.813007354736328125, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 53989); -- Noblegarden Vendor (Area: Dolanaar - Difficulty: 0) CreateObject1 + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+90; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 113769, 1, 141, 186, '0', 0, 0, 9671.5009765625, 943.3984375, 1290.744873046875, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+1, 113769, 1, 141, 186, '0', 0, 0, 9674.05078125, 940.224609375, 1290.3349609375, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+2, 113768, 1, 141, 186, '0', 0, 0, 9677.677734375, 968.15692138671875, 1293.7860107421875, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+3, 113770, 1, 141, 186, '0', 0, 0, 9683.44140625, 933.64581298828125, 1290.6617431640625, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+4, 113769, 1, 141, 186, '0', 0, 0, 9714.7001953125, 990.93804931640625, 1294.8983154296875, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+5, 113770, 1, 141, 186, '0', 0, 0, 9718.4267578125, 988.63897705078125, 1295.068115234375, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+6, 113770, 1, 141, 186, '0', 0, 0, 9721.951171875, 987.2344970703125, 1295.744140625, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+7, 113769, 1, 141, 186, '0', 0, 0, 9727.2451171875, 969.8856201171875, 1294.6402587890625, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+8, 113768, 1, 141, 186, '0', 0, 0, 9733.5771484375, 963.84307861328125, 1294.39501953125, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+9, 113771, 1, 141, 186, '0', 0, 0, 9750.5439453125, 904.02850341796875, 1295.517333984375, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+10, 113770, 1, 141, 186, '0', 0, 0, 9761.611328125, 931.51104736328125, 1299.7672119140625, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+11, 113768, 1, 141, 186, '0', 0, 0, 9764.15234375, 891.73529052734375, 1298.1422119140625, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+12, 113769, 1, 141, 186, '0', 0, 0, 9764.2373046875, 946.02191162109375, 1305.3731689453125, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+13, 113770, 1, 141, 186, '0', 0, 0, 9764.7001953125, 874.474365234375, 1297.418701171875, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+14, 113771, 1, 141, 186, '0', 0, 0, 9772.0712890625, 896.5762939453125, 1297.1168212890625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+15, 113771, 1, 141, 186, '0', 0, 0, 9777.8388671875, 960.312744140625, 1306.6773681640625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+16, 113771, 1, 141, 186, '0', 0, 0, 9778.068359375, 966.87152099609375, 1306.5452880859375, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+17, 113771, 1, 141, 186, '0', 0, 0, 9779.3818359375, 871.46527099609375, 1297.429931640625, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+18, 113768, 1, 141, 186, '0', 0, 0, 9779.5009765625, 893.6844482421875, 1297.871337890625, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+19, 113768, 1, 141, 186, '0', 0, 0, 9783.408203125, 890.62677001953125, 1298.6588134765625, 0.174451693892478942, 0, 0, 0.087115287780761718, 0.996198236942291259, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2 +(@OGUID+20, 113771, 1, 141, 186, '0', 0, 0, 9784.2099609375, 969.43035888671875, 1306.0733642578125, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+21, 113771, 1, 141, 186, '0', 0, 0, 9784.5791015625, 934.6805419921875, 1307.6177978515625, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+22, 113771, 1, 141, 186, '0', 0, 0, 9785.072265625, 936.801025390625, 1307.3857421875, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+23, 113771, 1, 141, 186, '0', 0, 0, 9785.58984375, 883.0936279296875, 1298.1529541015625, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+24, 113768, 1, 141, 186, '0', 0, 0, 9786.6318359375, 932.9698486328125, 1307.8604736328125, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+25, 113770, 1, 141, 186, '0', 0, 0, 9790.1455078125, 932.15472412109375, 1308.1011962890625, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+26, 113768, 1, 141, 186, '0', 0, 0, 9794.083984375, 935.43292236328125, 1307.495849609375, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+27, 113769, 1, 141, 186, '0', 0, 0, 9796.9736328125, 926.81097412109375, 1306.8636474609375, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+28, 113770, 1, 141, 186, '0', 0, 0, 9797.20703125, 924.8836669921875, 1306.8704833984375, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2 +(@OGUID+29, 113770, 1, 141, 186, '0', 0, 0, 9799.23046875, 973.43914794921875, 1303.2203369140625, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+30, 113771, 1, 141, 186, '0', 0, 0, 9800.3232421875, 925.2529296875, 1306.9283447265625, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+31, 113770, 1, 141, 186, '0', 0, 0, 9805.1650390625, 933.521728515625, 1307.33935546875, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+32, 113769, 1, 141, 186, '0', 0, 0, 9805.51953125, 932.68402099609375, 1309.300048828125, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+33, 113768, 1, 141, 186, '0', 0, 0, 9809.50390625, 936.32305908203125, 1307.838134765625, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+34, 113771, 1, 141, 186, '0', 0, 0, 9810.8125, 976.96820068359375, 1304.439208984375, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+35, 113771, 1, 141, 186, '0', 0, 0, 9813.13671875, 936.6649169921875, 1308.404052734375, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+36, 113771, 1, 141, 186, '0', 0, 0, 9814.17578125, 938.75042724609375, 1308.3084716796875, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+37, 113770, 1, 141, 186, '0', 0, 0, 9818.826171875, 940.40594482421875, 1308.3074951171875, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+38, 113771, 1, 141, 186, '0', 0, 0, 9823.4326171875, 942.53515625, 1307.0968017578125, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+39, 113770, 1, 141, 186, '0', 0, 0, 9823.7783203125, 920.981689453125, 1304.5885009765625, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2 +(@OGUID+40, 113769, 1, 141, 186, '0', 0, 0, 9826.576171875, 934.53009033203125, 1307.4765625, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+41, 113770, 1, 141, 186, '0', 0, 0, 9828.7158203125, 931.17230224609375, 1306.9986572265625, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+42, 113771, 1, 141, 186, '0', 0, 0, 9830.556640625, 928.17413330078125, 1306.2283935546875, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+43, 113768, 1, 141, 186, '0', 0, 0, 9834.787109375, 977.89044189453125, 1306.5548095703125, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+44, 113771, 1, 141, 186, '0', 0, 0, 9836.7431640625, 947.90997314453125, 1306.714111328125, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+45, 113769, 1, 141, 186, '0', 0, 0, 9837.103515625, 978.41058349609375, 1306.82666015625, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+46, 113770, 1, 141, 186, '0', 0, 0, 9837.5712890625, 944.31512451171875, 1306.8673095703125, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2 +(@OGUID+47, 113770, 1, 141, 186, '0', 0, 0, 9841.9345703125, 978.24652099609375, 1306.6475830078125, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+48, 113771, 1, 141, 186, '0', 0, 0, 9843.0419921875, 949.1944580078125, 1308.7177734375, 2.453766584396362304, 0, 0, 0.941442489624023437, 0.33717358112335205, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+49, 113771, 1, 141, 186, '0', 0, 0, 9848.3505859375, 953.5555419921875, 1307.35595703125, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+50, 113769, 1, 141, 186, '0', 0, 0, 9857.7548828125, 973.2294921875, 1304.809326171875, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+51, 113771, 1, 141, 186, '0', 0, 0, 9858.8876953125, 912.82965087890625, 1306.2568359375, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+52, 113768, 1, 141, 186, '0', 0, 0, 9860.51953125, 912.7969970703125, 1308.530029296875, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+53, 113768, 1, 141, 186, '0', 0, 0, 9860.888671875, 910.63336181640625, 1306.1309814453125, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+54, 113771, 1, 141, 186, '0', 0, 0, 9865.529296875, 996.1749267578125, 1309.404541015625, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+55, 113768, 1, 141, 186, '0', 0, 0, 9870.2900390625, 980.46697998046875, 1309.6800537109375, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+56, 113768, 1, 141, 186, '0', 0, 0, 9875.39453125, 983.86114501953125, 1310.076416015625, 1.269747257232666015, 0, 0, 0.593075752258300781, 0.805146694183349609, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+57, 113769, 1, 141, 186, '0', 0, 0, 9875.76953125, 959.9656982421875, 1308.5509033203125, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+58, 113769, 1, 141, 186, '0', 0, 0, 9876.3095703125, 979.510009765625, 1310.1600341796875, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+59, 113770, 1, 141, 186, '0', 0, 0, 9878.7294921875, 970.015625, 1313.8095703125, 0.698778986930847167, 0, 0, 0.342324256896972656, 0.939581871032714843, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+60, 113771, 1, 141, 186, '0', 0, 0, 9881.388671875, 956.99261474609375, 1308.8040771484375, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+61, 113770, 1, 141, 186, '0', 0, 0, 9882.2900390625, 957.22601318359375, 1311.06005859375, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+62, 113769, 1, 141, 186, '0', 0, 0, 9885.7431640625, 934.13653564453125, 1307.543701171875, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+63, 113770, 1, 141, 186, '0', 0, 0, 9887.40234375, 931.87823486328125, 1307.5709228515625, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject2 +(@OGUID+64, 113771, 1, 141, 186, '0', 0, 0, 9895.0791015625, 964.6641845703125, 1310.525390625, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+65, 415058, 1, 141, 186, '0', 0, 0, 9845.1376953125, 948.84027099609375, 1307.44189453125, 5.601917743682861328, 0, 0, -0.33408451080322265, 0.9425431489944458, 120, 255, 1, 53989), -- Noblegarden Banner - Double Post [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+66, 415060, 1, 141, 186, '0', 0, 0, 9797.9404296875, 972.8663330078125, 1317.5767822265625, 0.035241998732089996, 0, 0, 0.017620086669921875, 0.999844729900360107, 120, 255, 1, 53989), -- Noblegarden Candle - Blue [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+67, 415066, 1, 141, 186, '0', 0, 0, 9894.568359375, 1001.89410400390625, 1318.9034423828125, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Pink [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+68, 415067, 1, 141, 186, '0', 0, 0, 9875.876953125, 982.73614501953125, 1310.109375, 1.042196631431579589, -0.01762866973876953, -0.03814601898193359, 0.496669769287109375, 0.866921722888946533, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+69, 415067, 1, 141, 186, '0', 0, 0, 9876.25390625, 984.34375, 1310.1962890625, 0.52387094497680664, 0.002795696258544921, -0.04127979278564453, 0.25841522216796875, 0.96514749526977539, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+70, 415067, 1, 141, 186, '0', 0, 0, 9873.9189453125, 984.3992919921875, 1309.8153076171875, 0.814745128154754638, -0.02184343338012695, -0.03589916229248046, 0.395082473754882812, 0.917684018611907958, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+71, 415067, 1, 141, 186, '0', 0, 0, 9844.1806640625, 950.52606201171875, 1307.6920166015625, 0.927019894123077392, -0.00329828262329101, -0.03931522369384765, 0.446123123168945312, 0.894101560115814208, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+72, 415067, 1, 141, 186, '0', 0, 0, 9843.3251953125, 949.22222900390625, 1307.6885986328125, 0.590341150760650634, -0.00983858108520507, -0.03820705413818359, 0.290014266967773437, 0.956208705902099609, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+73, 415067, 1, 141, 186, '0', 0, 0, 9843.7314453125, 949.96875, 1308.8697509765625, 0.532653510570526123, -0.01093673706054687, -0.03790760040283203, 0.262316703796386718, 0.964174985885620117, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+74, 415070, 1, 141, 186, '0', 0, 0, 9888.67578125, 992.3836669921875, 1314.773681640625, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+75, 415070, 1, 141, 186, '0', 0, 0, 9796.3955078125, 984.625, 1315.6497802734375, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+76, 415070, 1, 141, 186, '0', 0, 0, 9809.0712890625, 948.859375, 1310.0616455078125, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+77, 415070, 1, 141, 186, '0', 0, 0, 9815.7041015625, 950.86981201171875, 1310.0618896484375, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+78, 415070, 1, 141, 186, '0', 0, 0, 9818.5595703125, 949.00347900390625, 1310.0582275390625, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+79, 415070, 1, 141, 186, '0', 0, 0, 9807.2509765625, 945.435791015625, 1310.0582275390625, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+80, 415073, 1, 141, 186, '0', 0, 0, 9839.1025390625, 965.46356201171875, 1316.9871826171875, 0.311209946870803833, 0, 0, 0.154977798461914062, 0.987917959690093994, 120, 255, 1, 53989), -- Noblegarden Streamers - Large Hanging [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+81, 415073, 1, 141, 186, '0', 0, 0, 9781.31640625, 948.3055419921875, 1316.7449951171875, 0.311209946870803833, 0, 0, 0.154977798461914062, 0.987917959690093994, 120, 255, 1, 53989), -- Noblegarden Streamers - Large Hanging [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+82, 415074, 1, 141, 186, '0', 0, 0, 9878.8388671875, 970.32989501953125, 1313.8115234375, 4.659245491027832031, 0, 0, -0.72564411163330078, 0.688070237636566162, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+83, 415074, 1, 141, 186, '0', 0, 0, 9839.3525390625, 984.50177001953125, 1306.4315185546875, 0.517049789428710937, -0.01195669174194335, 0.121256828308105468, 0.251471519470214843, 0.960164487361907958, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+84, 415074, 1, 141, 186, '0', 0, 0, 9848.1474609375, 953.51214599609375, 1307.3660888671875, 6.133958816528320312, -0.0654296875, 0.034489631652832031, -0.07233810424804687, 0.994633913040161132, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+85, 415074, 1, 141, 186, '0', 0, 0, 9888.607421875, 964.2569580078125, 1313.8111572265625, 3.535813331604003906, 0, 0, -0.9806365966796875, 0.195836395025253295, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+86, 415074, 1, 141, 186, '0', 0, 0, 9783.193359375, 890.53472900390625, 1298.5474853515625, 0.877304732799530029, 0, 0, 0.424719810485839843, 0.905324876308441162, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+87, 415075, 1, 141, 186, '0', 0, 0, 9888.884765625, 975.56427001953125, 1317.4840087890625, 4.197192192077636718, 0, 0, -0.86391735076904296, 0.503633558750152587, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+88, 415075, 1, 141, 186, '0', 0, 0, 9799.7158203125, 990.342041015625, 1311.4119873046875, 1.823575854301452636, 0, 0, 0.790599822998046875, 0.612333178520202636, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+89, 415075, 1, 141, 186, '0', 0, 0, 9813.8564453125, 944.10589599609375, 1312.8170166015625, 1.90288853645324707, 0, 0, 0.8142547607421875, 0.58050769567489624, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Dolanaar - Difficulty: 0) CreateObject1 +(@OGUID+90, 415075, 1, 141, 186, '0', 0, 0, 9775.1708984375, 890.02081298828125, 1301.729736328125, 1.383101701736450195, 0, 0, 0.637732505798339843, 0.770257890224456787, 120, 255, 1, 53989); -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: 0 - Difficulty: 0) CreateObject1 + +DELETE FROM `pool_members` WHERE `type`=1 AND `spawnId` BETWEEN @OGUID+0 AND @OGUID+64; +INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES +(1, @OGUID+0, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+1, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+2, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+3, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+4, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+5, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+6, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+7, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+8, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+9, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+10, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+11, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+12, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+13, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+14, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+15, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+16, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+17, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+18, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+19, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+20, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+21, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+22, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+23, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+24, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+25, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+26, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+27, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+28, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+29, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+30, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+31, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+32, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+33, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+34, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+35, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+36, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+37, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+38, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+39, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+40, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+41, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+42, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+43, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+44, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+45, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+46, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+47, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+48, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+49, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+50, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+51, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+52, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+53, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+54, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+55, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+56, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+57, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+58, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+59, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+60, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+61, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+62, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+63, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+64, @POOL, 0, 'Noblegarden - Brightly Colored Egg'); + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+1; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(@EVENT, @CGUID+0), +(@EVENT, @CGUID+1); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+90; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(@EVENT, @OGUID+65), +(@EVENT, @OGUID+66), +(@EVENT, @OGUID+67), +(@EVENT, @OGUID+68), +(@EVENT, @OGUID+69), +(@EVENT, @OGUID+70), +(@EVENT, @OGUID+71), +(@EVENT, @OGUID+72), +(@EVENT, @OGUID+73), +(@EVENT, @OGUID+74), +(@EVENT, @OGUID+75), +(@EVENT, @OGUID+76), +(@EVENT, @OGUID+77), +(@EVENT, @OGUID+78), +(@EVENT, @OGUID+79), +(@EVENT, @OGUID+80), +(@EVENT, @OGUID+81), +(@EVENT, @OGUID+82), +(@EVENT, @OGUID+83), +(@EVENT, @OGUID+84), +(@EVENT, @OGUID+85), +(@EVENT, @OGUID+86), +(@EVENT, @OGUID+87), +(@EVENT, @OGUID+88), +(@EVENT, @OGUID+89), +(@EVENT, @OGUID+90); |