sotagraphs.com - graphs for the API data

Discussion in 'Player Created Resources' started by that_shawn_guy, Jun 2, 2019.

Tags:
  1. Spungwa

    Spungwa Avatar

    Messages:
    609
    Likes Received:
    1,252
    Trophy Points:
    93
    Shaun
    (edit should of @that_shawn_guy )

    I was looking at a graph, very good by the way.

    I was looking specifically at
    https://sotagraphs.com/d/EgTXn0MWz/crafting?orgId=2

    Is this counting the amount of the item destroyed and created or is it the number of events.

    IE for the potion of restoration, imbued potions.
    The recipe makes 3 potions
    uses
    15 Garlic for example

    So if a single craft of this recipe would this add 1 to the crafted potions or 3
    and likewise
    would it add 1 to garlic or 15.

    It just the numbers seem low to me for the amount of some of these materials that i see being sold.


    Regards
    Spung
     
    Last edited: Jan 22, 2020
    Anpu likes this.
  2. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,119
    Likes Received:
    2,981
    Trophy Points:
    125
    Location:
    earth... mostly
    It's totaling up the quantity fields of the events.

    One thing to keep in mind, these events include character names. If someone is hiding their name from the API, those events will not show up here.
     
    Sean Silverfoot and Anpu like this.
  3. Spungwa

    Spungwa Avatar

    Messages:
    609
    Likes Received:
    1,252
    Trophy Points:
    93
    Oh right, it doesn't log all those characters it against anonymous character like some of the other stuff.

    That would do it then, so it a sample, useful for ratios, but not totals.
     
    that_shawn_guy and Anpu like this.
  4. Anpu

    Anpu Bug Hunter

    Messages:
    5,609
    Likes Received:
    6,252
    Trophy Points:
    153
    Location:
    Pacific Northwest
    When doing a search for Maple Wood, there is some very strange area showing up as "Novia_R1_Forest04_01" except, all forest scenes in the game only go from 1-3. Either this is a typo? Or is the API actually reporting that?

    Is that something you could check?

    I am almost positive it SHOULD be reporting area "HiddenVale_Forest01_Tier5" (Greymark Forest) which is strangely absent when searching for Maple Wood. And that has CRAPLOADS of Maple Wood.

    Thanks!
     
    Last edited: Jan 23, 2020
  5. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,119
    Likes Received:
    2,981
    Trophy Points:
    125
    Location:
    earth... mostly
    "Novia_R1_Forest04_01" is what's in the API.

    Code:
          {
            "_index": "logstash-2020.01.21",
            "_type": "doc",
            "_id": "D8tyxW8B9DlaFXTYXoKy",
            "_score": 1.0,
            "_source": {
              "EconomyGoldDelta": "3",
              "Archetype": "Ingredients/Materials_Raw/ItemRawMat_Wood_Maple",
              "SceneName": "Novia_R1_Forest04_01",
              "zpos": "-312.962",
              "LocationEvent": "ItemGained_Loot",
              "xpos": "345.619",
              "ypos": "-0.305",
              "ItemId": "5e2642224d97ac1570341281",
              "@timestamp": "2020-01-21T00:00:00.000Z",
              "Quantity": "1",
              "GoldValue": "3",
              "timestamp": "Jan 20 18:00:00"
            }
     
    StarLord, Anpu and Elgarion like this.
  6. Anpu

    Anpu Bug Hunter

    Messages:
    5,609
    Likes Received:
    6,252
    Trophy Points:
    153
    Location:
    Pacific Northwest
    Thanks for checking that. I completely forgot to just check one area *facepalm*.
     
  7. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,119
    Likes Received:
    2,981
    Trophy Points:
    125
    Location:
    earth... mostly
    It would be very nice to have a conversion table for this kind of data in the api.
     
    Aeryk and Anpu like this.
  8. Anpu

    Anpu Bug Hunter

    Messages:
    5,609
    Likes Received:
    6,252
    Trophy Points:
    153
    Location:
    Pacific Northwest
    Completely agree. I now plan on posting a monthly resource report. Hopefully this will get some attention from the team, as well as provide us discussion on these.
     
    that_shawn_guy likes this.
  9. Anpu

    Anpu Bug Hunter

    Messages:
    5,609
    Likes Received:
    6,252
    Trophy Points:
    153
    Location:
    Pacific Northwest
    Can you possibly add an option where the actual exact number are shown, with NO abbreviation?

    Currently items are displayed like this:

    [​IMG]

    I need that K removed, and instead an actual total number, with no K abbreviation.

    Could you possibly add such a selectable display option? I don't wan't to mess with the default display, which is fine for most people, but add an option we could select that only shows exact total numbers with no abbreviations (some cookie or session selectable option)?

    If that's WAY too much work for you to do, no worries. Never mind. Just wanted to ask first. :)
     
  10. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,119
    Likes Received:
    2,981
    Trophy Points:
    125
    Location:
    earth... mostly
    Sure. It's a per-graph setting though. If you click on the title of the graph, you can share a link to it and I can update the settings for it. Through the same dropdown, you can also go the inspect area and see the data for the backend of the graph. IIRC, you can also download it in CSV or maybe other formats.
     
    Anpu likes this.
  11. Anpu

    Anpu Bug Hunter

    Messages:
    5,609
    Likes Received:
    6,252
    Trophy Points:
    153
    Location:
    Pacific Northwest
    [​IMG]

    Lich Essence dropping in last 30 days

    @that_shawn_guy this *seems* abnormally low, but actually could be what is currently dropping. I was just wondering first that you do have the lich essence set up on the site correctly? It's possible the API is reporting this incorrectly...
     
    shawnbutts likes this.
  12. shawnbutts

    shawnbutts Avatar

    Messages:
    1
    Likes Received:
    1
    Trophy Points:
    3
    Anpu likes this.
  13. Anpu

    Anpu Bug Hunter

    Messages:
    5,609
    Likes Received:
    6,252
    Trophy Points:
    153
    Location:
    Pacific Northwest
    Ok thanks for checking. This is probably correct since troll essence is now all the rage.....
     
  14. Anpu

    Anpu Bug Hunter

    Messages:
    5,609
    Likes Received:
    6,252
    Trophy Points:
    153
    Location:
    Pacific Northwest
    The Economy page data seems a bit wacky. In the last 30 days it shows 1.94K coal has been purchased by NPC's. But the crafting page Crafted Items Destroyed shows 167K Coal destroyed?
     
    that_shawn_guy likes this.
  15. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,119
    Likes Received:
    2,981
    Trophy Points:
    125
    Location:
    earth... mostly
    Good find. I had them set to using different aggravation functions. Should be fixed now,
     
    Sean Silverfoot and Anpu like this.
  16. Anpu

    Anpu Bug Hunter

    Messages:
    5,609
    Likes Received:
    6,252
    Trophy Points:
    153
    Location:
    Pacific Northwest
    When clicking on the PvE page it is taking an astronomically long time to load (in fact I can't even get the page to load at all). Is there possibly something wrong with that page?

    I get a InfluxDB Error: query-timeout limit exceeded
     
  17. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,119
    Likes Received:
    2,981
    Trophy Points:
    125
    Location:
    earth... mostly
    Usually, when you see that error the DB crashed because it ran out of memory. When that happens, there are a few options you can try.
    1) Use a shorter time frame. Fewer data-points easier to deal with.
    2) Click on the title of the graph you are interested in select "View". This way, the DB doesn't have to pull the data-points for other graphs at the same time.
     
  18. Anpu

    Anpu Bug Hunter

    Messages:
    5,609
    Likes Received:
    6,252
    Trophy Points:
    153
    Location:
    Pacific Northwest
    @that_shawn_guy a few things seem to be a bit wacky on the Crafting page, Crafting Items Destroyed, for a 30 day period.

    The in game leaderboard says 85,561 garlic consumed, sotagraphs shows 86.6K that one looks fine.
    Leaderboard Nightshade shows 84,509, sotagraphs shows 13.6K - Something seems off there?
    Also teleport to zone scrolls seem to be completely missing in the Crafting Items Destroyed?

    Could you take a look at those, and a few other?

    Thank you!
     
  19. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,119
    Likes Received:
    2,981
    Trophy Points:
    125
    Location:
    earth... mostly
    I can't be sure. But, I think the "ItemDestroyed_Crafting" is just items consumed at a crafting table. I assume the leader boards include reagents used while casting as well.
     
    Anpu and Alley Oop like this.
  20. Anpu

    Anpu Bug Hunter

    Messages:
    5,609
    Likes Received:
    6,252
    Trophy Points:
    153
    Location:
    Pacific Northwest
    Thank you Shawn. That would make sense then.