diff options
author | Meji <alvaro.megias@outlook.com> | 2023-11-08 02:46:59 +0100 |
---|---|---|
committer | Meji <alvaro.megias@outlook.com> | 2023-11-08 02:46:59 +0100 |
commit | 6d65f3e0132d20d2f104d9d439ace3110ffe3ddf (patch) | |
tree | 9118fbeb83449076d76730a4ca6ec7a7086174ec | |
parent | 82de79e3867bba423ec5d4870c4254164a2baeb1 (diff) |
DB/SearingGorge: Added Hallows End spawns
-rw-r--r-- | sql/updates/world/master/2023_11_08_08_world_searing_gorge_iron_summit.sql | 249 |
1 files changed, 249 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_08_08_world_searing_gorge_iron_summit.sql b/sql/updates/world/master/2023_11_08_08_world_searing_gorge_iron_summit.sql new file mode 100644 index 00000000000..34659bf644b --- /dev/null +++ b/sql/updates/world/master/2023_11_08_08_world_searing_gorge_iron_summit.sql @@ -0,0 +1,249 @@ +SET @OGUID := 3004444; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208138; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=208138; -- Candy Bucket + +-- Quests +DELETE FROM `quest_offer_reward` WHERE `ID`=28965; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28965, 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`=208138; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208138, 28965, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208138 AND `quest`=28965); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208138; + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 231181 AND 231279; +DELETE FROM `gameobject` WHERE `guid`=232006; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231181 AND 231279; +DELETE FROM `game_event_gameobject` WHERE `guid`=232006; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+107; +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, 51, 5628, '0', 0, 0, -7107.51220703125, -1326.02783203125, 246.0437774658203125, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 51, 5628, '0', 0, 0, -7120.57470703125, -1188.876708984375, 308.032318115234375, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 51, 5628, '0', 0, 0, -7095.3681640625, -1192.21533203125, 325.77069091796875, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+3, 180405, 0, 51, 5628, '0', 0, 0, -7117.34228515625, -1259.9930419921875, 274.82403564453125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+4, 180406, 0, 51, 5628, '0', 0, 0, -7105.09716796875, -1205.53125, 326.203460693359375, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+5, 180406, 0, 51, 5628, '0', 0, 0, -7110.77783203125, -1208.6441650390625, 307.380615234375, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+6, 180406, 0, 51, 5628, '0', 0, 0, -7099.0244140625, -1301.0572509765625, 263.53094482421875, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+7, 180406, 0, 51, 5628, '0', 0, 0, -7116.83154296875, -1241.3853759765625, 288.814361572265625, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+8, 180407, 0, 51, 5628, '0', 0, 0, -7127.267578125, -1234.9757080078125, 290.513671875, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+9, 180407, 0, 51, 5628, '0', 0, 0, -7082.7880859375, -1188.001708984375, 326.045562744140625, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+10, 180407, 0, 51, 5628, '0', 0, 0, -7093.703125, -1277.185791015625, 268.135650634765625, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+11, 180408, 0, 51, 5628, '0', 0, 0, -7091.20654296875, -1266.6788330078125, 272.1671142578125, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+12, 180411, 0, 51, 5628, '0', 0, 0, -7110.861328125, -1205.5052490234375, 315.450653076171875, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+13, 180415, 0, 51, 5628, '0', 0, 0, -7080.11474609375, -1193.998291015625, 324.613922119140625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+14, 180415, 0, 51, 5628, '0', 0, 0, -7087.7431640625, -1216.93408203125, 323.594818115234375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+15, 180415, 0, 51, 5628, '0', 0, 0, -7101.19287109375, -1187.8367919921875, 323.57794189453125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+16, 180415, 0, 51, 5628, '0', 0, 0, -7080.15087890625, -1213.8629150390625, 324.1241455078125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+17, 180415, 0, 51, 5628, '0', 0, 0, -7111.0712890625, -1192.0035400390625, 323.25640869140625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+18, 180415, 0, 51, 5628, '0', 0, 0, -7106.44091796875, -1217.0572509765625, 325.47210693359375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+19, 180415, 0, 51, 5628, '0', 0, 0, -7102.96875, -1217.03125, 325.42529296875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+20, 180415, 0, 51, 5628, '0', 0, 0, -7080.11962890625, -1202.4930419921875, 324.327239990234375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+21, 180415, 0, 51, 5628, '0', 0, 0, -7090.626953125, -1216.9375, 324.043487548828125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+22, 180415, 0, 51, 5628, '0', 0, 0, -7097.21728515625, -1204.6597900390625, 316.000701904296875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+23, 180415, 0, 51, 5628, '0', 0, 0, -7102.06591796875, -1204.8629150390625, 312.007781982421875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+24, 180415, 0, 51, 5628, '0', 0, 0, -7108.40625, -1198.782958984375, 308.8804931640625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+25, 180415, 0, 51, 5628, '0', 0, 0, -7100.080078125, -1204.7239990234375, 313.653533935546875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+26, 180415, 0, 51, 5628, '0', 0, 0, -7103.77587890625, -1187.2742919921875, 323.26080322265625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+27, 180415, 0, 51, 5628, '0', 0, 0, -7105.93212890625, -1205.2916259765625, 309.329498291015625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+28, 180415, 0, 51, 5628, '0', 0, 0, -7081.7587890625, -1216.9410400390625, 323.97808837890625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+29, 180415, 0, 51, 5628, '0', 0, 0, -7110.54345703125, -1215.26220703125, 325.034393310546875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+30, 180415, 0, 51, 5628, '0', 0, 0, -7102.595703125, -1199.2725830078125, 312.521881103515625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+31, 180415, 0, 51, 5628, '0', 0, 0, -7111.35400390625, -1187.654541015625, 322.512725830078125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+32, 180415, 0, 51, 5628, '0', 0, 0, -7122.55029296875, -1190.1197509765625, 306.530426025390625, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+33, 180415, 0, 51, 5628, '0', 0, 0, -7086.63525390625, -1187.2569580078125, 324.38555908203125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+34, 180415, 0, 51, 5628, '0', 0, 0, -7080.10400390625, -1210.7742919921875, 324.1241455078125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+35, 180415, 0, 51, 5628, '0', 0, 0, -7085.001953125, -1216.921875, 323.51165771484375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+36, 180415, 0, 51, 5628, '0', 0, 0, -7104.15478515625, -1199.0416259765625, 311.271759033203125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+37, 180415, 0, 51, 5628, '0', 0, 0, -7106.7275390625, -1186.7847900390625, 322.86767578125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+38, 180415, 0, 51, 5628, '0', 0, 0, -7110.29345703125, -1270.8836669921875, 273.07177734375, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+39, 180415, 0, 51, 5628, '0', 0, 0, -7091.689453125, -1204.546875, 320.288482666015625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+40, 180415, 0, 51, 5628, '0', 0, 0, -7111.30908203125, -1189.6754150390625, 322.85833740234375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+41, 180415, 0, 51, 5628, '0', 0, 0, -7108.00537109375, -1205.68408203125, 307.956451416015625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+42, 180415, 0, 51, 5628, '0', 0, 0, -7091.6162109375, -1199.5521240234375, 320.38970947265625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+43, 180415, 0, 51, 5628, '0', 0, 0, -7080.142578125, -1207.8228759765625, 324.1241455078125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+44, 180415, 0, 51, 5628, '0', 0, 0, -7111.1650390625, -1208.7864990234375, 324.31103515625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+45, 180415, 0, 51, 5628, '0', 0, 0, -7088.58154296875, -1199.6910400390625, 322.709136962890625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+46, 180415, 0, 51, 5628, '0', 0, 0, -7105.90966796875, -1198.7742919921875, 309.776702880859375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+47, 180415, 0, 51, 5628, '0', 0, 0, -7098.43408203125, -1188.2447509765625, 323.923126220703125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+48, 180415, 0, 51, 5628, '0', 0, 0, -7080.1318359375, -1191.592041015625, 324.613922119140625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+49, 180415, 0, 51, 5628, '0', 0, 0, -7122.21337890625, -1190.032958984375, 306.61334228515625, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+50, 180415, 0, 51, 5628, '0', 0, 0, -7093.14404296875, -1187.8038330078125, 324.13043212890625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+51, 180415, 0, 51, 5628, '0', 0, 0, -7089.9130859375, -1187.545166015625, 324.257080078125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+52, 180415, 0, 51, 5628, '0', 0, 0, -7095.7255859375, -1188.0555419921875, 324.029205322265625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+53, 180415, 0, 51, 5628, '0', 0, 0, -7080.07666015625, -1196.6180419921875, 324.613922119140625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+54, 180415, 0, 51, 5628, '0', 0, 0, -7080.109375, -1199.4132080078125, 324.571929931640625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+55, 180415, 0, 51, 5628, '0', 0, 0, -7109.80712890625, -1186.5989990234375, 322.474395751953125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+56, 180415, 0, 51, 5628, '0', 0, 0, -7110.939453125, -1201.3333740234375, 324.242095947265625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+57, 180415, 0, 51, 5628, '0', 0, 0, -7097.453125, -1199.404541015625, 316.18487548828125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+58, 180415, 0, 51, 5628, '0', 0, 0, -7110.1181640625, -1270.57470703125, 272.932342529296875, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+59, 180415, 0, 51, 5628, '0', 0, 0, -7094.2255859375, -1216.88720703125, 324.524688720703125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+60, 180415, 0, 51, 5628, '0', 0, 0, -7104.05908203125, -1205.0816650390625, 310.741363525390625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+61, 180415, 0, 51, 5628, '0', 0, 0, -7122.31591796875, -1190.34033203125, 306.333709716796875, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+62, 180415, 0, 51, 5628, '0', 0, 0, -7096.96533203125, -1216.8975830078125, 324.806976318359375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+63, 180415, 0, 51, 5628, '0', 0, 0, -7111.53662109375, -1205.1944580078125, 323.937591552734375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+64, 180415, 0, 51, 5628, '0', 0, 0, -7110.9306640625, -1212.1180419921875, 324.6832275390625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+65, 180415, 0, 51, 5628, '0', 0, 0, -7100.533203125, -1199.407958984375, 314.010986328125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+66, 180415, 0, 51, 5628, '0', 0, 0, -7110.53466796875, -1197.4132080078125, 324.18145751953125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+67, 180415, 0, 51, 5628, '0', 0, 0, -7094.82470703125, -1199.40625, 318.045379638671875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+68, 180415, 0, 51, 5628, '0', 0, 0, -7088.56591796875, -1204.4288330078125, 322.662200927734375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+69, 180415, 0, 51, 5628, '0', 0, 0, -7080.16162109375, -1205.3333740234375, 324.1241455078125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+70, 180415, 0, 51, 5628, '0', 0, 0, -7094.68212890625, -1204.564208984375, 317.96038818359375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+71, 180415, 0, 51, 5628, '0', 0, 0, -7100.03466796875, -1216.9635009765625, 325.123046875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+72, 180415, 0, 51, 5628, '0', 0, 0, -7110.83837890625, -1194.59033203125, 323.698699951171875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+73, 180415, 0, 51, 5628, '0', 0, 0, -7108.99462890625, -1216.982666015625, 325.30474853515625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+74, 180425, 0, 51, 5628, '0', 0, 0, -7131.689453125, -1210.62158203125, 302.27880859375, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+75, 180425, 0, 51, 5628, '0', 0, 0, -7099.0400390625, -1332.3350830078125, 249.030548095703125, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+76, 180425, 0, 51, 5628, '0', 0, 0, -7130.3125, -1235.4288330078125, 293.651336669921875, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+77, 180425, 0, 51, 5628, '0', 0, 0, -7047.1630859375, -1216.40283203125, 267.647308349609375, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+78, 180425, 0, 51, 5628, '0', 0, 0, -7097.5693359375, -1299.8385009765625, 265.73175048828125, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+79, 180425, 0, 51, 5628, '0', 0, 0, -7102.48974609375, -1277.32470703125, 270.63525390625, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+80, 180425, 0, 51, 5628, '0', 0, 0, -7095.3505859375, -1276.7396240234375, 270.13934326171875, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+81, 180425, 0, 51, 5628, '0', 0, 0, -7111.48095703125, -1186.5103759765625, 324.82354736328125, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+82, 180425, 0, 51, 5628, '0', 0, 0, -7067.673828125, -1236.19970703125, 269.3179931640625, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+83, 180425, 0, 51, 5628, '0', 0, 0, -7110.15478515625, -1199.4879150390625, 309.272796630859375, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+84, 180425, 0, 51, 5628, '0', 0, 0, -7109.07470703125, -1238.9739990234375, 290.799530029296875, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+85, 180425, 0, 51, 5628, '0', 0, 0, -7080.68603515625, -1187.3697509765625, 327.14654541015625, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+86, 180425, 0, 51, 5628, '0', 0, 0, -7080.45654296875, -1216.7222900390625, 326.67999267578125, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+87, 180425, 0, 51, 5628, '0', 0, 0, -7091.08154296875, -1237.4375, 280.224029541015625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+88, 180425, 0, 51, 5628, '0', 0, 0, -7105.7744140625, -1326.7274169921875, 248.38238525390625, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+89, 180425, 0, 51, 5628, '0', 0, 0, -7110.32275390625, -1216.6822509765625, 327.7646484375, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+90, 180425, 0, 51, 5628, '0', 0, 0, -7031.98095703125, -1168.923583984375, 247.06890869140625, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+91, 180425, 0, 51, 5628, '0', 0, 0, -7037.392578125, -1162.421875, 247.6460723876953125, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 51886), -- SkullCandle01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+92, 180427, 0, 51, 5628, '0', 0, 0, -7095.875, -1202.0555419921875, 321.97967529296875, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 51886), -- Bat02 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+93, 180427, 0, 51, 5628, '0', 0, 0, -7092.53125, -1201.748291015625, 319.841339111328125, 2.914689540863037109, 0, 0, 0.993571281433105468, 0.113208353519439697, 120, 255, 1, 51886), -- Bat02 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+94, 180427, 0, 51, 5628, '0', 0, 0, -7094.2744140625, -1201.560791015625, 325.39727783203125, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- Bat02 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+95, 180427, 0, 51, 5628, '0', 0, 0, -7095.30224609375, -1201.001708984375, 323.85028076171875, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- Bat02 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+96, 180427, 0, 51, 5628, '0', 0, 0, -7093.28125, -1202.4635009765625, 323.901763916015625, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 51886), -- Bat02 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+97, 180427, 0, 51, 5628, '0', 0, 0, -7094.09912109375, -1200.51220703125, 327.6461181640625, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 51886), -- Bat02 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+98, 180471, 0, 51, 5628, '0', 0, 0, -7124.38037109375, -1189.5833740234375, 308.824127197265625, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+99, 180471, 0, 51, 5628, '0', 0, 0, -7113.36474609375, -1264.8125, 275.280670166015625, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+100, 180471, 0, 51, 5628, '0', 0, 0, -7121.8212890625, -1189.8992919921875, 308.861236572265625, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+101, 180471, 0, 51, 5628, '0', 0, 0, -7120.6494140625, -1268.7899169921875, 275.309326171875, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+102, 180471, 0, 51, 5628, '0', 0, 0, -7116.7431640625, -1276.0242919921875, 275.336181640625, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+103, 180471, 0, 51, 5628, '0', 0, 0, -7109.42724609375, -1272.1007080078125, 275.277252197265625, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+104, 180472, 0, 51, 5628, '0', 0, 0, -7111.73291015625, -1268.6441650390625, 275.634002685546875, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+105, 180523, 0, 51, 5628, '0', 0, 0, -7112.37353515625, -1197.8697509765625, 307.289337158203125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Apple Bob (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+106, 185434, 0, 51, 5628, '0', 0, 0, -7122.82470703125, -1188.1978759765625, 308.28125, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 51886), -- Sitting Skeleton 01 (Area: Iron Summit - Difficulty: 0) CreateObject1 +(@OGUID+107, 208138, 0, 51, 5628, '0', 0, 0, -7082.07275390625, -1203.7899169921875, 324.168853759765625, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 51886); -- Candy Bucket (Area: Iron Summit - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+107; +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); |