The application is good and Works well with MS SQL server… also Found that video or Voice jingle is missing in the Client… THough voice is working properly with other clients lie one team on openfire server.
Issue is that the Database structure and the program is not ID based and is purely on username… It is suggested that codes are user table contains userid (numric ) auto… This helps having users having same logon name in organsation as username password and email ID combination can be used to recognise the user. This helps integrating the server with other Applications for the organisations.
Hope this change can be brought in the new version of open fire. Also Found that jabbar id is username@defaultdomain why cant it be email id provided by the user. so that server can be integrated with hosted apps.