Schergrat - Githubissues

#!sql

-- https://github.com/Looking4Group/L4G_Core/issues/603
-- Blade's Edge Mountains
-- ======================================================
-- Texts & Scripts
-- ======================================================
--
-- texts 
-- 
DELETE FROM `creature_ai_texts` WHERE `entry` BETWEEN -9910 AND -9900;
INSERT INTO `creature_ai_texts` VALUES
('-9910','Me angered. Raaah!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','Schergrat Ogres on Aggro'),
('-9909','Me smash! You die!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','Schergrat Ogres on Aggro'),
('-9908','Now, proceed to the translocator. Forge Camp Wrath awaits your arrival!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','19747 OCC Summon Event'),
('-9907','You will suffer slowly until the end of time for this affront!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','1','0','0','19747 Yell on Aggro'),
('-9906','Prepare yourself for eternal torture, mortal!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','1','0','0','19747 Yell on Aggro'),
('-9905','I shall enjoy the smell of the grease from your marrow crackling over the fire!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','1','0','0','19747 Yell on Aggro'),
('-9904','Release the hounds!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','1','0','0','19747 IC Summon Event'),
('-9903','Your name is as insignificant to me as the names of the thousands who have died under the might of Goc. I will crush you and $N!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','20555 on Aggro'),
('-9902','Me mad. You get smash in face!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','19948 on Aggro'),
('-9901','As I shall consume your flesh, so too shall the Burning Legion consume your people!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','1','0','0','23355 Yell on Aggro');
-- ('-9900',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','SCHERGRATCOMMENT');

-- -9400 - -9499
DELETE FROM `creature_ai_texts` WHERE `entry` BETWEEN -9499 AND -9400;
-- INSERT INTO `creature_ai_texts` VALUES
-- (-9400,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'SchergartPlatzhalter');

-- ======================================================
-- Spawns
-- ======================================================

DELETE FROM `creature` WHERE `guid` IN (78210,298274,84704);
INSERT INTO `creature` VALUES (78210, 22255, 530, 1, 0, 0, 2613.5490, 7131.9140, 363.9926, 1.09119, 300, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (298274, 23570, 1, 1, 0, 0, -4587.81, -3155.6, 34.9767, 5.61996, 120, 0, 0, 1, 0, 0, 0); -- 18601
INSERT INTO `creature` VALUES (84704, 23386, 530, 1, 0, 0, 1913.64, 7359.83, 364.471, 0.0667496, 600, 0, 0, 6986, 0, 0, 0);

-- Quest Spawned
DELETE FROM creature WHERE id = 21446;

--  Add missing Apexis Flayer spawns
UPDATE `creature_template` SET `modelid_A`='21234' WHERE `entry` = 22175; -- 20870
SET @Guid=144801;
DELETE FROM `creature` WHERE `guid` BETWEEN @Guid+0 AND @Guid+41;
DELETE FROM `creature` WHERE `id`=22175;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
(77759, 22175, 530, 1, 0, 0, 4087.7500, 4998.1772, 272.7598, 2.8418, 300, 5, 0, 7181, 0, 1),
(@Guid+0, 22175, 530, 1, 0, 0, 2608.55, 7075.41, 364.496, 5.71923, 300, 5, 0, 7181, 0,  1),
(@Guid+1, 22175, 530, 1, 0, 0, 2238.57, 7119.23, 365.84, 3.09914, 300, 5, 0, 7181, 0,  1),
(@Guid+2, 22175, 530, 1, 0, 0, 2218.84, 7276.48, 366.109, 3.94579, 300, 5, 0, 7181, 0, 1),
(@Guid+3, 22175, 530, 1, 0, 0, 2154.76, 7242.51, 371.791, 1.50713, 300, 5, 0, 7181, 0, 1),
(@Guid+4, 22175, 530, 1, 0, 0, 1991.99, 7364.78, 366.955, 1.9501, 300, 5, 0, 7181, 0, 1),
(@Guid+5, 22175, 530, 1, 0, 0, 2076.62, 7337.08, 365.808, 0.65419, 300, 5, 0, 7181, 0, 1),
(@Guid+6, 22175, 530, 1, 0, 0, 4079.29, 5129.22, 268.446, 1.09823, 600, 5, 0, 7181, 0, 1),
(@Guid+7, 22175, 530, 1, 0, 0, 2270.3, 7189.96, 364.752, 6.06008, 300, 5, 0, 7181, 0, 1),
(@Guid+8, 22175, 530, 1, 0, 0, 2202.82, 7237.79, 375.415, 2.95619, 300, 5, 0, 7181, 0, 1),
(@Guid+9, 22175, 530, 1, 0, 0, 2008.2, 7182.08, 369.87, 5.39014, 300, 5, 0, 7181, 0, 1),
(@Guid+10, 22175, 530, 1, 0, 0, 1952.68, 7216.42, 368.281, 4.71862, 300, 5, 0, 7181, 0, 1),
(@Guid+11, 22175, 530, 1, 0, 0, 2129.63, 7169.39, 366.483, 2.49909, 300, 5, 0, 7181, 0, 1),
(@Guid+12, 22175, 530, 1, 0, 0, 2494.71, 7263.55, 367.219, 5.21106, 300, 5, 0, 7181, 0, 1),
(@Guid+13, 22175, 530, 1, 0, 0, 2054.45, 7271.76, 365.238, 2.8211, 300, 5, 0, 7181, 0, 1),
(@Guid+14, 22175, 530, 1, 0, 0, 2483.08, 7057.84, 364.585, 3.86333, 300, 5, 0, 7181, 0, 1),
(@Guid+15, 22175, 530, 1, 0, 0, 2525.27, 7252.78, 365.323, 4.43352, 300, 5, 0, 7181, 0, 1),
(@Guid+16, 22175, 530, 1, 0, 0, 2455.15, 7057.42, 366.643, 0.409148, 300, 5, 0, 7181, 0, 1),
(@Guid+17, 22175, 530, 1, 0, 0, 2050.88, 7172.54, 369.315, 4.41232, 300, 5, 0, 7181, 0,  1),
(@Guid+18, 22175, 530, 1, 0, 0, 2402.86, 7068.99, 369.09, 2.95541, 300, 5, 0, 7181, 0, 1),
(@Guid+19, 22175, 530, 1, 0, 0, 2383.77, 7040.89, 379.688, 2.85331, 300, 5, 0, 7181, 0, 1),
(@Guid+20, 22175, 530, 1, 0, 0, 2345.61, 7026.68, 387.225, 2.59727, 300, 5, 0, 7181, 0, 1),
(@Guid+21, 22175, 530, 1, 0, 0, 2209.37, 7124.08, 364.438, 5.00765, 300, 5, 0, 7181, 0, 1),
(@Guid+22, 22175, 530, 1, 0, 0, 1843.45, 7310.6, 369.195, 1.96894, 300, 5, 0, 7181, 0, 1),
(@Guid+23, 22175, 530, 1, 0, 0, 1847.23, 7324.28, 368.691, 5.12624, 300, 5, 0, 7181, 0, 1),
(@Guid+24, 22175, 530, 1, 0, 0, 1853.72, 7366.1, 366.072, 1.24245, 300, 5, 0, 7181, 0, 1),
(@Guid+25, 22175, 530, 1, 0, 0, 2148.09, 7282.4, 368.747, 6.10328, 300, 5, 0, 7181, 0, 1),
(@Guid+26, 22175, 530, 1, 0, 0, 2596.27, 7200.13, 367.541, 1.25031, 300, 5, 0, 7181, 0, 1),
(@Guid+27, 22175, 530, 1, 0, 0, 2176.91, 7309.42, 372.694, 5.73415, 300, 5, 0, 7181, 0, 1),
(@Guid+28, 22175, 530, 1, 0, 0, 2745.14, 7230.82, 368.577, 3.98822, 300, 5, 0, 7181, 0, 1),
(@Guid+29, 22175, 530, 1, 0, 0, 2725.08, 7244.41, 369.344, 6.08051, 300, 5, 0, 7181, 0, 1),
(@Guid+30, 22175, 530, 1, 0, 0, 2591.54, 7220.81, 364.005, 5.91165, 300, 5, 0, 7181, 0, 1),
(@Guid+31, 22175, 530, 1, 0, 0, 2305.98, 7154.86, 365.855, 0.25991, 300, 5, 0, 7181, 0, 1),
(@Guid+32, 22175, 530, 1, 0, 0, 2337.79, 7148.06, 368.183, 1.28878, 300, 5, 0, 7181, 0, 1),
(@Guid+33, 22175, 530, 1, 0, 0, 2425.56, 7173.66, 366.865, 6.19438, 300, 5, 0, 7181, 0, 1),
(@Guid+34, 22175, 530, 1, 0, 0, 2460.97, 7128.22, 367.7, 1.39166, 300, 5, 0, 7181, 0, 1),
(@Guid+35, 22175, 530, 1, 0, 0, 2491.67, 7155.23, 369.61, 3.2884, 300, 5, 0, 7181, 0, 1),
(@Guid+36, 22175, 530, 1, 0, 0, 2451.01, 7296.84, 365.796, 2.66794, 300, 5, 0, 7181, 0, 1),
(@Guid+37, 22175, 530, 1, 0, 0, 2439.87, 7254.54, 369.234, 2.22419, 300, 5, 0, 7181, 0, 1),
(@Guid+38, 22175, 530, 1, 0, 0, 1945.76, 7133.53, 367.456, 3.74865, 300, 5, 0, 7181, 0, 1),
(@Guid+39, 22175, 530, 1, 0, 0, 2037.34, 7265.44, 367.727, 0.68482, 300, 5, 0, 7181, 0, 1),
(@Guid+40, 22175, 530, 1, 0, 0, 1993.1, 7143.76, 373.431, 5.6768, 300, 5, 0, 7181, 0, 1),
(@Guid+41, 22175, 530, 1, 0, 0, 1948.44, 7203.54, 366.609, 1.46472, 300, 5, 0, 7181, 0, 1);
--
DELETE FROM `creature` WHERE `guid` BETWEEN 85655 AND 85668;
DELETE FROM `creature` WHERE `guid` IN (85671,85675,85676,16777288,16777287,16777286);
INSERT INTO `creature` VALUES (85655, 23118, 530, 1, 0, 0, 2764.71, 7024.45, 370.203, 0, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85656, 23118, 530, 1, 0, 0, 2786.61, 7036.28, 370.686, 0, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85657, 23118, 530, 1, 0, 0, 2824.71, 7044.79, 369.877, 0, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85658, 23118, 530, 1, 0, 0, 2940.82, 7107.17, 370.115, 4.65944, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85659, 23118, 530, 1, 0, 0, 2825.11, 7024.05, 369.982, 5.69617, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85660, 23118, 530, 1, 0, 0, 2938.84, 7094.48, 371.493, 0.225375, 60, 0, 0, 25, 0, 0, 0);
-- 85672 85673 85674 85680 85681 85684 85686 85689 85690 85691 85696 85697 85698 85699
INSERT INTO `creature` VALUES (85661, 23118, 530, 1, 0, 0, 2924.84, 7031.46, 367.857, 4.26205, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85662, 23118, 530, 1, 0, 0, 2938.02, 7015.59, 366.54, 3.65778, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85663, 23118, 530, 1, 0, 0, 2998.57, 7043.55, 368.539, 5.91266, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85664, 23118, 530, 1, 0, 0, 2982, 7054.94, 368.82, 4.99766, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85665, 23118, 530, 1, 0, 0, 2978.74, 6889.12, 371.288, 0.897875, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85666, 23118, 530, 1, 0, 0, 2941.56, 6827.17, 367.3, 4.54054, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85667, 23118, 530, 1, 0, 0, 2953.55, 6859.3, 369.954, 6.14433, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85668, 23118, 530, 1, 0, 0, 3023.13, 6799.74, 374.46, 1.58666, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85671, 23118, 530, 1, 0, 0, 3028.3, 6824.84, 373.591, 5.0275, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85675, 23118, 530, 1, 0, 0, 3022.15, 6859.05, 369.546, 3.44885, 60, 0, 0, 25, 0, 0, 0);
INSERT INTO `creature` VALUES (85676, 23118, 530, 1, 0, 0, 3016.28, 6876.11, 370.188, 3.47791, 60, 0, 0, 25, 0, 0, 0);

-- 2.0
-- Wrath Fiend 22392 
UPDATE `creature` SET `id` = 22291 WHERE `guid` IN (78717,78718,78719); -- 22392
-- Wrath Fiend 22286 pre 2.1
UPDATE `creature` SET `spawnmask` = 0 WHERE `guid` IN (78325,78326,78327,78328,78329,78330,78331,78332,78333); -- 1
-- Bladespine Basilisk 22187 pre 2.1
UPDATE `creature` SET `spawnmask` = 0 WHERE `guid` IN (77814,77815,77816,77817,77818,77819,77820);
-- Nightmare Imp 22202 pre 2.1
UPDATE `creature` SET `spawnmask` = 0 WHERE `guid` IN (77855,77856,77857,77858,77859,77860,77861,77862,77863,77864,77865,77866);
-- Terror-Fire Guardian 22327
UPDATE `creature` SET `id` = 22204 WHERE `guid` IN (78559,78560,78561,78562,78563,78564); -- 22327
-- Terrordar the Tormentor 22385 real bt release
-- UPDATE `creature` SET `spawnmask` = 0 WHERE `guid` = 78694;
-- Spire Needler 22194 pre 2.1
UPDATE `creature` SET `spawnmask` = 0 WHERE `guid` IN (77821,77822,77823,77824,77825,77826,77827,77828,77829,77830,77831,77832,77833,77834,77835,77836,77837,77838,77839,77840,77841,77842,77843,77844,77845);
-- Deathlash Stinger 22257 pre 2.1 -> Aether Ray
UPDATE `creature` SET `id` = 22257 WHERE `guid` BETWEEN 77787 AND 77791;
DELETE FROM `creature` WHERE `guid` IN (78216,78217,78218,78219,78220,78221,78223,78224,78225,78226,78227,78228,78229,78230,78231,78232,78233,78234,78235,78236,78237,78238,78239,78240,78241,78242,78243,78244,78245,78246,78247,78248,78249,78250,78251,78252,78253,78254,78255,78256,78257,78258,78259,78260,78261);
-- INSERT INTO `creature` VALUES (78216, 22257, 530, 1, 0, 0, 2706.82, 7151.3, 364.832, 4.39658, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78217, 22257, 530, 1, 0, 0, 2778.18, 7217.4, 365.399, 2.17515, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78218, 22257, 530, 1, 0, 0, 2650.19, 7215.58, 363.941, 4.31096, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78219, 22257, 530, 1, 0, 0, 2616.01, 7245.59, 364.671, 1.10546, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78220, 22257, 530, 1, 0, 0, 2512.59, 7275.21, 367.263, 2.72734, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78221, 22257, 530, 1, 0, 0, 2527.36, 7253.35, 364.53, 5.55499, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78223, 22257, 530, 1, 0, 0, 2504.71, 7245.27, 365.684, 0.66838, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78224, 22257, 530, 1, 0, 0, 2458.35, 7281.86, 365.359, 4.08158, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78225, 22257, 530, 1, 0, 0, 2446.84, 7359.08, 365.205, 2.49121, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78226, 22257, 530, 1, 0, 0, 2061.52, 7271.81, 363.911, 2.25509, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78227, 22257, 530, 1, 0, 0, 2099.33, 7330.34, 364.607, 2.57119, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78228, 22257, 530, 1, 0, 0, 2067.45, 7331.05, 364.735, 4.17056, 300, 0, 0, 7181, 0, 0, 0);
-- INSERT INTO `creature` VALUES (78229, 22257, 530, 1, 0, 0, 2103.11, 7353.6, 366.479, 5.89536, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78230, 22257, 530, 1, 0, 0, 2032.96, 7259.08, 363.918, 5.56344, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78231, 22257, 530, 1, 0, 0, 2036.44, 7293.47, 363.316, 5.38637, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78232, 22257, 530, 1, 0, 0, 1843.66, 7295.39, 364.686, 3.08165, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78233, 22257, 530, 1, 0, 0, 1858.35, 7351.39, 363.794, 2.91742, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78234, 22257, 530, 1, 0, 0, 1789.23, 7122.59, 362.149, 3.0024, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78235, 22257, 530, 1, 0, 0, 1926.84, 7195.48, 364.116, 3.93496, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78236, 22257, 530, 1, 0, 0, 2121.94, 7160.59, 363.906, 6.17584, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78237, 22257, 530, 1, 0, 0, 2114.53, 7187.61, 366.179, 4.56345, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78238, 22257, 530, 1, 0, 0, 2206.19, 7122.32, 364.065, 4.78504, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78239, 22257, 530, 1, 0, 0, 2239.24, 7142.74, 366.781, 2.45333, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78240, 22257, 530, 1, 0, 0, 2224.77, 7099.38, 365.982, 1.09666, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78241, 22257, 530, 1, 0, 0, 2353.17, 7104.93, 367.007, 2.18587, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78242, 22257, 530, 1, 0, 0, 2403.47, 7083.51, 366.579, 4.23665, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78243, 22257, 530, 1, 0, 0, 2490, 7043.62, 366.056, 4.14772, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78244, 22257, 530, 1, 0, 0, 2458.42, 7049.03, 367.785, 5.5253, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78245, 22257, 530, 1, 0, 0, 2464.83, 7072.46, 364.959, 6.15883, 300, 0, 0, 7181, 0, 0, 0);
-- INSERT INTO `creature` VALUES (78246, 22257, 530, 1, 0, 0, 2678.12, 7120.47, 364.677, 4.06626, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78247, 22257, 530, 1, 0, 0, 3790.07, 5840.06, 261.204, 5.2408, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78248, 22257, 530, 1, 0, 0, 3815.14, 5857.78, 266.07, 2.85368, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78249, 22257, 530, 1, 0, 0, 3877.07, 5943.6, 269.352, 1.46953, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78250, 22257, 530, 1, 0, 0, 3899.06, 5968.08, 268.173, 3.42963, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78251, 22257, 530, 1, 0, 0, 3827.45, 5814.51, 267.705, 4.15338, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78252, 22257, 530, 1, 0, 0, 4085.43, 5827.83, 264.129, 2.14618, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78253, 22257, 530, 1, 0, 0, 4077.67, 5856.85, 256.653, 6.22165, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78254, 22257, 530, 1, 0, 0, 4047.39, 5913.28, 263.395, 4.89851, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78255, 22257, 530, 1, 0, 0, 4041.46, 5970.79, 265.805, 6.14957, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78256, 22257, 530, 1, 0, 0, 3999.1237, 6005.3378, 268.6499, 3.2317, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78257, 22257, 530, 1, 0, 0, 3917.28, 6008.18, 267.865, 5.58632, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78258, 22257, 530, 1, 0, 0, 4006.68, 6042.7, 261.141, 5.28363, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78259, 22257, 530, 1, 0, 0, 3952.79, 6078.67, 266.482, 0.737055, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78260, 22257, 530, 1, 0, 0, 3905.1, 6107.35, 266.69, 5.08921, 300, 5, 0, 7181, 0, 0, 1);
-- INSERT INTO `creature` VALUES (78261, 22257, 530, 1, 0, 0, 3997.91, 6093.29, 260.065, 3.98226, 300, 5, 0, 7181, 0, 0, 1);
INSERT INTO `creature` VALUES (78216, 22181, 530, 1, 0, 0, 2706.82, 7151.3, 364.832, 4.39658, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78217, 22181, 530, 1, 0, 0, 2778.18, 7217.4, 365.399, 2.17515, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78218, 22181, 530, 1, 0, 0, 2650.19, 7215.58, 363.941, 4.31096, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78219, 22181, 530, 1, 0, 0, 2616.01, 7245.59, 364.671, 1.10546, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78220, 22181, 530, 1, 0, 0, 2512.59, 7275.21, 367.263, 2.72734, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78221, 22181, 530, 1, 0, 0, 2527.36, 7253.35, 364.53, 5.55499, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78223, 22181, 530, 1, 0, 0, 2504.71, 7245.27, 365.684, 0.66838, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78224, 22181, 530, 1, 0, 0, 2458.35, 7281.86, 365.359, 4.08158, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78225, 22181, 530, 1, 0, 0, 2446.84, 7359.08, 365.205, 2.49121, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78226, 22181, 530, 1, 0, 0, 2061.52, 7271.81, 363.911, 2.25509, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78227, 22181, 530, 1, 0, 0, 2099.33, 7330.34, 364.607, 2.57119, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78228, 22181, 530, 1, 0, 0, 2067.45, 7331.05, 364.735, 4.17056, 300, 0, 0, 7685, 0, 0, 0);
INSERT INTO `creature` VALUES (78229, 22181, 530, 1, 0, 0, 2159.1853, 7331.5122, 364.6892, 5.89536, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78230, 22181, 530, 1, 0, 0, 2032.96, 7259.08, 363.918, 5.56344, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78231, 22181, 530, 1, 0, 0, 2036.44, 7293.47, 363.316, 5.38637, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78232, 22181, 530, 1, 0, 0, 1843.66, 7295.39, 364.686, 3.08165, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78233, 22181, 530, 1, 0, 0, 1858.35, 7351.39, 363.794, 2.91742, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78234, 22181, 530, 1, 0, 0, 1789.23, 7122.59, 362.149, 3.0024, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78235, 22181, 530, 1, 0, 0, 1926.84, 7195.48, 364.116, 3.93496, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78236, 22181, 530, 1, 0, 0, 2121.94, 7160.59, 363.906, 6.17584, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78237, 22181, 530, 1, 0, 0, 2114.53, 7187.61, 366.179, 4.56345, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78238, 22181, 530, 1, 0, 0, 2206.19, 7122.32, 364.065, 4.78504, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78239, 22181, 530, 1, 0, 0, 2239.24, 7142.74, 366.781, 2.45333, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78240, 22181, 530, 1, 0, 0, 2224.77, 7099.38, 365.982, 1.09666, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78241, 22181, 530, 1, 0, 0, 2353.17, 7104.93, 367.007, 2.18587, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78242, 22181, 530, 1, 0, 0, 2403.47, 7083.51, 366.579, 4.23665, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78243, 22181, 530, 1, 0, 0, 2490, 7043.62, 366.056, 4.14772, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78244, 22181, 530, 1, 0, 0, 2458.42, 7049.03, 367.785, 5.5253, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78245, 22181, 530, 1, 0, 0, 2464.83, 7072.46, 364.959, 6.15883, 300, 0, 0, 7685, 0, 0, 0);
INSERT INTO `creature` VALUES (78246, 22181, 530, 1, 0, 0, 2678.12, 7120.47, 364.677, 4.06626, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78247, 22181, 530, 1, 0, 0, 3790.07, 5840.06, 261.204, 5.2408, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78248, 22181, 530, 1, 0, 0, 3815.14, 5857.78, 266.07, 2.85368, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78249, 22181, 530, 1, 0, 0, 3877.0700, 5943.6000, 270.9169, 1.46953, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78250, 22181, 530, 1, 0, 0, 3899.06, 5968.08, 268.173, 3.42963, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78251, 22181, 530, 1, 0, 0, 3827.45, 5814.51, 267.705, 4.15338, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78252, 22181, 530, 1, 0, 0, 4085.43, 5827.83, 264.129, 2.14618, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78253, 22181, 530, 1, 0, 0, 4077.67, 5856.85, 256.653, 6.22165, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78254, 22181, 530, 1, 0, 0, 4047.39, 5913.28, 263.395, 4.89851, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78255, 22181, 530, 1, 0, 0, 4041.46, 5970.79, 265.805, 6.14957, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78256, 22181, 530, 1, 0, 0, 3999.1237, 6005.3378, 268.6499, 3.2317, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78257, 22181, 530, 1, 0, 0, 3917.28, 6008.18, 267.865, 5.58632, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78258, 22181, 530, 1, 0, 0, 4006.68, 6042.7, 261.141, 5.28363, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78259, 22181, 530, 1, 0, 0, 3952.79, 6078.67, 266.482, 0.737055, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78260, 22181, 530, 1, 0, 0, 3905.1, 6107.35, 266.69, 5.08921, 300, 5, 0, 7685, 0, 0, 1);
INSERT INTO `creature` VALUES (78261, 22181, 530, 1, 0, 0, 3997.91, 6093.29, 260.065, 3.98226, 300, 5, 0, 7685, 0, 0, 1);

-- ======================================================
-- NPC Research
-- ======================================================
--
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` IN ('21004','20751','20714','21032','22123','21423','20768','20609','20614','20668','21124','21123','16952','19961','19960','21519','19980','21837','21516','20998');
DELETE FROM creature_ai_scripts WHERE `entryOrGUID` IN ('21004','20751','20714','21032','22123','21423','20768','20609','20614','20668','21124','21123','16952','19961','19960','21519','19980','21837','21516','20998');
INSERT INTO `creature_ai_scripts` VALUES
--
-- Lesser Nether Drake
(2100401,21004,0,0,100,1,6000,6000,12000,16000,11,36513,0,1,0,0,0,0,0,0,0,0,'Lesser Nether Drake - Casts Intangible Presence'),
--
-- Daggermaw Lashtail
(2075101,20751,4,0,100,0,0,0,0,0,11,35570,1,0,0,0,0,0,0,0,0,0,'Daggermaw Lashtail - Casts Mighty Charge on Aggro'),
(2075102,20751,0,0,100,1,3500,4000,10000,11000,11,7367,1,0,0,0,0,0,0,0,0,0,'Daggermaw Lashtail - Casts Infected Bite'),
--
-- Ridgespine Stalker
(2071401,20714,0,0,100,1,3500,4000,10000,11000,11,744,1,0,0,0,0,0,0,0,0,0,'Ridgespine Stalker - Casts Poison'),
(2071402,20714,1,0,100,0,1000,1000,0,0,11,22766,0,7,0,0,0,0,0,0,0,0,'Ridgespine Stalker - Cast Stealth'),
(2071403,20714,4,0,100,0,0,0,0,0,28,0,22766,0,0,0,0,0,0,0,0,0,'Ridgespine Stalker - Remove Stealth on Aggro'),
--
-- Ridgespine Horror
(2099801,20998,0,0,100,1,3500,4000,10000,11000,11,7951,1,0,0,0,0,0,0,0,0,0,'Ridgespine Horror - Casts Toxic Spit'),
(2099802,20998,0,0,100,1,6000,6000,12000,16000,11,745,1,0,0,0,0,0,0,0,0,0,'Ridgespine Horror - Casts Threatening Web'),
(2099803,20998,1,0,100,0,1000,1000,0,0,11,22766,0,7,0,0,0,0,0,0,0,0,'Ridgespine Horror - Cast Stealth'),
(2099804,20998,4,0,100,0,0,0,0,0,28,0,22766,0,0,0,0,0,0,0,0,0,'Ridgespine Horror - Remove Stealth on Aggro'),
--
(2103201,21032,0,0,100,1,6000,6000,14000,14000,11,36631,0,0,0,0,0,0,0,0,0,0,'Dreadwing - Casts Netherbreath'),
(2212301,22123,0,0,100,1,3500,4000,10000,11000,11,3242,1,0,0,0,0,0,0,0,0,0,'Rip-Blade Ravager - Casts Ravage'),
(2142301,21423,0,0,100,1,3000,3000,14000,15000,11,13443,1,0,0,0,0,0,0,0,0,0,'Gore-Scythe Ravager - Casts Rend'),
--
--
(2076801,20768,0,0,100,1,6000,6000,12000,16000,11,37597,1,0,0,0,0,0,0,0,0,0,'Gnosh Brognat - Casts Meat Slap'),
(2076802,20768,0,0,100,1,2500,5500,10000,11000,11,37596,1,0,0,0,0,0,0,0,0,0,'Gnosh Brognat - Casts Tenderize'),
(2060901,20609,0,0,100,1,6000,6000,12000,16000,11,36513,0,1,0,0,0,0,0,0,0,0,'Razaani Nexus Stalker - Casts Intangible Presence'),
(2060902,20609,0,0,100,1,6000,6000,12000,16000,11,11975,0,0,0,0,0,0,0,0,0,0,'Razaani Nexus Stalker - Casts Arcane Explosion'),
(2061401,20614,0,0,100,1,2500,5500,10000,11000,11,36508,1,1,0,0,0,0,0,0,0,0,'Razaani Spell-Thief - Casts Energy Surge'),
(2066801,20668,11,0,100,0,0,0,0,0,11,37816,0,0,0,0,0,0,0,0,0,0,'Fiendling Flesh Beast - Shadowform'),
(2112401,21124,4,0,100,0,0,0,0,0,11,35570,1,0,0,0,0,0,0,0,0,0,'Felsworn Daggermaw - Casts Chaos Charge on Aggro'),
(2112402,21124,0,0,100,1,2500,5500,10000,11000,11,7367,1,0,0,0,0,0,0,0,0,0,'Felsworn Daggermaw - Casts Infected Bite'),
(2112301,21123,0,0,100,1,3000,3000,14000,15000,11,32093,1,0,0,0,0,0,0,0,0,0,'Felsworn Scalewing - Casts Poison Spit'),
(1695201,16952,4,0,100,0,0,0,0,0,11,22911,1,0,0,0,0,0,0,0,0,0,'Anger Guard - Casts Charge'),
(1695202,16952,0,0,100,1,3500,5500,10000,11000,11,15496,1,0,0,0,0,0,0,0,0,0,'Anger Guard - Casts Cleave'),
(1996101,19961,0,0,100,1,8000,9000,16000,16000,11,36846,0,0,0,0,0,0,0,0,0,0,'Deathforge Over-Smith - Casts Mana Bomb'),
(1996102,19961,0,0,100,1,6000,6000,10000,15000,11,36208,1,1,0,0,0,0,0,0,0,0,'Deathforge Technician - Steal Weapon'),
(1996001,19960,0,0,100,1,8000,9000,16000,16000,11,36253,0,0,0,0,0,0,0,0,0,0,'Doomforge Engineer - Casts Chemical Flames'),
(1996002,19960,0,0,100,1,6000,6000,10000,15000,11,36251,0,0,0,0,0,0,0,0,0,0,'Doomforge Engineer - Hammer Slam'),
(2151901,21519,0,0,100,1,3500,4000,10000,11000,11,15496,1,0,0,0,0,0,0,0,0,0,'Deaths Might - Casts Cleave'),
(2151902,21519,0,0,100,1,6000,6000,14000,15000,11,32736,1,0,0,0,0,0,0,0,0,0,'Deaths Might - Casts Mortal Strike'),
(1998001,19980,0,0,100,1,5500,5500,14000,15000,11,36406,0,0,0,0,0,0,0,0,0,0,'Void Terror - Casts Double Breath'),
(1998002,19980,0,0,100,1,3500,4000,10000,11000,11,36405,0,0,0,0,0,0,0,0,0,0,'Void Terror - Casts Stomp'),
(2183701,21837,4,0,100,0,0,0,0,0,11,22911,1,0,0,0,0,0,0,0,0,0,'Summoned Wrath Hound - Cast Threshalisk Charge on Aggro'),
(2183702,21837,0,0,100,1,6000,8000,14000,16000,11,36406,0,0,0,0,0,0,0,0,0,0,'Summoned Wrath Hound - Casts Double Breath'),
(2151601,21516,0,0,100,1,3500,4000,10000,11000,11,37621,1,1,0,0,0,0,0,0,0,0,'Death Watch - Casts Mind Flay'),
(2151602,21516,0,0,100,1,6000,6000,14000,15000,11,36398,1,0,0,0,0,0,0,0,0,0,'Death Watch - Casts Tongue Lash');

-- Sons of Gruul Immunities
UPDATE `creature` SET `spawntimesecs`='600' WHERE `id` IN (18411,20216,20555,20600,21514,22199,22910);
UPDATE `creature_template` SET `mechanic_immune_mask`='787431423' WHERE `entry` IN (18411,20555,21514,22910);

-- Grulloc 20216
UPDATE `creature_template` SET `speed`='1.71',`mechanic_immune_mask`='787430911' WHERE `entry` = '20216'; -- grulloc sleep for quest
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '20216';
INSERT INTO `creature_ai_scripts` VALUES
('2021601','20216','0','0','100','1','10000','20000','18000','28000','11','38771','0','1','0','0','0','0','0','0','0','0','Grulloc - Cast Burning Rage'),
('2021602','20216','9','0','100','1','0','5','12000','17000','11','21055','1','0','0','0','0','0','0','0','0','0','Grulloc - Cast Crush Armor'),
('2021603','20216','0','0','100','1','6000','17000','5000','10000','11','38772','4','39','0','0','0','0','0','0','0','0','Grulloc - Cast Grievous Wound'),
('2021604','20216','6','0','100','0','0','0','0','0','11','39890','0','7','0','0','0','0','0','0','0','0','Grulloc - Summon Grulloc\'s Dragon Skull Chest on Death');

-- Maggoc <Son of Gruul> 20600
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='1500',`maxdmg`='3000',`AIName`='EventAI',`mechanic_immune_mask`='787431423' WHERE `entry` = '20600'; -- 1101 2251
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '20600';
INSERT INTO `creature_ai_scripts` VALUES
(2060001,20600,2,0,100,0,30,0,0,0,11,40743,0,1,1,-106,0,0,0,0,0,0,'Maggoc - Casts Frenzy at 30% HP'),
(2060002,20600,6,0,100,0,0,0,0,0,11,39891,0,7,0,0,0,0,0,0,0,0,'Maggoc - Summon Maggoc Treasure Chest on Death'),
(2060003,20600,9,0,100,1,5,30,5000,5000,11,42139,4,1,0,0,0,0,0,0,0,0,'Maggoc  - Casts Boulder on Aggro'),
(2060004,20600,9,0,100,1,0,5,5000,10000,11,38770,1,1,0,0,0,0,0,0,0,0,'Maggoc - Casts Mortal Wound'),
(2060005,20600,0,0,100,1,5000,5000,10000,15000,11,38777,4,1,0,0,0,0,0,0,0,0,'Maggoc - Rock Rumble');

-- Vim'gol the Vile 22911
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='1000',`maxdmg`='2000',`baseattacktime`='1400',`AIName`='EventAI',`mechanic_immune_mask`='787431423' WHERE `entry` = '22911'; -- 837 1812
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22911';
INSERT INTO `creature_ai_scripts` VALUES
('2291101','22911','6','0','100','0','0','0','0','0','11','39862','0','7','0','0','0','0','0','0','0','0','Vim\'gol the Vile - Cast Summon Vim\'gol\'s Vile Grimoire Chest on Death (Quest: 10998)'),
('2291102','22911','11','0','100','0','0','0','0','0','11','7741','0','7','0','0','0','0','0','0','0','0','Vim\'gol the Vile - Cast Summoned Demon on Spawn'),
('2291103','22911','0','0','100','1','10000','10000','300000','300000','11','40545','0','7','0','0','0','0','0','0','0','0','Vim\'gol the Vile - Cast Unholy Growth'),
('2291104','22911','1','0','100','1','30000','30000','1000','1000','41','0','0','0','0','0','0','0','0','0','0','0','Vim\'gol the Vile - Despawn OOC');

-- Skulloc Soulgrinder 22910
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='1500',`maxdmg`='3000',`AIName`='EventAI',`mechanic_immune_mask`='787431423' WHERE `entry` = '22910'; -- 1 1023 2087
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22910';
INSERT INTO `creature_ai_scripts` VALUES
(2291001,22910,9,0,100,1,0,30,3000,6000,11,39621,4,39,0,0,0,0,0,0,0,0,'Skulloc Soulgrinder - Cast Corruption'),
(2291002,22910,0,0,100,1,4000,8000,6000,12000,11,39622,5,32,0,0,0,0,0,0,0,0,'Skulloc Soulgrinder - Cast Banish'),
(2291003,22910,0,0,100,1,5000,5000,10000,10000,11,39620,1,7,0,0,0,0,0,0,0,0,'Skulloc Soulgrinder - Cast Summon Ogre Ghost');

-- Sundered Ghost 24039
UPDATE `creature_template` SET `modelid_A`='21587',`modelid_H`='21587',`minhealth`='9780',`maxhealth`='9780',`speed`='1.15',`scale`='1',`mindmg`='462',`maxdmg`='565',`baseattacktime`='1400',`mechanic_immune_mask`='8405008' WHERE `entry` = '24039'; -- 11686 2445 1 91 194 -- 462 - 565

-- Sundered Spirit 22912
UPDATE `creature_template` SET `modelid_A`='11686',`modelid_H`='11686',`minhealth`='4890',`maxhealth`='4890',`speed`='1.15',`scale`='1.25',`mindmg`='231',`maxdmg`='283',`baseattacktime`='1400',`AIName`='EventAI',`mechanic_immune_mask`='8405008' WHERE `entry` = '22912'; -- 2445 1 91 194 -- 462 - 565 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22912';
INSERT INTO `creature_ai_scripts` VALUES
(2291201,22912,0,0,100,1,4000,8000,6000,12000,11,11443,4,32,0,0,0,0,0,0,0,0,'Sundered Spirit - Cast Cripple'),
(2291202,22912,9,0,100,1,0,40,3000,5000,11,20816,1,0,0,0,0,0,0,0,0,0,'Sundered Spirit - Shadow Bolt');

-- Gorgrom the Dragon-Eater 21514
-- npc_gargrom

-- Goc 20555
-- 38784/bodenzerkracher 38785/bodenzerkracher 38783/brockensalve
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = '20555';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '20555';
INSERT INTO `creature_ai_scripts` VALUES
(2055501,20555,9,0,100,1,0,40,8000,16000,11,38783,1,0,0,0,0,0,0,0,0,0,'Goc - Casts Boulder Volley on Aggro'),
(2055502,20555,0,0,100,1,6000,6000,14000,15000,11,38784,0,7,11,38785,0,7,0,0,0,0,'Goc - Casts Ground Smash'),
(2055503,20555,1,0,100,1,30000,30000,1000,1000,41,0,0,0,0,0,0,0,0,0,0,0,'Goc  - Despawn OOC');

-- visual fledermaus
UPDATE `creature_template` SET `inhabittype`='5' WHERE `entry` = 22040;

-- Solus the Eternal 20888
-- It got a lot easier after he ran out of mana, and thus couldn't shadow bolt anymore. I have BTish gear with a high concentration on spellpower, but I bet a holy paladin could do it in SSCish gear.
-- UPDATE `creature_template` SET `speed`='1.48',`mindmg`='',`maxdmg`='',`mechanic_immune_mask`='1073692671',`flags_extra`='4259840' WHERE `entry` = 20888; -- 481 982

-- Matron Li-sahar 22825
-- Does Mark of Malice (increases melee damage taken).
-- Also does a shadow nova for ~1300 damage. Hits not too hard on warrior
-- As stated above she does an AOE (~1500) and a mark to increase damage taken.
-- UPDATE `creature_template` SET `speed`='1.48',`mindmg`='',`maxdmg`='',`mechanic_immune_mask`='1073692671',`flags_extra`='4259840' WHERE `entry` = 22825; -- 385 785

-- King Dorfbruiser 22826
-- King Dorfbruiser says: In Outland, lunch open prison for you! What a world! Time to eat!
-- King Dorfbruiser says: WUT! DA KING IS BACK, BABY!
--  I have around 60% damage reduction in my healing gear so he was hitting me for 500-700 normal hits but also does knockback and whirlwind that hits for around same. While he's whirling he moves 50% slower so it's possible to kite him but I didn't bother.
-- UPDATE `creature_template` SET `speed`='1.48',`mindmg`='',`maxdmg`='',`mechanic_immune_mask`='1073692671',`flags_extra`='4259840' WHERE `entry` = 22826; -- 518 1059

-- Gorgolon the All-Seeing 22827
-- This guy is predominantly a caster, uses channeled spells and a aoe fear. 
-- On my bear druid (heroic/badge/crafted epics - 28k armor) his melee hits were only for about 375. Mindblast was about 1700 shadow damage and his All-Seeing Glare (seemed like random school) is the channeled one that does about 530 a tick.
-- UPDATE `creature_template` SET `speed`='1.48',`mindmg`='',`maxdmg`='',`mechanic_immune_mask`='1073692671',`flags_extra`='4259840' WHERE `entry` = 22827; -- 481 982

-- Trelopades <Legion Commander> 22828
-- Hits for 500-600 on 25k armor. He also has a Mortal Cleave which does ~3000 dmg on 25k armor.
-- UPDATE `creature_template` SET `speed`='1.48',`mindmg`='',`maxdmg`='',`mechanic_immune_mask`='1073692671',`flags_extra`='4259840' WHERE `entry` = 22828; -- 622 1272

-- Grishna Arakkoa has no EventAI
UPDATE `creature_template` SET `AIName`= NULL WHERE `entry` = 22232; -- EventAI

-- Terrordar the Tormentor 22385
UPDATE `creature_template` SET `maxhealth`='25356',`mindmg`='1549',`maxdmg`='1840',`AIName`='EventAI',`mechanic_immune_mask`='618889051' WHERE `entry` = 22385; -- 22356 278 569
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22385;
INSERT INTO `creature_ai_scripts` VALUES
('2238501','22385','0','0','100','9','0','20','6000','12000','11','44519','1','0','0','0','0','0','0','0','0','0','Terrordar the Tormentor - Cast Incinerate'),
('2238502','22385','0','0','100','0','4000','8000','15000','18000','11','41281','1','0','0','0','0','0','0','0','0','0','Terrordar the Tormentor - Cast Criple');

-- Felstorm Corruptor 22217
UPDATE `creature_template` SET `minlevel`='70',`maxlevel`='71',`AIName`='EventAI' WHERE `entry` = 22217; -- 66 67
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22217;
INSERT INTO `creature_ai_scripts` VALUES
('2221701','22217','0','0','100','9','0','30','7000','9000','11','18376','4','32','0','0','0','0','0','0','0','0','Felstorm Corruptor - Cast Corruption'),
('2221702','22217','0','0','100','9','0','40','4000','5000','11','15232','1','0','0','0','0','0','0','0','0','0','Felstorm Corruptor - Cast Shadow Bolt');

-- Trigul 22174
UPDATE `creature_template` SET `baseattacktime`='2000',`AIName`='EventAI' WHERE `entry` = '22174';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22174';
INSERT INTO `creature_ai_scripts` VALUES
('2217401','22174','0','0','100','4','0','0','0','0','11','3391','0','7','0','0','0','0','0','0','0','0','Trigul - Cast Thrash on Aggro'),
('2217402','22174','9','0','100','0','0','5','8000','12000','11','33628','1','0','0','0','0','0','0','0','0','0','Trigul - Cast Lightning Tether');

-- Toshley Flying Machine 22089
UPDATE `creature_template` SET `InhabitType`='7' WHERE `entry` = '22089';

-- 23174 22304 not in db nowhere

-- Fear Fiend 22204
UPDATE `creature_template` SET `armor`='6800' WHERE `entry` = '22204';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22204';
INSERT INTO `creature_ai_scripts` VALUES
(2220401,22204,0,0,100,1,5000,10000,8000,24000,11,34259,4,32,0,0,0,0,0,0,0,0,'Fear Fiend - Cast Fear'),
(2220402,22204,9,0,50,1,0,5,7000,14000,11,38356,1,0,0,0,0,0,0,0,0,0,'Fear Fiend - Cast Fel Flames'), -- 36248 ->36487/38356
(2220422,22204,6,0,100,0,0,0,0,0,11,40828,0,3,0,0,0,0,0,0,0,0,'Banished - Cast Credit on Master on Death');

-- Furnace Guard 22291
UPDATE `creature_template` SET `modelid_A`='21307' WHERE `entry` = '22291'; -- 18832

-- Wrath Speaker 22195
-- UPDATE `creature_template` SET  WHERE `entry` = '22195';

-- Wrath Fiend 22392
DELETE FROM `creature` WHERE `guid` IN (78717,78719);
INSERT INTO `creature` VALUES (78717, 22392, 530, 1, 0, 0, 2938.08, 7097.49, 370.216, 2.54818, 300, 0, 0, 7181, 0, 0, 0);
INSERT INTO `creature` VALUES (78719, 22392, 530, 1, 0, 0, 2812.32, 7039.1, 370.632, 2.07694, 300, 0, 0, 7181, 0, 0, 0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22392';
INSERT INTO `creature_ai_scripts` VALUES
(2239201,22392,9,0,100,1,0,5,10000,20000,11,36965,1,32,0,0,0,0,0,0,0,0,'Wrath Fiend - Rend'),
(2239202,22392,9,0,50,1,0,5,7000,14000,11,41445,1,0,0,0,0,0,0,0,0,0,'Wrath Fiend - Cast Fel Flames'),
(2239203,22392,6,0,100,0,0,0,0,0,11,40828,0,3,0,0,0,0,0,0,0,0,'Banished - Cast Credit on Master on Death');

-- Abyssal Flamebringer 19973
-- They are imune to fire Roughly 8k hitpoints. abyssal strike around 800-900 They have around 9k hp
UPDATE `creature_template` SET `minhealth`='8000',`maxhealth`='9000',`resistance2`='-1' WHERE `entry` = 19973; -- 6986 7181
UPDATE `creature_template_addon` SET `auras`='7942 0' WHERE `entry` = 19973;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19973;
INSERT INTO `creature_ai_scripts` VALUES
(1997301,19973,0,0,100,1,3500,5500,10100,12800,11,37633,1,0,0,0,0,0,0,0,0,0,'Abyssal Flamebringer - Casts Abyssal Strike'),
(1997302,19973,8,0,100,1,36854,-1,10000,10000,22,1,0,0,0,0,0,0,0,0,0,0,'Abyssal Flammebringer - q11026 - q11051'),
(1997303,19973,6,1,100,0,0,0,0,0,33,23327,6,0,11,40828,0,3,23,-1,0,0,'Abyssal Flammebringer - q11026 - q11051'),
(1997304,19973,0,0,100,1,1000,1000,2000,2000,11,12744,0,38,0,0,0,0,0,0,0,0,'Abyssal Flamebringer - Cast Immolation Aura'); -- 12743 // 39808 39809

-- Wrath Hound 20557
UPDATE `creature_template` SET `resistance2`='-1' WHERE `entry` = 20557; --
UPDATE `creature_model_info` SET `bounding_radius`='5',`combat_reach`='5' WHERE `modelid`='20853'; -- 2.5
UPDATE `creature_model_info` SET `bounding_radius`='6',`combat_reach`='6' WHERE `modelid`='20854'; -- 3
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20557;
INSERT INTO `creature_ai_scripts` VALUES
('2055701','20557','9','0','100','0','8','25','0','0','11','22911','1','0','0','0','0','0','0','0','0','0','Wrath Hound - Cast Charge'),
('2055702','20557','0','0','100','1','7400','11600','12900','18900','11','36406 ','1','0','0','0','0','0','0','0','0','0','Wrath Hound - Cast Double Breath'), -- 36406  38361 41437  
(2055703,20557,6,0,100,0,0,0,0,0,11,40828,0,3,0,0,0,0,0,0,0,0,'Banished - Cast Credit on Master on Death');

-- Fel Rager 22286
UPDATE `creature_template` SET `armor`='6800',`dmgschool`='2',`resistance2`='-1' WHERE `entry` = 22286;

-- Wrath Reaver 22196 inacive
UPDATE `creature_template` SET `speed`='2',`mindmg`='1000',`maxdmg`='2000',`unit_flags`='32834',`mechanic_immune_mask`='1073741823',`flags_extra`='2' WHERE `entry` = 22196;

-- Vile Fire-Soul
UPDATE `creature_template` SET `AIName`='EventAI',`dmgschool`='2',`resistance2`='-1' WHERE `entry` = 22298;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22298;
INSERT INTO `creature_ai_scripts` VALUES
(2229801,22298,0,0,100,0,0,0,0,0,21,1,0,0,0,0,0,0,0,0,0,0,'Vile Fire-Soul - Stop Movement on Aggro'),
(2229802,22298,4,0,100,0,0,0,0,0,11,9053,1,0,22,1,0,0,0,0,0,0,'Vile Fire-Soul - Cast Fireball and Set Phase 1 on Aggro'),
(2229803,22298,0,13,100,1,3000,4000,3000,4000,11,9053,1,0,0,0,0,0,0,0,0,0,'Vile Fire-Soul - Cast Fireball (Phase 1)'),
(2229804,22298,3,13,100,0,15,0,0,0,21,1,0,0,22,2,0,0,0,0,0,0,'Vile Fire-Soul - Start Movement and Set Phase 2 when Mana is at 15%'),
(2229805,22298,9,13,100,1,25,80,0,0,21,1,0,0,0,0,0,0,0,0,0,0,'Vile Fire-Soul - Start Movement Beyond 25 Yards'),
(2229806,22298,3,11,100,1,100,30,100,100,22,1,0,0,0,0,0,0,0,0,0,0,'Vile Fire-Soul - Set Phase 1 when Mana is above 30% (Phase 2)'),
(2229807,22298,2,0,100,0,15,0,0,0,22,3,0,0,0,0,0,0,0,0,0,0,'Vile Fire-Soul - Set Phase 3 at 15% HP'),
(2229808,22298,2,7,100,0,15,0,0,0,21,1,0,0,25,0,0,0,1,-47,0,0,'Vile Fire-Soul - Start Movement and Flee at 15% HP (Phase 3)'),
(2229809,22298,7,0,100,0,0,0,0,0,22,0,0,0,0,0,0,0,0,0,0,0,'Vile Fire-Soul - On Evade set Phase to 0');

-- Aether Ray 22181
-- mob_aetherray
-- UPDATE `creature_template` SET  WHERE `entry` = '22181';

-- Bladespine Basilisk 22187
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = '22187';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22187';
INSERT INTO `creature_ai_scripts` VALUES
('2218701','22187','9','0','100','0','0','40','0','0','11','35385','1','0','0','0','0','0','0','0','0','0','Bladespine Basilisk - Cast Threshalisk Charge on Range'),
('2218702','22187','9','0','100','1','5','30','15000','25000','11','35313','1','32','0','0','0','0','0','0','0','0','Bladespine Basilisk - Cast Hypnotic Gaze');

-- Deathlash Stinger 22257
UPDATE `creature_template` SET `faction_A`='90',`faction_H`='90',`maxlevel`='72',`AIName`='EventAI' WHERE `entry` = '22257'; -- 73 16
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22257';
INSERT INTO `creature_ai_scripts` VALUES
('2225701','22257','9','0','100','1','0','5','5000','10000','11','5416','1','0','0','0','0','0','0','0','0','0','Deathlash Stinger - Cast Venom Sting'),
('2225702','22257','2','0','100','0','95','90','0','0','11','33962','0','0','0','0','0','0','0','0','0','0','Deathlash Stinger - Cast Toughen I at 95% HP'),
('2225703','22257','2','0','100','0','90','80','0','0','11','33962','0','0','0','0','0','0','0','0','0','0','Deathlash Stinger - Cast Toughen I at 90% HP'),
('2225704','22257','2','0','100','0','80','70','0','0','11','33962','0','0','0','0','0','0','0','0','0','0','Deathlash Stinger - Cast Toughen II at 80% HP'),
('2225705','22257','2','0','100','0','70','60','0','0','11','33962','0','0','0','0','0','0','0','0','0','0','Deathlash Stinger - Cast Toughen III at 70% HP'),
('2225706','22257','2','0','100','0','60','50','0','0','11','33962','0','0','0','0','0','0','0','0','0','0','Deathlash Stinger - Cast Toughen IV at 60% HP'),
('2225707','22257','2','0','100','0','50','40','0','0','11','33962','0','0','0','0','0','0','0','0','0','0','Deathlash Stinger - Cast Toughen V at 50% HP'),
('2225708','22257','2','0','100','0','40','30','0','0','11','33962','0','0','0','0','0','0','0','0','0','0','Deathlash Stinger - Cast Toughen VI at 40% HP'),
('2225709','22257','2','0','100','0','30','20','0','0','11','33962','0','0','0','0','0','0','0','0','0','0','Deathlash Stinger - Cast Toughen VII at 30% HP'),
('2225710','22257','2','0','100','0','20','10','0','0','11','33962','0','0','0','0','0','0','0','0','0','0','Deathlash Stinger - Cast Toughen VIII at 20% HP'),
('2225711','22257','2','0','100','0','10','0','0','0','11','33962','0','0','0','0','0','0','0','0','0','0','Deathlash Stinger - Cast Toughen IX at 10% HP');

-- Wrath Corruptor 22254
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22254';
INSERT INTO `creature_ai_scripts` VALUES
('2225401','22254','1','0','100','0','0','0','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Wrath Corruptor - Prevent Combat Movement on Spawn'),
('2225402','22254','4','0','100','0','0','0','0','0','11','9613','1','0','23','1','0','0','0','0','0','0','Wrath Corruptor - Cast Shadow Bolt and Set Phase 1 on Aggro'),
('2225403','22254','9','13','100','1','0','40','3000','3800','11','9613','1','0','0','0','0','0','0','0','0','0','Wrath Corruptor - Cast Shadow Bolt (Phase 1)'),
('2225404','22254','3','13','100','0','15','0','0','0','21','1','0','0','23','1','0','0','0','0','0','0','Wrath Corruptor - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)'),
('2225405','22254','9','13','100','1','35','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Wrath Corruptor - Start Combat Movement at 35 Yards (Phase 1)'),
('2225406','22254','9','13','100','1','5','15','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Wrath Corruptor - Prevent Combat Movement at 15 Yards (Phase 1)'),
('2225407','22254','9','13','100','1','0','5','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Wrath Corruptor - Start Combat Movement Below 5 Yards'),
('2225408','22254','3','11','100','1','100','30','1000','1000','23','-1','0','0','0','0','0','0','0','0','0','0','Wrath Corruptor - Set Phase 1 when Mana is above 30% (Phase 2)'),
('2225409','22254','0','0','100','1','2700','4200','9000','10000','11','32063','4','32','0','0','0','0','0','0','0','0','Wrath Corruptor - Cast Corruption'),
('2225410','22254','2','0','100','0','15','0','0','0','22','3','0','0','0','0','0','0','0','0','0','0','Wrath Corruptor - Set Phase 3 at 15% HP'),
('2225411','22254','2','7','100','0','15','0','0','0','21','1','0','0','25','0','0','0','1','-47','0','0','Wrath Corruptor - Start Combat Movement and Flee at 15% HP (Phase 3)'),
('2225412','22254','7','0','100','0','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Wrath Corruptor - Set Phase to 0 on Evade'),
('2225413','22254','10','0','100','1','1','30','15000','45000','11','36274','0','32','0','0','0','0','0','0','0','0','Wrath Corruptor - Cast Mad Seduced OOC normally on the animals');
DELETE FROM `spell_script_target` WHERE `entry` = 36274;
INSERT INTO `spell_script_target` VALUES (36274,1,22257);

-- Apexis Flayer 22175
-- UPDATE `creature_template` SET  WHERE `entry` = '22175';

-- Spire Needler 22194
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = '22194';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22194';
INSERT INTO `creature_ai_scripts` VALUES
('2219401','22194','9','0','100','1','0','30','4000','8000','11','35331','4','32','0','0','0','0','0','0','0','0','Spire Needler - Cast Black Blood');

-- Gan'arg Analyzer 23386 

-- Sai'kkal the Elder 22932 

-- Hemathion 18692
UPDATE `creature_template` SET `speed`='2',`mindmg`='2035',`maxdmg`='2068',`resistance2`='-1',`InhabitType`='5',`mechanic_immune_mask`='648232959' WHERE `entry` = '18692'; -- 734 800 -- 4,070 - 4,136
DELETE FROM `creature_template_addon` WHERE `entry` = 18692;
INSERT INTO `creature_template_addon` VALUES
(18692,0,0,16908544,0,4097,0,0,NULL);   -- 33555456
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '18692';
INSERT INTO `creature_ai_scripts` VALUES
(1869201,18692,0,0,100,1,5000,6000,12000,16000,11,9573,1,0,0,0,0,0,0,0,0,0,'Hemathion - Cast Flame Breath'),
(1869202,18692,0,0,100,1,10000,10000,15000,15000,11,14100,0,1,0,0,0,0,0,0,0,0,'Hemathion - Cast Terrifying Roar'),
(1869203,18692,12,0,100,1,20,0,5000,10000,11,38895,1,0,0,0,0,0,0,0,0,0,'Hemathion - Cast Devour');

-- Rivendark 23061
UPDATE `creature_template` SET `speed`='2',`mindmg`='3461',`maxdmg`='4111',`resistance2`='-1',`MovementType`='0',`InhabitType`='5',`mechanic_immune_mask`='648232959' WHERE `entry` = '23061'; -- 622 1272 -- 3461 - 4111
DELETE FROM `creature_template_addon` WHERE `entry` = 23061;
INSERT INTO `creature_template_addon` VALUES
(23061,0,0,16908544,0,4097,0,0,NULL);   -- 33555456
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23061';
INSERT INTO `creature_ai_scripts` VALUES
(2306101,23061,0,0,100,1,2500,5500,8000,12000,11,40505,1,0,0,0,0,0,0,0,0,0,'Rivendark - Cast Cleave'),
(2306102,23061,0,0,100,1,8000,12000,15000,25000,11,36922,0,0,0,0,0,0,0,0,0,0,'Rivendark - Cast Bellowing Roar'), -- 2
(2306103,23061,0,0,100,1,5000,6000,12000,18000,11,9573,1,7,0,0,0,0,0,0,0,0,'Rivendark - Cast Flame Breath'),
(2306104,23061,9,0,100,1,0,30,4000,8000,11,15847,0,0,0,0,0,0,0,0,0,0,'Rivendark - Cast Tail Sweep'), -- 0 0 -> 1 8
(2306105,23061,0,0,100,1,5000,15000,10000,12000,11,41988,4,32,0,0,0,0,0,0,0,0,'Rivendark - Cast Corruption'),
(2306106,23061,4,0,100,0,0,0,0,0,1,-23061,-23062,-23064,0,0,0,0,0,0,0,0,'Rivendark - Say on Aggro'),
(2306107,23061,9,0,100,1,20,40,15000,15000,11,40032,1,7,0,0,0,0,0,0,0,0,'Rivendark - Cast Fiery Breath');

-- Obsidia 23282
UPDATE `creature_template` SET `speed`='2',`mindmg`='3461',`maxdmg`='4111',`resistance2`='-1',`MovementType`='0',`InhabitType`='5',`mechanic_immune_mask`='648232959' WHERE `entry` = '23282';
DELETE FROM `creature_template_addon` WHERE `entry` = 23282;
INSERT INTO `creature_template_addon` VALUES
(23282,0,0,16908544,0,4097,0,0,NULL);   -- 33555456
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23282';
INSERT INTO `creature_ai_scripts` VALUES
(2328201,23282,0,0,100,1,2500,5500,8000,12000,11,40505,1,0,0,0,0,0,0,0,0,0,'Obsidia - Cast Cleave'),
(2328202,23282,0,0,100,1,8000,12000,15000,25000,11,36922,0,0,0,0,0,0,0,0,0,0,'Obsidia - Cast Bellowing Roar'),
(2328203,23282,0,0,100,1,5000,6000,12000,18000,11,9573,1,7,0,0,0,0,0,0,0,0,'Obsidia - Cast Flame Breath'),
(2328204,23282,9,0,100,1,0,30,4000,8000,11,15847,0,0,0,0,0,0,0,0,0,0,'Obsidia - Cast Tail Sweep'),
(2328205,23282,0,0,100,1,13500,15000,15000,25000,11,40717,0,0,0,0,0,0,0,0,0,0,'Obsidia - Cast Hellfire'),
(2328206,23282,4,0,100,0,0,0,0,0,1,-23063,-23065,-23066,0,0,0,0,0,0,0,0,'Obsidia - Say on Aggro'),
(2328207,23282,9,0,100,1,20,40,15000,15000,11,40032,1,7,0,0,0,0,0,0,0,0,'Obsidia - Cast Fiery Breath');

-- Insidion 23281
UPDATE `creature_template` SET `speed`='2',`mindmg`='3461',`maxdmg`='4111',`resistance2`='-1',`MovementType`='0',`InhabitType`='5',`mechanic_immune_mask`='648232959' WHERE `entry` = '23281';
DELETE FROM `creature_template_addon` WHERE `entry` = 23281;
INSERT INTO `creature_template_addon` VALUES
(23281,0,0,16908544,0,4097,0,0,NULL);   -- 33555456
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23281';
INSERT INTO `creature_ai_scripts` VALUES
(2328101,23281,0,0,100,1,2500,5500,8000,12000,11,40505,1,0,0,0,0,0,0,0,0,0,'Insidion - Cast Cleave'),
(2328102,23281,0,0,100,1,8000,12000,15000,25000,11,36922,0,0,0,0,0,0,0,0,0,0,'Insidion - Cast Bellowing Roar'),
(2328103,23281,0,0,100,1,5000,6000,12000,18000,11,9573,1,7,0,0,0,0,0,0,0,0,'Insidion - Cast Flame Breath'),
(2328104,23281,9,0,100,1,0,30,4000,8000,11,15847,0,0,0,0,0,0,0,0,0,0,'Insidion - Cast Tail Sweep'),
(2328105,23281,9,0,100,1,0,100,5000,10000,11,40719,1,0,0,0,0,0,0,0,0,0,'Insidion - Cast Flame Buffet'),
(2328106,23281,4,0,100,0,0,0,0,0,1,-23062,-23064,-23066,0,0,0,0,0,0,0,0,'Insidion - Say on Aggro'),
(2328107,23281,9,0,100,1,20,40,15000,15000,11,40032,1,7,0,0,0,0,0,0,0,0,'Insidion - Cast Fiery Breath');

-- Furywing 23261
UPDATE `creature_template` SET `speed`='2',`mindmg`='3461',`maxdmg`='4111',`resistance2`='-1',`MovementType`='0',`InhabitType`='5',`mechanic_immune_mask`='648232959' WHERE `entry` = '23261'; -- 622 all type flag 8+32 which is unkown -- 3,461 - 4,111
DELETE FROM `creature_template_addon` WHERE `entry` = 23261;
INSERT INTO `creature_template_addon` VALUES
(23261,0,0,16908544,0,4097,0,0,NULL);   -- 33555456
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23261';
INSERT INTO `creature_ai_scripts` VALUES
(2326101,23261,0,0,100,1,2500,5500,8000,12000,11,40505,1,0,0,0,0,0,0,0,0,0,'Furywing - Cast Cleave'),
(2326102,23261,0,0,100,1,8000,12000,15000,25000,11,36922,0,0,0,0,0,0,0,0,0,0,'Furywing - Cast Bellowing Roar'),
(2326103,23261,0,0,100,1,5000,6000,12000,18000,11,9573,1,7,0,0,0,0,0,0,0,0,'Furywing - Cast Flame Breath'),
(2326104,23261,9,0,100,1,0,30,4000,8000,11,15847,0,0,0,0,0,0,0,0,0,0,'Furywing - Cast Tail Sweep'),
(2326105,23261,0,0,100,1,13500,15000,15000,25000,11,41572,1,0,0,0,0,0,0,0,0,0,'Furywing - Cast Wing Buffet'),
(2326106,23261,4,0,100,0,0,0,0,0,1,-23062,-23064,-23066,0,0,0,0,0,0,0,0,'Furywing - Say on Aggro'),
(2326107,23261,9,0,100,1,20,40,15000,15000,11,40032,1,7,0,0,0,0,0,0,0,0,'Furywing - Cast Fiery Breath');

-- Apexis Guardian 22275
UPDATE `creature_template` SET `mindmg`='1900',`maxdmg`='2600',`AIName`='EventAI',`mechanic_immune_mask`='619396095' WHERE `entry` = '22275'; -- 5,193 - 6,167
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22275';
INSERT INTO `creature_ai_scripts` VALUES
(2227501,22275,9,0,100,1,5,30,4000,8000,11,40843,4,0,0,0,0,0,0,0,0,0,'Apexis Guardian - Cast Throw'),
(2227502,22275,0,0,100,1,5000,10000,7000,21000,11,40846,4,32,0,0,0,0,0,0,0,0,'Apexis Guardian - Cast Crystal Prison');

-- Galvanoth 22281
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='3210',`maxdmg`='3811',`AIName`='EventAI',`mechanic_immune_mask`='619396095',`spell1`='15708',`spell2`='38750',`spell3`='39139' WHERE `entry` = '22281'; -- 577 1178 -- 1200 - 1400 -- 3,210 - 3,811
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22281';
INSERT INTO `creature_ai_scripts` VALUES
(2228101,22281,9,0,100,1,0,5,10000,15000,11,15708,1,0,0,0,0,0,0,0,0,0,'Galvanoth - Cast Mortal Strike'),
(2228102,22281,0,0,100,1,4000,8000,10000,15000,11,38750,0,0,0,0,0,0,0,0,0,0,'Galvanoth - Cast Warstomp'),
(2228103,22281,0,0,100,1,2500,5500,15000,25000,11,39139,1,1,0,0,0,0,0,0,0,0,'Galvanoth - Cast Flame Strike');

-- Braxxus 23353
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='2140',`maxdmg`='2541',`AIName`='EventAI',`mechanic_immune_mask`='619396095' WHERE `entry` = '23353'; -- 1284 1524 -- 3,210 - 3,811
UPDATE `creature_model_info` SET `bounding_radius`='9',`combat_reach`='9' WHERE `modelid` = 21150;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23353';
INSERT INTO `creature_ai_scripts` VALUES
(2335301,23353,0,0,100,1,5000,10000,12000,18000,11,41437,1,0,0,0,0,0,0,0,0,0,'Braxxus - Casts Double Breath'),
(2335302,23353,9,0,100,1,0,5,8000,12000,11,41439,4,32,0,0,0,0,0,0,0,0,'Braxxus - Casts Mangle'),
(2335303,23353,0,0,100,1,10000,10000,15000,25000,11,41436,0,0,0,0,0,0,0,0,0,0,'Braxxus - Casts Panic');

-- Mo'arg Incinerator 23354
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='2140',`maxdmg`='2541',`AIName`='EventAI',`mechanic_immune_mask`='619396095' WHERE `entry` = '23354';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23354';
INSERT INTO `creature_ai_scripts` VALUES
(2335401,23354,9,0,100,1,0,5,8000,12000,11,25174,1,0,0,0,0,0,0,0,0,0,'Incinerator - Casts Sundering Cleave'),
(2335402,23354,0,0,100,1,6000,6000,12000,16000,11,44431,0,0,0,0,0,0,0,0,0,0,'Incinerator - Casts Acid Geyser'),
(2335403,23354,9,0,100,0,0,60,0,0,11,36606,1,0,0,0,0,0,0,0,0,0,'Incinerator - Casts Chaos Charge in Range');

-- Zarcsin 23355
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='2140',`maxdmg`='2541',`AIName`='EventAI',`mechanic_immune_mask`='619396095',`equipment_id`='1548' WHERE `entry` = '23355';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '23355';
INSERT INTO `creature_ai_scripts` VALUES
(2335501,23355,4,0,100,0,0,0,0,0,11,29651,0,7,1,-9901,0,0,0,0,0,0,'Zarcsin  - Cast Dual Wield on Aggro'),
(2335502,23355,2,0,100,0,50,0,0,0,11,41447,0,7,1,-106,0,0,0,0,0,0,'Zarcsin - Casts Enrage at 50% HP'),
(2335503,23355,0,0,100,1,5000,6000,12000,13000,11,41444,0,0,0,0,0,0,0,0,0,0,'Zarcsin - Casts Fel Flames');

-- Wrangled Aether Ray 23343
UPDATE `creature_template` SET `speed`='1.20',`InhabitType`='7' WHERE `entry` = 23343; -- 3

-- Felguard Degrader 23055
UPDATE `creature_template` SET `faction_A`='90',`faction_H`='90',`speed`='1.71',`equipment_id`='8043' WHERE `entry` = 23055; -- 35
DELETE FROM `creature_equip_template` WHERE `entry` = 8043;
INSERT INTO `creature_equip_template` VALUES
(8043,19741,0,0,50267138,0,0,781,0,0);

-- The Grand Collector 23333
UPDATE `creature_template` SET `speed`='2',`mindmg`='2568',`maxdmg`='3048',`unit_flags`='0',`type_flags`='0',`skinloot`='0',`flags_extra`='0' WHERE `entry` = '23333'; -- 1154 2356 -- 6,419 - 7,621 -- 80004
-- Bash'ir's Harbinger 23390
UPDATE `creature_template` SET `speed`='2',`mindmg`='3209',`maxdmg`='3811' WHERE `entry` = '23390'; -- 577 1179 -- 3,209 - 3,811
-- Bash'ir 23391
UPDATE `creature_template` SET `faction_A`='91',`faction_H`='91',`speed`='2',`mindmg`='3210',`maxdmg`='3811',`lootid`='23391' WHERE `entry` = '23391'; -- 577 1178 --  3,210 - 3,811

-- Witness of Doom
UPDATE `creature_template` SET `speed`='1.71',`AIName`='EventAI' WHERE `entry` = 22282;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '22282';
INSERT INTO `creature_ai_scripts` VALUES
('2228201','22282','4','0','100','0','0','0','0','0','25','0','0','0','1','-48','0','0','0','0','0','0','Witness of Doom - Flee and Emote on Aggro'),
('2228202','22282','0','0','100','1','10000','10000','1000','1000','41','0','0','0','0','0','0','0','0','0','0','0','Witness of Doom - Despawn IC'),
('2228203','22282','6','0','100','0','0','0','0','0','11','40828','0','3','0','0','0','0','0','0','0','0','Banished - Cast Credit on Master on Death');

-- Searing Elemental (Fire Elemental)
UPDATE `creature_template` SET `resistance2` = -1 WHERE `entry` = 20514;

DELETE FROM `creature` WHERE `guid` IN (78793,78794,170436);
INSERT INTO `creature` VALUES (78793, 22443, 530, 1, 0, 0, 2227.46, 5484.32, 153.773, 1.15192, 300, 0, 0, 7850, 0, 0, 0);
INSERT INTO `creature` VALUES (78794, 22443, 530, 1, 0, 0, 1931.44, 5330.76, 154.176, 2.86234, 300, 0, 0, 7850, 0, 0, 0);

-- https://trinitycore.atlassian.net/wiki/display/tc/creature_template
-- no kill credit stealing  2097152 makes creatures dummys
UPDATE `creature_template` SET `flags_extra`='2' WHERE `entry` IN ('22478');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('22478');
INSERT INTO `creature_ai_scripts` VALUES
('2247801','22478','0','0','100','1','8000','8000','12000','12000','11','39274','1','0','0','0','0','0','0','0','0','0','Evergrove Ancient - Cast Trample'),
('2247802','22478','11','0','100','1','0','0','0','0','11','39274','0','1','0','0','0','0','0','0','0','0','Evergrove Ancient - Cast Trample on Spawn'),
('2247803','22478','1','0','100','1','30000','30000','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Evergrove Ancient - Despawn OCC');

-- Baelmon the Hound-Master
UPDATE `creature_template` SET `mechanic_immune_mask`='8389713',`mindmg`='1037',`maxdmg`='1229',`baseattacktime`='1400' WHERE `entry` = 19747; -- 1,556 - 1,844
DELETE FROM `creature_ai_scripts` WHERE `id` IN ('1974706');
INSERT INTO `creature_ai_scripts` VALUES
('1974706','19747','4','0','100','2','0','0','0','0','1','-9907','-9906','-9905','28','0','39218','0','0','0','0','0','Baelmon the Hound-Master - Random Say and Stop Channeling on Aggro');
UPDATE `creature_ai_scripts` SET `action2_type`='1',`action2_param1`='-9904',`event_param1`='50',`event_flags`='1',`event_param3`='30000',`event_param4`='30000',`action1_param3`='33',`comment`='Baelmon the Hound-Master - Summon Wrath Hound at 50% HP' WHERE `id` IN ('1974703');
UPDATE `creature_ai_scripts` SET `action1_param2`='4',`action1_param3`='32' WHERE `id` IN ('1974704','1974705');

-- Lesser Wrath Hound
UPDATE `creature_template` SET `faction_A`='90',`faction_H`='90' WHERE `entry` IN ('22499');
DELETE FROM `creature_ai_scripts` WHERE `id` IN ('2249902');
INSERT INTO `creature_ai_scripts` VALUES
('2249902','22499','1','0','100','1','1000','1000','0','0','103','10','0','0','0','0','0','0','0','0','0','0','Lesser Wrath Hound - Startattack OCC');

-- Death's Door Fel Cannon Target Bunny
UPDATE `creature` SET `position_x` = 2195.8024, `position_y` = 5475.7568, `position_z` = 163.7464, `orientation` = 0.2682,`spawndist`='0',`movementtype`='0',`spawntimesecs`='1' WHERE `guid` = 78947;
-- UPDATE `creature_template` SET `flags_extra` = 130, `faction_A` = 35, `faction_H` = 35 WHERE `entry` = 22495; -- 35 130

-- Blade's Edge - Legion - Invis Bunny
UPDATE `creature_template` SET `AIName` = 'EventAI', `InhabitType` = 5, `flags_extra`=130 WHERE `entry` = 20736;

-- Death's Door North Warp-Gate
UPDATE `creature` SET `position_x` = '2196.6601', `position_y` = '5474.8798', `position_z` = '153.5782', `spawntimesecs` = 60 WHERE `guid` = 78881;
UPDATE `creature_template` SET `mindmg` = 1, `maxdmg` = 1, `AIName` = 'EventAI', `flags_extra`= 2 WHERE `entry` = 22471; -- 202 350

-- Death's Door South Warp-Gate
UPDATE `creature` SET `position_x` = '1968.8369', `position_y` = '5316.9965', `position_z` = '154.0295', `spawntimesecs` = 60 WHERE `guid` = 78882;
UPDATE `creature_template` SET `mindmg` = 1, `maxdmg` = 1, `AIName` = 'EventAI', `flags_extra`= 2 WHERE `entry` = 22472; -- 202 350

-- Void Hound
UPDATE `creature_template` SET `modelid_A` = 17188, `modelid_H` = 17188 WHERE `entry` = 22500;

-- AIs
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN (20736,22471,22472);
INSERT INTO `creature_ai_scripts` VALUES (2073601, 20736, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Blade\'s Edge - Legion - Invis Bunny - Disable Melee on Aggro');
INSERT INTO `creature_ai_scripts` VALUES (2247101, 22471, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Death\'s Door North Warp-Gate - Invis Bunny - Disable Melee on Aggro');
INSERT INTO `creature_ai_scripts` VALUES (2247201, 22472, 4, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Death\'s Door South Warp-Gate - Invis Bunny - Disable Melee on Aggro');

-- ======================================================
-- Visuals & Positioning & Movement
-- ======================================================

-- General
UPDATE creature SET MovementType = 0, spawndist = 0 WHERE guid = 71424;

-- Canons
UPDATE `creature` SET `orientation` = '5.8660', `spawntimesecs` = 60 WHERE `guid` = 78794;
UPDATE `creature` SET `orientation` = '3.3174', `spawntimesecs` = 60 WHERE `guid` = 78793;

UPDATE creature SET position_x = 3732.81, position_y = 4810.64, position_z = 250.242, orientation = 3.94357 WHERE guid = 72651;
UPDATE creature SET position_x = 1567.21, position_y = 6300.45, position_z = 3.92716, orientation = 1.57909 WHERE guid = 71174;
UPDATE creature SET position_x = 3482.38, position_y = 5011.42, position_z = 265.417, orientation = 4.52083 WHERE guid = 73675;
UPDATE creature SET position_x = 5006.45, position_y = 5006.45, position_z = 265.857, orientation = 4.21061 WHERE guid = 73673;
-- UPDATE creature SET orientation = 0.955641 WHERE guid = 77873;
UPDATE creature SET position_x = 3828.99, position_y = 6659.73, position_z = 169.658, orientation = 5.54995, MovementType = 0, spawndist = 0 WHERE guid = 71356;
-- UPDATE creature SET position_x = 3778.11, position_y = 6706.03, position_z = 138.19, orientation = 2.89689 WHERE guid = 71355;
UPDATE creature SET position_x = 3775.24, position_y = 6719.76, position_z = 137.539, orientation = 3.8433 WHERE guid = 71332;
UPDATE creature SET position_x = 3789.1, position_y = 6649.72, position_z = 159.939, orientation = 3.73333 WHERE guid = 71354;
-- tdb to change to aether ray 
UPDATE `creature` SET `position_x`='2091.4001', `position_y`='7382.1337', `position_z`='372.5668' WHERE `guid` = '78229';
UPDATE `creature` SET `position_x`='3877.0700', `position_y`='5943.6000', `position_z`='270.9162' WHERE `guid` = '78249';
UPDATE `creature` SET `position_x`='3899.0600', `position_y`='5968.0800', `position_z`='269.8273' WHERE `guid` = '78250';
UPDATE `creature` SET `position_x`='4041.4599', `position_y`='5970.7900', `position_z`='267.9311' WHERE `guid` = '78255';
UPDATE `creature` SET `position_x`='4002.8999', `position_y`='5996.7900', `position_z`='268.1863' WHERE `guid` = '78256';
UPDATE `creature` SET `position_x`='3917.2800', `position_y`='6008.1801', `position_z`='270.4826' WHERE `guid` = '78257';
UPDATE `creature` SET `position_x`='4006.6799', `position_y`='6042.7001', `position_z`='264.7456' WHERE `guid` = '78258';
UPDATE `creature` SET `position_x`='3952.7900', `position_y`='6078.6699', `position_z`='269.2231' WHERE `guid` = '78259';
UPDATE `creature` SET `position_x`='3905.1000', `position_y`='6107.3500', `position_z`='269.9914' WHERE `guid` = '78260';
UPDATE `creature` SET `position_x`='2754.2766', `position_y`='5808.5102', `position_z`='-7.1871', `orientation`='1.5129',`spawndist`='0',`movementtype`='0' WHERE `guid` = '100257';
--
UPDATE `creature` SET `position_x`='2742.7646', `position_y`='7263.2812', `position_z`='368.5848', `orientation`='1.5409',`spawndist`='5',`movementtype`='1' WHERE `guid` = '12859';
UPDATE `creature` SET `position_x`='2747.8618', `position_y`='7298.2163', `position_z`='368.5848', `orientation`='3.1510',`spawndist`='5',`movementtype`='1' WHERE `guid` = '51611';
UPDATE `creature` SET `position_x`='2709.1252', `position_y`='7303.5361', `position_z`='368.5854', `orientation`='4.6864',`spawndist`='5',`movementtype`='1' WHERE `guid` = '48038';
UPDATE `creature` SET `position_x`='2704.1682', `position_y`='7271.0244', `position_z`='368.5840', `orientation`='6.1223',`spawndist`='5',`movementtype`='1' WHERE `guid` = '28456';
UPDATE `creature` SET `position_x`='2122.2214', `position_y`='7106.7392', `position_z`='364.7709', `orientation`='3.0630',`spawndist`='5',`movementtype`='1' WHERE `guid` = '84226';
UPDATE `creature` SET `position_x`='2084.7136', `position_y`='7102.7553', `position_z`='364.7718', `orientation`='1.5550',`spawndist`='5',`movementtype`='1' WHERE `guid` = '84228';
UPDATE `creature` SET `position_x`='2080.6015', `position_y`='7137.5776', `position_z`='364.7713', `orientation`='0.0510',`spawndist`='5',`movementtype`='1' WHERE `guid` = '84236';
UPDATE `creature` SET `position_x`='2117.1728', `position_y`='7141.8442', `position_z`='364.7713', `orientation`='4.6691',`spawndist`='5',`movementtype`='1' WHERE `guid` = '84237';
UPDATE `creature` SET `position_x`='1950.2333', `position_y`='7344.6245', `position_z`='364.4700', `orientation`='3.1627',`spawndist`='5',`movementtype`='1' WHERE `guid` = '84238'; 
UPDATE `creature` SET `position_x`='1911.2104', `position_y`='7339.8510', `position_z`='364.4711', `orientation`='1.5291',`spawndist`='5',`movementtype`='1' WHERE `guid` = '84703';
UPDATE `creature` SET `position_x`='1907.1466', `position_y`='7375.6025', `position_z`='364.4706', `orientation`='6.1394',`spawndist`='5',`movementtype`='1' WHERE `guid` = '84704';
UPDATE `creature` SET `position_x`='1946.1286', `position_y`='7378.9438', `position_z`='364.4708', `orientation`='4.8160',`spawndist`='5',`movementtype`='1' WHERE `guid` = '84706';
UPDATE `creature` SET `spawndist`='5',`movementtype`='1' WHERE `guid` IN (51613,51612,51614,51615,55133,82671,53047,53046,53047,84232,84233,84705,84702);
--
UPDATE `creature` SET `position_x`='2548.5935', `position_y`='7331.4287', `position_z`='373.4237', `orientation`='4.2454',`spawndist`='0',`movementtype`='0' WHERE `guid` = '44255';
DELETE FROM `creature_addon` WHERE `guid` = 44255;
INSERT INTO `creature_addon` VALUES (44255,0,21152,0,0,4097,0,0,'');
--
UPDATE `creature` SET `spawndist`='10',`MovementType`='1' WHERE `id` IN (19973,20557);
--
-- eyes 
UPDATE `creature` SET `position_x`='2914.7097', `position_y`='6825.4423', `position_z`='364.5552', `orientation`='1.3445',`spawndist`='30',`movementtype`='1' WHERE `guid` = '78317';
UPDATE `creature` SET `position_x`='3061.0886', `position_y`='6877.4321', `position_z`='364.2837', `orientation`='1.4123',`spawndist`='30',`movementtype`='1' WHERE `guid` = '78318';
UPDATE `creature` SET `position_x`='3035.4667', `position_y`='6964.9379', `position_z`='363.9218', `orientation`='3.5176',`spawndist`='30',`movementtype`='1' WHERE `guid` = '78319';
UPDATE `creature` SET `position_x`='2849.3425', `position_y`='6940.5717', `position_z`='365.2920', `orientation`='0.6827',`spawndist`='30',`movementtype`='1' WHERE `guid` = '78320';
UPDATE `creature` SET `position_x`='2877.4897', `position_y`='7084.7822', `position_z`='364.9580', `orientation`='2.2578',`spawndist`='30',`movementtype`='1' WHERE `guid` = '78321';
UPDATE `creature` SET `position_x`='2976.6188', `position_y`='7086.7958', `position_z`='364.1542', `orientation`='5.2758',`spawndist`='30',`movementtype`='1' WHERE `guid` = '78322';
UPDATE `creature` SET `position_x`='2984.4492', `position_y`='6815.9365', `position_z`='369.9805', `orientation`='4.9337',`spawndist`='30',`movementtype`='1' WHERE `guid` = '78323';
--
--
--
-- Pathing for  Entry: 17855 'ODB FORMAT' 
SET @GUID := 63550;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3022.651,`position_y`=5963.609,`position_z`=130.7766 WHERE `guid`=@GUID;
DELETE FROM `creature_addon` WHERE `guid`=@GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@GUID,1,3022.651,5963.609,130.7766,6000,0,0,100,0),
(@GUID,2,3032.096,5959.558,130.6869,6000,0,0,100,0);

-- Pathing for  Entry: 22410 'ODB FORMAT' 
DELETE FROM `creature` WHERE `guid` = 78755;  
DELETE FROM `creature_addon` WHERE `guid` = 78755;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (78755, 22410, 530, 1, 0, 0, 2992.1, 5882.41, 131.079, 1.09818, 300, 0, 0, 3700, 3155, 0, 2);
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (78755,78754,14332,0,4097,0, '');
SET @GUID := 78754;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3009.127,`position_y`=5920.842,`position_z`=130.9854 WHERE `guid`=@GUID;
DELETE FROM `creature_addon` WHERE `guid`=@GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,14332,0,4097,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@GUID,1,3009.127,5920.842,130.9854,0,1,0,100,0),
(@GUID,2,3018.56,5944.067,131.0012,0,1,0,100,0),
(@GUID,3,3028.687,5971.723,131.0047,0,1,0,100,0),
(@GUID,4,3039.209,5998.325,130.9491,0,1,0,100,0),
(@GUID,5,3041.459,6004.325,130.9491,0,1,0,100,0),
(@GUID,6,3042.709,6007.575,130.9491,0,1,0,100,0),
(@GUID,7,3043.459,6009.825,130.9491,0,1,0,100,0),
(@GUID,8,3048.21,6021.786,130.8358,0,1,0,100,0),
(@GUID,9,3058.211,6046.689,130.7168,0,1,0,100,0),
(@GUID,10,3065.155,6064.995,130.614,0,1,0,100,0),
(@GUID,11,3078.91,6073.112,130.3709,0,1,0,100,0),
(@GUID,12,3084.571,6056.194,130.4195,0,1,0,100,0),
(@GUID,13,3079.821,6040.444,130.6695,0,1,0,100,0),
(@GUID,14,3079.655,6040.126,130.764,0,1,0,100,0),
(@GUID,15,3079.405,6039.626,130.764,0,1,0,100,0),
(@GUID,16,3078.905,6038.126,130.764,0,1,0,100,0),
(@GUID,17,3069.25,6014.667,130.9082,0,1,0,100,0),
(@GUID,18,3064,6000.667,130.9082,0,1,0,100,0),
(@GUID,19,3060.452,5991.971,130.99,0,1,0,100,0),
(@GUID,20,3050.27,5967.535,130.9908,0,1,0,100,0),
(@GUID,21,3045.52,5954.535,130.9908,0,1,0,100,0),
(@GUID,22,3039.294,5938.282,130.9514,0,1,0,100,0),
(@GUID,23,3028.456,5913.517,130.8795,0,1,0,100,0),
(@GUID,24,3019.764,5891.665,130.7868,0,1,0,100,0),
(@GUID,25,3016.764,5884.415,130.7868,0,1,0,100,0),
(@GUID,26,3012.264,5873.915,130.7868,0,1,0,100,0),
(@GUID,27,3009.264,5866.915,130.7868,0,1,0,100,0),
(@GUID,28,3012.196,5873.788,130.7515,0,1,0,100,0),
(@GUID,29,3008.946,5866.788,130.7515,0,1,0,100,0),
(@GUID,30,3008.446,5865.038,130.7515,0,1,0,100,0),
(@GUID,31,2995.446,5836.038,130.5015,0,1,0,100,0),
(@GUID,32,2995.104,5835.657,130.3808,0,1,0,100,0),
(@GUID,33,2991.854,5828.407,130.6308,0,1,0,100,0),
(@GUID,34,2990.604,5827.907,130.3808,0,1,0,100,0),
(@GUID,35,2976.186,5821.571,130.1743,0,1,0,100,0),
(@GUID,36,2970.518,5837.316,130.481,0,1,0,100,0),
(@GUID,37,2971.768,5840.066,130.481,0,1,0,100,0),
(@GUID,38,2980.487,5859.262,131.0515,0,1,0,100,0),
(@GUID,39,2983.987,5866.762,131.0515,0,1,0,100,0),
(@GUID,40,2989.237,5876.512,131.3015,0,1,0,100,0);

SET @NPC := 73833;
SET @PATH := @NPC * 10;  
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 73833;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,16908544,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,'1560.0057','6814.2592','125.9330',0,0,0,100,0),
(@PATH,2,'1543.2507','6807.8037','122.9554',10000,0,0,100,0),
(@PATH,3,'1560.0057','6814.2592','125.9330',0,0,0,100,0),
(@PATH,4,'1583.1910','6824.8935','128.4384',0,0,0,100,0),
(@PATH,5,'1615.6489','6820.9194','130.5220',0,0,0,100,0),
(@PATH,6,'1643.9464','6811.3750','132.1697',0,0,0,100,0),
(@PATH,7,'1669.6838','6812.7114','134.3553',0,0,0,100,0),
(@PATH,8,'1705.7690','6828.5761','136.0150',0,0,0,100,0),
(@PATH,9,'1770.1423','6807.6308','137.2133',0,0,0,100,0),
(@PATH,10,'1796.1015','6806.2011','137.3799',0,0,0,100,0),
(@PATH,11,'1866.7496','6828.6577','143.4973',0,0,0,100,0),
(@PATH,12,'1921.3824','6837.2202','149.3398',0,0,0,100,0),
(@PATH,13,'1918.1480','6836.7924','148.6411',10000,0,0,100,0),
(@PATH,14,'1866.7496','6828.6577','143.4973',0,0,0,100,0),
(@PATH,15,'1796.1015','6806.2011','137.3799',0,0,0,100,0),
(@PATH,16,'1770.1423','6807.6308','137.2133',0,0,0,100,0),
(@PATH,17,'1705.7690','6828.5761','136.0150',0,0,0,100,0),
(@PATH,18,'1669.6838','6812.7114','134.3553',0,0,0,100,0),
(@PATH,19,'1643.9464','6811.3750','132.1697',0,0,0,100,0),
(@PATH,20,'1615.6489','6820.9194','130.5220',0,0,0,100,0),
(@PATH,21,'1583.1910','6824.8935','128.4384',0,0,0,0,0);
--
SET @GUID := 78694;
SET @POINT := 0;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@GUID,@POINT := @POINT + 1,'1501.4047','7177.1020','364.8366',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'1542.2263','7187.4453','363.7533',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'1558.0931','7236.4135','363.9824',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'1559.1157','7305.6469','364.4091',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'1529.4974','7334.1015','364.1177',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'1467.1242','7332.9423','363.9970',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'1402.5922','7310.8276','364.0789',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'1369.8989','7261.9033','364.3698',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'1405.0351','7189.0825','364.0041',0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,'1456.0393','7176.1972','365.1547',0,0,0,100,0);
--
UPDATE `creature` SET `position_x`='3868.8671', `position_y`='5777.7602', `position_z`='267.0777', `orientation`='0.7928',`spawndist`='5',`movementtype`='1' WHERE `guid` = '77881';
UPDATE `creature` SET `position_x`='3866.2773', `position_y`='5775.1318', `position_z`='267.1492', `orientation`='0.7928',`spawndist`='5',`movementtype`='1' WHERE `guid` = '77910';
UPDATE `creature` SET `position_x`='3943.0634', `position_y`='5727.0981', `position_z`='268.1709', `orientation`='4.6550',`spawndist`='5',`movementtype`='1' WHERE `guid` = '78317';
UPDATE `creature` SET `position_x`='3868.9838', `position_y`='5736.1850', `position_z`='266.6504', `orientation`='1.5531',`spawndist`='5',`movementtype`='1' WHERE `guid` = '78343';
UPDATE `creature` SET `position_x`='3888.9775', `position_y`='5770.6542', `position_z`='267.5713', `orientation`='1.9144',`spawndist`='0',`movementtype`='0' WHERE `guid` = '78804';
UPDATE `creature` SET `position_z`='266.1194' WHERE `guid` = '78806';
UPDATE `creature` SET `position_x`='3992.0195', `position_y`='5706.6997', `position_z`='272.0166', `orientation`='5.8257',`spawndist`='0',`movementtype`='0' WHERE `guid` = '78805';
UPDATE `creature` SET `position_z`='266.7215' WHERE `guid` = '78808';
UPDATE `creature` SET `spawndist`='0',`movementtype`='0' WHERE `guid` = '73897';
UPDATE `creature` SET `position_x`='3257.1613', `position_y`='4653.7358', `position_z`='214.6408', `orientation`='5.7349',`spawndist`='0',`movementtype`='0' WHERE `guid` = '527398';
--
--
--
--
-- ======================================================
-- Linking
-- ======================================================
--
DELETE FROM `creature_formations` WHERE `leaderguid` IN (78191,78190,78192,78189,78193,78194,78200,78199,78202,78201,78204,78203,78196,78195,63550,63549,63548,78754,78755);
DELETE FROM `creature_formations` WHERE `leaderguid` IN (78191,78190,78192,78189,78193,78194,78200,78199,78202,78201,78204,78203,78196,78195,63550,63549,63548,78754,78755);
INSERT INTO `creature_formations` VALUES
--
--
--
--
--
--
(78191,78191,100,360,1),
(78191,78190,5,0,1),
--
(78192,78192,100,360,1),
(78192,78189,5,0,1),
--
(78194,78194,100,360,1),
(78194,78193,5,0,1),
--
(78200,78200,100,360,1),
(78200,78199,5,0,1),
--
(78202,78202,100,360,1),
(78202,78201,5,0,1),
--
(78204,78204,100,360,1),
(78204,78203,5,0,1),
--
(78196,78196,100,360,1),
(78196,78195,5,0,1),
--
-- (78754,78754,100,360,1),
-- (78754,78755,7,0,1),
--
(63550,63550,100,360,2),
(63550,63549,3,1.1,2),
(63550,63548,3,4.1,2);
--
-- ======================================================
-- Respawn
-- ======================================================
--
--
-- ======================================================
-- Gameobjects
-- ======================================================
--
-- Dragon Eggs 185929,185930,185931
-- UPDATE `gameobject` SET `
--
--
-- Simon Say Ogrila big thx to Robin
DELETE FROM `gameobject` WHERE `guid` BETWEEN 100001 AND 100088;
DELETE FROM `gameobject` WHERE `guid` IN (28038,28036,28039,28035,28030,28034,28037,28031,28032,28033);
INSERT INTO `gameobject` VALUES (100088, 185805, 530, 1, 3888.66, 5119.85, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100087, 185806, 530, 1, 3891.52, 5116.98, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100086, 185731, 530, 1, 3888.72, 5117.06, 270.148, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100085, 185730, 530, 1, 3888.72, 5117.07, 270.148, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100084, 185804, 530, 1, 3885.8,  5117.02, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100083, 185728, 530, 1, 3888.72, 5117.05, 270.148, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100082, 185729, 530, 1, 3888.73, 5117.06, 270.148, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100081, 185807, 530, 1, 3888.71, 5114.23, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100080, 185890, 530, 1, 3888.72, 5117.07, 272.293, 0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100079, 185894, 530, 1, 3888.7,  5117.03, 270.255,  0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100078, 185794, 530, 1, 3895.19, 5102.03, 270.093, 3.14159, 0, 0, 1, 0, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100077, 185811, 530, 1, 3891.35, 5085.79, 270.093, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100076, 185808, 530, 1, 3888.48, 5083.15, 270.093, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100075, 185809, 530, 1, 3885.68, 5086.06, 270.093, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100074, 185732, 530, 1, 3888.6,  5085.98, 270.148, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100073, 185733, 530, 1, 3888.61, 5085.97, 270.148, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100072, 185734, 530, 1, 3888.61, 5085.97, 270.148, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100071, 185810, 530, 1, 3888.66, 5088.69, 270.093, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100070, 185735, 530, 1, 3888.61, 5085.97, 270.148, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100069, 185890, 530, 1, 3888.63, 5085.98, 272.139, 0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100068, 185894, 530, 1, 3888.66, 5085.99, 270.247, 0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100067, 185795, 530, 1, 3905.94, 5091.22, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100066, 185792, 530, 1, 3916.73, 5102.01, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100065, 185797, 530, 1, 3919.67, 5086.12, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100064, 185799, 530, 1, 3922.57, 5086.15, 270.148, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100063, 185800, 530, 1, 3922.57, 5086.16, 270.148, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100062, 185803, 530, 1, 3925.41, 5086.07, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100061, 185727, 530, 1, 3922.49, 5116.90, 270.148, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100060, 185791, 530, 1, 3922.47, 5114.02, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100059, 185725, 530, 1, 3922.5,  5116.89, 270.148, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100058, 185726, 530, 1, 3922.49, 5116.90, 270.148, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100057, 185724, 530, 1, 3922.5,  5116.89, 270.148, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100056, 185802, 530, 1, 3922.57, 5086.16, 270.148, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100055, 185798, 530, 1, 3922.55, 5088.85, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100054, 185796, 530, 1, 3922.56, 5083.36, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100053, 185801, 530, 1, 3922.57, 5086.15, 270.148, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100052, 185788, 530, 1, 3919.61, 5116.84, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100051, 185793, 530, 1, 3905.97, 5112.77, 270.093, 3.12414, 0, 0, 0.999962, 0.008727, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100050, 185789, 530, 1, 3922.44, 5119.64, 270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100049, 185790, 530, 1, 3925.29, 5116.8,  270.093, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100048, 185890, 530, 1, 3922.6,  5086.17, 272.588, 0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100047, 185894, 530, 1, 3922.53, 5086.17, 270.25, 0, 0, 0, 0, 1, 180, 100, 1); 
INSERT INTO `gameobject` VALUES (100046, 185890, 530, 1, 3922.49, 5116.93, 272.559, 0, 0, 0, 0, 1, 180, 100, 1); 
INSERT INTO `gameobject` VALUES (100045, 185894, 530, 1, 3922.51, 5116.9,  270.238, 0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100044, 185805, 530, 1, 2708.96, 7301.26, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100043, 185806, 530, 1, 2711.82, 7298.39, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100042, 185731, 530, 1, 2709.02, 7298.47, 368.583, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100041, 185730, 530, 1, 2709.02, 7298.48, 368.583, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100040, 185804, 530, 1, 2706.1,  7298.43, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100039, 185728, 530, 1, 2709.02, 7298.46, 368.583, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100038, 185729, 530, 1, 2709.03, 7298.47, 368.583, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100037, 185807, 530, 1, 2709.01, 7295.64, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100036, 185890, 530, 1, 2709.02, 7298.48, 370.728, 0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100035, 185894, 530, 1, 2709.00, 7298.44, 368.69, 0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100034, 185794, 530, 1, 2715.49, 7283.44, 368.528, 3.14159, 0, 0, 1, 0, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100033, 185811, 530, 1, 2711.65, 7267.2,  368.528, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100032, 185808, 530, 1, 2708.78, 7264.56, 368.528, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100031, 185809, 530, 1, 2705.98, 7267.47, 368.528, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100030, 185732, 530, 1, 2708.9,  7267.39, 368.583, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100029, 185733, 530, 1, 2708.91, 7267.38, 368.583, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100028, 185734, 530, 1, 2708.91, 7267.38, 368.583, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100027, 185810, 530, 1, 2708.96, 7270.1,  368.528, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100026, 185735, 530, 1, 2708.91, 7267.38, 368.583, 3.11541, 0, 0, 0.999914, 0.01309, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100025, 185890, 530, 1, 2708.93, 7267.39, 370.574, 0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100024, 185894, 530, 1, 2708.96, 7267.4,  368.682, 0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100023, 185795, 530, 1, 2726.24, 7272.67, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100022, 185792, 530, 1, 2737.03, 7283.42, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100021, 185797, 530, 1, 2739.97, 7267.53, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100020, 185799, 530, 1, 2742.87, 7267.56, 368.583, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100019, 185800, 530, 1, 2742.87, 7267.57, 368.583, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100018, 185803, 530, 1, 2745.71, 7267.48, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100017, 185727, 530, 1, 2742.79, 7298.31, 368.583, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100016, 185791, 530, 1, 2742.77, 7295.43, 368.583, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100015, 185725, 530, 1, 2742.8,  7298.3,  368.583, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100014, 185726, 530, 1, 2742.79, 7298.31, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100013, 185724, 530, 1, 2742.8,  7298.3,  368.583, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100012, 185802, 530, 1, 2742.87, 7267.57, 368.583, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100011, 185798, 530, 1, 2742.85, 7270.26, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100010, 185796, 530, 1, 2742.86, 7264.77, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100009, 185801, 530, 1, 2742.87, 7267.56, 368.583, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100008, 185788, 530, 1, 2739.91, 7298.25, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100007, 185793, 530, 1, 2726.27, 7294.18, 368.528, 3.12414, 0, 0, 0.999962, 0.008727, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100006, 185789, 530, 1, 2742.74, 7301.05, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100005, 185790, 530, 1, 2745.59, 7298.21, 368.528, -3.13287, 0, 0, 0.99999, -0.004363, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100004, 185890, 530, 1, 2742.9,  7267.58, 371.023, 0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100003, 185894, 530, 1, 2742.83, 7267.58, 368.685, 0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100002, 185890, 530, 1, 2742.79, 7298.34, 370.994, 0, 0, 0, 0, 1, 180, 100, 1);
INSERT INTO `gameobject` VALUES (100001, 185894, 530, 1, 2742.81, 7298.31, 368.673, 0, 0, 0, 0, 1, 180, 100, 1);

DELETE FROM `gameobject` WHERE `guid` BETWEEN 100200 AND 100400;
INSERT INTO `gameobject` VALUES (100200, 185861, 530, 1, 2940.6, 7106.65, 370.123, 0.88561, 0, 0, 0.428475, 0.903553, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100201, 185861, 530, 1, 3016.28, 6876.11, 370.188, 3.47791, 0, 0, 0.985895, -0.167365, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100202, 185861, 530, 1, 3022.15, 6859.05, 369.546, 3.44885, 0, 0, 0.988222, -0.153025, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100203, 185861, 530, 1, 3028.3, 6824.84, 373.591, 5.0275, 0, 0, 0.587401, -0.809296, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100204, 185861, 530, 1, 3023.13, 6799.74, 374.46, 1.58666, 0, 0, 0.712695, 0.701474, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100205, 185861, 530, 1, 2953.55, 6859.3, 369.954, 6.14433, 0, 0, 0.0693712, -0.997591, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100206, 185861, 530, 1, 2941.56, 6827.17, 367.3, 4.08109, 0, 0, 0.891683, -0.452661, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100207, 185861, 530, 1, 2978.73, 6889.19, 369.701, 0.689745, 0, 0, 0.338077, 0.941119, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100208, 185861, 530, 1, 2982, 7054.94, 368.32, 4.99766, 0, 0, 0.599411, -0.800442, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100209, 185861, 530, 1, 2998.57, 7043.55, 368.539, 5.91266, 0, 0, 0.184206, -0.982888, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100210, 185861, 530, 1, 2938.02, 7015.59, 365.75, 3.65778, 0, 0, 0.966879, -0.255237, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100211, 185861, 530, 1, 2924.84, 7031.46, 367.857, 4.26205, 0, 0, 0.847134, -0.53138, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100212, 185861, 530, 1, 2938.26, 7094.72, 369.413, 2.78314, 0, 0, 0.983982, 0.178267, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100213, 185861, 530, 1, 2825.11, 7024.05, 369.982, 5.69617, 0, 0, 0.289313, -0.957235, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100214, 185861, 530, 1, 2825.11, 7024.05, 369.982, 5.69617, 0, 0, 0.289313, -0.957235, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100215, 185861, 530, 1, 2938.26, 7094.72, 369.413, 2.78314, 0, 0, 0.983982, 0.178267, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100216, 185861, 530, 1, 2924.84, 7031.46, 367.857, 4.26205, 0, 0, 0.847134, -0.53138, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100217, 185861, 530, 1, 2938.0200, 7015.5898, 366.5400, 3.65778, 0, 0, 0.966879, -0.255237, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100218, 185861, 530, 1, 2998.57, 7043.55, 368.539, 5.91266, 0, 0, 0.184206, -0.982888, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100219, 185861, 530, 1, 2982, 7054.94, 368.32, 4.99766, 0, 0, 0.599411, -0.800442, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100220, 185861, 530, 1, 2978.73, 6889.19, 369.701, 0.689745, 0, 0, 0.338077, 0.941119, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100221, 185861, 530, 1, 2941.56, 6827.17, 367.3, 4.08109, 0, 0, 0.891683, -0.452661, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100222, 185861, 530, 1, 2953.55, 6859.3, 369.954, 6.14433, 0, 0, 0.0693712, -0.997591, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100223, 185861, 530, 1, 3023.13, 6799.74, 374.46, 1.58666, 0, 0, 0.712695, 0.701474, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100224, 185861, 530, 1, 3028.3, 6824.84, 373.591, 5.0275, 0, 0, 0.587401, -0.809296, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100225, 185861, 530, 1, 3022.15, 6859.05, 369.546, 3.44885, 0, 0, 0.988222, -0.153025, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100226, 185861, 530, 1, 3016.28, 6876.11, 370.188, 3.47791, 0, 0, 0.985895, -0.167365, 300, 0, 1);
INSERT INTO `gameobject` VALUES (100227, 185861, 530, 1, 2940.6, 7106.65, 370.123, 0.88561, 0, 0, 0.428475, 0.903553, 300, 0, 1);
--
-- ======================================================
-- Miscellaneous
-- ======================================================
--
-- Apexis Shard
DELETE FROM `creature_loot_template` WHERE `item` = 32569;
INSERT INTO `creature_loot_template` VALUES (18692, 32569, 100, 2, 2, 3, 0, 0, 0); -- 15
INSERT INTO `creature_loot_template` VALUES (19973, 32569, 73, 0, 1, 1, 0, 0, 0); -- 18.7
INSERT INTO `creature_loot_template` VALUES (20557, 32569, 8.3465, 0, 1, 1, 0, 0, 0); -- 8.3465
INSERT INTO `creature_loot_template` VALUES (22175, 32569, 33.1139, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22180, 32569, 45, 0, 1, 1, 0, 0, 0); -- 29.4929
INSERT INTO `creature_loot_template` VALUES (22181, 32569, 31.0921, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22182, 32569, 22.768, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22195, 32569, 46, 0, 1, 1, 0, 0, 0); -- 16.6
INSERT INTO `creature_loot_template` VALUES (22204, 32569, 45, 0, 1, 1, 0, 0, 0); -- 25.2364
INSERT INTO `creature_loot_template` VALUES (22241, 32569, 47, 0, 1, 1, 0, 0, 0); -- 21.9174
INSERT INTO `creature_loot_template` VALUES (22242, 32569, 45, 0, 1, 1, 0, 0, 0); -- 21.9872
INSERT INTO `creature_loot_template` VALUES (22243, 32569, 48, 0, 1, 1, 0, 0, 0); -- 24.0095
INSERT INTO `creature_loot_template` VALUES (22244, 32569, 34, 0, 1, 1, 0, 0, 0); -- 15.2663,
INSERT INTO `creature_loot_template` VALUES (22254, 32569, 45, 0, 1, 1, 0, 0, 0); -- 26.756
INSERT INTO `creature_loot_template` VALUES (22291, 32569, 47, 0, 1, 1, 0, 0, 0); -- 15.2455
INSERT INTO `creature_loot_template` VALUES (22298, 32569, 33, 0, 1, 1, 0, 0, 0); -- 7.2
INSERT INTO `creature_loot_template` VALUES (22304, 32569, 98.2, 0, 2, 3, 0, 0, 0); -- 
INSERT INTO `creature_loot_template` VALUES (23061, 32569, 92, 0, 2, 3, 0, 0, 0); -- 24.9,
INSERT INTO `creature_loot_template` VALUES (23153, 32569, 97.2, 0, 2, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23154, 32569, 97.2, 0, 2, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23174, 32569, 98.7, 0, 2, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 32569, 92, 0, 2, 3, 0, 0, 0); -- 25
INSERT INTO `creature_loot_template` VALUES (23281, 32569, 93, 0, 2, 3, 0, 0, 0); -- 25.1
INSERT INTO `creature_loot_template` VALUES (23282, 32569, 93, 0, 2, 3, 0, 0, 0); -- 25
INSERT INTO `creature_loot_template` VALUES (23386, 32569, 50, 0, 1, 1, 0, 0, 0); -- 33.8
--
DELETE FROM `creature_loot_template` WHERE `entry` IN (22275,22281,23353,23354,23355);
-- Galvanoth 22281
INSERT INTO `creature_loot_template` VALUES (22281, 21877, 26.506, 0, 4, 5, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 24011, 1, 1, -24011, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 24035, 2, 1, -24035, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 27854, 3.6145, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 27860, 9.6386, 0, 1, 1, 0, 0, 0);
-- Apexis Crystal
INSERT INTO `creature_loot_template` VALUES (22281, 32572, 0, 2, 1, 1, 0, 0, 0); -- 62.6506 0
-- Depleted Items
INSERT INTO `creature_loot_template` VALUES (22281, 32670, 1.3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 32671, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 32672, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 32673, 1, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 32674, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 32675, 1.9, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 32676, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 32677, 1.4, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 32678, 1.9, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22281, 32679, 2, 3, 1, 1, 0, 0, 0);
-- Fel Whip
INSERT INTO `creature_loot_template` VALUES (22281, 32733, -100, 0, 1, 1, 0, 0, 0);
--
-- Braxxus 23353
INSERT INTO `creature_loot_template` VALUES (23353, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 24092, 0.5, 1, -24092, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 25418, 33.9, 0, 2, 4, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 25421, 8, 0, 2, 4, 0, 0, 0);
-- Apexis Crystal
INSERT INTO `creature_loot_template` VALUES (23353, 32572, 0, 2, 1, 1, 0, 0, 0); -- 77.3 0
-- Depleted Items
INSERT INTO `creature_loot_template` VALUES (23353, 32670, 6, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 32671, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 32672, 0.8, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 32673, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 32674, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 32676, 1.6, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 32677, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 32678, 0.9, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23353, 32679, 2, 3, 1, 1, 0, 0, 0);
-- Fel Whip
INSERT INTO `creature_loot_template` VALUES (23353, 32733, -100, 0, 1, 1, 0, 0, 0);
--
-- Mo'arg Incinerator 23354
INSERT INTO `creature_loot_template` VALUES (23354, 21877, 21.1, 0, 4, 6, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 27854, 1.7, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 27860, 1, 0, 1, 1, 0, 0, 0);
-- Apexis Crystal
INSERT INTO `creature_loot_template` VALUES (23354, 32572, 0, 2, 1, 1, 0, 0, 0); -- 80.5 0
-- Depleted Items
INSERT INTO `creature_loot_template` VALUES (23354, 32670, 1.6, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 32671, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 32672, 1.3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 32673, 1.9, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 32674, 1.8, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 32675, 1.6, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 32676, 1.4, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 32677, 1.8, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 32678, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23354, 32679, 2, 3, 1, 1, 0, 0, 0);
-- Fel Whip
INSERT INTO `creature_loot_template` VALUES (23354, 32733, -100, 0, 1, 1, 0, 0, 0);
--
-- Zarcsin 23355
INSERT INTO `creature_loot_template` VALUES (23355, 21877, 16.9, 0, 4, 6, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 22903, 0.5, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 24035, 2, 1, -24035, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 24092, 0.5, 1, -24092, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 27854, 2.6, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 27860, 0.5, 0, 1, 1, 0, 0, 0);
-- Apexis Crystal
INSERT INTO `creature_loot_template` VALUES (23355, 32572, 0, 2, 1, 1, 0, 0, 0); -- 86.8 0
-- Depleted Items
INSERT INTO `creature_loot_template` VALUES (23355, 32670, 1.5, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 32671, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 32672, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 32673, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 32674, 1.6, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 32675, 1.3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 32676, 1.9, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 32677, 1.9, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 32678, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23355, 32679, 2, 3, 1, 1, 0, 0, 0);
-- Fel Whip
INSERT INTO `creature_loot_template` VALUES (23355, 32733, -100, 0, 1, 1, 0, 0, 0);
--
-- Apexis Guardian 22275
INSERT INTO `creature_loot_template` VALUES (22275, 4552, 48.5095, 0, 2, 4, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 4554, 13.5501, 0, 2, 4, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 24009, 1, 1, -24009, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 24011, 1, 1, -24011, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 24092, 0.5, 1, -24092, 1, 0, 0, 0);
-- Apexis Crystal
INSERT INTO `creature_loot_template` VALUES (22275, 32572, 0, 2, 1, 1, 0, 0, 0); -- 60.7046 0
-- Depleted Items
INSERT INTO `creature_loot_template` VALUES (22275, 32670, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 32671, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 32672, 1.4, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 32673, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 32674, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 32675, 1.7, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 32676, 1.5, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 32677, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 32678, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22275, 32679, 2, 3, 1, 1, 0, 0, 0);
-- Apexis Guardian's Head
INSERT INTO `creature_loot_template` VALUES (22275, 32697, -100, 0, 1, 1, 0, 0, 0); -- -43
--
DELETE FROM `creature_loot_template` WHERE `entry` IN (23061,23282,23261,23281);
-- Rivendark 23061
INSERT INTO `creature_loot_template` VALUES (23061, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 24092, 0.5, 1, -24092, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 29549, 0.1, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 29563, 25.1, 0, 2, 4, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 29564, 5.7, 0, 2, 4, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 31837, 0.1, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 32569, 92, 0, 2, 3, 0, 0, 0); --  24.9
INSERT INTO `creature_loot_template` VALUES (23061, 32670, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 32671, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 32672, 1.7, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 32673, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 32674, 1.3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 32675, 1.2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 32676, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 32677, 1.7, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 32678, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 32679, 1.6, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23061, 32681, 0, 2, 1, 1, 0, 0, 0); -- 100 0
INSERT INTO `creature_loot_template` VALUES (23061, 32732, -100, 0, 1, 1, 0, 0, 0);
--
-- Obsidia 23282
INSERT INTO `creature_loot_template` VALUES (23282, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 29563, 23.6, 0, 2, 4, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 29564, 5, 0, 2, 4, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 32569, 93, 0, 2, 3, 0, 0, 0); -- 25
INSERT INTO `creature_loot_template` VALUES (23282, 32670, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 32671, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 32672, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 32673, 1.8, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 32674, 1.8, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 32675, 1.8, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 32676, 1.5, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 32677, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 32678, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 32679, 1.4, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23282, 32682, 0, 2 , 1, 1, 0, 0, 0); -- 100 0
INSERT INTO `creature_loot_template` VALUES (23282, 32732, -100, 0, 1, 1, 0, 0, 0);
--
-- Furywing 23261
INSERT INTO `creature_loot_template` VALUES (23261, 22153, 0.1, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 29549, 0.1, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 29563, 27.2, 0, 2, 4, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 29564, 5.1, 0, 2, 4, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 32569, 92, 0, 2, 3, 0, 0, 0); -- 25
INSERT INTO `creature_loot_template` VALUES (23261, 32670, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 32671, 1.8, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 32672, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 32673, 1.7, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 32674, 0.8, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 32675, 1.3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 32676, 1.4, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 32677, 1.9, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 32678, 1.7, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 32679, 4, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23261, 32683, 0, 2, 1, 1, 0, 0, 0); -- 100 0
INSERT INTO `creature_loot_template` VALUES (23261, 32732, -100, 0, 1, 1, 0, 0, 0);
--
-- Insidion 23281
INSERT INTO `creature_loot_template` VALUES (23281, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 29563, 23.6, 0, 2, 4, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 29564, 7, 0, 2, 4, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 32569, 93, 0, 2, 3, 0, 0, 0); -- 25.1 
INSERT INTO `creature_loot_template` VALUES (23281, 32670, 1.9, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 32671, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 32672, 1.8, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 32673, 1.1, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 32674, 2, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 32675, 3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 32676, 1.3, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 32677, 1.1, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 32678, 1.9, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 32679, 1.9, 3, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23281, 32684, 0, 2, 1, 1, 0, 0, 0); -- 100 0
INSERT INTO `creature_loot_template` VALUES (23281, 32732, -100, 0, 1, 1, 0, 0, 0);

-- Depleted Items
REPLACE INTO `creature_loot_template` VALUES (22182, 32576, 2.6, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22182, 32670, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22182, 32672, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22182, 32673, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22182, 32675, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22182, 32678, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22241, 32576, 2.6, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22241, 32670, 0.0109, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22241, 32671, 0.0109, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22241, 32672, 0.0328, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22241, 32674, 0.0109, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22241, 32676, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22241, 32678, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22241, 32679, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22242, 32576, 2.3, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22242, 32673, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22242, 32676, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22242, 32677, 0.0094, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22242, 32678, 0.0094, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22242, 32679, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22243, 32576, 2.5, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22243, 32670, 0.0079, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22243, 32671, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22243, 32672, 0.0079, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22243, 32673, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22243, 32675, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22243, 32677, 0.04, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22243, 32678, 0.0158, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22243, 32679, 0.0079, 0, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22275, 32670, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22275, 32671, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22275, 32672, 1.4, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22275, 32673, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22275, 32674, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22275, 32675, 1.7, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22275, 32676, 1.5, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22275, 32677, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22275, 32678, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22275, 32679, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22281, 32670, 1.3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22281, 32671, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22281, 32672, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22281, 32673, 1, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22281, 32674, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22281, 32675, 1.9, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22281, 32676, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22281, 32677, 1.4, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22281, 32678, 1.9, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (22281, 32679, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23061, 32670, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23061, 32671, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23061, 32672, 1.7, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23061, 32673, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23061, 32674, 1.3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23061, 32675, 1.2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23061, 32676, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23061, 32677, 1.7, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23061, 32678, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23061, 32679, 1.6, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23230, 32670, 6.5, 2, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23230, 32671, 12.9, 2, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23230, 32672, 4.4, 2, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23230, 32673, 15, 2, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23230, 32674, 4.4, 2, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23230, 32675, 10.7, 2, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23230, 32676, 3, 2, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23230, 32677, 6.5, 2, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23230, 32678, 15, 2, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23230, 32679, 8.6, 2, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23261, 32670, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23261, 32671, 1.8, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23261, 32672, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23261, 32673, 1.7, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23261, 32674, 0.8, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23261, 32675, 1.3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23261, 32676, 1.4, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23261, 32677, 1.9, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23261, 32678, 1.7, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23261, 32679, 4, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23281, 32670, 1.9, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23281, 32671, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23281, 32672, 1.8, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23281, 32673, 1.1, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23281, 32674, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23281, 32675, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23281, 32676, 1.3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23281, 32677, 1.1, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23281, 32678, 1.9, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23281, 32679, 1.9, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23282, 32670, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23282, 32671, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23282, 32672, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23282, 32673, 1.8, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23282, 32674, 1.8, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23282, 32675, 1.8, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23282, 32676, 1.5, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23282, 32677, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23282, 32678, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23282, 32679, 1.4, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23333, 32670, 6, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23333, 32671, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23333, 32672, 6, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23333, 32673, 0.5, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23333, 32674, 1.7, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23333, 32675, 0.5, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23333, 32676, 5, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23333, 32677, 0.5, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23333, 32678, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23333, 32679, 0.7, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23353, 32670, 6, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23353, 32671, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23353, 32672, 0.8, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23353, 32673, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23353, 32674, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23353, 32676, 1.6, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23353, 32677, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23353, 32678, 0.9, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23353, 32679, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23354, 32670, 1.6, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23354, 32671, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23354, 32672, 1.3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23354, 32673, 1.9, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23354, 32674, 1.8, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23354, 32675, 1.6, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23354, 32676, 1.4, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23354, 32677, 1.8, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23354, 32678, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23354, 32679, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23355, 32670, 1.5, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23355, 32671, 3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23355, 32672, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23355, 32673, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23355, 32674, 1.6, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23355, 32675, 1.3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23355, 32676, 1.9, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23355, 32677, 1.9, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23355, 32678, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23355, 32679, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23390, 32670, 1, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23390, 32671, 1, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23390, 32672, 1, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23390, 32673, 1, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23390, 32674, 1, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23390, 32675, 1, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23390, 32676, 1, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23390, 32677, 1, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23390, 32678, 11, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23390, 32679, 0.3, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23391, 32670, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23391, 32671, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23391, 32672, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23391, 32673, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23391, 32674, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23391, 32675, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23391, 32676, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23391, 32677, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23391, 32678, 2, 3, 1, 1, 0, 0, 0);
REPLACE INTO `creature_loot_template` VALUES (23391, 32679, 2, 3, 1, 1, 0, 0, 0);
Looking4Group / L4G_Core

Schergrat #603
