Warlord123
28.10.2011, 13:44
В продолжение [610] Npc trainer problem (http://ytdb.ru/showthread.php?t=11405).
Пока выверял только для классовых тренеров.
-- delete old warrior spells
DELETE FROM npc_trainer WHERE spell IN (1671, 1672, 6554, 7372, 7373, 7400, 7402, 7887, 11584, 11585, 20559, 20560, 20616, 20617, 23892, 23893, 23894, 25212, 25251, 25266, 25272, 25275, 29704, 30335);
-- 17844 Vindicator Aesom need some spells.
INSERT IGNORE INTO npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(17844, 3127, 100, 0, 0, 8), -- Parry (Passive)
(17844, 13820, 10000, 0, 0, 20), -- Warhorse (Summon)
(17844, 20217, 3600, 0, 0, 20), -- Blessing of Kings
(17844, 23214, 200000, 762, 150, 40), -- Charger (Summon)
(17844, 62124, 3000, 0, 0, 16); -- Hand of Reckoning
-- (10930)Dargh Trueaim, (4138)Jeen'ra Nightrunner, (8308)Alenndaar Lapidaar, (17122)Vord need 62757 - Call Stabled Pet
INSERT IGNORE INTO npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(10930,62757,300000,0,0,80),
(4138,62757,300000,0,0,80),
(8308,62757,300000,0,0,80),
(17122,62757,300000,0,0,80);
-- (31084)Highlord Darion Mograine need some spells.
INSERT IGNORE INTO npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(31084,61999,360000,0,0,72),-- 61999-Raise Ally
(31084,62158,360000,0,0,40),-- 62158-Rune of the Stoneskin Gargoyle
(31084,42650,360000,0,0,80);-- 42650-Army of the Dead
-- High Priest Rohan is Priest trainer;
UPDATE creature_template
SET trainer_class = 5
WHERE entry = 11406;
-- delete Priest spell 528-Cure Disease from shamans trainers
DELETE FROM npc_trainer
WHERE spell = 528 AND entry IN (SELECT entry FROM creature_template WHERE trainer_class = 7);
-- delete 42955-Conjure Refreshment Spell Level = 75 from beginners mage trainers 198-Khelden Bremen, 2124-Isabella, 15279-Julia Sunstriker
DELETE FROM npc_trainer
WHERE spell = 42955 AND entry IN (198,2124,15279);
-- delete from Warlock trainer 6251-Strahad Farsan spells DK Death Coil (Rank 1-5) and Priest Shadow Protection (Rank 5)
DELETE FROM npc_trainer WHERE entry = 6251 AND spell IN (47541, 48169, 49892, 49893, 49894, 49895);
-- Delete 1066 Aquatic Form (Shapeshift) from beginners druid trainer 3060 Gart Mistrunner
DELETE FROM npc_trainer WHERE entry = 3060 and spell=1066;
-- delete SPELLFAMILY_HUNTER spell 19883-Track Humanoids from 3036 Kym Wildmane
DELETE FROM npc_trainer WHERE entry = 3036 and spell=19883;
Пока выверял только для классовых тренеров.
-- delete old warrior spells
DELETE FROM npc_trainer WHERE spell IN (1671, 1672, 6554, 7372, 7373, 7400, 7402, 7887, 11584, 11585, 20559, 20560, 20616, 20617, 23892, 23893, 23894, 25212, 25251, 25266, 25272, 25275, 29704, 30335);
-- 17844 Vindicator Aesom need some spells.
INSERT IGNORE INTO npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(17844, 3127, 100, 0, 0, 8), -- Parry (Passive)
(17844, 13820, 10000, 0, 0, 20), -- Warhorse (Summon)
(17844, 20217, 3600, 0, 0, 20), -- Blessing of Kings
(17844, 23214, 200000, 762, 150, 40), -- Charger (Summon)
(17844, 62124, 3000, 0, 0, 16); -- Hand of Reckoning
-- (10930)Dargh Trueaim, (4138)Jeen'ra Nightrunner, (8308)Alenndaar Lapidaar, (17122)Vord need 62757 - Call Stabled Pet
INSERT IGNORE INTO npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(10930,62757,300000,0,0,80),
(4138,62757,300000,0,0,80),
(8308,62757,300000,0,0,80),
(17122,62757,300000,0,0,80);
-- (31084)Highlord Darion Mograine need some spells.
INSERT IGNORE INTO npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(31084,61999,360000,0,0,72),-- 61999-Raise Ally
(31084,62158,360000,0,0,40),-- 62158-Rune of the Stoneskin Gargoyle
(31084,42650,360000,0,0,80);-- 42650-Army of the Dead
-- High Priest Rohan is Priest trainer;
UPDATE creature_template
SET trainer_class = 5
WHERE entry = 11406;
-- delete Priest spell 528-Cure Disease from shamans trainers
DELETE FROM npc_trainer
WHERE spell = 528 AND entry IN (SELECT entry FROM creature_template WHERE trainer_class = 7);
-- delete 42955-Conjure Refreshment Spell Level = 75 from beginners mage trainers 198-Khelden Bremen, 2124-Isabella, 15279-Julia Sunstriker
DELETE FROM npc_trainer
WHERE spell = 42955 AND entry IN (198,2124,15279);
-- delete from Warlock trainer 6251-Strahad Farsan spells DK Death Coil (Rank 1-5) and Priest Shadow Protection (Rank 5)
DELETE FROM npc_trainer WHERE entry = 6251 AND spell IN (47541, 48169, 49892, 49893, 49894, 49895);
-- Delete 1066 Aquatic Form (Shapeshift) from beginners druid trainer 3060 Gart Mistrunner
DELETE FROM npc_trainer WHERE entry = 3060 and spell=1066;
-- delete SPELLFAMILY_HUNTER spell 19883-Track Humanoids from 3036 Kym Wildmane
DELETE FROM npc_trainer WHERE entry = 3036 and spell=19883;