Playeritems insert queue

From ArcEmu-Wiki
Revision as of 13:52, 9 September 2010 by 178.24.51.131 (Talk)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contents

ownerguid

Guid of the character (the player) who owns the item.

entry

Entry Id of the item.

wrapped_item_id

Need info.

wrapped_creator

Need info.

creator

Name of the creator.
For example: "This item has been created by Creator"

count

Amount of items

charges

Amount of charges left.

flags

Need info.

randomprop

Need info.

randomsuffix

Need info.

itemtext

Need info.

durability

Percentage of damage based on original item durability (see Items).

containerslot

ContainerSlot Id where the armor item is stored on the character.

  • 0 = Head
  • 1 = Neck
  • 2 = Shoulder
  • 3 = N/A
  • 4 = Chest
  • 5 = Waist
  • 6 = Legs
  • 7 = Feet
  • 8 = Wrist
  • 9 = Hands
  • 10 = Finger 1
  • 11 = Finger 2
  • 12 = Trinkets 1
  • 13 = Trinkets 2
  • 14 = Cloack
  • 15 = Main-Hand
  • 16 = Off Hand
  • 17 = Ranged/Relic
  • 18 = Tabard
  • 19 = N/A

this is as of Arc-emu revision 3024


slot

Need info.

enchantments

Enchantment(s) applied on the item.


SQL Structure

CREATE TABLE `playeritems_insert_queue` (
  `ownerguid` int(10) unsigned NOT NULL DEFAULT '0',
  `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) unsigned NOT NULL DEFAULT '0',
  `flags` int(10) unsigned NOT NULL DEFAULT '0',
  `randomprop` int(10) unsigned NOT NULL DEFAULT '0',
  `randomsuffix` int(30) NOT NULL,
  `itemtext` int(10) unsigned NOT NULL DEFAULT '0',
  `durability` int(10) unsigned NOT NULL DEFAULT '0',
  `containerslot` int(11) NOT NULL DEFAULT '-1' COMMENT 'couldnt find this being used in source',
  `slot` tinyint(4) NOT NULL DEFAULT '0',
  `enchantments` longtext COLLATE utf8_unicode_ci NOT NULL,
  KEY `ownerguid` (`ownerguid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Personal tools