Dear Support Team,

We are using ejabberd-1.1.4 as IM Server. we have given odbc support to that server from MySql database.

When ever any user login, that corresponding user entry of seconds field is changed in last table. How ever that state field in last table couldn’t changed when ever that corresponding user changes his/her status ( off-line to on-line, busy etc., and vice versa). it always shows empty value in that state field of that last table.

Can any one help on this issue??

Thanks in advance,
Satya.

Hello,
This forum is dedicated to module development.
Regarding your question: the last table store the date when the user was unavailable. The state is the content of the status tag when the user left the server (if any).
The last table does not store the state of the users online. This state is only stored in memory.

Thank you for your clarification.

We have one more Question. Regards presence information of User?

Can your any one tell me where should ejabberd server maintenance presence information (like Available, Busy, Away. etc.,) of particular user??

On Which table the ejabberd server stores presence information of particular user??

Thanks in Advance
Satya.

The states of the users is not maintened in database but in memory for performance reason.