Tec's Ilaros WoW

Datenbank 'characters'

account_data
account_instance_times
account_tutorial
addons
arena_team
arena_team_member
auctionhouse
banned_addons
bugreport
calendar_events
calendar_invites
channels
characters
character_account_data
character_achievement
character_achievement_progress
character_action
character_arena_stats
character_aura
character_banned
character_battleground_data
character_battleground_random
character_declinedname
character_equipmentsets
character_gifts
character_glyphs
character_homebind
character_instance
character_inventory
character_pet
character_pet_declinedname
character_queststatus
character_queststatus_daily
character_queststatus_monthly
character_queststatus_rewarded
character_queststatus_seasonal
character_queststatus_weekly
character_reputation
character_skills
character_social
character_spell
character_spell_cooldown
character_stats
character_talent
corpse
creature_respawn
gameobject_respawn
game_event_condition_save
game_event_save
gm_subsurvey
gm_survey
gm_ticket
groups
group_instance
group_member
guild
guild_bank_eventlog
guild_bank_item
guild_bank_right
guild_bank_tab
guild_eventlog
guild_member
guild_member_withdraw
guild_rank
instance
instance_reset
item_instance
item_loot_items
item_loot_money
item_refund_instance
item_soulbound_trade_data
lag_reports
lfg_data
mail
mail_items
petition
petition_sign
pet_aura
pet_spell
pet_spell_cooldown
pool_quest_save
pvpstats_battlegrounds
pvpstats_players
quest_tracker
reserved_name
updates
updates_include
warden_action
worldstates

Trinity DB, TrinityCore 2015-09-13, Tec's Ilaros WoW 3.3.5a, Datenbank 'characters'

Tabelle: 'character_pet'

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
id	int(10)	vorzeichenlos	PRI	NO	0
entry	int(10)	vorzeichenlos		nein	0
owner	int(10)	vorzeichenlos		nein	0
modelid	int(10)	vorzeichenlos		YES	0
CreatedBySpell	mediumint(8)	vorzeichenlos		nein	0
PetType	tinyint(3)	vorzeichenlos		nein	0
level	smallint(5)	vorzeichenlos		nein	1
exp	int(10)	vorzeichenlos		nein	0
Reactstate	tinyint(3)	vorzeichenlos		NO	0
name	varchar(21)	vorzeichenbehaftet		nein	Pet
renamed	tinyint(3)	vorzeichenlos		nein	0
slot	tinyint(3)	vorzeichenlos		nein	0
curhealth	int(10)	vorzeichenlos		nein	1
curmana	int(10)	vorzeichenlos		nein	0
curhappiness	int(10)	vorzeichenlos		nein	0
savetime	int(10)	vorzeichenlos		nein	0
resettalents_cost	int(10)	vorzeichenlos		NO	0
resettalents_time	int(10)	vorzeichenlos		nein	0
abdata	text	vorzeichenbehaftet		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.