[Help Thread] Please post your questions here.

Page 447 of 586 « First 347397437445446 447 448449457497547 Last »
11/14/2017 23:17 InkDevil#6691
Quote:
Originally Posted by YuhaBah View Post
But how i can remove durability from items in full?
I'd try
Code:
use Arcadia
UPDATE dbo.ItemResource
Set ethereal_durability = 0 where ethereal_durability <> 0
GO
:D
11/14/2017 23:49 YuhaBah#6692
Quote:
Originally Posted by LamiaCore View Post
I'd try
Code:
use Arcadia
UPDATE dbo.ItemResource
Set ethereal_durability = 0 where ethereal_durability <> 0
GO
:D
i try it before, so i have to restore this table, cause all item become broken xD
11/14/2017 23:53 InkDevil#6693
Quote:
Originally Posted by YuhaBah View Post
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.
11/15/2017 00:02 Shalindor#6694
@[Only registered and activated users can see links. Click Here To Register...]

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

Code:
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 @[Only registered and activated users can see links. Click Here To Register...] 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 :)
11/15/2017 01:15 ThunderNikk#6695
@[Only registered and activated users can see links. Click Here To Register...]

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.
11/15/2017 01:38 Shalindor#6696
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 ?
11/15/2017 12:21 YuhaBah#6697
Quote:
Originally Posted by LamiaCore View Post
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)

=(
11/15/2017 14:30 InkDevil#6698
Quote:
Originally Posted by Shalindor View Post
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 [Only registered and activated users can see links. Click Here To Register...])
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).


Quote:
Originally Posted by YuhaBah View Post
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:

So, what did you do additionally, that you killed your itemresource this way??? xDD
11/15/2017 15:54 YuhaBah#6699
Quote:
Originally Posted by LamiaCore View Post
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
11/15/2017 16:51 thefear511#6700
Quote:
Originally Posted by YuhaBah View Post
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.
11/15/2017 17:06 InkDevil#6701
Quote:
Originally Posted by thefear511 View Post
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 :D
But even if ethereal_durability is set in Telecaster to 0, the result shouldn't be the problem he wrote about.
11/15/2017 17:56 thefear511#6702
Quote:
Originally Posted by LamiaCore View Post
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 :D
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,
11/15/2017 20:07 YuhaBah#6703
Quote:
Originally Posted by thefear511 View Post
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?
11/15/2017 20:11 thefear511#6704
Quote:
Originally Posted by YuhaBah View Post
What name you get for hashed db_item.rbd?
U{W.Y(_ZdT!JV
11/15/2017 20:26 YuhaBah#6705
Quote:
Originally Posted by thefear511 View Post
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
Page 447 of 586 « First 347397437445446 447 448449457497547 Last »