[Help Thread] Please post your questions here.

Quote:

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

Quote:

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 [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). 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 [Only registered and activated users can see links. Click Here To Register...] So, what did you do additionally, that you killed your itemresource this way??? xDD

Quote:

Originally Posted by LamiaCore Why don't you just read what I wrote before?..

Quote:

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?

Quote:

Originally Posted by YuhaBah Maybe thats because i have 9.1 ItemResource?

Quote:

Originally Posted by ThunderNikk Why do you have 9.1 item resource? Are you running the 9.4 files or 9.1?

Quote:

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

Quote:

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

Quote:

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.

Quote:

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 :o

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

Quote:

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 ^^

Quote:

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.

Quote:

Originally Posted by LamiaCore Changed query. try that one. And by the way, the hashed .ref should be ~bWR@(C3!nyus