how do i get item id from tooltip code in db_string.rdb

#Close_Request

#Close_Request

I am not sure why you are finding the tooltip code easier than you are finding the item ID but generally the tooltip and name codes that link to the string resource are just a number 1 or a number 2 added on to the front or beginning of the item ID. Unless they are 6 digit item id's then it will be a 10 or a 20 added on to it.

For instance the item ID for a creature taming scroll is 2012259 and its name_id is 12012259 and its tooltip_id is 22012259

To be sure of this you can run the following query

select * from arcadia.dbo.ItemResource where tooltip_id = xxxxxxxx

Where the xxxxx's are the code you have. It will return the entire table entry for the item.

If you only want the ID then target it to be more specific...

select id from arcadia.dbo.ItemResource where tooltip_id = xxxxxxxx

It will return the ID only.

Have you even looked at your Item Resource table to see how the name_id and tooltip_id columns work with the item ID?

Lastly you would have gotten a quicker response had you actually asked this question in the help thread of the Rappelz Private Server section of the forum.

The general Rappelz section is just general. Lucky someone even looked here at all for the question.

Quote:

Originally Posted by thndr I am not sure why you are finding the tooltip code easier than you are finding the item ID but generally the tooltip and name codes that link to the string resource are just a number 1 or a number 2 added on to the front or beginning of the item ID. Unless they are 6 digit item id's then it will be a 10 or a 20 added on to it. For instance the item ID for a creature taming scroll is 2012259 and its name_id is 12012259 and its tooltip_id is 22012259 To be sure of this you can run the following query select * from arcadia.dbo.ItemResource where tooltip_id = xxxxxxxx Where the xxxxx's are the code you have. It will return the entire table entry for the item. If you only want the ID then target it to be more specific... select id from arcadia.dbo.ItemResource where tooltip_id = xxxxxxxx It will return the ID only. Have you even looked at your Item Resource table to see how the name_id and tooltip_id columns work with the item ID? Lastly you would have gotten a quicker response had you actually asked this question in the help thread of the Rappelz Private Server section of the forum. The general Rappelz section is just general. Lucky someone even looked here at all for the question.

Problem Solved!
#Close_Request

How selfish you don't even leave traces of your thread behind to help others who may have the same problem.

I am now sorry I took the time to answer in the first place.