about summary refs log tree commit diff stats
Commit message (Collapse)AuthorAgeFilesLines
* Fixed typo in database indexKelly Rauchenberger2018-01-291-1/+1
|
* Added Pokédex viewing pageKelly Rauchenberger2018-01-2911-1/+215
| | | | Currently a work in progress. The queries used to display the Pokémon for each species are very inefficient. The text at the top of the page is also very specific to the author.
* Cached a Pokémon's latest revisionKelly Rauchenberger2018-01-145-4/+47
| | | | | | | | This removes the need to use a GROUP or DISTINCT in eager-loading Pokémon on the front page. It duplicates data, but provisions are in place to keep the cache up-to-date. When a Pokémon record is updated, it is required that its cache points to the current revision. When a revision is created, it updates the Pokémon's cache to point to it, because a new revision will always be the most recent one, and it is impossible to reorder revisions. This does not affect the number of queries used on the front page (see #1). refs #4
* Replaced GROUP clause in front page query with DISTINCTKelly Rauchenberger2018-01-131-3/+3
| | | | Apparently the choice of row to be returned with a GROUP that uses fields outside of ones that are functionally dependent on the GROUP fields is arbitrary, as per https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
* Fixed incorrect icon eager loading bug on front pageKelly Rauchenberger2018-01-134-11/+7
| | | | A bug was causing a Vigoroth which had evolved into a Slaking to still show up as a Vigoroth on the front page of the engine, even though it showed up properly on its show page. This was deemed to be caused by eager loading.
* Moved species from Pokémon to revisionKelly Rauchenberger2018-01-1310-111/+152
| | | | | | | | The migration will set all of the revisions of each Pokémon to have the species that that Pokémon was set to. If reversed, the migration sets the Pokémon's species to the first revision's species, which mimics the behavior of the engine from before this change, but do note that running the migration backwards like this can lose data. This change slightly affects the loading time of the front page. See #2. refs #3
* Improved clarity of iconsKelly Rauchenberger2018-01-052-1/+28
|
* Added more space between trainer divsKelly Rauchenberger2017-10-151-1/+1
|
* Removed gen 4 abilities from db seedsKelly Rauchenberger2017-10-151-94/+94
|
* Fixed two more migrations, similar to previousKelly Rauchenberger2017-10-152-3/+5
|
* Fixed migration againKelly Rauchenberger2017-10-151-1/+1
|
* Changed the way that the hold item column is migratedKelly Rauchenberger2017-10-151-1/+3
| | | | | | | MySQL seems to choke on the previous way that the hold_item column became the item_id column; since this is an old migration and would only be run retroactively anyway, we can change this to just dropping the hold_item column and adding the item_id column.
* Fixed typo in some foreign keysKelly Rauchenberger2017-10-151-5/+5
|
* Centered trainer listKelly Rauchenberger2017-10-151-1/+2
|
* Actually fixed index page when there's no PokémonKelly Rauchenberger2017-10-151-4/+8
|
* Removed temporary headerKelly Rauchenberger2017-10-151-1/+0
|
* Changed trainer list to root routeKelly Rauchenberger2017-10-151-1/+2
|
* Fixed index page when there are no PokémonKelly Rauchenberger2017-10-151-1/+1
|
* Integrated auth into main appKelly Rauchenberger2017-10-153-1/+20
| | | | | | | Pokeviewer now expects the main app's ApplicationController to contain a method called "authenticate_pokeviewer" which will return true iff the username and token passed to it are valid. An example stub is present in the test dummy ApplicationController.
* Changed met text for fateful encountersKelly Rauchenberger2017-10-131-1/+1
|
* Added shiny starKelly Rauchenberger2017-10-134-3/+14
|
* Added gender symbol to Pokémon displayKelly Rauchenberger2017-10-133-6/+27
|
* Added sheen to Pokémon contest statsKelly Rauchenberger2017-10-132-1/+54
|
* Fixed behavior of gift ribbons for Pokémon not in any gameKelly Rauchenberger2017-10-132-7/+15
|
* Redesigned Pokémon show pageKelly Rauchenberger2017-10-138-246/+534
| | | | | | | | | | | | | The new design is heavily inspired by the status screen from Diamond & Pearl. It's not entirely done yet, with notable missing features including sheen and gender. However, it would also be nice to show a star for shiny Pokémon, Pokérus status, possibly a mention as to what game the Pokémon is currently in, and descriptive hover bubbles for moves. It is also notable that currently, as ribbons are located all the way to the right, their hover bubbles usually go off screen. The list of Pokémon page has not been redesigned, and the main layout is still bare.
* Fixed Gengar not being added to databaseKelly Rauchenberger2017-10-111-1/+1
| | | | | | | The data that was used to generate the database seed was accurate to generation VII, and thus listed Gengar as having the ability Cursed Body, since it was changed to have that ability in gen VII. This caused a validation to fail, and Gengar would not be added to the database.
* Added type and ability data to species modelKelly Rauchenberger2017-10-108-390/+537
|
* Made move names accurate to gen 3Kelly Rauchenberger2017-10-061-20/+20
| | | | | | Some moves have changed names in later gens, and those changed names were present in the database seeds, so they were changed to be accurate to gen 3.
* Pokémon now show the Poké Ball that they're inKelly Rauchenberger2017-10-045-2/+23
| | | | Also fixed a bug with viewing Pokémon that aren't in any game.
* Added generic met message for Pokémon from OrreKelly Rauchenberger2017-10-042-2/+7
| | | | | | Pokémon from Orre now display "Met in a trade" instead of an entirely incorrect met location, because we're not currently equipped to display the proper met data for them (see hatkirby/gen3uploader#6).
* Optimized front page queriesKelly Rauchenberger2017-10-032-9/+70
| | | | | | | | | | | Reduced the number of queries that the front page runs to 2 queries total: one to get trainer data, and one to get the Pokémon. The latter query selects only the necessary columns, notably ignoring basically everything from the revisions join other than the nickname of the most recent revision. The controller then does the work of chunking the Pokémon into party/boxes, and then into trainers/unaccounted. refs #2
* Removed box modelKelly Rauchenberger2017-10-037-68/+229
| | | | | | | | | | | | | It seemed kind of strange to have a model that there should always be exactly 14 of for each of the parent (Trainer) model instances, so the box names were moved into the Trainer model, and the Box model was removed. This commit also adds some eager loading to speed up page loading times. Also made a small change to the way the gift ribbons are extracted. refs #2
* Made "met location" into an actual associationKelly Rauchenberger2017-10-035-12/+40
|
* Emerald animated sprites only loop on demandKelly Rauchenberger2017-09-30833-2/+4
| | | | | | | It was a little annoying that the animated sprites for Pokémon in Emerald would infinitely loop without much delay between the loops, so the GIFs were edited such that they only play once, and some JavaScript was added such that mousing over the sprite makes it play again.
* Added hold itemsKelly Rauchenberger2017-09-30228-363/+1910
| | | | | | | | | | | | | | | | | | | | | | An items model was created, but the seed only contains items that can be held, which excludes key items and HMs. Berry Juice, while unobtainable, is still included. The item model contains three description fields: one for Ruby/Sapphire, one for FireRed/LeafGreen, and one for Emerald. This is because the descriptions for items are different between the games. In a lot of cases, the Emerald description is the same as the Ruby/Sapphire one, so in those cases, the Emerald description is nil. The purpose of having the different descriptions is so that when a Pokémon holds an item, the website can display the description that is accurate to the game that that Pokémon is currently in. In order to fully support TMs, the move model was improved to additionally contain type and also the three description fields which operate similarly to those of the item model. For TMs, the description fields on the item are usually nil. However, some TMs in Ruby/Sapphire, as well as Emerald, have different descriptions than the moves that they correspond with. In these cases, those descriptions are in the item model, and override the move descriptions when the move is looked at as a TM.
* Added gift ribbon descriptionsKelly Rauchenberger2017-09-308-8/+189
| | | | | | This is basically just for completeness because it is unknown whether gift ribbons other than the National Ribbon and Earth Ribbon from Pokémon Colosseum were ever distributed.
* Added ribbonsKelly Rauchenberger2017-09-299-30/+411
| | | | | | Gift ribbons currently partially work: the correct ribbon image and name is shown, but the ribbon description is not yet extracted from the game and thus is just blank.
* Added axes to condition diagramKelly Rauchenberger2017-09-292-4/+21
|
* Added contest diagramKelly Rauchenberger2017-09-285-2/+131
|
* Continued working on design, added movesKelly Rauchenberger2017-09-275-52/+203
| | | | | | | | Still a very early design Also, for Pokémon that have Natures that don't benefit and hinder the same stat, there is now a + next to the stat that the Nature benefits, and a - next to the stat it hinders.
* Added section on homepage for Pokémon not in any gameKelly Rauchenberger2017-09-264-19/+51
|
* Added met location dataKelly Rauchenberger2017-09-259-29/+351
| | | | | Note that the met location for Pokémon from Orre is completely incorrect.
* Fixed leading spaces in Pokémon namesKelly Rauchenberger2017-09-241-0/+3
|
* Added space to empty box slotsKelly Rauchenberger2017-09-242-1/+9
|
* Added box namesKelly Rauchenberger2017-09-246-23/+65
|
* Worked on PC display pageKelly Rauchenberger2017-09-2411-14/+228
|
* Added storage location information to PokémonKelly Rauchenberger2017-09-244-6/+28
|
* Added OT gender fieldKelly Rauchenberger2017-09-245-2/+12
|
* Started working on UIKelly Rauchenberger2017-09-242471-9/+208
| | | | | This commit imports a lot of assets from veekun, as well as a font from http://www.victoryroad.net/showthread.php?t=1507
* Added seed data for Pokémon species and movesKelly Rauchenberger2017-09-232-0/+744
|