Creature template 548: Difference between revisions
No edit summary |
No edit summary |
||
Line 787: | Line 787: | ||
===IconName=== | ===IconName=== | ||
Some infos later | |||
===gossip_menu_id=== | |||
Some infos later | Some infos later |
Revision as of 20:11, 11 August 2021
Back to world database list of tables.
The `creature_template` table
This table holds the information of any creatures in the world.
Structure
DB Structure
Field | Type | Attribute | Key | Null | Default | Comment |
entry | mediumint(8) | unsigned | PRI | NO | 0 | |
difficulty_entry_1 | mediumint(8) | unsigned | NO | NO | 0 | |
difficulty_entry_2 | mediumint(8) | unsigned | NO | NO | 0 | |
difficulty_entry_3 | mediumint(8) | unsigned | NO | NO | 0 | |
KillCredit1 | int(11) | unsigned | NO | NO | 0 | |
KillCredit2 | int(11) | unsigned | NO | NO | 0 | |
modelid1 | mediumint(8) | unsigned | NO | NO | 0 | |
modelid2 | mediumint(8) | unsigned | NO | NO | 0 | |
modelid3 | mediumint(8) | unsigned | NO | NO | 0 | |
modelid4 | mediumint(8) | unsigned | NO | NO | 0 | |
name | char(100) | NO | NO | 0 | ||
subname | char(100) | NO | YES | |||
IconName | char(100) | NO | YES | |||
gossip_menu_id | mediumint(8) | unsigned | NO | NO | 0 | |
minlevel | smallint(5) | NO | NO | 1 | ||
maxlevel | smallint(5) | NO | NO | 1 | ||
exp | smallint(5) | NO | NO | 0 | ||
exp_unk | smallint(5) | NO | NO | 0 | ||
faction_A | smallint(5) | unsigned | NO | NO | 0 | |
faction_H | smallint(5) | unsigned | NO | NO | 0 | |
npcflag | int(10) | NO | NO | 0 | ||
speed_walk | float | NO | NO | 1 | Result of 2.5/2.5, most common value | |
speed_run | float | NO | NO | 1.14286 | Result of 8.0/7.0, most common value | |
scale | float | NO | NO | 1 | ||
npc_rank | tinyint(3) | unsigned | NO | NO | 0 | |
mindmg | float | NO | NO | 0 | ||
maxdmg | float | NO | NO | 0 | ||
dmgschool | tinyint(3) | NO | NO | 0 | ||
attackpower | int(10) | unsigned | NO | NO | 0 | |
dmg_multiplier | float | NO | NO | 1 | ||
baseattacktime | int(10) | unsigned | NO | NO | 0 | |
rangeattacktime | int(10) | unsigned | NO | NO | 0 | |
unit_class | tinyint(3) | unsigned | NO | NO | 0 | |
unit_flags | int(10) | unsigned | NO | NO | 0 | |
unit_flags2 | int(10) | unsigned | NO | NO | 0 | |
dynamicflags | int(10) | unsigned | NO | NO | 0 | |
family | tinyint(3) | unsigned | NO | NO | 0 | |
trainer_type | tinyint(3) | NO | NO | 0 | ||
trainer_class | tinyint(3) | unsigned | NO | NO | 0 | |
trainer_race | tinyint(3) | unsigned | NO | NO | 0 | |
minrangedmg | float | NO | NO | 0 | ||
maxrangedmg | float | NO | NO | 0 | ||
rangedattackpower | smallint(5) | unsigned | NO | NO | 0 | |
type | tinyint(3) | unsigned | NO | NO | 0 | |
type_flags | int(10) | unsigned | NO | NO | 0 | |
type_flags2 | int(10) | unsigned | NO | NO | 0 | |
lootid | mediumint(7) | unsigned | NO | NO | 0 | |
pickpocketloot | mediumint(7) | unsigned | NO | NO | 0 | |
skinloot | mediumint(7) | unsigned | NO | NO | 0 | |
resistance1 | smallint(6) | NO | NO | 0 | ||
resistance2 | smallint(6) | NO | NO | 0 | ||
resistance3 | smallint(6) | NO | NO | 0 | ||
resistance4 | smallint(6) | NO | NO | 0 | ||
resistance5 | smallint(6) | NO | NO | 0 | ||
resistance6 | smallint(6) | NO | NO | 0 | ||
spell1 | mediumint(7) | unsigned | NO | NO | 0 | |
spell2 | mediumint(7) | unsigned | NO | NO | 0 | |
spell3 | mediumint(7) | unsigned | NO | NO | 0 | |
spell4 | mediumint(7) | unsigned | NO | NO | 0 | |
spell5 | mediumint(7) | unsigned | NO | NO | 0 | |
spell6 | mediumint(7) | unsigned | NO | NO | 0 | |
spell7 | mediumint(7) | unsigned | NO | NO | 0 | |
spell8 | mediumint(7) | unsigned | NO | NO | 0 | |
PetSpellDataId | mediumint(7) | unsigned | NO | NO | 0 | |
VehicleId | mediumint(7) | unsigned | NO | NO | 0 | |
mingold | mediumint(7) | unsigned | NO | NO | 0 | |
maxgold | mediumint(7) | unsigned | NO | NO | 0 | |
AIName | char(64) | NO | NO | |||
MovementType | tinyint(3) | unsigned | NO | NO | 0 | |
InhabitType | tinyint(3) | unsigned | NO | NO | 3 | |
HoverHeight | float | NO | NO | 1 | ||
Health_mod | float | NO | NO | 1 | ||
Mana_mod | float | NO | NO | 1 | ||
Mana_mod_extra | float | NO | NO | 1 | ||
Armor_mod | float | NO | NO | 1 | ||
RacialLeader | tinyint(3) | unsigned | NO | NO | 0 | |
questItem1 | int(10) | unsigned | NO | NO | 0 | |
questItem2 | int(10) | unsigned | NO | NO | 0 | |
questItem3 | int(10) | unsigned | NO | NO | 0 | |
questItem4 | int(10) | unsigned | NO | NO | 0 | |
questItem5 | int(10) | unsigned | NO | NO | 0 | |
questItem6 | int(10) | unsigned | NO | NO | 0 | |
movementId | int(10) | unsigned | NO | NO | 0 | |
RegenHealth | tinyint(3) | unsigned | NO | NO | 1 | |
mechanic_immune_mask | int(10) | unsigned | NO | NO | 0 | |
flags_extra | int(10) | unsigned | NO | NO | 0 | |
ScriptName | char(64) | NO | NO | |||
ModLevel | tinyint(3) | unsigned | NO | NO | 0 | |
WDBVerified | smallint(5) | NO | NO | 18414 |
Description of the fields
entry
entry# of the creature.
difficulty_entry_1
Some infos later
difficulty_entry_2
Some infos later
difficulty_entry_3
Some infos later
KillCredit1
Some infos later
KillCredit2
Some infos later
modelid1
Some infos later
modelid2
Some infos later
modelid3
Some infos later
modelid4
Some infos later
name
Some infos later
subname
Some infos later
IconName
Some infos later
Some infos later
minlevel
Some infos later
maxlevel
Some infos later
exp
Some infos later
exp_unk
Some infos later
faction_A
Some infos later
faction_H
Some infos later
npcflag
Some infos later
speed_walk
Some infos later
speed_run
Some infos later
scale
Some infos later
npc_rank
Some infos later
mindmg
Some infos later
maxdmg
Some infos later
dmgschool
Some infos later
attackpower
Some infos later
dmg_multiplier
Some infos later
baseattacktime
Some infos later
rangeattacktime
Some infos later
unit_class
Some infos later
unit_flags
Some infos later
unit_flags2
Some infos later
dynamicflags
Some infos later
family
Some infos later
trainer_type
Some infos later
trainer_class
Some infos later
trainer_race
Some infos later
minrangedmg
Some infos later
maxrangedmg
Some infos later
rangedattackpower
Some infos later
type
Some infos later
type_flags
Some infos later
type_flags2
Some infos later
lootid
Some infos later
pickpocketloot
Some infos later
skinloot
Some infos later
resistance1
Some infos later
resistance2
Some infos later
resistance3
Some infos later
resistance4
Some infos later
resistance5
Some infos later
resistance6
Some infos later
spell1
Some infos later
spell2
Some infos later
spell3
Some infos later
spell4
Some infos later
spell5
Some infos later
spell6
Some infos later
spell7
Some infos later
spell8
Some infos later
PetSpellDataId
Some infos later
VehicleId
Some infos later
mingold
Some infos later
maxgold
Some infos later
AIName
Some infos later
MovementType
Some infos later
InhabitType
Some infos later
HoverHeight
Some infos later
Health_mod
Some infos later
Mana_mod
Some infos later
Mana_mod_extra
Some infos later
Armor_mod
Some infos later
RacialLeader
Some infos later
questItem1
Some infos later
questItem2
Some infos later
questItem3
Some infos later
questItem4
Some infos later
questItem5
Some infos later
questItem6
Some infos later
movementId
Some infos later
RegenHealth
Some infos later
mechanic_immune_mask
Some infos later
flags_extra
Some infos later
ScriptName
Some infos later
ModLevel
Some infos later