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).
|
Threaded Mode
