API tools faq
paste
Advertisement
Rochet2

TrinityCore Trainers

Rochet2
May 8th, 2014
496
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 17.02 KB | None | 0 0
raw download clone embed print report
  1. -- Warrior
  2. SET @TRAINER_ENTRY = 9000001;
  3. DELETE FROM creature_template WHERE entry = @TRAINER_ENTRY;
  4. DELETE FROM npc_trainer WHERE entry = @TRAINER_ENTRY;
  5. INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  6. (@TRAINER_ENTRY, 3743, 0, 0, 0, 'Warrior Trainer', '', NULL, 0, 43, 43, 0, 35, 51, 1, 1.14286, 1, 0, 67, 88, 0, 162, 1, 2000, 1738, 1, 512, 2048, 8, 0, 0, 0, '1', 0, 46, 67, 16, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1.2, 1, 1, 0, 0, 1, 0, 2, '', 1);
  7. -- base spells
  8. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, spell FROM npc_trainer WHERE entry IN(SELECT entry FROM creature_template WHERE trainer_class = 1);
  9. -- quest spells
  10. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, rewardspell FROM quest_template WHERE -zoneorsort IN (81) AND (rewardspell <> 0 AND rewardspellcast <> 0) ORDER BY zoneorsort DESC;
  11. INSERT IGNORE INTO npc_trainer (entry, spell) VALUES (@TRAINER_ENTRY, 71), (@TRAINER_ENTRY, 7386), (@TRAINER_ENTRY, 355), (@TRAINER_ENTRY, 2458), (@TRAINER_ENTRY, 20252);
  12.  
  13. -- Paladin
  14. SET @TRAINER_ENTRY = 9000002;
  15. DELETE FROM creature_template WHERE entry = @TRAINER_ENTRY;
  16. DELETE FROM npc_trainer WHERE entry = @TRAINER_ENTRY;
  17. INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  18. (@TRAINER_ENTRY, 3743, 0, 0, 0, 'Paladin Trainer', '', NULL, 0, 43, 43, 0, 35, 51, 1, 1.14286, 1, 0, 67, 88, 0, 162, 1, 2000, 1738, 1, 512, 2048, 8, 0, 0, 0, '2', 0, 46, 67, 16, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1.2, 1, 1, 0, 0, 1, 0, 2, '', 1);
  19. -- base spells
  20. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, spell FROM npc_trainer WHERE entry IN(SELECT entry FROM creature_template WHERE trainer_class = 2);
  21. -- quest spells
  22. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, rewardspell FROM quest_template WHERE -zoneorsort IN (141) AND (rewardspell <> 0 AND rewardspellcast <> 0) ORDER BY zoneorsort DESC;
  23. INSERT IGNORE INTO npc_trainer (entry, spell) VALUES (@TRAINER_ENTRY, 23214);
  24.  
  25. -- Hunter
  26. SET @TRAINER_ENTRY = 9000003;
  27. DELETE FROM creature_template WHERE entry = @TRAINER_ENTRY;
  28. DELETE FROM npc_trainer WHERE entry = @TRAINER_ENTRY;
  29. INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  30. (@TRAINER_ENTRY, 3743, 0, 0, 0, 'Hunter Trainer', '', NULL, 0, 43, 43, 0, 35, 51, 1, 1.14286, 1, 0, 67, 88, 0, 162, 1, 2000, 1738, 1, 512, 2048, 8, 0, 0, 0, '3', 0, 46, 67, 16, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1.2, 1, 1, 0, 0, 1, 0, 2, '', 1);
  31. -- base spells
  32. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, spell FROM npc_trainer WHERE entry IN(SELECT entry FROM creature_template WHERE trainer_class = 3);
  33. -- quest spells
  34. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, rewardspell FROM quest_template WHERE -zoneorsort IN (261) AND (rewardspell <> 0 AND rewardspellcast <> 0) ORDER BY zoneorsort DESC;
  35.  
  36. -- Rogue
  37. SET @TRAINER_ENTRY = 9000004;
  38. DELETE FROM creature_template WHERE entry = @TRAINER_ENTRY;
  39. DELETE FROM npc_trainer WHERE entry = @TRAINER_ENTRY;
  40. INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  41. (@TRAINER_ENTRY, 3743, 0, 0, 0, 'Rogue Trainer', '', NULL, 0, 43, 43, 0, 35, 51, 1, 1.14286, 1, 0, 67, 88, 0, 162, 1, 2000, 1738, 1, 512, 2048, 8, 0, 0, 0, '4', 0, 46, 67, 16, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1.2, 1, 1, 0, 0, 1, 0, 2, '', 1);
  42. -- base spells
  43. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, spell FROM npc_trainer WHERE entry IN(SELECT entry FROM creature_template WHERE trainer_class = 4);
  44. -- quest spells
  45. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, rewardspell FROM quest_template WHERE -zoneorsort IN (162) AND (rewardspell <> 0 AND rewardspellcast <> 0) ORDER BY zoneorsort DESC;
  46. INSERT IGNORE INTO npc_trainer (entry, spell) VALUES (@TRAINER_ENTRY, 2842);
  47.  
  48. -- Priest
  49. SET @TRAINER_ENTRY = 9000005;
  50. DELETE FROM creature_template WHERE entry = @TRAINER_ENTRY;
  51. DELETE FROM npc_trainer WHERE entry = @TRAINER_ENTRY;
  52. INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  53. (@TRAINER_ENTRY, 3743, 0, 0, 0, 'Priest Trainer', '', NULL, 0, 43, 43, 0, 35, 51, 1, 1.14286, 1, 0, 67, 88, 0, 162, 1, 2000, 1738, 1, 512, 2048, 8, 0, 0, 0, '5', 0, 46, 67, 16, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1.2, 1, 1, 0, 0, 1, 0, 2, '', 1);
  54. -- base spells
  55. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, spell FROM npc_trainer WHERE entry IN(SELECT entry FROM creature_template WHERE trainer_class = 5);
  56. -- quest spells
  57. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, rewardspell FROM quest_template WHERE -zoneorsort IN (262) AND (rewardspell <> 0 AND rewardspellcast <> 0) ORDER BY zoneorsort DESC;
  58.  
  59. -- Death Knight
  60. SET @TRAINER_ENTRY = 9000006;
  61. DELETE FROM creature_template WHERE entry = @TRAINER_ENTRY;
  62. DELETE FROM npc_trainer WHERE entry = @TRAINER_ENTRY;
  63. INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  64. (@TRAINER_ENTRY, 3743, 0, 0, 0, 'Death Knight Trainer', '', NULL, 0, 43, 43, 0, 35, 51, 1, 1.14286, 1, 0, 67, 88, 0, 162, 1, 2000, 1738, 1, 512, 2048, 8, 0, 0, 0, '6', 0, 46, 67, 16, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1.2, 1, 1, 0, 0, 1, 0, 2, '', 1);
  65. -- base spells
  66. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, spell FROM npc_trainer WHERE entry IN(SELECT entry FROM creature_template WHERE trainer_class = 6);
  67. -- quest spells
  68. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, rewardspell FROM quest_template WHERE -zoneorsort IN (372) AND (rewardspell <> 0 AND rewardspellcast <> 0) ORDER BY zoneorsort DESC;
  69.  
  70. -- Shaman
  71. SET @TRAINER_ENTRY = 9000007;
  72. DELETE FROM creature_template WHERE entry = @TRAINER_ENTRY;
  73. DELETE FROM npc_trainer WHERE entry = @TRAINER_ENTRY;
  74. INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  75. (@TRAINER_ENTRY, 3743, 0, 0, 0, 'Shaman Trainer', '', NULL, 0, 43, 43, 0, 35, 51, 1, 1.14286, 1, 0, 67, 88, 0, 162, 1, 2000, 1738, 1, 512, 2048, 8, 0, 0, 0, '7', 0, 46, 67, 16, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1.2, 1, 1, 0, 0, 1, 0, 2, '', 1);
  76. -- base spells
  77. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, spell FROM npc_trainer WHERE entry IN(SELECT entry FROM creature_template WHERE trainer_class = 7);
  78. -- quest spells
  79. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, rewardspell FROM quest_template WHERE -zoneorsort IN (82) AND (rewardspell <> 0 AND rewardspellcast <> 0) ORDER BY zoneorsort DESC;
  80.  
  81. -- Mage
  82. SET @TRAINER_ENTRY = 9000008;
  83. DELETE FROM creature_template WHERE entry = @TRAINER_ENTRY;
  84. DELETE FROM npc_trainer WHERE entry = @TRAINER_ENTRY;
  85. INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  86. (@TRAINER_ENTRY, 3743, 0, 0, 0, 'Mage Trainer', '', NULL, 0, 43, 43, 0, 35, 51, 1, 1.14286, 1, 0, 67, 88, 0, 162, 1, 2000, 1738, 1, 512, 2048, 8, 0, 0, 0, '8', 0, 46, 67, 16, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1.2, 1, 1, 0, 0, 1, 0, 2, '', 1);
  87. -- base spells
  88. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, spell FROM npc_trainer WHERE entry IN(SELECT entry FROM creature_template WHERE trainer_class = 8);
  89. -- quest spells
  90. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, rewardspell FROM quest_template WHERE -zoneorsort IN (161) AND (rewardspell <> 0 AND rewardspellcast <> 0) ORDER BY zoneorsort DESC;
  91.  
  92. -- Warlock
  93. SET @TRAINER_ENTRY = 9000009;
  94. DELETE FROM creature_template WHERE entry = @TRAINER_ENTRY;
  95. DELETE FROM npc_trainer WHERE entry = @TRAINER_ENTRY;
  96. INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  97. (@TRAINER_ENTRY, 3743, 0, 0, 0, 'Warlock Trainer', '', NULL, 0, 43, 43, 0, 35, 51, 1, 1.14286, 1, 0, 67, 88, 0, 162, 1, 2000, 1738, 1, 512, 2048, 8, 0, 0, 0, '9', 0, 46, 67, 16, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1.2, 1, 1, 0, 0, 1, 0, 2, '', 1);
  98. -- base spells
  99. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, spell FROM npc_trainer WHERE entry IN(SELECT entry FROM creature_template WHERE trainer_class = 9);
  100. -- quest spells
  101. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, rewardspell FROM quest_template WHERE -zoneorsort IN (61) AND (rewardspell <> 0 AND rewardspellcast <> 0) ORDER BY zoneorsort DESC;
  102.  
  103. -- Druid
  104. SET @TRAINER_ENTRY = 9000011;
  105. DELETE FROM creature_template WHERE entry = @TRAINER_ENTRY;
  106. DELETE FROM npc_trainer WHERE entry = @TRAINER_ENTRY;
  107. INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  108. (@TRAINER_ENTRY, 3743, 0, 0, 0, 'Druid Trainer', '', NULL, 0, 43, 43, 0, 35, 51, 1, 1.14286, 1, 0, 67, 88, 0, 162, 1, 2000, 1738, 1, 512, 2048, 8, 0, 0, 0, '11', 0, 46, 67, 16, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1.2, 1, 1, 0, 0, 1, 0, 2, '', 1);
  109. -- base spells
  110. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, spell FROM npc_trainer WHERE entry IN(SELECT entry FROM creature_template WHERE trainer_class = 11);
  111. -- quest spells
  112. INSERT IGNORE INTO npc_trainer (entry, spell) SELECT DISTINCT @TRAINER_ENTRY, rewardspell FROM quest_template WHERE -zoneorsort IN (263) AND (rewardspell <> 0 AND rewardspellcast <> 0) ORDER BY zoneorsort DESC;
  113. INSERT IGNORE INTO npc_trainer (entry, spell) VALUES (@TRAINER_ENTRY, 1066), (@TRAINER_ENTRY, 8946), (@TRAINER_ENTRY, 5487), (@TRAINER_ENTRY, 6795), (@TRAINER_ENTRY, 6807);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!