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