[Help Thread] Please post your questions here.

[InkDevil]

Originally Posted by YuhaBah

But how i can remove durability from items in full?

I'd try

use Arcadia
UPDATE dbo.ItemResource
Set ethereal_durability = 0 where ethereal_durability <> 0
GO

[YuhaBah]

Originally Posted by LamiaCore

I'd try

use Arcadia
UPDATE dbo.ItemResource
Set ethereal_durability = 0 where ethereal_durability <> 0
GO

i try it before, so i have to restore this table, cause all item become broken xD

[InkDevil]

Originally Posted by YuhaBah

i try it before, so i have to restore this table, cause all item become broken xD

Did you forget to create item.rdb?
And possible you have also to update your Telecaster.dbo.Item to set all ethereal_durability to 0, too.

[Shalindor]

@

You're right, i've dumped the db_creatureenhance.rdb out the clients, 9.4 and 9.5, in both cases the durability values are as in your picture from RDB Tool starting with 18 at S1, ending with 10 at S5

While the server DB contains values starting with 15 at S1, then 10 at S2

Simple solution update your Arcadia.dbo.CreatureEnhance

USE Arcadia
GO
UPDATE dbo.CreatureEnhance SET card_durability = 18 WHERE enhance_level = 1;
UPDATE dbo.CreatureEnhance SET card_durability = 16 WHERE enhance_level = 2;
UPDATE dbo.CreatureEnhance SET card_durability = 14 WHERE enhance_level = 3;
UPDATE dbo.CreatureEnhance SET card_durability = 12 WHERE enhance_level = 4;
UPDATE dbo.CreatureEnhance SET card_durability = 10 WHERE enhance_level = 5;

Thank you @ for finding the bug reason.

Edit: Works like a charm. Now was able to successfully repair durability of creatures i staged before the fix and cards show 100 durability

[ThunderNikk]

@

The second pic you posted shows the number of deaths per stage recorded in the card durability column.

Good catch and no wonder it turned out wrong.

[Shalindor]

In Glandu2s RDB tool the Item94Database.lua the definition of the RDB has about 25 columns more then my actual Arcadia.dbo.ItemResource.
My dbo.ItemResource matches Item91Database.lua, although it comes from the Revolution 9.4 release.

How to make an RDB from Arcadia.dbo.ItemResource that does not match the columns of the db_item.rdb

After create a db_item.rdb, where should i put it ?

In the client/Resource folder or shall I updating the data.*** ?

[YuhaBah]

Originally Posted by LamiaCore

Did you forget to create item.rdb?
And possible you have also to update your Telecaster.dbo.Item to set all ethereal_durability to 0, too.

I do all what you said and all durability gone far-far away.

But now i can equip any item and ALL item seems like enchanted for pet equip with golden border around it ( include pieces, blesses, pet cards etc)

=(

[InkDevil]

Originally Posted by Shalindor

In Glandu2s RDB tool the Item94Database.lua the definition of the RDB has about 25 columns more then my actual Arcadia.dbo.ItemResource.
My dbo.ItemResource matches Item91Database.lua, although it comes from the Revolution 9.4 release.

How to make an RDB from Arcadia.dbo.ItemResource that does not match the columns of the db_item.rdb

After create a db_item.rdb, where should i put it ?

In the client/Resource folder or shall I updating the data.xxx ?

First, you have to use the item94Database.lua, and create the view, which was released by Gangor in his ItemReference-thread (click )
You also need db_item.rdb AND fitting db_item.ref!!!

Then you can choose if you want to put it into your datas (I would not suggest doing this before you tested those files), or you only put them hashed into your Resource-Folder of your client ( that's what I would do first).

Originally Posted by YuhaBah

I do all what you said and all durability gone far-far away.

But now i can equip any item and ALL item seems like enchanted for pet equip with golden border around it ( include pieces, blesses, pet cards etc)

=(

What the hell did you do? oO
I only used my Arcadia.dbo.ItemResource-query I posted first, created then db_item.rdb and db_item.ref and it works fine, as you can see in following screen:

 Spoiler

So, what did you do additionally, that you killed your itemresource this way??? xDD

[YuhaBah]

Originally Posted by LamiaCore

So, what did you do additionally, that you killed your itemresource this way??? xDD

set durability to 0 in dbo.ItemResource and Telecaster.dbo.Item
Create .rbd and hash it with glandu2 tool and put in Resurse =)

Before do this i made backups with client item.rdb and MSSQL dbo.ItemResourse so i turn all bakc

[thefear511]

Originally Posted by YuhaBah

set durability to 0 in dbo.ItemResource and Telecaster.dbo.Item
Create .rbd and hash it with glandu2 tool and put in Resurse =)

Before do this i made backups with client item.rdb and MSSQL dbo.ItemResourse so i turn all bakc

to make all items have no dura just set durability to 0 in itemresource and make .rdb , no need to do the telecaster step.

[InkDevil]

Originally Posted by thefear511

to make all items have no dura just set durability to 0 in itemresource and make .rdb , no need to do the telecaster step.

Just mentioned this step in case the rest-durability would cause issues with items - better to prepared with thoughts than not to know what to do in case if
But even if ethereal_durability is set in Telecaster to 0, the result shouldn't be the problem he wrote about.

[thefear511]

Originally Posted by LamiaCore

Just mentioned this step in case the rest-durability would cause issues with items - better to prepared with thoughts than not to know what to do in case if
But even if ethereal_durability is set in Telecaster to 0, the result shouldn't be the problem he wrote about.

i tried on 7.2 and 9.1 if you put 0 dura in itemresource and hash it to resource its enough to fix the broken gear,

[YuhaBah]

Originally Posted by thefear511

i tried on 7.2 and 9.1 if you put 0 dura in itemresource and hash it to resource its enough to fix the broken gear,

What name you get for hashed db_item.rbd?

[thefear511]

Originally Posted by YuhaBah

What name you get for hashed db_item.rbd?

U{W.Y(_ZdT!JV

[YuhaBah]

Originally Posted by thefear511

U{W.Y(_ZdT!JV

Look, 9.4 client have 9.4 ItemResource while db have 9.1 and its work fine, but when i put hashed file to client from bd ( 9.1 structure ) then ALL items became undefined