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