>< Desperately seeking a "searchable database" for gear ><

[danielbrown1969]

The title pretty much says it all, but to clarify:

We need a database that we can use to, as examples, search for:

~ ~ a level 40-45 heavy chest piece that has both vitality and morale as well as icmr

~ ~ or perhaps we need a level 50-60 light armor shoulder piece that has intermittent morale proc.

Obviously, the database would need to have every possible affix with a value range field (in case we wanted only a piece with >100 power instead of all pieces with power).

Also, having the functionality to include or preclude "only quest items" and/or "craftable" and/or "BoP items" and/or world drop BoE items.

I have googled this subject matter and virtually every post I have read says something to the effect of "we need this" and "why doesn't LOTRO offer this like ABC game does". On the surface, one might think this is a massive undertaking but upon further reflection one must understand that the game designers/programmers already have such a list so all that is really needed is to format this list and make it available to use.

Thank You!

~Happy Gaming~

[Yula_the_Mighty]

The only way it will happen is if us customers build it ourselves on the web perhaps within the lotro-wiki.

We had a partial implementation via exports from the game software to the Turbine web servers. Turbine could never get the web exports to work correctly. Customers kept complaining about about the accuracy problems. Middle of 2013, Turbine pulled the plug and the web data all went dark. Pulling the plug resolved the customer complaints about accuracy.

Turbine had web Skirmish leade boards, PvP leader boards, character blogs, kinship blogs, character sheets with the equipment that our characters were wearing and a activity log. Plus a kinship sheets. There was a lore book with quest, crafting recipes and other stuff. A Google map. I forget what all else. All gone middle of 2013.

[maartena]

Yep, someone needs to do it. Turbine isn't going to build it for us, they want us to discover everything in game anyways.

This site here has got a LOT, and it is fairly complete, but some of the level 90+ stuff isn't in yet.

http://lotro.allakhazam.com/db/itemlist.html

[danielbrown1969]

Thank you both for replies. I have been away from LOTRO for the past 4-5 years so I wasn't aware of the attempt and ultimate failure of what you mentioned in 2013. That is too bad - I know of many other games that have a very sophisticated database so "it can't be that hard" with the proper effort. As to allakhazam, I used that site a lot in my WOW days and enjoyed it. I did just now take a look at for LOTRO it but couldn't find any way to search BY any of the affixes and in fact, many of the cursor-over tooltips seemed not to work. If I knew anything about coding I would offer to help start a database site, but alas I can't even program my VCR :-)

[Calta]

These are the ones i have bookmarked. I think, apart from the HD BB ones, mostly they are the same now,-just stats are scaled to 100.
hope they help.

https://docs.google.com/spreadsheet/...=sharing#gid=0
from Dec 2013, by class (tabs at bottom) the instances are listed on far right column (scroll across)

and
https://www.lotro.com/forums/showthr...85#post7043285
How the scaling loot was updated in 2012 by Verizal. Makes for interesting reading

[danielbrown1969]

These are the ones i have bookmarked. I think, apart from the HD BB ones, mostly they are the same now,-just stats are scaled to 100.
hope they help.

https://docs.google.com/spreadsheet/...=sharing#gid=0
from Dec 2013, by class (tabs at bottom) the instances are listed on far right column (scroll across)

and
https://www.lotro.com/forums/showthr...85#post7043285
How the scaling loot was updated in 2012 by Verizal. Makes for interesting reading

TYVM! I will check these out later when I am @ work

[Roberto_the_First]

I used to maintain something like that on warcry before they changed direction.

[Yula_the_Mighty]

That is too bad - I know of many other games that have a very sophisticated database so "it can't be that hard" with the proper effort.

There is a very significant cost for this feature. It is something that you have to decide you want to do when writing out the game concepts. You start building in the feature as part of the creating of the initial application files, tools and databases. For the companies that I worked at as software designer we did not web enable the data to make our customers happy. We web enabled it very early on in the development process to make our jobs easier. Since we used the web databases to create feature documents, code, test and all aspects of the project, we made sure everything worked right. Otherwise, we had to spend unnecessary time getting at information.

We enabling had the nice benefit of reducing the cost of some writing parts of the application. When I worked on a hand held device like a cell phone, the entire User Interface was done in C++ code. You needed to change something you edited the code. Rebuilt the load. Make a mistake. The device crashed when you went to that panel within the UI. I helped switch over to using web page for the UI panels. Need to change a pic, move it around, resize it. FTP the need pic to the device. Edit the HTML. Change could be done in 1-5 minutes instead of 75-90 minutes. C++ designer - 100k a year. Web designer - hire a CSE graduate student pay them 15 dollars an hour (30k a year).

Lotro is a very old application. Turbine probably began work on it 10 years ago - 2005 or so. Turbine imported a lot of code and practices from existing games some of which go back the mid 1990s when everybody was using dial up. You have an application which has some code going all the way back to 1995.

Old code is normal in companies that have been doing the same thing for years. I worked on a project for a new hand held device. I started looking at some of the code in 2008. The creation date on parts of the software had creation dates of early last century. One of the modules which nobody wanted to touch had a date of 1982 or 3. I went - I can deal with this code. I remember this processor. I started engineering school in 1971. All the other people on the project were much younger with me. They had never seen the 8086 processor. In my case, I was in school when the 8008 came out. I was working when the 8086 came out.

Turbine had a terrible time with the web enabled data because it was a feature added long after Lotro went live. Instead of being something put into the application early on to help the developers get to the point where the first version of the application runs.

[Berelor]

There is also the item database plugin from Galuhad available:

http://www.lotrointerface.com/downlo...mTreasury.html
http://www.lotrointerface.com/downlo...mDatabase.html

It shows you every item in the game.

Hope this helps.

[danielbrown1969]

@ Yula - TY 4 reply. I appreciate your explanation and answer. It is unfortunate that Turbine did not have the foresight to properly code their items in-game to make their customers happy and satisfied. As to the age of the game itself being a contributing factor, I have to admit skepticism based on my knowledge of several independent database websites for another mmorpg that I used to play (WOW) which is older than LOTRO.

@ Berelor - TY 4 links. Seems like a good program feature IF I know the name of the piece of gear I am searching for. Unfortunately, what I am (and I am sure many others) are looking for is a searchable database whereby one can "browse" through unknown items based soley on inputting parameters into the database (ie., all items with Might >= 50 and Vitality >= 50 and ICMR >= 50 ... or any of the millions of possible combinations of gears).

Oh well, I guess I will need to (hopefully) find a NON in-game website that has "every item" in game and then just manually go thru them all one at a time as I search for the gear that I want. In case anyone is wondering "why not in-game" - I work 10 hours a day with an hour travel time so my actual in-game play time is limited but while I am AT work, I have several hours a day where I can browse as desired in an effort to maximize my actual play time.

[Altair6]

There's Tulkas - http://www.lotrointerface.com/downlo...69-Tulkas.html

It has a search function but I don't know if it will do exactly what you want.

[danielbrown1969]

There's Tulkas - http://www.lotrointerface.com/downlo...69-Tulkas.html

It has a search function but I don't know if it will do exactly what you want.

TY TY TY! I am at work so haven't installed this in-game (yet) but after a quick look at the site and reading a bit about the plugin, it does indeed look to be almost exactly what I wanted. I would prefer to be able to do my research off-line (while I am at work) but this plugin certainly seems thorough - even comparing "hypothetical gear" to know beforehand whether the gear is an upgrade or merely a sidegrade. It doesn't appear to have all the affixes I desire (like "+intermittent morale"), but it has the main 20 or so which is helpful albeit not complete.

Thanks again ><

~Happy Gaming~

[Castorix]

I had made a SQL database with all items (+ many cosmetics, several weeks to generate them...) in U15; I just completed it wih U16 items.
I added those criteria, I think they are sufficient :



=> LOTRO Item Database

[danielbrown1969]

I had made a SQL database with all items (+ many cosmetics, several weeks to generate them...) in U15; I just completed it wih U16 items.
I added those criteria, I think they are sufficient :



=> LOTRO Item Database

Thanks for the hard work and for sharing this with me!

I am at work atm so cannot download and open the zip file, but I will take a look at it from home later ><

[cdq1958]

I had made a SQL database with all items (+ many cosmetics, several weeks to generate them...) in U15; I just completed it wih U16 items.
I added those criteria, I think they are sufficient :



=> LOTRO Item Database

This is wonderful!

Thanks.

[TurinTickler]

I had made a SQL database with all items (+ many cosmetics, several weeks to generate them...) in U15; I just completed it wih U16 items.
I added those criteria, I think they are sufficient :



=> LOTRO Item Database

When I try to download this with Chrome it gets flagged as malicious. Anyone know why?

[Lilka]

My PC is displeased and firing up virus warnings all over the show. Opening the file did nothing; exe didn't run.

I prefer the old days with pictures on webpages

[fredtellier]

My PC is displeased and firing up virus warnings all over the show. Opening the file did nothing; exe didn't run.

I prefer the old days with pictures on webpages

Temporarily disable or add exceptions in anti-viruses
it works perfectly and it is the only complete database for Lotro

[SummerStorm]

I had made a SQL database with all items (+ many cosmetics, several weeks to generate them...) in U15; I just completed it wih U16 items.
I added those criteria, I think they are sufficient :



=> LOTRO Item Database

Castorix this is awesome! Thank you very much for sharing!!!

[TurinTickler]

Temporarily disable or add exceptions in anti-viruses
it works perfectly and it is the only complete database for Lotro

Just because it looks like it works perfectly, doesn't mean it isn't a vector for something malicious. Some viruses and malware can even get into a package without the author's intent to do so. I would really like to understand why multiple programs are flagging this download. It looks like a great tool, and I want to use it. I just don't have the time to setup a safe area to use it in isolation in case it has real problems.

[Altair6]

I don't get any virus warnings but it doesn't run anyway.

[Irin19]

I had made a SQL database with all items (+ many cosmetics, several weeks to generate them...) in U15; I just completed it wih U16 items.
I added those criteria, I think they are sufficient :



=> LOTRO Item Database

Love this! Does it include what the items look like? I ask, because with the coming of cosmetic weapons this could be a great resource to see what weapons look like.

[fearlessassassins]

Virus total:

https://www.virustotal.com/en/file/d...is/1435344035/


Comes up clean so no idea why some of you get warnings. Make sure you run as admin if it doesn't run for you

[RJFerret]

Apparently the code wasn't linked with necessary libraries, seems to be missing DLLs.

(Running as admin made no difference.)

[fredtellier]

Apparently the code wasn't linked with necessary libraries, seems to be missing DLLs.

(Running as admin made no difference.)

There is no missing DLL on my PC.
Dependency Walker can be used to see if some DLLs are missing.