Commit Graph

518 Commits

Author SHA1 Message Date
Earlopain
465c5b31c2
[DB] Make timestamps "not null"
This changes most, but not all. The remaining ones have nulls on prod
and must first be cleaned up.
2023-03-12 12:36:14 +01:00
Earlopain
257e717e56
[README] Document windows executable bit issues
This also adds/removes +x on a few files which should/shouldn't have it.
2023-03-04 14:20:39 +01:00
Earlopain
fbf33f7d29
[DB] Remove test_parser extension
Usage has been removed in 5215876862 and pr #476
2023-02-26 16:41:02 +01:00
Earlopain
478941aecb
[Cleanup] Remove old migrations/fixer scripts
These files are useless and account for more than 1000 rubocop offences.
Move the remaining fixer scripts to the db folder, the scripts folder
is empty otherwise.
2023-02-22 20:12:20 +01:00
Earlopain
ba0f9872c3
[DB] Drop dedicated index columns and their triggers
Their usage was removed in 5215876862
2023-02-22 19:37:13 +01:00
Earlopain
1600ecdf77
[Mascots] Drop safe_mode_only column
Replaced in b58707fab2
2023-02-22 19:37:10 +01:00
Earlopain
5215876862
[DB] Remove usage of dedicated index columns
The index for posts is also getting added, but will get used at a later date
If this turns out to work fine the materialized index colums can be dropped

This contains a semantic change where dmail and wiki page searches for the body
no longer includes matches for the title
2023-02-19 20:01:54 +01:00
Earlopain
8632aefb92
[DB] Fix accidental changes from a24bfeed69 2023-02-17 21:32:50 +01:00
Earlopain
a2c4f4f4a5
[DB] Remove some dev/prod differences 2023-02-10 10:39:41 +01:00
Earlopain
b58707fab2
[Mascots] More granular control on which site they appear
Previously it was only possible to exclude them from e9.
This allows mascots exclusive to e6 as well.
2023-02-03 18:11:17 +01:00
Earlopain
a24bfeed69
[DB] Update strucutre dump to what postgres gives us
This change appears every time a migration is done. It's beyond me why I
haven't commited that yet.
2023-02-03 18:00:42 +01:00
Earlopain
cc2a395b37
[Docker] Add seeding for mascots
Will only work after deploy, because of the added field in the API response
2022-10-20 18:52:07 +02:00
Earlopain
0de7135df9
[Docker] Clean up seeding script 2022-10-20 18:39:45 +02:00
Earlopain
c46e1f5fd9
[Mascots] Add option to restrict to e926 2022-10-16 18:37:12 +02:00
Earlopain
b5fbc1e2eb
[Home] Add dynamic mascots 2022-10-15 21:40:40 +02:00
Earlopain
d10607b033
[DB] Make some fields not null
This was already the case in the production database. Also contains a few
other small changes to bring the two more in line.
2022-08-14 21:38:09 +02:00
Earlopain
7e33ea8271
[Cleanup] Remove pool is_deleted
Pools are hard-deleted now. There are also a few pools with this flag
which can't be properly deleted at the moment
2022-07-11 22:52:26 +02:00
Earlopain
93cd28c0e1
[Posts] Change comment locked to disabled
Instead of just preventing new comments hide everything completly.
2022-05-16 15:53:39 +02:00
Earlopain
6d3f272e90
[Posts] Allow locking comment sections 2022-05-16 14:20:11 +02:00
Earlopain
3de690961d
[Cleanup] Remove unused gems and tables/columns 2022-04-07 19:17:33 +02:00
Earlopain
7a65ccdb5a
[Cleanup] Remove dead seeder script 2022-04-05 18:54:02 +02:00
Earlopain
b37bb3c001
[Cleanup] Remove remaining delayed jobs code 2022-03-05 16:09:28 +01:00
Earlopain
a09058f2cf
[Users] Add default to user about/artinfo
This fixes generating modactions for users who have never edited their profile
when an admin does so, since the value changed from null to the empty string
2022-02-20 11:20:26 +01:00
Earlopain
e9f7ac85bf
[Cleanup] Remove artist commentaries 2022-02-03 17:02:49 +01:00
Earlopain
ea28ab906b
[Posts] Add events for status/note lock 2022-01-06 13:54:40 +01:00
Earlopain
aa77f1a76a
[Posts] Save post events in separate table
Part of  #346
2022-01-06 13:44:30 +01:00
Earlopain
d13dc9cad4
[Docker] Set the posts to seed amount through env
Most of the time I don't need 100, especially when I'm `down -v` constantly.
This is a switch to easily lower that.
2022-01-05 13:44:36 +01:00
Earlopain
00958d5602
[PostReplacements] Mark new fields has hidden 2021-10-18 17:53:07 +02:00
Earlopain
da96e16fd6
[Replacements] Record original uploader
Add a link to users profile to search for their replaced posts and give
janitors the option to penalize the user when appropriate
2021-06-26 13:01:26 +02:00
Earlopain
2f3ac660d1
[ModActions] Remove category and description
category was not maintained at all and would fallback to 2000, it was
also not exposed in any way.
Same for description, it's always null
2021-07-18 19:33:37 +02:00
Earlopain
eb1f432fc5
Merge branch 'master' into style-changes 2021-06-02 14:28:22 +02:00
Earlopain
a023c2806e
[Tests] Fix forum post/topic tests 2021-05-14 15:04:03 +02:00
Kira
b3eb88405d [Staff Notes] Add staff notes 2021-05-12 21:57:12 -07:00
Earlopain
ed8a25b8a5
[Seeding] Add post approve flag to admin/system user 2021-05-01 13:24:20 +02:00
Earlopain
2a15947696
[Seeding] Fix uploader not being set
This broke seeding altogether, introduced in a28466bd
2021-04-30 23:50:22 +02:00
Earlopain
4b27ebb6f9
[Seeding] Fix system user not being promoted 2021-04-30 23:46:28 +02:00
Zwagoth
36130433f1
Merge pull request #254 from Earlopain/initial-setup
Improve initial vagrant setup
2021-04-30 14:46:46 -04:00
Kira
5843282986 [DB] Add missing indexes to large tables
The favorites table was missing the user_id column in prod
The post_votes table was missing the user_id column in prod
The comments table was missing the creator_id column in prod

The remaining indexes existed in prod, but not in the dev schema.
2021-04-24 19:13:36 -07:00
Kira
dff34d0f13 Merge branch 'user_warned' 2021-04-16 15:39:51 -07:00
Kira
1feee5e9a5 [Admin] Allow marking content as having earned a user a warning/ban 2021-04-16 15:39:32 -07:00
Kira
a28466bdaf [Replacements] Continued progress
[Replacements] Fix exceptions when processing replacements

[Replacements] Fix handling of invalid file types

[Replacements] Fix error reporting and promote dupe checking

[Replacements] Prevent duplicate replacements from cropping up
2021-04-07 10:33:19 -07:00
Kira
3855d64228 Post replacement system 2021-04-07 10:33:18 -07:00
Earlopain
731d9c3e9d
[Seeding] Set correct tag categories and add sources/desc 2021-04-05 16:14:24 +02:00
Earlopain
d46deaaefc
[Seeding] Get post data from live site 2021-04-05 15:23:02 +02:00
Kira
814db91046 [Artists] Allow locking artist pages 2021-01-17 11:33:21 -08:00
Kira
ac34b6fe26 Fix bad post_replacement column names 2020-12-20 11:11:35 -08:00
Kira
a37a346817 Update drop post index migration 2020-12-20 10:49:47 -08:00
Kira
db44e102c2 Drop unused post indexes 2020-12-20 10:33:21 -08:00
Kira
01abcf5762 [Posts] Log destroyed post information 2020-11-13 00:35:33 -08:00
Kira
436d2aea38 [Ruby 3] Fix up some deprecations involving ruby 3
Still pending are gems that make poor choices and need to be removed,
replaced, or fixed up.

Memoist
ActiveModelSerializers
2020-11-11 21:06:12 -08:00
Kira
db8d4c4773 Normalize EOL style + newline at end of files. 2020-10-24 05:50:32 -07:00
Kira
46c72acb64 [Video] Add post sample storage 2020-10-17 22:35:28 -07:00
Kira
c35d272d1e Updated encode settings
Save space, save time, make it clear it's a sample
2020-10-17 22:35:28 -07:00
Kira
804903c67d [BUR] Improve some bur error reporting 2020-07-12 22:53:02 -07:00
Zwagoth
d7701a0033
Merge pull request #189 from Sasquire/seeder_fix
Fix issues with seeder script failing
2020-06-04 13:01:11 -04:00
Kira
81f8986877 Post image hash temp 2020-05-14 10:47:59 -07:00
Sasquire
8e355b6b89 Fix issues with seeder script failing
Fixes the problems described in issue 188
2020-03-04 17:00:04 -05:00
Kira
621df484f5 Clean up dead db tables 2020-01-12 18:41:07 -08:00
Kira
15923af4ba Add janitor selectable background color per image 2019-12-31 10:19:11 -08:00
Kira
32f0266481 Add wiki edit reason 2019-11-15 20:00:54 -08:00
Kira
df2c76226b Add link to artist note changes to history 2019-10-13 16:47:48 -07:00
Kira
f8b339b3b0 Add reason to post versions 2019-10-06 07:34:29 -07:00
Kira
d378887d25 Add tag relationship reason 2019-10-06 00:59:19 -07:00
Kira
fa4a51d81b Add tag alias undo support 2019-10-03 06:26:25 -07:00
Kira
5a133e1643 Add lore tag category 2019-09-24 17:04:46 -07:00
Kira
f5bf733c86 Fix email verification being a user level
Having a distinct level for user verification proved to be rather
problematic for code flow and introduced an extra level below
blocked. Since it makes the account unusable until activated
it made sense to use an extra field and stop messing with user
levels explicitly.

This should also make tests a lot easier to deal with because it
doesn't require any changing of the user level.
2019-09-23 16:16:45 -07:00
Kira
e074080ade Potentially fix vote cheating 2019-09-19 14:41:55 -07:00
Kira
bb9e30dc74 Remove user inviter system 2019-09-16 13:50:47 -07:00
Kira
55cb64acf7 Fix deprecated use of update_attributes 2019-09-09 12:58:18 -07:00
Kira
fffe6b1c19 Fix test fixtures and seeds 2019-09-09 12:58:18 -07:00
Kira
6127ea6d25 Initial comment hide vs delete distinction 2019-09-06 07:01:37 -07:00
Kira
532e2c1e04 Update to rails 6 2019-08-28 21:50:40 -07:00
Kira
834d837572 Minor fixes for sets pages. 2019-08-28 19:03:39 -07:00
Kira
4fe2e02fa4 Make user_id column unique on user_statuses 2019-08-27 15:44:23 -07:00
Kira
41e1a1a0f7 Add change_seq support 2019-08-15 07:34:11 -07:00
evazion
3a0c2fbdc2 Remove obsolete scripts.
These are mostly old files mostly related to maintenance of Danbooru 1
or the upgrade to Danbooru 2.
2019-08-10 04:45:49 -07:00
Kira
9721705b64 Add permabans, for those special individuals that need them 2019-08-10 00:22:34 -07:00
Kira
1861441100 Add post status below post on index pages 2019-08-03 19:00:58 -07:00
Kira
1d09ff5440 Clarify flags from deletions in the deletion/flag log 2019-08-01 14:49:58 -07:00
Kira
3b1ca778f9 Add seeds
Blatantly stolen from Liam.
2019-07-19 04:23:31 -07:00
Kira
e0f1d69ead Allow turning off throttles during testing 2019-07-19 03:48:16 -07:00
Kira
db8b3583ed Add missing description field
I'm mostly confused by why this worked in dev
2019-07-18 13:14:49 -07:00
Kira
4fb3c9fedb Add some cheap exception logging until something better is made 2019-07-17 14:40:03 -07:00
Kira
7b750ac862 Descriptions on posts 2019-07-14 06:24:52 -07:00
Kira
9fa294ba31 Convert gold -> privileged for user level 2019-06-29 08:45:58 -07:00
Kira
0715b0c251 Add species and invalid tag types 2019-06-23 00:27:33 -07:00
Kira
583cd7e20d Make password resets closer to old e6 password resets 2019-06-12 21:39:45 -07:00
Kira
d21e36073b Remove cached counters from user model and update references 2019-06-04 11:51:23 -07:00
Kira
621148b097 Update more stuff to go in the user status table. 2019-06-04 05:56:20 -07:00
Kira
05e4736bb5 User different table for cached counters
This does not make the required changes to redirect to these
new properties yet.
2019-06-02 07:49:38 -07:00
Kira
7aaa36282d Fix bad migration of pool versions 2019-05-21 22:39:08 -07:00
Kira
5d8494caac Replace post archive service with inline code 2019-05-10 16:08:08 -07:00
Kira
25f8222d2c Add avatar to user class
This also updates the supporting code to enable dumping deferred
post information to the page, which was partially broken in a
previous commit.
2019-04-30 06:50:43 -07:00
Kira
128428f879 Add user profile info
Possible improvements:
 - Lock commission information to users linked to artists.
   (Currently not implemented.)
2019-04-28 06:59:29 -07:00
Kira
06db14aceb Add simple versioning replacement
This replaces the old simple versioning helper that existed on
e621. The implementaiton is roughly the same but has been updated
to use newer rails methods.

No, it's not very flexible, but it didn't need to be.
2019-04-27 11:28:02 -07:00
Kira
8698bd4e39 Support for access locked forum categories 2019-04-21 20:32:11 -07:00
Kira
4673523607 Update storage of mod actions to json for potential search abilities 2019-04-14 02:34:04 -07:00
Kira
779f30b6bd Preliminary mod action decorator and structure 2019-04-14 02:30:01 -07:00
Kira
86adf1eea4 Add fix up post disapproval things after revert 2019-04-11 23:46:34 -04:00
Kira
44ab7b1a8c Comment votes and vote fixups and interface 2019-04-09 13:04:40 -07:00