|
You last visited: Today at 05:19
Advertisement
[Help Thread] Please post your questions here.
Discussion on [Help Thread] Please post your questions here. within the Rappelz Private Server forum part of the Rappelz category.
11/14/2017, 23:17
|
#6691
|
elite*gold: 0
Join Date: Sep 2015
Posts: 594
Received Thanks: 1,188
|
Quote:
Originally Posted by YuhaBah
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
|
|
|
11/14/2017, 23:49
|
#6692
|
elite*gold: 0
Join Date: Apr 2017
Posts: 109
Received Thanks: 9
|
Quote:
Originally Posted by LamiaCore
I'd try
Code:
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
|
|
|
11/14/2017, 23:53
|
#6693
|
elite*gold: 0
Join Date: Sep 2015
Posts: 594
Received Thanks: 1,188
|
Quote:
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.
|
|
|
11/15/2017, 00:02
|
#6694
|
elite*gold: 0
Join Date: Jun 2009
Posts: 28
Received Thanks: 8
|
Creature Dura
@
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 @ 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
|
#6695
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,779
Received Thanks: 1,461
|
@
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
|
#6696
|
elite*gold: 0
Join Date: Jun 2009
Posts: 28
Received Thanks: 8
|
db_item.rdb
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.*** ?
|
|
|
11/15/2017, 12:21
|
#6697
|
elite*gold: 0
Join Date: Apr 2017
Posts: 109
Received Thanks: 9
|
Quote:
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)
=(
|
|
|
11/15/2017, 14:30
|
#6698
|
elite*gold: 0
Join Date: Sep 2015
Posts: 594
Received Thanks: 1,188
|
Quote:
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).
Quote:
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:
So, what did you do additionally, that you killed your itemresource this way??? xDD
|
|
|
11/15/2017, 15:54
|
#6699
|
elite*gold: 0
Join Date: Apr 2017
Posts: 109
Received Thanks: 9
|
Quote:
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
|
|
|
11/15/2017, 16:51
|
#6700
|
elite*gold: 0
Join Date: Nov 2012
Posts: 920
Received Thanks: 234
|
Quote:
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.
|
|
|
11/15/2017, 17:06
|
#6701
|
elite*gold: 0
Join Date: Sep 2015
Posts: 594
Received Thanks: 1,188
|
Quote:
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.
|
|
|
11/15/2017, 17:56
|
#6702
|
elite*gold: 0
Join Date: Nov 2012
Posts: 920
Received Thanks: 234
|
Quote:
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,
|
|
|
11/15/2017, 20:07
|
#6703
|
elite*gold: 0
Join Date: Apr 2017
Posts: 109
Received Thanks: 9
|
Quote:
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?
|
|
|
11/15/2017, 20:11
|
#6704
|
elite*gold: 0
Join Date: Nov 2012
Posts: 920
Received Thanks: 234
|
Quote:
Originally Posted by YuhaBah
What name you get for hashed db_item.rbd?
|
U{W.Y(_ZdT!JV
|
|
|
11/15/2017, 20:26
|
#6705
|
elite*gold: 0
Join Date: Apr 2017
Posts: 109
Received Thanks: 9
|
Quote:
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
|
|
|
Similar Threads
|
[Helping Topic] 24/7 Helping Services!
08/27/2008 - EO PServer Hosting - 31 Replies
stucked on anything while setuping your server?
post your problem here and you will get answer as fast as possible better than spamming with posts :cool:
first of all try reading Ahmedpotop's Pserver All thing guide.
if your couldn't solve it out post your problem down here
""That includes PHP rankings pages / registrations pages / Status pages""
|
All times are GMT +2. The time now is 05:19.
|
|