Creature template 548: Difference between revisions

From Project Skyfire
Jump to navigation Jump to search
Line 1,192: Line 1,192:


===trainer_type===
===trainer_type===
 
{| class="wikitable"
Some infos later
!colspan="3"|Trainer Type Information
|-
|'''Type'''
|'''Id'''
|'''Comment'''
|-
|TRAINER_TYPE_CLASS           
|0
|
|-
|TRAINER_TYPE_MOUNTS           
|1
|// on blizz it's 2
|-
|TRAINER_TYPE_TRADESKILLS     
|2
|
|-
|TRAINER_TYPE_PETS             
|3
|
|}


===trainer_class===
===trainer_class===

Revision as of 21:28, 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
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 Reference by CreatureType.dbc
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

gossip_menu_id

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

Creature NPC Rank
Rank Id Comment
CREATURE_ELITE_NORMAL 0
CREATURE_ELITE_ELITE 1
CREATURE_ELITE_RAREELITE 2
CREATURE_ELITE_WORLDBOSS 3
CREATURE_ELITE_RARE 4
CREATURE_UNKNOWN 5 // found in 2.2.3 for 2 mobs

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

Reference by CreatureFamily.dbc

Creature Family Information
Family Id Comment
CREATURE_FAMILY_WOLF 1
CREATURE_FAMILY_CAT 2
CREATURE_FAMILY_SPIDER 3
CREATURE_FAMILY_BEAR 4
CREATURE_FAMILY_BOAR 5
CREATURE_FAMILY_CROCOLISK 6
CREATURE_FAMILY_CARRION_BIRD 7
CREATURE_FAMILY_CRAB 8
CREATURE_FAMILY_GORILLA 9
CREATURE_FAMILY_HORSE_CUSTOM 10 // Does not exist in DBC but used for horse like beasts in DB
CREATURE_FAMILY_RAPTOR 11
CREATURE_FAMILY_TALLSTRIDER 12
CREATURE_FAMILY_FELHUNTER 15
CREATURE_FAMILY_VOIDWALKER 16
CREATURE_FAMILY_SUCCUBUS 17
CREATURE_FAMILY_DOOMGUARD 19
CREATURE_FAMILY_SCORPID 20
CREATURE_FAMILY_TURTLE 21
CREATURE_FAMILY_IMP 23
CREATURE_FAMILY_BAT 24
CREATURE_FAMILY_HYENA 25
CREATURE_FAMILY_BIRD_OF_PREY 26
CREATURE_FAMILY_WIND_SERPENT 27
CREATURE_FAMILY_REMOTE_CONTROL 28
CREATURE_FAMILY_FELGUARD 29
CREATURE_FAMILY_DRAGONHAWK 30
CREATURE_FAMILY_RAVAGER 31
CREATURE_FAMILY_WARP_STALKER 32
CREATURE_FAMILY_SPOREBAT 33
CREATURE_FAMILY_NETHER_RAY 34
CREATURE_FAMILY_SERPENT 35
CREATURE_FAMILY_MOTH 37
CREATURE_FAMILY_CHIMAERA 38
CREATURE_FAMILY_DEVILSAUR 39
CREATURE_FAMILY_GHOUL 40
CREATURE_FAMILY_SILITHID 41
CREATURE_FAMILY_WORM 42
CREATURE_FAMILY_RHINO 43
CREATURE_FAMILY_WASP 44
CREATURE_FAMILY_CORE_HOUND 45
CREATURE_FAMILY_SPIRIT_BEAST 46
CREATURE_FAMILY_WATER_ELEMENTAL 49
CREATURE_FAMILY_FOX 50
CREATURE_FAMILY_MONKEY 51
CREATURE_FAMILY_DOG 52
CREATURE_FAMILY_BEETLE 53
CREATURE_FAMILY_SHALE_SPIDER 55
CREATURE_FAMILY_ZOMBIE 56
CREATURE_FAMILY_QA_TEST_FAMILY 57
CREATURE_FAMILY_SILITHID_2 59
CREATURE_FAMILY_WASP_2 66
CREATURE_FAMILY_HYDRA 68
CREATURE_FAMILY_FEL_IMP 100
CREATURE_FAMILY_VOIDLORD 101
CREATURE_FAMILY_SHIVARRA 102
CREATURE_FAMILY_OBSERVER 103
CREATURE_FAMILY_WRATHGUARD 104
CREATURE_FAMILY_INFERNAL 108
CREATURE_FAMILY_FIRE_ELEMENTAL 116
CREATURE_FAMILY_EARTH_ELEMENTAL 117
CREATURE_FAMILY_CRANE 125
CREATURE_FAMILY_WATER_STRIDER 126
CREATURE_FAMILY_PORCUPINE 127
CREATURE_FAMILY_QUILEN 128
CREATURE_FAMILY_GOAT 129
CREATURE_FAMILY_BASILISK 130
CREATURE_FAMILY_DIREHORN 138

trainer_type

Trainer Type Information
Type Id Comment
TRAINER_TYPE_CLASS 0
TRAINER_TYPE_MOUNTS 1 // on blizz it's 2
TRAINER_TYPE_TRADESKILLS 2
TRAINER_TYPE_PETS 3

trainer_class

Some infos later

trainer_race

Some infos later

minrangedmg

Some infos later

maxrangedmg

Some infos later

rangedattackpower

Some infos later

type

Reference by CreatureType.dbc

Creature Type Information
Type Id
CREATURE_TYPE_BEAST 1
CREATURE_TYPE_DRAGONKIN 2
CREATURE_TYPE_DEMON 3
CREATURE_TYPE_ELEMENTAL 4
CREATURE_TYPE_GIANT 5
CREATURE_TYPE_UNDEAD 6
CREATURE_TYPE_HUMANOID 7
CREATURE_TYPE_CRITTER 8
CREATURE_TYPE_MECHANICAL 9
CREATURE_TYPE_NOT_SPECIFIED 10
CREATURE_TYPE_TOTEM 11
CREATURE_TYPE_NON_COMBAT_PET 12
CREATURE_TYPE_GAS_CLOUD 13
CREATURE_TYPE_WILD_PET 14
CREATURE_TYPE_ABERRATION 15

type_flags

Creature Type Flags Information
Type Byte Comment
CREATURE_TYPEFLAGS_TAMEABLE 0x00000001 // Tameable by any hunter
CREATURE_TYPEFLAGS_GHOST 0x00000002 // Creature are also visible for not alive player. Allow gossip interaction if npcflag allow?
CREATURE_TYPEFLAGS_BOSS 0x00000004
CREATURE_TYPEFLAGS_UNK3 0x00000008
CREATURE_TYPEFLAGS_UNK4 0x00000010
CREATURE_TYPEFLAGS_UNK5 0x00000020
CREATURE_TYPEFLAGS_UNK6 0x00000040
CREATURE_TYPEFLAGS_DEAD_INTERACT 0x00000080 // Player can interact with the creature if its dead (not player dead)
CREATURE_TYPEFLAGS_HERBLOOT 0x00000100 // Can be looted by herbalist
CREATURE_TYPEFLAGS_MININGLOOT 0x00000200 // Can be looted by miner
CREATURE_TYPEFLAGS_UNK10 0x00000400
CREATURE_TYPEFLAGS_MOUNTED_COMBAT 0x00000800 // Creature can remain mounted when entering combat
CREATURE_TYPEFLAGS_AID_PLAYERS 0x00001000 // ? Can aid any player in combat if in range?
CREATURE_TYPEFLAGS_UNK13 0x00002000
CREATURE_TYPEFLAGS_UNK14 0x00004000 // ? Possibly not in use
CREATURE_TYPEFLAGS_ENGINEERLOOT 0x00008000 // Can be looted by engineer
CREATURE_TYPEFLAGS_EXOTIC 0x00010000 // Can be tamed by hunter as exotic pet
CREATURE_TYPEFLAGS_UNK17 0x00020000 // ? Related to vehicles/pvp?
CREATURE_TYPEFLAGS_UNK18 0x00040000 // ? Related to vehicle/siege weapons?
CREATURE_TYPEFLAGS_UNK19 0x00080000
CREATURE_TYPEFLAGS_UNK20 0x00100000
CREATURE_TYPEFLAGS_UNK21 0x00200000
CREATURE_TYPEFLAGS_UNK22 0x00400000
CREATURE_TYPEFLAGS_UNK23 0x00800000 // ? First seen in 3.2.2. Related to banner/backpack of creature/companion?
CREATURE_TYPEFLAGS_UNK24 0x01000000
CREATURE_TYPEFLAGS_UNK25 0x02000000
CREATURE_TYPEFLAGS_PARTY_MEMBER 0x04000000 //! Creature can be targeted by spells that require target to be in caster's party/raid
CREATURE_TYPEFLAGS_UNK27 0x08000000
CREATURE_TYPEFLAGS_UNK28 0x10000000
CREATURE_TYPEFLAGS_UNK29 0x20000000
CREATURE_TYPEFLAGS_UNK30 0x40000000
CREATURE_TYPEFLAGS_UNK31 0x80000000

type_flags2

Creature TypeFlags2 Information
Type Byte
CREATURE_TYPEFLAGS_2_UNK1 0x00000001
CREATURE_TYPEFLAGS_2_UNK2 0x00000002
CREATURE_TYPEFLAGS_2_UNK3 0x00000004
CREATURE_TYPEFLAGS_2_UNK4 0x00000008
CREATURE_TYPEFLAGS_2_UNK5 0x00000010
CREATURE_TYPEFLAGS_2_UNK6 0x00000020
CREATURE_TYPEFLAGS_2_UNK7 0x00000040
CREATURE_TYPEFLAGS_2_UNK8 0x00000080

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

Flags Extra Informations
Flag Byte Comment
CREATURE_FLAG_EXTRA_INSTANCE_BIND 0x00000001 // creature kill bind instance with killer and killer's group
CREATURE_FLAG_EXTRA_CIVILIAN 0x00000002 // not aggro (ignore faction/reputation hostility)
CREATURE_FLAG_EXTRA_NO_PARRY 0x00000004 // creature can't parry
CREATURE_FLAG_EXTRA_NO_PARRY_HASTEN 0x00000008 // creature can't counter-attack at parry
CREATURE_FLAG_EXTRA_NO_BLOCK 0x00000010 // creature can't block
CREATURE_FLAG_EXTRA_NO_CRUSH 0x00000020 // creature can't do crush attacks
CREATURE_FLAG_EXTRA_NO_XP_AT_KILL 0x00000040 // creature kill not provide XP
CREATURE_FLAG_EXTRA_TRIGGER 0x00000080 // trigger creature
CREATURE_FLAG_EXTRA_NO_TAUNT 0x00000100 // creature is immune to taunt auras and effect attack me
CREATURE_FLAG_EXTRA_WORLDEVENT 0x00004000 // custom flag for world event creatures (left room for merging)
CREATURE_FLAG_EXTRA_GUARD 0x00008000 // Creature is guard
CREATURE_FLAG_EXTRA_NO_CRIT 0x00020000 // creature can't do critical strikes
CREATURE_FLAG_EXTRA_NO_SKILLGAIN 0x00040000 // creature won't increase weapon skills
CREATURE_FLAG_EXTRA_TAUNT_DIMINISH 0x00080000 // Taunt is a subject to diminishing returns on this creautre
CREATURE_FLAG_EXTRA_ALL_DIMINISH 0x00100000 // Creature is subject to all diminishing returns as player are
CREATURE_FLAG_EXTRA_DUNGEON_BOSS 0x10000000 // creature is a dungeon boss (SET DYNAMICALLY, DO NOT ADD IN DB)

ScriptName

Some infos later

ModLevel

Some infos later

WDBVerified