Comparación de páginas

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	Comment
entry	mediumint(8) unsigned	NO	PRI	0
difficulty_entry_1	mediumint(8) unsigned	NO		0
difficulty_entry_2	mediumint(8) unsigned	NO		0
difficulty_entry_3	mediumint(8) unsigned	NO		0
KillCredit1	int(10) unsigned	NO		0
KillCredit2	int(10) unsigned	NO		0
modelid1	mediumint(8) unsigned	NO		0
modelid2	mediumint(8) unsigned	NO		0
modelid3	mediumint(8) unsigned	NO		0
modelid4	mediumint(8) unsigned	NO		0
name	char(100)	NO	MUL	0
subname	char(100)	YES		(NULL)
IconName	char(100)	YES		(NULL)
gossip_menu_id	mediumint(8) unsigned	NO		0
minlevel	tinyint(3) unsigned	NO		1
maxlevel	tinyint(3) unsigned	NO		1
exp	smallint(6)	NO		0
faction	smallint(5) unsigned	NO		0
npcflag	int(10) unsigned	NO		0
speed_walk	float	NO		1	Result of 2.5/2.5, most common value
speed_run	float	NO		1.14286	Result of 8.0/7.0, most common value
scale	float	NO		1
rank	tinyint(3) unsigned	NO		0
dmgschool	tinyint(4)	NO		0
BaseAttackTime	int(10) unsigned	NO		0
RangeAttackTime	int(10) unsigned	NO		0
BaseVariance	float	NO		1
RangeVariance	float	NO		1
unit_class	tinyint(3) unsigned	NO		0
unit_flags	int(10) unsigned	NO		0
unit_flags2	int(10) unsigned	NO		0
dynamicflags	int(10) unsigned	NO		0
family	tinyint(4)	NO		0
trainer_type	tinyint(4)	NO		0
trainer_spell	mediumint(8) unsigned	NO		0
trainer_class	tinyint(3) unsigned	NO		0
trainer_race	tinyint(3) unsigned	NO		0
type	tinyint(3) unsigned	NO		0
type_flags	int(10) unsigned	NO		0
lootid	mediumint(8) unsigned	NO		0
pickpocketloot	mediumint(8) unsigned	NO		0
skinloot	mediumint(8) unsigned	NO		0
resistance1	smallint(6)	NO		0
resistance2	smallint(6)	NO		0
resistance3	smallint(6)	NO		0
resistance4	smallint(6)	NO		0
resistance5	smallint(6)	NO		0
resistance6	smallint(6)	NO		0
spell1	mediumint(8) unsigned	NO		0
spell2	mediumint(8) unsigned	NO		0
spell3	mediumint(8) unsigned	NO		0
spell4	mediumint(8) unsigned	NO		0
spell5	mediumint(8) unsigned	NO		0
spell6	mediumint(8) unsigned	NO		0
spell7	mediumint(8) unsigned	NO		0
spell8	mediumint(8) unsigned	NO		0
PetSpellDataId	mediumint(8) unsigned	NO		0
VehicleId	mediumint(8) unsigned	NO		0
mingold	mediumint(8) unsigned	NO		0
maxgold	mediumint(8) unsigned	NO		0
AIName	char(64)	NO
MovementType	tinyint(3) unsigned	NO		0
InhabitType	tinyint(3) unsigned	NO		3
HoverHeight	float	NO		1
HealthModifier	float	NO		1
ManaModifier	float	NO		1
ArmorModifier	float	NO		1
DamageModifier	float	NO		1
ExperienceModifier	float	NO		1
RacialLeader	tinyint(3) unsigned	NO		0
movementId	int(11) unsigned	NO		0
RegenHealth	tinyint(3) unsigned	NO		1
mechanic_immune_mask	int(10) unsigned	NO		0
flags_extra	int(10) unsigned	NO		0
ScriptName	char(64)	NO
VerifiedBuild	smallint(5)	YES		0

...

Note 3: If you want the creature to show a skull or "??" in the portrait (often with Bosses), set the type_flags to 4.

...

Minimum damage the creature deals in melee. This field is no longer combined with the attackpower field to calculate the damage.

...

Maximum damage the creature deals in melee. This field is no longer combined with the attackpower field to calculate the damage.

Ancla
dmgschool
dmgschool
dmgschool

...

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

Ancla

...

BaseAttackTime

...

BaseAttackTime

...

The attack power for the creature's melee attacks. This field along with mindmg and maxdmg dictate how much the creature will hit for. The formula in applying correct damages is as follows:

Bloque de código

language	sql

UPDATE `creature_template` SET 
    `mindmg` = <#1>, 
    `maxdmg` = <#2>, 
    `attackpower` = ROUND((`mindmg` + `maxdmg`) / 4 * 7), 
    `mindmg` = ROUND(`mindmg` - `attackpower` / 7), 
    `maxdmg` = ROUND(`maxdmg` - `attackpower` / 7) 
  WHERE `entry` = ...

In the query above, substitute '<#1>' with the minimum damage you want the creature to deal and '<#2>' with the maximum damage you want the creature to deal.

NOTE: You might also want to double check the values calculated after the query is run because if the difference between mindmg and maxdmg is too high, mindmg will end up being a negative value.

...

Multiplier for mindmg and maxdmg

Example: mindmg=200 maxdmg = 500 dmg_multiplier = 10

Outcome: mob will hit for 2000-5000

...

BaseAttackTime

This is the base time that determines how long a creature must wait between melee attacks. This time is in milliseconds.

Ancla

...

RangeAttackTime

...

RangeAttackTime

...

RangeAttackTime

This is the base time that determines how long a creature must wait between ranged attacks. This time is in milliseconds.

...

Ancla
unit_flags
unit_flags
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:

...

Ancla
dynamicflags
dynamicflags
dynamicflags

Flags that control visual appearance of the creature.

...

Decimal	Hexadecimal	Name	Comments
dynamicflags
0	0x00	UNIT_DYNFLAG_NONE
1	0x01	UNIT_DYNFLAG_LOOTABLE
2	0x02	UNIT_DYNFLAG_TRACK_UNIT	Creature's location will be seen as a small dot in the minimap
4	0x04	UNIT_DYNFLAG_TAPPED	Makes creatures name appear grey (Lua_UnitIsTapped)
8	0x08	UNIT_DYNFLAG_TAPPED_BY_PLAYER	Lua_UnitIsTappedByPlayer usually used by PCVs (Player Controlled Vehicles)
16	0x10	UNIT_DYNFLAG_SPECIALINFO
32	0x20	UNIT_DYNFLAG_DEAD	Makes the creature appear dead (this DOES NOT make the creature's name grey or not attack players).
64	0x40	UNIT_DYNFLAG_REFER_A_FRIEND
128	0x80	UNIT_DYNFLAG_TAPPED_BY_ALL_THREAT_LIST	Lua_UnitIsTappedByAllThreatList

Ancla
family
family
family

The family this creature belongs to.

ID	Family	ID	Family
1.	Wolf	26.	Owl
2.	Cat	27.	Wind Serpent
3.	Spider	28.	Remote Control
4.	Bear	29.	Felguard
5.	Boar	30.	Dragonhawk
6.	Crocolisk	31.	Ravager
7.	Carrion Bird	32.	Warp Stalker
8.	Crab	33.	Sporebat
9.	Gorilla	34.	Nether Ray
11.	Raptor	35.	Serpent
12.	Tallstrider	37.	Moth
15.	Felhunter	38.	Chimaera
16.	Voidwalker	39.	Devilsaur
17.	Succubus	40.	Ghoul
19.	Doomguard	41.	Silithid
20.	Scorpid	42.	Worm
21.	Turtle	43.	Rhino
23.	Imp	44.	Wasp
24.	Bat	45.	Core Hound
25.	Hyena	46.	Spirit Beast

Ancla
trainer_type
trainer_type
trainer_type

If the NPC is a trainer (has the trainer flag), then this field controls what kind of trainer it is. Both this field and the related field must be filled in for a trainer to work correctly.

ID	Type	Related Field	Comments
0	TRAINER_TYPE_CLASS	trainer_class	Trains class spells
1	TRAINER_TYPE_MOUNTS	trainer_race	Trains riding skill
2	TRAINER_TYPE_TRADESKILLS	trainer_spell	Trains professions
3	TRAINER_TYPE_PETS	trainer_class	Trains pet skills

Ancla
trainer_spell
trainer_spell
trainer_spell

If the NPC is a trainer that teaches professions (trainer_type = = 2), then the player must already know the spell ID specified here to be able to talk to this NPC.

Ancla
trainer_class
trainer_class
trainer_class

If the NPC is a class trainer or a pet trainer (trainer_type = = 0 or 3), then the player's class must be the same as the value specified here to talk to this trainer. For pet trainers, this value must be 3 (hunter). See characters.class

Ancla
trainer_race
trainer_race
trainer_race

If the NPC is a mount trainer (trainer_type == 1), then the player's race must be the same as the value specified here to talk to this trainer. See characters.race

minrangedmg

Minimum ranged damage the creature inflicts.

maxrangedmg

Maximum range damage the creature inflicts.

rangedattackpower

This field also refers to the damage multiplier.

Example: If the creature is using a ranged weapon and its rangedattackpower = 500 and the dmg_multiplier is 10 the max that it can hit for with ranged attacks would be 5000

Ancla
type
type
type

The type of the creature.

...

Decimal	Hexadecimal	Name	Comments
type_flags
1	0x0000 0001	CREATURE_TYPEFLAGS_TAMEABLE	Makes the mob tameable (must also be a beast and have family set)
2	0x0000 0002	CREATURE_TYPEFLAGS_GHOST	Creature are also visible for not alive player. Allow gossip interaction if npcflag allow?
4	0x0000 0004	CREATURE_TYPEFLAGS_BOSS	Changes creature's visible level to "??" in the creature's portrait - Inmune Knockback.
8	0x0000 0008	CREATURE_TYPEFLAGS_DO_NOT_PLAY_WOUND_PARRY_ANIMATION	Does not play wound animation on parry.
16	0x0000 0010	CREATURE_TYPEFLAGS_HIDE_FACTION_TOOLTIP	Hides tooltip faction.
32	0x0000 0020	CREATURE_TYPEFLAGS_UNK6
64	0x0000 0040	CREATURE_TYPEFLAGS_SPELL_ATTACKABLE	Spell attackable.
128	0x0000 0080	CREATURE_TYPEFLAGS_DEAD_INTERACT	Player can interact with the creature if its dead (not player dead)
256	0x0000 0100	CREATURE_TYPEFLAGS_HERBLOOT	Makes mob herbable
512	0x0000 0200	CREATURE_TYPEFLAGS_MININGLOOT	Makes mob minable
1024	0x0000 0400	CREATURE_TYPEFLAGS_DONT_LOG_DEATH	Does not combatlog death.
2048	0x0000 0800	CREATURE_TYPEFLAGS_MOUNTED_COMBAT	Creature can remain mounted when entering combat
4096	0x0000 1000	CREATURE_TYPEFLAGS_AID_PLAYERS	Can aid any player in combat if in range?
8192	0x0000 2000	CREATURE_TYPEFLAGS_IS_PET_BAR_USED	Is using pet bar.
16384	0x0000 4000	CREATURE_TYPEFLAGS_MASK_UID
32768	0x0000 8000	CREATURE_TYPEFLAGS_ENGINEERLOOT	Makes mob lootable by engineer
65536	0x0001 0000	CREATURE_TYPE_FLAG_EXOTIC_PET	Tamable as an exotic pet. Normal tamable flag must also be set.
131072	0x0002 0000	CREATURE_TYPEFLAGS_USE_DEFAULT_COLLISION_BOX	Collision related. (always using default collision box?)
262144	0x0004 0000	CREATURE_TYPEFLAGS_IS_SIEGE_WEAPON	Is siege weapon.
524288	0x0008 0000	CREATURE_TYPEFLAGS_PROJECTILE_COLLISION	Projectiles can collide with this creature - interacts with TARGET_DEST_TRAJ
1048576	0x0010 0000	CREATURE_TYPEFLAGS_HIDE_NAMEPLATE	Hides nameplate.
2097152	0x0020 0000	CREATURE_TYPEFLAGS_DO_NOT_PLAY_MOUNTED_ANIMATIONS	Does not play mounted animations.
4194304	0x0040 0000	CREATURE_TYPEFLAGS_IS_LINK_ALL
8388608	0x0080 0000	CREATURE_TYPEFLAGS_INTERACT_ONLY_WITH_CREATOR	Can only interact with its creator.
134217728	0x0800 0000	CREATURE_TYPEFLAGS_FORCE_GOSSIP	Allows the creature to display a single gossip option.

Ancla
lootid
lootid
lootid

The ID of the loot template ID that this creature should use to generate loots. See creature_loot_template.entry

Ancla
pickpocketloot
pickpocketloot
pickpocketloot

The ID of the pickpocketing loot template that this creature should use to generate pickpocketing loots. See pickpocketing_loot_template.entry

Ancla
skinloot
skinloot
skinloot

The ID of the skinning loot template that this creature should use to generate skinning loots. See skinning_loot_template.entry

...

Ancla

	ExperienceModifier
	ExperienceModifier

ExperienceModifier

TODO!

Ancla
RacialLeader
RacialLeader
RacialLeader

A flag with two possible values: '1' or '0' indicating whether the creature is a racial leader or not. Killing racial leaders grants 100 honor.

...

Decimal	Hexadecimal	Name	Type
flags_extra
1	0x00000001	CREATURE_FLAG_EXTRA_INSTANCE_BIND	creature kill binds instance to killer and killer's group
2	0x00000002	CREATURE_FLAG_EXTRA_CIVILIAN	creature does not aggro (ignore faction/reputation hostility)
4	0x00000004	CREATURE_FLAG_EXTRA_NO_PARRY	creature does not parry
8	0x00000008	CREATURE_FLAG_EXTRA_NO_PARRY_HASTEN	creature does not counter-attack at parry
16	0x00000010	CREATURE_FLAG_EXTRA_NO_BLOCK	creature does not block
32	0x00000020	CREATURE_FLAG_EXTRA_NO_CRUSH	creature does not do crush-attacks
64	0x00000040	CREATURE_FLAG_EXTRA_NO_XP_AT_KILL	creature kill does not give XP
128	0x00000080	CREATURE_FLAG_EXTRA_TRIGGER	creature is trigger-NPC (invisible to players only)
256	0x00000100	CREATURE_FLAG_EXTRA_NO_TAUNT	creature is immune to taunt-auras and "attack me"-effects
512	0x00000200	CREATURE_FLAG_EXTRA_NO_MOVE_FLAGS_UPDATE	creature won't update movement flags
1024	0x00000400	CREATURE_FLAG_EXTRA_GHOST_VISIBILITY	creature will be only visible for dead players
16384	0x00004000	CREATURE_FLAG_EXTRA_WORLDEVENT	custom flag for world events (left room for merging)
32768	0x00008000	CREATURE_FLAG_EXTRA_GUARD	creature is a guard (Will ignore feign death and vanish)
131072	0x00020000	CREATURE_FLAG_EXTRA_NO_CRIT	creature does not do critical strikes
262144	0x00040000	CREATURE_FLAG_EXTRA_NO_SKILLGAIN	creature won't increase weapon skills
524288	0x00080000	CREATURE_FLAG_EXTRA_TAUNT_DIMINISH	creature taunt is subject to diminishing returns
1048576	0x00100000	CREATURE_FLAG_EXTRA_ALL_DIMINISH	Creature is subject to all diminishing returns
2097152	0x00200000	CREATURE_FLAG_EXTRA_NO_PLAYER_DAMAGE_REQ	NPCs can help with killing this creature and player will still be credited if he tags the creature
268435456	0x10000000	CREATURE_FLAG_EXTRA_DUNGEON_BOSS	Creature is a dungeon boss. This flag is generically set by core during runtime. Setting this in database will give you startup error.
536870912	0x20000000	CREATURE_FLAG_EXTRA_IGNORE_PATHFINDING	Creature will ignore pathfinding. This is like disabling Mmaps, only for one creature.
1073741824	0x40000000	CREATURE_FLAG_EXTRA_IMMUNITY_KNOCKBACK	creature will immune all knockback effects

...

If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.#resistance

Versiones comparadas

Versión anterior 2

Nueva versión 3

Clave

Ancla
dmgschool
dmgschool
dmgschool

Ancla

BaseAttackTime

BaseAttackTime

BaseAttackTime

Ancla

RangeAttackTime

RangeAttackTime

RangeAttackTime

Ancla
unit_flags
unit_flags
unit_flags

Ancla
dynamicflags
dynamicflags
dynamicflags

dynamicflags

Ancla
family
family
family

Ancla
trainer_type
trainer_type
trainer_type

Ancla
trainer_spell
trainer_spell
trainer_spell

Ancla
trainer_class
trainer_class
trainer_class

Ancla
trainer_race
trainer_race
trainer_race

minrangedmg

maxrangedmg

rangedattackpower

Ancla
type
type
type

type_flags

Ancla
lootid
lootid
lootid

Ancla
pickpocketloot
pickpocketloot
pickpocketloot

Ancla
skinloot
skinloot
skinloot

Ancla
RacialLeader
RacialLeader
RacialLeader

flags_extra

Comparación de páginas

Versiones comparadas

Versión anterior 2

Nueva versión 3

Clave

Ancladmgschooldmgschooldmgschool

Ancla

BaseAttackTime

BaseAttackTime

BaseAttackTime

Ancla

RangeAttackTime

RangeAttackTime

RangeAttackTime

Anclaunit_flagsunit_flagsunit_flags

Ancladynamicflagsdynamicflagsdynamicflags

dynamicflags

Anclafamilyfamilyfamily

Anclatrainer_typetrainer_typetrainer_type

Anclatrainer_spelltrainer_spelltrainer_spell

Anclatrainer_classtrainer_classtrainer_class

Anclatrainer_racetrainer_racetrainer_race

minrangedmg

maxrangedmg

rangedattackpower

Anclatypetypetype

type_flags

Anclalootidlootidlootid

Anclapickpocketlootpickpocketlootpickpocketloot

Anclaskinlootskinlootskinloot

AnclaRacialLeaderRacialLeaderRacialLeader

flags_extra

Ancla
dmgschool
dmgschool
dmgschool

Ancla
unit_flags
unit_flags
unit_flags

Ancla
dynamicflags
dynamicflags
dynamicflags

Ancla
family
family
family

Ancla
trainer_type
trainer_type
trainer_type

Ancla
trainer_spell
trainer_spell
trainer_spell

Ancla
trainer_class
trainer_class
trainer_class

Ancla
trainer_race
trainer_race
trainer_race

Ancla
type
type
type

Ancla
lootid
lootid
lootid

Ancla
pickpocketloot
pickpocketloot
pickpocketloot

Ancla
skinloot
skinloot
skinloot

Ancla
RacialLeader
RacialLeader
RacialLeader