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 ?
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.
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 ?
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/
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