aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/master/2018_01_06_01_world.sql1345
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);