diff options
4 files changed, 582 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_22_00_world_northern_stranglethorn_gromgol_base_camp.sql b/sql/updates/world/master/2023_11_22_00_world_northern_stranglethorn_gromgol_base_camp.sql new file mode 100644 index 00000000000..aacf0cac3b7 --- /dev/null +++ b/sql/updates/world/master/2023_11_22_00_world_northern_stranglethorn_gromgol_base_camp.sql @@ -0,0 +1,123 @@ +SET @OGUID := 3005442; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=190084; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=190084; -- Candy Bucket + +-- Quests +UPDATE `quest_offer_reward` SET `VerifiedBuild`=51886 WHERE `ID`=12382; + +DELETE FROM `gameobject_queststarter` WHERE `id`=190084; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(190084, 12382, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=190084 AND `quest`=12382); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=190084; + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 231617 AND 231661; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231617 AND 231661; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+46; +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, 33, 117, '0', 0, 0, -12428.009765625, 132.83447265625, 3.73997807502746582, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 33, 117, '0', 0, 0, -12330.658203125, 169.2863006591796875, 16.24791336059570312, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 33, 117, '0', 0, 0, -12429.7822265625, 225.4612579345703125, 1.217295050621032714, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+3, 180405, 0, 33, 117, '0', 0, 0, -12383.953125, 229.4755096435546875, 15.22707271575927734, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+4, 180406, 0, 33, 117, '0', 0, 0, -12432.5986328125, 138.9429473876953125, 3.183878898620605468, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+5, 180406, 0, 33, 117, '0', 0, 0, -12397.3681640625, 129.2810821533203125, 16.65046119689941406, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+6, 180406, 0, 33, 117, '0', 0, 0, -12423.0478515625, 223.0655975341796875, 1.349156022071838378, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+7, 180406, 0, 33, 117, '0', 0, 0, -12331.6357421875, 179.3895111083984375, 16.12927055358886718, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+8, 180407, 0, 33, 117, '0', 0, 0, -12432.46875, 134.4552459716796875, 3.509543895721435546, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+9, 180407, 0, 33, 117, '0', 0, 0, -12386.4052734375, 128.4357147216796875, 16.494964599609375, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+10, 180407, 0, 33, 117, '0', 0, 0, -12373.7890625, 230.0304718017578125, 15.5079193115234375, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+11, 180411, 0, 33, 117, '0', 0, 0, -12425.2119140625, 184.6666717529296875, 22.937408447265625, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+12, 180411, 0, 33, 117, '0', 0, 0, -12452.228515625, 220.15972900390625, 23.67788124084472656, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+13, 180411, 0, 33, 117, '0', 0, 0, -12449.138671875, 191.111114501953125, 23.39250373840332031, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+14, 180411, 0, 33, 117, '0', 0, 0, -12406.53515625, 208.8246612548828125, 23.42061805725097656, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+15, 180411, 0, 33, 117, '0', 0, 0, -12425, 230.3975677490234375, 23.87989616394042968, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+16, 180471, 0, 33, 117, '0', 0, 0, -12427.46875, 200.4340362548828125, 12.97709465026855468, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+17, 180471, 0, 33, 117, '0', 0, 0, -12443.12890625, 197.7309112548828125, 8.0163421630859375, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+18, 180471, 0, 33, 117, '0', 0, 0, -12421.8095703125, 200.453125, 5.834054946899414062, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+19, 180471, 0, 33, 117, '0', 0, 0, -12415.2080078125, 195.2621612548828125, 7.879192829132080078, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+20, 180471, 0, 33, 117, '0', 0, 0, -12436.388671875, 188.8020782470703125, 7.177947044372558593, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+21, 180471, 0, 33, 117, '0', 0, 0, -12425.65625, 191.9270782470703125, 7.739860057830810546, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+22, 180471, 0, 33, 117, '0', 0, 0, -12436.7470703125, 225.0850677490234375, 7.963707923889160156, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+23, 180471, 0, 33, 117, '0', 0, 0, -12423.0068359375, 208.5243072509765625, 11.03492355346679687, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+24, 180471, 0, 33, 117, '0', 0, 0, -12415.7783203125, 207.154510498046875, 7.966198921203613281, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+25, 180471, 0, 33, 117, '0', 0, 0, -12449.5830078125, 207.2621612548828125, 8.5053863525390625, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+26, 180471, 0, 33, 117, '0', 0, 0, -12416.044921875, 217.8246612548828125, 8.443134307861328125, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+27, 180471, 0, 33, 117, '0', 0, 0, -12437.2919921875, 212.060760498046875, 7.178095817565917968, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+28, 180471, 0, 33, 117, '0', 0, 0, -12428.65625, 215.578125, 9.139922142028808593, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+29, 180471, 0, 33, 117, '0', 0, 0, -12443.2880859375, 216.361114501953125, 8.265881538391113281, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+30, 180471, 0, 33, 117, '0', 0, 0, -12427.3193359375, 221.6979217529296875, 8.162608146667480468, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+31, 180471, 0, 33, 117, '0', 0, 0, -12440.580078125, 207.0885467529296875, 5.970573902130126953, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+32, 180472, 0, 33, 117, '0', 0, 0, -12432.6318359375, 197.814239501953125, 7.392722129821777343, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+33, 180472, 0, 33, 117, '0', 0, 0, -12439.9140625, 193.9031829833984375, 8.770547866821289062, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+34, 180472, 0, 33, 117, '0', 0, 0, -12421.2431640625, 193.4652862548828125, 8.942568778991699218, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+35, 180472, 0, 33, 117, '0', 0, 0, -12431.2158203125, 190.2777862548828125, 8.79494476318359375, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+36, 180472, 0, 33, 117, '0', 0, 0, -12415.544921875, 201.2934112548828125, 9.187487602233886718, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+37, 180472, 0, 33, 117, '0', 0, 0, -12421.0517578125, 219.435760498046875, 9.466778755187988281, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+38, 180472, 0, 33, 117, '0', 0, 0, -12439.9443359375, 220.4913177490234375, 9.350820541381835937, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+39, 180472, 0, 33, 117, '0', 0, 0, -12432.2880859375, 216.51910400390625, 7.256028175354003906, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+40, 180472, 0, 33, 117, '0', 0, 0, -12422.763671875, 212.8090362548828125, 7.253457069396972656, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+41, 180472, 0, 33, 117, '0', 0, 0, -12433.076171875, 223.7256927490234375, 9.326802253723144531, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+42, 180472, 0, 33, 117, '0', 0, 0, -12445.8798828125, 212.2630767822265625, 9.529207229614257812, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+43, 180472, 0, 33, 117, '0', 0, 0, -12445.77734375, 201.7794342041015625, 9.364244461059570312, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+44, 180472, 0, 33, 117, '0', 0, 0, -12415.90625, 212.548614501953125, 9.490024566650390625, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+45, 180523, 0, 33, 117, '0', 0, 0, -12423.06640625, 216.5520782470703125, 2.649869918823242187, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 51886), -- Apple Bob (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+46, 190084, 0, 33, 117, '0', 0, 0, -12431.958984375, 211.2803497314453125, 2.36514902114868164, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 51886); -- Candy Bucket (Area: Grom'gol Base Camp - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+46; +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); diff --git a/sql/updates/world/master/2023_11_22_01_world_northern_stranglethorn_fort_livingston.sql b/sql/updates/world/master/2023_11_22_01_world_northern_stranglethorn_fort_livingston.sql new file mode 100644 index 00000000000..6a080b18622 --- /dev/null +++ b/sql/updates/world/master/2023_11_22_01_world_northern_stranglethorn_fort_livingston.sql @@ -0,0 +1,93 @@ +SET @OGUID := 3005489; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208125; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208125; -- Candy Bucket + +-- Quests +DELETE FROM `quest_offer_reward` WHERE `ID`=28964; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28964, 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`=208125; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208125, 28964, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208125 AND `quest`=28964); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208125; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+32; +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, 33, 5320, '0', 0, 0, -12827.6494140625, -401.064239501953125, 12.95209598541259765, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 33, 5320, '0', 0, 0, -12805.5244140625, -436.21527099609375, 13.0759744644165039, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+2, 180406, 0, 33, 5320, '0', 0, 0, -12836.8642578125, -401.423614501953125, 12.95469093322753906, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+3, 180406, 0, 33, 5320, '0', 0, 0, -12860.87890625, -417.982635498046875, 12.96472644805908203, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+4, 180407, 0, 33, 5320, '0', 0, 0, -12809.0068359375, -445.875, 12.96668052673339843, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+5, 180407, 0, 33, 5320, '0', 0, 0, -12861.9306640625, -427.234375, 13.21140289306640625, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+6, 180408, 0, 33, 5320, '0', 0, 0, -12818.767578125, -422.90277099609375, 18.00031089782714843, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+7, 180415, 0, 33, 5320, '0', 0, 0, -12841.625, -411.02777099609375, 13.66728687286376953, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+8, 180415, 0, 33, 5320, '0', 0, 0, -12841.705078125, -411.232635498046875, 13.61534976959228515, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+9, 180415, 0, 33, 5320, '0', 0, 0, -12811.4892578125, -428.375, 15.11994075775146484, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+10, 180415, 0, 33, 5320, '0', 0, 0, -12811.5595703125, -428.661468505859375, 15.00187492370605468, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+11, 180415, 0, 33, 5320, '0', 0, 0, -12811.2470703125, -428.560760498046875, 15.18839359283447265, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+12, 180425, 0, 33, 5320, '0', 0, 0, -12821.5732421875, -425.86285400390625, 13.91074752807617187, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 51886), -- SkullCandle01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+13, 180425, 0, 33, 5320, '0', 0, 0, -12847.0419921875, -418.032989501953125, 13.86970996856689453, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 51886), -- SkullCandle01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+14, 180426, 0, 33, 5320, '0', 0, 0, -12837.603515625, -426.21875, 18.19655227661132812, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 51886), -- Bat01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+15, 180426, 0, 33, 5320, '0', 0, 0, -12840.53125, -429.220489501953125, 21.11986732482910156, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 51886), -- Bat01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+16, 180426, 0, 33, 5320, '0', 0, 0, -12834.5693359375, -424.203125, 19.83699989318847656, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 51886), -- Bat01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+17, 180426, 0, 33, 5320, '0', 0, 0, -12836.919921875, -424.848968505859375, 21.17567062377929687, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- Bat01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+18, 180427, 0, 33, 5320, '0', 0, 0, -12839.919921875, -425.482635498046875, 19.43795394897460937, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 51886), -- Bat02 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+19, 180427, 0, 33, 5320, '0', 0, 0, -12833.607421875, -429.9288330078125, 17.53478813171386718, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 51886), -- Bat02 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+20, 180427, 0, 33, 5320, '0', 0, 0, -12835.6005859375, -427.7569580078125, 26.12606239318847656, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- Bat02 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+21, 180471, 0, 33, 5320, '0', 0, 0, -12823.9033203125, -420.399322509765625, 16.11289787292480468, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+22, 180471, 0, 33, 5320, '0', 0, 0, -12820.955078125, -428.20660400390625, 16.10209083557128906, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+23, 180471, 0, 33, 5320, '0', 0, 0, -12830.8134765625, -445.515625, 15.13029289245605468, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+24, 180471, 0, 33, 5320, '0', 0, 0, -12831.0068359375, -449.727447509765625, 15.24355411529541015, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+25, 180471, 0, 33, 5320, '0', 0, 0, -12813.22265625, -425.282989501953125, 16.12880516052246093, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+26, 180471, 0, 33, 5320, '0', 0, 0, -12816.0634765625, -417.4757080078125, 16.08460426330566406, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+27, 180471, 0, 33, 5320, '0', 0, 0, -12836.4130859375, -445.298614501953125, 15.17396068572998046, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+28, 180471, 0, 33, 5320, '0', 0, 0, -12836.5869140625, -449.477447509765625, 15.21264553070068359, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+29, 180472, 0, 33, 5320, '0', 0, 0, -12822.146484375, -424.140625, 16.56383705139160156, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+30, 180472, 0, 33, 5320, '0', 0, 0, -12837.576171875, -447.34027099609375, 17.73743438720703125, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+31, 180523, 0, 33, 5320, '0', 0, 0, -12853.28515625, -435.54339599609375, 13.22400093078613281, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 51886), -- Apple Bob (Area: Fort Livingston - Difficulty: 0) CreateObject1 +(@OGUID+32, 208125, 0, 33, 5320, '0', 0, 0, -12847.4755859375, -435.87152099609375, 12.96668052673339843, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886); -- Candy Bucket (Area: Fort Livingston - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+32; +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); diff --git a/sql/updates/world/master/2023_11_22_02_world_the_cape_of_stranglethorn_hardwrench_hideaway.sql b/sql/updates/world/master/2023_11_22_02_world_the_cape_of_stranglethorn_hardwrench_hideaway.sql new file mode 100644 index 00000000000..0b7d7b2a816 --- /dev/null +++ b/sql/updates/world/master/2023_11_22_02_world_the_cape_of_stranglethorn_hardwrench_hideaway.sql @@ -0,0 +1,269 @@ +SET @OGUID := 3005522; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208147; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208147; -- Candy Bucket + +-- Quests +DELETE FROM `quest_offer_reward` WHERE `ID`=28969; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28969, 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`=208147; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208147, 28969, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208147 AND `quest`=28969); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208147; + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 231662 AND 231768; +DELETE FROM `gameobject` WHERE `guid`=232009; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231662 AND 231768; +DELETE FROM `game_event_gameobject` WHERE `guid`=232009; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+117; +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, 5287, 1739, '0', 0, 0, -13302.5830078125, 698.98614501953125, 3.634574174880981445, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 5287, 1739, '0', 0, 0, -13299.5595703125, 780.607666015625, 3.02025008201599121, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 5287, 1739, '0', 0, 0, -13239.72265625, 727.53302001953125, 3.23460698127746582, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+3, 180405, 0, 5287, 1739, '0', 0, 0, -13223.5283203125, 788.5, 5.459138393402099609, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+4, 180405, 0, 5287, 1739, '0', 0, 0, -13211.5107421875, 765.31597900390625, 5.095337390899658203, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+5, 180406, 0, 5287, 1739, '0', 0, 0, -13308.5556640625, 705.08331298828125, 3.753398418426513671, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+6, 180406, 0, 5287, 1739, '0', 0, 0, -13234.59765625, 755.421875, 5.076615810394287109, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+7, 180406, 0, 5287, 1739, '0', 0, 0, -13204.6357421875, 781.25518798828125, 5.225908279418945312, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+8, 180406, 0, 5287, 1739, '0', 0, 0, -13218.87890625, 806.029541015625, 6.254114627838134765, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+9, 180407, 0, 5287, 1739, '0', 0, 0, -13292.28515625, 724.795166015625, 5.316525459289550781, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+10, 180407, 0, 5287, 1739, '0', 0, 0, -13217.361328125, 748.685791015625, 5.225267887115478515, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+11, 180407, 0, 5287, 1739, '0', 0, 0, -13228.75, 772.0694580078125, 5.126125335693359375, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+12, 180407, 0, 5287, 1739, '0', 0, 0, -13196.8818359375, 797.951416015625, 6.27034616470336914, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+13, 180408, 0, 5287, 1739, '0', 0, 0, -13276.357421875, 786.2430419921875, 5.884910106658935546, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+14, 180408, 0, 5287, 1739, '0', 0, 0, -13291.236328125, 789.27081298828125, 6.02010965347290039, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+15, 180408, 0, 5287, 1739, '0', 0, 0, -13276.1494140625, 776.24481201171875, 5.874763011932373046, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+16, 180408, 0, 5287, 1739, '0', 0, 0, -13283.646484375, 789.3125, 6.099256038665771484, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+17, 180410, 0, 5287, 1739, '0', 0, 0, -13291.9384765625, 721.97222900390625, 4.825801849365234375, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+18, 180411, 0, 5287, 1739, '0', 0, 0, -13284.3818359375, 795.5086669921875, 11.64819145202636718, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+19, 180426, 0, 5287, 1739, '0', 0, 0, -13281.548828125, 725.546875, 17.41829872131347656, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 51886), -- Bat01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+20, 180426, 0, 5287, 1739, '0', 0, 0, -13287.9580078125, 719.37677001953125, 14.69112682342529296, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 51886), -- Bat01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+21, 180426, 0, 5287, 1739, '0', 0, 0, -13290.03515625, 725.5555419921875, 16.37644767761230468, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 51886), -- Bat01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+22, 180426, 0, 5287, 1739, '0', 0, 0, -13285.1767578125, 717.8836669921875, 12.55963611602783203, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 51886), -- Bat01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+23, 180427, 0, 5287, 1739, '0', 0, 0, -13283.40625, 724.8975830078125, 15.27476310729980468, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 51886), -- Bat02 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+24, 180427, 0, 5287, 1739, '0', 0, 0, -13279.923828125, 721.0694580078125, 14.7591552734375, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 51886), -- Bat02 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+25, 180427, 0, 5287, 1739, '0', 0, 0, -13284.40625, 723.578125, 14.42632389068603515, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- Bat02 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+26, 180427, 0, 5287, 1739, '0', 0, 0, -13281.611328125, 723.482666015625, 13.838653564453125, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 51886), -- Bat02 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+27, 180471, 0, 5287, 1739, '0', 0, 0, -13302.7607421875, 698.45831298828125, 9.479153633117675781, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+28, 180471, 0, 5287, 1739, '0', 0, 0, -13315.7392578125, 719.326416015625, 11.37168598175048828, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+29, 180471, 0, 5287, 1739, '0', 0, 0, -13320.111328125, 710.84552001953125, 11.18074417114257812, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+30, 180471, 0, 5287, 1739, '0', 0, 0, -13310.4306640625, 705.6649169921875, 9.323391914367675781, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+31, 180471, 0, 5287, 1739, '0', 0, 0, -13312.013671875, 707.54168701171875, 11.35943889617919921, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+32, 180471, 0, 5287, 1739, '0', 0, 0, -13302.951171875, 699.46527099609375, 9.535321235656738281, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+33, 180471, 0, 5287, 1739, '0', 0, 0, -13318.41015625, 705.45489501953125, 11.13893508911132812, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+34, 180471, 0, 5287, 1739, '0', 0, 0, -13313.7119140625, 712.92364501953125, 11.33930778503417968, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+35, 180471, 0, 5287, 1739, '0', 0, 0, -13308.0595703125, 704.32464599609375, 9.501451492309570312, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+36, 180471, 0, 5287, 1739, '0', 0, 0, -13263.1845703125, 690.18927001953125, 10.23772430419921875, 6.14356088638305664, 0, 0, -0.06975555419921875, 0.997564136981964111, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+37, 180471, 0, 5287, 1739, '0', 0, 0, -13269.0517578125, 697.092041015625, 10.18217182159423828, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+38, 180471, 0, 5287, 1739, '0', 0, 0, -13275.6630859375, 690.36456298828125, 10.27999687194824218, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+39, 180471, 0, 5287, 1739, '0', 0, 0, -13263.28125, 697.1180419921875, 10.05506610870361328, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+40, 180471, 0, 5287, 1739, '0', 0, 0, -13256.00390625, 689.82293701171875, 9.959278106689453125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+41, 180471, 0, 5287, 1739, '0', 0, 0, -13317.361328125, 724.73614501953125, 11.30148601531982421, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+42, 180471, 0, 5287, 1739, '0', 0, 0, -13323.8232421875, 722.640625, 11.25609207153320312, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+43, 180471, 0, 5287, 1739, '0', 0, 0, -13268.8330078125, 690.38018798828125, 10.38430595397949218, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+44, 180471, 0, 5287, 1739, '0', 0, 0, -13322.0830078125, 717.045166015625, 11.251220703125, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+45, 180471, 0, 5287, 1739, '0', 0, 0, -13275.576171875, 697.046875, 10.24715900421142578, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+46, 180471, 0, 5287, 1739, '0', 0, 0, -13321.0419921875, 769.07989501953125, 8.513380050659179687, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+47, 180471, 0, 5287, 1739, '0', 0, 0, -13237.875, 721.5242919921875, 8.26969146728515625, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+48, 180471, 0, 5287, 1739, '0', 0, 0, -13261.1982421875, 746.01043701171875, 7.367527484893798828, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+49, 180471, 0, 5287, 1739, '0', 0, 0, -13315.0830078125, 773.95831298828125, 8.664608955383300781, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+50, 180471, 0, 5287, 1739, '0', 0, 0, -13321.3017578125, 758.63714599609375, 8.4150848388671875, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+51, 180471, 0, 5287, 1739, '0', 0, 0, -13302.3330078125, 775.7430419921875, 8.980707168579101562, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+52, 180471, 0, 5287, 1739, '0', 0, 0, -13225.9931640625, 690.58160400390625, 9.329193115234375, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+53, 180471, 0, 5287, 1739, '0', 0, 0, -13304.12890625, 775.71356201171875, 9.254458427429199218, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+54, 180471, 0, 5287, 1739, '0', 0, 0, -13250.4130859375, 696.59375, 10.46831989288330078, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+55, 180471, 0, 5287, 1739, '0', 0, 0, -13243.607421875, 689.8367919921875, 9.910434722900390625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+56, 180471, 0, 5287, 1739, '0', 0, 0, -13237.7119140625, 726.37847900390625, 8.383161544799804687, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+57, 180471, 0, 5287, 1739, '0', 0, 0, -13238.021484375, 689.859375, 9.887042999267578125, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+58, 180471, 0, 5287, 1739, '0', 0, 0, -13246.3134765625, 713.31597900390625, 7.480349063873291015, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+59, 180471, 0, 5287, 1739, '0', 0, 0, -13295.3369140625, 775.70660400390625, 9.509516716003417968, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+60, 180471, 0, 5287, 1739, '0', 0, 0, -13264.4267578125, 748.32989501953125, 7.330601215362548828, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+61, 180471, 0, 5287, 1739, '0', 0, 0, -13298.9130859375, 787.0711669921875, 8.5334320068359375, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+62, 180471, 0, 5287, 1739, '0', 0, 0, -13243.6943359375, 696.5867919921875, 10.47141742706298828, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+63, 180471, 0, 5287, 1739, '0', 0, 0, -13300.4345703125, 775.717041015625, 9.571603775024414062, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+64, 180471, 0, 5287, 1739, '0', 0, 0, -13259.201171875, 745.4600830078125, 7.303742408752441406, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+65, 180471, 0, 5287, 1739, '0', 0, 0, -13238.021484375, 719.87152099609375, 8.25495147705078125, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+66, 180471, 0, 5287, 1739, '0', 0, 0, -13250.236328125, 689.8350830078125, 10.02149772644042968, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+67, 180471, 0, 5287, 1739, '0', 0, 0, -13298.91015625, 786.232666015625, 8.428644180297851562, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+68, 180471, 0, 5287, 1739, '0', 0, 0, -13229.21875, 738.79864501953125, 7.076912879943847656, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+69, 180471, 0, 5287, 1739, '0', 0, 0, -13247.048828125, 712.23614501953125, 7.434943199157714843, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+70, 180471, 0, 5287, 1739, '0', 0, 0, -13237.736328125, 728.11285400390625, 8.391241073608398437, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+71, 180471, 0, 5287, 1739, '0', 0, 0, -13298.9306640625, 785.3836669921875, 8.8099365234375, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+72, 180471, 0, 5287, 1739, '0', 0, 0, -13237.673828125, 729.703125, 8.780866622924804687, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+73, 180471, 0, 5287, 1739, '0', 0, 0, -13238.15625, 696.58856201171875, 10.46476554870605468, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+74, 180471, 0, 5287, 1739, '0', 0, 0, -13313.4384765625, 775.6632080078125, 8.988854408264160156, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+75, 180471, 0, 5287, 1739, '0', 0, 0, -13315.5380859375, 758.55206298828125, 8.662702560424804687, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+76, 180471, 0, 5287, 1739, '0', 0, 0, -13298.853515625, 781.78472900390625, 8.717838287353515625, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+77, 180471, 0, 5287, 1739, '0', 0, 0, -13315.294921875, 769.0225830078125, 8.739010810852050781, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+78, 180471, 0, 5287, 1739, '0', 0, 0, -13245.0380859375, 714.2569580078125, 7.772821426391601562, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+79, 180471, 0, 5287, 1739, '0', 0, 0, -13320.91015625, 774.00518798828125, 8.491059303283691406, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+80, 180471, 0, 5287, 1739, '0', 0, 0, -13296.9169921875, 775.703125, 9.668292045593261718, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+81, 180471, 0, 5287, 1739, '0', 0, 0, -13241.1767578125, 715.5538330078125, 7.437693119049072265, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+82, 180471, 0, 5287, 1739, '0', 0, 0, -13298.9306640625, 784.22918701171875, 8.839211463928222656, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+83, 180471, 0, 5287, 1739, '0', 0, 0, -13310.59765625, 775.65277099609375, 9.4824676513671875, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+84, 180471, 0, 5287, 1739, '0', 0, 0, -13220.9345703125, 693.53125, 9.39056396484375, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+85, 180471, 0, 5287, 1739, '0', 0, 0, -13238.12890625, 717.96875, 8.485479354858398437, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+86, 180471, 0, 5287, 1739, '0', 0, 0, -13265.0693359375, 749.67706298828125, 7.285068988800048828, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+87, 180471, 0, 5287, 1739, '0', 0, 0, -13243.66015625, 714.98089599609375, 7.656339168548583984, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+88, 180471, 0, 5287, 1739, '0', 0, 0, -13305.69140625, 775.68231201171875, 9.107005119323730468, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+89, 180471, 0, 5287, 1739, '0', 0, 0, -13315.4580078125, 763.26739501953125, 8.729810714721679687, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+90, 180471, 0, 5287, 1739, '0', 0, 0, -13321.15625, 763.42535400390625, 8.476731300354003906, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+91, 180471, 0, 5287, 1739, '0', 0, 0, -13298.794921875, 779.8038330078125, 8.604342460632324218, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+92, 180471, 0, 5287, 1739, '0', 0, 0, -13313.978515625, 790.17535400390625, 10.03491687774658203, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+93, 180471, 0, 5287, 1739, '0', 0, 0, -13310.8681640625, 790.25347900390625, 10.08962535858154296, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+94, 180471, 0, 5287, 1739, '0', 0, 0, -13222.8017578125, 743.33331298828125, 6.331699371337890625, 3.647741317749023437, 0, 0, -0.96814727783203125, 0.250381410121917724, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+95, 180471, 0, 5287, 1739, '0', 0, 0, -13210.451171875, 699.67364501953125, 9.27510833740234375, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+96, 180471, 0, 5287, 1739, '0', 0, 0, -13215.3330078125, 696.765625, 9.288421630859375, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+97, 180471, 0, 5287, 1739, '0', 0, 0, -13320.2919921875, 790.15625, 10.04313182830810546, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+98, 180471, 0, 5287, 1739, '0', 0, 0, -13322.7080078125, 790.18927001953125, 10.16544628143310546, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+99, 180471, 0, 5287, 1739, '0', 0, 0, -13299.0244140625, 790.34722900390625, 10.33271026611328125, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+100, 180471, 0, 5287, 1739, '0', 0, 0, -13309.3232421875, 790.26214599609375, 10.10956859588623046, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+101, 180471, 0, 5287, 1739, '0', 0, 0, -13295.94140625, 790.3975830078125, 10.00638580322265625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+102, 180471, 0, 5287, 1739, '0', 0, 0, -13306.146484375, 790.2413330078125, 10.11559295654296875, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+103, 180472, 0, 5287, 1739, '0', 0, 0, -13306.4931640625, 702.9444580078125, 10.21372699737548828, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+104, 180472, 0, 5287, 1739, '0', 0, 0, -13262.7255859375, 747.515625, 8.165808677673339843, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+105, 180523, 0, 5287, 1739, '0', 0, 0, -13231.7744140625, 734.83856201171875, 3.494536876678466796, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 51886), -- Apple Bob (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+106, 207941, 0, 5287, 1739, '0', 0, 0, -13258.826171875, 752.46356201171875, 15.47326374053955078, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+107, 208069, 0, 5287, 1739, '0', 0, 0, -13263.19140625, 739.2430419921875, 5.132593154907226562, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+108, 208069, 0, 5287, 1739, '0', 0, 0, -13303.1181640625, 767.4930419921875, 5.324397563934326171, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+109, 208069, 0, 5287, 1739, '0', 0, 0, -13245.455078125, 742.888916015625, 5.063835620880126953, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+110, 208072, 0, 5287, 1739, '0', 0, 0, -13258.06640625, 735.75347900390625, 4.858164787292480468, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+111, 208072, 0, 5287, 1739, '0', 0, 0, -13240.28515625, 746.40802001953125, 4.869463920593261718, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+112, 208072, 0, 5287, 1739, '0', 0, 0, -13297.3056640625, 767.81427001953125, 5.191071033477783203, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+113, 208078, 0, 5287, 1739, '0', 0, 0, -13307.5, 767.5711669921875, 6.653748035430908203, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+114, 208078, 0, 5287, 1739, '0', 0, 0, -13291.1533203125, 767.0711669921875, 4.924769878387451171, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+115, 208078, 0, 5287, 1739, '0', 0, 0, -13251.75, 738.57464599609375, 5.221030712127685546, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+116, 208078, 0, 5287, 1739, '0', 0, 0, -13261.451171875, 744.3125, 4.582062244415283203, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 +(@OGUID+117, 208147, 0, 5287, 1739, '0', 0, 0, -13232.72265625, 725.55035400390625, 3.356358528137207031, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 51886); -- Candy Bucket (Area: Hardwrench Hideaway - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+117; +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), +(12, @OGUID+111), +(12, @OGUID+112), +(12, @OGUID+113), +(12, @OGUID+114), +(12, @OGUID+115), +(12, @OGUID+116), +(12, @OGUID+117); diff --git a/sql/updates/world/master/2023_11_22_03_world_the_cape_of_stranglethorn_booty_bay.sql b/sql/updates/world/master/2023_11_22_03_world_the_cape_of_stranglethorn_booty_bay.sql new file mode 100644 index 00000000000..a5e5c508004 --- /dev/null +++ b/sql/updates/world/master/2023_11_22_03_world_the_cape_of_stranglethorn_booty_bay.sql @@ -0,0 +1,97 @@ +SET @OGUID := 3005640; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=190103; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=190103; -- Candy Bucket + +-- Quests +UPDATE `quest_offer_reward` SET `VerifiedBuild`=51886 WHERE `ID`=12397; + +DELETE FROM `gameobject_queststarter` WHERE `id`=190103; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(190103, 12397, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=190103 AND `quest`=12397); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=190103; + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 231769 AND 231799; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231769 AND 231799; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+33; +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, 5287, 35, '0', 0, 0, -14455.8408203125, 480.71240234375, 16.39013481140136718, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 5287, 35, '0', 0, 0, -14447.5244140625, 516.3836669921875, 26.43097877502441406, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+2, 180406, 0, 5287, 35, '0', 0, 0, -14414.5, 525.33697509765625, 10.05939960479736328, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+3, 180406, 0, 5287, 35, '0', 0, 0, -14476.16015625, 461.171875, 36.54711151123046875, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+4, 180407, 0, 5287, 35, '0', 0, 0, -14477.6669921875, 488.01214599609375, 14.90494441986083984, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+5, 180411, 0, 5287, 35, '0', 0, 0, -14424.232421875, 470, 26.78550148010253906, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+6, 180411, 0, 5287, 35, '0', 0, 0, -14462.599609375, 487.209991455078125, 28.71769905090332031, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+7, 180415, 0, 5287, 35, '0', 0, 0, -14459.25390625, 482.09027099609375, 21.265472412109375, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+8, 180415, 0, 5287, 35, '0', 0, 0, -14457.900390625, 486.016998291015625, 15.87720012664794921, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+9, 180415, 0, 5287, 35, '0', 0, 0, -14460, 482.864990234375, 21.64749908447265625, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+10, 180415, 0, 5287, 35, '0', 0, 0, -14463.7998046875, 486.589996337890625, 21.636199951171875, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+11, 180415, 0, 5287, 35, '0', 0, 0, -14462.375, 485.703125, 21.32836151123046875, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+12, 180415, 0, 5287, 35, '0', 0, 0, -14453.7607421875, 494.274322509765625, 16.42455482482910156, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+13, 180415, 0, 5287, 35, '0', 0, 0, -14453.986328125, 494.36285400390625, 16.30660820007324218, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+14, 180415, 0, 5287, 35, '0', 0, 0, -14469.751953125, 481.3468017578125, 21.0760498046875, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+15, 180415, 0, 5287, 35, '0', 0, 0, -14469.646484375, 483.559906005859375, 16.48216819763183593, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+16, 180415, 0, 5287, 35, '0', 0, 0, -14466.09765625, 488.328125, 21.37956047058105468, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+17, 180415, 0, 5287, 35, '0', 0, 0, -14467.6845703125, 489.822906494140625, 21.65497207641601562, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+18, 180415, 0, 5287, 35, '0', 0, 0, -14468.72265625, 490.8038330078125, 21.46869468688964843, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+19, 180415, 0, 5287, 35, '0', 0, 0, -14463.146484375, 495.619781494140625, 15.77869033813476562, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 51886), -- CandleBlack01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+20, 180425, 0, 5287, 35, '0', 0, 0, -14451.599609375, 491.964996337890625, 16.42309951782226562, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 51886), -- SkullCandle01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+21, 180425, 0, 5287, 35, '0', 0, 0, -14455.275390625, 497.72796630859375, 16.4212646484375, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 51886), -- SkullCandle01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+22, 180425, 0, 5287, 35, '0', 0, 0, -14461.642578125, 487.55035400390625, 15.97133255004882812, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 51886), -- SkullCandle01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+23, 180425, 0, 5287, 35, '0', 0, 0, -14465.5244140625, 478.232635498046875, 21.2693328857421875, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 51886), -- SkullCandle01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+24, 180425, 0, 5287, 35, '0', 0, 0, -14469.517578125, 481.239593505859375, 21.26347160339355468, 0.994837164878845214, 0, 0, 0.477158546447753906, 0.878817260265350341, 120, 255, 1, 51886), -- SkullCandle01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+25, 180425, 0, 5287, 35, '0', 0, 0, -14464.6220703125, 485.65972900390625, 21.2722930908203125, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 51886), -- SkullCandle01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+26, 180425, 0, 5287, 35, '0', 0, 0, -14473.017578125, 493.423614501953125, 16.04327774047851562, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 51886), -- SkullCandle01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+27, 180425, 0, 5287, 35, '0', 0, 0, -14468.0732421875, 488.15625, 21.26880836486816406, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 51886), -- SkullCandle01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+28, 180425, 0, 5287, 35, '0', 0, 0, -14457.7744140625, 502.84027099609375, 15.95049858093261718, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 51886), -- SkullCandle01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+29, 180471, 0, 5287, 35, '0', 0, 0, -14467.8408203125, 492.973968505859375, 24.03863906860351562, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+30, 180472, 0, 5287, 35, '0', 0, 0, -14460.7001953125, 477.2139892578125, 22.01980018615722656, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+31, 180472, 0, 5287, 35, '0', 0, 0, -14459.5, 488.27099609375, 19.84510040283203125, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+32, 180523, 0, 5287, 35, '0', 0, 0, -14463.0986328125, 479.9761962890625, 20.72477340698242187, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 51886), -- Apple Bob (Area: Booty Bay - Difficulty: 0) CreateObject1 +(@OGUID+33, 190103, 0, 5287, 35, '0', 0, 0, -14456.39453125, 494.09564208984375, 15.126068115234375, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 51886); -- Candy Bucket (Area: Booty Bay - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+33; +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); |