From ArcEmu-Wiki
Revision as of 15:15, 28 May 2011 by (Talk)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search



Guid of the character who owns the pet.


Guid of the pet.


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


Entry id of the creature.


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.


Amount of experience the pet currently has.


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 of the pet.


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.


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).


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


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


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.


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.


Need info.


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`)

Updated because of character update on r1216 (arcscript)

Personal tools