Модератор форума: staford11 |
Форум » CMaNGOS » Патчи / Моды / Фиксы CMaNGOS » [SQL]Добавление квестовых спеллов в тренеров (3.Х.Х и 2.4.3) (Quest Spell by Pro[100]Hens) |
[SQL]Добавление квестовых спеллов в тренеров (3.Х.Х и 2.4.3) |
-- 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';
Quest Spell by Pro[100]Hens
Незабывайте благодарить! Если вам понравилась моя работа. И отписывайтесь в теме пожалуйсто.
Прикрепления:
2.4.3.sql
(6.1 Kb)
Совершенно безопасен для людей, обладающих хотя бы некоторыми минимальными зачатками интеллекта, и способными строить причинно-следственные цепочки. ©
|
-- 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'; Quest Spell by [Boombarash]
Незабывайте благодарить! Если вам понравилась моя работа. И отписывайтесь в теме пожалуйсто.
Прикрепления:
3.X.X.sql
(6.6 Kb)
Совершенно безопасен для людей, обладающих хотя бы некоторыми минимальными зачатками интеллекта, и способными строить причинно-следственные цепочки. ©
|
Сделал для 3.Х.Х
Думаю вам понравилась моя работа, и надеюсь тему закрепят, так-как многим это может пригодиться!
Совершенно безопасен для людей, обладающих хотя бы некоторыми минимальными зачатками интеллекта, и способными строить причинно-следственные цепочки. ©
Сообщение # 6 написано 10.12.2009 в 21:18
|
gud, спасибо, приятно.
с щитом и мечом обращайся к Zver535 он сделает классно)
Совершенно безопасен для людей, обладающих хотя бы некоторыми минимальными зачатками интеллекта, и способными строить причинно-следственные цепочки. ©
Сообщение # 14 написано 11.12.2009 в 00:34
|
KingDark, нечо) спс всеравно, меня просто бесит то что люди просматривают тему, а ответов в ней меньше...
и нечего неотписываются тупо плагят, а потом выдают за свою работу...
Совершенно безопасен для людей, обладающих хотя бы некоторыми минимальными зачатками интеллекта, и способными строить причинно-следственные цепочки. ©
Сообщение # 16 написано 12.12.2009 в 00:32
|
Natisk, спасибо! приятно)
Ребят, столько просмотров а ответов почти и нету... Вы комментируйте, мб есть недочоты какието!
Совершенно безопасен для людей, обладающих хотя бы некоторыми минимальными зачатками интеллекта, и способными строить причинно-следственные цепочки. ©
Сообщение # 18 написано 19.12.2009 в 19:07
|
Незабываем отписываться в теме после её просмотра!
Совершенно безопасен для людей, обладающих хотя бы некоторыми минимальными зачатками интеллекта, и способными строить причинно-следственные цепочки. ©
|
| |||