87 Commits

Author SHA1 Message Date
InvoxiPlayGames
e35e0d090c Fix SQL injection 2020-07-11 00:26:41 +01:00
Admiral H. Curtiss
9e84456bc2 Merge pull request #315 from sepalani/gs_query
Cleaned: gamespy/gs_query.py
2016-08-01 00:34:03 +02:00
Sepalani
f77afa38eb create_gamespy_message refactored 2016-07-24 16:46:58 +04:00
Sepalani
78d5624869 Cleaned: gamespy/gs_query.py 2016-07-24 15:01:35 +04:00
Sepalani
badcbdf9b4 Gamestats: Handles data with nul bytes in getpdr
Query: Accepts tuple w/ a single element as raw data
2016-07-16 19:15:34 +04:00
Sepalani
8bfc579c37 gs_database: Fixed - Truth Value Testing 2016-02-04 23:25:27 +01:00
Sepalani
35c253dc09 Fixed: Not found or invalid authtoken 2015-09-05 21:15:31 +02:00
payet_s
c849c8afd1 Cleaned: gamespy/gs_database.py 2015-09-05 21:12:43 +02:00
payet_s
9066a5f1e5 Cleaned: gamespy/gs_query.py 2015-09-05 21:01:44 +02:00
payet_s
73202b080c Cleaned: gamespy/gs_utility.py 2015-09-05 21:01:44 +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
a9ea32368f Revert "Bug fixes from SMTDDR"
This reverts commit 083a45367d.
2014-09-21 17:51:50 -04:00
polaris
083a45367d Bug fixes from SMTDDR 2014-09-11 06:30:29 -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
sepalani
1378efad94 Update gs_utility.py, broken b64decode
Afaik, this conversion should be done like that.
2014-07-25 07:28:40 +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
827f8d83a0 Fixed invalid filter error
If the first server in the server list does not have all of the
requested fields, it would assume that all of the servers lacked the
requested fields, so it would bail. This will let it keep checking
against ever server and skip the ones without the requested fields.
2014-07-22 23:00:10 -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
9882da3af3 Combine user login in profile and gamestats. 2014-06-17 19:45:19 +02:00
Admiral H. Curtiss
72a5f99b1d Should fix #40 and similar errors with extra backslashes. 2014-06-15 06:46:50 +02:00
Admiral H. Curtiss
0481f1ab13 Create some indexes in gpcm.db. 2014-06-01 18:51:18 +02:00
Admiral H. Curtiss
72ce04cdd9 Merge remote-tracking branch 'origin/database_refactor' 2014-05-31 21:06:54 +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
polaris
2f25dab9b7 Return if the RC4 is 0 2014-05-31 14:41:17 -04: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
Matt Soucy
3eaf22b1a6 Make use of context managers to safely close files 2014-05-27 02:38:48 -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
polaris
684e2a2c94 Revert "abort decoding query string on bad values"
This reverts commit 4809beaad7.
2014-05-25 08:22:48 -04:00
Toad King
4809beaad7 abort decoding query string on bad values 2014-05-25 00:10:33 -04:00
Toad King
827030f0d6 fix infinite loop with malformed messages 2014-05-25 00:00:09 -04: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