Commit Graph

271 Commits

Author SHA1 Message Date
Spotlight
f8225e1a73
Only delete Discord user on valid HTTP error 2024-09-03 19:19:50 -05:00
Spotlight
9a2b2d55fd
Fix up presence reset 2024-09-03 19:17:11 -05:00
Spotlight
7f88b14d96
Properly update session in table 2024-09-03 19:11:42 -05:00
Spotlight
14e01da28b
Further format RPC-related code
This introduces a class, `UserData`, that allows for better typed access of user data passed for presence information. It additionally removes quite a lot of redundancy between function calls by passing around the user's raw database object.
2024-09-03 19:10:48 -05:00
Spotlight
8680b6913e
Properly set session to empty
Refer to the original functionality here: d6d8343932/server/discord.py (L19-L21)
2024-09-03 18:55:42 -05:00
Spotlight
4ef93e8e2a
Further fix-up for sessions
Follow-up to dd83a8f4ad.
2024-09-03 18:09:25 -05:00
Spotlight
dd83a8f4ad
Fix up Discord session 2024-09-03 17:25:02 -05:00
Spotlight
cc235ed6c5
Format RPC-related code 2024-09-03 17:01:38 -05:00
Spotlight
07dddaafba
Nintendo <-> Pretendo 2024-09-02 22:05:31 -05:00
Spotlight
b77321ae2a
Trim off microseconds 2024-09-02 22:01:50 -05:00
Spotlight
59ebc757df
jeu_favori -> favorite_game 2024-09-02 21:55:22 -05:00
Spotlight
c78c28bb6b
Fix up column names 2024-09-02 21:52:22 -05:00
Spotlight
393da6ce3a
Migrate backend as well 2024-09-02 21:50:09 -05:00
Spotlight
b6f51aae72
Convert to DateTime 2024-09-02 21:43:49 -05:00
Spotlight
cadd1b6dad
Remove extraneous DB code 2024-09-02 21:22:48 -05:00
Spotlight
888331f02d
Various web refactors 2024-09-02 21:01:40 -05:00
Spotlight
b2fdede026
discord: Use DiscordFriends table
The wrong table was erroneously used.
2024-08-25 00:06:25 -05:00
Spotlight
6389699320
Fix up incorrect database path 2024-08-24 15:41:04 -05:00
Spotlight
907cd4fd26
Generalize database URL 2024-08-24 15:34:21 -05:00
Deltaion Lee
4280bcc97d Upgrade web dependencies 2024-08-24 15:19:53 -05:00
Spotlight
513b74d7cf
discord: Resolve column name 2024-08-24 14:58:31 -05:00
Logan
43a66ba531 hotfix: remove mistakenly committed changes 2024-08-22 12:11:12 -06:00
Logan
b91d63ebb0 fix: fix roster & active users not functioning properly 2024-08-22 12:10:00 -06:00
Logan
3c88644bc7 fix: update requirements.txt to include mysql support 2024-08-22 00:29:07 -06:00
Logan
51cd2c3470 refactor: purge unneeded dependancies from server.py 2024-08-21 23:42:51 -06:00
Logan
9bf7002a88 fix: misunderstanding of how session works 2024-08-21 23:40:50 -06:00
Logan
336e561dd2 fix: api bugs with multi networks 2024-08-21 22:35:50 -06:00
Logan
c46e6025d3 feat: add mysql (mariadb) support 2024-08-20 03:30:17 -06:00
Logan
dbdbe530c4 fix: implement proper duplicate detection 2024-08-20 02:34:25 -06:00
Logan
3d31fc55e6 refactor: discord.py & add implement ORM 2024-08-20 02:06:41 -06:00
Logan
d7ffc56cd0 revert: add back ignoring delay on pretendo 2024-08-19 01:26:41 -06:00
Logan
83d7d823c8 fix: orm now works for backend & server! 2024-08-19 01:03:49 -06:00
Logan
84dda40f3a refactor: add new database schema to backend 2024-08-18 13:03:58 -06:00
Logan
933146690d refactor: finish adding (buggy) ORM to server.py 2024-08-18 05:05:02 -06:00
Logan
0aa4080152 refactor: add ORM to non api routes 2024-08-18 03:52:11 -06:00
Logan
5c749db18b refactor: add ORM to non web functions 2024-08-18 02:54:02 -06:00
Logan
8381c27c9d fix: change database import to proper import 2024-08-08 12:42:34 -04:00
Spotlight
496b766081
Initial migration towards ORM-oriented queries 2024-07-22 15:22:36 -05:00
Spotlight
427132a752
Adjust to descriptive variable names 2024-07-22 13:52:52 -05:00
Spotlight
ac44dc663b
Initial migration towards separate database logic
We're simply breaking apart logic here - the majority of models are not implemented. The upgrade to Flask-SQLAlchemy has not yet been tested on `server`.
2024-07-22 13:20:40 -05:00
Spotlight
f478bd3fc5
Migrate to enum-oriented functions
By migrating information such as the bot's friend codes and database column names, a significant amount of boilerplate can be reduced.
2024-07-21 00:04:30 -05:00
Spotlight
a23380e0cd
Remove Pretendo-related delay adjustment
This is no longer necessary due to server-side changes.
2024-07-20 19:45:47 -05:00
Deltaion Lee
661755fa1a Update public.py
Preparation to prod has not started yet.
2024-06-28 16:15:44 -05:00
Deltaion Lee
8751376416 Squashed commit of the following:
commit 431529e50b
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sun Jun 2 09:44:49 2024 -0600

    Update copyright & requirements.txt

commit 40bfcc8a4a
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sun May 19 15:14:06 2024 -0600

    Fix the downloadable client's API, and missing variables

commit a209e537ff
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sun May 12 11:24:19 2024 -0600

    Add a quick note regarding my hacky fix.

commit 045b32e6fc
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sun May 12 11:11:31 2024 -0600

    this is actually horrifying, but it fixes pretendo finally.

commit 909fbeb472
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Fri May 3 15:28:09 2024 -0600

    Add default to some values in CREATE.sql

commit 788ed5dc41
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Fri May 3 10:33:36 2024 -0600

    Resolve some SQL syntax errors (thanks @spotlightishere)

commit 0eee7ab448
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Fri May 3 10:01:18 2024 -0600

    Move NetworkIDsToName and other functions to new file + change it to IntEnum

commit 5a96a68269
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sun Apr 28 13:48:38 2024 -0600

    Hot... Change?: Add the ability to use -n and --network instead of just --network

commit 8325f523bc
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sun Apr 28 13:36:33 2024 -0600

    Fix @HotaruBlaze (Phoenix)'s code

commit 25da282ba1
Merge: 51d10c7 4918ffb
Author: Logan <60761520+Preloading@users.noreply.github.com>
Date:   Sun Apr 28 13:25:36 2024 -0600

    Merge pull request #1 from HotaruBlaze/Preloading/main

    [Cleanup] Rework __main__: Add cleaner command line & Remove unneeded function.

commit 4918ffb61c
Author: Phoenix / Hotaru <DeriousHD@gmail.com>
Date:   Sun Apr 28 20:19:25 2024 +0100

    [Cleanup] Rework __main__: Add cleaner command line & Remove unneeded function.

commit 51d10c75bb
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sun Apr 28 12:28:25 2024 -0600

    Fix mistake where i mixed == with != somehow

commit 1b70062fa3
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sun Apr 28 12:09:38 2024 -0600

    Uncomment temporary commenting on getPresence (thanks phoenix)

commit bea621dfd4
Author: Logan <60761520+Preloading@users.noreply.github.com>
Date:   Sun Apr 28 08:22:52 2024 -0600

    Remove debug print line

commit 12bb21e7e1
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 19:31:20 2024 -0600

    Fix API commands to be compatible with before

commit f2f9c7a444
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 19:03:30 2024 -0600

    Add a sign of what network you are on, on the discord rpc

commit 6f26c3cd11
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 18:48:16 2024 -0600

    Show what network on the user's page

commit f4e569f4b2
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 17:47:20 2024 -0600

    Possibly finish off discord.py (open to adding something saying what network you are on later)

commit ec164ee361
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 16:27:32 2024 -0600

    Make discord.py not break and rename some variables in server.py

commit 998c0896dc
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 15:49:44 2024 -0600

    Update template.private.py to be accurate with my private file

commit 9145e04dae
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 15:01:37 2024 -0600

    Fix mobile support for the Select Network page

commit beb800f310
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 13:28:01 2024 -0600

    Done web backend!

commit db89c6f032
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 12:46:49 2024 -0600

    Finish sidebar, Fix index forgetting about pretendo, and another thing

commit 681ffffafa
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 10:10:30 2024 -0600

    Make the try profile button work with pretendo

commit 107bb05ac4
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 10:04:23 2024 -0600

    Fix console profile redirect

commit 628c5eccbe
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 09:59:08 2024 -0600

    Add proper pretendo redirection to the new users and active users (maybe to active users)

commit b8e44b9806
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 27 08:38:14 2024 -0600

    Well, the most inelegent way of fixing pretendo support (i guess)

commit d6e7facda4
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Mon Apr 22 00:18:08 2024 -0600

    Add small fixes allowing selecting and deleting consoles

commit 6f2987edae
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 20 10:24:03 2024 -0600

    try to work around missing function on pretendo, currently hangs at random spots

commit 8ae5da0921
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sat Apr 20 08:47:12 2024 -0600

    You can now add consoles from the menu + maybe fixing the backend for pretendo (thanks DaniElectra on discord)

commit 397a4a7a3a
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Fri Apr 19 23:14:51 2024 -0600

    Mostly finish up registering UI and site backend (actually registering todo)

commit 5fd14c3292
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Fri Apr 19 21:42:04 2024 -0600

    Hotfix: correct and implement some feedback

commit fa60f948a9
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Fri Apr 19 21:28:12 2024 -0600

    Created the basic "select the network" page

commit 232d317120
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Thu Apr 18 00:16:52 2024 -0600

    fix consoles page

commit 1ae808a5c5
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Wed Apr 17 23:53:26 2024 -0600

    fix homepage, roster, and active

commit 1da19cab4d
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Wed Apr 17 20:37:46 2024 -0600

    Add pretendo support to the backend uptime counter

commit fd3ab39ccf
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Wed Apr 17 19:31:47 2024 -0600

    Add broken pretendo backend support, waiting for help on a datetime bug in something.

commit 8c70cb40cd
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Mon Apr 15 23:07:54 2024 -0600

    Hotfix: Fix SQL being odd

commit c05e2fd270
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Mon Apr 15 23:00:19 2024 -0600

    changes to the migration script & small change to backend

commit c39d1253f3
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Mon Apr 15 22:52:55 2024 -0600

    Add args to choose between nintendo & pretendo

commit e1e85c4783
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Mon Apr 15 20:49:28 2024 -0600

    realizing that my ideas are stupid, and changing it from a flag to a table

commit b467277f99
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sun Apr 14 20:28:54 2024 -0600

    left my note to added friends oops

commit cc7c79e71c
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sun Apr 14 20:23:36 2024 -0600

    Update creation script and add Migration script to support multiple networks

commit 87a1589677
Author: Loganh4005 <60761520+Preloading@users.noreply.github.com>
Date:   Sun Apr 14 19:33:38 2024 -0600

    Updated code to use the latest NintendoClients version (+ a few other things)
2024-06-28 16:06:05 -05:00
Deltaion Lee
150ec4c003 Scrape update 2024-04-08 00:12:58 -05:00
Deltaion Lee
5ee03f5078 Change update times and delay 2024-02-01 20:40:46 -06:00
Deltaion Lee
bc1248a939 Speed up update times 2023-07-23 22:56:05 -05:00
Deltaion Lee
ff61bb2d99 Extend time (#20) 2023-07-23 22:53:34 -05:00
Deltaion Lee
d6d8343932 Fix makeup not existing
Thanks @neverforget9 on Discord for noticing this!
Also time to test on production.
2023-07-05 22:41:36 -05:00
Deltaion Lee
ee15f2d7cf Various updates to API routes
Minor functionality changes. Slightly more secure user token stuffs?
2023-06-27 21:04:06 -05:00