I’m currently working on a moderated Chat. I have 4 roles… Admin, Moderator, VIP and Participant.
I allready store a xml log file out of the OfMucConversationLog Table.
Instead of a conversation log I want to have a more an event based log… which means I want to store the role of the user who sent the message. The problem, I don’t kno how to do.
The Table OfMucAffiliation doesn’t help much because it just distinguishes between admin or not admin.
Did I may overlooked something helpful in the database schema?
An idea is to add a column to the OfMucConversation Table like “role”. So that evertime the message gets send it also stores the role of the user.
Adding a table is not the problem but is there any possibility to change and influence what openfire automatically stores into the DB?
If yes, how could I do this?