Playercreateinfo items

From ArcEmu-Wiki
Revision as of 19:53, 4 November 2009 by Bryce (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SQL Structure

CREATE TABLE `playercreateinfo_items` (
  `indexid` tinyint(3) unsigned NOT NULL default '0',
  `protoid` int(10) unsigned NOT NULL default '0',
  `slotid` tinyint(3) unsigned NOT NULL default '0',
  `amount` int(10) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Player System'

SQL Information

Credits: prezidani on WhyDB.org

Original Post: http://www.whydb.org/forum/viewtopic.php?f=24&t=715

Indexid see it Playercreateinfo table indexid

protoid item id

0=head
1=neck
2=Shoulder
3=shirt
4=chest
5=waist
6=legs
7=feet
8=wrists
9=gloves
10=finger1
11=finger2
12=trinket1
13=trinket2
14= Back
15= Main Hand
16= Off Hand
17= Ranged
18= Tabard

INVENTORY BAG SLOTS = 19 to 22 (the 4 bagslots next to the backpack)

INVENTORY ITEM = 23 to 39 (backpack slot)

BANK ITEMS = 39 to 66 (bankslots)

BANK BAG SLOTS = 67 to 73

KEYRING = 86 to 118

amount how many

Personal tools