 |
07.04.2010, 01:17
|
#1
|
|
|
|
|
|
 Старший сержант |
 Регистрация: 02.03.2010
 Сообщений: 244
 Популярность: 876
 Сказал(а) спасибо: 44
Поблагодарили 131 раз(а) в 81 сообщениях
|
[SQL]Добавление квестовых спеллов в тренеров 2.4.3 и 3.Х.Х
2.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';
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';
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';
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';
Mage
Код:
-- Polymorph
REPLACE INTO `npc_trainer` SELECT `entry`, '28272', '20000', '0', '0', '70' FROM `creature_template` WHERE `subname`='Mage 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';
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';
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';
Quest Spell by Pro[100]Hens
Добавлено через 9 минут
3.X.X (Все версии)
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 [Boombarash]
Последний раз редактировалось Винсент; 07.04.2010 в 01:27.
Причина: Добавлено сообщение
|
|
|
|
|
Пользователь сказал cпасибо:
|
|
Ваши права в разделе
|
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения
HTML код Выкл.
|
|
|
Заявление об ответственности / Список мошенников
Часовой пояс GMT +4, время: 01:39.
|
|
