xstream
07.03.2010, 15:57
Все спеллы проверены в соответствие с изминениями в патчах после 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);
Данные запросы предназначены для Фан серверов.
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);