versx / rdmopole2 Goto Github PK

Egg start/end time is timestamp but raid end time is in minutes.

As a title :-)

Not sure if this is still maintained tbh but just noticed stats pages not working though this could have been busted for months.

when folks try to login, I see this in the logs

(node:409561) UnhandledPromiseRejectionWarning: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual
 that corresponds to your MySQL server version for the right syntax to use near '() AS total
        FROM pokemon_iv_stats iv
          LEFT JOIN pokemon_shiny_s' at line 2

Hi all, missing option "hasMultipleInvasions": "true/false" in config(.example).json

In Pokemon stat page, when you scroll down the Historical Lookup or the Community Day pages until you're "in their graph", sometimes the title bar from the Shiny Rates appears on top (with ID-Pokemon-Shiny Rate-Shiny/Total).

To reproduce: from main page, go to Pokemon Tab, go to Shiny Rates, sort by Shiny Rate, scroll down until the floating title bar appears, then back up, go to historical lookup, scroll down and the same title bar appears.

Also for invasions.

First of all an option to make a heatmap for hundows would be enough but if it's possible why not make IV selector also? Obviously that heatmap could work for selected or all mons

The color chart shows in blue the scanned value and in green the seen value. Thus an ideal setup would show a half blue half green chart, which isn't really the best style tmo.
It would make more sense to show in green the scanned value, and like in orange or red the (seen-scanned) value -> giving a full green chart when all seens are scanned

Also, side note, it would be nice to also have on this panel the Shiny rate of this Cday Pokémon for the period.

Currently sorting by shiny rate is heavily biased by rare pokemon, e.g. estimating the shiny rate to be 1/50 for something having 1 shiny in 50 encounters is heavily biased, especially when there are a lot of Pokemon spawn in the spawn table, which overall makes the sorting meaningless. To remedy this, I propose that we could add two columns (might need a better name):

• Shiny rate (pessimist's tail): 2.5% lower tail
• Shiny rate (optimist's tail): 2.5% upper tail

The algorithm for estimating confidence interval for binomial distributions can be found here: https://statpages.info/confint.html

Should be updated when start/end date changes as well.

Add community day Pokemon shiny rate to the community day page.

Limit queries for provided bbox

Add a support to GeoJSON.

Migration 81 for RDM

ALTER TABLE pokestop
DROP COLUMN pokestop_display,
DROP COLUMN incident_expire_timestamp,
DROP COLUMN grunt_type;

sqlMessage: "Unknown column 'grunt_type' in 'field list'",
sqlState: '42S22',
index: 0,
sql: '\n' +
' SELECT \n' +
' lat, \n' +
' lon,\n' +
' name,\n' +
' grunt_type,\n' +
' incident_expire_timestamp,\n' +
' updated\n' +
' FROM\n' +
' pokestop\n' +
' WHERE\n' +
' incident_expire_timestamp > UNIX_TIMESTAMP()\n' +
' AND enabled = 1;\n' +