Логин:
Пароль:
 
 
Главная | Форум | Статьи | Ф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
Поиск:

Новые сообщения в темах
Разбойник специализации Ликвид... · (Разбойник)
Автор: Darkensand
Последнее сообщение в 01:36
Группа Best of the Best user W... · (Работа портала)
Автор: Darkensand
Последнее сообщение в 21:52
Гайд по Жрецам Тьмы в обновлен... · (Жрец)
Автор: Darkensand
Последнее сообщение в 03:33
▃ ▅ █ STRIKE-DEATH | WOTL... · (Обычные сервера WoW)
Автор: Pensukdeath
Последнее сообщение в 16:32
MPQ editor.Создание своих патч... · (Утилиты для ArcEmu)
Автор: Darkensand
Последнее сообщение в 20:59
[FAQ]вопрос ответ · ([TrinityCore] Help)
Автор: MaeStroVIP
Последнее сообщение в 18:44
Быстрый Старт WoW · (Общие вопросы по игре)
Автор: Armagidon
Последнее сообщение в 05:25
CCReport · (Проверенные аддоны для WoW)
Автор: Darkensand
Последнее сообщение в 14:05
[Гайд] По ArkInventory или нав... · (Помощь с аддонами для WoW)
Автор: Darkensand
Последнее сообщение в 12:28
Маги Льда в Туманах Пандарии, ... · (Маг)
Автор: Darkensand
Последнее сообщение в 00:06
WoW: Патч 4.3: Разъяснение изм... · (Новости)
Автор: booyoods
Последнее сообщение в 00:02
Hellscream.ORG - Азиатский WoW... · (Обычные сервера WoW)
Автор: Alexstrasza007
Последнее сообщение в 10:30
Совет при изучении C++ · (С++)
Автор: Online
Последнее сообщение в 08:15
Хороший изменённый мини-чат · (Ucoz зона)
Автор: Maylo
Последнее сообщение в 15:25
PortraitTimers(# Cataclysm #) · (Пользовательские аддоны для WoW)
Автор: Darkensand
Последнее сообщение в 11:00

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