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

-- v2.4.3

-- PALADIN

Код:

--   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

Код:

--   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

Код:

--   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

Код:

--   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

Код:

--   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

Код:

--   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

Код:

--   Polymorph

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

-- Priest

Код:

--   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

Код:

--   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';

Quest Spell by Pro[100]Hens

*ссылки на вовжп убраны, так как содержат рекламу открытого сервера, автор ушел по этой же причине, аттач перезалит*

-- v3.Х.Х

-- DEATH KNIGHT

Код:

--   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

Код:

--   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

Код:

--   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

Код:

--   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

Код:

--   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

Код:

--   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

Код:

--   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

Код:

--   Polymorph

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

-- Priest

Код:

--   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

Код:

--   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';

Quest Spell by Pro[100]Hens