Commit Graph

12 Commits (master)

Author SHA1 Message Date
Dessa Simpson 7897fe6f3d Add ratelimits
Fixes #10
2021-06-06 23:11:30 -07:00
Dessa Simpson 4607eaf307 Move ordering from views to queries.ts
Turns out views aren't guaranteed to keep their order ¯\_(ツ)_/¯

Fixes #24
2021-02-24 20:45:37 -07:00
Dessa Simpson 6bc292f122 Fix regression where songs with 0 votes had $normaluservotepoints points
Also, remove now-unnecessary join with users
2021-02-24 20:04:40 -07:00
Dessa Simpson dbe7e4c52d Restructure DB in preparation for follower/subscriber implementation
- Remove user.is{follower,subscriber}, replacing with tables follows and 
subscriptions
- Update vote_score_vw to reflect new structure
- Add db upgrade script
2021-02-22 23:54:47 -07:00
Dessa Simpson 173c22b90a Implement fetching of video titles
Fixes #2
2020-11-10 00:20:20 -07:00
Dessa Simpson 36d3871bdc Update updateRequestScore endpoint and clean up naming 2020-10-18 17:24:24 -07:00
Dessa Simpson 68f767b28d SQL refactoring 2020-09-21 11:12:00 -07:00
Dessa Simpson 76aa7b3bc4 Make bans work properly 2020-09-19 12:18:45 -07:00
Dessa Simpson 249a5911b4 Customize page with streamer username 2020-09-10 23:43:53 -07:00
Dessa Simpson 1256c4bb8b Display profile pictures in requests table
Fixes #14
2020-08-09 23:40:13 -07:00
Dessa Simpson 80e9bc1bde Redesign database and implement voting 2020-08-09 17:23:37 -07:00
Dessa Simpson fffe1596b8 Move 50-views.sql to 90-views.sql 2020-08-02 22:13:39 -07:00