[OpenSIPS-Users] AVP on local route

[M.Khaled W Chehab]

Hi,

 

The   execution for the avp_db_query is not working fine  in local route
after the  acc_db_request  ,

 

As I print the query using xlog(" and   insert t it to myql ,the query
executed normally which means I have no problem in the mysql query  .

 

My question: how can update the record in the acc table  after
acc_db_request("200 Dialog Timeout", "

 

 

local_route {

            if (is_method("BYE")  && $DLG_dir=="UPSTREAM") {

                         xlog("L_INFO", "--Debug Customer
ID:$avp(Cusid)/IP:$si---------Reply:
$T_reply_code------Source:$rd\nDialed:$fU\n:");

 

                        acc_db_request("200 Dialog Timeout", "acc");

 

avp_db_query("UPDATE `opensips`.`acc` SET `pdd`='$var(pdd)' WHERE `CALLID`
='$ci' and `method`='INVITE'" );

 

 

BTW: I cant find the acc record for the call unless  the call  ended ,and in
my case I set the  acc_db_request("200 Dialog Timeout  then call
avp_db_query(   is  that should insert the call in the acc to update it
later 

 

Regards

,.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130603/c7d313e4/attachment.htm>