We have detected that cookies are not enabled on your browser. Please enable cookies to ensure the proper experience.
Page 1 of 3 1 2 3 LastLast
Results 1 to 25 of 60
  1. #1
    Join Date
    Nov 2010
    Location
    Mesa, Arizona
    Posts
    1,078

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

    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~

  2. #2
    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.
    Unless stated otherwise, all content in this post is My Personal Opinion.

  3. #3
    Join Date
    Feb 2011
    Posts
    4,149
    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
    Moved from Riddermark to Arkenstone on 9/29/2015!
    -----
    Disclaimer: The definition of "Soon™" is based solely on SSG's interpretation of the word, and all similarities with dictionary definitions of the word "Soon™" are purely coincidental and should not be interpreted as a time frame that will come to pass within a reasonable amount of time.

  4. #4
    Join Date
    Nov 2010
    Location
    Mesa, Arizona
    Posts
    1,078
    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 :-)
    Learn much I must
    Kill many I will
    Grow stronger
    Live Longer

  5. #5
    Join Date
    Oct 2010
    Location
    Central Victoria, Australia
    Posts
    1,904
    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
    Last edited by Calta; Feb 03 2015 at 02:56 AM.

    And the minstrel sang to them……”and they passed in thought out to regions where pain and delight flow together and tears are the very wine of blessedness.”

  6. #6
    Join Date
    Nov 2010
    Location
    Mesa, Arizona
    Posts
    1,078
    Quote Originally Posted by Calta View Post
    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
    Learn much I must
    Kill many I will
    Grow stronger
    Live Longer

  7. #7
    Join Date
    Oct 2009
    Posts
    2,867
    I used to maintain something like that on warcry before they changed direction.

  8. #8
    Quote Originally Posted by danielbrown1969 View Post
    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.
    Unless stated otherwise, all content in this post is My Personal Opinion.

  9. #9
    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.

  10. #10
    Join Date
    Nov 2010
    Location
    Mesa, Arizona
    Posts
    1,078
    @ 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.
    Learn much I must
    Kill many I will
    Grow stronger
    Live Longer

  11. #11
    Join Date
    Oct 2012
    Location
    Lancashire, UK
    Posts
    1,773
    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.

  12. #12
    Join Date
    Nov 2010
    Location
    Mesa, Arizona
    Posts
    1,078
    Quote Originally Posted by Altair6 View Post
    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~
    Learn much I must
    Kill many I will
    Grow stronger
    Live Longer

  13. #13
    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

  14. #14
    Join Date
    Nov 2010
    Location
    Mesa, Arizona
    Posts
    1,078
    Quote Originally Posted by Castorix View Post
    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 ><
    Learn much I must
    Kill many I will
    Grow stronger
    Live Longer

  15. #15
    Join Date
    Jun 2010
    Location
    Alabama
    Posts
    6,342
    Quote Originally Posted by Castorix View Post
    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.
    "No sadder words of tongue or pen are the words: 'Might have been'." -- John Greenleaf Whittier
    "Do or do not. There is no try." -- Yoda
    On planet Earth, there is a try.
    Indeed, in a world and life full of change, the only constant is human nature (A is A, after all :P).
    We old vets need to keep in mind those who come after us.

  16. #16
    Quote Originally Posted by Castorix View Post
    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?

  17. #17
    Join Date
    Jun 2011
    Location
    England
    Posts
    1,408
    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
    'A cage,' she said. 'To stay behind bars, until use and old age accept them, and all chance of doing great deeds is gone beyond recall or desire.'

    [anor] lilka : warden | tam : minstrel
    [evernight] lilka : warden | gwenaëlle : champion | elorie | minstrel | cedar : hunter


  18. #18
    Quote Originally Posted by Lilka View Post
    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

  19. #19
    Join Date
    Dec 2011
    Location
    The Netherlands
    Posts
    18
    Quote Originally Posted by Castorix View Post
    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!!!
    [charsig=http://lotrosigs.level3.turbine.com/0e2150000000f6ee6/01004/signature.png]undefined[/charsig]

  20. #20
    Quote Originally Posted by fredtellier View Post
    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.

  21. #21
    Join Date
    Oct 2012
    Location
    Lancashire, UK
    Posts
    1,773
    I don't get any virus warnings but it doesn't run anyway.

  22. #22
    Join Date
    Apr 2007
    Location
    Menomonie, WI
    Posts
    1,666
    Quote Originally Posted by Castorix View Post
    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.
    Irin r8 Hunter // Arngar r8 Burg // Akthuri r15 LM // Vishus r5 Captain // Curad r11 (active) Mini

  23. #23
    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
    Underachieving - R8 Burg - Elendilmir
    Warta - R5 Warden // Dolvidhal - R9 Spider // Creeperr - R7 Warg // Uncreative - R5 Reaver - Imladris
    Retired until Turbine starts making quality raids again

  24. #24
    Join Date
    Aug 2010
    Location
    your mind
    Posts
    3,880
    Apparently the code wasn't linked with necessary libraries, seems to be missing DLLs.

    (Running as admin made no difference.)
    Link to our community LOTRO store google spreadsheet pricelist and conversion rates, please contribute too!: https://goo.gl/wxPqCm

  25. #25
    Quote Originally Posted by RJFerret View Post
    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.

 

 
Page 1 of 3 1 2 3 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

This form's session has expired. You need to reload the page.

Reload