[SQL] Add questspells to trainers

Like the description says. It lets you add the spells warrior gains from doing quest to the warrior trainers so players don’t need to do the quest.

Added spells to trainers:

Defensive stance

Berserker stance

Taunt

Sunder armor

Tell me if u like it and I’ll add the rest of all missing trainer spells /emoticons/default_smile.png

Copy the spoiler:

– sql adds defensive stance,berserker stance, taunt, sunder armor to all warrior trainers. –

INSERT INTO npc_trainer VALUES (‘913’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘914’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘985’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘1229’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘1901’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘2131’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘3041’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘3042’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘3043’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘3063’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘3169’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘3353’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘3354’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘3408’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘3598’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘4087’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘4089’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘4593’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘4594’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘4595’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘5113’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘5114’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘5479’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘5480’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘7315’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘8141’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘16771’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘17120’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘17480’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘26332’, ‘355’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘913’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘914’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘985’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘1229’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘1901’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘2131’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3041’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3042’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3043’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3063’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3169’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3353’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3354’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3408’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3598’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4087’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4089’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4593’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4594’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4595’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5113’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5114’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5479’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5480’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘7315’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘8141’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘16771’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘17100’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘17480’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘26332’, ‘71’, ‘680’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘913’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘914’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘985’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘1229’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘1901’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘2131’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3041’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3042’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3043’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3063’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3169’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3353’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3354’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3408’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3598’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4087’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4089’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4593’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4594’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4595’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5113’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5114’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5479’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5480’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘7315’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘8141’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘16771’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘17100’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘17480’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘26332’, ‘7386’, ‘2785’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘913’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘914’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘985’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘1229’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘1901’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘2131’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3041’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3042’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3043’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3063’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3169’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3353’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3354’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3408’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3598’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘4087’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘4089’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘4593’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘4594’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘4595’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘5113’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘5114’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘5479’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘5480’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘7315’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘8141’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘16771’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘17100’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘17480’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘26332’, ‘2458’, ‘8500’, ‘0’, ‘0’, ‘30’);

Or download the SQL file here:

http://filebeam.com/886a51e5629afb944726296a0d24bee3

Updated! Missing spells on one trainer.

Fixed 2011-03-20 22:35

Here are some new questspells added to all warlock trainers. (Not those trainers at all startpoints! it’s blizzlike)

[SPOILER]-- sql adds summon Voidwalker, summon succubus, summon felhunter, dreadstead, ritual of doom to all warlock trainers.Made by nis2cool–

INSERT INTO npc_trainer VALUES (‘460’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘461’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘906’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘988’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘2127’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3172’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3324’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3325’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3326’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4563’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4564’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4565’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5171’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5172’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5173’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5495’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5496’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5612’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘16266’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘16646’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘16647’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘16648’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘23534’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘26331’, ‘697’, ‘390’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘460’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘461’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘906’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘988’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘2127’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘3172’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘3324’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘3325’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘3326’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘4563’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘4564’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘4565’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘5171’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘5172’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘5173’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘5495’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘5496’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘5612’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘16266’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘16646’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘16647’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘16648’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘23534’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘26331’, ‘712’, ‘680’, ‘0’, ‘0’, ‘20’);

INSERT INTO npc_trainer VALUES (‘460’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘461’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘906’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘988’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘2127’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘3172’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘3324’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘3325’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘3326’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘4563’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘4564’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘4565’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘5171’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘5172’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘5173’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘5495’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘5496’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘5612’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘16266’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘16646’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘16647’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘16648’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘23534’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘26331’, ‘23161’, ‘55000’, ‘0’, ‘0’, ‘40’);

INSERT INTO npc_trainer VALUES (‘460’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘461’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘906’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘988’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘2127’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3172’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3324’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3325’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘3326’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘4563’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘4564’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘4565’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘5171’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘5172’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘5173’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘5495’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘5496’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘5612’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘16266’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘16646’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘16647’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘16648’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘23534’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘26331’, ‘691’, ‘7500’, ‘0’, ‘0’, ‘30’);

INSERT INTO npc_trainer VALUES (‘460’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘461’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘906’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘988’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘2127’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘3172’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘3324’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘3325’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘3326’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘4563’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘4564’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘4565’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘5171’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘5172’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘5173’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘5495’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘5496’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘5612’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘16266’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘16646’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘16647’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘16648’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘23534’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

INSERT INTO npc_trainer VALUES (‘26331’, ‘18540’, ‘27000’, ‘0’, ‘0’, ‘58’);

[/SPOILER]

Copy the spoiler or download this file here

http://filebeam.com/fba500ad6c657a968f8c10d1f099db09

I’ll add rest of all questspells as soon as possible.

Paladins Redemption rank1 is missing on every paladin trainer. Add this sql to make it trainable from them.

Either copy the spoiler or download the file.

– sql adds Redemption rank1 to all Paladin trainers.Made by nis2cool–

INSERT INTO npc_trainer VALUES (‘927’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘928’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘1232’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘5147’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘5148’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘5149’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘5491’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘5492’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘8140’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘16275’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘16679’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘16680’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘16681’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘16761’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘17121’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘17483’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘17509’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘20406’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘23128’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘26327’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

INSERT INTO npc_trainer VALUES (‘35281’, ‘7328’, ‘1076’, ‘0’, ‘0’, ‘12’);

http://filebeam.com/cdcff89a7a9fa79ccf7b49cf91049923

More spells are coming. Please comment if you like this /emoticons/default_smile.png

Added all the quest spells druid retrive from Quest.

Teleport moonglade

Growl

maul rank1

flight form.

copy spoiler or download file.

Please comment /emoticons/default_smile.png

– sql adds Growl, Maul rank1, Teleport Moonglade, Flight Form to all Druid trainers.Made by nis2cool–

INSERT INTO npc_trainer VALUES (‘3033’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3034’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3036’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3064’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3602’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4218’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4219’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5504’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5505’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5506’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘8142’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘9465’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘12042’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘16655’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘16721’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘26324’, ‘6795’, ‘1726’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3033’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3034’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3036’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3064’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3602’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4218’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘4219’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5504’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5505’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘5506’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘8142’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘9465’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘12042’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘16655’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘16721’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘26324’, ‘6807’, ‘1728’, ‘0’, ‘0’, ‘10’);

INSERT INTO npc_trainer VALUES (‘3033’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘3034’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘3036’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘3064’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘3602’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘4218’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘4219’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘5504’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘5505’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘5506’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘8142’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘9465’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘12042’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘16655’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘16721’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘26324’, ‘33943’, ‘27000’, ‘0’, ‘0’, ‘60’);

INSERT INTO npc_trainer VALUES (‘3033’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘3034’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘3036’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘3064’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘3602’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘4218’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘4219’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘5504’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘5505’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘5506’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘8142’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘9465’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘12042’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘16655’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘16721’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

INSERT INTO npc_trainer VALUES (‘26324’, ‘18960’, ‘1728’, ‘0’, ‘0’, ‘15’);

http://filebeam.com/6200cc8b259e9e7469ee21da61c2caf3

Thanks… realy useful!

Cool ! thx for share!

Next, hunter : p?

I’m just gonna add all spells in 1 simple sql when i got time /emoticons/default_wink.png

Thanks You very usefull!

Thanks really helpful! /emoticons/default_smile.png :slight_smile:

its way faster to add them to the reference templates

ugly sql is ugly, and slow.

it is not blizlike /emoticons/default_tongue.png

very good work /emoticons/default_wink.png