Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Код:
UPDATE `creature_template` SET `gossip_menu_id` = 9622 WHERE `entry` = 26519;
UPDATE `creature_template` SET `gossip_menu_id` = 9604 WHERE `entry` = 26424;
UPDATE `creature_template` SET `gossip_menu_id` = 9416 WHERE `entry` = 26604;
UPDATE `gossip_menu` SET `entry` = 9416, `text_id`= 12659 WHERE entry = 26604;
UPDATE `gossip_menu_option` SET menu_id = 9416 WHERE menu_id = 26604;
UPDATE `creature_template` SET `gossip_menu_id` = 9490 WHERE `entry` = 27262;
UPDATE `creature_template` SET `gossip_menu_id` = 9301 WHERE `entry` = 26422;
UPDATE `creature_template` SET `gossip_menu_id` = 8086 WHERE `entry` = 19253;
UPDATE `creature_template` SET `gossip_menu_id` = 7967 WHERE `entry` = 19401;
UPDATE `creature_template` SET `gossip_menu_id` = 7955 WHERE `entry` = 19273;
UPDATE `creature_template` SET `gossip_menu_id` = 7957 WHERE `entry` = 19315;
UPDATE `creature_template` SET `gossip_menu_id` = 7335 WHERE `entry` = 16576;
UPDATE `creature_template` SET `gossip_menu_id` = 7958 WHERE `entry` = 19332;
UPDATE `creature_template` SET `gossip_menu_id` = 8505 WHERE `entry` = 22231;
UPDATE `creature_template` SET `gossip_menu_id` = 8272 WHERE `entry` = 21279;
UPDATE `creature_template` SET `gossip_menu_id` = 7348 WHERE `entry` = 16858;
UPDATE `creature_template` SET `gossip_menu_id` = 7290 WHERE `entry` = 16602;
UPDATE `gossip_menu` SET `entry` = 7290, `text_id`= 8634 WHERE entry = 50245;
UPDATE `gossip_menu_option` SET menu_id = 7290 WHERE menu_id = 50245;
UPDATE `creature_template` SET `gossip_menu_id` = 7893 WHERE `entry` = 18267;
UPDATE `creature_template` SET `gossip_menu_id` = 7372 WHERE `entry` = 17123;
UPDATE `creature_template` SET `gossip_menu_id` = 7373 WHERE `entry` = 16848;
UPDATE `creature_template` SET `gossip_menu_id` = 7375 WHERE `entry` = 16845;
UPDATE `creature_template` SET `gossip_menu_id` = 7334 WHERE `entry` = 16574;
UPDATE `creature_template` SET `gossip_menu_id` = 7690 WHERE `entry` = 18747;
UPDATE `creature_template` SET `gossip_menu_id` = 7825 WHERE `entry` = 17558;
UPDATE `creature_template` SET `gossip_menu_id` = 7420 WHERE `entry` = 17493;
UPDATE `creature_template` SET `gossip_menu_id` = 8087 WHERE `entry` = 19255;
UPDATE `creature_template` SET `gossip_menu_id` = 7333 WHERE `entry` = 16584;
UPDATE `creature_template` SET `gossip_menu_id` = 7810 WHERE `entry` = 16588;
UPDATE `creature_template` SET `gossip_menu_id` = 7691 WHERE `entry` = 18748;
UPDATE `creature_template` SET `gossip_menu_id` = 7818 WHERE `entry` = 18753;
UPDATE `creature_template` SET `gossip_menu_id` = 8686 WHERE `entry` = 17002;
UPDATE `creature_template` SET `gossip_menu_id` = 7880 WHERE `entry` = 17277;
UPDATE `creature_template` SET `gossip_menu_id` = 7342 WHERE `entry` = 17015;
UPDATE `creature_template` SET `gossip_menu_id` = 7881 WHERE `entry` = 18997;
UPDATE `creature_template` SET `gossip_menu_id` = 10362 WHERE `entry` = 33631;
UPDATE `creature_template` SET `gossip_menu_id` = 10363 WHERE `entry` = 33634;
UPDATE `creature_template` SET `gossip_menu_id` = 10364 WHERE `entry` = 33636;
UPDATE `creature_template` SET `gossip_menu_id` = 11386 WHERE `entry` = 40438;
UPDATE `creature_template` SET `gossip_menu_id` = 8460 WHERE `entry` = 19185;
UPDATE `creature_template` SET `gossip_menu_id` = 8268 WHERE `entry` = 20791;
UPDATE `creature_template` SET `gossip_menu_id` = 9780 WHERE `entry` = 29160;
UPDATE `creature_template` SET `gossip_menu_id` = 9641 WHERE `entry` = 28042;
UPDATE `creature_template` SET `gossip_menu_id` = 9715 WHERE `entry` = 28561;
UPDATE `gossip_menu` SET `entry` = 9715, `text_id`= 13291 WHERE entry = 28561;
UPDATE `gossip_menu_option` SET menu_id = 9715 WHERE menu_id = 28561;
UPDATE `creature_template` SET `gossip_menu_id` = 9639 WHERE `entry` = 28059;
UPDATE `creature_template` SET `gossip_menu_id` = 9675 WHERE `entry` = 28309;
UPDATE `creature_template` SET `gossip_menu_id` = 10273 WHERE `entry` = 29327;
INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES
(9622, 13011),
(9604, 12966),
(9490, 12773),
(9301, 12617),
(8086, 9996),
(7967, 9801),
(9641, 13048),
(7955, 9771),
(7957, 9775),
(7335, 8719),
(7958, 9777),
(8505, 10636),
(8272, 10301),
(7348, 8767),
(7372, 8810),
(7373, 8811),
(7375, 8813),
(10364, 10652),
(11386, 15857),
(8460, 10568),
(10362, 16705),
(10363, 10650),
(8268, 10291),
(7881, 9644),
(7342, 8751),
(7880, 9643),
(8686, 10934),
(7334, 8718),
(7690, 9384),
(7825, 9574),
(8087, 9997),
(7893, 9657),
(7420, 8962),
(7333, 8717),
(7810, 9546),
(7691, 9385),
(9780, 13458),
(9675, 13121),
(9639, 13046),
(7818, 9546),
(10273, 14266);
Код:
UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 1083;
UPDATE `creature_model_info` SET `bounding_radius` = '1.7485' WHERE modelid = 1086;
UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 1086;
UPDATE `creature_model_info` SET `bounding_radius` = '0.85' WHERE modelid = 2705;
UPDATE `creature_model_info` SET `combat_reach` = '0.85' WHERE modelid = 2705;
UPDATE `creature_model_info` SET `combat_reach` = '0.5' WHERE modelid = 6303;
UPDATE `creature_model_info` SET `combat_reach` = '0.75' WHERE modelid = 7763;
UPDATE `creature_model_info` SET `bounding_radius` = '0.1705' WHERE modelid = 8109;
UPDATE `creature_model_info` SET `combat_reach` = '0.825' WHERE modelid = 8109;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 11631;
UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 11829;
UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 12829;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12829;
UPDATE `creature_model_info` SET `combat_reach` = '10.5' WHERE modelid = 15295;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17836;
UPDATE `creature_model_info` SET `bounding_radius` = '0.3' WHERE modelid = 18043;
UPDATE `creature_model_info` SET `combat_reach` = '0.6' WHERE modelid = 18043;
UPDATE `creature_model_info` SET `bounding_radius` = '2.4' WHERE modelid = 21392;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 23819;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24018;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24086;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24268;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24502;
UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 24506;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24662;
UPDATE `creature_model_info` SET `combat_reach` = '1.35' WHERE modelid = 24668;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24679;
UPDATE `creature_model_info` SET `combat_reach` = '1.35' WHERE modelid = 24709;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25059;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25100;
UPDATE `creature_model_info` SET `combat_reach` = '12.5' WHERE modelid = 25129;
UPDATE `creature_model_info` SET `bounding_radius` = '2.778' WHERE modelid = 25203;
UPDATE `creature_model_info` SET `combat_reach` = '4' WHERE modelid = 25203;
UPDATE `creature_model_info` SET `combat_reach` = '1.5525' WHERE modelid = 25205;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 25267;
UPDATE `creature_model_info` SET `combat_reach` = '4' WHERE modelid = 25269;
UPDATE `creature_model_info` SET `bounding_radius` = '1.59' WHERE modelid = 25378;
UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 25378;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 25381;
UPDATE `creature_model_info` SET `combat_reach` = '0.4' WHERE modelid = 25384;
UPDATE `creature_model_info` SET `combat_reach` = '0.8' WHERE modelid = 25385;
UPDATE `creature_model_info` SET `combat_reach` = '15' WHERE modelid = 25400;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 25461;
UPDATE `creature_model_info` SET `bounding_radius` = '0.694444' WHERE modelid = 25484;
UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 25484;
UPDATE `creature_model_info` SET `bounding_radius` = '0.694444' WHERE modelid = 25485;
UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 25485;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25502;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25580;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25584;
UPDATE `creature_model_info` SET `bounding_radius` = '0.694444' WHERE modelid = 25588;
UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 25588;
UPDATE `creature_model_info` SET `combat_reach` = '1.1' WHERE modelid = 25640;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25689;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25693;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25694;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25695;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25696;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25718;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25719;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25736;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25737;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25738;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25739;
UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 25923;
UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 26097;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 26098;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 26227;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26228;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26232;
UPDATE `creature_model_info` SET `combat_reach` = '1.35' WHERE modelid = 26256;
UPDATE `creature_model_info` SET `combat_reach` = '1.35' WHERE modelid = 26257;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 26354;
UPDATE `creature_model_info` SET `combat_reach` = '5' WHERE modelid = 26416;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 26634;
UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 26650;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 26650;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26697;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 26807;
UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 26807;
UPDATE `creature_model_info` SET `combat_reach` = '1.845' WHERE modelid = 26813;
UPDATE `creature_model_info` SET `combat_reach` = '2.325' WHERE modelid = 26848;
UPDATE `creature_model_info` SET `combat_reach` = '1.15' WHERE modelid = 26861;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27135;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27230;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27251;
UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 27817;
UPDATE `creature_model_info` SET `bounding_radius` = '0.78125' WHERE modelid = 27833;
UPDATE `creature_model_info` SET `combat_reach` = '3.375' WHERE modelid = 27833;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 27840;
UPDATE `creature_model_info` SET `combat_reach` = '2.1' WHERE modelid = 27875;
UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 27878;
UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 28008;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 6653;
UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 10218;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 10218;
UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 16570;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 16570;
UPDATE `creature_template` SET `faction_A` = '834', `faction_H` = '834' WHERE entry = 16570;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 22515;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 26298;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 26366;
UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 26366;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 26500;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 26500;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 26543;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 26543;
UPDATE `creature_template` SET `unit_flags` = '524288' WHERE entry = 26592;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 26646;
UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 26646;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 26646;
UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 26646;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 26679;
UPDATE `creature_template` SET `unit_flags` = '570721024' WHERE entry = 26682;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 26700;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 26701;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 26701;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 26704;
UPDATE `creature_template` SET `faction_A` = '1693', `faction_H` = '1693' WHERE entry = 26704;
UPDATE `creature_template` SET `faction_A` = '44', `faction_H` = '44' WHERE entry = 26706;
UPDATE `creature_template` SET `faction_A` = '2032', `faction_H` = '2032' WHERE entry = 26708;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26821;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 27263;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 27264;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 27265;
UPDATE `creature_template` SET `speed_run` = '0.571429' WHERE entry = 27354;
UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 27354;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 27413;
UPDATE `creature_template` SET `faction_A` = '1892', `faction_H` = '1892' WHERE entry = 27414;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27424;
UPDATE `creature_template` SET `faction_A` = '1314', `faction_H` = '1314' WHERE entry = 27424;
UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 27456;
UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 27457;
UPDATE `creature_template` SET `unit_flags` = '36864' WHERE entry = 27463;
UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 27481;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27482;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 27486;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27493;
UPDATE `creature_template` SET `faction_A` = '1314', `faction_H` = '1314' WHERE entry = 27493;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 27497;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27497;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 27499;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27499;
UPDATE `creature_template` SET `faction_A` = '2032', `faction_H` = '2032' WHERE entry = 27545;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27554;
UPDATE `creature_template` SET `faction_A` = '1693', `faction_H` = '1693' WHERE entry = 27554;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27554;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27555;
UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 27555;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27555;
UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 27581;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27581;
UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 27676;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28022;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 28022;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28026;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28026;
UPDATE `creature_template` SET `unit_flags` = '33280' WHERE entry = 28028;
UPDATE `creature_template` SET `unit_flags` = '33280' WHERE entry = 28029;
UPDATE `creature_template` SET `faction_A` = '2070', `faction_H` = '2070' WHERE entry = 28029;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28034;
UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28035;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28035;
UPDATE `creature_template` SET `baseattacktime` = '1818' WHERE entry = 28035;
UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28036;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28036;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28039;
UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28041;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28042;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28043;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28045;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28056;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28059;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28062;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 28064;
UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 28068;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28068;
UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28068;
UPDATE `creature_template` SET `unit_flags` = '537166592' WHERE entry = 28089;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 28089;
UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28089;
UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 28090;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28090;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28099;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28117;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28118;
UPDATE `creature_template` SET `faction_A` = '834', `faction_H` = '834' WHERE entry = 28118;
UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28118;
UPDATE `creature_template` SET `unit_flags` = '33280' WHERE entry = 28133;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 28137;
UPDATE `creature_template` SET `unit_flags` = '33280' WHERE entry = 28141;
UPDATE `creature_template` SET `unit_flags` = '33280' WHERE entry = 28143;
UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 28145;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28145;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28145;
UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28156;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28158;
UPDATE `creature_template` SET `speed_walk` = '0.4' WHERE entry = 28158;
UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28162;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28175;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 28176;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28177;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 28178;
UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 28203;
UPDATE `creature_template` SET `unit_flags` = '294912' WHERE entry = 28203;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 28203;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28204;
UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 28221;
UPDATE `creature_template` SET `unit_flags` = '33587200' WHERE entry = 28221;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28221;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 28233;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 28240;
UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 28246;
UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 28255;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28257;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28257;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28258;
UPDATE `creature_template` SET `speed_walk` = '0.833332' WHERE entry = 28258;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28268;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 28268;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28268;
UPDATE `creature_template` SET `speed_walk` = '0.2' WHERE entry = 28274;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28303;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28303;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 28304;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 28305;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28309;
UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28323;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28323;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28323;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28324;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 28330;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 28352;
UPDATE `creature_template` SET `speed_walk` = '1.55556' WHERE entry = 28387;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28387;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28388;
UPDATE `creature_template` SET `faction_A` = '1771', `faction_H` = '1771' WHERE entry = 28388;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 28396;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28396;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 28397;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 28398;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28401;
UPDATE `creature_template` SET `unit_flags` = '295680' WHERE entry = 28401;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 28401;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28402;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28403;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28403;
UPDATE `creature_template` SET `unit_flags` = '67141632' WHERE entry = 28404;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28404;
UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 28404;
UPDATE `creature_template` SET `speed_walk` = '1.55556' WHERE entry = 28411;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28411;
UPDATE `creature_template` SET `faction_A` = '834', `faction_H` = '834' WHERE entry = 28411;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28412;
UPDATE `creature_template` SET `baseattacktime` = '6000' WHERE entry = 28413;
UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 28416;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28417;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28417;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28418;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28418;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28442;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28442;
UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28442;
UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 28452;
UPDATE `creature_template` SET `faction_A` = '91', `faction_H` = '91' WHERE entry = 28452;
UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 28465;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28465;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28465;
UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 28477;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28478;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28479;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28480;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28484;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28494;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28494;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28495;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28495;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28496;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28496;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28503;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28504;
UPDATE `creature_template` SET `faction_A` = '1771', `faction_H` = '1771' WHERE entry = 28504;
UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 28514;
UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 28515;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 28516;
UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 28516;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28517;
UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 28517;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28519;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28519;
UPDATE `creature_template` SET `speed_run` = '2' WHERE entry = 28526;
UPDATE `creature_template` SET `unit_flags` = '33587200' WHERE entry = 28526;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28527;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 28541;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28541;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 28561;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28564;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28565;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 28565;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28575;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28575;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 28589;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28589;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28597;
UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 28597;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28597;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28600;
UPDATE `creature_template` SET `faction_A` = '1771', `faction_H` = '1771' WHERE entry = 28600;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28615;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 28615;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 28617;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 28636;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 28636;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28636;
UPDATE `creature_template` SET `speed_run` = '2' WHERE entry = 28639;
UPDATE `creature_template` SET `VehicleID` = '108' WHERE entry = 28639;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 28639;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28639;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28657;
UPDATE `creature_template` SET `speed_walk` = '2.4' WHERE entry = 28657;
UPDATE `creature_template` SET `speed_run` = '2.57143' WHERE entry = 28665;
UPDATE `creature_template` SET `VehicleID` = '126' WHERE entry = 28665;
UPDATE `creature_template` SET `unit_flags` = '33288' WHERE entry = 28665;
UPDATE `creature_template` SET `unit_flags` = '33088' WHERE entry = 28671;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28671;
UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28672;
UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 28750;
UPDATE `creature_template` SET `speed_walk` = '2.4' WHERE entry = 28750;
UPDATE `creature_template` SET `speed_run` = '1.28571' WHERE entry = 28759;
UPDATE `creature_template` SET `speed_walk` = '2.8' WHERE entry = 28759;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 28759;
UPDATE `creature_template` SET `speed_run` = '0.595239' WHERE entry = 28784;
UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 28784;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28791;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28792;
UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 28793;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28794;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28796;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28797;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28798;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28799;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28800;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28801;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28802;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28803;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28803;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28806;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28807;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28809;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28810;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28811;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28812;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28813;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28818;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28827;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28828;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28829;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28830;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28831;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28832;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 28843;
UPDATE `creature_template` SET `unit_flags` = '537166080' WHERE entry = 28844;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28844;
UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28844;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28848;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28848;
UPDATE `creature_template` SET `speed_walk` = '1.55556' WHERE entry = 28863;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28863;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28866;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28867;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 28867;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28868;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28869;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28870;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 28870;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28871;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 28871;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28872;
UPDATE `creature_template` SET `speed_run` = '1.28571' WHERE entry = 28879;
UPDATE `creature_template` SET `speed_walk` = '2.8' WHERE entry = 28879;
UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 28888;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28888;
UPDATE `creature_template` SET `speed_run` = '1.28571' WHERE entry = 28931;
UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28931;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28931;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29129;
UPDATE `creature_template` SET `faction_A` = '634', `faction_H` = '634' WHERE entry = 29129;
UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 29133;
UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 29133;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29169;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29211;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 29211;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29270;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29275;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29319;
UPDATE `creature_template` SET `faction_A` = '1990', `faction_H` = '1990' WHERE entry = 29319;
UPDATE `creature_template` SET `faction_A` = '1990', `faction_H` = '1990' WHERE entry = 29327;
UPDATE `creature_template` SET `speed_run` = '1.28571' WHERE entry = 29436;
UPDATE `creature_template` SET `faction_A` = '834', `faction_H` = '834' WHERE entry = 29436;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29437;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29438;
UPDATE `creature_template` SET `faction_A` = '2115', `faction_H` = '2115' WHERE entry = 29438;
UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 29439;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29444;
UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 29444;
UPDATE `creature_template` SET `baseattacktime` = '1923' WHERE entry = 29444;
UPDATE `creature_template` SET `speed_run` = '1.07143' WHERE entry = 29449;
UPDATE `creature_template` SET `speed_run` = '1.07143' WHERE entry = 29450;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 29450;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 29451;
UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 29451;
UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 29451;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 29452;
UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 29452;
UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 29453;
UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 29453;
UPDATE `creature_template` SET `unit_flags` = '537166592' WHERE entry = 29454;
UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 29454;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 29459;
UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 29459;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 29468;
UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 29484;
UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 29484;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29583;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 29647;
UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 29647;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29654;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29654;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29656;
UPDATE `creature_template` SET `speed_run` = '2' WHERE entry = 29664;
UPDATE `creature_template` SET `speed_walk` = '2.4' WHERE entry = 29664;
UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 29664;
UPDATE `creature_template` SET `faction_A` = '2068', `faction_H` = '2068' WHERE entry = 29664;
UPDATE `creature_template` SET `unit_flags` = '33280' WHERE entry = 29686;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29687;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29690;
UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 29690;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29690;
UPDATE `creature_template` SET `unit_flags` = '33587200' WHERE entry = 29692;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 29693;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29697;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29697;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29699;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29699;
UPDATE `creature_template` SET `unit_flags` = '33587200' WHERE entry = 29700;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29733;
UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 29733;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29733;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29848;
UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 29848;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 29848;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 29856;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 29856;
UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 29917;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 29928;
UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 29928;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 30007;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30009;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 30098;
UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 30102;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 30102;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 30156;
UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 30193;
UPDATE `creature_template` SET `unit_flags` = '262400' WHERE entry = 33007;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 33007;
UPDATE `creature_template` SET `unit_flags` = '262400' WHERE entry = 33008;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 33008;
UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 33010;
UPDATE `creature_model_info` SET `combat_reach` = '0.8125' WHERE modelid = 644;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 1122;
UPDATE `creature_model_info` SET `combat_reach` = '1.25' WHERE modelid = 1192;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1814;
UPDATE `creature_model_info` SET `combat_reach` = '2.4' WHERE modelid = 1872;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 2326;
UPDATE `creature_model_info` SET `bounding_radius` = '2' WHERE modelid = 2352;
UPDATE `creature_model_info` SET `combat_reach` = '2.5' WHERE modelid = 2352;
UPDATE `creature_model_info` SET `combat_reach` = '1.425' WHERE modelid = 2528;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 2585;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3337;
UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 4177;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4177;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5499;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 5771;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 6172;
UPDATE `creature_model_info` SET `bounding_radius` = '0.28' WHERE modelid = 6299;
UPDATE `creature_model_info` SET `combat_reach` = '1.2' WHERE modelid = 6299;
UPDATE `creature_model_info` SET `combat_reach` = '3.5' WHERE modelid = 6351;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7051;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7109;
UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 8610;
UPDATE `creature_model_info` SET `bounding_radius` = '1.3' WHERE modelid = 9562;
UPDATE `creature_model_info` SET `combat_reach` = '1.625' WHERE modelid = 9562;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 9786;
UPDATE `creature_model_info` SET `combat_reach` = '2.625' WHERE modelid = 9929;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 10215;
UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 10831;
UPDATE `creature_model_info` SET `combat_reach` = '2.6' WHERE modelid = 10906;
UPDATE `creature_model_info` SET `bounding_radius` = '1.3' WHERE modelid = 11417;
UPDATE `creature_model_info` SET `combat_reach` = '1.625' WHERE modelid = 11417;
UPDATE `creature_model_info` SET `combat_reach` = '3.075' WHERE modelid = 11546;
UPDATE `creature_model_info` SET `combat_reach` = '2.625' WHERE modelid = 11548;
UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 11551;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 11650;
UPDATE `creature_model_info` SET `combat_reach` = '7.5' WHERE modelid = 12929;
UPDATE `creature_model_info` SET `combat_reach` = '0.01' WHERE modelid = 13069;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 14337;
UPDATE `creature_model_info` SET `combat_reach` = '5' WHERE modelid = 14501;
UPDATE `creature_model_info` SET `combat_reach` = '2.5' WHERE modelid = 14502;
UPDATE `creature_model_info` SET `combat_reach` = '0.75' WHERE modelid = 15534;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 15578;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 15947;
UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 16269;
UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 16281;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16283;
UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 16284;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16285;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16286;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16292;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16295;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16299;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16300;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16301;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16302;
UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 16303;
UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 16304;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16305;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16306;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 16315;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16320;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16374;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16380;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16388;
UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 16396;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16403;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16404;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16411;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16420;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16449;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16480;
UPDATE `creature_model_info` SET `combat_reach` = '2.1' WHERE modelid = 16484;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16502;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16505;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16507;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16521;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16522;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16523;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16592;
UPDATE `creature_model_info` SET `combat_reach` = '15' WHERE modelid = 16630;
UPDATE `creature_model_info` SET `combat_reach` = '1.25' WHERE modelid = 16634;
UPDATE `creature_model_info` SET `combat_reach` = '1.2' WHERE modelid = 16724;
UPDATE `creature_model_info` SET `combat_reach` = '0.5' WHERE modelid = 16741;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 16867;
UPDATE `creature_model_info` SET `combat_reach` = '1.3' WHERE modelid = 16875;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 16878;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 16880;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16954;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16957;
UPDATE `creature_model_info` SET `combat_reach` = '1.3' WHERE modelid = 17005;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 17006;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17039;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17082;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17088;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17111;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 17191;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17639;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17645;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 17650;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 17689;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 17736;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 17737;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17741;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17798;
UPDATE `creature_model_info` SET `combat_reach` = '1.45' WHERE modelid = 17805;
UPDATE `creature_model_info` SET `combat_reach` = '1.45' WHERE modelid = 17806;
UPDATE `creature_model_info` SET `combat_reach` = '1.45' WHERE modelid = 17808;
UPDATE `creature_model_info` SET `combat_reach` = '1.3' WHERE modelid = 17809;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17810;
UPDATE `creature_model_info` SET `combat_reach` = '1.15' WHERE modelid = 17812;
UPDATE `creature_model_info` SET `combat_reach` = '1.3' WHERE modelid = 17859;
UPDATE `creature_model_info` SET `combat_reach` = '1.3' WHERE modelid = 17860;
UPDATE `creature_model_info` SET `combat_reach` = '1.45' WHERE modelid = 17865;
UPDATE `creature_model_info` SET `combat_reach` = '1.3' WHERE modelid = 17867;
UPDATE `creature_model_info` SET `bounding_radius` = '0.403' WHERE modelid = 17869;
UPDATE `creature_model_info` SET `combat_reach` = '1.3' WHERE modelid = 17869;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17875;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17878;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17892;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17893;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17894;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 17903;
UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 17972;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18003;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18016;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18020;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18021;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18022;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18025;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18042;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18044;
UPDATE `creature_model_info` SET `bounding_radius` = '1.4' WHERE modelid = 18063;
UPDATE `creature_model_info` SET `combat_reach` = '1.75' WHERE modelid = 18063;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18073;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18086;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18088;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18096;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18100;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18106;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18146;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18148;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18150;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18151;
UPDATE `creature_model_info` SET `combat_reach` = '0.5' WHERE modelid = 18156;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18172;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18174;
UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 18176;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18180;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18181;
UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 18183;
UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 18186;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18197;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18202;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18207;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18213;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18215;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18216;
UPDATE `creature_model_info` SET `combat_reach` = '5.55' WHERE modelid = 18275;
UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 18311;
UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 18368;
UPDATE `creature_model_info` SET `combat_reach` = '0.75' WHERE modelid = 18405;
UPDATE `creature_model_info` SET `bounding_radius` = '0.62' WHERE modelid = 18434;
UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 18434;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18435;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18438;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18440;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18446;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18453;
UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 18453;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18455;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18472;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18475;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18478;
UPDATE `creature_model_info` SET `combat_reach` = '1.1' WHERE modelid = 18480;
UPDATE `creature_model_info` SET `combat_reach` = '1.3' WHERE modelid = 18485;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 18486;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 18489;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 18491;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18492;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18493;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18496;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 18497;
UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 18498;
UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 18500;
UPDATE `creature_model_info` SET `combat_reach` = '1.1' WHERE modelid = 18516;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18521;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18522;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18543;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18546;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18551;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18556;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18568;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18618;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18623;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18625;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18627;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18628;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18629;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18630;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18639;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18640;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18641;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18648;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18663;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18664;
UPDATE `creature_model_info` SET `combat_reach` = '2.025' WHERE modelid = 18672;
UPDATE `creature_model_info` SET `combat_reach` = '2.4' WHERE modelid = 18679;
UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 18684;
UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 18685;
UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 18686;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18689;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18690;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 18691;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 18694;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18704;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18707;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18711;
UPDATE `creature_model_info` SET `bounding_radius` = '0.31' WHERE modelid = 18712;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 18729;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18730;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 18731;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18733;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18735;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 18736;
UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 18738;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 18739;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18743;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18744;
UPDATE `creature_model_info` SET `combat_reach` = '4.8' WHERE modelid = 18753;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18754;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18756;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18757;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18758;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18759;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18760;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18761;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18762;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18763;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18764;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18765;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18766;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18767;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18768;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18769;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18770;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18771;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18772;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18773;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18774;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18775;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18776;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 18819;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 18822;
UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 18824;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18835;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18838;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18849;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18850;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18851;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 18852;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18878;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18892;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18914;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 18921;
UPDATE `creature_model_info` SET `bounding_radius` = '2.6' WHERE modelid = 18923;
UPDATE `creature_model_info` SET `combat_reach` = '5.98' WHERE modelid = 18923;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18924;
UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 18991;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18992;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18993;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18994;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18995;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19086;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19087;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19088;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19089;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19128;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 19131;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19140;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 19153;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19156;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19159;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 19160;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19207;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 19219;
UPDATE `creature_model_info` SET `bounding_radius` = '1.25' WHERE modelid = 19249;
UPDATE `creature_model_info` SET `combat_reach` = '2.5' WHERE modelid = 19249;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19282;
UPDATE `creature_model_info` SET `combat_reach` = '2.1' WHERE modelid = 19345;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19354;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19355;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19356;
UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 19385;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19385;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19522;
UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 19643;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19695;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 19698;
UPDATE `creature_model_info` SET `combat_reach` = '2.4' WHERE modelid = 19719;
UPDATE `creature_model_info` SET `bounding_radius` = '1' WHERE modelid = 19720;
UPDATE `creature_model_info` SET `bounding_radius` = '1' WHERE modelid = 19721;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19789;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19790;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19791;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19794;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19795;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 19844;
UPDATE `creature_model_info` SET `combat_reach` = '2.65' WHERE modelid = 19905;
UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 19912;
UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 19912;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19983;
UPDATE `creature_model_info` SET `bounding_radius` = '0.31' WHERE modelid = 19998;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 19998;
UPDATE `creature_model_info` SET `combat_reach` = '2.5' WHERE modelid = 20024;
UPDATE `creature_model_info` SET `bounding_radius` = '0.2325' WHERE modelid = 20025;
UPDATE `creature_model_info` SET `combat_reach` = '0.75' WHERE modelid = 20025;
UPDATE `creature_model_info` SET `bounding_radius` = '0.443055' WHERE modelid = 20062;
UPDATE `creature_model_info` SET `combat_reach` = '1.45' WHERE modelid = 20062;
UPDATE `creature_model_info` SET `bounding_radius` = '0.397222' WHERE modelid = 20063;
UPDATE `creature_model_info` SET `combat_reach` = '1.3' WHERE modelid = 20063;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 20128;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 20168;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20186;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20190;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20266;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20267;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20268;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 20269;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20290;
UPDATE `creature_model_info` SET `bounding_radius` = '0.6' WHERE modelid = 20297;
UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 20297;
UPDATE `creature_model_info` SET `bounding_radius` = '0.6' WHERE modelid = 20308;
UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 20308;
UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 20309;
UPDATE `creature_model_info` SET `combat_reach` = '2.5' WHERE modelid = 20554;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20564;
UPDATE `creature_model_info` SET `combat_reach` = '1.45' WHERE modelid = 20572;
UPDATE `creature_model_info` SET `combat_reach` = '0.9' WHERE modelid = 20588;
UPDATE `creature_model_info` SET `combat_reach` = '4' WHERE modelid = 20597;
UPDATE `creature_model_info` SET `combat_reach` = '4.25' WHERE modelid = 20617;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20659;
UPDATE `creature_model_info` SET `combat_reach` = '1.45' WHERE modelid = 20682;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20692;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20696;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20725;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20741;
UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 20744;
UPDATE `creature_model_info` SET `combat_reach` = '1.6' WHERE modelid = 20766;
UPDATE `creature_model_info` SET `combat_reach` = '2.2' WHERE modelid = 20790;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20818;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20868;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 20869;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20873;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20875;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20969;
UPDATE `creature_model_info` SET `combat_reach` = '10' WHERE modelid = 21018;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21022;
UPDATE `creature_model_info` SET `combat_reach` = '1.45' WHERE modelid = 21032;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21065;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 21082;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21100;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 21113;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21389;
UPDATE `creature_model_info` SET `combat_reach` = '2.1' WHERE modelid = 21504;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 21514;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 21520;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 21521;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 21522;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 21523;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 21524;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 21525;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 21572;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 21573;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21697;
UPDATE `creature_model_info` SET `bounding_radius` = '1.5' WHERE modelid = 22042;
UPDATE `creature_model_info` SET `combat_reach` = '0.75' WHERE modelid = 22431;
UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 22673;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 22716;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22730;
UPDATE `creature_model_info` SET `bounding_radius` = '2.5' WHERE modelid = 22734;
UPDATE `creature_model_info` SET `combat_reach` = '2.5' WHERE modelid = 22734;
UPDATE `creature_model_info` SET `bounding_radius` = '1.2' WHERE modelid = 22747;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 22747;
UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 22757;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22757;
UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 22926;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22926;
UPDATE `creature_model_info` SET `bounding_radius` = '0.47875' WHERE modelid = 22928;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 22928;
UPDATE `creature_model_info` SET `bounding_radius` = '1.25' WHERE modelid = 22929;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 22929;
UPDATE `creature_model_info` SET `bounding_radius` = '0.47875' WHERE modelid = 22930;
UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 22930;
UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 22931;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22931;
UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 22933;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22933;
UPDATE `creature_model_info` SET `bounding_radius` = '1' WHERE modelid = 22941;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22941;
UPDATE `creature_model_info` SET `bounding_radius` = '1' WHERE modelid = 22944;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22944;
UPDATE `creature_model_info` SET `bounding_radius` = '1.35' WHERE modelid = 22951;
UPDATE `creature_model_info` SET `combat_reach` = '2.025' WHERE modelid = 22951;
UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 22952;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22952;
UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 22953;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22953;
UPDATE `creature_model_info` SET `bounding_radius` = '1.2' WHERE modelid = 22968;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 22968;
UPDATE `creature_model_info` SET `bounding_radius` = '0.3519' WHERE modelid = 23467;
UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 23467;
UPDATE `creature_model_info` SET `combat_reach` = '0.35' WHERE modelid = 23501;
UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 23812;
UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 23825;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24087;
UPDATE `creature_model_info` SET `combat_reach` = '1.515' WHERE modelid = 24270;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24271;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24276;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24277;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24278;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24279;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24292;
UPDATE `creature_model_info` SET `combat_reach` = '1.35' WHERE modelid = 24299;
UPDATE `creature_model_info` SET `combat_reach` = '1.35' WHERE modelid = 24300;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24305;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24306;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24310;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24367;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24475;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24492;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24503;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24507;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24604;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 24670;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24805;
UPDATE `creature_model_info` SET `bounding_radius` = '0.465' WHERE modelid = 25008;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25008;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 25944;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25960;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26066;
UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 26856;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27285;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27300;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 28738;
UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 28758;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28770;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28788;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28789;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28790;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28791;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28792;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28793;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28794;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28795;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28796;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28797;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28798;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28799;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28800;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28802;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28803;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28806;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28808;
UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28809;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 29516;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 29517;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 29518;
UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 29519;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 620;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 1410;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 1410;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2914;
UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 3230;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3230;
UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 4076;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 5355;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5355;
UPDATE `creature_template` SET `faction_A` = '1802', `faction_H` = '1802' WHERE entry = 15241;
UPDATE `creature_template` SET `faction_A` = '85', `faction_H` = '85' WHERE entry = 15242;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 15242;
UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 16574;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16574;
UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 16575;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16575;
UPDATE `creature_template` SET `faction_A` = '1669', `faction_H` = '1669' WHERE entry = 16576;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16577;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16577;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16578;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16578;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16579;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 16580;
UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 16580;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16580;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 16582;
UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 16582;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16582;
UPDATE `creature_template` SET `faction_A` = '1669', `faction_H` = '1669' WHERE entry = 16584;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16584;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16585;
UPDATE `creature_template` SET `faction_A` = '1729', `faction_H` = '1729' WHERE entry = 16586;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16586;
UPDATE `creature_template` SET `faction_A` = '1729', `faction_H` = '1729' WHERE entry = 16587;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16587;
UPDATE `creature_template` SET `faction_A` = '1729', `faction_H` = '1729' WHERE entry = 16588;
UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 16589;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16589;
UPDATE `creature_template` SET `faction_A` = '1669', `faction_H` = '1669' WHERE entry = 16590;
UPDATE `creature_template` SET `faction_A` = '1729', `faction_H` = '1729' WHERE entry = 16591;
UPDATE `creature_template` SET `faction_A` = '1668', `faction_H` = '1668' WHERE entry = 16599;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16599;
UPDATE `creature_template` SET `faction_A` = '1669', `faction_H` = '1669' WHERE entry = 16600;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16602;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 16769;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 16772;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16772;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16789;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16790;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16790;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16791;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16791;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16792;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16792;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16793;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16793;
UPDATE `creature_template` SET `faction_A` = '68', `faction_H` = '68' WHERE entry = 16794;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16794;
UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 16795;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 16795;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16795;
UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16796;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16796;
UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16797;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16797;
UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16798;
UPDATE `creature_template` SET `faction_A` = '1640', `faction_H` = '1640' WHERE entry = 16799;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16799;
UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 16805;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16805;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 16810;
UPDATE `creature_template` SET `faction_A` = '1697', `faction_H` = '1697' WHERE entry = 16810;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16810;
UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 16820;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16820;
UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 16821;
UPDATE `creature_template` SET `faction_A` = '1737', `faction_H` = '1737' WHERE entry = 16822;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16822;
UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 16823;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16823;
UPDATE `creature_template` SET `faction_A` = '1737', `faction_H` = '1737' WHERE entry = 16824;
UPDATE `creature_template` SET `faction_A` = '1667', `faction_H` = '1667' WHERE entry = 16825;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16825;
UPDATE `creature_template` SET `faction_A` = '1667', `faction_H` = '1667' WHERE entry = 16826;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16826;
UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 16827;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16827;
UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 16828;
UPDATE `creature_template` SET `unit_flags` = '4161' WHERE entry = 16830;
UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 16830;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16830;
UPDATE `creature_template` SET `unit_flags` = '576' WHERE entry = 16831;
UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 16831;
UPDATE `creature_template` SET `faction_A` = '1640', `faction_H` = '1640' WHERE entry = 16833;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16833;
UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16834;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16834;
UPDATE `creature_template` SET `faction_A` = '1640', `faction_H` = '1640' WHERE entry = 16836;
UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 16837;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16837;
UPDATE `creature_template` SET `faction_A` = '1737', `faction_H` = '1737' WHERE entry = 16838;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 16842;
UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 16842;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16842;
UPDATE `creature_template` SET `unit_flags` = '33554432' WHERE entry = 16844;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16844;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16845;
UPDATE `creature_template` SET `faction_A` = '1651', `faction_H` = '1651' WHERE entry = 16846;
UPDATE `creature_template` SET `faction_A` = '1651', `faction_H` = '1651' WHERE entry = 16847;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 16848;
UPDATE `creature_template` SET `faction_A` = '1651', `faction_H` = '1651' WHERE entry = 16848;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16848;
UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 16850;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16850;
UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 16851;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16851;
UPDATE `creature_template` SET `unit_flags` = '537137920' WHERE entry = 16852;
UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 16852;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16852;
UPDATE `creature_template` SET `unit_flags` = '33554432' WHERE entry = 16857;
UPDATE `creature_template` SET `faction_A` = '1669', `faction_H` = '1669' WHERE entry = 16858;
UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 16863;
UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 16863;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 16864;
UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 16864;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 16867;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 16870;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 16871;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 16873;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16873;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 16876;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 16878;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16878;
UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 16879;
UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 16880;
UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 16880;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16896;
UPDATE `creature_template` SET `faction_A` = '1664', `faction_H` = '1664' WHERE entry = 16904;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 16904;
UPDATE `creature_template` SET `faction_A` = '1664', `faction_H` = '1664' WHERE entry = 16905;
UPDATE `creature_template` SET `faction_A` = '1664', `faction_H` = '1664' WHERE entry = 16906;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 16906;
UPDATE `creature_template` SET `faction_A` = '1663', `faction_H` = '1663' WHERE entry = 16907;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 16907;
UPDATE `creature_template` SET `faction_A` = '1651', `faction_H` = '1651' WHERE entry = 16911;
UPDATE `creature_template` SET `faction_A` = '1651', `faction_H` = '1651' WHERE entry = 16912;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 16915;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 16927;
UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 16927;
UPDATE `creature_template` SET `faction_A` = '1873', `faction_H` = '1873' WHERE entry = 16927;
UPDATE `creature_template` SET `speed_run` = '0.496031' WHERE entry = 16928;
UPDATE `creature_template` SET `speed_walk` = '0.5' WHERE entry = 16928;
UPDATE `creature_template` SET `faction_A` = '1873', `faction_H` = '1873' WHERE entry = 16928;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16928;
UPDATE `creature_template` SET `faction_A` = '1873', `faction_H` = '1873' WHERE entry = 16929;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 16933;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 16937;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16937;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 16938;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 16947;
UPDATE `creature_template` SET `faction_A` = '1752', `faction_H` = '1752' WHERE entry = 16950;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16950;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 16951;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 16954;
UPDATE `creature_template` SET `unit_flags` = '65' WHERE entry = 16959;
UPDATE `creature_template` SET `faction_A` = '1752', `faction_H` = '1752' WHERE entry = 16959;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 16960;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 16960;
UPDATE `creature_template` SET `faction_A` = '1663', `faction_H` = '1663' WHERE entry = 16964;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 16966;
UPDATE `creature_template` SET `unit_flags` = '33554432' WHERE entry = 16968;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16968;
UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 16974;
UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 16975;
UPDATE `creature_template` SET `scale` = '1.5' WHERE entry = 16975;
UPDATE `creature_template` SET `unit_flags` = '33587456' WHERE entry = 16976;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 16977;
UPDATE `creature_template` SET `faction_A` = '1664', `faction_H` = '1664' WHERE entry = 16977;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 16978;
UPDATE `creature_template` SET `faction_A` = '1664', `faction_H` = '1664' WHERE entry = 16978;
UPDATE `creature_template` SET `unit_flags` = '67108864' WHERE entry = 16992;
UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 16992;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 16992;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16992;
UPDATE `creature_template` SET `faction_A` = '1654', `faction_H` = '1654' WHERE entry = 17006;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17015;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 17015;
UPDATE `creature_template` SET `faction_A` = '73', `faction_H` = '73' WHERE entry = 17035;
UPDATE `creature_template` SET `faction_A` = '73', `faction_H` = '73' WHERE entry = 17039;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 17039;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 17039;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17046;
UPDATE `creature_template` SET `faction_A` = '1654', `faction_H` = '1654' WHERE entry = 17052;
UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 17053;
UPDATE `creature_template` SET `unit_flags` = '81' WHERE entry = 17057;
UPDATE `creature_template` SET `faction_A` = '1873', `faction_H` = '1873' WHERE entry = 17057;
UPDATE `creature_template` SET `faction_A` = '1813', `faction_H` = '1813' WHERE entry = 17058;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 17059;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 17060;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 17084;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 17085;
UPDATE `creature_template` SET `speed_walk` = '1.4' WHERE entry = 17085;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 17085;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 17123;
UPDATE `creature_template` SET `faction_A` = '1651', `faction_H` = '1651' WHERE entry = 17123;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 17130;
UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 17226;
UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 17226;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17226;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 17226;
UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 17230;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 17230;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 17230;
UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 17250;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 17250;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 17250;
UPDATE `creature_template` SET `faction_A` = '188', `faction_H` = '188' WHERE entry = 17250;
UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 17251;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 17251;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 17251;
UPDATE `creature_template` SET `faction_A` = '1658', `faction_H` = '1658' WHERE entry = 17263;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17277;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 17277;
UPDATE `creature_template` SET `unit_flags` = '36864' WHERE entry = 17282;
UPDATE `creature_template` SET `faction_A` = '1656', `faction_H` = '1656' WHERE entry = 17282;
UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 17402;
UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17402;
UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17403;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 17467;
UPDATE `creature_template` SET `faction_A` = '1668', `faction_H` = '1668' WHERE entry = 17493;
UPDATE `creature_template` SET `faction_A` = '1668', `faction_H` = '1668' WHERE entry = 17558;
UPDATE `creature_template` SET `faction_A` = '1669', `faction_H` = '1669' WHERE entry = 17585;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 17585;
UPDATE `creature_template` SET `faction_A` = '1667', `faction_H` = '1667' WHERE entry = 17657;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 17657;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 17794;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 17794;
UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 17794;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 17795;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 17795;
UPDATE `creature_template` SET `faction_A` = '83', `faction_H` = '83' WHERE entry = 17795;
UPDATE `creature_template` SET `unit_flags` = '33025' WHERE entry = 18166;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18166;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 18252;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18252;
UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 18260;
UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 18262;
UPDATE `creature_template` SET `faction_A` = '1737', `faction_H` = '1737' WHERE entry = 18266;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18266;
UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 18273;
UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 18318;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 18318;
UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 18318;
UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 18323;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 18323;
UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 18327;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 18327;
UPDATE `creature_template` SET `baseattacktime` = '1800' WHERE entry = 18327;
UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 18328;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 18328;
UPDATE `creature_template` SET `baseattacktime` = '1800' WHERE entry = 18328;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 18387;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18387;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 18389;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18389;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 18390;
UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 18449;
UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 18449;
UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 18450;
UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 18451;
UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 18451;
UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 18455;
UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 18455;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 18459;
UPDATE `creature_template` SET `faction_A` = '49', `faction_H` = '49' WHERE entry = 18463;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18469;
UPDATE `creature_template` SET `faction_A` = '45', `faction_H` = '45' WHERE entry = 18475;
UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 18475;
UPDATE `creature_template` SET `faction_A` = '38', `faction_H` = '38' WHERE entry = 18477;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18481;
UPDATE `creature_template` SET `unit_flags` = '257' WHERE entry = 18481;
UPDATE `creature_template` SET `faction_A` = '1741', `faction_H` = '1741' WHERE entry = 18481;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18481;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 18484;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 18484;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18484;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18525;
UPDATE `creature_template` SET `unit_flags` = '257' WHERE entry = 18525;
UPDATE `creature_template` SET `faction_A` = '1741', `faction_H` = '1741' WHERE entry = 18525;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18525;
UPDATE `creature_template` SET `unit_flags` = '33025' WHERE entry = 18530;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18530;
UPDATE `creature_template` SET `unit_flags` = '33537' WHERE entry = 18531;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18531;
UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 18540;
UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 18540;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 18547;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18547;
UPDATE `creature_template` SET `faction_A` = '534', `faction_H` = '534' WHERE entry = 18565;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18565;
UPDATE `creature_template` SET `faction_A` = '1746', `faction_H` = '1746' WHERE entry = 18568;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18568;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 18583;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18583;
UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 18584;
UPDATE `creature_template` SET `speed_walk` = '0.944444' WHERE entry = 18584;
UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 18584;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 18584;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18584;
UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 18585;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18585;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 18593;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18593;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 18594;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18594;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 18595;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 18595;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18595;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 18596;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18596;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 18597;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18597;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 18600;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18600;
UPDATE `creature_template` SET `faction_A` = '1731', `faction_H` = '1731' WHERE entry = 18622;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18622;
UPDATE `creature_template` SET `speed_run` = '1.28571' WHERE entry = 18647;
UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 18647;
UPDATE `creature_template` SET `unit_flags` = '32833' WHERE entry = 18648;
UPDATE `creature_template` SET `faction_A` = '49', `faction_H` = '49' WHERE entry = 18648;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 18652;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18652;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 18653;
UPDATE `creature_template` SET `faction_A` = '38', `faction_H` = '38' WHERE entry = 18670;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18670;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 18704;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18704;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 18713;
UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 18733;
UPDATE `creature_template` SET `speed_walk` = '2.8' WHERE entry = 18733;
UPDATE `creature_template` SET `unit_flags` = '32833' WHERE entry = 18733;
UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 18733;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 18745;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18747;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18748;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18752;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18754;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18755;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 18756;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18756;
UPDATE `creature_template` SET `unit_flags` = '36864' WHERE entry = 18758;
UPDATE `creature_template` SET `faction_A` = '1639', `faction_H` = '1639' WHERE entry = 18758;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 18762;
UPDATE `creature_template` SET `faction_A` = '1737', `faction_H` = '1737' WHERE entry = 18772;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 18772;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18774;
UPDATE `creature_template` SET `faction_A` = '1737', `faction_H` = '1737' WHERE entry = 18777;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18779;
UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 18785;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18785;
UPDATE `creature_template` SET `faction_A` = '1737', `faction_H` = '1737' WHERE entry = 18809;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18809;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 18827;
UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 18827;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 18828;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 18843;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 18893;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18893;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18905;
UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 18906;
UPDATE `creature_template` SET `baseattacktime` = '1000' WHERE entry = 18906;
UPDATE `creature_template` SET `unit_flags` = '33537' WHERE entry = 18930;
UPDATE `creature_template` SET `faction_A` = '1760', `faction_H` = '1760' WHERE entry = 18930;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18930;
UPDATE `creature_template` SET `unit_flags` = '33537' WHERE entry = 18931;
UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 18931;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18931;
UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 18933;
UPDATE `creature_template` SET `baseattacktime` = '1200' WHERE entry = 18933;
UPDATE `creature_template` SET `unit_flags` = '33537' WHERE entry = 18940;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18940;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18942;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18942;
UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 18944;
UPDATE `creature_template` SET `faction_A` = '1754', `faction_H` = '1754' WHERE entry = 18944;
UPDATE `creature_template` SET `faction_A` = '1754', `faction_H` = '1754' WHERE entry = 18945;
UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 18946;
UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 18948;
UPDATE `creature_template` SET `unit_flags` = '559361' WHERE entry = 18949;
UPDATE `creature_template` SET `faction_A` = '1755', `faction_H` = '1755' WHERE entry = 18949;
UPDATE `creature_template` SET `unit_flags` = '559376' WHERE entry = 18950;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18950;
UPDATE `creature_template` SET `faction_A` = '1663', `faction_H` = '1663' WHERE entry = 18952;
UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 18965;
UPDATE `creature_template` SET `unit_flags` = '559361' WHERE entry = 18966;
UPDATE `creature_template` SET `faction_A` = '1757', `faction_H` = '1757' WHERE entry = 18966;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18966;
UPDATE `creature_template` SET `unit_flags` = '559361' WHERE entry = 18969;
UPDATE `creature_template` SET `faction_A` = '1759', `faction_H` = '1759' WHERE entry = 18969;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18969;
UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 18970;
UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 18971;
UPDATE `creature_template` SET `faction_A` = '1759', `faction_H` = '1759' WHERE entry = 18971;
UPDATE `creature_template` SET `unit_flags` = '559361' WHERE entry = 18972;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 18974;
UPDATE `creature_template` SET `faction_A` = '1752', `faction_H` = '1752' WHERE entry = 18975;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 18975;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18975;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 18977;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 18978;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 18981;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 18981;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 18986;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18987;
UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 18990;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18990;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18991;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18991;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18997;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18997;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18998;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18998;
UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 19001;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19001;
UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 19004;
UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 19005;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 19006;
UPDATE `creature_template` SET `unit_flags` = '33025' WHERE entry = 19006;
UPDATE `creature_template` SET `faction_A` = '1760', `faction_H` = '1760' WHERE entry = 19006;
UPDATE `creature_template` SET `unit_flags` = '33025' WHERE entry = 19007;
UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 19007;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 19032;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19033;
UPDATE `creature_template` SET `baseattacktime` = '1000' WHERE entry = 19033;
UPDATE `creature_template` SET `unit_flags` = '33025' WHERE entry = 19034;
UPDATE `creature_template` SET `faction_A` = '1743', `faction_H` = '1743' WHERE entry = 19034;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19034;
UPDATE `creature_template` SET `faction_A` = '210', `faction_H` = '210' WHERE entry = 19038;
UPDATE `creature_template` SET `faction_A` = '210', `faction_H` = '210' WHERE entry = 19042;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19042;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 19045;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19045;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 19047;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19047;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 19049;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19049;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 19051;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19051;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 19052;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19052;
UPDATE `creature_template` SET `faction_A` = '210', `faction_H` = '210' WHERE entry = 19053;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19053;
UPDATE `creature_template` SET `faction_A` = '210', `faction_H` = '210' WHERE entry = 19056;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19064;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 19074;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19074;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 19075;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19075;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19076;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19076;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19077;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19120;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19120;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19136;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19144;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19144;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 19147;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19150;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19154;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 19155;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 19155;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19155;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19159;
UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 19162;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 19162;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19162;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 19163;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 19164;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19170;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19170;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19180;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19182;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19182;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19184;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 19185;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19186;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19186;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19187;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19187;
UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 19188;
UPDATE `creature_template` SET `faction_A` = '778', `faction_H` = '778' WHERE entry = 19188;
UPDATE `creature_template` SET `speed_run` = '2' WHERE entry = 19189;
UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 19189;
UPDATE `creature_template` SET `faction_A` = '1752', `faction_H` = '1752' WHERE entry = 19190;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19194;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19194;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19195;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19195;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19196;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19196;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19197;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19197;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19202;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19202;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19213;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19213;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 19215;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19216;
UPDATE `creature_template` SET `faction_A` = '1956', `faction_H` = '1956' WHERE entry = 19216;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19216;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19223;
UPDATE `creature_template` SET `unit_flags` = '37120' WHERE entry = 19227;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19227;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19229;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19232;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19232;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19234;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19235;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19236;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19238;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19238;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19239;
UPDATE `creature_template` SET `faction_A` = '1744', `faction_H` = '1744' WHERE entry = 19239;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19239;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19240;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19240;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19242;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19242;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19243;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19243;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19244;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19244;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19245;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19246;
UPDATE `creature_template` SET `faction_A` = '1744', `faction_H` = '1744' WHERE entry = 19246;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19246;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19248;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19248;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19249;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19249;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19250;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19251;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19251;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19252;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19253;
UPDATE `creature_template` SET `faction_A` = '1760', `faction_H` = '1760' WHERE entry = 19253;
UPDATE `creature_template` SET `faction_A` = '1669', `faction_H` = '1669' WHERE entry = 19255;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19255;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19261;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19263;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 19264;
UPDATE `creature_template` SET `unit_flags` = '32833' WHERE entry = 19264;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19264;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19270;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19270;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19271;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19271;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19273;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 19275;
UPDATE `creature_template` SET `speed_walk` = '4' WHERE entry = 19275;
UPDATE `creature_template` SET `faction_A` = '1729', `faction_H` = '1729' WHERE entry = 19275;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19275;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 19276;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 19276;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19282;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 19282;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19283;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19289;
UPDATE `creature_template` SET `unit_flags` = '33555208' WHERE entry = 19291;
UPDATE `creature_template` SET `unit_flags` = '33555208' WHERE entry = 19292;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19295;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19296;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 19297;
UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 19297;
UPDATE `creature_template` SET `unit_flags` = '65' WHERE entry = 19299;
UPDATE `creature_template` SET `faction_A` = '1752', `faction_H` = '1752' WHERE entry = 19299;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19299;
UPDATE `creature_template` SET `faction_A` = '1667', `faction_H` = '1667' WHERE entry = 19308;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19308;
UPDATE `creature_template` SET `faction_A` = '1666', `faction_H` = '1666' WHERE entry = 19310;
UPDATE `creature_template` SET `faction_A` = '1667', `faction_H` = '1667' WHERE entry = 19314;
UPDATE `creature_template` SET `faction_A` = '1669', `faction_H` = '1669' WHERE entry = 19315;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19315;
UPDATE `creature_template` SET `faction_A` = '1667', `faction_H` = '1667' WHERE entry = 19316;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19318;
UPDATE `creature_template` SET `faction_A` = '1743', `faction_H` = '1743' WHERE entry = 19318;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19318;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19321;
UPDATE `creature_template` SET `faction_A` = '1743', `faction_H` = '1743' WHERE entry = 19321;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19321;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19330;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19330;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19331;
UPDATE `creature_template` SET `faction_A` = '1744', `faction_H` = '1744' WHERE entry = 19331;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19332;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 19336;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19338;
UPDATE `creature_template` SET `faction_A` = '1744', `faction_H` = '1744' WHERE entry = 19338;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19338;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19344;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 19350;
UPDATE `creature_template` SET `speed_run` = '1.38889' WHERE entry = 19354;
UPDATE `creature_template` SET `unit_flags` = '32833' WHERE entry = 19354;
UPDATE `creature_template` SET `faction_A` = '51', `faction_H` = '51' WHERE entry = 19354;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 19358;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 19359;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 19361;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19361;
UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 19363;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19367;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 19376;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19377;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19377;
UPDATE `creature_template` SET `unit_flags` = '34078720' WHERE entry = 19381;
UPDATE `creature_template` SET `faction_A` = '1752', `faction_H` = '1752' WHERE entry = 19381;
UPDATE `creature_template` SET `faction_A` = '1666', `faction_H` = '1666' WHERE entry = 19392;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 19393;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19397;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19397;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19398;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19399;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19400;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19401;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19408;
UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 19408;
UPDATE `creature_template` SET `faction_A` = '1666', `faction_H` = '1666' WHERE entry = 19409;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19410;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19411;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19413;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19414;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19415;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19417;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 19417;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19422;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19423;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19423;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19424;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19425;
UPDATE `creature_template` SET `faction_A` = '1760', `faction_H` = '1760' WHERE entry = 19425;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19426;
UPDATE `creature_template` SET `faction_A` = '1760', `faction_H` = '1760' WHERE entry = 19426;
UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 19429;
UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 19429;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19429;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 19432;
UPDATE `creature_template` SET `faction_A` = '1760', `faction_H` = '1760' WHERE entry = 19432;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19434;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19435;
UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 19435;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19436;
UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 19436;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19440;
UPDATE `creature_template` SET `baseattacktime` = '10000' WHERE entry = 19440;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19442;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19444;
UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 19444;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19446;
UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 19446;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 19447;
UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 19447;
UPDATE `creature_template` SET `baseattacktime` = '1000' WHERE entry = 19447;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19451;
UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 19451;
UPDATE `creature_template` SET `unit_flags` = '33025' WHERE entry = 19455;
UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 19455;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19458;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19458;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19459;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19459;
UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 19460;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19460;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 19460;
UPDATE `creature_template` SET `faction_A` = '1651', `faction_H` = '1651' WHERE entry = 19461;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19461;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19475;
UPDATE `creature_template` SET `faction_A` = '1956', `faction_H` = '1956' WHERE entry = 19475;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19485;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19485;
UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 19558;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19558;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 19560;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 19561;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 19624;
UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 19624;
UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 19640;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19640;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 19640;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19640;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19661;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19661;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19662;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19663;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19663;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19664;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19664;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 19665;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 19665;
UPDATE `creature_template` SET `faction_A` = '31', `faction_H` = '31' WHERE entry = 19665;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19678;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19678;
UPDATE `creature_template` SET `faction_A` = '1669', `faction_H` = '1669' WHERE entry = 19682;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19682;
UPDATE `creature_template` SET `faction_A` = '1669', `faction_H` = '1669' WHERE entry = 19683;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19683;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19684;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19684;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 19687;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19687;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19689;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19693;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 19697;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 19697;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 19701;
UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 19702;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19715;
UPDATE `creature_template` SET `faction_A` = '1741', `faction_H` = '1741' WHERE entry = 19715;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19715;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 19717;
UPDATE `creature_template` SET `unit_flags` = '33601' WHERE entry = 19720;
UPDATE `creature_template` SET `faction_A` = '1194', `faction_H` = '1194' WHERE entry = 19720;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19720;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19725;
UPDATE `creature_template` SET `faction_A` = '1194', `faction_H` = '1194' WHERE entry = 19725;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19725;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 19726;
UPDATE `creature_template` SET `faction_A` = '1194', `faction_H` = '1194' WHERE entry = 19726;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19726;
UPDATE `creature_template` SET `faction_A` = '1669', `faction_H` = '1669' WHERE entry = 19736;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19736;
UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 19773;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19836;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19937;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 20123;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 20124;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20124;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 20125;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20125;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 20145;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20159;
UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 20159;
UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 20159;
UPDATE `creature_template` SET `baseattacktime` = '2500' WHERE entry = 20159;
UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 20206;
UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 20206;
UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 20206;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20236;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20331;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 20613;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20677;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20677;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20678;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20678;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20679;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20679;
UPDATE `creature_template` SET `speed_run` = '1.38889' WHERE entry = 20680;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 20680;
UPDATE `creature_template` SET `faction_A` = '51', `faction_H` = '51' WHERE entry = 20680;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 20680;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20680;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 20791;
UPDATE `creature_template` SET `faction_A` = '1741', `faction_H` = '1741' WHERE entry = 20791;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20791;
UPDATE `creature_template` SET `faction_A` = '1667', `faction_H` = '1667' WHERE entry = 20793;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20793;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 20807;
UPDATE `creature_template` SET `faction_A` = '1743', `faction_H` = '1743' WHERE entry = 20807;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20807;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 20808;
UPDATE `creature_template` SET `faction_A` = '1744', `faction_H` = '1744' WHERE entry = 20808;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20808;
UPDATE `creature_template` SET `faction_A` = '534', `faction_H` = '534' WHERE entry = 21006;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21006;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 21075;
UPDATE `creature_template` SET `faction_A` = '1666', `faction_H` = '1666' WHERE entry = 21133;
UPDATE `creature_template` SET `unit_flags` = '258' WHERE entry = 21134;
UPDATE `creature_template` SET `faction_A` = '1662', `faction_H` = '1662' WHERE entry = 21134;
UPDATE `creature_template` SET `baseattacktime` = '10000' WHERE entry = 21134;
UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 21175;
UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 21209;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 21236;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21256;
UPDATE `creature_template` SET `faction_A` = '68', `faction_H` = '68' WHERE entry = 21257;
UPDATE `creature_template` SET `faction_A` = '68', `faction_H` = '68' WHERE entry = 21279;
UPDATE `creature_template` SET `faction_A` = '1751', `faction_H` = '1751' WHERE entry = 21284;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 21397;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 21398;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 21399;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 21400;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21411;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 21432;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 21434;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 21517;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 21655;
UPDATE `creature_template` SET `faction_A` = '49', `faction_H` = '49' WHERE entry = 21816;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21816;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 21847;
UPDATE `creature_template` SET `unit_flags` = '33554432' WHERE entry = 21849;
UPDATE `creature_template` SET `faction_A` = '49', `faction_H` = '49' WHERE entry = 21854;
UPDATE `creature_template` SET `unit_flags` = '33587456' WHERE entry = 21869;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 21869;
UPDATE `creature_template` SET `unit_flags` = '33587456' WHERE entry = 21870;
UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 21902;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 21903;
UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 21905;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 21905;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 21931;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 21963;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 22001;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 22002;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 22003;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 22095;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 22095;
UPDATE `creature_template` SET `faction_A` = '413', `faction_H` = '413' WHERE entry = 22100;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 22100;
UPDATE `creature_template` SET `faction_A` = '1729', `faction_H` = '1729' WHERE entry = 22225;
UPDATE `creature_template` SET `faction_A` = '1667', `faction_H` = '1667' WHERE entry = 22227;
UPDATE `creature_template` SET `faction_A` = '32', `faction_H` = '32' WHERE entry = 22265;
UPDATE `creature_template` SET `unit_flags` = '33587968' WHERE entry = 22288;
UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 22288;
UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 22307;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 22307;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 22314;
UPDATE `creature_template` SET `unit_flags` = '33587968' WHERE entry = 22340;
UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 22340;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 22371;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 22381;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 22381;
UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 22387;
UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 22387;
UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 22388;
UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 22388;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 22430;
UPDATE `creature_template` SET `faction_A` = '774', `faction_H` = '774' WHERE entry = 22431;
UPDATE `creature_template` SET `unit_flags` = '32770' WHERE entry = 22432;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 22441;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 22441;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 22441;
UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 22461;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 22497;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 22497;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 22497;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 22819;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 22831;
UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 22940;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 22987;
UPDATE `creature_template` SET `faction_A` = '1856', `faction_H` = '1856' WHERE entry = 22987;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 23263;
UPDATE `creature_template` SET `unit_flags` = '33025' WHERE entry = 23270;
UPDATE `creature_template` SET `faction_A` = '1743', `faction_H` = '1743' WHERE entry = 23270;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 23272;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 23273;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 23461;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 23462;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 23463;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 23464;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 23465;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 23466;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 23483;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 23484;
UPDATE `creature_template` SET `faction_A` = '1743', `faction_H` = '1743' WHERE entry = 23484;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 23745;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 23762;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 23764;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 23766;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 23830;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 23845;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 23850;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 23852;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 23853;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 23854;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 23855;
UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 24026;
UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 24261;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 24261;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 24369;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 24370;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 24393;
UPDATE `creature_template` SET `speed_walk` = '0.4' WHERE entry = 24412;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 24412;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 24416;
UPDATE `creature_template` SET `unit_class` = '2' WHERE entry = 24433;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 24433;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 24433;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 24434;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 24436;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 24437;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 24437;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 24885;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 24885;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 24901;
UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 24905;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 24905;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 24920;
UPDATE `creature_template` SET `faction_A` = '1873', `faction_H` = '1873' WHERE entry = 24920;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 24920;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 24922;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 24922;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 24928;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 24928;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 24932;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 24936;
UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 24938;
UPDATE `creature_template` SET `faction_A` = '1957', `faction_H` = '1957' WHERE entry = 24938;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 24938;
UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 25115;
UPDATE `creature_template` SET `faction_A` = '1960', `faction_H` = '1960' WHERE entry = 25115;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25115;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25134;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25135;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25136;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25137;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 25138;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25138;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 25140;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25140;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 25141;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25141;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25142;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25143;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 25153;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25153;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 25155;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25155;
UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 25167;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25167;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 25195;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 25196;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25885;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25967;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 25992;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25992;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 26363;
UPDATE `creature_template` SET `unit_flags` = '67141632' WHERE entry = 26363;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 26363;
UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 26369;
UPDATE `creature_template` SET `speed_run` = '2.14286' WHERE entry = 26422;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 26422;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 26423;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 26423;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 26424;
UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 26425;
UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26425;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 26446;
UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 26446;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 26447;
UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26447;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26447;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26457;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26457;
UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 26458;
UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26458;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26458;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26461;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 26461;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26461;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 26498;
UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26513;
UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 26513;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26513;
UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26516;
UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 26516;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26516;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 26519;
UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26544;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26544;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 26559;
UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26570;
UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26570;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26570;
UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26582;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26582;
UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26583;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26583;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 26591;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 26592;
UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 26592;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 26604;
UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 26616;
UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 26643;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 26785;
UPDATE `creature_template` SET `unit_flags` = '36864' WHERE entry = 26839;
UPDATE `creature_template` SET `faction_A` = '1979', `faction_H` = '1979' WHERE entry = 26864;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26875;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 27062;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 27068;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27072;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27072;
UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 27105;
UPDATE `creature_template` SET `speed_walk` = '2.4' WHERE entry = 27105;
UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 27105;
UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 27105;
UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 27117;
UPDATE `creature_template` SET `faction_A` = '1315', `faction_H` = '1315' WHERE entry = 27117;
UPDATE `creature_template` SET `unit_flags` = '563200' WHERE entry = 27118;
UPDATE `creature_template` SET `faction_A` = '1314', `faction_H` = '1314' WHERE entry = 27118;
UPDATE `creature_template` SET `speed_run` = '1.28571' WHERE entry = 27259;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27277;
UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 27292;
UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 27292;
UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 27292;
UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27293;
UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 27297;
UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 27326;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 27408;
UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 27408;
UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 27408;
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 27469;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27470;
UPDATE `creature_template` SET `faction_A` = '1314', `faction_H` = '1314' WHERE entry = 27470;
UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 27479;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27546;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 27546;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27547;
UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 27547;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27617;
UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 27666;
UPDATE `creature_template` SET `faction_A` = '1960', `faction_H` = '1960' WHERE entry = 27666;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 27666;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 27667;
UPDATE `creature_template` SET `faction_A` = '1960', `faction_H` = '1960' WHERE entry = 27667;
UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 27667;
UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 27783;
UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 27941;
UPDATE `creature_template` SET `speed_run` = '3.57143' WHERE entry = 28243;
UPDATE `creature_template` SET `speed_walk` = '4' WHERE entry = 28243;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29269;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30722;
UPDATE `creature_template` SET `faction_A` = '1729', `faction_H` = '1729' WHERE entry = 30722;
UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30735;
UPDATE `creature_template` SET `faction_A` = '1729', `faction_H` = '1729' WHERE entry = 30735;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31889;
UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31890;
UPDATE `creature_template` SET `unit_flags` = '33032' WHERE entry = 32663;
UPDATE `creature_template` SET `maxdmg` = '15.4371' WHERE entry = 32663;
UPDATE `creature_template` SET `mindmg` = '13.0774' WHERE entry = 32663;
UPDATE `creature_template` SET `attackpower` = '862' WHERE entry = 32663;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33608;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33609;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33610;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33611;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33612;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33613;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33614;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33615;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33616;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33617;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33618;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33619;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33621;
UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 33623;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33630;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33631;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33633;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33634;
UPDATE `creature_template` SET `faction_A` = '1744', `faction_H` = '1744' WHERE entry = 33634;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33635;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33636;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33637;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33638;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33639;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33640;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33641;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33642;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33674;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33675;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33677;
UPDATE `creature_template` SET `faction_A` = '1743', `faction_H` = '1743' WHERE entry = 33677;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33678;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33681;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33683;
UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33684;
UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 34999;
UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 35000;
UPDATE `creature_template` SET `faction_A` = '83', `faction_H` = '83' WHERE entry = 35001;
UPDATE `creature_template` SET `faction_A` = '83', `faction_H` = '83' WHERE entry = 35002;
UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 35093;
UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 35093;
UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 35099;
UPDATE `creature_template` SET `faction_A` = '1669', `faction_H` = '1669' WHERE entry = 35099;
UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 35100;
UPDATE `creature_template` SET `faction_A` = '1078', `faction_H` = '1078' WHERE entry = 35100;
UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 35101;
UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 40438;
UPDATE `creature_template` SET `speed_run` = '0.5' WHERE entry = 46954;
UPDATE `creature_template` SET `unit_flags` = '32776' WHERE entry = 46954;
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
|