Creature names

From ArcEmu-Wiki
Jump to: navigation, search

Description

This in combination with Creature_proto stores all data on creatures until they are spawned.


Contents



entry

The Entry ID of the creature. Used to reference records of this table and to spawn creature in game. 
Must be the same as this creature's creature_proto entry.


name

The name of the creature.


subname

The subname/title of the creature. Displayed in-game below the name, in <>'s.


info_str

The MouseFlags (when you hover over the npc).

WhyDB flags used:

PVP 
Quest
Repair
Point
Speak
Summon 1 -- ??
Summmon 2 -- ??
taxi
Trainer
vehichleCursor
Gunner
Directions
Buy
Attack
alarm bot 1 -- ??
The "scream" -- ??
LootAll

Flags1

 1    => Makes the mob tamable. Must be type "Beast" [1] and "family" set.
 2    => This creature can be seen also when player is as spirit.
 108  => This is boss flags (This makes the creature's level fixed to be harder to hit (approx 3 levels) if ArcEmu has this implemented correctly)
 256  => Makes mob herb-able.
 512  => Makes mob mine-able.
 2048 => Creature will fight mounted if has mount.
32768 => Engineer can loot this npc.
65536 => Exotic pet

type

The type of creature it is.

0  => None
1  => Beast
2  => Dragonkin
3  => Demon
4  => Elemental
5  => Giant
6  => Undead
7  => Humanoid
8  => Critter
9  => Mechanical
10 => Not specified
11 => Totem
12 => Non-combat Pet
13 => Gas Cloud

family

The family of the creature.

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

rank

The rank of the mob.

0 => Normal
1 => Elite
2 => Rare-Elite
3 => World Boss
4 => Boss

killcredit1-2

male_displayid1-2

The Display/Model ID of the creature. If more than 1 filled, randomly picks between them on creature spawn.


female_displayid1-2

The Display/Model ID of the creature. If more than 1 filled, randomly picks between them on creature spawn.


unknown_float1-2

HP and mana regen rate modifier, not used in ArcEmu.


Civilian

If this is one this creature will call city/zone guards when threatened.


Leader

Whether or not the creature is a leader of a group/faction. An example would be Thrall or King Varian Wrynn.

0 => Non-Leader
1 => Leader

Questitem1-6

Waypointid

SQL Structure

CREATE TABLE `creature_names` (
  `entry` int(10) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL,
  `subname` varchar(100) NOT NULL,
  `info_str` varchar(500) NOT NULL,
  `flags1` int(10) unsigned NOT NULL default '0',
  `type` int(10) unsigned NOT NULL default '0',
  `family` int(10) unsigned NOT NULL default '0',
  `rank` int(10) unsigned NOT NULL default '0',
  `killcredit1` int(10) unsigned NOT NULL default '0',
  `killcredit2` int(10) unsigned NOT NULL default '0',
  `male_displayid` int(30) unsigned NOT NULL default '0',
  `female_displayid` int(30) unsigned NOT NULL default '0',
  `male_displayid2` int(30) unsigned NOT NULL default '0',
  `female_displayid2` int(30) unsigned NOT NULL default '0',
  `unknown_float1` float NOT NULL default '1',
  `unknown_float2` float NOT NULL default '1',
  `leader` tinyint(3) unsigned NOT NULL default '0',
  `questitem1` int(11) unsigned NOT NULL default '0',
  `questitem2` int(11) unsigned NOT NULL default '0',
  `questitem3` int(11) unsigned NOT NULL default '0',
  `questitem4` int(11) unsigned NOT NULL default '0',
  `questitem5` int(11) unsigned NOT NULL default '0',
  `questitem6` int(11) unsigned NOT NULL default '0',
  `waypointid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Creature System';
Personal tools