Creature proto

From ArcEmu-Wiki
(Difference between revisions)
Jump to: navigation, search
(summonguard)
(Spell 1-4)
Line 239: Line 239:
 
==Spell 1-4==
 
==Spell 1-4==
  
  The spells that are available to the creature. These are the spells that used when the creature is a Totem, or when possessed too.
+
  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.
  
 
==Spell_Flags==
 
==Spell_Flags==

Revision as of 04:00, 31 July 2011

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

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.
UNIT_NPC_FLAG_NONE               => 0
UNIT_NPC_FLAG_GOSSIP             => 1
UNIT_NPC_FLAG_QUESTGIVER         => 2
UNIT_NPC_FLAG_UNK1               => 4
UNIT_NPC_FLAG_UNK2               => 8
UNIT_NPC_FLAG_TRAINER            => 16
UNIT_NPC_FLAG_TRAINER_CLASS      => 32
UNIT_NPC_FLAG_TRAINER_AND_GOSSIP => 49
UNIT_NPC_FLAG_TRAINER_PROF       => 64
UNIT_NPC_FLAG_VENDOR             => 128
UNIT_NPC_VENDOR_AND_QUEST        => 131
UNIT_NPC_VENDOR_AND_TRAINER      => 177
UNIT_NPC_FLAG_VENDOR_AMMO        => 256
UNIT_NPC_FLAG_VENDOR_FOOD        => 512
UNIT_NPC_FLAG_VENDOR_POISON      => 1024
UNIT_NPC_FLAG_VENDOR_REAGENT     => 2048
UNIT_NPC_FLAG_ARMORER            => 4096
UNIT_NPC_FLAG_TAXIVENDOR         => 8192
UNIT_NPC_FLAG_SPIRITHEALER       => 16384
UNIT_NPC_FLAG_SPIRITGUIDE        => 32768
UNIT_NPC_FLAG_INNKEEPER          => 65536
UNIT_NPC_FLAG_BANKER             => 131072
UNIT_NPC_FLAG_ARENACHARTER       => 262144
UNIT_NPC_FLAG_TABARDVENDOR       => 524288
UNIT_NPC_FLAG_GUILDMASTER        => 786433
UNIT_NPC_FLAG_BATTLEFIELDPERSON  => 1048576
UNIT_NPC_FLAG_AUCTIONEER         => 2097152
UNIT_NPC_FLAG_STABLE             => 4194304
UNIT_NPC_FLAG_GUILD_BANK         => 8388608
UNIT_NPC_FLAG_SPELLCLICK         => 16777216


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.


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. 
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_TOTA        => 10


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-4

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.

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. Unknown (?)


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.

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) NOT NULL DEFAULT '0',
  `spell2` int(30) NOT NULL DEFAULT '0',
  `spell3` int(30) NOT NULL DEFAULT '0',
  `spell4` int(30) 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,
  PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Creature System';

Personal tools