ADV Database Changelog

Version 1.10 - ?

Results from Zinc-Tratufo League Season 3 are now in the database.
Removed all tournaments with less than 32 players from the database.
Changed the name of the Emerald Open tournaments to have a roman numeral.
Added custom avatars for players that have won major tournaments or qualified for the Hoenn Draft Invitational.
Added links to the Battle Log from the Team Log.
Changed handling for players who forfeit mid-tournament on the Team Log.
Changed threshold for "Common Pokemon" player insight from 2.66 picks earlier than average to 4 picks earlier than average.
Changed the tournament code for Revival Draft from "RevD" to "REV".
Changed the Battle IDs of most battles. Some previously active battle links are broken as a result.
Changed the numbering of most accolades.
Changed the Flawless Ribbon to require winning the tournament with the undefeated team.
Removed the following accolades: Finalist Ribbon, Best Friend Ribbon
Awarded ribbons for those that placed between 48th or higher in circuit points for the 2025 Hoenn Draft invitational.

Updated the rest of the database to interface with cloud database instead of text files.
Added the Draft Board Viewer, which can be used to look at draft boards for previous tournaments.
Added a Player Leaderboard that uses the ADV Draft Circuit's points system for all tournaments with 48 or more players, and an associated accolade.
Tweaked the play-in matches for Smogon ADV Cup to be in the 'Preliminary' stage instead of the 'Bracket' stage.
Made player insights within Player Profiles sorted by type.
Replaced "Value Metrics" with "Common Partners" on Pokemon Profiles.
Temporarily removed the Random Draft Generator and Direct Pokemon Comparison.
Removed the ADV Draft Compendium, with the New Player Guide having its own separate page.
Removed "v2" from tool names as all tools are updated to interface with cloud database.

Added Battle Log v2, which improves the results table from the battle log. This replaces the old Battle Log tool.
Added summaries for Marowak and Magneton.
Fixed a bug that made draft rates incorrect for some Pokemon on their profile pages.
Fixed a bug that excluded RevD, CC, and K6 from tournament filter searches.
Fixed a bug in Battle Replay Tool that would sometimes cause replay graphics to not load (for real, this time).
Updated Battle Replay tool to interface with cloud database instead of text files.
Added a custom background and assets for the Battle Replay tool.
Added new accolades for players with milestone achievements: 100 battles, 20 tournaments, 24 drafts.

Results from Revival Draft are now in the database.
Added Duo Stats v2, which allows sorting by various fields and more duos per query. This replaces the old Duo Stats tool.

Results from Continental Crush are now in the database.
Replaced Gengar with Starmie for Globetrotter ribbons to represent current drafting trends.
Fixed data entry errors involving overall pick number for V3.3, creating errors in ADP.
Fixed bugs for various users around the database.

Cleaned up styling and many bugs across the site to look better on mobile devices.
Renamed "ADV Draft Article Compendium" to simply "ADV Draft Compendium".
Temporarily removed most tooltips from the website.

Made fix to Draft Stats for Pokemon that go undrafted in certain tournaments. - 1.5.1 Update - 6/27/25
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" accolade 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.