Creature proto

From ArcEmu-Wiki
(Difference between revisions)
Jump to: navigation, search
(Spell 1-4)
m (invisibilty_type)
 
(18 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 +
{{LanguageLinks|Creature_proto|EN}}
 +
 +
{{NeedUpdate}}
 +
 
== Description ==
 
== Description ==
  
Line 24: Line 28:
  
 
  The faction ID of the creature, from [[Faction IDs|FactionTemplate.DBC]].
 
  The faction ID of the creature, from [[Faction IDs|FactionTemplate.DBC]].
Neutral => 7
+
  Neutral => 7
Hostile => 14
+
  Hostile => 14
 
  Friendly => 35
 
  Friendly => 35
 +
Alliance => 1802
 +
    Horde => 1801
  
 
==minhealth==
 
==minhealth==
Line 51: Line 57:
 
==npcflags==
 
==npcflags==
  
  The flags of the creature. Note that most of these also require the "Gossip" [1] flag.
+
  The flags of the creature.
  UNIT_NPC_FLAG_NONE              => 0
+
Note that most of these also require the "Gossip" [1] flag to work.
UNIT_NPC_FLAG_GOSSIP             => 1
+
  So if you want a NPC that is a quest giver, a vendor and can repair you just add the specific flags together: 1 + 2 + 128 + 4096 = 4227.
UNIT_NPC_FLAG_QUESTGIVER         => 2
+
 
UNIT_NPC_FLAG_UNK1              => 4
+
{|
UNIT_NPC_FLAG_UNK2              => 8
+
! Pure Flags !! Decimal!! Binary (32 Bit)!!Remarks
UNIT_NPC_FLAG_TRAINER           => 16
+
|-
UNIT_NPC_FLAG_TRAINER_CLASS     => 32
+
| UNIT_NPC_FLAG_NONE
UNIT_NPC_FLAG_TRAINER_AND_GOSSIP => 49
+
| 0
UNIT_NPC_FLAG_TRAINER_PROF       => 64
+
| 0000 0000 0000 0000 0000 0000 0000 0000
UNIT_NPC_FLAG_VENDOR             => 128
+
|-
UNIT_NPC_VENDOR_AND_QUEST        => 131
+
| UNIT_NPC_FLAG_GOSSIP
UNIT_NPC_VENDOR_AND_TRAINER      => 177
+
| 1
UNIT_NPC_FLAG_VENDOR_AMMO       => 256
+
| 0000 0000 0000 0000 0000 0000 0000 0001
UNIT_NPC_FLAG_VENDOR_FOOD       => 512
+
| (If NPC has more gossip options, add this flag to bring up a menu.)
UNIT_NPC_FLAG_VENDOR_POISON     => 1024
+
|-
UNIT_NPC_FLAG_VENDOR_REAGENT     => 2048
+
| UNIT_NPC_FLAG_QUESTGIVER
UNIT_NPC_FLAG_ARMORER           => 4096
+
| 2
UNIT_NPC_FLAG_TAXIVENDOR         => 8192
+
| 0000 0000 0000 0000 0000 0000 0000 0010
UNIT_NPC_FLAG_SPIRITHEALER       => 16384
+
| (Any NPC giving or taking quests needs to have this flag.)
UNIT_NPC_FLAG_SPIRITGUIDE       => 32768
+
|-
UNIT_NPC_FLAG_INNKEEPER         => 65536
+
| UNIT_NPC_FLAG_UNKNOWN1
UNIT_NPC_FLAG_BANKER             => 131072
+
| 4
UNIT_NPC_FLAG_ARENACHARTER       => 262144
+
| 0000 0000 0000 0000 0000 0000 0000 0100
UNIT_NPC_FLAG_TABARDVENDOR       => 524288
+
|-
UNIT_NPC_FLAG_GUILDMASTER        => 786433
+
| UNIT_NPC_FLAG_UNKOWN2
UNIT_NPC_FLAG_BATTLEFIELDPERSON => 1048576
+
| 8
UNIT_NPC_FLAG_AUCTIONEER         => 2097152
+
| 0000 0000 0000 0000 0000 0000 0000 1000
UNIT_NPC_FLAG_STABLE             => 4194304
+
|-
UNIT_NPC_FLAG_GUILD_BANK         => 8388608
+
| UNIT_NPC_FLAG_TRAINER
UNIT_NPC_FLAG_SPELLCLICK         => 16777216
+
| 16
 +
| 0000 0000 0000 0000 0000 0000 0001 0000
 +
| (Allows the NPC to have a trainer list to teach spells, all trainers must have this flag)
 +
|-
 +
| UNIT_NPC_FLAG_TRAINER_CLASS
 +
| 32
 +
| 0000 0000 0000 0000 0000 0000 0010 0000
 +
|-
 +
| UNIT_NPC_FLAG_TRAINER_PROF
 +
| 64
 +
| 0000 0000 0000 0000 0000 0000 0100 0000
 +
|-
 +
| UNIT_NPC_FLAG_VENDOR
 +
| 128
 +
| 0000 0000 0000 0000 0000 0000 1000 0000
 +
| (Any NPC selling items needs to have this flag)
 +
|-
 +
| UNIT_NPC_FLAG_VENDOR_AMMO
 +
| 256
 +
| 0000 0000 0000 0000 0000 0001 0000 0000
 +
|-
 +
| UNIT_NPC_FLAG_VENDOR_FOOD
 +
| 512
 +
| 0000 0000 0000 0000 0000 0010 0000 0000
 +
|-
 +
| UNIT_NPC_FLAG_VENDOR_POISON
 +
| 1024
 +
| 0000 0000 0000 0000 0000 0100 0000 0000
 +
|-
 +
| UNIT_NPC_FLAG_VENDOR_REAGENT
 +
| 2048
 +
| 0000 0000 0000 0000 0000 1000 0000 0000
 +
|-
 +
| UNIT_NPC_FLAG_ARMORER
 +
| 4096
 +
| 0000 0000 0000 0000 0001 0000 0000 0000
 +
| (NPC with this flag can repair items.)
 +
|-
 +
| UNIT_NPC_FLAG_TAXIVENDOR
 +
| 8192
 +
| 0000 0000 0000 0000 0010 0000 0000 0000
 +
| (Any NPC serving as fly master has this.)
 +
|-
 +
| UNIT_NPC_FLAG_SPIRITHEALER
 +
| 16384
 +
| 0000 0000 0000 0000 0100 0000 0000 0000
 +
| (Makes the NPC invisible to alive characters and has the resurrect function.)
 +
|-
 +
| UNIT_NPC_FLAG_SPIRITGUIDE
 +
| 32768
 +
| 0000 0000 0000 0000 1000 0000 0000 0000
 +
|-
 +
| UNIT_NPC_FLAG_INNKEEPER
 +
| 65536
 +
| 0000 0000 0000 0001 0000 0000 0000 0000
 +
|(NPC with this flag can set hearthstone locations.)
 +
|-
 +
| UNIT_NPC_FLAG_BANKER
 +
| 131072
 +
| 0000 0000 0000 0010 0000 0000 0000 0000
 +
| (NPC with this flag can show the bank)
 +
|-
 +
| UNIT_NPC_FLAG_ARENACHARTER
 +
| 262144
 +
| 0000 0000 0000 0100 0000 0000 0000 0000
 +
|-
 +
| UNIT_NPC_FLAG_TABARDVENDOR
 +
| 524288
 +
| 0000 0000 0000 1000 0000 0000 0000 0000
 +
| (Allows the designing of guild tabards.)
 +
|-
 +
| UNIT_NPC_FLAG_BATTLEFIELDPERSON
 +
| 1048576
 +
| 0000 0000 0001 0000 0000 0000 0000 0000
 +
| (NPC with this flag port players to battlegrounds. Like battlemasters, arena organzier etc.)
 +
|-
 +
| UNIT_NPC_FLAG_AUCTIONEER
 +
| 2097152
 +
| 0000 0000 0010 0000 0000 0000 0000 0000
 +
| (Allows NPC to display auction list.)
 +
|-
 +
| UNIT_NPC_FLAG_STABLE
 +
| 4194304
 +
| 0000 0000 0100 0000 0000 0000 0000 0000
 +
| (Has the option to stable pets for hunters.)
 +
|-
 +
| UNIT_NPC_FLAG_GUILD_BANK
 +
| 8388608
 +
| 0000 0000 1000 0000 0000 0000 0000 0000
 +
|-
 +
| UNIT_NPC_FLAG_SPELLCLICK
 +
| 16777216
 +
| 0000 0001 0000 0000 0000 0000 0000 0000
 +
| (Needs data on npc_spellclick_spells table)
 +
|-
 +
| Mailbox
 +
| 67108864
 +
| 0000 0100 0000 0000 0000 0000 0000 0000
 +
| (NPC will act like a mailbox, opens mailbox with right-click)
 +
|-
 +
| Guard
 +
| 268435456
 +
| 0001 0000 0000 0000 0000 0000 0000 0000
 +
| (Cityguards, must be scripted)
 +
|}
 +
<br />
 +
{|
 +
! Flag Combinations !! Decimal!! Binary (32 Bit)
 +
|-
 +
| TRAINER_CLASS + TRAINER + GOSSIP
 +
| 49
 +
| 0000 0000 0000 0000 0000 0000 0011 0001
 +
|-
 +
| VENDOR + QUESTGIVER + GOSSIP
 +
| 131
 +
| 0000 0000 0000 0000 0000 0000 1000 0011
 +
|-
 +
| VENDOR + TRAINER_CLASS + TRAINER + GOSSIP
 +
| 177
 +
| 0000 0000 0000 0000 0000 0000 1011 0001
 +
|-
 +
| TABARDVENDOR + ARENACHARTER (GUILDMASTER)
 +
| 786433
 +
| 0000 0000 0000 1100 0000 0000 0000 0000
 +
|}
  
  
Line 90: Line 220:
  
 
==attacktype==
 
==attacktype==
 +
The type of damage that is dealt by the creature. Determines damage reduction via armor or resistances.
  
The type of damage that is dealt by the creature. Determines damage reduction via armor or resistances.
 
 
  SCHOOL_NORMAL => 0
 
  SCHOOL_NORMAL => 0
 
  SCHOOL_HOLY  => 1
 
  SCHOOL_HOLY  => 1
Line 99: Line 229:
 
  SCHOOL_SHADOW => 5
 
  SCHOOL_SHADOW => 5
 
  SCHOOL_ARCANE => 6
 
  SCHOOL_ARCANE => 6
 
  
 
==mindamage==
 
==mindamage==
Line 106: Line 235:
  
  
==maxdamage==
+
== maxdamage ==
 +
The maximum damage dealt by the creature.
  
The maximum damage dealt by the creature.
 
  
 +
== can_ranged ==
 +
TODO: Need description
  
==rangedattacktime==
 
  
The delay between ranged attacks, in milliseconds.
+
== rangedattacktime ==
 +
The delay between ranged attacks, in milliseconds.
  
  
 
==rangedmindamage==
 
==rangedmindamage==
 
+
The minimum ranged damage dealt by the creature.
The minimum ranged damage dealt by the creature.
+
  
  
 
==rangedmaxdamage==
 
==rangedmaxdamage==
 
+
The maximum damage dealt by the creature.
The maximum damage dealt by the creature.
+
  
  
 
==respawntime==
 
==respawntime==
 
+
The time before the creature respawns, in milliseconds.
The time before the creature respawns, in milliseconds.
+
  
  
 
==armor==
 
==armor==
 
+
The total armor of the creature.
The total armor of the creature.
+
  
  
 
==resistance1==
 
==resistance1==
 
+
The Holy resistance of the creature.
The Holy resistance of the creature.
+
  
  
 
==resistance2==
 
==resistance2==
 
+
The Fire resistance of the creature.
The Fire resistance of the creature.
+
  
  
 
==resistance3==
 
==resistance3==
 
+
The Nature resistance of the creature.
The Nature resistance of the creature.
+
  
  
 
==resistance4==
 
==resistance4==
 
+
The Frost resistance of the creature.
The Frost resistance of the creature.
+
  
  
 
==resistance5==
 
==resistance5==
 
+
The Shadow resistance of the creature.
The Shadow resistance of the creature.
+
  
  
 
==resistance6==
 
==resistance6==
 
+
The Arcane resistance of the creature.
The Arcane resistance of the creature.
+
  
  
 
==combat_reach==
 
==combat_reach==
 
+
The distance of where the creature can hit it's target.
The distance of where the creature can hit it's target.
+
  
  
 
==bounding_radius==
 
==bounding_radius==
 
+
The amount of yards before the creature will reset.
The amount of yards before the creature will reset.
+
  
  
 
==auras==
 
==auras==
 
+
The Spell IDs of auras that are present on the creature. IDs separated with a comma (,).
The Spell IDs of auras that are present on the creature. IDs separated with a comma (,).
+
  
  
 
==boss==
 
==boss==
 +
Indicates whether or not the creature is a boss.
  
Indicates whether or not the creature is a boss.
 
 
  Normal => 0
 
  Normal => 0
 
  Boss  => 1
 
  Boss  => 1
Line 189: Line 307:
  
 
==money==
 
==money==
 
+
The money dropped by the creature in copper (1000 = 10s, 100000 = 1g, 111111 = 11g 11s 11c)
The money dropped by the creature in copper (1000 = 10s, 100000 = 1g, 111111 = 11g 11s 11c)
+
  
  
 
==invisibilty_type==
 
==invisibilty_type==
 +
The invisibility type of the creature.
 +
You can see those in special cases, like while you are drunk you can see ghosts etc. or in some quests. (Found in Unit.h)
  
The invisibility type of the creature.
 
 
  INVIS_FLAG_NORMAL      => 0
 
  INVIS_FLAG_NORMAL      => 0
 
  INVIS_FLAG_SPIRIT1    => 1
 
  INVIS_FLAG_SPIRIT1    => 1
Line 206: Line 324:
 
  INVIS_FLAG_SHADOWMOON  => 8
 
  INVIS_FLAG_SHADOWMOON  => 8
 
  INVIS_FLAG_NETHERSTORM => 9
 
  INVIS_FLAG_NETHERSTORM => 9
  INVIS_FLAG_TOTA        => 10
+
  INVIS_FLAG_BASHIR      => 10
 
+
INVIS_FLAG_UNKNOWN8    => 11
 +
INVIS_FLAG_TOTAL      => 12
  
 
==death_state==
 
==death_state==
 +
Whether the creature is alive, a corpse, or completely gone from the world.
  
Whether the creature is alive, a corpse, or completely gone from the world.
 
 
  ALIVE => 0
 
  ALIVE => 0
 
  JUST_DIED => 1
 
  JUST_DIED => 1
Line 219: Line 338:
  
 
==walk_speed==
 
==walk_speed==
 
+
The speed of the creature when it is walking. Default: 2.5.
The speed of the creature when it is walking. Default: 2.5.
+
  
  
 
==run_speed==
 
==run_speed==
 
+
The speed of the creature when it is running. Default: 8.
The speed of the creature when it is running. Default: 8.
+
  
  
 
==fly_speed==
 
==fly_speed==
 
+
The speed of the creature when it is flying. Default: 14.
The speed of the creature when it is flying. Default: 14.
+
  
  
 
==extra_a9_flags==
 
==extra_a9_flags==
 +
Contains extra information for A9 flags.
  
Contains extra information for A9 flags.
 
  
==Spell 1-4==
+
==Spell 1-8==
 
+
The spells that are available to the creature. These are the spells that used when the creature is a Totem, or Pet, Vehicle or
The spells that are available to the creature. These are the spells that used when the creature is a Totem, or Pet, or when possessed (mind control) too.
+
when possessed (mind control) too.
  
 
==Spell_Flags==
 
==Spell_Flags==
 +
The flags for the spells in Spell1-4
  
The flags for the spells in Spell1-4
 
 
  RANDOM_CAST  => 1
 
  RANDOM_CAST  => 1
 
  OUT_OF_COMBAT => 2
 
  OUT_OF_COMBAT => 2
Line 250: Line 366:
  
 
==modImmunities==
 
==modImmunities==
 
+
Whether or not the creature is immune to Stuns, Fears, etc. They are flags, and can be added together.
Whether or not the creature is immune to Stuns, Fears, etc. They are flags, and can be added together.
+
   
  Charm (Mind Control, enslave demon): 1
+
  Charm (Mind Control, enslave demon) => 1
Confuse (Blind etc): 2
+
                  Confuse (Blind etc) => 2
Fear: 4
+
                                  Fear => 4
Root: 8
+
                                  Root => 8
Silence : 16
+
                              Silence => 16
Stun: 32
+
                                  Stun => 32
Sheep: 64
+
                                Sheep => 64
Banish: 128
+
                                Banish => 128
Sap: 256
+
                                  Sap => 256
Frozen : 512
+
                                Frozen => 512
Ensnared 1024
+
                              Ensnared => 1024
Sleep 2048
+
                                Sleep => 2048
Taunt (aura): 4096
+
                          Taunt (aura) => 4096
Decrease Speed (Hamstring) (aura): 8192
+
    Decrease Speed (Hamstring) (aura) => 8192
  Spell Haste (Curse of Tongues) (aura): 16384
+
  Spell Haste (Curse of Tongues) (aura) => 16384
Interrupt Cast: 32768
+
                        Interrupt Cast => 32768
Mod Healing % (Mortal Strike) (aura): 65536
+
  Mod Healing % (Mortal Strike) (aura) => 65536
Total Stats % (Vindication) (aura): 131072
+
    Total Stats % (Vindication) (aura) => 131072
 
+
  
 
==isTrainingDummy==
 
==isTrainingDummy==
 
+
Whether or not the creature is a "Training Dummy". Training dummy's are not killable and cannot move.
Whether or not the creature is a "Training Dummy". Training dummy's are not killable and cannot move.
+
  
  
 
==guardtype==
 
==guardtype==
 
+
The type of guard the creature is. Most city guards, bruisers and peace keepers has '2' here.
The type of guard the creature is. Unknown (?)
+
  
  
 
==summonguard==
 
==summonguard==
 +
The guard that is summoned. Unknown (?)
  
The guard that is summoned. Unknown (?)
 
  
 +
==spelldataid==
 +
Reference to the index of CreatureSpellData.dbc. Basically this is another source for getting spells for the creature.
  
==spelldataid==
 
  
Reference to the index of CreatureSpellData.dbc. Basically this is another source for getting spells for the creature.
+
==vehicleid==
 +
Vehicle data for this creature. Index of Vehicle.dbc
 +
 
 +
==rooted==
 +
When it is set to 1, the creature will be unable to move.
  
 
== SQL Structure ==
 
== SQL Structure ==
Line 330: Line 448:
 
   `fly_speed` float NOT NULL DEFAULT '14',
 
   `fly_speed` float NOT NULL DEFAULT '14',
 
   `extra_a9_flags` int(30) NOT NULL DEFAULT '0',
 
   `extra_a9_flags` int(30) NOT NULL DEFAULT '0',
   `spell1` int(30) NOT NULL DEFAULT '0',
+
   `spell1` int(30) unsigned NOT NULL DEFAULT '0',
   `spell2` int(30) NOT NULL DEFAULT '0',
+
   `spell2` int(30) unsigned NOT NULL DEFAULT '0',
   `spell3` int(30) NOT NULL DEFAULT '0',
+
   `spell3` int(30) unsigned NOT NULL DEFAULT '0',
   `spell4` int(30) NOT NULL DEFAULT '0',
+
   `spell4` int(30) unsigned NOT NULL DEFAULT '0',
 +
  `spell5` int(30) unsigned NOT NULL DEFAULT '0',
 +
  `spell6` int(30) unsigned NOT NULL DEFAULT '0',
 +
  `spell7` int(30) unsigned NOT NULL DEFAULT '0',
 +
  `spell8` int(30) unsigned NOT NULL DEFAULT '0',
 
   `spell_flags` int(30) NOT NULL DEFAULT '0',
 
   `spell_flags` int(30) NOT NULL DEFAULT '0',
 
   `modImmunities` int(30) unsigned NOT NULL DEFAULT '0',
 
   `modImmunities` int(30) unsigned NOT NULL DEFAULT '0',
Line 340: Line 462:
 
   `summonguard` int(10) unsigned NOT NULL DEFAULT '0',
 
   `summonguard` int(10) unsigned NOT NULL DEFAULT '0',
 
   `spelldataid` INT UNSIGNED DEFAULT '0' NOT NULL,
 
   `spelldataid` INT UNSIGNED DEFAULT '0' NOT NULL,
 +
  `vehicleid` int(30) unsigned NOT NULL DEFAULT '0',
 +
  `rooted` int(30) unsigned NOT NULL DEFAULT '0',
 
   PRIMARY KEY (`entry`)
 
   PRIMARY KEY (`entry`)
 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Creature System';
 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Creature System';

Latest revision as of 03:17, 12 May 2013

+/-
Main Page                   Other languages:   English  •   German   •   FrenchArcEmu Website     ArcEmu Forum     Bug Tracker


Ico maintenance.png Some of the content of this wikipage is not up to date and need some maintenance. Please help to improve this page and do some update.


Description

This table contains the other half of creature information. Combined with Creature_names this table completes names and lots of number values. It is recommended to generate this with a program because of the size of the query required.


Contents



entry

The entry ID of the creature, must be the same as in creature_names.


minlevel

The minimum level of the creature when it is spawned in-game.


maxlevel

The maximum level of the creature when it is spawned in-game. Must be higher than minlevel!


faction

The faction ID of the creature, from FactionTemplate.DBC.
 Neutral => 7
 Hostile => 14
Friendly => 35
Alliance => 1802
   Horde => 1801

minhealth

The minimum health of the creature.


maxhealth

The maximum health of the creature.


mana

The maximum mana of the creature.


scale

The scale/size of the creature.
Normal => 1 (100%)


npcflags

The flags of the creature.
Note that most of these also require the "Gossip" [1] flag to work.
So if you want a NPC that is a quest giver, a vendor and can repair you just add the specific flags together: 1 + 2 + 128 + 4096 = 4227. 
Pure Flags Decimal Binary (32 Bit) Remarks
UNIT_NPC_FLAG_NONE 0 0000 0000 0000 0000 0000 0000 0000 0000
UNIT_NPC_FLAG_GOSSIP 1 0000 0000 0000 0000 0000 0000 0000 0001 (If NPC has more gossip options, add this flag to bring up a menu.)
UNIT_NPC_FLAG_QUESTGIVER 2 0000 0000 0000 0000 0000 0000 0000 0010 (Any NPC giving or taking quests needs to have this flag.)
UNIT_NPC_FLAG_UNKNOWN1 4 0000 0000 0000 0000 0000 0000 0000 0100
UNIT_NPC_FLAG_UNKOWN2 8 0000 0000 0000 0000 0000 0000 0000 1000
UNIT_NPC_FLAG_TRAINER 16 0000 0000 0000 0000 0000 0000 0001 0000 (Allows the NPC to have a trainer list to teach spells, all trainers must have this flag)
UNIT_NPC_FLAG_TRAINER_CLASS 32 0000 0000 0000 0000 0000 0000 0010 0000
UNIT_NPC_FLAG_TRAINER_PROF 64 0000 0000 0000 0000 0000 0000 0100 0000
UNIT_NPC_FLAG_VENDOR 128 0000 0000 0000 0000 0000 0000 1000 0000 (Any NPC selling items needs to have this flag)
UNIT_NPC_FLAG_VENDOR_AMMO 256 0000 0000 0000 0000 0000 0001 0000 0000
UNIT_NPC_FLAG_VENDOR_FOOD 512 0000 0000 0000 0000 0000 0010 0000 0000
UNIT_NPC_FLAG_VENDOR_POISON 1024 0000 0000 0000 0000 0000 0100 0000 0000
UNIT_NPC_FLAG_VENDOR_REAGENT 2048 0000 0000 0000 0000 0000 1000 0000 0000
UNIT_NPC_FLAG_ARMORER 4096 0000 0000 0000 0000 0001 0000 0000 0000 (NPC with this flag can repair items.)
UNIT_NPC_FLAG_TAXIVENDOR 8192 0000 0000 0000 0000 0010 0000 0000 0000 (Any NPC serving as fly master has this.)
UNIT_NPC_FLAG_SPIRITHEALER 16384 0000 0000 0000 0000 0100 0000 0000 0000 (Makes the NPC invisible to alive characters and has the resurrect function.)
UNIT_NPC_FLAG_SPIRITGUIDE 32768 0000 0000 0000 0000 1000 0000 0000 0000
UNIT_NPC_FLAG_INNKEEPER 65536 0000 0000 0000 0001 0000 0000 0000 0000 (NPC with this flag can set hearthstone locations.)
UNIT_NPC_FLAG_BANKER 131072 0000 0000 0000 0010 0000 0000 0000 0000 (NPC with this flag can show the bank)
UNIT_NPC_FLAG_ARENACHARTER 262144 0000 0000 0000 0100 0000 0000 0000 0000
UNIT_NPC_FLAG_TABARDVENDOR 524288 0000 0000 0000 1000 0000 0000 0000 0000 (Allows the designing of guild tabards.)
UNIT_NPC_FLAG_BATTLEFIELDPERSON 1048576 0000 0000 0001 0000 0000 0000 0000 0000 (NPC with this flag port players to battlegrounds. Like battlemasters, arena organzier etc.)
UNIT_NPC_FLAG_AUCTIONEER 2097152 0000 0000 0010 0000 0000 0000 0000 0000 (Allows NPC to display auction list.)
UNIT_NPC_FLAG_STABLE 4194304 0000 0000 0100 0000 0000 0000 0000 0000 (Has the option to stable pets for hunters.)
UNIT_NPC_FLAG_GUILD_BANK 8388608 0000 0000 1000 0000 0000 0000 0000 0000
UNIT_NPC_FLAG_SPELLCLICK 16777216 0000 0001 0000 0000 0000 0000 0000 0000 (Needs data on npc_spellclick_spells table)
Mailbox 67108864 0000 0100 0000 0000 0000 0000 0000 0000 (NPC will act like a mailbox, opens mailbox with right-click)
Guard 268435456 0001 0000 0000 0000 0000 0000 0000 0000 (Cityguards, must be scripted)


Flag Combinations Decimal Binary (32 Bit)
TRAINER_CLASS + TRAINER + GOSSIP 49 0000 0000 0000 0000 0000 0000 0011 0001
VENDOR + QUESTGIVER + GOSSIP 131 0000 0000 0000 0000 0000 0000 1000 0011
VENDOR + TRAINER_CLASS + TRAINER + GOSSIP 177 0000 0000 0000 0000 0000 0000 1011 0001
TABARDVENDOR + ARENACHARTER (GUILDMASTER) 786433 0000 0000 0000 1100 0000 0000 0000 0000


attacktime

The delay between attacks, in milliseconds.


attacktype

The type of damage that is dealt by the creature. Determines damage reduction via armor or resistances.

SCHOOL_NORMAL => 0
SCHOOL_HOLY   => 1
SCHOOL_FIRE   => 2
SCHOOL_NATURE => 3
SCHOOL_FROST  => 4
SCHOOL_SHADOW => 5
SCHOOL_ARCANE => 6

mindamage

The minimum damage dealt by the creature.


maxdamage

The maximum damage dealt by the creature.


can_ranged

TODO: Need description


rangedattacktime

The delay between ranged attacks, in milliseconds.


rangedmindamage

The minimum ranged damage dealt by the creature.


rangedmaxdamage

The maximum damage dealt by the creature.


respawntime

The time before the creature respawns, in milliseconds.


armor

The total armor of the creature.


resistance1

The Holy resistance of the creature.


resistance2

The Fire resistance of the creature.


resistance3

The Nature resistance of the creature.


resistance4

The Frost resistance of the creature.


resistance5

The Shadow resistance of the creature.


resistance6

The Arcane resistance of the creature.


combat_reach

The distance of where the creature can hit it's target.


bounding_radius

The amount of yards before the creature will reset.


auras

The Spell IDs of auras that are present on the creature. IDs separated with a comma (,).


boss

Indicates whether or not the creature is a boss.

Normal => 0
Boss   => 1


money

The money dropped by the creature in copper (1000 = 10s, 100000 = 1g, 111111 = 11g 11s 11c)


invisibilty_type

The invisibility type of the creature. You can see those in special cases, like while you are drunk you can see ghosts etc. or in some quests. (Found in Unit.h)

INVIS_FLAG_NORMAL      => 0
INVIS_FLAG_SPIRIT1     => 1
INVIS_FLAG_SPIRIT2     => 2
INVIS_FLAG_TRAP        => 3
INVIS_FLAG_QUEST       => 4
INVIS_FLAG_GHOST       => 5
INVIS_FLAG_UNKNOWN6    => 6
INVIS_FLAG_UNKNOWN7    => 7
INVIS_FLAG_SHADOWMOON  => 8
INVIS_FLAG_NETHERSTORM => 9
INVIS_FLAG_BASHIR      => 10
INVIS_FLAG_UNKNOWN8    => 11
INVIS_FLAG_TOTAL       => 12

death_state

Whether the creature is alive, a corpse, or completely gone from the world.

ALIVE => 0
JUST_DIED => 1
CORPSE => 2
DEAD => 3


walk_speed

The speed of the creature when it is walking. Default: 2.5.


run_speed

The speed of the creature when it is running. Default: 8.


fly_speed

The speed of the creature when it is flying. Default: 14.


extra_a9_flags

Contains extra information for A9 flags.


Spell 1-8

The spells that are available to the creature. These are the spells that used when the creature is a Totem, or Pet, Vehicle or when possessed (mind control) too.

Spell_Flags

The flags for the spells in Spell1-4

RANDOM_CAST   => 1
OUT_OF_COMBAT => 2
COOLDOWN_HALF => 4 (Sets cooldown to 1.5)


modImmunities

Whether or not the creature is immune to Stuns, Fears, etc. They are flags, and can be added together.

  Charm (Mind Control, enslave demon) => 1
                  Confuse (Blind etc) => 2
                                 Fear => 4
                                 Root => 8
                              Silence => 16
                                 Stun => 32
                                Sheep => 64
                               Banish => 128
                                  Sap => 256
                               Frozen => 512
                             Ensnared => 1024
                                Sleep => 2048
                         Taunt (aura) => 4096
    Decrease Speed (Hamstring) (aura) => 8192
Spell Haste (Curse of Tongues) (aura) => 16384
                       Interrupt Cast => 32768
 Mod Healing % (Mortal Strike) (aura) => 65536
   Total Stats % (Vindication) (aura) => 131072

isTrainingDummy

Whether or not the creature is a "Training Dummy". Training dummy's are not killable and cannot move.


guardtype

The type of guard the creature is. Most city guards, bruisers and peace keepers has '2' here.


summonguard

The guard that is summoned. Unknown (?)


spelldataid

Reference to the index of CreatureSpellData.dbc. Basically this is another source for getting spells for the creature.


vehicleid

Vehicle data for this creature. Index of Vehicle.dbc

rooted

When it is set to 1, the creature will be unable to move.

SQL Structure

CREATE TABLE `creature_proto` (
  `entry` int(30) unsigned NOT NULL DEFAULT '0',
  `minlevel` int(30) unsigned NOT NULL,
  `maxlevel` int(30) unsigned NOT NULL,
  `faction` int(30) unsigned NOT NULL DEFAULT '0',
  `minhealth` int(30) unsigned NOT NULL,
  `maxhealth` int(30) unsigned NOT NULL,
  `mana` int(30) unsigned NOT NULL DEFAULT '0',
  `scale` float NOT NULL DEFAULT '0',
  `npcflags` int(30) unsigned NOT NULL DEFAULT '0',
  `attacktime` int(30) unsigned NOT NULL DEFAULT '0',
  `attacktype` int(4) NOT NULL DEFAULT '0',
  `mindamage` float NOT NULL DEFAULT '0',
  `maxdamage` float NOT NULL DEFAULT '0',
  `can_ranged` int(11) unsigned NOT NULL DEFAULT '0',
  `rangedattacktime` int(30) unsigned NOT NULL DEFAULT '0',
  `rangedmindamage` float unsigned NOT NULL DEFAULT '0',
  `rangedmaxdamage` float unsigned NOT NULL DEFAULT '0',
  `respawntime` int(30) unsigned NOT NULL DEFAULT '0',
  `armor` int(30) unsigned NOT NULL DEFAULT '0',
  `resistance1` int(30) unsigned NOT NULL DEFAULT '0',
  `resistance2` int(30) unsigned NOT NULL DEFAULT '0',
  `resistance3` int(30) unsigned NOT NULL DEFAULT '0',
  `resistance4` int(30) unsigned NOT NULL DEFAULT '0',
  `resistance5` int(30) unsigned NOT NULL DEFAULT '0',
  `resistance6` int(30) unsigned NOT NULL DEFAULT '0',
  `combat_reach` float NOT NULL DEFAULT '0',
  `bounding_radius` float NOT NULL DEFAULT '0',
  `auras` longtext NOT NULL,
  `boss` int(11) unsigned NOT NULL DEFAULT '0',
  `money` int(30) NOT NULL DEFAULT '0',
  `invisibility_type` int(30) unsigned NOT NULL,
  `walk_speed` float NOT NULL DEFAULT '2.5',
  `run_speed` float NOT NULL DEFAULT '8',
  `fly_speed` float NOT NULL DEFAULT '14',
  `extra_a9_flags` int(30) NOT NULL DEFAULT '0',
  `spell1` int(30) unsigned NOT NULL DEFAULT '0',
  `spell2` int(30) unsigned NOT NULL DEFAULT '0',
  `spell3` int(30) unsigned NOT NULL DEFAULT '0',
  `spell4` int(30) unsigned NOT NULL DEFAULT '0',
  `spell5` int(30) unsigned NOT NULL DEFAULT '0',
  `spell6` int(30) unsigned NOT NULL DEFAULT '0',
  `spell7` int(30) unsigned NOT NULL DEFAULT '0',
  `spell8` int(30) unsigned NOT NULL DEFAULT '0',
  `spell_flags` int(30) NOT NULL DEFAULT '0',
  `modImmunities` int(30) unsigned NOT NULL DEFAULT '0',
  `isTrainingDummy` int(10) unsigned NOT NULL DEFAULT '0',
  `guardtype` int(10) unsigned NOT NULL DEFAULT '0',
  `summonguard` int(10) unsigned NOT NULL DEFAULT '0',
  `spelldataid` INT UNSIGNED DEFAULT '0' NOT NULL,
  `vehicleid` int(30) unsigned NOT NULL DEFAULT '0',
  `rooted` int(30) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Creature System';

Personal tools