beerpsi
bc7524c8fc
fix: make database async
2024-11-14 12:36:22 +07:00
Midorica
b7a006f7ee
core: pushing changes regarding MySQL ssl toggle that is now mandatory
2024-11-12 10:53:02 -05:00
daydensteve
c2d4abcc26
db and import updates for userbox, avatar, voice, and map icon
2024-11-03 16:37:05 -05:00
Kevin Trocolli
0cef797a8a
mai2: rework photo uploads, relates to #67
2024-10-06 03:47:10 -04:00
ppc
f47175a144
[mai2] add buddies plus support ( #177 )
...
Adds favorite music support (there's an option in the results screen to star a song), handlers for new methods and fixes upsert failures for `userFavoriteList`.
The `UserIntimateApi` has been added but didn't seem to add any data during testing, and `CreateTokenApi`/`RemoveTokenApi` have also been added but I think they're only used during guest play.
---
Tested on 1.45 with no errors/game crashes (see logs). Card Maker hasn't been tested as I don't have a setup to play with.
Reviewed-on: https://gitea.tendokyu.moe/Hay1tsme/artemis/pulls/177
Co-authored-by: ppc <albie@ppc.moe>
Co-committed-by: ppc <albie@ppc.moe>
2024-09-23 17:21:29 +00:00
ppc
1db020b5fc
fix generated keychip validation failures
2024-09-09 16:53:14 +00:00
Kevin Trocolli
6a43e0eada
update keychip serial generation code
2024-07-09 15:10:42 -04:00
Hay1tsme
c65c71e89e
card: add memos
2024-07-06 23:13:41 -04:00
Kevin Trocolli
44fb6037cf
chuni: add missing alembic script
2024-06-29 00:08:11 -04:00
Hay1tsme
4446ff1f21
mai2: add present support
2024-06-28 15:48:27 -04:00
Hay1tsme
7242a187ab
sao: fix sao_hero_log_data nullability
2024-06-28 12:25:33 -04:00
Kevin Trocolli
601cec9075
sao: you already know what it is
2024-06-27 10:02:19 -04:00
Kevin Trocolli
177f851368
sao: cleanup
2024-06-27 00:07:10 -04:00
Kevin Trocolli
40a66614bc
sao: fix user_hero_log_id
2024-06-27 00:04:23 -04:00
Kevin Trocolli
171131493f
sao: fix new issues
2024-06-26 23:57:07 -04:00
Kevin Trocolli
c13b096190
sao: split massive upgrade in half and hope it works
2024-06-26 23:31:59 -04:00
Kevin Trocolli
5eb2ef8311
sao: schema fixes 3: the misery never ends
2024-06-26 23:01:47 -04:00
Kevin Trocolli
f27f789269
sao: alembic sucks sometimes.
2024-06-26 22:37:56 -04:00
Kevin Trocolli
7206af83cb
sao: fix upgrade script
2024-06-26 22:30:12 -04:00
Kevin Trocolli
e91f84fecc
sao: backport changes from diana
2024-06-25 14:02:53 -04:00
Hay1tsme
8f9e9d4766
fix downgrade script issue referenced in #156
2024-06-24 13:37:10 -04:00
Kevin Trocolli
3979a020a6
add idm and chip_id fields to card table
2024-06-22 00:47:12 -04:00
Kevin Trocolli
ca9ccbe8a3
chuni: add missing net battle funcs
2024-06-21 23:00:35 -04:00
beerpsi
5378655c52
[chunithm] Support LUMINOUS
2024-06-20 08:11:24 +07:00
Kevin Trocolli
784ac544f0
fix event log ordering, paging, add timestamp
2024-06-16 14:42:23 -04:00
Kevin Trocolli
00224585bb
pokken: fix pokemon_data uk
2024-06-14 00:06:39 -04:00
Kevin Trocolli
79f511c837
frontend: add username login
2024-06-08 19:18:15 -04:00
Kevin Trocolli
f94d22ab0d
mai2: add tables for rivals and favorite music
2024-06-08 19:04:27 -04:00
akanyan
df2a4d3074
ongeki: clearstatus db migration
2024-05-29 19:15:22 +09:00
Kevin Trocolli
a2fe83ae06
cxb: add grade to playlog
2024-05-28 22:32:38 -04:00
Kevin Trocolli
e66ae91740
add basic event log viewer
2024-05-22 01:36:41 -04:00
Kevin Trocolli
4ee4c26f5e
allnet: enhance logging
2024-05-22 00:05:32 -04:00
Kevin Trocolli
a9587a9c91
add additional details to event_log
2024-05-21 23:05:22 -04:00
Hay1tsme
926713431d
Merge branch 'develop' of https://gitea.tendokyu.moe/Hay1tsme/artemis into develop
2024-04-02 16:43:16 -04:00
Hay1tsme
1072a9d63b
database: fix create_revision_auto
2024-04-02 16:43:13 -04:00
Hay1tsme
87c7c91e3a
add ability to add users, cards, arcades and cabs on the webui
2024-03-23 20:01:32 -04:00
Dniel97
3613f4dbd2
mai2: BUDDiES support added
2024-03-20 21:42:38 +01:00
beerpsi
40a0817009
CHUNITHM & O.N.G.E.K.I.: Handle userRatingBase*List ( #113 )
...
These tables are not used by the game, but are useful for anyone wanting to develop a web UI showing what the player's rating consists of. As such, instead of storing them in JSON columns, I've split them out, one row per each entry.
Reviewed-on: https://gitea.tendokyu.moe/Hay1tsme/artemis/pulls/113
Co-authored-by: beerpsi <beerpsi@duck.com>
Co-committed-by: beerpsi <beerpsi@duck.com>
2024-03-14 14:44:32 +00:00
Kevin Trocolli
b63c2c2d12
dbutils: add autocreate option to revision
2024-03-11 21:24:57 -04:00
Kevin Trocolli
c4deff9d1c
add database downgrading
2024-03-04 00:50:51 -05:00
Kevin Trocolli
e69149632f
frontend: fix namechange and password change failing
2024-03-02 17:52:01 -05:00
Kevin Trocolli
bd97428166
frontend: fix account and owner creation ( fixes #108 )
2024-03-02 17:48:48 -05:00
Hay1tsme
4149944d56
aimedb: update card last login time properly
2024-02-12 15:53:28 -05:00
Kevin Trocolli
fc3f0900b3
dbutils: add create-revision command
2024-01-11 20:48:27 -05:00
Kevin Trocolli
19fd008598
fix legacy upgrade script
2024-01-11 20:39:29 -05:00
Hay1tsme
261d09aaef
dbutils: add legacy migration
2024-01-09 17:11:49 -05:00
Hay1tsme
37304500a5
fix SDDT v5 rollback and v6 upgrade scripts
2024-01-09 16:22:43 -05:00
Hay1tsme
f8c77e69ed
remove unused table
2024-01-09 15:56:49 -05:00
Hay1tsme
9dab26b122
port frontend changes from different project
2024-01-09 15:54:34 -05:00
Hay1tsme
05586df08a
move to async database
2024-01-09 14:42:17 -05:00
Hay1tsme
edd3ce8ead
move to alembic
2024-01-09 13:57:59 -05:00
Kevin Trocolli
14fa0f5e8e
begin move
2024-01-09 03:07:04 -05:00
Midorica
37b1f41b44
fixing the upgrade & downgrade script for chunithm
2023-12-15 22:21:05 -05:00
EmmyHeart
9b9d1f664d
Rollback for Sun Plus changed
...
should hopefully never need to use this
2023-12-13 06:34:32 +00:00
EmmyHeart
b6d1f2cd3a
Updated playlog and best tables for Sun Plus
...
Lord have mercy, this is my first schema update
2023-12-13 06:33:06 +00:00
Kevin Trocolli
283cf41bce
chuni: bandaid fix for if a user or team is named 'true' or 'false', fixes #65
2023-12-10 17:41:05 -05:00
phantomlan
80ae372ccf
fix rollback
2023-11-13 04:05:13 +01:00
phantomlan
b56a5f020b
add rollback sql
...
move GP support to table in DB
small fixes
2023-11-13 03:26:09 +01:00
phantomlan
f81c53558e
- Add ClientTestmode upsert
...
- Add ClientSetting upsert
- Add endDate for Events
- Add Upgrade Schema
- Small bugfixes for events
2023-11-13 02:01:56 +00:00
EmmyHeart
8fcd227b33
Added functions for checking if Aime card is locked or banned
2023-10-20 03:24:25 +00:00
Midorica
54c77c047e
fixing duplicated is_cab value from machine table
2023-10-18 18:44:03 -04:00
Dniel97
d6e4db48f4
Added maimai DX FESTiVAL PLUS support
...
- Added Card Maker support for FESTiVAL PLUS
- Bumped SDEZ database to version 8
- Updated docs for FESTiVAL PLUS
2023-10-15 19:04:15 +02:00
Midorica
aa9d48ccc9
fixed the diva profile again
2023-10-10 18:37:18 -04:00
Midorica
6d592dcbc7
fixing skin issue with diva profile
2023-10-10 18:24:54 -04:00
Kevin Trocolli
b5ccd67940
db: add memcache toggle
2023-10-05 22:16:50 -04:00
Kevin Trocolli
aa17f99252
frontend: add placeholders, arcade search by IP
2023-09-19 02:31:29 -04:00
Hay1tsme
9e3a51a57a
allnet: add IP checking
2023-08-08 12:35:38 -04:00
Hay1tsme
88a1462304
logger: change from warn to warning
2023-08-08 10:17:56 -04:00
Hay1tsme
2e277e7791
add arcade ip column
2023-08-08 10:17:38 -04:00
Kevin Trocolli
b943807904
core: add columns to machine table, bump to v5
2023-07-23 22:21:41 -04:00
Kevin Trocolli
14a315a673
replace except with except Exception
2023-07-16 16:58:34 -04:00
Midorica
c6e7100f51
Merge pull request 'O.N.G.E.K.I.: Card Maker fixes, improvements and bug fixes' ( #25 ) from Dniel97/artemis:cardmaker_ongeki_fix into develop
...
Reviewed-on: https://gitea.tendokyu.moe/Hay1tsme/artemis/pulls/25
2023-07-16 17:06:44 +00:00
Dniel97
f39317301b
mai2: fixed update script, added mai2 heredity, fixed cards import
2023-07-15 22:51:54 +02:00
Kevin Trocolli
2f13596885
fix db ignoring port in config, createing database no longer runs over version
2023-07-15 00:15:14 -04:00
Dniel97
6a41dac46c
ongeki: card maker config added, small fixes, improved credits
...
- Changed the credits config to the default 370 instead of 360
- Added `start_date` to the events to show new events
- Fixed Card Maker Gachas to only allow "Select Gacha" once
- Fixed the `get_profile_rating_log` database query
2023-07-12 11:25:46 +02:00
Kevin Trocolli
6c155a5e48
database: add static variables to prevent having multiple sessions
2023-07-08 00:01:52 -04:00
Kevin Trocolli
f279adb894
mai2: add consecutive day login count, update db to v7, fix reader, courses, and docs
2023-07-01 21:51:18 -04:00
Kevin Trocolli
127e6f8aa8
mai2: add finale databases
2023-06-27 00:32:35 -04:00
Kevin Trocolli
858b101a36
dbutils: add command to show versions
2023-06-24 13:14:40 -04:00
Dniel97
ad820ed091
cm: Added individual Card Maker version and maimai DX passes working
2023-05-30 12:14:18 +02:00
Hay1tsme
4da8622977
frontend: user page fixes, add card display
2023-05-20 15:32:02 -04:00
Dniel97
b85a65204f
chuni: added SUN support, matchmaking, fixed bugs, added docs
...
- Added CHUNITHM SUN support
- Added first matchmaking support with CPU spawning and messages
- Fixed wrong `next_idx` calculations
- Added `startDate` to events to spawn the correct items
- Fixed login bonus per version
- Added information to docs
2023-05-10 21:32:35 +02:00
Dniel97
a0793aa13a
diva: added clear set calculation + small improvements
2023-04-30 23:31:13 +02:00
Kevin Trocolli
238d437519
reformat with black in preperation for merge to master
2023-04-23 21:04:52 -04:00
Kevin Trocolli
a30967e8d7
wacca: fix time free not saving, add counter to profile table
2023-04-20 09:46:18 -04:00
Midorica
017ef1e224
Merge pull request 'maimai DX FESTiVAL support' ( #17 ) from Dniel97/artemis:maimai_dx_festival into develop
...
Reviewed-on: https://gitea.tendokyu.moe/Hay1tsme/artemis/pulls/17
2023-04-19 18:13:31 +00:00
Dniel97
958471b8eb
mai2: update script hotfix
2023-04-19 17:41:36 +02:00
Kevin Trocolli
0dc96f33e1
database: don't set schema version if autoupdate fails
2023-04-15 03:13:14 -04:00
Kevin Trocolli
4102ba21fc
database: remove print
2023-04-15 03:07:15 -04:00
Kevin Trocolli
9895068125
database: fix autoupdate
2023-04-15 01:31:52 -04:00
Kevin Trocolli
a416fb09e1
dbutils: version can now be left black to auto-upgrade to latest
2023-04-15 00:13:04 -04:00
Kevin Trocolli
0d5567c990
wacca: fix v4 upgrade scripts
2023-04-15 00:12:28 -04:00
Kevin Trocolli
b1f9be0121
wacca: fix crash on 4th page of Reverse Gate, partially fixes #5
2023-04-14 23:47:31 -04:00
Dniel97
f63dd07937
maimai: Initial Festival support
2023-04-10 19:11:58 +02:00
Kevin Trocolli
188be2dfc1
database: add autoupgrade command
2023-03-18 02:12:58 -04:00
Kevin Trocolli
6ff8c4d931
fix mai2 and diva db scripts
2023-03-18 02:12:33 -04:00
Dniel97
2af7751504
Added support for maimai and Chunithm in Card Maker 1.34/1.35 ( #14 )
...
Co-authored-by: Dniel97 <Dniel97@noreply.gitea.tendokyu.moe>
Reviewed-on: https://gitea.tendokyu.moe/Hay1tsme/artemis/pulls/14
Co-authored-by: Dniel97 <dniel97@noreply.gitea.tendokyu.moe>
Co-committed-by: Dniel97 <dniel97@noreply.gitea.tendokyu.moe>
2023-03-15 20:03:22 +00:00
Kevin Trocolli
a791142f95
database: add check for current_schema_version
2023-03-12 22:37:44 -04:00
Kevin Trocolli
ea14f105d5
database: skip games that lack a database member
2023-03-12 00:26:48 -05:00
Hay1tsme
a76bb94eb1
let black do it's magic
2023-03-09 11:38:58 -05:00