diff options
3 files changed, 413 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_08_01_world_wetlands_swiftgear_station.sql b/sql/updates/world/master/2023_11_08_01_world_wetlands_swiftgear_station.sql new file mode 100644 index 00000000000..b6c6ea0a2f8 --- /dev/null +++ b/sql/updates/world/master/2023_11_08_01_world_wetlands_swiftgear_station.sql @@ -0,0 +1,131 @@ +SET @CGUID := 3000246; +SET @OGUID := 3004024; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208136; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208136; -- Candy Bucket + +-- Quests +DELETE FROM `quest_offer_reward` WHERE `ID`=28990; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28990, 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`=208136; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208136, 28990, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208136 AND `quest`=28990); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208136; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid`=@CGUID+0; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 22816, 0, 11, 5304, '0', 0, 0, 0, 0, -2870.8140625, -1486.9669189453125, 9.818784332275390625, 4.822881221771240234, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 51886); -- Black Cat (Area: Swiftgear Station - Difficulty: 0) CreateObject1 + +-- 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, 11, 5304, '0', 0, 0, -2871.520751953125, -1475.826416015625, 10.35446643829345703, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+1, 180406, 0, 11, 5304, '0', 0, 0, -2863.147705078125, -1489.1754150390625, 10.36012172698974609, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+2, 180407, 0, 11, 5304, '0', 0, 0, -2887.572998046875, -1500.888916015625, 10.53237438201904296, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+3, 180408, 0, 11, 5304, '0', 0, 0, -2871.435791015625, -1475.80908203125, 11.98334980010986328, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+4, 180415, 0, 11, 5304, '0', 0, 0, -2868.685791015625, -1509.7760009765625, 14.44237422943115234, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+5, 180415, 0, 11, 5304, '0', 0, 0, -2862.513916015625, -1518.3472900390625, 14.45221614837646484, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+6, 180415, 0, 11, 5304, '0', 0, 0, -2880.203125, -1491.095458984375, 11.87953567504882812, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+7, 180415, 0, 11, 5304, '0', 0, 0, -2867.8525390625, -1522.3489990234375, 14.44019603729248046, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+8, 180415, 0, 11, 5304, '0', 0, 0, -2880.5869140625, -1479.3125, 12.23726844787597656, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+9, 180415, 0, 11, 5304, '0', 0, 0, -2863.272705078125, -1512.657958984375, 14.44959831237792968, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+10, 180415, 0, 11, 5304, '0', 0, 0, -2877.557373046875, -1480, 11.96598625183105468, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+11, 180415, 0, 11, 5304, '0', 0, 0, -2874.010498046875, -1513.439208984375, 14.44103813171386718, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+12, 180415, 0, 11, 5304, '0', 0, 0, -2881.38720703125, -1486.109375, 11.737091064453125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+13, 180415, 0, 11, 5304, '0', 0, 0, -2879.092041015625, -1488.2379150390625, 11.72139739990234375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+14, 180415, 0, 11, 5304, '0', 0, 0, -2873.380126953125, -1519.34375, 14.45655536651611328, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+15, 180415, 0, 11, 5304, '0', 0, 0, -2851.666748046875, -1484.0711669921875, 11.46669292449951171, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+16, 180415, 0, 11, 5304, '0', 0, 0, -2874.710205078125, -1480.578125, 11.8100128173828125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+17, 180415, 0, 11, 5304, '0', 0, 0, -2860.548583984375, -1473.857666015625, 12.30389690399169921, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+18, 180415, 0, 11, 5304, '0', 0, 0, -2854.517333984375, -1486.359375, 11.2798776626586914, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+19, 180415, 0, 11, 5304, '0', 0, 0, -2864.932373046875, -1473.5208740234375, 12.31827831268310546, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+20, 180415, 0, 11, 5304, '0', 0, 0, -2860.64404296875, -1475.09375, 11.71836280822753906, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+21, 180415, 0, 11, 5304, '0', 0, 0, -2872.654541015625, -1478.0677490234375, 11.818939208984375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+22, 180415, 0, 11, 5304, '0', 0, 0, -2862.380126953125, -1487.28125, 11.5845956802368164, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+23, 180415, 0, 11, 5304, '0', 0, 0, -2865, -1474.7379150390625, 11.74198341369628906, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+24, 180415, 0, 11, 5304, '0', 0, 0, -2859.223876953125, -1486.8802490234375, 11.61402606964111328, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+25, 180426, 0, 11, 5304, '0', 0, 0, -2892.838623046875, -1496.1822509765625, 12.88392925262451171, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+26, 180426, 0, 11, 5304, '0', 0, 0, -2879.94091796875, -1492.217041015625, 10.54752254486083984, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+27, 180426, 0, 11, 5304, '0', 0, 0, -2844.62158203125, -1494.5242919921875, 10.80093860626220703, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+28, 180427, 0, 11, 5304, '0', 0, 0, -2886.838623046875, -1496.5694580078125, 10.93411159515380859, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+29, 180427, 0, 11, 5304, '0', 0, 0, -2892.541748046875, -1499.8836669921875, 10.63610267639160156, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+30, 180427, 0, 11, 5304, '0', 0, 0, -2841.208251953125, -1500.107666015625, 9.833813667297363281, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+31, 180471, 0, 11, 5304, '0', 0, 0, -2862.939208984375, -1502.0504150390625, 13.86891746520996093, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+32, 180471, 0, 11, 5304, '0', 0, 0, -2862.94970703125, -1501.3350830078125, 13.84463977813720703, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+33, 180471, 0, 11, 5304, '0', 0, 0, -2857.947998046875, -1496.0208740234375, 13.79524612426757812, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+34, 180471, 0, 11, 5304, '0', 0, 0, -2858.76904296875, -1473.578125, 16.10841751098632812, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+35, 180471, 0, 11, 5304, '0', 0, 0, -2861.322998046875, -1473.375, 16.10841751098632812, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+36, 180471, 0, 11, 5304, '0', 0, 0, -2866.859375, -1472.98095703125, 16.10841751098632812, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+37, 180471, 0, 11, 5304, '0', 0, 0, -2858.541748046875, -1496.032958984375, 13.80309104919433593, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+38, 180471, 0, 11, 5304, '0', 0, 0, -2865.7587890625, -1473.045166015625, 16.10841751098632812, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+39, 180471, 0, 11, 5304, '0', 0, 0, -2864.49658203125, -1473.0555419921875, 16.10841751098632812, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+40, 180471, 0, 11, 5304, '0', 0, 0, -2860.010498046875, -1473.4444580078125, 16.10841751098632812, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+41, 180472, 0, 11, 5304, '0', 0, 0, -2862.8369140625, -1473.1910400390625, 16.86874008178710937, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+42, 180523, 0, 11, 5304, '0', 0, 0, -2859.296875, -1470.263916015625, 12.07879161834716796, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Apple Bob (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+43, 185434, 0, 11, 5304, '0', 0, 0, -2865.798583984375, -1474.7899169921875, 10.15371227264404296, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 51886), -- Sitting Skeleton 01 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+44, 185436, 0, 11, 5304, '0', 0, 0, -2868.145751953125, -1474.3629150390625, 10.193450927734375, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 51886), -- Sitting Skeleton 03 (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+45, 208088, 0, 11, 5304, '0', 0, 0, -2867.85595703125, -1474.970458984375, 10.71336174011230468, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 120, 255, 1, 51886), -- Web Wide (Scale 0.5) (Area: Swiftgear Station - Difficulty: 0) CreateObject1 +(@OGUID+46, 208136, 0, 11, 5304, '0', 0, 0, -2864.1494140625, -1467.638916015625, 11.66132831573486328, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 51886); -- Candy Bucket (Area: Swiftgear Station - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid`=@CGUID+0; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(12, @CGUID+0); + +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_08_02_world_wetlands_greenwardens_grove.sql b/sql/updates/world/master/2023_11_08_02_world_wetlands_greenwardens_grove.sql new file mode 100644 index 00000000000..6b49ecb4766 --- /dev/null +++ b/sql/updates/world/master/2023_11_08_02_world_wetlands_greenwardens_grove.sql @@ -0,0 +1,133 @@ +SET @OGUID := 3004071; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208135; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208135; -- Candy Bucket + +-- Quests +DELETE FROM `quest_offer_reward` WHERE `ID`=28991; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28991, 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`=208135; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208135, 28991, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208135 AND `quest`=28991); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208135; + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 230567 AND 230597; +DELETE FROM `gameobject` WHERE `guid`=231997; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 230567 AND 230597; +DELETE FROM `game_event_gameobject` WHERE `guid`=231997; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+49; +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, 11, 5305, '0', 0, 0, -3213.479248046875, -2662.052001953125, 9.070924758911132812, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 11, 5305, '0', 0, 0, -3232.411376953125, -2775.147705078125, 21.12751579284667968, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 11, 5305, '0', 0, 0, -3332.526123046875, -2769.291748046875, 50.91151809692382812, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+3, 180405, 0, 11, 5305, '0', 0, 0, -3362.173583984375, -2760.395751953125, 50.91151046752929687, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+4, 180406, 0, 11, 5305, '0', 0, 0, -3221.060791015625, -2663.572998046875, 9.146597862243652343, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+5, 180406, 0, 11, 5305, '0', 0, 0, -3243.9306640625, -2783.625, 21.1275177001953125, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+6, 180406, 0, 11, 5305, '0', 0, 0, -3310.814208984375, -2724.295166015625, 20.48355865478515625, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+7, 180406, 0, 11, 5305, '0', 0, 0, -3323.234375, -2738.791748046875, 50.91151809692382812, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+8, 180407, 0, 11, 5305, '0', 0, 0, -3252.1025390625, -2775.182373046875, 13.22046947479248046, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+9, 180407, 0, 11, 5305, '0', 0, 0, -3352.677001953125, -2729.61279296875, 50.91151046752929687, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+10, 180411, 0, 11, 5305, '0', 0, 0, -3324.592041015625, -2747.569580078125, 33.90011215209960937, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+11, 180415, 0, 11, 5305, '0', 0, 0, -3248.569580078125, -2773.553955078125, 15.58920764923095703, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+12, 180415, 0, 11, 5305, '0', 0, 0, -3242.14404296875, -2765.060791015625, 13.6106119155883789, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+13, 180415, 0, 11, 5305, '0', 0, 0, -3240.859375, -2767.861083984375, 15.55647945404052734, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+14, 180415, 0, 11, 5305, '0', 0, 0, -3245.92529296875, -2776.13720703125, 17.70518302917480468, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+15, 180415, 0, 11, 5305, '0', 0, 0, -3250.772705078125, -2771.37158203125, 13.6251382827758789, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+16, 180415, 0, 11, 5305, '0', 0, 0, -3239.119873046875, -2771.40283203125, 17.81036567687988281, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+17, 180415, 0, 11, 5305, '0', 0, 0, -3237.520751953125, -2774.34375, 19.56087684631347656, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+18, 180415, 0, 11, 5305, '0', 0, 0, -3236.475830078125, -2776.578125, 20.82664299011230468, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+19, 180415, 0, 11, 5305, '0', 0, 0, -3241.513916015625, -2780.322998046875, 20.86226844787597656, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+20, 180415, 0, 11, 5305, '0', 0, 0, -3243.53466796875, -2778.623291015625, 19.52212715148925781, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+21, 180415, 0, 11, 5305, '0', 0, 0, -3326.447998046875, -2747.973876953125, 29.86408805847167968, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+22, 180415, 0, 11, 5305, '0', 0, 0, -3330.06591796875, -2759.635498046875, 29.86320686340332031, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+23, 180415, 0, 11, 5305, '0', 0, 0, -3324.5, -2762.130126953125, 27.62269020080566406, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+24, 180415, 0, 11, 5305, '0', 0, 0, -3327.538330078125, -2760.998291015625, 28.98279190063476562, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+25, 180415, 0, 11, 5305, '0', 0, 0, -3323.604248046875, -2748.55908203125, 28.94002342224121093, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+26, 180415, 0, 11, 5305, '0', 0, 0, -3320.611083984375, -2749.00341796875, 27.67959213256835937, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+27, 180425, 0, 11, 5305, '0', 0, 0, -3252.194580078125, -2772.4150390625, 15.58044147491455078, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 51886), -- SkullCandle01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+28, 180425, 0, 11, 5305, '0', 0, 0, -3223.494873046875, -2786.505126953125, 22.92118453979492187, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 51886), -- SkullCandle01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+29, 180426, 0, 11, 5305, '0', 0, 0, -3249.546875, -2744.600830078125, 22.19921302795410156, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+30, 180426, 0, 11, 5305, '0', 0, 0, -3286.579833984375, -2725.953125, 23.09676551818847656, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+31, 180426, 0, 11, 5305, '0', 0, 0, -3259.5556640625, -2748.614501953125, 22.60544776916503906, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+32, 180426, 0, 11, 5305, '0', 0, 0, -3217.671875, -2735.954833984375, 24.28947639465332031, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+33, 180426, 0, 11, 5305, '0', 0, 0, -3275.15283203125, -2757.25, 22.51864051818847656, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+34, 180426, 0, 11, 5305, '0', 0, 0, -3287.61279296875, -2752.53466796875, 23.10024452209472656, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+35, 180426, 0, 11, 5305, '0', 0, 0, -3286.763916015625, -2772.708251953125, 22.26169776916503906, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+36, 180427, 0, 11, 5305, '0', 0, 0, -3228.92529296875, -2715.498291015625, 21.38068389892578125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+37, 180427, 0, 11, 5305, '0', 0, 0, -3283.015625, -2711.333251953125, 22.24781227111816406, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+38, 180427, 0, 11, 5305, '0', 0, 0, -3239.19970703125, -2735.666748046875, 21.06899452209472656, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+39, 180427, 0, 11, 5305, '0', 0, 0, -3278.0869140625, -2729.6494140625, 20.86760139465332031, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+40, 180427, 0, 11, 5305, '0', 0, 0, -3271.005126953125, -2746.65283203125, 22.30317878723144531, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+41, 180427, 0, 11, 5305, '0', 0, 0, -3280.579833984375, -2762.423583984375, 22.71308326721191406, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+42, 180471, 0, 11, 5305, '0', 0, 0, -3234.76904296875, -2779.614501953125, 24.5140533447265625, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+43, 180471, 0, 11, 5305, '0', 0, 0, -3238.991455078125, -2782.720458984375, 24.60868072509765625, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+44, 180471, 0, 11, 5305, '0', 0, 0, -3238.005126953125, -2782.140625, 25.26064491271972656, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+45, 180471, 0, 11, 5305, '0', 0, 0, -3235.651123046875, -2780.366455078125, 25.1731414794921875, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+46, 180472, 0, 11, 5305, '0', 0, 0, -3236.607666015625, -2781.638916015625, 26.77636146545410156, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+47, 180472, 0, 11, 5305, '0', 0, 0, -3333.541748046875, -2752.298583984375, 35.06074905395507812, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+48, 180523, 0, 11, 5305, '0', 0, 0, -3235.24658203125, -2793.890625, 21.56790351867675781, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Apple Bob (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 +(@OGUID+49, 208135, 0, 11, 5305, '0', 0, 0, -3228.350830078125, -2796.87841796875, 21.12751388549804687, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 51886); -- Candy Bucket (Area: Greenwarden's Grove - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+49; +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); diff --git a/sql/updates/world/master/2023_11_08_03_world_wetlands_menethil_harbor.sql b/sql/updates/world/master/2023_11_08_03_world_wetlands_menethil_harbor.sql new file mode 100644 index 00000000000..e69999267a6 --- /dev/null +++ b/sql/updates/world/master/2023_11_08_03_world_wetlands_menethil_harbor.sql @@ -0,0 +1,149 @@ +SET @OGUID := 3004121; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=190044; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=190044; -- Candy Bucket + +-- Quests +UPDATE `quest_offer_reward` SET `VerifiedBuild`=51886 WHERE `ID`=12343; + +DELETE FROM `gameobject_queststarter` WHERE `id`=190044; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(190044, 12343, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=190044 AND `quest`=12343); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=190044; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+61; +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, 11, 150, '0', 0, 0, -3655.95654296875, -840.0711669921875, 27.72624397277832031, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 11, 150, '0', 0, 0, -3795.458251953125, -835.826416015625, 7.968945980072021484, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 11, 150, '0', 0, 0, -3824.989990234375, -843.39599609375, 1.734210014343261718, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+3, 180405, 0, 11, 150, '0', 0, 0, -3828.780029296875, -826.364990234375, 3.874840021133422851, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+4, 180406, 0, 11, 150, '0', 0, 0, -3647.244873046875, -836.54339599609375, -0.33513733744621276, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+5, 180406, 0, 11, 150, '0', 0, 0, -3802.330078125, -822.9739990234375, 7.506130218505859375, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+6, 180406, 0, 11, 150, '0', 0, 0, -3800.090087890625, -824.10797119140625, 1.734210014343261718, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+7, 180406, 0, 11, 150, '0', 0, 0, -3828.570068359375, -819.24700927734375, 3.868160009384155273, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+8, 180407, 0, 11, 150, '0', 0, 0, -3655.282958984375, -850.296875, -0.4669334590435028, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+9, 180407, 0, 11, 150, '0', 0, 0, -3807.85009765625, -843.60198974609375, 1.734210014343261718, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+10, 180407, 0, 11, 150, '0', 0, 0, -3839.39990234375, -840.97900390625, 7.506130218505859375, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+11, 180407, 0, 11, 150, '0', 0, 0, -3798.0869140625, -787.498291015625, 6.00261545181274414, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+12, 180410, 0, 11, 150, '0', 0, 0, -3804.469970703125, -841.08001708984375, 8.381130218505859375, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+13, 180411, 0, 11, 150, '0', 0, 0, -3797.550048828125, -823.8800048828125, 9.14875030517578125, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+14, 180411, 0, 11, 150, '0', 0, 0, -3828.39990234375, -822.9439697265625, 8.559020042419433593, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+15, 180415, 0, 11, 150, '0', 0, 0, -3812.199951171875, -831.093994140625, 1.42697000503540039, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 51886), -- CandleBlack01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+16, 180415, 0, 11, 150, '0', 0, 0, -3812.280029296875, -827.37200927734375, 1.403079986572265625, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+17, 180415, 0, 11, 150, '0', 0, 0, -3820.1201171875, -823.343994140625, 8.7096099853515625, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 51886), -- CandleBlack01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+18, 180415, 0, 11, 150, '0', 0, 0, -3820.030029296875, -830.96002197265625, 1.428159952163696289, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 51886), -- CandleBlack01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+19, 180415, 0, 11, 150, '0', 0, 0, -3819.929931640625, -827.25, 1.393519997596740722, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 51886), -- CandleBlack01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+20, 180415, 0, 11, 150, '0', 0, 0, -3826.625, -822.4617919921875, 4.433471202850341796, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 51886), -- CandleBlack01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+21, 180425, 0, 11, 150, '0', 0, 0, -3803.050048828125, -831.8280029296875, 8.450570106506347656, 3.647741317749023437, 0, 0, -0.96814727783203125, 0.250381410121917724, 120, 255, 1, 51886), -- SkullCandle01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+22, 180425, 0, 11, 150, '0', 0, 0, -3810.550048828125, -831.11297607421875, 1.863680005073547363, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- SkullCandle01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+23, 180425, 0, 11, 150, '0', 0, 0, -3810.409912109375, -827.4639892578125, 1.8694000244140625, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 51886), -- SkullCandle01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+24, 180425, 0, 11, 150, '0', 0, 0, -3813.68994140625, -838.41998291015625, 1.206840038299560546, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 51886), -- SkullCandle01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+25, 180425, 0, 11, 150, '0', 0, 0, -3819.219970703125, -838.343994140625, 1.207119941711425781, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 51886), -- SkullCandle01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+26, 180425, 0, 11, 150, '0', 0, 0, -3821.89990234375, -830.91998291015625, 1.887799978256225585, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- SkullCandle01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+27, 180425, 0, 11, 150, '0', 0, 0, -3820.47998046875, -822.6810302734375, 2.249219894409179687, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 51886), -- SkullCandle01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+28, 180425, 0, 11, 150, '0', 0, 0, -3821.820068359375, -827.2550048828125, 1.872979998588562011, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 51886), -- SkullCandle01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+29, 180425, 0, 11, 150, '0', 0, 0, -3836.510009765625, -837.85101318359375, 2.040560007095336914, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 51886), -- SkullCandle01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+30, 180425, 0, 11, 150, '0', 0, 0, -3826.639892578125, -823.22601318359375, 5.128640174865722656, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 51886), -- SkullCandle01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+31, 180425, 0, 11, 150, '0', 0, 0, -3848.80908203125, -837.59893798828125, -4.68501138687133789, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- SkullCandle01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+32, 180471, 0, 11, 150, '0', 0, 0, -3800.02001953125, -844.96197509765625, 9.838250160217285156, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+33, 180471, 0, 11, 150, '0', 0, 0, -3794.989990234375, -832.12701416015625, 3.634690046310424804, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+34, 180471, 0, 11, 150, '0', 0, 0, -3795.179931640625, -839.34197998046875, 3.690279960632324218, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+35, 180471, 0, 11, 150, '0', 0, 0, -3798.2900390625, -815.95501708984375, 9.573880195617675781, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+36, 180471, 0, 11, 150, '0', 0, 0, -3817.050048828125, -823.26397705078125, 14.07970046997070312, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+37, 180471, 0, 11, 150, '0', 0, 0, -3808.22998046875, -816.54302978515625, 9.247209548950195312, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+38, 180471, 0, 11, 150, '0', 0, 0, -3832.1298828125, -844.45098876953125, 9.567979812622070312, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+39, 180471, 0, 11, 150, '0', 0, 0, -3828.050048828125, -836.81097412109375, 14.04920005798339843, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+40, 180471, 0, 11, 150, '0', 0, 0, -3823.889892578125, -816.2860107421875, 9.184100151062011718, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+41, 180471, 0, 11, 150, '0', 0, 0, -3833.510009765625, -815.35601806640625, 9.56497955322265625, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+42, 180471, 0, 11, 150, '0', 0, 0, -3851.639892578125, -844.04498291015625, 9.662079811096191406, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+43, 180471, 0, 11, 150, '0', 0, 0, -3851.39990234375, -827, 9.68350982666015625, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+44, 180472, 0, 11, 150, '0', 0, 0, -3808.159912109375, -843.52801513671875, 12.14799976348876953, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+45, 180472, 0, 11, 150, '0', 0, 0, -3798.679931640625, -831.17401123046875, 10.18290042877197265, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+46, 180472, 0, 11, 150, '0', 0, 0, -3798.85009765625, -840.22198486328125, 10.31330013275146484, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+47, 180472, 0, 11, 150, '0', 0, 0, -3795.219970703125, -835.73602294921875, 7.179299831390380859, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+48, 180472, 0, 11, 150, '0', 0, 0, -3803.760009765625, -815.9169921875, 10.3601999282836914, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+49, 180472, 0, 11, 150, '0', 0, 0, -3824.64990234375, -843.3489990234375, 12.08300018310546875, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+50, 180472, 0, 11, 150, '0', 0, 0, -3806.469970703125, -823.41302490234375, 15.69680023193359375, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+51, 180472, 0, 11, 150, '0', 0, 0, -3816.090087890625, -815.70098876953125, 10.20779991149902343, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+52, 180472, 0, 11, 150, '0', 0, 0, -3844.3798828125, -827.16302490234375, 10.26949977874755859, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+53, 180472, 0, 11, 150, '0', 0, 0, -3832.360107421875, -823.1820068359375, 11.97789955139160156, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+54, 180472, 0, 11, 150, '0', 0, 0, -3843.5, -843.9639892578125, 10.22949981689453125, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+55, 180472, 0, 11, 150, '0', 0, 0, -3836.1201171875, -843.48602294921875, 10.16030025482177734, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+56, 180472, 0, 11, 150, '0', 0, 0, -3835.5, -827.33502197265625, 10.25080013275146484, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+57, 180472, 0, 11, 150, '0', 0, 0, -3827.919921875, -815.46697998046875, 10.21090030670166015, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+58, 180472, 0, 11, 150, '0', 0, 0, -3845.580078125, -836.67901611328125, 14.76570034027099609, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+59, 180472, 0, 11, 150, '0', 0, 0, -3850.239990234375, -836.24700927734375, 11.91759967803955078, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+60, 180523, 0, 11, 150, '0', 0, 0, -3823.929931640625, -834.99298095703125, 0.64826202392578125, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 51886), -- Apple Bob (Area: Menethil Harbor - Difficulty: 0) CreateObject1 +(@OGUID+61, 190044, 0, 11, 150, '0', 0, 0, -3828.860107421875, -837.22698974609375, 1.809499979019165039, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 51886); -- Candy Bucket (Area: Menethil Harbor - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+61; +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); |