From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/character_pet.md | 326 ++++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 305 insertions(+), 21 deletions(-) (limited to 'docs/character_pet.md') diff --git a/docs/character_pet.md b/docs/character_pet.md index 67c903f..fcfa072 100644 --- a/docs/character_pet.md +++ b/docs/character_pet.md @@ -1,21 +1,305 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [character_pet](character_pet) - -Column | Type | Description ---- | --- | --- -Id | int(10) unsigned | -Entry | int(10) unsigned | -Owner | int(10) unsigned | -Modelid | int(10) unsigned | -CreatedBySpell | mediumint(8) unsigned | -PetType | tinyint(3) unsigned | -Level | smallint(5) unsigned | -Exp | int(10) unsigned | -Reactstate | tinyint(3) unsigned | -Name | varchar(21) | -Renamed | tinyint(3) unsigned | -Slot | tinyint(3) unsigned | -Curhealth | int(10) unsigned | -Curmana | int(10) unsigned | -Curhappiness | int(10) unsigned | -Savetime | int(10) unsigned | -Abdata | text | +# character\_pet + +`Back-to:Characters` + +**The \`character\_pet\` table** + +This table holds the pet data for each pet summoned by anyone in the game. + +**Structure** + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

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** + +### id + +The special pet ID. This is a unique identifier among all pets. + +### entry + +The creature entry of this pet. See creature\_template.entry + +### owner + +The GUID of the pet's owner. See characters.guid + +### modelid + +The model ID to use to display the pet. + +### CreatedBySpell + +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 + +### PetType + +The type of pet that this is. 0 = summoned pet, 1 = tamed pet + +### level + +The current level of the pet. + +### exp + +The current experience that this pet has. For summoned pets, this field is always 0. + +### Reactstate + +The current reaction state of the pet (passive, aggressive, etc). + +### name + +The pet's name. + +### renamed + +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. + +### slot + +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. + +### curhealth + +The current pet health at the time it was saved to DB. + +### curmana + +The current pet mana at the time it was saved to DB. + +### curhappiness + +The current pet happiness. + +### savetime + +The time when the pet was last saved, in Unix time. + +### resettalents\_cost + +The cost for the character to reset pet's talents, measured in copper. + +### resettalents\_time + +The date when the talents were reset, in Unix time. + +### abdata + +`field-no-description|19` -- cgit