playerpets
This table contains the information for the player saved pets.
Structure
| Field | Type | Default | Comment |
|---|---|---|---|
| ownerguid | bigint(20) | 0 | |
| petnumber | tinyint | 0 | |
| type | tinyint | 1 | |
| name | varchar(21) | Empty String | |
| entry | int(10) | 0 | |
| model | int(10) | 0 | |
| level | int(11) | 0 | |
| xp | int(11) | 0 | |
| slot | tinyint | 0 | |
| active | tinyint(1) | 0 | |
| alive | tinyint(1) | 1 | |
| actionbar | longtext | Empty String | |
| reset_time | int(10) | 0 | |
| reset_cost | int(10) | 0 | |
| spellid | int(10) | 0 | |
| petstate | tinyint | 0 | |
| talentpoints | int(10) | 0 | |
| current_power | int(10) | 1 | |
| current_hp | int(10) | 1 | |
| current_happiness | int(10) | 1000000 | |
| renamable | tinyint | 1 |
ownerguid
The character guid of the pet owner from characters table.
petnumber
The number of the pet linked to the player.
type
1 = Hunter pet
2 = Summoned pet (warlock minions, death knight ghoul etc)
name
The pet name (generated by core/created by player).
entry
The creature entry ID from creature_properties table.
model
The creature model ID.
level
The level of the player pet.
xp
The XP of the player pet.
slot
The slot of the player pet. Although 0-4 slots are reserved for active slots in all versions, classic - wotlk only use the first slot (0).
0-4 = active pet slot
+5 = stable slot
active
The active state of player pet.
1 = true, pet is active
0 = false, pet not active
alive
0 = false, pet not alive
1 = true, pet is alive
actionbar
These values defines the actionbar in following form:
<actionid> <flags>,<actionid> <flags>,<actionid> <flags>
Blank entries are listet like: 0 0, We have 10 actionbar elements:
1. = Spell(actionid): 117440514 -> Attack
2. = Spell(actionid): 117440513 -> Follow
3. = Spell(actionid): 117440512 -> Stay
4. = Depends on pet type
5. = Depends on pet type
6. = Depends on pet type
7. = Depends on pet type
8. = Spell(actionid): 100663298 -> Agressive
9. = Spell(actionid): 100663297 -> Defensive
10. = Spell(actionid): 100663296 -> Passive
reset_time
Timestamp when pet’s beast training skills (classic - tbc) or talents (wotlk+) were last resetted.
reset_cost
The last beast training skill reset (classic - tbc) or talent reset (wotlk+) cost of pet.
spellid
The spell ID of the spell which created this pet.
petstate
0 = passive
1 = defensive
2 = aggressive
talentpoints
The talentpoints of the pet.
current_power
The current power of the pet.
current_hp
The current health points of the pet.
current_happiness
The current happiness of the pet.
The happiness of a pet is shown beside the pet's portrait and in his pet paper doll as a small smiley face icon. This icon shows the states of happiness your pet goes through:
3 = 
Happy. Your pet is happy and do 125% damage during fights.
2 = 
Content. Your pet is contented and do 100% damage during fights.
1 = 
Unhappy. Your pet do only 75% damage during fights.
renamable
0 = false, pet is not renameable
1 = true, pet is renameable