DB/Valdrakken: Added Noblegarden spawns

1 files changed, 347 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_04_07_09_world.sql b/sql/updates/world/master/2024_04_07_09_world.sql
new file mode 100644
index 00000000000..2b19efd605e
--- /dev/null
+++ b/sql/updates/world/master/2024_04_07_09_world.sql
@@ -0,0 +1,347 @@
+SET @CGUID := 9800111;
+SET @OGUID := 9804966;
+SET @POOL := 5707;
+SET @EVENT := 9;
+
+-- Creature templates
+UPDATE `creature_template` SET `faction`=3276, `npcflag`=2, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048 WHERE `entry`=199261; -- Holiday Enthusiast
+UPDATE `creature_template` SET `faction`=35, `npcflag`=2, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=215033; -- Spring Sorter
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (199261, 215033);
+INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(199261, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 199261 (Holiday Enthusiast)
+(215033, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- 215033 (Spring Sorter)
+
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=53989 WHERE (`Entry`=199261 AND `DifficultyID`=0); -- Holiday Enthusiast
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=390, `StaticFlags1`=268435456, `VerifiedBuild`=53989 WHERE (`Entry`=215033 AND `DifficultyID`=0); -- Spring Sorter
+
+DELETE FROM `creature_model_info` WHERE `DisplayID` IN (117262, 116537, 116389, 116366, 104329, 115766, 107227, 114495, 116905, 113669, 111430, 111010, 110997, 110604, 116648, 113621);
+INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES
+(117262, 3.736554384231567382, 3.599999904632568359, 0, 53989),
+(116537, 0.305999994277954101, 1.5, 0, 53989),
+(116389, 0.208165675401687622, 0, 0, 53989),
+(116366, 0.208000004291534423, 1.5, 0, 53989),
+(104329, 1.132115364074707031, 1.5, 0, 53989),
+(115766, 1.755318164825439453, 3, 0, 53989),
+(107227, 0.384812593460083007, 1.5, 0, 53989),
+(114495, 0.354500472545623779, 0, 0, 53989),
+(116905, 0.208000004291534423, 1.5, 0, 53989),
+(113669, 0.305999994277954101, 1.5, 0, 53989),
+(111430, 0.722000002861022949, 2, 0, 53989),
+(111010, 0.305999994277954101, 1.5, 0, 53989),
+(110997, 0.208000004291534423, 1.5, 0, 53989),
+(110604, 0.722000002861022949, 2, 0, 53989),
+(116648, 20.98719215393066406, 17.20000076293945312, 0, 53989),
+(113621, 0.545473396778106689, 0.818644046783447265, 0, 53989);
+
+-- Quests
+DELETE FROM `quest_template` WHERE `ID` IN (79134, 79136);
+INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestPackageID`, `ContentTuningID`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `FlagsEx2`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitGiverMount`, `PortraitGiverModelSceneID`, `PortraitTurnIn`, `RewardItem1`, `RewardItem2`, `RewardItem3`, `RewardItem4`, `RewardAmount1`, `RewardAmount2`, `RewardAmount3`, `RewardAmount4`, `ItemDrop1`, `ItemDrop2`, `ItemDrop3`, `ItemDrop4`, `ItemDropQuantity1`, `ItemDropQuantity2`, `ItemDropQuantity3`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemID2`, `RewardChoiceItemID3`, `RewardChoiceItemID4`, `RewardChoiceItemID5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity1`, `RewardChoiceItemQuantity2`, `RewardChoiceItemQuantity3`, `RewardChoiceItemQuantity4`, `RewardChoiceItemQuantity5`, `RewardChoiceItemQuantity6`, `RewardChoiceItemDisplayID1`, `RewardChoiceItemDisplayID2`, `RewardChoiceItemDisplayID3`, `RewardChoiceItemDisplayID4`, `RewardChoiceItemDisplayID5`, `RewardChoiceItemDisplayID6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionID2`, `RewardFactionID3`, `RewardFactionID4`, `RewardFactionID5`, `RewardFactionValue1`, `RewardFactionValue2`, `RewardFactionValue3`, `RewardFactionValue4`, `RewardFactionValue5`, `RewardFactionCapIn1`, `RewardFactionCapIn2`, `RewardFactionCapIn3`, `RewardFactionCapIn4`, `RewardFactionCapIn5`, `RewardFactionOverride1`, `RewardFactionOverride2`, `RewardFactionOverride3`, `RewardFactionOverride4`, `RewardFactionOverride5`, `RewardFactionFlags`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `TreasurePickerID`, `Expansion`, `ManagedWorldStateID`, `QuestSessionBonus`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES
+(79134, 2, 0, 390, -374, 0, 0, 78274, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 36700168, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 6130900294268439629, 2596, 9, 0, 0, 'A Spring Awakening', 'Speak with Zinnia Brooks at Goldshire in Elwynn Forest.', 'The citizens of Goldshire have reported frequent interruptions to their recent festivities. Something about being overrun by angry... ducks? Perhaps you could look further into this conundrum.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 53989), -- A Spring Awakening
+(79136, 2, 0, 390, -374, 0, 0, 79135, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 36700168, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 12261800583900083122, 2596, 9, 0, 0, 'A Spring Awakening', 'Talk to Sylnaria Fareflame in Razor Hill.', 'The citizens of Razor Hill have reported frequent interruptions to their recent festivities due to a duck infestation, of all things. Perhaps you could look further into this conundrum.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 53989); -- A Spring Awakening
+
+DELETE FROM `quest_poi` WHERE (`QuestID` IN (79134,79136) AND `BlobIndex`=0 AND `Idx1`=0);
+INSERT INTO `quest_poi` (`QuestID`, `BlobIndex`, `Idx1`, `ObjectiveIndex`, `QuestObjectiveID`, `QuestObjectID`, `MapID`, `UiMapID`, `Priority`, `Flags`, `WorldEffectID`, `PlayerConditionID`, `NavigationPlayerConditionID`, `SpawnTrackingID`, `AlwaysAllowMergingBlobs`, `VerifiedBuild`) VALUES
+(79134, 0, 0, -1, 0, 0, 0, 37, 0, 0, 0, 0, 0, 2424752, 0, 53989), -- A Spring Awakening
+(79136, 0, 0, -1, 0, 0, 1, 1, 0, 0, 0, 0, 0, 2444695, 0, 53989); -- A Spring Awakening
+
+UPDATE `quest_poi` SET `VerifiedBuild`=53989 WHERE (`QuestID`=65435 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=65435 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=54759 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=54759 AND `BlobIndex`=0 AND `Idx1`=0);
+DELETE FROM `quest_poi_points` WHERE (`QuestID` IN (79134,79136) AND `Idx1`=0 AND `Idx2`=0);
+INSERT INTO `quest_poi_points` (`QuestID`, `Idx1`, `Idx2`, `X`, `Y`, `Z`, `VerifiedBuild`) VALUES
+(79134, 0, 0, -9445, 76, 57, 53989), -- A Spring Awakening
+(79136, 0, 0, 357, -4743, 10, 53989); -- A Spring Awakening
+
+DELETE FROM `quest_greeting` WHERE (`ID` IN (211646,215033,217125) AND `Type`=0);
+INSERT INTO `quest_greeting` (`ID`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES
+(211646, 0, 0, 0, 'Isn''t it a beautiful time of year?', 53989), -- 211646
+(215033, 0, 0, 0, 'Isn''t it beautiful this time of year?', 53989), -- 215033
+(217125, 0, 0, 0, 'Isn''t it a beautiful time of year?', 53989); -- 217125
+
+DELETE FROM `quest_details` WHERE `ID` IN (79134, 79136);
+INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES
+(79134, 1, 0, 0, 0, 0, 0, 0, 0, 53989), -- A Spring Awakening
+(79136, 1, 0, 0, 0, 0, 0, 0, 0, 53989); -- A Spring Awakening
+
+DELETE FROM `quest_offer_reward` WHERE `ID` IN (79134, 79136);
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(79134, 1, 0, 0, 0, 0, 0, 0, 0, 'Yes! Yes, I think I have just the task for you...', 53989), -- A Spring Awakening
+(79136, 1, 0, 0, 0, 0, 0, 0, 0, 'Yes! Yes, I think I have just the task for you...', 53989); -- A Spring Awakening
+
+DELETE FROM `creature_queststarter` WHERE (`id`=215033 AND `quest` IN (13479,13503)) OR (`id`=199261 AND `quest` IN (79134,79136));
+INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(215033, 13479, 53989), -- The Great Egg Hunt offered by Spring Sorter
+(215033, 13503, 53989), -- A Tisket, a Tasket, a Noblegarden Basket offered by Spring Sorter
+(199261, 79134, 53989), -- A Spring Awakening offered by Holiday Enthusiast
+(199261, 79136, 53989); -- A Spring Awakening offered by Holiday Enthusiast
+
+DELETE FROM `creature_questender` WHERE (`id`=215033 AND `quest` IN (13503,13479));
+DELETE FROM `creature_questender` WHERE (`id`=211646 AND `quest`=79134);
+DELETE FROM `creature_questender` WHERE (`id`=217125 AND `quest`=79136);
+INSERT INTO `creature_questender` (`id`, `quest`, `VerifiedBuild`) VALUES
+(215033, 13503, 53989), -- A Tisket, a Tasket, a Noblegarden Basket ended by Spring Sorter
+(215033, 13479, 53989), -- The Great Egg Hunt ended by Spring Sorter
+(211646, 79134, 53989), -- A Spring Awakening ended by Zinnia Brooks
+(217125, 79136, 53989); -- A Spring Awakening ended by Sylnaria Fareflame
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry` IN (79134,79136);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(19, 0, 79134, 0, 0, 12, 0, 9, 0, 0, '', 0, 0, 0, '', 'Show quest 79134 only if event "Noblegarden" is active'),
+(19, 0, 79136, 0, 0, 12, 0, 9, 0, 0, '', 0, 0, 0, '', 'Show quest 79136 only if event "Noblegarden" is active');
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+0;
+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, 215033, 2444, 13862, 13862, '0', 0, 0, 0, 0, 63.7430572509765625, -987.3194580078125, 837.7484130859375, 1.005072712898254394, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 53989); -- Spring Sorter (Area: Valdrakken - Difficulty: 0) CreateObject1
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+114;
+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, 2444, 13862, 0, '0', 0, 0, -16.7204856872558593, -837.25347900390625, 840.15283203125, 0.207295060157775878, 0.389369964599609375, 0.271696090698242187, -0.01844406127929687, 0.879904568195343017, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+1, 113769, 2444, 13862, 13862, '0', 0, 0, 7.713541507720947265, -883.13543701171875, 838.97735595703125, 5.819158554077148437, 0, 0, -0.22993755340576171, 0.973205387592315673, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+2, 113770, 2444, 13862, 13862, '0', 0, 0, 24.86458396911621093, -991.8819580078125, 838.7984619140625, 0.543560206890106201, 0.033314704895019531, -0.27843666076660156, 0.245789527893066406, 0.927874267101287841, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+3, 113768, 2444, 13862, 0, '0', 0, 0, 26.69270896911621093, -977.14581298828125, 836.0587158203125, 5.804564952850341796, -0.03101062774658203, -0.26867866516113281, -0.21909904479980468, 0.937467694282531738, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+4, 113770, 2444, 13862, 0, '0', 0, 0, 27.86111068725585937, -903.435791015625, 834.39434814453125, 4.084720611572265625, 0.028797626495361328, 0.014321327209472656, -0.89040279388427734, 0.454035788774490356, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2
+(@OGUID+5, 113771, 2444, 13862, 0, '0', 0, 0, 33.62326431274414062, -922.89410400390625, 841.07958984375, 3.668955802917480468, -0.27869749069213867, -0.03105831146240234, -0.92983436584472656, 0.238266989588737487, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+6, 113768, 2444, 13862, 13862, '0', 0, 0, 34.62326431274414062, -864.58160400390625, 838.1739501953125, 3.514240264892578125, -0.28026437759399414, -0.00942707061767578, -0.94546699523925781, 0.16569596529006958, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+7, 113769, 2444, 13862, 13862, '0', 0, 0, 35.17534637451171875, -931.7569580078125, 837.92437744140625, 3.383446216583251953, 0.033954143524169921, -0.00257492065429687, -0.99214839935302734, 0.120341517031192779, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+8, 113770, 2444, 13862, 0, '0', 0, 0, 44.71354293823242187, -945.19793701171875, 836.79443359375, 5.913544178009033203, 0, 0, -0.18377017974853515, 0.982969224452972412, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2
+(@OGUID+9, 113770, 2444, 13862, 14489, '0', 0, 0, 52.29513931274414062, -987.08856201171875, 840.397705078125, 0.501820802688598632, 0.068746566772460937, 0.024851799011230468, 0.247126579284667968, 0.966221868991851806, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: The Seat of the Aspects - Difficulty: 0) CreateObject1
+(@OGUID+10, 113770, 2444, 13862, 13862, '0', 0, 0, 58.47222137451171875, -807.20831298828125, 843.900390625, 0.207295060157775878, 0.389369964599609375, 0.271696090698242187, -0.01844406127929687, 0.879904568195343017, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+11, 113770, 2444, 13862, 13862, '0', 0, 0, 58.63541793823242187, -917.38018798828125, 836.58251953125, 2.163239240646362304, 0, 0, 0.882719993591308593, 0.469899356365203857, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+12, 113769, 2444, 13862, 14489, '0', 0, 0, 61.97916793823242187, -990.46356201171875, 838.140869140625, 0.718110501766204833, 0, 0, 0.351389884948730468, 0.936229228973388671, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: The Seat of the Aspects - Difficulty: 0) CreateObject1
+(@OGUID+13, 113770, 2444, 13862, 13862, '0', 0, 0, 63.63541793823242187, -929.97918701171875, 836.58587646484375, 3.61611485481262207, 0.250940799713134765, 0.173117637634277343, -0.91749000549316406, 0.255482047796249389, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+14, 113768, 2444, 13862, 14489, '0', 0, 0, 66.21875, -868.0711669921875, 840.33624267578125, 0.692702472209930419, 0, 0, 0.339468002319335937, 0.940617561340332031, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: The Seat of the Aspects - Difficulty: 0) CreateObject1
+(@OGUID+15, 113769, 2444, 13862, 0, '0', 0, 0, 68.67534637451171875, -992.09552001953125, 837.3919677734375, 5.182238578796386718, -0.02373170852661132, 0.328441619873046875, -0.44664764404296875, 0.831906735897064208, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2
+(@OGUID+16, 113770, 2444, 13862, 13862, '0', 0, 0, 74.609375, -850.6180419921875, 841.2037353515625, 0.392070144414901733, 0.26264810562133789, 0.100202560424804687, 0.173559188842773437, 0.943849921226501464, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+17, 113768, 2444, 13862, 13862, '0', 0, 0, 77.95659637451171875, -928.84375, 839.3203125, 4.291027545928955078, 0.483234882354736328, -0.40095233917236328, -0.72144603729248046, 0.291953593492507934, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+18, 113768, 2444, 13862, 13862, '0', 0, 0, 81.60590362548828125, -943.109375, 836.5052490234375, 6.232175827026367187, 0.00114297866821289, 0.032141685485839843, -0.02549934387207031, 0.999157369136810302, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+19, 113768, 2444, 13862, 0, '0', 0, 0, 81.90277862548828125, -916.96527099609375, 839.0283203125, 0.239789932966232299, 0, 0, 0.119607925415039062, 0.992821216583251953, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2
+(@OGUID+20, 113771, 2444, 13862, 14489, '0', 0, 0, 87.76909637451171875, -930.89239501953125, 837.18585205078125, 0.718110501766204833, 0, 0, 0.351389884948730468, 0.936229228973388671, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: The Seat of the Aspects - Difficulty: 0) CreateObject1
+(@OGUID+21, 113771, 2444, 13862, 13862, '0', 0, 0, 90.18576812744140625, -916.6944580078125, 845.0380859375, 0.692702472209930419, 0, 0, 0.339468002319335937, 0.940617561340332031, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+22, 113768, 2444, 13862, 0, '0', 0, 0, 92.454864501953125, -924.02777099609375, 839.18780517578125, 5.063467979431152343, 0.358398914337158203, 0.203983306884765625, -0.57962322235107421, 0.702835679054260253, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2
+(@OGUID+23, 113769, 2444, 13862, 0, '0', 0, 0, 94.71353912353515625, -906.59552001953125, 837.3565673828125, 0.718110501766204833, 0, 0, 0.351389884948730468, 0.936229228973388671, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2
+(@OGUID+24, 113771, 2444, 13862, 0, '0', 0, 0, 95.22916412353515625, -831.4617919921875, 841.63916015625, 1.114711642265319824, 0.225320339202880859, 0.288501739501953125, 0.452166557312011718, 0.813352882862091064, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2
+(@OGUID+25, 113771, 2444, 13862, 13862, '0', 0, 0, 95.736114501953125, -894.060791015625, 836.64862060546875, 3.514240264892578125, -0.28026437759399414, -0.00942707061767578, -0.94546699523925781, 0.16569596529006958, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+26, 113770, 2444, 13862, 13862, '0', 0, 0, 98.83853912353515625, -856.76739501953125, 839.83111572265625, 5.680533885955810546, -0.04760265350341796, -0.26624011993408203, -0.27677822113037109, 0.922086775302886962, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+27, 113770, 2444, 13862, 0, '0', 0, 0, 105.166656494140625, -978.50347900390625, 838.386474609375, 5.819158554077148437, 0, 0, -0.22993755340576171, 0.973205387592315673, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2
+(@OGUID+28, 113771, 2444, 13862, 0, '0', 0, 0, 106.8836822509765625, -970.857666015625, 836.89715576171875, 5.913938045501708984, 0, 0, -0.18357658386230468, 0.983005404472351074, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+29, 113768, 2444, 13862, 0, '0', 0, 0, 107.875, -860.875, 839.04339599609375, 0.692702472209930419, 0, 0, 0.339468002319335937, 0.940617561340332031, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2
+(@OGUID+30, 113768, 2444, 13862, 0, '0', 0, 0, 110.4756927490234375, -996.4288330078125, 838.1953125, 6.232175827026367187, 0.00114297866821289, 0.032141685485839843, -0.02549934387207031, 0.999157369136810302, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+31, 113771, 2444, 13862, 13862, '0', 0, 0, 137.4375, -991.9774169921875, 845.58428955078125, 5.308331966400146484, 0.330804347991943359, 0.246227264404296875, -0.48944950103759765, 0.768361806869506835, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+32, 113769, 2444, 13862, 13862, '0', 0, 0, 141.4184112548828125, -931.02606201171875, 840.3699951171875, 1.39609384536743164, 0.145460128784179687, -0.23974609375, 0.607447624206542968, 0.743216335773468017, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+33, 113771, 2444, 13862, 13862, '0', 0, 0, 143.359375, -937.4757080078125, 838.15753173828125, 0.414500027894973754, 0, 0, 0.205769538879394531, 0.978600502014160156, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+34, 113769, 2444, 13862, 0, '0', 0, 0, 148.232635498046875, -987.90625, 859.09478759765625, 0.684720873832702636, 0, 0, 0.335711479187011718, 0.94196486473083496, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+35, 113769, 2444, 13862, 0, '0', 0, 0, 148.4461822509765625, -869.25177001953125, 839.57891845703125, 1.892361164093017578, 0.062030315399169921, -0.32458972930908203, 0.7303314208984375, 0.597837567329406738, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+36, 113769, 2444, 13862, 0, '0', 0, 0, 150.51910400390625, -875.5625, 839.60369873046875, 0.718110501766204833, 0, 0, 0.351389884948730468, 0.936229228973388671, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+37, 113771, 2444, 13862, 0, '0', 0, 0, 153.5850677490234375, -897.65625, 840.38043212890625, 4.095988273620605468, 0.412148475646972656, 0.013890266418457031, -0.84000205993652343, 0.352614790201187133, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+38, 113771, 2444, 13862, 14489, '0', 0, 0, 165.3975677490234375, -924.44097900390625, 842.40216064453125, 6.114505767822265625, 0, 0, -0.08423995971679687, 0.996445536613464355, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: The Seat of the Aspects - Difficulty: 0) CreateObject2
+(@OGUID+39, 113771, 2444, 13862, 0, '0', 0, 0, 166.5590362548828125, -947.02606201171875, 842.65863037109375, 0.471867799758911132, 0.255458831787109375, 0.348034858703613281, 0.109780311584472656, 0.895299315452575683, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+40, 113769, 2444, 13862, 13862, '0', 0, 0, 170.6371612548828125, -957.36285400390625, 859.2047119140625, 0.034917011857032775, 0.170427799224853515, 0.375517845153808593, -0.05671882629394531, 0.909243464469909667, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+41, 113770, 2444, 13862, 0, '0', 0, 0, 174.3038177490234375, -940.7274169921875, 844.1318359375, 5.913938045501708984, 0, 0, -0.18357658386230468, 0.983005404472351074, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+42, 113770, 2444, 13862, 0, '0', 0, 0, 179.78125, -921.47222900390625, 842.76947021484375, 1.157083034515380859, 0.556319236755371093, 0.424533843994140625, 0.347611427307128906, 0.624056220054626464, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: 0 - Difficulty: 0) CreateObject2
+(@OGUID+43, 113768, 2444, 13862, 13862, '0', 0, 0, 182.4635467529296875, -952.28643798828125, 858.03277587890625, 2.051968097686767578, 0, 0, 0.855224609375, 0.518257558345794677, 300, 255, 1, 53989), -- Brightly Colored Egg (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+44, 415057, 2444, 13862, 13862, '0', 0, 0, 107.0850677490234375, -861.060791015625, 838.94610595703125, 4.730592727661132812, 0, 0, -0.70064163208007812, 0.713513314723968505, 120, 255, 1, 53989), -- Noblegarden Banner - Single Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+45, 415057, 2444, 13862, 13862, '0', 0, 0, 187.6475677490234375, -1015.86798095703125, 872.58489990234375, 1.8302154541015625, 0, 0, 0.792628288269042968, 0.609705150127410888, 120, 255, 1, 53989), -- Noblegarden Banner - Single Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+46, 415057, 2444, 13862, 13862, '0', 0, 0, -8.98958301544189453, -863.01910400390625, 837.02545166015625, 0.476779729127883911, 0, 0, 0.236138343811035156, 0.971719443798065185, 120, 255, 1, 53989), -- Noblegarden Banner - Single Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+47, 415057, 2444, 13862, 13862, '0', 0, 0, 6.875, -842.609375, 837.02691650390625, 4.730592727661132812, 0, 0, -0.70064163208007812, 0.713513314723968505, 120, 255, 1, 53989), -- Noblegarden Banner - Single Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+48, 415057, 2444, 13862, 13862, '0', 0, 0, 30.76909828186035156, -978.95660400390625, 836.13177490234375, 0.916820406913757324, 0, 0, 0.442523002624511718, 0.896757185459136962, 120, 255, 1, 53989), -- Noblegarden Banner - Single Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+49, 415057, 2444, 13862, 13862, '0', 0, 0, 209.70660400390625, -983.59027099609375, 872.58489990234375, 3.061485767364501953, 0, 0, 0.999197959899902343, 0.040042784065008163, 120, 255, 1, 53989), -- Noblegarden Banner - Single Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+50, 415058, 2444, 13862, 13862, '0', 0, 0, 63.53819656372070312, -989.26739501953125, 837.5921630859375, 0.792685747146606445, 0.0162811279296875, 0.021816253662109375, 0.3856048583984375, 0.922262370586395263, 120, 255, 1, 53989), -- Noblegarden Banner - Double Post [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+51, 415060, 2444, 13862, 13862, '0', 0, 0, 211.845489501953125, -873.26739501953125, 844.5369873046875, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Blue [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+52, 415060, 2444, 13862, 13862, '0', 0, 0, 209.94097900390625, -888.56768798828125, 844.6649169921875, 2.102109432220458984, 0, 0, 0.867947578430175781, 0.496655851602554321, 120, 255, 1, 53989), -- Noblegarden Candle - Blue [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+53, 415060, 2444, 13862, 13862, '0', 0, 0, 208.4305572509765625, -891.69268798828125, 848.6826171875, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Blue [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+54, 415066, 2444, 13862, 13862, '0', 0, 0, 210.80035400390625, -888.1336669921875, 844.65948486328125, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Pink [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+55, 415066, 2444, 13862, 13862, '0', 0, 0, 210.7395782470703125, -888.73956298828125, 846.5166015625, 2.590077877044677734, 0, 0, 0.96221923828125, 0.272275805473327636, 120, 255, 1, 53989), -- Noblegarden Candle - Pink [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+56, 415066, 2444, 13862, 13862, '0', 0, 0, 180.6770782470703125, -873.20489501953125, 844.36395263671875, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Pink [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+57, 415066, 2444, 13862, 0, '0', 0, 0, 280.083343505859375, -1003.486083984375, 872.40350341796875, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Pink [DNT] (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+58, 415067, 2444, 13862, 13862, '0', 0, 0, -6.18576383590698242, -867.01214599609375, 836.96173095703125, 5.568370342254638671, 0, 0, -0.34984683990478515, 0.936806917190551757, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+59, 415067, 2444, 13862, 13862, '0', 0, 0, 149.8524322509765625, -876.25518798828125, 839.5826416015625, 0.475139081478118896, 0.062619686126708984, 0.031441688537597656, 0.233710289001464843, 0.969778180122375488, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+60, 415067, 2444, 13862, 13862, '0', 0, 0, 63.23784637451171875, -990.513916015625, 838.06610107421875, 5.567256450653076171, 0, 0, -0.35036849975585937, 0.936611950397491455, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+61, 415067, 2444, 13862, 13862, '0', 0, 0, 149.654510498046875, -874.6875, 839.74786376953125, 0.197665378451347351, 0.048303127288818359, 0.038861274719238281, 0.096727371215820312, 0.993378281593322753, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+62, 415067, 2444, 13862, 13862, '0', 0, 0, 87.23090362548828125, -931.71356201171875, 837.22442626953125, 5.919732570648193359, 0, 0, -0.18072795867919921, 0.983533143997192382, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+63, 415067, 2444, 13862, 13862, '0', 0, 0, -7.10590267181396484, -865.607666015625, 836.94268798828125, 5.249133586883544921, 0, 0, -0.49429702758789062, 0.869293034076690673, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+64, 415067, 2444, 13862, 13862, '0', 0, 0, 31.05034828186035156, -852.5069580078125, 836.9366455078125, 5.887559413909912109, 0, 0, -0.19652557373046875, 0.980498671531677246, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+65, 415067, 2444, 13862, 13862, '0', 0, 0, 31.21354103088378906, -899.5, 834.27703857421875, 5.796253204345703125, 0, 0, -0.24106788635253906, 0.970508277416229248, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+66, 415067, 2444, 13862, 13862, '0', 0, 0, 62.07291793823242187, -989.52081298828125, 838.10955810546875, 5.969395637512207031, 0, 0, -0.15625190734863281, 0.987717211246490478, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+67, 415067, 2444, 13862, 13862, '0', 0, 0, 175.3836822509765625, -940.12152099609375, 844.21270751953125, 0.466730117797851562, 0, 0, 0.231252670288085937, 0.972893714904785156, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+68, 415067, 2444, 13862, 13862, '0', 0, 0, 149.986114501953125, -876.13714599609375, 840.738525390625, 0.948345899581909179, 0.064003467559814453, 0.027177810668945312, 0.455809593200683593, 0.887357056140899658, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+69, 415067, 2444, 13862, 13862, '0', 0, 0, 175.4947967529296875, -939.640625, 843.06658935546875, 0.8466835618019104, 0, 0, 0.410809516906738281, 0.91172116994857788, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+70, 415067, 2444, 13862, 13862, '0', 0, 0, -6.96354150772094726, -866.52606201171875, 838.10577392578125, 5.090242862701416015, 0, 0, -0.56172657012939453, 0.827322959899902343, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+71, 415067, 2444, 13862, 13862, '0', 0, 0, 88.82639312744140625, -931.27606201171875, 837.23321533203125, 6.200795173645019531, 0, 0, -0.0411834716796875, 0.999151587486267089, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+72, 415067, 2444, 13862, 13862, '0', 0, 0, 62.84722137451171875, -990.27777099609375, 839.21484375, 5.919732570648193359, 0, 0, -0.18072795867919921, 0.983533143997192382, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+73, 415067, 2444, 13862, 13862, '0', 0, 0, 29.46180534362792968, -852.279541015625, 836.90423583984375, 5.568370342254638671, 0, 0, -0.34984683990478515, 0.936806917190551757, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+74, 415067, 2444, 13862, 13862, '0', 0, 0, 174.40625, -940.7586669921875, 843.06500244140625, 0.245089292526245117, 0, 0, 0.1222381591796875, 0.992500782012939453, 120, 255, 1, 53989), -- Noblegarden Crate - Closed [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+75, 415070, 2444, 13862, 13862, '0', 0, 0, 185.390625, -885.123291015625, 844.23516845703125, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+76, 415070, 2444, 13862, 13862, '0', 0, 0, 61.47569656372070312, -821.51214599609375, 846.96368408203125, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+77, 415070, 2444, 13862, 13862, '0', 0, 0, 198.2395782470703125, -893.982666015625, 844.1141357421875, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+78, 415070, 2444, 13862, 13862, '0', 0, 0, 107.0868072509765625, -975.17706298828125, 837.51220703125, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+79, 415070, 2444, 13862, 13862, '0', 0, 0, 77.04514312744140625, -816.1024169921875, 846.96368408203125, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+80, 415070, 2444, 13862, 0, '0', 0, 0, 291.552093505859375, -1000.78131103515625, 872.3851318359375, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Flower Vase [DNT] (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+81, 415071, 2444, 13862, 13862, '0', 0, 0, 173.84375, -908.8055419921875, 848.6004638671875, 0.793021082878112792, -0.02721071243286132, 0.077428817749023437, 0.384534835815429687, 0.919454932212829589, 120, 255, 1, 53989), -- Noblegarden Ribbon 0.13 [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+82, 415071, 2444, 13862, 13862, '0', 0, 0, 202.9305572509765625, -867.55206298828125, 852.21697998046875, 4.2111663818359375, 0, 0, -0.86037731170654296, 0.509657621383666992, 120, 255, 1, 53989), -- Noblegarden Ribbon 0.13 [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+83, 415071, 2444, 13862, 13862, '0', 0, 0, 73.282989501953125, -808.33160400390625, 851.52752685546875, 1.548047661781311035, -0.02590227127075195, 0.033840179443359375, 0.698227882385253906, 0.714605987071990966, 120, 255, 1, 53989), -- Noblegarden Ribbon 0.13 [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+84, 415071, 2444, 13862, 13862, '0', 0, 0, 163.9913177490234375, -891.185791015625, 849.23272705078125, 0.309986233711242675, -0.00833988189697265, 0.049449920654296875, 0.154209136962890625, 0.986764788627624511, 120, 255, 1, 53989), -- Noblegarden Ribbon 0.13 [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+85, 415071, 2444, 13862, 13862, '0', 0, 0, 99.10590362548828125, -998.375, 847.44024658203125, 5.252030849456787109, 0, 0, -0.49303722381591796, 0.870008230209350585, 120, 255, 1, 53989), -- Noblegarden Ribbon 0.13 [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+86, 415071, 2444, 13862, 13862, '0', 0, 0, 84.1180572509765625, -1002.24298095703125, 847.4383544921875, 4.514918327331542968, 0, 0, -0.77336597442626953, 0.633959829807281494, 120, 255, 1, 53989), -- Noblegarden Ribbon 0.13 [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+87, 415071, 2444, 13862, 13862, '0', 0, 0, 59.88888931274414062, -812.97052001953125, 851.63592529296875, 2.162378311157226562, -0.03492212295532226, 0.024424552917480468, 0.881613731384277343, 0.470043748617172241, 120, 255, 1, 53989), -- Noblegarden Ribbon 0.13 [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+88, 415072, 2444, 13862, 13862, '0', 0, 0, 168.08160400390625, -900.32293701171875, 853.60113525390625, 0.512264192104339599, 0, 0, 0.253340721130371093, 0.967377126216888427, 120, 255, 1, 53989), -- Noblegarden Streamers - Small Hanging [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+89, 415072, 2444, 13862, 13862, '0', 0, 0, 79, -847.0086669921875, 854.91265869140625, 1.899121522903442382, 0, 0, 0.813159942626953125, 0.582040309906005859, 120, 255, 1, 53989), -- Noblegarden Streamers - Small Hanging [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+90, 415073, 2444, 13862, 13862, '0', 0, 0, 207.09375, -891.421875, 851.9412841796875, 2.581905603408813476, 0, 0, 0.961098670959472656, 0.276205271482467651, 120, 255, 1, 53989), -- Noblegarden Streamers - Large Hanging [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+91, 415074, 2444, 13862, 13862, '0', 0, 0, 194.3350677490234375, -897.73614501953125, 842.90411376953125, 2.215928554534912109, -0.02596426010131835, -0.00593280792236328, 0.894629478454589843, 0.446014255285263061, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+92, 415074, 2444, 13862, 13862, '0', 0, 0, 153.5850677490234375, -897.4617919921875, 840.28961181640625, 3.743134975433349609, 0.023415088653564453, -0.01070690155029296, -0.95488929748535156, 0.295843750238418579, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+93, 415074, 2444, 13862, 13862, '0', 0, 0, 73.423614501953125, -845.25, 843.787353515625, 1.358677148818969726, -0.02608156204223632, 0.005394935607910156, 0.628326416015625, 0.777493774890899658, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+94, 415074, 2444, 13862, 13862, '0', 0, 0, 68.62847137451171875, -992.55902099609375, 837.46331787109375, 1.404404520988464355, 0.02464151382446289, 0.090140342712402343, 0.639944076538085937, 0.76271820068359375, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+95, 415074, 2444, 13862, 13862, '0', 0, 0, -14.8072919845581054, -849.79864501953125, 838.0687255859375, 0.385387301445007324, -0.00158977508544921, 0.012691497802734375, 0.191476821899414062, 0.981413781642913818, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+96, 415074, 2444, 13862, 13862, '0', 0, 0, 20.453125, -880.8819580078125, 836.90252685546875, 1.855726838111877441, -0.01508998870849609, 0.018261909484863281, 0.800039291381835937, 0.599479734897613525, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+97, 415074, 2444, 13862, 13862, '0', 0, 0, 161.6788177490234375, -913.17364501953125, 840.77996826171875, 2.651485919952392578, -0.01795530319213867, 0.0731964111328125, 0.966792106628417968, 0.244198605418205261, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+98, 415074, 2444, 13862, 13862, '0', 0, 0, 82.46527862548828125, -842.4149169921875, 843.76605224609375, 2.553126096725463867, -0.02460050582885742, -0.01020526885986328, 0.956786155700683593, 0.289570242166519165, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+99, 415074, 2444, 13862, 13862, '0', 0, 0, 31.68402862548828125, -866.12847900390625, 836.90771484375, 3.098542690277099609, -0.01685285568237304, 0.0034027099609375, 0.999619483947753906, 0.021571589633822441, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+100, 415074, 2444, 13862, 0, '0', 0, 0, 204.0052032470703125, -1024.5867919921875, 870.9683837890625, 0.88096696138381958, -0.0240645408630371, 0.011412620544433593, 0.426540374755859375, 0.904076278209686279, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+101, 415074, 2444, 13862, 0, '0', 0, 0, 223.9618072509765625, -996.34893798828125, 870.9683837890625, 4.145311355590820312, 0.009914875030517578, 0.02471923828125, -0.87621116638183593, 0.481190830469131469, 120, 255, 1, 53989), -- Noblegarden Wreath Standing [DNT] (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+102, 415075, 2444, 13862, 13862, '0', 0, 0, 76.93576812744140625, -858.3125, 841.27349853515625, 4.832324028015136718, 0, 0, -0.66345787048339843, 0.748213648796081542, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+103, 415075, 2444, 13862, 13862, '0', 0, 0, 52.1805572509765625, -876.60418701171875, 836.1959228515625, 6.01987314224243164, 0, 0, -0.13127613067626953, 0.991345822811126708, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+104, 415075, 2444, 13862, 13862, '0', 0, 0, 35.515625, -898.19097900390625, 836.1107177734375, 5.252039432525634765, 0, 0, -0.49303340911865234, 0.8700103759765625, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+105, 415075, 2444, 13862, 13862, '0', 0, 0, 87.37152862548828125, -854.78125, 841.220703125, 5.25415658950805664, 0.002147197723388671, -0.00048637390136718, -0.4921121597290039, 0.870529055595397949, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.1 [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+106, 415722, 2444, 13862, 13862, '0', 0, 0, 199.7291717529296875, -999.58331298828125, 923.22491455078125, 2.458448648452758789, 0, 0, 0.942229270935058593, 0.3349686861038208, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+107, 415724, 2444, 13862, 13862, '0', 0, 0, 92.10590362548828125, -999.73614501953125, 851.31549072265625, 1.820411205291748046, 0, 0, 0.789629936218261718, 0.613583385944366455, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.5 [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+108, 415724, 2444, 13862, 0, '0', 0, 0, 279.876739501953125, -1019.2725830078125, 876.63897705078125, 4.045746326446533203, 0, 0, -0.89954185485839843, 0.436834573745727539, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.5 [DNT] (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+109, 415724, 2444, 13862, 0, '0', 0, 0, 244.2413177490234375, -1070.9600830078125, 876.71820068359375, 1.031191945075988769, 0, 0, 0.493053436279296875, 0.8699989914894104, 120, 255, 1, 53989), -- Noblegarden Hanging Wreath 0.5 [DNT] (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+110, 415838, 2444, 13862, 13862, '0', 0, 0, 81.43576812744140625, -913.107666015625, 839.27557373046875, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Floating [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+111, 415838, 2444, 13862, 13862, '0', 0, 0, 88.4149322509765625, -911.34893798828125, 839.27557373046875, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Floating [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+112, 415838, 2444, 13862, 13862, '0', 0, 0, 80.4930572509765625, -920.34027099609375, 839.27557373046875, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Floating [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+113, 415838, 2444, 13862, 13862, '0', 0, 0, 89.69791412353515625, -923.9600830078125, 839.2755126953125, 0, 0, 0, 0, 1, 120, 255, 1, 53989), -- Noblegarden Candle - Floating [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+(@OGUID+114, 415838, 2444, 13862, 13862, '0', 0, 0, 93.74826812744140625, -917.17535400390625, 839.27557373046875, 0, 0, 0, 0, 1, 120, 255, 1, 53989); -- Noblegarden Candle - Floating [DNT] (Area: Valdrakken - Difficulty: 0) CreateObject1
+
+DELETE FROM `pool_template` WHERE `entry`=@POOL;
+INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
+(@POOL, 14, 'Noblegarden - Valdrakken - Brightly Colored Egg');
+
+DELETE FROM `pool_members` WHERE `type`=1 AND `spawnId` BETWEEN @OGUID+0 AND @OGUID+43;
+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');
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+0;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(@EVENT, @CGUID+0);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+114;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(@EVENT, @OGUID+44),
+(@EVENT, @OGUID+45),
+(@EVENT, @OGUID+46),
+(@EVENT, @OGUID+47),
+(@EVENT, @OGUID+48),
+(@EVENT, @OGUID+49),
+(@EVENT, @OGUID+50),
+(@EVENT, @OGUID+51),
+(@EVENT, @OGUID+52),
+(@EVENT, @OGUID+53),
+(@EVENT, @OGUID+54),
+(@EVENT, @OGUID+55),
+(@EVENT, @OGUID+56),
+(@EVENT, @OGUID+57),
+(@EVENT, @OGUID+58),
+(@EVENT, @OGUID+59),
+(@EVENT, @OGUID+60),
+(@EVENT, @OGUID+61),
+(@EVENT, @OGUID+62),
+(@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),
+(@EVENT, @OGUID+96),
+(@EVENT, @OGUID+97),
+(@EVENT, @OGUID+98),
+(@EVENT, @OGUID+99),
+(@EVENT, @OGUID+100),
+(@EVENT, @OGUID+101),
+(@EVENT, @OGUID+102),
+(@EVENT, @OGUID+103),
+(@EVENT, @OGUID+104),
+(@EVENT, @OGUID+105),
+(@EVENT, @OGUID+106),
+(@EVENT, @OGUID+107),
+(@EVENT, @OGUID+108),
+(@EVENT, @OGUID+109),
+(@EVENT, @OGUID+110),
+(@EVENT, @OGUID+111),
+(@EVENT, @OGUID+112),
+(@EVENT, @OGUID+113),
+(@EVENT, @OGUID+114);
+
+DELETE FROM `game_event_pool` WHERE `eventEntry`=@EVENT AND `pool_entry`=@POOL;	
+INSERT INTO `game_event_pool`(`eventEntry`, `pool_entry`) VALUES
+(@EVENT, @POOL);