SOTA Elasticsearch Web app (closed)

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

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

    Scoffer Avatar

    Messages:
    905
    Likes Received:
    2,651
    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. DavidDC

    DavidDC Programmer Moderator SOTA Developer

    Messages:
    1,532
    Likes Received:
    3,236
    Trophy Points:
    113
    Gender:
    Male
    Yeah ill get that sorted soon
     
    Time Lord likes this.
  3. DavidDC

    DavidDC Programmer Moderator SOTA Developer

    Messages:
    1,532
    Likes Received:
    3,236
    Trophy Points:
    113
    Gender:
    Male
    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:
    595
    Likes Received:
    1,644
    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,845
    Likes Received:
    4,276
    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. DavidDC

    DavidDC Programmer Moderator SOTA Developer

    Messages:
    1,532
    Likes Received:
    3,236
    Trophy Points:
    113
    Gender:
    Male
    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:
    214
    Likes Received:
    379
    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 Bug Hunter

    Messages:
    5,884
    Likes Received:
    11,033
    Trophy Points:
    153
    Gender:
    Male
    Location:
    Pacific Northwest
    Is the search you have for Player Stats supposed to be working currently ?
     
  9. null2

    null2 Avatar

    Messages:
    373
    Likes Received:
    1,152
    Trophy Points:
    55
    Jaanelle DeJure likes this.
  10. DavidDC

    DavidDC Programmer Moderator SOTA Developer

    Messages:
    1,532
    Likes Received:
    3,236
    Trophy Points:
    113
    Gender:
    Male
    its working @FrostII
    Do you have problem with it?
     
  11. Jaanelle DeJure

    Jaanelle DeJure Avatar

    Messages:
    1,845
    Likes Received:
    4,276
    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,845
    Likes Received:
    4,276
    Trophy Points:
    113
  13. Rok Yrikk

    Rok Yrikk Developer Emeritus

    Messages:
    105
    Likes Received:
    680
    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:
    734
    Likes Received:
    1,524
    Trophy Points:
    93
  15. DavidDC

    DavidDC Programmer Moderator SOTA Developer

    Messages:
    1,532
    Likes Received:
    3,236
    Trophy Points:
    113
    Gender:
    Male
    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 Hunter Bug Moderator

    Messages:
    15,679
    Likes Received:
    19,463
    Trophy Points:
    153
     
    Some Dude and devilcult like this.
  18. DavidDC

    DavidDC Programmer Moderator SOTA Developer

    Messages:
    1,532
    Likes Received:
    3,236
    Trophy Points:
    113
    Gender:
    Male
    manual queries should now show Service Unavailable after a connection timed out!
     
  19. Rowell

    Rowell Avatar

    Messages:
    612
    Likes Received:
    1,281
    Trophy Points:
    105
    Gender:
    Female
    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 Moderator SOTA Developer

    Messages:
    346
    Likes Received:
    848
    Trophy Points:
    43
    Public API should be back up!
     
Thread Status:
Not open for further replies.