Добавление классовых квестовых скиллов тренерам для 3.0.X

Сообщение от evilstar

Все спеллы проверены в соответствие с изминениями в патчах после 3.0.Х
Данные запросы предназначены для Фан серверов.

Mage

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