Eevee [Fri, 26 Nov 2010 07:04:38 +0000 (23:04 -0800)]
Added a little script for editing our csv files as yaml.
Eevee [Thu, 25 Nov 2010 08:09:06 +0000 (00:09 -0800)]
Add Dream World abilities. #380
Eevee [Wed, 24 Nov 2010 03:24:19 +0000 (19:24 -0800)]
Fix names for Whirl Islands floors. #403
Eevee [Tue, 23 Nov 2010 23:54:44 +0000 (15:54 -0800)]
Gen V English names for the starters and Reshiram/Zekrom. #450
Petr Viktorin [Sun, 3 Oct 2010 19:21:39 +0000 (22:21 +0300)]
Finish documenting the tables
Petr Viktorin [Sun, 3 Oct 2010 15:21:50 +0000 (18:21 +0300)]
Schema documentation, up to Language
Eevee [Sat, 13 Nov 2010 06:40:45 +0000 (22:40 -0800)]
Various move/ability updates from surskitty! #376
Eevee [Thu, 4 Nov 2010 02:41:23 +0000 (19:41 -0700)]
Fix GLARING ERROR in gear change effect. #376
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.
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...?
Eevee [Sun, 17 Oct 2010 05:20:23 +0000 (22:20 -0700)]
Bump required whoosh version.
Eevee [Wed, 6 Oct 2010 05:53:30 +0000 (22:53 -0700)]
Fix typo in Up-Grade effect.
Eevee [Thu, 30 Sep 2010 05:12:48 +0000 (22:12 -0700)]
Moved priority out of the move_effects table.
Zhorken [Mon, 4 Oct 2010 01:25:01 +0000 (21:25 -0400)]
Fix a syntax error in Immunity's short effect.
Zhorken [Sun, 3 Oct 2010 00:24:49 +0000 (20:24 -0400)]
baaku auto makes more sense as "bark out".
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.
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.
Eevee [Wed, 29 Sep 2010 05:00:08 +0000 (22:00 -0700)]
Gen V ability (and a move) effect fixing, round 1.
Eevee [Wed, 29 Sep 2010 04:58:13 +0000 (21:58 -0700)]
"slime wave" should be "sludge wave".
Eevee [Wed, 29 Sep 2010 04:53:32 +0000 (21:53 -0700)]
ancient song is sorta a tutor move for meroetta.
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.
Zhorken [Mon, 27 Sep 2010 06:59:48 +0000 (02:59 -0400)]
Order Pokemon.stats by stat id. #366
Zhorken [Mon, 27 Sep 2010 06:58:53 +0000 (02:58 -0400)]
B/W: Real form names for basurao, hihidaruma, and meroetta.
Zhorken [Sat, 25 Sep 2010 18:54:51 +0000 (14:54 -0400)]
B/W: Add national and Isshu dex numbers for new Pokémon.
Zhorken [Sat, 25 Sep 2010 10:17:39 +0000 (06:17 -0400)]
B/W: Add Pokémon's wild held items.
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.
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.
Zhorken [Sat, 25 Sep 2010 08:56:43 +0000 (04:56 -0400)]
B/W: Add new items' sprites.
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.
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.
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.
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.
Zhorken [Thu, 23 Sep 2010 22:53:49 +0000 (18:53 -0400)]
Improve the description for Shaymin's forms a little.
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
a_magical_me [Thu, 23 Sep 2010 06:39:17 +0000 (23:39 -0700)]
Add B&W Substitute sprites.
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.
Eevee [Tue, 21 Sep 2010 06:07:02 +0000 (23:07 -0700)]
Fixed some evolution screwery; mostly B&W fallout. #364
Eevee [Tue, 21 Sep 2010 05:57:42 +0000 (22:57 -0700)]
Fixed the name of trash burmy/wormadam sprites in B&W.
Eevee [Tue, 21 Sep 2010 05:23:37 +0000 (22:23 -0700)]
Names, most effects, and Japanese flavor text for new moves.
Eevee [Tue, 21 Sep 2010 05:23:25 +0000 (22:23 -0700)]
Names, most effects, and Japanese flavor text for new abilities.
Eevee [Mon, 20 Sep 2010 02:54:07 +0000 (19:54 -0700)]
Unfuck habitat and shape for new Castform forms.
Eevee [Mon, 20 Sep 2010 02:31:14 +0000 (19:31 -0700)]
B&W: Sprites for Arceus forms and white 649.
Eevee [Mon, 20 Sep 2010 02:11:14 +0000 (19:11 -0700)]
B&W: Tutor compatibility.
Eevee [Mon, 20 Sep 2010 01:46:19 +0000 (18:46 -0700)]
Removed some junk gen5 egg moves.
Eevee [Mon, 20 Sep 2010 01:42:58 +0000 (18:42 -0700)]
B&W: Machine compatibility.
Eevee [Sun, 19 Sep 2010 10:15:13 +0000 (03:15 -0700)]
Normal Castform icon.
Eevee [Sun, 19 Sep 2010 10:09:42 +0000 (03:09 -0700)]
Added blue Hihidaruma to evolution table.
Eevee [Sun, 19 Sep 2010 10:02:08 +0000 (03:02 -0700)]
B&W: New Pokémon icons.
Eevee [Sun, 19 Sep 2010 09:57:46 +0000 (02:57 -0700)]
B&W: Egg moves.
Eevee [Sun, 19 Sep 2010 09:57:12 +0000 (02:57 -0700)]
B&W: New cropped-pokemon based on black-white sprites.
Eevee [Sun, 19 Sep 2010 09:41:46 +0000 (02:41 -0700)]
B&W: Level-up moves.
Eevee [Sun, 19 Sep 2010 09:15:27 +0000 (02:15 -0700)]
B&W: New Pokémon cries.
Eevee [Sun, 19 Sep 2010 09:10:33 +0000 (02:10 -0700)]
B&W: Some non-physical forms for new Pokémon.
Eevee [Sun, 19 Sep 2010 09:09:26 +0000 (02:09 -0700)]
B&W: Sprites! And a bigger frame.
Eevee [Sun, 19 Sep 2010 08:11:32 +0000 (01:11 -0700)]
B&W: Japanese names for all those new Pokémon and moves.
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.
Eevee [Sun, 19 Sep 2010 05:52:19 +0000 (22:52 -0700)]
B&W: Added all new Pokémon! Forms now start at 10001.
Eevee [Sun, 19 Sep 2010 01:32:47 +0000 (18:32 -0700)]
B&W: New abilities.
Eevee [Sun, 19 Sep 2010 01:31:26 +0000 (18:31 -0700)]
Added some more weird katakana combos to roomaji.py.
Eevee [Mon, 13 Sep 2010 04:14:03 +0000 (21:14 -0700)]
Fifth move flag is Mirror-Move-able, NOT rolls-accuracy. #350
Eevee [Mon, 13 Sep 2010 04:08:50 +0000 (21:08 -0700)]
Crash fix: lookup with empty prefixes.
Eevee [Mon, 13 Sep 2010 03:51:51 +0000 (20:51 -0700)]
Fixes for Whoosh 1.0, and better index recreation.
Eevee [Sat, 11 Sep 2010 06:29:26 +0000 (23:29 -0700)]
Fixed missing indices on the pokemon_moves table.
Eevee [Thu, 9 Sep 2010 03:37:44 +0000 (20:37 -0700)]
Adding SVG of the version icons. Revamped gen4, too. #166
Eevee [Thu, 9 Sep 2010 03:36:26 +0000 (20:36 -0700)]
Black and White setup!
Eevee [Thu, 2 Sep 2010 06:24:21 +0000 (23:24 -0700)]
Make baby-trigger items (i.e., incense) a foreign key. #337
Eevee [Thu, 2 Sep 2010 04:52:44 +0000 (21:52 -0700)]
Add a Nature.is_neutral helper property.
Eevee [Tue, 31 Aug 2010 02:33:16 +0000 (19:33 -0700)]
Added a bunch of missing Sugimori art. #319
Eevee [Sun, 29 Aug 2010 07:34:21 +0000 (00:34 -0700)]
Whoops; had two item categories both called "training". #254
Eevee [Sun, 29 Aug 2010 07:32:03 +0000 (00:32 -0700)]
Griseous Orb should be in the species-specific category. #328
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
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.
Eevee [Wed, 25 Aug 2010 03:15:12 +0000 (20:15 -0700)]
Return more than just ten results for wildcard lookups. #90
Eevee [Wed, 25 Aug 2010 03:06:40 +0000 (20:06 -0700)]
Allow restricting lookup by language, with a @ja: prefix. #90
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.
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
Eevee [Fri, 20 Aug 2010 03:48:03 +0000 (20:48 -0700)]
Adapt the Pokémon savefile struct to the database.
Eevee [Tue, 10 Aug 2010 17:04:47 +0000 (10:04 -0700)]
Move big items from underground/ to big/, like I thought I did months ago. Oops.
Zhorken [Sat, 7 Aug 2010 02:32:11 +0000 (22:32 -0400)]
Add foreign type names to the database.
Zhorken [Fri, 6 Aug 2010 04:36:09 +0000 (00:36 -0400)]
Elaborate on Honey Gather's effect. #39
Thanks to magical for discovering this.
Zhorken [Thu, 5 Aug 2010 19:54:32 +0000 (15:54 -0400)]
Replace mp3 cries with newly-ripped ogg cries. #91
Created with oggenc, using the default quality of 3.
As with sprites, Shaymin has its default form's cry both as 492.ogg, so
that one can ignore anything that isn't ###.ogg and get a cry for every
Pokémon, and as 492-land.ogg, to avoid needing "don't append the form if
it's the default" junk.
Zhorken [Mon, 26 Jul 2010 20:00:16 +0000 (16:00 -0400)]
Fix/improve a handful of abilities' descriptions.
Eevee [Mon, 26 Jul 2010 03:25:59 +0000 (20:25 -0700)]
Added gen 4 location internal ids and some pseudo-locations.
Eevee [Sun, 11 Jul 2010 08:31:43 +0000 (01:31 -0700)]
Add identifiers for move flags.
Eevee [Sun, 11 Jul 2010 08:31:33 +0000 (01:31 -0700)]
Fix short effect for Flower Gift.
Zhorken [Wed, 14 Jul 2010 03:07:25 +0000 (23:07 -0400)]
Store each Pokémon's initial hatch counter instead of a step count.
The step counts we had weren't even good estimates. To hatch an egg
uninterrupted takes (counter + 1) * 255 steps in gen IV; what we had
was counter * 256.
Phione and Manaphy have different counters, as do Croagunk and Toxicroak
for some reason, so they're associated with individual Pokémon now,
rather than entire evolution chains. Double-checked with Pearl,
Platinum, and SoulSilver; there were no differences between the three,
aside from the alternate forms introduced in Platinum.
Eevee [Thu, 8 Jul 2010 05:29:30 +0000 (22:29 -0700)]
Added an is_shiny accessor to Pokémon structs.
Eevee [Thu, 8 Jul 2010 05:25:23 +0000 (22:25 -0700)]
Add shiny leaf and pokeathlon stat sprites.
Eevee [Sun, 4 Jul 2010 03:45:02 +0000 (20:45 -0700)]
Added ribbon sprites.
Eevee [Thu, 1 Jul 2010 06:04:39 +0000 (23:04 -0700)]
Significantly improved lookup fuzzy matching.
Eevee [Tue, 29 Jun 2010 04:58:08 +0000 (21:58 -0700)]
Fuzzy lookup results were not respecting type limits.
Zhorken [Sun, 4 Jul 2010 18:14:48 +0000 (14:14 -0400)]
Fix a few Japanese Pokémon names.
Taken from a SoulSilver text dump. No other errors.
Not so obvious: Bayleef had a hiragana "be" instead of a katakana "be".
Must have missed it when we noticed herugaa et al had hiragana "he"
instead of katakana.
Eevee [Fri, 18 Jun 2010 04:43:50 +0000 (21:43 -0700)]
Added a big old construct-based pkm parser. #183
Eevee [Sat, 5 Jun 2010 08:02:41 +0000 (01:02 -0700)]
No longer require docutils.
a_magical_me [Thu, 17 Jun 2010 20:05:38 +0000 (13:05 -0700)]
Re-rip G/S/C egg moves.
Level up, TM, and tutor moves have already been ripped, so this should
be the last.
There are no changes (from what we had before) to Crystal, and only a
few additions to Gold/Silver.
Also, just to be safe, i checked that the egg moves in Silver are the
same as in Gold.
Thanks once again to UPC--it's easier to find something when you know
what you're looking for.
Zhorken [Tue, 15 Jun 2010 03:34:23 +0000 (23:34 -0400)]
Er, those were ITEM names. Fix the Pokéblock Case's names.
Zhorken [Tue, 15 Jun 2010 03:13:42 +0000 (23:13 -0400)]
Add foreign names to the database.
Most names as ripped from HeartGold or SoulSilver. Gen-III-only names
ripped from Emerald and de-allcapsed; for French, I also judged where
accents belong on newly-lowercase letters. A couple of them might have
mistakes.
Zhorken [Tue, 8 Jun 2010 00:14:37 +0000 (20:14 -0400)]
Added foreign nature names to the database.
Same as abilities. Japanese as ripped from SoulSilver; French, German,
Italian, and Spanish as ripped from Platinum.
Zhorken [Mon, 7 Jun 2010 20:10:44 +0000 (16:10 -0400)]
Order Pokémon dex numbers by Pokédex ID.
Zhorken [Mon, 7 Jun 2010 19:35:22 +0000 (15:35 -0400)]
Give Pokémon internal IDs their own table and add all gens' IDs.
- Gen I has them all mixed around.
- Gen II has no surprises, but I figured it's good to be thorough.
- Gen III has the first 251 in order, then a big break, then the
third-gen Pokémon mixed around, though families are usually together.
- Gen IV has the 493 in order and then alternate forms after Arceus,
which will be useful to have once Gen V comes and we have to bump
the alt forms in the pokemon table forward.