http://wowsoft.ru/shapkawowsoft.jpg
[ Новые сообщения · Участники · Правила форума · Поиск · RSS ]
Страница 1 из 11
Модератор форума: Mannoroh 
Форум » MANGOS » Патчи в базу Mangos » [SQL]Добавление квестовых спеллов в тренеров (3.Х.Х)
[SQL]Добавление квестовых спеллов в тренеров (3.Х.Х)
JeRaiNДата: Пятница, 14.05.2010, 18:59 | Сообщение # 1
Сержант
Группа: Пользователи
Сообщений: 44
Статус: :-)
-- 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';

Незабывайте благодарить! Если вам понравилась моя работа. И отписывайтесь в теме пожалуйсто.
Прикрепления: 3.X.X.sql(6Kb)


Быстрый Зыработок Тык

Сообщение отредактировал DimxO403 - Пятница, 14.05.2010, 18:59
 
Форум » MANGOS » Патчи в базу Mangos » [SQL]Добавление квестовых спеллов в тренеров (3.Х.Х)
Страница 1 из 11
Поиск:



Copyright WoWsoft © 2010 | Карта сайта | Карта форума Хостинг от uCoz
При использовании материалов необходимо наличие прямой индексируемой ссылки на первоисточник
WoWsoft — World of Warcraft портал — Статьи World of Warcraft | Аддоны для WoW | Патчи World of Warcraft | Cервера WoW | Новости WoW