* Apply Rubocop Rails/WhereNot

* Update spec for where.not

* Autofix Rails/EagerEvaluationLogMessage

* Update spec for debug block syntax

* Add tests

* Fix account activation being triggered before email confirmation

Fixes #23098

* Fix ・ detection in hashtag regex to construct hashtag correctly

* Fixed rubocop liniting issues

* More rubocop linting fix

* Add requested_by to relationship maps

* Display whether an account has requested to follow you on their profile

* Save avatar or header correctly if other one fails

* Fix test

* Fix 500 error when trying to migrate to an invalid address

* Add tests

* Don't allow URLs that contain non-normalized paths to be verified

This stops things like https://example.com/otheruser/../realuser where
"/otheruser" appears to be the verified URL, but the actual URL being
verified is "/realuser" due to the "/../".

Also fix a test to use 'https', so it is testing the right thing, now
that since #20304 https is required.

* missing do

Fix #19156

* Test blank account field verifiability

This change tests the need for #20428, which ensures that we guard against a situation in which `at_xpath` returns `nil`.

* Test verifiability of blank fields for remote account profiles

This adds a counterpart test for remote account profiles' fields' verifiability when those fields are blank. I previously added the same test for local accounts.

Fix #3833

- Change verification to happen in `default` queue
- Change verification worker to only be queued if there's something to do
- Add `link` tags from metadata fields to page header of profiles

Found via `codespell -q 3 -S ./yarn.lock,./CHANGELOG.md,./AUTHORS.md,./config/locales,./app/javascript/mastodon/locales -L ba,followings,keypair,medias,pattens,pixelx,rememberable,ro,te`

In the absence of an opt-in to multiple specific languages in the
preferences, it makes more sense to filter by the user's presumed
language only (interface language or `lang` override)

* Change how hashtags are normalized

* Fix tests

* Add customizable user roles

* Various fixes and improvements

* Add migration for old settings and fix tootctl role management