Commit Graph

79 Commits

Author SHA1 Message Date
Greg Edwards
e0740dcd6c Toying with the idea of using a DbParameterFactory to further database engine agnosticism in the project. 2015-02-06 21:20:16 -05:00
Greg Edwards
06a73d96e4 Log trade_id and partner_pid fields for trades. 2015-01-20 18:21:49 -05:00
Greg Edwards
de1f37c914 Methods to load Pokedex from database (untested) 2015-01-03 17:11:19 -05:00
Greg Edwards
5c1d45394e Added more foreign object references in Pokedex classes. 2015-01-02 18:44:11 -05:00
Greg Edwards
f1530f76bb WIP of Pokedex retrieval logic 2015-01-02 18:22:23 -05:00
Greg Edwards
f50e76c15d VeekunImport project inserts form stats. 2014-12-27 03:17:39 -05:00
Greg Edwards
772e3b8609 Added INSERT statements for pokedex. 2014-12-26 00:58:21 -05:00
Greg Edwards
30b820b87f First draft of VeekunImport project. (Database insert commands are nops.) (Also includes some Pokedex types.) 2014-12-08 02:31:47 -05:00
Greg Edwards
d1a628702a Added new overloads to Database.CreateInstance to allow for custom connection strings. 2014-10-14 19:38:00 -04:00
Greg Edwards
9f1dbd0f0f Rename DataAbstract to Database. 2014-10-14 18:50:41 -04:00
Greg Edwards
ab16eb46d3 Implemented battle video saved request type. 2014-09-15 12:50:26 -04:00
Greg Edwards
1f8234cf37 Show number of battle videos in header 2014-09-02 00:27:26 -04:00
Greg Edwards
f3b1b79a42 More ctors to allow for cleaner fake trainer code. 2014-08-18 19:58:32 -04:00
Greg Edwards
7add8ac7d3 Allow the same trainer to appear in different ranks of the same room. (More authentic?) 2014-08-11 19:53:36 -04:00
Greg Edwards
4d2ce62d4a Fixed database regression causing a comm error when you try to take your pokemon out of the GTS. 2014-08-08 03:04:25 -04:00
Greg Edwards
f7374e962d Fixed some stupid battle subway issues. 2014-08-07 19:57:33 -04:00
Greg Edwards
8e072eb06e Store trendy phrases in separate fields. 2014-08-07 18:37:38 -04:00
Greg Edwards
ffbb2d6c10 Store leader phrase in trendy phrase object. 2014-08-07 16:33:48 -04:00
Greg Edwards
c2376eef58 Fixed some battle tower structure offsets. (breaking change) 2014-08-05 00:33:40 -04:00
Greg Edwards
0dc2bec496 aaa 2014-08-03 23:22:22 -04:00
Greg Edwards
5145e2f5e2 Fixes to Battle Subway data schema 2014-08-03 19:15:36 -04:00
Greg Edwards
f770316334 Implemented GenV battle subway data access. 2014-08-02 01:49:52 -04:00
Greg Edwards
9592bcda28 Fixed logic error causing numbering gaps and odd trainer ordering in battle tower. 2014-08-01 18:15:17 -04:00
Greg Edwards
7a4c4644c8 GenV battle subway structures 2014-08-01 17:14:02 -04:00
Greg Edwards
81bcc14ed3 This should be a correct implementation of Gen4 Battle Tower but it makes the game hang for some reason. 2014-07-30 15:42:50 -04:00
Greg Edwards
533791443f Fixed trendy phrase getting overwritten with "System" in ASCII in the database. 2014-07-29 19:09:19 -04:00
Greg Edwards
32a1c4ab57 Fixed a lot of bugs with battle tower data logic. 2014-07-28 20:08:51 -04:00
Greg Edwards
4974500015 Implemented some more battle tower database work. 2014-07-28 18:06:17 -04:00
Greg Edwards
a91d861c67 Implemented some battle tower database work. 2014-07-27 01:57:04 -04:00
Greg Edwards
30085bb4a1 Fixed GTServer showing 0 for every upload ID in logs. 2014-07-22 16:59:21 -04:00
Greg Edwards
4198aace33 For fuck's sake mysql
Workaround LAST_INSERT_ID and CAST limitations by making all primary keys unsigned bigint.
Workaround LAST_INSERT_ID signed/unsigned inconsistency between 5.5 and 5.6 by using Convert.ToUInt64 instead of casts.
2014-07-22 12:04:31 -04:00
Greg Edwards
29d0d6b31b Timestamp trainer profiles 2014-07-17 11:51:51 -04:00
Greg Edwards
008c7a0f6a Save setProfile.asp profiles to the database. 2014-07-16 23:57:24 -04:00
Greg Edwards
bae6404d9a Log completed trades. 2014-07-16 01:02:20 -04:00
Greg Edwards
10c0b32c6c Changed TimeWithdrawn column name to TimeExchanged. 2014-07-15 20:40:36 -04:00
Greg Edwards
cc14cbc6d2 Added column to track the number of times a battle video is watched. 2014-07-14 19:47:53 -04:00
Greg Edwards
9fc5459c66 Added some extra validation to the _finish.asp series of requests. 2014-07-14 12:58:10 -04:00
Greg Edwards
b27414fe75 Implemented top Colosseum / Battle Frontier battle video search on GenIV. 2014-07-10 22:52:33 -04:00
Greg Edwards
170cd55e77 Battle video search improvements 2014-07-10 00:52:02 -04:00
Greg Edwards
dd13c270b3 Fixed some issues with the GenV Global Terminal while testing. 2014-07-09 22:18:29 -04:00
Greg Edwards
a8d8c60d7a Implemented battle video server on GenV. (to test) 2014-07-09 11:39:07 -04:00
Greg Edwards
70ed7b904f Expanded some enums. 2014-07-07 11:53:55 -04:00
Greg Edwards
593dd13cd6 Fixed inserting to the wrong table. 2014-07-06 18:53:54 -04:00
Greg Edwards
8797b57e1a Implemented musical search. 2014-07-06 18:33:22 -04:00
Greg Edwards
8b69ba21a9 Implemented GenV Musical upload. (untested) 2014-07-06 18:24:55 -04:00
Greg Edwards
c23ea3e153 mysql is an idiot.
Workaround InvalidCastException happening because the connector returns a signed type for an unsigned column.
2014-07-05 02:03:59 -04:00
Greg Edwards
f7e06a5b51 Fixed Colosseum searches returning 0 results. 2014-07-01 18:49:23 -04:00
Greg Edwards
683b18a27a Fixed issues with battle video server I found after testing. 2014-07-01 18:09:36 -04:00
Greg Edwards
5b775ed32b Probably implemented battle videos server on Generation IV. 2014-06-30 02:17:13 -04:00
Greg Edwards
92d831abaf Mysql's type validation sucks.
(Fixed GenV trainer name string getting inserted as text instead of binary.)
2014-06-27 23:14:59 -04:00