Commit Graph

180 Commits (master)

Author SHA1 Message Date
justcool393 c9ecb5d535
account linking improvements (#448)
currently account delinking is very messy and can sometimes just not work
we do codey stuff so it's not as bad
also we create a pretty page for mops to mop up borked account links

* alts: allow proper delinking

* fix prev commit

* url fix

* fix 500

* fixes

* :pepodrool:

* flag

* :pepodrool: redux

* sdsdsdsds

* correct endpoint

* fix html page

* alts: only adjust session history if flag is set

* fix 500

* allow relinking

* fsdsds

* :pepodrool: redux

* alts: don't fail if an alt isn't history

* use postToastSwitch + some API changes

* remove unnecessary variables

* d-none

* delink accounts mod action

* fa-link-slash

* alts: add form to create alt

* remove copied and pasted template

* rounded section

* UI improvement + fix

* \n

* fix status

* admin: remove duplicate route
admin: do a permissions check on 2 pages that need it
admin: set the manual flag for manually flagged alts

* variable change

* fix 500

* alts

* add shadowban icon to alt link tool

* shadowbanned tooltip

* add user info section

* fix 500, remove unnecessary form, and add alt votes button

* trans and also link to page

* margin

* sdsdsd

* stop the count

* fix prev commit

* with ctx

* plural

* alts

* don't show shadowbanned users to those who can't see them
this is... extremely rare and won't ever be seen in production however if perms were ever rearranged in the future, this keeps permissions correct

* shadowban check in alt list

* let shadow realm enthusiasts see shadowban alts

* sdsdsds

* test

* be graceful where needed

* sdsdsdsds

* alts: don't allow adding the same account
alts: clarify wording

* rename and reorder on admin panel

* EOL

* remove frankly unnecessary check

* try with a set

* test

* Revert "try with a set"

This reverts commit 72be353fba5ffa39b37590cc5d3bf584c94ee06e.

* Revert "Revert "try with a set""

This reverts commit 81e41890a192e8b46d0463477998e905fddf56ba.

* Revert "Revert "Revert "try with a set"""

This reverts commit be51592135a3c09848f993f0154bd2ac862ae505.

* clean up test
2022-11-14 12:32:13 -05:00
Aevann1 9147427996 do what snekdaddy said 2022-11-11 20:01:23 +02:00
Snakes 4f849c2c36
Fix userpage hat counter showing equipped.
Essentially, just needed to not reuse owned_hats.
2022-11-09 10:32:14 -05:00
Snakes ebb3957f41
Eager load submission listing relationships. 2022-11-09 09:16:22 -05:00
Snakes a310d43b10
Fix DMs not checking blocks. 2022-11-02 16:23:01 -04:00
justcool393 35e2128dec
get: use function to get voted and blocked properties (#425)
* get: comments and posts: use get function from get.py
* fix prev commit
* move filter to correct place
* fix error and also log so i can figure out what's wrong
* comments: add some more trace logging
* should_keep_func always acts as return True if None is passed in
* remove logging code
2022-10-28 19:13:37 -05:00
Aevann1 5719688178 use tabs, not spaces 2022-10-29 01:39:31 +02:00
justcool393 68451513b0 get: use a single function to sanitize usernames 2022-10-27 21:39:57 -05:00
justcool393 ea46bafce2 get: List -> Iterable, we accept lists, sets, etc 2022-10-27 19:30:53 -07:00
justcool393 8a8e6f2233 get: functions to add blocks and vote properties
get: don't attempt to re-query if blocks or voted properties are already present
2022-10-27 19:30:53 -07:00
justcool393 16ba59d8b3 get: check stripped out names before querying the db and return None if graceful in other places 2022-10-27 19:30:53 -07:00
justcool393 5ff6fea4dc get: add type annotations everywhere 2022-10-27 19:30:53 -07:00
justcool393 308e9cbbd6 get: remove weird vestigal load_parent part of get_comment 2022-10-27 19:30:53 -07:00
Aevann1 1a35e2ec6a refactor banned domains 2022-10-28 00:37:29 +02:00
justcool393 fe9064a9b7
update get.py redux 2022-10-12 08:40:43 -07:00
justcool393 5c03e5a7a4
Update get.py 2022-10-12 08:33:49 -07:00
justcool393 db9b37de40 type hints for get functions :) 2022-10-12 02:22:13 -07:00
Aevann1 2aa281e8c8 refactor sorting again (untested) 2022-10-12 09:03:28 +02:00
Aevann1 925ec12141 more shadowban refactor 2022-10-12 08:53:32 +02:00
Aevann1 e1ee9a69e4 refactor seeing shadowbanned shit (untested) 2022-10-12 08:24:30 +02:00
justcool393 ae0c215af3 ... 2022-10-05 19:51:44 -07:00
justcool393 2fc3044d5b shadowban perms and stuff 2022-10-05 19:24:37 -07:00
justcool393 9575e11b8b add get_sub_by_name function 2022-10-05 03:37:29 -07:00
justcool393 fc623b7201 get id fix for sbs 2022-09-30 22:16:15 -07:00
justcool393 7e3f43c9ab
unperson shadowbanned users (#373)
* unperson shadowbanned users
if a shadowbanned user copes, does anyone hear them seethe?

* unperson shadowbanned users (by id)

* don't import that

* Add include_blocks.
We don't always want to request blocks from the db when we have a user set

* block shadowbanned users from hole mod tools

* don't allow awarding shadowbanned things

* fix conflict

* gracefully use get_account when specified and also add include_blocks flag to get_account as well
2022-09-30 14:00:58 -07:00
Aevann1 0686cdbcf6 remove testing print statement 2022-09-27 12:52:48 +02:00
Aevann1 c882b366a1 testing smth 2022-09-27 08:41:23 +02:00
Aevann1 f54791cc4c remove categories 2022-09-19 20:04:30 +02:00
Aevann1 7edc44ff6f fix https://rdrama.net/post/18459/marseycapywalking-megathread-for-bugs-and-suggestions/2713626?context=8#context 2022-09-13 11:59:40 +02:00
Aevann1 ee756bf4b6 minor submission changes 2022-09-12 09:17:57 +02:00
Aevann1 7404d94610 fix issues for new instances 2022-09-05 22:37:38 +02:00
official-techsupport d49cba78a3
improve 'graceful' behavior of get_users (#331) 2022-08-21 21:54:55 +02:00
Aevann1 0cae055403 remove weird spaces annoying me 2022-08-17 21:25:57 +02:00
Snakes 1411018f8d Add post categories.
Implemented for LGB but can likely be used for WPD and other future
sites. Similar to a reddit post flair. Provides:
  - Admin panel for Category management.
  - Category selection on post submission.
  - 'Recategorize' post action.
2022-08-07 02:57:30 -04:00
Aevann1 a8fe49f232 kitchen sink commit, all over the place 2022-07-08 21:03:04 +02:00
Aevann1 c380848d47 remove leftover code from ill-fated joinedload attempt 2022-07-08 20:28:56 +02:00
Aevann1 e34f1a1c15 Revert "testing bandwidth"
This reverts commit d6559471b7.
2022-07-08 17:13:37 +02:00
Aevann1 d6559471b7 testing bandwidth 2022-07-08 17:05:08 +02:00
Aevann1 4ba413eaa9 Revert "Revert "remove all joinedload bullshit I added""
This reverts commit 4057711c83.
2022-07-06 13:08:11 +02:00
Aevann1 4057711c83 Revert "remove all joinedload bullshit I added"
This reverts commit c8d5eb0f57.
2022-07-06 12:58:44 +02:00
Aevann1 c8d5eb0f57 remove all joinedload bullshit I added 2022-07-04 09:04:14 +02:00
Aevann1 e60c4d46fe Revert "testing bandwidth"
This reverts commit cc3137d730.
2022-07-04 04:02:34 +02:00
Aevann1 cc3137d730 testing bandwidth 2022-07-04 03:08:13 +02:00
Aevann1 a6b7fed2fc minor logic change in /@username 2022-07-03 14:12:33 +02:00
Aevann1 8917427323 fix snytax error 2022-07-03 13:59:39 +02:00
Aevann1 ed86ec1c14 more query optimization v3 2022-07-03 13:56:40 +02:00
Aevann1 3e87b20ed0 more query optiimzation v2 2022-07-03 13:30:54 +02:00
Aevann1 72884713ac more quert optimization 2022-07-03 13:21:58 +02:00
Aevann1 1f0f0ef0be messing with joins 2022-07-03 08:12:53 +02:00
Aevann1 c8b4838157 unmessing with queries 2022-07-03 06:34:29 +02:00
Aevann1 91951ed142 messing with relationships 2022-07-03 06:27:48 +02:00
Aevann1 d0d15c319a Poll rework (#312)
* poll rework

* forgot to do joinedload on comments

* Fix logic errors with voting, SQL syntax.

Kitchen sink commit from review of poll-rework changes:
  1. Fix seed-db.sql syntax error.
  2. Fix SQL patch file duplication of *submissions* tables rather
     than one set of submissions and one for comments.
  3. Start makeshift SQL patch folder, since this is a large change
     that contributors may wish to apply to their local instances.
  4. Fix checkbox (non-`exclusive`) polls being unable to be
     unchecked. For consistency with `exclusive` polls, they should.
  5. Fix changing the option of an `exclusive` poll when both
     exclusive and non-exclusive options are present in one comment/
     post causing the non-exclusive options to become unchecked.
     (which, by my reading of SQLAlchemy `Query.one_or_none()`
     really could break quite badly in some cases).

* link relationships with their counterparts

* small modification to poll unchecking

Co-authored-by: TLSM <duolsm@outlook.com>
2022-07-02 08:48:04 +02:00
Aevann1 f56be06eb8 add hole pinning 2022-07-02 01:11:48 +02:00
Aevann1 9ffc3015e2 testing 2022-07-01 20:09:56 +02:00
Aevann1 e8f5827c5e more testing 2022-07-01 15:34:11 +02:00
Aevann1 1676572f09 test 2022-07-01 15:15:44 +02:00
Aevann1 5bbd14ebd6 testing 2022-07-01 15:11:41 +02:00
Aevann1 2fd8e88ceb try fixing inbound bandwidth 2022-07-01 13:32:01 +02:00
Aevann1 05aa116a8a cutting down on query volume 2022-07-01 03:18:06 +02:00
Aevann1 070945d98a cut down on the number of queries 2022-06-29 09:22:18 +02:00
Aevann1 3b8188fd67 fixed version of d83d47e280 2022-06-26 03:22:05 +02:00
Aevann1 a1b137447e Revert "reduce query volume #1"
This reverts commit d83d47e280.
2022-06-26 03:12:31 +02:00
Aevann1 d83d47e280 reduce query volume #1 2022-06-26 02:50:47 +02:00
Aevann1 6f6d01c1c6 actually use the get functions 2022-06-24 15:19:53 +02:00
Aevann1 f60db1598d replace "g.db.query" on pkeys with the much more efficient "g.db.get" 2022-06-18 02:57:23 +02:00
Aevann1 c01d53aa0d make mentioning case-insensitive again 2022-06-18 00:03:23 +02:00
Aevann1 fae0bee0d9 Refactored mention sanitization (stolen commit from themotte) 2022-06-17 22:37:27 +02:00
Snakes acde2c856b Enable JL2 viewing shadowbanned comments. 2022-06-12 05:48:27 -04:00
Aevann1 50b995d3a0 fds 2022-05-25 22:16:26 +02:00
Aevann1 6b10d097a2 mn 2022-05-05 01:09:46 +02:00
Aevann1 99cb01d9fc fdsfds 2022-04-15 18:28:08 +02:00
Aevann1 35ec2a7712 fart 2022-03-05 00:46:20 +02:00
Aevann1 ad761ac0ae fds 2022-02-26 21:01:32 +02:00
Aevann1 6cc9cddef0 fug 2022-02-26 16:21:07 +02:00
Aevann1 14c7148eed fd 2022-02-24 10:28:13 +02:00
Aevann1 b46978d537 gf 2022-02-16 04:15:17 +02:00
Aevann1 6411fe5829 sdf 2022-02-15 00:50:27 +02:00
Aevann1 03f1a106b4 dude subdramas lmao 2022-02-10 22:35:16 +02:00
Aevann1 5ade054494 sd 2022-02-04 10:59:12 +02:00
Aevann1 e54d85c056 zxc 2022-01-28 20:33:49 +02:00
Aevann1 d0f3ae65e5 sfd 2022-01-07 23:03:14 +02:00
Aevann1 d2a6691c24 fd 2022-01-06 03:24:03 +02:00
Aevann1 00e5e1c048 fsd 2022-01-02 02:06:46 +02:00
Aevann1 19bacd8357 pins logic rework 2021-12-26 03:03:21 +02:00
Aevann1 daf790e150 fsdsfd 2021-12-17 19:55:11 +02:00
Aevann1 64bdb679bd sfdfsd 2021-12-05 20:52:03 +02:00
Aevann1 31e4214620 dfssdf 2021-11-30 20:22:31 +02:00
Aevann1 d686b53c4e dfsfds 2021-11-23 01:25:33 +02:00
Aevann1 8a49ee0dc3 gffg 2021-11-16 00:13:29 +02:00
Aevann1 9e449dd8b0 redundant 2021-11-06 17:52:48 +02:00
Aevann1 0ed1212131 dfsf 2021-11-06 02:33:32 +02:00
Aevann1 df7dd13c61 fse 2021-11-02 13:54:04 -07:00
Aevann1 83dcd2b198 fds 2021-11-02 13:33:36 -07:00
Aevann1 efa408ab2c fd 2021-10-15 16:08:27 +02:00
Aevann1 e69dbd0ed1 gdfsd 2021-10-08 04:14:54 +02:00
Aevann1 f3b24c948c df 2021-10-02 21:07:30 +02:00
Aevann1 9fe1b0bda6 dfssfd 2021-10-02 13:34:37 +02:00
Aevann1 47a0acab80 hfghf 2021-09-30 21:40:33 +02:00
Aevann1 79e6356b29 dfs 2021-09-28 21:45:17 +02:00
Aevann1 e613f7864f fgg4 2021-09-28 21:39:51 +02:00