diff options
4 files changed, 640 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_06_16_world_hinterlands_hiriwatha_research_station.sql b/sql/updates/world/master/2023_11_06_16_world_hinterlands_hiriwatha_research_station.sql new file mode 100644 index 00000000000..c83e7fc6ad5 --- /dev/null +++ b/sql/updates/world/master/2023_11_06_16_world_hinterlands_hiriwatha_research_station.sql @@ -0,0 +1,115 @@ +SET @OGUID := 3003647; + +-- Gameobject templates +UPDATE `gameobject_template` SET `Data6`=0, `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208148; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208148; -- Candy Bucket + +-- Quests +DELETE FROM `quest_offer_reward` WHERE `ID`=28971; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28971, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket + +DELETE FROM `gameobject_queststarter` WHERE `id`=208148; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208148, 28971, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208148 AND `quest`=28971); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208148; + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 230383 AND 230457; +DELETE FROM `gameobject` WHERE `guid`=231995; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 230383 AND 230457; +DELETE FROM `game_event_gameobject` WHERE `guid`=231995; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+40; +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, 180405, 0, 47, 1885, '0', 0, 0, -30.4670143127441406, -2799.882080078125, 123.3467178344726562, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 47, 1885, '0', 0, 0, -2.25173616409301757, -2829.098876953125, 120.656890869140625, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 47, 1885, '0', 0, 0, -36.3732643127441406, -2805.663330078125, 123.3467178344726562, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+3, 180406, 0, 47, 1885, '0', 0, 0, 4.78993082046508789, -2821.41845703125, 120.8081207275390625, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+4, 180406, 0, 47, 1885, '0', 0, 0, -29.7517356872558593, -2827.185791015625, 125.8238906860351562, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+5, 180406, 0, 47, 1885, '0', 0, 0, -55.2951393127441406, -2838.911376953125, 121.5378189086914062, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+6, 180407, 0, 47, 1885, '0', 0, 0, -62.3923606872558593, -2830.907958984375, 123.0560226440429687, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+7, 180407, 0, 47, 1885, '0', 0, 0, -18.1961803436279296, -2822.98779296875, 125.7594375610351562, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+8, 180408, 0, 47, 1885, '0', 0, 0, -30.3923606872558593, -2799.96533203125, 124.96826171875, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+9, 180408, 0, 47, 1885, '0', 0, 0, -36.3125, -2805.770751953125, 124.9587020874023437, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+10, 180415, 0, 47, 1885, '0', 0, 0, -64.0850677490234375, -2829.23095703125, 126.0993728637695312, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 51886), -- CandleBlack01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+11, 180415, 0, 47, 1885, '0', 0, 0, -5.59375, -2807.085205078125, 127.3749771118164062, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 51886), -- CandleBlack01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+12, 180415, 0, 47, 1885, '0', 0, 0, -46.8107643127441406, -2816.564208984375, 125.2691421508789062, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 51886), -- CandleBlack01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+13, 180415, 0, 47, 1885, '0', 0, 0, -63.8836822509765625, -2829.5400390625, 125.94476318359375, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 51886), -- CandleBlack01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+14, 180415, 0, 47, 1885, '0', 0, 0, -63.7621536254882812, -2829.17529296875, 125.9222183227539062, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 51886), -- CandleBlack01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+15, 180415, 0, 47, 1885, '0', 0, 0, -6.94791650772094726, -2795.538330078125, 126.8768081665039062, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 51886), -- CandleBlack01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+16, 180415, 0, 47, 1885, '0', 0, 0, -6.93923616409301757, -2795.229248046875, 126.9227676391601562, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 51886), -- CandleBlack01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+17, 180415, 0, 47, 1885, '0', 0, 0, -47.1649322509765625, -2817.100830078125, 125.0144195556640625, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 51886), -- CandleBlack01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+18, 180415, 0, 47, 1885, '0', 0, 0, -5.59895849227905273, -2806.638916015625, 127.4177780151367187, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 51886), -- CandleBlack01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+19, 180415, 0, 47, 1885, '0', 0, 0, -7.19618082046508789, -2795.208251953125, 126.72509765625, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 51886), -- CandleBlack01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+20, 180425, 0, 47, 1885, '0', 0, 0, -46.7083320617675781, -2817.046875, 125.2868728637695312, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 51886), -- SkullCandle01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+21, 180426, 0, 47, 1885, '0', 0, 0, -20.7100696563720703, -2810.166748046875, 137.744903564453125, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 51886), -- Bat01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+22, 180426, 0, 47, 1885, '0', 0, 0, -24.6857643127441406, -2801.52783203125, 135.47216796875, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 51886), -- Bat01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+23, 180426, 0, 47, 1885, '0', 0, 0, -35.3159713745117187, -2817.48779296875, 136.742706298828125, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 51886), -- Bat01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+24, 180426, 0, 47, 1885, '0', 0, 0, -22.6579856872558593, -2818.704833984375, 138.9788055419921875, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 51886), -- Bat01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+25, 180427, 0, 47, 1885, '0', 0, 0, -29.7864589691162109, -2806.576416015625, 139.372772216796875, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- Bat02 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+26, 180427, 0, 47, 1885, '0', 0, 0, -27.2326393127441406, -2806.923583984375, 135.824066162109375, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 51886), -- Bat02 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+27, 180427, 0, 47, 1885, '0', 0, 0, -25.28125, -2811.357666015625, 140.7371368408203125, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 51886), -- Bat02 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+28, 180427, 0, 47, 1885, '0', 0, 0, -30.9583339691162109, -2812.34375, 138.4758758544921875, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 51886), -- Bat02 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+29, 180471, 0, 47, 1885, '0', 0, 0, -18.4774303436279296, -2793.828125, 125.5235366821289062, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+30, 180471, 0, 47, 1885, '0', 0, 0, -23.6267356872558593, -2790.607666015625, 125.6942291259765625, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+31, 180471, 0, 47, 1885, '0', 0, 0, -26.8559036254882812, -2795.798583984375, 125.6960830688476562, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+32, 180471, 0, 47, 1885, '0', 0, 0, -30.8177089691162109, -2798.545166015625, 130.7800140380859375, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+33, 180471, 0, 47, 1885, '0', 0, 0, -21.7100696563720703, -2798.944580078125, 125.707550048828125, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+34, 180471, 0, 47, 1885, '0', 0, 0, -37.515625, -2805.41845703125, 130.8957366943359375, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+35, 180472, 0, 47, 1885, '0', 0, 0, -33.1701393127441406, -2802.90966796875, 130.7775115966796875, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+36, 180523, 0, 47, 1885, '0', 0, 0, -24.3368053436279296, -2801.001708984375, 121.9005508422851562, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 51886), -- Apple Bob (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+37, 208069, 0, 47, 1885, '0', 0, 0, -4.63020849227905273, -2806.642333984375, 125.6697769165039062, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+38, 208072, 0, 47, 1885, '0', 0, 0, -5.28645849227905273, -2805.967041015625, 127.6161422729492187, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+39, 208078, 0, 47, 1885, '0', 0, 0, -5.20833349227905273, -2807.755126953125, 127.3490371704101562, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 +(@OGUID+40, 208148, 0, 47, 1885, '0', 0, 0, -18.5954856872558593, -2799.447998046875, 121.9956588745117187, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 51886); -- Candy Bucket (Area: Hiri'watha Research Station - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+40; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(12, @OGUID+0), +(12, @OGUID+1), +(12, @OGUID+2), +(12, @OGUID+3), +(12, @OGUID+4), +(12, @OGUID+5), +(12, @OGUID+6), +(12, @OGUID+7), +(12, @OGUID+8), +(12, @OGUID+9), +(12, @OGUID+10), +(12, @OGUID+11), +(12, @OGUID+12), +(12, @OGUID+13), +(12, @OGUID+14), +(12, @OGUID+15), +(12, @OGUID+16), +(12, @OGUID+17), +(12, @OGUID+18), +(12, @OGUID+19), +(12, @OGUID+20), +(12, @OGUID+21), +(12, @OGUID+22), +(12, @OGUID+23), +(12, @OGUID+24), +(12, @OGUID+25), +(12, @OGUID+26), +(12, @OGUID+27), +(12, @OGUID+28), +(12, @OGUID+29), +(12, @OGUID+30), +(12, @OGUID+31), +(12, @OGUID+32), +(12, @OGUID+33), +(12, @OGUID+34), +(12, @OGUID+35), +(12, @OGUID+36), +(12, @OGUID+37), +(12, @OGUID+38), +(12, @OGUID+39), +(12, @OGUID+40); diff --git a/sql/updates/world/master/2023_11_06_17_world_hinterlands_revantusk_village.sql b/sql/updates/world/master/2023_11_06_17_world_hinterlands_revantusk_village.sql new file mode 100644 index 00000000000..2246d7d5972 --- /dev/null +++ b/sql/updates/world/master/2023_11_06_17_world_hinterlands_revantusk_village.sql @@ -0,0 +1,131 @@ +SET @OGUID := 3003688; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=190089; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=190089; -- Candy Bucket + +-- Quests +UPDATE `quest_offer_reward` SET `VerifiedBuild`=51886 WHERE `ID`=12387; + +DELETE FROM `gameobject_queststarter` WHERE `id`=190089; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(190089, 12387, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=190089 AND `quest`=12387); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=190089; + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 230519 AND 230566; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 230519 AND 230566; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+50; +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, 180405, 0, 47, 3317, '0', 0, 0, -600.074462890625, -4603.5712890625, 27.95272254943847656, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 47, 3317, '0', 0, 0, -623.763916015625, -4593.28466796875, 34.01917648315429687, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 47, 3317, '0', 0, 0, -636.35400390625, -4569.6640625, 12.28984355926513671, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+3, 180405, 0, 47, 3317, '0', 0, 0, -620.32464599609375, -4573.29541015625, 35.35692214965820312, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+4, 180406, 0, 47, 3317, '0', 0, 0, -611.77777099609375, -4580.4443359375, 34.78152847290039062, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+5, 180406, 0, 47, 3317, '0', 0, 0, -605.93890380859375, -4601.9169921875, 12.38033771514892578, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+6, 180406, 0, 47, 3317, '0', 0, 0, -630.96356201171875, -4587.06103515625, 35.465423583984375, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+7, 180407, 0, 47, 3317, '0', 0, 0, -601.9031982421875, -4597.53271484375, 12.37905597686767578, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+8, 180407, 0, 47, 3317, '0', 0, 0, -614.33331298828125, -4590.375, 35.14227294921875, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+9, 180407, 0, 47, 3317, '0', 0, 0, -518.55731201171875, -4547.2724609375, 18.71857643127441406, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+10, 180407, 0, 47, 3317, '0', 0, 0, -522.36456298828125, -4527.26416015625, 18.77182960510253906, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+11, 180411, 0, 47, 3317, '0', 0, 0, -597.5, -4606.0244140625, 17.79171371459960937, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+12, 180411, 0, 47, 3317, '0', 0, 0, -606.1475830078125, -4567.1806640625, 21.98404312133789062, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+13, 180415, 0, 47, 3317, '0', 0, 0, -638.91461181640625, -4578.73388671875, 26.27497291564941406, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 51886), -- CandleBlack01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+14, 180415, 0, 47, 3317, '0', 0, 0, -643.2164306640625, -4570.73974609375, 23.73820877075195312, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 51886), -- CandleBlack01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+15, 180415, 0, 47, 3317, '0', 0, 0, -636.442138671875, -4574.0966796875, 25.59309959411621093, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+16, 180415, 0, 47, 3317, '0', 0, 0, -631.79864501953125, -4561.673828125, 19.59987831115722656, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 51886), -- CandleBlack01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+17, 180415, 0, 47, 3317, '0', 0, 0, -640.5399169921875, -4563.9599609375, 21.84121131896972656, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 51886), -- CandleBlack01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+18, 180425, 0, 47, 3317, '0', 0, 0, -632.81268310546875, -4584.07421875, 29.49501609802246093, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 51886), -- SkullCandle01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+19, 180425, 0, 47, 3317, '0', 0, 0, -629.3067626953125, -4579.80712890625, 29.92309188842773437, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 51886), -- SkullCandle01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+20, 180426, 0, 47, 3317, '0', 0, 0, -574.90106201171875, -4601.1494140625, 21.73719978332519531, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- Bat01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+21, 180426, 0, 47, 3317, '0', 0, 0, -583.15106201171875, -4609.05712890625, 21.79574012756347656, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 51886), -- Bat01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+22, 180426, 0, 47, 3317, '0', 0, 0, -570.20489501953125, -4596.0693359375, 24.93818092346191406, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 51886), -- Bat01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+23, 180426, 0, 47, 3317, '0', 0, 0, -597.40802001953125, -4624.0400390625, 23.65849113464355468, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 51886), -- Bat01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+24, 180426, 0, 47, 3317, '0', 0, 0, -579.83160400390625, -4604.65966796875, 17.17628860473632812, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 51886), -- Bat01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+25, 180426, 0, 47, 3317, '0', 0, 0, -580.07989501953125, -4594.6005859375, 23.55320549011230468, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 51886), -- Bat01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+26, 180426, 0, 47, 3317, '0', 0, 0, -570.8975830078125, -4590.861328125, 18.33801460266113281, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 51886), -- Bat01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+27, 180426, 0, 47, 3317, '0', 0, 0, -573.79864501953125, -4582.7275390625, 19.13083839416503906, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 51886), -- Bat01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+28, 180426, 0, 47, 3317, '0', 0, 0, -579.3663330078125, -4578.72900390625, 26.74537086486816406, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 51886), -- Bat01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+29, 180426, 0, 47, 3317, '0', 0, 0, -575.32989501953125, -4580.14404296875, 19.87532234191894531, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 51886), -- Bat01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+30, 180427, 0, 47, 3317, '0', 0, 0, -621.9757080078125, -4582.93408203125, 39.33240127563476562, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 51886), -- Bat02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+31, 180427, 0, 47, 3317, '0', 0, 0, -621.84027099609375, -4582.96533203125, 39.98805618286132812, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 51886), -- Bat02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+32, 180427, 0, 47, 3317, '0', 0, 0, -621.93231201171875, -4583.01025390625, 39.21599197387695312, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- Bat02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+33, 180427, 0, 47, 3317, '0', 0, 0, -621.84375, -4582.84033203125, 41.33563995361328125, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 51886), -- Bat02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+34, 180427, 0, 47, 3317, '0', 0, 0, -621.90106201171875, -4582.84375, 41.6900482177734375, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 51886), -- Bat02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+35, 180427, 0, 47, 3317, '0', 0, 0, -621.90972900390625, -4582.95654296875, 39.91201019287109375, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 51886), -- Bat02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+36, 180427, 0, 47, 3317, '0', 0, 0, -621.70660400390625, -4582.9306640625, 39.70874404907226562, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 51886), -- Bat02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+37, 180427, 0, 47, 3317, '0', 0, 0, -621.78302001953125, -4583.01025390625, 40.22352981567382812, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 51886), -- Bat02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+38, 180427, 0, 47, 3317, '0', 0, 0, -621.82989501953125, -4583.048828125, 38.66334152221679687, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- Bat02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+39, 180427, 0, 47, 3317, '0', 0, 0, -621.8350830078125, -4583.015625, 37.54110336303710937, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 51886), -- Bat02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+40, 180471, 0, 47, 3317, '0', 0, 0, -632.19061279296875, -4599.37744140625, 15.73878288269042968, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+41, 180471, 0, 47, 3317, '0', 0, 0, -627.28302001953125, -4572.66650390625, 15.36933612823486328, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+42, 180471, 0, 47, 3317, '0', 0, 0, -633.3211669921875, -4579, 15.43650245666503906, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+43, 180471, 0, 47, 3317, '0', 0, 0, -610.36895751953125, -4566.494140625, 16.35060882568359375, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+44, 180472, 0, 47, 3317, '0', 0, 0, -637.0369873046875, -4594.470703125, 17.55111312866210937, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+45, 180472, 0, 47, 3317, '0', 0, 0, -629.40625, -4569.79150390625, 16.90836524963378906, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+46, 180472, 0, 47, 3317, '0', 0, 0, -638.77777099609375, -4571.51220703125, 16.92748451232910156, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+47, 180472, 0, 47, 3317, '0', 0, 0, -626.373291015625, -4568.43408203125, 20.87187385559082031, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+48, 180472, 0, 47, 3317, '0', 0, 0, -605.28302001953125, -4571.3125, 17.34696197509765625, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+49, 180523, 0, 47, 3317, '0', 0, 0, -628.6632080078125, -4577.1318359375, 11.96486282348632812, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 51886), -- Apple Bob (Area: Revantusk Village - Difficulty: 0) CreateObject1 +(@OGUID+50, 190089, 0, 47, 3317, '0', 0, 0, -624.4285888671875, -4585.31298828125, 11.68708515167236328, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 51886); -- Candy Bucket (Area: Revantusk Village - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+50; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(12, @OGUID+0), +(12, @OGUID+1), +(12, @OGUID+2), +(12, @OGUID+3), +(12, @OGUID+4), +(12, @OGUID+5), +(12, @OGUID+6), +(12, @OGUID+7), +(12, @OGUID+8), +(12, @OGUID+9), +(12, @OGUID+10), +(12, @OGUID+11), +(12, @OGUID+12), +(12, @OGUID+13), +(12, @OGUID+14), +(12, @OGUID+15), +(12, @OGUID+16), +(12, @OGUID+17), +(12, @OGUID+18), +(12, @OGUID+19), +(12, @OGUID+20), +(12, @OGUID+21), +(12, @OGUID+22), +(12, @OGUID+23), +(12, @OGUID+24), +(12, @OGUID+25), +(12, @OGUID+26), +(12, @OGUID+27), +(12, @OGUID+28), +(12, @OGUID+29), +(12, @OGUID+30), +(12, @OGUID+31), +(12, @OGUID+32), +(12, @OGUID+33), +(12, @OGUID+34), +(12, @OGUID+35), +(12, @OGUID+36), +(12, @OGUID+37), +(12, @OGUID+38), +(12, @OGUID+39), +(12, @OGUID+40), +(12, @OGUID+41), +(12, @OGUID+42), +(12, @OGUID+43), +(12, @OGUID+44), +(12, @OGUID+45), +(12, @OGUID+46), +(12, @OGUID+47), +(12, @OGUID+48), +(12, @OGUID+49), +(12, @OGUID+50); diff --git a/sql/updates/world/master/2023_11_06_18_world_hinterlands_aerie_peak.sql b/sql/updates/world/master/2023_11_06_18_world_hinterlands_aerie_peak.sql new file mode 100644 index 00000000000..61f58f7f195 --- /dev/null +++ b/sql/updates/world/master/2023_11_06_18_world_hinterlands_aerie_peak.sql @@ -0,0 +1,143 @@ +SET @OGUID := 3003739; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=190054; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=190054; -- Candy Bucket + +-- Quests +UPDATE `quest_offer_reward` SET `VerifiedBuild`=51886 WHERE `ID`=12351; + +DELETE FROM `gameobject_queststarter` WHERE `id`=190054; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(190054, 12351, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=190054 AND `quest`=12351); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=190054; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+58; +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, 180405, 0, 47, 348, '0', 0, 0, 288.705230712890625, -2113.147216796875, 124.8901214599609375, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Aerie Peak - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 47, 348, '0', 0, 0, 294.172576904296875, -2137.14892578125, 124.8752593994140625, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Aerie Peak - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 47, 349, '0', 0, 0, 379.283355712890625, -2098.822021484375, 132.368072509765625, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+3, 180405, 0, 47, 349, '0', 0, 0, 392.12933349609375, -2101.987060546875, 131.5618896484375, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+4, 180405, 0, 47, 349, '0', 0, 0, 399.2591552734375, -2086.6962890625, 121.839141845703125, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+5, 180406, 0, 47, 349, '0', 0, 0, 394.451446533203125, -2129.339111328125, 131.5634765625, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+6, 180406, 0, 47, 349, '0', 0, 0, 405.19091796875, -2112.425048828125, 121.8408966064453125, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+7, 180406, 0, 47, 349, '0', 0, 0, 396.10321044921875, -2072.954833984375, 126.8394088745117187, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+8, 180407, 0, 47, 348, '0', 0, 0, 314.21441650390625, -2119.865966796875, 155.8123931884765625, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Aerie Peak - Difficulty: 0) CreateObject1 +(@OGUID+9, 180407, 0, 47, 349, '0', 0, 0, 381.986602783203125, -2110.2294921875, 132.368072509765625, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+10, 180407, 0, 47, 349, '0', 0, 0, 382.116058349609375, -2076.256103515625, 131.5617523193359375, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+11, 180407, 0, 47, 349, '0', 0, 0, 408.37371826171875, -2126.1640625, 126.8411712646484375, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+12, 180411, 0, 47, 348, '0', 0, 0, 305.977447509765625, -2121.635498046875, 129.2921142578125, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Aerie Peak - Difficulty: 0) CreateObject1 +(@OGUID+13, 180411, 0, 47, 349, '0', 0, 0, 399.421875, -2100.041748046875, 135.02923583984375, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+14, 180415, 0, 47, 349, '0', 0, 0, 399.9600830078125, -2102.404541015625, 132.4575653076171875, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 51886), -- CandleBlack01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+15, 180415, 0, 47, 349, '0', 0, 0, 392.211822509765625, -2104.052001953125, 132.2078399658203125, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 51886), -- CandleBlack01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+16, 180425, 0, 47, 349, '0', 0, 0, 404.5201416015625, -2123.700927734375, 127.7131500244140625, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 51886), -- SkullCandle01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+17, 180425, 0, 47, 349, '0', 0, 0, 404.06304931640625, -2123.4296875, 132.4418182373046875, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 51886), -- SkullCandle01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+18, 180425, 0, 47, 349, '0', 0, 0, 402.8507080078125, -2116.423583984375, 122.9971389770507812, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- SkullCandle01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+19, 180425, 0, 47, 349, '0', 0, 0, 398.6632080078125, -2098.364501953125, 132.4645843505859375, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- SkullCandle01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+20, 180425, 0, 47, 349, '0', 0, 0, 392.130218505859375, -2103.65966796875, 132.2633819580078125, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 51886), -- SkullCandle01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+21, 180425, 0, 47, 349, '0', 0, 0, 397.191131591796875, -2125.177490234375, 132.4427032470703125, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 51886), -- SkullCandle01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+22, 180425, 0, 47, 349, '0', 0, 0, 386.4443359375, -2078.662841796875, 132.440948486328125, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 51886), -- SkullCandle01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+23, 180425, 0, 47, 349, '0', 0, 0, 393.408050537109375, -2077.37890625, 132.4400634765625, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 51886), -- SkullCandle01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+24, 180425, 0, 47, 349, '0', 0, 0, 395.38909912109375, -2084.167236328125, 122.9953765869140625, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 51886), -- SkullCandle01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+25, 180425, 0, 47, 349, '0', 0, 0, 393.6806640625, -2076.903076171875, 127.71832275390625, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 51886), -- SkullCandle01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+26, 180471, 0, 47, 349, '0', 0, 0, 400.666656494140625, -2106.407958984375, 137.945892333984375, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+27, 180471, 0, 47, 349, '0', 0, 0, 402.51214599609375, -2118.767333984375, 134.1628570556640625, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+28, 180471, 0, 47, 349, '0', 0, 0, 402.352447509765625, -2128.5556640625, 134.1715850830078125, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+29, 180471, 0, 47, 349, '0', 0, 0, 397.90625, -2094.095458984375, 137.9875640869140625, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+30, 180471, 0, 47, 349, '0', 0, 0, 392.508697509765625, -2126.048583984375, 134.230316162109375, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+31, 180471, 0, 47, 349, '0', 0, 0, 396.916656494140625, -2119.25, 134.174163818359375, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+32, 180471, 0, 47, 349, '0', 0, 0, 393.666656494140625, -2130.507080078125, 134.17242431640625, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+33, 180471, 0, 47, 349, '0', 0, 0, 394.08160400390625, -2082.217041015625, 134.24444580078125, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+34, 180471, 0, 47, 349, '0', 0, 0, 388.869781494140625, -2084.185791015625, 134.186279296875, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+35, 180471, 0, 47, 349, '0', 0, 0, 407.55035400390625, -2117.491455078125, 134.3300323486328125, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+36, 180471, 0, 47, 349, '0', 0, 0, 408.586822509765625, -2122.392333984375, 134.184814453125, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+37, 180471, 0, 47, 349, '0', 0, 0, 409.723968505859375, -2127.029541015625, 134.2262115478515625, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+38, 180472, 0, 47, 349, '0', 0, 0, 384.6319580078125, -2109.80029296875, 139.4461517333984375, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+39, 180472, 0, 47, 349, '0', 0, 0, 382.1788330078125, -2098.0625, 139.4114227294921875, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+40, 180472, 0, 47, 349, '0', 0, 0, 401.8125, -2115.882080078125, 135.6278839111328125, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+41, 180472, 0, 47, 349, '0', 0, 0, 400.00347900390625, -2103.194580078125, 139.4389495849609375, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+42, 180472, 0, 47, 349, '0', 0, 0, 404.8194580078125, -2118.23095703125, 135.6009063720703125, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+43, 180472, 0, 47, 349, '0', 0, 0, 393.17962646484375, -2128.55615234375, 135.5971221923828125, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+44, 180472, 0, 47, 349, '0', 0, 0, 398.166656494140625, -2129.510498046875, 135.6094207763671875, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+45, 180472, 0, 47, 349, '0', 0, 0, 394.6632080078125, -2084.802001953125, 135.6330108642578125, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+46, 180472, 0, 47, 349, '0', 0, 0, 386.052093505859375, -2091.513916015625, 135.414886474609375, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+47, 180472, 0, 47, 349, '0', 0, 0, 398.52777099609375, -2097.022705078125, 139.4111785888671875, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+48, 180472, 0, 47, 349, '0', 0, 0, 396.388885498046875, -2116.888916015625, 135.623260498046875, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+49, 180472, 0, 47, 349, '0', 0, 0, 390.529510498046875, -2126.463623046875, 135.6192474365234375, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+50, 180472, 0, 47, 349, '0', 0, 0, 391.220489501953125, -2113.921875, 135.4010009765625, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+51, 180472, 0, 47, 349, '0', 0, 0, 391.90264892578125, -2120.487548828125, 135.63922119140625, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+52, 180472, 0, 47, 349, '0', 0, 0, 389.484375, -2086.819580078125, 135.5934906005859375, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+53, 180472, 0, 47, 349, '0', 0, 0, 408.07464599609375, -2120.248291015625, 135.6153411865234375, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+54, 180472, 0, 47, 349, '0', 0, 0, 406.291412353515625, -2127.577392578125, 135.5952911376953125, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+55, 180472, 0, 47, 349, '0', 0, 0, 405.171875, -2117.848876953125, 130.1558380126953125, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+56, 180472, 0, 47, 349, '0', 0, 0, 409.052093505859375, -2124.505126953125, 135.6364288330078125, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Wildhammer Keep - Difficulty: 0) CreateObject1 +(@OGUID+57, 180523, 0, 47, 348, '0', 0, 0, 325.046875, -2113.30029296875, 122.3416900634765625, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 51886), -- Apple Bob (Area: Aerie Peak - Difficulty: 0) CreateObject1 +(@OGUID+58, 190054, 0, 47, 348, '0', 0, 0, 321.95660400390625, -2121.260498046875, 121.7661285400390625, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 51886); -- Candy Bucket (Area: Aerie Peak - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+58; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(12, @OGUID+0), +(12, @OGUID+1), +(12, @OGUID+2), +(12, @OGUID+3), +(12, @OGUID+4), +(12, @OGUID+5), +(12, @OGUID+6), +(12, @OGUID+7), +(12, @OGUID+8), +(12, @OGUID+9), +(12, @OGUID+10), +(12, @OGUID+11), +(12, @OGUID+12), +(12, @OGUID+13), +(12, @OGUID+14), +(12, @OGUID+15), +(12, @OGUID+16), +(12, @OGUID+17), +(12, @OGUID+18), +(12, @OGUID+19), +(12, @OGUID+20), +(12, @OGUID+21), +(12, @OGUID+22), +(12, @OGUID+23), +(12, @OGUID+24), +(12, @OGUID+25), +(12, @OGUID+26), +(12, @OGUID+27), +(12, @OGUID+28), +(12, @OGUID+29), +(12, @OGUID+30), +(12, @OGUID+31), +(12, @OGUID+32), +(12, @OGUID+33), +(12, @OGUID+34), +(12, @OGUID+35), +(12, @OGUID+36), +(12, @OGUID+37), +(12, @OGUID+38), +(12, @OGUID+39), +(12, @OGUID+40), +(12, @OGUID+41), +(12, @OGUID+42), +(12, @OGUID+43), +(12, @OGUID+44), +(12, @OGUID+45), +(12, @OGUID+46), +(12, @OGUID+47), +(12, @OGUID+48), +(12, @OGUID+49), +(12, @OGUID+50), +(12, @OGUID+51), +(12, @OGUID+52), +(12, @OGUID+53), +(12, @OGUID+54), +(12, @OGUID+55), +(12, @OGUID+56), +(12, @OGUID+57), +(12, @OGUID+58); diff --git a/sql/updates/world/master/2023_11_06_19_world_hinterlands_stormfeather_outpost.sql b/sql/updates/world/master/2023_11_06_19_world_hinterlands_stormfeather_outpost.sql new file mode 100644 index 00000000000..1544132032f --- /dev/null +++ b/sql/updates/world/master/2023_11_06_19_world_hinterlands_stormfeather_outpost.sql @@ -0,0 +1,251 @@ +SET @OGUID := 3003798; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208127; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208127; -- Candy Bucket + +-- Quests +UPDATE `quest_template` SET `Expansion`=9, `VerifiedBuild`=51886 WHERE `ID`=28970; -- Candy Bucket + +DELETE FROM `quest_offer_reward` WHERE `ID`=28970; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28970, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket + +DELETE FROM `gameobject_queststarter` WHERE `id`=208127; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208127, 28970, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208127 AND `quest`=28970); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208127; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+110; +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, 180405, 0, 47, 5323, '0', 0, 0, 312.364593505859375, -4112.82666015625, 118.5153427124023437, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+1, 180406, 0, 47, 5323, '0', 0, 0, 352.380218505859375, -4118.71337890625, 125.2792129516601562, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+2, 180407, 0, 47, 5323, '0', 0, 0, 334.986114501953125, -4112.359375, 119.6699066162109375, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+3, 180410, 0, 47, 5323, '0', 0, 0, 336.67535400390625, -4121.8525390625, 120.3730316162109375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+4, 180410, 0, 47, 5323, '0', 0, 0, 336.6475830078125, -4133.95166015625, 120.4598236083984375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+5, 180415, 0, 47, 5323, '0', 0, 0, 313.567718505859375, -4110.4287109375, 118.206146240234375, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+6, 180415, 0, 47, 5323, '0', 0, 0, 323.595489501953125, -4118.4619140625, 118.9815826416015625, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+7, 180415, 0, 47, 5323, '0', 0, 0, 327.274322509765625, -4106.546875, 119.9332427978515625, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+8, 180415, 0, 47, 5323, '0', 0, 0, 303.65972900390625, -4116.283203125, 120.1780776977539062, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+9, 180415, 0, 47, 5323, '0', 0, 0, 317.713531494140625, -4105.22900390625, 118.3829879760742187, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+10, 180415, 0, 47, 5323, '0', 0, 0, 316.685760498046875, -4107.30029296875, 118.3378219604492187, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+11, 180415, 0, 47, 5323, '0', 0, 0, 313.4375, -4110.74462890625, 118.2456207275390625, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+12, 180415, 0, 47, 5323, '0', 0, 0, 317.880218505859375, -4104.8994140625, 118.3566665649414062, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+13, 180415, 0, 47, 5323, '0', 0, 0, 322.232635498046875, -4111.53125, 120.2766036987304687, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+14, 180415, 0, 47, 5323, '0', 0, 0, 303.395843505859375, -4121.74853515625, 119.7488937377929687, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+15, 180415, 0, 47, 5323, '0', 0, 0, 326.967010498046875, -4115.173828125, 118.9473724365234375, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+16, 180415, 0, 47, 5323, '0', 0, 0, 315.211822509765625, -4108.88037109375, 118.2577590942382812, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+17, 180415, 0, 47, 5323, '0', 0, 0, 317.7413330078125, -4117.31787109375, 120.26751708984375, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+18, 180415, 0, 47, 5323, '0', 0, 0, 316.838531494140625, -4106.9931640625, 118.2613906860351562, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+19, 180415, 0, 47, 5323, '0', 0, 0, 313.27777099609375, -4110.44775390625, 118.1058273315429687, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+20, 180415, 0, 47, 5323, '0', 0, 0, 317.529510498046875, -4104.94970703125, 118.1822433471679687, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+21, 180415, 0, 47, 5323, '0', 0, 0, 303.66839599609375, -4127.22900390625, 119.8719329833984375, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+22, 180415, 0, 47, 5323, '0', 0, 0, 336.789947509765625, -4120.53466796875, 131.209442138671875, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+23, 180415, 0, 47, 5323, '0', 0, 0, 337.095489501953125, -4126.29150390625, 127.3756637573242187, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+24, 180415, 0, 47, 5323, '0', 0, 0, 331.73089599609375, -4127.955078125, 131.209442138671875, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+25, 180415, 0, 47, 5323, '0', 0, 0, 323.611114501953125, -4137.1630859375, 118.964202880859375, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+26, 180415, 0, 47, 5323, '0', 0, 0, 336.9444580078125, -4123.8037109375, 129.092559814453125, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+27, 180415, 0, 47, 5323, '0', 0, 0, 311.435760498046875, -4135.71728515625, 120.2576217651367187, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+28, 180415, 0, 47, 5323, '0', 0, 0, 303.6875, -4133.2255859375, 120.4885635375976562, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+29, 180415, 0, 47, 5323, '0', 0, 0, 332.875, -4123.6474609375, 131.208343505859375, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+30, 180415, 0, 47, 5323, '0', 0, 0, 337.1319580078125, -4128.86279296875, 125.7062835693359375, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+31, 180415, 0, 47, 5323, '0', 0, 0, 318.546875, -4140.5537109375, 119.76043701171875, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+32, 180415, 0, 47, 5323, '0', 0, 0, 331.045135498046875, -4111.13525390625, 118.9806137084960937, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+33, 180415, 0, 47, 5323, '0', 0, 0, 332.8194580078125, -4132.18603515625, 131.2079010009765625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+34, 180415, 0, 47, 5323, '0', 0, 0, 332.7725830078125, -4104.73291015625, 120.4819488525390625, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+35, 180415, 0, 47, 5323, '0', 0, 0, 340.37152099609375, -4102.6318359375, 121.2888031005859375, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+36, 180415, 0, 47, 5323, '0', 0, 0, 305.895843505859375, -4135.673828125, 120.5101165771484375, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+37, 180415, 0, 47, 5323, '0', 0, 0, 362.328125, -4115.29541015625, 121.0760116577148437, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+38, 180415, 0, 47, 5323, '0', 0, 0, 358.354156494140625, -4144.125, 121.2448577880859375, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+39, 180415, 0, 47, 5323, '0', 0, 0, 365.609375, -4127.84228515625, 120.1816864013671875, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+40, 180415, 0, 47, 5323, '0', 0, 0, 363.9288330078125, -4121.35791015625, 120.5629730224609375, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+41, 180415, 0, 47, 5323, '0', 0, 0, 344.65277099609375, -4135.37841796875, 131.209442138671875, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+42, 180415, 0, 47, 5323, '0', 0, 0, 352.39410400390625, -4105.830078125, 120.2817535400390625, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+43, 180415, 0, 47, 5323, '0', 0, 0, 340.333343505859375, -4153.19091796875, 119.843658447265625, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+44, 180415, 0, 47, 5323, '0', 0, 0, 328.03125, -4149.8212890625, 120.9545135498046875, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+45, 180415, 0, 47, 5323, '0', 0, 0, 363.93402099609375, -4134.330078125, 120.6692581176757812, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+46, 180415, 0, 47, 5323, '0', 0, 0, 330.638885498046875, -4144.361328125, 118.9478530883789062, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+47, 180415, 0, 47, 5323, '0', 0, 0, 326.73785400390625, -4140.52099609375, 118.9572525024414062, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+48, 180415, 0, 47, 5323, '0', 0, 0, 347.123260498046875, -4151.46728515625, 120.5383834838867187, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+49, 180415, 0, 47, 5323, '0', 0, 0, 334.869781494140625, -4151.5869140625, 120.322021484375, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+50, 180415, 0, 47, 5323, '0', 0, 0, 343.58160400390625, -4120.5400390625, 131.209442138671875, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+51, 180415, 0, 47, 5323, '0', 0, 0, 323.40625, -4145.52783203125, 120.4298477172851562, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+52, 180415, 0, 47, 5323, '0', 0, 0, 357.48089599609375, -4110.71875, 120.6629562377929687, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+53, 180415, 0, 47, 5323, '0', 0, 0, 335.901031494140625, -4135.345703125, 131.209442138671875, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+54, 180415, 0, 47, 5323, '0', 0, 0, 343.65625, -4131.41650390625, 124.4604568481445312, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+55, 180415, 0, 47, 5323, '0', 0, 0, 337.057281494140625, -4131.39404296875, 124.4604568481445312, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+56, 180415, 0, 47, 5323, '0', 0, 0, 347.810760498046875, -4132.19775390625, 131.209442138671875, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+57, 180415, 0, 47, 5323, '0', 0, 0, 343.52777099609375, -4123.751953125, 128.94287109375, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+58, 180415, 0, 47, 5323, '0', 0, 0, 352.994781494140625, -4149.48974609375, 121.1174163818359375, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+59, 180415, 0, 47, 5323, '0', 0, 0, 348.97222900390625, -4127.93603515625, 131.209442138671875, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+60, 180415, 0, 47, 5323, '0', 0, 0, 346.140625, -4104.34228515625, 120.7802505493164062, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+61, 180415, 0, 47, 5323, '0', 0, 0, 343.65972900390625, -4128.9755859375, 125.5296401977539062, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+62, 180415, 0, 47, 5323, '0', 0, 0, 347.805572509765625, -4123.62841796875, 131.209442138671875, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+63, 180415, 0, 47, 5323, '0', 0, 0, 362.197906494140625, -4140.3037109375, 121.3036727905273437, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+64, 180415, 0, 47, 5323, '0', 0, 0, 343.583343505859375, -4126.314453125, 127.37188720703125, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+65, 180415, 0, 47, 5323, '0', 0, 0, 340.336822509765625, -4136.55029296875, 131.2082061767578125, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- CandleBlack01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+66, 180425, 0, 47, 5323, '0', 0, 0, 315.010406494140625, -4109.064453125, 118.4174270629882812, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 51886), -- SkullCandle01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+67, 180425, 0, 47, 5323, '0', 0, 0, 303.75, -4114.31591796875, 120.5847930908203125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 51886), -- SkullCandle01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+68, 180426, 0, 47, 5323, '0', 0, 0, 334.758697509765625, -4128.49462890625, 144.2128143310546875, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 51886), -- Bat01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+69, 180426, 0, 47, 5323, '0', 0, 0, 344.73785400390625, -4121.8525390625, 144.0807647705078125, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 51886), -- Bat01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+70, 180426, 0, 47, 5323, '0', 0, 0, 343.95660400390625, -4129.23974609375, 145.5301361083984375, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- Bat01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+71, 180426, 0, 47, 5323, '0', 0, 0, 339.649322509765625, -4126.580078125, 133.9463958740234375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+72, 180426, 0, 47, 5323, '0', 0, 0, 337.970489501953125, -4123.111328125, 141.371734619140625, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 51886), -- Bat01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+73, 180426, 0, 47, 5323, '0', 0, 0, 339.149322509765625, -4126.0849609375, 140.5427398681640625, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 51886), -- Bat01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+74, 180427, 0, 47, 5323, '0', 0, 0, 373.223968505859375, -4030.079833984375, 120.4513931274414062, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+75, 180471, 0, 47, 5323, '0', 0, 0, 317.423614501953125, -4125.70654296875, 121.0174026489257812, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+76, 180471, 0, 47, 5323, '0', 0, 0, 327.248260498046875, -4123.41845703125, 133.413848876953125, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+77, 180471, 0, 47, 5323, '0', 0, 0, 337.7257080078125, -4114.23779296875, 133.408355712890625, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+78, 180471, 0, 47, 5323, '0', 0, 0, 317.203125, -4128.77783203125, 121.3172836303710937, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+79, 180471, 0, 47, 5323, '0', 0, 0, 329.682281494140625, -4119.1005859375, 133.400054931640625, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+80, 180471, 0, 47, 5323, '0', 0, 0, 317.361114501953125, -4130.03466796875, 121.0230331420898437, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+81, 180471, 0, 47, 5323, '0', 0, 0, 326.765625, -4130.40478515625, 133.4097900390625, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+82, 180471, 0, 47, 5323, '0', 0, 0, 326.743072509765625, -4125.59375, 133.4256591796875, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+83, 180471, 0, 47, 5323, '0', 0, 0, 317.11285400390625, -4127.75537109375, 121.5284805297851562, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+84, 180471, 0, 47, 5323, '0', 0, 0, 327.263885498046875, -4132.9287109375, 133.3914794921875, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+85, 180471, 0, 47, 5323, '0', 0, 0, 331.552093505859375, -4117.546875, 133.4232940673828125, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+86, 180471, 0, 47, 5323, '0', 0, 0, 317.279510498046875, -4126.69775390625, 121.2981796264648437, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+87, 180471, 0, 47, 5323, '0', 0, 0, 351.338531494140625, -4119.7275390625, 133.453216552734375, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+88, 180471, 0, 47, 5323, '0', 0, 0, 345.0625, -4140.8369140625, 133.4311065673828125, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+89, 180471, 0, 47, 5323, '0', 0, 0, 353.875, -4130.29345703125, 133.27178955078125, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+90, 180471, 0, 47, 5323, '0', 0, 0, 342.7725830078125, -4141.41650390625, 133.425079345703125, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+91, 180471, 0, 47, 5323, '0', 0, 0, 331.59027099609375, -4138.48291015625, 133.432281494140625, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+92, 180471, 0, 47, 5323, '0', 0, 0, 349.295135498046875, -4138.32275390625, 133.2808837890625, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+93, 180471, 0, 47, 5323, '0', 0, 0, 329.79339599609375, -4136.98779296875, 133.4102783203125, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+94, 180471, 0, 47, 5323, '0', 0, 0, 342.508697509765625, -4114.267578125, 133.4024658203125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+95, 180471, 0, 47, 5323, '0', 0, 0, 352.78472900390625, -4134.03125, 133.31207275390625, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+96, 180471, 0, 47, 5323, '0', 0, 0, 351.18402099609375, -4136.251953125, 133.31817626953125, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+97, 180471, 0, 47, 5323, '0', 0, 0, 349.07464599609375, -4117.47412109375, 133.4058685302734375, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+98, 180471, 0, 47, 5323, '0', 0, 0, 338.095489501953125, -4141.62158203125, 133.3983154296875, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+99, 180471, 0, 47, 5323, '0', 0, 0, 352.83160400390625, -4122.43408203125, 133.4535675048828125, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+100, 180471, 0, 47, 5323, '0', 0, 0, 335.65625, -4140.84033203125, 133.414703369140625, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+101, 180471, 0, 47, 5323, '0', 0, 0, 353.95660400390625, -4125.439453125, 133.4044189453125, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+102, 180471, 0, 47, 5323, '0', 0, 0, 344.963531494140625, -4114.84228515625, 133.4049072265625, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+103, 180472, 0, 47, 5323, '0', 0, 0, 352.2413330078125, -4134.99658203125, 134.1078338623046875, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+104, 180472, 0, 47, 5323, '0', 0, 0, 352.446197509765625, -4121.0849609375, 134.2257843017578125, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+105, 180523, 0, 47, 5323, '0', 0, 0, 326.454864501953125, -4134.033203125, 117.3855819702148437, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Apple Bob (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+106, 185437, 0, 47, 5323, '0', 0, 0, 329.666656494140625, -4114.65966796875, 131.893768310546875, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- Laying Skeleton 01 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+107, 208069, 0, 47, 5323, '0', 0, 0, 335.208343505859375, -4130.15283203125, 117.2158203125, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+108, 208072, 0, 47, 5323, '0', 0, 0, 350.020843505859375, -4140.21875, 125.3933868408203125, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+109, 208078, 0, 47, 5323, '0', 0, 0, 335.135406494140625, -4125.60595703125, 117.2158203125, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 +(@OGUID+110, 208127, 0, 47, 5323, '0', 0, 0, 326.24652099609375, -4122.345703125, 117.1905899047851562, 0, 0, 0, 0, 1, 120, 255, 1, 51886); -- Candy Bucket (Area: Stormfeather Outpost - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+110; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(12, @OGUID+0), +(12, @OGUID+1), +(12, @OGUID+2), +(12, @OGUID+3), +(12, @OGUID+4), +(12, @OGUID+5), +(12, @OGUID+6), +(12, @OGUID+7), +(12, @OGUID+8), +(12, @OGUID+9), +(12, @OGUID+10), +(12, @OGUID+11), +(12, @OGUID+12), +(12, @OGUID+13), +(12, @OGUID+14), +(12, @OGUID+15), +(12, @OGUID+16), +(12, @OGUID+17), +(12, @OGUID+18), +(12, @OGUID+19), +(12, @OGUID+20), +(12, @OGUID+21), +(12, @OGUID+22), +(12, @OGUID+23), +(12, @OGUID+24), +(12, @OGUID+25), +(12, @OGUID+26), +(12, @OGUID+27), +(12, @OGUID+28), +(12, @OGUID+29), +(12, @OGUID+30), +(12, @OGUID+31), +(12, @OGUID+32), +(12, @OGUID+33), +(12, @OGUID+34), +(12, @OGUID+35), +(12, @OGUID+36), +(12, @OGUID+37), +(12, @OGUID+38), +(12, @OGUID+39), +(12, @OGUID+40), +(12, @OGUID+41), +(12, @OGUID+42), +(12, @OGUID+43), +(12, @OGUID+44), +(12, @OGUID+45), +(12, @OGUID+46), +(12, @OGUID+47), +(12, @OGUID+48), +(12, @OGUID+49), +(12, @OGUID+50), +(12, @OGUID+51), +(12, @OGUID+52), +(12, @OGUID+53), +(12, @OGUID+54), +(12, @OGUID+55), +(12, @OGUID+56), +(12, @OGUID+57), +(12, @OGUID+58), +(12, @OGUID+59), +(12, @OGUID+60), +(12, @OGUID+61), +(12, @OGUID+62), +(12, @OGUID+63), +(12, @OGUID+64), +(12, @OGUID+65), +(12, @OGUID+66), +(12, @OGUID+67), +(12, @OGUID+68), +(12, @OGUID+69), +(12, @OGUID+70), +(12, @OGUID+71), +(12, @OGUID+72), +(12, @OGUID+73), +(12, @OGUID+74), +(12, @OGUID+75), +(12, @OGUID+76), +(12, @OGUID+77), +(12, @OGUID+78), +(12, @OGUID+79), +(12, @OGUID+80), +(12, @OGUID+81), +(12, @OGUID+82), +(12, @OGUID+83), +(12, @OGUID+84), +(12, @OGUID+85), +(12, @OGUID+86), +(12, @OGUID+87), +(12, @OGUID+88), +(12, @OGUID+89), +(12, @OGUID+90), +(12, @OGUID+91), +(12, @OGUID+92), +(12, @OGUID+93), +(12, @OGUID+94), +(12, @OGUID+95), +(12, @OGUID+96), +(12, @OGUID+97), +(12, @OGUID+98), +(12, @OGUID+99), +(12, @OGUID+100), +(12, @OGUID+101), +(12, @OGUID+102), +(12, @OGUID+103), +(12, @OGUID+104), +(12, @OGUID+105), +(12, @OGUID+106), +(12, @OGUID+107), +(12, @OGUID+108), +(12, @OGUID+109), +(12, @OGUID+110); |