|
---|
|
Другое / Other Другие ошибки базы. Если сообщение не подходит под ошибки заселения, баги предметов, или отсутствие рабочих скриптов - в этот раздел. |
|
Опции темы | Поиск в этой теме | Опции просмотра |
|
13.02.2011, 16:15 | #1 | |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Цитата:
Код:
INSERT IGNORE INTO `creature_template` VALUE (52030, 'Liliana Emberfrost', 'Honor Heirlooms', '', 0, 7, 0, 0, 0, 0, 37720, 0, 0, 0,'1', '1', 0,0,0,0,0,0,0, 0);
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян |
|
13.02.2011, 20:01 | #2 |
YTDB dev
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
|
В 403 нет http://www.wowhead.com/npc=52030 , в "Added in patch 4.0.6" будут темплеты все, зачем напрягаться раньше времени (фулл темплеты, линкуются (квесты и мобы))?
|
11.02.2011, 19:04 | #3 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Код:
DELETE FROM creature WHERE guid IN(1964,1966); REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES (1966, 1, 7863.441, 939.5631, 451.765), (1966, 2, 7863.832, 940.4836, 451.765), (1966, 3, 7864.777, 946.7762, 451.3077), (1966, 4, 7862.519, 962.6602, 450.2893), (1966, 5, 7862.519, 962.6602, 450.2893); REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES (1964, 1, 7811.847, 1085.282, 410.4067), (1964, 2, 7812.188, 1084.342, 410.4067), (1964, 3, 7820.208, 1062.171, 488.4612), (1964, 4, 7820.208, 1062.171, 488.4612); REPLACE INTO `creature_template_addon` VALUES (32446, 1964, 0, 50331648, 1, 0, 0); REPLACE INTO `creature_template_addon` VALUES (32443, 1966, 0, 0, 1, 0, 0); SET @SCRIPT_ID := XXXXX; UPDATE `quest_template` SET `CompleteScript` = @SCRIPT_ID WHERE `entry` IN (13359,13398); DELETE FROM `quest_end_scripts` WHERE `id` IN(@SCRIPT_ID, @SCRIPT_ID+1,@SCRIPT_ID+2); INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (99999994, 0, 10, 32443, 27000, '', 7864.093, 942.2219, 451.638, 1.42168), (99999995, 0, 20, 1966, 0, '0', 0, 0, 0, 0), (99999996, 8000, 0, 0, 0, '2000000452', 0, 0, 0, 0), (99999997, 0, 10, 32446, 20000, '', 7812.442, 1083.642, 412.7914, 5.059513), (99999998, 1000, 20, 1964, 0, '', 0, 0, 0, 0); insert into `db_script_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) values ('2000000452','The Lich King says: Rise, Sindragosa! Rise and lead the Frostbrood into war!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Восстань, Синдрагоса! Восстань и веди ледяных драконов в бой!'); http://ru.wowhead.com/quest=13359 http://ru.wowhead.com/quest=13398 Не хватает только эмоции, когда лич втыкает меч в землю. В сниффе эмоцию не нашел. Спела, который бы мог это делать тоже. Синдру и лича сумонить приходится скриптом, т.к тогда есть возможность их деспаунить. В противном случае будет бред. Главное, чтобы лич и синдра суомнились в верной маске фазы Боюсь что скрипт в корне не верный В первый раз пишу квест скрипт
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян |
11.02.2011, 19:21 | #4 | ||
YTDB dev
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
|
Цитата:
Ты вынес мобов из заселения и прилепил им поинты .... финал апдейта сразу это вчухает и вынесет эти поинты. Цитата:
|
||
11.02.2011, 19:53 | #5 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Тогда вот так
Код:
UPDATE `creature` SET `position_x` = 7864.093, `position_y` = 942.2219, `position_z` = 451.638, `spawndist` = 0, `MovementType` = 2 WHERE `guid` = 1966; REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES (1966, 1, 7863.441, 939.5631, 451.765), (1966, 2, 7863.832, 940.4836, 451.765), (1966, 3, 7864.777, 946.7762, 451.3077), (1966, 4, 7862.519, 962.6602, 450.2893), (1966, 5, 7862.519, 962.6602, 450.2893); REPLACE INTO `creature_addon` VALUES (1966, 1966, 0, 0, 1, 0, 0); UPDATE `creature` SET `position_x` = 7812.442, `position_y` = 1083.642, `position_z` = 412.7914, `orientation` = 5.059513, `spawndist` = 0, `MovementType` = 2 WHERE `guid` = 1964; REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES (1964, 1, 7811.847, 1085.282, 410.4067), (1964, 2, 7812.188, 1084.342, 410.4067), (1964, 3, 7820.208, 1062.171, 488.4612), (1964, 4, 7820.208, 1062.171, 488.4612); REPLACE INTO `creature_addon` VALUES (1964, 1964, 0, 50331648, 1, 0, 0); SET @SCRIPT_ID := XXXXX; UPDATE `quest_template` SET `CompleteScript` = @SCRIPT_ID WHERE `entry` IN (13359,13398); DELETE FROM `quest_end_scripts` WHERE `id` IN(@SCRIPT_ID); INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (@SCRIPT_ID, 0, 20, 1966, 0, '0', 0, 0, 0, 0), (@SCRIPT_ID, 8, 0, 0, 0, '2000000452', 0, 0, 0, 0), (@SCRIPT_ID, 1, 20, 1964, 0, '', 0, 0, 0, 0), (@SCRIPT_ID, 20, 3, 32443, 0, '0', 7864.093, 942.2219, 451.638, 1.42168), (@SCRIPT_ID, 20, 3, 32446, 0, '0', 7812.442, 1083.642, 412.7914, 5.059513); insert into `db_script_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) values ('2000000452','Rise, Sindragosa! Rise and lead the Frostbrood into war!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Восстань, Синдрагоса! Восстань и веди ледяных драконов в бой!');
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян Последний раз редактировалось NeatElves; 11.02.2011 в 21:37. |
11.02.2011, 20:15 | #6 |
YTDB dev
Регистрация: 05.11.2009
Сообщений: 5,920
Сказал(а) спасибо: 91
Поблагодарили 5,383 раз(а) в 4,847 сообщениях
|
Теория под мангос, если лич кричит в точке, тогда текстовку из квестскрипта можно забрать.) Флаги аддонами не вешал...
Последний раз редактировалось NeatElves; 15.02.2011 в 17:09. |
11.02.2011, 21:17 | #7 |
YTDB dev
Регистрация: 05.11.2009
Сообщений: 5,920
Сказал(а) спасибо: 91
Поблагодарили 5,383 раз(а) в 4,847 сообщениях
|
Да, кстати, дай им http://www.trinitycore.org/w/Creature_tc2#spawnMask=0, тогда ничего не сотрет никто и их в мире не будет.)
|
11.02.2011, 22:53 | #8 |
YTDB dev
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
|
А как я это в мангос заливать буду? )
Ну это я сразу переименовываю: "waypoint_data" А этого в триньке нет: "creature_movement_template", оно помоему там "waypoints". |
12.02.2011, 19:45 | #9 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Я уже скидывал
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян |
12.02.2011, 21:00 | #10 |
YTDB dev
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
|
|
13.02.2011, 20:29 | #11 | |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Цитата:
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян |
|
13.02.2011, 21:08 | #12 |
YTDB dev
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
|
Выбирать не надо, открываешь и линкуешь всех.
|
13.02.2011, 21:40 | #13 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян |
14.02.2011, 15:25 | #14 | |
YTDB dev
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
|
Цитата:
|
|
13.02.2011, 23:54 | #15 |
Брянский волк
|
По квесту http://ru.wowhead.com/quest=12029 нужен снифф или аура, которая накладывается на нпц при поджигании:
47214 Burninate Effect SPELL_AURA_PERIODIC_DUMMY - ? |
16.02.2011, 19:08 | #16 | |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Цитата:
Да Килл кредит идет ID - 47208 Burninate Kill Credit Испепеление делается этим спелом ID - 42726 Декоративное - Испепеление (всего тела) В сниффе еще попался 1 раз спелл ID - 47285 Зола. Моб селф кастит Дохнут мобы ID - 51744 Suicide (No Log)
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян |
|
Пользователь сказал cпасибо: | virusav (16.02.2011) |
16.02.2011, 19:11 | #17 |
Брянский волк
|
Желателен кусок сниффа с момента каста на нпц до его смерти, т.к. у указанных спеллов думми-эффекты, надо по сниффу разбирать, что к чему.
|
16.02.2011, 21:50 | #18 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
В аттаче спарсеный снифф + спарсеные up данные(фракция, позиция, флаги and etc.) . Сейчас 4.0.6, кучу опкодов сменили. У меня многие не совпадают. Не смотри на постороннюю кривую дату.
Госсипы для квеста "Перемирие" Если надо какой нибудь квест сниффануть - стучите в аську 380 210 472
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян Последний раз редактировалось Heisenberg; 16.02.2011 в 22:01. |
16.02.2011, 22:30 | #19 |
Брянский волк
|
Сниффать надо все квесты из раздела с требованием поддержки скриптов.
|
17.02.2011, 12:00 | #20 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян |
17.02.2011, 14:26 | #21 | ||
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Госсипы для квеста http://ru.wowhead.com/quest=13549
Мишка: Код:
UPDATE `creature_template` SET `gossip_menu_id` = 10274 WHERE `entry` = 29319; INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (10274, 14267); Цитата:
Кицька: Код:
UPDATE `creature_template` SET `gossip_menu_id` = 10273 WHERE `entry` = 29327; INSERT IGNORE INTO `gossip_menu` (`entry`, `text_id`) VALUES (10273, 14266); Цитата:
Вот спарсеный снифф. Правдо там не только этот кв, там их много. Ищи спелл 62105 - кидание дротика(по кв)
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян Последний раз редактировалось Heisenberg; 17.02.2011 в 15:40. |
||
17.02.2011, 14:38 | #22 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Кеш будет потом С квестами зи "Нид скрипт суппорт" тяжко будет. У меня больше половины квестов уже сделаны. Правда есть 1 квест который я вчсера сниффанул, когда делал ачивку наквесты в зулдраке. Как только исправлю краш - скину спарсенный снифф. Некоторые квесты просто отсутствуют
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян Последний раз редактировалось Heisenberg; 17.02.2011 в 15:39. |
17.02.2011, 16:20 | #23 |
YTDB dev
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
|
Lordronn
В аддонах: аура по умолчанию '' а не 0 (те что для поинтов оставляешь). |
Пользователь сказал cпасибо: | Heisenberg (17.02.2011) |
17.02.2011, 18:50 | #24 | ||
YTDB dev
Регистрация: 05.11.2009
Сообщений: 5,920
Сказал(а) спасибо: 91
Поблагодарили 5,383 раз(а) в 4,847 сообщениях
|
Цитата:
Цитата:
|
||
17.02.2011, 19:02 | #25 |
RuDB Dev
Регистрация: 06.11.2009
Сообщений: 677
Сказал(а) спасибо: 592
Поблагодарили 690 раз(а) в 289 сообщениях
|
Все что пришло в сплинах, но тут надо смотреть по данным...
|
Пользователь сказал cпасибо: | Heisenberg (17.02.2011) |
19.02.2011, 03:51 | #26 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян |
Пользователь сказал cпасибо: | YuruY (19.02.2011) |
20.02.2011, 19:23 | #27 | |
YTDB histori
|
Цитата:
|
|
21.02.2011, 07:57 | #28 | |
YTDB dev
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
|
Цитата:
|
|
21.02.2011, 12:27 | #29 |
YTDB dev
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
|
Очень много предметов в продаже, нужно выяснить каких нет (возможно по уровню старые остались):
http://www.wowhead.com/npc=12785#sells http://www.wowhead.com/npc=12795#sells http://www.wowhead.com/npc=20278#sells http://www.wowhead.com/npc=35498#sells http://www.wowhead.com/npc=40205#sells http://www.wowhead.com/npc=40210#sells http://www.wowhead.com/npc=40213#sells http://www.wowhead.com/npc=40214#sells http://www.wowhead.com/npc=44245#sells http://www.wowhead.com/npc=46556#sells http://www.wowhead.com/npc=46594#sells http://www.wowhead.com/npc=51254#sells http://www.wowhead.com/npc=51256#sells |
22.02.2011, 14:28 | #30 |
YTDB histori
|
По сниффу заметил в яме сарона кучу триггеров, не знаю даже нужны ли они. ))
Код:
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (NULL, '24110', '658', '1', '1', '11686', '0', '1003.776', '140.4306', '628.2395', '0', '300', '0', '0', '6141', '0', '0', '1'); UPDATE `creature_template` SET `speed_run` = 1.142857 WHERE entry = 24110; UPDATE `creature_template` SET `faction_A` = 35, `faction_H` = 35 WHERE `entry` = 24110; UPDATE `creature_template` SET `baseattacktime` = 2000 WHERE `entry` = 24110; UPDATE `creature_template` SET `unit_flags` = `unit_flags` | 33555200 WHERE `entry` = 24110; UPDATE `creature_model_info` SET `bounding_radius` = 0.5 WHERE `modelid` = 11686; UPDATE `creature_model_info` SET `combat_reach` = 1 WHERE `modelid` = 11686; UPDATE `creature_model_info` SET `gender` = 2 WHERE `modelid` = 11686; INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (NULL, '23837', '658', '1', '1', '11686', '0', '899.2604', '67.38194', '541.6858', '0', '300', '0', '0', '6141', '0', '0', '1'); UPDATE `creature_template` SET `speed_run` = 1.142857 WHERE entry = 23837; UPDATE `creature_template` SET `faction_A` = 35, `faction_H` = 35 WHERE `entry` = 23837; UPDATE `creature_template` SET `baseattacktime` = 2000 WHERE `entry` = 23837; UPDATE `creature_template` SET `unit_flags` = `unit_flags` | 33555200 WHERE `entry` = 23837; UPDATE `creature_model_info` SET `bounding_radius` = 0.5 WHERE `modelid` = 11686; UPDATE `creature_model_info` SET `combat_reach` = 1 WHERE `modelid` = 11686; UPDATE `creature_model_info` SET `gender` = 2 WHERE `modelid` = 11686; INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (NULL, '23837', '658', '1', '1', '11686', '0', '947.3351', '75.41146', '565.9358', '0', '300', '0', '0', '6141', '0', '0', '1'), (NULL, '24110', '658', '1', '1', '11686', '0', '1010.278', '179.5', '628.2394', '0', '300', '0', '0', '6141', '0', '0', '1'), (NULL, '24110', '658', '1', '1', '11686', '0', '1022.826', '158.2726', '628.2394', '0', '300', '0', '0', '6141', '0', '0', '1'), (NULL, '24110', '658', '1', '1', '11686', '0', '1010.904', '207.7066', '628.3898', '0', '300', '0', '0', '6141', '0', '0', '1'), (NULL, '24110', '658', '1', '1', '11686', '0', '1041.708', '108.151', '628.7607', '0', '300', '0', '0', '6141', '0', '0', '1'), (NULL, '24110', '658', '1', '1', '11686', '0', '1048.118', '114.7101', '628.2394', '0', '300', '0', '0', '6141', '0', '0', '1'), (NULL, '24110', '658', '1', '1', '11686', '0', '1047.194', '110.8681', '628.272', '0', '300', '0', '0', '6141', '0', '0', '1'), (NULL, '24110', '658', '1', '1', '11686', '0', '1046.622', '106.7101', '628.9221', '0', '300', '0', '0', '6141', '0', '0', '1'); Последний раз редактировалось Kores; 22.02.2011 в 16:37. |
22.02.2011, 14:57 | #31 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Все они есть в базе, и даже больше)
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян |
22.02.2011, 15:10 | #32 | ||
YTDB dev
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
|
Только както наоборот, те есть а этих нет, на этой маппе.
Далее, учитываем спавн-маску, в этом данже она =3. Далее: Цитата:
Цитата:
|
||
22.02.2011, 15:19 | #33 |
YTDB histori
|
|
22.02.2011, 16:21 | #34 |
Брянский волк
|
Вместо
Код:
('NULL', '23837', '658' .... Код:
(NULL, '23837', '658' .... |
22.02.2011, 16:28 | #35 |
YTDB histori
|
Поправил.
|
22.02.2011, 16:37 | #36 |
Брянский волк
|
Одну строку все-таки забыл.
Поясню на примере таблицы локализации. Если в поле `name_loc8` вписать: 1. `NULL`, то получим ошибку, т.к. такого поля в таблице нет. 2. 'NULL', то в игре увидим текст NULL, т.к. это значение поля. 3. NULL, то получим в игре название на английском. Это правильный вариант. |
Пользователь сказал cпасибо: | Kores (22.02.2011) |
22.02.2011, 18:09 | #37 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян Последний раз редактировалось Heisenberg; 22.02.2011 в 18:19. |
28.02.2011, 17:44 | #38 |
Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
123кб данных)
Код:
UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 385; UPDATE `creature_template` SET `unit_flags` = '2056' WHERE entry = 2630; UPDATE `creature_template` SET `unit_flags` = '2060' WHERE entry = 5925; UPDATE `creature_template` SET `unit_flags` = '526344' WHERE entry = 5950; UPDATE `creature_template` SET `unit_flags` = '2048' WHERE entry = 10218; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 10218; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 10218; UPDATE `creature_template` SET `speed_walk` = '0.5' WHERE entry = 12922; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 12922; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 12922; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 12922; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 14881; UPDATE `creature_template` SET `faction_A` = '1802', `faction_H` = '1802' WHERE entry = 15241; UPDATE `creature_template` SET `faction_A` = '85', `faction_H` = '85' WHERE entry = 15242; UPDATE `creature_template` SET `faction_A` = '834', `faction_H` = '834' WHERE entry = 16570; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 16570; UPDATE `creature_template` SET `faction_A` = '1668', `faction_H` = '1668' WHERE entry = 16580; UPDATE `creature_template` SET `faction_A` = '1729', `faction_H` = '1729' WHERE entry = 16587; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16587; UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 16831; UPDATE `creature_template` SET `unit_flags` = '832' WHERE entry = 16831; UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 16831; UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 16850; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16850; UPDATE `creature_template` SET `faction_A` = '1671', `faction_H` = '1671' WHERE entry = 16851; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16851; UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 16863; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 16863; UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 16879; UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 16880; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 16880; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 16903; UPDATE `creature_template` SET `faction_A` = '1651', `faction_H` = '1651' WHERE entry = 16911; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 16946; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 16947; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 16947; UPDATE `creature_template` SET `faction_A` = '1752', `faction_H` = '1752' WHERE entry = 16950; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 16950; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 16951; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 16954; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 16954; UPDATE `creature_template` SET `faction_A` = '1752', `faction_H` = '1752' WHERE entry = 16959; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 16960; UPDATE `creature_template` SET `faction_A` = '73', `faction_H` = '73' WHERE entry = 17035; UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 17053; UPDATE `creature_template` SET `speed_run` = '0.214286' WHERE entry = 17407; UPDATE `creature_template` SET `speed_walk` = '0.6' WHERE entry = 17407; UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 18449; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 18449; UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 18449; UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 18450; UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 18451; UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 18451; UPDATE `creature_template` SET `faction_A` = '49', `faction_H` = '49' WHERE entry = 18463; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18469; UPDATE `creature_template` SET `faction_A` = '38', `faction_H` = '38' WHERE entry = 18477; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 18528; UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 18528; UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 18540; UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 18540; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 18595; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 18595; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18595; UPDATE `creature_template` SET `unit_flags` = '559169' WHERE entry = 18733; UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 18733; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 18733; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 18827; UPDATE `creature_template` SET `faction_A` = '1760', `faction_H` = '1760' WHERE entry = 18930; UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 18931; UPDATE `creature_template` SET `faction_A` = '694', `faction_H` = '694' WHERE entry = 18939; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 18939; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 18944; UPDATE `creature_template` SET `faction_A` = '1752', `faction_H` = '1752' WHERE entry = 18944; UPDATE `creature_template` SET `faction_A` = '1754', `faction_H` = '1754' WHERE entry = 18945; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 18945; UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 18948; UPDATE `creature_template` SET `unit_flags` = '559361' WHERE entry = 18949; UPDATE `creature_template` SET `faction_A` = '1755', `faction_H` = '1755' WHERE entry = 18949; UPDATE `creature_template` SET `unit_flags` = '559376' WHERE entry = 18950; UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 18965; UPDATE `creature_template` SET `unit_flags` = '35073' WHERE entry = 18966; UPDATE `creature_template` SET `faction_A` = '1757', `faction_H` = '1757' WHERE entry = 18966; UPDATE `creature_template` SET `faction_A` = '1759', `faction_H` = '1759' WHERE entry = 18969; UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 18970; UPDATE `creature_template` SET `unit_flags` = '35072' WHERE entry = 18971; UPDATE `creature_template` SET `unit_flags` = '559361' WHERE entry = 18972; UPDATE `creature_template` SET `faction_A` = '1752', `faction_H` = '1752' WHERE entry = 18975; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 18977; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 18978; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 18978; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 18981; UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 18986; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 19005; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19136; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 19136; UPDATE `creature_template` SET `speed_run` = '2' WHERE entry = 19189; UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 19189; UPDATE `creature_template` SET `faction_A` = '1752', `faction_H` = '1752' WHERE entry = 19190; UPDATE `creature_template` SET `unit_flags` = '526400' WHERE entry = 19191; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19191; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 19191; UPDATE `creature_template` SET `speed_walk` = '0.5' WHERE entry = 19192; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 19192; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19192; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 19192; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19261; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 19277; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 19277; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19282; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19298; UPDATE `creature_template` SET `faction_A` = '1752', `faction_H` = '1752' WHERE entry = 19299; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19317; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 19319; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 19333; UPDATE `creature_template` SET `unit_flags` = '4608' WHERE entry = 19339; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 19339; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 19341; UPDATE `creature_template` SET `unit_flags` = '4608' WHERE entry = 19342; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 19342; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 19343; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 19345; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 19348; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19351; UPDATE `creature_template` SET `unit_flags` = '36864' WHERE entry = 19352; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19352; UPDATE `creature_template` SET `faction_A` = '84', `faction_H` = '84' WHERE entry = 19353; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 19355; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19362; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 19364; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19368; UPDATE `creature_template` SET `unit_flags` = '36864' WHERE entry = 19369; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19369; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19370; UPDATE `creature_template` SET `unit_flags` = '36864' WHERE entry = 19371; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19371; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19372; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19373; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19373; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19374; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19375; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 19379; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19379; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19379; UPDATE `creature_template` SET `speed_run` = '2.85714' WHERE entry = 19382; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 19382; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19382; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19384; UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 19387; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19387; UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 19388; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19388; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19394; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 19395; UPDATE `creature_template` SET `faction_A` = '1760', `faction_H` = '1760' WHERE entry = 19425; UPDATE `creature_template` SET `faction_A` = '1760', `faction_H` = '1760' WHERE entry = 19426; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 19434; UPDATE `creature_template` SET `faction_A` = '1756', `faction_H` = '1756' WHERE entry = 19444; UPDATE `creature_template` SET `faction_A` = '1838', `faction_H` = '1838' WHERE entry = 19504; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19504; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19517; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19517; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19518; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19518; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19520; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19520; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 19521; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19521; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19625; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19627; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 19717; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19740; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 19754; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 19755; UPDATE `creature_template` SET `speed_walk` = '0.944444' WHERE entry = 19755; UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 19757; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 19757; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 19759; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 19760; UPDATE `creature_template` SET `faction_A` = '1701', `faction_H` = '1701' WHERE entry = 19792; UPDATE `creature_template` SET `faction_A` = '1701', `faction_H` = '1701' WHERE entry = 19796; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 19806; UPDATE `creature_template` SET `faction_A` = '1701', `faction_H` = '1701' WHERE entry = 19806; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 19824; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 19824; UPDATE `creature_template` SET `faction_A` = '1701', `faction_H` = '1701' WHERE entry = 19824; UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 19825; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 19825; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 20158; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 20431; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20490; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20491; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20492; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20493; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 20494; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 20500; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 20502; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20503; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20503; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20504; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20504; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20505; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20505; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20506; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20506; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20507; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20507; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20508; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20508; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 20509; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 20509; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 20510; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 20511; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 20683; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 20683; UPDATE `creature_template` SET `faction_A` = '1813', `faction_H` = '1813' WHERE entry = 20684; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 20798; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 20872; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 20872; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 20878; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 20878; UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 20887; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 20887; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 20887; UPDATE `creature_template` SET `speed_walk` = '1.55556' WHERE entry = 21050; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 21059; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 21059; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 21060; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 21061; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 21095; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 21108; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 21108; UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 21153; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 21153; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 21166; UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 21166; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 21207; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 21207; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 21210; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 21211; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 21233; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 21233; UPDATE `creature_template` SET `faction_A` = '68', `faction_H` = '68' WHERE entry = 21257; UPDATE `creature_template` SET `speed_run` = '0.912699' WHERE entry = 21287; UPDATE `creature_template` SET `speed_walk` = '0.888888' WHERE entry = 21287; UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 21287; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 21287; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 21293; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 21293; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 21302; UPDATE `creature_template` SET `speed_run` = '1.38889' WHERE entry = 21314; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 21314; UPDATE `creature_template` SET `speed_run` = '0.357143' WHERE entry = 21316; UPDATE `creature_template` SET `unit_flags` = '33026' WHERE entry = 21316; UPDATE `creature_template` SET `faction_A` = '114', `faction_H` = '114' WHERE entry = 21316; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 21330; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21330; UPDATE `creature_template` SET `unit_flags` = '37376' WHERE entry = 21336; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 21336; UPDATE `creature_template` SET `unit_flags` = '37376' WHERE entry = 21340; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 21340; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 21357; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 21359; UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 21384; UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 21385; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 21403; UPDATE `creature_template` SET `unit_flags` = '33600' WHERE entry = 21404; UPDATE `creature_template` SET `faction_A` = '954', `faction_H` = '954' WHERE entry = 21404; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21404; UPDATE `creature_template` SET `scale` = '0.5' WHERE entry = 21417; UPDATE `creature_template` SET `speed_walk` = '0.5' WHERE entry = 21419; UPDATE `creature_template` SET `unit_flags` = '571083008' WHERE entry = 21419; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 21419; UPDATE `creature_template` SET `faction_A` = '1738', `faction_H` = '1738' WHERE entry = 21450; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 21471; UPDATE `creature_template` SET `unit_flags` = '36864' WHERE entry = 21472; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 21472; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 21475; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 21476; UPDATE `creature_template` SET `faction_A` = '1839', `faction_H` = '1839' WHERE entry = 21477; UPDATE `creature_template` SET `baseattacktime` = '4000' WHERE entry = 21477; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 21478; UPDATE `creature_template` SET `faction_A` = '1839', `faction_H` = '1839' WHERE entry = 21478; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 21478; UPDATE `creature_template` SET `speed_run` = '0.952381' WHERE entry = 21499; UPDATE `creature_template` SET `speed_walk` = '0.944444' WHERE entry = 21499; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 21499; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 21500; UPDATE `creature_template` SET `speed_walk` = '0.777776' WHERE entry = 21500; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 21500; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 21500; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 21501; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21501; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 21512; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 21627; UPDATE `creature_template` SET `faction_A` = '1793', `faction_H` = '1793' WHERE entry = 21627; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 21627; UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 21648; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 21648; UPDATE `creature_template` SET `unit_flags` = '33344' WHERE entry = 21648; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21648; UPDATE `creature_template` SET `speed_run` = '2.85714' WHERE entry = 21657; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21657; UPDATE `creature_template` SET `faction_A` = '1858', `faction_H` = '1858' WHERE entry = 21701; UPDATE `creature_template` SET `faction_A` = '29', `faction_H` = '29' WHERE entry = 21725; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 21727; UPDATE `creature_template` SET `unit_flags` = '563200' WHERE entry = 21736; UPDATE `creature_template` SET `faction_A` = '1819', `faction_H` = '1819' WHERE entry = 21736; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21736; UPDATE `creature_template` SET `faction_A` = '1701', `faction_H` = '1701' WHERE entry = 21742; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 21744; UPDATE `creature_template` SET `faction_A` = '1744', `faction_H` = '1744' WHERE entry = 21744; UPDATE `creature_template` SET `unit_flags` = '563200' WHERE entry = 21749; UPDATE `creature_template` SET `faction_A` = '1835', `faction_H` = '1835' WHERE entry = 21749; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21766; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 21769; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21769; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 21770; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21770; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 21771; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21771; UPDATE `creature_template` SET `faction_A` = '1734', `faction_H` = '1734' WHERE entry = 21772; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21772; UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 21773; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21773; UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 21774; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21774; UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 21775; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21775; UPDATE `creature_template` SET `faction_A` = '1733', `faction_H` = '1733' WHERE entry = 21777; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21777; UPDATE `creature_template` SET `faction_A` = '1813', `faction_H` = '1813' WHERE entry = 21802; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21803; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 21807; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21808; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 21878; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 21909; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 21924; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 21937; UPDATE `creature_template` SET `faction_A` = '1727', `faction_H` = '1727' WHERE entry = 21937; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 21938; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21938; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 21953; UPDATE `creature_template` SET `faction_A` = '1744', `faction_H` = '1744' WHERE entry = 21953; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21953; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 21954; UPDATE `creature_template` SET `faction_A` = '1744', `faction_H` = '1744' WHERE entry = 21954; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21954; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 21955; UPDATE `creature_template` SET `faction_A` = '1744', `faction_H` = '1744' WHERE entry = 21955; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 21955; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 22002; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 22008; UPDATE `creature_template` SET `faction_A` = '1701', `faction_H` = '1701' WHERE entry = 22016; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 22016; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 22016; UPDATE `creature_template` SET `faction_A` = '1701', `faction_H` = '1701' WHERE entry = 22017; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 22017; UPDATE `creature_template` SET `faction_A` = '1701', `faction_H` = '1701' WHERE entry = 22018; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 22018; UPDATE `creature_template` SET `faction_A` = '1732', `faction_H` = '1732' WHERE entry = 22042; UPDATE `creature_template` SET `faction_A` = '1735', `faction_H` = '1735' WHERE entry = 22043; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 22070; UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 22072; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 22082; UPDATE `creature_template` SET `faction_A` = '1813', `faction_H` = '1813' WHERE entry = 22134; UPDATE `creature_template` SET `baseattacktime` = '10000' WHERE entry = 22134; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 22211; UPDATE `creature_template` SET `faction_A` = '1845', `faction_H` = '1845' WHERE entry = 22211; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 22211; UPDATE `creature_template` SET `faction_A` = '32', `faction_H` = '32' WHERE entry = 22265; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 22323; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 22445; UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 22445; UPDATE `creature_template` SET `faction_A` = '2204', `faction_H` = '2204' WHERE entry = 22445; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 22461; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 22461; UPDATE `creature_template` SET `unit_flags` = '537430016' WHERE entry = 22857; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 22858; UPDATE `creature_template` SET `faction_A` = '1843', `faction_H` = '1843' WHERE entry = 22858; UPDATE `creature_template` SET `unit_flags` = '537166592' WHERE entry = 22859; UPDATE `creature_template` SET `faction_A` = '1843', `faction_H` = '1843' WHERE entry = 22859; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 22859; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 22860; UPDATE `creature_template` SET `faction_A` = '1843', `faction_H` = '1843' WHERE entry = 22860; UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 22861; UPDATE `creature_template` SET `faction_A` = '1854', `faction_H` = '1854' WHERE entry = 22861; UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 22862; UPDATE `creature_template` SET `faction_A` = '1854', `faction_H` = '1854' WHERE entry = 22862; UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 22863; UPDATE `creature_template` SET `faction_A` = '1855', `faction_H` = '1855' WHERE entry = 22863; UPDATE `creature_template` SET `unit_flags` = '559360' WHERE entry = 22864; UPDATE `creature_template` SET `faction_A` = '1855', `faction_H` = '1855' WHERE entry = 22864; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 22966; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 22966; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 22967; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 22967; UPDATE `creature_template` SET `faction_A` = '1855', `faction_H` = '1855' WHERE entry = 22967; UPDATE `creature_template` SET `faction_A` = '1876', `faction_H` = '1876' WHERE entry = 23434; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 23434; UPDATE `creature_template` SET `unit_flags` = '33587968' WHERE entry = 23443; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 23472; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 23725; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 23725; UPDATE `creature_template` SET `faction_A` = '634', `faction_H` = '634' WHERE entry = 23725; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 23740; UPDATE `creature_template` SET `unit_flags` = '67108864' WHERE entry = 23740; UPDATE `creature_template` SET `faction_A` = '634', `faction_H` = '634' WHERE entry = 23740; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 23740; UPDATE `creature_template` SET `speed_run` = '1.11111' WHERE entry = 23744; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 23744; UPDATE `creature_template` SET `speed_run` = '2.14286' WHERE entry = 23772; UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 23772; UPDATE `creature_template` SET `faction_A` = '634', `faction_H` = '634' WHERE entry = 23772; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 23796; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 23796; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 23796; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 23874; UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 23875; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 23875; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 23875; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 23876; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 23989; UPDATE `creature_template` SET `faction_A` = '1885', `faction_H` = '1885' WHERE entry = 23989; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 23990; UPDATE `creature_template` SET `faction_A` = '1885', `faction_H` = '1885' WHERE entry = 23990; UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 23991; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 23991; UPDATE `creature_template` SET `faction_A` = '1885', `faction_H` = '1885' WHERE entry = 23991; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 23992; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 23992; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 23992; UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 23993; UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 23993; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 23993; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 23993; UPDATE `creature_template` SET `speed_run` = '1.28571' WHERE entry = 24013; UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 24013; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 24013; UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 24013; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 24014; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 24014; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24018; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 24018; UPDATE `creature_template` SET `baseattacktime` = '2500' WHERE entry = 24018; UPDATE `creature_template` SET `speed_run` = '2.85714' WHERE entry = 24019; UPDATE `creature_template` SET `speed_walk` = '4' WHERE entry = 24019; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 24019; UPDATE `creature_template` SET `baseattacktime` = '1800' WHERE entry = 24019; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 24026; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 24026; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 24028; UPDATE `creature_template` SET `speed_run` = '1.07143' WHERE entry = 24029; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24029; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 24029; UPDATE `creature_template` SET `baseattacktime` = '2500' WHERE entry = 24029; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 24030; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24030; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 24030; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24031; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 24033; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24035; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24050; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24052; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24053; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24054; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24055; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24056; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24057; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24058; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24061; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24062; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24066; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 24067; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 24073; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 24073; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 24073; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24129; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24135; UPDATE `creature_template` SET `speed_run` = '1.85714' WHERE entry = 24142; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24142; UPDATE `creature_template` SET `speed_run` = '0.714286' WHERE entry = 24174; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24176; UPDATE `creature_template` SET `speed_run` = '1.11111' WHERE entry = 24178; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 24178; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 24196; UPDATE `creature_template` SET `unit_flags` = '537166080' WHERE entry = 24196; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 24196; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 24206; UPDATE `creature_template` SET `unit_flags` = '67108864' WHERE entry = 24206; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 24206; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 24212; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24212; UPDATE `creature_template` SET `scale` = '1.5' WHERE entry = 24212; UPDATE `creature_template` SET `speed_walk` = '1.55556' WHERE entry = 24228; UPDATE `creature_template` SET `faction_A` = '91', `faction_H` = '91' WHERE entry = 24228; UPDATE `creature_template` SET `unit_flags` = '770' WHERE entry = 24235; UPDATE `creature_template` SET `faction_A` = '91', `faction_H` = '91' WHERE entry = 24235; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 24261; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 24261; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24262; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 24262; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24316; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 24329; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 24329; UPDATE `creature_template` SET `faction_A` = '778', `faction_H` = '778' WHERE entry = 24329; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 24334; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24334; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 24334; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 24335; UPDATE `creature_template` SET `speed_walk` = '0.777776' WHERE entry = 24371; UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 24371; UPDATE `creature_template` SET `faction_A` = '778', `faction_H` = '778' WHERE entry = 24371; UPDATE `creature_template` SET `speed_run` = '2.28571' WHERE entry = 24514; UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 24514; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 24515; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 24515; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 24524; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 24524; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 24524; UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 24638; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 24638; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 24638; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 24669; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 24812; UPDATE `creature_template` SET `speed_walk` = '2.4' WHERE entry = 24812; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 24863; UPDATE `creature_template` SET `unit_flags` = '67108864' WHERE entry = 24863; UPDATE `creature_template` SET `faction_A` = '634', `faction_H` = '634' WHERE entry = 24863; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 24863; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 24901; UPDATE `creature_template` SET `unit_flags` = '526352' WHERE entry = 24901; UPDATE `creature_template` SET `faction_A` = '1693', `faction_H` = '1693' WHERE entry = 24901; UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 24918; UPDATE `creature_template` SET `faction_A` = '1793', `faction_H` = '1793' WHERE entry = 24918; UPDATE `creature_template` SET `faction_A` = '90', `faction_H` = '90' WHERE entry = 24919; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 24919; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 24920; UPDATE `creature_template` SET `faction_A` = '1873', `faction_H` = '1873' WHERE entry = 24920; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 24920; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 24922; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 24922; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 24925; UPDATE `creature_template` SET `unit_flags` = '33026' WHERE entry = 24933; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 24933; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 24937; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 24937; UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 25099; UPDATE `creature_template` SET `unit_flags` = '33817344' WHERE entry = 26298; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 26347; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26356; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 26356; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 26356; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26357; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 26357; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 26357; UPDATE `creature_template` SET `unit_flags` = '537692928' WHERE entry = 26363; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 26363; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 26366; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 26366; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 26369; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 26369; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26408; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 26408; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26414; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 26414; UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 26414; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26417; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 26417; UPDATE `creature_template` SET `faction_A` = '1771', `faction_H` = '1771' WHERE entry = 26417; UPDATE `creature_template` SET `faction_A` = '1999', `faction_H` = '1999' WHERE entry = 26418; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 26423; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26425; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26434; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 26434; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 26434; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26436; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 26436; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 26436; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 26446; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26447; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 26458; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26458; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26458; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 26461; UPDATE `creature_template` SET `speed_run` = '1.28571' WHERE entry = 26472; UPDATE `creature_template` SET `faction_A` = '2000', `faction_H` = '2000' WHERE entry = 26472; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 26500; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 26500; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26513; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 26513; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26516; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 26516; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 26543; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 26543; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26544; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26570; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26570; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26570; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26582; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26582; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 26583; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26583; UPDATE `creature_template` SET `speed_run` = '0.928571' WHERE entry = 26588; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 26588; UPDATE `creature_template` SET `speed_run` = '0.928571' WHERE entry = 26589; UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 26589; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 26592; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 26646; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 26646; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 26646; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 26646; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 26681; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 26681; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 26681; UPDATE `creature_template` SET `faction_A` = '2001', `faction_H` = '2001' WHERE entry = 26681; UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 26700; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 26701; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 26701; UPDATE `creature_template` SET `unit_flags` = '559120' WHERE entry = 26704; UPDATE `creature_template` SET `faction_A` = '1693', `faction_H` = '1693' WHERE entry = 26704; UPDATE `creature_template` SET `faction_A` = '44', `faction_H` = '44' WHERE entry = 26706; UPDATE `creature_template` SET `faction_A` = '2032', `faction_H` = '2032' WHERE entry = 26708; UPDATE `creature_template` SET `faction_A` = '1979', `faction_H` = '1979' WHERE entry = 26864; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 26883; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 26885; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 26935; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 27062; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27072; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27072; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 27117; UPDATE `creature_template` SET `faction_A` = '1315', `faction_H` = '1315' WHERE entry = 27117; UPDATE `creature_template` SET `unit_flags` = '563200' WHERE entry = 27118; UPDATE `creature_template` SET `faction_A` = '1314', `faction_H` = '1314' WHERE entry = 27118; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 27230; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 27263; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 27264; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 27265; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 27274; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27293; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 27322; UPDATE `creature_template` SET `unit_flags` = '33554688' WHERE entry = 27326; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 27408; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 27408; UPDATE `creature_template` SET `faction_A` = '1892', `faction_H` = '1892' WHERE entry = 27414; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 27421; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 27424; UPDATE `creature_template` SET `faction_A` = '1314', `faction_H` = '1314' WHERE entry = 27424; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 27456; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 27457; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 27469; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 27475; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 27479; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 27481; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 27486; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27493; UPDATE `creature_template` SET `faction_A` = '1314', `faction_H` = '1314' WHERE entry = 27493; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 27497; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27497; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 27523; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 27523; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27523; UPDATE `creature_template` SET `faction_A` = '1953', `faction_H` = '1953' WHERE entry = 27523; UPDATE `creature_template` SET `faction_A` = '2032', `faction_H` = '2032' WHERE entry = 27545; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27554; UPDATE `creature_template` SET `faction_A` = '1693', `faction_H` = '1693' WHERE entry = 27554; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27554; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27555; UPDATE `creature_template` SET `faction_A` = '37', `faction_H` = '37' WHERE entry = 27555; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27555; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 27581; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 27581; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 27676; UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 27676; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 27699; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27699; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 27699; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 27701; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 27701; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 27701; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 27783; UPDATE `creature_template` SET `speed_run` = '3' WHERE entry = 27869; UPDATE `creature_template` SET `speed_walk` = '8' WHERE entry = 27869; UPDATE `creature_template` SET `baseattacktime` = '10000' WHERE entry = 27869; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 27986; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28001; UPDATE `creature_template` SET `unit_flags` = '67108864' WHERE entry = 28003; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28003; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28004; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28009; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28011; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 28022; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 28023; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28024; UPDATE `creature_template` SET `unit_flags` = '294912' WHERE entry = 28024; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28025; UPDATE `creature_template` SET `unit_flags` = '294912' WHERE entry = 28025; UPDATE `creature_template` SET `unit_flags` = '8947712' WHERE entry = 28026; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28027; UPDATE `creature_template` SET `unit_flags` = '559632' WHERE entry = 28028; UPDATE `creature_template` SET `faction_A` = '2138', `faction_H` = '2138' WHERE entry = 28028; UPDATE `creature_template` SET `unit_flags` = '559616' WHERE entry = 28029; UPDATE `creature_template` SET `faction_A` = '2070', `faction_H` = '2070' WHERE entry = 28029; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 28030; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 28030; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28034; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28034; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28034; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28035; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28035; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28035; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28036; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28036; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 28037; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28041; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28043; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28068; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28068; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28076; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28076; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28077; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28077; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28078; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28078; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28078; UPDATE `creature_template` SET `scale` = '1.3' WHERE entry = 28078; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 28078; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28079; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28079; UPDATE `creature_template` SET `unit_flags` = '559120' WHERE entry = 28079; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 28079; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28080; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28080; UPDATE `creature_template` SET `unit_flags` = '294912' WHERE entry = 28080; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28081; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28081; UPDATE `creature_template` SET `unit_flags` = '294912' WHERE entry = 28081; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28081; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28082; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28082; UPDATE `creature_template` SET `unit_flags` = '537166592' WHERE entry = 28086; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28086; UPDATE `creature_template` SET `unit_flags` = '537166592' WHERE entry = 28089; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 28089; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28089; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28095; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28095; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28096; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28097; UPDATE `creature_template` SET `faction_A` = '189', `faction_H` = '189' WHERE entry = 28098; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 28098; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28107; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 28107; UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 28108; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28111; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28111; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28112; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28112; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28113; UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 28113; UPDATE `creature_template` SET `unit_flags` = '570721024' WHERE entry = 28113; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28113; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 28114; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 28118; UPDATE `creature_template` SET `faction_A` = '834', `faction_H` = '834' WHERE entry = 28118; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28118; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28120; UPDATE `creature_template` SET `unit_flags` = '32776' WHERE entry = 28120; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28121; UPDATE `creature_template` SET `unit_flags` = '32776' WHERE entry = 28121; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28122; UPDATE `creature_template` SET `unit_flags` = '32776' WHERE entry = 28122; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28123; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28124; UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 28129; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 28129; UPDATE `creature_template` SET `faction_A` = '1999', `faction_H` = '1999' WHERE entry = 28129; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28138; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28138; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28139; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28139; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 28140; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28145; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28156; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28162; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28170; UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 28203; UPDATE `creature_template` SET `unit_flags` = '294912' WHERE entry = 28203; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 28203; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28204; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28208; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 28217; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28218; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28220; UPDATE `creature_template` SET `speed_run` = '1.14286' WHERE entry = 28221; UPDATE `creature_template` SET `unit_flags` = '100696064' WHERE entry = 28221; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28221; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28221; UPDATE `creature_template` SET `speed_walk` = '1.5' WHERE entry = 28222; UPDATE `creature_template` SET `unit_flags` = '16777224' WHERE entry = 28222; UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 28222; UPDATE `creature_template` SET `unit_flags` = '67141632' WHERE entry = 28233; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 28233; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28233; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28242; UPDATE `creature_template` SET `unit_flags` = '512' WHERE entry = 28246; UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 28246; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28246; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 28255; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28257; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28257; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28258; UPDATE `creature_template` SET `speed_walk` = '0.833332' WHERE entry = 28258; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28268; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 28268; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28268; UPDATE `creature_template` SET `dynamicflags` = '132' WHERE entry = 28274; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 28297; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28297; UPDATE `creature_template` SET `faction_A` = '2030', `faction_H` = '2030' WHERE entry = 28297; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28300; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28303; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28303; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28315; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 28315; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28323; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28323; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28324; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28333; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28346; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 28362; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28362; UPDATE `creature_template` SET `speed_run` = '1.5873' WHERE entry = 28378; UPDATE `creature_template` SET `speed_walk` = '1.44444' WHERE entry = 28378; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 28378; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28378; UPDATE `creature_template` SET `unit_flags` = '537166592' WHERE entry = 28380; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28380; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28387; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28388; UPDATE `creature_template` SET `faction_A` = '1771', `faction_H` = '1771' WHERE entry = 28388; UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 28388; UPDATE `creature_template` SET `speed_run` = '1.5873' WHERE entry = 28389; UPDATE `creature_template` SET `speed_walk` = '1.44444' WHERE entry = 28389; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28396; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28401; UPDATE `creature_template` SET `unit_flags` = '295680' WHERE entry = 28401; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 28401; UPDATE `creature_template` SET `scale` = '0.75' WHERE entry = 28401; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28402; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28403; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28403; UPDATE `creature_template` SET `unit_flags` = '67141632' WHERE entry = 28404; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28404; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28404; UPDATE `creature_template` SET `faction_A` = '834', `faction_H` = '834' WHERE entry = 28411; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28411; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 28416; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28417; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28417; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28418; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28418; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28418; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28442; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28442; UPDATE `creature_template` SET `faction_A` = '91', `faction_H` = '91' WHERE entry = 28452; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28454; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28455; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28456; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28457; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28458; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28459; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28460; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28461; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28462; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28463; UPDATE `creature_template` SET `speed_run` = '1.57143' WHERE entry = 28465; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28465; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28465; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28465; UPDATE `creature_template` SET `speed_run` = '1.5873' WHERE entry = 28467; UPDATE `creature_template` SET `speed_walk` = '1.44444' WHERE entry = 28467; UPDATE `creature_template` SET `baseattacktime` = '3000' WHERE entry = 28467; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 28473; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28479; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28494; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28494; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28495; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28495; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28496; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28496; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28504; UPDATE `creature_template` SET `faction_A` = '1771', `faction_H` = '1771' WHERE entry = 28504; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28504; UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 28514; UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 28515; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 28516; UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 28516; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28517; UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 28517; UPDATE `creature_template` SET `speed_run` = '2' WHERE entry = 28526; UPDATE `creature_template` SET `unit_flags` = '33587200' WHERE entry = 28526; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28527; UPDATE `creature_template` SET `faction_A` = '2080', `faction_H` = '2080' WHERE entry = 28538; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28541; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28575; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28575; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 28589; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 28589; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28597; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 28600; UPDATE `creature_template` SET `faction_A` = '1771', `faction_H` = '1771' WHERE entry = 28600; UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 28600; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 28617; UPDATE `creature_template` SET `speed_run` = '0.857143' WHERE entry = 28636; UPDATE `creature_template` SET `unit_flags` = '33024' WHERE entry = 28636; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28636; UPDATE `creature_template` SET `speed_run` = '2' WHERE entry = 28639; UPDATE `creature_template` SET `VehicleID` = '108' WHERE entry = 28639; UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 28639; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28639; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 28641; UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 28641; UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 28659; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 28659; UPDATE `creature_template` SET `speed_run` = '2.57143' WHERE entry = 28665; UPDATE `creature_template` SET `VehicleID` = '126' WHERE entry = 28665; UPDATE `creature_template` SET `unit_flags` = '33288' WHERE entry = 28665; UPDATE `creature_template` SET `speed_run` = '1.30952' WHERE entry = 28667; UPDATE `creature_template` SET `unit_flags` = '2147779136' WHERE entry = 28667; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 28668; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28668; UPDATE `creature_template` SET `unit_flags` = '2147779136' WHERE entry = 28668; UPDATE `creature_template` SET `unit_flags` = '33088' WHERE entry = 28671; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28671; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28672; UPDATE `creature_template` SET `unit_flags` = '34081024' WHERE entry = 28717; UPDATE `creature_template` SET `faction_A` = '2073', `faction_H` = '2073' WHERE entry = 28719; UPDATE `creature_template` SET `unit_flags` = '33554432' WHERE entry = 28724; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28745; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28747; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28747; UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 28747; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28748; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28748; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28748; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28748; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28750; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28752; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28752; UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 28752; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28754; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28754; UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 28754; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 28756; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28756; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28756; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 28759; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28759; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28779; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28784; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 28785; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 28785; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28792; UPDATE `creature_template` SET `unit_flags` = '788544' WHERE entry = 28793; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28796; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28797; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28799; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28800; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28802; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28803; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28827; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28829; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28830; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28831; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28832; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 28843; UPDATE `creature_template` SET `speed_walk` = '0.5' WHERE entry = 28844; UPDATE `creature_template` SET `unit_flags` = '537692416' WHERE entry = 28844; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28844; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28844; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28848; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28852; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 28852; UPDATE `creature_template` SET `speed_run` = '0.595239' WHERE entry = 28858; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 28858; UPDATE `creature_template` SET `faction_A` = '2098', `faction_H` = '2098' WHERE entry = 28858; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 28861; UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 28861; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 28862; UPDATE `creature_template` SET `faction_A` = '2099', `faction_H` = '2099' WHERE entry = 28862; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 28879; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28882; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 28882; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28902; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28916; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28917; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 28918; UPDATE `creature_template` SET `dynamicflags` = '12' WHERE entry = 28918; UPDATE `creature_template` SET `unit_class` = '2' WHERE entry = 28927; UPDATE `creature_template` SET `unit_flags` = '32776' WHERE entry = 28927; UPDATE `creature_template` SET `speed_run` = '2.57143' WHERE entry = 28952; UPDATE `creature_template` SET `unit_flags` = '295680' WHERE entry = 28952; UPDATE `creature_template` SET `baseattacktime` = '1000' WHERE entry = 28952; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 28988; UPDATE `creature_template` SET `faction_A` = '1771', `faction_H` = '1771' WHERE entry = 28988; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 29006; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 29013; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29015; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 29015; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 29021; UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 29021; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29022; UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 29022; UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 29023; UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 29024; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 29028; UPDATE `creature_template` SET `faction_A` = '2102', `faction_H` = '2102' WHERE entry = 29028; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 29035; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 29037; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29043; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 29043; UPDATE `creature_template` SET `speed_run` = '3.57143' WHERE entry = 29050; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 29050; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 29050; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 29058; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 29066; UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 29066; UPDATE `creature_template` SET `unit_flags` = '33555200' WHERE entry = 29069; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 29121; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29122; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 29122; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29122; UPDATE `creature_template` SET `speed_walk` = '1.55556' WHERE entry = 29124; UPDATE `creature_template` SET `faction_A` = '634', `faction_H` = '634' WHERE entry = 29129; UPDATE `creature_template` SET `faction_A` = '21', `faction_H` = '21' WHERE entry = 29133; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29146; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 29146; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 29149; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 29149; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 29157; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 29211; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 29235; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 29236; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 29236; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 29237; UPDATE `creature_template` SET `unit_flags` = '33538' WHERE entry = 29255; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29269; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29270; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29275; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 29319; UPDATE `creature_template` SET `faction_A` = '1990', `faction_H` = '1990' WHERE entry = 29319; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 29319; UPDATE `creature_template` SET `unit_flags` = '67108864' WHERE entry = 29327; UPDATE `creature_template` SET `faction_A` = '1990', `faction_H` = '1990' WHERE entry = 29327; UPDATE `creature_template` SET `dynamicflags` = '13' WHERE entry = 29327; UPDATE `creature_template` SET `unit_flags` = '16' WHERE entry = 29328; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 29332; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 29334; UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 29351; UPDATE `creature_template` SET `speed_walk` = '2.8' WHERE entry = 29351; UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 29358; UPDATE `creature_template` SET `speed_walk` = '2.8' WHERE entry = 29358; UPDATE `creature_template` SET `faction_A` = '14', `faction_H` = '14' WHERE entry = 29397; UPDATE `creature_template` SET `unit_flags` = '2181038080' WHERE entry = 29399; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 29402; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 29402; UPDATE `creature_template` SET `unit_flags` = '571246848' WHERE entry = 29404; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 29404; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 29404; UPDATE `creature_template` SET `faction_A` = '1692', `faction_H` = '1692' WHERE entry = 29411; UPDATE `creature_template` SET `faction_A` = '1693', `faction_H` = '1693' WHERE entry = 29413; UPDATE `creature_template` SET `faction_A` = '834', `faction_H` = '834' WHERE entry = 29436; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 29437; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 29438; UPDATE `creature_template` SET `faction_A` = '2115', `faction_H` = '2115' WHERE entry = 29438; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 29439; UPDATE `creature_template` SET `unit_flags` = '34816' WHERE entry = 29444; UPDATE `creature_template` SET `faction_A` = '2069', `faction_H` = '2069' WHERE entry = 29444; UPDATE `creature_template` SET `baseattacktime` = '1869' WHERE entry = 29444; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 29449; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 29450; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 29451; UPDATE `creature_template` SET `unit_flags` = '537166592' WHERE entry = 29454; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 29454; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29458; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 29459; UPDATE `creature_template` SET `speed_walk` = '2' WHERE entry = 29459; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 29460; UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 29460; UPDATE `creature_template` SET `unit_flags` = '33554432' WHERE entry = 29475; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29479; UPDATE `creature_template` SET `faction_A` = '634', `faction_H` = '634' WHERE entry = 29479; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29492; UPDATE `creature_template` SET `faction_A` = '2032', `faction_H` = '2032' WHERE entry = 29492; UPDATE `creature_template` SET `speed_run` = '1.28571' WHERE entry = 29498; UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 29500; UPDATE `creature_template` SET `speed_run` = '1.5873' WHERE entry = 29544; UPDATE `creature_template` SET `speed_walk` = '2.8' WHERE entry = 29544; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 29544; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 29545; UPDATE `creature_template` SET `speed_walk` = '3.2' WHERE entry = 29545; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 29545; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29571; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 29571; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29583; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29584; UPDATE `creature_template` SET `unit_flags` = '537133824' WHERE entry = 29584; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 29584; UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 29585; UPDATE `creature_template` SET `unit_flags` = '537133824' WHERE entry = 29585; UPDATE `creature_template` SET `faction_A` = '2113', `faction_H` = '2113' WHERE entry = 29585; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 29585; UPDATE `creature_template` SET `speed_run` = '1.28571' WHERE entry = 29592; UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 29598; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29605; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 29618; UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 29619; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 29619; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 29623; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 29623; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 29646; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 29654; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 29654; UPDATE `creature_template` SET `unit_flags` = '559104' WHERE entry = 29656; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 29656; UPDATE `creature_template` SET `speed_run` = '2' WHERE entry = 29664; UPDATE `creature_template` SET `speed_walk` = '2.4' WHERE entry = 29664; UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 29664; UPDATE `creature_template` SET `faction_A` = '2068', `faction_H` = '2068' WHERE entry = 29664; UPDATE `creature_template` SET `unit_flags` = '2147750658' WHERE entry = 29672; UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 29672; UPDATE `creature_template` SET `unit_flags` = '2147750658' WHERE entry = 29674; UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 29674; UPDATE `creature_template` SET `unit_flags` = '2147750658' WHERE entry = 29676; UPDATE `creature_template` SET `faction_A` = '714', `faction_H` = '714' WHERE entry = 29676; UPDATE `creature_template` SET `speed_run` = '2.85714' WHERE entry = 29679; UPDATE `creature_template` SET `speed_walk` = '1.44444' WHERE entry = 29679; UPDATE `creature_template` SET `unit_flags` = '8' WHERE entry = 29679; UPDATE `creature_template` SET `dynamicflags` = '4' WHERE entry = 29692; UPDATE `creature_template` SET `scale` = '0.5' WHERE entry = 29692; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 29693; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 29699; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 29699; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 29721; UPDATE `creature_template` SET `unit_flags` = '256' WHERE entry = 29856; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 29856; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 29917; UPDATE `creature_template` SET `unit_flags` = '33536' WHERE entry = 30007; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30009; UPDATE `creature_template` SET `unit_flags` = '768' WHERE entry = 30098; UPDATE `creature_template` SET `faction_A` = '35', `faction_H` = '35' WHERE entry = 30102; UPDATE `creature_template` SET `unit_flags` = '526336' WHERE entry = 30174; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 30265; UPDATE `creature_template` SET `speed_walk` = '10' WHERE entry = 30466; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 30560; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30671; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 30676; UPDATE `creature_template` SET `speed_run` = '1.42857' WHERE entry = 30737; UPDATE `creature_template` SET `speed_run` = '1.28968' WHERE entry = 30846; UPDATE `creature_template` SET `speed_walk` = '1.55556' WHERE entry = 30849; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 30856; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 30856; UPDATE `creature_template` SET `scale` = '1.2' WHERE entry = 30856; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 30860; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 30860; UPDATE `creature_template` SET `speed_run` = '1.71429' WHERE entry = 30861; UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 30861; UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 30861; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 30861; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 30862; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 30863; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 30864; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 30865; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 30868; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 30868; UPDATE `creature_template` SET `scale` = '1.2' WHERE entry = 30868; UPDATE `creature_template` SET `baseattacktime` = '1538' WHERE entry = 30868; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 30876; UPDATE `creature_template` SET `faction_A` = '634', `faction_H` = '634' WHERE entry = 31041; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 31106; UPDATE `creature_template` SET `unit_flags` = '64' WHERE entry = 31107; UPDATE `creature_template` SET `baseattacktime` = '1500' WHERE entry = 31109; UPDATE `creature_template` SET `faction_A` = '16', `faction_H` = '16' WHERE entry = 31123; UPDATE `creature_template` SET `speed_walk` = '1.11111' WHERE entry = 31229; UPDATE `creature_template` SET `unit_flags` = '32832' WHERE entry = 31229; UPDATE `creature_template` SET `faction_A` = '634', `faction_H` = '634' WHERE entry = 31229; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 31233; UPDATE `creature_template` SET `speed_walk` = '0.8' WHERE entry = 31236; UPDATE `creature_template` SET `speed_run` = '1.19048' WHERE entry = 31910; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 31911; UPDATE `creature_template` SET `speed_walk` = '0.666668' WHERE entry = 31911; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 32371; UPDATE `creature_template` SET `speed_run` = '0.142857' WHERE entry = 32522; UPDATE `creature_template` SET `speed_walk` = '0.4' WHERE entry = 32522; UPDATE `creature_template` SET `speed_walk` = '1.2' WHERE entry = 32569; UPDATE `creature_template` SET `dynamicflags` = '32' WHERE entry = 32569; UPDATE `creature_template` SET `speed_run` = '1.38571' WHERE entry = 32596; UPDATE `creature_template` SET `unit_flags` = '262400' WHERE entry = 33007; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 33007; UPDATE `creature_template` SET `unit_flags` = '262400' WHERE entry = 33008; UPDATE `creature_template` SET `faction_A` = '190', `faction_H` = '190' WHERE entry = 33008; UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 33010; UPDATE `creature_template` SET `faction_A` = '2204', `faction_H` = '2204' WHERE entry = 33010; UPDATE `creature_template` SET `unit_flags` = '776' WHERE entry = 33011; UPDATE `creature_template` SET `faction_A` = '2204', `faction_H` = '2204' WHERE entry = 33011; UPDATE `creature_template` SET `unit_flags` = '32768' WHERE entry = 33025; UPDATE `creature_template` SET `baseattacktime` = '2000' WHERE entry = 33025; UPDATE `creature_template` SET `speed_walk` = '1.6' WHERE entry = 33224; UPDATE `creature_template` SET `speed_run` = '0.992063' WHERE entry = 33422; UPDATE `creature_template` SET `unit_class` = '2' WHERE entry = 34381; UPDATE `creature_model_info` SET `combat_reach` = '1.125' WHERE modelid = 171; UPDATE `creature_model_info` SET `bounding_radius` = '1' WHERE modelid = 239; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 239; UPDATE `creature_model_info` SET `combat_reach` = '1.4375' WHERE modelid = 809; UPDATE `creature_model_info` SET `combat_reach` = '1.25' WHERE modelid = 842; UPDATE `creature_model_info` SET `combat_reach` = '0.15' WHERE modelid = 1160; UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 1269; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 1340; UPDATE `creature_model_info` SET `combat_reach` = '0.5' WHERE modelid = 1986; UPDATE `creature_model_info` SET `bounding_radius` = '0.60725' WHERE modelid = 1988; UPDATE `creature_model_info` SET `combat_reach` = '3.5' WHERE modelid = 1988; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 2306; UPDATE `creature_model_info` SET `combat_reach` = '0.15' WHERE modelid = 2536; UPDATE `creature_model_info` SET `bounding_radius` = '1.95' WHERE modelid = 2601; UPDATE `creature_model_info` SET `combat_reach` = '5.2' WHERE modelid = 2601; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3265; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 3922; UPDATE `creature_model_info` SET `bounding_radius` = '0.397228' WHERE modelid = 5450; UPDATE `creature_model_info` SET `combat_reach` = '1.3' WHERE modelid = 5450; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 7198; UPDATE `creature_model_info` SET `combat_reach` = '0.15' WHERE modelid = 7511; UPDATE `creature_model_info` SET `combat_reach` = '7.5' WHERE modelid = 8811; UPDATE `creature_model_info` SET `bounding_radius` = '0.347' WHERE modelid = 9590; UPDATE `creature_model_info` SET `combat_reach` = '0.15' WHERE modelid = 9829; UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 10621; UPDATE `creature_model_info` SET `bounding_radius` = '2.21' WHERE modelid = 10891; UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 10891; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 11032; UPDATE `creature_model_info` SET `bounding_radius` = '1.6967' WHERE modelid = 11554; UPDATE `creature_model_info` SET `combat_reach` = '2.85' WHERE modelid = 11554; UPDATE `creature_model_info` SET `bounding_radius` = '1.3' WHERE modelid = 12350; UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 12350; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 13468; UPDATE `creature_model_info` SET `combat_reach` = '3.125' WHERE modelid = 13629; UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 13662; UPDATE `creature_model_info` SET `combat_reach` = '0.15' WHERE modelid = 14952; UPDATE `creature_model_info` SET `combat_reach` = '3.25' WHERE modelid = 15145; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 15297; UPDATE `creature_model_info` SET `combat_reach` = '0.25' WHERE modelid = 15470; UPDATE `creature_model_info` SET `combat_reach` = '0.25' WHERE modelid = 15471; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 15579; UPDATE `creature_model_info` SET `bounding_radius` = '0.77' WHERE modelid = 16033; UPDATE `creature_model_info` SET `combat_reach` = '22' WHERE modelid = 16033; UPDATE `creature_model_info` SET `combat_reach` = '5.5' WHERE modelid = 16215; UPDATE `creature_model_info` SET `combat_reach` = '7.5' WHERE modelid = 16309; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16377; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 16949; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 17384; UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 17456; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 17522; UPDATE `creature_model_info` SET `bounding_radius` = '0.3' WHERE modelid = 18043; UPDATE `creature_model_info` SET `combat_reach` = '0.6' WHERE modelid = 18043; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18484; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18749; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18751; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18788; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18791; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18890; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18941; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18942; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 18943; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 19487; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 19489; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 19490; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 19595; UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 20017; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20113; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20114; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20115; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 20220; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20350; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20353; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20443; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20444; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20446; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20447; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20448; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20449; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 20712; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 20713; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20716; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20718; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20719; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20720; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20721; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 20722; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 20800; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 20803; UPDATE `creature_model_info` SET `combat_reach` = '0.375' WHERE modelid = 20996; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21273; UPDATE `creature_model_info` SET `combat_reach` = '0.45' WHERE modelid = 21360; UPDATE `creature_model_info` SET `combat_reach` = '7' WHERE modelid = 21718; UPDATE `creature_model_info` SET `combat_reach` = '1.125' WHERE modelid = 21910; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 21961; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21983; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21984; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21985; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 21986; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 21987; UPDATE `creature_model_info` SET `combat_reach` = '2.625' WHERE modelid = 21988; UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 22005; UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 22007; UPDATE `creature_model_info` SET `combat_reach` = '4.5' WHERE modelid = 22008; UPDATE `creature_model_info` SET `combat_reach` = '4.5' WHERE modelid = 22009; UPDATE `creature_model_info` SET `combat_reach` = '4.5' WHERE modelid = 22014; UPDATE `creature_model_info` SET `combat_reach` = '2.4' WHERE modelid = 22015; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 22016; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22017; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22018; UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 22024; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22026; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22027; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22028; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22029; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22030; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22031; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22032; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22033; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22034; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22035; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22036; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22037; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22038; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22039; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22043; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22045; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22046; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22051; UPDATE `creature_model_info` SET `combat_reach` = '4.5' WHERE modelid = 22052; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 22110; UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 22115; UPDATE `creature_model_info` SET `combat_reach` = '2.625' WHERE modelid = 22116; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 22121; UPDATE `creature_model_info` SET `combat_reach` = '2.8' WHERE modelid = 22132; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 22133; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22134; UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 22136; UPDATE `creature_model_info` SET `combat_reach` = '4.5' WHERE modelid = 22142; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22190; UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 22207; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 22210; UPDATE `creature_model_info` SET `combat_reach` = '2.4' WHERE modelid = 22229; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22245; UPDATE `creature_model_info` SET `combat_reach` = '3' WHERE modelid = 22249; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 22255; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22266; UPDATE `creature_model_info` SET `bounding_radius` = '0.62' WHERE modelid = 22321; UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 22321; UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 22342; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22357; UPDATE `creature_model_info` SET `combat_reach` = '4' WHERE modelid = 22359; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 22359; UPDATE `creature_model_info` SET `combat_reach` = '2.4' WHERE modelid = 22392; UPDATE `creature_model_info` SET `combat_reach` = '1.25' WHERE modelid = 22447; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22510; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22514; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22515; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22516; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22518; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22519; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22520; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 22521; UPDATE `creature_model_info` SET `combat_reach` = '2.325' WHERE modelid = 22546; UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 22549; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 22648; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 22649; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 22650; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 22651; UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 22674; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 23337; UPDATE `creature_model_info` SET `combat_reach` = '2.5' WHERE modelid = 23356; UPDATE `creature_model_info` SET `combat_reach` = '3.125' WHERE modelid = 23358; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 23504; UPDATE `creature_model_info` SET `combat_reach` = '3.75' WHERE modelid = 23724; UPDATE `creature_model_info` SET `combat_reach` = '4.375' WHERE modelid = 23827; UPDATE `creature_model_info` SET `combat_reach` = '4.125' WHERE modelid = 23828; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 23896; UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 23958; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 23959; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24017; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24075; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24076; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24088; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24097; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24098; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24195; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24269; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24309; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24416; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24448; UPDATE `creature_model_info` SET `combat_reach` = '4.5' WHERE modelid = 24491; UPDATE `creature_model_info` SET `combat_reach` = '0.75' WHERE modelid = 24630; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24643; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 24644; UPDATE `creature_model_info` SET `bounding_radius` = '0.9747' WHERE modelid = 24649; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 24649; UPDATE `creature_model_info` SET `combat_reach` = '4.5' WHERE modelid = 24654; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24657; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24661; UPDATE `creature_model_info` SET `combat_reach` = '1.35' WHERE modelid = 24705; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 24969; UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 25005; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 25005; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25027; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25028; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 25029; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25056; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 25058; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25061; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 25062; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25067; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25068; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 25072; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25097; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25099; UPDATE `creature_model_info` SET `combat_reach` = '0.45' WHERE modelid = 25106; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 25110; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 25110; UPDATE `creature_model_info` SET `combat_reach` = '1.75' WHERE modelid = 25156; UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 25163; UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 25192; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25264; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25310; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25329; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 25340; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 25340; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 25379; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 25380; UPDATE `creature_model_info` SET `combat_reach` = '0.4' WHERE modelid = 25383; UPDATE `creature_model_info` SET `combat_reach` = '0.8' WHERE modelid = 25387; UPDATE `creature_model_info` SET `combat_reach` = '1.2' WHERE modelid = 25388; UPDATE `creature_model_info` SET `combat_reach` = '0.4' WHERE modelid = 25394; UPDATE `creature_model_info` SET `combat_reach` = '3.5' WHERE modelid = 25466; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25486; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25516; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25518; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 25524; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25596; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25597; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25598; UPDATE `creature_model_info` SET `combat_reach` = '1.1' WHERE modelid = 25638; UPDATE `creature_model_info` SET `bounding_radius` = '0.3672' WHERE modelid = 25661; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 25661; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25671; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25675; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 25681; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 25744; UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 25745; UPDATE `creature_model_info` SET `bounding_radius` = '0.325' WHERE modelid = 25860; UPDATE `creature_model_info` SET `combat_reach` = '0.975' WHERE modelid = 25860; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 25889; UPDATE `creature_model_info` SET `bounding_radius` = '0.6975' WHERE modelid = 25925; UPDATE `creature_model_info` SET `combat_reach` = '2.25' WHERE modelid = 25925; UPDATE `creature_model_info` SET `bounding_radius` = '0.42' WHERE modelid = 25928; UPDATE `creature_model_info` SET `combat_reach` = '2.4' WHERE modelid = 25928; UPDATE `creature_model_info` SET `combat_reach` = '0.9' WHERE modelid = 25938; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 25938; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26073; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26103; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26122; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26145; UPDATE `creature_model_info` SET `combat_reach` = '1.75' WHERE modelid = 26150; UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 26155; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 26155; UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 26226; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26229; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26230; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26234; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26250; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 26250; UPDATE `creature_model_info` SET `bounding_radius` = '0.465' WHERE modelid = 26279; UPDATE `creature_model_info` SET `combat_reach` = '7.5' WHERE modelid = 26279; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 26382; UPDATE `creature_model_info` SET `combat_reach` = '1.25' WHERE modelid = 26583; UPDATE `creature_model_info` SET `bounding_radius` = '1.272' WHERE modelid = 26618; UPDATE `creature_model_info` SET `combat_reach` = '2.4' WHERE modelid = 26618; UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 26636; UPDATE `creature_model_info` SET `combat_reach` = '5' WHERE modelid = 26709; UPDATE `creature_model_info` SET `combat_reach` = '5' WHERE modelid = 26713; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 26808; UPDATE `creature_model_info` SET `combat_reach` = '1.845' WHERE modelid = 26810; UPDATE `creature_model_info` SET `combat_reach` = '1.95' WHERE modelid = 26847; UPDATE `creature_model_info` SET `combat_reach` = '1.845' WHERE modelid = 26849; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26877; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26878; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26879; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 26880; UPDATE `creature_model_info` SET `combat_reach` = '4' WHERE modelid = 27060; UPDATE `creature_model_info` SET `combat_reach` = '1.875' WHERE modelid = 27078; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 27137; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27137; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27208; UPDATE `creature_model_info` SET `combat_reach` = '4.05' WHERE modelid = 27209; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27303; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27304; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27306; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 27358; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27360; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27365; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27366; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27367; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27368; UPDATE `creature_model_info` SET `combat_reach` = '4' WHERE modelid = 27391; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27391; UPDATE `creature_model_info` SET `combat_reach` = '2' WHERE modelid = 27392; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27392; UPDATE `creature_model_info` SET `combat_reach` = '2.5' WHERE modelid = 27451; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27451; UPDATE `creature_model_info` SET `combat_reach` = '6' WHERE modelid = 27478; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27478; UPDATE `creature_model_info` SET `combat_reach` = '0.8' WHERE modelid = 27482; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27482; UPDATE `creature_model_info` SET `combat_reach` = '1' WHERE modelid = 27572; UPDATE `creature_model_info` SET `gender` = '1' WHERE modelid = 27572; UPDATE `creature_model_info` SET `combat_reach` = '1.65' WHERE modelid = 27867; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27868; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 27869; UPDATE `creature_model_info` SET `combat_reach` = '0.75' WHERE modelid = 27907; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 27907; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27945; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27946; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 27948; UPDATE `creature_model_info` SET `bounding_radius` = '2.325' WHERE modelid = 28008; UPDATE `creature_model_info` SET `combat_reach` = '7.5' WHERE modelid = 28008; UPDATE `creature_model_info` SET `combat_reach` = '1.725' WHERE modelid = 28158; UPDATE `creature_model_info` SET `combat_reach` = '0.15' WHERE modelid = 28345; UPDATE `creature_model_info` SET `combat_reach` = '1.5' WHERE modelid = 28501; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 28501; UPDATE `creature_model_info` SET `combat_reach` = '1.25' WHERE modelid = 28618; UPDATE `creature_model_info` SET `combat_reach` = '1.8' WHERE modelid = 29113; UPDATE `creature_model_info` SET `gender` = '2' WHERE modelid = 29113;
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян |
Пользователь сказал cпасибо: | YuruY (28.02.2011) |
28.02.2011, 19:45 | #39 |
Брянский волк
|
С флагами невыделяемости поаккуратнее, а то уже которую обнову из-за этого флага квесты ломаются.
|
28.02.2011, 20:34 | #40 |
YTDB dev
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
|
НЭ гони, все закоменчено в 335а.
|