[SQL]Адд спеллов, на которых требуется квест у тренеров - Форум All-infoWoW
 
Главная Статьи Файлы Фото Мувимейкинг Гайды Видео Патчи


  • Страница 1 из 1
  • 1
Модератор форума: JohnCrasher, xxnextxx  
Форум All-infoWoW » ManGos » Патчи для ManGos » [SQL]Адд спеллов, на которых требуется квест у тренеров
[SQL]Адд спеллов, на которых требуется квест у тренеров
RoguemasterДата: Четверг, 27.05.2010, 16:03 | Сообщение # 1


Группа: Модератор высокой группы
Сообщений: 989
Награды: 2
Репутация: 5
Статус:
[SQL]Адд спеллов, на которых требуется квест у тренеров
только ДЛЯ 3.х.х и 2.4.3!
-- v2.4.3
Quest Spell by Pro[100]Hens
Скачать:
для WoW 3.x.x - http://all-infowow.ru/_fr/21/3.X.X-1-.sql
для WoW 2.4.3 - http://all-infowow.ru/_fr/21/2.4.3-1-.sql
-- 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';
Прикрепления: 3.X.X-1-.sql (6.6 Kb) · 2.4.3-1-.sql (6.1 Kb)


Сообщение отредактировал Roguemaster - Четверг, 27.05.2010, 16:04
 
ArtitrakeДата: Суббота, 14.04.2012, 11:25 | Сообщение # 2


Группа: Гости





Приветики дай Вам Бог крепкого Здоровья
 
icoreHoritupeДата: Суббота, 05.05.2012, 02:15 | Сообщение # 3


Группа: Гости





Всем привет! Хотел похвалить Ваш сайт. Мне здесь очень понравилось.
 
Форум All-infoWoW » ManGos » Патчи для ManGos » [SQL]Адд спеллов, на которых требуется квест у тренеров
  • Страница 1 из 1
  • 1
Поиск:
Статистика
Rambler's Top100
 
07.07.2012 » Расплывчатые углы в Sony Vegas

05.07.2012 » Как замедлить и ускорить видео в Sony Vegas

04.07.2012 » Проблемы при фрапсинге

 
24.10.2010 » Маг Noone и нынешнее PvP
30.09.2011 » 5 причин полюбить Катаклизм
02.09.2011 » Неопределенность направлений оборвавшихся сюжетных тропинок
 
Соц сети

Сайт управляется системой uCoz | Copyright All-infoWoW.ru © 2009-2018 | Designs by Jekins Designs
All-infoWoW.ru - World of Warcraft портал - аддоны, статьи, патчи, новости, Warlords of Draenor...