Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 01:40

  • Please register to post and access all features, it's quick, easy and FREE!

 

Rappelz 9.1 item ID request

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2011
Posts: 6
Received Thanks: 0
Rappelz 9.1 item ID request

Hi guys could someone please upload the item ID's for 9.1 please thank you



buzzing is offline  
Old   #2
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,006
Received Thanks: 961
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.


ThunderNikk is offline  
Thanks
1 User
Old   #3
 
elite*gold: 0
Join Date: Nov 2011
Posts: 6
Received Thanks: 0
thank you
buzzing is offline  
Reply



« Previous Thread | Next Thread »



All times are GMT +2. The time now is 01:40.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.