Page 1 of 17 1234511 ... LastLast
Results 1 to 20 of 331
  1. #1
    Founder & Hero jjflanigan's Avatar
    Join Date
    Feb 2006
    Posts
    5,000

    Default Static Rewards and Unique Loot Web Application

    The intention of this application is to be a "wiki" of sorts for static rewards and unique loot (i.e. a web application version of the amazing loot thread).

    It currently has 1694 items in it. The item data was originally parsed from the loot thread and as since been updated / improved / cleaned up by myself and the many people that have offered to help in getting the application up to snuff. Including adding information about upgrading items, non-standard acquisition of items, etc.

    It allows users to search for items via:
    • Name
    • Keywords
    • Type and subtype
    • If / How the item binds
    • Whether or not it is exclusive
    • The min level of the item
    • The Adventure pack it requires to loot it
    • When it was added to the DB
    • The Quest of Chain from which it comes
    • Whether or not it comes from a F2P quest or not


    Additionally you can search the quests that are indexed and see all of the items that come from the various quests via that method.

    A threaded view has been added that more closely resembles the original item listing from the loot thread for those who prefer a full browsable listing of items.

    You can link directly to any item details in the system by the ID or by the name of the item:

    http://itemwiki.cubicleninja.com/ite...n%20Eardweller

    You can also link directly to an image in the system like so where the thumbnail parameter can be any of these values:
    • 0: full size / quality
    • 1: reduced size / quality
    • 2: greatly reduced size / quality
    • 3: thumbnail tiny size / quality


    http://itemwiki.cubicleninja.com/ima...n%20Eardweller


    Links to the Standard and MyDDO version of the site:

    Static Rewards and Unique Loot Web Application
    Static Rewards and Unique Loot Web Application (MyDDO Friendly) (Alternately, just opening the base page in the MyDDO browser automatically adjusts now)
    New, Cleaner, pure search interface
    Advanced search interface with all the filters
    Last edited by jjflanigan; 09-11-2011 at 12:02 PM.

  2. #2
    Founder & Hero Fixitosis's Avatar
    Join Date
    Feb 2006
    Posts
    313

    Default

    Awesome... Thank you. This'll be great.

  3. #3
    Community Member sephiroth1084's Avatar
    Join Date
    Jan 2008
    Location
    Staten Island, NY
    Posts
    12,813

    Default

    I'm excited about this!
    Useful links: A Guide to Using a Gamepad w/ DDO / All Caster Shroud, Hard Shroud, VoD, ToD Einhander, Elochka, Ferrumrym, Ferrumdermis, Ferrumshot, Ferrumblood, Ferrumender, Ferrumshadow, Ferrumschtik All proud officers of The Loreseekers. Except Bruucelee, he's a Sentinel!

  4. #4
    Founder & Hero jjflanigan's Avatar
    Join Date
    Feb 2006
    Posts
    5,000

    Default

    Alright, I had a moment so I reworked my regex for parsing the thread -- the search now contains 1205 items (14 of them had invalid images so are now using a placeholder image). I also adjusted the indexes on my DB so I was able to up the item return limit to 100 for now and it should be faster as well.

  5. #5

    Default

    Really looking forward to this!
    Argonnessen mains: Pinku, Ohtaku

  6. #6
    Founder & Hero jjflanigan's Avatar
    Join Date
    Feb 2006
    Posts
    5,000

    Default

    Yay for not being able to sleep due to car alarms constantly going off...

    I went back through and linked many of the items to the quests from which you can get them ( wow, that was tedious to do) . I also adjusted weapons to have a sub-type to make it easier to search for a specific weapon type.

    Additionally, I made a first pass at the item detail page and that is what the search results now link to.

    Made a few more tweaks to my DB indexes and my keys to try to optimize the searching a bit more.

  7. #7
    Founder & Hero jjflanigan's Avatar
    Join Date
    Feb 2006
    Posts
    5,000

    Default

    Redid my code to create the thumbnails to allow them to appear crisper
    Redid the results page to come back in search results style instead of a grid (let me know which you guys like better, please)

    Added in logging and user access roles
    Added the ability to edit and add new items via the web interface
    Added audit logging for edits made to items to allow for "rolling back"

    Anyone interested in (willing to) help with item clean up and adding missing items into the system, please drop me a PM with your desired username and whether you want to be able to just add new items or add new items and edit existing ones. I'll get you set up and reply back with your ID/password so you can get started.

  8. #8
    Founder & Hero jjflanigan's Avatar
    Join Date
    Feb 2006
    Posts
    5,000

    Default

    Added paging to results page
    Added the ability to search for recently added items.
    Last edited by jjflanigan; 11-01-2010 at 02:26 PM.

  9. #9
    Founder & Hero jjflanigan's Avatar
    Join Date
    Feb 2006
    Posts
    5,000

    Default

    Based upon a suggestion I received I've put in a piece of code that attempts to locate the link for the quest name on the ddo wiki and automatically link to it from the item detail page.

    Not 100% tested so not sure how accurate it will end up being, but it worked for the 6 quests I tested.

  10. #10
    Founder Kale_Hagan's Avatar
    Join Date
    Feb 2006
    Location
    Beyond The Sun
    Posts
    832

    Default

    Holy cow this is awesome. +1 rep for sure!

    This will most likely replace my Definitive Loot Thread favorite.
    "Funny 'Ha-Ha, or Funny 'Uh-oh...'?
    Probably Funny 'Uh-Oh.'"
    Khyber - Mesaana, Samaeila Suncrusher

  11. #11
    Community Member augie's Avatar
    Join Date
    Feb 2006
    Location
    Minnesota
    Posts
    520

    Default

    Insanely useful! Great search options as well.

    +4,000,000!!
    (TR)
    Elite Raiders and Twilight Alliance guilds
    Journal of an Experienced Newbie - Level 1 thru 10 - (Melee)

  12. #12
    Founder & Hero jjflanigan's Avatar
    Join Date
    Feb 2006
    Posts
    5,000

    Default

    Created a utility to parse the DDOWiki to pull in information about quests and chains so I can more accurately link to it from the search results and item details page.

    This has the side effect of now requiring two different search options: The first lets you search by a "confirmed" quest or chain name and the other let's you pick all the non-confirmed sources that were entered in.

    This will make it easier for people adding / updating items as well, since now you are presented with dropdown lists containing all of the known quests / chains instead of having to manually type it in and making sure it matches casing and what-not.

  13. #13
    Founder & Hero jjflanigan's Avatar
    Join Date
    Feb 2006
    Posts
    5,000

    Default

    Did another parse from DDOWiki and flagged all but 3 of the quests based upon whether they are F2P or not.

    Added F2P filter to the search (please note that a LARGE portion of the items aren't linked to a specific quest yet, so they will not show up if you filter based upon F2P status)

    Added the ability to show / hide the search filters to make it more pleasant when browsing the items

  14. #14
    Founder & Hero jjflanigan's Avatar
    Join Date
    Feb 2006
    Posts
    5,000

    Default

    Per user request parsed the items and added armor sub types (light, medium, heavy) to the various items and added those filters to the bottom of the sub types drop down (right now weapon and armor subtypes are both on the same list because I don't want to wire up ajax yet to filter it based upon the other drop down).

  15. #15
    Founder & Hero jjflanigan's Avatar
    Join Date
    Feb 2006
    Posts
    5,000

    Default

    Added Augment Slot type as a searchable field (it's a "Special detail")
    Added Mabar Endless Night Festival as an item source

  16. #16
    Founder & Hero jjflanigan's Avatar
    Join Date
    Feb 2006
    Posts
    5,000

    Default

    Went through the Loot Thread and added the bulk of the items I found that were missing

  17. #17
    Founder & Hero jjflanigan's Avatar
    Join Date
    Feb 2006
    Posts
    5,000

    Default

    Began tagging items gained from collectibles -- The following are now available as a Source Filter

    • Adamantine Ore
    • Ancient Dragon Relic
    • Ancient Elven Relic
    • Ancient Giant Relic
    • Black Dragon Scale
    • Blue Dragon Scale
    • Dark Scarab Powder
    • Eerie Scarab Powder
    • Emerald Claw Nugget
    • Invasion Tokens
    • Scarlet Scarab Powder
    • Shield of Legend
    • Silver Flame Nugget
    • Tattered Tapestries
    • Tome of Untold Legends
    • White Dragon Scale

  18. #18
    Community Member Gnorbert's Avatar
    Join Date
    Apr 2009
    Posts
    1,241

    Default

    hitting the search button and nothing happens, no matter which options I select. Is it currently not working?
    "Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so."
    - Douglas Adams -

  19. #19
    Community Member stainer's Avatar
    Join Date
    Oct 2009
    Location
    sixty-sixth layer of the Abyss
    Posts
    4,666

    Default

    Quote Originally Posted by Gnorbert View Post
    hitting the search button and nothing happens, no matter which options I select. Is it currently not working?
    Working for me. I am using Firefox.

  20. #20
    Community Member kernal42's Avatar
    Join Date
    Oct 2009
    Posts
    1,870

    Default

    I like it!

Page 1 of 17 1234511 ... 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