Commit Graph

1041 Commits

Author SHA1 Message Date
Andrew Ekstedt 4cd091241e Whoosh 2.5 performance quickfix
In Whoosh 2.5, fields that can be sorted on need to specify
sortable=True or else take a performance hit (a large one, in our case).

These probably don't all need to be sortable, but hey.
2014-03-13 00:31:53 -07:00
Andrew Ekstedt 9e3bfd7971 Use Unicode(256) for names and identifiers.
MySQL requires that text columns that are indexed or used as keys be
given a maximum length.

256 bytes should be enough for anyone.
2014-03-13 00:29:49 -07:00
Lynn "Zhorken" Vaughan 7462c0fc1b Put short_effect before effect in ability_prose.
This way it matches /all the other prose tables/.  Relatedly, all the
abilities I recently expanded on had short_effect and effect swapped,
so I fixed that too.
2014-03-12 12:18:37 -04:00
Lynn "Zhorken" Vaughan 2632454829 Set form_name=pokemon_name for Mega Evolutions. 2014-03-12 11:17:05 -04:00
Lynn "Zhorken" Vaughan 3fe999db89 Add a dummy pokemon_form_names row for Diancie.
Apparently PokemonForm.name requires this row, so the tests weren't
passing. 9_6
2014-03-11 20:36:06 -04:00
Lynn "Zhorken" Vaughan efa41be984 Fix a typo in a move flag description so the tests pass again. 2014-03-11 20:23:02 -04:00
Lynn "Zhorken" Vaughan 308f5f4ed9 Use UnicodeText for all text columns. 2014-03-11 20:15:16 -04:00
Lynn "Zhorken" Vaughan d344e8b5f0 Strip some trailing whitespace in X/Y flavour text. 2014-03-11 18:31:41 -04:00
Lynn "Zhorken" Vaughan d74b55fbad Add zero-width space to Thick Fat's flavour text as needed. 2014-03-11 18:22:51 -04:00
Lynn "Zhorken" Vaughan cb1523e296 Add everything remaining from the spreadsheet. 2014-03-11 18:20:41 -04:00
Lynn "Zhorken" Vaughan df449280b7 Add a separate fucking language for kanji. 2014-03-11 16:49:08 -04:00
Lynn "Zhorken" Vaughan 5770a3ea7d Add Spanish and Italian Pokémon names.
We decided a while back to just give up and include these separately,
even though they're really just the English names.  Now I actually need
them, because genus.
2014-03-11 16:14:59 -04:00
Lynn "Zhorken" Vaughan 5625b8274d Add national dex #, dex entries, name for Diancie. 2014-03-10 16:13:47 -04:00
Lynn "Zhorken" Vaughan 7cd9f36e24 Improve effects for new moves and abilities a little. 2014-03-09 20:53:53 -04:00
Lynn "Zhorken" Vaughan 8edb9329dc Add Diancie to the Undiscovered egg group. 2014-03-07 12:32:32 -05:00
Lynn "Zhorken" Vaughan 4b11c70231 Fix Diamond Storm's type. 2014-03-07 12:32:22 -05:00
Lynn "Zhorken" Vaughan d91a2e5e13 Sync moves with Showdown. #116 2014-03-07 12:28:12 -05:00
Lynn "Zhorken" Vaughan 21fd51bb0b Add Hold Back and Diamond Storm. 2014-03-07 11:18:14 -05:00
Lynn "Zhorken" Vaughan f71e1521a9 Load/dump dance. 2014-03-07 11:18:14 -05:00
Lynn "Zhorken" Vaughan 9cb44f56e5 Add Diancie. 2014-03-07 11:18:03 -05:00
Lynn "Zhorken" Vaughan b8630cb076 Correct the descriptions for the Razor Claw and Razor Fang. 2014-03-04 13:50:19 -05:00
Lynn "Zhorken" Vaughan 5ddbee886f Update the docstring on rewrite_long_table_names. 2014-02-21 17:59:52 -05:00
Lynn "Zhorken" Vaughan 0c8aadc53c Merge branch 'oracle'. #109 2014-02-21 17:51:46 -05:00
Lynn "Zhorken" Vaughan f54a4caaca General code tidying for this Oracle fix. 2014-02-21 17:48:19 -05:00
Lynn "Zhorken" Vaughan 5b759feaa2 Sort out all the non-nullable columns with empty values. 2014-02-21 17:48:19 -05:00
Epithumia 7b2743be75 Dynamically mangle long table names for Oracle; Unicode → UnicodeText. 2014-02-21 17:47:55 -05:00
Lynn Vaughan 80838793d5 Merge pull request #100 from valepert/patch-3
Merge valepert's Italian names for B/W 2 items. #100
2014-02-06 15:33:10 -05:00
Lynn "Zhorken" Vaughan a9bce8f5a3 Add ability changes for Feebas, Milotic, and Zapdos. 2014-01-06 13:12:43 -05:00
Lynn "Zhorken" Vaughan 61b5032519 Put the hyphen back in Lock-On's name.
Showdown's data files said "Lock On" in a bunch of places, so I assumed
it had changed.  I was wrong!  Oops.  Thanks to Chispy for confirming
that it hadn't.
2014-01-04 08:07:02 -05:00
Lynn "Zhorken" Vaughan 3fbe98c93a Sync move stats with Showdown. 2014-01-03 20:24:18 -05:00
Lynn "Zhorken" Vaughan 0ad40dee14 Sync Pokémon moves with Showdown. 2014-01-03 20:00:47 -05:00
Lynn "Zhorken" Vaughan befea028ca Correct Japanese names for a few Kalos Pokémon.
I double-checked against http://wiki.ポケモン.com/wiki/ポケモン一覧 .
(Apologies for the likely-unclickable URL but it was really really long
otherwise.)

Flabébé was using hiragana べ instead of katakana ベ.  Those were the
only hiragana in the csv.
2013-12-20 20:28:06 -05:00
Lynn "Zhorken" Vaughan bf2c79879d Add Happy Hour and Celebrate. 2013-12-11 14:20:14 -05:00
Lynn "Zhorken" Vaughan fb06d85e1e Keldeo can switch forms. 2013-12-05 16:41:22 -05:00
Lynn "Zhorken" Vaughan 199feadce6 Fix a typo in Combusken's X entry. 2013-12-02 22:49:23 -05:00
Lynn "Zhorken" Vaughan 489b0dca9b Add all the remaining heights and weights.
I got these all from pokemonxy.com, along with most of the last batch.
I'll double-check them in-game when I can.
2013-11-23 10:14:28 -05:00
Lynn "Zhorken" Vaughan 5bba8d9ca9 Remove flags for nonexistent moves. 2013-11-23 09:42:09 -05:00
Lynn "Zhorken" Vaughan 79acc09c4f Correct Eerie Impulse's effect. 2013-11-23 09:30:40 -05:00
surskitty b9b39b0baa Actually add abilities ignored by role play this time. 2013-11-22 10:44:16 -05:00
surskitty e3f2f4006f Add abilities ignored by role play. 2013-11-22 10:41:48 -05:00
surskitty bfbd41c29e Update a few moves for XY. 2013-11-21 21:56:54 -05:00
surskitty 20e211fac6 Correct powder move flag to include overcoat. 2013-11-21 21:56:15 -05:00
surskitty 525bbfc971 Fix errors with Draining Kiss and Mat Block flags. 2013-11-21 20:54:22 -05:00
surskitty 7b3016618c Preliminary flags for new moves. 2013-11-21 20:31:18 -05:00
surskitty 1a6b68ab1f Add new flags to old moves. 2013-11-21 20:30:32 -05:00
surskitty 92f75858c7 Add new flags (powder, pulse, ballistics, bite, mental) 2013-11-21 20:15:23 -05:00
Andrew Ekstedt d51fe2d834 Merge pull request #104 from LouieGeetoo/patch-1
Fix Big Pecks ability description
2013-11-17 13:16:57 -08:00
John Pray c80e35bae7 Fix Big Pecks ability description
Fix typo of "Attack" to "Defense"
2013-11-17 14:24:03 -05:00
Lynn "Zhorken" Vaughan cfb19162ea Correct Magician too (thx daikonpan). 2013-11-17 11:22:37 -05:00
Lynn "Zhorken" Vaughan 53e4c063ba A handful of move/ability corrections (thx Bachuru). 2013-11-17 11:12:16 -05:00