diff options
3 files changed, 565 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_08_09_world_badlands_fuselight.sql b/sql/updates/world/master/2023_11_08_09_world_badlands_fuselight.sql new file mode 100644 index 00000000000..f8131965492 --- /dev/null +++ b/sql/updates/world/master/2023_11_08_09_world_badlands_fuselight.sql @@ -0,0 +1,261 @@ +SET @CGUID := 3000296; +SET @OGUID := 3004552; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208137; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=208137; -- Candy Bucket + +-- Quests +DELETE FROM `quest_offer_reward` WHERE `ID`=28955; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28955, 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`=208137; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208137, 28955, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208137 AND `quest`=28955); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208137; + +-- 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, 3, 5496, '0', 0, 0, 0, 0, -6611.26169921875, -3925.318349609375, 378.753109130859375, 6.03973245620727539, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 51886); -- Black Cat (Area: Fuselight - Difficulty: 0) CreateObject1 (possible waypoints or random movement) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 231018 AND 231117; +DELETE FROM `gameobject` WHERE `guid`=232004; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231018 AND 231117; +DELETE FROM `game_event_gameobject` WHERE `guid`=232004; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+108; +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, 3, 5496, '0', 0, 0, -6632.92529296875, -3929.3056640625, 381.0665283203125, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 3, 5496, '0', 0, 0, -6589.0556640625, -3838.838623046875, 379.7763671875, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 3, 5496, '0', 0, 0, -6595.0693359375, -3928.560791015625, 381.683990478515625, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+3, 180405, 0, 3, 1898, '0', 0, 0, -6486.390625, -3765.482666015625, 329.17230224609375, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Dustwind Gulch - Difficulty: 0) CreateObject1 +(@OGUID+4, 180406, 0, 3, 5496, '0', 0, 0, -6636.84033203125, -3834.989501953125, 381.67694091796875, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+5, 180406, 0, 3, 5496, '0', 0, 0, -6572.751953125, -3813.163330078125, 375.05999755859375, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+6, 180406, 0, 3, 5496, '0', 0, 0, -6628.6962890625, -3930.0712890625, 381.191558837890625, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+7, 180406, 0, 3, 1898, '0', 0, 0, -6427.61474609375, -3776.541748046875, 294.458343505859375, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Dustwind Gulch - Difficulty: 0) CreateObject1 +(@OGUID+8, 180407, 0, 3, 5496, '0', 0, 0, -6630.705078125, -3834.116455078125, 381.672393798828125, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+9, 180407, 0, 3, 5496, '0', 0, 0, -6642.32470703125, -3916.654541015625, 380.97943115234375, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+10, 180407, 0, 3, 5496, '0', 0, 0, -6595.7431640625, -3922.40625, 381.65960693359375, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+11, 180407, 0, 3, 1898, '0', 0, 0, -6488.77978515625, -3810.2431640625, 346.660552978515625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Dustwind Gulch - Difficulty: 0) CreateObject1 +(@OGUID+12, 180409, 0, 3, 5496, '0', 0, 0, -6629.9599609375, -3925.717041015625, 378.63720703125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- G_WitchBroom_01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+13, 180410, 0, 3, 5496, '0', 0, 0, -6581.798828125, -3901.13720703125, 379.870758056640625, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+14, 180410, 0, 3, 5496, '0', 0, 0, -6578.38720703125, -3906.28125, 380.519073486328125, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+15, 180411, 0, 3, 5496, '0', 0, 0, -6593.27783203125, -3899.282958984375, 386.30523681640625, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+16, 180415, 0, 3, 5496, '0', 0, 0, -6633.13525390625, -3837.15625, 384.546539306640625, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+17, 180415, 0, 3, 5496, '0', 0, 0, -6634.1962890625, -3837.303955078125, 384.665191650390625, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+18, 180415, 0, 3, 5496, '0', 0, 0, -6647.67041015625, -3833.201416015625, 380.556488037109375, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+19, 180415, 0, 3, 5496, '0', 0, 0, -6645.236328125, -3833.59033203125, 380.572174072265625, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+20, 180415, 0, 3, 5496, '0', 0, 0, -6622.55029296875, -3830.13720703125, 380.572052001953125, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+21, 180415, 0, 3, 5496, '0', 0, 0, -6625.00341796875, -3832.23095703125, 381.024810791015625, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+22, 180415, 0, 3, 5496, '0', 0, 0, -6633.70654296875, -3837.251708984375, 384.64422607421875, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+23, 180415, 0, 3, 5496, '0', 0, 0, -6635.15283203125, -3837.40966796875, 384.743804931640625, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+24, 180415, 0, 3, 5496, '0', 0, 0, -6632.21875, -3836.99658203125, 384.837005615234375, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+25, 180415, 0, 3, 5496, '0', 0, 0, -6617.265625, -3829.388916015625, 380.757415771484375, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+26, 180415, 0, 3, 5496, '0', 0, 0, -6634.76416015625, -3837.38720703125, 384.594207763671875, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+27, 180415, 0, 3, 5496, '0', 0, 0, -6631.77587890625, -3836.9619140625, 384.628326416015625, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+28, 180415, 0, 3, 5496, '0', 0, 0, -6643.11474609375, -3834.623291015625, 381.019287109375, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+29, 180415, 0, 3, 5496, '0', 0, 0, -6650.41845703125, -3833.751708984375, 380.737396240234375, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+30, 180415, 0, 3, 5496, '0', 0, 0, -6626.2119140625, -3834.854248046875, 380.766876220703125, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+31, 180415, 0, 3, 5496, '0', 0, 0, -6641.0380859375, -3836.939208984375, 380.799285888671875, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+32, 180415, 0, 3, 5496, '0', 0, 0, -6632.63525390625, -3837.0869140625, 384.755767822265625, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+33, 180415, 0, 3, 5496, '0', 0, 0, -6620.07666015625, -3829.265625, 380.56695556640625, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+34, 180415, 0, 3, 5496, '0', 0, 0, -6643.95654296875, -3898.182373046875, 380.47833251953125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+35, 180415, 0, 3, 5496, '0', 0, 0, -6654.20166015625, -3842.866455078125, 380.576324462890625, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+36, 180415, 0, 3, 5496, '0', 0, 0, -6569.48974609375, -3874.748291015625, 392.137603759765625, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+37, 180415, 0, 3, 5496, '0', 0, 0, -6652.296875, -3845.880126953125, 380.281646728515625, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+38, 180415, 0, 3, 5496, '0', 0, 0, -6611.9619140625, -3837.65283203125, 380.708892822265625, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+39, 180415, 0, 3, 5496, '0', 0, 0, -6643.79345703125, -3902.944580078125, 380.40093994140625, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+40, 180415, 0, 3, 5496, '0', 0, 0, -6649.22900390625, -3847.5, 380.338104248046875, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+41, 180415, 0, 3, 5496, '0', 0, 0, -6613.048828125, -3832.395751953125, 380.464935302734375, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+42, 180415, 0, 3, 5496, '0', 0, 0, -6637.8056640625, -3882.916748046875, 380.321929931640625, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+43, 180415, 0, 3, 5496, '0', 0, 0, -6644.5537109375, -3904.442626953125, 380.690643310546875, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+44, 180415, 0, 3, 5496, '0', 0, 0, -6615.30712890625, -3842.541748046875, 380.3345947265625, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+45, 180415, 0, 3, 5496, '0', 0, 0, -6643.47900390625, -3898.234375, 380.474456787109375, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+46, 180415, 0, 3, 5496, '0', 0, 0, -6652.984375, -3835.788330078125, 380.243804931640625, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+47, 180415, 0, 3, 5496, '0', 0, 0, -6643.658203125, -3898.557373046875, 380.4755859375, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+48, 180415, 0, 3, 5496, '0', 0, 0, -6640.06103515625, -3888.197998046875, 379.954681396484375, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+49, 180415, 0, 3, 5496, '0', 0, 0, -6614.861328125, -3830.54345703125, 380.311676025390625, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+50, 180415, 0, 3, 5496, '0', 0, 0, -6654.54541015625, -3839.03466796875, 380.411529541015625, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+51, 180415, 0, 3, 5496, '0', 0, 0, -6643.9755859375, -3904.020751953125, 380.510162353515625, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+52, 180415, 0, 3, 5496, '0', 0, 0, -6637.8974609375, -3882.39404296875, 380.486328125, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+53, 180415, 0, 3, 5496, '0', 0, 0, -6640.5087890625, -3888.545166015625, 379.93841552734375, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+54, 180415, 0, 3, 5496, '0', 0, 0, -6612.04345703125, -3834.890625, 380.229644775390625, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+55, 180415, 0, 3, 5496, '0', 0, 0, -6613.03466796875, -3840.598876953125, 380.423492431640625, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+56, 180415, 0, 3, 5496, '0', 0, 0, -6569.55712890625, -3874.482666015625, 391.970458984375, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+57, 180415, 0, 3, 5496, '0', 0, 0, -6625.08154296875, -3934.052001953125, 380.298614501953125, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+58, 180415, 0, 3, 5496, '0', 0, 0, -6592.65478515625, -3925.322998046875, 385.218475341796875, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+59, 180415, 0, 3, 5496, '0', 0, 0, -6592.845703125, -3924.067626953125, 385.313385009765625, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+60, 180415, 0, 3, 5496, '0', 0, 0, -6592.68603515625, -3924.463623046875, 385.355712890625, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+61, 180415, 0, 3, 5496, '0', 0, 0, -6592.5068359375, -3926.600830078125, 385.277252197265625, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+62, 180415, 0, 3, 5496, '0', 0, 0, -6624.72412109375, -3933.73779296875, 379.945068359375, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+63, 180415, 0, 3, 5496, '0', 0, 0, -6592.8349609375, -3923.614501953125, 385.367095947265625, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+64, 180415, 0, 3, 5496, '0', 0, 0, -6592.54541015625, -3926.07470703125, 385.416412353515625, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+65, 180415, 0, 3, 5496, '0', 0, 0, -6592.71728515625, -3924.8837890625, 385.427154541015625, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+66, 180415, 0, 3, 5496, '0', 0, 0, -6624.376953125, -3934.1806640625, 380.122467041015625, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+67, 180415, 0, 3, 5496, '0', 0, 0, -6621.3974609375, -3938.013916015625, 380.142669677734375, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+68, 180415, 0, 3, 5496, '0', 0, 0, -6621.2724609375, -3937.479248046875, 380.00677490234375, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+69, 180415, 0, 3, 5496, '0', 0, 0, -6608.01416015625, -3963.9150390625, 381.504302978515625, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+70, 180415, 0, 3, 5496, '0', 0, 0, -6608.44091796875, -3964.0625, 381.350494384765625, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+71, 180415, 0, 3, 5496, '0', 0, 0, -6610.15478515625, -3965.600830078125, 381.71533203125, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+72, 180415, 0, 3, 5496, '0', 0, 0, -6609.99462890625, -3966.130126953125, 381.776153564453125, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+73, 180415, 0, 3, 5496, '0', 0, 0, -6610.45849609375, -3965.880126953125, 381.86773681640625, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+74, 180415, 0, 3, 5496, '0', 0, 0, -6607.85791015625, -3962.607666015625, 381.43914794921875, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 51886), -- CandleBlack01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+75, 180425, 0, 3, 5496, '0', 0, 0, -6568.95849609375, -3875.6025390625, 392.694061279296875, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 51886), -- SkullCandle01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+76, 180425, 0, 3, 5496, '0', 0, 0, -6621.67724609375, -3937.373291015625, 380.191314697265625, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 51886), -- SkullCandle01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+77, 180425, 0, 3, 5496, '0', 0, 0, -6609.689453125, -3965.71533203125, 381.730133056640625, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 51886), -- SkullCandle01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+78, 180426, 0, 3, 5496, '0', 0, 0, -6610.03125, -3921.435791015625, 384.79083251953125, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 120, 255, 1, 51886), -- Bat01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+79, 180426, 0, 3, 5496, '0', 0, 0, -6621.95849609375, -3894.704833984375, 384.862274169921875, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 51886), -- Bat01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+80, 180426, 0, 3, 5496, '0', 0, 0, -6637.27783203125, -3899.15625, 386.831207275390625, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- Bat01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+81, 180426, 0, 3, 5496, '0', 0, 0, -6624.46728515625, -3915.892333984375, 386.943511962890625, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 51886), -- Bat01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+82, 180426, 0, 3, 5496, '0', 0, 0, -6607.40625, -3932.083251953125, 384.79083251953125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+83, 180427, 0, 3, 5496, '0', 0, 0, -6620.01220703125, -3892.04345703125, 385.982330322265625, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 51886), -- Bat02 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+84, 180427, 0, 3, 5496, '0', 0, 0, -6619.54150390625, -3907.694580078125, 388.0679931640625, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 51886), -- Bat02 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+85, 180427, 0, 3, 5496, '0', 0, 0, -6613.25, -3924.520751953125, 388.0679931640625, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 51886), -- Bat02 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+86, 180471, 0, 3, 5496, '0', 0, 0, -6644.06103515625, -3906.060791015625, 383.185638427734375, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+87, 180471, 0, 3, 5496, '0', 0, 0, -6570.80029296875, -3872.536376953125, 394.820220947265625, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+88, 180471, 0, 3, 5496, '0', 0, 0, -6623.86962890625, -3936.239501953125, 383.493804931640625, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+89, 180471, 0, 3, 5496, '0', 0, 0, -6624.251953125, -3935.71875, 383.212554931640625, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+90, 180471, 0, 3, 5496, '0', 0, 0, -6623.4306640625, -3936.66845703125, 383.493804931640625, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+91, 180471, 0, 3, 5496, '0', 0, 0, -6623.02587890625, -3937.076416015625, 383.20440673828125, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+92, 180472, 0, 3, 5496, '0', 0, 0, -6573.251953125, -3879.33154296875, 396.374908447265625, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+93, 180472, 0, 3, 5496, '0', 0, 0, -6639.27587890625, -3886.017333984375, 385.15234375, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+94, 180523, 0, 3, 5496, '0', 0, 0, -6595.4443359375, -3914.677001953125, 379.509429931640625, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 51886), -- Apple Bob (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+95, 185436, 0, 3, 5496, '0', 0, 0, -6572.48779296875, -3880.829833984375, 391.084381103515625, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- Sitting Skeleton 03 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+96, 185438, 0, 3, 5496, '0', 0, 0, -6570.3974609375, -3870.8125, 391.13250732421875, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 51886), -- Sitting Skeleton 04 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+97, 207941, 0, 3, 5496, '0', 0, 0, -6644.80224609375, -3879.234375, 391.212982177734375, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+98, 207941, 0, 3, 5496, '0', 0, 0, -6650.57275390625, -3900.9619140625, 391.190704345703125, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+99, 207941, 0, 3, 5496, '0', 0, 0, -6630.89599609375, -3850.598876953125, 397.21563720703125, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+100, 207941, 0, 3, 5496, '0', 0, 0, -6578.36962890625, -3924.16845703125, 391.194976806640625, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+101, 207941, 0, 3, 5496, '0', 0, 0, -6628.0537109375, -3940.70654296875, 390.834381103515625, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+102, 208057, 0, 3, 5496, '0', 0, 0, -6684.9375, -3896.15966796875, 396.434539794921875, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 51886), -- G_Pumpkin_01 Scale 2.0 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+103, 208057, 0, 3, 5496, '0', 0, 0, -6609.98095703125, -3963.296875, 381.712799072265625, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 120, 255, 1, 51886), -- G_Pumpkin_01 Scale 2.0 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+104, 208057, 0, 3, 5496, '0', 0, 0, -6516.63525390625, -3871.65625, 397.878692626953125, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 51886), -- G_Pumpkin_01 Scale 2.0 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+105, 208061, 0, 3, 5496, '0', 0, 0, -6683.376953125, -3931.201416015625, 405.699371337890625, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 2.0 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+106, 208061, 0, 3, 5496, '0', 0, 0, -6510.35595703125, -3856.47216796875, 401.944305419921875, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 2.0 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+107, 208062, 0, 3, 5496, '0', 0, 0, -6678.32470703125, -3849.010498046875, 402.203094482421875, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 2.0 (Area: Fuselight - Difficulty: 0) CreateObject1 +(@OGUID+108, 208137, 0, 3, 5496, '0', 0, 0, -6583.486328125, -3924.451416015625, 379.541748046875, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 51886); -- Candy Bucket (Area: Fuselight - 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+108; +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); diff --git a/sql/updates/world/master/2023_11_08_10_world_badlands_new_kargath.sql b/sql/updates/world/master/2023_11_08_10_world_badlands_new_kargath.sql new file mode 100644 index 00000000000..d823fe28283 --- /dev/null +++ b/sql/updates/world/master/2023_11_08_10_world_badlands_new_kargath.sql @@ -0,0 +1,197 @@ +SET @CGUID := 3000297; +SET @OGUID := 3004661; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208143; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208143; -- Candy Bucket + +-- Quests +DELETE FROM `quest_offer_reward` WHERE `ID`=28957; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28957, 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`=208143; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208143, 28957, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208143 AND `quest`=28957); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208143; + +-- 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, 3, 5565, '0', 0, 0, 0, 0, -6707.89306640625, -2457.85693359375, 272.76043701171875, 0.259810924530029296, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 51886); -- Black Cat (Area: New Kargath - Difficulty: 0) CreateObject1 (possible waypoints or random movement) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 231118 AND 231180; +DELETE FROM `gameobject` WHERE `guid`=232005; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231118 AND 231180; +DELETE FROM `game_event_gameobject` WHERE `guid`=232005; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+76; +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, 3, 5565, '0', 0, 0, -6677.7880859375, -2424.708251953125, 275.574615478515625, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 3, 5565, '0', 0, 0, -6722.2900390625, -2455.8681640625, 290.265472412109375, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 3, 5565, '0', 0, 0, -6721.27978515625, -2497.7587890625, 290.146209716796875, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+3, 180406, 0, 3, 5565, '0', 0, 0, -6709.82275390625, -2433.130126953125, 274.440948486328125, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+4, 180406, 0, 3, 5565, '0', 0, 0, -6740.296875, -2497.782958984375, 290.109619140625, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+5, 180407, 0, 3, 5565, '0', 0, 0, -6711.7900390625, -2481.21875, 290.165374755859375, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+6, 180407, 0, 3, 5565, '0', 0, 0, -6738.86474609375, -2455.708251953125, 290.226654052734375, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+7, 180407, 0, 3, 5565, '0', 0, 0, -6749.7744140625, -2481.453125, 290.185455322265625, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+8, 180411, 0, 3, 5565, '0', 0, 0, -6681.4755859375, -2482.171875, 255.5470123291015625, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 51886), -- G_Ghost_01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+9, 180411, 0, 3, 5565, '0', 0, 0, -6709.82275390625, -2514.2431640625, 255.72100830078125, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 51886), -- G_Ghost_01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+10, 180411, 0, 3, 5565, '0', 0, 0, -6754.095703125, -2513.3994140625, 254.288116455078125, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 51886), -- G_Ghost_01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+11, 180411, 0, 3, 5565, '0', 0, 0, -6785.0380859375, -2486.05908203125, 254.8849029541015625, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 51886), -- G_Ghost_01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+12, 180415, 0, 3, 5565, '0', 0, 0, -6713.4150390625, -2434.234375, 276.524139404296875, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+13, 180415, 0, 3, 5565, '0', 0, 0, -6714.796875, -2434.552001953125, 276.534088134765625, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+14, 180415, 0, 3, 5565, '0', 0, 0, -6717.7744140625, -2434.479248046875, 276.599517822265625, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+15, 180415, 0, 3, 5565, '0', 0, 0, -6716.19775390625, -2434.673583984375, 276.51177978515625, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+16, 180415, 0, 3, 5565, '0', 0, 0, -6703.6787109375, -2476.295166015625, 274.505767822265625, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+17, 180415, 0, 3, 5565, '0', 0, 0, -6704.203125, -2476.37158203125, 274.396820068359375, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+18, 180415, 0, 3, 5565, '0', 0, 0, -6703.8349609375, -2476.01220703125, 274.351470947265625, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+19, 180415, 0, 3, 5565, '0', 0, 0, -6724.24462890625, -2478.2275390625, 279.05157470703125, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+20, 180415, 0, 3, 5565, '0', 0, 0, -6737.84912109375, -2479.1962890625, 280.634124755859375, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+21, 180415, 0, 3, 5565, '0', 0, 0, -6737.26416015625, -2478.2431640625, 279.2568359375, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+22, 180415, 0, 3, 5565, '0', 0, 0, -6726.19775390625, -2474.864501953125, 275.273193359375, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+23, 180415, 0, 3, 5565, '0', 0, 0, -6725.51025390625, -2476.109375, 276.55242919921875, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+24, 180415, 0, 3, 5565, '0', 0, 0, -6723.67724609375, -2479.229248046875, 280.526214599609375, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+25, 180415, 0, 3, 5565, '0', 0, 0, -6735.2587890625, -2474.921875, 275.380859375, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+26, 180415, 0, 3, 5565, '0', 0, 0, -6736.65283203125, -2477.26220703125, 277.920989990234375, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+27, 180415, 0, 3, 5565, '0', 0, 0, -6735.97412109375, -2476.114501953125, 276.622528076171875, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+28, 180415, 0, 3, 5565, '0', 0, 0, -6724.861328125, -2477.1650390625, 277.662689208984375, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 51886), -- CandleBlack01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+29, 180426, 0, 3, 5565, '0', 0, 0, -6693.1318359375, -2452.59716796875, 279.710693359375, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- Bat01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+30, 180426, 0, 3, 5565, '0', 0, 0, -6681.3994140625, -2441.704833984375, 280.9503173828125, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- Bat01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+31, 180426, 0, 3, 5565, '0', 0, 0, -6699.22412109375, -2444.4462890625, 287.570953369140625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- Bat01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+32, 180426, 0, 3, 5565, '0', 0, 0, -6730.9130859375, -2481.069580078125, 308.809967041015625, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- Bat01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+33, 180426, 0, 3, 5565, '0', 0, 0, -6730.52587890625, -2481.201416015625, 304.143218994140625, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 51886), -- Bat01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+34, 180427, 0, 3, 5565, '0', 0, 0, -6688.87841796875, -2445.453125, 286.295013427734375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 51886), -- Bat02 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+35, 180427, 0, 3, 5565, '0', 0, 0, -6688.95166015625, -2447.76220703125, 282.62060546875, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 51886), -- Bat02 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+36, 180427, 0, 3, 5565, '0', 0, 0, -6690.986328125, -2448.12158203125, 279.261688232421875, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- Bat02 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+37, 180427, 0, 3, 5565, '0', 0, 0, -6730.72900390625, -2481.864501953125, 288.708404541015625, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 51886), -- Bat02 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+38, 180427, 0, 3, 5565, '0', 0, 0, -6730.72900390625, -2481.864501953125, 292.490631103515625, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 51886), -- Bat02 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+39, 180427, 0, 3, 5565, '0', 0, 0, -6730.72900390625, -2481.864501953125, 302.653717041015625, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- Bat02 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+40, 180471, 0, 3, 5565, '0', 0, 0, -6706.58837890625, -2469.57470703125, 275.398101806640625, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+41, 180471, 0, 3, 5565, '0', 0, 0, -6731.5087890625, -2459.607666015625, 280.257720947265625, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+42, 180471, 0, 3, 5565, '0', 0, 0, -6712.60400390625, -2474.104248046875, 275.502838134765625, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+43, 180471, 0, 3, 5565, '0', 0, 0, -6701.8037109375, -2475.4306640625, 275.375091552734375, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+44, 180471, 0, 3, 5565, '0', 0, 0, -6728.658203125, -2459.661376953125, 279.480865478515625, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+45, 180471, 0, 3, 5565, '0', 0, 0, -6729.93603515625, -2459.626708984375, 280.216949462890625, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+46, 180471, 0, 3, 5565, '0', 0, 0, -6707.8662109375, -2480.2431640625, 275.515960693359375, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+47, 180471, 0, 3, 5565, '0', 0, 0, -6732.62841796875, -2459.638916015625, 279.2852783203125, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+48, 180471, 0, 3, 5565, '0', 0, 0, -6732.1962890625, -2459.62158203125, 279.94482421875, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+49, 180471, 0, 3, 5565, '0', 0, 0, -6730.66162109375, -2459.592041015625, 280.467803955078125, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+50, 180471, 0, 3, 5565, '0', 0, 0, -6729.26416015625, -2459.65966796875, 280.025299072265625, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+51, 180472, 0, 3, 5565, '0', 0, 0, -6736.25, -2481.546875, 280.674163818359375, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+52, 180472, 0, 3, 5565, '0', 0, 0, -6725.76904296875, -2481.57470703125, 280.63726806640625, 2.827429771423339843, 0, 0, 0.987688064575195312, 0.156436234712600708, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+53, 180523, 0, 3, 5565, '0', 0, 0, -6733.76904296875, -2456.46875, 274.928131103515625, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 51886), -- Apple Bob (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+54, 185436, 0, 3, 5565, '0', 0, 0, -6678.5869140625, -2425.3056640625, 272.77056884765625, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 51886), -- Sitting Skeleton 03 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+55, 185437, 0, 3, 5565, '0', 0, 0, -6713.42724609375, -2434.609375, 272.770050048828125, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 51886), -- Laying Skeleton 01 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+56, 207941, 0, 3, 5565, '0', 0, 0, -6775.59375, -2558.2119140625, 262.0103759765625, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+57, 207941, 0, 3, 5565, '0', 0, 0, -6668.236328125, -2564.010498046875, 261.570220947265625, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+58, 207941, 0, 3, 5565, '0', 0, 0, -6701.359375, -2559.772705078125, 261.77215576171875, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+59, 207941, 0, 3, 5565, '0', 0, 0, -6754.86962890625, -2475.072998046875, 292.638275146484375, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+60, 208058, 0, 3, 5565, '0', 0, 0, -6689.49853515625, -2480.576416015625, 280.5703125, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 51886), -- G_Pumpkin_01 Scale 3.0 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+61, 208058, 0, 3, 5565, '0', 0, 0, -6778.88916015625, -2481.32470703125, 280.034912109375, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 51886), -- G_Pumpkin_01 Scale 3.0 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+62, 208063, 0, 3, 5565, '0', 0, 0, -6728.57470703125, -2490.95654296875, 276.25439453125, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 51886), -- Web Hanging (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+63, 208064, 0, 3, 5565, '0', 0, 0, -6718.81591796875, -2481.736083984375, 277.26239013671875, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 51886), -- Web Corner (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+64, 208064, 0, 3, 5565, '0', 0, 0, -6742.85791015625, -2481.5, 277.089019775390625, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 51886), -- Web Corner (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+65, 208064, 0, 3, 5565, '0', 0, 0, -6724.96337890625, -2491.92529296875, 277.140594482421875, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 51886), -- Web Corner (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+66, 208064, 0, 3, 5565, '0', 0, 0, -6737.00537109375, -2491.928955078125, 277.474578857421875, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 51886), -- Web Corner (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+67, 208068, 0, 3, 5565, '0', 0, 0, -6678.580078125, -2425.329833984375, 273.987060546875, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 51886), -- Web Hanging Scale 0.5 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+68, 208069, 0, 3, 5565, '0', 0, 0, -6669.85595703125, -2435.93408203125, 274.722564697265625, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+69, 208069, 0, 3, 5565, '0', 0, 0, -6709.43212890625, -2471.3056640625, 272.753509521484375, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+70, 208070, 0, 3, 5565, '0', 0, 0, -6730.88037109375, -2468.913330078125, 275.821380615234375, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 51886), -- Web Hanging Scale 2.0 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+71, 208071, 0, 3, 5565, '0', 0, 0, -6681.96533203125, -2481.9375, 266.760284423828125, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 51886), -- Web Hanging Scale 3.0 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+72, 208071, 0, 3, 5565, '0', 0, 0, -6710.18408203125, -2513.57470703125, 267.202606201171875, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 51886), -- Web Hanging Scale 3.0 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+73, 208071, 0, 3, 5565, '0', 0, 0, -6753.861328125, -2512.814208984375, 265.83404541015625, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 51886), -- Web Hanging Scale 3.0 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+74, 208071, 0, 3, 5565, '0', 0, 0, -6784.1025390625, -2485.776123046875, 266.37457275390625, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 51886), -- Web Hanging Scale 3.0 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+75, 208072, 0, 3, 5565, '0', 0, 0, -6710.595703125, -2471.73779296875, 272.767608642578125, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: New Kargath - Difficulty: 0) CreateObject1 +(@OGUID+76, 208143, 0, 3, 5565, '0', 0, 0, -6728.28125, -2465.94091796875, 274.57843017578125, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 51886); -- Candy Bucket (Area: New Kargath - 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+76; +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); diff --git a/sql/updates/world/master/2023_11_08_11_world_badlands_dragons_mouth.sql b/sql/updates/world/master/2023_11_08_11_world_badlands_dragons_mouth.sql new file mode 100644 index 00000000000..b0df4b9f9ed --- /dev/null +++ b/sql/updates/world/master/2023_11_08_11_world_badlands_dragons_mouth.sql @@ -0,0 +1,107 @@ +SET @CGUID := 3000298; +SET @OGUID := 3004738; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208121; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208121; -- Candy Bucket + +-- Quests +UPDATE `quest_template` SET `Expansion`=9, `VerifiedBuild`=51886 WHERE `ID`=28956; -- Candy Bucket + +DELETE FROM `quest_offer_reward` WHERE `ID`=28956; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28956, 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`=208121; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208121, 28956, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208121 AND `quest`=28956); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208121; + +-- 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, 3, 5564, '0', 0, 0, 0, 0, -6996.51318359375, -2528.797607421875, 241.7134552001953125, 5.925296306610107421, 120, 5, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 51886); -- Black Cat (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 231118 AND 231180; +DELETE FROM `gameobject` WHERE `guid`=232005; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231118 AND 231180; +DELETE FROM `game_event_gameobject` WHERE `guid`=232005; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+30; +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, 3, 5564, '0', 0, 0, -6985.7275390625, -2529.0400390625, 241.7134552001953125, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 3, 5564, '0', 0, 0, -7013.7099609375, -2529.25341796875, 243.217742919921875, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+2, 180406, 0, 3, 5564, '0', 0, 0, -7035.1943359375, -2575.94970703125, 253.75103759765625, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+3, 180407, 0, 3, 5564, '0', 0, 0, -7034.7431640625, -2540.6650390625, 253.2794342041015625, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+4, 180407, 0, 3, 5564, '0', 0, 0, -6998.26220703125, -2517.55029296875, 241.7515411376953125, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+5, 180408, 0, 3, 5564, '0', 0, 0, -6993.1875, -2547.814208984375, 246.2427825927734375, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+6, 180410, 0, 3, 5564, '0', 0, 0, -7042.73779296875, -2573.5400390625, 254.078643798828125, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+7, 180411, 0, 3, 5564, '0', 0, 0, -7033.21875, -2535.35595703125, 260.396881103515625, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+8, 180415, 0, 3, 5564, '0', 0, 0, -7040.99853515625, -2567.53466796875, 253.3317108154296875, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+9, 180415, 0, 3, 5564, '0', 0, 0, -6995.91162109375, -2542.359375, 242.7194366455078125, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+10, 180415, 0, 3, 5564, '0', 0, 0, -6996.251953125, -2542.382080078125, 242.7102813720703125, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+11, 180425, 0, 3, 5564, '0', 0, 0, -7033.125, -2549.257080078125, 252.693878173828125, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 51886), -- SkullCandle01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+12, 180425, 0, 3, 5564, '0', 0, 0, -7040.9287109375, -2565.569580078125, 254.166778564453125, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 51886), -- SkullCandle01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+13, 180425, 0, 3, 5564, '0', 0, 0, -6997.9912109375, -2544.197998046875, 242.737579345703125, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 51886), -- SkullCandle01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+14, 180426, 0, 3, 5564, '0', 0, 0, -7020.765625, -2555.935791015625, 254.18536376953125, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 51886), -- Bat01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+15, 180426, 0, 3, 5564, '0', 0, 0, -7015.1337890625, -2552.248291015625, 256.81298828125, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 51886), -- Bat01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+16, 180426, 0, 3, 5564, '0', 0, 0, -7004.3349609375, -2540.255126953125, 247.265594482421875, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 51886), -- Bat01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+17, 180427, 0, 3, 5564, '0', 0, 0, -7008.07666015625, -2556.4375, 258.976043701171875, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 51886), -- Bat02 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+18, 180427, 0, 3, 5564, '0', 0, 0, -7016.62841796875, -2557.90283203125, 251.0806732177734375, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 51886), -- Bat02 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+19, 180427, 0, 3, 5564, '0', 0, 0, -7003.470703125, -2548.078125, 252.189910888671875, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 51886), -- Bat02 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+20, 180471, 0, 3, 5564, '0', 0, 0, -7041.31787109375, -2550.654541015625, 254.7256622314453125, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+21, 180471, 0, 3, 5564, '0', 0, 0, -7031.390625, -2544.3125, 254.70147705078125, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+22, 180471, 0, 3, 5564, '0', 0, 0, -7033.19287109375, -2552.46875, 254.742462158203125, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+23, 180471, 0, 3, 5564, '0', 0, 0, -7039.515625, -2542.49658203125, 254.7635650634765625, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+24, 180472, 0, 3, 5564, '0', 0, 0, -7036.2431640625, -2560.645751953125, 252.0963287353515625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+25, 180523, 0, 3, 5564, '0', 0, 0, -7003.7255859375, -2528.96875, 241.9618377685546875, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 51886), -- Apple Bob (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+26, 185434, 0, 3, 5564, '0', 0, 0, -7007.63916015625, -2528.928955078125, 241.7134552001953125, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 51886), -- Sitting Skeleton 01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+27, 185435, 0, 3, 5564, '0', 0, 0, -6991.015625, -2543.057373046875, 241.7134552001953125, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 51886), -- Sitting Skeleton 02 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+28, 185437, 0, 3, 5564, '0', 0, 0, -7011.88720703125, -2539.13720703125, 241.7134552001953125, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 51886), -- Laying Skeleton 01 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+29, 185438, 0, 3, 5564, '0', 0, 0, -7039.8369140625, -2569.94970703125, 252.457275390625, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 51886), -- Sitting Skeleton 04 (Area: Dragon's Mouth - Difficulty: 0) CreateObject1 +(@OGUID+30, 208121, 0, 3, 5564, '0', 0, 0, -7006.34716796875, -2542.850830078125, 241.7134552001953125, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 51886); -- Candy Bucket (Area: Dragon's Mouth - 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+30; +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); |