diff options
| -rw-r--r-- | sql/updates/world/master/2023_11_08_06_world_loch_modan_thelsamar.sql | 125 | ||||
| -rw-r--r-- | sql/updates/world/master/2023_11_08_07_world_loch_modan_farstrider_lodge.sql | 169 |
2 files changed, 294 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_08_06_world_loch_modan_thelsamar.sql b/sql/updates/world/master/2023_11_08_06_world_loch_modan_thelsamar.sql new file mode 100644 index 00000000000..cee65358033 --- /dev/null +++ b/sql/updates/world/master/2023_11_08_06_world_loch_modan_thelsamar.sql @@ -0,0 +1,125 @@ +SET @OGUID := 3004328; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=190043; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=190043; -- Candy Bucket + +-- Quests +UPDATE `quest_template` SET `Expansion`=9, `VerifiedBuild`=51886 WHERE `ID`=12339; -- Candy Bucket + +UPDATE `quest_offer_reward` SET `VerifiedBuild`=51886 WHERE `ID`=12339; + +DELETE FROM `gameobject_queststarter` WHERE `id`=190043; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(190043, 12339, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=190043 AND `quest`=12339); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=190043; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+48; +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, 38, 144, '0', 0, 0, -5363.9501953125, -2959.135986328125, 327.41644287109375, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 38, 144, '0', 0, 0, -5379.72900390625, -2957.8173828125, 345.710357666015625, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 38, 144, '0', 0, 0, -5357.1005859375, -2973.14501953125, 335.55950927734375, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+3, 180406, 0, 38, 144, '0', 0, 0, -5390.8173828125, -2947.8544921875, 345.709014892578125, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+4, 180406, 0, 38, 144, '0', 0, 0, -5376.16650390625, -2942.420166015625, 335.727996826171875, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+5, 180406, 0, 38, 144, '0', 0, 0, -5361.37158203125, -3019.73779296875, 327.072509765625, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+6, 180407, 0, 38, 144, '0', 0, 0, -5363.23291015625, -2969.87158203125, 326.779693603515625, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+7, 180407, 0, 38, 144, '0', 0, 0, -5436.35791015625, -2918.18701171875, 347.243011474609375, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+8, 180407, 0, 38, 144, '0', 0, 0, -5361.61962890625, -2957.439453125, 335.493438720703125, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+9, 180415, 0, 38, 144, '0', 0, 0, -5393.9306640625, -2974.626708984375, 326.780029296875, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 51886), -- CandleBlack01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+10, 180415, 0, 38, 144, '0', 0, 0, -5386.9990234375, -2973.473388671875, 326.826080322265625, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- CandleBlack01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+11, 180415, 0, 38, 144, '0', 0, 0, -5392.10400390625, -2955.005126953125, 322.8935546875, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+12, 180415, 0, 38, 144, '0', 0, 0, -5380.4443359375, -2963.6875, 322.90478515625, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+13, 180425, 0, 38, 144, '0', 0, 0, -5386.62841796875, -2965.178955078125, 322.967315673828125, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 51886), -- SkullCandle01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+14, 180425, 0, 38, 144, '0', 0, 0, -5392.65625, -2953.064697265625, 322.928192138671875, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 51886), -- SkullCandle01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+15, 180425, 0, 38, 144, '0', 0, 0, -5382.7001953125, -2972.2265625, 324.04827880859375, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 51886), -- SkullCandle01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+16, 180425, 0, 38, 144, '0', 0, 0, -5383.79052734375, -2957.52587890625, 322.970184326171875, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, 51886), -- SkullCandle01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+17, 180426, 0, 38, 144, '0', 0, 0, -5329.7744140625, -2955.854248046875, 347.7984619140625, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 51886), -- Bat01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+18, 180426, 0, 38, 144, '0', 0, 0, -5329.796875, -2956.15625, 337.812530517578125, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 51886), -- Bat01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+19, 180426, 0, 38, 144, '0', 0, 0, -5329.47412109375, -2955.62158203125, 344.731201171875, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 51886), -- Bat01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+20, 180426, 0, 38, 144, '0', 0, 0, -5329.359375, -2955.65283203125, 343.894378662109375, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- Bat01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+21, 180426, 0, 38, 144, '0', 0, 0, -5331.140625, -2956.6962890625, 345.508026123046875, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 51886), -- Bat01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+22, 180426, 0, 38, 144, '0', 0, 0, -5329.5, -2955.9931640625, 339.369384765625, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 51886), -- Bat01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+23, 180426, 0, 38, 144, '0', 0, 0, -5329.7587890625, -2956.022705078125, 340.1060791015625, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 51886), -- Bat01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+24, 180426, 0, 38, 144, '0', 0, 0, -5329.63916015625, -2956.380126953125, 337.192596435546875, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 51886), -- Bat01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+25, 180426, 0, 38, 144, '0', 0, 0, -5329.845703125, -2955.829833984375, 343.071533203125, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 51886), -- Bat01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+26, 180426, 0, 38, 144, '0', 0, 0, -5331.04345703125, -2956.37841796875, 340.6446533203125, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 51886), -- Bat01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+27, 180427, 0, 38, 144, '0', 0, 0, -5375.93115234375, -2947.4658203125, 350.673309326171875, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 51886), -- Bat02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+28, 180427, 0, 38, 144, '0', 0, 0, -5375.5205078125, -2948.0390625, 352.75592041015625, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 51886), -- Bat02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+29, 180427, 0, 38, 144, '0', 0, 0, -5375.2177734375, -2947.725830078125, 352.885406494140625, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 51886), -- Bat02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+30, 180427, 0, 38, 144, '0', 0, 0, -5375.6552734375, -2947.367919921875, 352.023101806640625, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 51886), -- Bat02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+31, 180427, 0, 38, 144, '0', 0, 0, -5375.671875, -2948.19580078125, 352.402984619140625, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 51886), -- Bat02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+32, 180427, 0, 38, 144, '0', 0, 0, -5375.32568359375, -2948.587158203125, 351.627838134765625, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 51886), -- Bat02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+33, 180427, 0, 38, 144, '0', 0, 0, -5375.69384765625, -2948.718017578125, 352.133636474609375, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 51886), -- Bat02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+34, 180427, 0, 38, 144, '0', 0, 0, -5375.64453125, -2947.98046875, 349.6409912109375, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 51886), -- Bat02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+35, 180427, 0, 38, 144, '0', 0, 0, -5376.10400390625, -2948.143798828125, 354.537139892578125, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 51886), -- Bat02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+36, 180427, 0, 38, 144, '0', 0, 0, -5375.0322265625, -2951.165283203125, 351.474853515625, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 51886), -- Bat02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+37, 180471, 0, 38, 144, '0', 0, 0, -5362.783203125, -2974.111083984375, 331.339080810546875, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+38, 180471, 0, 38, 144, '0', 0, 0, -5381.1904296875, -2947.02294921875, 324.301361083984375, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+39, 180471, 0, 38, 144, '0', 0, 0, -5361.953125, -2958.0556640625, 331.24664306640625, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+40, 180471, 0, 38, 144, '0', 0, 0, -5377.232421875, -2961.757080078125, 324.134124755859375, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+41, 180471, 0, 38, 144, '0', 0, 0, -5385.6962890625, -2977.3994140625, 330.495635986328125, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+42, 180472, 0, 38, 144, '0', 0, 0, -5367.111328125, -2960.0869140625, 332.670257568359375, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+43, 180472, 0, 38, 144, '0', 0, 0, -5359.60791015625, -2966.953125, 332.670257568359375, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+44, 180472, 0, 38, 144, '0', 0, 0, -5386.61962890625, -2949.305419921875, 329.70751953125, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+45, 180472, 0, 38, 144, '0', 0, 0, -5372.71533203125, -2977.007080078125, 332.77252197265625, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+46, 180472, 0, 38, 144, '0', 0, 0, -5379.21923828125, -2954.436767578125, 325.509674072265625, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+47, 180523, 0, 38, 144, '0', 0, 0, -5377.68603515625, -2966.282470703125, 322.34234619140625, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 51886), -- Apple Bob (Area: Thelsamar - Difficulty: 0) CreateObject1 +(@OGUID+48, 190043, 0, 38, 144, '0', 0, 0, -5379.70654296875, -2973.98779296875, 323.16851806640625, 2.914689540863037109, 0, 0, 0.993571281433105468, 0.113208353519439697, 120, 255, 1, 51886); -- Candy Bucket (Area: Thelsamar - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+48; +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); diff --git a/sql/updates/world/master/2023_11_08_07_world_loch_modan_farstrider_lodge.sql b/sql/updates/world/master/2023_11_08_07_world_loch_modan_farstrider_lodge.sql new file mode 100644 index 00000000000..29f76f1993b --- /dev/null +++ b/sql/updates/world/master/2023_11_08_07_world_loch_modan_farstrider_lodge.sql @@ -0,0 +1,169 @@ +SET @OGUID := 3004377; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208124; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208124; -- Candy Bucket + +-- Quests +UPDATE `quest_template` SET `Expansion`=9, `VerifiedBuild`=51886 WHERE `ID`=28963; -- Candy Bucket + +DELETE FROM `quest_offer_reward` WHERE `ID`=28963; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28963, 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`=208124; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208124, 28963, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208124 AND `quest`=28963); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208124; + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 230962 AND 231017; +DELETE FROM `gameobject` WHERE `guid`=232003; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 230962 AND 231017; +DELETE FROM `game_event_gameobject` WHERE `guid`=232003; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+66; +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, 38, 147, '0', 0, 0, -5637.2744140625, -4294.43603515625, 407.863739013671875, 0.994837164878845214, 0, 0, 0.477158546447753906, 0.878817260265350341, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 38, 147, '0', 0, 0, -5673.17041015625, -4239.890625, 407.028228759765625, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 38, 147, '0', 0, 0, -5680.9130859375, -4244.95166015625, 406.984771728515625, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+3, 180406, 0, 38, 147, '0', 0, 0, -5646.236328125, -4300.33837890625, 407.85760498046875, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+4, 180407, 0, 38, 147, '0', 0, 0, -5656.16162109375, -4275.203125, 409.881683349609375, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+5, 180408, 0, 38, 147, '0', 0, 0, -5680.90087890625, -4244.923828125, 408.58099365234375, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+6, 180408, 0, 38, 147, '0', 0, 0, -5673.19287109375, -4239.890625, 408.630096435546875, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+7, 180411, 0, 38, 147, '0', 0, 0, -5639.2568359375, -4301.05029296875, 413.21649169921875, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 51886), -- G_Ghost_01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+8, 180415, 0, 38, 147, '0', 0, 0, -5641.8369140625, -4257.1962890625, 409.459747314453125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+9, 180415, 0, 38, 147, '0', 0, 0, -5625.921875, -4246.96728515625, 409.476043701171875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+10, 180415, 0, 38, 147, '0', 0, 0, -5694.251953125, -4291.17724609375, 409.475128173828125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+11, 180415, 0, 38, 147, '0', 0, 0, -5678.40625, -4280.84228515625, 409.459747314453125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+12, 180415, 0, 38, 147, '0', 0, 0, -5631.876953125, -4250.79541015625, 409.459747314453125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+13, 180415, 0, 38, 147, '0', 0, 0, -5635.86962890625, -4253.345703125, 409.459747314453125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+14, 180415, 0, 38, 147, '0', 0, 0, -5622.11474609375, -4244.408203125, 409.50885009765625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+15, 180415, 0, 38, 147, '0', 0, 0, -5698.02587890625, -4293.74853515625, 409.508819580078125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+16, 180415, 0, 38, 147, '0', 0, 0, -5684.220703125, -4284.81103515625, 409.459747314453125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+17, 180415, 0, 38, 147, '0', 0, 0, -5688.142578125, -4287.3525390625, 409.459747314453125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+18, 180415, 0, 38, 147, '0', 0, 0, -5674.296875, -4278.35400390625, 409.459747314453125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+19, 180415, 0, 38, 147, '0', 0, 0, -5645.720703125, -4259.76904296875, 409.459747314453125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+20, 180425, 0, 38, 147, '0', 0, 0, -5643.814453125, -4258.51220703125, 409.459747314453125, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+21, 180425, 0, 38, 147, '0', 0, 0, -5633.86962890625, -4252.11962890625, 409.459747314453125, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+22, 180425, 0, 38, 147, '0', 0, 0, -5686.21533203125, -4286.13720703125, 409.459747314453125, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+23, 180425, 0, 38, 147, '0', 0, 0, -5676.2568359375, -4279.62158203125, 409.459747314453125, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+24, 180425, 0, 38, 147, '0', 0, 0, -5624.00537109375, -4245.689453125, 409.4942626953125, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+25, 180425, 0, 38, 147, '0', 0, 0, -5695.98974609375, -4292.51220703125, 409.49285888671875, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+26, 180426, 0, 38, 147, '0', 0, 0, -5692.3037109375, -4215.56787109375, 401.80633544921875, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 51886), -- Bat01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+27, 180426, 0, 38, 147, '0', 0, 0, -5689.41845703125, -4215.12158203125, 397.439117431640625, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 120, 255, 1, 51886), -- Bat01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+28, 180426, 0, 38, 147, '0', 0, 0, -5692.265625, -4214.39404296875, 399.35845947265625, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 51886), -- Bat01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+29, 180426, 0, 38, 147, '0', 0, 0, -5633.04345703125, -4220.88037109375, 392.00274658203125, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 51886), -- Bat01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+30, 180426, 0, 38, 147, '0', 0, 0, -5640.876953125, -4221.267578125, 396.80322265625, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- Bat01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+31, 180426, 0, 38, 147, '0', 0, 0, -5636.98974609375, -4218.828125, 401.769561767578125, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 51886), -- Bat01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+32, 180427, 0, 38, 147, '0', 0, 0, -5646.3681640625, -4206.1630859375, 413.4278564453125, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 51886), -- Bat02 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+33, 180427, 0, 38, 147, '0', 0, 0, -5636.91845703125, -4211.8037109375, 411.973114013671875, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 51886), -- Bat02 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+34, 180427, 0, 38, 147, '0', 0, 0, -5677.5087890625, -4211.05908203125, 410.945587158203125, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 51886), -- Bat02 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+35, 180427, 0, 38, 147, '0', 0, 0, -5689.49658203125, -4212.70654296875, 408.18804931640625, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 51886), -- Bat02 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+36, 180427, 0, 38, 147, '0', 0, 0, -5660.27978515625, -4208.73095703125, 409.994781494140625, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- Bat02 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+37, 180471, 0, 38, 147, '0', 0, 0, -5641.87353515625, -4257.15478515625, 413.416961669921875, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+38, 180471, 0, 38, 147, '0', 0, 0, -5631.98291015625, -4250.74462890625, 413.416107177734375, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+39, 180471, 0, 38, 147, '0', 0, 0, -5624.033203125, -4245.70166015625, 413.547271728515625, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+40, 180471, 0, 38, 147, '0', 0, 0, -5694.1787109375, -4291.22412109375, 413.594635009765625, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+41, 180471, 0, 38, 147, '0', 0, 0, -5645.86474609375, -4305.95654296875, 413.4664306640625, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+42, 180471, 0, 38, 147, '0', 0, 0, -5684.23095703125, -4284.767578125, 413.36029052734375, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+43, 180471, 0, 38, 147, '0', 0, 0, -5645.798828125, -4259.74658203125, 413.34197998046875, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+44, 180471, 0, 38, 147, '0', 0, 0, -5678.23779296875, -4247.19287109375, 414.426422119140625, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+45, 180471, 0, 38, 147, '0', 0, 0, -5665.783203125, -4265.89599609375, 414.515167236328125, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+46, 180471, 0, 38, 147, '0', 0, 0, -5660.41650390625, -4261.9462890625, 414.42901611328125, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+47, 180471, 0, 38, 147, '0', 0, 0, -5688.17529296875, -4287.34375, 413.58673095703125, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+48, 180471, 0, 38, 147, '0', 0, 0, -5628.85791015625, -4295.220703125, 413.2857666015625, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+49, 180471, 0, 38, 147, '0', 0, 0, -5674.34228515625, -4278.3212890625, 413.58673095703125, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+50, 180471, 0, 38, 147, '0', 0, 0, -5686.283203125, -4286.09375, 413.440826416015625, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+51, 180471, 0, 38, 147, '0', 0, 0, -5698.03662109375, -4293.74658203125, 413.581878662109375, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+52, 180471, 0, 38, 147, '0', 0, 0, -5633.98974609375, -4252.095703125, 413.31298828125, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+53, 180471, 0, 38, 147, '0', 0, 0, -5625.94970703125, -4246.92041015625, 413.324249267578125, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+54, 180471, 0, 38, 147, '0', 0, 0, -5632.283203125, -4297.1005859375, 413.535552978515625, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+55, 180471, 0, 38, 147, '0', 0, 0, -5678.376953125, -4280.91162109375, 413.571807861328125, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+56, 180471, 0, 38, 147, '0', 0, 0, -5672.5625, -4243.4443359375, 414.311676025390625, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+57, 180471, 0, 38, 147, '0', 0, 0, -5635.892578125, -4253.330078125, 413.431671142578125, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+58, 180471, 0, 38, 147, '0', 0, 0, -5696.04150390625, -4292.4931640625, 413.314727783203125, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+59, 180471, 0, 38, 147, '0', 0, 0, -5676.3037109375, -4279.564453125, 413.330322265625, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+60, 180471, 0, 38, 147, '0', 0, 0, -5649.1787109375, -4308.265625, 413.274566650390625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+61, 180471, 0, 38, 147, '0', 0, 0, -5643.8525390625, -4258.50341796875, 413.24169921875, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+62, 180471, 0, 38, 147, '0', 0, 0, -5622.15625, -4244.39404296875, 413.381011962890625, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+63, 180472, 0, 38, 147, '0', 0, 0, -5663.376953125, -4263.90625, 416.525665283203125, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+64, 180472, 0, 38, 147, '0', 0, 0, -5675.50537109375, -4245.3056640625, 416.476776123046875, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+65, 180523, 0, 38, 147, '0', 0, 0, -5648.705078125, -4278.234375, 407.81256103515625, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 51886), -- Apple Bob (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 +(@OGUID+66, 208124, 0, 38, 147, '0', 0, 0, -5656.1962890625, -4283.87353515625, 407.81732177734375, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 51886); -- Candy Bucket (Area: The Farstrider Lodge - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+66; +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); |