[Users] Help with MySQL acc query

Mon Oct 31 11:48:48 CET 2005

Hello

On 10/31/05 00:27, Daryl Sanders wrote:
> I'm trying to come up with a query on the acc table that will return
> all INVITES that don't have a matching BYE. I'm basically looking for
> sessions that are currently open.
>   
You have to check that there is no BYE with same call-id, To and From 
tags as the INVITE. Since the BYE may be sent by any of the parties in 
the call, you have to do a cross check of the tags, too.

Daniel
> - Daryl
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>