|
Патчи и наработки Патчи и работы по части БД |
|
Опции темы | Поиск в этой теме | Опции просмотра |
|
07.03.2010, 15:57 | #1 | |
Гость
Сообщений: n/a
|
Добавление классовых квестовых скиллов тренерам для 3.0.X
Цитата:
Код:
DELETE FROM npc_trainer WHERE (`spell`=28272); INSERT INTO `npc_trainer` SELECT `entry`, '28272', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Mage Trainer'; -- Polymorph Pig Warrior Код:
DELETE FROM npc_trainer WHERE (`spell`=20252); DELETE FROM npc_trainer WHERE (`spell`=71); DELETE FROM npc_trainer WHERE (`spell`=2458); DELETE FROM npc_trainer WHERE (`spell`=7386); DELETE FROM npc_trainer WHERE (`spell`=355); INSERT INTO `npc_trainer` SELECT `entry`, '20252', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Warrior Trainer'; -- Intercept INSERT INTO `npc_trainer` SELECT `entry`, '71', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Warrior Trainer'; -- Defensive Stance INSERT INTO `npc_trainer` SELECT `entry`, '2458', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Warrior Trainer'; -- Berserker Stance INSERT INTO `npc_trainer` SELECT `entry`, '7386', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Warrior Trainer'; -- Sunder Armor INSERT INTO `npc_trainer` SELECT `entry`, '355', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Warrior Trainer'; -- Taunt Druid Код:
DELETE FROM npc_trainer WHERE (`spell`=5487); DELETE FROM npc_trainer WHERE (`spell`=1066); DELETE FROM npc_trainer WHERE (`spell`=40120); DELETE FROM npc_trainer WHERE (`spell`=6807); DELETE FROM npc_trainer WHERE (`spell`=6795); INSERT INTO `npc_trainer` SELECT `entry`, '5487', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Druid Trainer'; -- Bear Form INSERT INTO `npc_trainer` SELECT `entry`, '6807', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Druid Trainer'; -- Maul INSERT INTO `npc_trainer` SELECT `entry`, '6795', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Druid Trainer'; -- Growl INSERT INTO `npc_trainer` SELECT `entry`, '1066', '1600', '0', '0', '16' FROM `creature_template` WHERE `subname`='Druid Trainer'; -- Aquatic Form INSERT INTO `npc_trainer` SELECT `entry`, '40120', '200000', '0', '0', '70' FROM `creature_template` WHERE `subname`='Druid Trainer'; -- Swift Flight Form Paladin Код:
DELETE FROM npc_trainer WHERE (`spell`=7328); DELETE FROM npc_trainer WHERE (`spell`=5502); INSERT INTO `npc_trainer` SELECT `entry`, '7328', '1200', '0', '0', '12' FROM `creature_template` WHERE `subname`='Paladin Trainer'; -- Redemption INSERT INTO `npc_trainer` SELECT `entry`, '5502', '1200', '0', '0', '12' FROM `creature_template` WHERE `subname`='Paladin Trainer'; -- Sense Undead Hunter Код:
DELETE FROM npc_trainer WHERE (`spell`=883); DELETE FROM npc_trainer WHERE (`spell`=6991); DELETE FROM npc_trainer WHERE (`spell`=2641); DELETE FROM npc_trainer WHERE (`spell`=982); DELETE FROM npc_trainer WHERE (`spell`=1515); INSERT INTO `npc_trainer` SELECT `entry`, '883', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer'; -- Call Pet INSERT INTO `npc_trainer` SELECT `entry`, '6991', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer'; -- Feed Pet INSERT INTO `npc_trainer` SELECT `entry`, '2641', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer'; -- Dismiss Pet INSERT INTO `npc_trainer` SELECT `entry`, '982', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer'; -- Revive Pet INSERT INTO `npc_trainer` SELECT `entry`, '1515', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer'; -- Tame Beast Warlock Код:
DELETE FROM npc_trainer WHERE (`spell`=688); DELETE FROM npc_trainer WHERE (`spell`=697); DELETE FROM npc_trainer WHERE (`spell`=712); DELETE FROM npc_trainer WHERE (`spell`=691); DELETE FROM npc_trainer WHERE (`spell`=1122); DELETE FROM npc_trainer WHERE (`spell`=18540); DELETE FROM npc_trainer WHERE (`spell`=54785); DELETE FROM npc_trainer WHERE (`spell`=59671); DELETE FROM npc_trainer WHERE (`spell`=50589); INSERT INTO `npc_trainer` SELECT `entry`, '688', '100', '0', '0', '4' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Summon Imp INSERT INTO `npc_trainer` SELECT `entry`, '697', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Summon Voidwalker INSERT INTO `npc_trainer` SELECT `entry`, '712', '2000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Summon Succubus INSERT INTO `npc_trainer` SELECT `entry`, '691', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Summon Felhunter INSERT INTO `npc_trainer` SELECT `entry`, '1122', '5000', '0', '0', '50' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Summon Inferno INSERT INTO `npc_trainer` SELECT `entry`, '18540', '5000', '0', '0', '50' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Ritual of Doom INSERT INTO `npc_trainer` SELECT `entry`, '54785', '5000', '0', '0', '50' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Demon Charge INSERT INTO `npc_trainer` SELECT `entry`, '59671', '5000', '0', '0', '50' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Challenging Howl INSERT INTO `npc_trainer` SELECT `entry`, '50589', '5000', '0', '0', '50' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Immolation Aura Shaman Код:
DELETE FROM npc_trainer WHERE (`spell`=8071); DELETE FROM npc_trainer WHERE (`spell`=3599); DELETE FROM npc_trainer WHERE (`spell`=5394); INSERT INTO `npc_trainer` SELECT `entry`, '8071', '100', '0', '0', '4' FROM `creature_template` WHERE `subname`='Shaman Trainer'; -- Stoneskin Totem INSERT INTO `npc_trainer` SELECT `entry`, '3599', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Shaman Trainer'; -- Searing Totem INSERT INTO `npc_trainer` SELECT `entry`, '5394', '2000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Shaman Trainer'; -- Healing Stream Totem Priest Код:
DELETE FROM npc_trainer WHERE (`spell`=2944); DELETE FROM npc_trainer WHERE (`spell`=6346); INSERT INTO `npc_trainer` SELECT `entry`, '2944', '5000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Priest Trainer'; -- Devouring Plague INSERT INTO `npc_trainer` SELECT `entry`, '6346', '5000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Priest Trainer'; -- Fear Ward Death Knight Код:
DELETE FROM npc_trainer WHERE (`spell`=48778); DELETE FROM npc_trainer WHERE (`spell`=50977); DELETE FROM npc_trainer WHERE (`spell`=53428); INSERT INTO `npc_trainer` SELECT `entry`, '48778', '100', '0', '0', '4' FROM `creature_template` WHERE entry in (28474, 29194, 31084, 28471, 29195, 28472, 29196) ; -- Acherus Deathcharger INSERT INTO `npc_trainer` SELECT `entry`, '50977', '1000', '0', '0', '10' FROM `creature_template` WHERE entry in (28474, 29194, 31084, 28471, 29195, 28472, 29196); -- Death Gate INSERT INTO `npc_trainer` SELECT `entry`, '53428', '2000', '0', '0', '20' FROM `creature_template` WHERE entry in (28474, 29194, 31084, 28471, 29195, 28472, 29196); -- Runeforging Чтоб не мучиться с тотемами вот вам запросик, чтоб тотемы появлялись сразу в сумке у чаров: Код:
REPLACE INTO playercreateinfo_item (`race`, `class`, `itemid`, `amount`) VALUES (11, 7, 5178, 1), (11, 7, 5175, 1), (11, 7, 5176, 1), (11, 7, 5177, 1), (2, 7, 5175, 1), (2, 7, 5176, 1), (2, 7, 5177, 1), (2, 7, 5178, 1), (6, 7, 5175, 1), (6, 7, 5176, 1), (6, 7, 5177, 1), (6, 7, 5178, 1), (8, 7, 5175, 1), (8, 7, 5176, 1), (8, 7, 5177, 1), (8, 7, 5178, 1); |
|
|
|
Похожие темы | ||||
Тема | Автор | Раздел | Ответов | Последнее сообщение |
[patch]Скалирующиеся Маунты (Добавление) | evilstar | Отвергнутые патчи | 3 | 11.05.2010 23:42 |
[патч] Добавление условий в areatrigger_teleport(доступ по квестам) | NeatElves | Патчи на рассмотрении | 1 | 17.04.2010 13:18 |
Баги классовых магий и талантов | Limpnau | Баг-репорты | 13 | 14.04.2010 15:37 |
[9677] Добавление Показателя блокирования | Antimozg | Принятые патчи | 1 | 06.04.2010 01:16 |
[SQL]Добавление квестовых спеллов в тренеров (3.Х.Х и 2.4.3) | Pro[100]Hens | Патчи и наработки | 3 | 11.03.2010 10:42 |