<br><font size=2 face="sans-serif">I'm not completely following you. Is
has_to_tag() a regular command, and which module is it in?</font>
<br><font size=2 face="sans-serif">thanks</font>
<br>
<br><font size=2 face="sans-serif">Jon</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>Klaus Darilion <klaus.mailinglists@pernau.at></b></font>
<p><font size=1 face="sans-serif">05/27/2004 05:41 AM</font>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To:
jon@bostontech.com</font>
<br><font size=1 face="sans-serif"> cc:
serusers@lists.iptel.org</font>
<br><font size=1 face="sans-serif"> Fax
to: </font>
<br><font size=1 face="sans-serif"> Subject:
Re: [Serusers] Call Accounting - multiple
INVITE entries</font></table>
<br>
<br>
<br><font size=2><tt>You can check if the message has a to-tag has_to_tag()
und in that case: <br>
don't set the acc flag.<br>
<br>
klaus<br>
<br>
jon@bostontech.com wrote:<br>
> <br>
> I am running ser 0.8.12 (on RedHat 9) and have it set up to log all
<br>
> invite and bye messages, so that I can use the accounting feature
in <br>
> SerWeb. It's logging fine.<br>
> My problem is that if there are multiple invites and only one bye
during <br>
> a session, I get multiple entries in SerWeb with the same sip_callid.
I <br>
> noticed that this happens when the hold feature is used with the XTen
<br>
> soft phone.<br>
> Is there any way I can avoid logging these subsequent INVITE messages
or <br>
> stop from displaying them in the call log on SerWeb?<br>
> <br>
> <br>
> My accounting routine:<br>
> <br>
> modparam("acc", "log_level",1)<br>
> modparam("acc", "db_flag", 1)<br>
> if ((method=="INVITE") || (method=="BYE")) {<br>
> setflag (1);<br>
> };<br>
> <br>
> <br>
> Serweb $q call to MySQL (4.0.18) db:<br>
> <br>
> $q="select t1.to_uri, t1.from_uri, t1.sip_callid, t1.time, ".<br>
> "t1.fromtag as invft, t2.fromtag
as byeft, t2.totag as byett, ".<br>
> "sec_to_time(unix_timestamp(t2.time)-unix_timestamp(t1.time))
".<br>
> "as length
".<br>
> "from ".$config->table_accounting."
t1, ".<br>
> $config->table_accounting.
" t2 ".<br>
> "where t1.domain='".$config->realm."'
and ".<br>
> "t1.sip_callid=t2.sip_callid
and ".<br>
> "t1.sip_method='INVITE'
and t2.sip_method='BYE'".<br>
> "order by t1.time desc";<br>
> <br>
> <br>
> <br>
> Thanks<br>
> -Jon B<br>
> <br>
> <br>
> ------------------------------------------------------------------------<br>
> <br>
> _______________________________________________<br>
> Serusers mailing list<br>
> serusers@lists.iptel.org<br>
> http://lists.iptel.org/mailman/listinfo/serusers<br>
</tt></font>
<br>