InvoxiPlayGames
e35e0d090c
Fix SQL injection
2020-07-11 00:26:41 +01:00
Sepalani
8bfc579c37
gs_database: Fixed - Truth Value Testing
2016-02-04 23:25:27 +01:00
payet_s
c849c8afd1
Cleaned: gamespy/gs_database.py
2015-09-05 21:12:43 +02:00
payet_s
2ba6518669
Cleaned: master_server.py, nas_server.py
...
Massive cleanup
Removed: Anoying UTF-8 BOM
2015-09-05 21:01:43 +02:00
payet_s
cc84f739ca
Upgraded: Visual Studio solution
...
Changed: module comment style
2015-09-05 19:17:38 +02:00
kyle95wm
550579ae7b
Console registration
...
I've decided to impliment a new feature into the server (disabled by default in nas_server.py) where when enabled, the server will check if a console's MAC is in BOTH the registered and pending database tables. If this is not the case, one of two error codes will be returned:
error 23888 - Console pending activation by server admin
error 23921 - Unknown console
A registration page was also included on port 9998 for users to enter their MAC and add it to the pending table. The server admin can then log in to the admin page and activate the console if they so please.
2015-07-18 16:39:04 -04:00
Admiral H. Curtiss
c065e3fc19
Properly Insert/Update into gamestats_profile.
2015-05-04 21:51:18 +02:00
Admiral H. Curtiss
7d5951dd01
Change table creation code to IF NOT EXISTS syntax so that newly added tables can auto-create.
2015-05-04 13:53:23 +02:00
Kyle Warwick-Mathieu
4c627bf7ef
Udated gs_database to new ban system standards
2015-05-04 13:53:21 +02:00
Admiral H. Curtiss
798a9238bd
Return error code 23912 when a user is banned. See #138 .
2015-05-02 15:28:24 +02:00
Admiral H. Curtiss
09aecb8bb1
Fixes #136 , I think.
2015-04-24 02:20:26 +02:00
smtddr
cf8a519b17
Fix issue with empty whitelist breaking stuff.
2015-04-18 00:11:05 +00:00
BeanJr
3309bf5225
added whitelisting to admin page and a friend fix
2015-01-23 00:43:31 -05:00
smtddr
7957896573
acctcreate returns next userid
2015-01-18 05:42:43 +00:00
polaris
77b943e8ae
Added method to close sqlite3 connection
2015-01-08 17:07:56 -05:00
polaris-
caa7864b9a
Merge pull request #92 from SMTDDR/onlyadminpage
...
Admin page for banning people.
2014-12-27 20:46:38 -05:00
smtddr
44a553eca5
Admin page
2014-12-28 01:45:52 +00:00
polaris
19c0b6d74c
Modify SQL index queries
2014-10-11 16:32:59 -04:00
polaris
522cd001ba
SMTDDR's gs_database changes
2014-10-11 15:27:54 -04:00
polaris
452ce0ddbd
Check if the account is enabled at login
...
Not used yet, but possibly will be in the future.
2014-08-03 22:40:04 -04:00
polaris
11b8a406d5
Change password check
...
Who cares about security for their login data anyway?
2014-07-22 23:47:26 -04:00
polaris
68d1c39607
Licensing part 2
2014-07-04 20:16:00 -04:00
Admiral H. Curtiss
876689c259
Avoid calling initialize_db() on every database connection, to hopefully improve preformance and log spam.
2014-06-17 20:52:30 +02:00
Admiral H. Curtiss
0481f1ab13
Create some indexes in gpcm.db.
2014-06-01 18:51:18 +02:00
Admiral H. Curtiss
b5cc713a35
Explicit log warning when SQL statement takes long.
2014-05-31 20:58:58 +02:00
Admiral H. Curtiss
2c8f29f551
Cleaner database log output.
2014-05-31 20:42:47 +02:00
Admiral H. Curtiss
ca7d44339d
Refactor GamespyDatabase for easier use and logging.
2014-05-31 20:13:02 +02:00
polaris
0a0e37cc11
Changed console detecting, added more debug code
2014-05-28 15:54:58 -04:00
Admiral H. Curtiss
e7837fbd4d
Match the length of some things to the real server's.
2014-05-27 04:00:39 +02:00
Admiral H. Curtiss
cb2ba136aa
Loginticket is now stored, which allows the storage server to properly process GetMyRecords.
...
Also added a check so an user may only edit his own records, I dunno if
the official server actually enforced this but it makes sense to.
2014-05-24 04:02:52 +02:00
polaris
3a4faf53d4
Turn binary blob into base64
2014-05-20 11:15:59 -04:00
polaris
12367dcf0b
Updated devname field in DB
2014-05-17 15:52:55 -04:00
polaris
0e0d4bebe5
Implement getpd
2014-05-15 14:56:41 -04:00
polaris
751b0066cf
Added more fields to the database
2014-05-14 16:56:03 -04:00
Toad King
23776c1b18
cleanup nintendo_nas_server and implement stub /pr handling
2014-05-03 14:04:19 -04:00
polaris
9c8824ff0c
Modified NAS slightly
...
I was having trouble with the base64 encoded data, so I replaced it with
something that should definitely work.
I also reduced the size of the auth token so there won't be any possible
overflows. Since it's random data it can easily be adjusted in the
future if for some reason it's too small.
2014-04-18 09:19:57 -04:00
polaris
d1ecc4e480
Commented out most of pd_get
2014-04-18 08:11:09 -04:00
Toad King
71111340df
fix nas_logins entries not being reused when possible
2014-04-18 01:59:02 -04:00
Toad King
5ceff7e29f
move NAS server to python, save authentication data in database instead of challenge key
2014-04-18 01:40:50 -04:00
polaris
199cdc835e
Small tweaks part 2
2014-04-17 16:56:27 -04:00
polaris
ec3410c8c2
Small tweaks, nothing major
2014-04-17 16:55:33 -04:00
polaris
98e97ba6d3
Added gamestats server
...
Not everything is implemented but it should be good enough for now.
2014-04-16 22:01:52 -04:00
polaris
6cdf7ea3ae
Updated sql statement
2014-04-15 15:32:25 -04:00
polaris
1de133d779
Started implementing more buddy commands
2014-04-15 15:00:14 -04:00
polaris
acf67b2857
Somehow missed the actual insert code
2014-04-13 13:14:50 -04:00
polaris
bdaaba296a
Store the gameid in the database
...
I wanted to make it easier to do searches in the future based on games,
so the game ids (not region specific, but the generic one that all
regions share) is stored in the datbase now too.
2014-04-12 05:26:36 -04:00
polaris
6b47de9655
Fixed bug #2
...
Exception "variable 'now' referenced before assignment"
2014-04-11 10:31:30 -04:00
polaris
156948f401
Fixed a bug in the update_profile sql query
2014-04-10 19:14:15 -04:00
polaris
d4e65391cf
Updated logging levels
2014-04-10 18:20:40 -04:00
polaris
7f39c5cf66
Log all sqlite commands
2014-04-10 17:35:22 -04:00
