Eevee [Thu, 27 May 2010 18:12:49 +0000 (11:12 -0700)]
Bump required SQLA to 0.6.
Eevee [Thu, 27 May 2010 04:58:18 +0000 (21:58 -0700)]
Link stats to damage classes.
Eevee [Wed, 26 May 2010 05:40:30 +0000 (22:40 -0700)]
Blindly throw some more indexes on pokemon_moves.
Zhorken [Tue, 1 Jun 2010 17:20:25 +0000 (13:20 -0400)]
Fix remakes' titles, e.g. "Fire Red" to "FireRed". #196
Like I said, it is a bit funny-lookin', but it's correct.
Zhorken [Tue, 1 Jun 2010 06:17:58 +0000 (02:17 -0400)]
Strip gamma and ICC profiles from a few sprites.
The gamma here likely represents the monitor someone was using when they
saved the sprite, and not anything useful. ICC profiles are huge.
Zhorken [Mon, 31 May 2010 21:55:57 +0000 (17:55 -0400)]
Change some hyphens to shy hyphens in flavour text.
Gen III and IV only seem to shy-hyphenate compound words; I determined
whether or not to use a shy hyphen by looking at other instances of the
word. If it's consistently not hyphenated or just hyphenated on a line
break, I figure they mean for it to be a compound word, e.g.
"kindhearted" rather than "kind-hearted".
"Supereffective" is weird, but they seem to consistently spell it as all
one word when it's an attributive adjective, only ever hyphenating it on
a line break and only spacing it as a predicative adjective. So I
counted it as a compound word in the flavour text for Filter and Solid
Rock.
Zhorken [Mon, 31 May 2010 16:49:56 +0000 (12:49 -0400)]
Fix the rendering of some suspended hyphens.
"Fire-\nand Ice-type" should be displayed "Fire- and Ice-type", but the
flavour text rendering can't tell that it's not "Fire-and". Added zero-
width spaces to invisibly separate these hyphens from the newlines,
preventing them from being interpreted as hyphenated words split over
two lines.
Zhorken [Fri, 28 May 2010 22:27:02 +0000 (18:27 -0400)]
Optimize item sprites with OptiPNG.
I only meant for this to go over the new sprites, but apparently a
bunch of them weren't optimized.
Zhorken [Fri, 28 May 2010 22:25:55 +0000 (18:25 -0400)]
Add missing item sprites.
Snagged them from Bulbapedia. I don't care enough to figure out how to
rerip them right now.
Zhorken [Thu, 27 May 2010 06:12:27 +0000 (02:12 -0400)]
Fix a few Gen III items' sprites' filenames.
Still missing:
- Rm. 1/2/4 Key (slightly different from Rm. 6 Key's icon!)
- Old Sea Chart (Emerald only)
- Magma Emblem (Emerald only)
Zhorken [Thu, 27 May 2010 05:42:33 +0000 (01:42 -0400)]
Add Gen III and DPPt item flavour text.
Zhorken [Thu, 27 May 2010 03:56:59 +0000 (23:56 -0400)]
Add Gen III items and internal IDs to the database.
Items with the same name are considered the same. So, for example,
Storage Key is all one item, even though there are multiple storage keys
named "Storage Key" across the generations. As far as I know, this only
ever affects miscellaneous keys.
The Itemfinder is considered the same item as the Dowsing MCHN. They
have the same Japanese name and do the same thing; as far as I'm
concerned, the name change is just another data change.
I wrote effects for the newly-added items very quickly. They aren't
very good. I'm leaving it up to whoever takes care of issue #247 to
write good ones.
Zhorken [Wed, 26 May 2010 19:52:23 +0000 (15:52 -0400)]
Correct the happiness evolution threshold.
Tested by messing about with Pokésav. 200 doesn't work; 219 doesn't
work; 220 works.
Zhorken [Wed, 26 May 2010 18:46:01 +0000 (14:46 -0400)]
Update the form group description column. #210
I meant to include this in the last commit. Whoops.
Rotom's description is *really long*, so I needed to bump the length up
to fit it. Also changed it to an RstTextColumn.
Zhorken [Wed, 26 May 2010 18:29:33 +0000 (14:29 -0400)]
Rewrote Pokémon form group descriptions.
They now use our modified reST to link a few things like "Gracidea",
mention HG/SS where applicable, and are much more correct in general.
I might have missed some odd thing, and there are still a couple of
stylistic issues. Rotom's description is really long, for example, and
I'm not sure what to do about that; all of it seems fairly important.
Zhorken [Tue, 25 May 2010 21:07:05 +0000 (17:07 -0400)]
Add foreign ability names to the database.
This adds Japanese, French, German, Spanish, and Italian names, as
ripped from SoulSilver (Japanese) or Platinum (everything else).
This also fixes a couple of backrefs.
a_magical_me [Sun, 25 Apr 2010 07:14:29 +0000 (00:14 -0700)]
Python 2.5 compatibility
Eevee [Tue, 25 May 2010 07:09:29 +0000 (00:09 -0700)]
Pokemon.evolution_* => Pokemon.*_pokemon
Eevee [Tue, 25 May 2010 07:00:56 +0000 (00:00 -0700)]
Fix a many-to-many join bug with evolutions.
Eevee [Tue, 25 May 2010 04:31:14 +0000 (21:31 -0700)]
Removed evolution_methods table. #42
Eevee [Tue, 25 May 2010 04:29:04 +0000 (21:29 -0700)]
Overhauled evolution. #42
Zhorken [Thu, 20 May 2010 00:55:16 +0000 (20:55 -0400)]
(Re)ripped move flavour text for Gen II-IV. #171
Gen II move flavour sometimes has shy hyphens; these, like in the
Pokémon flavour text, are represented by U+00AD SHY HYPHEN even though
the Unicode standard specifies that it be used to mark where a shy
hyphen *could* go rather than where one was placed. (Supposedly, at
least; I haven't read it for myself.)
Zhorken [Thu, 20 May 2010 00:49:48 +0000 (20:49 -0400)]
Link move flavour text to version groups. #169
Zhorken [Wed, 19 May 2010 23:10:31 +0000 (19:10 -0400)]
Fix the PBR terrain tables.
I am an idiot and pushed too soon. >:(
Also, the "In Pokémon Battle Revolution:" label is too close to the
table above it, but that's a CSS issue.
Zhorken [Wed, 19 May 2010 23:01:53 +0000 (19:01 -0400)]
Split off and labelled the PBR terrains for Secret Power and Nature Power.
Zhorken [Wed, 19 May 2010 23:01:02 +0000 (19:01 -0400)]
Fixed some stylistic issues with ability effects.
Zhorken [Wed, 19 May 2010 17:58:10 +0000 (13:58 -0400)]
Flipped Crystal animations as a temporary fix.
Zhorken [Wed, 19 May 2010 03:37:27 +0000 (23:37 -0400)]
(Re)ripped GSC sprites, sans animations. #197 #102
We now have backsprites and still-frame sprites for Crystal. I'm
considering the still-frame sprites to be the canon ones to match
Emerald; the current (backwards) animated ones have been moved to
animated/. We also now have separate backsprites for Silver even
though they're the same as Gold. Crystal's do sometimes differ.
Turns out the sprites are actually all different sizes, too; it's
just that nobody can tell in-game, since the game places them all
in the same frame. (Actually, I think it might bottom-align them
in battle and center them in the Pokédex or something; not sure.)
The backsprites are all the same size, but it's not the same size
as the ones we had before. Either way, I think it's more correct
not to pad the sprites to a uniform size, in-game display aside.
I converted my script's PPM output to PNG with OptiPNG. It seems
to have rounded the five-bit-per-channel colors to fit eight bits
per channel, which I like. (Rather than flooring or something?)
Zhorken [Tue, 11 May 2010 06:00:39 +0000 (02:00 -0400)]
Specify which Gen IV evolutions are in the HG/SS Johto dex.
Most of them aren't; they just added the move-based evolutions because
they can't really keep those away from you until the National dex.
Eevee [Fri, 14 May 2010 01:06:50 +0000 (18:06 -0700)]
Make setup.py install work with package_data.
The CSVs are now the only package data. Otherwise, setuptools would
copy every single sprite individually to the standard library directory,
which is slow and time-consuming and wasteful. If you need the sprites,
use them from the repo. :(
a_magical_me [Thu, 13 May 2010 17:33:07 +0000 (10:33 -0700)]
Factor out logic for finding the default db/index. #180
Note: `if not x:` has changed to `if x is not None:`, changing the
semantics slightly. Shouldn't be a big issue.
Eevee [Thu, 13 May 2010 06:23:05 +0000 (23:23 -0700)]
Make plumbing respect the same env vars as the CLI. #180
Eevee [Thu, 13 May 2010 06:18:02 +0000 (23:18 -0700)]
Make `pokedex status` a bit more useful. #180
Eevee [Thu, 13 May 2010 05:36:12 +0000 (22:36 -0700)]
Split PokedexLookup(recreate=True) into its own method. #216
Eevee [Wed, 12 May 2010 03:20:33 +0000 (20:20 -0700)]
Added some missing item icons and fixed TMs/Data Cards. #248
Eevee [Tue, 11 May 2010 05:39:34 +0000 (22:39 -0700)]
Photo Album icon. #248
Eevee [Tue, 11 May 2010 02:04:49 +0000 (19:04 -0700)]
s/Pokemon/Pokémon/g #45
Eevee [Mon, 10 May 2010 04:21:59 +0000 (21:21 -0700)]
Unique Pokédex names.
Eevee [Sun, 9 May 2010 05:39:06 +0000 (22:39 -0700)]
Pokemon.types should order by slot. #220
Eevee [Fri, 7 May 2010 04:19:55 +0000 (21:19 -0700)]
Fix ordering of Pokémon abilities. #257
a_magical_me [Fri, 7 May 2010 07:30:55 +0000 (00:30 -0700)]
Munge SGB colors. Add GBC colors. #245
Firstly: it was discovered (or rather, noticed) that the sprites in
Green have a greenish background (technically, first palette entry)
rather than a reddish one.
1. To properly represent this difference between Red and Green, we would
have to give Green its own directory. This is silly, considering
that the sprites are identical in every other respect.
2. The background is not something inherent to the sprites, but a tint
which pervades the different versions of the game: Red is red, Green
is green, and Yellow is yellow. (Blue is red, not blue. Don't ask
me why.)
For these reasons, the Gen I sprites have had their background changed
to white. (The red background was ugly anyway.)
Secondly: Yellow has an additional set of palettes, which it uses when
played on a Gameboy Color. Sprites colored with these palettes have
been added to media/yellow/gbc and media/yellow/back/gbc.
It was suggested that the GBC-paletted sprites should be considered the
"main" ones; the argument being that the GBC is more canon (because it
is the platform most people would have played on).
I have kept the SGB-paletted sprites as the main ones, for the following
reasons:
1. By the above argument, the *grayscale* sprites should be considered
the main ones for Red & Green & Blue, since that is how they would
appear on a Gameboy.
2. The SGB colors go better with the colors we have for Red & Green &
Blue. (They should--they were designed to.)
Eevee [Thu, 6 May 2010 05:36:04 +0000 (22:36 -0700)]
Optipnged some version icons.
Eevee [Thu, 6 May 2010 05:35:52 +0000 (22:35 -0700)]
Added R/G version icons. #212
Eevee [Thu, 6 May 2010 04:35:06 +0000 (21:35 -0700)]
Fixed small problems with D/P font.
Zhorken [Tue, 4 May 2010 06:06:49 +0000 (02:06 -0400)]
Corrected a couple of French Pokémon names.
I compared with a rip from a Mystery Dungeon game. These are the only
two that didn't match, ignoring accents on capital letters. I need to
find an official list of names that includes accents on capital
letters....
Zhorken [Tue, 4 May 2010 06:03:01 +0000 (02:03 -0400)]
Added ability flavour text. #62
We had D/P flavour text in the abilities table already, but I didn't
entirely trust it, so I reripped it along with the rest when I moved
flavour text into its own table. And we didn't actually use the D/P
text anywhere, so I'm just going to pretend that it is entirely new.
Zhorken [Tue, 4 May 2010 06:01:34 +0000 (02:01 -0400)]
Added ability effects. Rewrote short effects. #39
Zhorken [Sat, 1 May 2010 21:35:11 +0000 (17:35 -0400)]
Removed "No Ability" from abilities.
B|
Zhorken [Sat, 1 May 2010 21:33:11 +0000 (17:33 -0400)]
Added abilities' generations to the database.
Eevee [Mon, 3 May 2010 08:00:05 +0000 (01:00 -0700)]
Added GrowthRate.max_experience.
Eevee [Sun, 2 May 2010 23:07:45 +0000 (16:07 -0700)]
Restored Item.appears_underground and added location support to rst.
Eevee [Sun, 2 May 2010 22:40:54 +0000 (15:40 -0700)]
Broke existing item flags out into their own table.
Eevee [Sun, 2 May 2010 08:33:44 +0000 (01:33 -0700)]
Added item HG/SS flavor text and internal ids. #168?
Eevee [Sun, 2 May 2010 06:49:34 +0000 (23:49 -0700)]
Added some HG/SS item data. #168
a_magical_me [Sun, 2 May 2010 07:54:08 +0000 (00:54 -0700)]
Ripped Gen I Pokémon sprites. #245
The previous sprites were backwards, were too large, and had alignment
issues. (Because they were made by cropping screenshots.)
This commit replaces the old, busted sprites with sprites ripped
directly from the ROM. It also adds grayscale sprites.
Thanks to Peter O. (of UPC) and RHWiki for documenting the sprite
compression algorithm.
http://www.upokecenter.com/projects/rbgfx.c
http://www.magicstone.de/rhwiki/article/Grafikkomprimierung_PKMN_RGBY
Some notes:
- The media/jp-blue directory has been renamed to media/red-green.
- The grayscale sprites are found in the "gray" subdirectories. For
example, media/red-blue/back/gray/1.png.
- Frontsprites are 40x40, 48x48, and 56x56. Backsprites are 32x32.
The game blows backsprites up to 64x64 when it displays them. The
previous sprites were all 60x60.
- The sprite colors come from a Super Gameboy extension which allowed
Gameboy games (which are normally grayscale) to display colors.
- The Red, Blue, and Green sprites have a pinkish, off-white background
rather than a white one. This is correct. The background of the
Yellow sprites is off-white too, but not as noticable.
Eevee [Fri, 30 Apr 2010 07:22:03 +0000 (00:22 -0700)]
Lookup now respects "ability" as a lookup type.
Eevee [Wed, 28 Apr 2010 17:26:27 +0000 (10:26 -0700)]
Let lookup accept hex/octal/binary numbers.
Zhorken [Wed, 28 Apr 2010 07:59:04 +0000 (03:59 -0400)]
Merge branch 'master' of git@veekun.com:pokedex
Zhorken [Wed, 28 Apr 2010 06:52:46 +0000 (02:52 -0400)]
Reripped Gen I–III Pokémon flavour text. #46
Page breaks are represented by form feeds and soft hyphens are
represented by soft hyphens, even though the Unicode standard's idea of
a soft hyphen is different from what we mean here.
My ripping scripts are at http://github.com/Zhorken/pokemon-flavour
Zhorken [Wed, 28 Apr 2010 06:52:46 +0000 (02:52 -0400)]
Reripped Gen I–III Pokémon flavour text.
Page breaks are represented by form feeds and soft hyphens are
represented by soft hyphens, even though the Unicode standard's idea of
a soft hyphen is different from what we mean here.
My ripping scripts are at http://github.com/Zhorken/pokemon-flavour
a_magical_me [Mon, 26 Apr 2010 11:27:55 +0000 (04:27 -0700)]
Add experience tables.
Eevee [Tue, 27 Apr 2010 06:26:37 +0000 (23:26 -0700)]
Jammed in a bunch of nature stuff.
Eevee [Tue, 27 Apr 2010 04:48:44 +0000 (21:48 -0700)]
Turned Move.contest_type into a foreign key.
Eevee [Tue, 27 Apr 2010 04:48:32 +0000 (21:48 -0700)]
Shuffled item categories.
Eevee [Tue, 27 Apr 2010 04:13:38 +0000 (21:13 -0700)]
Added bag pocket icons.
Eevee [Tue, 27 Apr 2010 04:13:28 +0000 (21:13 -0700)]
Item tidying; fixed missing és, added ItemPocket.identifier.
Eevee [Mon, 26 Apr 2010 06:23:52 +0000 (23:23 -0700)]
At last, imported item and berry data. #10
Eevee [Sat, 24 Apr 2010 22:37:55 +0000 (15:37 -0700)]
Use fnmatch for filenameish glob parsing.
Eevee [Sat, 24 Apr 2010 21:16:16 +0000 (14:16 -0700)]
Tiny fix for CLI help.
Eevee [Sat, 24 Apr 2010 21:06:32 +0000 (14:06 -0700)]
Loading big tables now shows a progress indicator. #180
Eevee [Sat, 24 Apr 2010 21:04:15 +0000 (14:04 -0700)]
Overhauled CLI. #180
- Everything now accepts -i, -e, -q, and -v.
- Plumbing commands now announce what database/index they're using and
where they got them from.
- New command status, which does nothing but still does the announcing.
- New command reindex, which recreates only the whoosh index.
Eevee [Thu, 22 Apr 2010 18:56:15 +0000 (11:56 -0700)]
Oops; Rash had its stats backwards.
Eevee [Tue, 20 Apr 2010 01:16:02 +0000 (18:16 -0700)]
Fixed some location names. #167
Zhorken [Sat, 24 Apr 2010 07:01:42 +0000 (03:01 -0400)]
Merge branch 'master' of git@veekun.com:pokedex
Zhorken [Fri, 23 Apr 2010 04:45:21 +0000 (00:45 -0400)]
Fixed references to "U-Turn" to "U-turn".
There were no references to Conversion 2 or Roar of Time.
a_magical_me [Wed, 21 Apr 2010 06:26:12 +0000 (23:26 -0700)]
Fix location_area_encounter_rates
- encounter_type_id -> encounter_terrain_id
- Added a version_id column. Previous rates were from Diamond and
HeartGold; these have been copied to Pearl & Platinum and SoulSilver,
respectively, which i assume is accurate. RBY rates need to be added.
Zhorken [Wed, 21 Apr 2010 04:45:09 +0000 (00:45 -0400)]
Added missing R/B internal IDs.
Zhorken [Tue, 20 Apr 2010 19:17:37 +0000 (15:17 -0400)]
Fixed "Roar Of Time" to "Roar of Time", too.
Shouldn't be so push-happy, I suppose.
Zhorken [Tue, 20 Apr 2010 18:54:05 +0000 (14:54 -0400)]
Fixed Conversion 2 and U-turn's names.
Based on a Platinum text dump; I'm pretty sure Conversion2 was all one
word at some point.
Interestingly, the use messages for U-turn all read "___________ used
U-Turn!", but it's "U-turn" as the actual move name.
Eevee [Mon, 19 Apr 2010 07:33:09 +0000 (00:33 -0700)]
Refactored valid-type handling in lookup.
- User-specified types are now merged with code-enforced ones, rather
than being blindly clobbered.
- Prefix lookup now supports type prefixes.
Eevee [Mon, 19 Apr 2010 06:37:53 +0000 (23:37 -0700)]
Fixed description for one-Pokémon targeting, and effect for Me First. #135
Eevee [Mon, 19 Apr 2010 06:11:52 +0000 (23:11 -0700)]
Fixed some missing colons in ":mechanic:". #185
Eevee [Mon, 19 Apr 2010 05:43:33 +0000 (22:43 -0700)]
Support natures in lookup.
Eevee [Sat, 17 Apr 2010 09:12:27 +0000 (02:12 -0700)]
Fixed the hell out of the capture rate formula. #150
- Wobbles are based on WHICH number is greater than some pivot, not how
many. This was making everything totally wrong, especially 0 wobbles.
- HG/SS balls all modify capture rate, rather than ball bonus.
- Everything really is integer math; even the sqrts. Bonuses are
relative to 10, not 1. HP is now treated as integer math, too.
- Implemented a minor game bug with very hard to catch Pokémon.
Eevee [Sat, 17 Apr 2010 05:45:44 +0000 (22:45 -0700)]
Added pokedex.savefile, which can encrypt/decrypt Pokémon save structs.
Eevee [Sat, 17 Apr 2010 00:49:22 +0000 (17:49 -0700)]
Made Encore effect a bit more accurate.
Eevee [Fri, 16 Apr 2010 04:22:06 +0000 (21:22 -0700)]
Sunflora can be tutored Earth Power in HG/SS. #149
Eevee [Fri, 16 Apr 2010 04:16:05 +0000 (21:16 -0700)]
Once and for all, fixed Pt tutor moves. #126
Eevee [Fri, 16 Apr 2010 03:05:31 +0000 (20:05 -0700)]
roomaji.py now handles "wu xe" and "shi xi" correctly. #132
Eevee [Fri, 16 Apr 2010 03:05:03 +0000 (20:05 -0700)]
Added Pokemon.stat() accessor.
Eevee [Tue, 30 Mar 2010 03:22:57 +0000 (20:22 -0700)]
Added canonical_pokedex, Pokedex.region, and some Pokédex descriptions.
a_magical_me [Tue, 13 Apr 2010 06:11:48 +0000 (23:11 -0700)]
Fix HGSS fishing encounter slot rarities.
<http://www.smogon.com/forums/showpost.php?p=2564048&postcount=215>
mingot has found the correct slot rarities for HGSS fishing encounters.
They are 40/30/15/10/5 for all rods. Surfing is the same as in DPPt.
a_magical_me [Thu, 18 Mar 2010 04:31:07 +0000 (21:31 -0700)]
Fix RBY grass/water encounter slot rarities.
<http://tasvideos.org/PokemonTricks.html>
This page explains how the RNG in RBY works, and gives exact rarities.
They are out of 256 rather than 100, so some rounding is necessary to
fit them into the database.
==== ======= ====== ========== =======
Slot Range Chance Percentage Rounded
==== ======= ====== ========== =======
0 0-50 51/256 19.921875% 20%
1 51-101 51/256 19.921875% 20%
2 102-140 39/256 15.234375% 15%
3 141-165 25/256 9.765625% 10%
4 166-190 25/256 9.765625% 10%
5 191-215 25/256 9.765625% 10%
6 216-228 13/256 5.078125% 5%
7 229-241 13/256 5.078125% 5%
8 242-252 11/256 4.296875% 4%
9 253-255 3/256 1.171875% 1%
==== ======= ====== ========== =======
a_magical_me [Tue, 16 Mar 2010 09:45:25 +0000 (02:45 -0700)]
Add slot index to encounter_slots
Zhorken [Tue, 13 Apr 2010 03:34:12 +0000 (23:34 -0400)]
Fixed some misspelled German Pokémon names. #140
Eevee [Mon, 29 Mar 2010 05:14:27 +0000 (22:14 -0700)]
Fixed lookup tests to, um, run.
Eevee [Sun, 28 Mar 2010 02:47:36 +0000 (19:47 -0700)]
Remove absolute HP from the capture chance formula.
Eevee [Sat, 27 Mar 2010 23:12:51 +0000 (16:12 -0700)]
Roar and Whirlwind cancel Wish.
Eevee [Sat, 27 Mar 2010 05:18:19 +0000 (22:18 -0700)]
Nope, shake formula dun use integers.
Eevee [Thu, 25 Mar 2010 15:39:48 +0000 (08:39 -0700)]
Why am I importing sqlalchemy.databases.mysql...?