Multiple Community Admins with Matrix/Riot

Sometimes you want that another person can administrate the matrix communities. With Riot it is not possible so we need a hacky way to fix this.

All community members can be listed using:

SELECT * FROM group_users;

Start a transaction and set a user as admin in a certain community:

BEGIN;
UPDATE group_users SET is_admin='t' WHERE group_id='+community:domain.com' AND user_id='@user:domain.com';

Make sure that only one row is updated. You should see UPDATE 1. You could also list the community members again to see the result. If everything is correct, commit the change:

COMMIT;

If something went wrong just rollback the changes:

ROLLBACK;

Voìla, now you can create as many admins as you like.