Affiliation based conversation log

Hello,

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?

Thank you!

Best Regards

Hi,

you may want to write your own monitoring plugin using the Openfire API to log or store the things you need. Modifying the default tables is a bad idea as this may break Openfire updates.

LG

Hy,

I guess that would be a solution. Thanks.

Is it a good idea to use the Monitoring Service plugin to develop and change it further for my requirements?

I read the plugin developer guide but i didn’t find the information i searched for…

I tried to look into the source code of the monitorin service plugin to get a first impression about accessing and writing into a DB but I didn’t find or was not able to see the source code.

Is the source code within the lib folder with the filename.jar.pack files? How could I look into the source code?

Hi,

you can download the source code here: http://www.igniterealtime.org/downloads/source.jsp or use SVN http://www.igniterealtime.org/fisheye/viewrep/svn-org/openfire

Take also a look at http://www.igniterealtime.org/community/docs/DOC-1020 or http://www.igniterealtime.org/community/docs/DOC-1022 to setup your development environment.

In http://www.igniterealtime.org/community/docs/DOC-1041 you’ll find some more plugins, they usually include the source code.

I did not look at the source code of the plugins so I can’t recommend one or the other to extend.

LG