Eevee [Fri, 1 May 2009 13:20:18 +0000 (06:20 -0700)]
Added encounter data for Diamond, Pearl, and Platinum.
Finally! Location order is the same as from the old dex, which was
something like the game but ultimately arbitrary, so it's not any better
now.
This takes a very different approach to storage, rather than copying the
game exactly and trying to fix everything in code. Comments coming
shortly so other people can actually make use of this.
Eevee [Fri, 27 Mar 2009 23:49:20 +0000 (19:49 -0400)]
Added a function for the EXP formula.
Eevee [Thu, 26 Mar 2009 00:48:36 +0000 (20:48 -0400)]
Added a couple extra female back sprite flags, new in Platinum.
Renamed the female-sprite columns as for 'gen4' rather than 'dp'.
Eevee [Thu, 26 Mar 2009 00:43:09 +0000 (20:43 -0400)]
Fixed CSV import's handling of Boolean columns.
Eevee [Thu, 26 Mar 2009 00:42:08 +0000 (20:42 -0400)]
Added Platinum sprites, excluding Formes.
Eevee [Mon, 23 Mar 2009 02:07:31 +0000 (22:07 -0400)]
Added Python versions of stat formulae.
Eevee [Mon, 23 Mar 2009 01:14:44 +0000 (21:14 -0400)]
Merge branch 'master' of eevee@tekkanin.veekun.com:dev/pokedex
Eevee [Mon, 23 Mar 2009 01:09:16 +0000 (18:09 -0700)]
Added generic trainer guy/girl sprites, used for size comparison.
Eevee [Fri, 20 Mar 2009 23:28:41 +0000 (19:28 -0400)]
Added relations for evolution.
Alternate Formes also now have NULL evolution chain ids.
Eevee [Fri, 20 Mar 2009 04:05:07 +0000 (00:05 -0400)]
Oops. Removed leading zeroes on icons.
Eevee [Fri, 20 Mar 2009 04:01:43 +0000 (00:01 -0400)]
Added Pokémon icons.
Eevee [Mon, 9 Mar 2009 01:34:48 +0000 (21:34 -0400)]
CSV import now respects NULLability of columns.
Empty strings loaded into NULL columns are changed to NULL instead.
Eevee [Sun, 8 Mar 2009 02:54:01 +0000 (18:54 -0800)]
Fixed some MySQL import problems.
Tables weren't being defined as UTF-8 if that wasn't the server default.
A lot of tables were trying to create erroneous auto_increment columns.
Foreign key checks were pretty much fucking everything up.
Eevee [Sun, 8 Mar 2009 00:26:57 +0000 (16:26 -0800)]
Added SQLAlchemy to setup.py and fixed a typo in .gitignore.
Eevee [Sat, 7 Mar 2009 04:54:32 +0000 (20:54 -0800)]
Added Pokémon cries.
Eevee [Sat, 7 Mar 2009 04:21:43 +0000 (20:21 -0800)]
Added Diamond/Pearl Pokemon sprites.
Eevee [Sat, 7 Mar 2009 04:15:19 +0000 (20:15 -0800)]
Fixed some Platinum sprite naming.
201-f.png had become female/201.png.
Deoxys forms were named after games, rather than stats.
Eevee [Sat, 7 Mar 2009 03:14:42 +0000 (19:14 -0800)]
Added habitat sprites. Renamed flavor to flavor_text.
pokemon_flavor_text.flavor -> pokemon_flavor_text.flavor_text
Eevee [Sat, 7 Mar 2009 01:15:24 +0000 (17:15 -0800)]
Moved images/ to media/.
Since this directory will shortly contain cries, which are mp3s,
'images' didn't really seem fitting.
Eevee [Fri, 6 Mar 2009 05:37:25 +0000 (21:37 -0800)]
Added footprint images.
Eevee [Thu, 5 Mar 2009 03:36:09 +0000 (19:36 -0800)]
Added body shape icons. Oops.
Eevee [Thu, 5 Mar 2009 03:29:43 +0000 (19:29 -0800)]
Added Pokemon body shapes.
Eevee [Wed, 4 Mar 2009 02:19:48 +0000 (18:19 -0800)]
Added gender rate bars.
Putting them in here because they strike me as generally useful.
Eevee [Wed, 4 Mar 2009 01:59:18 +0000 (17:59 -0800)]
Round 1 of version icons!
Eevee [Wed, 4 Mar 2009 01:58:27 +0000 (17:58 -0800)]
Few more relations, for egg groups and evo chains.
Eevee [Wed, 4 Mar 2009 01:58:10 +0000 (17:58 -0800)]
Added region names to the generations table.
Eevee [Mon, 2 Mar 2009 09:06:31 +0000 (01:06 -0800)]
Added a generation_id column to the pokemon table.
Eevee [Mon, 2 Mar 2009 09:05:26 +0000 (01:05 -0800)]
Added sprite frames, used on Pokemon page headers.
Eevee [Mon, 2 Mar 2009 03:49:23 +0000 (19:49 -0800)]
Added contest and type ingame sprites.
Eevee [Mon, 2 Mar 2009 03:40:02 +0000 (19:40 -0800)]
Added more table relations, for spline-pokedex Pokemon page.
Eevee [Sat, 28 Feb 2009 08:00:39 +0000 (00:00 -0800)]
Added Sugimori art. Moves images into data/ folder.
Eevee [Sat, 28 Feb 2009 02:42:12 +0000 (18:42 -0800)]
Fixed Pokemon female-sprite flags.
Pokemon that have both a female front and back sprite in Gen IV didn't
import the flags at all. Some goof on my part.
Eevee [Tue, 24 Feb 2009 07:31:35 +0000 (23:31 -0800)]
Added a whole bunch of foreign keys.
Eevee [Tue, 24 Feb 2009 02:21:15 +0000 (18:21 -0800)]
Added Trozei sprites.
Eevee [Mon, 23 Feb 2009 07:46:25 +0000 (23:46 -0800)]
Reverted unnecessary changes to setup.py.
Eevee [Mon, 23 Feb 2009 07:44:40 +0000 (23:44 -0800)]
Moved CSV sources into pokedex/.
This appears to be the only way to make data access in eggs actually
work, and is why the Platinum sprites are in pokedex/ too.
Eevee [Mon, 23 Feb 2009 07:43:33 +0000 (23:43 -0800)]
Added Platinum front sprites.
Eevee [Sun, 15 Feb 2009 03:19:19 +0000 (19:19 -0800)]
Made a data/csv directory for CSV sources.
Eevee [Thu, 5 Feb 2009 08:05:42 +0000 (00:05 -0800)]
Initial commit, with much of the data imported.
Includes a wrapper script 'pokedex' that can, so far, read data from a
db and spit out CSVs or deploy CSVs to a db.