How to make a custom trainner.

**giorgos** Fri Jul 30, 2010 1:58 am

-== Step 1 ==-

Open your Database Editing Tool
that would be, "Navicat", "HeidiSQL" or "SQLyog"

-== Step 2 =--
Make a Npc / Creature for your Skill that you chose for that npc to Train

Go into your Database and Open the Table called "creautre_names"

1 : Entry:
Put any number but not one thats already taken

2:
Creature name:
The name you want it

3:
Subname:
The name displayed below the name of the monster

4:Flags1:
Needs to be 0

5 : Type.
Code:
1-Beast
2-Dragonkin
3-Demon
4-Elemental
5-Giant
6-Undead
7-Humanoid
8-Critter
9-Mechanical
10-Not specified
11-Totem

6 : Family

Code:
1-Wolf
2-Cat
3-Spider
4-Bear
5-Boar
6-Crocolisk
7-Carrion Bird
8-Crab
9-Gorilla
11-Raptor
12-Tallstrider
15-Felhunter
16-Voidwalker
17-Succubus
19-Doomguard
20-Scorpid
21-Turtle
23-Imp
24-Bat
25-Hyena
26-Owl
27-Wind Serpent
28-Remote Control
29-Felguard
30-Dragonhawk
31-Ravager
32-Warp Stalker
33-Sporebat
34-Nether Ray
35-Serpent

7 :

Code:
0-Normal
1-Elite
2-RareElite
3-WorldBoss
4-Rare

8:unk4:
Needs to be 0

9:SpelldataID:
Needs to be (NULL) or 0

10:
Display id:
Display id of existing display id

11:
unk2 and unk3:
needs to be 1

12:
Civilian:
City creature = 1 Regular creature = 0

13:
Leader:
Null or 0

-== Step 3 ==-

Here is a Guide thanks to Fireking300

Now open the Table called "creautre_proto"

1:Entry:
Same as your creature_names entry id

2:level:
what level is it 1-999 a 999+ number wil crash World of warcraft

3:
Faction:
Number/Name/Ignore

Code:
1 PLAYER, Human 1
2 PLAYER, Orc 2
3 PLAYER, Dwarf 3
4 PLAYER, Night Elf 4
5 PLAYER, Undead 5
6 PLAYER, Tauren 6
7 Creature 7
10 Escortee 40
11 Stormwind 72
12 Stormwind 72
14 Monster 14
15 Creature 7
16 Monster 14
17 Defias Brotherhood 15
18 Murloc 19
19 Gnoll - Redridge 17
20 Gnoll - Riverpaw 16
21 Undead, Scourge 20
22 Beast - Spider 22
23 Gnomeregan Exiles 54
24 Worgen 24
25 Kobold 25
26 Kobold 25
27 Defias Brotherhood 15
28 Troll, Bloodscalp 26
29 Orgrimmar 76
30 Troll, Skullsplitter 27
31 Prey 28
32 Beast - Wolf 29
33 Escortee 40
34 Defias Brotherhood 15
35 Friendly 31
36 Trogg 32
37 Troll, Frostmane 33
38 Beast - Wolf 29
39 Gnoll - Shadowhide 18
40 Orc, Blackrock 34
41 Villian 35
42 Victim 36
43 Villian 35
44 Beast - Bear 37
45 Ogre 38
46 Kurzen's Mercenaries 39
47 Venture Company 41
48 Beast - Raptor 42
49 Basilisk 43
50 Dragonflight, Green 44
51 Lost Ones 45
52 Gizlock's Dummy 769
53 Human, Night Watch 49
54 Dark Iron Dwarves 48
55 Ironforge 47
56 Human, Night Watch 49
57 Ironforge 47
58 Creature 7
59 Trogg 32
60 Dragonflight, Red 50
61 Gnoll - Mosshide 51
62 Orc, Dragonmaw 52
63 Gnome - Leper 53
64 Gnomeregan Exiles 54
65 Orgrimmar 76
66 Leopard 55
67 Scarlet Crusade 56
68 Undercity 68
69 Ratchet 470
70 Gnoll - Rothide 57
71 Undercity 68
72 Beast - Gorilla 58
73 Beast - Carrion Bird 669
74 Naga 60
76 Dalaran 61
77 Forlorn Spirit 62
78 Darkhowl 63
79 Darnassus 69
80 Darnassus 69
81 Grell 64
82 Furbolg 65
83 Horde Generic 66
84 Alliance Generic 189
85 Orgrimmar 76
86 Gizlock's Charm 770
87 Syndicate 70
88 Hillsbrad Militia 71
89 Scarlet Crusade 56
90 Demon 73
91 Elemental 74
92 Spirit 75
93 Monster 14
94 Treasure 77
95 Gnoll - Mudsnout 78
96 HIllsbrad, Southshore Mayor 79
97 Syndicate 70
98 Undercity 68
99 Victim 36
100 Treasure 77
101 Treasure 77
102 Treasure 77
103 Dragonflight, Black 80
104 Thunder Bluff 81
105 Thunder Bluff 81
106 Horde Generic 66
107 Troll, Frostmane 33
108 Syndicate 70
109 Quilboar, Razormane 2 110
110 Quilboar, Razormane 2 110
111 Quilboar, Bristleback 85
112 Quilboar, Bristleback 85
113 Escortee 40
114 Treasure 77
115 PLAYER, Gnome 8
116 PLAYER, Troll 9
118 Undercity 68
119 Bloodsail Buccaneers 87
120 Booty Bay 21
121 Booty Bay 21
122 Ironforge 47
123 Stormwind 72
124 Darnassus 69
125 Orgrimmar 76
126 Darkspear Trolls 530
127 Villian 35
128 Blackfathom 88
129 Makrura 89
130 Centaur, Kolkar 90
131 Centaur, Galak 91
132 Gelkis Clan Centaur 92
133 Magram Clan Centaur 93
134 Maraudine 94
148 Monster 14
149 Theramore 108
150 Theramore 108
151 Theramore 108
152 Quilboar, Razorfen 109
153 Quilboar, Razorfen 109
154 Quilboar, Deathshead 111
168 Enemy 128
188 Ambient 148
189 Creature 7
190 Ambient 148
208 Nethergarde Caravan 168
209 Nethergarde Caravan 168
210 Alliance Generic 189
230 Southsea Freebooters 573
231 Escortee 40
232 Escortee 40
233 Undead, Scourge 20
250 Escortee 40
270 Wailing Caverns 229
290 Escortee 40
310 Silithid 249
311 Silithid 249
312 Beast - Spider 22
330 Wailing Caverns 229
350 Blackfathom 88
370 Armies of C'Thun 915
371 Silvermoon Remnant 269
390 Booty Bay 21
410 Basilisk 43
411 Beast - Bat 310
412 The Defilers 510
413 Scorpid 309
414 Timbermaw Hold 576
415 Titan 311
416 Titan 311
430 Taskmaster Fizzule 329
450 Wailing Caverns 229
470 Titan 311
471 Ravenholdt 349
472 Syndicate 70
473 Ravenholdt 349
474 Gadgetzan 369
475 Gadgetzan 369
494 Gnomeregan Bug 389
495 Escortee 40
514 Harpy 409
534 Alliance Generic 189
554 Burning Blade 429
574 Shadowsilk Poacher 449
575 Searing Spider 450
594 Trogg 32
614 Victim 36
634 Monster 14
635 Cenarion Circle 609
636 Timbermaw Hold 576
637 Ratchet 470
654 Troll, Witherbark 82
655 Centaur, Kolkar 90
674 Dark Iron Dwarves 48
694 Wildhammer Clan 471
695 Hydraxian Waterlords 749
714 Horde Generic 66
734 Dark Iron Dwarves 48
735 Goblin, Dark Iron Bar Patron 489
736 Goblin, Dark Iron Bar Patron 489
754 Dark Iron Dwarves 48
774 Escortee 40
775 Escortee 40
776 Brood of Nozdormu 910
777 Might of Kalimdor 912
778 Giant 511
794 Argent Dawn 529
795 Troll, Vilebranch 572
814 Argent Dawn 529
834 Elemental 74
854 Everlook 577
855 Everlook 577
874 Wintersaber Trainers 589
875 Gnomeregan Exiles 54
876 Darkspear Trolls 530
877 Darkspear Trolls 530
894 Theramore 108
914 Training Dummy 679
934 Furbolg, Uncorrupted 575
954 Demon 73
974 Undead, Scourge 20
994 Cenarion Circle 609
995 Thunder Bluff 81
996 Cenarion Circle 609
1014 Shatterspear Trolls 629
1015 Shatterspear Trolls 629
1034 Horde Generic 66
1054 Wildhammer Clan 471
1055 Wildhammer Clan 471
1074 Orgrimmar 76
1075 Theramore 108
1076 Darnassus 69
1077 Theramore 108
1078 Stormwind 72
1080 Friendly 31
1081 Elemental 74
1094 Beast - Boar 23
1095 Training Dummy 679
1096 Theramore 108
1097 Darnassus 69
1114 Dragonflight, Black - Bait 689
1134 Undercity 68
1154 Undercity 68
1174 Orgrimmar 76
1194 Battleground Neutral 709
1214 Frostwolf Clan 729
1215 Frostwolf Clan 729
1216 Stormpike Guard 730
1217 Stormpike Guard 730
1234 Sulfuron Firelords 750
1235 Sulfuron Firelords 750
1236 Sulfuron Firelords 750
1254 Cenarion Circle 609
1274 Creature 7
1275 Creature 7
1294 Gizlock 771
1314 Horde Generic 66
1315 Alliance Generic 189
1334 Stormpike Guard 730
1335 Frostwolf Clan 729
1354 Shen'dralar 809
1355 Shen'dralar 809
1374 Ogre (Captain Kromcrush) 829
1375 Treasure 77
1394 Dragonflight, Black 80
1395 Silithid Attackers 916
1414 Spirit Guide - Alliance 790
1415 Spirit Guide - Horde 849
1434 Jaedenar 869
1454 Victim 36
1474 Thorium Brotherhood 59
1475 Thorium Brotherhood 59
1494 Revantusk Trolls 893
1495 Revantusk Trolls 893
1496 Revantusk Trolls 893
1514 Silverwing Sentinels 890
1515 Warsong Outriders 889
1534 Stormpike Guard 730
1554 Frostwolf Clan 729
1555 Darkmoon Faire 909
1574 Zandalar Tribe 270
1575 Stormwind 72
1576 Silvermoon Remnant 269
1577 The League of Arathor 509
1594 Darnassus 69
1595 Orgrimmar 76
1596 Stormpike Guard 730
1597 Frostwolf Clan 729
1598 The Defilers 510
1599 The League of Arathor 509
1600 Darnassus 69
1601 Brood of Nozdormu 910
1602 Silvermoon City 911
1603 Silvermoon City 911
1604 Silvermoon City 911
1605 Dragonflight, Bronze 531
1606 Creature 7
1607 Creature 7
1608 Cenarion Circle 609
1610 PLAYER, Blood Elf 914
1611 Ironforge 47
1612 Orgrimmar 76
1613 Might of Kalimdor 912
1614 Monster 14
1615 Steamwheedle Cartel 169
1616 RC Objects 919
1617 RC Enemies 918
1618 Ironforge 47
1619 Orgrimmar 76
1620 Enemy 128
1621 Blue 921
1622 Red 920
1623 Tranquillien 922
1624 Argent Dawn 529
1625 Argent Dawn 529
1626 Undead, Scourge 20
1627 Farstriders 923
1628 Tranquillien 922
1629 PLAYER, Draenei 927
1630 Scourge Invaders 928
1634 Scourge Invaders 928
1635 Steamwheedle Cartel 169
1636 Farstriders 923
1637 Farstriders 923
1638 Exodar 930
1639 Exodar 930
1640 Exodar 930
1641 Warsong Outriders 889
1642 Silverwing Sentinels 890
1643 Troll, Forest 937
1644 The Sons of Lothar 940
1645 The Sons of Lothar 940
1646 Exodar 930
1647 Exodar 930
1648 The Sons of Lothar 940
1649 The Sons of Lothar 940
1650 The Mag'har 941
1651 The Mag'har 941
1652 The Mag'har 941
1653 The Mag'har 941
1654 Exodar 930
1655 Exodar 930
1656 Silvermoon City 911
1657 Silvermoon City 911
1658 Silvermoon City 911
1659 Cenarion Expedition 942
1660 Cenarion Expedition 942
1661 Cenarion Expedition 942
1662 Fel Orc 943
1663 Fel Orc Ghost 944
1664 Sons of Lothar Ghosts 945
1665 0
1666 Honor Hold 946
1667 Honor Hold 946
1668 Thrallmar 947
1669 Thrallmar 947
1670 Thrallmar 947
1671 Honor Hold 946
1672 Test Faction 2 948
1673 ToWoW - Flag 950
1674 Test Faction 4 953
1675 Test Faction 3 952
1676 ToWoW - Flag Trigger Horde ( 954
1677 ToWoW - Flag Trigger Allianc 951
1678 Ethereum 956
1679 Broken 955
1680 Elemental 74
1681 Earth Elemental 957
1682 Fighting Robots 958
1683 Actor Good 959
1684 Actor Evil 960
1685 Stillpine Furbolg 961
1686 Stillpine Furbolg 961
1687 Crazed Owlkin 962
1688 Chess Alliance 963
1689 Chess Horde 964
1690 Chess Alliance 963
1691 Chess Horde 964
1692 Monster Spar 965
1693 Monster Spar Buddy 966
1694 Exodar 930
1695 Silvermoon City 911
1696 The Violet Eye 967
1697 Fel Orc 943
1698 Exodar 930
1699 Exodar 930
1700 Exodar 930
1701 Sunhawks 968
1702 Sunhawks 968
1703 Training Dummy 679
1704 Fel Orc 943
1705 Fel Orc 943
1706 Fungal Giant 971
1707 Sporeggar 970
1708 Sporeggar 970
1709 Sporeggar 970
1710 Cenarion Expedition 942
1711 Monster, Predator 973
1712 Monster, Prey 974
1713 Monster, Prey 974
1714 Sunhawks 968
1715 Void Anomaly 975
1716 Hyjal Defenders 976
1717 Hyjal Defenders 976
1718 Hyjal Defenders 976
1719 Hyjal Defenders 976
1720 Hyjal Invaders 977
1721 Kurenai 978
1722 Kurenai 978
1723 Kurenai 978
1724 Kurenai 978
1725 Earthen Ring 979
1726 Earthen Ring 979
1727 Earthen Ring 979
1728 Cenarion Expedition 942
1729 Thrallmar 947
1730 The Consortium 933
1731 The Consortium 933
1732 Alliance Generic 189
1733 Alliance Generic 189
1734 Horde Generic 66
1735 Horde Generic 66
1736 Monster Spar Buddy 966
1737 Honor Hold 946
1738 Arakkoa 981
1739 Zangarmarsh Banner (Alliance 982
1740 Zangarmarsh Banner (Horde) 983
1741 The Sha'tar 935
1742 Zangarmarsh Banner (Neutral) 984
1743 The Aldor 932
1744 The Scryers 934
1745 Silvermoon City 911
1746 The Scryers 934
1747 Caverns of Time - Thrall 985
1748 Caverns of Time - Durnholde 986
1749 Caverns of Time - Southshore 987
1750 Shadow Council Covert 988
1751 Monster 14
1752 Dark Portal Attacker, Legion 993
1753 Dark Portal Attacker, Legion 993
1754 Dark Portal Attacker, Legion 993
1755 Dark Portal Defender, Allian 991
1756 Dark Portal Defender, Allian 991
1757 Dark Portal Defender, Allian 991
1758 Dark Portal Defender, Horde 992
1759 Dark Portal Defender, Horde 992
1760 Dark Portal Defender, Horde 992
1761 Inciter Trigger 994
1762 Inciter Trigger 2 995
1763 Inciter Trigger 3 996
1764 Inciter Trigger 4 997
1765 Inciter Trigger 5 998
1766 Argent Dawn 529
1767 Argent Dawn 529
1768 Demon 73
1769 Demon 73
1770 Actor Good 959
1771 Actor Evil 960
1772 Mana Creature 999
1773 Khadgar's Servant 1000
1774 Friendly 31
1775 The Sha'tar 935
1776 The Aldor 932
1777 The Aldor 932
1778 The Scale of the Sands 990
1779 Keepers of Time 989
1780 Bladespire Clan 1001
1781 Bloodmaul Clan 929
1782 Bladespire Clan 1001
1783 Bloodmaul Clan 929
1784 Bladespire Clan 1001
1785 Bloodmaul Clan 929
1786 Demon 73
1787 Monster 14
1788 The Consortium 933
1789 Sunhawks 968
1790 Bladespire Clan 1001
1791 Bloodmaul Clan 929
1792 Fel Orc 943
1793 Sunhawks 968
1794 Protectorate 1003
1795 Protectorate 1003
1796 Ethereum 956
1797 Protectorate 1003
1798 Arcane Annihilator (DNR) 1004
1799 Ethereum Sparbuddy 1002
1800 Ethereum 956
1801 Horde 67
1802 Alliance 469
1803 Ambient 148
1804 Ambient 148
1805 The Aldor 932
1806 Friendly 31
1807 Protectorate 1003
1808 Kirin'Var - Belmara 1007
1809 Kirin'Var - Cohlien 1009
1810 Kirin'Var - Dathric 1006
1811 Kirin'Var - Luminrath 1008
1812 Friendly 31
1813 Servant of Illidan 1010
1814 Monster Spar Buddy 966
1815 Beast - Wolf 29
1816 Friendly 31
1818 Lower City 1011
1819 Alliance Generic 189
1820 Ashtongue Deathsworn 1012
1821 Spirits of Shadowmoon 1 1013
1822 Spirits of Shadowmoon 2 1014
1823 Ethereum 956
1824 Netherwing 1015
1825 Demon 73
1826 Servant of Illidan 1010
1827 Wyrmcult 1016
1828 Treant 1017
1829 Leotheras Demon I 1018
1830 Leotheras Demon II 1019
1831 Leotheras Demon III 1020
1832 Leotheras Demon IV 1021
1833 Leotheras Demon V 1022
1834 Azaloth 1023
1835 Horde Generic 66
1836 The Consortium 933
1837 Sporeggar 970
1838 The Scryers 934
1839 Rock Flayer 1024
1840 Flayer Hunter 1025
1841 Shadowmoon Shade 1026
1842 Legion Communicator 1027
1843 Servant of Illidan 1010
1844 The Aldor 932
1845 The Scryers 934
1846 Ravenswood Ancients 1028
1847 Monster Spar 965
1848 Monster Spar Buddy 966
1849 Servant of Illidan 1010
1850 Netherwing 1015
1851 Lower City 1011
1852 Chess, Friendly to All Chess 1029
4:Health/mana:
Your own choice

5:
Scale:
1 for regular scale of Display id. Like 1 is scale of a wolf and same as a giant

npc flags:
going to be a trainer so put 16

6:
Attacktime until rangemaxdamage:
You will know

7:
Mountdisplay:
To make a monster on a mount

8:
itemslotdisplay:
the weapon he gots in his main hand

9:
item2slotdisplay:
the weapon he gots in this other hand

10:Respawntime:
360000=5 min
180000=2 min and 30 sec

11:
Resistance0_armor:
The choice of resistance.

12.
Combat_reach:
If You put this on 1 he attacks when he stands near you.
If You put it 1000 u dont even see him and he already attacking you

13 :Bounding_radius:
How far he see you put it on 1 and it wil have a normal rate of sight put it on 2 he will attack you faster when you come close.

14
Auras
MEMO or 0

15
Boss
Put it as 0

16
Money
Put it on 0 or if you want money when you kill it put a number higher than 0 Money goes by copper so for 1 silver it would be 100.

-== Making a Trainer ==-

So you have just made your Npc / Creature and it has the Flag Id for Trainer
Now we have to Make the Skills and put them into the Trainer / Npc

-== Step 1 ==-Go into the Table called "trainer_spells"

[color:6347=blue[color=darkblue]]-== Step 2 ==-[/color]entry:
Enter the Npc Spawn Id of the creature you made in the Fist Step up top

[color:6347=blue[color=darkblue]]-== Step 3 ==-[/color]cast_spell:
The Spell that you wont your Npc to cast on your Self or a Player
Ass you can see here, if you wont > Power Word: Fortitude
You would put this Spell in "cast_spell" > Power Word: Fortitude - Spells - World of Warcraft
Not the Actual Spell, or it will just give them the buff "Power Word: Fortitude"

-== Step 4 ==-spellcost:
The amount it will cost to buy that Spell from the Trainer
1 = 1 Copper
1000 = 1g, Etc

-== Step 5 ==-
reqspell:
This really isn't needed, but do you know Spells Like " Heroic Strike: Rank 3"
And you need "Heroic Strike: Rank 2" to get that spell, That is what it is for

-== Step 6 ==-reqskill:
A skill need to learn then spell, here is a list of some Skill IDs \/

Code:
754 Racial - Human
393 Skinning
109 Language: Orcish
124 Tauren Racial
433 Shield
137 Language: Thalassian
473 Fist Weapons
140 Language: Titan
160 Two-Handed Maces
253 Assassination
313 Language: Gnomish
613 Discipline
653 Pet - Bat
413 Mail
414 Leather
45 Bows
229 Polearms
593 Destruction
573 Restoration
251 Pet - Turtle
257 Protection
293 Plate Mail
8 Fire
46 Guns
270 Pet - Generic
98 Language: Common
125 Orc Racial
315 Language: Troll
139 Language: Demon Tongue
354 Demonology
355 Affliction
165 Leatherworking
134 Feral Combat
373 Enhancement
374 Restoration
375 Elemental Combat
415 Cloth
236 Pet - Scorpid
176 Thrown
6 Frost
26 Arms
38 Combat
39 Subtlety
44 Axes
50 Beast Mastery
51 Survival
56 Holy
78 Shadow Magic
101 Dwarven Racial
111 Language: Dwarven
113 Language: Darnassian
115 Language: Taurahe
118 Dual Wield
136 Staves
138 Language: Draconic
141 Language: Old Tongue
142 Survival
155 Swimming
163 Marksmanship
164 Blacksmithing
172 Two-Handed Axes
173 Daggers
183 GENERIC (DND)
184 Retribution
189 Pet - Felhunter
197 Tailoring
204 Pet - Voidwalker
205 Pet - Succubus
206 Pet - Infernal
208 Pet - Wolf
209 Pet - Cat
210 Pet - Bear
211 Pet - Boar
212 Pet - Crocilisk
213 Pet - Carrion Bird
214 Pet - Crab
217 Pet - Raptor
218 Pet - Tallstrider
220 Racial - Undead
226 Crossbows
228 Wands
574 Balance
256 Fury
594 Holy
633 Lockpicking
654 Pet - Hyena
655 Pet - Owl
656 Pet - Wind Serpent
673 Language: Gutterspeak
95 Defense
333 Enchanting
186 Mining
43 Swords
55 Two-Handed Swords
733 Racial - Troll
753 Racial - Gnome
188 Pet - Imp
203 Pet - Spider
207 Pet - Doomguard
215 Pet - Gorilla
202 Engineering
356 Fishing
171 Alchemy
54 Maces
182 Herbalism
129 First Aid
185 Cooking
126 Night Elf Racial
237 Arcane
261 Beast Training
267 Protection
40 Poisons
162 Unarmed
762 Riding

-== Step 7 ==-
reqskillvalue:
The level of the Skill needed to learn the Spell

-== Step 8 ==-reqlevel:
the level needed to learn that Skill

-== Step 9 ==-deletespell:
The Spell Id that will be Deleted when you learn the spell
(Leave this at 0 unless you know what you are doing)