Playeritems

From ArcEmu-Wiki
Revision as of 13:23, 28 July 2013 by Magnifikator (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contents

ownerguid

The guid of the player who has the item.


guid

The guid of the item.

Each new item increments this value by 1.


entry

The entryid of the item.


wrapped_item_id

wrapped_creator

creator

The name of the character which created the item.

This appears on conjured items, etc.


count

How many of an item is stacked in a slot.


charges

How many charges the item has left.


flags

This field is a bitfield, so the following values are flags.

0 - no flag

1 - soulbound

2 - conjured

4 - lootable ( unlocked )

8 - wrapped

134217728 - accountbound

randomprop

randomsuffix

itemtext

Text shown at the bottom of the item's tooltip.


durability

Current durability rating of the item. Does not change maximum durability.


containerslot

The container where a given slot is located. (ArcEmu r4012)

If this value is anything other than -1, the value in the Slots column will be the slots in a given bag (i.e. 0-3 for a 4 slot bag).


-1 = paperdoll, Bag0 (Backpack)

19 = bag in Bag1 slot

20 = bag in Bag2 slot

21 = bag in Bag3 slot

22 = bag in Bag4 slot


slot

Slot where a given item is located.

if containerslot = -1

0  = Head
1  = Neck
2  = Shoulders
3  = Shirt
4  = Chest
5  = Waist
6  = Legs
7  = Feet
8  = Wrist
9  = Hands
10 = Finger0
11 = Finger1
12 = Trinket0
13 = Trinket1
14 = Back
15 = Main-Hand
16 = Off-Hand/Shield
17 = Relic/Ranged
18 = Ammo
19 = Bag1
20 = Bag2
21 = Bag3
22 = Bag4
23-38    = Bag0 (Backpack, Slots 0-15)
39-66    = Main Bank slots
67-73    = Bank Bags
86-117   = Keys in Keyring
118-135  = Currencies (Emblems,badges,marks etc.) 

enchantments

Enchantments on the item.

Format:

[Enchantment ID],[Time Left],[Enchantment Slot];


duration_expireson

The date/time when the items expires as unix timestamp.

Appears on conjured items. etc.

refund_purchasedon

refund_costid

SQL Structure

CREATE TABLE `playeritems` (
  `ownerguid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `guid` BIGINT(10) NOT NULL AUTO_INCREMENT,
  `entry` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `wrapped_item_id` INT(30) NOT NULL DEFAULT '0',
  `wrapped_creator` INT(30) NOT NULL DEFAULT '0',
  `creator` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `charges` INT(10) NOT NULL DEFAULT '0',
  `flags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `randomprop` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `randomsuffix` INT(10) NOT NULL,
  `itemtext` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `durability` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `containerslot` INT(11) DEFAULT '-1',
  `slot` INT(10) NOT NULL DEFAULT '0',
  `enchantments` longtext NOT NULL,
  `duration_expireson` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `refund_purchasedon` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `refund_costid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`guid`),
  KEY `ownerguid` (`ownerguid`),
  KEY `itemtext` (`itemtext`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1;
Personal tools