| Commit message (Collapse) | Author | Age | Files | Lines |
|---|
| | |
|
| | |
|
| |
|
|
| |
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.
|
| |
|
|
|
|
|
|
| |
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
|
| |
|
|
|
|
|
|
| |
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
|
| | |
|
| | |
|
| | |
|
| |
|
|
|
|
|
| |
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.
|
| | |
|
| |
|
|
|
|
|
| |
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.
|
| | |
|
| |
|
|
|
|
| |
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.
|
| |
|
|
| |
Also fixed a bug with viewing Pokémon that aren't in any game.
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
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
|
| | |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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.
|
| |
|
|
|
|
| |
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.
|
| |
|
|
|
|
| |
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.
|
| |
|
|
|
| |
Note that the met location for Pokémon from Orre is completely
incorrect.
|
| | |
|
| | |
|
| | |
|
| |
|
|
|
| |
This commit imports a lot of assets from veekun, as well as a font from
http://www.victoryroad.net/showthread.php?t=1507
|
| | |
|
| |
|
|
|
|
| |
This is a retroactive schema change, so there's no easy way to migrate
into it without losing data, but this is so early into the development
of this project that it really doesn't matter.
|
| |
|
