Логин:
Пароль:
 
 
Главная | Форум | Статьи | Фaйлы| Картинки WoW | Профиль | Регистрация | Вход

[ Новые сообщения · Правила форума · Поиск · RSS ]

WoW-Info — информационный World of Warcraft портал

[SQL]Добавление квестовых спеллов в тренеров (2.4.3 и 3.х.х) - Форум

  • Страница 1 из 1
  • 1
Форум » MANGOS » Патчи в базу Mangos » [SQL]Добавление квестовых спеллов в тренеров (2.4.3 и 3.х.х)
[SQL]Добавление квестовых спеллов в тренеров (2.4.3 и 3.х.х)
DarkensandДата: Суббота, 04.12.2010, 04:40 | Сообщение # 1



Darkensand
Главный Админ
Лучший из лучших
Группа: Администратор
Сообщений: 8083



Оффлайн
-- v2.4.3

-- PALADIN

Code
--   Summon Warhorse      
REPLACE INTO `npc_trainer` SELECT `entry`, '13819', '200000', '0', '0', '40'  FROM `creature_template` WHERE `subname`='Paladin Trainer' AND NOT `faction_A`='1604';      
REPLACE INTO `npc_trainer` SELECT `entry`, '13819', '200000', '0', '0', '40'  FROM `creature_template` WHERE `subname`='Paladin Trainer' AND `faction_A`='1604';      
--   Summon Charger      
REPLACE INTO `npc_trainer` SELECT `entry`, '23214', '1000000', '0', '0', '60'  FROM `creature_template` WHERE `subname`='Paladin Trainer' AND NOT `faction_A`='1604';      
REPLACE INTO `npc_trainer` SELECT `entry`, '23214', '1000000', '0', '0', '60'  FROM `creature_template` WHERE `subname`='Paladin Trainer' AND `faction_A`='1604';      
--   Redemption RANK1      
REPLACE INTO `npc_trainer` SELECT `entry`, '7328', '250', '0', '0', '12'  FROM `creature_template` WHERE `subname`='Paladin Trainer';      
--   Sense Undead      
REPLACE INTO `npc_trainer` SELECT `entry`, '5502', '2500', '0', '0', '20'  FROM `creature_template` WHERE `subname`='Paladin Trainer';

-- DRUID

Code
--   Bear Form      
REPLACE INTO `npc_trainer` SELECT `entry`, '5487', '200', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Druid Trainer';      
--   Maul RANK1      
REPLACE INTO `npc_trainer` SELECT `entry`, '6807', '200', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Druid Trainer';      
--   Enrage      
REPLACE INTO `npc_trainer` SELECT `entry`, '5229', '200', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Druid Trainer';      
--   Aquatic Form      
REPLACE INTO `npc_trainer` SELECT `entry`, '1446', '200', '0', '0', '16'  FROM `creature_template` WHERE `subname`='Druid Trainer';      
--   Growl      
REPLACE INTO `npc_trainer` SELECT `entry`, '6795', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Druid Trainer';      
--   Swift Flight Form      
REPLACE INTO `npc_trainer` SELECT `entry`, '40120', '200000', '0', '0', '70' FROM `creature_template` WHERE `subname`='Druid Trainer';

-- WARLOCK

Code
--   Summon Imp      
REPLACE INTO `npc_trainer` SELECT `entry`, '688', '1', '0', '0', '1'  FROM `creature_template` WHERE `subname`='Warlock Trainer';      
--   Summon Voidwalker      
REPLACE INTO `npc_trainer` SELECT `entry`, '697', '200', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Warlock Trainer';      
--   Summon Succubus      
REPLACE INTO `npc_trainer` SELECT `entry`, '712', '3000', '0', '0', '20'  FROM `creature_template` WHERE `subname`='Warlock Trainer';      
--   Summon Felhunter      
REPLACE INTO `npc_trainer` SELECT `entry`, '691', '40000', '0', '0', '30'  FROM `creature_template` WHERE `subname`='Warlock Trainer';      
--   Summon Felsteed      
REPLACE INTO `npc_trainer` SELECT `entry`, '5784', '200000', '0', '0', '40'  FROM `creature_template` WHERE `subname`='Warlock Trainer';      
--   Summon Infernal      
REPLACE INTO `npc_trainer` SELECT `entry`, '1122', '60000', '0', '0', '50'  FROM `creature_template` WHERE `subname`='Warlock Trainer';      
--   Ritual of Doom      
REPLACE INTO `npc_trainer` SELECT `entry`, '18540', '70000', '0', '0', '60'  FROM `creature_template` WHERE `subname`='Warlock Trainer';      
--   Summon Dreadsteed      
REPLACE INTO `npc_trainer` SELECT `entry`, '23161', '1000000', '0', '0', '60'  FROM `creature_template` WHERE `subname`='Warlock Trainer';

-- WARRIOR

Code
--   Defencive Stance      
REPLACE INTO `npc_trainer` SELECT `entry`, '71', '200', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Warrior Trainer';      
--   Berserker Stance      
REPLACE INTO `npc_trainer` SELECT `entry`, '2458', '20000', '0', '0', '40'  FROM `creature_template` WHERE `subname`='Warrior Trainer';      
--   Intercept RANK1      
REPLACE INTO `npc_trainer` SELECT `entry`, '20252', '20000', '0', '0', '40'  FROM `creature_template` WHERE `subname`='Warrior Trainer';      
--   Taunt      
REPLACE INTO `npc_trainer` SELECT `entry`, '355', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Warrior Trainer';      
--   Sunder Armor      
REPLACE INTO `npc_trainer` SELECT `entry`, '7386', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Warrior Trainer';

-- Rogue

Code
--   Poisons      
REPLACE INTO `npc_trainer` SELECT `entry`, '2842', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Rogue Trainer';      
--   Instant Poison      
REPLACE INTO `npc_trainer` SELECT `entry`, '8681', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Rogue Trainer';      

-- Hunter

Code
--   Tame Beast      
REPLACE INTO `npc_trainer` SELECT `entry`, '1515', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Hunter Trainer';      
--   Feed Pet      
REPLACE INTO `npc_trainer` SELECT `entry`, '6991', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Hunter Trainer';      
--   Call Pet      
REPLACE INTO `npc_trainer` SELECT `entry`, '883', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Hunter Trainer';      
--   Dismiss Pet      
REPLACE INTO `npc_trainer` SELECT `entry`, '2641', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Hunter Trainer';      
--   Beast Training      
REPLACE INTO `npc_trainer` SELECT `entry`, '5149', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Hunter Trainer';      
--   Revive Pet      
REPLACE INTO `npc_trainer` SELECT `entry`, '982', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer';

-- Mage

Code
--   Polymorph      
REPLACE INTO `npc_trainer` SELECT `entry`, '28272', '20000', '0', '0', '70'  FROM `creature_template` WHERE `subname`='Mage Trainer';

-- Priest      
Code
--   Devouring Plague      
REPLACE INTO `npc_trainer` SELECT `entry`, '2944', '5000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Priest Trainer';      
--   Fear Ward      
REPLACE INTO `npc_trainer` SELECT `entry`, '6346', '5000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Priest Trainer';

-- Shaman

Code
--   Healing Stream Totem      
REPLACE INTO `npc_trainer` SELECT `entry`, '5394', '20000', '0', '0', '70'  FROM `creature_template` WHERE `subname`='Shaman Trainer';      
--   Searing Totem      
REPLACE INTO `npc_trainer` SELECT `entry`, '3599', '20000', '0', '0', '70'  FROM `creature_template` WHERE `subname`='Shaman Trainer';      
--   Stoneskin Totem      
REPLACE INTO `npc_trainer` SELECT `entry`, '8071', '20000', '0', '0', '70'  FROM `creature_template` WHERE `subname`='Shaman Trainer';

Незабывайте благодарить! Если вам понравилась моя работа. И отписывайтесь в теме пожалуйсто.

-- v3.X.X (Все версии)

- DEATH KNIGHT

Code
--   Acherus Deathcharger    
REPLACE INTO `npc_trainer` SELECT `entry`, '48778', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Death Knight Trainer';    
--   Death Gate    
REPLACE INTO `npc_trainer` SELECT `entry`, '50977', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Death Knight Trainer';    
--   Runeforging    
REPLACE INTO `npc_trainer` SELECT `entry`, '53428', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Death Knight Trainer';

-- PALADIN

Code
--   Summon Warhorse    
REPLACE INTO `npc_trainer` SELECT `entry`, '13819', '200000', '0', '0', '40'  FROM `creature_template` WHERE `subname`='Paladin Trainer' AND NOT `faction_A`='1604';    
REPLACE INTO `npc_trainer` SELECT `entry`, '13819', '200000', '0', '0', '40'  FROM `creature_template` WHERE `subname`='Paladin Trainer' AND `faction_A`='1604';    
--   Summon Charger    
REPLACE INTO `npc_trainer` SELECT `entry`, '23214', '1000000', '0', '0', '60'  FROM `creature_template` WHERE `subname`='Paladin Trainer' AND NOT `faction_A`='1604';    
REPLACE INTO `npc_trainer` SELECT `entry`, '23214', '1000000', '0', '0', '60'  FROM `creature_template` WHERE `subname`='Paladin Trainer' AND `faction_A`='1604';    
--   Redemption RANK1    
REPLACE INTO `npc_trainer` SELECT `entry`, '7328', '250', '0', '0', '12'  FROM `creature_template` WHERE `subname`='Paladin Trainer';    
--   Sense Undead    
REPLACE INTO `npc_trainer` SELECT `entry`, '5502', '2500', '0', '0', '20'  FROM `creature_template` WHERE `subname`='Paladin Trainer';

-- DRUID

Code
--   Bear Form    
REPLACE INTO `npc_trainer` SELECT `entry`, '5487', '200', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Druid Trainer';    
--   Maul RANK1    
REPLACE INTO `npc_trainer` SELECT `entry`, '6807', '200', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Druid Trainer';    
--   Enrage    
REPLACE INTO `npc_trainer` SELECT `entry`, '5229', '200', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Druid Trainer';    
--   Aquatic Form    
REPLACE INTO `npc_trainer` SELECT `entry`, '1446', '200', '0', '0', '16'  FROM `creature_template` WHERE `subname`='Druid Trainer';    
--   Growl    
REPLACE INTO `npc_trainer` SELECT `entry`, '6795', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Druid Trainer';    
--   Swift Flight Form    
REPLACE INTO `npc_trainer` SELECT `entry`, '40120', '200000', '0', '0', '70' FROM `creature_template` WHERE `subname`='Druid Trainer';

-- WARLOCK

--

Code
Summon Imp    
REPLACE INTO `npc_trainer` SELECT `entry`, '688', '1', '0', '0', '1'  FROM `creature_template` WHERE `subname`='Warlock Trainer';    
--   Summon Voidwalker    
REPLACE INTO `npc_trainer` SELECT `entry`, '697', '200', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Warlock Trainer';    
--   Summon Succubus    
REPLACE INTO `npc_trainer` SELECT `entry`, '712', '3000', '0', '0', '20'  FROM `creature_template` WHERE `subname`='Warlock Trainer';    
--   Summon Felhunter    
REPLACE INTO `npc_trainer` SELECT `entry`, '691', '40000', '0', '0', '30'  FROM `creature_template` WHERE `subname`='Warlock Trainer';    
--   Summon Felsteed    
REPLACE INTO `npc_trainer` SELECT `entry`, '5784', '200000', '0', '0', '40'  FROM `creature_template` WHERE `subname`='Warlock Trainer';    
--   Summon Infernal    
REPLACE INTO `npc_trainer` SELECT `entry`, '1122', '60000', '0', '0', '50'  FROM `creature_template` WHERE `subname`='Warlock Trainer';    
--   Ritual of Doom    
REPLACE INTO `npc_trainer` SELECT `entry`, '18540', '70000', '0', '0', '60'  FROM `creature_template` WHERE `subname`='Warlock Trainer';    
--   Summon Dreadsteed    
REPLACE INTO `npc_trainer` SELECT `entry`, '23161', '1000000', '0', '0', '60'  FROM `creature_template` WHERE `subname`='Warlock Trainer';

-- WARRIOR

Code
--   Defencive Stance    
REPLACE INTO `npc_trainer` SELECT `entry`, '71', '200', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Warrior Trainer';    
--   Berserker Stance    
REPLACE INTO `npc_trainer` SELECT `entry`, '2458', '20000', '0', '0', '40'  FROM `creature_template` WHERE `subname`='Warrior Trainer';    
--   Intercept RANK1    
REPLACE INTO `npc_trainer` SELECT `entry`, '20252', '20000', '0', '0', '40'  FROM `creature_template` WHERE `subname`='Warrior Trainer';    
--   Taunt    
REPLACE INTO `npc_trainer` SELECT `entry`, '355', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Warrior Trainer';    
--   Sunder Armor    
REPLACE INTO `npc_trainer` SELECT `entry`, '7386', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Warrior Trainer';

-- Rogue

Code
--   Poisons    
REPLACE INTO `npc_trainer` SELECT `entry`, '2842', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Rogue Trainer';    
--   Instant Poison    
REPLACE INTO `npc_trainer` SELECT `entry`, '8681', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Rogue Trainer';

-- Hunter

-

Code
-   Tame Beast    
REPLACE INTO `npc_trainer` SELECT `entry`, '1515', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Hunter Trainer';    
--   Feed Pet    
REPLACE INTO `npc_trainer` SELECT `entry`, '6991', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Hunter Trainer';    
--   Call Pet    
REPLACE INTO `npc_trainer` SELECT `entry`, '883', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Hunter Trainer';    
--   Dismiss Pet    
REPLACE INTO `npc_trainer` SELECT `entry`, '2641', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Hunter Trainer';    
--   Beast Training    
REPLACE INTO `npc_trainer` SELECT `entry`, '5149', '20000', '0', '0', '10'  FROM `creature_template` WHERE `subname`='Hunter Trainer';    
--   Revive Pet    
REPLACE INTO `npc_trainer` SELECT `entry`, '982', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer';

-- Mage

Code
--   Polymorph    
REPLACE INTO `npc_trainer` SELECT `entry`, '28272', '20000', '0', '0', '70'  FROM `creature_template` WHERE `subname`='Mage Trainer';

-- Priest

Code
--   Devouring Plague    
REPLACE INTO `npc_trainer` SELECT `entry`, '2944', '5000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Priest Trainer';    
--   Fear Ward    
REPLACE INTO `npc_trainer` SELECT `entry`, '6346', '5000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Priest Trainer';

-- Shaman

Code
--   Healing Stream Totem    
REPLACE INTO `npc_trainer` SELECT `entry`, '5394', '20000', '0', '0', '70'  FROM `creature_template` WHERE `subname`='Shaman Trainer';    
--   Searing Totem    
REPLACE INTO `npc_trainer` SELECT `entry`, '3599', '20000', '0', '0', '70'  FROM `creature_template` WHERE `subname`='Shaman Trainer';    
--   Stoneskin Totem    
REPLACE INTO `npc_trainer` SELECT `entry`, '8071', '20000', '0', '0', '70'  FROM `creature_template` WHERE `subname`='Shaman Trainer';
 
Форум » MANGOS » Патчи в базу Mangos » [SQL]Добавление квестовых спеллов в тренеров (2.4.3 и 3.х.х)
  • Страница 1 из 1
  • 1
Поиск:

Новые сообщения в темах
[Гайд] - Ездовые животные · (Гайды по WoW)
Автор: Darkensand
Последнее сообщение в 12:59
Тактика: Безумие Смертокрыла (... · (Тактики WoW)
Автор: Darkensand
Последнее сообщение в 21:16
Обновление 581 , 580(FULL) · (Базы TrinityCore)
Автор: Ganstar
Последнее сообщение в 21:42
Cataclysm: Новые способности Ч... · (Чернокнижник)
Автор: Darkensand
Последнее сообщение в 15:22
▃ ▅ █ STRIKE-DEATH | WOTL... · (Обычные сервера WoW)
Автор: Pensukdeath
Последнее сообщение в 05:18
[Осбуждение] - Друиды · (Классы)
Автор: Grimus
Последнее сообщение в 17:43
ARQ - Бот для слива арены · (Боты для WoW)
Автор: Darkensand
Последнее сообщение в 17:42
AlphaMap · (Проверенные аддоны для WoW)
Автор: ADRE[N]ALINE
Последнее сообщение в 17:42
Новая группа v2.0 · (Работа портала)
Автор: Grimus
Последнее сообщение в 17:41
ACID Полный · (Базы Mangos)
Автор: ADRE[N]ALINE
Последнее сообщение в 17:40
Juked · (Проверенные аддоны для WoW)
Автор: Darkensand
Последнее сообщение в 17:39
Готовый сервер 1.12.1 · (Корзина)
Автор: aspect165
Последнее сообщение в 17:39
Набор в команду WoW-Info.net! · (Работа портала)
Автор: Darkensand
Последнее сообщение в 17:38
Очень хороший зароботок!!! · (Флудилка)
Автор: Hordcore
Последнее сообщение в 17:38
Гайд по Охотнику [Повелитель З... · (Охотник)
Автор: UncontesteD
Последнее сообщение в 17:37

Контакты Контакты Copyright WoW-Info — World of Warcraft портал © 2018 | Условия и правила использования ресурса | Реклама / Услуги
WoW-Info портал.World of Warcraft портал — готовые сервера, сайты, картинки, аддоны, патчи, читы, баги, mangos, ArcEmu, TrinityCore, Warcraft 3, новости, Cataclysm...
Яндекс.Метрика Создать бесплатный сайт с uCoz