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

SOTA Elasticsearch Web app (closed)

Discussion in 'Player Created Resources' started by devilcult, May 20, 2017.

  1. Scoffer

    Scoffer Avatar

    Messages:
    634
    Likes Received:
    1,910
    Trophy Points:
    93
    It needs something that allows you to group results if possible.

    For example, checking how much iron ore was mined in the last 24 hours shows 100 lines of 1,2,1,1,1,1 etc rather than just a total (ideally grouped by scene name).
     
    Time Lord likes this.
  2. devilcult

    devilcult Avatar

    Messages:
    580
    Likes Received:
    1,250
    Trophy Points:
    63
    Yeah ill get that sorted soon
     
    Time Lord likes this.
  3. devilcult

    devilcult Avatar

    Messages:
    580
    Likes Received:
    1,250
    Trophy Points:
    63
    Did a good update today, still some stuff to fix but check it out! :)
     
    Jaanelle DeJure and Time Lord like this.
  4. Sheamus McGuinness

    Sheamus McGuinness Avatar

    Messages:
    603
    Likes Received:
    1,675
    Trophy Points:
    93
    Love this tool! I couldn't remember who made it and I forgot to bookmark the link, was asking in Discord and no one remembered. Great work man!
     
    Time Lord likes this.
  5. Jaanelle DeJure

    Jaanelle DeJure Avatar

    Messages:
    1,835
    Likes Received:
    4,251
    Trophy Points:
    113
    How about... "search since last Release" option?

    Also wondering if there is any way to use operators like < > = for example

    LocationEvent: *gain* AND GoldValue: > 50
     
    Time Lord likes this.
  6. devilcult

    devilcult Avatar

    Messages:
    580
    Likes Received:
    1,250
    Trophy Points:
    63
    Sorry for late anwser, i tought id get alert when someone post here :\

    For the formatting with special operation its a bit hard to setup and i dont think i will do that. But there something i forgot to do is make the table sortable by title. So if you wanted gold to show ascendant you would just click the GoldValue on top make it go that way, anyway that is something i will add in the near futur.

    I can add the since last release option but that would require me to go there every month and add the new dates of release. I try to make it automatic as most possible so i dont have to come back and touch the code again :p

    I also need to add the aggregates number top of the list which should also be there soon.

    The main reason i'm not updating much is right now is my head is on another projet for sota that should come in soon :p

    But yeah i got some works there o_O
     
    Jaanelle DeJure likes this.
  7. Armeleon Vesaz

    Armeleon Vesaz Avatar

    Messages:
    165
    Likes Received:
    274
    Trophy Points:
    18
    Gender:
    Male
    Location:
    Finland
    Great tool, thank you!

    One feature I would love to see is the ability download the search results in csv.
     
  8. FrostII

    FrostII Avatar

    Messages:
    3,994
    Likes Received:
    8,402
    Trophy Points:
    153
    Gender:
    Male
    Location:
    Pacific Northwest
    Is the search you have for Player Stats supposed to be working currently ?
     
  9. Kigu Starfish (Kor)

    Kigu Starfish (Kor) Avatar

    Messages:
    379
    Likes Received:
    1,209
    Trophy Points:
    55
    Gender:
    Male
    Location:
    Rift's End, Owl Sky City
    Jaanelle DeJure likes this.
  10. devilcult

    devilcult Avatar

    Messages:
    580
    Likes Received:
    1,250
    Trophy Points:
    63
    its working @FrostII
    Do you have problem with it?
     
  11. Jaanelle DeJure

    Jaanelle DeJure Avatar

    Messages:
    1,835
    Likes Received:
    4,251
    Trophy Points:
    113
    @devilcult Is this down? It is not giving me any results.
     
    Last edited: Dec 19, 2017
  12. Jaanelle DeJure

    Jaanelle DeJure Avatar

    Messages:
    1,835
    Likes Received:
    4,251
    Trophy Points:
    113
  13. Rok Yrikk

    Rok Yrikk Web Developer

    Messages:
    105
    Likes Received:
    679
    Trophy Points:
    18
    @Jaanelle DeJure
    You might be temporarily blocked. We typically do not add people to the black list unless they are doing something actively nefarious.

    To clarify when you might get throttled or temporarily denied, our API constraints are as follows:
    * Maximum of 10 requests within a minute
    * Maximum of 15mb reply from our server within 15 minutes
    * Counters expire after 25 minutes, so if you put in 100 requests within a minute, then nothing, after 26 minutes it's all starting over
     
  14. Hemswal The Descended

    Hemswal The Descended Avatar

    Messages:
    475
    Likes Received:
    968
    Trophy Points:
    43
  15. devilcult

    devilcult Avatar

    Messages:
    580
    Likes Received:
    1,250
    Trophy Points:
    63
    Applerust and Antrax Artek like this.
  16. Some Dude

    Some Dude Avatar

    Messages:
    10
    Likes Received:
    7
    Trophy Points:
    3
    Location:
    Brittany Wharfs
    So I've tried to use the database to do some manual queries over the last couple of weeks, and every time I put in a manual query it gets stuck on "Retrieving data...". Just figured I'd leave a heads up.
     
  17. Alley Oop

    Alley Oop Bug Brigade – Bug Hunter

    Messages:
    6,682
    Likes Received:
    11,177
    Trophy Points:
    153
     
    Some Dude and devilcult like this.
  18. devilcult

    devilcult Avatar

    Messages:
    580
    Likes Received:
    1,250
    Trophy Points:
    63
    manual queries should now show Service Unavailable after a connection timed out!
     
  19. Rowell

    Rowell Avatar

    Messages:
    418
    Likes Received:
    809
    Trophy Points:
    43
    Location:
    Brittany Fields
    Yea, the SOTA API Server is currently experiencing some problems. So sites that pull data from there aren't working. Portalarium is aware of the issue and will be working on it shortly.
     
  20. Undone

    Undone Trap Master SOTA Developer

    Messages:
    250
    Likes Received:
    652
    Trophy Points:
    28
    Public API should be back up!