Upgrade

[Brujeria]

Hello

Someone can tell me where I find the tables that store the enhancements that the char buy?
I'm working on a CashShop to make improvements in sales of a particular character, but need to know in which DB and table data is stored.
For instance, my character has improved attack (Impact Control) level 3, find the table where you record it on my char?

Thank you for your help.
-------------------
Sorry for my bad English

[MentaL]

[chumpywumpy]

It's gamedb..cabal_skilllist_table but it's binary format like items/warehouse (the decoding method is very similar).

Never edit a char when they are online or you will cause problems ;)

[Brujeria]

Hello

Thanks for the help, but I'm more of a problem ...
The Date column in all the fields are written "Binary Data" how do I read these binaries?

Thanks in advance

--------
Sorry for bad English

[cypher]

Open them with a query or with a query analyzer window.

[chumpywumpy]

Before you can edit you need to know how to decode what you are seeing. This is how item binary works:

http://forum.ragezone.com/f460/tips-...binary-430732/

The skill binaries are made up pretty much the same way but i don't have a guide or anything i can post yet. Once you work out inventory item binary you will see how skills work pretty quick. Just make a basic character with just the starting skills and check the binary. Level a skill up, check the binary again.

Some SQL for your gamedb:

select data,convert(varchar(max),data) from cabal_skilllist_table where characteridx=<insert charidx here>

The data field in cabal_skilllist_table is a varbinary(512) if you want to convert it back for an update statement.

[cypher]

Before you can edit you need to know how to decode what you are seeing. This is how item binary works:

http://forum.ragezone.com/f460/tips-...binary-430732/

The skill binaries are made up pretty much the same way but i don't have a guide or anything i can post yet. Once you work out inventory item binary you will see how skills work pretty quick. Just make a basic character with just the starting skills and check the binary. Level a skill up, check the binary again.

Some SQL for your gamedb:

select data,convert(varchar(max),data) from cabal_skilllist_table where characteridx=<insert charidx here>

The data field in cabal_skilllist_table is a varbinary(512) if you want to convert it back for an update statement.

This is how I did it :)!