(Update) Make tabs alpine component csp-safe

These values are written, but never read.

(Remove) Unused chatbox variables

The optional parameters always use the default, so remove the branches that are never reached and simplify the code.

(Fix) Censor changing case of censored words

…arameters

(Remove) Unused parameters in chat repository

This functionality never worked. It first takes n messages in `messages()`, then counts the number of messages, then compares the count to n, then deletes every message that has an index lower than count minus n. But, because the count is always equal or lower than n, no messages are ever deleted. Because this feature has existed for so long as is, it would probably scare people if it started deleting data. So, let's remove its unused usecase instead.

(Remove) Unused chatbox auto deleting message limits

(Update) Make various inline alpinejs components csp-safe

fixes #5169

Remove title casing, change verb tense and other adjustments.

(Fix) Return error if meta not found when adding wishlist entry

Typo. Every other query that searches for this is correct. Align this query to match the others.

…ghlight

(Fix) Torrent completed highlight on torrent search page

(Update) Improve notification wording

Personal freeleeches would otherwise show on the site as expired if the cache was empty, even if the value was in the database.

Lots of weird things here that never worked. I couldn't test out this patch, but it makes a lot more sense logically. Blur/focus don't do anything since it's not an interactive element. The audible status was never checked before playing the sound. In the vue.js version, the audio attribute was checked before playing the sound. I chose to use css to check the focus-within status before playing the sound instead (Prefer simplifying writes over reads).

Manual chunking speeds it up overall by 3x, and also distributes the query across many 50ms queries. Manual chunking is needed over `->chunkById()` because we have to pass the range to both an inner query and an outer query. Chunking would only allow passing the range to one of the queries.

(Security) Fix cors on api routes

(Refactor) Use `#[\Override]` attribute when overriding methods

(Fix) Read only database regex

Often, tmdb merges different people, and the credits have their id updated to the deduplicated person, but the dupe person is still in the database undeleted. Delete these orphaned people daily.

(Fix) Distributor deletion messsage

(Refactor) Cruddify and use form requests for report submissions

(Fix) Delete orphaned people

(Add) Config for minimum request bounty

Also `use`d `CursorPaginator` and `LengthAwarePaginator` to shorten the length of some lines.

(Update) Phpstan and extensions

And use the HTTP method instead.

(Fix) Exclude missing media without torrents or requests

(Refactor) Remove `/store`, `/update`, `/destroy` routes

This optimization only makes sense if trying to reduce the dataset before a large join and where user_id isn't indexed.

Keeps the db performance efficient while keeping each job on the queue small enough to not time out.

(Update) Use batches of 50 to update title credits

The warnings.torrent column was renamed to torrent_id (migration
2025_11_08_094209_rename_warnings_torrent_to_torrent_id), but WarningFactory
still writes to the old column name, so any test using the factory fails
with an unknown-column error.

…nt-id

(Fix) Use torrent_id in WarningFactory

(Remove) Unused optimization

The room was being changed by fetchrooms but the conversation wasn't. Only start the watchers after all the initially loaded data has been fetched.

Tabs should be sorted with rooms first, followed by dms, followed by bots. Regression from #5335.

…n-load

(Fix) Chatbox initial conversation loading

(Fix) Chat conversation tab sort order

This is needed now that person fetching is separate from movie/tv fetching.

(Add) Custom meta not found exception to person fetching