Bank Items?

[blindaviator]

I have searched around but haven't seen anything specific to this question...

How are regular bank items and coin stored (not shared items)??
Are they stored in the database or is it somehow hard coded??

I have looked everywhere in the database but haven't seen anything that would point me in the right direction...

Anyone can help with an answer??

I have found where shared items and coin are stored but nothing on regular bank items and coin...

[GeorgeS]

Coins are in the profile struct BLOB in the database under table character_
I think the inventory of bank items should be in the inventory table

GeorgeS

[blindaviator]

Originally Posted by GeorgeS

Coins are in the profile struct BLOB in the database under table character_
I think the inventory of bank items should be in the inventory table

GeorgeS

Well I had already checked the inventory table but it only contains character inventory items... It doesn't hold the coin amounts for inventory or regular bank slots...

Also what is the structure for the coin held in the BLOB of character_ table??
I can see it is in HEX format but what is the structure that tells the system what item is where?

I appreciate the help...

[GeorgeS]

Here's the relevant profile struct

'/*4720*/ sint32 platinum; // Platinum Pieces on player
'/*4724*/ sint32 gold; // Gold Pieces on player
'/*4728*/ sint32 silver; // Silver Pieces on player
'/*4732*/ sint32 copper; // Copper Pieces on player
'/*4736*/ sint32 platinum_bank; // Platinum Pieces in Bank
'/*4740*/ sint32 gold_bank; // Gold Pieces in Bank
'/*4744*/ sint32 silver_bank; // Silver Pieces in Bank
'/*4748*/ sint32 copper_bank; // Copper Pieces in Bank

use little endian byte order to decode

GeorgeS

[GeorgeS]

Here's the inventory table data

Equipped slots
(somebody should make this prettier some day)

SLOT_CHARM = 0,
SLOT_EAR01 = 1,
SLOT_HEAD = 2,
SLOT_FACE = 3,
SLOT_EAR02 = 4,
SLOT_NECK = 5,
SLOT_SHOULDER = 6,
SLOT_ARMS = 7,
SLOT_BACK = 8,
SLOT_BRACER01 = 9,
SLOT_BRACER02 = 10,
SLOT_RANGE = 11,
SLOT_HANDS = 12,
SLOT_PRIMARY = 13,
SLOT_SECONDARY = 14,
SLOT_RING01 = 15,
SLOT_RING02 = 16,
SLOT_CHEST = 17,
SLOT_LEGS = 18,
SLOT_FEET = 19,
SLOT_WAIST = 20,
SLOT_AMMO = 21,


Inventory Slots
NOTE: Numbering for personal inventory goes top to bottom, then left to right
It's the opposite for inside bags: left to right, then top to bottom
Example:
inventory: containers:
1 6 1 2
2 7 3 4
3 8 5 6
4 9 7 8
5 10 9 10



Personal Inventory
Personal inventory slots 22 through 29.
Bags in personal inventory are:
22: 251->260
23: 261->270
24: 271->280
25: 281->290
26: 291->300
27: 301->310
28: 311->320
29: 321->330


Cursor
Cursor is slot 30, and the bag slots for the cursor are 331->340.


Tribute
Tribute items are slots 400->404, these items are not visible, but are counted for stats/effects.


Bank
Bank slots are 2000->2015
Bags in the bank are:
2000: 2031->2040
2001: 2041->2050
2002: 2051->2060
2003: 2061->2070
2004: 2071->2080
2005: 2081->2090
2006: 2091->2100
2007: 2101->2110
2008: 2111->2120
2009: 2121->2130
2010: 2131->2140
2011: 2141->2150
2012: 2151->2160
2013: 2161->2170
2014: 2171->2180
2015: 2181->2190


Shared Bank
Shared bank slots are 2500 and 2501
Bags in the shared bank are:
2500: 2531->2540
2501: 2541->2550

[blindaviator]

Much appreciated GeorgeS.... With that info and some investigations on my own I am slowly getting it...