280 Commits

Author SHA1 Message Date
Spine
2dee8ef9b8 give a bonus reward for the first uploads of a user 2025-10-09 09:42:41 +02:00
Spine
d8058f7b77 add non-Music audiobook/ebook report types 2025-10-09 09:41:54 +02:00
Spine
2076cae5d6 add a manager to deal with rejected tags 2025-10-03 08:32:06 +02:00
Spine
b19dfa460f capture wtf garbage from login failures 2025-10-01 09:34:01 +02:00
Spine
de779923e0 refactor edit torrent group 2025-10-01 09:34:01 +02:00
Spine
5686b6e274 merge torrent history and required ratio calculation tasks 2025-09-17 22:07:58 +02:00
itismadness
c706232634 Add select perms to nyro docker user 2025-09-17 22:07:58 +02:00
itismadness
9d317538b7 Update stylelint configuration and lint scss 2025-09-17 22:07:58 +02:00
Spine
2db8d5f3c1 promote bonus shop items to first class objects 2025-09-17 22:07:58 +02:00
Spine
1f7eaae26f replace overloaded DEBUG_MODE with specific constants 2025-09-10 13:01:53 +02:00
Spine
d0243c69a4 add pg tablefunc extension 2025-09-10 13:01:53 +02:00
itismadness
27507468ac Setup mysql ro user for docker 2025-09-10 13:01:53 +02:00
Spine
b59aa0512a kill the last traces of the funky artist Importance nonsense 2025-09-10 13:01:53 +02:00
Spine
540e520e00 consolidate tracker useragents in a summary table 2025-09-10 13:01:53 +02:00
Spine
6628e583e1 precalculate hourly bp accrual in user summary table 2025-09-10 13:01:53 +02:00
Spine
fa67f6781b allow bonus accrual by category 2025-08-27 16:44:44 +02:00
Spine
d686d0d54e FL token size as a configurable site option 2025-08-27 16:44:44 +02:00
Spine
f248574adf move upload bonus rewards to the db to permit changes over time 2025-08-27 16:44:44 +02:00
Spine
0e3a21fec8 sphinx tweaks to fix "word overrun buffer, clipped" 2025-08-27 16:44:44 +02:00
Spine
342af0fc6c redo category resource tables with 1-based ids 2025-08-27 16:44:44 +02:00
Spine
e10376887b enable phpstan numericOperandsInArithmeticOperators and strictArrayFilter 2025-08-27 16:44:44 +02:00
Spine
c9645beb91 drop mysql log table 2025-08-27 16:44:44 +02:00
Spine
dd8ee6160e file storage classes are object based 2025-08-27 16:44:44 +02:00
Spine
be151fab96 add mysql InnoDB op/sec to performance dashboards 2025-08-27 16:44:44 +02:00
Spine
b6d2cbfcfd relay email changes to pg 2025-08-27 16:44:44 +02:00
Spine
6d756445a7 tgroup bookmarks have an ordering sequence 2025-08-27 16:44:44 +02:00
Spine
d7bcc62918 relay request artists 2025-08-27 16:44:44 +02:00
Spine
be9789e2d0 drop sphinx request tables 2025-08-27 16:44:44 +02:00
Spine
4be104f053 stop updating sphinx request index 2025-08-27 16:44:44 +02:00
Spine
d34a62733b migrate bookmarks to Pg (phase 1) 2025-08-27 16:44:44 +02:00
Spine
86d409e30c initialize userclass privilege tables in Postgres 2025-08-27 16:44:44 +02:00
Spine
cef1aa91db deploy some stricter phpstan rules 2025-08-27 16:44:44 +02:00
itismadness
773b262a83 update composer to 2.8.10 2025-08-27 16:44:43 +02:00
Spine
24c623e600 introduce a second phase of mysql migrations (and drop migrated tables) 2025-08-27 16:44:43 +02:00
Spine
254d557e67 fix initial seed of user privileges 2025-08-07 16:03:48 +02:00
Spine
c78e2712a6 add Postgresql unaccent extension 2025-08-07 16:03:48 +02:00
Spine
7c5bb92d5d switch artist_usage pk from role to artist_role_id 2025-08-07 16:03:10 +02:00
Spine
7310259d06 add cascade to forums_transitions foreign keys 2025-08-07 16:03:10 +02:00
Spine
eb48a2606d stop writing to artist_role Importance field 2025-08-07 16:03:10 +02:00
Spine
13e08b602d switch artist_role pk from Importance to artist_role_id 2025-08-07 16:03:10 +02:00
Spine
bd5f13de09 bump composer version and sign repos 2025-08-07 16:03:10 +02:00
Spine
26ad99caba tally request voter totals 2025-08-07 16:03:10 +02:00
Spine
3823ac07c2 dual-write ratio watches to Pg 2025-08-07 16:03:10 +02:00
Spine
225c4c66cb add request_vote_summary table for ordering searches 2025-08-07 16:03:10 +02:00
Spine
9a9b88c74f revamp request creation interface 2025-08-07 16:03:10 +02:00
Spine
cdc9f070b5 load request artist and title for fulltext search 2025-08-07 16:03:10 +02:00
Spine
a11bcc1371 add resource tables (format, encoding, media) 2025-08-07 16:03:10 +02:00
Spine
bcd26db1e8 run advanced user search from Pg 2025-08-07 16:03:10 +02:00
Spine
bc43439d8a add column artist_usage.artist_role_id 2025-08-07 16:03:10 +02:00
Spine
6741c3bed1 relay request tags and votes 2025-08-07 16:03:10 +02:00