Turns out my original query was dumb, though perfectly legal SQL. MySQL
couldn't handle the 'dumb' which is kinda surprising but there you go.

generation.

Institutions are strings, not numbers. Should've picked this up before.

one.

copy_artefacts_allowed.

copy_artefacts_allowed is unnecessary as it's only called if the copy
type is 'full', and there's now no way that you would want to fully
copy a block and not copy the artefacts inside it.

Some other API tidyups have been done - default_artefact_config has been
renamed to rewrite_blockinstance_config and had a method signature
change to be a bit more flexible.

The copyconfig field of the View object is gone too, no longer required.

artefact plugin.

It now uses the fileid column of the artefact_file_files table in
appropriate places, especially important when a profile icon is in a
copied view.

It also reuses the image artefact's render_self method.

The image not being a link has proved to be quite annoying.

because their file quota has been exceeded.

View.

This means that blog/profile/resume blocktypes don't show up in
group/institution/site Views.

This is controlled through a new Blocktype method - allowed_in_view.
Various code had to be changed to listen to this method, mostly around
the display of the category browser.

When making a template, all blocktypes are available.

Part 3 is to change the configuration forms to be more sensible when
editing a template, and then testing what happens when blocktypes are
rendered somewhere that they "shouldn't" be - e.g. a My Friends block in
a group View.

of 'user', to match the database schema.

View::create_from_template

User class.

copied by everyone.

It now is ordered a bit more sensibly. Improved help and description
text on the page. Added a button to allow admins to delete users.
Improved the suspension/unsuspension process.

Darkened the colour of it a bit too.

It now covers everything, although this includes images that are in the
View in other blocks too.

Also fixed a bug where scrolling the page would mean the overlay didn't
cover the new part of the page that was in view.

[UPSTREAM] Only subscribe members to newly created forums if the forum has been marked as an auto-subscribe forum.