Thanks for your reply. I found that it's only update after around 30 seconds. Is there anyway that I can fasten the update on the database? Thanks. Cheers, Roa Yu -----Original Message----- From: SIP [mailto:sip@arcdiv.com] Sent: Tuesday, October 09, 2007 9:14 PM To: roayu Cc: serusers(a)lists.iptel.org Subject: Re: [Serusers] Get RealTime Online Users status roayu wrote: The location table in the MySQL database stores what are, in effect, currently online users. It is, however, only an approximation. When a UA registers, it sends an expiration time on its registration and that gets stored in the location table. If the user disconnects without cancelling his registration (some UAs send am expire register message to 'log out' and some don't), then the data may still be in the table until the expire time occurs. Realistically, though, you can get a good idea of currenly online users using the location table and while it may not be 100% accurate, it's close enough for government work, as it were. N.