diff options
| -rw-r--r-- | sql/updates/world/master/2018_01_06_01_world.sql | 1345 |
1 files changed, 1345 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_01_06_01_world.sql b/sql/updates/world/master/2018_01_06_01_world.sql new file mode 100644 index 00000000000..e9729336541 --- /dev/null +++ b/sql/updates/world/master/2018_01_06_01_world.sql @@ -0,0 +1,1345 @@ +-- +SET @CGUID := 452577; -- Set by TC dev team, 115 free creature GUIDs needed (must be above 450000) +SET @OGUID := 301114; -- 6 free gameobjects GUIDs needed (above 300000) + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+115; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `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, 61367, 1, 1637, 1, 0, 1, 0, 0, 1609.04, -4156.14, 49.4761, 5.29779, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 1, 61367, 1, 1637, 1, 0, 1, 0, 0, 2001.41, -4812.4, 37.8786, 4.48539, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 2, 61367, 1, 1637, 1, 0, 1, 0, 0, 1944.82, -4346.04, 24.1683, 1.87501, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 3, 61367, 1, 1637, 1, 0, 1, 0, 0, 1890.56, -4314.79, 23.9115, 0.932115, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 4, 61367, 1, 1637, 1, 0, 1, 0, 0, 1894.11, -4315.77, 24.1761, 4.59161, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 5, 61369, 1, 1637, 1, 0, 1, 0, 0, 1695.89, -4053.79, 50.1794, 0.76942, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 6, 61369, 1, 1637, 1, 0, 1, 0, 0, 2009.79, -4809.51, 37.5768, 1.55703, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 7, 61369, 1, 1637, 1, 0, 1, 0, 0, 1947.36, -4359.97, 24.1683, 0.779957, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 8, 61369, 1, 1637, 1, 0, 1, 0, 0, 2056.35, -4772.68, 27.9174, 3.91232, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 9, 62114, 1, 1637, 1, 0, 1, 0, 0, 1562.28, -4311.51, 24.2247, 4.68299, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 10, 62114, 1, 1637, 1, 0, 1, 0, 0, 1681.04, -4273.32, 27.5728, 1.52195, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 11, 62114, 1, 1637, 1, 0, 1, 0, 0, 1945.5, -4238.65, 34.9403, 0.983607, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 12, 62114, 1, 1637, 1, 0, 1, 0, 0, 2200.73, -4661.24, 80.8062, 4.78362, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 13, 62114, 1, 1637, 1, 0, 1, 0, 0, 1839.86, -4687.14, 104.83, 3.75271, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 14, 62114, 1, 1637, 1, 0, 1, 0, 0, 2083.41, -4438.11, 96.3776, 3.01926, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 15, 62114, 1, 1637, 1, 0, 1, 0, 0, 1675.57, -4035.83, 130.557, 2.4505, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 16, 62114, 1, 1637, 1, 0, 1, 0, 0, 2045.79, -4188.96, 109.192, 3.3724, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 17, 62114, 1, 1637, 1, 0, 1, 0, 0, 2043.77, -4208.79, 103.57, 0.997679, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 18, 62114, 1, 1637, 1, 0, 1, 0, 0, 2055.36, -4267.99, 95.4692, 6.17469, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 19, 62114, 1, 1637, 1, 0, 1, 0, 0, 1565.14, -4386.37, 16.6173, 5.12055, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 20, 62115, 1, 1637, 1, 0, 1, 0, 0, 1608.7, -4072.23, 123.244, 3.62472, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 21, 62115, 1, 1637, 1, 0, 1, 0, 0, 1594.18, -4077.82, 122.359, 0.928522, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 22, 62115, 1, 1637, 1, 0, 1, 0, 0, 1901.09, -4124.02, 110.536, 3.16079, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 23, 62115, 1, 1637, 1, 0, 1, 0, 0, 1614.49, -4221.1, 53.5546, 5.62659, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 24, 62115, 1, 1637, 1, 0, 1, 0, 0, 1814.7, -4041.45, 123.146, 3.18692, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 25, 62115, 1, 1637, 1, 0, 1, 0, 0, 1750.34, -4556.96, 94.6477, 6.17357, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 26, 62115, 1, 1637, 1, 0, 1, 0, 0, 2311.32, -4699.6, 113.751, 4.55045, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 27, 62115, 1, 1637, 1, 0, 1, 0, 0, 1922.59, -4850.44, 137.291, 5.22781, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 28, 62115, 1, 1637, 1, 0, 1, 0, 0, 2056.76, -4245.75, 96.7391, 3.49932, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 29, 62115, 1, 1637, 1, 0, 1, 0, 0, 2078.34, -4309.84, 98.6946, 5.77397, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 30, 62115, 1, 1637, 1, 0, 1, 0, 0, 2051.04, -4257.11, 95.4638, 1.03828, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 31, 62115, 1, 1637, 1, 0, 1, 0, 0, 1507.08, -4459.71, 27.3521, 3.97947, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 32, 62119, 1, 1637, 1, 0, 1, 0, 0, 1485.36, -4171.62, 52.66, 0.982962, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 33, 62193, 1, 1637, 1, 0, 1, 0, 0, 1968.62, -4660.15, 32.7913, 1.07868, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 34, 62194, 1, 1637, 1, 0, 1, 0, 0, 1730.54, -4496.73, 31.2299, 4.49224, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 35, 62195, 1, 1637, 1, 0, 1, 0, 0, 1511.54, -4399.88, 22.7516, 3.87685, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 36, 62196, 1, 1637, 1, 0, 1, 0, 0, 1888.09, -4550.54, 30.4186, 6.26197, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 37, 62197, 1, 1637, 1, 0, 1, 0, 0, 1890.44, -4550.62, 30.4734, 3.16144, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 38, 62198, 1, 1637, 1, 0, 1, 0, 0, 1742.44, -4412.38, 36.8779, 1.56109, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 39, 62199, 1, 1637, 1, 0, 1, 0, 0, 1807.28, -4515.37, 23.2216, 4.26977, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 40, 62200, 1, 1637, 1, 0, 1, 0, 0, 1808.13, -4515.41, 23.2949, 4.20537, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 41, 62445, 1, 1637, 1, 0, 1, 0, 0, 2023.18, -4704.5, 28.5836, 2.69736, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 42, 63085, 1, 1637, 1, 0, 1, 0, 0, 1567.21, -4158.8, 51.7948, 0.459947, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 43, 63086, 1, 1637, 1, 0, 1, 0, 0, 1567.33, -4159.98, 51.9237, 6.1226, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 44, 63626, 1, 1637, 1, 0, 1, 0, 0, 1799.38, -4420.59, 102.843, 1.09577, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 45, 64105, 1, 1637, 1, 0, 1, 0, 0, 2086.14, -4563.78, 49.378, 2.47499, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 46, 65008, 1, 1637, 1, 0, 1, 0, 0, 2026.58, -4701.57, 28.4496, 2.06214, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 47, 65008, 1, 1637, 1, 0, 1, 0, 0, 2024.45, -4698.13, 28.4639, 5.29936, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 48, 65008, 1, 1637, 1, 0, 1, 0, 0, 2022.24, -4712.99, 28.75, 2.62995, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 49, 65008, 1, 1637, 1, 0, 1, 0, 0, 2017.88, -4711.02, 28.9092, 5.84357, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 50, 65058, 1, 1637, 1, 0, 1, 0, 0, 2041.07, -4706.37, 28.4637, 5.44555, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 51, 65060, 1, 1637, 1, 0, 1, 0, 0, 2032.91, -4718.25, 28.3349, 4.38759, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 52, 65061, 1, 1637, 1, 0, 1, 0, 0, 2025.54, -4714.88, 28.6491, 4.04744, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 53, 65063, 1, 1637, 1, 0, 1, 0, 0, 2034.25, -4699.74, 28.4286, 0, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 54, 65065, 1, 1637, 1, 0, 1, 0, 0, 2018.76, -4747.48, 25.5655, 3.78937, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 55, 65071, 1, 1637, 1, 0, 1, 0, 0, 1988.43, -4720.21, 25.5487, 2.32694, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 56, 65074, 1, 1637, 1, 0, 1, 0, 0, 2009.51, -4732.73, 27.371, 3.83367, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 57, 65076, 1, 1637, 1, 0, 1, 0, 0, 1998.42, -4720.98, 26.9615, 3.84017, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 58, 65078, 1, 1637, 1, 0, 1, 0, 0, 1996.54, -4705.65, 29.4085, 1.73967, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 59, 66022, 1, 1637, 1, 0, 1, 0, 0, 2009.27, -4721.25, 29.5977, 1.0317, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 60, 68869, 1, 1637, 1, 0, 1, 0, 0, 2018.89, -4702.83, 28.6567, 1.33797, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 61, 69333, 1, 1637, 1, 0, 1, 0, 0, 2020.43, -4699.12, 28.5923, 6.15581, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 62, 69977, 1, 1637, 1, 0, 1, 0, 0, 1671.66, -4168.72, 56.3184, 3.9968, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 63, 69978, 1, 1637, 1, 0, 1, 0, 0, 1677.1, -4176.04, 56.3885, 3.61283, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 64, 70301, 1, 1637, 1, 0, 1, 0, 0, 2010.89, -4722.87, 29.4273, 0.383237, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 65, 72559, 1, 1637, 1, 0, 1, 0, 0, 1913.62, -4611.63, 66.4293, 5.35816, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 66, 72559, 1, 1637, 1, 0, 1, 0, 0, 1679.15, -4441.36, 22.7472, 3.54302, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 67, 72559, 1, 1637, 1, 0, 1, 0, 0, 1581.45, -4373.27, 20.3464, 5.66766, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 68, 72939, 1, 1637, 1, 0, 1, 0, 0, 1938.56, -4183.41, 37.063, 4.64258, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 69, 73151, 1, 1637, 1, 0, 1, 0, 0, 1638.24, -4232.46, 52.2176, 4.4855, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 70, 74228, 1, 1637, 1, 0, 1, 0, 0, 1550.95, -4322.51, 26.0445, 2.60054, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 71, 74228, 1, 1637, 1, 0, 1, 0, 0, 1567.81, -4265.52, 97.374, 1.77999, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 72, 74228, 1, 1637, 1, 0, 1, 0, 0, 1633.43, -4316.06, 21.1172, 0.518971, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 73, 74228, 1, 1637, 1, 0, 1, 0, 0, 1584.01, -4219.2, 53.8156, 0.733038, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 74, 74228, 1, 1637, 1, 0, 1, 0, 0, 1800.69, -3969.93, 132.321, 4.98069, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 75, 74228, 1, 1637, 1, 0, 1, 0, 0, 1803.52, -3968.89, 132.124, 4.98068, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 76, 74228, 1, 1637, 1, 0, 1, 0, 0, 1685.38, -3999.98, 133.673, 5.32204, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 77, 74228, 1, 1637, 1, 0, 1, 0, 0, 1687.46, -3997.71, 133.819, 2.18044, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 78, 74228, 1, 1637, 1, 0, 1, 0, 0, 1726.62, -3983.29, 51.2507, 1.51844, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 79, 74228, 1, 1637, 1, 0, 1, 0, 0, 1733.74, -4050.68, 49.7536, 1.23918, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 80, 74228, 1, 1637, 1, 0, 1, 0, 0, 1649.27, -4136.94, 72.0459, 1.95722, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 81, 74228, 1, 1637, 1, 0, 1, 0, 0, 1635.3, -4144.07, 49.0071, 3.56047, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 82, 74228, 1, 1637, 1, 0, 1, 0, 0, 1733.33, -4092.54, 67.755, 1.72788, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 83, 74228, 1, 1637, 1, 0, 1, 0, 0, 1740.93, -4089.11, 67.755, 3.08923, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 84, 74228, 1, 1637, 1, 0, 1, 0, 0, 1735.24, -4087.18, 50.6644, 1.27409, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 85, 74228, 1, 1637, 1, 0, 1, 0, 0, 1736.5, -4125.33, 52.2227, 4.62512, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 86, 74228, 1, 1637, 1, 0, 1, 0, 0, 1673.93, -4433.27, 21.6334, 0.715585, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 87, 74228, 1, 1637, 1, 0, 1, 0, 0, 1950.83, -4738.58, 37.2592, 0.837758, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 88, 74228, 1, 1637, 1, 0, 1, 0, 0, 1843.65, -4396.6, 4.9321, 2.6529, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 89, 74228, 1, 1637, 1, 0, 1, 0, 0, 1594.91, -4209.55, 53.8646, 3.87463, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 90, 74228, 1, 1637, 1, 0, 1, 0, 0, 1736.8, -3981.89, 51.2329, 2.37365, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 91, 74228, 1, 1637, 1, 0, 1, 0, 0, 1725.66, -4017.07, 80.1695, 3.23874, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 92, 74228, 1, 1637, 1, 0, 1, 0, 0, 1689.52, -4094.06, 48.6725, 6.02139, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 93, 74228, 1, 1637, 1, 0, 1, 0, 0, 1686.25, -4086.88, 82.9223, 4.91325, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 94, 74228, 1, 1637, 1, 0, 1, 0, 0, 1721.29, -4266.01, 101.892, 4.45059, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 95, 74228, 1, 1637, 1, 0, 1, 0, 0, 1745.08, -4197.11, 51.9507, 4.64258, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 96, 74228, 1, 1637, 1, 0, 1, 0, 0, 1791.03, -4239.45, 41.0986, 0.645772, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 97, 74228, 1, 1637, 1, 0, 1, 0, 0, 1675.7, -4431.75, 21.6349, 3.83972, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 98, 74228, 1, 1637, 1, 0, 1, 0, 0, 1715.66, -4419.38, 110.297, 3.82227, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 99, 74228, 1, 1637, 1, 0, 1, 0, 0, 1960.46, -4827.36, 57.814, 3.31101, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 10, 74228, 1, 1637, 1, 0, 1, 0, 0, 2012.85, -4693.72, 28.5666, 0.856188, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 101, 74228, 1, 1637, 1, 0, 1, 0, 0, 1804.69, -4410.82, -17.6331, 1.71042, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 102, 74228, 1, 1637, 1, 0, 1, 0, 0, 1725.24, -4309.58, 62.4263, 5.34071, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 103, 74228, 1, 1637, 1, 0, 1, 0, 0, 1540.72, -4320.43, 28.5666, 4.20624, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 104, 74228, 1, 1637, 1, 0, 1, 0, 0, 1548.15, -4361.13, 17.8357, 5.70723, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 105, 74228, 1, 1637, 1, 0, 1, 0, 0, 1676.92, -4436.25, 21.5299, 2.40967, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 106, 86832, 1, 1637, 1, 0, 1, 0, 0, 1669.59, -4343.08, 28.446, 3.61283, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 107, 88543, 1, 1637, 1, 0, 1, 0, 0, 1652.06, -4332.71, 26.8497, 3.56814, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 108, 88543, 1, 1637, 1, 0, 1, 0, 0, 1646.69, -4335.62, 26.8459, 0, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 109, 88701, 1, 1637, 1, 0, 1, 0, 0, 1571.3, -4464.18, 23.2507, 5.37561, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 110, 88702, 1, 1637, 1, 0, 1, 0, 0, 1577.87, -4462.79, 16.1197, 5.07891, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 111, 88703, 1, 1637, 1, 0, 1, 0, 0, 1606.32, -4423.52, 13.6591, 3.02082, 120, 5, 0, 1, 0, 1, 0, 0, 0, 0), +(@CGUID + 112, 88704, 1, 1637, 1, 0, 1, 0, 0, 1843.89, -4353.78, -14.5776, 3.31613, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 113, 88705, 1, 1637, 1, 0, 1, 0, 0, 1848.79, -4360.65, -14.6395, 2.81739, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 114, 88706, 1, 1637, 1, 0, 1, 0, 0, 1838.73, -4348.16, -14.5402, 3.42085, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(@CGUID + 115, 89175, 1, 1637, 1, 0, 1, 0, 0, 1788.39, -4274.87, 7.82597, 5.4083, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0); + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+5; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID + 0, 237942, 1, 1, 0, 1, 1890.26, -4414.05, 15.0157, 4.03161, 0, 0, 0, 1, 120, 255, 1), +(@OGUID + 1, 212212, 1, 1, 0, 1, 1845.52, -4366.61, -14.598, 2.95216, 0, 0, 0, 1, 120, 255, 1), +(@OGUID + 2, 212212, 1, 1, 0, 1, 1811.49, -4370.86, -15.9694, 2.95216, 0, 0, 0, 1, 120, 255, 1), +(@OGUID + 3, 223739, 1, 1, 0, 1, 1395.6, -4368.46, 25.4736, 3.25506, 0, 0, 0.998392, -0.0566929, 120, 255, 0), +(@OGUID + 4, 223814, 1, 1, 0, 1, 1476.76, -4418.42, 25.4728, 0.113445, 0, 0, 0.998392, -0.0566929, 120, 255, 0), +(@OGUID + 5, 237738, 1, 1, 0, 1, 1649.4, -4334.81, 26.7591, 0, 0, 0, 0, 1, 120, 255, 1); + +-- could the DELETE FROM values be compressed by using "WHERE `entry` BETWEEN" instead of "WHERE `entry` IN" ? +-- even if that change needs more than 1 line to separate the groups, it would be a lower amount of values and a better overview. +DELETE FROM `creature_template_addon` WHERE `entry` IN (44158, 49837, 3296, 43062, 9564, 50477, 3310, 51346, 12136, 44919, 15476, 49743, 14881, 20486, 50488, 20493, 20488, 44918, 63626, 49131, 50323, 46718, 7010, 3372, 44948, 20490, 20489, 20491, 46716, 20492, 46741, 52032, 11066, 3345, 74228, 46742, 42548, 45230, 3371, 5875, 46181, 1420, 61367, 3346, 44735, 88704, 88705, 3216, 5639, 47254, 44725, 5909, 3412, 88706, 38821, 47247, 47246, 47253, 3330, 3329, 3335, 5816, 86832, 32520, 47248, 44740, 44743, 44745, 44726, 61369, 44723, 54113, 54004, 50088, 8659, 47321, 51230, 45244, 47335, 47336, 11046, 58193, 58199, 62114, 62115, 44779, 44780, 356, 3347, 3348, 12351, 31146, 4752, 12353, 5195, 3350, 47809, 3351, 64105, 47808, 3362, 6986, 6987, 31755, 47771, 4953, 46647, 31756, 31757, 31758, 31768, 47764, 31769, 52809, 72559, 52812, 62196, 62197, 52810, 47663, 62193, 3225, 5811, 3366, 7088, 3365, 3316, 23635, 16076, 3321, 46621, 3359, 49750, 16069, 2855, 46618, 46619, 46620, 46622, 43239, 3332, 3333, 15186, 7951, 68869, 46642, 65076, 69333, 35845, 65078, 42709, 42638, 4485, 66022, 65071, 31144, 70301, 32666, 46985, 46667, 65074, 3353, 13842, 65008, 3354, 35364, 16868, 16869, 34955, 49573, 65061, 65065, 62445, 65060, 32667, 5029, 65058, 5034, 65063, 2756, 3360, 3361, 7790, 7792, 7793, 4043, 7231, 7230, 3409, 3356, 5812, 46637, 46638, 46639, 46640, 57922, 46675, 50482, 3357, 3358, 11176, 11177, 11178, 1383, 3355, 10266, 47815, 3352, 72254, 67267, 68807, 68404, 68810, 68811, 68403, 68364, 68991, 41200, 66305, 68990, 73639, 70718, 70716, 70713, 70714, 67260, 70726, 68794, 70790, 68808, 68765, 70751, 49889, 71467, 68767, 47818, 47767, 47788, 14539, 14541, 47817, 14540, 42650, 42673, 42671, 42672, 35086, 8576, 35162, 35096, 14377, 3367, 51989, 2857, 14499, 3317, 3413, 11017, 14498, 62199, 62200, 3364, 3363, 3368, 46708, 3369, 46709, 3315, 49737, 42506, 62194, 54472, 57801, 54473, 62198, 28960, 25075, 24927, 44787, 44781, 3322, 3334, 3189, 89175, 15188, 44770, 44782, 3403, 44788, 44785, 44783, 5892, 72939, 13417, 3327, 3328, 47233, 29143, 44160, 26537, 5910, 34765, 3331, 52036, 3405, 12789, 12790, 19850, 12791, 12798, 69977, 69978, 52033, 3404, 7311, 30723, 30706, 45139, 44975, 45093, 45211, 44978, 7565, 12793, 45094, 11814, 8404, 45137, 45138, 45081, 45029, 7562, 45082, 9988, 7567, 12794, 12795, 12797, 45086, 3399, 3400, 45095, 45008, 53081, 5640, 45023, 45015, 45025, 45019, 41266, 45814, 63085, 45822, 63086, 45830, 45659, 46080, 46082, 45661, 45709, 46078, 45662, 14376, 45566, 45827, 45780, 45714, 45720, 49773, 12796, 45563, 30611, 73151, 45558, 45717, 52170, 45567, 45549, 45548, 45789, 45559, 45553, 45713, 45551, 46302, 45552, 45784, 45565, 45718, 62119, 46358, 53153, 45550, 37072, 46512, 3319, 46357, 52412, 46359, 52818, 48510, 46754, 48513, 45544, 45546, 45540, 46755, 45545, 29929, 45347, 3314, 88543, 58155, 35068, 46142, 45339, 5188, 52034, 46555, 3370, 49622, 46556, 4047, 23128, 47571, 45337, 3144, 51195, 46572, 46140, 17098, 3312, 14375, 27489, 89830, 3342, 44878, 44338, 3323, 15116, 88703, 44853, 44877, 44851, 14392, 6929, 44876, 44872, 62195, 44854, 44856, 44871, 14480, 44852, 44867, 5609, 5613, 44865, 44868, 88701, 88702, 6466, 5606, 5610, 5611, 5614, 42637, 44866, 5817, 3313, 3300, 40891, 42859, 4311, 71100, 10880, 31724, 31725, 31720, 31723, 31726, 31727, 25171, 25070, 25071, 25072, 25074, 25076, 24934, 25083, 15214, 24935, 25079, 25077); +INSERT IGNORE INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(44158, 0, 0x0, 0x101, ''), -- 44158 +(44158, 0, 0x1, 0x101, ''), -- 44158 +(49837, 0, 0x0, 0x1, ''), -- 49837 +(3296, 0, 0x0, 0x101, ''), -- 3296 +(43062, 0, 0x0, 0x101, '80160'), -- 43062 - 80160 +(9564, 0, 0x0, 0x101, ''), -- 9564 +(44158, 0, 0x0, 0x101, '81245'), -- 44158 - 81245 +(50477, 29261, 0x0, 0x100, ''), -- 50477 +(3310, 0, 0x0, 0x101, ''), -- 3310 +(51346, 17719, 0x3000000, 0x101, ''), -- 51346 +(12136, 0, 0x0, 0x101, ''), -- 12136 +(44919, 17699, 0x0, 0x1, ''), -- 44919 +(44158, 0, 0x0, 0x101, '82614'), -- 44158 - 82614 +(15476, 0, 0x0, 0x1, ''), -- 15476 +(49743, 0, 0x0, 0x1, ''), -- 49743 +(14881, 0, 0x0, 0x1, ''), -- 14881 +(20486, 0, 0x0, 0x1, ''), -- 20486 +(50488, 29260, 0x0, 0x100, ''), -- 50488 +(20493, 0, 0x0, 0x1, ''), -- 20493 +(20488, 0, 0x0, 0x1, ''), -- 20488 +(44918, 0, 0x0, 0x101, ''), -- 44918 +(63626, 0, 0x0, 0x1, ''), -- 63626 +(49131, 0, 0x0, 0x1, ''), -- 49131 +(50323, 0, 0x0, 0x100, ''), -- 50323 +(46718, 0, 0x0, 0x101, '79849'), -- 46718 - 79849 +(7010, 0, 0x0, 0x101, ''), -- 7010 +(3372, 0, 0x0, 0x101, ''), -- 3372 +(44948, 0, 0x0, 0x1, ''), -- 44948 +(20490, 0, 0x0, 0x1, ''), -- 20490 +(3296, 0, 0x0, 0x100, ''), -- 3296 +(20489, 0, 0x0, 0x1, ''), -- 20489 +(20491, 0, 0x0, 0x1, ''), -- 20491 +(46716, 0, 0x0, 0x101, '79865'), -- 46716 - 79865 +(20492, 0, 0x0, 0x1, ''), -- 20492 +(44158, 0, 0x0, 0x101, '82612'), -- 44158 - 82612 +(46741, 0, 0x0, 0x101, ''), -- 46741 +(52032, 0, 0x0, 0x101, ''), -- 52032 +(11066, 0, 0x0, 0x101, ''), -- 11066 +(3345, 0, 0x0, 0x101, ''), -- 3345 +(74228, 0, 0x0, 0x101, ''), -- 74228 +(46742, 0, 0x0, 0x101, ''), -- 46742 +(42548, 0, 0x0, 0x1, ''), -- 42548 +(45230, 0, 0x0, 0x101, ''), -- 45230 +(3371, 0, 0x0, 0x101, ''), -- 3371 +(5875, 0, 0x0, 0x101, ''), -- 5875 +(46181, 0, 0x0, 0x101, ''), -- 46181 +(1420, 0, 0x0, 0x1, ''), -- 1420 +(3296, 0, 0x1, 0x101, ''), -- 3296 +(61367, 0, 0x0, 0x1, ''), -- 61367 +(3346, 0, 0x0, 0x101, ''), -- 3346 +(45230, 0, 0x1, 0x101, ''), -- 45230 +(44735, 0, 0x0, 0x101, ''), -- 44735 +(88704, 0, 0x0, 0x101, ''), -- 88704 +(88705, 0, 0x0, 0x101, ''), -- 88705 +(3216, 0, 0x0, 0x101, ''), -- 3216 +(5639, 0, 0x0, 0x101, ''), -- 5639 +(47254, 0, 0x0, 0x1, ''), -- 47254 +(44725, 0, 0x0, 0x101, ''), -- 44725 +(5909, 0, 0x1, 0x101, ''), -- 5909 +(3412, 0, 0x0, 0x1, ''), -- 3412 +(88706, 0, 0x0, 0x101, ''), -- 88706 +(38821, 0, 0x0, 0x1, ''), -- 38821 +(47247, 0, 0x0, 0x101, '79865'), -- 47247 - 79865 +(47246, 0, 0x0, 0x101, ''), -- 47246 +(47253, 0, 0x0, 0x101, ''), -- 47253 +(3330, 0, 0x0, 0x101, ''), -- 3330 +(3329, 0, 0x8, 0x101, ''), -- 3329 +(3335, 0, 0x0, 0x101, ''), -- 3335 +(5816, 0, 0x0, 0x102, ''), -- 5816 +(86832, 0, 0x0, 0x101, ''), -- 86832 +(32520, 0, 0x0, 0x1, ''), -- 32520 +(47248, 0, 0x0, 0x101, '79849'), -- 47248 - 79849 +(44740, 0, 0x0, 0x101, ''), -- 44740 +(44743, 0, 0x0, 0x102, ''), -- 44743 +(44745, 0, 0x0, 0x1, ''), -- 44745 +(44726, 0, 0x0, 0x101, ''), -- 44726 +(61369, 0, 0x0, 0x1, ''), -- 61369 +(44723, 0, 0x0, 0x101, ''), -- 44723 +(54113, 0, 0x0, 0x1, ''), -- 54113 +(54004, 0, 0x10000, 0x1, '89302'), -- 54004 - 89302 +(50088, 0, 0x0, 0x1, ''), -- 50088 +(8659, 0, 0x0, 0x101, ''), -- 8659 +(47321, 0, 0x0, 0x1, '32783'), -- 47321 - 32783 +(51230, 0, 0x0, 0x1, ''), -- 51230 +(45244, 0, 0x0, 0x1, ''), -- 45244 +(47335, 0, 0x0, 0x1, ''), -- 47335 +(47336, 0, 0x0, 0x1, ''), -- 47336 +(11046, 0, 0x0, 0x101, ''), -- 11046 +(51346, 17719, 0x3000000, 0x101, '95230'), -- 51346 - 95230 +(58193, 0, 0x0, 0x1, ''), -- 58193 +(58199, 0, 0x0, 0x1, ''), -- 58199 +(62114, 0, 0x0, 0x1, ''), -- 62114 +(62115, 0, 0x0, 0x1, ''), -- 62115 +(44779, 0, 0x0, 0x101, ''), -- 44779 +(44780, 0, 0x0, 0x101, ''), -- 44780 +(356, 0, 0x0, 0x1, ''), -- 356 +(3347, 0, 0x0, 0x101, ''), -- 3347 +(3348, 0, 0x0, 0x101, ''), -- 3348 +(12351, 0, 0x0, 0x1, ''), -- 12351 +(31146, 0, 0x0, 0x1, '61573'), -- 31146 - 61573 +(4752, 0, 0x0, 0x100, ''), -- 4752 +(12353, 0, 0x0, 0x1, ''), -- 12353 +(5195, 0, 0x0, 0x1, ''), -- 5195 +(3350, 0, 0x0, 0x101, ''), -- 3350 +(47809, 0, 0x0, 0x1, ''), -- 47809 +(3351, 0, 0x0, 0x101, ''), -- 3351 +(64105, 0, 0x0, 0x101, ''), -- 64105 +(47808, 0, 0x0, 0x1, ''), -- 47808 +(3362, 0, 0x0, 0x100, ''), -- 3362 +(6986, 0, 0x0, 0x101, ''), -- 6986 +(6987, 0, 0x0, 0x101, ''), -- 6987 +(31755, 0, 0x0, 0x1, ''), -- 31755 +(47771, 0, 0x0, 0x100, ''), -- 47771 +(4953, 0, 0x0, 0x1, ''), -- 4953 +(46647, 0, 0x0, 0x1, '61573'), -- 46647 - 61573 +(31756, 0, 0x0, 0x1, ''), -- 31756 +(31757, 0, 0x0, 0x1, ''), -- 31757 +(31758, 0, 0x0, 0x1, ''), -- 31758 +(31768, 0, 0x0, 0x1, ''), -- 31768 +(47764, 0, 0x0, 0x101, ''), -- 47764 +(31769, 0, 0x0, 0x1, ''), -- 31769 +(52809, 0, 0x0, 0x101, ''), -- 52809 +(72559, 0, 0x0, 0x101, ''), -- 72559 +(52812, 0, 0x0, 0x1, '46598 96847'), -- 52812 - 46598, 96847 +(62196, 0, 0x0, 0x101, '79865'), -- 62196 - 79865 +(62197, 0, 0x0, 0x102, '94218'), -- 62197 - 94218 +(52810, 0, 0x0, 0x1, '46598 96850 16245 97577'), -- 52810 - 46598, 96850, 16245, 97577 +(47663, 0, 0x0, 0x101, '18950'), -- 47663 - 18950 +(62193, 0, 0x1, 0x101, '116562'), -- 62193 - 116562 +(3225, 0, 0x0, 0x1, '65985'), -- 3225 - 65985 +(5811, 0, 0x0, 0x101, ''), -- 5811 +(3366, 0, 0x0, 0x101, ''), -- 3366 +(7088, 0, 0x8, 0x101, ''), -- 7088 +(3365, 0, 0x0, 0x101, ''), -- 3365 +(3316, 0, 0x0, 0x101, ''), -- 3316 +(23635, 0, 0x0, 0x101, ''), -- 23635 +(16076, 0, 0x0, 0x1, ''), -- 16076 +(3321, 0, 0x0, 0x101, ''), -- 3321 +(46621, 0, 0x0, 0x101, ''), -- 46621 +(3359, 0, 0x0, 0x101, ''), -- 3359 +(49750, 0, 0x0, 0x1, ''), -- 49750 +(16069, 0, 0x0, 0x1, '24983'), -- 16069 - 24983 +(2855, 0, 0x0, 0x101, ''), -- 2855 +(46618, 0, 0x0, 0x101, ''), -- 46618 +(46619, 0, 0x0, 0x101, ''), -- 46619 +(46620, 0, 0x0, 0x101, ''), -- 46620 +(46622, 0, 0x0, 0x101, ''), -- 46622 +(3296, 0, 0x3, 0x101, '55701'), -- 3296 - 55701 +(43239, 0, 0x0, 0x101, ''), -- 43239 +(3332, 0, 0x0, 0x101, ''), -- 3332 +(3333, 0, 0x0, 0x101, ''), -- 3333 +(15186, 0, 0x0, 0x1, '24983'), -- 15186 - 24983 +(7951, 0, 0x0, 0x1, ''), -- 7951 +(68869, 0, 0x0, 0x1, '19231'), -- 68869 - 19231 +(46642, 0, 0x0, 0x101, ''), -- 46642 +(65076, 0, 0x0, 0x1, ''), -- 65076 +(69333, 0, 0x0, 0x101, ''), -- 69333 +(35845, 0, 0x0, 0x1, ''), -- 35845 +(65078, 0, 0x0, 0x1, ''), -- 65078 +(42709, 0, 0x0, 0x101, ''), -- 42709 +(42638, 0, 0x0, 0x101, ''), -- 42638 +(4485, 0, 0x0, 0x101, ''), -- 4485 +(3296, 0, 0x8, 0x100, ''), -- 3296 +(66022, 0, 0x0, 0x1, ''), -- 66022 +(65071, 0, 0x3000000, 0x1, ''), -- 65071 +(31144, 0, 0x0, 0x1, '61573'), -- 31144 - 61573 +(70301, 0, 0x1, 0x101, ''), -- 70301 +(32666, 0, 0x0, 0x1, '61573'), -- 32666 - 61573 +(46985, 0, 0x0, 0x1, ''), -- 46985 +(46667, 0, 0x0, 0x101, '79064'), -- 46667 - 79064 +(65074, 0, 0x0, 0x1, ''), -- 65074 +(3353, 0, 0x1, 0x100, ''), -- 3353 +(13842, 0, 0x0, 0x101, ''), -- 13842 +(65008, 0, 0x0, 0x1, ''), -- 65008 +(3354, 0, 0x1, 0x100, ''), -- 3354 +(35364, 0, 0x0, 0x0, ''), -- 35364 +(16868, 0, 0x0, 0x1, ''), -- 16868 +(16869, 0, 0x0, 0x1, ''), -- 16869 +(34955, 0, 0x0, 0x100, ''), -- 34955 +(49573, 0, 0x0, 0x100, '12544'), -- 49573 - 12544 +(65061, 0, 0x0, 0x1, ''), -- 65061 +(65065, 0, 0x3000000, 0x1, ''), -- 65065 +(62445, 0, 0x0, 0x1, ''), -- 62445 +(65060, 0, 0x0, 0x1, ''), -- 65060 +(32667, 0, 0x0, 0x1, '61573'), -- 32667 - 61573 +(5029, 0, 0x0, 0x1, ''), -- 5029 +(65058, 0, 0x0, 0x1, ''), -- 65058 +(5034, 0, 0x0, 0x1, ''), -- 5034 +(65063, 0, 0x0, 0x1, ''), -- 65063 +(2756, 0, 0x0, 0x1, ''), -- 2756 +(3360, 0, 0x0, 0x101, ''), -- 3360 +(3361, 0, 0x0, 0x101, ''), -- 3361 +(7790, 0, 0x0, 0x101, ''), -- 7790 +(7792, 0, 0x0, 0x101, ''), -- 7792 +(7793, 0, 0x0, 0x101, ''), -- 7793 +(4043, 0, 0x0, 0x101, ''), -- 4043 +(7231, 0, 0x0, 0x101, ''), -- 7231 +(7230, 0, 0x0, 0x101, ''), -- 7230 +(3409, 0, 0x0, 0x101, ''), -- 3409 +(3356, 0, 0x0, 0x101, ''), -- 3356 +(5812, 0, 0x0, 0x101, ''), -- 5812 +(46637, 0, 0x0, 0x101, ''), -- 46637 +(46638, 0, 0x0, 0x101, ''), -- 46638 +(46639, 0, 0x0, 0x101, ''), -- 46639 +(46640, 0, 0x0, 0x101, ''), -- 46640 +(57922, 0, 0x0, 0x101, ''), -- 57922 +(46675, 0, 0x0, 0x101, ''), -- 46675 +(50482, 0, 0x0, 0x101, ''), -- 50482 +(3357, 0, 0x0, 0x101, ''), -- 3357 +(3358, 0, 0x0, 0x101, ''), -- 3358 +(11176, 0, 0x0, 0x101, ''), -- 11176 +(11177, 0, 0x0, 0x101, ''), -- 11177 +(11178, 0, 0x0, 0x101, ''), -- 11178 +(1383, 0, 0x0, 0x101, ''), -- 1383 +(3355, 0, 0x0, 0x101, ''), -- 3355 +(10266, 0, 0x0, 0x101, ''), -- 10266 +(47815, 0, 0x0, 0x1, ''), -- 47815 +(3352, 0, 0x0, 0x102, ''), -- 3352 +(72254, 0, 0x0, 0x101, ''), -- 72254 +(67267, 0, 0x0, 0x101, '134909'), -- 67267 - 134909 +(68807, 0, 0x0, 0x1, ''), -- 68807 +(68404, 0, 0x0, 0x1, ''), -- 68404 +(67267, 0, 0x0, 0x101, ''), -- 67267 +(68810, 0, 0x0, 0x1, ''), -- 68810 +(68811, 0, 0x0, 0x1, ''), -- 68811 +(68403, 0, 0x0, 0x1, ''), -- 68403 +(68364, 0, 0x0, 0x1, ''), -- 68364 +(68991, 0, 0x0, 0x1, ''), -- 68991 +(41200, 0, 0x3000000, 0x1, ''), -- 41200 +(66305, 0, 0x3000000, 0x1, ''), -- 66305 +(68990, 0, 0x0, 0x1, ''), -- 68990 +(73639, 0, 0x0, 0x1, ''), -- 73639 +(70718, 0, 0x0, 0x1, ''), -- 70718 +(70716, 0, 0x0, 0x1, ''), -- 70716 +(70713, 0, 0x0, 0x1, ''), -- 70713 +(70714, 0, 0x0, 0x1, ''), -- 70714 +(67260, 0, 0x3000000, 0x1, '132640 135965 135966 90766'), -- 67260 - 132640, 135965, 135966, 90766 +(70726, 0, 0x0, 0x1, ''), -- 70726 +(68794, 0, 0x0, 0x1, ''), -- 68794 +(70790, 0, 0x0, 0x1, ''), -- 70790 +(68808, 0, 0x1, 0x1, ''), -- 68808 +(68765, 0, 0x0, 0x1, ''), -- 68765 +(70751, 0, 0x0, 0x101, ''), -- 70751 +(49889, 0, 0x0, 0x1, '90317 75773'), -- 49889 - 90317, 75773 +(71467, 0, 0x0, 0x1, ''), -- 71467 +(68767, 0, 0x6, 0x1, ''), -- 68767 +(47818, 0, 0x0, 0x1, ''), -- 47818 +(47767, 0, 0x0, 0x101, ''), -- 47767 +(47788, 0, 0x0, 0x101, ''), -- 47788 +(14539, 0, 0x0, 0x1, ''), -- 14539 +(14541, 0, 0x0, 0x1, ''), -- 14541 +(47817, 0, 0x0, 0x1, ''), -- 47817 +(14540, 0, 0x0, 0x1, ''), -- 14540 +(42650, 0, 0x0, 0x101, '80126'), -- 42650 - 80126 +(42650, 0, 0x0, 0x101, ''), -- 42650 +(42673, 0, 0x0, 0x1, ''), -- 42673 +(42671, 0, 0x0, 0x101, ''), -- 42671 +(42650, 0, 0x0, 0x100, ''), -- 42650 +(42672, 0, 0x0, 0x101, ''), -- 42672 +(35086, 0, 0x0, 0x101, ''), -- 35086 +(8576, 0, 0x0, 0x101, ''), -- 8576 +(35162, 0, 0x0, 0x1, ''), -- 35162 +(35096, 0, 0x0, 0x1, ''), -- 35096 +(14377, 0, 0x0, 0x101, '18950'), -- 14377 - 18950 +(3367, 0, 0x0, 0x101, ''), -- 3367 +(51989, 0, 0x0, 0x1, ''), -- 51989 +(2857, 0, 0x0, 0x101, ''), -- 2857 +(14499, 0, 0x0, 0x1, ''), -- 14499 +(3317, 0, 0x0, 0x101, ''), -- 3317 +(3413, 0, 0x0, 0x1, ''), -- 3413 +(11017, 0, 0x0, 0x1, ''), -- 11017 +(14498, 0, 0x0, 0x101, ''), -- 14498 +(62199, 0, 0x0, 0x1, ''), -- 62199 +(62200, 0, 0x0, 0x1, ''), -- 62200 +(3364, 0, 0x0, 0x101, ''), -- 3364 +(3363, 0, 0x0, 0x101, ''), -- 3363 +(3368, 0, 0x0, 0x101, ''), -- 3368 +(46708, 0, 0x0, 0x101, ''), -- 46708 +(3369, 0, 0x0, 0x101, ''), -- 3369 +(46709, 0, 0x0, 0x101, ''), -- 46709 +(3315, 0, 0x0, 0x100, ''), -- 3315 +(49737, 0, 0x0, 0x101, ''), -- 49737 +(42506, 0, 0x0, 0x101, ''), -- 42506 +(62194, 0, 0x0, 0x101, ''), -- 62194 +(54472, 0, 0x3000000, 0x1, '101667'), -- 54472 - 101667 +(57801, 0, 0x0, 0x1, ''), -- 57801 +(54473, 0, 0x0, 0x1, ''), -- 54473 +(74228, 0, 0x0, 0x100, ''), -- 74228 +(62198, 0, 0x0, 0x101, ''), -- 62198 +(72559, 0, 0x3, 0x1, '55701'), -- 72559 - 55701 +(28960, 0, 0x0, 0x1, ''), -- 28960 +(25075, 0, 0x0, 0x1, ''), -- 25075 +(24927, 0, 0x0, 0x1, ''), -- 24927 +(44787, 0, 0x0, 0x101, ''), -- 44787 +(44781, 0, 0x0, 0x101, ''), -- 44781 +(3322, 0, 0x0, 0x102, ''), -- 3322 +(3334, 0, 0x0, 0x101, ''), -- 3334 +(3189, 0, 0x1, 0x101, ''), -- 3189 +(89175, 0, 0x0, 0x101, ''), -- 89175 +(15188, 0, 0x0, 0x1, ''), -- 15188 +(44770, 0, 0x0, 0x101, ''), -- 44770 +(44782, 0, 0x0, 0x100, ''), -- 44782 +(3403, 0, 0x1, 0x101, ''), -- 3403 +(44788, 0, 0x0, 0x101, ''), -- 44788 +(44785, 0, 0x0, 0x101, ''), -- 44785 +(44783, 0, 0x0, 0x101, ''), -- 44783 +(5892, 0, 0x0, 0x100, ''), -- 5892 +(72939, 0, 0x0, 0x100, ''), -- 72939 +(13417, 0, 0x0, 0x100, ''), -- 13417 +(3327, 0, 0x0, 0x100, ''), -- 3327 +(3328, 0, 0x0, 0x100, ''), -- 3328 +(47233, 0, 0x0, 0x100, '10022'), -- 47233 - 10022 +(29143, 0, 0x0, 0x101, ''), -- 29143 +(44160, 0, 0x0, 0x1, ''), -- 44160 +(26537, 0, 0x0, 0x1, ''), -- 26537 +(5910, 0, 0x0, 0x101, ''), -- 5910 +(34765, 0, 0x0, 0x1, ''), -- 34765 +(3331, 0, 0x0, 0x101, ''), -- 3331 +(52036, 0, 0x0, 0x1, ''), -- 52036 +(3405, 0, 0x0, 0x101, ''), -- 3405 +(12789, 0, 0x0, 0x100, ''), -- 12789 +(12790, 0, 0x0, 0x101, ''), -- 12790 +(19850, 0, 0x0, 0x101, ''), -- 19850 +(12791, 0, 0x0, 0x102, ''), -- 12791 +(12798, 0, 0x0, 0x101, ''), -- 12798 +(69977, 0, 0x0, 0x0, ''), -- 69977 +(69978, 0, 0x0, 0x0, ''), -- 69978 +(52033, 0, 0x0, 0x1, ''), -- 52033 +(3404, 0, 0x1, 0x101, ''), -- 3404 +(7311, 0, 0x0, 0x101, ''), -- 7311 +(30723, 0, 0x0, 0x101, ''), -- 30723 +(30706, 0, 0x0, 0x101, ''), -- 30706 +(45139, 0, 0x0, 0x101, ''), -- 45139 +(44975, 0, 0x0, 0x101, ''), -- 44975 +(45093, 0, 0x0, 0x101, ''), -- 45093 +(45211, 0, 0x0, 0x1, '75230'), -- 45211 - 75230 +(44978, 0, 0x1, 0x101, ''), -- 44978 +(7565, 0, 0x0, 0x1, ''), -- 7565 +(12793, 0, 0x0, 0x0, ''), -- 12793 +(45094, 0, 0x0, 0x101, ''), -- 45094 +(11814, 0, 0x0, 0x1, ''), -- 11814 +(8404, 0, 0x0, 0x101, ''), -- 8404 +(45137, 0, 0x0, 0x101, '84401'), -- 45137 - 84401 +(45138, 0, 0x0, 0x101, '45104'), -- 45138 - 45104 +(45081, 0, 0x0, 0x101, ''), -- 45081 +(45029, 0, 0x0, 0x101, ''), -- 45029 +(7562, 0, 0x0, 0x1, ''), -- 7562 +(45082, 0, 0x0, 0x101, ''), -- 45082 +(9988, 0, 0x0, 0x101, ''), -- 9988 +(7567, 0, 0x0, 0x1, ''), -- 7567 +(12794, 0, 0x0, 0x0, ''), -- 12794 +(12795, 0, 0x0, 0x0, ''), -- 12795 +(12797, 0, 0x0, 0x101, ''), -- 12797 +(45086, 0, 0x0, 0x101, ''), -- 45086 +(3399, 0, 0x0, 0x101, ''), -- 3399 +(3400, 0, 0x0, 0x101, ''), -- 3400 +(45095, 0, 0x1, 0x101, ''), -- 45095 +(45008, 0, 0x0, 0x101, ''), -- 45008 +(53081, 0, 0x0, 0x1, ''), -- 53081 +(5640, 0, 0x0, 0x101, ''), -- 5640 +(45023, 0, 0x0, 0x102, ''), -- 45023 +(45015, 0, 0x1, 0x100, ''), -- 45015 +(45025, 0, 0x1, 0x1, ''), -- 45025 +(45019, 0, 0x0, 0x101, ''), -- 45019 +(41266, 0, 0x3000000, 0x1, ''), -- 41266 +(45814, 0, 0x0, 0x101, ''), -- 45814 +(63085, 0, 0x0, 0x1, ''), -- 63085 +(45822, 0, 0x0, 0x100, ''), -- 45822 +(63086, 0, 0x0, 0x101, ''), -- 63086 +(45830, 0, 0x0, 0x101, ''), -- 45830 +(45659, 0, 0x0, 0x101, ''), -- 45659 +(46080, 0, 0x0, 0x101, ''), -- 46080 +(46082, 0, 0x0, 0x101, ''), -- 46082 +(45661, 0, 0x0, 0x101, ''), -- 45661 +(45709, 0, 0x0, 0x100, ''), -- 45709 +(46078, 0, 0x0, 0x100, '10022'), -- 46078 - 10022 +(45662, 0, 0x0, 0x101, ''), -- 45662 +(14376, 0, 0x0, 0x101, '18950'), -- 14376 - 18950 +(45566, 0, 0x0, 0x101, ''), -- 45566 +(45827, 0, 0x0, 0x100, ''), -- 45827 +(45780, 0, 0x0, 0x1, ''), -- 45780 +(45714, 0, 0x0, 0x101, ''), -- 45714 +(45720, 0, 0x0, 0x101, ''), -- 45720 +(49773, 0, 0x0, 0x1, ''), -- 49773 +(12796, 14334, 0x0, 0x0, ''), -- 12796 +(45563, 0, 0x0, 0x101, ''), -- 45563 +(30611, 0, 0x0, 0x101, '18950'), -- 30611 - 18950 +(73151, 51048, 0x0, 0x0, ''), -- 73151 +(45558, 0, 0x0, 0x101, ''), -- 45558 +(45717, 0, 0x0, 0x100, ''), -- 45717 +(52170, 0, 0x0, 0x101, ''), -- 52170 +(45567, 0, 0x0, 0x101, ''), -- 45567 +(45549, 0, 0x0, 0x101, ''), -- 45549 +(45548, 0, 0x0, 0x101, ''), -- 45548 +(45789, 0, 0x0, 0x101, ''), -- 45789 +(45559, 0, 0x0, 0x101, ''), -- 45559 +(45553, 0, 0x0, 0x101, ''), -- 45553 +(45713, 0, 0x0, 0x101, ''), -- 45713 +(45830, 0, 0x0, 0x101, '42648'), -- 45830 - 42648 +(45551, 0, 0x0, 0x101, ''), -- 45551 +(46302, 0, 0x0, 0x1, ''), -- 46302 +(45552, 0, 0x0, 0x101, ''), -- 45552 +(45784, 0, 0x0, 0x101, ''), -- 45784 +(45565, 0, 0x0, 0x101, ''), -- 45565 +(45718, 0, 0x0, 0x101, ''), -- 45718 +(62119, 0, 0x0, 0x1, ''), -- 62119 +(46358, 0, 0x0, 0x101, ''), -- 46358 +(53153, 0, 0x0, 0x1, '98404'), -- 53153 - 98404 +(45550, 0, 0x0, 0x101, ''), -- 45550 +(37072, 0, 0x0, 0x101, ''), -- 37072 +(46512, 0, 0x0, 0x100, ''), -- 46512 +(3319, 0, 0x0, 0x100, ''), -- 3319 +(46357, 0, 0x0, 0x101, ''), -- 46357 +(52412, 0, 0x0, 0x1, '96986'), -- 52412 - 96986 +(46359, 0, 0x0, 0x101, ''), -- 46359 +(52818, 0, 0x0, 0x101, ''), -- 52818 +(48510, 0, 0x0, 0x101, ''), -- 48510 +(46754, 0, 0x0, 0x1, ''), -- 46754 +(48513, 0, 0x0, 0x101, ''), -- 48513 +(45544, 0, 0x3, 0x1, ''), -- 45544 +(45546, 0, 0x0, 0x1, ''), -- 45546 +(45544, 0, 0x7, 0x1, ''), -- 45544 +(45540, 0, 0x0, 0x101, ''), -- 45540 +(46755, 0, 0x0, 0x1, ''), -- 46755 +(45545, 0, 0x0, 0x1, ''), -- 45545 +(29929, 0, 0x0, 0x1, ''), -- 29929 +(45347, 0, 0x0, 0x101, ''), -- 45347 +(3314, 0, 0x0, 0x101, ''), -- 3314 +(88543, 0, 0x0, 0x1, '32783'), -- 88543 - 32783 +(58155, 0, 0x0, 0x1, ''), -- 58155 +(35068, 0, 0x0, 0x101, ''), -- 35068 +(46142, 0, 0x0, 0x101, '18950'), -- 46142 - 18950 +(45339, 0, 0x0, 0x101, ''), -- 45339 +(5188, 0, 0x0, 0x100, ''), -- 5188 +(52034, 0, 0x0, 0x1, ''), -- 52034 +(46555, 0, 0x0, 0x1, ''), -- 46555 +(3370, 0, 0x0, 0x101, ''), -- 3370 +(49622, 0, 0x0, 0x101, ''), -- 49622 +(46556, 0, 0x0, 0x1, ''), -- 46556 +(4047, 0, 0x0, 0x101, ''), -- 4047 +(23128, 0, 0x0, 0x101, ''), -- 23128 +(47571, 0, 0x0, 0x100, '10022'), -- 47571 - 10022 +(45337, 0, 0x0, 0x101, ''), -- 45337 +(3144, 0, 0x0, 0x101, ''), -- 3144 +(51195, 0, 0x0, 0x1, ''), -- 51195 +(46572, 0, 0x0, 0x101, ''), -- 46572 +(46140, 0, 0x0, 0x101, ''), -- 46140 +(17098, 0, 0x0, 0x101, ''), -- 17098 +(3312, 0, 0x0, 0x101, ''), -- 3312 +(14375, 0, 0x0, 0x101, '18950'), -- 14375 - 18950 +(27489, 0, 0x0, 0x1, ''), -- 27489 +(74228, 0, 0x3, 0x1, '55701'), -- 74228 - 55701 +(89830, 0, 0x0, 0x1, ''), -- 89830 +(72559, 0, 0x0, 0x100, ''), -- 72559 +(3342, 0, 0x0, 0x101, ''), -- 3342 +(44878, 0, 0x0, 0x101, ''), -- 44878 +(44338, 0, 0x0, 0x1, ''), -- 44338 +(3323, 0, 0x0, 0x101, ''), -- 3323 +(15116, 0, 0x0, 0x1, ''), -- 15116 +(88703, 0, 0x0, 0x101, ''), -- 88703 +(44853, 0, 0x0, 0x101, ''), -- 44853 +(44877, 0, 0x0, 0x101, ''), -- 44877 +(44851, 0, 0x0, 0x101, ''), -- 44851 +(14392, 0, 0x0, 0x101, ''), -- 14392 +(6929, 0, 0x0, 0x101, ''), -- 6929 +(44876, 0, 0x0, 0x101, ''), -- 44876 +(44872, 0, 0x0, 0x101, ''), -- 44872 +(62195, 0, 0x0, 0x101, ''), -- 62195 +(44854, 0, 0x0, 0x101, ''), -- 44854 +(44856, 0, 0x0, 0x101, ''), -- 44856 +(44871, 0, 0x0, 0x101, ''), -- 44871 +(14480, 0, 0x0, 0x1, ''), -- 14480 +(44852, 0, 0x0, 0x101, ''), -- 44852 +(44867, 0, 0x0, 0x101, ''), -- 44867 +(5609, 0, 0x0, 0x101, ''), -- 5609 +(5613, 0, 0x0, 0x101, ''), -- 5613 +(44865, 0, 0x0, 0x101, ''), -- 44865 +(44868, 0, 0x0, 0x101, ''), -- 44868 +(74228, 0, 0x1, 0x100, ''), -- 74228 +(88701, 0, 0x1, 0x101, ''), -- 88701 +(88702, 0, 0x0, 0x101, ''), -- 88702 +(6466, 0, 0x0, 0x1, '162443'), -- 6466 - 162443 +(5606, 0, 0x0, 0x101, ''), -- 5606 +(5610, 0, 0x0, 0x101, ''), -- 5610 +(5611, 0, 0x0, 0x101, ''), -- 5611 +(5614, 0, 0x0, 0x101, ''), -- 5614 +(42637, 0, 0x10000, 0x101, '49414'), -- 42637 - 49414 +(44866, 0, 0x0, 0x101, ''), -- 44866 +(5817, 0, 0x0, 0x101, ''), -- 5817 +(3313, 0, 0x0, 0x101, ''), -- 3313 +(3300, 0, 0x0, 0x1, ''), -- 3300 +(40891, 0, 0x8, 0x101, ''), -- 40891 +(42859, 0, 0x0, 0x1, ''), -- 42859 +(40891, 0, 0x0, 0x101, ''), -- 40891 +(4311, 0, 0x0, 0x101, ''), -- 4311 +(71100, 0, 0x0, 0x1, ''), -- 71100 +(10880, 0, 0x0, 0x101, ''), -- 10880 +(31724, 0, 0x0, 0x1, ''), -- 31724 +(31725, 0, 0x0, 0x1, ''), -- 31725 +(31720, 0, 0x0, 0x1, ''), -- 31720 +(31723, 0, 0x0, 0x1, ''), -- 31723 +(31726, 0, 0x0, 0x1, ''), -- 31726 +(31727, 0, 0x0, 0x1, ''), -- 31727 +(25171, 0, 0x0, 0x1, ''), -- 25171 +(25070, 0, 0x0, 0x0, ''), -- 25070 +(25071, 0, 0x0, 0x1, ''), -- 25071 +(25072, 0, 0x0, 0x1, ''), -- 25072 +(25074, 0, 0x0, 0x1, ''), -- 25074 +(25076, 0, 0x0, 0x1, ''), -- 25076 +(24934, 0, 0x0, 0x1, ''), -- 24934 +(25083, 0, 0x0, 0x0, ''), -- 25083 +(15214, 0, 0x0, 0x1, ''), -- 15214 +(24935, 0, 0x0, 0x1, ''), -- 24935 +(25079, 0, 0x0, 0x0, ''), -- 25079 +(25077, 0, 0x0, 0x0, ''); -- 25077 + +DELETE FROM `npc_vendor` WHERE `entry` IN (68364, 69333, 68794, 49889, 12796, 5812, 45546, 50482, 3356, 3360, 52818, 3361, 3362, 14480, 57922, 3409, 3413, 73151); +INSERT INTO `npc_vendor` (`entry`, `item`, `slot`, `maxcount`, `ExtendedCost`, `Type`) VALUES +-- 68364 +(68364, 118916, 1, 0, 0, 1), -- 118916 +(68364, 118910, 2, 0, 0, 1), -- 118910 +(68364, 118911, 3, 0, 0, 1), -- 118911 +(68364, 118912, 4, 0, 0, 1), -- 118912 +(68364, 118908, 5, 0, 0, 1), -- 118908 +(68364, 122396, 6, 0, 0, 1), -- 122396 +(68364, 98405, 7, 0, 0, 1), -- 98405 +(68364, 93025, 8, 0, 0, 1), -- 93025 +(68364, 118913, 9, 0, 0, 1), -- 118913 +(68364, 118914, 10, 0, 0, 1), -- 118914 +(68364, 118915, 11, 0, 0, 1), -- 118915 +-- 69333 +(69333, 83080, 1, 0, 0, 1), -- 83080 +(69333, 92070, 2, 0, 0, 1), -- 92070 +-- 68794 +(68794, 93043, 1, 0, 0, 1), -- 93043 +(68794, 93044, 2, 0, 0, 1), -- 93044 +(68794, 93045, 3, 0, 0, 1), -- 93045 +(68794, 93158, 4, 0, 0, 1), -- 93158 +-- 49889 +(49889, 61982, 1, 0, 0, 1), -- 61982 +(49889, 61983, 2, 0, 0, 1), -- 61983 +(49889, 61984, 3, 0, 0, 1), -- 61984 +(49889, 61985, 4, 0, 0, 1), -- 61985 +(49889, 61986, 5, 0, 0, 1), -- 61986 +-- 12796 +(12796, 29466, 1, 0, 423, 1), -- 29466 +(12796, 29469, 2, 0, 423, 1), -- 29469 +(12796, 29470, 3, 0, 423, 1), -- 29470 +(12796, 29472, 4, 0, 423, 1), -- 29472 +(12796, 34129, 5, 0, 423, 1), -- 34129 +-- 5812 +(5812, 2392, 1, 0, 0, 1), -- 2392 +(5812, 2393, 2, 0, 0, 1), -- 2393 +(5812, 2394, 3, 0, 0, 1), -- 2394 +(5812, 2395, 4, 0, 0, 1), -- 2395 +(5812, 2396, 5, 0, 0, 1), -- 2396 +(5812, 2397, 6, 0, 0, 1), -- 2397 +(5812, 847, 7, 0, 0, 1), -- 847 +(5812, 1845, 8, 0, 0, 1), -- 1845 +(5812, 848, 9, 0, 0, 1), -- 848 +(5812, 849, 10, 0, 0, 1), -- 849 +(5812, 1846, 11, 0, 0, 1), -- 1846 +(5812, 850, 12, 0, 0, 1), -- 850 +(5812, 2417, 13, 0, 0, 1), -- 2417 +(5812, 2419, 14, 0, 0, 1), -- 2419 +(5812, 2418, 15, 0, 0, 1), -- 2418 +(5812, 2420, 16, 0, 0, 1), -- 2420 +(5812, 2421, 17, 0, 0, 1), -- 2421 +(5812, 2422, 18, 0, 0, 1), -- 2422 +(5812, 3891, 19, 0, 0, 1), -- 3891 +(5812, 17189, 20, 0, 0, 1), -- 17189 +(5812, 2448, 21, 0, 0, 1), -- 2448 +(5812, 2153, 22, 0, 0, 1), -- 2153 +(5812, 2148, 23, 0, 0, 1), -- 2148 +(5812, 2152, 24, 0, 0, 1), -- 2152 +(5812, 2149, 25, 0, 0, 1), -- 2149 +(5812, 2150, 26, 0, 0, 1), -- 2150 +(5812, 2151, 27, 0, 0, 1), -- 2151 +(5812, 17192, 28, 0, 0, 1), -- 17192 +(5812, 2446, 29, 0, 0, 1), -- 2446 +(5812, 285, 30, 0, 0, 1), -- 285 +(5812, 1853, 31, 0, 0, 1), -- 1853 +(5812, 286, 32, 0, 0, 1), -- 286 +(5812, 287, 33, 0, 0, 1), -- 287 +(5812, 1852, 34, 0, 0, 1), -- 1852 +(5812, 718, 35, 0, 0, 1), -- 718 +(5812, 62265, 36, 0, 0, 1), -- 62265 +(5812, 62260, 37, 0, 0, 1), -- 62260 +(5812, 62264, 38, 0, 0, 1), -- 62264 +(5812, 62261, 39, 0, 0, 1), -- 62261 +(5812, 62262, 40, 0, 0, 1), -- 62262 +(5812, 62263, 41, 0, 0, 1), -- 62263 +(5812, 62266, 42, 0, 0, 1), -- 62266 +(5812, 62253, 43, 0, 0, 1), -- 62253 +(5812, 62254, 44, 0, 0, 1), -- 62254 +(5812, 62258, 45, 0, 0, 1), -- 62258 +(5812, 62255, 46, 0, 0, 1), -- 62255 +(5812, 62256, 47, 0, 0, 1), -- 62256 +(5812, 62257, 48, 0, 0, 1), -- 62257 +(5812, 62259, 49, 0, 0, 1), -- 62259 +(5812, 17190, 50, 0, 0, 1), -- 17190 +(5812, 2451, 51, 0, 0, 1), -- 2451 +-- 70751 +-- 45546 +(45546, 59496, 15, 0, 3306, 1), -- 59496 +(45546, 59493, 16, 0, 3307, 1), -- 59493 +(45546, 59491, 17, 0, 3305, 1), -- 59491 +(45546, 59480, 18, 0, 3308, 1), -- 59480 +(45546, 59479, 19, 0, 3311, 1), -- 59479 +(45546, 59478, 20, 0, 3311, 1), -- 59478 +(45546, 59477, 21, 0, 3392, 1), -- 59477 +(45546, 59489, 22, 0, 3310, 1), -- 59489 +(45546, 68660, 23, 0, 989, 1), -- 68660 +(45546, 22729, 807, 1, 0, 1), -- 22729 +(45546, 5956, 808, 0, 0, 1), -- 5956 +(45546, 2901, 809, 0, 0, 1), -- 2901 +(45546, 90146, 810, 0, 0, 1), -- 90146 +(45546, 4399, 811, 0, 0, 1), -- 4399 +(45546, 4400, 812, 0, 0, 1), -- 4400 +(45546, 40533, 813, 0, 0, 1), -- 40533 +(45546, 39684, 814, 0, 0, 1), -- 39684 +(45546, 2880, 815, 0, 0, 1), -- 2880 +(45546, 3466, 816, 0, 0, 1), -- 3466 +(45546, 10647, 817, 0, 0, 1), -- 10647 +(45546, 4382, 818, 1, 0, 1), -- 4382 +(45546, 4357, 819, 3, 0, 1), -- 4357 +(45546, 4364, 820, 2, 0, 1), -- 4364 +(45546, 39354, 821, 0, 0, 1), -- 39354 +-- 50482 +(50482, 20815, 1, 0, 0, 1), -- 20815 +(50482, 52188, 2, 0, 0, 1), -- 52188 +(50482, 52196, 3, 0, 3232, 1), -- 52196 +(50482, 52381, 4, 0, 2972, 1), -- 52381 +(50482, 52449, 5, 0, 2972, 1), -- 52449 +(50482, 52447, 6, 0, 2972, 1), -- 52447 +(50482, 52448, 7, 0, 2972, 1), -- 52448 +(50482, 52459, 8, 0, 2972, 1), -- 52459 +(50482, 52457, 9, 0, 2972, 1), -- 52457 +(50482, 52450, 10, 0, 2972, 1), -- 52450 +(50482, 52458, 11, 0, 2972, 1), -- 52458 +(50482, 52454, 12, 0, 2972, 1), -- 52454 +(50482, 52456, 13, 0, 2972, 1), -- 52456 +(50482, 52451, 14, 0, 2972, 1), -- 52451 +(50482, 52452, 15, 0, 2972, 1), -- 52452 +(50482, 52453, 16, 0, 2972, 1), -- 52453 +(50482, 52455, 17, 0, 2972, 1), -- 52455 +(50482, 52398, 18, 0, 2970, 1), -- 52398 +(50482, 52396, 19, 0, 2970, 1), -- 52396 +(50482, 52397, 20, 0, 2970, 1), -- 52397 +(50482, 52395, 21, 0, 2970, 1), -- 52395 +(50482, 52394, 22, 0, 2970, 1), -- 52394 +(50482, 52409, 23, 0, 2970, 1), -- 52409 +(50482, 52401, 24, 0, 2970, 1), -- 52401 +(50482, 52405, 25, 0, 2970, 1), -- 52405 +(50482, 52408, 26, 0, 2970, 1), -- 52408 +(50482, 52406, 27, 0, 2970, 1), -- 52406 +(50482, 52403, 28, 0, 2970, 1), -- 52403 +(50482, 52407, 29, 0, 2970, 1), -- 52407 +(50482, 52404, 30, 0, 2970, 1), -- 52404 +(50482, 52400, 31, 0, 2970, 1), -- 52400 +(50482, 52399, 32, 0, 2970, 1), -- 52399 +(50482, 52402, 33, 0, 2970, 1), -- 52402 +(50482, 52428, 34, 0, 2970, 1), -- 52428 +(50482, 52425, 35, 0, 2970, 1), -- 52425 +(50482, 52429, 36, 0, 2970, 1), -- 52429 +(50482, 52424, 37, 0, 2970, 1), -- 52424 +(50482, 52426, 38, 0, 2970, 1), -- 52426 +(50482, 52430, 39, 0, 2970, 1), -- 52430 +(50482, 52423, 40, 0, 2970, 1), -- 52423 +(50482, 52432, 41, 0, 2970, 1), -- 52432 +(50482, 52427, 42, 0, 2970, 1), -- 52427 +(50482, 68742, 43, 0, 2970, 1), -- 68742 +(50482, 52431, 44, 0, 2970, 1), -- 52431 +(50482, 52419, 45, 0, 2970, 1), -- 52419 +(50482, 52421, 46, 0, 2970, 1), -- 52421 +(50482, 52417, 47, 0, 2970, 1), -- 52417 +(50482, 52413, 48, 0, 2970, 1), -- 52413 +(50482, 52416, 49, 0, 2970, 1), -- 52416 +(50482, 52415, 50, 0, 2970, 1), -- 52415 +(50482, 52420, 51, 0, 2970, 1), -- 52420 +(50482, 52412, 52, 0, 2970, 1), -- 52412 +(50482, 52422, 53, 0, 2970, 1), -- 52422 +(50482, 68360, 54, 0, 2970, 1), -- 68360 +(50482, 52410, 55, 0, 2970, 1), -- 52410 +(50482, 52414, 56, 0, 2970, 1), -- 52414 +(50482, 52418, 57, 0, 2970, 1), -- 52418 +(50482, 52411, 58, 0, 2970, 1), -- 52411 +(50482, 68361, 59, 0, 2970, 1), -- 68361 +(50482, 68359, 60, 0, 2970, 1), -- 68359 +(50482, 52362, 61, 0, 2970, 1), -- 52362 +(50482, 52387, 62, 0, 2970, 1), -- 52387 +(50482, 52380, 63, 0, 2970, 1), -- 52380 +(50482, 52384, 64, 0, 2970, 1), -- 52384 +(50482, 52389, 65, 0, 2970, 1), -- 52389 +(50482, 52393, 66, 0, 2970, 1), -- 52393 +(50482, 52390, 67, 0, 2970, 1), -- 52390 +(50482, 52391, 68, 0, 2970, 1), -- 52391 +(50482, 52392, 69, 0, 2970, 1), -- 52392 +(50482, 52437, 70, 0, 2971, 1), -- 52437 +(50482, 52435, 71, 0, 2971, 1), -- 52435 +(50482, 52434, 72, 0, 2971, 1), -- 52434 +(50482, 52441, 73, 0, 2971, 1), -- 52441 +(50482, 52438, 74, 0, 2971, 1), -- 52438 +(50482, 52439, 75, 0, 2971, 1), -- 52439 +(50482, 52443, 76, 0, 2971, 1), -- 52443 +(50482, 52436, 77, 0, 2971, 1), -- 52436 +(50482, 52433, 78, 0, 2971, 1), -- 52433 +(50482, 52445, 79, 0, 2971, 1), -- 52445 +(50482, 52444, 80, 0, 2971, 1), -- 52444 +(50482, 52442, 81, 0, 2971, 1), -- 52442 +(50482, 52440, 82, 0, 2971, 1), -- 52440 +(50482, 69853, 83, 0, 2973, 1), -- 69853 +(50482, 52460, 84, 0, 2973, 1), -- 52460 +(50482, 52461, 85, 0, 2973, 1), -- 52461 +(50482, 52463, 86, 0, 2973, 1), -- 52463 +(50482, 52462, 87, 0, 2973, 1), -- 52462 +(50482, 52467, 88, 0, 2973, 1), -- 52467 +(50482, 52465, 89, 0, 2973, 1), -- 52465 +(50482, 52464, 90, 0, 2973, 1), -- 52464 +(50482, 52466, 91, 0, 2973, 1), -- 52466 +-- 3356 +(3356, 2901, 1, 0, 0, 1), -- 2901 +(3356, 5956, 2, 0, 0, 1), -- 5956 +(3356, 2880, 3, 0, 0, 1), -- 2880 +(3356, 3466, 4, 0, 0, 1), -- 3466 +(3356, 18567, 5, 0, 0, 1), -- 18567 +(3356, 3857, 6, 0, 0, 1), -- 3857 +(3356, 66117, 7, 0, 3312, 1), -- 66117 +(3356, 66118, 8, 0, 3312, 1), -- 66118 +(3356, 66125, 9, 0, 3312, 1), -- 66125 +(3356, 66126, 10, 0, 3312, 1), -- 66126 +(3356, 66103, 11, 0, 3312, 1), -- 66103 +(3356, 66119, 12, 0, 3312, 1), -- 66119 +(3356, 66107, 13, 0, 3312, 1), -- 66107 +(3356, 66105, 14, 0, 3312, 1), -- 66105 +(3356, 66109, 15, 0, 3312, 1), -- 66109 +(3356, 66127, 16, 0, 3312, 1), -- 66127 +(3356, 66120, 17, 0, 3313, 1), -- 66120 +(3356, 67603, 18, 0, 3313, 1), -- 67603 +(3356, 67606, 19, 0, 3314, 1), -- 67606 +(3356, 66113, 20, 0, 3313, 1), -- 66113 +(3356, 66106, 21, 0, 3313, 1), -- 66106 +(3356, 66111, 22, 0, 3313, 1), -- 66111 +(3356, 66104, 23, 0, 3313, 1), -- 66104 +(3356, 66108, 24, 0, 3313, 1), -- 66108 +(3356, 66128, 25, 0, 3313, 1), -- 66128 +(3356, 66121, 26, 0, 3313, 1), -- 66121 +(3356, 66115, 27, 0, 3313, 1), -- 66115 +(3356, 66112, 28, 0, 3313, 1), -- 66112 +(3356, 66114, 29, 0, 3313, 1), -- 66114 +(3356, 66110, 30, 0, 3313, 1), -- 66110 +(3356, 66116, 31, 0, 3313, 1), -- 66116 +(3356, 66129, 32, 0, 3313, 1), -- 66129 +(3356, 66124, 33, 0, 3314, 1), -- 66124 +(3356, 66123, 34, 0, 3314, 1), -- 66123 +(3356, 66122, 35, 0, 3314, 1), -- 66122 +(3356, 66100, 36, 0, 3314, 1), -- 66100 +(3356, 66132, 37, 0, 3314, 1), -- 66132 +(3356, 66131, 38, 0, 3314, 1), -- 66131 +(3356, 66130, 39, 0, 3314, 1), -- 66130 +(3356, 66101, 40, 0, 3314, 1), -- 66101 +(3356, 12162, 110, 1, 0, 1), -- 12162 +-- 3360 +(3360, 852, 1, 0, 0, 1), -- 852 +(3360, 1197, 2, 0, 0, 1), -- 1197 +(3360, 854, 3, 0, 0, 1), -- 854 +(3360, 2030, 4, 0, 0, 1), -- 2030 +(3360, 2028, 5, 0, 0, 1), -- 2028 +(3360, 2026, 6, 0, 0, 1), -- 2026 +(3360, 925, 7, 0, 0, 1), -- 925 +(3360, 928, 8, 0, 0, 1), -- 928 +(3360, 924, 9, 0, 0, 1), -- 924 +-- 52818 +(52818, 69243, 1, 0, 0, 1), -- 69243 +(52818, 69244, 2, 0, 0, 1), -- 69244 +(52818, 33234, 3, 0, 0, 1), -- 33234 +-- 3361 +(3361, 851, 1, 0, 0, 1), -- 851 +(3361, 1198, 2, 0, 0, 1), -- 1198 +(3361, 2207, 3, 0, 0, 1), -- 2207 +(3361, 2027, 4, 0, 0, 1), -- 2027 +(3361, 2208, 5, 0, 0, 1), -- 2208 +(3361, 2024, 6, 0, 0, 1), -- 2024 +(3361, 2209, 7, 0, 0, 1), -- 2209 +(3361, 922, 8, 0, 0, 1), -- 922 +(3361, 923, 9, 0, 0, 1), -- 923 +(3361, 2520, 10, 0, 0, 1), -- 2520 +(3361, 2528, 11, 0, 0, 1), -- 2528 +(3361, 2526, 12, 0, 0, 1), -- 2526 +(3361, 2534, 13, 0, 0, 1), -- 2534 +(3361, 15905, 14, 0, 0, 1), -- 15905 +(3361, 15903, 15, 0, 0, 1), -- 15903 +(3361, 15904, 16, 0, 0, 1), -- 15904 +-- 3362 +(3362, 1132, 1, 0, 0, 1), -- 1132 +(3362, 5665, 2, 0, 0, 1), -- 5665 +(3362, 5668, 3, 0, 0, 1), -- 5668 +(3362, 46099, 4, 0, 0, 1), -- 46099 +(3362, 18796, 5, 0, 0, 1), -- 18796 +(3362, 18798, 6, 0, 0, 1), -- 18798 +(3362, 18797, 7, 0, 0, 1), -- 18797 +-- 14480 +(14480, 18635, 1, 0, 0, 1), -- 18635 +(14480, 7228, 2, 0, 0, 1), -- 7228 +(14480, 18632, 3, 0, 0, 1), -- 18632 +(14480, 18633, 4, 0, 0, 1), -- 18633 +-- 57922 +(57922, 71949, 1, 0, 2971, 1), -- 71949 +(57922, 71943, 2, 0, 2973, 1), -- 71943 +(57922, 71941, 3, 0, 2973, 1), -- 71941 +(57922, 71939, 4, 0, 2973, 1), -- 71939 +(57922, 71942, 5, 0, 2973, 1), -- 71942 +(57922, 71940, 6, 0, 2973, 1), -- 71940 +(57922, 71917, 7, 0, 2973, 1), -- 71917 +(57922, 71919, 8, 0, 2973, 1), -- 71919 +(57922, 71912, 9, 0, 2973, 1), -- 71912 +(57922, 71906, 10, 0, 2973, 1), -- 71906 +(57922, 71905, 11, 0, 2973, 1), -- 71905 +(57922, 71913, 12, 0, 2973, 1), -- 71913 +(57922, 71916, 13, 0, 2973, 1), -- 71916 +(57922, 71920, 14, 0, 2973, 1), -- 71920 +(57922, 71908, 15, 0, 2973, 1), -- 71908 +(57922, 71918, 16, 0, 2973, 1), -- 71918 +(57922, 71922, 17, 0, 2973, 1), -- 71922 +(57922, 71909, 18, 0, 2973, 1), -- 71909 +(57922, 71907, 19, 0, 2973, 1), -- 71907 +(57922, 71915, 20, 0, 2973, 1), -- 71915 +(57922, 71910, 21, 0, 2973, 1), -- 71910 +(57922, 71926, 22, 0, 2973, 1), -- 71926 +(57922, 71921, 23, 0, 2973, 1), -- 71921 +(57922, 71925, 24, 0, 2973, 1), -- 71925 +(57922, 71911, 25, 0, 2973, 1), -- 71911 +(57922, 71923, 26, 0, 2973, 1), -- 71923 +(57922, 71914, 27, 0, 2973, 1), -- 71914 +(57922, 71924, 28, 0, 2973, 1), -- 71924 +(57922, 71928, 29, 0, 2973, 1), -- 71928 +(57922, 71937, 30, 0, 2973, 1), -- 71937 +(57922, 71931, 31, 0, 2973, 1), -- 71931 +(57922, 71927, 32, 0, 2973, 1), -- 71927 +(57922, 71935, 33, 0, 2973, 1), -- 71935 +(57922, 71932, 34, 0, 2973, 1), -- 71932 +(57922, 71933, 35, 0, 2973, 1), -- 71933 +(57922, 71930, 36, 0, 2973, 1), -- 71930 +(57922, 71934, 37, 0, 2973, 1), -- 71934 +(57922, 71938, 38, 0, 2973, 1), -- 71938 +(57922, 71936, 39, 0, 2973, 1), -- 71936 +(57922, 71929, 40, 0, 2973, 1), -- 71929 +(57922, 71947, 41, 0, 2973, 1), -- 71947 +(57922, 71948, 42, 0, 2973, 1), -- 71948 +(57922, 71946, 43, 0, 2973, 1), -- 71946 +(57922, 71944, 44, 0, 2973, 1), -- 71944 +(57922, 71945, 45, 0, 2973, 1), -- 71945 +(57922, 71821, 46, 0, 2973, 1), -- 71821 +(57922, 71886, 47, 0, 2973, 1), -- 71886 +(57922, 71885, 48, 0, 2973, 1), -- 71885 +(57922, 71884, 49, 0, 2973, 1), -- 71884 +(57922, 71893, 50, 0, 2973, 1), -- 71893 +(57922, 71898, 51, 0, 2973, 1), -- 71898 +(57922, 71901, 52, 0, 2973, 1), -- 71901 +(57922, 71891, 53, 0, 2973, 1), -- 71891 +(57922, 71899, 54, 0, 2973, 1), -- 71899 +(57922, 71889, 55, 0, 2973, 1), -- 71889 +(57922, 71887, 56, 0, 2973, 1), -- 71887 +(57922, 71902, 57, 0, 2973, 1), -- 71902 +(57922, 71888, 58, 0, 2973, 1), -- 71888 +(57922, 71903, 59, 0, 2973, 1), -- 71903 +(57922, 71896, 60, 0, 2973, 1), -- 71896 +(57922, 71900, 61, 0, 2973, 1), -- 71900 +(57922, 71890, 62, 0, 2973, 1), -- 71890 +(57922, 71897, 63, 0, 2973, 1), -- 71897 +(57922, 71904, 64, 0, 2973, 1), -- 71904 +(57922, 71895, 65, 0, 2973, 1), -- 71895 +(57922, 71894, 66, 0, 2973, 1), -- 71894 +(57922, 71892, 67, 0, 2973, 1), -- 71892 +-- 3409 +(3409, 853, 1, 0, 0, 1), -- 853 +(3409, 2029, 2, 0, 0, 1), -- 2029 +(3409, 927, 3, 0, 0, 1), -- 927 +(3409, 1196, 4, 0, 0, 1), -- 1196 +(3409, 2025, 5, 0, 0, 1), -- 2025 +(3409, 926, 6, 0, 0, 1), -- 926 +(3409, 2507, 7, 0, 0, 1), -- 2507 +(3409, 3026, 8, 0, 0, 1), -- 3026 +(3409, 2495, 9, 0, 0, 1), -- 2495 +(3409, 854, 10, 0, 0, 1), -- 854 +(3409, 2030, 11, 0, 0, 1), -- 2030 +(3409, 928, 12, 0, 0, 1), -- 928 +-- 3413 +(3413, 59496, 15, 0, 3306, 1), -- 59496 +(3413, 59493, 16, 0, 3307, 1), -- 59493 +(3413, 59491, 17, 0, 3305, 1), -- 59491 +(3413, 59480, 18, 0, 3308, 1), -- 59480 +(3413, 59479, 19, 0, 3311, 1), -- 59479 +(3413, 59478, 20, 0, 3311, 1), -- 59478 +(3413, 59477, 21, 0, 3392, 1), -- 59477 +(3413, 59489, 22, 0, 3310, 1), -- 59489 +(3413, 68660, 23, 0, 989, 1), -- 68660 +(3413, 5956, 819, 0, 0, 1), -- 5956 +(3413, 2901, 820, 0, 0, 1), -- 2901 +(3413, 90146, 821, 0, 0, 1), -- 90146 +(3413, 4399, 822, 0, 0, 1), -- 4399 +(3413, 4400, 823, 0, 0, 1), -- 4400 +(3413, 40533, 824, 0, 0, 1), -- 40533 +(3413, 39684, 825, 0, 0, 1), -- 39684 +(3413, 2880, 826, 0, 0, 1), -- 2880 +(3413, 3466, 827, 0, 0, 1), -- 3466 +(3413, 10647, 828, 0, 0, 1), -- 10647 +(3413, 4357, 829, 4, 0, 1), -- 4357 +(3413, 4364, 830, 4, 0, 1), -- 4364 +(3413, 39354, 831, 0, 0, 1), -- 39354 +(3413, 18647, 835, 1, 0, 1), -- 18647 +(3413, 22729, 836, 1, 0, 1), -- 22729 +-- 73151 +(73151, 70910, 1, 0, 5214, 1), -- 70910 +(73151, 102533, 2, 0, 5214, 1), -- 102533 +(73151, 116778, 3, 0, 5214, 1); -- 116778 + + +DELETE FROM `creature_equip_template` WHERE `entry` IN (3351, 3352, 3353, 3354, 3355, 3356, 11176, 3357, 11177, 3358, 11178, 3360, 3361, 3362, 3363, 13417, 3366, 3367, 45814, 4485, 3368, 3369, 3370, 5606, 5609, 5610, 45822, 5611, 5613, 5614, 45827, 45830, 44723, 44725, 44726, 3399, 3400, 3403, 3404, 5639, 3405, 44735, 5640, 50323, 3409, 44740, 42506, 3412, 3413, 44743, 58155, 69333, 44770, 44779, 44780, 44781, 44782, 44785, 58193, 7951, 34765, 44851, 23635, 42637, 44871, 44872, 44876, 44877, 44878, 42650, 37072, 50477, 10266, 50488, 42672, 5811, 6929, 68364, 5812, 5816, 5817, 44919, 46078, 46080, 6986, 4752, 46082, 6987, 5875, 44975, 5892, 7010, 47233, 5910, 45008, 34955, 47246, 47247, 72939, 47248, 45015, 47253, 45019, 45023, 46142, 45029, 46181, 7088, 45081, 45086, 47321, 45093, 45094, 45095, 70790, 47335, 47336, 49573, 16076, 13842, 35068, 31720, 31723, 31724, 31725, 31726, 31727, 30611, 45137, 88701, 45138, 88702, 35086, 45139, 88703, 88704, 88705, 88706, 89830, 49622, 25070, 25071, 25072, 25074, 12789, 25077, 12790, 12791, 25079, 12793, 74228, 12794, 12795, 25083, 12796, 12797, 12798, 7230, 7231, 73151, 30706, 45230, 46357, 46358, 46359, 45244, 53081, 8404, 49737, 15116, 44158, 49750, 7311, 2855, 2857, 9564, 11814, 52032, 45337, 47571, 45339, 45347, 4043, 4047, 5188, 69977, 69978, 71100, 35364, 49889, 47663, 8576, 46555, 62193, 46556, 62194, 62195, 62196, 62197, 72254, 23128, 52170, 43239, 86832, 46622, 57801, 8659, 46642, 26537, 47764, 47767, 54472, 54473, 47771, 45540, 45545, 45546, 45548, 45549, 46667, 45551, 45552, 45553, 47788, 45558, 6466, 45563, 45565, 45566, 3144, 46708, 46709, 46716, 46741, 46742, 3189, 4311, 11017, 12136, 14375, 14376, 14377, 3216, 14392, 11046, 11066, 45709, 45713, 45714, 45717, 45718, 45720, 9988, 3296, 72559, 3310, 3312, 3313, 3314, 3315, 51346, 7790, 3322, 3323, 7792, 7793, 3327, 3328, 14498, 3329, 3330, 3331, 3332, 3333, 3334, 3335, 3342, 3345, 3347, 3348, 3350); +INSERT INTO `creature_equip_template` (`CreatureID`, `itemID1`, `itemID2`, `itemID3`) VALUES +(3351, 2717, 0, 0), -- 3351 +(3352, 17383, 0, 5262), -- 3352 +(3353, 10612, 10611, 0), -- 3353 +(3354, 1983, 0, 0), -- 3354 +(3355, 1903, 0, 0), -- 3355 +(3356, 1903, 13611, 0), -- 3356 +(11176, 5532, 0, 0), -- 11176 +(3357, 1910, 0, 0), -- 3357 +(11177, 5491, 0, 0), -- 11177 +(3358, 2714, 0, 0), -- 3358 +(11178, 1903, 0, 0), -- 11178 +(3360, 3361, 0, 0), -- 3360 +(3361, 1897, 0, 0), -- 3361 +(3362, 2147, 0, 0), -- 3362 +(3363, 1908, 0, 0), -- 3363 +(13417, 2558, 0, 0), -- 13417 +(3366, 3699, 0, 0), -- 3366 +(3367, 2197, 0, 0), -- 3367 +(45814, 61337, 0, 50150), -- 45814 +(4485, 2183, 2183, 0), -- 4485 +(3368, 2827, 2196, 0), -- 3368 +(3369, 0, 12745, 0), -- 3369 +(3370, 5303, 0, 0), -- 3370 +(5606, 2703, 0, 0), -- 5606 +(5609, 2703, 0, 0), -- 5609 +(5610, 2703, 0, 0), -- 5610 +(45822, 61337, 0, 50150), -- 45822 +(5611, 0, 0, 2551), -- 5611 +(5613, 2703, 0, 0), -- 5613 +(5614, 2716, 0, 0), -- 5614 +(45827, 5289, 0, 5260), -- 45827 +(45830, 1117, 0, 0), -- 45830 +(44723, 10611, 7120, 0), -- 44723 +(44725, 31266, 0, 0), -- 44725 +(44726, 13337, 0, 0), -- 44726 +(3399, 2827, 0, 0), -- 3399 +(3400, 3351, 0, 0), -- 3400 +(3403, 5300, 0, 0), -- 3403 +(3404, 6233, 0, 0), -- 3404 +(5639, 5277, 0, 0), -- 5639 +(3405, 3696, 0, 0), -- 3405 +(44735, 14836, 0, 0), -- 44735 +(5640, 2711, 0, 0), -- 5640 +(50323, 17112, 17112, 0), -- 50323 +(3409, 1909, 0, 0), -- 3409 +(44740, 45203, 0, 0), -- 44740 +(42506, 2827, 0, 0), -- 42506 +(3412, 4994, 0, 0), -- 3412 +(3413, 1911, 0, 0), -- 3413 +(44743, 15424, 0, 45210), -- 44743 +(58155, 17462, 0, 0), -- 58155 +(69333, 89988, 0, 0), -- 69333 +(44770, 12744, 12745, 0), -- 44770 +(44779, 12854, 0, 0), -- 44779 +(44780, 1910, 12870, 0), -- 44780 +(44781, 1903, 0, 0), -- 44781 +(44782, 2711, 0, 0), -- 44782 +(44785, 3362, 0, 0), -- 44785 +(58193, 73423, 0, 0), -- 58193 +(7951, 20468, 0, 0), -- 7951 +(34765, 4994, 0, 0), -- 34765 +(44851, 3346, 0, 0), -- 44851 +(23635, 4994, 0, 0), -- 23635 +(42637, 57034, 0, 0), -- 42637 +(44871, 5289, 0, 5260), -- 44871 +(44872, 5289, 0, 5260), -- 44872 +(44876, 5289, 0, 5260), -- 44876 +(44877, 5289, 0, 5260), -- 44877 +(44878, 5289, 0, 5260), -- 44878 +(42650, 1902, 0, 0), -- 42650 +(37072, 2182, 0, 0), -- 37072 +(50477, 33982, 33980, 0), -- 50477 +(10266, 5532, 0, 0), -- 10266 +(50488, 17383, 0, 0), -- 50488 +(42672, 3774, 0, 0), -- 42672 +(5811, 2184, 0, 0), -- 5811 +(6929, 6334, 0, 0), -- 6929 +(68364, 30732, 0, 0), -- 68364 +(5812, 1903, 0, 0), -- 5812 +(5816, 0, 0, 6231), -- 5816 +(5817, 1910, 0, 0), -- 5817 +(44919, 3433, 0, 0), -- 44919 +(46078, 3364, 12332, 0), -- 46078 +(46080, 12862, 0, 0), -- 46080 +(6986, 1911, 0, 0), -- 6986 +(4752, 10611, 0, 0), -- 4752 +(46082, 31824, 0, 0), -- 46082 +(6987, 1903, 0, 0), -- 6987 +(5875, 12864, 0, 0), -- 5875 +(44975, 1117, 0, 0), -- 44975 +(5892, 5291, 0, 0), -- 5892 +(7010, 5303, 0, 0), -- 7010 +(47233, 1900, 5281, 0), -- 47233 +(5910, 12329, 0, 0), -- 5910 +(45008, 6225, 13854, 0), -- 45008 +(34955, 47034, 0, 0), -- 34955 +(47246, 12868, 0, 0), -- 47246 +(47247, 12742, 0, 0), -- 47247 +(72939, 3361, 0, 0), -- 72939 +(47248, 12751, 0, 0), -- 47248 +(45015, 13631, 0, 0), -- 45015 +(47253, 14873, 0, 0), -- 47253 +(45019, 60822, 60822, 0), -- 45019 +(45023, 3433, 0, 19993), -- 45023 +(46142, 5286, 0, 2551), -- 46142 +(45029, 9482, 0, 0), -- 45029 +(46181, 13709, 0, 0), -- 46181 +(7088, 5278, 0, 0), -- 7088 +(45081, 25622, 0, 0), -- 45081 +(45086, 2703, 0, 0), -- 45086 +(47321, 17282, 0, 0), -- 47321 +(45093, 1910, 12870, 0), -- 45093 +(45094, 12854, 0, 0), -- 45094 +(45095, 17123, 17123, 0), -- 45095 +(70790, 42759, 0, 0), -- 70790 +(47335, 42222, 42224, 0), -- 47335 +(47336, 42222, 42224, 0), -- 47336 +(49573, 46983, 0, 0), -- 49573 +(16076, 20468, 0, 0), -- 16076 +(13842, 13339, 0, 0), -- 13842 +(35068, 11383, 0, 0), -- 35068 +(31720, 31824, 0, 0), -- 31720 +(31723, 31824, 0, 0), -- 31723 +(31724, 31824, 0, 0), -- 31724 +(31725, 3364, 0, 0), -- 31725 +(31726, 5289, 0, 5258), -- 31726 +(31727, 5289, 0, 5258), -- 31727 +(30611, 5289, 0, 2507), -- 30611 +(45137, 56157, 0, 0), -- 45137 +(88701, 5287, 0, 0), -- 88701 +(45138, 4993, 0, 0), -- 45138 +(88702, 2704, 0, 0), -- 88702 +(35086, 4994, 0, 0), -- 35086 +(45139, 14873, 0, 0), -- 45139 +(88703, 5289, 0, 5260), -- 88703 +(88704, 5277, 0, 0), -- 88704 +(88705, 5277, 0, 0), -- 88705 +(88706, 5304, 0, 0), -- 88706 +(89830, 33161, 0, 0), -- 89830 +(49622, 1908, 0, 0), -- 49622 +(25070, 1897, 0, 0), -- 25070 +(25071, 1903, 0, 0), -- 25071 +(25072, 1911, 0, 0), -- 25072 +(25074, 31824, 0, 0), -- 25074 +(12789, 13631, 0, 0), -- 12789 +(25077, 3364, 0, 0), -- 25077 +(12790, 13612, 0, 0), -- 12790 +(12791, 0, 0, 16582), -- 12791 +(25079, 1905, 0, 2552), -- 25079 +(12793, 6680, 0, 0), -- 12793 +(74228, 13631, 0, 5870), -- 74228 +(12794, 21580, 0, 0), -- 12794 +(12795, 12786, 0, 0), -- 12795 +(25083, 1905, 0, 2552), -- 25083 +(12796, 10611, 0, 0), -- 12796 +(12797, 12403, 0, 0), -- 12797 +(12798, 12403, 0, 0), -- 12798 +(7230, 2182, 0, 0), -- 7230 +(7231, 1903, 0, 0), -- 7231 +(73151, 100541, 0, 0), -- 73151 +(30706, 12862, 0, 0), -- 30706 +(45230, 12754, 0, 14642), -- 45230 +(46357, 1910, 0, 0), -- 46357 +(46358, 3346, 0, 0), -- 46358 +(46359, 1903, 13604, 0), -- 46359 +(45244, 39749, 0, 0), -- 45244 +(53081, 31801, 0, 0), -- 53081 +(8404, 1906, 0, 0), -- 8404 +(49737, 0, 13407, 0), -- 49737 +(15116, 12850, 0, 0), -- 15116 +(44158, 1902, 0, 0), -- 44158 +(49750, 1906, 0, 0), -- 49750 +(7311, 12328, 0, 0), -- 7311 +(2855, 0, 12745, 0), -- 2855 +(2857, 31824, 0, 0), -- 2857 +(9564, 4994, 0, 0), -- 9564 +(11814, 10611, 0, 0), -- 11814 +(52032, 2199, 13341, 0), -- 52032 +(45337, 12421, 0, 0), -- 45337 +(47571, 24324, 24324, 0), -- 47571 +(45339, 13709, 0, 0), -- 45339 +(45347, 1907, 0, 0), -- 45347 +(4043, 1903, 0, 0), -- 4043 +(4047, 5304, 0, 0), -- 4047 +(5188, 5284, 0, 0), -- 5188 +(69977, 37123, 0, 0), -- 69977 +(69978, 14824, 0, 0), -- 69978 +(71100, 31824, 0, 0), -- 71100 +(35364, 47844, 47846, 0), -- 35364 +(49889, 64433, 0, 0), -- 49889 +(47663, 10612, 0, 2507), -- 47663 +(8576, 10611, 10611, 0), -- 8576 +(46555, 17383, 0, 0), -- 46555 +(62193, 1117, 0, 0), -- 62193 +(46556, 49671, 49671, 0), -- 46556 +(62194, 76711, 73203, 0), -- 62194 +(62195, 73893, 0, 0), -- 62195 +(62196, 2177, 0, 0), -- 62196 +(62197, 0, 0, 30128), -- 62197 +(72254, 96906, 96910, 0), -- 72254 +(23128, 29403, 27406, 0), -- 23128 +(52170, 1903, 0, 0), -- 52170 +(43239, 1117, 0, 0), -- 43239 +(86832, 14085, 0, 14118), -- 86832 +(46622, 3346, 0, 0), -- 46622 +(57801, 71732, 0, 0), -- 57801 +(8659, 2711, 10619, 0), -- 8659 +(46642, 2703, 13859, 0), -- 46642 +(26537, 4994, 0, 0), -- 26537 +(47764, 1908, 0, 0), -- 47764 +(47767, 3433, 0, 0), -- 47767 +(54472, 0, 71736, 0), -- 54472 +(54473, 71739, 71741, 0), -- 54473 +(47771, 6680, 0, 0), -- 47771 +(45540, 2827, 0, 0), -- 45540 +(45545, 1911, 0, 0), -- 45545 +(45546, 31824, 3774, 0), -- 45546 +(45548, 1903, 0, 0), -- 45548 +(45549, 1903, 13611, 0), -- 45549 +(46667, 10613, 62373, 0), -- 46667 +(45551, 3351, 0, 0), -- 45551 +(45552, 1910, 12851, 0), -- 45552 +(45553, 12854, 12855, 0), -- 45553 +(47788, 3433, 0, 0), -- 47788 +(45558, 3696, 0, 0), -- 45558 +(6466, 63252, 0, 0), -- 6466 +(45563, 2197, 13855, 0), -- 45563 +(45565, 2703, 13859, 0), -- 45565 +(45566, 2703, 13859, 0), -- 45566 +(3144, 10612, 0, 0), -- 3144 +(46708, 3351, 2197, 0), -- 46708 +(46709, 2196, 0, 0), -- 46709 +(46716, 12862, 0, 0), -- 46716 +(46741, 6233, 0, 0), -- 46741 +(46742, 6233, 0, 0), -- 46742 +(3189, 2023, 0, 0), -- 3189 +(4311, 5288, 0, 0), -- 4311 +(11017, 1903, 0, 0), -- 11017 +(12136, 4994, 0, 0), -- 12136 +(14375, 10612, 0, 2507), -- 14375 +(14376, 10612, 0, 2507), -- 14376 +(14377, 10612, 0, 2507), -- 14377 +(3216, 2559, 0, 0), -- 3216 +(14392, 34058, 0, 0), -- 14392 +(11046, 3699, 3697, 0), -- 11046 +(11066, 0, 12860, 0), -- 11066 +(45709, 12901, 0, 0), -- 45709 +(45713, 1117, 0, 21554), -- 45713 +(45714, 2030, 0, 0), -- 45714 +(45717, 2711, 2711, 0), -- 45717 +(45718, 15274, 0, 0), -- 45718 +(45720, 52009, 0, 0), -- 45720 +(9988, 1908, 0, 0), -- 9988 +(3296, 5289, 0, 2507), -- 3296 +(72559, 33609, 12454, 49462), -- 72559 +(3310, 3433, 0, 0), -- 3310 +(3312, 2827, 2196, 2551), -- 3312 +(3313, 12850, 12745, 0), -- 3313 +(3314, 10611, 0, 0), -- 3314 +(3315, 1896, 0, 0), -- 3315 +(51346, 5289, 0, 2507), -- 51346 +(7790, 1903, 0, 0), -- 7790 +(3322, 0, 0, 2552), -- 3322 +(3323, 2200, 0, 0), -- 3323 +(7792, 2182, 0, 0), -- 7792 +(7793, 5491, 0, 0), -- 7793 +(3327, 2184, 0, 0), -- 3327 +(3328, 5278, 0, 0), -- 3328 +(14498, 12751, 0, 0), -- 14498 +(3329, 3346, 0, 0), -- 3329 +(3330, 5304, 0, 0), -- 3330 +(3331, 2179, 2711, 0), -- 3331 +(3332, 1117, 0, 0), -- 3332 +(3333, 1117, 0, 0), -- 3333 +(3334, 2199, 34717, 0), -- 3334 +(3335, 2199, 0, 0), -- 3335 +(3342, 12329, 0, 0), -- 3342 +(3345, 12746, 0, 6230), -- 3345 +(3347, 3699, 3697, 0), -- 3347 +(3348, 0, 3698, 0), -- 3348 +(3350, 1906, 12745, 0); -- 3350 + +-- In addition to cleaning up the above code style, I have inserted the table column names below, since it was missing in the OP's SQL. +-- Notice that the values don't match the table columns (or is the documentation page http://collab.kpsn.org/display/tc/World only for the 3.3.5 DB?) +INSERT INTO `areatrigger_teleport` VALUES +(7999, 4139, 'Ring of Valor - Entrance Target'), +(8001, 4140, 'Ring of Valor - Exit Target'); + +UPDATE `creature_template` SET `npcflag`=128 WHERE `entry` IN (68794,49889,68364); |