|
---|
|
Другое / Other Другие ошибки базы. Если сообщение не подходит под ошибки заселения, баги предметов, или отсутствие рабочих скриптов - в этот раздел. |
Ссылки сообщества |
Изображения и альбомы |
Пользователи |
Поиск по форуму |
Поиск по метке |
Расширенный поиск |
Найти все сообщения с благодарностями |
К странице... |
|
Опции темы | Поиск в этой теме | Опции просмотра |
10.02.2011, 02:01 | #11 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
227+ кб данных)))
Код:
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 385; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 721; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 883; UPDATE `creature_template` SET `faction_A` = '31', `faction_H` = '31' WHERE entry = 883; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 890; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 1412; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 1420; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 1984; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 1985; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 1988; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 1989; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 1995; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 1996; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 1997; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 1998; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 1999; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2000; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2010; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 2010; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2011; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 2011; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2015; UPDATE `creature_template` SET `speed_walk` = '1.38889' WHERE entry = 2015; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2017; UPDATE `creature_template` SET `speed_walk` = '1.38889' WHERE entry = 2017; UPDATE `creature_template` SET `baseattacktime` = '1200' WHERE entry = 2017; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2018; UPDATE `creature_template` SET `speed_walk` = '1.38889' WHERE entry = 2018; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2019; UPDATE `creature_template` SET `speed_walk` = '1.38889' WHERE entry = 2019; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2020; UPDATE `creature_template` SET `speed_walk` = '1.38889' WHERE entry = 2020; UPDATE `creature_template` SET `speed_walk` = '1.38889' WHERE entry = 2021; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2031; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2032; UPDATE `creature_template` SET `baseattacktime` = '1400' WHERE entry = 2033; UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 2041; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 2041; UPDATE `creature_template` SET `baseattacktime` = '1400' WHERE entry = 2042; UPDATE `creature_template` SET `faction_A` = '66', `faction_H` = '66' WHERE entry = 2043; UPDATE `creature_template` SET `baseattacktime` = '1400' WHERE entry = 2043; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 2077; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 2079; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 2080; UPDATE `creature_template` SET `baseattacktime` = '1000' WHERE entry = 2081; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 2082; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 2082; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 2083; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 2150; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 2151; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2152; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 2152; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 2155; UPDATE `creature_template` SET `npcflag` = '2' WHERE entry = 2155; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2162; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 2162; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 2162; UPDATE `creature_template` SET `faction_A` = '82', `faction_H` = '82' WHERE entry = 2162; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 2334; UPDATE `creature_template` SET `faction_A` = '12', `faction_H` = '12' WHERE entry = 2334; UPDATE `creature_template` SET `unit_flags` = '8' WHERE entry = 2523; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 2796; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 2796; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 2912; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3306; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3468; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3469; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 3514; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 3517; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 3561; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3561; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 3562; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3562; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3571; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 3587; UPDATE `creature_template` SET `npcflag` = '896' WHERE entry = 3587; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 3588; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 3589; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 3590; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 3591; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 3592; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 3593; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 3594; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 3595; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 3596; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 3597; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3603; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3605; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3606; UPDATE `creature_template` SET `npcflag` = '896' WHERE entry = 3608; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3835; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 4075; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4087; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 4087; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4087; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4088; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4088; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4089; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4089; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4090; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4090; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4091; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4091; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4092; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4092; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4138; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 4138; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4138; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4146; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4146; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4155; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4155; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4156; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4156; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4159; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4159; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4160; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4160; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4161; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4161; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4163; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4164; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4164; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4165; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4165; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4167; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4167; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4168; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4168; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4169; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4170; UPDATE `creature_template` SET `npcflag` = '896' WHERE entry = 4170; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4170; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4171; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4171; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4172; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4172; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4173; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4173; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4175; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4177; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4177; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4180; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4180; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4181; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4181; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4203; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4203; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4204; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4204; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4205; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 4205; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4205; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4208; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4208; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4209; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4209; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4210; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4212; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4212; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4213; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4213; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4214; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4214; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4215; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4215; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4216; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4216; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4217; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4217; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4218; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4218; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4219; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4219; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4220; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4220; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4221; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4221; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4222; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4222; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4223; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4225; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4225; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4226; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4228; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4228; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4229; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4229; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4230; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4230; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4231; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4231; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4232; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4232; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4233; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4233; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4234; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4234; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4235; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4236; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4236; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4240; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4240; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4241; UPDATE `creature_template` SET `npcflag` = '899' WHERE entry = 4241; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4241; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 4242; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4242; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4242; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4243; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4243; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4244; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4244; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 4262; UPDATE `creature_template` SET `unit_flags` = '36864' WHERE entry = 4262; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4262; UPDATE `creature_template` SET `npcflag` = '131' WHERE entry = 4265; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4423; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4521; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4593; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4594; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4595; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 4606; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4606; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4607; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4730; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4730; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 4753; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4753; UPDATE `creature_template` SET `faction_A` = '814', `faction_H` = '814' WHERE entry = 4783; UPDATE `creature_template` SET `faction_A` = '814', `faction_H` = '814' WHERE entry = 4784; UPDATE `creature_template` SET `faction_A` = '814', `faction_H` = '814' WHERE entry = 4786; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 5047; UPDATE `creature_template` SET `npcflag` = '524289' WHERE entry = 5047; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 5191; UPDATE `creature_template` SET `unit_flags` = '563200' WHERE entry = 5653; UPDATE `creature_template` SET `unit_flags` = '563200' WHERE entry = 5654; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5679; UPDATE `creature_template` SET `unit_flags` = '526592' WHERE entry = 5680; UPDATE `creature_template` SET `unit_flags` = '526592' WHERE entry = 5681; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 5782; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5782; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 6034; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6034; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 6091; UPDATE `creature_template` SET `npcflag` = '643' WHERE entry = 6091; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 6142; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6142; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 6145; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 6292; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6292; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 6368; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 6735; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6735; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6736; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 6780; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 7296; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7296; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 7313; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 7315; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7315; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 7316; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 7553; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 7553; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 7555; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 7555; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 7690; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 7740; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7740; UPDATE `creature_template` SET `unit_flags` = '36928' WHERE entry = 7999; UPDATE `creature_template` SET `faction_A` = '124', `faction_H` = '124' WHERE entry = 7999; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 8026; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8026; UPDATE `creature_template` SET `npcflag` = '2' WHERE entry = 8396; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8396; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 8583; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 8583; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 8665; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8665; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 8669; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8669; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 8723; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8723; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 8996; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 8996; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 9047; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 10051; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 10056; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 10056; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 10089; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 10089; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 10606; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 10878; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 10928; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 10928; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 10928; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 11041; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 11042; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11042; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 11050; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 11070; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11070; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 11081; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11081; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 11083; UPDATE `creature_template` SET `faction_A` = '1076', `faction_H` = '1076' WHERE entry = 11401; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 11401; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11401; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 11700; UPDATE `creature_template` SET `npcflag` = '2' WHERE entry = 11700; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11700; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 11709; UPDATE `creature_template` SET `npcflag` = '2' WHERE entry = 11709; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 11942; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12160; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 12922; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12922; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 13321; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 14378; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14378; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 14379; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14379; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 14380; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14380; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 14431; UPDATE `creature_template` SET `speed_walk` = '1.38889' WHERE entry = 14431; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 14431; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14431; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 14555; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 14556; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 14602; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 15271; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 15274; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 15281; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 15281; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 15289; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 15289; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 15289; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 15291; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 15291; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 15291; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 15292; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 15292; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 15292; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 15294; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 15297; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 15297; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 15297; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 15301; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 15301; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 15366; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 15371; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 15372; UPDATE `creature_template` SET `faction_A` = '189', `faction_H` = '189' WHERE entry = 15372; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 15403; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 15403; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 15416; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 15416; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 15418; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 15418; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 15433; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 15433; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 15468; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 15493; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 15493; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 15595; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 15595; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 15598; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 15598; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 15624; UPDATE `creature_template` SET `faction_A` = '91', `faction_H` = '91' WHERE entry = 15638; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 15644; UPDATE `creature_template` SET `faction_A` = '7', `faction_H` = '7' WHERE entry = 15649; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 15654; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 15655; UPDATE `creature_template` SET `speed_walk` = '0.777776' WHERE entry = 15655; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 15655; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 15655; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 15678; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 15678; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 15679; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 15679; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 15893; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 15894; UPDATE `creature_template` SET `faction_A` = '114', `faction_H` = '114' WHERE entry = 15897; UPDATE `creature_template` SET `unit_flags` = '530440' WHERE entry = 15938; UPDATE `creature_template` SET `faction_A` = '1603', `faction_H` = '1603' WHERE entry = 15938; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 15938; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 15949; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 15949; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16185; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16185; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16186; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16186; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16192; UPDATE `creature_template` SET `faction_A` = '1603', `faction_H` = '1603' WHERE entry = 16221; UPDATE `creature_template` SET `faction_A` = '1603', `faction_H` = '1603' WHERE entry = 16222; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16222; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16257; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16257; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16258; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16258; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16259; UPDATE `creature_template` SET `npcflag` = '897' WHERE entry = 16259; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16259; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16262; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16262; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16266; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16266; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16267; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16267; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16269; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16269; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16270; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16270; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16271; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16271; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16272; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16273; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16273; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16275; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16275; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16276; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16276; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16277; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16278; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16278; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16279; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16279; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16442; UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 16476; UPDATE `creature_template` SET `unit_flags` = '37120' WHERE entry = 16499; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16499; UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 16500; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16500; UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 16503; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16503; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 16516; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 16517; UPDATE `creature_template` SET `faction_A` = '7', `faction_H` = '7' WHERE entry = 16517; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 16520; UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 16535; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16535; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16551; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16553; UPDATE `creature_template` SET `baseattacktime` = '1000' WHERE entry = 16553; UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 16554; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16554; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16568; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16610; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16610; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16612; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16612; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16613; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16613; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16615; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16615; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16616; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16616; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16617; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16617; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16618; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16618; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16619; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16619; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16620; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16620; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16623; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16623; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16624; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16624; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16625; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16625; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16626; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16626; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16627; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16628; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16629; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16631; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16631; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16632; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16633; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16634; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16635; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16635; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16636; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16636; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16646; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16647; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16648; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 16648; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16649; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16649; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16651; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16652; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16653; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 16653; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16654; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16654; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16655; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16656; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16656; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16658; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 16658; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16659; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16660; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16662; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16663; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16664; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16664; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16667; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16668; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16669; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16669; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 16670; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16670; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16671; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16672; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 16672; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16673; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16674; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 16674; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16675; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16675; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16676; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16677; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16677; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16679; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16680; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16681; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 16681; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16683; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16683; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16684; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16685; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16686; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16687; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16688; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16689; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16689; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16690; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16690; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16692; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16693; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16693; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16703; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16705; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16706; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16708; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16709; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16710; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16712; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16715; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16718; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16721; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16722; UPDATE `creature_template` SET `npcflag` = '896' WHERE entry = 16732; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16732; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 16733; UPDATE `creature_template` SET `faction_A` = '1639', `faction_H` = '1639' WHERE entry = 16733; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16733; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 16734; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16735; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 16739; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16739; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 16749; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16755; UPDATE `creature_template` SET `npcflag` = '2176' WHERE entry = 16757; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16757; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 16761; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16764; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16766; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16768; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16780; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16782; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16782; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16800; UPDATE `creature_template` SET `unit_flags` = '32833' WHERE entry = 16801; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16801; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16802; UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 16897; UPDATE `creature_template` SET `faction_A` = '15', `faction_H` = '15' WHERE entry = 16897; UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 16899; UPDATE `creature_template` SET `faction_A` = '15', `faction_H` = '15' WHERE entry = 16899; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 16916; UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 16919; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16919; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16919; UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 16920; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16920; UPDATE `creature_template` SET `npcflag` = '896' WHERE entry = 16920; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16920; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 16921; UPDATE `creature_template` SET `faction_A` = '1639', `faction_H` = '1639' WHERE entry = 16921; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16923; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16923; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 16924; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 16924; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 16971; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17005; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17005; UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 17071; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 17073; UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 17089; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17089; UPDATE `creature_template` SET `unit_flags` = '37632' WHERE entry = 17101; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17110; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 17114; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 17114; UPDATE `creature_template` SET `faction_A` = '774', `faction_H` = '774' WHERE entry = 17114; UPDATE `creature_template` SET `unit_flags` = '37120' WHERE entry = 17117; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 17117; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 17122; UPDATE `creature_template` SET `faction_A` = '91', `faction_H` = '91' WHERE entry = 17197; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 17200; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 17200; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 17201; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 17201; UPDATE `creature_template` SET `baseattacktime` = '1600' WHERE entry = 17203; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17212; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 17213; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17214; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17215; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17222; UPDATE `creature_template` SET `npcflag` = '211' WHERE entry = 17222; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17228; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17232; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 17252; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 17252; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 17372; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 17373; UPDATE `creature_template` SET `unit_flags` = '37120' WHERE entry = 17425; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17425; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17431; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 17435; UPDATE `creature_template` SET `faction_A` = '1640', `faction_H` = '1640' WHERE entry = 17468; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 17468; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17480; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 17481; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17481; UPDATE `creature_template` SET `speed_walk` = '0.9' WHERE entry = 17482; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17482; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17483; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17484; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17484; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17485; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17485; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17486; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17486; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17488; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17488; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 17505; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17512; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 17513; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 17519; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 17520; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 17520; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 17538; UPDATE `creature_template` SET `unit_flags` = '832' WHERE entry = 17538; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 17538; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 17555; UPDATE `creature_template` SET `faction_A` = '80', `faction_H` = '80' WHERE entry = 17614; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17630; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17630; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17631; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17631; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17632; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17632; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17633; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17633; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17717; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17718; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 17718; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17768; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17769; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17773; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17845; UPDATE `creature_template` SET `unit_flags` = '537137920' WHERE entry = 17849; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17849; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 17849; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17849; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 17929; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17929; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17929; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 17930; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17930; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17930; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 17983; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 17983; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18038; UPDATE `creature_template` SET `faction_A` = '1639', `faction_H` = '1639' WHERE entry = 18038; UPDATE `creature_template` SET `faction_A` = '1603', `faction_H` = '1603' WHERE entry = 18103; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18103; UPDATE `creature_template` SET `faction_A` = '1656', `faction_H` = '1656' WHERE entry = 18147; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 18147; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18174; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18175; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 18187; UPDATE `creature_template` SET `faction_A` = '126', `faction_H` = '126' WHERE entry = 18188; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18191; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18230; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18231; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18232; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18237; UPDATE `creature_template` SET `faction_A` = '1695', `faction_H` = '1695' WHERE entry = 18277; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18347; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 18350; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 18375; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 18376; UPDATE `creature_template` SET `unit_flags` = '33685760' WHERE entry = 18504; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18527; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18626; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18627; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18629; UPDATE `creature_template` SET `faction_A` = '1695', `faction_H` = '1695' WHERE entry = 18727; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 18727; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18743; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18744; UPDATE `creature_template` SET `unit_flags` = '4352' WHERE entry = 18763; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18763; UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 18781; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18781; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18790; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18792; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18800; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 18810; UPDATE `creature_template` SET `npcflag` = '896' WHERE entry = 18810; UPDATE `creature_template` SET `speed_run` = '0.628572' WHERE entry = 18815; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 18823; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 18823; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 18825; UPDATE `creature_template` SET `speed_walk` = '1.55556' WHERE entry = 18826; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 18826; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18899; UPDATE `creature_template` SET `faction_A` = '1639', `faction_H` = '1639' WHERE entry = 18899; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18900; UPDATE `creature_template` SET `faction_A` = '1639', `faction_H` = '1639' WHERE entry = 18900; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18901; UPDATE `creature_template` SET `faction_A` = '1639', `faction_H` = '1639' WHERE entry = 18901; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18902; UPDATE `creature_template` SET `faction_A` = '1639', `faction_H` = '1639' WHERE entry = 18902; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18903; UPDATE `creature_template` SET `faction_A` = '1639', `faction_H` = '1639' WHERE entry = 18903; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18915; UPDATE `creature_template` SET `faction_A` = '1639', `faction_H` = '1639' WHERE entry = 18915; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18916; UPDATE `creature_template` SET `faction_A` = '1639', `faction_H` = '1639' WHERE entry = 18916; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18921; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18924; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18926; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 18926; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 18929; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 18929; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 18955; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 18955; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 19073; UPDATE `creature_template` SET `faction_A` = '534', `faction_H` = '534' WHERE entry = 19073; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 19169; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 19658; UPDATE `creature_template` SET `unit_flags` = '2056' WHERE entry = 19668; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 19668; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 19775; UPDATE `creature_template` SET `faction_A` = '1695', `faction_H` = '1695' WHERE entry = 19882; UPDATE `creature_template` SET `unit_flags` = '33280' WHERE entry = 20087; UPDATE `creature_template` SET `faction_A` = '1695', `faction_H` = '1695' WHERE entry = 20087; UPDATE `creature_template` SET `faction_A` = '1603', `faction_H` = '1603' WHERE entry = 20672; UPDATE `creature_template` SET `faction_A` = '1639', `faction_H` = '1639' WHERE entry = 20674; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 20722; UPDATE `creature_template` SET `speed_run` = '2.85714' WHERE entry = 20725; UPDATE `creature_template` SET `faction_A` = '188', `faction_H` = '188' WHERE entry = 20725; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20846; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20847; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20848; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20849; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20850; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 21008; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 21008; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 21010; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 21010; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 21018; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 21018; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 21019; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 21376; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 21376; UPDATE `creature_template` SET `unit_flags` = '33587968' WHERE entry = 21757; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 23033; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 23988; UPDATE `creature_template` SET `faction_A` = '91', `faction_H` = '91' WHERE entry = 24601; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 24613; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 24614; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 24614; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 24637; UPDATE `creature_template` SET `speed_run` = '0.142857' WHERE entry = 24879; UPDATE `creature_template` SET `speed_walk` = '0.4' WHERE entry = 24879; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 24921; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 24957; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 24957; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 25148; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 25149; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 25150; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 25150; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 25151; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 25152; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 25152; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 25200; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 25202; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 25207; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 25220; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 25222; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 25223; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 25227; UPDATE `creature_template` SET `faction_A` = '1988', `faction_H` = '1988' WHERE entry = 25227; UPDATE `creature_template` SET `faction_A` = '1975', `faction_H` = '1975' WHERE entry = 25228; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 25228; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25228; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 25264; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 25271; UPDATE `creature_template` SET `unit_flags` = '34081536' WHERE entry = 25297; UPDATE `creature_template` SET `faction_A` = '1703', `faction_H` = '1703' WHERE entry = 25297; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 25307; UPDATE `creature_template` SET `unit_flags` = '34816' WHERE entry = 25311; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 25313; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25313; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 25317; UPDATE `creature_template` SET `unit_flags` = '537166594' WHERE entry = 25342; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 25350; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25350; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25353; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25355; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 25355; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 25355; UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 25377; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 25377; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 25377; UPDATE `creature_template` SET `baseattacktime` = '5000' WHERE entry = 25377; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 25378; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25378; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 25383; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 25383; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 25386; UPDATE `creature_template` SET `speed_run` = '1.28571' WHERE entry = 25387; UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 25387; UPDATE `creature_template` SET `faction_A` = '974', `faction_H` = '974' WHERE entry = 25387; UPDATE `creature_template` SET `speed_run` = '2' WHERE entry = 25390; UPDATE `creature_template` SET `speed_walk` = '0.833332' WHERE entry = 25390; UPDATE `creature_template` SET `unit_flags` = '33554432' WHERE entry = 25390; UPDATE `creature_template` SET `baseattacktime` = '200' WHERE entry = 25390; UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 25391; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 25392; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 25392; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 25393; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 25393; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 25393; UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 25395; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 25396; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 25396; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 25396; UPDATE `creature_template` SET `baseattacktime` = '6000' WHERE entry = 25422; UPDATE `creature_template` SET `unit_flags` = '4864' WHERE entry = 25425; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25427; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25427; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25428; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25428; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25429; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25429; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 25430; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25430; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 25431; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 25432; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25432; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 25433; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25433; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 25434; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25434; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 25434; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25444; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 25452; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 25452; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 25452; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 25454; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 25464; UPDATE `creature_template` SET `faction_A` = '188', `faction_H` = '188' WHERE entry = 25464; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25467; UPDATE `creature_template` SET `faction_A` = '1985', `faction_H` = '1985' WHERE entry = 25467; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25468; UPDATE `creature_template` SET `faction_A` = '1985', `faction_H` = '1985' WHERE entry = 25468; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25470; UPDATE `creature_template` SET `faction_A` = '1985', `faction_H` = '1985' WHERE entry = 25470; UPDATE `creature_template` SET `unit_flags` = '33554944' WHERE entry = 25492; UPDATE `creature_template` SET `speed_walk` = '1.55556' WHERE entry = 25514; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 25516; UPDATE `creature_template` SET `faction_A` = '1922', `faction_H` = '1922' WHERE entry = 25516; UPDATE `creature_template` SET `faction_A` = '974', `faction_H` = '974' WHERE entry = 25534; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 25582; UPDATE `creature_template` SET `faction_A` = '1988', `faction_H` = '1988' WHERE entry = 25582; UPDATE `creature_template` SET `speed_walk` = '1.8' WHERE entry = 25589; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 25589; UPDATE `creature_template` SET `faction_A` = '1973', `faction_H` = '1973' WHERE entry = 25589; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 25589; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 25601; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 25601; UPDATE `creature_template` SET `faction_A` = '974', `faction_H` = '974' WHERE entry = 25601; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 25604; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 25604; UPDATE `creature_template` SET `faction_A` = '1975', `faction_H` = '1975' WHERE entry = 25605; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 25605; UPDATE `creature_template` SET `faction_A` = '1921', `faction_H` = '1921' WHERE entry = 25606; UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 25606; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 25615; UPDATE `creature_template` SET `faction_A` = '1953', `faction_H` = '1953' WHERE entry = 25615; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 25617; UPDATE `creature_template` SET `faction_A` = '1974', `faction_H` = '1974' WHERE entry = 25617; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 25623; UPDATE `creature_template` SET `speed_walk` = '0.777776' WHERE entry = 25650; UPDATE `creature_template` SET `faction_A` = '1975', `faction_H` = '1975' WHERE entry = 25650; UPDATE `creature_template` SET `faction_A` = '1975', `faction_H` = '1975' WHERE entry = 25651; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 25651; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 25668; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 25677; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 25679; UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 25679; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 25680; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25685; UPDATE `creature_template` SET `faction_A` = '18', `faction_H` = '18' WHERE entry = 25685; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25686; UPDATE `creature_template` SET `faction_A` = '18', `faction_H` = '18' WHERE entry = 25686; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25686; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25687; UPDATE `creature_template` SET `faction_A` = '18', `faction_H` = '18' WHERE entry = 25687; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25699; UPDATE `creature_template` SET `faction_A` = '18', `faction_H` = '18' WHERE entry = 25699; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25700; UPDATE `creature_template` SET `faction_A` = '18', `faction_H` = '18' WHERE entry = 25700; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 25701; UPDATE `creature_template` SET `faction_A` = '18', `faction_H` = '18' WHERE entry = 25701; UPDATE `creature_template` SET `speed_walk` = '1.55556' WHERE entry = 25715; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 25725; UPDATE `creature_template` SET `faction_A` = '18', `faction_H` = '18' WHERE entry = 25725; UPDATE `creature_template` SET `speed_run` = '2' WHERE entry = 25743; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 25743; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 25747; UPDATE `creature_template` SET `speed_run` = '2.57143' WHERE entry = 25748; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 25750; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25752; UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 25753; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25753; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25758; UPDATE `creature_template` SET `unit_flags` = '33587200' WHERE entry = 25760; UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 25762; UPDATE `creature_template` SET `speed_walk` = '2.4' WHERE entry = 25762; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 25764; UPDATE `creature_template` SET `faction_A` = '1973', `faction_H` = '1973' WHERE entry = 25783; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 25791; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25806; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 25811; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 25812; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 25814; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 25814; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 25816; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 25816; UPDATE `creature_template` SET `speed_run` = '2.57143' WHERE entry = 25817; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 25817; UPDATE `creature_template` SET `speed_run` = '3.42857' WHERE entry = 25819; UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 25819; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 25825; UPDATE `creature_template` SET `faction_A` = '1989', `faction_H` = '1989' WHERE entry = 25839; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 25844; UPDATE `creature_template` SET `faction_A` = '1989', `faction_H` = '1989' WHERE entry = 25844; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 25850; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 26073; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 26073; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 26073; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 26076; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 26076; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 26076; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 26083; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 26084; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 26085; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 26094; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 26098; UPDATE `creature_template` SET `faction_A` = '974', `faction_H` = '974' WHERE entry = 26103; UPDATE `creature_template` SET `faction_A` = '974', `faction_H` = '974' WHERE entry = 26115; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 26161; UPDATE `creature_template` SET `faction_A` = '114', `faction_H` = '114' WHERE entry = 26161; UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 26170; UPDATE `creature_template` SET `faction_A` = '1892', `faction_H` = '1892' WHERE entry = 26170; UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 26171; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 26172; UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 26173; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 26173; UPDATE `creature_template` SET `speed_run` = '2.14286' WHERE entry = 26174; UPDATE `creature_template` SET `speed_walk` = '0.888888' WHERE entry = 26185; UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 26185; UPDATE `creature_template` SET `unit_flags` = '258' WHERE entry = 26189; UPDATE `creature_template` SET `faction_A` = '1975', `faction_H` = '1975' WHERE entry = 26189; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 26191; UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 26191; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 26202; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26203; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 26203; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 26219; UPDATE `creature_template` SET `faction_A` = '1975', `faction_H` = '1975' WHERE entry = 26224; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 26224; UPDATE `creature_template` SET `faction_A` = '1975', `faction_H` = '1975' WHERE entry = 26225; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 26225; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 26248; UPDATE `creature_template` SET `speed_run` = '1.07143' WHERE entry = 26266; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 26266; UPDATE `creature_template` SET `faction_A` = '1771', `faction_H` = '1771' WHERE entry = 26266; UPDATE `creature_template` SET `speed_run` = '4.71429' WHERE entry = 26310; UPDATE `creature_template` SET `speed_walk` = '8' WHERE entry = 26310; UPDATE `creature_template` SET `unit_flags` = '320' WHERE entry = 26310; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 26310; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 26525; UPDATE `creature_template` SET `speed_walk` = '0.4' WHERE entry = 26525; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 26549; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 26556; UPDATE `creature_template` SET `npcflag` = '83' WHERE entry = 27001; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 27010; UPDATE `creature_template` SET `npcflag` = '4992' WHERE entry = 27011; UPDATE `creature_template` SET `faction_A` = '2148', `faction_H` = '2148' WHERE entry = 27189; UPDATE `creature_template` SET `npcflag` = '896' WHERE entry = 27193; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 27364; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 27365; UPDATE `creature_template` SET `unit_flags` = '33587200' WHERE entry = 27365; UPDATE `creature_template` SET `baseattacktime` = '1300' WHERE entry = 27365; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 27385; UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 27569; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 27610; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 27610; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 27859; UPDATE `creature_template` SET `faction_A` = '974', `faction_H` = '974' WHERE entry = 27859; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 27859; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 27860; UPDATE `creature_template` SET `faction_A` = '974', `faction_H` = '974' WHERE entry = 27860; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 27860; UPDATE `creature_template` SET `faction_A` = '1603', `faction_H` = '1603' WHERE entry = 27946; UPDATE `creature_template` SET `unit_flags` = '295168' WHERE entry = 27987; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 28001; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28009; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 28093; UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 28093; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 28101; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28103; UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 28103; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28108; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28109; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28110; UPDATE `creature_template` SET `faction_A` = '1999', `faction_H` = '1999' WHERE entry = 28129; UPDATE `creature_template` SET `speed_run` = '2.14286' WHERE entry = 28170; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28189; UPDATE `creature_template` SET `unit_class` = '8' WHERE entry = 28189; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 28189; UPDATE `creature_template` SET `faction_A` = '974', `faction_H` = '974' WHERE entry = 28189; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 28195; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28207; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 28208; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 28208; UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 28208; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28211; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28212; UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 28212; UPDATE `creature_template` SET `speed_walk` = '0.777776' WHERE entry = 28218; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28218; UPDATE `creature_template` SET `speed_run` = '1.07143' WHERE entry = 28242; UPDATE `creature_template` SET `VehicleID` = '105' WHERE entry = 28288; UPDATE `creature_template` SET `unit_flags` = '33554944' WHERE entry = 28320; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 28379; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28379; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 28380; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28380; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 28381; UPDATE `creature_template` SET `scale` = '1.28' WHERE entry = 28440; UPDATE `creature_template` SET `faction_A` = '2080', `faction_H` = '2080' WHERE entry = 28538; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 29123; UPDATE `creature_template` SET `speed_run` = '1.28571' WHERE entry = 29328; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29377; UPDATE `creature_template` SET `unit_flags` = '526848' WHERE entry = 29377; UPDATE `creature_template` SET `faction_A` = '2102', `faction_H` = '2102' WHERE entry = 29377; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29390; UPDATE `creature_template` SET `unit_flags` = '526592' WHERE entry = 29477; UPDATE `creature_template` SET `speed_run` = '0.595239' WHERE entry = 29624; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 29724; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 29746; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 29752; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29950; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 29950; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29959; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 29960; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29965; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29978; UPDATE `creature_template` SET `faction_A` = '2102', `faction_H` = '2102' WHERE entry = 29978; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29979; UPDATE `creature_template` SET `faction_A` = '2102', `faction_H` = '2102' WHERE entry = 29979; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 29980; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 29980; UPDATE `creature_template` SET `faction_A` = '1770', `faction_H` = '1770' WHERE entry = 29980; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 29981; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 29981; UPDATE `creature_template` SET `faction_A` = '1770', `faction_H` = '1770' WHERE entry = 29981; UPDATE `creature_template` SET `speed_run` = '1.5873' WHERE entry = 29984; UPDATE `creature_template` SET `speed_walk` = '0.888888' WHERE entry = 29984; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 29984; UPDATE `creature_template` SET `faction_A` = '2102', `faction_H` = '2102' WHERE entry = 29984; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 30035; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 30148; UPDATE `creature_template` SET `unit_flags` = '536871680' WHERE entry = 30148; UPDATE `creature_template` SET `faction_A` = '1711', `faction_H` = '1711' WHERE entry = 30148; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 30148; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 30164; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30164; UPDATE `creature_template` SET `faction_A` = '1712', `faction_H` = '1712' WHERE entry = 30164; UPDATE `creature_template` SET `faction_A` = '12', `faction_H` = '12' WHERE entry = 30217; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 30270; UPDATE `creature_template` SET `unit_flags` = '32776' WHERE entry = 30270; UPDATE `creature_template` SET `speed_run` = '4.28571' WHERE entry = 30281; UPDATE `creature_template` SET `unit_flags` = '33587968' WHERE entry = 30343; UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 30376; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 30376; UPDATE `creature_template` SET `faction_A` = '2102', `faction_H` = '2102' WHERE entry = 30376; UPDATE `creature_template` SET `speed_run` = '0.992057' WHERE entry = 30597; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 30597; UPDATE `creature_template` SET `faction_A` = '974', `faction_H` = '974' WHERE entry = 30597; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30710; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 30710; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30715; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30716; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30727; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 30727; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30731; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30732; UPDATE `creature_template` SET `faction_A` = '1638', `faction_H` = '1638' WHERE entry = 30732; UPDATE `creature_template` SET `unit_flags` = '33554944' WHERE entry = 30744; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 30744; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 30894; UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 30894; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30921; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 30921; UPDATE `creature_template` SET `speed_run` = '1.07143' WHERE entry = 30922; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30922; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 30922; UPDATE `creature_template` SET `unit_flags` = '33554944' WHERE entry = 30950; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 30950; UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 30953; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 30953; UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 30956; UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 30988; UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 30988; UPDATE `creature_template` SET `faction_A` = '974', `faction_H` = '974' WHERE entry = 30988; UPDATE `creature_template` SET `unit_flags` = '33554432' WHERE entry = 30990; UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 31075; UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 31075; UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 31137; UPDATE `creature_template` SET `faction_A` = '974', `faction_H` = '974' WHERE entry = 31137; UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 31139; UPDATE `creature_template` SET `speed_walk` = '2.4' WHERE entry = 31139; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 31139; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 31140; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 31142; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 31142; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 31142; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 31144; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 31145; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 31146; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 31147; UPDATE `creature_template` SET `speed_walk` = '2.4' WHERE entry = 31147; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 31147; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31152; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 31152; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 31152; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 31155; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 31155; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 31163; UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 31163; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 31177; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31205; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 31205; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 31221; UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 31221; UPDATE `creature_template` SET `faction_A` = '974', `faction_H` = '974' WHERE entry = 31221; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 31255; UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 31255; UPDATE `creature_template` SET `unit_flags` = '33587456' WHERE entry = 31281; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 31281; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 31304; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31685; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 31702; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 31747; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 31754; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 31779; UPDATE `creature_template` SET `speed_run` = '2' WHERE entry = 31780; UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 31780; UPDATE `creature_template` SET `speed_run` = '1.07143' WHERE entry = 31783; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31788; UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 31788; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31789; UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 31789; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31790; UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 31790; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31791; UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 31791; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31792; UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 31792; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31793; UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 31793; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 31847; UPDATE `creature_template` SET `speed_run` = '1.07143' WHERE entry = 31853; UPDATE `creature_template` SET `speed_run` = '2.57143' WHERE entry = 32492; UPDATE `creature_template` SET `speed_walk` = '1.4' WHERE entry = 32492; UPDATE `creature_template` SET `scale` = '1.44' WHERE entry = 32498; UPDATE `creature_template` SET `speed_run` = '0.142857' WHERE entry = 32544; UPDATE `creature_template` SET `speed_walk` = '0.4' WHERE entry = 32544; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 32666; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 32667; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33222; UPDATE `creature_template` SET `faction_A` = '1078', `faction_H` = '1078' WHERE entry = 33222; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33223; UPDATE `creature_template` SET `faction_A` = '1078', `faction_H` = '1078' WHERE entry = 33223; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33225; UPDATE `creature_template` SET `faction_A` = '1078', `faction_H` = '1078' WHERE entry = 33225; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33243; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33272; UPDATE `creature_template` SET `baseattacktime` = '1000' WHERE entry = 33272; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33285; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33285; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33306; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33307; UPDATE `creature_template` SET `faction_A` = '1078', `faction_H` = '1078' WHERE entry = 33307; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33309; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33310; UPDATE `creature_template` SET `faction_A` = '2155', `faction_H` = '2155' WHERE entry = 33310; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33312; UPDATE `creature_template` SET `faction_A` = '2155', `faction_H` = '2155' WHERE entry = 33312; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33315; UPDATE `creature_template` SET `faction_A` = '2155', `faction_H` = '2155' WHERE entry = 33315; UPDATE `creature_template` SET `unit_flags` = '16777224' WHERE entry = 33320; UPDATE `creature_template` SET `unit_flags` = '17301512' WHERE entry = 33321; UPDATE `creature_template` SET `unit_flags` = '17301512' WHERE entry = 33324; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33335; UPDATE `creature_template` SET `faction_A` = '64', `faction_H` = '64' WHERE entry = 33335; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33361; UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 33361; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 33361; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33372; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33373; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33379; UPDATE `creature_template` SET `faction_A` = '1695', `faction_H` = '1695' WHERE entry = 33379; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33382; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33382; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33383; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33383; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33384; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33384; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33403; UPDATE `creature_template` SET `faction_A` = '104', `faction_H` = '104' WHERE entry = 33403; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33405; UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 33405; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 33447; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33447; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33459; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33462; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33463; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33465; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33467; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33474; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33477; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33480; UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 33513; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 33518; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33518; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 33522; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33522; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33538; UPDATE `creature_template` SET `faction_A` = '1695', `faction_H` = '1695' WHERE entry = 33538; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33539; UPDATE `creature_template` SET `faction_A` = '104', `faction_H` = '104' WHERE entry = 33539; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33540; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33541; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33542; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 33542; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 33543; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33544; UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 33544; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33545; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33547; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33548; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 33548; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33549; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33553; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33554; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33555; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33556; UPDATE `creature_template` SET `faction_A` = '104', `faction_H` = '104' WHERE entry = 33556; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33557; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 33557; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33558; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33558; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33559; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33559; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33560; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33561; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33562; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33562; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33564; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33564; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33592; UPDATE `creature_template` SET `faction_A` = '1076', `faction_H` = '1076' WHERE entry = 33592; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33593; UPDATE `creature_template` SET `faction_A` = '1694', `faction_H` = '1694' WHERE entry = 33593; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 33595; UPDATE `creature_template` SET `npcflag` = '130' WHERE entry = 33595; UPDATE `creature_template` SET `npcflag` = '130' WHERE entry = 33601; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33625; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 33643; UPDATE `creature_template` SET `faction_A` = '2071', `faction_H` = '2071' WHERE entry = 33644; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33645; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33646; UPDATE `creature_template` SET `faction_A` = '2027', `faction_H` = '2027' WHERE entry = 33646; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33647; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33648; UPDATE `creature_template` SET `faction_A` = '64', `faction_H` = '64' WHERE entry = 33648; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33649; UPDATE `creature_template` SET `faction_A` = '64', `faction_H` = '64' WHERE entry = 33649; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33650; UPDATE `creature_template` SET `faction_A` = '64', `faction_H` = '64' WHERE entry = 33650; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33652; UPDATE `creature_template` SET `faction_A` = '1076', `faction_H` = '1076' WHERE entry = 33652; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33653; UPDATE `creature_template` SET `faction_A` = '1076', `faction_H` = '1076' WHERE entry = 33653; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33654; UPDATE `creature_template` SET `faction_A` = '1076', `faction_H` = '1076' WHERE entry = 33654; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33655; UPDATE `creature_template` SET `faction_A` = '1694', `faction_H` = '1694' WHERE entry = 33655; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33656; UPDATE `creature_template` SET `faction_A` = '1694', `faction_H` = '1694' WHERE entry = 33656; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33657; UPDATE `creature_template` SET `faction_A` = '1694', `faction_H` = '1694' WHERE entry = 33657; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33658; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 33658; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33659; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 33659; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33698; UPDATE `creature_template` SET `speed_run` = '1.03929' WHERE entry = 33738; UPDATE `creature_template` SET `speed_walk` = '0.9' WHERE entry = 33738; UPDATE `creature_template` SET `unit_flags` = '8914944' WHERE entry = 33738; UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 33738; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 33738; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33739; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33739; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33740; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33740; UPDATE `creature_template` SET `speed_run` = '1.03929' WHERE entry = 33743; UPDATE `creature_template` SET `speed_walk` = '0.9' WHERE entry = 33743; UPDATE `creature_template` SET `unit_flags` = '8915200' WHERE entry = 33743; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 33743; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33744; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33745; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33745; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33746; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33746; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33747; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33748; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33748; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33749; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 33749; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33759; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33763; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 33771; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 33790; UPDATE `creature_template` SET `npcflag` = '16777216' WHERE entry = 33790; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 33791; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 33792; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 33793; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 33794; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 33795; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 33796; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 33798; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 33799; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 33800; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 33817; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 33817; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33842; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 33843; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 33865; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33870; UPDATE `creature_template` SET `npcflag` = '896' WHERE entry = 33872; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33970; UPDATE `creature_template` SET `faction_A` = '2025', `faction_H` = '2025' WHERE entry = 33970; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 33971; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 33971; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33972; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33973; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 33974; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 34210; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 34210; UPDATE `creature_template` SET `unit_class` = '2' WHERE entry = 34281; UPDATE `creature_template` SET `unit_class` = '2' WHERE entry = 34735; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 34735; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 34771; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 34771; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 34772; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 34772; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 34788; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 34788; UPDATE `creature_template` SET `faction_A` = '634', `faction_H` = '634' WHERE entry = 34788; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 34794; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 34880; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 34881; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 34885; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 34912; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 34914; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 34914; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 34973; UPDATE `creature_template` SET `faction_A` = '83', `faction_H` = '83' WHERE entry = 34973; UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 34986; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 34987; UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 34987; UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 34988; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 34989; UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 34989; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 35094; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 35117; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 35131; UPDATE `creature_template` SET `faction_A` = '1892', `faction_H` = '1892' WHERE entry = 35131; UPDATE `creature_template` SET `npcflag` = '130' WHERE entry = 35131; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 35133; UPDATE `creature_template` SET `faction_A` = '1892', `faction_H` = '1892' WHERE entry = 35133; UPDATE `creature_template` SET `npcflag` = '82' WHERE entry = 35133; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 35168; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 35281; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 35281; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 35290; UPDATE `creature_template` SET `faction_A` = '2121', `faction_H` = '2121' WHERE entry = 35290; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 35291; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 35292; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 35293; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 35344; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 35462; UPDATE `creature_template` SET `faction_A` = '1922', `faction_H` = '1922' WHERE entry = 35462; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 35467; UPDATE `creature_template` SET `faction_A` = '1922', `faction_H` = '1922' WHERE entry = 35467; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 35469; UPDATE `creature_template` SET `unit_flags` = '33602' WHERE entry = 35469; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 35469; UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 35470; UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 35470; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 35470; UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 35473; UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 35473; UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 35475; UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 35475; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 35475; UPDATE `creature_template` SET `baseattacktime` = '1750' WHERE entry = 35475; UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 35476; UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 35476; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 35476; UPDATE `creature_template` SET `baseattacktime` = '1750' WHERE entry = 35476; UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 35482; UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 35482; UPDATE `creature_template` SET `baseattacktime` = '1750' WHERE entry = 35482; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 35483; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 35499; UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 35501; UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 35501; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 35573; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 35574; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 35574; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 35575; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 35576; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 35576; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 35577; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 35578; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 35578; UPDATE `creature_template` SET `unit_class` = '4' WHERE entry = 35579; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 35579; UPDATE `creature_template` SET `unit_class` = '4' WHERE entry = 35580; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 35580; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 35580; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 35808; UPDATE `creature_template` SET `speed_run` = '4.28571' WHERE entry = 35984; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 36065; UPDATE `creature_template` SET `unit_flags` = '33620' WHERE entry = 36065; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 36066; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 36069; UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 36102; UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 36102; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 36102; UPDATE `creature_template` SET `faction_A` = '2070', `faction_H` = '2070' WHERE entry = 36102; UPDATE `creature_template` SET `baseattacktime` = '1750' WHERE entry = 36102; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 36108; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 36108; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 36109; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 36109; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 36114; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 36114; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 36116; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 36116; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 36118; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 36118; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 36119; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 36119; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 36120; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 36120; UPDATE `creature_template` SET `unit_class` = '4' WHERE entry = 36121; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 36121; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 36121; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 36122; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 36122; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 36124; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 36124; UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 36173; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 36173; UPDATE `creature_template` SET `unit_flags` = '33587968' WHERE entry = 36173; UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 36173; UPDATE `creature_template` SET `faction_A` = '85', `faction_H` = '85' WHERE entry = 36213; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 36223; UPDATE `creature_template` SET `unit_flags` = '770' WHERE entry = 36506; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 36624; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 36624; UPDATE `creature_template` SET `faction_A` = '2027', `faction_H` = '2027' WHERE entry = 36624; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 36642; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 36642; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 36642; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 36656; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 36656; UPDATE `creature_template` SET `faction_A` = '2027', `faction_H` = '2027' WHERE entry = 36656; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 36657; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 36657; UPDATE `creature_template` SET `faction_A` = '2123', `faction_H` = '2123' WHERE entry = 36657; UPDATE `creature_template` SET `speed_run` = '0.571429' WHERE entry = 37543; UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 37543; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 37543; UPDATE `creature_template` SET `baseattacktime` = '4000' WHERE entry = 37543; UPDATE `creature_template` SET `speed_run` = '0.571429' WHERE entry = 37574; UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 37574; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 37574; UPDATE `creature_template` SET `baseattacktime` = '4000' WHERE entry = 37574; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 37674; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 37675; UPDATE `creature_template` SET `npcflag` = '1' WHERE entry = 37742; UPDATE `creature_template` SET `unit_class` = '2' WHERE entry = 37852; UPDATE `creature_template` SET `VehicleID` = '616' WHERE entry = 37966; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 37966; UPDATE `creature_template` SET `npcflag` = '16777216' WHERE entry = 37966; UPDATE `creature_template` SET `VehicleID` = '615' WHERE entry = 37980; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 37980; UPDATE `creature_template` SET `npcflag` = '16777216' WHERE entry = 37980; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 37981; UPDATE `creature_template` SET `unit_class` = '2' WHERE entry = 37981; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 38039; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 38040; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 38043; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 38293; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 38293; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 38295; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 38295; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 40405; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 40405; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 40405; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 40405; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 40413; UPDATE `creature_template` SET `faction_A` = '83', `faction_H` = '83' WHERE entry = 40413; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 40438; UPDATE `creature_template` SET `npcflag` = '1' WHERE entry = 40438; UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 30; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 66; UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 94; UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 113; UPDATE `creature_template` SET `npcflag` = '2' WHERE entry = 240; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 240; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 241; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 297; UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 299; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 338; UPDATE `creature_template` SET `baseattacktime` = '1000' WHERE entry = 340; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 352; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 514; UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 525; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 525; UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 620; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 795; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 796; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 797; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 913; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 927; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 1125; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 1246; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 1284; UPDATE `creature_template` SET `baseattacktime` = '1000' WHERE entry = 1284; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 1292; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 1304; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 1308; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 1314; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 1316; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 1323; UPDATE `creature_template` SET `npcflag` = '641' WHERE entry = 1327; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 1327; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 1328; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 1333; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 1346; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 1347; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 1349; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 1350; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 1368; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 1370; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 1371; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 1444; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 1477; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 1478; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 1573; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 1646; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 1706; UPDATE `creature_template` SET `faction_A` = '17', `faction_H` = '17' WHERE entry = 1706; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 1756; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 1959; UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 2442; UPDATE `creature_template` SET `faction_A` = '7', `faction_H` = '7' WHERE entry = 2442; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 2460; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 2461; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 2532; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 2533; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 2790; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 3505; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 3507; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 3508; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 3509; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 3510; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 3511; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 3512; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 3513; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 3626; UPDATE `creature_template` SET `npcflag` = '2' WHERE entry = 3842; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3842; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3937; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4258; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4259; UPDATE `creature_template` SET `faction_A` = '122', `faction_H` = '122' WHERE entry = 4961; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5099; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5100; UPDATE `creature_template` SET `npcflag` = '896' WHERE entry = 5101; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5101; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5102; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5103; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5106; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5107; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5108; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5109; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5110; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5111; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5112; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 5115; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5115; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5116; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5117; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5119; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5120; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5121; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5122; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5123; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5124; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5125; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5126; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5127; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5128; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5129; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5130; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5132; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5137; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5138; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5140; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5150; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5154; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5157; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5158; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5159; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5160; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5164; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5177; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5178; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 5384; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5570; UPDATE `creature_template` SET `faction_A` = '57', `faction_H` = '57' WHERE entry = 5595; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5595; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5605; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6031; UPDATE `creature_template` SET `faction_A` = '123', `faction_H` = '123' WHERE entry = 6089; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6089; UPDATE `creature_template` SET `faction_A` = '12', `faction_H` = '12' WHERE entry = 6090; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6114; UPDATE `creature_template` SET `faction_A` = '875', `faction_H` = '875' WHERE entry = 6169; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6169; UPDATE `creature_template` SET `faction_A` = '12', `faction_H` = '12' WHERE entry = 6175; UPDATE `creature_template` SET `faction_A` = '12', `faction_H` = '12' WHERE entry = 6181; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6181; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6291; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 6749; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7292; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7298; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 7917; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7976; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8517; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8671; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8720; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8879; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 9099; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 9859; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 9984; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 10090; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 10276; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 10782; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11029; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11145; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11146; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 11940; UPDATE `creature_template` SET `unit_flags` = '33280' WHERE entry = 12780; UPDATE `creature_template` SET `faction_A` = '124', `faction_H` = '124' WHERE entry = 12780; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12780; UPDATE `creature_template` SET `unit_flags` = '33280' WHERE entry = 12781; UPDATE `creature_template` SET `faction_A` = '1078', `faction_H` = '1078' WHERE entry = 12781; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12781; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 12783; UPDATE `creature_template` SET `unit_flags` = '33280' WHERE entry = 12783; UPDATE `creature_template` SET `faction_A` = '1078', `faction_H` = '1078' WHERE entry = 12783; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12783; UPDATE `creature_template` SET `unit_flags` = '33280' WHERE entry = 12787; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12787; UPDATE `creature_template` SET `faction_A` = '1217', `faction_H` = '1217' WHERE entry = 13843; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 13843; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14183; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14363; UPDATE `creature_template` SET `faction_A` = '57', `faction_H` = '57' WHERE entry = 14365; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14365; UPDATE `creature_template` SET `faction_A` = '57', `faction_H` = '57' WHERE entry = 14367; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14367; UPDATE `creature_template` SET `unit_flags` = '33280' WHERE entry = 14450; UPDATE `creature_template` SET `faction_A` = '11', `faction_H` = '11' WHERE entry = 14450; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 14496; UPDATE `creature_template` SET `unit_flags` = '0' WHERE entry = 15565; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 15565; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16013; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 18406; UPDATE `creature_template` SET `faction_A` = '875', `faction_H` = '875' WHERE entry = 19172; UPDATE `creature_template` SET `faction_A` = '1640', `faction_H` = '1640' WHERE entry = 19848; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 23050; UPDATE `creature_template` SET `faction_A` = '12', `faction_H` = '12' WHERE entry = 23050; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 27478; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 27810; UPDATE `creature_template` SET `faction_A` = '774', `faction_H` = '774' WHERE entry = 27810; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 28347; UPDATE `creature_template` SET `npcflag` = '1153' WHERE entry = 28347; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 28355; UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 29141; UPDATE `creature_template` SET `faction_A` = '11', `faction_H` = '11' WHERE entry = 30713; UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 34991; UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 35007; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 38041; UPDATE `creature_template` SET `unit_flags` = '520' WHERE entry = 38334; UPDATE `creature_template` SET `unit_flags` = '520' WHERE entry = 38335; UPDATE `creature_template` SET `unit_flags` = '520' WHERE entry = 38336; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 193; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 207; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 236; UPDATE `creature_model_info` SET `bounding_radius` = '0.42' WHERE modelid = 247; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 247; UPDATE `creature_model_info` SET `combat_reach` = '0.75' WHERE modelid = 381; UPDATE `creature_model_info` SET `combat_reach` = '0.272949' WHERE modelid = 382; UPDATE `creature_model_info` SET `bounding_radius` = '0.745464' WHERE modelid = 503; UPDATE `creature_model_info` SET `combat_reach` = '0.745464' WHERE modelid = 503; UPDATE `creature_model_info` SET `bounding_radius` = '1.08051' WHERE modelid = 604; UPDATE `creature_model_info` SET `combat_reach` = '0.900424' WHERE modelid = 604; UPDATE `creature_model_info` SET `bounding_radius` = '0.737491' WHERE modelid = 607; UPDATE `creature_model_info` SET `combat_reach` = '0.627119' WHERE modelid = 607; UPDATE `creature_model_info` SET `combat_reach` = '1.0625' WHERE modelid = 643; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 704; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 744; UPDATE `creature_model_info` SET `combat_reach` = '1.08814' WHERE modelid = 903; UPDATE `creature_model_info` SET `combat_reach` = '1.275' WHERE modelid = 949; UPDATE `creature_model_info` SET `bounding_radius` = '0.588559' WHERE modelid = 1035; UPDATE `creature_model_info` SET `combat_reach` = '1.05932' WHERE modelid = 1035; UPDATE `creature_model_info` SET `combat_reach` = '1.2' WHERE modelid = 1041; UPDATE `creature_model_info` SET `bounding_radius` = '0.795' WHERE modelid = 1056; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1056; UPDATE `creature_model_info` SET `combat_reach` = '1.4375' WHERE modelid = 1105; UPDATE `creature_model_info` SET `combat_reach` = '0.6' WHERE modelid = 1159; UPDATE `creature_model_info` SET `bounding_radius` = '0.2006' WHERE modelid = 1185; UPDATE `creature_model_info` SET `combat_reach` = '0.85' WHERE modelid = 1185; UPDATE `creature_model_info` SET `bounding_radius` = '0.476' WHERE modelid = 1225; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1225; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 1225; UPDATE `creature_model_info` SET `bounding_radius` = '0.597976' WHERE modelid = 1250; UPDATE `creature_model_info` SET `combat_reach` = '1.07627' WHERE modelid = 1250; UPDATE `creature_model_info` SET `bounding_radius` = '0.3132' WHERE modelid = 1252; UPDATE `creature_model_info` SET `combat_reach` = '1.35' WHERE modelid = 1252; UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 1253; UPDATE `creature_model_info` SET `bounding_radius` = '0.3132' WHERE modelid = 1254; UPDATE `creature_model_info` SET `combat_reach` = '1.35' WHERE modelid = 1254; UPDATE `creature_model_info` SET `bounding_radius` = '0.348' WHERE modelid = 1274; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1274; UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 1283; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 1284; UPDATE `creature_model_info` SET `combat_reach` = '0.208' WHERE modelid = 1287; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1288; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1289; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1298; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1299; UPDATE `creature_model_info` SET `combat_reach` = '0.208' WHERE modelid = 1300; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1310; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1311; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1312; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1313; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1314; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1315; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1316; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 1317; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1317; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1318; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 1319; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1319; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1320; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 1321; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1321; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1323; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1324; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1325; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1326; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1327; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1328; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1329; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1330; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1331; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 1332; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1332; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 1333; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1333; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1334; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1335; UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 1339; UPDATE `creature_model_info` SET `bounding_radius` = '0.4524' WHERE modelid = 1342; UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 1342; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 1343; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1357; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 1358; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1358; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1366; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1367; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1368; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1369; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1371; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1372; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 1373; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1373; UPDATE `creature_model_info` SET `bounding_radius` = '0.4092' WHERE modelid = 1374; UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 1374; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 1375; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1375; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 1378; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1378; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 1379; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1379; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 1380; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1380; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 1381; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1381; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 1382; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1382; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 1383; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1383; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 1384; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1384; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1385; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1386; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1387; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1388; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1389; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1390; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1391; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1392; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1394; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1432; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1449; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1485; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1487; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1488; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1494; UPDATE `creature_model_info` SET `combat_reach` = '0.208' WHERE modelid = 1497; UPDATE `creature_model_info` SET `combat_reach` = '0.208' WHERE modelid = 1498; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1500; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1502; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1505; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1508; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1509; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1511; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1515; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1516; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1518; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1519; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1521; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1524; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1526; UPDATE `creature_model_info` SET `bounding_radius` = '1.2' WHERE modelid = 1532; UPDATE `creature_model_info` SET `combat_reach` = '1.75' WHERE modelid = 1532; UPDATE `creature_model_info` SET `bounding_radius` = '0.5' WHERE modelid = 1534; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1534; UPDATE `creature_model_info` SET `bounding_radius` = '0.575' WHERE modelid = 1536; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 1536; UPDATE `creature_model_info` SET `combat_reach` = '1.75' WHERE modelid = 1538; UPDATE `creature_model_info` SET `bounding_radius` = '0.17625' WHERE modelid = 1560; UPDATE `creature_model_info` SET `combat_reach` = '0.75' WHERE modelid = 1560; UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 1646; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1646; UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 1647; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1647; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1652; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 1654; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1654; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1655; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1670; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1696; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1697; UPDATE `creature_model_info` SET `combat_reach` = '1.05' WHERE modelid = 1744; UPDATE `creature_model_info` SET `combat_reach` = '1.275' WHERE modelid = 1747; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1756; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1815; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1858; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1866; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 1877; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1877; UPDATE `creature_model_info` SET `bounding_radius` = '0.347' WHERE modelid = 1891; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1891; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 1897; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1897; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1935; UPDATE `creature_model_info` SET `combat_reach` = '4.86' WHERE modelid = 1941; UPDATE `creature_model_info` SET `bounding_radius` = '0.7511' WHERE modelid = 1959; UPDATE `creature_model_info` SET `combat_reach` = '1.05' WHERE modelid = 1959; UPDATE `creature_model_info` SET `bounding_radius` = '0.59015' WHERE modelid = 1960; UPDATE `creature_model_info` SET `combat_reach` = '0.825' WHERE modelid = 1960; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1963; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1964; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1965; UPDATE `creature_model_info` SET `bounding_radius` = '0.795' WHERE modelid = 1973; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1973; UPDATE `creature_model_info` SET `bounding_radius` = '1.0335' WHERE modelid = 1977; UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 1977; UPDATE `creature_model_info` SET `bounding_radius` = '0.795' WHERE modelid = 1978; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 1978; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 1978; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 1985; UPDATE `creature_model_info` SET `combat_reach` = '0.5' WHERE modelid = 1987; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 2148; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 2327; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 2328; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 2410; UPDATE `creature_model_info` SET `bounding_radius` = '0.425' WHERE modelid = 2486; UPDATE `creature_model_info` SET `combat_reach` = '0.85' WHERE modelid = 2486; UPDATE `creature_model_info` SET `bounding_radius` = '0.425' WHERE modelid = 2487; UPDATE `creature_model_info` SET `combat_reach` = '0.85' WHERE modelid = 2487; UPDATE `creature_model_info` SET `bounding_radius` = '0.5' WHERE modelid = 2732; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 2732; UPDATE `creature_model_info` SET `bounding_radius` = '0.9747' WHERE modelid = 2739; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 2739; UPDATE `creature_model_info` SET `bounding_radius` = '0.65' WHERE modelid = 2766; UPDATE `creature_model_info` SET `combat_reach` = '1.3' WHERE modelid = 2766; UPDATE `creature_model_info` SET `bounding_radius` = '0.7' WHERE modelid = 2768; UPDATE `creature_model_info` SET `combat_reach` = '4.375' WHERE modelid = 2768; UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 2785; UPDATE `creature_model_info` SET `combat_reach` = '0.5' WHERE modelid = 2955; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 2999; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3007; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3037; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3038; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3039; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 3040; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3041; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3042; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3043; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3044; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3045; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3046; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3047; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3049; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3050; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3051; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3053; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3054; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 3055; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3056; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3057; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3063; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3064; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3065; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3068; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3069; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3072; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3073; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3075; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3076; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3077; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3078; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3079; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3080; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3081; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3094; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3095; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3097; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3098; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3099; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 3104; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 3105; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 3106; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 3107; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 3111; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 3120; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 3124; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 3125; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3128; UPDATE `creature_model_info` SET `combat_reach` = '0.208' WHERE modelid = 3234; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3238; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 3254; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 3263; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 3340; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3458; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3527; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3546; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3564; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3591; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3600; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3604; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3605; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3606; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3608; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3609; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3736; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3736; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3737; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3738; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3738; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3739; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3739; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3740; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3740; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3741; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3741; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3742; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3742; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3743; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3743; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3744; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3744; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3745; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3745; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3746; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3746; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3747; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3747; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3748; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3748; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3749; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3749; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3751; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3751; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3754; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3755; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3755; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3758; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3850; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3856; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3865; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3866; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 3867; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3868; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3869; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 3872; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3873; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 3875; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3877; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 3881; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 3884; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3884; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 3914; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4073; UPDATE `creature_model_info` SET `bounding_radius` = '0.554237' WHERE modelid = 4091; UPDATE `creature_model_info` SET `combat_reach` = '0.554237' WHERE modelid = 4091; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4092; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4093; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4094; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4095; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4096; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4097; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 4206; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4206; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 4208; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4208; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4260; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4261; UPDATE `creature_model_info` SET `combat_reach` = '0.875' WHERE modelid = 4266; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 4296; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4296; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4350; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 4351; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4351; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4354; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4355; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4356; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 4363; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4363; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4366; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4368; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 4382; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4382; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4384; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 4386; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4386; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4442; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 4464; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4464; UPDATE `creature_model_info` SET `combat_reach` = '2.125' WHERE modelid = 4473; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4492; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 4514; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4514; UPDATE `creature_model_info` SET `bounding_radius` = '0.4092' WHERE modelid = 4515; UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 4515; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 4521; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4521; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4525; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4545; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4546; UPDATE `creature_model_info` SET `combat_reach` = '0.208' WHERE modelid = 4558; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4601; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4602; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 4611; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4611; UPDATE `creature_model_info` SET `bounding_radius` = '0.4092' WHERE modelid = 4612; UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 4612; UPDATE `creature_model_info` SET `bounding_radius` = '0.35' WHERE modelid = 4658; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4658; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 4728; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4728; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 4768; UPDATE `creature_model_info` SET `bounding_radius` = '0.35' WHERE modelid = 4871; UPDATE `creature_model_info` SET `combat_reach` = '1.25' WHERE modelid = 4871; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 4871; UPDATE `creature_model_info` SET `bounding_radius` = '0.4025' WHERE modelid = 4874; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 4874; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4889; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4893; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4950; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4986; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4995; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 4996; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 4999; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5000; UPDATE `creature_model_info` SET `bounding_radius` = '0.35' WHERE modelid = 5052; UPDATE `creature_model_info` SET `combat_reach` = '0.8' WHERE modelid = 5052; UPDATE `creature_model_info` SET `combat_reach` = '0.347' WHERE modelid = 5079; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 5080; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 5081; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5128; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 5205; UPDATE `creature_model_info` SET `bounding_radius` = '1' WHERE modelid = 5228; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 5366; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5366; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5408; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5410; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 5535; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5535; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 5549; UPDATE `creature_model_info` SET `combat_reach` = '0.5' WHERE modelid = 5586; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 5705; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5705; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5706; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5728; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 5730; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5730; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5769; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5770; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 5846; UPDATE `creature_model_info` SET `combat_reach` = '0.25' WHERE modelid = 5905; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 6005; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6005; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 6006; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6006; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6062; UPDATE `creature_model_info` SET `bounding_radius` = '0.315' WHERE modelid = 6088; UPDATE `creature_model_info` SET `combat_reach` = '1.35' WHERE modelid = 6088; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 6088; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 6094; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6096; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 6096; UPDATE `creature_model_info` SET `bounding_radius` = '0.4872' WHERE modelid = 6115; UPDATE `creature_model_info` SET `combat_reach` = '2.1' WHERE modelid = 6115; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 6295; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 6412; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6412; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 6414; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6414; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 6415; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6415; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 6424; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6424; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 6429; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6429; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6468; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6588; UPDATE `creature_model_info` SET `bounding_radius` = '0.476' WHERE modelid = 6815; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6815; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 6815; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6839; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 6843; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6843; UPDATE `creature_model_info` SET `bounding_radius` = '0.9747' WHERE modelid = 6854; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 6854; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 6873; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6873; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 6883; UPDATE `creature_model_info` SET `combat_reach` = '0.2754' WHERE modelid = 7008; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7057; UPDATE `creature_model_info` SET `bounding_radius` = '0.455' WHERE modelid = 7114; UPDATE `creature_model_info` SET `combat_reach` = '1.04' WHERE modelid = 7114; UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 7117; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7117; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7120; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 7129; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7129; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 7135; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7135; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 7136; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7136; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7137; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7182; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7215; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7216; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7335; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7340; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7341; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7342; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7343; UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 7345; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7346; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7598; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 7920; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7921; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7989; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7990; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 8000; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 8001; UPDATE `creature_model_info` SET `bounding_radius` = '1' WHERE modelid = 8149; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 8149; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 8171; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 8353; UPDATE `creature_model_info` SET `bounding_radius` = '0.389' WHERE modelid = 8449; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 8449; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 8550; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 8631; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 8631; UPDATE `creature_model_info` SET `combat_reach` = '0.1872' WHERE modelid = 8632; UPDATE `creature_model_info` SET `bounding_radius` = '0.9747' WHERE modelid = 8670; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 8670; UPDATE `creature_model_info` SET `combat_reach` = '0.15' WHERE modelid = 8971; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 9131; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 9133; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 9254; UPDATE `creature_model_info` SET `combat_reach` = '0.208' WHERE modelid = 9257; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 9258; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 9259; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 9262; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 9262; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 9338; UPDATE `creature_model_info` SET `bounding_radius` = '1.22203' WHERE modelid = 9570; UPDATE `creature_model_info` SET `combat_reach` = '1.52754' WHERE modelid = 9570; UPDATE `creature_model_info` SET `combat_reach` = '1.625' WHERE modelid = 9571; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 9739; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 9739; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 9740; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 9741; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 9801; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 9801; UPDATE `creature_model_info` SET `combat_reach` = '0.4' WHERE modelid = 10015; UPDATE `creature_model_info` SET `combat_reach` = '1.2' WHERE modelid = 10038; UPDATE `creature_model_info` SET `bounding_radius` = '0.8725' WHERE modelid = 10093; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 10093; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 10131; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 10171; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10171; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10186; UPDATE `creature_model_info` SET `bounding_radius` = '0.9747' WHERE modelid = 10236; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 10236; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 10472; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10472; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 10570; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10570; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 10571; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10578; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10588; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10589; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 10620; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10625; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10635; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10693; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10694; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 10695; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10695; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 10696; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10696; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 10697; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 10697; UPDATE `creature_model_info` SET `combat_reach` = '2.175' WHERE modelid = 10704; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 10722; UPDATE `creature_model_info` SET `combat_reach` = '2.875' WHERE modelid = 10918; UPDATE `creature_model_info` SET `combat_reach` = '1.15' WHERE modelid = 10987; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 11375; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 11377; UPDATE `creature_model_info` SET `bounding_radius` = '1' WHERE modelid = 11414; UPDATE `creature_model_info` SET `combat_reach` = '1.25' WHERE modelid = 11414; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 11689; UPDATE `creature_model_info` SET `combat_reach` = '0.208' WHERE modelid = 11898; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 11901; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 11901; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 12229; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12229; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 12477; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12477; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 12669; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 12671; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12671; UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 12672; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12672; UPDATE `creature_model_info` SET `bounding_radius` = '0.9747' WHERE modelid = 12673; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 12673; UPDATE `creature_model_info` SET `bounding_radius` = '0.8725' WHERE modelid = 12675; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 12675; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 12676; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12676; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 12677; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12677; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 12678; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12678; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 12679; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12679; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 12680; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12680; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12919; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12922; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 12924; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 13843; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 13850; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 14235; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 14396; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 14404; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 14405; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 14413; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 14414; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 14415; UPDATE `creature_model_info` SET `bounding_radius` = '0.4092' WHERE modelid = 14429; UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 14429; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 14499; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 14499; UPDATE `creature_model_info` SET `combat_reach` = '0.208' WHERE modelid = 14500; UPDATE `creature_model_info` SET `bounding_radius` = '0.42' WHERE modelid = 14573; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 14573; UPDATE `creature_model_info` SET `bounding_radius` = '0.42' WHERE modelid = 14574; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 14574; UPDATE `creature_model_info` SET `bounding_radius` = '0.42' WHERE modelid = 14575; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 14575; UPDATE `creature_model_info` SET `bounding_radius` = '1.07217' WHERE modelid = 14612; UPDATE `creature_model_info` SET `combat_reach` = '4.455' WHERE modelid = 14612; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 14616; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 14774; UPDATE `creature_model_info` SET `bounding_radius` = '1' WHERE modelid = 15137; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 15137; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 15324; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 15324; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 15352; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 15352; UPDATE `creature_model_info` SET `combat_reach` = '0.15' WHERE modelid = 15467; UPDATE `creature_model_info` SET `combat_reach` = '0.15' WHERE modelid = 15468; UPDATE `creature_model_info` SET `bounding_radius` = '1.047' WHERE modelid = 15607; UPDATE `creature_model_info` SET `combat_reach` = '4.5' WHERE modelid = 15607; UPDATE `creature_model_info` SET `bounding_radius` = '1.16964' WHERE modelid = 15609; UPDATE `creature_model_info` SET `combat_reach` = '4.86' WHERE modelid = 15609; UPDATE `creature_model_info` SET `bounding_radius` = '0.4668' WHERE modelid = 15621; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 15621; UPDATE `creature_model_info` SET `bounding_radius` = '1.047' WHERE modelid = 15631; UPDATE `creature_model_info` SET `combat_reach` = '4.5' WHERE modelid = 15631; UPDATE `creature_model_info` SET `combat_reach` = '0.4164' WHERE modelid = 15643; UPDATE `creature_model_info` SET `bounding_radius` = '0.389' WHERE modelid = 15864; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 15864; UPDATE `creature_model_info` SET `bounding_radius` = '0.8725' WHERE modelid = 15865; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 15865; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 15965; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 15966; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 15966; UPDATE `creature_model_info` SET `bounding_radius` = '0.372' WHERE modelid = 15988; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 15988; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 15998; UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 16850; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16850; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 17699; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 17719; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 17720; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 17721; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 17722; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 17759; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 18290; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18290; UPDATE `creature_model_info` SET `bounding_radius` = '2.35375' WHERE modelid = 18315; UPDATE `creature_model_info` SET `combat_reach` = '2.625' WHERE modelid = 18315; UPDATE `creature_model_info` SET `combat_reach` = '0.306' WHERE modelid = 18627; UPDATE `creature_model_info` SET `bounding_radius` = '0.465' WHERE modelid = 19017; UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 19017; UPDATE `creature_model_info` SET `bounding_radius` = '0.3519' WHERE modelid = 19176; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 19176; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 19182; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 19182; UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 19216; UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 19217; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 19217; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 19229; UPDATE `creature_model_info` SET `bounding_radius` = '0.35' WHERE modelid = 19736; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 19736; UPDATE `creature_model_info` SET `bounding_radius` = '0.383' WHERE modelid = 21264; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21264; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21512; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22397; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22493; UPDATE `creature_model_info` SET `bounding_radius` = '0.8725' WHERE modelid = 23130; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 23130; UPDATE `creature_model_info` SET `combat_reach` = '0.975' WHERE modelid = 23515; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 23926; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24164; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24980; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25118; UPDATE `creature_model_info` SET `bounding_radius` = '0.306' WHERE modelid = 25182; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25182; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25319; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25336; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25955; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 25955; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27164; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 27164; UPDATE `creature_model_info` SET `combat_reach` = '1.75' WHERE modelid = 27692; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27692; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 27913; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27913; UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 27953; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 28118; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28120; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28300; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 29077; UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 29512; UPDATE `creature_model_info` SET `combat_reach` = '1.8975' WHERE modelid = 29520; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 30725; UPDATE `creature_model_info` SET `bounding_radius` = '0.236' WHERE modelid = 31041; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 31041; UPDATE `creature_model_info` SET `combat_reach` = '1.05' WHERE modelid = 31049; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 356; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 1383; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 2620; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3099; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3100; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3101; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3102; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 3110; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3111; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3112; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3113; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3114; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3115; UPDATE `creature_template` SET `speed_walk` = '1.38889' WHERE entry = 3115; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3116; UPDATE `creature_template` SET `speed_walk` = '1.38889' WHERE entry = 3116; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3122; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3123; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3125; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3126; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3127; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 3139; UPDATE `creature_template` SET `npcflag` = '896' WHERE entry = 3164; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3169; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3172; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3174; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3216; UPDATE `creature_template` SET `unit_flags` = '570564608' WHERE entry = 3225; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 3225; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 3225; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 3242; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 3243; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 3243; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 3243; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 3244; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 3244; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 3246; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 3246; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 3275; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 3293; UPDATE `creature_template` SET `unit_flags` = '33591296' WHERE entry = 3296; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 3300; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 3300; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3310; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3312; UPDATE `creature_template` SET `npcflag` = '896' WHERE entry = 3313; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3313; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3314; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3315; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3316; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3317; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3319; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3321; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3323; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3324; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3325; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3326; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3327; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3328; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3329; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3330; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3331; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3332; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3333; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3334; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3335; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3336; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3338; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3342; UPDATE `creature_template` SET `npcflag` = '83' WHERE entry = 3345; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3345; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3346; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3347; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3348; UPDATE `creature_template` SET `npcflag` = '896' WHERE entry = 3350; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3350; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3351; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3352; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 3353; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 3353; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3353; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 3354; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3354; UPDATE `creature_template` SET `npcflag` = '83' WHERE entry = 3355; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3355; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3356; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3357; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3358; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3359; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3360; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3361; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3362; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3363; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3364; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3365; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3366; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3367; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3368; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3369; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3370; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3372; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3409; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3412; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3413; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 3415; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 3415; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 3415; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3429; UPDATE `creature_template` SET `npcflag` = '2' WHERE entry = 3431; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3478; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3479; UPDATE `creature_template` SET `npcflag` = '897' WHERE entry = 3481; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3490; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3501; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3615; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3620; UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 3631; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3659; UPDATE `creature_template` SET `npcflag` = '643' WHERE entry = 3881; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 3934; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4047; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 4076; UPDATE `creature_template` SET `speed_walk` = '0.4' WHERE entry = 4076; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4311; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4485; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4708; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 4752; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5188; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 5195; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 5195; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 5403; UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 5419; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5594; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5597; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5603; UPDATE `creature_template` SET `faction_A` = '83', `faction_H` = '83' WHERE entry = 5639; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5639; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 5645; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 5646; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 5647; UPDATE `creature_template` SET `unit_flags` = '33600' WHERE entry = 5649; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 5649; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 5774; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5811; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5812; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 5815; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5815; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5816; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5817; UPDATE `creature_template` SET `faction_A` = '83', `faction_H` = '83' WHERE entry = 5875; UPDATE `creature_template` SET `npcflag` = '3' WHERE entry = 5875; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5875; UPDATE `creature_template` SET `faction_A` = '83', `faction_H` = '83' WHERE entry = 5878; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5878; UPDATE `creature_template` SET `faction_A` = '83', `faction_H` = '83' WHERE entry = 5909; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5909; UPDATE `creature_template` SET `faction_A` = '83', `faction_H` = '83' WHERE entry = 5910; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 5951; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 5951; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 5953; UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 6466; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 6466; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6568; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6928; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6929; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6986; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 6987; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7010; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7088; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7230; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7231; UPDATE `creature_template` SET `unit_flags` = '33600' WHERE entry = 7270; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 7270; UPDATE `creature_template` SET `npcflag` = '66179' WHERE entry = 7733; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7733; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7790; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 7792; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7792; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7793; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7804; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7824; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 7951; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 7951; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8124; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8126; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8128; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8129; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8131; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 8659; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 8881; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 8882; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 8883; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 8884; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 8885; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 8996; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 9460; UPDATE `creature_template` SET `faction_A` = '2240', `faction_H` = '2240' WHERE entry = 9460; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 9523; UPDATE `creature_template` SET `faction_A` = '130', `faction_H` = '130' WHERE entry = 9523; UPDATE `creature_template` SET `baseattacktime` = '1000' WHERE entry = 9564; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 9981; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 9985; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 9987; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 10685; UPDATE `creature_template` SET `faction_A` = '31', `faction_H` = '31' WHERE entry = 10685; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11017; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11025; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11066; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11176; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11177; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11178; UPDATE `creature_template` SET `npcflag` = '2' WHERE entry = 11756; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 11756; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 11943; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 12136; UPDATE `creature_template` SET `baseattacktime` = '1000' WHERE entry = 12136; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 12351; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 12353; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 12789; UPDATE `creature_template` SET `faction_A` = '876', `faction_H` = '876' WHERE entry = 12789; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12789; UPDATE `creature_template` SET `unit_class` = '8' WHERE entry = 12790; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 12790; UPDATE `creature_template` SET `faction_A` = '68', `faction_H` = '68' WHERE entry = 12790; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12790; UPDATE `creature_template` SET `unit_class` = '2' WHERE entry = 12791; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 12791; UPDATE `creature_template` SET `faction_A` = '104', `faction_H` = '104' WHERE entry = 12791; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12791; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 12793; UPDATE `creature_template` SET `faction_A` = '125', `faction_H` = '125' WHERE entry = 12793; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 12794; UPDATE `creature_template` SET `faction_A` = '125', `faction_H` = '125' WHERE entry = 12794; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12794; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 12795; UPDATE `creature_template` SET `faction_A` = '125', `faction_H` = '125' WHERE entry = 12795; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12795; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 12796; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 12796; UPDATE `creature_template` SET `faction_A` = '1074', `faction_H` = '1074' WHERE entry = 12796; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12796; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 12797; UPDATE `creature_template` SET `faction_A` = '85', `faction_H` = '85' WHERE entry = 12797; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12797; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 12798; UPDATE `creature_template` SET `faction_A` = '85', `faction_H` = '85' WHERE entry = 12798; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 12798; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 12922; UPDATE `creature_template` SET `faction_A` = '1215', `faction_H` = '1215' WHERE entry = 13842; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 13842; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14304; UPDATE `creature_template` SET `npcflag` = '268435458' WHERE entry = 14375; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14375; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14376; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14377; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14392; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 14451; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 14498; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14498; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 14499; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 14539; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 14540; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 14540; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 14541; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 14743; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 15186; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 15186; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 15476; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 15572; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 15572; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 15579; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 15579; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 15586; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 15586; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 15597; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 15597; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16012; UPDATE `creature_template` SET `faction_A` = '474', `faction_H` = '474' WHERE entry = 16014; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16014; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 16069; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 16069; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 16076; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 16076; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16417; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 17098; UPDATE `creature_template` SET `unit_class` = '8' WHERE entry = 19850; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 19850; UPDATE `creature_template` SET `faction_A` = '1604', `faction_H` = '1604' WHERE entry = 19850; UPDATE `creature_template` SET `npcflag` = '2' WHERE entry = 19860; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20486; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20488; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20489; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20490; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20490; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20491; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20491; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20492; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20492; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20493; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20493; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 21448; UPDATE `creature_template` SET `faction_A` = '475', `faction_H` = '475' WHERE entry = 21448; UPDATE `creature_template` SET `faction_A` = '1695', `faction_H` = '1695' WHERE entry = 23128; UPDATE `creature_template` SET `npcflag` = '51' WHERE entry = 23128; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 24924; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 24926; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 24927; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 24929; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 24930; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 24931; UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 24934; UPDATE `creature_template` SET `unit_flags` = '2147746560' WHERE entry = 24935; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 25070; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 25070; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 25071; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 25071; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 25072; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 25072; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 25074; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 25074; UPDATE `creature_template` SET `unit_flags` = '2181300992' WHERE entry = 25075; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 25076; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 25076; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 25077; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 25077; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 25079; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 25079; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 25080; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 25081; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 25083; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 25083; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 26537; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 26537; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 27489; UPDATE `creature_template` SET `faction_A` = '775', `faction_H` = '775' WHERE entry = 27810; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 28126; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29143; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 29143; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30611; UPDATE `creature_template` SET `faction_A` = '85', `faction_H` = '85' WHERE entry = 30611; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 31047; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 31720; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31723; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 31723; UPDATE `creature_template` SET `npcflag` = '1' WHERE entry = 31723; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31724; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 31724; UPDATE `creature_template` SET `npcflag` = '1' WHERE entry = 31724; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31725; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 31725; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 31726; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 31727; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31755; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 31755; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31756; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 31756; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31757; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 31757; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31758; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 31758; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31768; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 31768; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 31769; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 31769; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 32641; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 32641; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 32642; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 32642; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 34765; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 34765; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 34955; UPDATE `creature_template` SET `faction_A` = '83', `faction_H` = '83' WHERE entry = 34955; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 35068; UPDATE `creature_template` SET `faction_A` = '104', `faction_H` = '104' WHERE entry = 35068; UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 35364; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 35364; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 37072; UPDATE `creature_template` SET `npcflag` = '16' WHERE entry = 37072; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 37172; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 37172; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 38042; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 38328; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 40213; UPDATE `creature_template` SET `npcflag` = '128' WHERE entry = 40213; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 40214; UPDATE `creature_template` SET `npcflag` = '128' WHERE entry = 40214; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 40215; UPDATE `creature_template` SET `npcflag` = '128' WHERE entry = 40215; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 40216; UPDATE `creature_template` SET `npcflag` = '128' WHERE entry = 40216;
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян Последний раз редактировалось Heisenberg; 10.02.2011 в 02:17. |
Пользователь сказал cпасибо: | YuruY (10.02.2011) |
Опции просмотра |
Линейный вид |
Комбинированный вид |
Древовидный вид |
|
|