Finding an Item Number?

[Giopawa]

How would I go about finding item numbers for items?

Sorry if this does not belong in this thread.

[Zengez]

There are two ways to do it, from inside the game as a GM (or with the #finditem command) or outside the game in the database...

If you don't know how to use SQL, then it's much easier to use the in game menu where you simply type #finditem (part of item's name)

So say I want to know the item numbers for banded armor... I can simply type;

#Finditem Banded

Then it will list item numbers followed by item descriptions... I don't know any but for the sake of example assume these are correct;

22003 Banded Helm
22004 Banded Tunic
22005 Banded Gloves

Etc. Unfortunately you, at times, need to be specific because in game will only list 20 items before it errors out as too many items, so the above find attempt will give you anything with 'banded' in it, including large and small banded armor numbers which may or may not help you.


If you're comfortable with SQL, you can merely run a search query through the database, such as "Select ID,Name from Items where name LIKE "%banded%"; It's been a while since I've done any SQL and I usually get it wrong the first time but I think that's right... someone else can correct the syntax if it's not.

Basically that will do the same thing as the in game menu, pulling up anything where banded is in the title. Using LIKE and % functions are what allows you to do that as the % means anything is acceptable on that side of what you wrote. Thus if you type %banded that will give you (blah blah blah) Banded. Which would get you nothing as banded never ends with that word, but rather banded Gloves or Tunic or something after it. conversely using Banded% would get you anything that started with "banded" and may or may not have anything after it. Thus "Banded Arms" would work "Small Banded Arms" would not.

Hope that helps, as I said, the in game menu is loads more user friendly if you don't know how to use SQL, the only real downside is the 20 line limit (wish we could extend that /shrug).

[Giopawa]

Can you tell me a server where I may use the #finditem command?
If there is not one up now,
Can you help me out with the SQL?

[John Adams]

To find items containing any of your letters:
select * from items where name like '%partial name%';

To find items starting with any of your letters:
select * from items where name like 'partial name%';

To find items ending any of your letters:
select * from items where name like '%partial name';

etc... "like" is the option you're looking for. the percents '%' are like wildcards.


Example:
select * from items where name like '%ration%';

...would return anything in the Item Database with the word "ration" anywhere in the name.


If you do not want to see the whole Item record, change "select *" to "select id, name"... etc. A valid column name from the Items table.

[Giopawa]

Awesome,
One more question though,
Where is the database, I am not sure I get what you mean.
I know if you use SQL with an website you do it in an open form like a place you would type in a password or what not.
I don't truly get it with a program though..... not that I truly get it with the web either lol.

[John Adams]

Oh, I thought you had your own Emulator and database setup. If not, I am pretty sure the Allakhazam's Item IDs line up with ours (not the custom items, of course). Also, since our Items are mostly sourced from 13th Floor, those item ID definitely line up fine.

Search the text file by name, and it's ID will be right there too. Open in Excel if you have it, works great.