DB/DunMorogh: Update Noblegarden spawns (Dragonflight)

1 files changed, 218 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_04_07_06_world.sql b/sql/updates/world/master/2024_04_07_06_world.sql
new file mode 100644
index 00000000000..0288b81af64
--- /dev/null
+++ b/sql/updates/world/master/2024_04_07_06_world.sql
@@ -0,0 +1,218 @@
+SET @CGUID := 9800109;
+SET @OGUID := 9804870;
+SET @POOL := 5700;
+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, 0, 1, 131, '0', 0, 0, 0, 0, -5612.5224609375, -510.64410400390625, 402.716400146484375, 1.699380159378051757, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 53989), -- Spring Collector (Area: Kharanos - Difficulty: 0) CreateObject1
+(@CGUID+1, 32836, 0, 1, 131, '0', 0, 0, 0, 1, -5610.8974609375, -510.920135498046875, 401.98736572265625, 1.297245502471923828, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 53989); -- Noblegarden Vendor (Area: Kharanos - Difficulty: 0) CreateObject1
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+95;
+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, 113771, 0, 1, 131, '0', 0, 0, -5675.24853515625, -494.342010498046875, 396.69561767578125, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+1, 113769, 0, 1, 131, '0', 0, 0, -5667.04345703125, -500.7100830078125, 398.63848876953125, 4.779402732849121093, 0, 0, -0.68302154541015625, 0.730398237705230712, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+2, 113770, 0, 1, 131, '0', 0, 0, -5666.783203125, -497.088531494140625, 397.32025146484375, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+3, 113769, 0, 1, 131, '0', 0, 0, -5661.345703125, -505.664947509765625, 397.853363037109375, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+4, 113769, 0, 1, 131, '0', 0, 0, -5660.15625, -475.5625, 396.272552490234375, 5.31696939468383789, 0, 0, -0.46453380584716796, 0.885555386543273925, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+5, 113769, 0, 1, 131, '0', 0, 0, -5655.43994140625, -507.667999267578125, 397.51800537109375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+6, 113771, 0, 1, 131, '0', 0, 0, -5653.78662109375, -501.8819580078125, 397.00970458984375, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+7, 113769, 0, 1, 131, '0', 0, 0, -5651.9462890625, -504.05902099609375, 396.895538330078125, 5.904340744018554687, 0, 0, -0.18829154968261718, 0.982113182544708251, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+8, 113769, 0, 1, 131, '0', 0, 0, -5645.81005859375, -506.29998779296875, 396.864990234375, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+9, 113770, 0, 1, 131, '0', 0, 0, -5641.919921875, -530.1510009765625, 404.553009033203125, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+10, 113771, 0, 1, 131, '0', 0, 0, -5640.06982421875, -511.8599853515625, 398.785003662109375, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+11, 113769, 0, 1, 131, '0', 0, 0, -5639.81982421875, -477.9429931640625, 396.8380126953125, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+12, 113771, 0, 1, 131, '0', 0, 0, -5639, -504.024993896484375, 396.66900634765625, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+13, 113770, 0, 1, 131, '0', 0, 0, -5638.40966796875, -530.44793701171875, 405.016998291015625, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+14, 113769, 0, 1, 131, '0', 0, 0, -5637.740234375, -529.75299072265625, 404.60101318359375, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+15, 113770, 0, 1, 131, '0', 0, 0, -5636.759765625, -501.881011962890625, 396.66900634765625, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+16, 113768, 0, 1, 131, '0', 0, 0, -5634.759765625, -478.43499755859375, 396.985992431640625, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+17, 113771, 0, 1, 131, '0', 0, 0, -5633.7099609375, -500.428009033203125, 396.66900634765625, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+18, 113768, 0, 1, 131, '0', 0, 0, -5631.669921875, -478.305999755859375, 397.141998291015625, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+19, 113770, 0, 1, 131, '0', 0, 0, -5629.68017578125, -477.993011474609375, 397.100006103515625, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+20, 113768, 0, 1, 131, '0', 0, 0, -5628.72021484375, -497.47698974609375, 397.230987548828125, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+21, 113771, 0, 1, 131, '0', 0, 0, -5626.330078125, -478.569000244140625, 396.980010986328125, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+22, 113769, 0, 1, 131, '0', 0, 0, -5625.35009765625, -523.54400634765625, 403.863006591796875, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+23, 113769, 0, 1, 131, '0', 0, 0, -5625.0693359375, -468.670135498046875, 398.58746337890625, 6.2151641845703125, 0, 0, -0.03400421142578125, 0.99942171573638916, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+24, 113770, 0, 1, 131, '0', 0, 0, -5615.9501953125, -446.212005615234375, 404.558990478515625, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+25, 113770, 0, 1, 131, '0', 0, 0, -5614.0498046875, -522.4959716796875, 402.70599365234375, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+26, 113770, 0, 1, 131, '0', 0, 0, -5606.81005859375, -446.06500244140625, 403.97900390625, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+27, 113770, 0, 1, 131, '0', 0, 0, -5598.14404296875, -514.80902099609375, 404.072662353515625, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+28, 113771, 0, 1, 131, '0', 0, 0, -5597.52001953125, -476.048004150390625, 396.980010986328125, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+29, 113770, 0, 1, 131, '0', 0, 0, -5594.56005859375, -460.384002685546875, 402.493011474609375, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+30, 113771, 0, 1, 131, '0', 0, 0, -5592.35009765625, -477.011993408203125, 396.980010986328125, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+31, 113770, 0, 1, 131, '0', 0, 0, -5591.89990234375, -508.066986083984375, 401.45001220703125, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+32, 113771, 0, 1, 131, '0', 0, 0, -5591.83984375, -501.423004150390625, 400.1099853515625, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+33, 113769, 0, 1, 131, '0', 0, 0, -5590.93994140625, -497.847991943359375, 399.436004638671875, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+34, 113769, 0, 1, 131, '0', 0, 0, -5590.85009765625, -507.5050048828125, 404.09600830078125, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+35, 113770, 0, 1, 131, '0', 0, 0, -5589.14990234375, -477.10699462890625, 397.566009521484375, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+36, 113769, 0, 1, 131, '0', 0, 0, -5588.740234375, -514.17401123046875, 404.09600830078125, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+37, 113769, 0, 1, 131, '0', 0, 0, -5588.47021484375, -506.386993408203125, 401.389007568359375, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+38, 113770, 0, 1, 131, '0', 0, 0, -5588.14990234375, -451.483001708984375, 403.20599365234375, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+39, 113771, 0, 1, 131, '0', 0, 0, -5585.18994140625, -461.907989501953125, 402.358001708984375, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+40, 113770, 0, 1, 131, '0', 0, 0, -5584.02978515625, -462.618988037109375, 402.3070068359375, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+41, 113769, 0, 1, 131, '0', 0, 0, -5583.83984375, -476.837005615234375, 397.76300048828125, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+42, 113769, 0, 1, 131, '0', 0, 0, -5578.14990234375, -516.45098876953125, 404.09600830078125, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+43, 113770, 0, 1, 131, '0', 0, 0, -5578.06982421875, -508.540985107421875, 404.09600830078125, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+44, 113769, 0, 1, 131, '0', 0, 0, -5577.18994140625, -521.81402587890625, 401.47698974609375, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+45, 113771, 0, 1, 131, '0', 0, 0, -5574.18994140625, -515.8489990234375, 402.803009033203125, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+46, 113768, 0, 1, 131, '0', 0, 0, -5572.72998046875, -462.92999267578125, 402.26800537109375, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+47, 113770, 0, 1, 131, '0', 0, 0, -5572.02978515625, -457.20599365234375, 403.20599365234375, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+48, 113770, 0, 1, 131, '0', 0, 0, -5570.3701171875, -454.209991455078125, 402.22601318359375, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+49, 113769, 0, 1, 131, '0', 0, 0, -5568.46728515625, -501.154510498046875, 402.826690673828125, 4.251789093017578125, 0, 0, -0.84984874725341796, 0.527026653289794921, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+50, 113770, 0, 1, 131, '0', 0, 0, -5563.830078125, -535.073974609375, 409.95599365234375, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+51, 113770, 0, 1, 131, '0', 0, 0, -5561.3798828125, -454.769012451171875, 403.0260009765625, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+52, 113771, 0, 1, 131, '0', 0, 0, -5561.02978515625, -445.5830078125, 403.800994873046875, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+53, 113769, 0, 1, 131, '0', 0, 0, -5554.669921875, -446.8380126953125, 403.45098876953125, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+54, 113769, 0, 1, 131, '0', 0, 0, -5551.1201171875, -475.1099853515625, 397.944000244140625, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+55, 113769, 0, 1, 131, '0', 0, 0, -5550.990234375, -438.001007080078125, 405.385009765625, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+56, 113770, 0, 1, 131, '0', 0, 0, -5549.990234375, -499.27099609375, 401.70098876953125, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+57, 113770, 0, 1, 131, '0', 0, 0, -5545.60009765625, -497.102996826171875, 402.079010009765625, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+58, 113768, 0, 1, 131, '0', 0, 0, -5545.35986328125, -475.141998291015625, 397.95001220703125, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+59, 113770, 0, 1, 131, '0', 0, 0, -5543.06982421875, -475.489013671875, 397.93798828125, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+60, 113771, 0, 1, 131, '0', 0, 0, -5537.10009765625, -475.811004638671875, 398.22100830078125, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject2
+(@OGUID+61, 113768, 0, 1, 131, '0', 0, 0, -5535.89990234375, -504.5, 401.279998779296875, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+62, 113771, 0, 1, 131, '0', 0, 0, -5531.89990234375, -461.553985595703125, 402.1619873046875, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+63, 415057, 0, 1, 131, '0', 0, 0, -5668.20849609375, -501.791656494140625, 397.546051025390625, 0.717138826847076416, 0, 0, 0.350934982299804687, 0.936399817466735839, 120, 255, 1, 53989), -- Noblegarden Banner - Single Standing [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+64, 415058, 0, 1, 131, '0', 0, 0, -5611.88720703125, -511.611114501953125, 402.068817138671875, 1.60054326057434082, 0.03347015380859375, 0.045039176940917968, 0.716129302978515625, 0.695708274841308593, 120, 255, 1, 53989), -- Noblegarden Banner - Double Post [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+65, 415060, 0, 1, 131, '0', 0, 0, -5592.19091796875, -540.01910400390625, 400.212310791015625, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Blue [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+66, 415066, 0, 1, 131, '0', 0, 0, -5654.68212890625, -502.70660400390625, 398.257568359375, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Pink [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+67, 415066, 0, 1, 131, '0', 0, 0, -5600.75537109375, -524.0069580078125, 400.560516357421875, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Pink [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+68, 415067, 0, 1, 131, '0', 0, 0, -5659.126953125, -476.032989501953125, 396.24139404296875, 0.254914075136184692, 0.016227245330810546, 0.00160980224609375, 0.127102851867675781, 0.991755485534667968, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+69, 415067, 0, 1, 131, '0', 0, 0, -5631.44775390625, -495.74652099609375, 396.817901611328125, 0.149577170610427856, -0.01556158065795898, -0.02778911590576171, 0.074214935302734375, 0.996733546257019042, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+70, 415067, 0, 1, 131, '0', 0, 0, -5625.9443359375, -468.942718505859375, 398.61944580078125, 0.184974342584609985, 0.022572040557861328, -0.01748943328857421, 0.092722892761230468, 0.995282411575317382, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+71, 415067, 0, 1, 131, '0', 0, 0, -5659.9150390625, -476.395843505859375, 397.404449462890625, 0.229649469256401062, 0.016246318817138671, 0.001404762268066406, 0.114564895629882812, 0.993281900882720947, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+72, 415067, 0, 1, 131, '0', 0, 0, -5626.5849609375, -468.890625, 397.433197021484375, 0.611260890960693359, 0.01778411865234375, -0.00109577178955078, 0.300948143005371093, 0.953474044799804687, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+73, 415067, 0, 1, 131, '0', 0, 0, -5624.99658203125, -468.854156494140625, 397.490081787109375, 0.220926195383071899, 0.02821207046508789, -0.00846290588378906, 0.110501289367675781, 0.993439435958862304, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+74, 415067, 0, 1, 131, '0', 0, 0, -5667.017578125, -500.532989501953125, 397.563629150390625, 0.227094054222106933, 0, 0, 0.113303184509277343, 0.993560492992401123, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+75, 415067, 0, 1, 131, '0', 0, 0, -5660.52099609375, -476.55035400390625, 396.227691650390625, 0.043737299740314483, 0.016306877136230468, -0.0001077651977539, 0.021871566772460937, 0.999627768993377685, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+76, 415070, 0, 1, 131, '0', 0, 0, -5641.6025390625, -528.8350830078125, 404.921783447265625, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+77, 415070, 0, 1, 131, '0', 0, 0, -5636.28466796875, -500.6632080078125, 398.860748291015625, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+78, 415070, 0, 1, 131, '0', 0, 0, -5584.625, -532.9757080078125, 404.42047119140625, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+79, 415070, 0, 1, 131, '0', 0, 0, -5586.7275390625, -528.25, 400.222381591796875, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+80, 415070, 0, 1, 131, '0', 0, 0, -5605.65966796875, -532.55035400390625, 400.522613525390625, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+81, 415070, 0, 1, 131, '0', 0, 0, -5584.5380859375, -528.48089599609375, 401.6427001953125, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+82, 415071, 0, 1, 131, '0', 0, 0, -5572.9931640625, -460.9913330078125, 407.1519775390625, 1.693253993988037109, -0.00877666473388671, 0.013727188110351562, 0.748904228210449218, 0.66247791051864624, 120, 255, 1, 53989), -- Noblegarden Ribbon 0.13 [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+83, 415071, 0, 1, 131, '0', 0, 0, -5585.296875, -460.967010498046875, 407.094635009765625, 1.403016448020935058, 0, 0, 0.6453704833984375, 0.763869702816009521, 120, 255, 1, 53989), -- Noblegarden Ribbon 0.13 [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+84, 415072, 0, 1, 131, '0', 0, 0, -5597.453125, -531.8680419921875, 403.586822509765625, 1.555495142936706542, 0, 0, 0.701676368713378906, 0.712495803833007812, 120, 255, 1, 53989), -- Noblegarden Streamers - Small Hanging [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+85, 415073, 0, 1, 131, '0', 0, 0, -5579.41650390625, -461.946197509765625, 410.535736083984375, 1.573351740837097167, 0, 0, 0.708009719848632812, 0.706202685832977294, 120, 255, 1, 53989), -- Noblegarden Streamers - Large Hanging [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+86, 415074, 0, 1, 131, '0', 0, 0, -5643.314453125, -503.404510498046875, 396.686431884765625, 1.542473077774047851, 0, 0, 0.697022438049316406, 0.717049300670623779, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+87, 415074, 0, 1, 131, '0', 0, 0, -5568.5087890625, -501.555572509765625, 402.875457763671875, 1.335180401802062988, -0.0636916160583496, 0.017416000366210937, 0.619382858276367187, 0.782307446002960205, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+88, 415074, 0, 1, 131, '0', 0, 0, -5605.55908203125, -489.869781494140625, 397.585784912109375, 1.798869848251342773, -0.07820320129394531, 0.058689117431640625, 0.779388427734375, 0.618864715099334716, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+89, 415075, 0, 1, 131, '0', 0, 0, -5593.0244140625, -489.333343505859375, 398.49273681640625, 1.617055416107177734, -0.00505018234252929, 0.002595901489257812, 0.723265647888183593, 0.690546572208404541, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+90, 415075, 0, 1, 131, '0', 0, 0, -5608.63720703125, -529.70489501953125, 401.268035888671875, 6.261324405670166015, -0.00154972076416015, 0.005462646484375, -0.01092147827148437, 0.999924242496490478, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+91, 415075, 0, 1, 131, '0', 0, 0, -5592.1875, -532.4444580078125, 403.868560791015625, 1.529445886611938476, -0.00493144989013671, 0.002814292907714843, 0.692332267761230468, 0.721556484699249267, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+92, 415075, 0, 1, 131, '0', 0, 0, -5607.88916015625, -525.56427001953125, 403.31060791015625, 6.20969247817993164, -0.00140857696533203, 0.00550079345703125, -0.0367288589477539, 0.999309122562408447, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+93, 415075, 0, 1, 131, '0', 0, 0, -5608.4775390625, -522.03302001953125, 401.218109130859375, 6.261324405670166015, -0.00154972076416015, 0.005462646484375, -0.01092147827148437, 0.999924242496490478, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+94, 415075, 0, 1, 131, '0', 0, 0, -5590.78662109375, -514.046875, 406.447174072265625, 1.628377795219421386, -0.00506448745727539, 0.002567291259765625, 0.727163314819335937, 0.686441004276275634, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+(@OGUID+95, 415075, 0, 1, 131, '0', 0, 0, -5579.82666015625, -525.4774169921875, 403.96826171875, 3.159708023071289062, 0.00543069839477539, 0.001658439636230468, -0.99994277954101562, 0.009066134691238403, 120, 255, 1, 53989); -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Kharanos - Difficulty: 0) CreateObject1
+
+DELETE FROM `pool_members` WHERE `type`=1 AND `spawnId` BETWEEN @OGUID+0 AND @OGUID+62;
+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');
+
+-- 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+95;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(@EVENT, @OGUID+63),
+(@EVENT, @OGUID+64),
+(@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),
+(@EVENT, @OGUID+91),
+(@EVENT, @OGUID+92),
+(@EVENT, @OGUID+93),
+(@EVENT, @OGUID+94),
+(@EVENT, @OGUID+95);