[Help Thread] Please post your questions here.

[InkDevil]

Originally Posted by YuhaBah

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

Why don't you just read what I wrote before?..

Originally Posted by LamiaCore

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).




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

Why don't you just read what I wrote before?..

Okay, i execute 9.4 view and add 2 .lua for glandu2 tool folder. But when i try load itemRef94Database.lua with glandu2 tool its nothing happend and when i try load from SQL dbo.ItemReferenseResource it gives me error.

Maybe thats because i have 9.1 ItemResource?

[アルカード]

Originally Posted by YuhaBah

Okay, i execute 9.4 view and add 2 .lua for glandu2 tool folder. But when i try load itemRef94Database.lua with glandu2 tool its nothing happend and when i try load from SQL dbo.ItemReferenseResource it gives me error.

Maybe thats because i have 9.1 ItemResource?

Firstly do u use 9.4 or 9.1?
For 9.4 u need update rdb.itemresources and itemresources.ref for all custom items

[ThunderNikk]

Originally Posted by YuhaBah

Maybe thats because i have 9.1 ItemResource?

Why do you have 9.1 item resource? Are you running the 9.4 files or 9.1?

[JeeDee2]

Any1 know a good host(dedicated 24/7) cheap? its only for 5-10 pleople max
pref. in NA/BR
*Sry for bad english

[ThunderNikk]

5 to 10 people you could do on a home tower.

Have about 16 gig of ram and a good internet connection for the most important things.

Decent processor you can have a quad i5 or i7 but Rappelz is only going to use the first core anyway it is not very processor dependent. The server files may utilize more of the processor than the clients, but they still would not bog it down too much.

A regular off the shelf gaming tower could do 5 to 10 people for you.

As far as your question I really don't know much about server hosts.

[YuhaBah]

Originally Posted by ThunderNikk

Why do you have 9.1 item resource? Are you running the 9.4 files or 9.1?

I have a 9.1 structure of item resource! But i runing 9.4 . Did you have another structure with Revilution client and batabases?

Originally Posted by アルカード

Firstly do u use 9.4 or 9.1?
For 9.4 u need update rdb.itemresources and itemresources.ref for all custom items

From client rdb? when i do this, mu itemResource change the structure and all item became broken in all sense. I'll try what you said, TY

UPDATE

I try first dumped item.rdb from client ( cause in client its have 9.4 structure) then i replace my dbo.ItemResource with it and when i try use the SQL, that posted Gongor i get error.

How i know that my original dbo.ItemResource 9.1? glandu2 tool throw error, when i try to load from sql my itemresource with item94database.lua and work well with 91

[InkDevil]

Originally Posted by YuhaBah

I have a 9.1 structure of item resource! But i runing 9.4 . Did you have another structure with Revilution client and batabases?



From client rdb? when i do this, mu itemResource change the structure and all item became broken in all sense. I'll try what you said, TY

UPDATE

I try first dumped item.rdb from client ( cause in client its have 9.4 structure) then i replace my dbo.ItemResource with it and when i try use the SQL, that posted Gongor i get error.

How i know that my original dbo.ItemResource 9.1? glandu2 tool throw error, when i try to load from sql my itemresource with item94database.lua and work well with 91

I'll try it one more -and hopefully last- time to explain:
- download the view-create-script I've linked above (the view-query which is attached in the comment i've directly linked)
- use both luas Gangor posted in his thread, too(!!!! both should be added at the top of his thread)
- create db_item.ref and db_item.rdb with these 94 luas....
The structure for servermay be the same as it is for 9.1, but for Client/sFrame you need the 9.4 structure, which is by the way also already as rdb in your client....
The views combines all columns you need for the 9.4 structure.

[Shalindor]

@
Let me thanks for the tip, with Gangors Item-Generator Release it was no problem to build an db_item.rdb and db_item.ref. Hashed it and put it into the clients resource folder. All fine.

I have Revo 9.4 files and database

[YuhaBah]

Originally Posted by LamiaCore

I'll try it one more -and hopefully last- time to explain:
- download the view-create-script I've linked above (the view-query which is attached in the comment i've directly linked)
- use both luas Gangor posted in his thread, too(!!!! both should be added at the top of his thread)
- create db_item.ref and db_item.rdb with these 94 luas....
The structure for servermay be the same as it is for 9.1, but for Client/sFrame you need the 9.4 structure, which is by the way also already as rdb in your client....
The views combines all columns you need for the 9.4 structure.

I did exactly what you said but got insane mix from items icon and view of npc. Sorry that my silliness waste your time

[InkDevil]

Originally Posted by YuhaBah

I did exactly what you said but got insane mix from items icon and view of npc. Sorry that my silliness waste your time

No you didn't.
Because you didn't create additionally db_item.ref.
(it is btw the ItemReferenceDatabase.lua you have to choose when you want to create it.)
Otherwise your icons and models wouldn't be mixed ^^

Edit: Ah yeah, and you should use a query to make just one empty entry.

UPDATE dbo.ItemResource
SET [model_00]='' WHERE [model_00]= '0'
UPDATE dbo.ItemResource
SET [model_01]='' WHERE [model_01]= '0'
UPDATE dbo.ItemResource
SET [model_00]='' WHERE [model_02]= '0'
UPDATE dbo.ItemResource
SET [model_01]='' WHERE [model_03]= '0'
UPDATE dbo.ItemResource
SET [model_00]='' WHERE [model_04]= '0'
UPDATE dbo.ItemResource
SET [model_01]='' WHERE [model_05]= '0'
UPDATE dbo.ItemResource
SET [model_00]='' WHERE [model_06]= '0'
UPDATE dbo.ItemResource
SET [model_01]='' WHERE [model_07]= '0'
UPDATE dbo.ItemResource
SET [model_00]='' WHERE [model_08]= '0'
UPDATE dbo.ItemResource
SET [model_01]='' WHERE [model_09]= '0'
UPDATE dbo.ItemResource
SET [model_00]='' WHERE [model_10]= '0'
UPDATE dbo.ItemResource
SET [model_01]='' WHERE [model_11]= '0'
UPDATE dbo.ItemResource
SET [model_00]='' WHERE [model_12]= '0'
UPDATE dbo.ItemResource
SET [model_01]='' WHERE [model_13]= '0'
UPDATE dbo.ItemResource
SET [model_00]='' WHERE [model_14]= '0'
UPDATE dbo.ItemResource
SET [model_01]='' WHERE [model_15]= '0'
UPDATE dbo.ItemResource
SET [model_00]='' WHERE [model_16]= '0'
UPDATE dbo.ItemResource
SET [model_01]='' WHERE [model_17]= '0'
UPDATE dbo.ItemResource
SET [texture_filename]='' WHERE [texture_filename]= '0'
UPDATE dbo.ItemResource
SET [drop_type]='' WHERE [drop_type]='0'
UPDATE dbo.ItemResource
SET [icon_file_name]='' WHERE [icon_file_name]='0'
Go

[YuhaBah]

Originally Posted by LamiaCore

No you didn't.
Because you didn't create additionally db_item.ref.
(it is btw the ItemReferenceDatabase.lua you have to choose when you want to create it.)
Otherwise your icons and models wouldn't be mixed ^^

i swear, i was(ITu'(i)=rVUCH5!=8;T K& - hashed name of .ref). Now try to do this with this sql

Update: got thi message
Conversion failed when converting the varchar value 'dem_body_warrior204' to data type int.

[InkDevil]

Originally Posted by YuhaBah

i swear, i was(ITu'(i)=rVUCH5!=8;T K& - hashed name of .ref). Now try to do this with this sql

Update: got thi message
Conversion failed when converting the varchar value 'dem_body_warrior204' to data type int.

Changed query. try that one.

And by the way, the hashed .ref should be ~bWR@(C3!nyus

[YuhaBah]

Originally Posted by LamiaCore

Changed query. try that one.

And by the way, the hashed .ref should be ~bWR@(C3!nyus

i have other name =(

[ThunderNikk]

db_item(ascii).ref...I am getting this from Ncarbon dumper?

(4~-XpJip)bj!i_)AcIr

Same thing from Rappelz-Files Hasher.exe

But non (ascii) from Rappelz files hasher I get...

~bWR@(C3!nyus

When in doubt hash em both...its what I do. :P