Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Tue Nov 19, 2019 8:30 pm
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Unknown and non-numeric Caller-ID
PostPosted: Sun Dec 03, 2006 12:57 pm 
Offline

Joined: Sun Dec 03, 2006 10:40 am
Posts: 10
I'm running asterisk2billing v1.2.3 on PostgreSQL-8.1

I noticed that (in case of Unknown and non-numeric Caller-ID) the query is somewhat like

INSERT .... (...src...) values (...,Unknown,...)

as src field is "text" it should be included within single quotes, so I suggest the following patch (after appliyng that patch everything is Ok with Unknown Caller-IDs):

available also at http://voip-trade.net/patch1.txt

--- trunk/A2Billing_AGI/libs_a2billing/Class.A2Billing.php.orig 2006-12-03 12:48:46.000000000 +0000
+++ trunk/A2Billing_AGI/libs_a2billing/Class.A2Billing.php 2006-12-03 12:50:01.000000000 +0000
@@ -937,7 +937,7 @@
$QUERY .= " CURRENT_TIMESTAMP - INTERVAL $answeredtime SECOND ";
}
$QUERY .= ", '$answeredtime', '".$inst_listdestination[4]."', '$dialstatus', now(), '0', '0', ".
- " '".$this->countrycode."', '".$this->subcode."', 'DID CALL', '0', '0', '0', '0', $this->CallerID, '3' )";
+ " '".$this->countrycode."', '".$this->subcode."', 'DID CALL', '0', '0', '0', '0', '$this->CallerID', '3' )";
if ($this->agiconfig['debug']>=1) $agi->verbose('line:'.__LINE__.' - '.$QUERY);
$this -> write_log("[DID CALL - LOG CC_CALL: SQL: $QUERY]");
$result = $this -> instance_table -> SQLExec ($this->DBHandle, $QUERY, 0);


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 04, 2006 12:42 am 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
That sounds like an important patch.
Thx, Areski


Top
 Profile  
 
 Post subject: Similar problem with unknown callerID
PostPosted: Fri Dec 15, 2006 10:10 pm 
Offline

Joined: Tue Nov 21, 2006 7:01 pm
Posts: 19
Can you tell me what the symptoms were when you used a blank callerid, before applying the patch? I am having trouble when receiving a call where the callerid is blank, the system disconnects the caller immediately after they choose a language. I don't know if the SQL query executes before the hang up or not, but I don't see it in the logs. Have a look at my post on this matter and please comment if you can shed any additional light on it.

http://forum.asterisk2billing.org/viewt ... =4091#4091

Thanks

Tim


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 
Hosted Voice Broadcast


All times are UTC


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group