zzz-pokedex.git
14 years agoMake version_group.versions an actual relation with an order_by().
Zhorken [Mon, 6 Dec 2010 22:56:43 +0000 (17:56 -0500)] 
Make version_group.versions an actual relation with an order_by().

14 years agoImplement an ability changelog; add a few changes. #78
Zhorken [Mon, 6 Dec 2010 22:45:43 +0000 (17:45 -0500)] 
Implement an ability changelog; add a few changes. #78

14 years agoVarious B/W ability fixes based on Smogon's research.
Zhorken [Mon, 6 Dec 2010 22:38:11 +0000 (17:38 -0500)] 
Various B/W ability fixes based on Smogon's research.

14 years agoCorrected effect of shell break, added a few idiosyncrasies for rest
Brigit Lemanski [Mon, 6 Dec 2010 21:15:48 +0000 (16:15 -0500)] 
Corrected effect of shell break, added a few idiosyncrasies for rest

14 years agoMention buggy interaction between freefall and Gravity. #376
Eevee [Mon, 6 Dec 2010 02:41:04 +0000 (18:41 -0800)] 
Mention buggy interaction between freefall and Gravity.  #376

14 years agoFinal gen V move effects, part 6 of 6!!! #376
Eevee [Mon, 6 Dec 2010 02:30:15 +0000 (18:30 -0800)] 
Final gen V move effects, part 6 of 6!!!  #376

14 years agoFinal gen V move effects, part 5 of 6. #376
Eevee [Mon, 6 Dec 2010 02:08:04 +0000 (18:08 -0800)] 
Final gen V move effects, part 5 of 6.  #376

14 years agoFinal gen V move effects, part 4 of 6. #376
Eevee [Mon, 6 Dec 2010 01:52:05 +0000 (17:52 -0800)] 
Final gen V move effects, part 4 of 6.  #376

14 years agoFinal gen V move effects, part 3 of 6. #376
Eevee [Sun, 5 Dec 2010 08:20:14 +0000 (00:20 -0800)] 
Final gen V move effects, part 3 of 6.  #376

14 years agoFinal gen V move effects, part 2 of 6. #376
Eevee [Sun, 5 Dec 2010 05:15:00 +0000 (21:15 -0800)] 
Final gen V move effects, part 2 of 6.  #376

14 years agoVersion group Pokédexes don't need their own table.
Zhorken [Sun, 5 Dec 2010 01:46:06 +0000 (20:46 -0500)] 
Version group Pokédexes don't need their own table.

14 years agoMove effect text: never capitalize accuracy/evasion. #353
Eevee [Sat, 4 Dec 2010 06:24:14 +0000 (22:24 -0800)] 
Move effect text: never capitalize accuracy/evasion.  #353

14 years agoMove effect text: "stage" instead of "level" for stat changes; "critical hit" phrasin...
Eevee [Sat, 4 Dec 2010 06:19:22 +0000 (22:19 -0800)] 
Move effect text: "stage" instead of "level" for stat changes; "critical hit" phrasing.  #353

14 years agoFinal gen V move effects, part 1 of 6. #376
Eevee [Sat, 4 Dec 2010 05:31:30 +0000 (21:31 -0800)] 
Final gen V move effects, part 1 of 6.  #376

14 years agoSugimori art for Gen V.
Eevee [Fri, 3 Dec 2010 02:57:28 +0000 (18:57 -0800)] 
Sugimori art for Gen V.

14 years agoAdded tests for form lookup, fixing the suite.
Eevee [Wed, 1 Dec 2010 20:06:45 +0000 (12:06 -0800)] 
Added tests for form lookup, fixing the suite.

14 years agoImplement a move data changelog. Update old moves to their Gen V stats. #78
Eevee [Sat, 27 Nov 2010 09:25:38 +0000 (01:25 -0800)] 
Implement a move data changelog.  Update old moves to their Gen V stats.  #78

14 years agoForeign names for the handful of Gen V stuff.
Zhorken [Tue, 30 Nov 2010 17:55:52 +0000 (12:55 -0500)] 
Foreign names for the handful of Gen V stuff.

14 years agoUse Unova's English name. #451
Zhorken [Tue, 30 Nov 2010 09:44:27 +0000 (04:44 -0500)] 
Use Unova's English name. #451

14 years agoAdd Pokémon's Pokéathlon stats to the database. #285
Zhorken [Tue, 30 Nov 2010 07:29:14 +0000 (02:29 -0500)] 
Add Pokémon's Pokéathlon stats to the database. #285

14 years agoAdd some needed quotation marks to pokemon_form_groups.
Zhorken [Tue, 30 Nov 2010 02:29:39 +0000 (21:29 -0500)] 
Add some needed quotation marks to pokemon_form_groups.

14 years agoB/W: Info for new form groups. #453
Zhorken [Tue, 30 Nov 2010 02:19:22 +0000 (21:19 -0500)] 
B/W: Info for new form groups. #453

14 years agoOverhaul the Pokémon form schema. #286 #179 #379
Zhorken [Mon, 29 Nov 2010 23:51:50 +0000 (18:51 -0500)] 
Overhaul the Pokémon form schema. #286 #179 #379

14 years agoMunna Black flavor text. #449
Eevee [Sat, 27 Nov 2010 09:15:25 +0000 (01:15 -0800)] 
Munna Black flavor text.  #449

14 years agoAdded a little script for editing our csv files as yaml. veekun-promotions/2010112601
Eevee [Fri, 26 Nov 2010 07:04:38 +0000 (23:04 -0800)] 
Added a little script for editing our csv files as yaml.

14 years agoAdd Dream World abilities. #380
Eevee [Thu, 25 Nov 2010 08:09:06 +0000 (00:09 -0800)] 
Add Dream World abilities.  #380

14 years agoFix names for Whirl Islands floors. #403
Eevee [Wed, 24 Nov 2010 03:24:19 +0000 (19:24 -0800)] 
Fix names for Whirl Islands floors.  #403

14 years agoGen V English names for the starters and Reshiram/Zekrom. #450
Eevee [Tue, 23 Nov 2010 23:54:44 +0000 (15:54 -0800)] 
Gen V English names for the starters and Reshiram/Zekrom.  #450

14 years agoFinish documenting the tables veekun-promotions/2010112001
Petr Viktorin [Sun, 3 Oct 2010 19:21:39 +0000 (22:21 +0300)] 
Finish documenting the tables

14 years agoSchema documentation, up to Language
Petr Viktorin [Sun, 3 Oct 2010 15:21:50 +0000 (18:21 +0300)] 
Schema documentation, up to Language

14 years agoVarious move/ability updates from surskitty! #376
Eevee [Sat, 13 Nov 2010 06:40:45 +0000 (22:40 -0800)] 
Various move/ability updates from surskitty!  #376

14 years agoFix GLARING ERROR in gear change effect. #376
Eevee [Thu, 4 Nov 2010 02:41:23 +0000 (19:41 -0700)] 
Fix GLARING ERROR in gear change effect.  #376

14 years agoFix a few syntax errors and such in abilities.
Zhorken [Wed, 27 Oct 2010 23:50:37 +0000 (19:50 -0400)] 
Fix a few syntax errors and such in abilities.

Only one of these is actually a syntax error, but whatever.

14 years agoB/W: Footprints! Replace the old ones with a B/W rip.
Zhorken [Wed, 27 Oct 2010 17:38:55 +0000 (13:38 -0400)] 
B/W: Footprints!  Replace the old ones with a B/W rip.

The old ones were 3× for some reason and the blank ones all had Gen II's
"NONE" image.  Also, the first 386 had their Gen III footprints; a
handful matched the actual feet badly enough that they changed in D/P.
See #250.

And, of course, this means we aren't missing footprints for the new
Pokémon.

There was also an extra footprint for Cherrim before, even though it was
the same...?

14 years agoBump required whoosh version. veekun-promotions/2010101701
Eevee [Sun, 17 Oct 2010 05:20:23 +0000 (22:20 -0700)] 
Bump required whoosh version.

14 years agoFix typo in Up-Grade effect.
Eevee [Wed, 6 Oct 2010 05:53:30 +0000 (22:53 -0700)] 
Fix typo in Up-Grade effect.

14 years agoMoved priority out of the move_effects table.
Eevee [Thu, 30 Sep 2010 05:12:48 +0000 (22:12 -0700)] 
Moved priority out of the move_effects table.

14 years agoFix a syntax error in Immunity's short effect. veekun-promotions/2010101501
Zhorken [Mon, 4 Oct 2010 01:25:01 +0000 (21:25 -0400)] 
Fix a syntax error in Immunity's short effect.

14 years agobaaku auto makes more sense as "bark out".
Zhorken [Sun, 3 Oct 2010 00:24:49 +0000 (20:24 -0400)] 
baaku auto makes more sense as "bark out".

14 years agoAdd a few missing HG/SS tutor moves. #276 #288
Zhorken [Wed, 29 Sep 2010 20:39:36 +0000 (16:39 -0400)] 
Add a few missing HG/SS tutor moves. #276 #288

I noticed that the Togepi line was also missing Magic Coat when I went to
double-check Togetic's Twister.  I checked Togepi and Togekiss and added
that, too.

14 years agoRename the pawprints folder to footprints. #282
Zhorken [Wed, 29 Sep 2010 19:33:45 +0000 (15:33 -0400)] 
Rename the pawprints folder to footprints. #282

Bunch of things are showing up as "copied" because a lot of footprints
are the same.

14 years agoGen V ability (and a move) effect fixing, round 1.
Eevee [Wed, 29 Sep 2010 05:00:08 +0000 (22:00 -0700)] 
Gen V ability (and a move) effect fixing, round 1.

14 years ago"slime wave" should be "sludge wave".
Eevee [Wed, 29 Sep 2010 04:58:13 +0000 (21:58 -0700)] 
"slime wave" should be "sludge wave".

14 years agoancient song is sorta a tutor move for meroetta.
Eevee [Wed, 29 Sep 2010 04:53:32 +0000 (21:53 -0700)] 
ancient song is sorta a tutor move for meroetta.

14 years agoWhoops. Also rename these forms' sprites to match.
Zhorken [Mon, 27 Sep 2010 07:29:48 +0000 (03:29 -0400)] 
Whoops.  Also rename these forms' sprites to match.

Also fix shikijika, mebukijika, and genosekuto's alt-form icons, even
though they aren't used anywhere, and fix their cropped sprites.

... Also fix basurao's entries in the pokemon_form_sprites table.
Apparently pokemon_form_sprites isn't for form sprites, but for what
Eevee calls """sprite forms""".  So the form names are form names, and
not just for image filenames.  So the space versus hyphen matters for
flavour page links.

14 years agoOrder Pokemon.stats by stat id. #366
Zhorken [Mon, 27 Sep 2010 06:59:48 +0000 (02:59 -0400)] 
Order Pokemon.stats by stat id. #366

14 years agoB/W: Real form names for basurao, hihidaruma, and meroetta.
Zhorken [Mon, 27 Sep 2010 06:58:53 +0000 (02:58 -0400)] 
B/W: Real form names for basurao, hihidaruma, and meroetta.

14 years agoB/W: Add national and Isshu dex numbers for new Pokémon.
Zhorken [Sat, 25 Sep 2010 18:54:51 +0000 (14:54 -0400)] 
B/W: Add national and Isshu dex numbers for new Pokémon.

14 years agoB/W: Add Pokémon's wild held items.
Zhorken [Sat, 25 Sep 2010 10:17:39 +0000 (06:17 -0400)] 
B/W: Add Pokémon's wild held items.

14 years agoLink TMs 93-95 to the right items so the TM/HM pocket doesn't crash.
Zhorken [Sat, 25 Sep 2010 10:04:43 +0000 (06:04 -0400)] 
Link TMs 93-95 to the right items so the TM/HM pocket doesn't crash.

14 years agoAdd Pokémon internal IDs for Gen V.
Zhorken [Sat, 25 Sep 2010 09:39:42 +0000 (05:39 -0400)] 
Add Pokémon internal IDs for Gen V.

The 649 base forms' IDs match their Pokédex numbers, but I needed the
alternate forms' IDs for Black and White wild held items.

14 years agoB/W: Add new items' sprites.
Zhorken [Sat, 25 Sep 2010 08:56:43 +0000 (04:56 -0400)] 
B/W: Add new items' sprites.

14 years agoB/W: Add new items to the database.
Zhorken [Sat, 25 Sep 2010 08:55:21 +0000 (04:55 -0400)] 
B/W: Add new items to the database.

There's now a hole in the items table: there's no item 667.  There are
two records for the Live Caster in B/W, and I couldn't figure out why,
or see any difference between them, and they were causing problems, so
I deleted the second one.

14 years agoToss some unneeded quotation marks from abilities.csv.
Zhorken [Sat, 25 Sep 2010 08:53:56 +0000 (04:53 -0400)] 
Toss some unneeded quotation marks from abilities.csv.

When I re-dumped, they disappeared.  I figured that might happen; I
intended to do that before pushing and then I didn't.  Whoops.

14 years agoFix handling of some fullwidth Latin characters in romanization.
Zhorken [Fri, 24 Sep 2010 08:18:20 +0000 (04:18 -0400)] 
Fix handling of some fullwidth Latin characters in romanization.

Including fullwidth 0, which was acutally a problem.

14 years agoAdd a couple more odd katakana combos to roomaji.py.
Zhorken [Fri, 24 Sep 2010 06:37:45 +0000 (02:37 -0400)] 
Add a couple more odd katakana combos to roomaji.py.

This covers wooguru and chiraamy; also change their temporary names in
pokemon.csv to reflect this.

14 years agoImprove the description for Shaymin's forms a little.
Zhorken [Thu, 23 Sep 2010 22:53:49 +0000 (18:53 -0400)] 
Improve the description for Shaymin's forms a little.

14 years agoImprove a bunch of (Gen III/IV) ability effects. #39 #353
Zhorken [Thu, 23 Sep 2010 22:45:16 +0000 (18:45 -0400)] 
Improve a bunch of (Gen III/IV) ability effects. #39 #353

Cleanup relevant to #353:
- merged a bunch of {mechanic} synonyms
- tweaked Normalize to correctly reflect Thunder Wave
- heighten/reduce -> increase/decrease

14 years agoAdd B&W Substitute sprites.
a_magical_me [Thu, 23 Sep 2010 06:39:17 +0000 (23:39 -0700)] 
Add B&W Substitute sprites.

14 years agoFix B&W sprites for 585, 586, 649.
a_magical_me [Thu, 23 Sep 2010 06:34:49 +0000 (23:34 -0700)] 
Fix B&W sprites for 585, 586, 649.

They were all missing a named image for the default form.

585 and 586 were inconsistent about fall/autumn.

649 had a couple sprites mislabled.

14 years agoFixed some evolution screwery; mostly B&W fallout. #364 veekun-promotions/2010092101
Eevee [Tue, 21 Sep 2010 06:07:02 +0000 (23:07 -0700)] 
Fixed some evolution screwery; mostly B&W fallout.  #364

14 years agoFixed the name of trash burmy/wormadam sprites in B&W.
Eevee [Tue, 21 Sep 2010 05:57:42 +0000 (22:57 -0700)] 
Fixed the name of trash burmy/wormadam sprites in B&W.

14 years agoNames, most effects, and Japanese flavor text for new moves.
Eevee [Tue, 21 Sep 2010 05:23:37 +0000 (22:23 -0700)] 
Names, most effects, and Japanese flavor text for new moves.

14 years agoNames, most effects, and Japanese flavor text for new abilities.
Eevee [Tue, 21 Sep 2010 05:23:25 +0000 (22:23 -0700)] 
Names, most effects, and Japanese flavor text for new abilities.

14 years agoUnfuck habitat and shape for new Castform forms.
Eevee [Mon, 20 Sep 2010 02:54:07 +0000 (19:54 -0700)] 
Unfuck habitat and shape for new Castform forms.

14 years agoB&W: Sprites for Arceus forms and white 649. veekun-promotions/2010091902
Eevee [Mon, 20 Sep 2010 02:31:14 +0000 (19:31 -0700)] 
B&W: Sprites for Arceus forms and white 649.

14 years agoB&W: Tutor compatibility.
Eevee [Mon, 20 Sep 2010 02:11:14 +0000 (19:11 -0700)] 
B&W: Tutor compatibility.

14 years agoRemoved some junk gen5 egg moves.
Eevee [Mon, 20 Sep 2010 01:46:19 +0000 (18:46 -0700)] 
Removed some junk gen5 egg moves.

14 years agoB&W: Machine compatibility.
Eevee [Mon, 20 Sep 2010 01:42:58 +0000 (18:42 -0700)] 
B&W: Machine compatibility.

14 years agoNormal Castform icon. veekun-promotions/2010091901
Eevee [Sun, 19 Sep 2010 10:15:13 +0000 (03:15 -0700)] 
Normal Castform icon.

14 years agoAdded blue Hihidaruma to evolution table.
Eevee [Sun, 19 Sep 2010 10:09:42 +0000 (03:09 -0700)] 
Added blue Hihidaruma to evolution table.

14 years agoB&W: New Pokémon icons.
Eevee [Sun, 19 Sep 2010 10:02:08 +0000 (03:02 -0700)] 
B&W: New Pokémon icons.

14 years agoB&W: Egg moves.
Eevee [Sun, 19 Sep 2010 09:57:46 +0000 (02:57 -0700)] 
B&W: Egg moves.

14 years agoB&W: New cropped-pokemon based on black-white sprites.
Eevee [Sun, 19 Sep 2010 09:57:12 +0000 (02:57 -0700)] 
B&W: New cropped-pokemon based on black-white sprites.

14 years agoB&W: Level-up moves.
Eevee [Sun, 19 Sep 2010 09:41:46 +0000 (02:41 -0700)] 
B&W: Level-up moves.

14 years agoB&W: New Pokémon cries.
Eevee [Sun, 19 Sep 2010 09:15:27 +0000 (02:15 -0700)] 
B&W: New Pokémon cries.

14 years agoB&W: Some non-physical forms for new Pokémon.
Eevee [Sun, 19 Sep 2010 09:10:33 +0000 (02:10 -0700)] 
B&W: Some non-physical forms for new Pokémon.

14 years agoB&W: Sprites! And a bigger frame.
Eevee [Sun, 19 Sep 2010 09:09:26 +0000 (02:09 -0700)] 
B&W: Sprites!  And a bigger frame.

14 years agoB&W: Japanese names for all those new Pokémon and moves.
Eevee [Sun, 19 Sep 2010 08:11:32 +0000 (01:11 -0700)] 
B&W: Japanese names for all those new Pokémon and moves.

14 years agoB&W: New moves. Also changed always-hit moves to NULL; helps #124.
Eevee [Sun, 19 Sep 2010 08:11:03 +0000 (01:11 -0700)] 
B&W: New moves.  Also changed always-hit moves to NULL; helps #124.

14 years agoB&W: Added all new Pokémon! Forms now start at 10001.
Eevee [Sun, 19 Sep 2010 05:52:19 +0000 (22:52 -0700)] 
B&W: Added all new Pokémon!  Forms now start at 10001.

14 years agoB&W: New abilities.
Eevee [Sun, 19 Sep 2010 01:32:47 +0000 (18:32 -0700)] 
B&W: New abilities.

14 years agoAdded some more weird katakana combos to roomaji.py.
Eevee [Sun, 19 Sep 2010 01:31:26 +0000 (18:31 -0700)] 
Added some more weird katakana combos to roomaji.py.

14 years agoFifth move flag is Mirror-Move-able, NOT rolls-accuracy. #350 veekun-promotions/2010091501
Eevee [Mon, 13 Sep 2010 04:14:03 +0000 (21:14 -0700)] 
Fifth move flag is Mirror-Move-able, NOT rolls-accuracy.  #350

14 years agoCrash fix: lookup with empty prefixes.
Eevee [Mon, 13 Sep 2010 04:08:50 +0000 (21:08 -0700)] 
Crash fix: lookup with empty prefixes.

14 years agoFixes for Whoosh 1.0, and better index recreation.
Eevee [Mon, 13 Sep 2010 03:51:51 +0000 (20:51 -0700)] 
Fixes for Whoosh 1.0, and better index recreation.

14 years agoFixed missing indices on the pokemon_moves table. veekun-promotions/2010091201 veekun-promotions/2010091202
Eevee [Sat, 11 Sep 2010 06:29:26 +0000 (23:29 -0700)] 
Fixed missing indices on the pokemon_moves table.

14 years agoAdding SVG of the version icons. Revamped gen4, too. #166
Eevee [Thu, 9 Sep 2010 03:37:44 +0000 (20:37 -0700)] 
Adding SVG of the version icons.  Revamped gen4, too.  #166

14 years agoBlack and White setup!
Eevee [Thu, 9 Sep 2010 03:36:26 +0000 (20:36 -0700)] 
Black and White setup!

14 years agoMake baby-trigger items (i.e., incense) a foreign key. #337
Eevee [Thu, 2 Sep 2010 06:24:21 +0000 (23:24 -0700)] 
Make baby-trigger items (i.e., incense) a foreign key.  #337

14 years agoAdd a Nature.is_neutral helper property.
Eevee [Thu, 2 Sep 2010 04:52:44 +0000 (21:52 -0700)] 
Add a Nature.is_neutral helper property.

14 years agoAdded a bunch of missing Sugimori art. #319
Eevee [Tue, 31 Aug 2010 02:33:16 +0000 (19:33 -0700)] 
Added a bunch of missing Sugimori art.  #319

14 years agoWhoops; had two item categories both called "training". #254
Eevee [Sun, 29 Aug 2010 07:34:21 +0000 (00:34 -0700)] 
Whoops; had two item categories both called "training".  #254

14 years agoGriseous Orb should be in the species-specific category. #328
Eevee [Sun, 29 Aug 2010 07:32:03 +0000 (00:32 -0700)] 
Griseous Orb should be in the species-specific category.  #328

14 years agoFix a couple of location names: Spring Path vs Sendoff Spring, Solaceon Town, and...
Eevee [Wed, 25 Aug 2010 04:35:10 +0000 (21:35 -0700)] 
Fix a couple of location names: Spring Path vs Sendoff Spring, Solaceon Town, and Bell Tower.  #296

14 years agoMake user and code valid_types not interfere when one is language and the other is...
Eevee [Wed, 25 Aug 2010 04:21:29 +0000 (21:21 -0700)] 
Make user and code valid_types not interfere when one is language and the other is table.

14 years agoReturn more than just ten results for wildcard lookups. #90
Eevee [Wed, 25 Aug 2010 03:15:12 +0000 (20:15 -0700)] 
Return more than just ten results for wildcard lookups.  #90

14 years agoAllow restricting lookup by language, with a @ja: prefix. #90
Eevee [Wed, 25 Aug 2010 03:06:40 +0000 (20:06 -0700)] 
Allow restricting lookup by language, with a @ja: prefix.  #90

14 years agoFix Arceus's mismatched and missing sprites. #189
Zhorken [Tue, 24 Aug 2010 03:38:12 +0000 (23:38 -0400)] 
Fix Arceus's mismatched and missing sprites. #189

Its Platinum backsprites followed the veekun database's IDs instead of
the game's internal IDs.  (Our IDs are the same, except for ??? being
moved to the end.)  For example, veekun lists Fire as type #10, but the
gen IV games have ??? as type #10; 493-fire.png was the sprite for ???-
type Arceus.  This is why about half of them were in a loop.

Its Normal-type Platinum backsprites were outright missing, and its ???
Platinum frontsprites were copies of Dark's instead.  I reripped those.

493-normal overworld sprites were missing, but its plain 493.png sprites
were its default, Normal-type form, so I copied those.

14 years agoAdd Mr. Pokémon and Primo as "locations".
Zhorken [Mon, 23 Aug 2010 05:29:13 +0000 (01:29 -0400)] 
Add Mr. Pokémon and Primo as "locations".

Primo is the dude in the Violet City Pokémon Center who used to host the
Teachy TV programs and now sits around asking passersby what they think
of him or whatever.  If you tell him the right phrases for your trainer
ID, he'll give you an egg.  See: http://www.filb.de/games/tools/aikotoba