diff options
| -rw-r--r-- | sql/updates/world/2016_03_26_00_world.sql | 933 |
1 files changed, 933 insertions, 0 deletions
diff --git a/sql/updates/world/2016_03_26_00_world.sql b/sql/updates/world/2016_03_26_00_world.sql new file mode 100644 index 00000000000..cd1d9645e9f --- /dev/null +++ b/sql/updates/world/2016_03_26_00_world.sql @@ -0,0 +1,933 @@ +-- +SET @CGUID :=452400; +SET @OGUID :=235193; +SET @EventDF:=3; +SET @EventLF:=7; + +-- Monks class quests ONLY for Monks wod only +DELETE FROM `quest_template_addon` WHERE `id` IN (31142,31147,31157,31166,31171,31173); +INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`) VALUES +(31142, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(31147, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(31157, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(31166, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(31171, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(31173, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); + +-- missing creatures wod only +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+23; +DELETE FROM `creature` WHERE `guid` IN (452383); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 62019, 530, 0, 0, 1, 0, 0, 0, 0, 10397.75, -6335.153, 35.51038, 3.02442, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62019 (Area: 3431) (possible waypoints or random movement) -- guid 40358 +(@CGUID+1, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 10121.43, -6569.628, 5.975308, 6.034535, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62020 (Area: 3431) (possible waypoints or random movement) +(@CGUID+2, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 10111.88, -6665.626, 5.193566, 3.138304, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62020 (Area: 0) (possible waypoints or random movement) +(@CGUID+3, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 9926.03, -6420.462, 13.50202, 3.781705, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62020 (Area: 3532) (possible waypoints or random movement) +(@CGUID+4, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 9850.044, -6544.73, 11.68306, 6.062163, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62020 (Area: 3532) +(@CGUID+5, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 9657.41, -6628.202, 1.757, 1.820137, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62020 (Area: 3532) +(@CGUID+6, 61080, 530, 0, 0, 1, 0, 0, 0, 0, 9526.51, -7361.26, 14.9035, 0.718482, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 61080 (Area: 3532) +(@CGUID+7, 61141, 1, 0, 0, 1, 0, 0, 0, 0, -1480.36, 182.608, -7.66781, 1.05064, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 61141 (Area: 3532) +(@CGUID+8, 61142, 530, 0, 0, 1, 0, 0, 0, 0, 9703.78, -6578.54, 2.37355, 5.1673, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 61142 (Area: 3532) +(@CGUID+9, 61142, 530, 0, 0, 1, 0, 0, 0, 0, 9789.03, -6851.56, 20.2193, 1.72698, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 61142 (Area: 3532) +(@CGUID+10, 61142, 530, 0, 0, 1, 0, 0, 0, 0, 9845.15, -6844.67, 19.7022, 1.35528, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 61142 (Area: 3532) +(@CGUID+11, 61142, 530, 0, 0, 1, 0, 0, 0, 0, 9877.52, -6662.29, 9.57221, 0.993357, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 61142 (Area: 3532) +(@CGUID+12, 61142, 530, 0, 0, 1, 0, 0, 0, 0, 9898.88, -6846.83, 22.4555, 4.76365, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 61142 (Area: 3532) +(@CGUID+13, 62019, 530, 0, 0, 1, 0, 0, 0, 0, 10428.1, -6325.35, 36.204, 1.54112, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62019 (Area: 3532) +(@CGUID+14, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 9110.79, -7189.94, 38.0401, 0.682427, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62020 (Area: 3532) +(@CGUID+15, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 9718.92, -6512.37, 5.43116, 2.40863, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62020 (Area: 3532) +(@CGUID+16, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 9775.54, -6408.24, 42.0098, 5.6549, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62020 (Area: 3532) +(@CGUID+17, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 9858.46, -6431.11, 26.2754, 4.48199, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62020 (Area: 3532) +(@CGUID+18, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 10026.8, -6695.62, 31.498, 1.8663, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62020 (Area: 3532) +(@CGUID+19, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 10131.4, -6571.13, 3.61063, 2.935, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 62020 (Area: 3532) +(@CGUID+20, 61142, 530, 0, 0, 1, 0, 0, 0, 0, 9508.73, -6736.73, 12.4202, 1.99397, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20886), -- 61142 (Area: 3532) +(@CGUID+21, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 10038.7, -6562.21, 5.95995, 3.58071, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20886), -- 62020 (Area: 3532) +(@CGUID+22, 62020, 530, 0, 0, 1, 0, 0, 0, 0, 10044, -6626.94, 6.64551, 4.66207, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20886), -- 62020 (Area: 3532) +(@CGUID+23, 61080, 530, 0, 0, 1, 0, 0, 0, 0, 9565.66, -7288.26, 15.6218, 3.84893, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20886), -- 61080 (Area: 3532) +(452383, 63079, 530, 0, 0, 1, 0, 0, 0, 0, 9488.3, -6820.91, 17.4888, 0.879762, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886); -- 63079 (Area: 3532) + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+5; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(@CGUID+0, 0, 0, 0, 1, 0, ''), -- 62019 +(@CGUID+1, 0, 0, 0, 1, 0, ''), -- 62020 +(@CGUID+2, 0, 0, 0, 1, 0, ''), -- 62020 +(@CGUID+3, 0, 0, 0, 1, 0, ''), -- 62020 +(@CGUID+4, 0, 0, 0, 1, 0, ''), -- 62020 +(@CGUID+5, 0, 0, 0, 1, 0, ''); -- 62020 + +-- missing creatures Cata +SET @CGUID :=375601; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+65; +DELETE FROM `creature` WHERE `guid` IN (79591,79592,79589,203489,203488,81639,81707,79593,79973,80358); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 15649, 530, 0, 0, 1, 0, 0, 0, 0, 10091.9, -6712.537, 30.61743, 3.059479, 120, 5, 0, 0, 0, 1, 0, 0, 0, 20779), -- 15649 (Area: 0) (Auras: 29118 - 29118) +(@CGUID+1, 15649, 530, 0, 0, 1, 0, 0, 0, 0, 10118.95, -6710.145, 18.09287, 0.02538517, 120, 5, 0, 0, 0, 1, 0, 0, 0, 20779), -- 15649 (Area: 0) (Auras: 29118 - 29118) +(@CGUID+2, 15468, 530, 0, 0, 1, 0, 0, 0, 0, 10419.43, -6320.495, 35.65676, 2.268928, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- 15468 (Area: 3431) +(@CGUID+3, 17047, 530, 0, 0, 1, 0, 0, 0, 0, 9700.187, -6652.041, 6.386805, 0.2268076, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- 17047 (Area: 3532) +(@CGUID+4, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9870.647, -6588.936, 12.83284, 3.73227, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 3532) +(@CGUID+5, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9680.125, -6626.853, 1.815215, 2.622492, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 3532) +(@CGUID+6, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9578.392, -6627.083, 6.173154, 3.468156, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 3532) +(@CGUID+7, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9566.408, -7288.541, 15.68915, 6.099087, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 0) +(@CGUID+8, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9337.884, -6839.113, 19.01505, 2.379223, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 3482) +(@CGUID+9, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9566.705, -7311.879, 15.52523, 4.978549, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 0) +(@CGUID+10, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9524.353, -7362.491, 14.9024, 4.282718, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 0) +(@CGUID+11, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9492.827, -7381.279, 15.1119, 4.580041, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 0) +(@CGUID+12, 2914, 530, 0, 0, 1, 0, 0, 0, 0, 9893.699, -6624.409, 12.0006, 4.424645, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 2914 (Area: 3532) +(@CGUID+13, 2914, 530, 0, 0, 1, 0, 0, 0, 0, 9877.223, -6661.679, 9.37977, 1.211769, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 2914 (Area: 3532) +(@CGUID+14, 2914, 530, 0, 0, 1, 0, 0, 0, 0, 9702.272, -6577.847, 2.862622, 3.342354, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 2914 (Area: 3532) +(@CGUID+15, 2914, 530, 0, 0, 1, 0, 0, 0, 0, 9508.09, -6735.645, 12.53016, 0.5976114, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 2914 (Area: 3532) (possible waypoints or random movement) +(@CGUID+16, 2914, 530, 0, 0, 1, 0, 0, 0, 0, 9605.442, -6849.589, 16.27581, 1.273689, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 2914 (Area: 3665) (possible waypoints or random movement) +(@CGUID+17, 2914, 530, 0, 0, 1, 0, 0, 0, 0, 9655.773, -6840.898, 17.71838, 6.043538, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 2914 (Area: 3534) +(@CGUID+18, 6271, 530, 0, 0, 1, 0, 0, 0, 0, 9525.813, -7343.337, 14.35287, 3.530473, 120, 5, 0, 0, 0, 1, 0, 0, 0, 20779), -- 6271 (Area: 0) +(@CGUID+19, 37574, 530, 0, 0, 1, 0, 0, 0, 0, 9672.353, -7495.389, 26.50705, 4.660029, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- 37574 (Area: 3430) +(@CGUID+20, 37574, 530, 0, 0, 1, 0, 0, 0, 0, 9694.286, -7496.104, 26.50705, 4.660029, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- 37574 (Area: 3430) +(@CGUID+21, 37574, 530, 0, 0, 1, 0, 0, 0, 0, 9765.388, -7494.438, 29.27381, 4.660029, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- 37574 (Area: 0) +(@CGUID+22, 37574, 530, 0, 0, 1, 0, 0, 0, 0, 9766.234, -7480.335, 29.2571, 4.660029, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- 37574 (Area: 0) +(@CGUID+23, 1420, 530, 0, 0, 1, 0, 0, 0, 0, 9601.76, -6762.35, 4.37582, 0.380023, 120, 8, 0, 0, 0, 1, 0, 0, 0, 20886), -- 1420 (Area: 0) +(@CGUID+24, 37543, 530, 0, 0, 1, 0, 0, 0, 0, 9678.442, -7522.537, 37.08941, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- 37543 (Area: 3430) +(@CGUID+25, 37543, 530, 0, 0, 1, 0, 0, 0, 0, 9805.595, -7490.866, 29.50456, 0, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- 37543 (Area: 0) +(@CGUID+26, 1420, 530, 0, 0, 1, 0, 0, 0, 0, 9244.917, -7179.292, 13.43854, 0.6216487, 120, 8, 0, 0, 0, 1, 0, 0, 0, 20779), -- 1420 (Area: 0) +(@CGUID+27, 26400, 530, 0, 0, 1, 0, 0, 0, 0, 9500.021, -7329.172, 14.46843, 0.122173, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- 26400 (Area: 0) (Auras: ) +(@CGUID+28, 721, 1, 0, 0, 1, 0, 0, 0, 0, -1388.88, 250.904, -4.4672, 0.0195288, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 3532) +(@CGUID+29, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9192.43, -6663.44, 35.655, 5.37561, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 3532) +(@CGUID+30, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9276.41, -6485.19, 38.9196, 5.37561, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 3532) +(@CGUID+31, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9588.15, -6537.84, 11.7239, 3.10397, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 3532) +(@CGUID+32, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9589.79, -7311.63, 15.78, 1.92268, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 3532) +(@CGUID+33, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9611.34, -6583.31, 4.4215, 5.32305, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 3532) +(@CGUID+34, 721, 530, 0, 0, 1, 0, 0, 0, 0, 9723.78, -6526.42, 5.30616, 0.871714, 120, 15, 0, 0, 0, 1, 0, 0, 0, 20779), -- 721 (Area: 3532) +(@CGUID+35, 1420, 530, 0, 0, 1, 0, 0, 0, 0, 9735.71, -6688.79, 0.443353, 3.21035, 120, 8, 0, 0, 0, 1, 0, 0, 0, 20779), -- 1420 (Area: 0) +(@CGUID+36, 1420, 530, 0, 0, 1, 0, 0, 0, 0, 9822.47, -6637, 0.292085, 6.25269, 120, 8, 0, 0, 0, 1, 0, 0, 0, 20779), -- 1420 (Area: 0) +(@CGUID+37, 1420, 530, 0, 0, 1, 0, 0, 0, 0, 9857.64, -6647.77, 2.45696, 3.45659, 120, 8, 0, 0, 0, 1, 0, 0, 0, 20779), -- 1420 (Area: 0) +(@CGUID+38, 2914, 530, 0, 0, 1, 0, 0, 0, 0, 9648.1, -6481.31, 11.6481, 5.87784, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 2914 (Area: 3532) +(@CGUID+39, 2914, 530, 0, 0, 1, 0, 0, 0, 0, 9882.58, -6745.04, 11.2932, 0.402869, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 2914 (Area: 3532) +(@CGUID+40, 2956, 1, 0, 0, 1, 0, 0, 0, 0, -1501.91, 113.105, 0.488553, 1.66612, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- 2956 (Area: 3532) +(@CGUID+41, 2957, 1, 0, 0, 1, 0, 0, 0, 0, -1449.36, 258.98, 1.60081, 1.14999, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- 2957 (Area: 3532) +(@CGUID+42, 4166, 1, 0, 0, 1, 0, 0, 0, 0, -1449.63, 149.779, -5.62964, 2.81367, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 4166 (Area: 3532) +(@CGUID+43, 13321, 530, 0, 0, 1, 0, 0, 0, 0, 9603.84, -6761.81, 3.91621, 3.17961, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 13321 (Area: 3532) +(@CGUID+44, 13321, 530, 0, 0, 1, 0, 0, 0, 0, 9648.08, -6648.99, 0.852893, 5.22043, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 13321 (Area: 3532) +(@CGUID+45, 13321, 530, 0, 0, 1, 0, 0, 0, 0, 9672.23, -6760.84, 0.65865, 3.73763, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20779), -- 13321 (Area: 3532) +(@CGUID+46, 15271, 530, 0, 0, 1, 0, 0, 0, 0, 10049, -6256.32, 8.45932, 0.0684086, 120, 5, 0, 0, 0, 1, 0, 0, 0, 20779), -- 15271 (Area: 3532) +(@CGUID+47, 15271, 530, 0, 0, 1, 0, 0, 0, 0, 10157.4, -6193.6, 19.8952, 0.068454, 120, 5, 0, 0, 0, 1, 0, 0, 0, 20779), -- 15271 (Area: 3532) +(@CGUID+48, 15271, 530, 0, 0, 1, 0, 0, 0, 0, 10138.1, -6250.15, 16.0197, 5.30513, 120, 5, 0, 0, 0, 1, 0, 0, 0, 20779), -- 15271 (Area: 3532) +(@CGUID+49, 15271, 530, 0, 0, 1, 0, 0, 0, 0, 10185.2, -6447.42, 31.2529, 5.19594, 120, 5, 0, 0, 0, 1, 0, 0, 0, 20779), -- 15271 (Area: 3532) +(@CGUID+50, 15271, 530, 0, 0, 1, 0, 0, 0, 0, 10244.4, -6440.85, 71.8632, 5.87547, 120, 5, 0, 0, 0, 1, 0, 0, 0, 20779), -- 15271 (Area: 3532) +(@CGUID+51, 6368, 530, 0, 0, 1, 0, 0, 0, 0, 10381, -6411.29, 49.716, 1.77828, 120, 5, 0, 0, 0, 1, 0, 0, 0, 20886), -- 6368 (Area: 3532) +(@CGUID+52, 6368, 530, 0, 0, 1, 0, 0, 0, 0, 10397.6, -6403.9, 50.0688, 4.6153, 120, 5, 0, 0, 0, 1, 0, 0, 0, 20886), -- 6368 (Area: 3532) +(@CGUID+53, 6368, 530, 0, 0, 1, 0, 0, 0, 0, 10428.1, -6322.37, 36.077, 2.82188, 120, 5, 0, 0, 0, 1, 0, 0, 0, 20886), -- 6368 (Area: 3532) +(@CGUID+54, 6368, 530, 0, 0, 1, 0, 0, 0, 0, 10428.7, -6331.7, 36.2033, 4.64271, 120, 5, 0, 0, 0, 1, 0, 0, 0, 20886), -- 6368 (Area: 3532) +(@CGUID+55, 13321, 530, 0, 0, 1, 0, 0, 0, 0, 9821.77, -6636.79, 0.292085, 0.437495, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20886), -- 13321 (Area: 3532) +(@CGUID+56, 15371, 530, 0, 0, 1, 0, 0, 0, 0, 10359.8, -6366.38, 35.807, 5.80892, 120, 7, 0, 0, 0, 1, 0, 0, 0, 20886), -- 15371 (Area: 3532) +(@CGUID+57, 15371, 530, 0, 0, 1, 0, 0, 0, 0, 10398.9, -6364.87, 36.1891, 2.12164, 120, 7, 0, 0, 0, 1, 0, 0, 0, 20886), -- 15371 (Area: 3532) +(@CGUID+58, 15371, 530, 0, 0, 1, 0, 0, 0, 0, 10434.6, -6332.94, 36.5589, 2.51703, 120, 7, 0, 0, 0, 1, 0, 0, 0, 20886), -- 15371 (Area: 3532) +(@CGUID+59, 16221, 530, 0, 0, 1, 0, 0, 0, 0, 9308.29, -7134.01, 16.308, 5.08281, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 16221 (Area: 3532) +(@CGUID+60, 16221, 530, 0, 0, 1, 0, 0, 0, 0, 9309.98, -7133.21, 16.4483, 5.14132, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 16221 (Area: 3532) +(@CGUID+61, 16221, 530, 0, 0, 1, 0, 0, 0, 0, 9513.53, -6842.88, 16.5768, 1.16937, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 16221 (Area: 3532) +(@CGUID+62, 16221, 530, 0, 0, 1, 0, 0, 0, 0, 9700.91, -6652.96, 6.55616, 3.67324, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 16221 (Area: 3532) +(@CGUID+63, 16222, 530, 0, 0, 1, 0, 0, 0, 0, 9575.19, -7385.3, 13.875, 3.01397, 120, 10, 0, 0, 0, 1, 0, 0, 0, 20886), -- 16222 (Area: 3532) +(@CGUID+64, 17047, 530, 0, 0, 1, 0, 0, 0, 0, 9790.28, -6641.63, -0.195337, 0.345802, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 17047 (Area: 3532) +(203489, 27946, 530, 0, 0, 1, 0, 0, 0, 0, 9377.62, -7169.04, 9.17141, 3.10669, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 27946 (Area: 3532) +(203488, 27946, 530, 0, 0, 1, 0, 0, 0, 0, 9378.31, -7162.12, 8.98845, 3.14159, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 27946 (Area: 3532) +(81639, 25148, 530, 0, 0, 1, 0, 0, 0, 0, 9494.68, -7332.85, 28.1517, 6.14356, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 25148 (Area: 3532) +(81707, 25149, 530, 0, 0, 1, 0, 0, 0, 0, 9492.2, -7327.05, 28.1517, 1.23918, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 25149 (Area: 3532) +(79593, 25150, 530, 0, 0, 1, 0, 0, 0, 0, 9492.45, -7334.37, 28.1517, 5.11381, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 25150 (Area: 3532) +(79973, 25151, 530, 0, 0, 1, 0, 0, 0, 0, 9495.08, -7330.59, 28.1517, 0.0349066, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 25151 (Area: 3532) +(80358, 25152, 530, 0, 0, 1, 0, 0, 0, 0, 9494.46, -7328.32, 28.1517, 0.802851, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 25152 (Area: 3532) +(79591, 25200, 530, 0, 0, 1, 0, 0, 0, 0, 9492.8, -7329.02, 14.4499, 6.14356, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 25200 (Area: 3532) +(79592, 25202, 530, 0, 0, 1, 0, 0, 0, 0, 9494.2, -7327.13, 14.4557, 5.2709, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 25202 (Area: 3532) +(79589, 25207, 530, 0, 0, 1, 0, 0, 0, 0, 9493.89, -7331.08, 14.4512, 1.15192, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886), -- 25207 (Area: 3532) +-- darkmoon faire npc +(@CGUID+65, 55382, 530, 0, 0, 0, 1, 0, 0, 0, 9493.11, -7301.05, 14.4769, 2.93215, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20886); -- 1x darkmoon faire mystic mage +DELETE FROM `game_event_creature` WHERE `guid`=@CGUID+65 AND `eventEntry`=@EventDF; +INSERT INTO `game_event_creature` VALUES(@EventDF, @CGUID+65); + +-- Solanian and Winthren fix position from sniffs +DELETE FROM `creature` WHERE `id` IN (15295,16693); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(55053, 15295, 530, 0, 0, 1, 0, 0, 0, 0, 10376.43, -6406.686, 49.798, 3.586652, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- 15295 (Area: 3431) +(57682, 16693, 530, 0, 0, 1, 0, 0, 0, 0, 9452.567, -7129.445, 16.13763, 3.66181, 120, 0, 0, 0, 0, 0, 0, 0, 0, 20779); -- 16693 (Area: 3430) + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+27; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(@CGUID+0, 0, 0, 0, 1, 0, '29118'), -- 15649 - 29118 - 29118 +(@CGUID+1, 0, 0, 0, 1, 0, '29118'), -- 15649 - 29118 - 29118 +(@CGUID+2, 0, 0, 0, 1, 0, ''), -- 15468 +(@CGUID+3, 0, 0, 0, 1, 0, ''), -- 17047 +(@CGUID+4, 0, 0, 0, 1, 0, ''), -- 721 +(@CGUID+5, 0, 0, 0, 1, 0, ''), -- 721 +(@CGUID+6, 0, 0, 0, 1, 0, ''), -- 721 +(@CGUID+7, 0, 0, 0, 1, 0, ''), -- 721 +(@CGUID+8, 0, 0, 0, 1, 0, ''), -- 721 +(@CGUID+9, 0, 0, 0, 1, 0, ''), -- 721 +(@CGUID+10, 0, 0, 0, 1, 0, ''), -- 721 +(@CGUID+11, 0, 0, 0, 1, 0, ''), -- 721 +(@CGUID+12, 0, 0, 0, 1, 0, ''), -- 2914 +(@CGUID+13, 0, 0, 0, 1, 0, ''), -- 2914 +(@CGUID+14, 0, 0, 0, 1, 0, ''), -- 2914 +(@CGUID+15, 0, 0, 0, 1, 0, ''), -- 2914 +(@CGUID+16, 0, 0, 0, 1, 0, ''), -- 2914 +(@CGUID+17, 0, 0, 0, 1, 0, ''), -- 2914 +(@CGUID+18, 0, 0, 0, 1, 0, ''), -- 6271 +(@CGUID+19, 0, 0, 0, 1, 0, ''), -- 37574 +(@CGUID+20, 0, 0, 0, 1, 0, ''), -- 37574 +(@CGUID+21, 0, 0, 0, 1, 0, ''), -- 37574 +(@CGUID+22, 0, 0, 0, 1, 0, ''), -- 37574 +(@CGUID+23, 0, 0, 0, 1, 0, ''), -- 37543 +(@CGUID+24, 0, 0, 0, 1, 0, ''), -- 37543 +(@CGUID+25, 0, 0, 0, 1, 0, ''), -- 37543 +(@CGUID+26, 0, 0, 0, 1, 0, ''), -- 1420 +(@CGUID+27, 0, 0, 0, 1, 0, ''); -- 26400 + +-- some missing or repaired addons from sniffs +DELETE FROM `creature_template_addon` WHERE `entry` IN (18191,16662,15891,15893,15894,15895,15897,15898,6662,17630,18187,18188,18189,18190,8191,61080,15405,15420,15946,16676,16687,16780,17213,18347,18527,19882,721,13321,15271,15273,15274,15278,15279,15280,15281,15283,15284,15285,15287,15289,15291,15292,15294,15295,15296,15297,15298,15301,15366,15367,15371,15372,15403,15416,15418,15433,15468,15493,15494,15501,15513,15638,15644,15649,15651,15654,15760,15938,15949,15970,15971,16185,16186,16192,16221,16222,16257,16258,16259,16262,16266,16267,16269,16270,16271,16272,16273,16275,16276,16277,16278,16279,16568,16610,16625,16626,16693,16916,16923,16924,17005,17047,17213,17631,17632,17633,17807,17849,18103,18277,18790,18792,18926,18929,18951,19882,20098,20100,20244,25148,25149,25150,25151,25152,25200,25202,25207,26400,43010,43012,44244,44857,44937,47421,50484,51502,51796,55382,61071,61142,61369,62019,62020,63079,63080,63332,89713); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(721, 0, 0, 0, 1, 0, ''), +(13321, 0, 0, 0, 1, 0, ''), +(15271, 0, 0, 0, 1, 0, ''), +(15273, 0, 0, 0, 1, 0, ''), +(15274, 0, 0, 0, 1, 0, ''), +(15278, 0, 0, 0, 1, 0, ''), +(15279, 0, 0, 0, 1, 0, ''), +(15280, 0, 0, 0, 1, 0, ''), +(15281, 0, 0, 0, 257, 0, ''), +(15283, 0, 0, 0, 1, 0, ''), +(15284, 0, 0, 0, 1, 0, ''), +(15285, 0, 0, 0, 1, 0, ''), +(15287, 0, 0, 0, 1, 0, ''), +(15289, 0, 0, 0, 1, 0, ''), +(15291, 0, 0, 0, 1, 0, ''), +(15292, 0, 0, 0, 1, 0, ''), +(15294, 0, 0, 0, 1, 0, ''), +(15295, 0, 0, 0, 1, 0, ''), +(15296, 0, 0, 0, 1, 0, ''), +(15297, 0, 0, 0, 1, 0, ''), +(15298, 0, 0, 0, 1, 0, '18951'), +(15301, 0, 0, 0, 257, 0, ''), +(15366, 0, 0, 0, 1, 0, ''), +(15367, 0, 0, 8, 1, 0, ''), +(15371, 0, 0, 0, 257, 0, ''), +(15372, 0, 0, 0, 1, 0, ''), +(15403, 0, 0, 0, 257, 0, ''), +(15416, 0, 0, 0, 257, 0, ''), +(15418, 0, 0, 0, 257, 0, ''), +(15433, 0, 0, 0, 257, 0, ''), +(15468, 0, 0, 0, 1, 0, ''), +(15493, 0, 0, 0, 1, 0, ''), +(15494, 0, 0, 0, 1, 0, ''), +(15501, 0, 0, 0, 257, 0, ''), +(15513, 0, 0, 0, 2, 0, ''), +(15638, 0, 0, 0, 1, 0, ''), +(15644, 0, 0, 0, 1, 0, ''), +(15649, 0, 0, 0, 1, 0, '29118'), +(15651, 0, 0, 0, 1, 0, ''), +(15654, 0, 0, 0, 1, 0, ''), +(15760, 0, 0, 0, 257, 0, '39860'), +(15938, 0, 0, 0, 257, 0, ''), +(15949, 0, 0, 0, 1, 0, ''), +(15970, 0, 0, 0, 257, 0, ''), +(15971, 0, 0, 0, 257, 0, ''), +(16185, 0, 0, 0, 257, 0, ''), +(16186, 0, 0, 0, 257, 0, ''), +(16192, 0, 0, 0, 257, 0, ''), +(16221, 0, 0, 0, 257, 0, ''), +(16222, 0, 0, 0, 257, 0, ''), +(16257, 0, 0, 0, 257, 0, ''), +(16258, 0, 0, 0, 257, 0, ''), +(16259, 0, 0, 0, 257, 0, ''), +(16262, 0, 0, 0, 257, 0, ''), +(16266, 0, 0, 0, 257, 0, ''), +(16267, 0, 0, 0, 257, 0, ''), +(16269, 0, 0, 0, 257, 0, ''), +(16270, 0, 0, 0, 257, 0, ''), +(16271, 0, 0, 0, 257, 0, ''), +(16272, 0, 0, 0, 257, 0, ''), +(16273, 0, 0, 0, 257, 0, ''), +(16275, 0, 0, 0, 257, 0, ''), +(16276, 0, 0, 0, 257, 0, ''), +(16277, 0, 0, 0, 257, 0, ''), +(16278, 0, 0, 0, 257, 0, ''), +(16279, 0, 0, 0, 257, 0, ''), +(16568, 0, 0, 0, 257, 0, ''), +(16610, 0, 0, 0, 257, 0, ''), +(16625, 0, 0, 0, 257, 0, ''), +(16626, 0, 0, 0, 257, 0, ''), +(16693, 0, 0, 0, 257, 0, ''), +(16916, 0, 0, 0, 1, 0, ''), +(16923, 0, 0, 0, 257, 0, ''), +(16924, 0, 0, 0, 257, 0, ''), +(17005, 0, 0, 0, 257, 0, ''), +(17047, 0, 0, 0, 1, 0, ''), +(17213, 0, 0, 0, 1, 0, ''), +(17631, 0, 0, 0, 257, 0, ''), +(17632, 0, 0, 0, 257, 0, ''), +(17633, 0, 0, 0, 257, 0, ''), +(17807, 0, 0, 0, 1, 0, ''), +(17849, 0, 0, 0, 1, 0, '29266'), +(18103, 0, 0, 0, 257, 0, '18950'), +(18277, 0, 0, 0, 257, 0, ''), +(18790, 0, 0, 0, 257, 0, ''), +(18792, 0, 0, 8, 257, 0, ''), +(18926, 0, 0, 0, 257, 0, ''), +(18929, 0, 0, 0, 257, 0, ''), +(18951, 0, 0, 0, 257, 0, ''), +(19882, 0, 0, 0, 1, 0, ''), +(20098, 0, 0, 0, 1, 0, ''), +(20100, 0, 0, 3, 1, 0, '14915'), +(20244, 0, 0, 0, 1, 0, ''), +(25148, 0, 0, 0, 1, 0, ''), +(25149, 0, 0, 0, 1, 0, ''), +(25150, 0, 0, 0, 1, 0, ''), +(25151, 0, 0, 0, 1, 0, ''), +(25152, 0, 0, 0, 1, 0, ''), +(25200, 0, 0, 0, 257, 0, ''), +(25202, 0, 0, 0, 257, 0, ''), +(25207, 0, 0, 0, 256, 0, ''), +(26400, 0, 0, 0, 1, 0, ''), +(43010, 0, 0, 0, 1, 0, ''), +(43012, 0, 0, 0, 1, 0, ''), +(44244, 0, 0, 0, 257, 0, ''), +(44857, 0, 0, 8, 1, 0, ''), +(44937, 0, 0, 0, 1, 0, '83470'), +(47421, 0, 0, 0, 1, 0, ''), +(50484, 0, 29262, 0, 257, 0, ''), +(51502, 0, 0, 0, 257, 0, ''), +(51796, 0, 0, 0, 257, 0, ''), +(55382, 0, 0, 0, 1, 0, ''), +(15405, 0, 0, 0, 257, 0, ''), +(15420, 0, 0, 0, 1, 0, ''), +(15946, 0, 0, 0, 257, 0, ''), +(16676, 0, 0, 0, 257, 0, ''), +(16687, 0, 0, 0, 257, 0, ''), +(16780, 0, 0, 0, 257, 0, ''), +(18347, 0, 0, 0, 257, 0, ''), +(18527, 0, 0, 0, 1, 0, ''), +(15891, 0, 0, 0, 1, 0, ''), +(15893, 0, 0, 0, 1, 0, ''), +(15894, 0, 0, 0, 1, 0, ''), +(15895, 0, 0, 0, 1, 0, ''), +(15897, 0, 0, 0, 1, 0, '25824'), +(15898, 0, 0, 0, 1, 0, ''), +(16662, 0, 0, 0, 257, 0, ''), +(17630, 0, 0, 0, 257, 0, ''), +(18187, 0, 0, 0, 1, 0, ''), +(18188, 0, 0, 0, 1, 0, ''), +(18189, 0, 0, 0, 1, 0, ''), +(18190, 0, 0, 0, 1, 0, ''), +(18191, 0, 0, 0, 1, 0, ''), +-- wod only +(61080, 0, 0, 0, 1, 0, ''), +(61071, 0, 0, 0, 1, 0, ''), +(61142, 0, 0, 0, 1, 0, ''), +(61369, 0, 0, 0, 1, 0, ''), +(62019, 0, 0, 0, 1, 0, ''), +(62020, 0, 0, 0, 1, 0, ''), +(63079, 0, 0, 33554432, 1, 0, ''), +(63080, 0, 0, 0, 257, 0, ''), +(63332, 0, 0, 0, 1, 0, ''), +(89713, 0, 0, 0, 1, 0, '46598'); + +-- missing gameobjects +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+58; +DELETE FROM `gameobject` WHERE `guid`=24348 AND `id`=183446; +DELETE FROM `gameobject` WHERE `id`=181594; +UPDATE `gameobject` SET `VerifiedBuild`=20779 WHERE `ID` IN (4170,4171,47296,47297); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 3719, 530, 0, 0, 1, 0, 0, 9362.122, -7144.28, 8.746221, 3.665196, 0, 0, 0, 1, 120, 255, 1, 20779), -- 3719 (Area: 3430) +(@OGUID+1, 202586, 530, 0, 0, 1, 0, 0, 10354.45, -6370.502, 35.95272, 2.042034, 0, 0, 0, 1, 120, 255, 1, 20779), -- 202586 (Area: 3431) mailbox +(@OGUID+2, 180600, 530, 0, 0, 1, 0, 0, 9536.12, -6575.59, 4.14954, 1.25664, 0, 0, 0, 1, 120, 255, 1, 20779), -- 180600 (Area: 3665) +(@OGUID+3, 180600, 530, 0, 0, 1, 0, 0, 9553.74, -6584.36, 1.55516, 5.61996, 0, 0, 0, 1, 120, 255, 1, 20779), -- 180600 (Area: 3665) +(@OGUID+4, 180600, 530, 0, 0, 1, 0, 0, 9618.74, -6477.04, 12.9131, 2.9845, 0, 0, 0, 1, 120, 255, 1, 20779), -- 180600 (Area: 3665) +(@OGUID+5, 180600, 530, 0, 0, 1, 0, 0, 9733.15, -6755.04, 3.90703, 3.33359, 0, 0, 0, 1, 120, 255, 1, 20779), -- 180600 (Area: 3665) +(@OGUID+6, 181166, 530, 0, 0, 1, 0, 0, 9313.42, -6620.12, 26.1349, 2.56563, 0, 0, 0, 1, 120, 255, 1, 20886), -- 181166 (Area: 3665) +(@OGUID+7, 181166, 530, 0, 0, 1, 0, 0, 9342.73, -6716.92, 19.3892, 2.09439, 0, 0, 0, 1, 120, 255, 1, 20886), -- 181166 (Area: 3665) +(@OGUID+8, 180600, 530, 0, 0, 1, 0, 0, 9763.85, -6506.64, 4.63438, 4.01426, 0, 0, 0, 1, 120, 255, 1, 20779), -- 180600 (Area: 3665) +(@OGUID+9, 180600, 530, 0, 0, 1, 0, 0, 9779.1, -6662.13, -0.022488, 1.55334, 0, 0, 0, 1, 120, 255, 1, 20779), -- 180600 (Area: 3665) +(@OGUID+10, 180600, 530, 0, 0, 1, 0, 0, 9779.99, -6863, 20.9196, 2.1293, 0, 0, 0, 1, 120, 255, 1, 20779), -- 180600 (Area: 3665) +(@OGUID+11, 180600, 530, 0, 0, 1, 0, 0, 9786.07, -6739.99, 0.046767, 5.34071, 0, 0, 0, 1, 120, 255, 1, 20779), -- 180600 (Area: 3665) +(@OGUID+12, 180600, 530, 0, 0, 1, 0, 0, 9796.33, -6651.49, -0.797033, 0, 0, 0, 0, 1, 120, 255, 1, 20779), -- 180600 (Area: 3665) +(@OGUID+13, 180600, 530, 0, 0, 1, 0, 0, 9798.27, -6720.63, 3.08128, 4.93928, 0, 0, 0, 1, 120, 255, 1, 20779), -- 180600 (Area: 3665) +(@OGUID+14, 180600, 530, 0, 0, 1, 0, 0, 9807.8, -6652.73, -0.782087, 1.48353, 0, 0, 0, 1, 120, 255, 1, 20779), -- 180600 (Area: 3665) +(@OGUID+15, 180600, 530, 0, 0, 1, 0, 0, 9811.11, -6674.26, 2.59833, 0.575957, 0, 0, 0, 1, 120, 255, 1, 20779), -- 180600 (Area: 3665) +(@OGUID+16, 181166, 530, 0, 0, 1, 0, 0, 9275.18, -6687.62, 22.2829, 3.7001, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181166 (Area: 3665) +(@OGUID+17, 181166, 530, 0, 0, 1, 0, 0, 9294.24, -6712.64, 22.5865, 1.43117, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181166 (Area: 3665) +(@OGUID+18, 181166, 530, 0, 0, 1, 0, 0, 9341.32, -6687.04, 23.1537, 5.8294, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181166 (Area: 3665) +(@OGUID+19, 181584, 530, 0, 0, 1, 0, 0, 9536.12, -6575.59, 4.14954, 1.25664, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181584 (Area: 3665) +(@OGUID+20, 181584, 530, 0, 0, 1, 0, 0, 9553.74, -6584.36, 1.55516, 5.61996, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181584 (Area: 3665) +(@OGUID+21, 181584, 530, 0, 0, 1, 0, 0, 9618.74, -6477.04, 12.9131, 2.9845, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181584 (Area: 3665) +(@OGUID+22, 181584, 530, 0, 0, 1, 0, 0, 9733.15, -6755.04, 3.90703, 3.33359, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181584 (Area: 3665) +(@OGUID+23, 181584, 530, 0, 0, 1, 0, 0, 9763.85, -6506.64, 4.63438, 4.01426, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181584 (Area: 3665) +(@OGUID+24, 181584, 530, 0, 0, 1, 0, 0, 9779.1, -6662.13, -0.022488, 1.55334, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181584 (Area: 3665) +(@OGUID+25, 181584, 530, 0, 0, 1, 0, 0, 9779.99, -6863, 20.9196, 2.1293, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181584 (Area: 3665) +(@OGUID+26, 181584, 530, 0, 0, 1, 0, 0, 9786.07, -6739.99, 0.046767, 5.34071, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181584 (Area: 3665) +(@OGUID+27, 181584, 530, 0, 0, 1, 0, 0, 9796.33, -6651.49, -0.797033, 0, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181584 (Area: 3665) +(@OGUID+28, 181584, 530, 0, 0, 1, 0, 0, 9798.27, -6720.63, 3.08128, 4.93928, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181584 (Area: 3665) +(@OGUID+29, 181584, 530, 0, 0, 1, 0, 0, 9807.8, -6652.73, -0.782087, 1.48353, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181584 (Area: 3665) +(@OGUID+30, 181584, 530, 0, 0, 1, 0, 0, 9811.11, -6674.26, 2.59833, 0.575957, 0, 0, 0, 1, 120, 255, 1, 20779), -- 181584 (Area: 3665) +(@OGUID+31, 1617, 1, 0, 0, 1, 0, 0, -1423, 310.951, 22.9903, 0.645772, 0, 0, 0, 1, 120, 255, 1, 20779), -- 1617 (Area: 3665) +(@OGUID+32, 1617, 530, 0, 0, 1, 0, 0, 9288.36, -7157.48, 18.2337, 4.32842, 0, 0, 0, 1, 120, 255, 1, 20779), -- 1617 (Area: 3665) +(@OGUID+33, 1617, 530, 0, 0, 1, 0, 0, 9343.92, -7057.61, 16.1092, 2.23402, 0, 0, 0, 1, 120, 255, 1, 20779), -- 1617 (Area: 3665) +(@OGUID+34, 1617, 530, 0, 0, 1, 0, 0, 9362.75, -6547.81, 43.9791, 0.209439, 0, 0, 0, 1, 120, 255, 1, 20779), -- 1617 (Area: 3665) +(@OGUID+35, 1617, 530, 0, 0, 1, 0, 0, 9395.27, -6630.87, 40.9423, 6.24828, 0, 0, 0, 1, 120, 255, 1, 20779), -- 1617 (Area: 3665) +(@OGUID+36, 1618, 530, 0, 0, 1, 0, 0, 9352.64, -6468.07, 49.0716, 4.03171, 0, 0, 0, 1, 120, 255, 1, 20779), -- 1618 (Area: 3665) +(@OGUID+37, 1731, 530, 0, 0, 1, 0, 0, 9091.77, -7088.56, 54.2384, 1.37881, 0, 0, 0, 1, 120, 255, 1, 20779), -- 1731 (Area: 3665) +(@OGUID+38, 1731, 530, 0, 0, 1, 0, 0, 9360.84, -6429.67, 63.6471, 4.29351, 0, 0, 0, 1, 120, 255, 1, 20779), -- 1731 (Area: 3665) +(24348, 183446, 530, 0, 0, 1, 0, 0, 9376.899, -7273.636, 14.27941, 4.725073, 0, 0, -0.7091335, 0.7050743, 120, 255, 1, 20779), -- 183446 (Area: 3430) correct values +(22020, 181594, 530, 0, 0, 1, 0, 0, 9190.69, -7189.68, -3.46538, 5.81195, 0, 0, 0, 1, 120, 255, 1, 20779); -- because doublespawn + +-- Darkmoon faire in Silvermoon city +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+39, 179965, 1, 0, 0, 1, 0, 0, -1495.23, 196.238, -8.02897, 3.07177, 0, 0, 0, 1, 120, 255, 1, 20779), +(@OGUID+40, 179965, 1, 0, 0, 1, 0, 0, -1490.22, 182.352, -8.01583, 3.78737, 0, 0, 0, 1, 120, 255, 1, 20779), +(@OGUID+41, 179965, 1, 0, 0, 1, 0, 0, -1489.67, 211.472, -8.01938, 2.3911, 0, 0, 0, 1, 120, 255, 1, 20779), +(@OGUID+42, 179965, 1, 0, 0, 1, 0, 0, -1477.99, 175.309, -8.05679, 4.39823, 0, 0, 0, 1, 120, 255, 1, 20779), +(@OGUID+43, 179965, 1, 0, 0, 1, 0, 0, -1477.7, 218.847, -8.29682, 1.79769, 0, 0, 0, 1, 120, 255, 1, 20779), +(@OGUID+44, 179965, 1, 0, 0, 1, 0, 0, -1464.8, 176.132, -8.03784, 4.95674, 0, 0, 0, 1, 120, 255, 1, 20779), +(@OGUID+45, 179965, 1, 0, 0, 1, 0, 0, -1463.52, 217.385, -8.06816, 1.20428, 0, 0, 0, 1, 120, 255, 1, 20779), +(@OGUID+46, 179965, 1, 0, 0, 1, 0, 0, -1453.68, 183.12, -8.02572, 5.5676, 0, 0, 0, 1, 120, 255, 1, 20779), +(@OGUID+47, 179965, 1, 0, 0, 1, 0, 0, -1448.7, 196.95, -7.76938, 6.21337, 0, 0, 0, 1, 120, 255, 1, 20779), +(@OGUID+48, 179965, 1, 0, 0, 1, 0, 0, -1214.58, 59.6389, 130.108, 3.12412, 0, 0, 0, 1, 120, 255, 1, 20779), +(@OGUID+49, 179965, 530, 0, 0, 1, 0, 0, 9494.33, -7300.11, 14.3907, 3.12412, 0, 0, 0, 1, 120, 255, 1, 20779), +(@OGUID+50, 209114, 530, 0, 0, 1, 0, 0, 9494.11, -7299.99, 17.2074, 3.45576, 0, 0, 0, 1, 120, 255, 1, 20779), +(@OGUID+51, 209124, 530, 0, 0, 1, 0, 0, 9495.88, -7300.28, 15.7656, 6.26573, 0, 0, 0, 1, 120, 255, 1, 20779); +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+39 AND @OGUID+51 AND `eventEntry`=@EventDF; +INSERT INTO `game_event_gameobject` SELECT @EventDF, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+39 AND @OGUID+51; + +-- Lunar festival in Silvermoon city +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+52, 180763, 530, 0, 0, 1, 0, 0, 9475.93, -7288.83, 15.2564, 3.80482, 0, 0, 0, 1, 120, 255, 1, 20886), +(@OGUID+53, 180764, 530, 0, 0, 1, 0, 0, 9477.12, -7303.08, 15.2716, 3.90954, 0, 0, 0, 1, 120, 255, 1, 20886), +(@OGUID+54, 180764, 530, 0, 0, 1, 0, 0, 9486.37, -7295.56, 15.3876, 3.59538, 0, 0, 0, 1, 120, 255, 1, 20886), +(@OGUID+55, 180870, 530, 0, 0, 1, 0, 0, 9487.01, -7286.97, 15.2407, 3.75246, 0, 0, 0, 1, 120, 255, 1, 20886), +(@OGUID+56, 180871, 530, 0, 0, 1, 0, 0, 9483.73, -7300.72, 15.3416, 0.610863, 0, 0, 0, 1, 120, 255, 1, 20886), +(@OGUID+57, 180873, 530, 0, 0, 1, 0, 0, 9471.67, -7294.08, 15.2562, 0.698131, 0, 0, 0, 1, 120, 255, 1, 20886), +(@OGUID+58, 180873, 530, 0, 0, 1, 0, 0, 9481.27, -7288, 15.2669, 0.418879, 0, 0, 0, 1, 120, 255, 1, 20886); + +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+52 AND @OGUID+58 AND `eventEntry`=@EventLF; +INSERT INTO `game_event_gameobject` SELECT @EventLF, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+52 AND @OGUID+58; + +-- missing gossip +DELETE FROM gossip_menu WHERE (`entry`=12248 AND `text_id`=17209) OR (`entry`=13868 AND `text_id`=20038) OR (`entry`=13017 AND `text_id`=18288) OR (`entry`=13068 AND `text_id`=18353) OR (`entry`=13124 AND `text_id`=18463) OR (`entry`=13131 AND `text_id`=18472) OR (`entry`=13142 AND `text_id`=18508) OR (`entry`=13210 AND `text_id`=18618) OR (`entry`=13352 AND `text_id`=18941) OR (`entry`=15306 AND `text_id`=21955) OR (`entry`=18184 AND `text_id`=26114) OR (`entry`=4783 AND `text_id`=5839) OR (`entry`=12418 AND `text_id`=17459) OR (`entry`=12629 AND `text_id`=17755) OR (`entry`=12750 AND `text_id`=17897) OR (`entry`=13895 AND `text_id`=19888) OR (`entry`=14136 AND `text_id`=9192) OR (`entry`=14137 AND `text_id`=9193) OR (`entry`=14138 AND `text_id`=7903) OR (`entry`=14139 AND `text_id`=9186) OR (`entry`=14140 AND `text_id`=9187) OR (`entry`=14141 AND `text_id`=9189) OR (`entry`=14144 AND `text_id`=9189) OR (`entry`=14199 AND `text_id`=16540) OR (`entry`=14991 AND `text_id`=20326) OR (`entry`=15734 AND `text_id`=22594) OR (`entry`=12180 AND `text_id`=17125) OR (`entry`=12185 AND `text_id`=17126) OR (`entry`=12186 AND `text_id`=17127) OR (`entry`=12188 AND `text_id`=17128) OR (`entry`=12189 AND `text_id`=17129) OR (`entry`=12190 AND `text_id`=17130) OR (`entry`=12191 AND `text_id`=17131) OR (`entry`=12192 AND `text_id`=17132) OR (`entry`=12193 AND `text_id`=17133) OR (`entry`=12195 AND `text_id`=17134) OR (`entry`=12196 AND `text_id`=17135) OR (`entry`=12197 AND `text_id`=17136) OR (`entry`=12198 AND `text_id`=17137) OR (`entry`=12199 AND `text_id`=17138) OR (`entry`=12670 AND `text_id`=17816) OR (`entry`=13895 AND `text_id`=19889) OR (`entry`=14136 AND `text_id`=9191) OR (`entry`=14137 AND `text_id`=7904) OR (`entry`=14138 AND `text_id`=7882) OR (`entry`=14139 AND `text_id`=9007) OR (`entry`=14140 AND `text_id`=9188) OR (`entry`=14141 AND `text_id`=9190) OR (`entry`=14142 AND `text_id`=9185) OR (`entry`=14199 AND `text_id`=16541); +INSERT INTO gossip_menu (`entry`, `text_id`) VALUES +(12248, 17209), +(13868, 20038), +(13017, 18288), +(13068, 18353), +(13124, 18463), +(13131, 18472), +(13142, 18508), +(13210, 18618), +(13352, 18941), +(15306, 21955), +(18184, 26114), +(4783, 5839), +(12418, 17459), +(12629, 17755), +(12750, 17897), +(13895, 19888), +(14136, 9192), +(14137, 9193), +(14138, 7903), +(14139, 9186), +(14140, 9187), +(14141, 9189), +(14144, 9189), +(14199, 16540), +(14991, 20326), +(15734, 22594), +(12180, 17125), +(12185, 17126), +(12186, 17127), +(12188, 17128), +(12189, 17129), +(12190, 17130), +(12191, 17131), +(12192, 17132), +(12193, 17133), +(12195, 17134), +(12196, 17135), +(12197, 17136), +(12198, 17137), +(12199, 17138), +(12670, 17816), +(13895, 19889), +(14136, 9191), +(14137, 7904), +(14138, 7882), +(14139, 9007), +(14140, 9188), +(14141, 9190), +(14142, 9185), +(14199, 16541); + +-- Silvermoon Guards navigation +UPDATE `points_of_interest` SET `VerifiedBuild`=20779 WHERE `Name` IN ('Silvermoon City, Auction House','Silvermoon City, Bank','Silvermoon City, Flight Master','Silvermoon City, Guild House','Silvermoon City, Inn','Silvermoon City, Mailbox','Silvermoon City, Stable Master'); +DELETE FROM `points_of_interest` WHERE `ID` IN (494,495,360,361,382,367,359,496,497,498,499); +INSERT INTO `points_of_interest` (`ID`, `PositionX`, `PositionY`, `Icon`, `Flags`, `Importance`, `Name`, `VerifiedBuild`) VALUES +(494, 9832.22, -7405.87, 7, 99, 0, 'Silvermoon City, Monk Trainer', 20779), +(361, 9704.17, -7265.84, 7, 99, 0, 'Silvermoon City, Druid Trainer', 20886), +(495, 9638.31, -7392.76, 7, 99, 0, 'Silvermoon City, Archaeology', 20779), +(496, 9503.18, -6897.72, 7, 583, 0, 'Falconwing Square, Profession Trainer', 20886), +(497, 9523.22, -6865.83, 7, 583, 0, 'Falconwing Square, Warrior Trainer', 20886), +(498, 9703.7, -7269.97, 7, 99, 0, 'Silvermoon City, Shaman Trainer', 20886), +(367, 9801.76, -7322.78, 7, 99, 0, 'Silvermoon City, Warlock Trainer', 20886), +(499, 9849.68, -7381.36, 7, 99, 0, 'Silvermoon City, Warrior Trainer', 20886); + +-- gossips +DELETE FROM `gossip_menu_option` WHERE `menu_id`=7649 AND `id`=9; +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (14991,9821,6202,6225,6620,7633,13210,13124); +INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES +(7649, 9, 0, 'Monk', 61793, 0, 0, 0, 494, 0, 0, '', 0), +(9821, 1, 1, 'I''m looking for a lost companion.', 56613, 3, 128, 0, 0, 0, 0, '', 0), +(9821, 2, 0, 'I''d like to heal and revive my battle pets.', 64115, 0, 0, 0, 0, 0, 1000, 'A small fee for supplies is required.', 0), +(14991, 0, 3, 'Interested in catching some rare pets?', 62763, 5, 16, 0, 0, 0, 0, '', 0), +(14991, 1, 1, 'Interested in trading your battle-stones?', 74772, 3, 128, 0, 0, 0, 0, '', 0), +(6202, 0, 1, 'Would you be interesting in some card trading?', 8097, 3, 128, 0, 0, 0, 0, '', 0), +(6202, 1, 0, 'Tell me more about these Darkmoon Cards.', 10064, 1, 1, 6207, 0, 0, 0, '', 0), +(6225, 0, 0, 'How does the Shooting Gallery work?', 53329, 0, 0, 0, 0, 0, 0, '', 0), +(6225, 2, 0, 'Let''s shoot! |cFF0008E8(Darkmoon Game Token)|r', 53042, 0, 0, 0, 0, 0, 0, '', 0), +(6620, 0, 5, 'Make this inn your home.', 10693, 8, 65536, 0, 0, 0, 0, '', 0), +(6620, 1, 1, 'I want to browse your goods.', 3370, 3, 128, 0, 0, 0, 0, '', 0), +(7633, 0, 0, 'Auction House', 44627, 1, 1, 7668, 0, 0, 0, '', 0), +(7633, 1, 0, 'Bank', '7066', 1, 1, 7639, 0, 0, 0, '', 0), +(7633, 2, 0, 'Dragonhawk Master', 15220, 1, 1, 7640, 353, 0, 0, '', 0), +(7633, 3, 0, 'Class Trainer', 45378, 1, 1, 7641, 354, 0, 0, '', 0), +(7633, 4, 0, 'Guild Master & Vendor', 7075, 1, 1, 7845, 0, 0, 0, '', 0), +(7633, 5, 0, 'Inn', 45381, 1, 1, 7643, 357, 0, 0, '', 0), +(7633, 6, 0, 'Mailbox', 45383, 1, 1, 7644, 358, 0, 0, '', 0), +(7633, 7, 0, 'Profession Trainer', 45382, 1, 1, 7645, 359, 0, 0, '', 0), +(7633, 8, 0, 'Stable Master', 45377, 1, 1, 7646, 360, 0, 0, '', 0), +(13210, 0, 1, 'Let me browse your goods.', 2823, 3, 128, 0, 0, 0, 0, '', 0), +(13210, 1, 0, 'No thank you.', 0, 0, 0, 0, 0, 0, 0, '', 0), +(13124, 0, 0, 'Take me to the faire staging area.', 52971, 0, 0, 0, 0, 0, 25, 'Travel to the faire staging area will cost:', 0); +DELETE FROM `gossip_menu_option` WHERE `menu_id`=13352 AND `id`=1; +UPDATE `gossip_menu_option` SET `action_poi_id`=495 WHERE `menu_id`=7667 AND `id`=1; +UPDATE `gossip_menu_option` SET `action_poi_id`=496 WHERE `menu_id`=8185 AND `id`=5; +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12180 AND `id` IN (0,1,3,4,6,8); +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12185 AND `id` IN (3,8); +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12186 AND `id` IN (3,8); +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12188 AND `id`=11; +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12189 AND `id`=11; +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12190 AND `id` IN (9,11); +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12191 AND `id` IN (4,11); +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12192 AND `id` IN (8,11); +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12193 AND `id` IN (10,11); +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12195 AND `id` IN (8,11); +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12196 AND `id`=11; +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12197 AND `id`=11; +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12198 AND `id` IN (9,11); +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=12199 AND `id`=11; +UPDATE `gossip_menu_option` SET `option_id`=3 WHERE `menu_id`=14991 AND `id`=0; +UPDATE `gossip_menu_option` SET `action_poi_id`=497, `OptionBroadcastTextID`=45408 WHERE `menu_id`=8196 AND `id`=7; +UPDATE `gossip_menu_option` SET `action_poi_id`=381, `OptionBroadcastTextID`=52077 WHERE `menu_id`=7667 AND `id`=14; +UPDATE `gossip_menu_option` SET `action_poi_id`=367, `OptionBroadcastTextID`=45407 WHERE `menu_id`=7649 AND `id`=7; +UPDATE `gossip_menu_option` SET `action_poi_id`=499, `OptionBroadcastTextID`=45408 WHERE `menu_id`=7649 AND `id`=8; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2823 WHERE `option_text`='Let me browse your goods.'; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12271 WHERE `option_text`='Show me where I can fly.'; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=50696 WHERE `option_text`='Abandon Imp'; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=50697 WHERE `option_text`='Abandon Voidwalker'; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=50698 WHERE `option_text`='Abandon Succubus'; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=50699 WHERE `option_text`='Abandon Felhunter'; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3428 WHERE `menu_id`=7633 AND `id`=4; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5513 WHERE `menu_id`=7633 AND `id`=5; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=4895 WHERE `menu_id`=7633 AND `id`=6; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=8508 WHERE `menu_id`=7633 AND `id`=8; +UPDATE `gossip_menu_option` SET `action_menu_id`=7649 WHERE `menu_id`=7633 AND `id`=3; +UPDATE `gossip_menu_option` SET `action_poi_id`=0 WHERE `menu_id`=7633 AND `id`=3; +UPDATE `gossip_menu_option` SET `action_menu_id`=7641 WHERE `menu_id`=7633 AND `id`=4; +UPDATE `gossip_menu_option` SET `action_poi_id`=354 WHERE `menu_id`=7633 AND `id`=4; +UPDATE `gossip_menu_option` SET `action_menu_id`=7845 WHERE `menu_id`=7633 AND `id`=5; +UPDATE `gossip_menu_option` SET `action_poi_id`=0 WHERE `menu_id`=7633 AND `id`=5; +UPDATE `gossip_menu_option` SET `action_menu_id`=7643 WHERE `menu_id`=7633 AND `id`=6; +UPDATE `gossip_menu_option` SET `action_poi_id`=357 WHERE `menu_id`=7633 AND `id`=6; +UPDATE `gossip_menu_option` SET `action_menu_id`=7667 WHERE `menu_id`=7633 AND `id`=7; +UPDATE `gossip_menu_option` SET `action_poi_id`=0 WHERE `menu_id`=7633 AND `id`=7; +UPDATE `gossip_menu_option` SET `action_menu_id`=7644 WHERE `menu_id`=7633 AND `id`=8; +UPDATE `gossip_menu_option` SET `action_poi_id`=358 WHERE `menu_id`=7633 AND `id`=8; +UPDATE `gossip_menu_option` SET `option_id`=1 WHERE `menu_id`=7649 AND `id` IN (7,8,9); +UPDATE `gossip_menu_option` SET `npc_option_npcflag`=1 WHERE `menu_id`=7649 AND `id` IN (7,8,9); +UPDATE `gossip_menu_option` SET `action_menu_id`=12750 WHERE `menu_id`=7649 AND `id`=6; +UPDATE `gossip_menu_option` SET `action_poi_id`=498 WHERE `menu_id`=7649 AND `id`=6; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3450 WHERE `menu_id`=7649 AND `id`=6; +UPDATE `gossip_menu_option` SET `action_menu_id`=7654 WHERE `menu_id`=7649 AND `id`=7; +UPDATE `gossip_menu_option` SET `action_menu_id`=12418 WHERE `menu_id`=7649 AND `id`=8; +UPDATE `gossip_menu_option` SET `action_menu_id`=13868 WHERE `menu_id`=7649 AND `id`=9; +UPDATE `gossip_menu_option` SET `action_menu_id`=12248 WHERE `menu_id`=7667 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=44649 WHERE `menu_id`=7667 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5513 WHERE `menu_id`=8185 AND `id`=2; +UPDATE `gossip_menu_option` SET `action_poi_id`=354 WHERE `menu_id`=8185 AND `id`=1; +UPDATE `gossip_menu_option` SET `option_id`=1 WHERE `menu_id`=8196 AND `id`=7; +UPDATE `gossip_menu_option` SET `npc_option_npcflag`=1 WHERE `menu_id`=8196 AND `id`=7; +UPDATE `gossip_menu_option` SET `action_menu_id`=12629 WHERE `menu_id`=8196 AND `id`=7; +UPDATE `gossip_menu_option` SET `action_menu_id`=15734 WHERE `menu_id`=8185 AND `id`=5; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2822 WHERE `menu_id`=6620 AND `id`=0; + +-- update templates from sniffs wod only +DELETE FROM `creature_template` WHERE `entry` IN (97229,89713); +INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `femaleName`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `exp_unk`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `HealthModifierExtra`, `ManaModifier`, `ManaModifierExtra`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES +(97229, 0, 0, 0, 0, 0, 65128, 0, 0, 0, 'Grumpling', 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.01, 1, 1, 1, 1, 0, 0, 0, 100, 0, 0, 0, 0, 20886), +(89713, 0, 0, 0, 0, 0, 61763, 0, 0, 0, 'Koak Hoburn', 0, 'Chauffeur', 0, 0, 100, 100, 0, 0, 35, 0, 1, 1.142857, 1, 0, 0, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 20886); + +UPDATE `creature_template` SET `npcflag`=0 WHERE `entry` IN (15294,15273,15298,17005); +UPDATE `creature_template` SET `npcflag`=640 WHERE `entry` IN (15287,16259); +UPDATE `creature_template` SET `npcflag`=2 WHERE `entry` IN (15296,15297); +UPDATE `creature_template` SET `npcflag`=1 WHERE `entry`=43012; +UPDATE `creature_template` SET `npcflag`=3 WHERE `entry`=63332; +UPDATE `creature_template` SET `npcflag`=179 WHERE `entry`=63080; +UPDATE `creature_template` SET `speed_run`=0.857143 WHERE `entry` IN (15273,15298,15367,63079); +UPDATE `creature_template` SET `speed_run`=0.992063 WHERE `entry` IN (20098,20244); +UPDATE `creature_template` SET `speed_run`=1.142857 WHERE `entry` IN (16662,16676,17630,18187,18188,18189,18190,18191,32638,32641,32642); +UPDATE `creature_template` SET `faction`=90 WHERE `entry`=12922; +UPDATE `creature_template` SET `gossip_menu_id`=14136 WHERE `entry`=15279; +UPDATE `creature_template` SET `gossip_menu_id`=14137 WHERE `entry`=15280; +UPDATE `creature_template` SET `gossip_menu_id`=14138 WHERE `entry`=15283; +UPDATE `creature_template` SET `gossip_menu_id`=14139 WHERE `entry`=15284; +UPDATE `creature_template` SET `gossip_menu_id`=14140 WHERE `entry`=15285; +UPDATE `creature_template` SET `gossip_menu_id`=14141 WHERE `entry`=15513; +UPDATE `creature_template` SET `gossip_menu_id`=14144 WHERE `entry`=16270; +UPDATE `creature_template` SET `gossip_menu_id`=14199 WHERE `entry` IN (43010,43012); +UPDATE `creature_template` SET `gossip_menu_id`=14991 WHERE `entry`=63080; +UPDATE `creature_template` SET `gossip_menu_id`=13895 WHERE `entry`=63332; +UPDATE `creature_template` SET `gossip_menu_id`=12670 WHERE `entry`=15494; +UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry` IN (15281,63080); +UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry` IN (20100,63332); +UPDATE `creature_template` SET `trainer_type`=0 WHERE `entry`=17005; +UPDATE `creature_template` SET `trainer_type`=2 WHERE `entry`=47421; +UPDATE `creature_template` SET `trainer_class`=0 WHERE `entry`=16279; +UPDATE `creature_template` SET `type_flags`=0 WHERE `entry`=17005; +UPDATE `creature_template` SET `ManaModifier`=24164 WHERE `entry`=15371; +UPDATE `creature_template` SET `dynamicflags`=64 WHERE `entry`=17849; +UPDATE `creature_template` SET `VerifiedBuild`=20779 WHERE `entry` IN (15296,45322,16662,16676,17630,18187,18188,18189,18190,18191,32638,32639,32641,32642,89713,2914,6368,12922,13321,15271,15274,15278,15279,15280,15281,15283,15284,15285,15287,15289,15291,15292,15294,15295,15296,15297,15301,15366,15371,15372,15403,15405,15416,15418,15420,15433,15468,15493,15494,15501,15513,15638,15644,15654,15938,15946,15949,16185,16186,16192,16259,16266,16267,16269,16270,16271,16273,16276,16278,16625,16626,16676,16687,16693,16780,16916,16923,16924,17047,18277,18347,18527,18926,18929,21055,27946,37865,42710,43010,43012,44244,44857,44937,50484,61142,62019,62246,63079,63080,63332,68267,86716,97229,89713,10259,15273,15298,15367,15651,16257,16258,16262,16272,16275,16277,16279,17005,17807,17849,20098,20100,20244,20246,20247,47421,51796,61071,61369,84915,6271,15970,15971,17631,17632,17633,18951,23988,25148,25150,25151,26400); + +DELETE FROM `gameobject_template` WHERE `entry` IN (243307); -- wod only +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `unkInt32`, `AIName`, `ScriptName`, `VerifiedBuild`) VALUES +(243307, 8, 29886, 'Felflame Campfire', '', '', '', 0, 0, 0.75, 4, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 20779); + +UPDATE `gameobject_template` SET `VerifiedBuild`=20779 WHERE `entry` IN (180851,180854,180855,182612,182618,182834,182835,182839,182842,182843,182844,185453,183162,202586,182834,181584,180918,180643,182356,182357,182608,182609,182612,182618,182619,182620,182755,182758,182840,182841,184090,184091,184245,187390,2870,29784,180510,180511,180512,180516,180640,182828,182829,183444,183812,183880,183881,208607,208956,243307); +UPDATE `gameobject_template` SET `size`=4.38663 WHERE `entry` IN (182755,182758); +UPDATE `gameobject_template` SET `size`=0.873393 WHERE `entry` IN (182840,182841,182844,182839,182842); +UPDATE `gameobject_template` SET `size`=2.89973 WHERE `entry`=184245; +UPDATE `gameobject_template` SET `size`=1.48375 WHERE `entry` IN (182828,182829,182834,182835); +UPDATE `gameobject_template` SET `size`=0.861422 WHERE `entry`=182843; +UPDATE `gameobject_template` SET `flags`=65540 WHERE `entry` IN (180510,180511,180512); +UPDATE `gameobject_template` SET `flags`=65536 WHERE `entry`=180516; +UPDATE `gameobject_template` SET `Data26`=1 WHERE `entry`=180516; + +-- missing model info +DELETE FROM `creature_model_info` WHERE `DisplayID` IN (7804,61763,42947,42335); +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`) VALUES +(42335, 0.1041, 0.6, 0), -- wod only +(42947, 0.347222, 1.5, 0), -- wod only +(7804, 0.00235, 0.01, 0), +(61763, 0.372, 1.5, 0); -- wod only + +-- missing creature texts +DELETE FROM `creature_text` WHERE `entry` IN (18926,20244) AND `id`=0; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(18926, 0, 0, 'Something must be done about these Wretched...\n', 12, 0, 100, 274, 0, 0, 0, 0, 'Sleyin'), +(20244, 0, 0, 'Oooh! Look, a shiny one!', 12, 10, 100, 0, 0, 0, 0, 0, 'Nova'); +UPDATE `creature_text` SET `comment`='Felendren the Banished to Player' WHERE `entry`=15367 AND `groupid`=0; + +-- missing npc_text +DELETE FROM `npc_text` WHERE `ID` IN (22594,20038,17459,17755,17897,9193,9346,10181,16540,17209,9186,9187); +INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextID0`, `BroadcastTextID1`, `BroadcastTextID2`, `BroadcastTextID3`, `BroadcastTextID4`, `BroadcastTextID5`, `BroadcastTextID6`, `BroadcastTextID7`, `VerifiedBuild`) VALUES +(9186, 1, 0, 0, 0, 0, 0, 0, 0, 14765, 0, 0, 0, 0, 0, 0, 0, 20886), +(9187, 1, 0, 0, 0, 0, 0, 0, 0, 14766, 0, 0, 0, 0, 0, 0, 0, 20886), +(17209, 1, 0, 0, 0, 0, 0, 0, 0, 47561, 0, 0, 0, 0, 0, 0, 0, 20779), +(9193, 1, 0, 0, 0, 0, 0, 0, 0, 14773, 0, 0, 0, 0, 0, 0, 0, 20886), +(9346, 1, 0, 0, 0, 0, 0, 0, 0, 15268, 0, 0, 0, 0, 0, 0, 0, 20886), +(10181, 0, 1, 0, 0, 0, 0, 0, 0, 18550, 50499, 0, 0, 0, 0, 0, 0, 20886), +(16540, 1, 0, 0, 0, 0, 0, 0, 0, 44400, 0, 0, 0, 0, 0, 0, 0, 20886), +(17459, 1, 0, 0, 0, 0, 0, 0, 0, 48551, 0, 0, 0, 0, 0, 0, 0, 20886), +(17755, 1, 0, 0, 0, 0, 0, 0, 0, 50502, 0, 0, 0, 0, 0, 0, 0, 20886), +(17897, 1, 0, 0, 0, 0, 0, 0, 0, 50991, 0, 0, 0, 0, 0, 0, 0, 20886), +(20038, 1, 0, 0, 0, 0, 0, 0, 0, 61847, 0, 0, 0, 0, 0, 0, 0, 20886), +(22594, 1, 0, 0, 0, 0, 0, 0, 0, 74286, 0, 0, 0, 0, 0, 0, 0, 20886); +UPDATE `npc_text` SET `BroadcastTextID0`=10117 WHERE `ID`=7381; +UPDATE `npc_text` SET `VerifiedBuild`=20779 WHERE `ID` IN (10117,16703,12335,12336,12341,12342,13893,10182,10183,10184,10185,10186,10187,10189,10190,10191,10192,9577,9587,9602,9603,9624,9330,9331,9332,9333,9334,9335,9336,9337,9338,9339,9340,9341,9342,9343,9344,9345,9347,9348,9349,9350,9316,9317,9318,9319,9320,9321,9322,9323,9324,9325,9326,9327,9192,9189,7381,7395,8684,9630,10180,7784,7821,7869,7903,8229,8413,8698); + +-- delete Sunstrider Mana Tap Counter as quest giver +DELETE FROM `creature_queststarter` WHERE `id`=15468; + +-- Lunar Festival Harbinger questgiver +DELETE FROM `creature_queststarter` WHERE `id`=15895; +INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES +(15895, 8867), +(15895, 8883); + +-- Yasmine Teli'Larien <Demon Trainer> summon imp +UPDATE creature_template SET AIName="SmartAI" WHERE entry=15494; +DELETE FROM `smart_scripts` WHERE `entryorguid`=15494 AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(15494, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 11939, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Yasmine Teli/Larien - On Just Summoned - Summon Imp'); + +-- missing quest stuff +DELETE FROM `quest_details` WHERE `ID` IN (8867,8326,8327,8328,10068,8334,8335,8338,8347,8350,9704,9705,37439,37440,37442,37443); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(8326, 1, 1, 0, 0, 0, 0, 0, 0, 20779), +(8327, 1, 2, 0, 0, 0, 0, 0, 0, 20779), +(8328, 1, 1, 0, 0, 0, 0, 0, 0, 20779), +(10068, 1, 1, 0, 0, 0, 1000, 0, 0, 20779), +(8334, 5, 25, 1, 0, 0, 0, 0, 0, 20779), +(8335, 1, 5, 0, 0, 0, 0, 0, 0, 20779), +(8338, 0, 0, 0, 0, 0, 0, 0, 0, 20779), +(8347, 2, 1, 0, 0, 0, 0, 0, 0, 20779), +(8350, 1, 1, 0, 0, 0, 0, 0, 0, 20779), +(9704, 0, 0, 0, 0, 0, 0, 0, 0, 20779), +(9705, 0, 0, 0, 0, 0, 0, 0, 0, 20779), +(37439, 1, 1, 0, 0, 0, 0, 0, 0, 20779), -- cata only +(37440, 0, 0, 0, 0, 0, 0, 0, 0, 20779), -- cata only +(37442, 1, 1, 1, 0, 0, 1000, 1000, 0, 20779), -- cata only +(37443, 1, 1, 1, 0, 0, 0, 0, 0, 20779), -- cata only +(8867, 0, 0, 0, 0, 0, 0, 0, 0, 20886); + +DELETE FROM `quest_request_items` WHERE `ID` IN (8326,10068,8335,8338,9705,37440,37443); +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES +(8326, 0, 0, 0, 0, 'It gives me no pleasure to ask you to destroy these beasts. While in times past we have lived in relative harmony with woodland creatures, these are different times. The first order of business for all sin\'dorei is survival; make sure you remember that.', 20779), +(10068, 0, 0, 0, 0, 'Have you adequately practiced your new spell?', 20779), +(8335, 1, 0, 0, 0, 'Heed well this warning - Felendren the Banished is only a symptom of a much larger problem. His demise will solve our immediate concerns, but all blood elves share the potential same fate as him if we let our addictions get the best of us.', 20779), +(8338, 6, 0, 0, 0, 'From your demeanor, you seem to be on a matter of some urgency. Is there something specific I can assist you with?', 20779), +(9705, 0, 0, 0, 0, 'What did you find, $n?', 20779), +(37440, 5, 0, 0, 0, 'Many of the creatures here on the isle were at one point bound into non-aggression and complacency by our magical skills. When the Scourge destroyed the Sunwell, our hold over these creatures shattered. Arcane slivers are the remnants of the control we once had, and as such might be usable in fashioning a new device to aid us in regaining their control.$B$BBetter still, perhaps the slivers could be used to see what malaise the isle truly suffers under...', 20779), +(37443, 6, 0, 0, 0, 'Have you had a chance to find my belongings? Once we reassert our dominance over Sunstrider Isle, I will need them in my work. For now though, I must maintain my watch over the Sunwell... or what remains of it.', 20779); + +DELETE FROM `quest_offer_reward` WHERE `ID` IN (8327,8334,8335,8338,8347,9704,9705,37439,37440,37442,37443); +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(8327, 2, 1, 0, 0, 0, 0, 0, 0, 'Magistrix Erona told me you\'d be along quick enough, $n. The Falthrien Academy to our west - the huge floating building with the ornate spires - is in bad shape. You\'re going to be leading the effort to recapture it from one of the Wretched - a blood elf who has forever succumbed to their basest cravings.$B$BI hope you\'re ready to work. This is not only going to be a lesson about danger, but also of what happens when you forsake the realities of who you are.', 20779), +(8334, 1, 1, 0, 0, 0, 0, 0, 0, 'While the deaths of the tenders give me no joy whatsoever, it does show me that you\'re ready for the most important task you\'ll do here on Sunstrider Isle. Take this and put it to good use; you\'ll need good items and sharp wits for the task ahead. Our reassertion of control over the island depends on it.', 20779), +(8335, 0, 0, 0, 0, 0, 0, 0, 0, 'Felendren\'s head... you are to be commended, $n. You\'ve succeeded where others, like Felendren, have utterly failed. Perhaps you are truly ready to be a contributing member of blood elf society.$B$BYour success here means that you are capable of surviving the greater threats that lurk in Eversong... and believe me, there are plenty to face.', 20779), +(8338, 1, 1, 0, 0, 0, 0, 0, 0, 'This is... most interesting. And when I say interesting, I mean more disturbing than anything else.$B$BOur efforts to reassert control over the isle in the time following the destruction of the Sunwell have been a challenge. I suspect that whatever foul source is corrupting the isle is at the heart of it all; this sliver may be of some aid in uncovering what\'s really going on.$B$BYou were wise to bring this to me, $n. Take this as compensation for your diligence. Thank you.', 20779), +(8347, 1, 1, 0, 0, 0, 0, 0, 0, 'Well hello there, $c! I heard that a resourceful young blood elf formerly in the service of Magistrix Erona might be making their way down here to help us Outrunners out. We certainly welcome the help, especially from someone who\'s proven to be so competent.$B$BI hope you\'re interested in running an errand or two for us.', 20779), +(9704, 0, 0, 0, 0, 0, 0, 0, 0, 'The outrunner\'s belongings have all been stolen with the exception of one package. It seems to match Alarion\'s description of Erona\'s package.', 20779), +(9705, 0, 0, 0, 0, 0, 0, 0, 0, 'By the Sunwell! That\'s the third outrunner we\'ve lost this month.$B$BI appreciate your courage in venturing into Dawning Street. The guards need to keep a closer eye on these blasted Wretched.', 20779), +(37439, 1, 1, 0, 0, 0, 0, 0, 0, 'You\'ve done well today, $n. Your willingness to learn shows that you may very well rise above the unyielding cravings you must endure as a blood elf.$B$BRest not on your laurels, young one, but instead seek to master what you have learned. Only through diligence will we as a race survive.$B$BTake this - it may be of some use to you. Go now, and bring glory once more to our people.', 20779), +(37440, 1, 1, 0, 0, 0, 0, 0, 0, 'Splendid - these will do nicely. I\'ve been doing quite a bit of thinking on the current malaise Sunstrider Isle suffers under. One possible course of action I had pondered was to collect these arcane slivers from the beasts on the isle. In doing so, they could be experimented on; this would provide a potential source of culpability.$B$BAnyway, I will tend to the research. Allow me to place this incantation on you. I believe you\'ll make good use of it!', 20779), +(37442, 2, 1, 1, 0, 0, 0, 0, 0, 'Ah, $n - thank you for sharing your experience at the Shrine of Dath\'Remar. First off, you should be commended for your sense of duty and respect - it will serve you well not only here, but in all of Azeroth as well.$B$BAs for the odd sensation, it is no doubt a contributing part of the taint that has befallen Sunstrider Isle. We shall keep an eye on it; thank you for alerting us to it!', 20779), +(37443, 21, 1, 0, 0, 0, 0, 0, 0, 'Well done - I knew you\'d be perfect for the task. Once it\'s safe to make use of our outdoor facilities on the isle, I\'ll be putting these things to good use.$B$BLike I mentioned, please feel free to keep the satchel. Also, you may find this piece of armor to be useful. Consider it ample compensation for a simple task performed dutifully!', 20779); +UPDATE `quest_request_items` SET `VerifiedBuild`=20886 WHERE `ID`=8867; + +-- npc_vendor +UPDATE `npc_vendor` SET `VerifiedBuild`=20886 WHERE `entry`=15898; +DELETE FROM `npc_vendor` WHERE `item` IN (2512,2515,3030,3464,9399,11285,19316,18042,12654,28053,24417,28056,30611,31949,33803,34581,31737,30319,41165,41586,52021,2516,8067,4960,2519,8068,5568,3033,8069,3465,10512,11284,10513,19317,15997,11630,13377,28060,23772,28061,30612,32883,32882,23773,34582,31735,41164,41584,52020); +DELETE FROM `creature_loot_template` WHERE `Item` IN (2512,2515,3030,3464,9399,11285,19316,18042,12654,28053,24417,28056,30611,31949,33803,34581,31737,30319,41165,41586,52021,2516,8067,4960,2519,8068,5568,3033,8069,3465,10512,11284,10513,19317,15997,11630,13377,28060,23772,28061,30612,32883,32882,23773,34582,31735,41164,41584,52020); +DELETE FROM `gameobject_loot_template` WHERE `Item` IN (2512,2515,3030,3464,9399,11285,19316,18042,12654,28053,24417,28056,30611,31949,33803,34581,31737,30319,41165,41586,52021,2516,8067,4960,2519,8068,5568,3033,8069,3465,10512,11284,10513,19317,15997,11630,13377,28060,23772,28061,30612,32883,32882,23773,34582,31735,41164,41584,52020); +DELETE FROM `npc_vendor` WHERE `entry` IN (15433,15287,15289,15292,16185,16257,16258,18277,18926,18929,18951,50484,63080,15291); +INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES +(15287, 2, 159, 0, 0, 0, 1, 0, 0, 20886), +(15287, 1, 20857, 0, 0, 0, 1, 0, 0, 20886), +(15289, 4, 20849, 0, 0, 0, 1, 0, 0, 20886), +(15289, 1, 20850, 0, 0, 0, 1, 0, 0, 20886), +(15289, 3, 20851, 0, 0, 0, 1, 0, 0, 20886), +(15289, 2, 20852, 0, 0, 0, 1, 0, 0, 20886), +(15289, 5, 20853, 0, 0, 0, 1, 0, 0, 20886), +(15289, 6, 20910, 0, 0, 0, 1, 0, 0, 20886), +(15292, 7, 20911, 0, 0, 0, 1, 0, 1, 20886), +(15292, 8, 20912, 0, 0, 0, 1, 0, 1, 20886), +(15292, 3, 20914, 0, 0, 0, 1, 0, 0, 20886), +(15292, 4, 20915, 0, 0, 0, 1, 0, 0, 20886), +(15292, 6, 20916, 0, 0, 0, 1, 0, 0, 20886), +(15292, 5, 20917, 0, 0, 0, 1, 0, 0, 20886), +(15292, 2, 20918, 0, 0, 0, 1, 0, 0, 20886), +(15292, 1, 20919, 0, 0, 0, 1, 0, 0, 20886), +(16185, 1, 37460, 0, 0, 0, 1, 0, 0, 20886), +(16257, 6, 2488, 0, 0, 0, 1, 0, 1, 20886), +(16257, 1, 2489, 0, 0, 0, 1, 0, 1, 20886), +(16257, 7, 2490, 0, 0, 0, 1, 0, 1, 20886), +(16257, 3, 2491, 0, 0, 0, 1, 0, 1, 20886), +(16257, 2, 2492, 0, 0, 0, 1, 0, 1, 20886), +(16257, 8, 2493, 0, 0, 0, 1, 0, 1, 20886), +(16257, 4, 2494, 0, 0, 0, 1, 0, 1, 20886), +(16257, 5, 2495, 0, 0, 0, 1, 0, 1, 20886), +(16258, 8, 2376, 0, 0, 0, 1, 0, 1, 20886), +(16258, 1, 2398, 0, 0, 0, 1, 0, 0, 20886), +(16258, 2, 2399, 0, 0, 0, 1, 0, 0, 20886), +(16258, 3, 2400, 0, 0, 0, 1, 0, 0, 20886), +(16258, 4, 2401, 0, 0, 0, 1, 0, 0, 20886), +(16258, 5, 2402, 0, 0, 0, 1, 0, 0, 20886), +(16258, 6, 2403, 0, 0, 0, 1, 0, 0, 20886), +(16258, 7, 17185, 0, 0, 0, 1, 0, 1, 20886), +(18277, 3, 2320, 0, 0, 0, 1, 0, 0, 20886), +(18277, 4, 2321, 0, 0, 0, 1, 0, 0, 20886), +(18277, 9, 2325, 0, 0, 0, 1, 0, 0, 20886), +(18277, 11, 2604, 0, 0, 0, 1, 0, 0, 20886), +(18277, 12, 2605, 0, 0, 0, 1, 0, 0, 20886), +(18277, 2, 4289, 0, 0, 0, 1, 0, 0, 20886), +(18277, 5, 4291, 0, 0, 0, 1, 0, 0, 20886), +(18277, 13, 4340, 0, 0, 0, 1, 0, 0, 20886), +(18277, 14, 4341, 0, 0, 0, 1, 0, 0, 20886), +(18277, 16, 4342, 0, 0, 0, 1, 0, 0, 20886), +(18277, 10, 6260, 0, 0, 0, 1, 0, 0, 20886), +(18277, 15, 6261, 0, 0, 0, 1, 0, 0, 20886), +(18277, 1, 7005, 0, 0, 0, 1, 0, 0, 20886), +(18277, 6, 8343, 0, 0, 0, 1, 0, 0, 20886), +(18277, 17, 10290, 0, 0, 0, 1, 0, 0, 20886), +(18277, 7, 14341, 0, 0, 0, 1, 0, 0, 20886), +(18277, 8, 38426, 0, 0, 0, 1, 0, 0, 20886), +(18926, 6, 2488, 0, 0, 0, 1, 0, 1, 20886), +(18926, 1, 2489, 0, 0, 0, 1, 0, 1, 20886), +(18926, 7, 2490, 0, 0, 0, 1, 0, 1, 20886), +(18926, 3, 2491, 0, 0, 0, 1, 0, 1, 20886), +(18926, 2, 2492, 0, 0, 0, 1, 0, 1, 20886), +(18926, 8, 2493, 0, 0, 0, 1, 0, 1, 20886), +(18926, 4, 2494, 0, 0, 0, 1, 0, 1, 20886), +(18926, 5, 2495, 0, 0, 0, 1, 0, 1, 20886), +(18929, 2, 414, 0, 0, 0, 1, 0, 0, 20886), +(18929, 3, 422, 0, 0, 0, 1, 0, 0, 20886), +(18929, 4, 1707, 0, 0, 0, 1, 0, 0, 20886), +(18929, 1, 2070, 0, 0, 0, 1, 0, 0, 20886), +(18929, 5, 3927, 0, 0, 0, 1, 0, 0, 20886), +(18929, 6, 8932, 0, 0, 0, 1, 0, 0, 20886), +(18951, 5, 4470, 0, 0, 0, 1, 0, 0, 20886), +(18951, 2, 6217, 0, 0, 0, 1, 0, 0, 20886), +(18951, 4, 10938, 2, 7200, 0, 1, 0, 0, 20886), +(18951, 3, 10940, 4, 7200, 0, 1, 0, 0, 20886), +(18951, 6, 11291, 0, 0, 0, 1, 0, 0, 20886), +(18951, 8, 20752, 0, 0, 0, 1, 0, 0, 20886), +(18951, 9, 20753, 0, 0, 0, 1, 0, 0, 20886), +(18951, 7, 20758, 0, 0, 0, 1, 0, 0, 20886), +(18951, 10, 22307, 0, 0, 0, 1, 0, 0, 20886), +(18951, 1, 38682, 0, 0, 0, 1, 0, 0, 20886), +(50484, 1, 45585, 0, 0, 0, 1, 0, 0, 20886), +(50484, 5, 64914, 0, 0, 0, 1, 12250, 0, 20886), +(50484, 4, 64915, 0, 0, 0, 1, 12250, 0, 20886), +(50484, 3, 64916, 0, 0, 0, 1, 12250, 0, 20886), +(50484, 2, 67535, 0, 0, 0, 1, 12249, 0, 20886), +(63080, 10, 98715, 0, 0, 4301, 1, 0, 0, 20886), -- cata only +(63080, 9, 98715, 0, 0, 4300, 1, 0, 0, 20886), -- cata only +(63080, 8, 98715, 0, 0, 4299, 1, 0, 0, 20886), -- cata only +(63080, 7, 98715, 0, 0, 4298, 1, 0, 0, 20886), -- cata only +(63080, 6, 98715, 0, 0, 4297, 1, 0, 0, 20886), -- cata only +(63080, 5, 98715, 0, 0, 4296, 1, 0, 0, 20886), -- cata only +(63080, 4, 98715, 0, 0, 4295, 1, 0, 0, 20886), -- cata only +(63080, 3, 98715, 0, 0, 4294, 1, 0, 0, 20886), -- cata only +(63080, 2, 98715, 0, 0, 4293, 1, 0, 0, 20886), -- cata only +(63080, 1, 98715, 0, 0, 4292, 1, 0, 0, 20886), -- cata only +(15291, 8, 20920, 0, 0, 0, 1, 0, 0, 20886), +(15291, 10, 20921, 0, 0, 0, 1, 0, 0, 20886), +(15291, 11, 20922, 0, 0, 0, 1, 0, 0, 20886), +(15291, 12, 20923, 0, 0, 0, 1, 0, 0, 20886), +(15291, 9, 20924, 0, 0, 0, 1, 0, 0, 20886), +(15291, 7, 20925, 0, 0, 0, 1, 0, 0, 20886), +(15291, 4, 20985, 0, 0, 0, 1, 0, 0, 20886), +(15291, 3, 20986, 0, 0, 0, 1, 0, 0, 20886), +(15291, 6, 20987, 0, 0, 0, 1, 0, 0, 20886), +(15291, 5, 20988, 0, 0, 0, 1, 0, 0, 20886), +(15291, 2, 20989, 0, 0, 0, 1, 0, 0, 20886), +(15291, 1, 20990, 0, 0, 0, 1, 0, 0, 20886), +(15433, 12, 8766, 0, 0, 0, 1, 0, 0, 20886), -- 8766 +(15433, 11, 1645, 0, 0, 0, 1, 0, 0, 20886), -- 1645 +(15433, 10, 1708, 0, 0, 0, 1, 0, 0, 20886), -- 1708 +(15433, 9, 1205, 0, 0, 0, 1, 0, 0, 20886), -- 1205 +(15433, 8, 1179, 0, 0, 0, 1, 0, 0, 20886), -- 1179 +(15433, 7, 159, 0, 0, 0, 1, 0, 0, 20886), -- 159 +(15433, 6, 8950, 0, 0, 0, 1, 0, 0, 20886), -- 8950 +(15433, 5, 4601, 0, 0, 0, 1, 0, 0, 20886), -- 4601 +(15433, 4, 4544, 0, 0, 0, 1, 0, 0, 20886), -- 4544 +(15433, 3, 4542, 0, 0, 0, 1, 0, 0, 20886), -- 4542 +(15433, 2, 4541, 0, 0, 0, 1, 0, 0, 20886), -- 4541 +(15433, 1, 4540, 0, 0, 0, 1, 0, 0, 20886); -- 4540 + +-- creature equip +DELETE FROM `creature_equip_template` WHERE `CreatureID` IN (14822,14823,14827,14828,14829,14832,14844,14847,14849,14849,14849,15278,15279,15280,15281,15283,15284,15285,15287,15289,15292,15295,15296,15297,15301,15303,15367,15403,15405,15416,15418,15433,15494,15501,15644,15654,15760,15938,15940,15946,15949,15970,16185,16192,16257,16258,16262,16266,16267,16269,16272,16273,16275,16276,16278,16279,16923,16924,17005,17807,17849,18347,18790,18951,19882,23721,43010,43012,50484,54595,54596,54601,55096,55220,55221,55222,55223,55225,55226,55229,55231,55264,55266,55278,55339,55341,55342,55348,55397,55398,55730,56041,56068,56069,57850,58342,63332,68402,68492,74056,85484,85519,90473); +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`, `VerifiedBuild`) VALUES +(14822, 1, 12746, 0, 72515, 0), +(14823, 1, 19214, 0, 0, 0), +(14827, 1, 5287, 0, 0, 0), +(14828, 1, 0, 0, 12851, 0), +(14829, 1, 1911, 0, 0, 0), +(14832, 1, 74776, 0, 74776, 0), +(14844, 1, 13861, 0, 0, 0), +(14847, 1, 0, 0, 12867, 0), +(14849, 1, 2493, 0, 0, 0), +(14849, 2, 3362, 0, 13604, 0), +(14849, 3, 3362, 0, 13605, 0), +(15278, 1, 11343, 0, 0, 0), +(15279, 1, 11343, 0, 0, 0), +(15280, 1, 13160, 0, 0, 0), +(15281, 1, 11343, 0, 0, 0), +(15283, 1, 19987, 0, 0, 0), +(15284, 1, 13751, 0, 0, 0), +(15285, 1, 17283, 0, 0, 0), +(15287, 1, 12850, 0, 0, 0), +(15289, 1, 5291, 0, 14880, 0), +(15292, 1, 1903, 0, 0, 0), +(15295, 1, 11343, 0, 0, 0), +(15296, 1, 11343, 0, 0, 0), +(15297, 1, 11343, 0, 0, 0), +(15301, 1, 5305, 0, 0, 0), +(15303, 1, 1906, 0, 0, 0), +(15367, 1, 2147, 0, 0, 0), +(15403, 1, 23225, 0, 0, 0), +(15405, 1, 11343, 0, 0, 0), +(15416, 1, 12993, 0, 0, 0), +(15418, 1, 11343, 0, 0, 0), +(15433, 1, 13861, 0, 0, 0), +(15494, 1, 2184, 0, 0, 0), +(15501, 1, 13750, 0, 0, 0), +(15644, 1, 2184, 0, 0, 0), +(15654, 1, 1895, 0, 0, 0), +(15760, 1, 2703, 0, 0, 0), +(15938, 1, 24034, 0, 24034, 0), +(15940, 1, 12993, 0, 0, 0), +(15946, 1, 12328, 0, 0, 0), +(15949, 1, 23240, 0, 0, 0), +(15970, 1, 11343, 0, 0, 0), +(16185, 1, 3346, 0, 0, 0), +(16192, 1, 5303, 0, 0, 0), +(16257, 1, 1905, 0, 0, 0), +(16258, 1, 0, 0, 11041, 0), +(16262, 1, 2717, 0, 12860, 0), +(16266, 1, 11343, 0, 0, 0), +(16267, 1, 12959, 0, 0, 0), +(16269, 1, 23240, 0, 0, 0), +(16272, 1, 13220, 0, 0, 0), +(16273, 1, 5278, 0, 0, 0), +(16275, 1, 1983, 0, 0, 0), +(16276, 1, 12591, 0, 0, 0), +(16278, 1, 10616, 0, 0, 0), +(16279, 1, 2184, 0, 0, 0), +(16923, 1, 23241, 0, 0, 0), +(16924, 1, 23225, 0, 0, 0), +(17005, 1, 23382, 0, 23382, 0), +(17807, 1, 23673, 0, 24038, 0), +(17849, 1, 12993, 0, 0, 0), +(18347, 1, 1117, 0, 0, 0), +(18790, 1, 0, 0, 24038, 0), +(18951, 1, 12864, 0, 0, 0), +(19882, 1, 2716, 0, 13609, 0), +(23721, 1, 5301, 0, 0, 0), +(43010, 1, 23225, 0, 24322, 0), +(43012, 1, 24320, 0, 24328, 0), +(50484, 1, 34337, 0, 0, 0), +(54595, 1, 72107, 0, 0, 0), +(54596, 1, 3350, 0, 0, 0), +(54601, 1, 71969, 0, 0, 0), +(55096, 1, 52358, 0, 2200, 0), +(55220, 1, 1906, 0, 2081, 0), +(55221, 1, 1906, 0, 2081, 0), +(55222, 1, 1906, 0, 2081, 0), +(55223, 1, 1906, 0, 2081, 0), +(55225, 1, 1906, 0, 2081, 0), +(55226, 1, 1906, 0, 2081, 0), +(55229, 1, 2200, 0, 0, 0), +(55231, 1, 2200, 0, 0, 0), +(55264, 1, 0, 0, 12851, 0), +(55266, 1, 0, 0, 12851, 0), +(55278, 1, 9702, 0, 0, 0), +(55339, 1, 0, 0, 12851, 0), +(55341, 1, 1906, 0, 2081, 0), +(55342, 1, 1906, 0, 2081, 0), +(55348, 1, 2202, 0, 0, 0), +(55397, 1, 1906, 0, 2081, 0), +(55398, 1, 1906, 0, 2081, 0), +(55730, 1, 1117, 0, 0, 0), +(56041, 1, 75039, 0, 13407, 0), +(56068, 1, 45991, 0, 0, 0), +(56069, 1, 5278, 0, 19485, 0), +(57850, 1, 1117, 0, 0, 0), +-- wod only +(58342, 1, 3362, 0, 13604, 0), +(63332, 1, 79719, 0, 0, 0), +(68402, 1, 0, 0, 76393, 0), +(68492, 1, 0, 0, 13604, 0), +(74056, 1, 110708, 0, 0, 0), +(85484, 1, 6235, 0, 0, 0), +(85519, 1, 7944, 0, 0, 0), +(90473, 1, 110708, 0, 0, 0); +UPDATE `creature_equip_template` SET `VerifiedBuild`=20779 WHERE `CreatureID` IN (14822,14823,14827,14828,14829,14832,14844,14847,14849,14849,14849,15278,15279,15280,15281,15283,15284,15285,15287,15289,15292,15295,15296,15297,15301,15303,15367,15403,15405,15416,15418,15433,15494,15501,15644,15654,15760,15938,15940,15946,15949,15970,16185,16192,16257,16258,16262,16266,16267,16269,16272,16273,16275,16276,16278,16279,16923,16924,17005,17807,17849,18347,18790,18951,19882,23721,43010,43012,50484,54595,54596,54601,55096,55220,55221,55222,55223,55225,55226,55229,55231,55264,55266,55278,55339,55341,55342,55348,55397,55398,55730,56041,56068,56069,57850,58342,63332,68402,68492,74056,85484,85519,90473); |