Database / Item Slots / Stuff
Posted: Thu Mar 27, 2008 4:19 am
UPDATE
- Found Cloak SLOT!!
- Added food, drink & Charm slot
along with menu_type and tier column! (learn something new every day)
(Thanks to Zcoretri!)
Ive been messing with the DB, working out slot numbers and such, taken me a while but I still cant find the cloak slot or a lot of the jewelery slots, here's what I have now, I also found a few bugs.
Also have some useful tips (IF YOU HAVE ANYTHING TO ADD OR CORRECT PLEASE DO!)
DATABASE BUGS:
- Within the eq2.item_appearances table Green is in fact Blue, I've tested this with some armor, putting 255 in green and leaving everything else at 0
The armor then, when loaded into the game on my character is blue not green, this could cause a little confusion and I'm sure it wont take long to rectify.
ARMOR SLOTS:
Primary = 1
Secondary = 2
Primary/Secondary = 3
Ranged = 65536
Ammo = 131072
Head = 4
Cloak = 524288
Chest = 8
Shoulders = 16
Forearms = 32
Hands = 64
Waist = 262144
Legs = 128
Feet = 256
Finger = 512 / 1024
Ear = 2048 / 4096
Neck = 8192
Wrist = 16384 / 32768
Charm = 1048576/2097152
Food = 4194304
Drink = 8388608
COLOURING ARMOR:
Use the RGB Values from this link (currently blue in the database is green and green is blue..)
http://www.allprofitallfree.com/color-wheel2.html
ICONS:
- Download WTV - http://developer.nvidia.com/object/wind ... iewer.html
- Navigate to the interface Icon files in C:\Games\EverQuest II\UI\Default\images\icons
- The Inventory Icons start with icon_is1.dds Open this file and use the mouse wheel
to scroll through the icons until you find one you want, then some simple maths!
- Use Windows Calculator or if you're clever enough work it out in your head, each .dds file
has 36 icons, starting at 0-36 therefore we need to do this.
(I'll use icon_is27 for example)
36 x 26 = 936
Which means the last icon in that page is 936 so take away until you get to the icon you want to
use in the database, icons DO NOT start at 1 but at 0, they also go from left to right and then
start from the left again the next row down.
MENU_TYPE table
EQUIP = 2
NORMAL = 3
BAG = 7
HOUSE_EQUIP = 10
HOUSE = 11
WEAPON WIELD STYLE
1 = Dual Wield Slashing
2 = Main Hand Slashing
3 =
4 = Two-Handed Slashing
Im hoping to turn this into a guide, will add more to it as its either submitted by other users or I find out myself. (ALSO I know its messy im gonna format it correctly when I have a little more info to order, just wanted to get it out there so people can start testing, and making it what its going to be!)
- Found Cloak SLOT!!
- Added food, drink & Charm slot
along with menu_type and tier column! (learn something new every day)
(Thanks to Zcoretri!)
Ive been messing with the DB, working out slot numbers and such, taken me a while but I still cant find the cloak slot or a lot of the jewelery slots, here's what I have now, I also found a few bugs.
Also have some useful tips (IF YOU HAVE ANYTHING TO ADD OR CORRECT PLEASE DO!)
DATABASE BUGS:
- Within the eq2.item_appearances table Green is in fact Blue, I've tested this with some armor, putting 255 in green and leaving everything else at 0
The armor then, when loaded into the game on my character is blue not green, this could cause a little confusion and I'm sure it wont take long to rectify.
ARMOR SLOTS:
Primary = 1
Secondary = 2
Primary/Secondary = 3
Ranged = 65536
Ammo = 131072
Head = 4
Cloak = 524288
Chest = 8
Shoulders = 16
Forearms = 32
Hands = 64
Waist = 262144
Legs = 128
Feet = 256
Finger = 512 / 1024
Ear = 2048 / 4096
Neck = 8192
Wrist = 16384 / 32768
Charm = 1048576/2097152
Food = 4194304
Drink = 8388608
COLOURING ARMOR:
Use the RGB Values from this link (currently blue in the database is green and green is blue..)
http://www.allprofitallfree.com/color-wheel2.html
ICONS:
- Download WTV - http://developer.nvidia.com/object/wind ... iewer.html
- Navigate to the interface Icon files in C:\Games\EverQuest II\UI\Default\images\icons
- The Inventory Icons start with icon_is1.dds Open this file and use the mouse wheel
to scroll through the icons until you find one you want, then some simple maths!
- Use Windows Calculator or if you're clever enough work it out in your head, each .dds file
has 36 icons, starting at 0-36 therefore we need to do this.
(I'll use icon_is27 for example)
36 x 26 = 936
Which means the last icon in that page is 936 so take away until you get to the icon you want to
use in the database, icons DO NOT start at 1 but at 0, they also go from left to right and then
start from the left again the next row down.
MENU_TYPE table
EQUIP = 2
NORMAL = 3
BAG = 7
HOUSE_EQUIP = 10
HOUSE = 11
WEAPON WIELD STYLE
1 = Dual Wield Slashing
2 = Main Hand Slashing
3 =
4 = Two-Handed Slashing
Im hoping to turn this into a guide, will add more to it as its either submitted by other users or I find out myself. (ALSO I know its messy im gonna format it correctly when I have a little more info to order, just wanted to get it out there so people can start testing, and making it what its going to be!)
