Looking for the DB where Item charges are stored

[gd2k84]

I've gone through the individual tables in the database but I'm not seeing where the Information about how many charges/ uses are left on the equipment. Can some one point me in the right direction?

[TeoTwawki]

I wasn't exactly sure so I did a quick search for where it tries to store that you've used a charge, and looks like it goes into the recast container same as JA and spell use so that would save it into the char_recast table.

If you mean to alter the base item to change how many charges and item CAN have or the time between uses, you'd want item_uable table instead.

edit: further confirmation:

server/src/map/recast_container.h

Line 29 in 7c235e8

enum RECASTTYPE

enum RECASTTYPE
{
    RECAST_ITEM    = 0,
    RECAST_MAGIC   = 1,
    RECAST_ABILITY = 2,
    RECAST_LOOT    = 3
};

[gd2k84]

Thanks for the fast reply. I looked at that table but I didn't see the data I was looking for. I was looking for the charges remaining on the Destrier Beret. (Item number 11811) I don't want to increase how many or on the item by default but that is good to know where that information is located as well.

Is the data in a protected database that we don't see in HeidiSQL?

[TeoTwawki]

no we don't have anything protected/hidden, though it may look like random numbers because our predecessors in past versions of the server software didn't prioritize human readability. I was trying to track down an error with this table last week and could not find what the recast that was erroring was even FOR, so it may be one of the rows in front of you but not look like it at all.

[TeoTwawki]

I think the "id" for the item's recast in there is a combined set of bytes with the slot id and container ID - its position in inventory. what a pain in the rear.

[gd2k84]

Alright I will keep looking for it and If I figure it out I will post my findings. Thanks for the assistance at where I need to look.

[TeoTwawki]

slotID << 8 | containerID a bit-shift left by 8 plus a bit-wize OR operation