YTDB

Вернуться   YTDB > Баг-репорты (Патчи) / Bug reports (Patches) 3.3.5a > Другое / Other

Другое / Other Другие ошибки базы.
Если сообщение не подходит под ошибки заселения, баги предметов, или отсутствие рабочих скриптов - в этот раздел.

Ответ
 
Опции темы Поиск в этой теме Опции просмотра
Старый 11.02.2011, 19:21   #161
YuruY
YTDB dev
 
Аватар для YuruY
 
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
YuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспорима
По умолчанию

Цитата:
Сообщение от Lordronn Посмотреть сообщение
На тринити вейпоинт ИД привязывается к креатеру в креатуре темплейт аддон. Вот я привязал. Или я что-то не так понял?В темлпейт аддон я привязать не могу т.кя вынес моба.
Эт ты кому объясняешл? Они еще и умножают на 100 ... накойто хрен.

Ты вынес мобов из заселения и прилепил им поинты .... финал апдейта сразу это вчухает и вынесет эти поинты.

Цитата:
DELETE
`waypoint_data`
FROM
`waypoint_data`
LEFT JOIN
(`creature`)
ON
(`creature`.`guid`=`waypoint_data`.`id`)
WHERE
`creature`.`guid` IS NULL;
Если ты хотел внести поинты в "waypoints" то там по "ентри".
__________________
Правила написания баг-репортов.
Общие правила поведения - рекомендуемые исключительно всем для прочтения.
YuruY вне форума   Ответить с цитированием
Старый 11.02.2011, 19:53   #162
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию

Тогда вот так
Код:
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.
Heisenberg вне форума   Ответить с цитированием
Старый 11.02.2011, 20:15   #163
NeatElves
YTDB dev
 
Аватар для NeatElves
 
Регистрация: 05.11.2009
Сообщений: 5,920
Сказал(а) спасибо: 91
Поблагодарили 5,383 раз(а) в 4,847 сообщениях
NeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспорима
По умолчанию

Теория под мангос, если лич кричит в точке, тогда текстовку из квестскрипта можно забрать.) Флаги аддонами не вешал...

Последний раз редактировалось NeatElves; 15.02.2011 в 17:09.
NeatElves вне форума   Ответить с цитированием
Старый 11.02.2011, 21:17   #164
NeatElves
YTDB dev
 
Аватар для NeatElves
 
Регистрация: 05.11.2009
Сообщений: 5,920
Сказал(а) спасибо: 91
Поблагодарили 5,383 раз(а) в 4,847 сообщениях
NeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспорима
По умолчанию

Да, кстати, дай им http://www.trinitycore.org/w/Creature_tc2#spawnMask=0, тогда ничего не сотрет никто и их в мире не будет.)
NeatElves вне форума   Ответить с цитированием
Старый 11.02.2011, 22:53   #165
YuruY
YTDB dev
 
Аватар для YuruY
 
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
YuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспорима
По умолчанию

А как я это в мангос заливать буду? )
Ну это я сразу переименовываю: "waypoint_data"
А этого в триньке нет: "creature_movement_template", оно помоему там "waypoints".
__________________
Правила написания баг-репортов.
Общие правила поведения - рекомендуемые исключительно всем для прочтения.
YuruY вне форума   Ответить с цитированием
Старый 12.02.2011, 19:28   #166
Fedia22
YTDB Helper
 
Аватар для Fedia22
 
Регистрация: 06.11.2009
Адрес: Сибирь, 58°14′00″ с. ш. 92°29′00″ в. д.
Сообщений: 51
Сказал(а) спасибо: 206
Поблагодарили 54 раз(а) в 37 сообщениях
Fedia22 Скоро придёт к известности
По умолчанию

Цитата:
Сообщение от YuruY Посмотреть сообщение
Гляньте кто нибудь цены у вендора на оффе, нужно уточнить "порядок" цен, т.к. таких нет в ДБЦ (как их показывает ВХ): http://www.wowhead.com/npc=40607
Желательно скрин, хоть одной странички продажи чтоб видно было цены.
http://i15.fastpic.ru/big/2011/0212/...beaea05a50.jpg
http://i15.fastpic.ru/big/2011/0212/...ec47ef12c5.jpg
http://i15.fastpic.ru/big/2011/0212/...d445b956b0.jpg
http://i15.fastpic.ru/big/2011/0212/...3a78dfac4b.jpg

снифер не работает Кости в аське нет( обновлять некому(
__________________
меня съела учёба... очень редко за компом... все просьбы по поводу снифов выполняю по мере свободного времени... так что не пинайте!!
Fedia22 вне форума   Ответить с цитированием
Старый 12.02.2011, 19:45   #167
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию

Я уже скидывал
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Heisenberg вне форума   Ответить с цитированием
Старый 12.02.2011, 21:00   #168
YuruY
YTDB dev
 
Аватар для YuruY
 
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
YuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспорима
По умолчанию



Lordronn
Код:
REPLACE INTO `creature_addon` VALUES (1966, 1966, 0, 0, 1, 0, '');
__________________
Правила написания баг-репортов.
Общие правила поведения - рекомендуемые исключительно всем для прочтения.
YuruY вне форума   Ответить с цитированием
Старый 13.02.2011, 16:15   #169
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию

Цитата:
Сообщение от YuruY Посмотреть сообщение
"enGB" даже лучше.
Странная тетка, в темплетах нет, на ВХ тоже.)
http://ytdb.ru/album.php?albumid=17&pictureid=197

Код:
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);
В сниффе поймал
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Heisenberg вне форума   Ответить с цитированием
Старый 13.02.2011, 20:01   #170
YuruY
YTDB dev
 
Аватар для YuruY
 
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
YuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспорима
По умолчанию

Цитата:
Сообщение от Lordronn Посмотреть сообщение
В сниффе поймал
В 403 нет http://www.wowhead.com/npc=52030 , в "Added in patch 4.0.6" будут темплеты все, зачем напрягаться раньше времени (фулл темплеты, линкуются (квесты и мобы))?
__________________
Правила написания баг-репортов.
Общие правила поведения - рекомендуемые исключительно всем для прочтения.
YuruY вне форума   Ответить с цитированием
Старый 13.02.2011, 20:29   #171
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию

Цитата:
зачем напрягаться раньше времени
Я не особо напрягаюсь. Я плагин для query написал недели 2 - 3 назад. Остается только открыть снифф и выбрать моба)
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Heisenberg вне форума   Ответить с цитированием
Старый 13.02.2011, 21:08   #172
YuruY
YTDB dev
 
Аватар для YuruY
 
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
YuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспорима
По умолчанию

Выбирать не надо, открываешь и линкуешь всех.
__________________
Правила написания баг-репортов.
Общие правила поведения - рекомендуемые исключительно всем для прочтения.
YuruY вне форума   Ответить с цитированием
Старый 13.02.2011, 21:40   #173
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию

Цитата:
Сообщение от YuruY Посмотреть сообщение
Выбирать не надо, открываешь и линкуешь всех.
http://ytdb.ru/album.php?albumid=17&pictureid=206
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Heisenberg вне форума   Ответить с цитированием
Старый 13.02.2011, 23:54   #174
virusav
Брянский волк
 
Аватар для virusav
 
Регистрация: 06.11.2009
Сообщений: 588
Сказал(а) спасибо: 30
Поблагодарили 433 раз(а) в 260 сообщениях
virusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человек
Отправить сообщение для virusav с помощью ICQ
По умолчанию

По квесту http://ru.wowhead.com/quest=12029 нужен снифф или аура, которая накладывается на нпц при поджигании:
47214 Burninate Effect
SPELL_AURA_PERIODIC_DUMMY - ?
virusav вне форума   Ответить с цитированием
Старый 14.02.2011, 15:25   #175
YuruY
YTDB dev
 
Аватар для YuruY
 
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
YuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспорима
По умолчанию

Цитата:
Сообщение от Lordronn Посмотреть сообщение
Да я понял, мы добываем темплеты мобов немного по другому, и сразу фулл.
__________________
Правила написания баг-репортов.
Общие правила поведения - рекомендуемые исключительно всем для прочтения.
YuruY вне форума   Ответить с цитированием
Старый 16.02.2011, 19:08   #176
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию

Цитата:
Сообщение от virusav Посмотреть сообщение
По квесту http://ru.wowhead.com/quest=12029 нужен снифф или аура, которая накладывается на нпц при поджигании:
47214 Burninate Effect
SPELL_AURA_PERIODIC_DUMMY - ?


Да

Килл кредит идет ID - 47208 Burninate Kill Credit

Испепеление делается этим спелом ID - 42726 Декоративное - Испепеление (всего тела)

В сниффе еще попался 1 раз спелл ID - 47285 Зола.
Моб селф кастит

Дохнут мобы ID - 51744 Suicide (No Log)
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Heisenberg вне форума   Ответить с цитированием
Пользователь сказал cпасибо:
virusav (16.02.2011)
Старый 16.02.2011, 19:11   #177
virusav
Брянский волк
 
Аватар для virusav
 
Регистрация: 06.11.2009
Сообщений: 588
Сказал(а) спасибо: 30
Поблагодарили 433 раз(а) в 260 сообщениях
virusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человек
Отправить сообщение для virusav с помощью ICQ
По умолчанию

Желателен кусок сниффа с момента каста на нпц до его смерти, т.к. у указанных спеллов думми-эффекты, надо по сниффу разбирать, что к чему.
virusav вне форума   Ответить с цитированием
Старый 16.02.2011, 21:50   #178
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию

В аттаче спарсеный снифф + спарсеные up данные(фракция, позиция, флаги and etc.) . Сейчас 4.0.6, кучу опкодов сменили. У меня многие не совпадают. Не смотри на постороннюю кривую дату.

Госсипы для квеста "Перемирие"



Если надо какой нибудь квест сниффануть - стучите в аську 380 210 472
Вложения
Тип файла: rar ТРОЛИ.rar (86.9 Кб, 846 просмотров)
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян

Последний раз редактировалось Heisenberg; 16.02.2011 в 22:01.
Heisenberg вне форума   Ответить с цитированием
2 пользователя(ей) сказали cпасибо:
NeatElves (17.02.2011), virusav (16.02.2011)
Старый 16.02.2011, 22:30   #179
virusav
Брянский волк
 
Аватар для virusav
 
Регистрация: 06.11.2009
Сообщений: 588
Сказал(а) спасибо: 30
Поблагодарили 433 раз(а) в 260 сообщениях
virusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человек
Отправить сообщение для virusav с помощью ICQ
По умолчанию

Сниффать надо все квесты из раздела с требованием поддержки скриптов.
virusav вне форума   Ответить с цитированием
Старый 17.02.2011, 12:00   #180
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию



__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Heisenberg вне форума   Ответить с цитированием
2 пользователя(ей) сказали cпасибо:
NeatElves (17.02.2011), YuruY (17.02.2011)
Старый 17.02.2011, 14:26   #181
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию

Госсипы для квеста 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 - кидание дротика(по кв)
Вложения
Тип файла: rar зулдрак_1.rar (478.8 Кб, 606 просмотров)
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян

Последний раз редактировалось Heisenberg; 17.02.2011 в 15:40.
Heisenberg вне форума   Ответить с цитированием
2 пользователя(ей) сказали cпасибо:
NeatElves (17.02.2011), virusav (17.02.2011)
Старый 17.02.2011, 14:38   #182
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию



Кеш будет потом


С квестами зи "Нид скрипт суппорт" тяжко будет. У меня больше половины квестов уже сделаны. Правда есть 1 квест который я вчсера сниффанул, когда делал ачивку наквесты в зулдраке. Как только исправлю краш - скину спарсенный снифф. Некоторые квесты просто отсутствуют
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян

Последний раз редактировалось Heisenberg; 17.02.2011 в 15:39.
Heisenberg вне форума   Ответить с цитированием
2 пользователя(ей) сказали cпасибо:
NeatElves (17.02.2011), YuruY (17.02.2011)
Старый 17.02.2011, 16:20   #183
YuruY
YTDB dev
 
Аватар для YuruY
 
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
YuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспорима
По умолчанию

Lordronn
В аддонах: аура по умолчанию '' а не 0 (те что для поинтов оставляешь).
__________________
Правила написания баг-репортов.
Общие правила поведения - рекомендуемые исключительно всем для прочтения.
YuruY вне форума   Ответить с цитированием
Пользователь сказал cпасибо:
Heisenberg (17.02.2011)
Старый 17.02.2011, 18:50   #184
NeatElves
YTDB dev
 
Аватар для NeatElves
 
Регистрация: 05.11.2009
Сообщений: 5,920
Сказал(а) спасибо: 91
Поблагодарили 5,383 раз(а) в 4,847 сообщениях
NeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспоримаNeatElves Репутация неоспорима
По умолчанию

Цитата:
2011-02-17 17:37:21 Table `creature_movement` was auto corrected for using points out of order (invalid or points missing)
Глянул бегло, интересует вопрос - зачем мобам повторы в 2-х последних строчках, пример:
Цитата:
(112275,13,5848.888,559.2279,657.8221),
(112275,14,5848.888,559.2279,657.8221),
(77884,7,5857.606,565.6177,660.739),
(77884,8,5857.606,565.6177,660.739);
NeatElves вне форума   Ответить с цитированием
Старый 17.02.2011, 19:02   #185
Konctantin
RuDB Dev
 
Аватар для Konctantin
 
Регистрация: 06.11.2009
Сообщений: 677
Сказал(а) спасибо: 592
Поблагодарили 690 раз(а) в 289 сообщениях
Konctantin Великолепный пример подражанияKonctantin Великолепный пример подражанияKonctantin Великолепный пример подражанияKonctantin Великолепный пример подражанияKonctantin Великолепный пример подражанияKonctantin Великолепный пример подражания
По умолчанию

Все что пришло в сплинах, но тут надо смотреть по данным...
Konctantin вне форума   Ответить с цитированием
Пользователь сказал cпасибо:
Heisenberg (17.02.2011)
Старый 19.02.2011, 03:51   #186
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию

__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Heisenberg вне форума   Ответить с цитированием
Пользователь сказал cпасибо:
YuruY (19.02.2011)
Старый 20.02.2011, 19:23   #187
Kores
YTDB histori
 
Регистрация: 20.02.2010
Сообщений: 255
Сказал(а) спасибо: 51
Поблагодарили 179 раз(а) в 140 сообщениях
Kores Обладатель прекрасной аурыKores Обладатель прекрасной ауры
Отправить сообщение для Kores с помощью ICQ
По умолчанию

Цитата:
--------------------------------GUID (High: Unit Entry: 31517, Counter: 8027)----------------------------------
SET @GUID := XXXXX+6;
REPLACE 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
(`@GUID`, `31517`, `571`, `1`, `1`, `11686`, `0`, `5698.818`, `606.1702`, `646.3978`, `0.6108652`, `300`, `0`, `0`, `10282`, `0`, `0`, `1`);
UPDATE `creature_template` SET `speed_run` = 1.142857 WHERE entry = 31517;
UPDATE `creature_template` SET `faction_A` = 35, `faction_H` = 35 WHERE `entry` = 31517;
UPDATE `creature_template` SET `baseattacktime` = 2000 WHERE `entry` = 31517;
UPDATE `creature_template` SET `unit_flags` = `unit_flags` | 33554944 WHERE `entry` = 31517;
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;
Подозрительный триггер.
Kores вне форума   Ответить с цитированием
Старый 21.02.2011, 07:57   #188
YuruY
YTDB dev
 
Аватар для YuruY
 
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
YuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспорима
По умолчанию

Цитата:
Подозрительный триггер.
Он и есть там в базе.
__________________
Правила написания баг-репортов.
Общие правила поведения - рекомендуемые исключительно всем для прочтения.
YuruY вне форума   Ответить с цитированием
Старый 21.02.2011, 12:27   #189
YuruY
YTDB dev
 
Аватар для YuruY
 
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
YuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспорима
По умолчанию

Очень много предметов в продаже, нужно выяснить каких нет (возможно по уровню старые остались):
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
__________________
Правила написания баг-репортов.
Общие правила поведения - рекомендуемые исключительно всем для прочтения.
YuruY вне форума   Ответить с цитированием
Старый 22.02.2011, 14:28   #190
Kores
YTDB histori
 
Регистрация: 20.02.2010
Сообщений: 255
Сказал(а) спасибо: 51
Поблагодарили 179 раз(а) в 140 сообщениях
Kores Обладатель прекрасной аурыKores Обладатель прекрасной ауры
Отправить сообщение для Kores с помощью ICQ
По умолчанию

По сниффу заметил в яме сарона кучу триггеров, не знаю даже нужны ли они. ))

Код:
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.
Kores вне форума   Ответить с цитированием
Старый 22.02.2011, 14:57   #191
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию

Все они есть в базе, и даже больше)
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Heisenberg вне форума   Ответить с цитированием
Старый 22.02.2011, 15:10   #192
YuruY
YTDB dev
 
Аватар для YuruY
 
Регистрация: 05.11.2009
Адрес: Thunder Bluff
Сообщений: 3,625
Сказал(а) спасибо: 7,839
Поблагодарили 3,255 раз(а) в 498 сообщениях
YuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспоримаYuruY Репутация неоспорима
По умолчанию

Только както наоборот, те есть а этих нет, на этой маппе.

Далее, учитываем спавн-маску, в этом данже она =3.

Далее:
Цитата:
(`NULL`, `23837`, `658` ....
Эт че за ковычки, залейте с ними попробуйте, д.б:
Цитата:
('NULL', '23837', '658' ....
А те что выше, это для названий столбцов.
__________________
Правила написания баг-репортов.
Общие правила поведения - рекомендуемые исключительно всем для прочтения.
YuruY вне форума   Ответить с цитированием
Старый 22.02.2011, 15:19   #193
Kores
YTDB histori
 
Регистрация: 20.02.2010
Сообщений: 255
Сказал(а) спасибо: 51
Поблагодарили 179 раз(а) в 140 сообщениях
Kores Обладатель прекрасной аурыKores Обладатель прекрасной ауры
Отправить сообщение для Kores с помощью ICQ
По умолчанию

Цитата:
Сообщение от Lordronn Посмотреть сообщение
Все они есть в базе, и даже больше)
Я проверял, в яме сарона этих триггеров нету.
Kores вне форума   Ответить с цитированием
Старый 22.02.2011, 16:21   #194
virusav
Брянский волк
 
Аватар для virusav
 
Регистрация: 06.11.2009
Сообщений: 588
Сказал(а) спасибо: 30
Поблагодарили 433 раз(а) в 260 сообщениях
virusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человек
Отправить сообщение для virusav с помощью ICQ
По умолчанию

Вместо
Код:
('NULL', '23837', '658' ....
надо
Код:
(NULL, '23837', '658' ....
virusav вне форума   Ответить с цитированием
Старый 22.02.2011, 16:28   #195
Kores
YTDB histori
 
Регистрация: 20.02.2010
Сообщений: 255
Сказал(а) спасибо: 51
Поблагодарили 179 раз(а) в 140 сообщениях
Kores Обладатель прекрасной аурыKores Обладатель прекрасной ауры
Отправить сообщение для Kores с помощью ICQ
По умолчанию

Поправил.
Kores вне форума   Ответить с цитированием
Старый 22.02.2011, 16:37   #196
virusav
Брянский волк
 
Аватар для virusav
 
Регистрация: 06.11.2009
Сообщений: 588
Сказал(а) спасибо: 30
Поблагодарили 433 раз(а) в 260 сообщениях
virusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человек
Отправить сообщение для virusav с помощью ICQ
По умолчанию

Одну строку все-таки забыл.

Поясню на примере таблицы локализации.
Если в поле `name_loc8` вписать:
1. `NULL`, то получим ошибку, т.к. такого поля в таблице нет.
2. 'NULL', то в игре увидим текст NULL, т.к. это значение поля.
3. NULL, то получим в игре название на английском. Это правильный вариант.
virusav вне форума   Ответить с цитированием
Пользователь сказал cпасибо:
Kores (22.02.2011)
Старый 22.02.2011, 18:09   #197
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию



__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян

Последний раз редактировалось Heisenberg; 22.02.2011 в 18:19.
Heisenberg вне форума   Ответить с цитированием
2 пользователя(ей) сказали cпасибо:
NeatElves (01.03.2011), YuruY (22.02.2011)
Старый 28.02.2011, 17:44   #198
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию

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;
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Heisenberg вне форума   Ответить с цитированием
Пользователь сказал cпасибо:
YuruY (28.02.2011)
Старый 28.02.2011, 19:45   #199
virusav
Брянский волк
 
Аватар для virusav
 
Регистрация: 06.11.2009
Сообщений: 588
Сказал(а) спасибо: 30
Поблагодарили 433 раз(а) в 260 сообщениях
virusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человекvirusav Реально хороший человек
Отправить сообщение для virusav с помощью ICQ
По умолчанию

С флагами невыделяемости поаккуратнее, а то уже которую обнову из-за этого флага квесты ломаются.
virusav вне форума   Ответить с цитированием
Старый 28.02.2011, 19:54   #200
Heisenberg
Ученый
 
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
Heisenberg Обладатель прекрасной аурыHeisenberg Обладатель прекрасной ауры
По умолчанию

Вот не знаю как с ним быть. Пропускать нельзя, т.к могут же быть мобы у которых он есть всегда, но вы его пропустили.

Еквипы с катаклизма(улдум, нордскол 4-5 лок,1лока в оутленде)

Код:
UPDATE `creature_template` SET `equipment_id` = 16580 WHERE `entry` = 16580;
UPDATE `creature_template` SET `equipment_id` = 16587 WHERE `entry` = 16587;
UPDATE `creature_template` SET `equipment_id` = 16831 WHERE `entry` = 16831;
UPDATE `creature_template` SET `equipment_id` = 16851 WHERE `entry` = 16851;
UPDATE `creature_template` SET `equipment_id` = 16911 WHERE `entry` = 16911;
UPDATE `creature_template` SET `equipment_id` = 16947 WHERE `entry` = 16947;
UPDATE `creature_template` SET `equipment_id` = 16954 WHERE `entry` = 16954;
UPDATE `creature_template` SET `equipment_id` = 16967 WHERE `entry` = 16967;
UPDATE `creature_template` SET `equipment_id` = 17084 WHERE `entry` = 17084;
UPDATE `creature_template` SET `equipment_id` = 18449 WHERE `entry` = 18449;
UPDATE `creature_template` SET `equipment_id` = 18450 WHERE `entry` = 18450;
UPDATE `creature_template` SET `equipment_id` = 18451 WHERE `entry` = 18451;
UPDATE `creature_template` SET `equipment_id` = 18540 WHERE `entry` = 18540;
UPDATE `creature_template` SET `equipment_id` = 18595 WHERE `entry` = 18595;
UPDATE `creature_template` SET `equipment_id` = 18733 WHERE `entry` = 18733;
UPDATE `creature_template` SET `equipment_id` = 18827 WHERE `entry` = 18827;
UPDATE `creature_template` SET `equipment_id` = 18930 WHERE `entry` = 18930;
UPDATE `creature_template` SET `equipment_id` = 18931 WHERE `entry` = 18931;
UPDATE `creature_template` SET `equipment_id` = 18939 WHERE `entry` = 18939;
UPDATE `creature_template` SET `equipment_id` = 18944 WHERE `entry` = 18944;
UPDATE `creature_template` SET `equipment_id` = 18945 WHERE `entry` = 18945;
UPDATE `creature_template` SET `equipment_id` = 18948 WHERE `entry` = 18948;
UPDATE `creature_template` SET `equipment_id` = 18949 WHERE `entry` = 18949;
UPDATE `creature_template` SET `equipment_id` = 18950 WHERE `entry` = 18950;
UPDATE `creature_template` SET `equipment_id` = 18965 WHERE `entry` = 18965;
UPDATE `creature_template` SET `equipment_id` = 18966 WHERE `entry` = 18966;
UPDATE `creature_template` SET `equipment_id` = 18969 WHERE `entry` = 18969;
UPDATE `creature_template` SET `equipment_id` = 18970 WHERE `entry` = 18970;
UPDATE `creature_template` SET `equipment_id` = 18971 WHERE `entry` = 18971;
UPDATE `creature_template` SET `equipment_id` = 18972 WHERE `entry` = 18972;
UPDATE `creature_template` SET `equipment_id` = 18975 WHERE `entry` = 18975;
UPDATE `creature_template` SET `equipment_id` = 18977 WHERE `entry` = 18977;
UPDATE `creature_template` SET `equipment_id` = 18981 WHERE `entry` = 18981;
UPDATE `creature_template` SET `equipment_id` = 18986 WHERE `entry` = 18986;
UPDATE `creature_template` SET `equipment_id` = 19005 WHERE `entry` = 19005;
UPDATE `creature_template` SET `equipment_id` = 19190 WHERE `entry` = 19190;
UPDATE `creature_template` SET `equipment_id` = 19282 WHERE `entry` = 19282;
UPDATE `creature_template` SET `equipment_id` = 19298 WHERE `entry` = 19298;
UPDATE `creature_template` SET `equipment_id` = 19317 WHERE `entry` = 19317;
UPDATE `creature_template` SET `equipment_id` = 19319 WHERE `entry` = 19319;
UPDATE `creature_template` SET `equipment_id` = 19333 WHERE `entry` = 19333;
UPDATE `creature_template` SET `equipment_id` = 19339 WHERE `entry` = 19339;
UPDATE `creature_template` SET `equipment_id` = 19341 WHERE `entry` = 19341;
UPDATE `creature_template` SET `equipment_id` = 19342 WHERE `entry` = 19342;
UPDATE `creature_template` SET `equipment_id` = 19345 WHERE `entry` = 19345;
UPDATE `creature_template` SET `equipment_id` = 19348 WHERE `entry` = 19348;
UPDATE `creature_template` SET `equipment_id` = 19353 WHERE `entry` = 19353;
UPDATE `creature_template` SET `equipment_id` = 19355 WHERE `entry` = 19355;
UPDATE `creature_template` SET `equipment_id` = 19362 WHERE `entry` = 19362;
UPDATE `creature_template` SET `equipment_id` = 19364 WHERE `entry` = 19364;
UPDATE `creature_template` SET `equipment_id` = 19370 WHERE `entry` = 19370;
UPDATE `creature_template` SET `equipment_id` = 19384 WHERE `entry` = 19384;
UPDATE `creature_template` SET `equipment_id` = 19425 WHERE `entry` = 19425;
UPDATE `creature_template` SET `equipment_id` = 19444 WHERE `entry` = 19444;
UPDATE `creature_template` SET `equipment_id` = 19504 WHERE `entry` = 19504;
UPDATE `creature_template` SET `equipment_id` = 19625 WHERE `entry` = 19625;
UPDATE `creature_template` SET `equipment_id` = 19627 WHERE `entry` = 19627;
UPDATE `creature_template` SET `equipment_id` = 19740 WHERE `entry` = 19740;
UPDATE `creature_template` SET `equipment_id` = 19762 WHERE `entry` = 19762;
UPDATE `creature_template` SET `equipment_id` = 19768 WHERE `entry` = 19768;
UPDATE `creature_template` SET `equipment_id` = 19789 WHERE `entry` = 19789;
UPDATE `creature_template` SET `equipment_id` = 19792 WHERE `entry` = 19792;
UPDATE `creature_template` SET `equipment_id` = 19796 WHERE `entry` = 19796;
UPDATE `creature_template` SET `equipment_id` = 19802 WHERE `entry` = 19802;
UPDATE `creature_template` SET `equipment_id` = 19806 WHERE `entry` = 19806;
UPDATE `creature_template` SET `equipment_id` = 19825 WHERE `entry` = 19825;
UPDATE `creature_template` SET `equipment_id` = 20684 WHERE `entry` = 20684;
UPDATE `creature_template` SET `equipment_id` = 20872 WHERE `entry` = 20872;
UPDATE `creature_template` SET `equipment_id` = 20878 WHERE `entry` = 20878;
UPDATE `creature_template` SET `equipment_id` = 21153 WHERE `entry` = 21153;
UPDATE `creature_template` SET `equipment_id` = 21207 WHERE `entry` = 21207;
UPDATE `creature_template` SET `equipment_id` = 21257 WHERE `entry` = 21257;
UPDATE `creature_template` SET `equipment_id` = 21287 WHERE `entry` = 21287;
UPDATE `creature_template` SET `equipment_id` = 21314 WHERE `entry` = 21314;
UPDATE `creature_template` SET `equipment_id` = 21330 WHERE `entry` = 21330;
UPDATE `creature_template` SET `equipment_id` = 21336 WHERE `entry` = 21336;
UPDATE `creature_template` SET `equipment_id` = 21337 WHERE `entry` = 21337;
UPDATE `creature_template` SET `equipment_id` = 21357 WHERE `entry` = 21357;
UPDATE `creature_template` SET `equipment_id` = 21359 WHERE `entry` = 21359;
UPDATE `creature_template` SET `equipment_id` = 21384 WHERE `entry` = 21384;
UPDATE `creature_template` SET `equipment_id` = 21385 WHERE `entry` = 21385;
UPDATE `creature_template` SET `equipment_id` = 21404 WHERE `entry` = 21404;
UPDATE `creature_template` SET `equipment_id` = 21450 WHERE `entry` = 21450;
UPDATE `creature_template` SET `equipment_id` = 21453 WHERE `entry` = 21453;
UPDATE `creature_template` SET `equipment_id` = 21454 WHERE `entry` = 21454;
UPDATE `creature_template` SET `equipment_id` = 21455 WHERE `entry` = 21455;
UPDATE `creature_template` SET `equipment_id` = 21471 WHERE `entry` = 21471;
UPDATE `creature_template` SET `equipment_id` = 21500 WHERE `entry` = 21500;
UPDATE `creature_template` SET `equipment_id` = 21501 WHERE `entry` = 21501;
UPDATE `creature_template` SET `equipment_id` = 21701 WHERE `entry` = 21701;
UPDATE `creature_template` SET `equipment_id` = 21727 WHERE `entry` = 21727;
UPDATE `creature_template` SET `equipment_id` = 21736 WHERE `entry` = 21736;
UPDATE `creature_template` SET `equipment_id` = 21742 WHERE `entry` = 21742;
UPDATE `creature_template` SET `equipment_id` = 21749 WHERE `entry` = 21749;
UPDATE `creature_template` SET `equipment_id` = 21770 WHERE `entry` = 21770;
UPDATE `creature_template` SET `equipment_id` = 21771 WHERE `entry` = 21771;
UPDATE `creature_template` SET `equipment_id` = 21774 WHERE `entry` = 21774;
UPDATE `creature_template` SET `equipment_id` = 21775 WHERE `entry` = 21775;
UPDATE `creature_template` SET `equipment_id` = 21803 WHERE `entry` = 21803;
UPDATE `creature_template` SET `equipment_id` = 21808 WHERE `entry` = 21808;
UPDATE `creature_template` SET `equipment_id` = 21953 WHERE `entry` = 21953;
UPDATE `creature_template` SET `equipment_id` = 21954 WHERE `entry` = 21954;
UPDATE `creature_template` SET `equipment_id` = 21955 WHERE `entry` = 21955;
UPDATE `creature_template` SET `equipment_id` = 22016 WHERE `entry` = 22016;
UPDATE `creature_template` SET `equipment_id` = 22017 WHERE `entry` = 22017;
UPDATE `creature_template` SET `equipment_id` = 22018 WHERE `entry` = 22018;
UPDATE `creature_template` SET `equipment_id` = 22042 WHERE `entry` = 22042;
UPDATE `creature_template` SET `equipment_id` = 22043 WHERE `entry` = 22043;
UPDATE `creature_template` SET `equipment_id` = 22072 WHERE `entry` = 22072;
UPDATE `creature_template` SET `equipment_id` = 22081 WHERE `entry` = 22081;
UPDATE `creature_template` SET `equipment_id` = 22082 WHERE `entry` = 22082;
UPDATE `creature_template` SET `equipment_id` = 22211 WHERE `entry` = 22211;
UPDATE `creature_template` SET `equipment_id` = 22857 WHERE `entry` = 22857;
UPDATE `creature_template` SET `equipment_id` = 22858 WHERE `entry` = 22858;
UPDATE `creature_template` SET `equipment_id` = 22859 WHERE `entry` = 22859;
UPDATE `creature_template` SET `equipment_id` = 22861 WHERE `entry` = 22861;
UPDATE `creature_template` SET `equipment_id` = 22862 WHERE `entry` = 22862;
UPDATE `creature_template` SET `equipment_id` = 22863 WHERE `entry` = 22863;
UPDATE `creature_template` SET `equipment_id` = 22864 WHERE `entry` = 22864;
UPDATE `creature_template` SET `equipment_id` = 22966 WHERE `entry` = 22966;
UPDATE `creature_template` SET `equipment_id` = 22967 WHERE `entry` = 22967;
UPDATE `creature_template` SET `equipment_id` = 23434 WHERE `entry` = 23434;
UPDATE `creature_template` SET `equipment_id` = 23745 WHERE `entry` = 23745;
UPDATE `creature_template` SET `equipment_id` = 23762 WHERE `entry` = 23762;
UPDATE `creature_template` SET `equipment_id` = 23989 WHERE `entry` = 23989;
UPDATE `creature_template` SET `equipment_id` = 23990 WHERE `entry` = 23990;
UPDATE `creature_template` SET `equipment_id` = 23991 WHERE `entry` = 23991;
UPDATE `creature_template` SET `equipment_id` = 24014 WHERE `entry` = 24014;
UPDATE `creature_template` SET `equipment_id` = 24018 WHERE `entry` = 24018;
UPDATE `creature_template` SET `equipment_id` = 24029 WHERE `entry` = 24029;
UPDATE `creature_template` SET `equipment_id` = 24031 WHERE `entry` = 24031;
UPDATE `creature_template` SET `equipment_id` = 24032 WHERE `entry` = 24032;
UPDATE `creature_template` SET `equipment_id` = 24050 WHERE `entry` = 24050;
UPDATE `creature_template` SET `equipment_id` = 24052 WHERE `entry` = 24052;
UPDATE `creature_template` SET `equipment_id` = 24053 WHERE `entry` = 24053;
UPDATE `creature_template` SET `equipment_id` = 24055 WHERE `entry` = 24055;
UPDATE `creature_template` SET `equipment_id` = 24056 WHERE `entry` = 24056;
UPDATE `creature_template` SET `equipment_id` = 24058 WHERE `entry` = 24058;
UPDATE `creature_template` SET `equipment_id` = 24062 WHERE `entry` = 24062;
UPDATE `creature_template` SET `equipment_id` = 24123 WHERE `entry` = 24123;
UPDATE `creature_template` SET `equipment_id` = 24127 WHERE `entry` = 24127;
UPDATE `creature_template` SET `equipment_id` = 24129 WHERE `entry` = 24129;
UPDATE `creature_template` SET `equipment_id` = 24131 WHERE `entry` = 24131;
UPDATE `creature_template` SET `equipment_id` = 24135 WHERE `entry` = 24135;
UPDATE `creature_template` SET `equipment_id` = 24139 WHERE `entry` = 24139;
UPDATE `creature_template` SET `equipment_id` = 24142 WHERE `entry` = 24142;
UPDATE `creature_template` SET `equipment_id` = 24176 WHERE `entry` = 24176;
UPDATE `creature_template` SET `equipment_id` = 24212 WHERE `entry` = 24212;
UPDATE `creature_template` SET `equipment_id` = 24234 WHERE `entry` = 24234;
UPDATE `creature_template` SET `equipment_id` = 24282 WHERE `entry` = 24282;
UPDATE `creature_template` SET `equipment_id` = 24328 WHERE `entry` = 24328;
UPDATE `creature_template` SET `equipment_id` = 24362 WHERE `entry` = 24362;
UPDATE `creature_template` SET `equipment_id` = 24376 WHERE `entry` = 24376;
UPDATE `creature_template` SET `equipment_id` = 24390 WHERE `entry` = 24390;
UPDATE `creature_template` SET `equipment_id` = 24528 WHERE `entry` = 24528;
UPDATE `creature_template` SET `equipment_id` = 24532 WHERE `entry` = 24532;
UPDATE `creature_template` SET `equipment_id` = 24868 WHERE `entry` = 24868;
UPDATE `creature_template` SET `equipment_id` = 24918 WHERE `entry` = 24918;
UPDATE `creature_template` SET `equipment_id` = 24919 WHERE `entry` = 24919;
UPDATE `creature_template` SET `equipment_id` = 26356 WHERE `entry` = 26356;
UPDATE `creature_template` SET `equipment_id` = 26357 WHERE `entry` = 26357;
UPDATE `creature_template` SET `equipment_id` = 26408 WHERE `entry` = 26408;
UPDATE `creature_template` SET `equipment_id` = 26414 WHERE `entry` = 26414;
UPDATE `creature_template` SET `equipment_id` = 26424 WHERE `entry` = 26424;
UPDATE `creature_template` SET `equipment_id` = 26425 WHERE `entry` = 26425;
UPDATE `creature_template` SET `equipment_id` = 26434 WHERE `entry` = 26434;
UPDATE `creature_template` SET `equipment_id` = 26436 WHERE `entry` = 26436;
UPDATE `creature_template` SET `equipment_id` = 26447 WHERE `entry` = 26447;
UPDATE `creature_template` SET `equipment_id` = 26474 WHERE `entry` = 26474;
UPDATE `creature_template` SET `equipment_id` = 26519 WHERE `entry` = 26519;
UPDATE `creature_template` SET `equipment_id` = 26544 WHERE `entry` = 26544;
UPDATE `creature_template` SET `equipment_id` = 26604 WHERE `entry` = 26604;
UPDATE `creature_template` SET `equipment_id` = 26679 WHERE `entry` = 26679;
UPDATE `creature_template` SET `equipment_id` = 26681 WHERE `entry` = 26681;
UPDATE `creature_template` SET `equipment_id` = 26682 WHERE `entry` = 26682;
UPDATE `creature_template` SET `equipment_id` = 26704 WHERE `entry` = 26704;
UPDATE `creature_template` SET `equipment_id` = 26708 WHERE `entry` = 26708;
UPDATE `creature_template` SET `equipment_id` = 26839 WHERE `entry` = 26839;
UPDATE `creature_template` SET `equipment_id` = 26852 WHERE `entry` = 26852;
UPDATE `creature_template` SET `equipment_id` = 26860 WHERE `entry` = 26860;
UPDATE `creature_template` SET `equipment_id` = 26864 WHERE `entry` = 26864;
UPDATE `creature_template` SET `equipment_id` = 26883 WHERE `entry` = 26883;
UPDATE `creature_template` SET `equipment_id` = 26885 WHERE `entry` = 26885;
UPDATE `creature_template` SET `equipment_id` = 26935 WHERE `entry` = 26935;
UPDATE `creature_template` SET `equipment_id` = 26971 WHERE `entry` = 26971;
UPDATE `creature_template` SET `equipment_id` = 27062 WHERE `entry` = 27062;
UPDATE `creature_template` SET `equipment_id` = 27072 WHERE `entry` = 27072;
UPDATE `creature_template` SET `equipment_id` = 27102 WHERE `entry` = 27102;
UPDATE `creature_template` SET `equipment_id` = 27117 WHERE `entry` = 27117;
UPDATE `creature_template` SET `equipment_id` = 27118 WHERE `entry` = 27118;
UPDATE `creature_template` SET `equipment_id` = 27125 WHERE `entry` = 27125;
UPDATE `creature_template` SET `equipment_id` = 27132 WHERE `entry` = 27132;
UPDATE `creature_template` SET `equipment_id` = 27266 WHERE `entry` = 27266;
UPDATE `creature_template` SET `equipment_id` = 27293 WHERE `entry` = 27293;
UPDATE `creature_template` SET `equipment_id` = 27388 WHERE `entry` = 27388;
UPDATE `creature_template` SET `equipment_id` = 27424 WHERE `entry` = 27424;
UPDATE `creature_template` SET `equipment_id` = 27456 WHERE `entry` = 27456;
UPDATE `creature_template` SET `equipment_id` = 27457 WHERE `entry` = 27457;
UPDATE `creature_template` SET `equipment_id` = 27463 WHERE `entry` = 27463;
UPDATE `creature_template` SET `equipment_id` = 27469 WHERE `entry` = 27469;
UPDATE `creature_template` SET `equipment_id` = 27475 WHERE `entry` = 27475;
UPDATE `creature_template` SET `equipment_id` = 27479 WHERE `entry` = 27479;
UPDATE `creature_template` SET `equipment_id` = 27481 WHERE `entry` = 27481;
UPDATE `creature_template` SET `equipment_id` = 27482 WHERE `entry` = 27482;
UPDATE `creature_template` SET `equipment_id` = 27486 WHERE `entry` = 27486;
UPDATE `creature_template` SET `equipment_id` = 27493 WHERE `entry` = 27493;
UPDATE `creature_template` SET `equipment_id` = 27497 WHERE `entry` = 27497;
UPDATE `creature_template` SET `equipment_id` = 27545 WHERE `entry` = 27545;
UPDATE `creature_template` SET `equipment_id` = 27581 WHERE `entry` = 27581;
UPDATE `creature_template` SET `equipment_id` = 27615 WHERE `entry` = 27615;
UPDATE `creature_template` SET `equipment_id` = 27676 WHERE `entry` = 27676;
UPDATE `creature_template` SET `equipment_id` = 27699 WHERE `entry` = 27699;
UPDATE `creature_template` SET `equipment_id` = 27701 WHERE `entry` = 27701;
UPDATE `creature_template` SET `equipment_id` = 27986 WHERE `entry` = 27986;
UPDATE `creature_template` SET `equipment_id` = 27987 WHERE `entry` = 27987;
UPDATE `creature_template` SET `equipment_id` = 28023 WHERE `entry` = 28023;
UPDATE `creature_template` SET `equipment_id` = 28027 WHERE `entry` = 28027;
UPDATE `creature_template` SET `equipment_id` = 28028 WHERE `entry` = 28028;
UPDATE `creature_template` SET `equipment_id` = 28029 WHERE `entry` = 28029;
UPDATE `creature_template` SET `equipment_id` = 28032 WHERE `entry` = 28032;
UPDATE `creature_template` SET `equipment_id` = 28033 WHERE `entry` = 28033;
UPDATE `creature_template` SET `equipment_id` = 28034 WHERE `entry` = 28034;
UPDATE `creature_template` SET `equipment_id` = 28035 WHERE `entry` = 28035;
UPDATE `creature_template` SET `equipment_id` = 28036 WHERE `entry` = 28036;
UPDATE `creature_template` SET `equipment_id` = 28039 WHERE `entry` = 28039;
UPDATE `creature_template` SET `equipment_id` = 28041 WHERE `entry` = 28041;
UPDATE `creature_template` SET `equipment_id` = 28042 WHERE `entry` = 28042;
UPDATE `creature_template` SET `equipment_id` = 28043 WHERE `entry` = 28043;
UPDATE `creature_template` SET `equipment_id` = 28044 WHERE `entry` = 28044;
UPDATE `creature_template` SET `equipment_id` = 28045 WHERE `entry` = 28045;
UPDATE `creature_template` SET `equipment_id` = 28046 WHERE `entry` = 28046;
UPDATE `creature_template` SET `equipment_id` = 28056 WHERE `entry` = 28056;
UPDATE `creature_template` SET `equipment_id` = 28059 WHERE `entry` = 28059;
UPDATE `creature_template` SET `equipment_id` = 28062 WHERE `entry` = 28062;
UPDATE `creature_template` SET `equipment_id` = 28076 WHERE `entry` = 28076;
UPDATE `creature_template` SET `equipment_id` = 28077 WHERE `entry` = 28077;
UPDATE `creature_template` SET `equipment_id` = 28078 WHERE `entry` = 28078;
UPDATE `creature_template` SET `equipment_id` = 28079 WHERE `entry` = 28079;
UPDATE `creature_template` SET `equipment_id` = 28080 WHERE `entry` = 28080;
UPDATE `creature_template` SET `equipment_id` = 28081 WHERE `entry` = 28081;
UPDATE `creature_template` SET `equipment_id` = 28082 WHERE `entry` = 28082;
UPDATE `creature_template` SET `equipment_id` = 28090 WHERE `entry` = 28090;
UPDATE `creature_template` SET `equipment_id` = 28095 WHERE `entry` = 28095;
UPDATE `creature_template` SET `equipment_id` = 28099 WHERE `entry` = 28099;
UPDATE `creature_template` SET `equipment_id` = 28103 WHERE `entry` = 28103;
UPDATE `creature_template` SET `equipment_id` = 28114 WHERE `entry` = 28114;
UPDATE `creature_template` SET `equipment_id` = 28117 WHERE `entry` = 28117;
UPDATE `creature_template` SET `equipment_id` = 28123 WHERE `entry` = 28123;
UPDATE `creature_template` SET `equipment_id` = 28124 WHERE `entry` = 28124;
UPDATE `creature_template` SET `equipment_id` = 28125 WHERE `entry` = 28125;
UPDATE `creature_template` SET `equipment_id` = 28156 WHERE `entry` = 28156;
UPDATE `creature_template` SET `equipment_id` = 28175 WHERE `entry` = 28175;
UPDATE `creature_template` SET `equipment_id` = 28178 WHERE `entry` = 28178;
UPDATE `creature_template` SET `equipment_id` = 28186 WHERE `entry` = 28186;
UPDATE `creature_template` SET `equipment_id` = 28188 WHERE `entry` = 28188;
UPDATE `creature_template` SET `equipment_id` = 28204 WHERE `entry` = 28204;
UPDATE `creature_template` SET `equipment_id` = 28205 WHERE `entry` = 28205;
UPDATE `creature_template` SET `equipment_id` = 28222 WHERE `entry` = 28222;
UPDATE `creature_template` SET `equipment_id` = 28242 WHERE `entry` = 28242;
UPDATE `creature_template` SET `equipment_id` = 28244 WHERE `entry` = 28244;
UPDATE `creature_template` SET `equipment_id` = 28260 WHERE `entry` = 28260;
UPDATE `creature_template` SET `equipment_id` = 28283 WHERE `entry` = 28283;
UPDATE `creature_template` SET `equipment_id` = 28284 WHERE `entry` = 28284;
UPDATE `creature_template` SET `equipment_id` = 28303 WHERE `entry` = 28303;
UPDATE `creature_template` SET `equipment_id` = 28309 WHERE `entry` = 28309;
UPDATE `creature_template` SET `equipment_id` = 28315 WHERE `entry` = 28315;
UPDATE `creature_template` SET `equipment_id` = 28324 WHERE `entry` = 28324;
UPDATE `creature_template` SET `equipment_id` = 28388 WHERE `entry` = 28388;
UPDATE `creature_template` SET `equipment_id` = 28397 WHERE `entry` = 28397;
UPDATE `creature_template` SET `equipment_id` = 28398 WHERE `entry` = 28398;
UPDATE `creature_template` SET `equipment_id` = 28402 WHERE `entry` = 28402;
UPDATE `creature_template` SET `equipment_id` = 28403 WHERE `entry` = 28403;
UPDATE `creature_template` SET `equipment_id` = 28417 WHERE `entry` = 28417;
UPDATE `creature_template` SET `equipment_id` = 28418 WHERE `entry` = 28418;
UPDATE `creature_template` SET `equipment_id` = 28465 WHERE `entry` = 28465;
UPDATE `creature_template` SET `equipment_id` = 28473 WHERE `entry` = 28473;
UPDATE `creature_template` SET `equipment_id` = 28479 WHERE `entry` = 28479;
UPDATE `creature_template` SET `equipment_id` = 28480 WHERE `entry` = 28480;
UPDATE `creature_template` SET `equipment_id` = 28484 WHERE `entry` = 28484;
UPDATE `creature_template` SET `equipment_id` = 28494 WHERE `entry` = 28494;
UPDATE `creature_template` SET `equipment_id` = 28495 WHERE `entry` = 28495;
UPDATE `creature_template` SET `equipment_id` = 28496 WHERE `entry` = 28496;
UPDATE `creature_template` SET `equipment_id` = 28504 WHERE `entry` = 28504;
UPDATE `creature_template` SET `equipment_id` = 28518 WHERE `entry` = 28518;
UPDATE `creature_template` SET `equipment_id` = 28527 WHERE `entry` = 28527;
UPDATE `creature_template` SET `equipment_id` = 28532 WHERE `entry` = 28532;
UPDATE `creature_template` SET `equipment_id` = 28538 WHERE `entry` = 28538;
UPDATE `creature_template` SET `equipment_id` = 28568 WHERE `entry` = 28568;
UPDATE `creature_template` SET `equipment_id` = 28575 WHERE `entry` = 28575;
UPDATE `creature_template` SET `equipment_id` = 28600 WHERE `entry` = 28600;
UPDATE `creature_template` SET `equipment_id` = 28636 WHERE `entry` = 28636;
UPDATE `creature_template` SET `equipment_id` = 28668 WHERE `entry` = 28668;
UPDATE `creature_template` SET `equipment_id` = 28747 WHERE `entry` = 28747;
UPDATE `creature_template` SET `equipment_id` = 28752 WHERE `entry` = 28752;
UPDATE `creature_template` SET `equipment_id` = 28754 WHERE `entry` = 28754;
UPDATE `creature_template` SET `equipment_id` = 28787 WHERE `entry` = 28787;
UPDATE `creature_template` SET `equipment_id` = 28791 WHERE `entry` = 28791;
UPDATE `creature_template` SET `equipment_id` = 28792 WHERE `entry` = 28792;
UPDATE `creature_template` SET `equipment_id` = 28794 WHERE `entry` = 28794;
UPDATE `creature_template` SET `equipment_id` = 28796 WHERE `entry` = 28796;
UPDATE `creature_template` SET `equipment_id` = 28797 WHERE `entry` = 28797;
UPDATE `creature_template` SET `equipment_id` = 28800 WHERE `entry` = 28800;
UPDATE `creature_template` SET `equipment_id` = 28801 WHERE `entry` = 28801;
UPDATE `creature_template` SET `equipment_id` = 28806 WHERE `entry` = 28806;
UPDATE `creature_template` SET `equipment_id` = 28807 WHERE `entry` = 28807;
UPDATE `creature_template` SET `equipment_id` = 28809 WHERE `entry` = 28809;
UPDATE `creature_template` SET `equipment_id` = 28811 WHERE `entry` = 28811;
UPDATE `creature_template` SET `equipment_id` = 28812 WHERE `entry` = 28812;
UPDATE `creature_template` SET `equipment_id` = 28813 WHERE `entry` = 28813;
UPDATE `creature_template` SET `equipment_id` = 28818 WHERE `entry` = 28818;
UPDATE `creature_template` SET `equipment_id` = 28827 WHERE `entry` = 28827;
UPDATE `creature_template` SET `equipment_id` = 28832 WHERE `entry` = 28832;
UPDATE `creature_template` SET `equipment_id` = 28844 WHERE `entry` = 28844;
UPDATE `creature_template` SET `equipment_id` = 28848 WHERE `entry` = 28848;
UPDATE `creature_template` SET `equipment_id` = 28852 WHERE `entry` = 28852;
UPDATE `creature_template` SET `equipment_id` = 28855 WHERE `entry` = 28855;
UPDATE `creature_template` SET `equipment_id` = 28865 WHERE `entry` = 28865;
UPDATE `creature_template` SET `equipment_id` = 28869 WHERE `entry` = 28869;
UPDATE `creature_template` SET `equipment_id` = 28870 WHERE `entry` = 28870;
UPDATE `creature_template` SET `equipment_id` = 28882 WHERE `entry` = 28882;
UPDATE `creature_template` SET `equipment_id` = 28902 WHERE `entry` = 28902;
UPDATE `creature_template` SET `equipment_id` = 28916 WHERE `entry` = 28916;
UPDATE `creature_template` SET `equipment_id` = 28917 WHERE `entry` = 28917;
UPDATE `creature_template` SET `equipment_id` = 28918 WHERE `entry` = 28918;
UPDATE `creature_template` SET `equipment_id` = 28927 WHERE `entry` = 28927;
UPDATE `creature_template` SET `equipment_id` = 28988 WHERE `entry` = 28988;
UPDATE `creature_template` SET `equipment_id` = 29028 WHERE `entry` = 29028;
UPDATE `creature_template` SET `equipment_id` = 29122 WHERE `entry` = 29122;
UPDATE `creature_template` SET `equipment_id` = 29146 WHERE `entry` = 29146;
UPDATE `creature_template` SET `equipment_id` = 29157 WHERE `entry` = 29157;
UPDATE `creature_template` SET `equipment_id` = 29160 WHERE `entry` = 29160;
UPDATE `creature_template` SET `equipment_id` = 29169 WHERE `entry` = 29169;
UPDATE `creature_template` SET `equipment_id` = 29211 WHERE `entry` = 29211;
UPDATE `creature_template` SET `equipment_id` = 29235 WHERE `entry` = 29235;
UPDATE `creature_template` SET `equipment_id` = 29236 WHERE `entry` = 29236;
UPDATE `creature_template` SET `equipment_id` = 29237 WHERE `entry` = 29237;
UPDATE `creature_template` SET `equipment_id` = 29244 WHERE `entry` = 29244;
UPDATE `creature_template` SET `equipment_id` = 29269 WHERE `entry` = 29269;
UPDATE `creature_template` SET `equipment_id` = 29270 WHERE `entry` = 29270;
UPDATE `creature_template` SET `equipment_id` = 29275 WHERE `entry` = 29275;
UPDATE `creature_template` SET `equipment_id` = 29332 WHERE `entry` = 29332;
UPDATE `creature_template` SET `equipment_id` = 29351 WHERE `entry` = 29351;
UPDATE `creature_template` SET `equipment_id` = 29352 WHERE `entry` = 29352;
UPDATE `creature_template` SET `equipment_id` = 29366 WHERE `entry` = 29366;
UPDATE `creature_template` SET `equipment_id` = 29404 WHERE `entry` = 29404;
UPDATE `creature_template` SET `equipment_id` = 29413 WHERE `entry` = 29413;
UPDATE `creature_template` SET `equipment_id` = 29433 WHERE `entry` = 29433;
UPDATE `creature_template` SET `equipment_id` = 29434 WHERE `entry` = 29434;
UPDATE `creature_template` SET `equipment_id` = 29437 WHERE `entry` = 29437;
UPDATE `creature_template` SET `equipment_id` = 29439 WHERE `entry` = 29439;
UPDATE `creature_template` SET `equipment_id` = 29449 WHERE `entry` = 29449;
UPDATE `creature_template` SET `equipment_id` = 29450 WHERE `entry` = 29450;
UPDATE `creature_template` SET `equipment_id` = 29451 WHERE `entry` = 29451;
UPDATE `creature_template` SET `equipment_id` = 29458 WHERE `entry` = 29458;
UPDATE `creature_template` SET `equipment_id` = 29492 WHERE `entry` = 29492;
UPDATE `creature_template` SET `equipment_id` = 29498 WHERE `entry` = 29498;
UPDATE `creature_template` SET `equipment_id` = 29525 WHERE `entry` = 29525;
UPDATE `creature_template` SET `equipment_id` = 29571 WHERE `entry` = 29571;
UPDATE `creature_template` SET `equipment_id` = 29584 WHERE `entry` = 29584;
UPDATE `creature_template` SET `equipment_id` = 29592 WHERE `entry` = 29592;
UPDATE `creature_template` SET `equipment_id` = 29618 WHERE `entry` = 29618;
UPDATE `creature_template` SET `equipment_id` = 29619 WHERE `entry` = 29619;
UPDATE `creature_template` SET `equipment_id` = 29623 WHERE `entry` = 29623;
UPDATE `creature_template` SET `equipment_id` = 29654 WHERE `entry` = 29654;
UPDATE `creature_template` SET `equipment_id` = 29688 WHERE `entry` = 29688;
UPDATE `creature_template` SET `equipment_id` = 29689 WHERE `entry` = 29689;
UPDATE `creature_template` SET `equipment_id` = 29697 WHERE `entry` = 29697;
UPDATE `creature_template` SET `equipment_id` = 29699 WHERE `entry` = 29699;
UPDATE `creature_template` SET `equipment_id` = 29733 WHERE `entry` = 29733;
UPDATE `creature_template` SET `equipment_id` = 29796 WHERE `entry` = 29796;
UPDATE `creature_template` SET `equipment_id` = 29905 WHERE `entry` = 29905;
UPDATE `creature_template` SET `equipment_id` = 29907 WHERE `entry` = 29907;
UPDATE `creature_template` SET `equipment_id` = 29908 WHERE `entry` = 29908;
UPDATE `creature_template` SET `equipment_id` = 29909 WHERE `entry` = 29909;
UPDATE `creature_template` SET `equipment_id` = 29910 WHERE `entry` = 29910;
UPDATE `creature_template` SET `equipment_id` = 30006 WHERE `entry` = 30006;
UPDATE `creature_template` SET `equipment_id` = 30008 WHERE `entry` = 30008;
UPDATE `creature_template` SET `equipment_id` = 30011 WHERE `entry` = 30011;
UPDATE `creature_template` SET `equipment_id` = 30012 WHERE `entry` = 30012;
UPDATE `creature_template` SET `equipment_id` = 30146 WHERE `entry` = 30146;
UPDATE `creature_template` SET `equipment_id` = 30154 WHERE `entry` = 30154;
UPDATE `creature_template` SET `equipment_id` = 30175 WHERE `entry` = 30175;
UPDATE `creature_template` SET `equipment_id` = 30233 WHERE `entry` = 30233;
UPDATE `creature_template` SET `equipment_id` = 30265 WHERE `entry` = 30265;
UPDATE `creature_template` SET `equipment_id` = 30572 WHERE `entry` = 30572;
UPDATE `creature_template` SET `equipment_id` = 30676 WHERE `entry` = 30676;
UPDATE `creature_template` SET `equipment_id` = 30737 WHERE `entry` = 30737;
UPDATE `creature_template` SET `equipment_id` = 30739 WHERE `entry` = 30739;
UPDATE `creature_template` SET `equipment_id` = 30856 WHERE `entry` = 30856;
UPDATE `creature_template` SET `equipment_id` = 30860 WHERE `entry` = 30860;
UPDATE `creature_template` SET `equipment_id` = 30863 WHERE `entry` = 30863;
UPDATE `creature_template` SET `equipment_id` = 30864 WHERE `entry` = 30864;
UPDATE `creature_template` SET `equipment_id` = 30865 WHERE `entry` = 30865;
UPDATE `creature_template` SET `equipment_id` = 30868 WHERE `entry` = 30868;
UPDATE `creature_template` SET `equipment_id` = 31036 WHERE `entry` = 31036;
UPDATE `creature_template` SET `equipment_id` = 31106 WHERE `entry` = 31106;
UPDATE `creature_template` SET `equipment_id` = 31107 WHERE `entry` = 31107;
UPDATE `creature_template` SET `equipment_id` = 31109 WHERE `entry` = 31109;
UPDATE `creature_template` SET `equipment_id` = 31247 WHERE `entry` = 31247;
UPDATE `creature_template` SET `equipment_id` = 31911 WHERE `entry` = 31911;
UPDATE `creature_template` SET `equipment_id` = 32371 WHERE `entry` = 32371;
UPDATE `creature_template` SET `equipment_id` = 32372 WHERE `entry` = 32372;
UPDATE `creature_template` SET `equipment_id` = 32374 WHERE `entry` = 32374;
UPDATE `creature_template` SET `equipment_id` = 32725 WHERE `entry` = 32725;
UPDATE `creature_template` SET `equipment_id` = 33025 WHERE `entry` = 33025;
UPDATE `creature_template` SET `equipment_id` = 33422 WHERE `entry` = 33422;
UPDATE `creature_template` SET `equipment_id` = 42696 WHERE `entry` = 42696;
UPDATE `creature_template` SET `equipment_id` = 43430 WHERE `entry` = 43430;
UPDATE `creature_template` SET `equipment_id` = 43537 WHERE `entry` = 43537;
UPDATE `creature_template` SET `equipment_id` = 44896 WHERE `entry` = 44896;
UPDATE `creature_template` SET `equipment_id` = 44897 WHERE `entry` = 44897;
UPDATE `creature_template` SET `equipment_id` = 44922 WHERE `entry` = 44922;
UPDATE `creature_template` SET `equipment_id` = 44924 WHERE `entry` = 44924;
UPDATE `creature_template` SET `equipment_id` = 44926 WHERE `entry` = 44926;
UPDATE `creature_template` SET `equipment_id` = 44932 WHERE `entry` = 44932;
UPDATE `creature_template` SET `equipment_id` = 44976 WHERE `entry` = 44976;
UPDATE `creature_template` SET `equipment_id` = 44977 WHERE `entry` = 44977;
UPDATE `creature_template` SET `equipment_id` = 44981 WHERE `entry` = 44981;
UPDATE `creature_template` SET `equipment_id` = 45007 WHERE `entry` = 45007;
UPDATE `creature_template` SET `equipment_id` = 45122 WHERE `entry` = 45122;
UPDATE `creature_template` SET `equipment_id` = 45181 WHERE `entry` = 45181;
UPDATE `creature_template` SET `equipment_id` = 45186 WHERE `entry` = 45186;
UPDATE `creature_template` SET `equipment_id` = 45190 WHERE `entry` = 45190;
UPDATE `creature_template` SET `equipment_id` = 45205 WHERE `entry` = 45205;
UPDATE `creature_template` SET `equipment_id` = 45275 WHERE `entry` = 45275;
UPDATE `creature_template` SET `equipment_id` = 45772 WHERE `entry` = 45772;
UPDATE `creature_template` SET `equipment_id` = 45799 WHERE `entry` = 45799;
UPDATE `creature_template` SET `equipment_id` = 45905 WHERE `entry` = 45905;
UPDATE `creature_template` SET `equipment_id` = 45949 WHERE `entry` = 45949;
UPDATE `creature_template` SET `equipment_id` = 46134 WHERE `entry` = 46134;
UPDATE `creature_template` SET `equipment_id` = 46135 WHERE `entry` = 46135;
UPDATE `creature_template` SET `equipment_id` = 46315 WHERE `entry` = 46315;
UPDATE `creature_template` SET `equipment_id` = 46401 WHERE `entry` = 46401;
UPDATE `creature_template` SET `equipment_id` = 46402 WHERE `entry` = 46402;
UPDATE `creature_template` SET `equipment_id` = 46603 WHERE `entry` = 46603;
UPDATE `creature_template` SET `equipment_id` = 46646 WHERE `entry` = 46646;
UPDATE `creature_template` SET `equipment_id` = 47062 WHERE `entry` = 47062;
UPDATE `creature_template` SET `equipment_id` = 47306 WHERE `entry` = 47306;
UPDATE `creature_template` SET `equipment_id` = 47326 WHERE `entry` = 47326;
UPDATE `creature_template` SET `equipment_id` = 47567 WHERE `entry` = 47567;
UPDATE `creature_template` SET `equipment_id` = 47594 WHERE `entry` = 47594;
UPDATE `creature_template` SET `equipment_id` = 47625 WHERE `entry` = 47625;
UPDATE `creature_template` SET `equipment_id` = 47645 WHERE `entry` = 47645;
UPDATE `creature_template` SET `equipment_id` = 47684 WHERE `entry` = 47684;
UPDATE `creature_template` SET `equipment_id` = 47699 WHERE `entry` = 47699;
UPDATE `creature_template` SET `equipment_id` = 47715 WHERE `entry` = 47715;
UPDATE `creature_template` SET `equipment_id` = 47716 WHERE `entry` = 47716;
UPDATE `creature_template` SET `equipment_id` = 47755 WHERE `entry` = 47755;
UPDATE `creature_template` SET `equipment_id` = 48011 WHERE `entry` = 48011;
UPDATE `creature_template` SET `equipment_id` = 48012 WHERE `entry` = 48012;
UPDATE `creature_template` SET `equipment_id` = 48029 WHERE `entry` = 48029;
UPDATE `creature_template` SET `equipment_id` = 48040 WHERE `entry` = 48040;
UPDATE `creature_template` SET `equipment_id` = 48041 WHERE `entry` = 48041;
UPDATE `creature_template` SET `equipment_id` = 48043 WHERE `entry` = 48043;
UPDATE `creature_template` SET `equipment_id` = 48263 WHERE `entry` = 48263;
UPDATE `creature_template` SET `equipment_id` = 48267 WHERE `entry` = 48267;
UPDATE `creature_template` SET `equipment_id` = 48617 WHERE `entry` = 48617;
UPDATE `creature_template` SET `equipment_id` = 48697 WHERE `entry` = 48697;
UPDATE `creature_template` SET `equipment_id` = 48853 WHERE `entry` = 48853;
UPDATE `creature_template` SET `equipment_id` = 48856 WHERE `entry` = 48856;
UPDATE `creature_template` SET `equipment_id` = 48857 WHERE `entry` = 48857;
UPDATE `creature_template` SET `equipment_id` = 48858 WHERE `entry` = 48858;
UPDATE `creature_template` SET `equipment_id` = 48860 WHERE `entry` = 48860;
UPDATE `creature_template` SET `equipment_id` = 48861 WHERE `entry` = 48861;
UPDATE `creature_template` SET `equipment_id` = 48868 WHERE `entry` = 48868;
UPDATE `creature_template` SET `equipment_id` = 48874 WHERE `entry` = 48874;
UPDATE `creature_template` SET `equipment_id` = 48883 WHERE `entry` = 48883;
UPDATE `creature_template` SET `equipment_id` = 48884 WHERE `entry` = 48884;
UPDATE `creature_template` SET `equipment_id` = 48885 WHERE `entry` = 48885;
UPDATE `creature_template` SET `equipment_id` = 48886 WHERE `entry` = 48886;
UPDATE `creature_template` SET `equipment_id` = 48887 WHERE `entry` = 48887;
UPDATE `creature_template` SET `equipment_id` = 49156 WHERE `entry` = 49156;
UPDATE `creature_template` SET `equipment_id` = 50036 WHERE `entry` = 50036;
UPDATE `creature_template` SET `equipment_id` = 50037 WHERE `entry` = 50037;
UPDATE `creature_template` SET `equipment_id` = 50038 WHERE `entry` = 50038;
UPDATE `creature_template` SET `equipment_id` = 50048 WHERE `entry` = 50048;
UPDATE `creature_template` SET `equipment_id` = 50702 WHERE `entry` = 50702;
UPDATE `creature_template` SET `equipment_id` = 51759 WHERE `entry` = 51759;
UPDATE `creature_template` SET `equipment_id` = 51884 WHERE `entry` = 51884;
UPDATE `creature_template` SET `equipment_id` = 51909 WHERE `entry` = 51909;

insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('16580','21465','12452','5260');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('16587','0','0','13924');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('16831','1899','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('16851','0','0','12523');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('16911','14822','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('16947','1903','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('16954','12902','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('16967','3494','11506','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('17084','12950','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18449','3494','11506','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18450','19214','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18451','1896','2052','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18540','1895','2053','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18595','2695','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18733','22738','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18827','1903','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18930','3433','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18931','13312','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18939','2182','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18944','12902','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18945','13504','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18948','1899','143','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18949','14873','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18950','5289','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18965','0','0','14105');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18966','24017','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18969','14084','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18970','0','0','28023');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18971','13050','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18972','5600','11505','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18975','10613','10613','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18977','12902','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18981','28037','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('18986','14082','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19005','26003','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19190','14877','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19282','28037','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19298','25816','25816','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19317','3433','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19319','6334','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19333','1903','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19339','0','0','5262');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19341','1903','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19342','1903','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19345','1910','2081','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19348','2202','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19353','14533','0','5260');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19355','1903','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19362','30181','21549','2507');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19364','30182','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19370','14533','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19384','2182','0','12523');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19425','1903','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19444','1903','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19504','23382','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19625','2717','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19627','2716','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19740','14874','14874','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19762','10614','1984','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19768','12182','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19789','18122','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19792','29417','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19796','29715','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19802','5287','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19806','27405','24328','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('19825','30578','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('20684','11343','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('20872','13698','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('20878','10612','12454','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21153','30182','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21207','22391','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21257','2199','3694','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21287','25879','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21314','12755','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21330','30445','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21336','30455','0','30456');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21337','5285','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21357','14533','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21359','18062','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21384','29410','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21385','29310','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21404','22738','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21450','19987','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21453','29685','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21454','17383','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21455','1910','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21471','13312','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21500','31274','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21501','31273','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21701','14707','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21727','13312','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21736','2182','1984','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21742','5956','24322','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21749','17462','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21770','30424','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21771','1903','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21774','30714','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21775','1903','13859','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21803','2695','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21808','22215','22215','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21953','19981','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21954','29404','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('21955','19981','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22016','31207','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22017','24321','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22018','25758','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22042','14533','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22043','30848','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22072','31327','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22081','13336','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22082','14874','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22211','29403','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22857','5287','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22858','2147','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22859','2147','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22861','28800','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22862','14873','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22863','20468','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22864','23673','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22966','28400','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('22967','12403','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('23434','30388','0','32827');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('23745','2023','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('23762','2717','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('23989','14707','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('23990','5303','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('23991','33544','13922','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24014','13722','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24018','28650','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24029','4993','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24031','9659','12456','5262');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24032','0','0','13924');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24050','3361','13922','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24052','1903','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24053','0','12857','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24055','1117','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24056','1117','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24058','1902','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24062','2704','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24123','29310','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24127','5287','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24129','25588','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24131','11763','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24135','13721','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24139','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24142','2703','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24176','1910','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24212','1910','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24234','28914','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24282','33320','1961','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24328','1910','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24362','1910','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24376','12742','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24390','9659','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24528','2147','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24532','13612','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24868','1911','1911','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24918','30367','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('24919','31965','31965','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26356','1904','1904','5259');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26357','2023','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26408','35727','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26414','0','0','28286');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26424','1897','13922','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26425','15222','13922','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26434','2023','0','3778');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26436','29310','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26447','2013','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26474','25698','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26519','2558','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26544','33275','33275','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26604','2717','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26679','0','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26681','29310','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26682','1906','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26704','33979','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26708','1905','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26839','14870','0','5260');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26852','0','0','13924');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26860','28918','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26864','14870','0','5260');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26883','2715','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26885','36790','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26935','0','0','25270');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('26971','0','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27062','0','13611','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27072','1899','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27102','29165','18826','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27117','2178','10616','2551');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27118','10611','10614','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27125','1906','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27132','12856','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27266','14870','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27293','5278','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27388','29900','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27424','10611','10614','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27456','14870','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27457','14870','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27463','14870','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27469','0','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27475','2178','1203','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27479','0','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27481','2178','1203','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27482','2178','1203','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27486','0','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27493','10611','10614','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27497','0','0','25270');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27545','0','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27581','0','0','25270');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27615','21795','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27676','1909','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27699','0','0','29151');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27701','778','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27986','5278','0','15460');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('27987','0','0','15460');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28023','33276','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28027','0','28734','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28028','40598','40597','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28029','39658','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28032','28914','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28033','31824','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28034','18596','33789','23051');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28035','2810','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28036','44252','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28039','1899','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28041','44733','42543','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28042','1899','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28043','1899','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28044','1899','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28045','1899','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28046','1292','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28056','39661','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28059','29409','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28062','31801','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28076','3494','11506','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28077','11763','0','5262');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28078','5289','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28079','10617','0','5262');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28080','2023','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28081','2023','0','5870');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28082','9477','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28090','1899','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28095','2023','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28099','33320','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28103','33301','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28114','19053','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28117','33521','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28123','1910','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28124','36512','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28125','1899','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28156','33521','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28175','22199','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28178','33168','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28186','3494','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28188','14586','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28204','13750','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28205','2717','3757','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28222','25316','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28242','34820','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28244','10612','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28260','33521','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28283','39661','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28284','31824','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28303','14707','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28309','39662','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28315','5303','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28324','1899','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28388','40729','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28397','14824','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28398','33521','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28402','38602','38603','13147');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28403','35740','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28417','23369','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28418','36778','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28465','28914','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28473','55294','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28479','33798','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28480','944','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28484','1459','33789','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28494','14879','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28495','13336','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28496','2827','2827','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28504','4993','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28518','38707','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28527','12742','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28532','38633','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28538','28678','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28568','31824','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28575','36778','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28600','13952','13319','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28636','33431','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28668','28914','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28747','28678','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28752','13622','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28754','28739','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28787','2884','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28791','1906','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28792','1906','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28794','1910','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28796','0','13611','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28797','31824','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28800','0','0','5260');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28801','40595','40596','11021');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28806','1910','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28807','1906','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28809','0','12855','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28811','2202','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28812','1117','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28813','0','0','12523');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28818','40595','40596','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28827','0','12855','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28832','0','34717','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28844','12294','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28848','33975','33975','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28852','12322','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28855','12329','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28865','37123','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28869','0','34717','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28870','0','12855','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28882','30795','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28902','34638','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28916','25646','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28917','39312','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28918','33169','13319','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28927','39312','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('28988','29435','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29028','39892','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29122','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29146','12802','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29157','2705','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29160','39742','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29169','13705','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29211','18596','39921','44454');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29235','17123','39922','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29236','17123','39922','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29237','1906','2081','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29244','2827','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29269','0','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29270','1910','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29275','2202','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29332','33981','39923','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29351','40770','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29352','40436','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29366','40542','39288','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29404','3350','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29413','9378','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29433','2884','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29434','2901','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29437','40967','40968','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29439','0','0','36755');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29449','40606','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29450','40605','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29451','40607','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29458','0','0','40759');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29492','0','0','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29498','40436','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29525','2023','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29571','0','0','40759');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29584','40436','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29592','40436','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29618','3350','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29619','33276','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29623','5289','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29654','33981','33981','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29688','1911','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29689','11087','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29697','41090','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29699','33975','33975','23051');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29733','11542','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29796','34079','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29905','2827','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29907','1903','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29908','12850','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29909','2198','12870','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('29910','34818','0','25280');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30006','40542','40542','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30008','40487','0','40759');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30011','12858','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30012','40542','39288','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30146','1910','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30154','40542','39288','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30175','40436','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30233','24320','24320','24326');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30265','13631','0','24326');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30572','0','0','36755');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30676','12742','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30737','19015','0','25280');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30739','14870','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30856','12892','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30860','41256','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30863','43223','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30864','0','0','43224');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30865','43221','43222','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('30868','39743','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('31036','13160','0','14105');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('31106','11323','0','5260');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('31107','12593','0','14118');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('31109','24017','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('31247','1911','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('31911','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('32371','20718','0','6231');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('32372','20718','0','6231');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('32374','13723','0','6231');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('32725','30310','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('33025','36791','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('33422','39743','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('42696','56050','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('43430','56070','56070','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('43537','58802','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('44896','60765','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('44897','0','0','60764');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('44922','57009','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('44924','57025','56175','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('44926','0','0','60789');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('44932','0','0','60790');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('44976','58802','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('44977','57113','57113','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('44981','56231','57021','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('45007','2179','2179','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('45122','57009','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('45181','60765','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('45186','60765','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('45190','60765','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('45205','2527','0','60764');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('45275','60894','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('45772','62798','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('45799','3433','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('45905','29583','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('45949','2179','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('46134','57027','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('46135','58803','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('46315','3433','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('46401','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('46402','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('46603','3433','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('46646','62392','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('47062','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('47306','62798','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('47326','60765','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('47567','62798','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('47594','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('47625','1903','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('47645','32912','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('47684','64351','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('47699','30697','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('47715','27412','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('47716','3433','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('47755','8196','8196','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48011','62491','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48012','0','0','60789');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48029','62491','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48040','60765','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48041','0','0','60764');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48043','0','0','60764');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48263','62797','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48267','62798','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48617','1903','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48697','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48853','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48856','2827','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48857','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48858','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48860','2199','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48861','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48868','1906','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48874','62798','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48883','62798','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48884','1906','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48885','3696','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48886','0','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('48887','3696','0','5258');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('49156','3433','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('50036','43967','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('50037','43967','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('50038','62798','0','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('50048','58137','57763','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('50702','0','0','61320');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('51759','56231','57021','0');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('51884','3361','13922','2552');
insert into `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) values('51909','14533','0','5260');
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Heisenberg вне форума   Ответить с цитированием
Пользователь сказал cпасибо:
YuruY (24.03.2011)
Ответ

Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.



Текущее время: 09:18. Часовой пояс GMT +4.


YTDB - MaNGOS DataBase

Русский форум Мангос - официальный форум RMDC

Главная цель проекта MaNGOS - обучающая, поэтому разрешается использовать исходный код и собранную программу только для образовательных целей.
Вы не можете использовать MaNGOS в коммерческих целях, а также не разрешается устанавливать публичные серверы на базе MaNGOS.
Любое копирование материалов, информации в любом виде без указания источника - форума YTDB будет считаться нарушением авторских прав и нарушением Уголовного Кодекса РФ, ст. 146 ст. 147.
Перевод vBulletin: zCarot
Punk's On-Air - Punk, Folk, Blues, Ska Bascinet - реконструкция denw IL-2 Training Книготорговая Компания «А-5» - художественная, учебная литература, скидки, опт и мелкий опт, доставка, дешево, низкие цены издательства