Dear Ejabberd 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.
The table 'last_activity' is
The table 'last_activity' is used by mod_last. This module implements the protocol . Its purpose is to remember when did the user disconnect for the last time, and if they set a status message when disconnecting.
As explained in the protocol: 'the element MAY contain XML character data that specifies the status message of the last unavailable presence received from the user.'