Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Reference class to add some missing spells you get from quest and some others.
- SET @Deathknight :=90001;
- SET @Druid :=90001; -- Adding missing spell you get from quest.
- SET @Shaman :=90001; -- Adding missing spell you get from quest.
- SET @Hunter :=90001; -- Adding missing spell you get from quest.
- SET @Mage :=90001; -- Adding missing spell you get from quest.
- SET @Warlock :=90001; -- Adding missing spell you get from quest.
- SET @Warrior :=90001; -- Adding missing spell you get from quest.
- SET @GMspells :=90001;
- SET @Skills :=90001;
- SET @Trainer :=500000;
- -- Clean Trainer before inserting new NPC,spells & skills.
- -- Helps prevent dupe related SQL errors
- DELETE FROM `creature` WHERE `id`=@Trainer;
- DELETE FROM `creature_template` WHERE `entry`=@Trainer;
- DELETE FROM `npc_trainer` WHERE `entry`=@Trainer;
- DELETE FROM `npc_trainer` WHERE `entry`=@Deathknight;
- DELETE FROM `npc_trainer` WHERE `entry`=@Druid;
- DELETE FROM `npc_trainer` WHERE `entry`=@Mage;
- DELETE FROM `npc_trainer` WHERE `entry`=@Priest;
- DELETE FROM `npc_trainer` WHERE `entry`=@Rogue;
- DELETE FROM `npc_trainer` WHERE `entry`=@Paladin;
- DELETE FROM `npc_trainer` WHERE `entry`=@Warlock;
- DELETE FROM `npc_trainer` WHERE `entry`=@Warrior;
- DELETE FROM `npc_trainer` WHERE `entry`=@Hunter;
- DELETE FROM `npc_trainer` WHERE `entry`=@Shaman;
- DELETE FROM `npc_trainer` WHERE `entry`=@Skills;
- -- Create Trainer NPC
- INSERT INTO `creature_template` (`entry`,`difficulty_entry_1`,`difficulty_entry_2`,`difficulty_entry_3`,`KillCredit1`,`KillCredit2`,`modelid1`,`modelid2`,`modelid3`,`modelid4`,`name`,`subname`,`IconName`,`gossip_menu_id`,`minlevel`,`maxlevel`,`exp`,`faction_A`,`faction_H`,`npcflag`,`speed_walk`,`speed_run`,`scale`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`dmg_multiplier`,`baseattacktime`,`rangeattacktime`,`unit_class`,`unit_flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`trainer_class`,`trainer_race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`spell5`,`spell6`,`spell7`,`spell8`,`PetSpellDataId`,`VehicleId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`Health_mod`,`Mana_mod`,`Armor_mod`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`questItem5`,`questItem6`,`movementId`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`,`WDBVerified`) VALUES
- (@Trainer, -- entry
- 0, -- difficulty_entry_1
- 0, -- difficulty_entry_2
- 0, -- difficulty_entry_3
- 0, -- KillCredit1
- 0, -- KillCredit2
- 22931, -- modelid1
- 0, -- modelid2
- 0, -- modelid3
- 0, -- modelid4
- 'Global Class Trainer', -- name
- 'TonicWoW', -- subname
- '', -- IconeName
- 0, -- gossip_menu_id
- 80, -- minlevel
- 80, -- maxlevel
- 0, -- exp
- 35, -- faction_A
- 35, -- faction_h
- 51, -- npcflag
- 1, -- speed_walk
- 1, -- speed_run
- 1, -- scale
- 0, -- rank
- 1755, -- mindmg
- 1755, -- maxdmg
- 0, -- dmgschool
- 1504, -- attackpower
- 1, -- dmg_multiplier
- 1500, -- baseattacktime
- 0, -- rangeattacktime
- 2, -- unit_class
- 0, -- unit_flags
- 0, -- dynamicflags
- 0, -- family
- 2, -- trainer_type
- 0, -- trainer_spell
- 0, -- trainer_class
- 0, -- trainer_race
- 0, -- minrangedmg
- 0, -- maxrangedmg
- 0, -- rangedattackpower
- 7, -- type
- 0, -- type_flags
- 0, -- lootid
- 0, -- pickpocketloot
- 0, -- skinloot
- 0, -- resistance1
- 0, -- resistance2
- 0, -- resistance3
- 0, -- resistance4
- 0, -- resistance5
- 0, -- resistance6
- 0, -- spell1
- 0, -- spell2
- 0, -- spell3
- 0, -- spell4
- 0, -- spell5
- 0, -- spell6
- 0, -- spell7
- 0, -- spell8
- 0, -- PetSpellDataId
- 0, -- VehicleId
- 0, -- mingold
- 0, -- maxgold
- '', -- AIName
- 0, -- MovementType
- 3, -- InhabitType
- 1, -- Health_mod
- 1, -- Mana_mod
- 1, -- Armor_mod
- 0, -- RacialLeader
- 0, -- questItem1
- 0, -- questItem2
- 0, -- questItem3
- 0, -- questItem4
- 0, -- questItem5
- 0, -- questItem6
- 0, -- movementId
- 1, -- RegenHealth
- 0, -- equipment_id
- 0, -- mechanic_immune_mask
- 0, -- flags_extra
- '', -- ScriptName
- 1); -- WDBVerified
- -- Make Trainer mounted (Comment this part if you dont want him mounted)
- DELETE FROM `creature_template_addon` WHERE `entry`=@Trainer;
- INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
- (@Trainer,0,24725,0,4096,0,NULL);
- -- Insert spells to trainer
- INSERT INTO `npc_trainer` (`entry`,`spell`) VALUES
- (@Trainer,-200001), -- Warrior-Lowlevel
- (@Trainer,-200002), -- Warrior-Highlevel
- (@Trainer,-200003), -- Paladin-Lowlevel
- (@Trainer,-200004), -- Paladin-Highlevel
- (@Trainer,-200005), -- Druid-Lowlevel
- (@Trainer,-200006), -- Druid-Highlevel
- (@Trainer,-200007), -- Mage-Lowlevel
- (@Trainer,-200008), -- Mage-Highlevel
- (@Trainer,-200009), -- Warlock-Lowlevel
- (@Trainer,-200010), -- Warlock-Highlevel
- (@Trainer,-200011), -- Priest-Lowlevel
- (@Trainer,-200012), -- Priest-Highlevel
- (@Trainer,-200013), -- Hunter-Lowlevel
- (@Trainer,-200014), -- Hunter-Highlevel
- (@Trainer,-200015), -- Rogue-Lowlevel
- (@Trainer,-200016), -- Rogue-Highlevel
- (@Trainer,-200017), -- Shaman-Lowlevel
- (@Trainer,-200018); -- Shaman-Highlevel
- -- (@Trainer,-200019); -- Death Knights-Alllevel (Disable because alot of frost spell available to any class. Remade the DK spells and will remove the one trainable by any class)
- -- DeathKnight Spells
- INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
- (@Deathknight,48707,0,0,0,55),
- (@Deathknight,42650,0,0,0,55),
- (@Deathknight,48721,0,0,0,55),
- (@Deathknight,48263,0,0,0,55),
- (@Deathknight,45529,0,0,0,55),
- (@Deathknight,45524,0,0,0,55),
- (@Deathknight,56222,0,0,0,55),
- (@Deathknight,77606,0,0,0,55),
- (@Deathknight,48743,0,0,0,55),
- (@Deathknight,49998,0,0,0,55),
- (@Deathknight,43265,0,0,0,55),
- (@Deathknight,47568,0,0,0,55),
- (@Deathknight,85948,0,0,0,55),
- (@Deathknight,57330,0,0,0,55),
- (@Deathknight,48792,0,0,0,55),
- (@Deathknight,87492,0,0,0,55),
- (@Deathknight,47528,0,0,0,55),
- (@Deathknight,73975,0,0,0,55),
- (@Deathknight,49020,0,0,0,55),
- (@Deathknight,77575,0,0,0,55),
- (@Deathknight,3714,0,0,0,55),
- (@Deathknight,50842,0,0,0,55),
- (@Deathknight,61999,0,0,0,55),
- (@Deathknight,46584,0,0,0,55),
- (@Deathknight,56815,0,0,0,55),
- (@Deathknight,53341,0,0,0,55),
- (@Deathknight,53331,0,0,0,55),
- (@Deathknight,53343,0,0,0,55),
- (@Deathknight,54447,0,0,0,55),
- (@Deathknight,53342,0,0,0,55),
- (@Deathknight,54446,0,0,0,55),
- (@Deathknight,53323,0,0,0,55),
- (@Deathknight,53344,0,0,0,55),
- (@Deathknight,70164,0,0,0,55),
- (@Deathknight,62158,0,0,0,55),
- (@Deathknight,81229,0,0,0,55),
- (@Deathknight,47476,0,0,0,55),
- (@Deathknight,48265,0,0,0,55),
- -- Druid Spells
- (@Druid,1066,0,0,0,55),
- (@Druid,22812,0,0,0,55),
- (@Druid,5211,0,0,0,55),
- (@Druid,5487,0,0,0,55),
- (@Druid,768,0,0,0,55),
- (@Druid,5209,0,0,0,55),
- (@Druid,1082,0,0,0,55),
- (@Druid,8998,0,0,0,55),
- (@Druid,33786,0,0,0,55),
- (@Druid,1850,0,0,0,55),
- (@Druid,99,0,0,0,55),
- (@Druid,5228,0,0,0,55),
- (@Druid,339,0,0,0,55),
- (@Druid,770,0,0,0,55),
- (@Druid,16857,0,0,0,55),
- (@Druid,20719,0,0,0,55),
- (@Druid,22568,0,0,0,55),
- (@Druid,33943,0,0,0,55),
- (@Druid,22842,0,0,0,55),
- (@Druid,6795,0,0,0,55),
- (@Druid,5185,0,0,0,55),
- (@Druid,2637,0,0,0,55),
- (@Druid,16914,0,0,0,55),
- (@Druid,29166,0,0,0,55),
- (@Druid,5570,0,0,0,55),
- (@Druid,33745,0,0,0,55),
- (@Druid,87505,0,0,0,55),
- (@Druid,33763,0,0,0,55),
- (@Druid,22570,0,0,0,55),
- (@Druid,1126,0,0,0,55),
- (@Druid,87491,0,0,0,55),
- (@Druid,6807,0,0,0,55),
- (@Druid,8921,0,0,0,55),
- (@Druid,16689,0,0,0,55),
- (@Druid,50464,0,0,0,55),
- (@Druid,16864,0,0,0,55),
- (@Druid,5215,0,0,0,55),
- (@Druid,1822,0,0,0,55),
- (@Druid,6785,0,0,0,55),
- (@Druid,20484,0,0,0,55),
- (@Druid,8936,0,0,0,55),
- (@Druid,774,0,0,0,55),
- (@Druid,2782,0,0,0,55),
- (@Druid,50769,0,0,0,55),
- (@Druid,1079,0,0,0,55),
- (@Druid,62600,0,0,0,55),
- (@Druid,52610,0,0,0,55),
- (@Druid,5221,0,0,0,55),
- (@Druid,80964,0,0,0,55),
- (@Druid,80965,0,0,0,55),
- (@Druid,2908,0,0,0,55),
- (@Druid,77764,0,0,0,55),
- (@Druid,77761,0,0,0,55),
- (@Druid,2912,0,0,0,55),
- (@Druid,40120,0,0,0,55),
- (@Druid,779,0,0,0,55),
- (@Druid,62078,0,0,0,55),
- (@Druid,18960,0,0,0,55),
- (@Druid,467,0,0,0,55),
- (@Druid,77758,0,0,0,55),
- (@Druid,5217,0,0,0,55),
- (@Druid,5225,0,0,0,55),
- (@Druid,740,0,0,0,55),
- (@Druid,783,0,0,0,55),
- (@Druid,88747,0,0,0,55),
- (@Druid,88751,0,0,0,55);
- -- Hunter Spells
- INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
- (@Hunter,5118,0,0,0,55),
- (@Hunter,82661,0,0,0,55),
- (@Hunter,13615,0,0,0,55),
- (@Hunter,13159,0,0,0,55),
- (@Hunter,20043,0,0,0,55),
- (@Hunter,1462,0,0,0,55),
- (@Hunter,83242,0,0,0,55),
- (@Hunter,83243,0,0,0,55),
- (@Hunter,83244,0,0,0,55),
- (@Hunter,83245,0,0,0,55),
- (@Hunter,51753,0,0,0,55),
- (@Hunter,77767,0,0,0,55),
- (@Hunter,5116,0,0,0,55),
- (@Hunter,79682,0,0,0,55),
- (@Hunter,19263,0,0,0,55),
- (@Hunter,871,0,0,0,55),
- (@Hunter,2641,0,0,0,55),
- (@Hunter,20736,0,0,0,55),
- (@Hunter,6197,0,0,0,55),
- (@Hunter,13813,0,0,0,55),
- (@Hunter,6991,0,0,0,55),
- (@Hunter,5384,0,0,0,55),
- (@Hunter,1543,0,0,0,55),
- (@Hunter,1499,0,0,0,55),
- (@Hunter,1130,0,0,0,55),
- (@Hunter,13809,0,0,0,55),
- (@Hunter,13795,0,0,0,55),
- (@Hunter,34026,0,0,0,55),
- (@Hunter,53351,0,0,0,55),
- (@Hunter,87506,0,0,0,55),
- (@Hunter,53271,0,0,0,55),
- (@Hunter,87493,0,0,0,55),
- (@Hunter,136,0,0,0,55),
- (@Hunter,34477,0,0,0,55),
- (@Hunter,2643,0,0,0,55),
- (@Hunter,82243,0,0,0,55),
- (@Hunter,3045,0,0,0,55),
- (@Hunter,2973,0,0,0,55),
- (@Hunter,1513,0,0,0,55),
- (@Hunter,19503,0,0,0,55),
- (@Hunter,1978,0,0,0,55),
- (@Hunter,34600,0,0,0,55),
- (@Hunter,56641,0,0,0,55),
- (@Hunter,1515,0,0,0,55),
- (@Hunter,1494,0,0,0,55),
- (@Hunter,19878,0,0,0,55),
- (@Hunter,19879,0,0,0,55),
- (@Hunter,19880,0,0,0,55),
- (@Hunter,19822,0,0,0,55),
- (@Hunter,19885,0,0,0,55),
- (@Hunter,19883,0,0,0,55),
- (@Hunter,19884,0,0,0,55),
- (@Hunter,19801,0,0,0,55),
- (@Hunter,77769,0,0,0,55),
- (@Hunter,82654,0,0,0,55),
- (@Hunter,2974,0,0,0,55);
- -- Mage
- INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
- (@Mage,759,0,0,0,55),
- (@Mage,30451,0,0,0,55),
- (@Mage,1459,0,0,0,55),
- (@Mage,1449,0,0,0,55),
- (@Mage,5143,0,0,0,55),
- (@Mage,1953,0,0,0,55),
- (@Mage,10,0,0,0,55),
- (@Mage,120,0,0,0,55),
- (@Mage,42955,0,0,0,55),
- (@Mage,2139,0,0,0,55),
- (@Mage,12051,0,0,0,55),
- (@Mage,2136,0,0,0,55),
- (@Mage,82731,0,0,0,55),
- (@Mage,2120,0,0,0,55),
- (@Mage,7302,0,0,0,55),
- (@Mage,122,0,0,0,55),
- (@Mage,116,0,0,0,55),
- (@Mage,44614,0,0,0,55),
- (@Mage,45438,0,0,0,55),
- (@Mage,30455,0,0,0,55),
- (@Mage,66,0,0,0,55),
- (@Mage,6117,0,0,0,55),
- (@Mage,543,0,0,0,55),
- (@Mage,1463,0,0,0,55),
- (@Mage,86467,0,0,0,55),
- (@Mage,55342,0,0,0,55),
- (@Mage,30842,0,0,0,55),
- (@Mage,118,0,0,0,55),
- (@Mage,475,0,0,0,55),
- (@Mage,82676,0,0,0,55),
- (@Mage,43987,0,0,0,55),
- (@Mage,2948,0,0,0,55),
- (@Mage,130,0,0,0,55),
- (@Mage,30449,0,0,0,55),
- (@Mage,80553,0,0,0,55),
- (@Mage,89744,0,0,0,55);
- -- Paladin
- INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
- (@Paladin,31884,0,0,0,55),
- (@Paladin,20217,0,0,0,55),
- (@Paladin,19740,0,0,0,55),
- (@Paladin,4987,0,0,0,55),
- (@Paladin,19746,0,0,0,55),
- (@Paladin,26573,0,0,0,55),
- (@Paladin,32223,0,0,0,55),
- (@Paladin,465,0,0,0,55),
- (@Paladin,82326,0,0,0,55),
- (@Paladin,54428,0,0,0,55),
- (@Paladin,498,0,0,0,55),
- (@Paladin,642,0,0,0,55),
- (@Paladin,879,0,0,0,55),
- (@Paladin,19750,0,0,0,55),
- (@Paladin,86150,0,0,0,55),
- (@Paladin,853,0,0,0,55),
- (@Paladin,24275,0,0,0,55),
- (@Paladin,1044,0,0,0,55),
- (@Paladin,1022,0,0,0,55),
- (@Paladin,62124,0,0,0,55),
- (@Paladin,6940,0,0,0,55),
- (@Paladin,1038,0,0,0,55),
- (@Paladin,635,0,0,0,55),
- (@Paladin,82327,0,0,0,55),
- (@Paladin,2812,0,0,0,55),
- (@Paladin,84963,0,0,0,55),
- (@Paladin,20271,0,0,0,55),
- (@Paladin,633,0,0,0,55),
- (@Paladin,87494,0,0,0,55),
- (@Paladin,82242,0,0,0,55),
- (@Paladin,87511,0,0,0,55),
- (@Paladin,96231,0,0,0,55),
- (@Paladin,7328,0,0,0,55),
- (@Paladin,19891,0,0,0,55),
- (@Paladin,7294,0,0,0,55),
- (@Paladin,31789,0,0,0,55),
- (@Paladin,25780,0,0,0,55),
- (@Paladin,20165,0,0,0,55),
- (@Paladin,20164,0,0,0,55),
- (@Paladin,20154,0,0,0,55),
- (@Paladin,31801,0,0,0,55),
- (@Paladin,34767,0,0,0,55),
- (@Paladin,69826,0,0,0,55),
- (@Paladin,69820,0,0,0,55),
- (@Paladin,34769,0,0,0,55),
- (@Paladin,10326,0,0,0,55),
- (@Paladin,85673,0,0,0,55);
- -- Priest
- INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
- (@Priest,32546,0,0,0,55),
- (@Priest,528,0,0,0,55),
- (@Priest,2944,0,0,0,55),
- (@Priest,527,0,0,0,55),
- (@Priest,64843,0,0,0,55),
- (@Priest,586,0,0,0,55),
- (@Priest,6346,0,0,0,55),
- (@Priest,2061,0,0,0,55),
- (@Priest,2060,0,0,0,55),
- (@Priest,2050,0,0,0,55),
- (@Priest,14914,0,0,0,55),
- (@Priest,15237,0,0,0,55),
- (@Priest,64901,0,0,0,55),
- (@Priest,588,0,0,0,55),
- (@Priest,73413,0,0,0,55),
- (@Priest,73325,0,0,0,55),
- (@Priest,1706,0,0,0,55),
- (@Priest,8129,0,0,0,55),
- (@Priest,32375,0,0,0,55),
- (@Priest,87495,0,0,0,55),
- (@Priest,8092,0,0,0,55),
- (@Priest,605,0,0,0,55),
- (@Priest,48045,0,0,0,55),
- (@Priest,453,0,0,0,55),
- (@Priest,73510,0,0,0,55),
- (@Priest,2096,0,0,0,55),
- (@Priest,89745,0,0,0,55),
- (@Priest,21562,0,0,0,55),
- (@Priest,17,0,0,0,55),
- (@Priest,596,0,0,0,55),
- (@Priest,33076,0,0,0,55),
- (@Priest,8122,0,0,0,55),
- (@Priest,139,0,0,0,55),
- (@Priest,2006,0,0,0,55),
- (@Priest,9484,0,0,0,55),
- (@Priest,27683,0,0,0,55),
- (@Priest,32379,0,0,0,55),
- (@Priest,589,0,0,0,55),
- (@Priest,34433,0,0,0,55);
- -- Rogue
- INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
- (@Rogue,674,0,0,0,55),
- (@Rogue,8676,0,0,0,55),
- (@Rogue,53,0,0,0,55),
- (@Rogue,2094,0,0,0,55),
- (@Rogue,1833,0,0,0,55),
- (@Rogue,31224,0,0,0,55),
- (@Rogue,74001,0,0,0,55),
- (@Rogue,26679,0,0,0,55),
- (@Rogue,2836,0,0,0,55),
- (@Rogue,1842,0,0,0,55),
- (@Rogue,51722,0,0,0,55),
- (@Rogue,1725,0,0,0,55),
- (@Rogue,32645,0,0,0,55),
- (@Rogue,5277,0,0,0,55),
- (@Rogue,2098,0,0,0,55),
- (@Rogue,8647,0,0,0,55),
- (@Rogue,51723,0,0,0,55),
- (@Rogue,1966,0,0,0,55),
- (@Rogue,703,0,0,0,55),
- (@Rogue,1776,0,0,0,55),
- (@Rogue,1766,0,0,0,55),
- (@Rogue,408,0,0,0,55),
- (@Rogue,87504,0,0,0,55),
- (@Rogue,87496,0,0,0,55),
- (@Rogue,82245,0,0,0,55),
- (@Rogue,1804,0,0,0,55),
- (@Rogue,921,0,0,0,55),
- (@Rogue,73651,0,0,0,55),
- (@Rogue,73981,0,0,0,55),
- (@Rogue,1943,0,0,0,55),
- (@Rogue,1860,0,0,0,55),
- (@Rogue,6770,0,0,0,55),
- (@Rogue,5938,0,0,0,55),
- (@Rogue,5171,0,0,0,55),
- (@Rogue,76577,0,0,0,55),
- (@Rogue,2983,0,0,0,55),
- (@Rogue,1784,0,0,0,55),
- (@Rogue,57934,0,0,0,55),
- (@Rogue,1856,0,0,0,55);
- -- Shaman
- INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
- (@Shaman,2008,0,0,0,55),
- (@Shaman,556,0,0,0,55),
- (@Shaman,76780,0,0,0,55),
- (@Shaman,66843,0,0,0,55),
- (@Shaman,66842,0,0,0,55),
- (@Shaman,66844,0,0,0,55),
- (@Shaman,1064,0,0,0,55),
- (@Shaman,421,0,0,0,55),
- (@Shaman,51886,0,0,0,55),
- (@Shaman,2062,0,0,0,55),
- (@Shaman,8042,0,0,0,55),
- (@Shaman,2484,0,0,0,55),
- (@Shaman,51730,0,0,0,55),
- (@Shaman,8184,0,0,0,55),
- (@Shaman,6196,0,0,0,55),
- (@Shaman,2894,0,0,0,55),
- (@Shaman,1535,0,0,0,55),
- (@Shaman,8050,0,0,0,55),
- (@Shaman,8227,0,0,0,55),
- (@Shaman,8024,0,0,0,55),
- (@Shaman,8056,0,0,0,55),
- (@Shaman,8033,0,0,0,55),
- (@Shaman,2645,0,0,0,55),
- (@Shaman,77472,0,0,0,55),
- (@Shaman,8177,0,0,0,55),
- (@Shaman,73920,0,0,0,55),
- (@Shaman,5394,0,0,0,55),
- (@Shaman,8004,0,0,0,55),
- (@Shaman,331,0,0,0,55),
- (@Shaman,32182,0,0,0,55),
- (@Shaman,51514,0,0,0,55),
- (@Shaman,51505,0,0,0,55),
- (@Shaman,324,0,0,0,55),
- (@Shaman,8190,0,0,0,55),
- (@Shaman,87507,0,0,0,55),
- (@Shaman,5675,0,0,0,55),
- (@Shaman,87497,0,0,0,55),
- (@Shaman,73899,0,0,0,55),
- (@Shaman,370,0,0,0,55),
- (@Shaman,20608,0,0,0,55),
- (@Shaman,8017,0,0,0,55),
- (@Shaman,3599,0,0,0,55),
- (@Shaman,79206,0,0,0,55),
- (@Shaman,5730,0,0,0,55),
- (@Shaman,8071,0,0,0,55),
- (@Shaman,8075,0,0,0,55),
- (@Shaman,87718,0,0,0,55),
- (@Shaman,36936,0,0,0,55),
- (@Shaman,8143,0,0,0,55),
- (@Shaman,73680,0,0,0,55),
- (@Shaman,131,0,0,0,55),
- (@Shaman,52127,0,0,0,55),
- (@Shaman,546,0,0,0,55),
- (@Shaman,57994,0,0,0,55),
- (@Shaman,8512,0,0,0,55),
- (@Shaman,8232,0,0,0,55),
- (@Shaman,3738,0,0,0,55);
- -- Warlock
- INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
- (@Warlock,693,0,0,0,55),
- (@Warlock,980,0,0,0,55),
- (@Warlock,603,0,0,0,55),
- (@Warlock,710,0,0,0,55),
- (@Warlock,80388,0,0,0,55),
- (@Warlock,172,0,0,0,55),
- (@Warlock,6201,0,0,0,55),
- (@Warlock,1714,0,0,0,55),
- (@Warlock,702,0,0,0,55),
- (@Warlock,1490,0,0,0,55),
- (@Warlock,80398,0,0,0,55),
- (@Warlock,6789,0,0,0,55),
- (@Warlock,687,0,0,0,55),
- (@Warlock,77801,0,0,0,55),
- (@Warlock,48018,0,0,0,55),
- (@Warlock,48020,0,0,0,55),
- (@Warlock,689,0,0,0,55),
- (@Warlock,1120,0,0,0,55),
- (@Warlock,23161,0,0,0,55),
- (@Warlock,1098,0,0,0,55),
- (@Warlock,126,0,0,0,55),
- (@Warlock,5782,0,0,0,55),
- (@Warlock,28176,0,0,0,55),
- (@Warlock,77799,0,0,0,55),
- (@Warlock,5784,0,0,0,55),
- (@Warlock,755,0,0,0,55),
- (@Warlock,1949,0,0,0,55),
- (@Warlock,5484,0,0,0,55),
- (@Warlock,348,0,0,0,55),
- (@Warlock,29722,0,0,0,55),
- (@Warlock,1454,0,0,0,55),
- (@Warlock,87498,0,0,0,55),
- (@Warlock,86091,0,0,0,55),
- (@Warlock,5740,0,0,0,55),
- (@Warlock,29893,0,0,0,55),
- (@Warlock,698,0,0,0,55),
- (@Warlock,5676,0,0,0,55),
- (@Warlock,27243,0,0,0,55),
- (@Warlock,6229,0,0,0,55),
- (@Warlock,47897,0,0,0,55),
- (@Warlock,6353,0,0,0,55),
- (@Warlock,79268,0,0,0,55),
- (@Warlock,19028,0,0,0,55),
- (@Warlock,74434,0,0,0,55),
- (@Warlock,29858,0,0,0,55),
- (@Warlock,18540,0,0,0,55),
- (@Warlock,691,0,0,0,55),
- (@Warlock,1122,0,0,0,55),
- (@Warlock,712,0,0,0,55),
- (@Warlock,697,0,0,0,55),
- (@Warlock,5697,0,0,0,55);
- -- Warrior
- INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
- (@Warrior,6673,0,0,0,55),
- (@Warrior,18499,0,0,0,55),
- (@Warrior,2458,0,0,0,55),
- (@Warrior,1161,0,0,0,55),
- (@Warrior,100,0,0,0,55),
- (@Warrior,845,0,0,0,55),
- (@Warrior,86346,0,0,0,55),
- (@Warrior,469,0,0,0,55),
- (@Warrior,71,0,0,0,55),
- (@Warrior,1160,0,0,0,55),
- (@Warrior,676,0,0,0,55),
- (@Warrior,55694,0,0,0,55),
- (@Warrior,5308,0,0,0,55),
- (@Warrior,1715,0,0,0,55),
- (@Warrior,6544,0,0,0,55),
- (@Warrior,78,0,0,0,55),
- (@Warrior,57755,0,0,0,55),
- (@Warrior,1134,0,0,0,55),
- (@Warrior,20252,0,0,0,55),
- (@Warrior,3411,0,0,0,55),
- (@Warrior,5246,0,0,0,55),
- (@Warrior,87500,0,0,0,55),
- (@Warrior,7384,0,0,0,55),
- (@Warrior,3127,0,0,0,55),
- (@Warrior,87509,0,0,0,55),
- (@Warrior,6552,0,0,0,55),
- (@Warrior,1719,0,0,0,55),
- (@Warrior,772,0,0,0,55),
- (@Warrior,20230,0,0,0,55),
- (@Warrior,6572,0,0,0,55),
- (@Warrior,64382,0,0,0,55),
- (@Warrior,72,0,0,0,55),
- (@Warrior,2565,0,0,0,55),
- (@Warrior,871,0,0,0,55),
- (@Warrior,1464,0,0,0,55),
- (@Warrior,23920,0,0,0,55),
- (@Warrior,12678,0,0,0,55),
- (@Warrior,7386,0,0,0,55),
- (@Warrior,355,0,0,0,55),
- (@Warrior,6343,0,0,0,55),
- (@Warrior,34428,0,0,0,55),
- (@Warrior,1680,0,0,0,55);
- -- Skills
- INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
- (@Skills,33388,0,0,0,0), -- Apprentice Riding
- (@Skills,33391,0,33388,0,0), -- Journeyman Riding
- (@Skills,34090,0,33391,0,0), -- Expert Riding
- (@Skills,34091,0,34090,0,0), -- Artisan Riding
- (@Skills,54197,0,34090,0,0), -- Cold Weather Flying
- (@Skills,90265,0,34090,0,0), -- Master Riding
- (@Skills,90267,0,34090,0,0), -- Flight Master's License
- (@Skills,196,10000,0,0,1), -- One-Handed Axes
- (@Skills,197,10000,0,0,1), -- Two-Handed Axes
- (@Skills,198,10000,0,0,1), -- One-Handed Maces
- (@Skills,199,10000,0,0,1), -- Two-Handed Maces
- (@Skills,200,10000,0,0,1), -- Polearms
- (@Skills,201,10000,0,0,1), -- One-Handed Swords
- (@Skills,202,10000,0,0,1), -- Two-Handed Swords
- (@Skills,227,10000,0,0,1), -- Staves
- (@Skills,264,10000,0,0,1), -- Bows
- (@Skills,266,10000,0,0,1), -- Guns
- (@Skills,1180,10000,0,0,1), -- Daggers
- (@Skills,2567,10000,0,0,1), -- Throwns
- (@Skills,5011,10000,0,0,1), -- Crossbows
- (@Skills,15590,10000,0,0,1), -- Fists
- (@Skills,8737,10000,0,0,40), -- Mail Armor
- (@Skills,750,10000,0,0,40); -- Plate Armor
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement