Playerpets

From ArcEmu-Wiki
Jump to: navigation, search

Contents

ownerguid

Guid of the character who owns the pet.

pet_number

Guid of the pet.

name

Name of the pet. Default WoW names are the type of the pet.
Example : a bat will be named "Bat" if not renamed.

entry

Entry id of the creature.

fields

Need info.

[Edit: Pichubolt090] The fourth number is the model which will be used on the logon screen. For example; if the fields were as follows:

1811939329 4047503364 9 1132 1061912465 0 0 0 .....

...the "1132" would be the model, in this case, a timber wolf.

xp

Amount of experience the pet currently has.

active

If the pet is currently used or 'stabled'.

Based on my tests:

10 = The current unsummoned pet

11 = The current summoned pet

20 = A stabled unsummoned pet (note: All stabled slots use slot value 20. Stabled pets will fill slots from left to right)

21 = A stabled SUMMONED pet. (Note: In my tests, stabling a summoned pet can possibly lead to a player losing the pet.)

level

Level of the pet.

actionbar

List of entries that go on the pet-specific action bar (a.k.a. Pet Bar, Pet Action Bar). Entries are in the format: <actionid> <flags>,<actionid> <flags>,...,<actionid> <flags>

For example, a Hunter pet that is a low-level tamed cat might have an action bar that looks like this:

    117440514 0,117440513 0,117440512 0,2649 33024,16827 33024,24450 33024,0 0,100663298 0,100663297 0,
    <attack>     <follow>    <stay>     <Growl 1>  <Claw 1>    <Prowl 1>  <blank><aggress> <defens>

Entries listed as "0 0" are blank slots on the action bar.

happinessupdate

Need info. I guess, pet is flagued happy, not happy, angry, etc. Need flag info.

[Edit: Drake1132] After watching the values on this in my database for a while I believe this value is a countdown timer. When it reaches 0 the pet's happiness should reduce by one level (i.e. from Happy to Content) and the timer should reset. Max value seems to be 7500, and values should be time as given in seconds, 10ths of seconds, or 100ths of seconds (not sure which).

summon

Need info. True/False flag (valid entries are 0 and 1), but not sure at this time what these are used for.

reset_time

Need info. How many time has the pet talent been resetted?

reset_cost

Need info. Should be the cost to "untrain" pet talents, at least assuming this is used in the same way as in live 3.02 and later.

spellid

Need info. Known spells ?

Possibly the spellid of the spell used to summon the pet originally in the case of caster pets vs. hunter pets. Hunter pets use a spellid of 0.

petstate

Need info.

Alive

Checks if the pet is alive. Should be 1 or 0

SQL Structure

CREATE TABLE `playerpets` (
  `ownerguid` bigint(20) NOT NULL DEFAULT '0',
  `petnumber` int(11) NOT NULL DEFAULT '0',
  `name` varchar(21) NOT NULL DEFAULT '',
  `entry` int(10) unsigned NOT NULL DEFAULT '0',
  `fields` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `xp` int(11) NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT '0',
  `actionbar` varchar(200) NOT NULL DEFAULT '',
  `happinessupdate` int(11) NOT NULL DEFAULT '0',
  `summon` int(11) NOT NULL DEFAULT '0',
  `reset_time` int(10) unsigned NOT NULL DEFAULT '0',
  `reset_cost` int(10) NOT NULL DEFAULT '0',
  `spellid` int(10) unsigned NOT NULL DEFAULT '0',
  `petstate` int(10) unsigned NOT NULL DEFAULT '0',
  `alive` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`ownerguid`,`petnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Updated because of character update on r1216 (arcscript)

Personal tools