Character pet SF

From Project Skyfire
Jump to navigation Jump to search

Back to characters database list of tables.

The `character_pet` table

This table holds the pet data for each pet summoned by anyone in the game.


Field Type Attributes Key Null Default Extra Comment
id int(10) unsigned PRI NO 0
entry int(10) unsigned NO 0
owner int(10) unsigned NO 0
modelid int(10) unsigned YES 0
CreatedBySpell mediumint(8) unsigned NO 0
PetType tinyint(3) unsigned NO 0
level smallint(5) unsigned NO 1
exp int(10) unsigned NO 0
Reactstate tinyint(3) unsigned NO 0
name varchar(21) signed NO Pet
renamed tinyint(3) unsigned NO 0
slot tinyint(3) unsigned NO 0
curhealth int(10) unsigned NO 1
curmana int(10) unsigned NO 0
curhappiness int(10) unsigned NO 0
savetime int(10) unsigned NO 0
resettalents_cost int(10) unsigned NO 0
resettalents_time int(10) unsigned NO 0
abdata text signed YES NULL

Description of the fields


The special pet ID. This is a unique identifier among all pets.


The creature entry of this pet. See creature_template.entry


The GUID of the pet's owner. See characters.guid


The model ID to use to display the pet.


The ID of the spell that has created this pet. For hunters, this is usually the Tame Beast spell. For warlocks or other classes (mages), it is the spell ID that summoned the creature. See Spell.dbc column 1


The type of pet that this is. 0 = summoned pet, 1 = tamed pet


The current level of the pet.


The current experience that this pet has. For summoned pets, this field is always 0.


The current reaction state of the pet (passive, aggressive, etc).


The pet's name.


Boolean 1 or 0. 1 = Pet has been renamed, 0 = Pet has never been renamed and still uses the same name as the creature that was tamed.


The pet slot that the pet is in. The slot is 0 for the active pet, which is with the player; 1-4 for pets in stable (slot 1-4) 100 for a pet which is with the player but currently dismissed.


The current pet health at the time it was saved to DB.


The current pet mana at the time it was saved to DB.


The current pet happiness.


The time when the pet was last saved, in Unix time.


The cost for the character to reset pet's talents, measured in copper.


The date when the talents were reset, in Unix time.


This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.