Automatically update room permissions from SQL

Hi all,

I’m trying to get full external database integration on my OF server and I have some problems.

Currently I have a cron script that writes into the external database every hour with user data. If this data changes the changes are not reflected on the server itself until it is restarted.

For example if a user goes inactive they are placed in an inactive group. However even though the database shows them in the inactive group they remain in the active members group which is obviously undesirable.

Is there a way to get OF to “reload” the user data from the database say once an hour ?

Also is there a way to assign chat room membership ( room members user permissions ) based on the group that a user is in or will I have to manually add each user to the rooms ?