1. Before posting any MODs, please contact us at support@portalarium.com to ensure your MOD is acceptable to the Terms of Service and EULA of the game. Portalarium is not responsible for use of MODs and possible adverse effects on your client or computer, and we may take action on accounts using MODs that are deemed illegal. Whether submitted here or elsewhere in the community, use MODs at your own risk!
    Dismiss Notice

Item recipes, stats, and other info

Discussion in 'Player Created Resources' started by Tiina Onir, Apr 24, 2017.

  1. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    I still have a lot of work to do on this, but I wanted to get it out there. I've been working on a website for keeping all the recipes for all the items, as well as all the stats on those items. I've been concentrating on the foods, and that list is just short of complete but, as they say, "the perfect is the enemy of the good," so without further adieu,


    Sections which are believed complete (please report any mistakes or omissions):
    Smelting: Everything from my book.
    Alchemy: missing "Poison, Chaos"
    Milling: Everything from my book (looks incomplete).
    Tanning: Everything from my book.
    Butchery: Believed complete.
    Blacksmithing: Everything from my book (incomplete).
    Tailoring: Everything from my book.
    Carpentry: Everything from my book.
    Cooking: Believed complete.
    Textiles: Everything from my book.
    Obsidian Forge: Everything from my book.

    Here's a listing of all the items with re-teachable/discoverable recipes. It's not linked to the rest of the site yet, it's probably going to move, and it needs work but hopefully it's useful.

    There are a number of things I still need to do:
    • I'm missing 6 food recipes. (Should be added this week) (DONE!)
    • I need to get the list sorted consistently. (DONE!).
    • I need to fill in the other recipies.
    • Fix bugs, including any errors I may have made in entering data (please report them here if you spot any!)
    • Allow for news updates on the front page.
    • Allow for feedback on the site itself.
    • Add any information I can pull from the Public API
    • Improve "Items" section of browse pages
    • Add advanced searching (including by Stat Duration and Stat affected)
    • Add support for ingredients that can resolve to multiple items (ie "metal binding").
    While this may look to many like "Yet another SotA recipe site," I have started it to address some pet-peeves with the other sites I've found: Not listing the number prepared and not listing both the stats and the recipe. I have a few other ideas for features, but they will be added after I get enough of the items in to make them useful. This site is purely interested in the mechanics: stats, recipes, where to find hard to find things. It's not going to be getting into lore.

    If I've made any mistakes, or you see anything I could do to make it more useful, please post it here, PM me here, or feel free to contact me in game (Tiina Onir).
     
    Last edited: Jul 23, 2018
    Vaiden Luro, Lesni, Ataniiq and 12 others like this.
  2. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    Updates for the week of 4/29

    Lists are now sorted consistently (alphabetically, to be precise).
    I'm considering moving the equipped tool to the top of the recipe.
    I've added all of the Gems now. They include the recipes, and the stats applied. A few include what enchantments they allow (this will take a while to get complete experimentally).
    I've added all of the Jewels now. They only include the recipes. I'll get the stats next week.

    Known Issues:
    Dragon Stew incorrectly lists the the -50 focus for the full 8hrs. The DB cannot handle differing stat durations at the moment, I will get this fixed next week. (FIXED!)
     
    Last edited: Apr 30, 2017
    Fionwyn Wyldemane likes this.
  3. Stundorn

    Stundorn Avatar

    Messages:
    3,798
    Likes Received:
    5,679
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Estgard/ Cologne
    Good Work!
    Maybe Add duration of the food.
     
  4. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    It already has the duration on the foods, it's right by each stat. (that's actually what's wrong with Dragon Stew, one stat has a DIFFERENT duration and I can't store that yet). I'll try to get the layout to match the in-game layout next week.

    EDIT: Just realized you meant duration on the page I linked. If you click the actual recipe, it has it. I think the answer there is to make a more advanced search function. That's a pretty in-depth project though. I think it will happen once I get a more complete recipe list.
     
    Last edited: Apr 29, 2017
    Stundorn likes this.
  5. Stundorn

    Stundorn Avatar

    Messages:
    3,798
    Likes Received:
    5,679
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Estgard/ Cologne
    Ups, overseen it.
     
  6. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    Sorry for the downtime today. I was reconfigureing the DB to fix the duration problem with "Dragon Stew". It gave me all kinds of fits. It's fixed now! (hopefully I'll not have to touch that query again)
     
  7. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    When I fixed the "Dragon Stew" recipe, I broke the interface for modifying recipes. It's taken longer then expected to resolve. I have the changes to the UI done, I just need to get it tied to the back-end. (hopefully this coming week I can get it done).

    I did update the user UI slightly. Now the stats show green if they are positive and red of they are negative (like the in-game UI)
     
    Last edited: May 7, 2017
  8. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    A week past my worst estimate :eek:, I finally have the item-add functionality working again.
    That said, it's now much better:
    • first, it works again (which it hasn't since the "dragon stew" fix)
    • all of the changes are done using single pl/pgsql function now. This means
    • it's atomic (it either fully does the update, or does none of it)
    • It doesn't waste sequence numbers as badly. (there is still an improvement that could be made here, but I don't think it's worth the effort at this time)
    • I can make as many changes as I want before committing the update to the DB. (this should mean I can work much faster)
    • The python/flask code is much cleaner
    There are still a couple things I'd like to improve with it, namely error reporting. I mean, there shouldn't be any errors, but as they say "A good programmer is someone who looks both ways before crossing a one-way street", but I'm a little burned out on back-end stuff no one but me will ever see. In the next week I plan on getting some more Alchemy items in. I have some ideas about pulling data from the public API I'd like to start looking into. I also had some ideas about how I can restructure the browse pages to make them a bit better (and will also facilitate even more functionality in the future).
     
  9. Elgarion

    Elgarion Avatar

    Messages:
    871
    Likes Received:
    2,515
    Trophy Points:
    93
    Gender:
    Male
    Looking great so far, and I love how fast it loads, like greased lightning! :) I featured this as a link at SotAHelp.org -- hope you get the time to finish this massive undertaking, so far its fabulous!
     
    Tiina Onir likes this.
  10. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    Thanks for the kind word and the link! I think it's more a marathon then a sprint...

    hrm... I'll need to make a "Friends" page to link back.
     
    Elgarion likes this.
  11. Elgarion

    Elgarion Avatar

    Messages:
    871
    Likes Received:
    2,515
    Trophy Points:
    93
    Gender:
    Male
    Thank you as well!
     
  12. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    Ok, I did some refactoring on the code for the browse pages in preparation for some layout improvements I have in mind. Unfortunately it caused some problems, everything should be good now.

    Over the week I managed to add:
    • Support for stats with ranges
    • Support for stats with no point value (namely Duration when on Poisons)
    • Support for periodic stats (again, mostly used for Poisons)
    • Added all potions except for "Poison, Festering Death" and "Poison, Chaos"
    All the things I added support for, I don't think would have been possible (at least not so quickly) without the modifications that took so long. Suffice it to say, they are working far better then I even hoped. There is a known bug with some poisons where they will show a stat as red (because it's a negative) even though it applies to your target, not you (and is green in-game). I should have a fix for that next week.
     
  13. Alley Oop

    Alley Oop Bug Brigade – Bug Hunter

    Messages:
    6,817
    Likes Received:
    11,338
    Trophy Points:
    153
    not sure whether chaos poison isn't in because the info is weird and hard to add or because you don't HAVE the info, but i got one in loot in case it's the latter.

    [​IMG]
     
    Tiina Onir likes this.
  14. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    I'm just looking for a copy of the recipe for those two. I'll get the stats added, anyway.
     
  15. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    Ok, (except for the two missing poison recipes) as far as I'm aware Alchemy is done. I do need to go ahead and finish support for ingredients that can be fulfilled by different items. That should happen today or tomorrow.

    Also, I'm going to have to take the site down for a bit soon. This will happen during the day on a weekday (CDT/NBT), so I doubt many will be affected. The setup it's running on is really designed to be a cluster, but I haven't had the hardware for it to operate that way. It's going to be getting that hardware now, including 10GigE for intra-cluster traffic. It's also going to be doubling the processing and memory resources, and greatly increasing disk-space. To better utilize these resources, I'm strongly considering separating the nginx front-end from the container running the python/flask code. In order to better keep a handle on the site, I'm also considering adding a container running splunk for log analysis.

    I'm not sure when this will happen yet as, while I got my shiny 10G switch, they forgot mounting hardware, so I'm waiting on that still.
     
  16. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    Okay, I've finally managed to get everything working for doing green/blue deployment. This should help me prevent downtime when working on the code. In the process I've had to change the address from https://sotadb.info/ to https://www.sotadb.info. Going to the "apex domain" will forward you to the "www" domain, but going to the "www" domain directly will come up a little faster, so I recommend if anyone has bookmarks, they update them. I have no intention of ever changing this again.

    Ugh... this took more time then it should have due to some DNS issues. Hopefully we're all good now and I can get moving on some real updates.
     
  17. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    Ok, I found a list of 32 pages which where broken. Basicly it was anything with a dash in the name; they have now all been fixed. In doing this I have done the following:

    1. I now have a crawler which crawls the site looking for problems like these. It's not perfect, but it's a start. I should be able to improve it in the future. Even as incomplete as this site is right now, it's STILL over 300 pages. A script is the only way I could realsticly check the whole thing.
    2. The crawler can be manually run against the development site, to make sure code-changes haven't broken anything.
    3. I have now tested changing between the production and development site. It works flawlessly, and is totally awesome.
     
  18. Tiina Onir

    Tiina Onir Avatar

    Messages:
    926
    Likes Received:
    1,554
    Trophy Points:
    105
    Location:
    Bramble, South Paladis
    Okay, FEATURE UPDATE!

    We now have "reverse recipe lookup," so if you go to a page for an item, there is now a tab that shares the space for "notes" titled "Used In." if you click this tab, you'll see the list of items you can make with this item. This is a feature I've been wanting to put in for a while, because sometimes I really want to know what I can do with something (particularly those cooking recipes).

    The layout for it needs a little work, but overall I'm just thrilled to get it in.

    This did introduce some bugs in the code that updates the items, so fixing that is the next item to work on, so I can get back to adding items.
     
    Diminio and Spoon like this.
  19. Spoon

    Spoon Bug Brigade - Bug Hunter

    Messages:
    8,128
    Likes Received:
    22,786
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Sweden
    Sweet.

    [​IMG]
     
  20. Solazur

    Solazur Avatar

    Messages:
    1,433
    Likes Received:
    3,523
    Trophy Points:
    113
    Gender:
    Male
    Location:
    Pacific NW
    Awesome 2 thumbs up