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!

 

[PunkS7yle]

Give me a min. I need to pull a MrSensei tactic.

 

[ShinWanYeon]

View attachment 239678

0x7A06000007000004000000000600000000006E26090002000004FF1111200300000000006826090002000004FF1111200200000000004E860A0005000004F424002005000000000074E6090002000004F424002000000000000062A6090000000004FF11112001000000000050960A0008000004F4241630040000000000080A08000800000498D2D100080000000000080F0800000000049BABAB00070000000000

How about this?

 

[PunkS7yle]

Here you go https://forum.ragezone.com/threads/how-to-edit-character-items-using-sweetscape-010.1217941/

 

[olokers]

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.

Bro sorry for nobs question where do i find the length of the varbin data

 

[ShinWanYeon]

Bro sorry for nobs question where do i find the length of the varbin data

SQL:
Select Data FROM Server01.dbo.cabal_equipment_table where CharacterIdx = ?

 

[Anndralgon]

You would get the entire string of data if you just extract the Data column as is.
PunkS7yle already posted a very clear approach, you can of course translate it into sql, but to do that you will have to have the curiosity to learn.

You can use sql to search for (and replace) substrings with sql very easily, google would provide a number of answers.

However I do suggest to benchmark every approach if you are aiming for a longterm solution, find the fastest and most resource efficient approach that does not run the risk of corrupting data.
While still insecure about new things, you can always use few additional lines of code and tables to store the original data elsewhere whenever your queries are executed.
Just make sure you keep the environment organized in a way that allows for you to not lose track of changes applied or things you have previously tried.

The "item unbind" code that was posted into this forum is beyond slow, and couldn't even be used on a live platform by players (through the website i.e) as they would just remain in a banned state if trying to log back in at the right time.
The time frame for that to happen is not exactly small either, I was able to recreate it by reducing my ping into a range between 150ms and 600ms, the account updates would just be stopped as the login would attempt to update that same data.
That event alone ends in neither of the item unbinding stuff actually happening and the account remaining blocked, even though it was supposed to be unblocked at the end of the procedure.

The reason I'm bringing that up is simply because even though I had linked it as a reference, trusting code blindly without understanding it always comes with such risks.
The above obviously only happened if the player would attempt to login quickly after submitting the request to run the procedure.

And I'm sure that most would agree with me when I say that sacrificing speed in a game this old would only reduce the already small community even further.

 

[geography]

your cabalmain can't load PW5 data, you must change your cabalmain up to 26 - 1A

 

[ShinWanYeon]

your cabalmain can't load PW5 data, you must change your cabalmain up to 26 - 1A

How to change cabalmain?

 

[upanddown]

How to change cabalmain?

if you mean the addresses, 0x00484457 and 0x008D46FC