Rappelz 9.1 item ID request

They are in the arcadia.dbo.ItemResource table.

Far too many to upload sorry.

Maybe if you were slightly more specific someone could show you a few or maybe even teach you how to write an SQL join query that will let you link an item resource ID to the item name in the string resource table like...

Code:

USE ARCADIA
GO

SELECT 
ITEMRES.id as item_id, STRINGRES.value as item_name, TOOLTIP.value
FROM 
dbo.ItemResource ITEMRES
LEFT JOIN
dbo.StringResource STRINGRES
ON 
STRINGRES.code = ITEMRES.name_id
LEFT JOIN 
dbo.StringResource TOOLTIP
ON
TOOLTIP.code = ITEMRES.tooltip_id

WHERE STRINGRES.value LIKE '%medusa%' OR  STRINGRES.value LIKE '%bone dragon%'

Just for an example.

This was written by someone else BTW it is not mine I was too lazy to write a join query right now, and there are much simpler ways to write them.