PW5 Bug Help

[ShinWanYeon]

Hi again everyone, I just recently looted a PW5 and after I equip it, the game crashes.

After I try to re-open the client and log in to my account, the game crashes again after loading.

Is there a way I can erase or fix the PW5 I recently equipped?

Thank you!

Update:

Found this post https://forum.ragezone.com/threads/deleting-items-from-inventory.431333/ but I need is to erase/remove the item that is currently equip to the character.

I hope someone can help me.

Thank you!

 

[Yakud3a]

Hi again everyone, I just recently looted a PW5 and after I equip it, the game crashes.

After I try to re-open the client and log in to my account, the game crashes again after loading.

Is there a way I can erase or fix the PW5 I recently equipped?

Thank you!

Update:

Found this post https://forum.ragezone.com/threads/deleting-items-from-inventory.431333/ but I need is to erase/remove the item that is currently equip to the character.

I hope someone can help me.

Thank you!

eqip wipe in db

 

[ShinWanYeon]

eqip wipe in db

You mean wipe the data here?

 

[Yakud3a]

You mean wipe the data here?

View attachment 239474

yes, find your id and wipe

 

[ShinWanYeon]

yes, find your id and wipe

Okay I will try it tomorrow.

 

[upanddown]

In Gameserver database

update cabal_equipment_table set data = 0x where characteridx = YourCharIDX

 

[Anndralgon]

Or you simply check the length of the varbin data of each item and search & replace that specifically with 0x so that you won't have to wipe your entire equipment, inventory or whatever every time you want to remove a faulty item.

 

[Crashed]

or you can use changeitem.scp to replace the bug item with a working one...

ex:

(replacing PW5 for RW3)

[ChangeItem]    OldItemIndex    OldItemOption    NewItemIndex    NewItemOption    Type
0    3867    0    439    0    1

 

[Anndralgon]

If the item causes trouble only because of it being equipped, or even being equipped in the wrong gear slot because of a mistake, then that change item option is quite the extreme move to be honest.

 

[Crashed]

If the item causes trouble only because of it being equipped, or even being equipped in the wrong gear slot because of a mistake, then that change item option is quite the extreme move to be honest.

it's an alternative offered by the game itself, so as long as it solves his problem, it's valid

 

[Anndralgon]

it's an alternative offered by the game itself, so as long as it solves his problem, it's valid

On a server where you're alone, or if it is an item that no one has access to, sure.

 

[Crashed]

On a server where you're alone, or if it is an item that no one has access to, sure.

Why do you think this could not be used on a large scale?

In a scenario where you have sent a bug or wrong item by mistake to 1000 players, I believe the changeitem is much safer, more reliable, faster and (mostly) cheaper, than binary editing the inventory and equipment of all of them

 

[Anndralgon]

Why do you think this could not be used on a large scale?

In a scenario where you have sent a bug or wrong item by mistake to 1000 players, I believe the changeitem is much safer, more reliable, faster and (mostly) cheaper, than binary editing the inventory and equipment of all of them

It can be used on a larger scale, there simply are numerous exceptions.
However the only reason I brought up the database part was because that works for a lot more things than just equipment | inventory data so it could be worth having that in mind.

There's also the fact that it won't really do anything to inactive characters and you'll want to make use of whatever ID you might have previously replaced, so that data will remain the same as before on them and when they come back they'll have a completely new item equipped that may not even belong into any equipment slots.

And frankly, even if you were to be managing a cabal online server with 1000 players, which sounds a little off the charts, you would most likely have appropriate resources for the database to be able to handle the task of searching through and replacing the respective data during a short maintenance.
Even in a slow case it would not take that long.

 

[ShinWanYeon]

Hi guys!

I haven't tried any of your suggestions because I don't have the laptop that has the problem.

I will try your suggestions next week once I get to my office.

Or you simply check the length of the varbin data of each item and search & replace that specifically with 0x so that you won't have to wipe your entire equipment, inventory or whatever every time you want to remove a faulty item.

Where do I check this one?

Can you give me an example where can I find this?

This will be helpful to me because I'm trying almost every item in cabal_msg.

 

[Anndralgon]

There is a post in this forum that includes everything you need to know.
You can narrow it down to whatever you want to use it for, rather than using it for what it was made for originally.
https://forum.ragezone.com/threads/database-unbind-inventory-item-sql-script-only.1208710/

If you remove the whole UnBound stuff and just stick to adding the item list and id's, you can comfortably check the data from your characters and even receive the item names but most importantly the actual data from those items.

You can use the code as a starting point for other things such as blessing beads as well, existing procedures can help finding the exact length of certain things, or you can just (in the case of beads or mercenaries) activate one at a time, relog and select the data to figure out the length per single item of the specific type.

It is a fair bit to go through but I'd argue that this still is the rather simple level of sql and it can (and most likely will) come in handy once you try to build some more advanced bits.

 

[ShinWanYeon]

There is a post in this forum that includes everything you need to know.
You can narrow it down to whatever you want to use it for, rather than using it for what it was made for originally.
https://forum.ragezone.com/threads/database-unbind-inventory-item-sql-script-only.1208710/

If you remove the whole UnBound stuff and just stick to adding the item list and id's, you can comfortably check the data from your characters and even receive the item names but most importantly the actual data from those items.

You can use the code as a starting point for other things such as blessing beads as well, existing procedures can help finding the exact length of certain things, or you can just (in the case of beads or mercenaries) activate one at a time, relog and select the data to figure out the length per single item of the specific type.

It is a fair bit to go through but I'd argue that this still is the rather simple level of sql and it can (and most likely will) come in handy once you try to build some more advanced bits.

Will try this.

Thank you!

Or you simply check the length of the varbin data of each item and search & replace that specifically with 0x so that you won't have to wipe your entire equipment, inventory or whatever every time you want to remove a faulty item.

But can you tell me how to do this one?

Where can I find varbin data?

Thank you!

 

[Anndralgon]

In the respective tables under Server01.

Most of it is given away by the scripts mentioned in the thread that I linked.
I know you'd likely be happier about straight forward type of answers and I'm sorry for not giving them the way you might want them.
But I do believe that it helps more to just look through your database and actually bother to open stored procedures (right click, modify) as well as tables to see how your database works.

While dealing with that type of data you will want to look at the design of the table to know the names of each field and then select the data through a query.
It helps using indexes in order to speed up the execution time of these queries, something you will want to keep in mind when creating new tables or just dealing with generally bigger ones.

Achievements, dungeon clear data, inventory data, quest data, buff data, blessing bead data, skill data, there's plenty for you to go through.
Try to pick one topic after another, find out how to comfortably deal with the data of your choosing and once you can complete any task you want without having to look it up somewhere, move on to the next topic.

I don't think there is a "best" approach but there's a "worst" one, which would be going through it fully randomly whenever you have problems.

 

[ShinWanYeon]

In the respective tables under Server01.

Most of it is given away by the scripts mentioned in the thread that I linked.
I know you'd likely be happier about straight forward type of answers and I'm sorry for not giving them the way you might want them.
But I do believe that it helps more to just look through your database and actually bother to open stored procedures (right click, modify) as well as tables to see how your database works.

While dealing with that type of data you will want to look at the design of the table to know the names of each field and then select the data through a query.
It helps using indexes in order to speed up the execution time of these queries, something you will want to keep in mind when creating new tables or just dealing with generally bigger ones.

Achievements, dungeon clear data, inventory data, quest data, buff data, blessing bead data, skill data, there's plenty for you to go through.
Try to pick one topic after another, find out how to comfortably deal with the data of your choosing and once you can complete any task you want without having to look it up somewhere, move on to the next topic.

I don't think there is a "best" approach but there's a "worst" one, which would be going through it fully randomly whenever you have problems.

Thank you again for replying to my questions.

This is the table that holds the data of the item equip but I can't view or edit this table

If I delete the record, all of the items equiped will be deleted.

Is there a way I can only delete specific items in this table or can I view this table like this one?

 

[Anndralgon]

If it says (BLOB) that just means you'll want to use a select query to retrieve the data contained there.

So after replacing the CharNameHere with the target character's name:

USE Server01

DECLARE @char INT = (SELECT CharacterIdx FROM cabal_character_table WHERE Name = 'CharNameHere')

SELECT Data FROM cabal_equipment_table WHERE CharacterIdx = @char

 

[ShinWanYeon]

This is the result of the query.