Creature template
Ir a la navegación
Ir a la búsqueda
La tabla `creature_template`
Esta tabla contiene la información básica de las criaturas. Si no hay datos aquí, la criatura no existe.
Estructura
| Field | Type | Attributes | Key | Null | Default | Extra | Comment | |
|---|---|---|---|---|---|---|---|---|
| Entry | mediumint(8) | unsigned | PRI | NO | 700000 | |||
| 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(11) | unsigned | NO | 0 | ||||
| KillCredit2 | int(11) | unsigned | NO | 0 | ||||
| modelid1 | mediumint(8) | unsigned | NO | 3167 | ||||
| modelid2 | mediumint(8) | unsigned | NO | 5446 | ||||
| modelid3 | mediumint(8) | unsigned | PRI | NO | 0 | |||
| modelid4 | mediumint(8) | unsigned | PRI | NO | 0 | |||
| name | char(100) | signed | NO | Timeless | ||||
| subname | char(100) | signed | YES | NULL | ||||
| Iconname | char(100) | signed | NO | Timeless | ||||
| goship_menu_id | mediumint(8) | signed | YES | 0 | ||||
| minlevel | tinyint(3) | unsigned | NO | 100 | ||||
| maxlevel | tinyint(3) | unsigned | NO | 1 | ||||
| exp | smallint(2) | signed | NO | 0 | ||||
| faction_A | smallint(5) | signed | NO | 35 | ||||
| faction_H | smallint(5) | signed | NO | 0 | ||||
| npcflag | int(10) | signed | NO | 1 | ||||
| speed_walk | float | signed | NO | 1 | Result of 2.5/2.5, most common value | |||
| speed_run | float | signed | NO | 1.14286 | Result of 8.0/7.0, most common value | |||
| scale | float | signed | NO | 1.5 | ||||
| rank | tinyint(3) | unsigned | NO | 1 | ||||
| mindmg | float | signed | NO | 0 | ||||
| maxdmg | float | signed | NO | 0 | ||||
| dmgschool | tinyint(4) | signed | NO | 0 | ||||
| attackpower | int(10) | unsigned | NO | 0 | ||||
| dmg_multiplier | float | signed | NO | 1 | ||||
| baseattacktime | int(10) | unsigned | NO | 2000 | ||||
| rangeattacktime | int(10) | unsigned | NO | 1000 | ||||
| unit_class | tinyint(3) | unsigned | NO | 1 | ||||
| unit_flag | int(10) | unsigned | NO | 0 | ||||
| unit_flag2 | int(10) | unsigned | NO | 0 | ||||
| dynamicflags | int(10) | unsigned | NO | 0 | ||||
| family | tinyint(4) | signed | NO | 0 | ||||
| trainer_type | tinyint(4) | signed | NO | 0 | ||||
| trainer_spell | mediumint(8) | unsigned | NO | 0 | ||||
| trainer_class | tinyint(3) | unsigned | NO | 0 | ||||
| trainer_race | tinyint(3) | unsigned | NO | 0 | ||||
| minrangedmg | float | signed | NO | 0 | ||||
| maxrangedmg | float | signed | NO | 0 | ||||
| rangedattackpower | smallint(5) | unsigned | NO | 0 | ||||
| type | tinyint(3) | unsigned | NO | 7 | ||||
| type | tinyint(3) | unsigned | NO | 7 | ||||
| type_flag | 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(5) | signed | NO | 200 | ||||
| resistance2 | smallint(5) | signed | NO | 200 | ||||
| resistance3 | smallint(5) | signed | NO | 200 | ||||
| resistance4 | smallint(5) | signed | NO | 200 | ||||
| resistance5 | smallint(5) | signed | NO | 200 | ||||
| resistance6 | smallint(5) | signed | NO | 200 | ||||
| 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 | 100000 | ||||
| maxgold | mediumint(8) | unsigned | NO | 100000 | ||||
| AIName | char(64) | signed | NO | * | ||||
| MovementType | tinyint(3) | unsigned | NO | 0 | ||||
| InhabitType | tinyint(3) | unsigned | NO | 3 | ||||
| HoverHeight | float | signed | NO | 0 | ||||
| Health_mod | float | signed | NO | 100000 | ||||
| Mana_mod | float | signed | NO | 100000 | ||||
| Armor_mod | float | signed | NO | 100000 | ||||
| RacialLeader | tinyint(3) | unsigned | NO | 0 | ||||
| Questitem1 | int(11) | unsigned | NO | 0 | ||||
| Questitem2 | int(11) | unsigned | NO | 0 | ||||
| Questitem3 | int(11) | unsigned | NO | 0 | ||||
| Questitem4 | int(11) | unsigned | NO | 0 | ||||
| Questitem5 | int(11) | unsigned | NO | 0 | ||||
| Questitem6 | int(11) | 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) | signed | NO | * | ||||
| WDBVerified | smallint(5) | signed | YES | 1 |