1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
|
# creature_template
This table contains the description of creatures. Each spawned creature is an instance of a template present in this table, this means every creature MUST be defined in this table.
| Field | Type | Null | Key | Default | Extra | Comment |
| -------------------------------------------------- | ------------------ | ---- | --- | ------- | ----- | ------------------------------------ |
| [entry](#entry) | MEDIUMINT UNSIGNED | NO | PRI | 0 | | |
| [difficulty_entry_1](#difficultyentryx) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [difficulty_entry_2](#difficultyentryx) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [difficulty_entry_3](#difficultyentryx) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [KillCredit1](#killcredit1) | INT UNSIGNED | NO | | 0 | | |
| [KillCredit2](#killcredit2) | INT UNSIGNED | NO | | 0 | | |
| [modelid1](#modelidx) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [modelid2](#modelidx) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [modelid3](#modelidx) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [modelid4](#modelidx) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [name](#name) | char(100) | NO | MUL | 0 | | |
| [subname](#subname) | char(100) | YES | | (NULL) | | |
| [IconName](#iconname) | char(100) | YES | | (NULL) | | |
| [gossip_menu_id](#gossipmenuid) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [minlevel](#minlevel) | TINYINT UNSIGNED | NO | | 1 | | |
| [maxlevel](#maxlevel) | TINYINT UNSIGNED | NO | | 1 | | |
| [exp](#exp) | SMALLINT | NO | | 0 | | |
| [faction](#faction) | SMALLINT UNSIGNED | NO | | 0 | | |
| [npcflag](#npcflag) | INT UNSIGNED | NO | | 0 | | |
| [speed_walk](#speedwalk) | FLOAT | NO | | 1 | | Result of 2.5/2.5, most common value |
| [speed_run](#speedrun) | FLOAT | NO | | 1.14286 | | Result of 8.0/7.0, most common value |
| [speed_swim](#speedswim) | FLOAT | NO | | 1 | | |
| [speed_swim](#speedflight) | FLOAT | NO | | 1 | | |
| [detection_range](#detectionrange) | FLOAT | NO | | 20 | | |
| [scale](#scale) | FLOAT | NO | | 1 | | |
| [rank](#rank) | TINYINT UNSIGNED | NO | | 0 | | |
| [dmgschool](#dmgschool) | TINYINT | NO | | 0 | | |
| [BaseAttackTime](#baseattacktime) | INT UNSIGNED | NO | | 0 | | |
| [RangeAttackTime](#rangeattacktime) | INT UNSIGNED | NO | | 0 | | |
| [BaseVariance](#basevariance) | FLOAT | NO | | 1 | | |
| [RangeVariance](#rangevariance) | FLOAT | NO | | 1 | | |
| [unit_class](#unitclass) | TINYINT UNSIGNED | NO | | 0 | | |
| [unit_flags](#unitflags) | INT UNSIGNED | NO | | 0 | | |
| [unit_flags2](#unitflags2) | INT UNSIGNED | NO | | 0 | | |
| [dynamicflags](#dynamicflags) | INT UNSIGNED | NO | | 0 | | |
| [family](#family) | TINYINT | NO | | 0 | | |
| [trainer_type](#trainertype) | TINYINT | NO | | 0 | | |
| [trainer_spell](#trainerspell) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [trainer_class](#trainerclass) | TINYINT UNSIGNED | NO | | 0 | | |
| [trainer_race](#trainerrace) | TINYINT UNSIGNED | NO | | 0 | | |
| [type](#type) | TINYINT UNSIGNED | NO | | 0 | | |
| [type_flags](#typeflags) | INT UNSIGNED | NO | | 0 | | |
| [lootid](#lootid) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [pickpocketloot](#pickpocketloot) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [skinloot](#skinloot) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [PetSpellDataId](#petspelldataid) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [VehicleId](#vehicleid) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [mingold](#mingold) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [maxgold](#maxgold) | MEDIUMINT UNSIGNED | NO | | 0 | | |
| [AIName](#ainame) | char(64) | NO | | | | |
| [MovementType](#movementtype) | TINYINT UNSIGNED | NO | | 0 | | |
| [HoverHeight](#hoverheight) | FLOAT | NO | | 1 | | |
| [HealthModifier](#healthmodifier) | FLOAT | NO | | 1 | | |
| [ManaModifier](#manamodifier) | FLOAT | NO | | 1 | | |
| [ArmorModifier](#armormodifier) | FLOAT | NO | | 1 | | |
| [DamageModifier](#damagemodifier) | FLOAT | NO | | 1 | | |
| [ExperienceModifier](#experiencemodifier) | FLOAT | NO | | 1 | | |
| [RacialLeader](#racialleader) | TINYINT UNSIGNED | NO | | 0 | | |
| [movementId](#movementid) | INT UNSIGNED | NO | | 0 | | |
| [RegenHealth](#regenhealth) | TINYINT UNSIGNED | NO | | 1 | | |
| [mechanic_immune_mask](#mechanicimmunemask) | INT UNSIGNED | NO | | 0 | | |
| [spell_school_immune_mask](#spellschoolimmunemask) | INT UNSIGNED | NO | | 0 | | |
| [flags_extra](#flags_extra) | INT UNSIGNED | NO | | 0 | | |
| [ScriptName](#scriptname) | char(64) | NO | | | | |
| [VerifiedBuild](#verifiedbuild) | SMALLINT | YES | | 0 | | |
---
**Description of the fields**
#### entry
Creature's unique id.
#### difficulty_entry_x
| name | entry | difficulty_entry_1 | difficulty_entry_2 | difficulty_entry_3 |
| --------------------------------------------------------- | ----- | ------------------ | ------------------ | ------------------ |
| [Anomalus](http://www.wowhead.com/npc=26763/anomalus) | 26763 | 30529 | 0 | 0 |
| [Sindragosa](http://www.wowhead.com/npc=36853/sindragosa) | 36853 | 38265 | 38266 | 38267 |
Anomalus is a 5 man boss located in The Nexus. You can fight him on two types of difficulties (normal dungeon and heroic dungeon). Depending on the type of difficulty, bosses have different statistics like health and damage. In case of Anomalus information from entry 26763 is used when you fight him at normal difficulty and entry 30529 is used when you fight him at heroic difficulty.
Sindragosa, a raid boss encounter located in the Icecrown Citadel can be fought on 4 different difficulties due to the introduction of heroic raid modes in Patch 3.2 (10man normal/heroic, 25man normal/heroic). Depending on the type of difficulty, she must have different statistics. So if you see her in 10man normal raid she will use information from entry 36853, in a 25man normal raid entry 38265 will be used and so on. This is in stark contrast to raid bosses such as Patchwerk and XT-002 Deconstructor, located in Naxxramas and Ulduar respectively, who only have two different raid modes (10-man 'normal'/25-man 'normal'). Hardmodes within the Ulduar raid do not have their own template, due to game mechanics engaging the harder difficulty during the encounter itself.
Here is a special case with the Alterac Valley battleground. There are 4 level brackets where the NPCs are made easier or harder, depending on your level bracket (Added in WoW patch 3.2.2 when level 80 characters received their own bracket for this battleground and all brackets below level 80 received their own level of difficulty). The same concept applies to the Isle of Conquest battleground, with only two brackets.
If you look at the database you will notice a very characteristic pattern which is summarized in table below:
| name | entry | difficulty_entry_1 | difficulty_entry_2 | difficulty_entry_3 |
| ---------------- | ----------------- | ------------------ | ------------------ | ------------------ |
| Normal Creature | Different than 0 | 0 | 0 | 0 |
| Dungeon Creature | Normal Dungeon | Heroic Dungeon | 0 | 0 |
| Raid Creature | 10man Normal Raid | 25man Normal Raid | 10man Heroic Raid | 25man Heroic Raid |
| Battleground | 51- 59 | 60-69 | 70-79 | 80 |
#### KillCredit1
If this is a kill credit template -- one that is a dummy template that is used when more than one creature can count as a kill in a quest, then this is a link to the first [entry](#entry) of the creature that could be killed to give quest credit.
#### KillCredit2
If this is a kill credit template -- one that is a dummy template that is used when more than one creature can count as a kill in a quest, then this is a link to the second [entry](#entry) of the creature that could be killed to give quest credit. If more than two creatures can be killed and count toward a single objective, an smart or C++ script will be required.
#### modelidx
A random graphical model that the client applies on this creature. Of course if you specify only one modelid and the rest will be equal to 0, model you have set won't be chosen randomly. This is a [creature_model_info.modelid](creature_model_info#modelid)
#### name
Base name of the creature.
#### subname
The subname of the creature that appears in <> below the creature's name.
#### IconName
Used to tell the player what kind of NPC this creature is.
| IconName | description |
| ------------------ | ---------------------------------------------------------------------------------- |
| **Directions** | Used for guards and teleporter NPC's. |
| **Gunner** | Indicator of a turret NPC/Player Controlled. |
| **vehichleCursor** | Indicator that this is a PCV (Player Controlled Vehicle) |
| **Driver** | Shows a steering wheel icon when mouse over. |
| **Attack** | Shows a sword icon indicating you can attack this target. |
| **Buy** | Shows a brown bag icon usually if the NPC only sells things. |
| **Speak** | Shows a chat bubble icon if this NPC has quest/gossip options. |
| **Pickup** | Shows a hand grasping icon if this NPC can be picked up for quest/items. |
| **Interact** | Shows cog icon commonly used for quest/transport. |
| **Trainer** | Shows a book icon, identifying this NPC as a trainer. |
| **Taxi** | Shows a boot with wings icon identifying this NPC as a taxi. |
| **Repair** | Shows a anvil icon identifying that this NPC can repair. |
| **LootAll** | Shows a multiple brown bag icon (same as holding shift before looting a creature). |
| **Quest** | Unused or unknown (see entry 32870 "The Real Ronakada"). |
| **PVP** | Unused or Unknown (see entry 29387 "Arena Master: Dalaran Arena"). |
**Attention!** This is not required to make the NPC function unless you are using scripts or gossip options. Names are case sensitive, If in doubt use an example above.
#### gossip_menu_id
The gossip ID of this creature. This field is obtained from sniff (update fields). If you can not sniff this value, and need to make one up, it must be > 50000. This field is the link to [gossip_menu.MenuID](gossip_menu#menu_id).
#### minlevel
The minimum level of the creature if the creature has a level range.
#### maxlevel
The maximum level of the creature if the creature has a level range. When added to world, a level in chosen in the specified level range.
#### exp
The expansion table the creatures health value is taken from. Values are from 0 to 2. See creature_classlevelstats.
| exp | name |
| --- | ---------------------- |
| 0 | Classic |
| 1 | The Burning Crusade |
| 2 | Wrath of The Lich King |
#### faction
The faction of the creature. See [FactionTemplate](FactionTemplate). Just because more than one faction has the same name, the inter-faction relationships can be different.
Note: This field also controls the creature family assistance mechanic. Only creatures with the same faction will assist each other.
#### npcflag
A bitmask that represents what NPC flags the creature has. Each bit controls a different flag and to combine flags, you can add each flag that you want, in effect activating the respective bits.
| Flag | | Name | Comment |
| -------- | ---------- | ------------------ | -------------------------------------------------------------------------------- |
| 1 | 0x00000001 | Gossip | If creature has more gossip options, add this flag to bring up a menu. |
| 2 | 0x00000002 | Quest Giver | Any creature giving or taking quests needs to have this flag. |
| 16 | 0x00000010 | Trainer | Allows the creature to have a trainer list to teach spells |
| 32 | 0x00000020 | Class Trainer | Is class trainer |
| 64 | 0x00000040 | Profession Trainer | Is profession trainer |
| 128 | 0x00000080 | Vendor | Is vendor (generic) Any creature selling items needs to have this flag. |
| 256 | 0x00000100 | Vendor Ammo | Is vendor (ammo) |
| 512 | 0x00000200 | Vendor Food | Is vendor (food) |
| 1024 | 0x00000400 | Vendor Poison | Is vendor (poison) |
| 2048 | 0x00000800 | Vendor Reagent | Is vendor (Reagent) |
| 4096 | 0x00001000 | Repairer | Creatures with this flag can repair items. |
| 8192 | 0x00002000 | Flight Master | Any creature serving as flight master has this. |
| 16384 | 0x00004000 | Spirit Healer | Makes the creature invisible to alive characters and has the resurrect function. |
| 32768 | 0x00008000 | Spirit Guide | Is spirit guide |
| 65536 | 0x00010000 | Innkeeper | Creatures with this flag can set hearthstone locations. |
| 131072 | 0x00020000 | Banker | Creatures with this flag can show the bank |
| 262144 | 0x00040000 | Petitioner | Handles guild/arena petitions |
| 524288 | 0x00080000 | Tabard Designer | Allows the designing of guild tabards. |
| 1048576 | 0x00100000 | Battlemaster | Creatures with this flag port players to battlegrounds. |
| 2097152 | 0x00200000 | Auctioneer | Allows creature to display auction list. |
| 4194304 | 0x00400000 | Stable Master | Has the option to stable pets for hunters. |
| 8388608 | 0x00800000 | Guild Banker | Is guild banker |
| 16777216 | 0x01000000 | Spellclick | Needs data on npc_spellclick_spells table |
| 67108864 | 0x04000000 | Mailbox | NPC will act like a mailbox (opens mailbox with right-click) |
So if you want a NPC that is a quest giver(2), a vendor(128) and can repair(4096) you just add specific flags together: 2+128+4096=4226
#### speed_walk
Controls how fast the creature can walk. For vehicles: increases fly speed.
#### speed_run
Controls how fast the creature can run. For vehicles: increases ground movement speed.
#### speed_swim
Controls how fast the creature can swim.
#### speed_flight
Controls how fast the creature can fly.
#### detection_range
Controls the range at which creatures detect and see players.
#### scale
If non-zero, this field defines the size of how the model of the creature appears ingame. If zero, it will use default model size taken from the DBC.
#### rank
The rank of the creature:
| Rank | Name | Default Respawn Time Creature.spawntimesecs | Corpse Decay Time Worldserver.conf (Corpse.Decay) | Total Default Respawn spawntimesecs + Corpse.Decay |
| ---- | ---------- | ------------------------------------------- | ------------------------------------------------- | -------------------------------------------------- |
| 0 | Normal | 5 min | 60 sec | 6 min |
| 1 | Elite | 5 min | 5 min | 10 min |
| 2 | Rare Elite | 5 min | 5 min | 10 min |
| 3 | Boss | 5 min | 1 hour | 1 hour, 5 min |
| 4 | Rare | 5 min | 5 min | 10 min |
**Note 1:** An NPC's rank is mostly visual (which also requires your Cache to be cleared to see changes). Changing this value will not change its health, damage, or loot. However, it will change the respawn time of the creature.
**Note 2:** Respawn times can be modified in two other places: [Creature.spawntimesecs](creature#spawntimesecs) (only for that single GUID of the creature) and in the worldserver.conf file under the "Corpse.Decay" settings (for ALL creatures of the same rank). The default \`spawntimesecs\` for all spawned creatures is 300 seconds (5 minutes). For example, using the ".npc add" command to spawn a "Normal" NPC will give it a default respawn time of 6 minutes (spawntimesecs + Corpse.Decay time). Also, the creature must decay first before it can respawn. For this reason, the Corpse Decay Time of the creature is also it's minimum respawn time, since setting the creature's Creature.spawntimesecs = 0 will remove the Default Respawn Time. In the example above, setting our Normal NPC's spawntimesecs = 0 will mean the creature's respawn time decreases from 6 minutes to 60 seconds.
**Note 3:** If you want the creature to show a skull or "??" in the portrait (often with Bosses), set the [type_flags](#type_flags) to 4.
#### dmgschool
Creature's melee damage school.
| ID | Name |
| --- | ------------------- |
| 0 | SPELL_SCHOOL_NORMAL |
| 1 | SPELL_SCHOOL_HOLY |
| 2 | SPELL_SCHOOL_FIRE |
| 3 | SPELL_SCHOOL_NATURE |
| 4 | SPELL_SCHOOL_FROST |
| 5 | SPELL_SCHOOL_SHADOW |
| 6 | SPELL_SCHOOL_ARCANE |
#### BaseAttackTime
This is the base time that determines how long a creature must wait between melee attacks. This time is in milliseconds.
#### RangeAttackTime
This is the base time that determines how long a creature must wait between ranged attacks. This time is in milliseconds.
#### BaseVariance
Value to customize the creature's damage output. See [DamageModifier](#damagemodifier).
Non-custom creatures should always leave this at 1.
#### RangeVariance
Value to customize the creature's damage output. See [DamageModifier](#damagemodifier).
Non-custom creatures should always leave this at 1.
#### unit_class
This is the creature's class, and it dictates levels of health and mana. Also note that health and mana will change according to [exp](#exp), [HealthModifier](#healthmodifier), and [ManaModifier](#manamodifier). Not setting this value will report a minor warning in the "DB_Errors.log".
| Value | Name | Power Shown |
| ----- | ------------- | ------------------------------------------------------ |
| 1 | CLASS_WARRIOR | health only (equal to rogue) |
| 2 | CLASS_PALADIN | health & mana (more health than mage but less mana) |
| 4 | CLASS_ROGUE | Health only (equal to warrior) |
| 8 | CLASS_MAGE | health & mana (less health than paladin but more mana) |
#### unit_flags
Allows the manual application of unit flags to creatures. Again this is a bitmask field and to apply more than one flag, just add the different numbers. Some possible flags are:
| Flag | | Name | Comments |
| ---------- | ---------- | --------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 1 | 0x00000001 | UNIT_FLAG_SERVER_CONTROLLED | set only when unit movement is controlled by server - by SPLINE/MONSTER_MOVE packets, together with UNIT_FLAG_STUNNED; only set to units controlled by client; client function CGUnit_C::IsClientControlled returns false when set for owner |
| 2 | 0x00000002 | UNIT_FLAG_NON_ATTACKABLE | Not attackable |
| 4 | 0x00000004 | UNIT_FLAG_DISABLE_MOVE | |
| 8 | 0x00000008 | UNIT_FLAG_PLAYER_CONTROLLED | Controlled by player, use
|
