SUO Item Type Database

[Cerveza]

So what do we think about this idea?

If we could put together a simple item scanner to get the #property Name, and Item TYPE, maybe color, and have it all save to a text file. Then we just upload the text files and paste them together in a spread sheet, sort them and delete the duplicates. That would give us a "master listing" of items and TYPES on OSI shards.

We could go as far as sorting them into different categories if someone wanted to spent the time doing it.

Two types of scanners could be used.

1 - A "Miffy" item finder that would scan all surrounding containers and keep the info.
2 - A "Runner" that would scan everything visible while moving around.

Thoughts?

[TrailMyx]

Well, remember I already have that World Item Catelogger and a pretty huge database already.  All that really needs to happen is to convert that EasyUO database to something that can be imported into MySQL.  I would have to write a merge script in PHP that would take databases and merge only new information, but then people could submit their information and it could be merged easily.

Lemme dust off the WIC and see if it's ready for people to play with.  Since it's EasyUO, it's rather slow loading in larger databases and does have it's quirks.  I'm almost level 70 in WoW, so a break is in order.

I do remember one bug I have to fix that was corrupting the database, so I do have to fix that finally.

[_C2_]

I absoultly want to see color added as a column next to the item.   A lot of coders use that often and have to go find it.  I think that would add to the draw.

I think a run around script would be nice if it saved its own database and ignored items once it wrote them... if it scans a deamon and gets FD... then it ignores anything that is FD from every use.  That would help a lot with script getting items fast enough on a run around version and hopefully eliminate a bit of the deleting process.

it would be nice to see the data base searchable by...
name
monsters
tools
animals
resources
etc....

have columns....
item/monster                    Id(s)                        Color

[Cerveza]

It would be a great idea to have the scanners ignore items already on the list.

I think the problem is that there are so many item TYPES in the game that the ignore list would grow HUGE and unmanageable in EUO. Not sure about that though.

And formatting will be easy once the data is collected. Data would have to include Name/ID and I think Color would be awesome to include.

If the final output would be categorized, it would have to be done manually by someone very familiar with game items. Most of it would go quickly, but there are some very odd items. I suppose it could be a collective effort, making an UNKNOWN category and have people speak up when they know what it category it should go in.

Would some kind of Wiki work for this? I'm wondering how we incorporate it into SUO?

[TrailMyx]

That's sort of how the WIC works now:



For this example, I've kept an array of "ITK" starting from 0 to whatever.  So it will keep unique creatures/items by name.

Here's a different search for title instead.



Search for items with "MIST" in the name:

[Tidus]

what i would like to see in the database is the item type and the #findCol   that way we can make a comprehensive one.  And you could make a script like miffy's that auto puts it in a txt/html file, but instead puts it to an XML file which you can sometimes convert to a database file.

XML for the win

[TrailMyx]

what i would like to see in the database is the item type and the #findCol   that way we can make a comprehensive one.  And you could make a script like miffy's that auto puts it in a txt/html file, but instead puts it to an XML file which you can sometimes convert to a database file.

XML for the win

#FINDCOL is an easy add.

The problem with XML and EasyUO is that you'd have to output each line at a time and file saving would take literally 100 years.  My file save routines cut that into a fraction of the time, but from there you can use a script in PHP, Python to convert the database to whatever format you want.  If you are converting to a format, you might as well just convert it directly to the database instead of having to convert it again after you get it into another format.

It would be rather easy to make some VB/C# helper routines to save items.  I have my old VB ones laying around.  I never used them just because I wanted the scripts to stand alone without any other dependencies.  They're slower, but at least everyone can use them.

What I may do is just put up the WIC for you guys to look at and play with.  I'm sure I don't have much time to work on this but if you guys get some traction regarding content, I'd be glad to host it.

[Cerveza]

A random walker script to run along with this would be pretty awesome.

Have a walker script that would get itself out of spots if it gets stuck. Have some options with it like "take all gates/stairs" or something. You could plant it in the bottom level of a dungeon and let him run for a couple hours, come back and he'd found his way to the exit and logged everything along the way 

[TrailMyx]

A random walker script to run along with this would be pretty awesome.

Have a walker script that would get itself out of spots if it gets stuck. Have some options with it like "take all gates/stairs" or something. You could plant it in the bottom level of a dungeon and let him run for a couple hours, come back and he'd found his way to the exit and logged everything along the way 

Would you like fries with your order, Sir? :p

[Cerveza]

LOL actually I think the wander bot would be the easiest to do. Just put in a little "right hand rule" logic and let it go. It "should" find stairs or teleports between levels.

[Khameleon]

years ago I helped easyuo put together there item catalog, but that script is long gone.  besides Tm's looks much more advanced, the menu wasn't even available when I wrote my script. had to use the old writetofile.bat

[Gemviper]

Sorry for bumping this post a bit but TM you mentioned having an item database, you know what would be really cool? If the IDOC looter prioritized those items based on player value and other factors. Sites like finduo already monitor item prices and availability to keep their sites automated/updated but I'm not sure the same is being done to make sure you focus on the highest value targets at idoc.

When I built my idoc wrecker I knew it was only as good as the list I provided it with and I was doing that manually as I found items I wanted to focus on, a database and value integration would be next. Making it grab rares and EM items first would be good too, if they are there and I don't tell it otherwise. I enjoy working out this type of thing but before I do(eventually) has something like this been done yet?

Gem

[TrailMyx]

That database pushed the limits of EUO and really wasn't all that useful.  Hopefully now that I'm spending more time with Stealth, I'll be able to finally start coming up with some really cool new things.  Perhaps once Crome stops refactoring things... :p

[Gemviper]

Just a heads up that the itemlist catalog is out of date and missing many types(of everything, not only statuettes, ex: house teleporter tiles) http://www.easyuo.com/itemdb/?search=search

Does anyone have a list of statuette item types handy? If not I'll do the vendor search thing and gather as many as I can later on.

[Crome969]

You very easy can make your own type catalog.. Open fiddler Check Graphics. The Value of a graphic is converted in EUO. There was a converter online for runuo to euo. With this you can convert graphic types from fiddler to euo