Half-fix.

institution when there's only one available, rather than requesting

available institution (most likely 'mahara' but not guaranteed)

This allows messages to appear to be from a given user instead of from the system itself.

Also add a flag for activity types to choose whether this means exposing the user's email address. Contact Us implements this and shows the address while forum posts hide the address.

This is a much better logical split. Though the whole system is still roundly indecipherable :)

As per suggestion from Craig Eves.

permitting the public twice, allowing two time regions that overlap)

The cause of a lot of complaints on mahara.org! Now done properly.

Also, fixed up the keys on the subscription tables. The primary keys were missing. It looks like mahara.org has duplicate data somehow, so the upgrade path cleans that up.

Paid for thanks to Flexible Learning.

Now Mahara will actually crash and burn if the database isn't UTF8, rather than just bitching about it.

It's time we put an end to the madness.

More to the point, add in an unsubscribe link that will eventually allow them to unsubscribe even if they're logged out.

Allow notifications to override the message contents for email notifications entirely if they choose.