diff options
| -rw-r--r-- | sql/updates/world/master/2023_02_20_05_world.sql | 248 |
1 files changed, 248 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_02_20_05_world.sql b/sql/updates/world/master/2023_02_20_05_world.sql new file mode 100644 index 00000000000..16476b2a390 --- /dev/null +++ b/sql/updates/world/master/2023_02_20_05_world.sql @@ -0,0 +1,248 @@ +SET @CGUID := 3000021; +SET @OGUID := 3000635; +SET @EVENT := 8; + +-- Creature templates +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=38293; -- Junior Inspector +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=38041; -- Kwee Q. Peddlefeet + +DELETE FROM `creature_template_addon` WHERE `entry` IN (38293, 38041); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(38293, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 38293 (Junior Inspector) +(38041, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- 38041 (Kwee Q. Peddlefeet) + +-- Equipments +UPDATE `creature_equip_template` SET `VerifiedBuild`=48069 WHERE (`ID`=1 AND `CreatureID` IN (175410,175403,96490,53544,52584,52335,52321,51978,51383,50732,50729,50723,50720,50717,50716,50309,50308,47582,42928,42147,42146,42131,39718,35073,35007,34991,30717,27478,23127,15119,14367,14365,14363,14183,13843,11146,11145,11065,11029,11028,10455,10277,10276,9616,8879,7976,7950,7944,7312,7298,6382,6291,6181,6179,6178,6169,6114,6031,5637,5605,5595,5570,5569,5178,5177,5175,5174,5173,5172,5171,5170,5169,5167,5166,5165,5163,5162,5161,5160,5159,5152,5151,5149,5148,5147,5146,5145,5144,5143,5142,5141,5140,5138,5137,5133,5130,5126,5124,5122,5121,5120,5119,5117,5116,5115,5114,5113,5112,5111,5110,5109,5107,5106,5103,5102,5101,5100,4259,4258,4256,4254,3979,2918,2916,2790,2786,2737,2695,2489,2092,1959,1901,1703,1573,1356)); + +-- Models +UPDATE `creature_model_info` SET `VerifiedBuild`=48069 WHERE `DisplayID` IN (109714, 109476, 99617, 99600, 74943, 65406, 64921, 24979, 26184, 43152, 15395, 37957, 37956, 37844, 37836, 37695, 37693, 37514, 37401, 99841, 99839, 99842, 37350, 37351, 36940, 36941, 36938, 36934, 36936, 36937, 37017, 37018, 36357, 36342, 35706, 33140, 9288, 8826, 32681, 32680, 35687, 29573, 29520, 29512, 27298, 27274, 22397, 21265, 15986, 15965, 15238, 14405, 14404, 14396, 14235, 13850, 11053, 10694, 10693, 10588, 10722, 10571, 10184, 9821, 9818, 9740, 9741, 9338, 9258, 9131, 8829, 8353, 8171, 7989, 7951, 7990, 7598, 7805, 7769, 7119, 7120, 7041, 7028, 7003, 6072, 6062, 6588, 5647, 5377, 5085, 4988, 4986, 4893, 4892, 4891, 4889, 4999, 4865, 4995, 4950, 3756, 3591, 77915, 3526, 3527, 99838, 99836, 3524, 3525, 99837, 3458, 3457, 3596, 3125, 3124, 3118, 3117, 3122, 3116, 3115, 3103, 3114, 3113, 3100, 3101, 3112, 3121, 3096, 3095, 3094, 3120, 3111, 3071, 3070, 3069, 3091, 3110, 3119, 3068, 3087, 3088, 3089, 3109, 10214, 3108, 3085, 3066, 3086, 3065, 3064, 3063, 3082, 3107, 3081, 3106, 3105, 3104, 3080, 3079, 3078, 5408, 3077, 3076, 3057, 3075, 3073, 3072, 3056, 3055, 3054, 3051, 3047, 3046, 3050, 3049, 3045, 3044, 3043, 3042, 3041, 3040, 3039, 2999, 3098, 3097, 3093, 3092, 2184, 2049, 1935, 7916, 3598, 3595, 5410, 3599, 9817, 1670, 10548, 3038, 3037, 3600, 1891, 3053, 10629, 3007, 10620, 3594, 1655, 10635); +UPDATE `creature_model_info` SET `BoundingRadius`=0.199706122279167175, `CombatReach`=0.719999969005584716, `VerifiedBuild`=48069 WHERE `DisplayID`=88407; +UPDATE `creature_model_info` SET `BoundingRadius`=0.166421771049499511, `CombatReach`=0.60000002384185791, `VerifiedBuild`=48069 WHERE `DisplayID`=5554; + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (197776,197249,38293,38041)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(197776, 0, 0, 0, 2474, 48069), +(197249, 0, 0, 0, 868, 48069), +(38293, 0, 0, 0, 378, 48069), +(38041, 0, 0, 0, 378, 48069); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=48069 WHERE (`DifficultyID`=0 AND `Entry` IN (175412,175411,175410,175403,118889,97762,96490,62425,61690,61317,53568,53544,52586,52584,52335,52321,51978,51976,51596,51495,51383,50732,50729,50723,50720,50717,50716,50309,50308,48972,48935,47582,42928,42152,42147,42146,42131,42129,39718,35073,35007,34991,30733,30717,29141,27478,24110,23127,16070,16013,15119,14367,14365,14363,14183,13843,11406,11146,11145,11065,11029,11028,10877,10456,10455,10277,10276,10090,9984,9859,9616,9099,8879,8720,8681,8671,8517,8507,8256,7978,7976,7950,7944,7936,7312,7298,7292,6826,6569,6382,6294,6291,6181,6179,6178,6175,6169,6120,6114,6031,5637,5605,5595,5570,5569,5387,5178,5177,5175,5174,5173,5172,5171,5170,5169,5167,5166,5165,5163,5162,5161,5160,5159,5158,5157,5156,5155,5154,5153,5152,5151,5150,5149,5148,5147,5146,5145,5144,5143,5142,5141,5140,5138,5137,5133,5132,5130,5129,5128,5127,5126,5125,5124,5123,5122,5121,5120,5119,5117,5116,5115,5114,5113,5112,5111,5110,5109,5108,5107,5106,5103,5102,5101,5100,5099,5049,4259,4258,4256,4254,4081,3979,3842,2943,2918,2916,2790,2786,2737,2695,2489,2461,2460,2092,1959,1901,1703,1573,1466,1356,1274,1246)); + +-- Quests +UPDATE `quest_poi` SET `VerifiedBuild`=48069 WHERE (`QuestID`=24609 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=24609 AND `BlobIndex`=0 AND `Idx1`=0); + +UPDATE `quest_poi_points` SET `VerifiedBuild`=48069 WHERE (`QuestID`=24609 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=24609 AND `Idx1`=0 AND `Idx2`=0); + +DELETE FROM `quest_details` WHERE `ID` IN (24609 /*A Gift for a Lord of Ironforge*/, 24804 /*Uncommon Scents*/); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(24609, 0, 0, 0, 0, 0, 0, 0, 0, 48069), -- A Gift for a Lord of Ironforge +(24804, 1, 0, 0, 0, 0, 0, 0, 0, 48069); -- Uncommon Scents + +DELETE FROM `creature_queststarter` WHERE (`id`=38041 AND `quest`=24609) OR (`id`=38293 AND `quest`=24804); +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(38041, 24609, 48069), -- A Gift for a Lord of Ironforge offered Kwee Q. Peddlefeet +(38293, 24804, 48069); -- Uncommon Scents offered Junior Inspector + +DELETE FROM `game_event_creature_quest` WHERE (`id`=38041 AND `quest`=24609) OR (`id`=38293 AND `quest`=24804); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+4; +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`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 37674, 0, 1537, 1537, '0', 0, 0, 0, 0, -4918.1474609375, -982.11114501953125, 502.711334228515625, 2.234021425247192382, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Lovely Merchant (Area: Ironforge - Difficulty: 0) (Auras: ) +(@CGUID+1, 37675, 0, 1537, 1537, '0', 0, 0, 0, 0, -4919.6875, -983.6163330078125, 502.696075439453125, 2.94960641860961914, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Public Relations Agent (Area: Ironforge - Difficulty: 0) (Auras: ) +(@CGUID+2, 38041, 0, 1537, 1537, '0', 0, 0, 0, 0, -4915.37841796875, -979.03643798828125, 501.531707763671875, 2.426007747650146484, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Kwee Q. Peddlefeet (Area: Ironforge - Difficulty: 0) +(@CGUID+3, 38293, 0, 1537, 1537, '0', 0, 0, 0, 0, -4933.3349609375, -993.22222900390625, 501.527679443359375, 0.872664630413055419, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Junior Inspector (Area: Ironforge - Difficulty: 0) +(@CGUID+4, 40438, 0, 1537, 1537, '0', 0, 0, 0, 0, -4939.44775390625, -937.36981201171875, 503.2398681640625, 0.767944872379302978, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069); -- Steamwheedle Shyster (Area: Ironforge - Difficulty: 0) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 84740 AND 84744; +DELETE FROM `gameobject` WHERE `guid` IN (83173, 83299, 84689, 84690); +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 84740 AND 84744; +DELETE FROM `game_event_gameobject` WHERE `guid` IN (83173, 83299, 84689, 84690); + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+84; +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, 181015, 0, 1537, 1537, '0', 0, 0, -4919.72216796875, -983.61285400390625, 501.455474853515625, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+1, 181015, 0, 1537, 1537, '0', 0, 0, -4918.15283203125, -982.19793701171875, 501.455291748046875, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+2, 181015, 0, 1537, 1537, '0', 0, 0, -4917.7900390625, -985.234375, 501.448577880859375, 0, 0, 0, 0, 1, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+3, 181015, 0, 1537, 1537, '0', 0, 0, -4917.01416015625, -984.74481201171875, 502.687286376953125, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+4, 181015, 0, 1537, 1537, '0', 0, 0, -4916.251953125, -984.53125, 501.447113037109375, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+5, 181016, 0, 1537, 1537, '0', 0, 0, -4990.28857421875, -853.3427734375, 501.659332275390625, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+6, 181016, 0, 1537, 1537, '0', 0, 0, -5018.2275390625, -855.9774169921875, 501.659332275390625, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+7, 181016, 0, 1537, 1537, '0', 0, 0, -4997.84912109375, -880.6900634765625, 501.659332275390625, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+8, 181016, 0, 1537, 1537, '0', 0, 0, -5000.1611328125, -841.3087158203125, 501.659332275390625, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+9, 181016, 0, 1537, 1537, '0', 0, 0, -5008.32275390625, -868.1883544921875, 501.659332275390625, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+10, 181016, 0, 1537, 1537, '0', 0, 0, -4980.03466796875, -865.87548828125, 501.659332275390625, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+11, 181016, 0, 1537, 5344, '0', 0, 0, -4623.98583984375, -917.63336181640625, 501.06304931640625, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Mystic Ward - Difficulty: 0) +(@OGUID+12, 181016, 0, 1537, 5344, '0', 0, 0, -4602.83056640625, -912.78594970703125, 501.066070556640625, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Mystic Ward - Difficulty: 0) +(@OGUID+13, 181016, 0, 1537, 5344, '0', 0, 0, -4618.0244140625, -925.11968994140625, 501.0621337890625, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Mystic Ward - Difficulty: 0) +(@OGUID+14, 181016, 0, 1537, 5344, '0', 0, 0, -4609.134765625, -905.39166259765625, 501.067718505859375, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Mystic Ward - Difficulty: 0) +(@OGUID+15, 181017, 0, 1537, 1537, '0', 0, 0, -4974.47900390625, -1033.467041015625, 509.7349853515625, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+16, 181017, 0, 1537, 1537, '0', 0, 0, -4880.09716796875, -957.7725830078125, 509.6275634765625, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+17, 181017, 0, 1537, 1537, '0', 0, 0, -4899.02783203125, -982.31427001953125, 510.77691650390625, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+18, 181017, 0, 1537, 5719, '0', 0, 0, -4849.923828125, -877.53643798828125, 506.388824462890625, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Commons - Difficulty: 0) +(@OGUID+19, 181017, 0, 1537, 5719, '0', 0, 0, -4840.26904296875, -859.96875, 506.08197021484375, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Commons - Difficulty: 0) +(@OGUID+20, 181017, 0, 1537, 5719, '0', 0, 0, -4798.3662109375, -908.9757080078125, 503.249847412109375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Commons - Difficulty: 0) +(@OGUID+21, 181017, 0, 1537, 5719, '0', 0, 0, -4765.7744140625, -913.38714599609375, 508.2344970703125, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Commons - Difficulty: 0) +(@OGUID+22, 181017, 0, 1537, 5719, '0', 0, 0, -4707.56591796875, -948.40972900390625, 509.871734619140625, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Commons - Difficulty: 0) +(@OGUID+23, 181017, 0, 1537, 5344, '0', 0, 0, -4730.88720703125, -1063.310791015625, 508.73834228515625, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Mystic Ward - Difficulty: 0) +(@OGUID+24, 181017, 0, 1537, 5344, '0', 0, 0, -4591.765625, -999.46356201171875, 508.2066650390625, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Mystic Ward - Difficulty: 0) +(@OGUID+25, 181017, 0, 1537, 5344, '0', 0, 0, -4601.875, -1010.21527099609375, 509.9107666015625, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Mystic Ward - Difficulty: 0) +(@OGUID+26, 181017, 0, 1537, 5344, '0', 0, 0, -4612.87841796875, -1093.2603759765625, 509.64056396484375, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Mystic Ward - Difficulty: 0) +(@OGUID+27, 181017, 0, 1537, 5344, '0', 0, 0, -4614.03662109375, -1114.4791259765625, 509.549957275390625, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Mystic Ward - Difficulty: 0) +(@OGUID+28, 181017, 0, 1537, 4679, '0', 0, 0, -4691.63525390625, -1183.8958740234375, 509.914825439453125, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Forlorn Cavern - Difficulty: 0) +(@OGUID+29, 181017, 0, 1537, 4679, '0', 0, 0, -4732.765625, -1146.4896240234375, 507.5391845703125, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Forlorn Cavern - Difficulty: 0) +(@OGUID+30, 181017, 0, 1537, 5341, '0', 0, 0, -4804.95654296875, -1180.3507080078125, 510.45892333984375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: Hall of Explorers - Difficulty: 0) +(@OGUID+31, 181017, 0, 1537, 0, '0', 0, 0, -4927.70654296875, -1279.470458984375, 509.795623779296875, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: 0 - Difficulty: 0) +(@OGUID+32, 181017, 0, 1537, 5343, '0', 0, 0, -4868.57470703125, -1144.732666015625, 510.406951904296875, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Military Ward - Difficulty: 0) +(@OGUID+33, 181017, 0, 1537, 5343, '0', 0, 0, -5017.75, -1125.0382080078125, 509.957183837890625, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Military Ward - Difficulty: 0) +(@OGUID+34, 181017, 0, 1537, 5343, '0', 0, 0, -5030.98095703125, -1153.90283203125, 509.76019287109375, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Military Ward - Difficulty: 0) +(@OGUID+35, 181017, 0, 1537, 5343, '0', 0, 0, -4989.77783203125, -1117.27783203125, 508.185760498046875, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Military Ward - Difficulty: 0) +(@OGUID+36, 181017, 0, 1537, 5343, '0', 0, 0, -5041.65283203125, -1166.185791015625, 508.227386474609375, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Military Ward - Difficulty: 0) +(@OGUID+37, 181017, 0, 1537, 5342, '0', 0, 0, -4847.69091796875, -1162.9617919921875, 508.74658203125, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: The Great Forge - Difficulty: 0) +(@OGUID+38, 181018, 0, 1537, 1537, '0', 0, 0, -4897.69091796875, -1002.0504150390625, 510.0543212890625, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+39, 181018, 0, 1537, 1537, '0', 0, 0, -4879.8349609375, -987.32989501953125, 509.98291015625, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+40, 181018, 0, 1537, 1537, '0', 0, 0, -4888.8212890625, -994.73785400390625, 510.048828125, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+41, 181019, 0, 1537, 1537, '0', 0, 0, -4905.373046875, -979.254150390625, 503.518463134765625, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+42, 181019, 0, 1537, 1537, '0', 0, 0, -4895.28857421875, -1001.1298828125, 504.7578125, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+43, 181019, 0, 1537, 1537, '0', 0, 0, -4900.673828125, -975.40972900390625, 503.49066162109375, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+44, 181019, 0, 1537, 1537, '0', 0, 0, -4899.34814453125, -1004.4788818359375, 504.7578125, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+45, 181019, 0, 1537, 1537, '0', 0, 0, -4886.38330078125, -993.6834716796875, 504.7578125, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+46, 181019, 0, 1537, 1537, '0', 0, 0, -4890.2255859375, -996.79949951171875, 504.7578125, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+47, 181019, 0, 1537, 1537, '0', 0, 0, -4881.06103515625, -989.32257080078125, 504.7578125, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+48, 181019, 0, 1537, 5719, '0', 0, 0, -4877.421875, -986.307861328125, 504.7578125, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: The Commons - Difficulty: 0) +(@OGUID+49, 181019, 0, 1537, 5719, '0', 0, 0, -4846.3212890625, -864.107666015625, 502.8443603515625, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: The Commons - Difficulty: 0) +(@OGUID+50, 181019, 0, 1537, 5719, '0', 0, 0, -4837.50927734375, -865.4373779296875, 502.851348876953125, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: The Commons - Difficulty: 0) +(@OGUID+51, 181021, 0, 1537, 1537, '0', 0, 0, -4993.27783203125, -886.91668701171875, 524.600341796875, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+52, 181021, 0, 1537, 1537, '0', 0, 0, -5013.38916015625, -862.51910400390625, 524.67938232421875, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+53, 181021, 0, 1537, 1537, '0', 0, 0, -4974.6494140625, -871.54168701171875, 524.52850341796875, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+54, 181021, 0, 1537, 1537, '0', 0, 0, -5003.3349609375, -874.71356201171875, 524.83770751953125, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+55, 181021, 0, 1537, 1537, '0', 0, 0, -4984.7099609375, -859.3367919921875, 524.798828125, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+56, 181021, 0, 1537, 1537, '0', 0, 0, -4994.7783203125, -847.123291015625, 524.5223388671875, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+57, 181021, 0, 1537, 5344, '0', 0, 0, -4634.705078125, -1025.5736083984375, 514.93280029296875, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: The Mystic Ward - Difficulty: 0) +(@OGUID+58, 181021, 0, 1537, 4679, '0', 0, 0, -4641.595703125, -1178.900634765625, 515.0255126953125, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: The Forlorn Cavern - Difficulty: 0) +(@OGUID+59, 181025, 0, 1537, 1537, '0', 0, 0, -4971.14892578125, -937.86602783203125, 510.348785400390625, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+60, 181025, 0, 1537, 1537, '0', 0, 0, -4928.48681640625, -902.7635498046875, 510.451171875, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+61, 181025, 0, 1537, 1537, '0', 0, 0, -5003.4814453125, -983.32867431640625, 510.498046875, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: Ironforge - Difficulty: 0) +(@OGUID+62, 181025, 0, 1537, 5719, '0', 0, 0, -4878.06005859375, -879.94696044921875, 510.241851806640625, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: The Commons - Difficulty: 0) +(@OGUID+63, 181025, 0, 1537, 5719, '0', 0, 0, -4700.93505859375, -958.9013671875, 510.295135498046875, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: The Commons - Difficulty: 0) +(@OGUID+64, 181025, 0, 1537, 5344, '0', 0, 0, -4672.89892578125, -992.93902587890625, 510.1920166015625, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: The Mystic Ward - Difficulty: 0) +(@OGUID+65, 181025, 0, 1537, 4679, '0', 0, 0, -4684.71630859375, -1205.30712890625, 510.450103759765625, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: The Forlorn Cavern - Difficulty: 0) +(@OGUID+66, 181025, 0, 1537, 5341, '0', 0, 0, -4720.98291015625, -1235.19873046875, 510.422576904296875, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: Hall of Explorers - Difficulty: 0) +(@OGUID+67, 181025, 0, 1537, 0, '0', 0, 0, -4931.61474609375, -1206.3570556640625, 509.640350341796875, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0) +(@OGUID+68, 181025, 0, 1537, 0, '0', 0, 0, -4959.70703125, -1172.3468017578125, 509.829864501953125, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0) +(@OGUID+69, 181060, 0, 1537, 5719, '0', 0, 0, -4885.0947265625, -1005.57061767578125, 506.957855224609375, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+70, 181060, 0, 1537, 5719, '0', 0, 0, -4888.35205078125, -1008.2703857421875, 506.957855224609375, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+71, 181060, 0, 1537, 5719, '0', 0, 0, -4875.5341796875, -997.69598388671875, 506.957855224609375, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+72, 181060, 0, 1537, 5719, '0', 0, 0, -4844.4921875, -874.7479248046875, 511.13970947265625, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+73, 181060, 0, 1537, 5719, '0', 0, 0, -4843.60791015625, -859.5867919921875, 502.78375244140625, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+74, 181060, 0, 1537, 5719, '0', 0, 0, -4840.7568359375, -874.3367919921875, 511.13970947265625, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+75, 181060, 0, 1537, 5719, '0', 0, 0, -4835.0693359375, -873.53497314453125, 511.13970947265625, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+76, 181060, 0, 1537, 5719, '0', 0, 0, -4841.9296875, -874.42425537109375, 511.13970947265625, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+77, 181060, 0, 1537, 5719, '0', 0, 0, -4839.0927734375, -874.047119140625, 511.13970947265625, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+78, 181060, 0, 1537, 5719, '0', 0, 0, -4836.302734375, -873.739501953125, 511.13970947265625, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+79, 181060, 0, 1537, 5719, '0', 0, 0, -4837.7333984375, -873.98687744140625, 511.13970947265625, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+80, 181060, 0, 1537, 5719, '0', 0, 0, -4843.251953125, -874.55352783203125, 511.13970947265625, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+81, 181060, 0, 1537, 5719, '0', 0, 0, -4837.337890625, -858.78009033203125, 502.78082275390625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+82, 181060, 0, 1537, 5719, '0', 0, 0, -4877.7509765625, -999.52667236328125, 506.957855224609375, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: The Commons - Difficulty: 0) +(@OGUID+83, 187575, 0, 1537, 5344, '0', 0, 0, -4630.103515625, -928.94500732421875, 506.122406005859375, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 48069), -- Hanging, Square, Small - Val (Area: The Mystic Ward - Difficulty: 0) +(@OGUID+84, 201940, 0, 1537, 1537, '0', 0, 0, -4918.39404296875, -983.5625, 501.45306396484375, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 48069); -- Valentine Arch (x2.00) (Area: Ironforge - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+4; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(@EVENT, @CGUID+0), +(@EVENT, @CGUID+1), +(@EVENT, @CGUID+2), +(@EVENT, @CGUID+3), +(@EVENT, @CGUID+4); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+84; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(@EVENT, @OGUID+0), +(@EVENT, @OGUID+1), +(@EVENT, @OGUID+2), +(@EVENT, @OGUID+3), +(@EVENT, @OGUID+4), +(@EVENT, @OGUID+5), +(@EVENT, @OGUID+6), +(@EVENT, @OGUID+7), +(@EVENT, @OGUID+8), +(@EVENT, @OGUID+9), +(@EVENT, @OGUID+10), +(@EVENT, @OGUID+11), +(@EVENT, @OGUID+12), +(@EVENT, @OGUID+13), +(@EVENT, @OGUID+14), +(@EVENT, @OGUID+15), +(@EVENT, @OGUID+16), +(@EVENT, @OGUID+17), +(@EVENT, @OGUID+18), +(@EVENT, @OGUID+19), +(@EVENT, @OGUID+20), +(@EVENT, @OGUID+21), +(@EVENT, @OGUID+22), +(@EVENT, @OGUID+23), +(@EVENT, @OGUID+24), +(@EVENT, @OGUID+25), +(@EVENT, @OGUID+26), +(@EVENT, @OGUID+27), +(@EVENT, @OGUID+28), +(@EVENT, @OGUID+29), +(@EVENT, @OGUID+30), +(@EVENT, @OGUID+31), +(@EVENT, @OGUID+32), +(@EVENT, @OGUID+33), +(@EVENT, @OGUID+34), +(@EVENT, @OGUID+35), +(@EVENT, @OGUID+36), +(@EVENT, @OGUID+37), +(@EVENT, @OGUID+38), +(@EVENT, @OGUID+39), +(@EVENT, @OGUID+40), +(@EVENT, @OGUID+41), +(@EVENT, @OGUID+42), +(@EVENT, @OGUID+43), +(@EVENT, @OGUID+44), +(@EVENT, @OGUID+45), +(@EVENT, @OGUID+46), +(@EVENT, @OGUID+47), +(@EVENT, @OGUID+48), +(@EVENT, @OGUID+49), +(@EVENT, @OGUID+50), +(@EVENT, @OGUID+51), +(@EVENT, @OGUID+52), +(@EVENT, @OGUID+53), +(@EVENT, @OGUID+54), +(@EVENT, @OGUID+55), +(@EVENT, @OGUID+56), +(@EVENT, @OGUID+57), +(@EVENT, @OGUID+58), +(@EVENT, @OGUID+59), +(@EVENT, @OGUID+60), +(@EVENT, @OGUID+61), +(@EVENT, @OGUID+62), +(@EVENT, @OGUID+63), +(@EVENT, @OGUID+64), +(@EVENT, @OGUID+65), +(@EVENT, @OGUID+66), +(@EVENT, @OGUID+67), +(@EVENT, @OGUID+68), +(@EVENT, @OGUID+69), +(@EVENT, @OGUID+70), +(@EVENT, @OGUID+71), +(@EVENT, @OGUID+72), +(@EVENT, @OGUID+73), +(@EVENT, @OGUID+74), +(@EVENT, @OGUID+75), +(@EVENT, @OGUID+76), +(@EVENT, @OGUID+77), +(@EVENT, @OGUID+78), +(@EVENT, @OGUID+79), +(@EVENT, @OGUID+80), +(@EVENT, @OGUID+81), +(@EVENT, @OGUID+82), +(@EVENT, @OGUID+83), +(@EVENT, @OGUID+84); |