Questions for those who parse the API we have access to.

Discussion in 'Lua Discussions' started by FrostII, Feb 22, 2020.

Thread Status:
Not open for further replies.
  1. FrostII

    FrostII Bug Hunter

    Messages:
    5,884
    Likes Received:
    11,033
    Trophy Points:
    153
    Gender:
    Male
    Location:
    Pacific Northwest
    1: Does the API show when players log in/out of game (with names) ?
    2: Does it show every loot drop for every mob looted by anyone ?
     
  2. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,409
    Likes Received:
    3,738
    Trophy Points:
    125
    Location:
    earth... mostly
    Nope.

    Some events do have player names. But, players can choose to hide their names and they just show up as "Anonymous".

    Nope.

    Artifacts drops are a good example. Most quests items are excluded as well.

    If you have you are interested, have a look at my archive of the raw data at archive.sotagraphs.com for yourself.
     
  3. FrostII

    FrostII Bug Hunter

    Messages:
    5,884
    Likes Received:
    11,033
    Trophy Points:
    153
    Gender:
    Male
    Location:
    Pacific Northwest
    Thanks shawn...
    Has Chris stated a reason for NOT including artifacts ?
    I assume it is intentional on his part.
    What might be the reason he doesn't want us to see how many arties drop per day ?
    Might it be the time/location that he doesn't want known ?
     
  4. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,409
    Likes Received:
    3,738
    Trophy Points:
    125
    Location:
    earth... mostly
    Locations data has already been removed from many events and the time stamps are rounded.

    The original thread where the lack of information was discussed can be found at https://www.shroudoftheavatar.com/forum/index.php?threads/public-stats-api.89186/
     
    FrostII, Rentier and Anpu like this.
  5. FrostII

    FrostII Bug Hunter

    Messages:
    5,884
    Likes Received:
    11,033
    Trophy Points:
    153
    Gender:
    Male
    Location:
    Pacific Northwest
    Thanks for the info and reference, shawn .
     
  6. Kardall

    Kardall Avatar

    Messages:
    22
    Likes Received:
    54
    Trophy Points:
    3
    Our SotAssist database collects Item Looted, Item Sales to NPC, Monster Kills, Player Kills and such for two months of stored data. So we can get some pretty neat graphs going.

    The timestamps are rounded to 15 minute intervals, so when you pull data, you have to be careful of what time stamps you pull. The other funny thing is, since it's rounded it does make it kind of difficult to get 100% accurate loot information.

    For example:

    Player kills a Dragon at 3:14pm, but has to tend to other mobs around the dragon. By the time everything is dead it is now 3:15pm. That means that anything looted is at the 3:15pm timestamp, but the dragon kill is in the 3:00pm timestamp. So you will miss a 'loot' event for that specific dragon.

    But other than that, the kill of the Dragon by the Player or Anonymous is actually logged at 3:00pm, so you can "kind of" fiddle with things to make it as accurate as possible.

    Just if you pick a Date Time range, and miss the cutoff, your evaluations of say, Dragon Head drop % won't be accurate because that one dragon is not in the kill window with loot window alignment ;s
     
    that_shawn_guy likes this.
Thread Status:
Not open for further replies.