ADV Database Changelog

Version 1.5.1 - 6/27/25

Made fix to Draft Stats for Pokemon that go undrafted in certain tournaments.

Version 1.5 - 6/25/25 - Current

Added Historical Pick Log v2, which allows filtering by tournament and more. This replaces the old Historical Pick Log and Historical Draft Log tools.
Added Pokemon Draft Stats v2, which allows filtering by tournament and more. This will eventually replace the Aggregate Pokemon Stats tool, which has been renamed to Pokemon Battle Stats.
Edited the Aggregate Pokemon Stats tool to only show battle stats -- this will soon be depreciated.
Fixed a bug where Ice Soup drafts would not generate using the Draft Generator, and tweaked the logic to enable more realistic Ice Soup drafts.
Fixed average costs across the site.
Added a summary for Arcanine.

Results from Emerald Open V are now in the database.
Added summaries for Breloom and Torkoal.
Tweaked the Random Draft Generator to give more realistic drafts on non-chaos mode settings.
Changed the "Flawless Ribbon" requirement to have a 5-0 or better team instead of a 3-0 or better team.
Added expert ribbons for Vaporeon, Regirock, Regice, Registeel, Gyarados, Flygon, Dugtrio, Blaziken, Alakazam, and Donphan.

Added summaries for Snorlax and Vaporeon.
Made the accolades page more visible and re-ordered items on the landing page to accomodate it.
Added a 'Minimum Total Drafts' filter on the Duo Analysis tool.
Cleaned up debug statements across database scripts.
Players' accolades are now linked images that lead to a ribbon's specific page, which shows all players with the ribbon.
Added the Random Draft Generator tool. This tool randomly generates drafts in one of four archetypes (the three normal team archetypes and a random 'Chaos' mode) for players to use.

Results from Apocalypse Draft League Season 7 are now in the database.
Results from Continental Draft League Association ADV Offseason are now in the database.
Added more granularity into indirect damage: hovering over the number now shows damage per game in the categories of Spikes, Weather, Leech Seed, Status, and Other.
Cleaned up the summary page for the case where a summary is not yet written for a Pokemon.

Fixed a bug where usage rate was calculated as battles over usage, instead of usage over battles.

Results from Zinc-Tratufo Draft League Season 2 are now in the database.
Added new ribbons for Zinc-Tratufo Draft League Season 2. The accolades page is now updated with this new information.
Added dynamic titles to pages.
Added dropdown options for some Pokemon who have been drafted for the first time between August 2024 and now.
Fixed a bug with extra accolades showing for certain players.
Changed tournament code for Zinc-Tratufo Draft League Season 1 from 'ZTDL1' to 'ZTL1'.
Corrected a few match results that had an incorrect winner assigned.

Fixed a bug where weather's indirect damage calculation counted damage dealt to allies. This mainly affected Tyranitar.
Added summaries for Celebi, Skarmory, Grumpig, and Sudowoodo. Summaries are ~10% complete.

Fixed a bug where certain users appeared in the database twice, or had teams attributed to them that weren't theirs.
Added change log.

The base release! I'll keep track of changes starting here.