Shroud of the Avatar - Elastic search queries made easy!
Here is a list of pre-made functions you can use. It will also give you an idea on how to use queries manually if you ever want to have a more specific research.
Since an hour
Last 24 hours
Use headers on each rows
(Unchecking this could be confusing if changes are done in the databases)
Note that for now, a maximum of 100 results will be displayed. There is also a delay of 5 seconds between queries.
What is this site?
This website is a client application accessible by all for the elastic search database of Shroud of the Avatar.
With this, you can find statistic about maps, players, items and maybe more at a later time.
Shroud of the Avatar made this available to all and they are in control of the data flow.
That mean things could appear or disapear from the db as they are still working on the ideas of making datas public.
You can profit while you are here and check out how many monsters you have killed and compare your stats with your friend!
Welcome to the Shroud of the Avatar queries made easy!
Changed buttons and mouse pointer so they look more like buttons.
Updated and corrected some texts.
Filled archetypes dropdown list with tons of items (might not be all there yet!).
Filled maps dropdown list with most of the maps (Probably some are missing!).
Players are now added automatically to the dropdown list when found in the database.
If you want to add your name in the database, make sure show public stats is enabled in the game. It start recording when you enabled that button, after a while come back in manual queries and write PlayerName: 'yourname'
If your name is found, or any other name in the PlayerName field, it will be added.
Then refresh the page to see the change.
Added Map Activities to see what is happening in a map in "almost" real time.
Not all the maps images and correct position are available yet. It will be with time. For now, only the grunvald region and deep ravenswood maps is shown correctly. Others maps images aren't set but are kinda viewable.
Added mention for www.sotamap.com top of maps... Tryed to contact the administrator Jakub but seem unreachable for now. Took screen shot of in game map to show the dots in Map Activities. If anyone have all the maps in a zip id GLADLY take them. ;)
In manual queries, when you click on a dropdown box, stuff will be automatically added to the query box. You can now selection multiple item in each box and it will format itself properly in the box. I didnt add OR and NOT yet, but still a great improvement i think.
Added stuck and position + suicides in the Players Stats
Added new function Player Information. It give you details on kills and death PvE & PvP with a number for each creatures/players killed.
Removed the automated system to add names in the dropdown list. It went weird because of bad requests. Instead, i will add all the archetype and scenename found so far (which is pretty huge so far). Still have to figure out what to do with the player list. (The list is not yet in, it will be soon!)
Fixed something that interacted between users on my app server.
Added a prompt on droplist in client side so they can copy the text more easy.
Added a new features to my app server that will automatically add positive research from the user to the dropdown lists on the UI.
This is the type recorded for now: Archetype, LocationEvent, PlayerName, SceneName
For example if you search SceneName: 'Novia' and novia isnt already in the dropdown list AND the research is succesful. Then it will automatically add it to the right db then show it in the dropdown lists next time you refresh the page.
This is some examples of queries that can be sent to the server.
There is many data that has been disabled by SOTA server to protect the privacy of the players. Artifacts for examples cannot be searched for.
This show every records available from that player. PlayerName: 'player name here'
This show world item gained in a specific scene. LocationEvent: 'ItemGained_World' AND SceneName: 'The Rise'
This show all player that died from another player or by suicide. PlayerKilledByPlayer OR PlayerKilledBySelf
This show all loot generated in The Rise dungeon. (Can't see items) SceneName: 'The Rise' AND LocationEvent: 'LootGenerated'
Thanks to Jaanelle DeJure from SOTA community for this examples of more complexes queries.
LocationEvent: *LootGold* NOT (SceneName: *mine* OR SceneName: *city*) AND GoldValue: 25
Archetype: *HemlockBorer* AND LocationEvent: ItemGained_Loot* AND (SceneName: *R6* OR SceneName: *blackblade*)
Archetype: *silver* NOT (LocationEvent: *destroy* OR LocationEvent: *craft*) NOT SceneName: *mines*
LocationEvent: *Gained_World* AND Archetype: *port* NOT Archetype: *book*
If you came here by error and looking for the game, here it is! ;)
Frequently asked questions
People ask me frequently those questions so i decided to make an overview of what you can and cannot do.
Q: How do i add my name in the list?
A: Do a manual query and enter PlayerName: 'yourname' in the query box. Make sure your public stats are enabled in game and some events had time to be recorded.
Q: Can i search for artifacts?
A: No. Artifact cannot be searched for. But you can see some events that have artifact like when people are crafting the warlock chain and using attunement rings for example.
Q: Is this in real time?
Here you can see how many monsters or players you have killed in the selected time. Select a name from the list or search it manually! If a name doesn't appear in the list, search it manually and it will be automatically added if the search was successful.
Since an hour
Last 24 hours
Search monster name (test)
About this website
This website was made with the idea to help players to get access easily to the public data from SOTA.
This SOTA Elastic search web client application has been developed by DevilCult.
If you have any question related to this site you can post on this thread or contact me via SoTA Forum.
I am not affiliated with Portalarium, Inc.
Shroud of the Avatar, the SotA logos and images are trademarks of Portalarium, Inc.