How to get a list of users sorted by custom critieria

Openfire Openfire Dev
1
  1. Which XMPP protocol should I use to fetch a list of all users (not just friends/buddies) sorted by a dynamic. These are some scenarios:

a. How to fetch a list of all server users sorted by their last logoff time ?

b. How to fetch a list of all server users sorted by shortest distance from client’s current geolocation ?

c. How to fetch a list of some, say first 100 users, which are online AND closest from the client’s current geolocation ?

  1. I want to issue xmpp server calls even when the client user is logged in as a guest and regardless he has or hasn’t any buddies/friends.

  2. Which XMPP protocol has a support for storing a users’s favorite movies, hobbies, etc ?

  3. If I want to integrate my custom MySQL database tables with openfire’s database, how am I supposed to do that ?

  4. If I want to extend xmpp, should I write my custom code in my favorite server language and integrate xmpp somehow or should I write an xmpp server extension and using my own db within this extension ?

  5. If I want to write a custom admin interface which is a small subset of openfire admin console, can I write in my favorite language or do I have to write this frontend in JAVA to access xmpp stuff ?