<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Hi,</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">At this point in the code the call is already prepaid since the account has been found with the query:</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><span style="font-family: monospace; font-size: 12px; white-space: pre;">$query=sprintf("select * from %s where account = '%s'",addslashes($this->prepaid_table),addslashes($CDR->BillingPartyId));</span></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><span style="font-family: monospace; font-size: 12px; white-space: pre;"><br></span></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Normally if the normalized number starts with a 0 it is routed to PSTN, what in most cases has a price. If a number resolves over ENUM, the Normalized URI would not start with a 0, but will be a sip account. </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">This is just a convention we made and therefore you also should not have accounts starting with a 0</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div> <div id="bloop_sign_1412013809499613952" class="bloop_sign"><span style="font-family:helvetica,arial;font-size:13px"></span>-- <br>Tijmen de Mes<br>AG-Projects</div> <div style="color:black"><br>From: <span style="color:black">Pavel Eremin</span> <a href="mailto:eremina.net@gmail.com"><eremina.net@gmail.com></a><br>Reply: <span style="color:black">OpenSIPS users mailling list</span> <a href="mailto:users@lists.opensips.org"><users@lists.opensips.org>></a><br>Date: <span style="color:black">29 september 2014 at 18:30:00</span><br>To: <span style="color:black">OpenSIPS users mailling list</span> <a href="mailto:users@lists.opensips.org"><users@lists.opensips.org>></a><br>Subject: <span style="color:black"> Re: [OpenSIPS-Users] CDRtool <br></span></div><br> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>
<title></title>
<div dir="ltr">This code in rating.php...</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2014-09-29 22:18 GMT+06:00 Pavel Eremin
<span dir="ltr"><<a href="mailto:eremina.net@gmail.com" target="_blank">eremina.net@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hi, All! Let's dance with CDRTool
<div><br></div>
<div>I am trying to use it on heavy load system and get
stack.</div>
<div><br></div>
<div>Why in this code author match canonical number with string
started by 0?(in hard way) Because of this line all calls are
postpaid...:(</div>
<div><br></div>
<div>
<div> <b>if
(!preg_match("/^0[9-0]{1,}@/",$CDR->CanonicalURINormalized))</b>
{</div>
<div>
$log=sprintf ("MaxSessionTime=unlimited Type=prepaid CallId=%s
BillingParty=%s
DestId=None",$NetFields['callid'],$CDR->BillingPartyId);</div>
<div>
syslog(LOG_NOTICE, $log);</div>
<div>
$this->logRuntime();</div>
<div>
$ret="none"."\n"."type=prepaid";</div>
<div> return
$ret;</div>
<div> } else {</div>
<div> if
(!$CDR->DestinationId) {</div>
<div>
$log = sprintf ("error: cannot figure out the destination id
for %s",$CDR->CanonicalURI);</div>
<div>
$this->logRuntime();</div>
<div>
syslog(LOG_NOTICE, $log);</div>
<div>
$ret=$log."\n"."type=prepaid";</div>
<div>
return $ret;</div>
<div>
}</div>
<div> }</div>
</div>
<div><br></div>
</div>
</blockquote>
</div>
<br></div>
_______________________________________________
<br>Users mailing list
<br>Users@lists.opensips.org
<br>http://lists.opensips.org/cgi-bin/mailman/listinfo/users
<br></div></div></span></blockquote></body></html>