diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2023_11_08_04_world_dun_morogh_ironforge.sql | 237 | ||||
| -rw-r--r-- | sql/updates/world/master/2023_11_08_05_world_dun_morogh_kharanos.sql | 200 |
2 files changed, 437 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_08_04_world_dun_morogh_ironforge.sql b/sql/updates/world/master/2023_11_08_04_world_dun_morogh_ironforge.sql new file mode 100644 index 00000000000..b13ee5815ef --- /dev/null +++ b/sql/updates/world/master/2023_11_08_04_world_dun_morogh_ironforge.sql @@ -0,0 +1,237 @@ +SET @CGUID := 3000247; +SET @OGUID := 3004183; + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` IN (395773, 395774); +DELETE FROM `game_event_creature` WHERE `guid` IN (395773, 395774); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` IN (@CGUID+0, @CGUID+1); +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, 15353, 0, 1537, 5719, '0', 0, 0, 0, 1, -4918.63671875, -983.14117431640625, 501.53759765625, 2.268928050994873046, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Katrina Shimmerstar (Area: The Commons - Difficulty: 0) +(@CGUID+1, 40435, 0, 1537, 1537, '0', 0, 0, 0, 0, -4939.44775390625, -937.36981201171875, 502.2398681640625, 0.767944872379302978, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745); -- Headless Ghost (Area: Ironforge - Difficulty: 0) (Auras: 33900 - Shroud of Death) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 242308 AND 242411; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 242308 AND 242411; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+103; +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, 1537, 1537, '0', 0, 0, -5028.53076171875, -835.8565673828125, 505.492523193359375, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+1, 180405, 0, 1537, 1537, '0', 0, 0, -4956.92822265625, -921.64093017578125, 504.260650634765625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+2, 180405, 0, 1537, 1537, '0', 0, 0, -4957.27197265625, -928.35333251953125, 514.70294189453125, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+3, 180405, 0, 1537, 1537, '0', 0, 0, -4901.64697265625, -904.99554443359375, 503.59613037109375, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+4, 180405, 0, 1537, 1537, '0', 0, 0, -4936.35791015625, -943.3858642578125, 503.58935546875, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+5, 180405, 0, 1537, 1537, '0', 0, 0, -4938.49755859375, -927.9288330078125, 503.59613037109375, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+6, 180405, 0, 1537, 1537, '0', 0, 0, -4888.81005859375, -913.69891357421875, 503.58935546875, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+7, 180405, 0, 1537, 1537, '0', 0, 0, -4978.9833984375, -971.4383544921875, 503.59613037109375, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+8, 180405, 0, 1537, 1537, '0', 0, 0, -4853.765625, -880.60284423828125, 501.6593017578125, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+9, 180405, 0, 1537, 1537, '0', 0, 0, -4842.84033203125, -874.50225830078125, 511.13970947265625, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+10, 180405, 0, 1537, 1537, '0', 0, 0, -4875.7529296875, -948.45355224609375, 503.399261474609375, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+11, 180405, 0, 1537, 5719, '0', 0, 0, -4900.6884765625, -971.5928955078125, 503.59967041015625, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: The Commons - Difficulty: 0) +(@OGUID+12, 180405, 0, 1537, 5719, '0', 0, 0, -4915.74072265625, -980.40765380859375, 501.446014404296875, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: The Commons - Difficulty: 0) +(@OGUID+13, 180405, 0, 1537, 5719, '0', 0, 0, -4926.08447265625, -996.48114013671875, 509.854888916015625, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: The Commons - Difficulty: 0) +(@OGUID+14, 180406, 0, 1537, 1537, '0', 0, 0, -4949.3046875, -921.61480712890625, 514.82037353515625, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+15, 180406, 0, 1537, 1537, '0', 0, 0, -4946.80859375, -913.25390625, 504.265350341796875, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+16, 180406, 0, 1537, 1537, '0', 0, 0, -4930.08251953125, -938.236328125, 503.58935546875, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+17, 180406, 0, 1537, 1537, '0', 0, 0, -4894.27880859375, -901.64935302734375, 503.59613037109375, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+18, 180406, 0, 1537, 1537, '0', 0, 0, -4974.2509765625, -964.82855224609375, 503.59613037109375, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+19, 180406, 0, 1537, 1537, '0', 0, 0, -4968.23681640625, -979.19378662109375, 503.58935546875, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+20, 180406, 0, 1537, 1537, '0', 0, 0, -4842.47265625, -876.994140625, 503.18011474609375, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+21, 180406, 0, 1537, 1537, '0', 0, 0, -4836.2900390625, -873.71954345703125, 511.13970947265625, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+22, 180406, 0, 1537, 1537, '0', 0, 0, -4835.505859375, -860.6971435546875, 501.913787841796875, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+23, 180406, 0, 1537, 1537, '0', 0, 0, -4882.04052734375, -958.47637939453125, 505.988189697265625, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+24, 180406, 0, 1537, 5719, '0', 0, 0, -4876.5732421875, -998.62762451171875, 506.957855224609375, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: The Commons - Difficulty: 0) +(@OGUID+25, 180406, 0, 1537, 5719, '0', 0, 0, -4939.24609375, -999.1815185546875, 503.487640380859375, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: The Commons - Difficulty: 0) +(@OGUID+26, 180407, 0, 1537, 1537, '0', 0, 0, -5018.09130859375, -827.22796630859375, 505.487213134765625, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+27, 180407, 0, 1537, 1537, '0', 0, 0, -4940.6220703125, -914.50823974609375, 514.966064453125, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+28, 180407, 0, 1537, 1537, '0', 0, 0, -4944.7734375, -933.1199951171875, 503.59613037109375, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+29, 180407, 0, 1537, 1537, '0', 0, 0, -4896.19677734375, -917.08355712890625, 503.58935546875, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+30, 180407, 0, 1537, 1537, '0', 0, 0, -4963.49853515625, -972.52911376953125, 503.58935546875, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+31, 180407, 0, 1537, 1537, '0', 0, 0, -4835.7294921875, -860.53656005859375, 510.247833251953125, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+32, 180407, 0, 1537, 1537, '0', 0, 0, -4839.59033203125, -874.0457763671875, 511.13970947265625, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+33, 180407, 0, 1537, 1537, '0', 0, 0, -4881.75634765625, -950.1873779296875, 503.399261474609375, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+34, 180407, 0, 1537, 5719, '0', 0, 0, -4909.0869140625, -978.534423828125, 503.59967041015625, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: The Commons - Difficulty: 0) +(@OGUID+35, 180407, 0, 1537, 5719, '0', 0, 0, -4922.03759765625, -985.384765625, 501.451324462890625, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: The Commons - Difficulty: 0) +(@OGUID+36, 180407, 0, 1537, 5719, '0', 0, 0, -4936.35498046875, -995.56488037109375, 503.487640380859375, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: The Commons - Difficulty: 0) +(@OGUID+37, 180407, 0, 1537, 5719, '0', 0, 0, -4886.5703125, -1007.10821533203125, 506.957855224609375, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: The Commons - Difficulty: 0) +(@OGUID+38, 180411, 0, 1537, 1537, '0', 0, 0, -4849.771484375, -878.50732421875, 506.66607666015625, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+39, 180411, 0, 1537, 5719, '0', 0, 0, -4883.40625, -1001.21881103515625, 508.31005859375, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 45745), -- G_Ghost_01 (Area: The Commons - Difficulty: 0) +(@OGUID+40, 180415, 0, 1537, 1537, '0', 0, 0, -4957.9287109375, -928.28179931640625, 505.37689208984375, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+41, 180415, 0, 1537, 1537, '0', 0, 0, -4941.94775390625, -915.01739501953125, 505.37689208984375, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+42, 180415, 0, 1537, 1537, '0', 0, 0, -4943.302734375, -916.166259765625, 505.37689208984375, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+43, 180415, 0, 1537, 1537, '0', 0, 0, -4955.7431640625, -896.0538330078125, 505.200958251953125, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+44, 180415, 0, 1537, 1537, '0', 0, 0, -4959.265625, -929.35577392578125, 505.37689208984375, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+45, 180415, 0, 1537, 1537, '0', 0, 0, -4955.1982421875, -926.044189453125, 505.37689208984375, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+46, 180415, 0, 1537, 1537, '0', 0, 0, -4960.6396484375, -930.4656982421875, 505.37689208984375, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+47, 180415, 0, 1537, 1537, '0', 0, 0, -4956.62841796875, -927.19097900390625, 505.37689208984375, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+48, 180415, 0, 1537, 1537, '0', 0, 0, -4940.43994140625, -913.79864501953125, 505.37689208984375, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+49, 180415, 0, 1537, 1537, '0', 0, 0, -4937.15625, -911.08538818359375, 505.37689208984375, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+50, 180415, 0, 1537, 1537, '0', 0, 0, -4955.5537109375, -896.262939453125, 505.04833984375, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+51, 180415, 0, 1537, 1537, '0', 0, 0, -4938.955078125, -912.55645751953125, 505.37689208984375, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+52, 180415, 0, 1537, 1537, '0', 0, 0, -4846.251953125, -865.09375, 502.74017333984375, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+53, 180415, 0, 1537, 1537, '0', 0, 0, -4849.1953125, -865.3992919921875, 511.16314697265625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+54, 180415, 0, 1537, 1537, '0', 0, 0, -4837.81591796875, -867.01214599609375, 502.8790283203125, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+55, 180425, 0, 1537, 1537, '0', 0, 0, -4958.61474609375, -928.82183837890625, 505.37689208984375, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+56, 180425, 0, 1537, 1537, '0', 0, 0, -4955.93701171875, -926.625244140625, 505.37689208984375, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+57, 180425, 0, 1537, 1537, '0', 0, 0, -4942.63330078125, -915.615234375, 505.37689208984375, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+58, 180425, 0, 1537, 1537, '0', 0, 0, -4959.98681640625, -929.9571533203125, 505.37689208984375, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+59, 180425, 0, 1537, 1537, '0', 0, 0, -4957.25341796875, -927.7078857421875, 505.37689208984375, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+60, 180425, 0, 1537, 1537, '0', 0, 0, -4955.84814453125, -896.46124267578125, 505.221954345703125, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+61, 180425, 0, 1537, 1537, '0', 0, 0, -4938.1318359375, -911.855712890625, 505.37689208984375, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+62, 180425, 0, 1537, 1537, '0', 0, 0, -4939.71044921875, -913.1580810546875, 505.37689208984375, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+63, 180425, 0, 1537, 1537, '0', 0, 0, -4941.24072265625, -914.404296875, 505.37689208984375, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+64, 180425, 0, 1537, 1537, '0', 0, 0, -4846.0537109375, -864.82464599609375, 502.87213134765625, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+65, 180425, 0, 1537, 1537, '0', 0, 0, -4849.30029296875, -866.21875, 511.211822509765625, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+66, 180425, 0, 1537, 1537, '0', 0, 0, -4837.330078125, -865.61456298828125, 502.879119873046875, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+67, 180426, 0, 1537, 1537, '0', 0, 0, -4931.57666015625, -947.78472900390625, 513.38287353515625, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+68, 180426, 0, 1537, 1537, '0', 0, 0, -4927.861328125, -945.00518798828125, 515.46136474609375, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+69, 180426, 0, 1537, 1537, '0', 0, 0, -4928.8525390625, -947.6180419921875, 509.7388916015625, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+70, 180426, 0, 1537, 1537, '0', 0, 0, -4928.72216796875, -947.59893798828125, 511.9814453125, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+71, 180426, 0, 1537, 1537, '0', 0, 0, -4928.7412109375, -947.609375, 514.09259033203125, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+72, 180426, 0, 1537, 1537, '0', 0, 0, -4928.96337890625, -950.28302001953125, 515.3365478515625, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+73, 180426, 0, 1537, 1537, '0', 0, 0, -4928.69091796875, -947.43927001953125, 521.35711669921875, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+74, 180426, 0, 1537, 1537, '0', 0, 0, -4928.671875, -947.66839599609375, 514.348876953125, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+75, 180426, 0, 1537, 1537, '0', 0, 0, -4925.87841796875, -947.7586669921875, 516.1114501953125, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+76, 180426, 0, 1537, 1537, '0', 0, 0, -4928.8681640625, -947.52606201171875, 517.66998291015625, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+77, 180427, 0, 1537, 1537, '0', 0, 0, -4928.73779296875, -947.52777099609375, 511.884674072265625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+78, 180427, 0, 1537, 1537, '0', 0, 0, -4928.8193359375, -947.4757080078125, 510.558929443359375, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+79, 180427, 0, 1537, 1537, '0', 0, 0, -4928.8662109375, -947.6319580078125, 511.35693359375, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+80, 180427, 0, 1537, 1537, '0', 0, 0, -4928.9462890625, -947.83331298828125, 512.134033203125, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+81, 180427, 0, 1537, 1537, '0', 0, 0, -4926.798828125, -946.28643798828125, 512.2135009765625, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+82, 180427, 0, 1537, 1537, '0', 0, 0, -4928.751953125, -947.8507080078125, 511.09136962890625, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+83, 180427, 0, 1537, 1537, '0', 0, 0, -4927.2880859375, -949.342041015625, 513.88909912109375, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+84, 180427, 0, 1537, 1537, '0', 0, 0, -4928.5869140625, -947.76214599609375, 513.11883544921875, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+85, 180427, 0, 1537, 1537, '0', 0, 0, -4928.41162109375, -947.6007080078125, 513.528564453125, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+86, 180427, 0, 1537, 1537, '0', 0, 0, -4930.28662109375, -948.92364501953125, 509.870819091796875, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+87, 180471, 0, 1537, 1537, '0', 0, 0, -4934.767578125, -910.578125, 510.15924072265625, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+88, 180471, 0, 1537, 1537, '0', 0, 0, -4960.97216796875, -932.6805419921875, 509.7530517578125, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+89, 180471, 0, 1537, 1537, '0', 0, 0, -4947.46533203125, -920.88543701171875, 509.991363525390625, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+90, 180471, 0, 1537, 1537, '0', 0, 0, -4955.48095703125, -928.0555419921875, 509.8668212890625, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+91, 180471, 0, 1537, 1537, '0', 0, 0, -4937.27783203125, -912.6632080078125, 510.1572265625, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+92, 180471, 0, 1537, 1537, '0', 0, 0, -4952.8056640625, -925.55035400390625, 509.851287841796875, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+93, 180471, 0, 1537, 1537, '0', 0, 0, -4945.0712890625, -918.95831298828125, 509.975799560546875, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+94, 180471, 0, 1537, 1537, '0', 0, 0, -4950.1962890625, -923.3194580078125, 509.88177490234375, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+95, 180471, 0, 1537, 1537, '0', 0, 0, -4942.47900390625, -916.8350830078125, 509.991851806640625, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+96, 180471, 0, 1537, 1537, '0', 0, 0, -4939.85595703125, -914.72222900390625, 510.08544921875, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+97, 180471, 0, 1537, 1537, '0', 0, 0, -4958.2744140625, -930.33856201171875, 509.757476806640625, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+98, 180472, 0, 1537, 1537, '0', 0, 0, -4842.5693359375, -857.8194580078125, 506.665313720703125, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Ironforge - Difficulty: 0) +(@OGUID+99, 180472, 0, 1537, 5719, '0', 0, 0, -4896.71875, -1003.2882080078125, 508.574493408203125, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: The Commons - Difficulty: 0) +(@OGUID+100, 180472, 0, 1537, 5719, '0', 0, 0, -4887.74853515625, -995.8497314453125, 508.6065673828125, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: The Commons - Difficulty: 0) +(@OGUID+101, 180472, 0, 1537, 5719, '0', 0, 0, -4878.736328125, -988.529541015625, 508.603424072265625, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: The Commons - Difficulty: 0) +(@OGUID+102, 180523, 0, 1537, 1537, '0', 0, 0, -4839.1806640625, -863.86456298828125, 510.518280029296875, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 45745), -- Apple Bob (Area: Ironforge - Difficulty: 0) +(@OGUID+103, 190039, 0, 1537, 1537, '0', 0, 0, -4838.04443359375, -858.582275390625, 502.78167724609375, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 45745); -- Candy Bucket (Area: Ironforge - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid` IN (@CGUID+0, @CGUID+1); +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(12, @CGUID+0), +(12, @CGUID+1); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+103; +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); diff --git a/sql/updates/world/master/2023_11_08_05_world_dun_morogh_kharanos.sql b/sql/updates/world/master/2023_11_08_05_world_dun_morogh_kharanos.sql new file mode 100644 index 00000000000..64b967060c6 --- /dev/null +++ b/sql/updates/world/master/2023_11_08_05_world_dun_morogh_kharanos.sql @@ -0,0 +1,200 @@ +SET @CGUID := 3000249; +SET @OGUID := 3004287; + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN 222573 AND 222619; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 222573 AND 222619; + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+46; +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, 727, 0, 1, 131, '0', 0, 0, 0, 1, -5753.5478515625, -486.14599609375, 397.446533203125, 4.764749050140380859, 120, 0, 0, 3208, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Ironforge Mountaineer (Area: Kharanos - Difficulty: 0) +(@CGUID+1, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5592.62939453125, -513.1434326171875, 413.200286865234375, 0.418879032135009765, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+2, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5569.30029296875, -453.50531005859375, 413.957122802734375, 0.244346097111701965, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire, 42091 - Headless Horseman - Fire Size) +(@CGUID+3, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5602.48876953125, -512.93988037109375, 413.349609375, 4.555309295654296875, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+4, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5591.30908203125, -451.56011962890625, 414.119140625, 6.195918560028076171, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+5, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5576.232421875, -528.524658203125, 413.310516357421875, 4.415682792663574218, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+6, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5610.64404296875, -513.148681640625, 413.48809814453125, 3.124139308929443359, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+7, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5600.7197265625, -513.49688720703125, 409.49169921875, 5.410520553588867187, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+8, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5561.84130859375, -445.294921875, 413.864013671875, 4.729842185974121093, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+9, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5577.59716796875, -462.362640380859375, 414.413116455078125, 2.234021425247192382, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+10, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5570.11767578125, -459.232330322265625, 414.162139892578125, 6.056292533874511718, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire, 42091 - Headless Horseman - Fire Size) +(@CGUID+11, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5576.17626953125, -506.083984375, 413.802886962890625, 0.314159274101257324, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+12, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5611.57666015625, -517.38531494140625, 413.508026123046875, 4.066617012023925781, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+13, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5590.50634765625, -503.79644775390625, 413.6107177734375, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire) +(@CGUID+14, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5578.97119140625, -515.63604736328125, 418.2305908203125, 3.071779489517211914, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+15, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5587.3701171875, -456.188690185546875, 414.337158203125, 3.577924966812133789, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+16, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5579.26025390625, -504.0714111328125, 413.870361328125, 2.687807083129882812, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+17, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5606.1171875, -513.9608154296875, 413.425750732421875, 1.239183783531188964, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+18, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5592.69775390625, -508.243499755859375, 413.198577880859375, 1.117010712623596191, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire) +(@CGUID+19, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5591.3349609375, -506.9825439453125, 416.902099609375, 3.298672199249267578, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire) +(@CGUID+20, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5576.13818359375, -520.48175048828125, 413.36090087890625, 3.50811171531677246, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+21, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5590.603515625, -512.17742919921875, 417.089080810546875, 2.460914134979248046, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+22, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5573.0166015625, -462.277130126953125, 414.32763671875, 1.553343057632446289, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire, 42091 - Headless Horseman - Fire Size) +(@CGUID+23, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5586.5224609375, -462.394744873046875, 414.571014404296875, 5.759586334228515625, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+24, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5565.75927734375, -450.4853515625, 413.891448974609375, 3.892084121704101562, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire, 42091 - Headless Horseman - Fire Size) +(@CGUID+25, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5597.5849609375, -513.343994140625, 413.274566650390625, 1.361356854438781738, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+26, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5578.8701171875, -510.202484130859375, 418.157562255859375, 0.959931075572967529, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+27, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5576.0546875, -511.168304443359375, 413.390380859375, 1.989675283432006835, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+28, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5581.982421875, -462.513336181640625, 414.499481201171875, 5.497786998748779296, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+29, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5565.82080078125, -445.305572509765625, 414.1419677734375, 0.122173048555850982, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+30, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5581.326171875, -520.92547607421875, 413.45751953125, 4.450589656829833984, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+31, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5595.66650390625, -513.594970703125, 409.415008544921875, 2.775073528289794921, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+32, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5605.53125, -513.3857421875, 409.533447265625, 1.448623299598693847, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+33, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5576.083984375, -524.460205078125, 413.22607421875, 0.366519153118133544, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+34, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5576.19140625, -515.56134033203125, 413.4317626953125, 2.076941728591918945, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+35, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5595.75341796875, -447.16253662109375, 414.118377685546875, 2.408554315567016601, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+36, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5581.23291015625, -527.37664794921875, 415.252410888671875, 0.383972436189651489, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+37, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5747.29638671875, -527.312744140625, 400.115203857421875, 1.274090290069580078, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42096 - Headless Horseman - Fire onSpawn, Size, 42091 - Headless Horseman - Fire Size, 42074 - Headless Horseman - Fire) +(@CGUID+38, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5754.14794921875, -526.8839111328125, 402.474517822265625, 1.047197580337524414, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42112 - Headless Horseman - Update Size) +(@CGUID+39, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5758.3759765625, -522.03582763671875, 399.287109375, 2.199114799499511718, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) (Auras: 42112 - Headless Horseman - Update Size) +(@CGUID+40, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5753.0244140625, -532.90118408203125, 404.06353759765625, 0.663225114345550537, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) +(@CGUID+41, 23537, 0, 1, 131, '0', 0, 0, 0, 0, -5761.04443359375, -528.05767822265625, 403.967010498046875, 1.064650893211364746, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Kharanos - Difficulty: 0) +(@CGUID+42, 23712, 0, 1, 131, '0', 0, 0, 0, 0, -5622.77587890625, -470.675445556640625, 397.39288330078125, 5.340707302093505859, 120, 0, 0, 41, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Touring Orphan (Area: Kharanos - Difficulty: 0) +(@CGUID+43, 23712, 0, 1, 131, '0', 0, 0, 0, 0, -5623.98876953125, -472.76129150390625, 397.1551513671875, 5.934119224548339843, 120, 0, 0, 34, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Touring Orphan (Area: Kharanos - Difficulty: 0) +(@CGUID+44, 23712, 0, 1, 131, '0', 0, 0, 0, 0, -5620.98828125, -471.1534423828125, 397.332916259765625, 5.480333805084228515, 120, 0, 0, 34, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Touring Orphan (Area: Kharanos - Difficulty: 0) +(@CGUID+45, 23712, 0, 1, 131, '0', 0, 0, 0, 0, -5622.87353515625, -474.229705810546875, 397.0635986328125, 5.916666030883789062, 120, 0, 0, 34, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Touring Orphan (Area: Kharanos - Difficulty: 0) +(@CGUID+46, 24519, 0, 1, 131, '0', 0, 0, 0, 0, -5621.9462890625, -472.836700439453125, 397.14019775390625, 5.672319889068603515, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745); -- Costumed Orphan Matron (Area: Kharanos - Difficulty: 0) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 166055 AND 166095; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 166055 AND 166095; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+40; +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, 1, 131, '0', 0, 0, -5636.83349609375, -498.25, 399.752410888671875, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Kharanos - Difficulty: 0) +(@OGUID+1, 180405, 0, 1, 131, '0', 0, 0, -5585.7587890625, -461.76458740234375, 414.433380126953125, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Kharanos - Difficulty: 0) +(@OGUID+2, 180405, 0, 1, 131, '0', 0, 0, -5636.26708984375, -530.2227783203125, 404.7664794921875, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Kharanos - Difficulty: 0) +(@OGUID+3, 180406, 0, 1, 131, '0', 0, 0, -5611.35205078125, -513.34161376953125, 413.419525146484375, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Kharanos - Difficulty: 0) +(@OGUID+4, 180406, 0, 1, 131, '0', 0, 0, -5576.09375, -504.130218505859375, 413.209136962890625, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Kharanos - Difficulty: 0) +(@OGUID+5, 180406, 0, 1, 131, '0', 0, 0, -5579.09228515625, -461.78570556640625, 414.31842041015625, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Kharanos - Difficulty: 0) +(@OGUID+6, 180407, 0, 1, 131, '0', 0, 0, -5591.71728515625, -507.606109619140625, 405.010467529296875, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Kharanos - Difficulty: 0) +(@OGUID+7, 180407, 0, 1, 131, '0', 0, 0, -5587.2744140625, -531.5355224609375, 399.651641845703125, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Kharanos - Difficulty: 0) +(@OGUID+8, 180407, 0, 1, 131, '0', 0, 0, -5572.81689453125, -461.663787841796875, 414.200958251953125, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Kharanos - Difficulty: 0) +(@OGUID+9, 180407, 0, 1, 131, '0', 0, 0, -5477.36962890625, -459.368011474609375, 398.4930419921875, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Kharanos - Difficulty: 0) +(@OGUID+10, 180410, 0, 1, 131, '0', 0, 0, -5600.61083984375, -519.86065673828125, 401.59832763671875, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Kharanos - Difficulty: 0) +(@OGUID+11, 180411, 0, 1, 131, '0', 0, 0, -5579.19091796875, -436.064239501953125, 402.61480712890625, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Kharanos - Difficulty: 0) +(@OGUID+12, 180415, 0, 1, 131, '0', 0, 0, -5586.52978515625, -534.69964599609375, 404.420013427734375, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 45745), -- CandleBlack01 (Area: Kharanos - Difficulty: 0) +(@OGUID+13, 180415, 0, 1, 131, '0', 0, 0, -5594.556640625, -526.07012939453125, 400.373809814453125, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 45745), -- CandleBlack01 (Area: Kharanos - Difficulty: 0) +(@OGUID+14, 180425, 0, 1, 131, '0', 0, 0, -5586.76025390625, -534.98089599609375, 404.455078125, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 45745), -- SkullCandle01 (Area: Kharanos - Difficulty: 0) +(@OGUID+15, 180425, 0, 1, 131, '0', 0, 0, -5601.1630859375, -525.24481201171875, 400.5550537109375, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 45745), -- SkullCandle01 (Area: Kharanos - Difficulty: 0) +(@OGUID+16, 180471, 0, 1, 131, '0', 0, 0, -5585.8818359375, -462.482635498046875, 411.03558349609375, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Kharanos - Difficulty: 0) +(@OGUID+17, 180471, 0, 1, 131, '0', 0, 0, -5572.96875, -462.4913330078125, 410.719879150390625, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Kharanos - Difficulty: 0) +(@OGUID+18, 180472, 0, 1, 131, '0', 0, 0, -5578.98974609375, -462.439239501953125, 412.27301025390625, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Kharanos - Difficulty: 0) +(@OGUID+19, 180472, 0, 1, 131, '0', 0, 0, -5605.22216796875, -531.842041015625, 402.5753173828125, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Kharanos - Difficulty: 0) +(@OGUID+20, 180523, 0, 1, 131, '0', 0, 0, -5584.79052734375, -539.92950439453125, 404.089324951171875, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 45745), -- Apple Bob (Area: Kharanos - Difficulty: 0) +(@OGUID+21, 180700, 0, 1, 131, '0', 0, 0, -5747.55810546875, -527.714599609375, 400.000579833984375, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Kharanos - Difficulty: 0) +(@OGUID+22, 180700, 0, 1, 131, '0', 0, 0, -5746.9794921875, -529.003662109375, 399.285064697265625, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Kharanos - Difficulty: 0) +(@OGUID+23, 180700, 0, 1, 131, '0', 0, 0, -5753.1630859375, -533.396240234375, 403.65386962890625, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Kharanos - Difficulty: 0) +(@OGUID+24, 180700, 0, 1, 131, '0', 0, 0, -5752.77197265625, -533.24114990234375, 403.9241943359375, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Kharanos - Difficulty: 0) +(@OGUID+25, 180700, 0, 1, 131, '0', 0, 0, -5757.09326171875, -522.66571044921875, 398.45355224609375, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Kharanos - Difficulty: 0) +(@OGUID+26, 180700, 0, 1, 131, '0', 0, 0, -5758.15673828125, -521.982666015625, 399.159027099609375, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Kharanos - Difficulty: 0) +(@OGUID+27, 180700, 0, 1, 131, '0', 0, 0, -5753.9140625, -526.596435546875, 402.29656982421875, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Kharanos - Difficulty: 0) +(@OGUID+28, 180700, 0, 1, 131, '0', 0, 0, -5752.87939453125, -527.554931640625, 402.026458740234375, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Kharanos - Difficulty: 0) +(@OGUID+29, 180700, 0, 1, 131, '0', 0, 0, -5760.94287109375, -528.08416748046875, 403.882415771484375, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 45745), -- Hay Bale 1 (Area: Kharanos - Difficulty: 0) +(@OGUID+30, 186234, 0, 1, 131, '0', 0, 0, -5751.90087890625, -483.79339599609375, 396.50201416015625, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 45745), -- Water Barrel (Area: Kharanos - Difficulty: 0) +(@OGUID+31, 186234, 0, 1, 131, '0', 0, 0, -5624.01611328125, -478.673828125, 396.980255126953125, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 45745), -- Water Barrel (Area: Kharanos - Difficulty: 0) +(@OGUID+32, 186614, 0, 1, 131, '0', 0, 0, -5622.24609375, -478.1807861328125, 396.980255126953125, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 45745), -- Water Bucket (Area: Kharanos - Difficulty: 0) +(@OGUID+33, 186614, 0, 1, 131, '0', 0, 0, -5623.4853515625, -477.085845947265625, 396.980255126953125, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 45745), -- Water Bucket (Area: Kharanos - Difficulty: 0) +(@OGUID+34, 186615, 0, 1, 131, '0', 0, 0, -5625.37158203125, -477.26605224609375, 396.862213134765625, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 45745), -- Water Buckets (Area: Kharanos - Difficulty: 0) +(@OGUID+35, 186720, 0, 1, 131, '0', 0, 0, -5747.51708984375, -527.633544921875, 400.29693603515625, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 45745), -- Fire Effigy (Area: Kharanos - Difficulty: 0) +(@OGUID+36, 186720, 0, 1, 131, '0', 0, 0, -5753.23779296875, -533.6519775390625, 404.02215576171875, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 45745), -- Fire Effigy (Area: Kharanos - Difficulty: 0) +(@OGUID+37, 186720, 0, 1, 131, '0', 0, 0, -5754.20556640625, -527.0972900390625, 402.495208740234375, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 45745), -- Fire Effigy (Area: Kharanos - Difficulty: 0) +(@OGUID+38, 186720, 0, 1, 131, '0', 0, 0, -5758.470703125, -521.98565673828125, 399.218231201171875, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 45745), -- Fire Effigy (Area: Kharanos - Difficulty: 0) +(@OGUID+39, 186720, 0, 1, 131, '0', 0, 0, -5761.1650390625, -528.19342041015625, 403.854522705078125, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 45745), -- Fire Effigy (Area: Kharanos - Difficulty: 0) +(@OGUID+40, 190036, 0, 1, 131, '0', 0, 0, -5598.9833984375, -531.22772216796875, 399.65155029296875, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 45745); -- Candy Bucket (Area: Kharanos - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid` BETWEEN @CGUID+0 AND @CGUID+46; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(12, @CGUID+0), +(12, @CGUID+1), +(12, @CGUID+2), +(12, @CGUID+3), +(12, @CGUID+4), +(12, @CGUID+5), +(12, @CGUID+6), +(12, @CGUID+7), +(12, @CGUID+8), +(12, @CGUID+9), +(12, @CGUID+10), +(12, @CGUID+11), +(12, @CGUID+12), +(12, @CGUID+13), +(12, @CGUID+14), +(12, @CGUID+15), +(12, @CGUID+16), +(12, @CGUID+17), +(12, @CGUID+18), +(12, @CGUID+19), +(12, @CGUID+20), +(12, @CGUID+21), +(12, @CGUID+22), +(12, @CGUID+23), +(12, @CGUID+24), +(12, @CGUID+25), +(12, @CGUID+26), +(12, @CGUID+27), +(12, @CGUID+28), +(12, @CGUID+29), +(12, @CGUID+30), +(12, @CGUID+31), +(12, @CGUID+32), +(12, @CGUID+33), +(12, @CGUID+34), +(12, @CGUID+35), +(12, @CGUID+36), +(12, @CGUID+37), +(12, @CGUID+38), +(12, @CGUID+39), +(12, @CGUID+40), +(12, @CGUID+41), +(12, @CGUID+42), +(12, @CGUID+43), +(12, @CGUID+44), +(12, @CGUID+45), +(12, @CGUID+46); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+40; +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); |