I make sure the PHP was right now. with the pcntl extensions
and rebooted the server. Last night.
I am using asterisk 1.4.15
But here are 2 calls from same person this morning
on a call for more that 20 minutes,
and only charged her .015 cents on the second call.
Also note I have other people using the system and it appears to
be working for them, and counting the calls. and charging their account.
Sorry
==================
[18/12/2007 07:49:23]:[file:a2billing.php - line:76]:[CallerID:]:[CN:]:[IDCONFIG : 1]
[18/12/2007 07:49:23]:[file:a2billing.php - line:77]:[CallerID:]:[CN:]:[MODE : standard]
[18/12/2007 07:49:23]:[file:Class.A2Billing.php - line:616]:[CallerID:1112223333]:[CN:]:[ get_agi_request_parameter = 1112223333 ; SIP/l-274111-b7700468 ; 1197982162.13 ; ; 6782021111]
[18/12/2007 07:49:23]:[file:a2billing.php - line:139]:[CallerID:1112223333]:[CN:]:[[ANSWER CALL]]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:555]:[CallerID:1112223333]:[CN:]:[RES Menu Language DTMF : 1]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:581]:[CallerID:1112223333]:[CN:]:[[SET LANGUAGE() en]]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:1437]:[CallerID:1112223333]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:1112223333]]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:1438]:[CallerID:1112223333]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:1112223333]]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:1455]:[CallerID:1112223333]:[CN:]:[QUERY = SELECT cc_callerid.cid, cc_callerid.id_cc_card, cc_callerid.activated, cc_card.credit, cc_card.tariff, cc_card.activated, cc_card.inuse, cc_card.simultaccess, cc_card.typepaid, cc_card.creditlimit, cc_card.language, cc_card.username, removeinterprefix, cc_card.redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias FROM cc_callerid LEFT JOIN cc_card ON cc_callerid.id_cc_card=cc_card.id LEFT JOIN cc_tariffgroup ON cc_card.tariff=cc_tariffgroup.id WHERE cc_callerid.cid='1112223333'
RESULT : ]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:1514]:[CallerID:1112223333]:[CN:]:[[CID_CONTROL - STOP - NO CALLERID]]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:1625]:[CallerID:1112223333]:[CN:]:[ - Account code - ]
[18/12/2007 07:49:27]:[file:Class.A2Billing.php - line:1769]:[CallerID:1112223333]:[CN:]:[Requesting DTMF, CARDNUMBER_LENGTH_MAX 15]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:1771]:[CallerID:1112223333]:[CN:]:[RES DTMF : 1111105298]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:1775]:[CallerID:1112223333]:[CN:1111105298]:[CARDNUMBER ::> 1111105298]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:1798]:[CallerID:1112223333]:[CN:1111105298]:[QUERY = SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id, cc_card.id_campaign, cc_card.id, useralias FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id WHERE username='1111105298'
Array
(
[0] => Array
(
[0] => 12.00000
[credit] => 12.00000
[1] => 2
[tariff] => 2
[2] => t
[activated] => t
[3] => 0
[inuse] => 0
[4] => 0
[simultaccess] => 0
[5] => 0
[typepaid] => 0
[6] =>
[creditlimit] =>
[7] => en
[language] => en
[8] => 1
[removeinterprefix] => 1
[9] =>
[redial] =>
[10] => 0
[enableexpire] => 0
[11] => 1512928406
[UNIX_TIMESTAMP(expirationdate)] => 1512928406
[12] => 0
[expiredays] => 0
[13] => 0
[nbused] => 0
[14] => 0
[UNIX_TIMESTAMP(firstusedate)] => 0
[15] => 1197309295
[UNIX_TIMESTAMP(cc_card.creationdate)] => 1197309295
[16] => USD
[currency] => USD
[17] => Patino
[lastname] => Patino
[18] => Claudia
[firstname] => Claudia
[19] =>
[email] =>
[20] => 1111
[uipass] => 1111
[21] => 7
[id] => 7
[22] => -1
[id_campaign] => -1
[23] => 7
[24] => 4045799502
[useralias] => 4045799502
)
)
]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:1922]:[CallerID:1112223333]:[CN:1111105298]:[[NOT ADDING NEW CID IN CC_CALLERID : CID LIMIT]]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:649]:[CallerID:1112223333]:[CN:1111105298]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='1111105298']]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:1950]:[CallerID:1112223333]:[CN:1111105298]:[[A2Billing] SAY BALANCE : 12.00000
]
[18/12/2007 07:49:45]:[file:Class.A2Billing.php - line:1143]:[CallerID:1112223333]:[CN:1111105298]:[[CURRENCY : USD]]
[18/12/2007 07:49:48]:[file:a2billing.php - line:156]:[CallerID:1112223333]:[CN:1111105298]:[[TRY : callingcard_ivr_authenticate]]
[18/12/2007 07:49:48]:[file:Class.A2Billing.php - line:1399]:[CallerID:1112223333]:[CN:1111105298]:[[AUTO SetCallerID]]
[18/12/2007 07:49:48]:[file:Class.A2Billing.php - line:1405]:[CallerID:1112223333]:[CN:1111105298]:[[REQUESTED SetCallerID : 1112223333]]
[18/12/2007 07:49:48]:[file:Class.A2Billing.php - line:1416]:[CallerID:1112223333]:[CN:1111105298]:[[EXEC SetCallerID : 1112223333]]
[18/12/2007 07:49:48]:[file:a2billing.php - line:170]:[CallerID:1112223333]:[CN:1111105298]:[[CHANNEL STATUS : 6 = Line is up]]
[18/12/2007 07:49:48]:[file:a2billing.php - line:171]:[CallerID:1112223333]:[CN:1111105298]:[[CREDIT : 12.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[18/12/2007 07:49:58]:[file:a2billing.php - line:241]:[CallerID:1112223333]:[CN:1111105298]:[RES REFILL CARD VOUCHER DTMF : ]
[18/12/2007 07:49:58]:[file:Class.A2Billing.php - line:671]:[CallerID:1112223333]:[CN:1111105298]:[ && && 10&& 0]
[18/12/2007 07:50:08]:[file:Class.A2Billing.php - line:678]:[CallerID:1112223333]:[CN:1111105298]:[RES DTMF : 0115777211111]
[18/12/2007 07:50:08]:[file:Class.A2Billing.php - line:696]:[CallerID:1112223333]:[CN:1111105298]:[DESTINATION ::> 0115777211111]
[18/12/2007 07:50:08]:[file:Class.A2Billing.php - line:698]:[CallerID:1112223333]:[CN:1111105298]:[RULES APPLY ON DESTINATION ::> 5777211111]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:73]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: (2, 5777211111)]]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:122]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: CALLERID]
1112223333
]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:136]:[CallerID:1112223333]:[CN:1111105298]:[[CALLERID_QUERY]
SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=2 WHERE calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix))
[RESULT]Array
(
[0] => Array
(
[0] => 0
[count(calleridprefix)] => 0
)
)
]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:182]:[CallerID:1112223333]:[CN:1111105298]:[[RATE ENGINE QUERY]
SELECT tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination,
cc_ratecard.id, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock,
connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb,
timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc,
cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,
tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,
cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,
rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix,
musiconhold,
tp_trunk.failover_trunk AS tp_failover_trunk,
rt_trunk.failover_trunk AS rt_failover_trunk,
tp_trunk.addparameter AS tp_addparameter_trunk,
rt_trunk.addparameter AS rt_addparameter_trunk,
id_outbound_cidgroup,
freetimetocall_package_offer, freetimetocall, packagetype, billingtype, startday, id_cc_package_offer
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=2
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer
WHERE (dialprefix=SUBSTRING('5777211111',1,length(dialprefix)) OR dialprefix='defaultprefix')
AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5)
AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5)
AND (starttime <= 1910 AND endtime >=1910)
AND idtariffgroup='2'
AND ( dnidprefix=SUBSTRING('6782021111',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0))
AND ( calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:192]:[CallerID:1112223333]:[CN:1111105298]:[[rate-engine: Count Total result 2]]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:281]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: Count Total result 2]]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:282]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: number_trunk 2]]
[18/12/2007 07:50:08]:[file:Class.A2Billing.php - line:736]:[CallerID:1112223333]:[CN:1111105298]:[OK - RESFINDRATE::> 1]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:295]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (12.00000)]]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:5647]]
[18/12/2007 07:50:08]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=1 - res_calcultimeout:5106]]
[18/12/2007 07:50:08]:[file:Class.A2Billing.php - line:758]:[CallerID:1112223333]:[CN:1111105298]:[RES_ALL_CALCULTIMEOUT ::> 1]
[18/12/2007 07:50:08]:[file:Class.A2Billing.php - line:775]:[CallerID:1112223333]:[CN:1111105298]:[TIMEOUT::> 5647 : minutes=94 - seconds=7]
[18/12/2007 07:50:14]:[file:Class.RateEngine.php - line:1025]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: Dialing 'SIP/Inphonex/0115777211111|60|HRgrL(5647000:61000:30000)' with timeout of '5647'.
]
[18/12/2007 07:50:14]:[file:Class.RateEngine.php - line:1050]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[18/12/2007 07:50:42]:[file:Class.RateEngine.php - line:1055]:[CallerID:1112223333]:[CN:1111105298]:[DIAL SIP/Inphonex/0115777211111|60|HRgrL(5647000:61000:30000)]
[18/12/2007 07:50:42]:[file:Class.RateEngine.php - line:1025]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: Dialing 'IAX2/VP-IAX2-A/0115777211111|60|HRgrL(5106000:61000:30000)' with timeout of '5106'.
]
[18/12/2007 07:50:42]:[file:Class.RateEngine.php - line:1050]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[18/12/2007 07:51:33]:[file:Class.RateEngine.php - line:1055]:[CallerID:1112223333]:[CN:1111105298]:[DIAL IAX2/VP-IAX2-A/0115777211111|60|HRgrL(5106000:61000:30000)]
[18/12/2007 07:51:33]:[file:Class.RateEngine.php - line:1156]:[CallerID:1112223333]:[CN:1111105298]:[[USEDRATECARD=1]]
[18/12/2007 07:51:33]:[file:Class.RateEngine.php - line:889]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=1 - (sessiontime=0 :: dialstatus=CANCEL :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]]
[18/12/2007 07:51:33]:[file:Class.RateEngine.php - line:913]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop QUERY = INSERT INTO cc_call (uniqueid,sessionid,username,nasipaddress,starttime,sessiontime, calledstation, terminatecause, stoptime, calledrate, sessionbill, calledcountry, calledsub, destination, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buyrate, buycost, id_card_package_offer) VALUES ('1197982162.13', 'SIP/lfowler-274523-b7700468', '1111105298', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '5777211111', 'CANCEL', now(), '0.141', '-0', '', '', 'colombia', '2', '2', '27204', '3', '1112223333', '0', '0.0842', '0', '0')]]
[18/12/2007 07:51:33]:[file:Class.RateEngine.php - line:916]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]]
[18/12/2007 07:51:33]:[file:a2billing.php - line:310]:[CallerID:1112223333]:[CN:1111105298]:[[a2billing account stop]]
[18/12/2007 07:51:33]:[file:a2billing.php - line:170]:[CallerID:1112223333]:[CN:1111105298]:[[CHANNEL STATUS : 6 = Line is up]]
[18/12/2007 07:51:33]:[file:a2billing.php - line:171]:[CallerID:1112223333]:[CN:1111105298]:[[CREDIT : 12.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[18/12/2007 07:51:43]:[file:a2billing.php - line:241]:[CallerID:1112223333]:[CN:1111105298]:[RES REFILL CARD VOUCHER DTMF : ]
[18/12/2007 07:51:43]:[file:Class.A2Billing.php - line:671]:[CallerID:1112223333]:[CN:1111105298]:[0 && && 10&& 1]
[18/12/2007 07:51:57]:[file:Class.A2Billing.php - line:678]:[CallerID:1112223333]:[CN:1111105298]:[RES DTMF : 011573153711111]
[18/12/2007 07:51:57]:[file:Class.A2Billing.php - line:696]:[CallerID:1112223333]:[CN:1111105298]:[DESTINATION ::> 011573153711111]
[18/12/2007 07:51:57]:[file:Class.A2Billing.php - line:698]:[CallerID:1112223333]:[CN:1111105298]:[RULES APPLY ON DESTINATION ::> 573153711111]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:73]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: (2, 573153711111)]]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:122]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: CALLERID]
1112223333
]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:136]:[CallerID:1112223333]:[CN:1111105298]:[[CALLERID_QUERY]
SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=2 WHERE calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix))
[RESULT]Array
(
[0] => Array
(
[0] => 0
[count(calleridprefix)] => 0
)
)
]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:182]:[CallerID:1112223333]:[CN:1111105298]:[[RATE ENGINE QUERY]
SELECT tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination,
cc_ratecard.id, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock,
connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb,
timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc,
cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,
tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,
cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,
rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix,
musiconhold,
tp_trunk.failover_trunk AS tp_failover_trunk,
rt_trunk.failover_trunk AS rt_failover_trunk,
tp_trunk.addparameter AS tp_addparameter_trunk,
rt_trunk.addparameter AS rt_addparameter_trunk,
id_outbound_cidgroup,
freetimetocall_package_offer, freetimetocall, packagetype, billingtype, startday, id_cc_package_offer
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=2
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer
WHERE (dialprefix=SUBSTRING('573153711111',1,length(dialprefix)) OR dialprefix='defaultprefix')
AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5)
AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5)
AND (starttime <= 1911 AND endtime >=1911)
AND idtariffgroup='2'
AND ( dnidprefix=SUBSTRING('6782021111',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0))
AND ( calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:192]:[CallerID:1112223333]:[CN:1111105298]:[[rate-engine: Count Total result 6]]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:281]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: Count Total result 2]]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:282]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: number_trunk 2]]
[18/12/2007 07:51:57]:[file:Class.A2Billing.php - line:736]:[CallerID:1112223333]:[CN:1111105298]:[OK - RESFINDRATE::> 1]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:295]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (12.00000)]]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:3582]]
[18/12/2007 07:51:57]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=1 - res_calcultimeout:2711]]
[18/12/2007 07:51:57]:[file:Class.A2Billing.php - line:758]:[CallerID:1112223333]:[CN:1111105298]:[RES_ALL_CALCULTIMEOUT ::> 1]
[18/12/2007 07:51:57]:[file:Class.A2Billing.php - line:775]:[CallerID:1112223333]:[CN:1111105298]:[TIMEOUT::> 3582 : minutes=59 - seconds=42]
[18/12/2007 07:52:04]:[file:Class.RateEngine.php - line:1025]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: Dialing 'IAX2/VP-IAX2-A/011573153711111|60|HRgrL(3582000:61000:30000)' with timeout of '3582'.
]
[18/12/2007 07:52:04]:[file:Class.RateEngine.php - line:1050]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[18/12/2007 07:59:03]:[file:Class.RateEngine.php - line:1055]:[CallerID:1112223333]:[CN:1111105298]:[DIAL IAX2/VP-IAX2-A/011573153711111|60|HRgrL(3582000:61000:30000)]
[18/12/2007 07:59:03]:[file:Class.RateEngine.php - line:1156]:[CallerID:1112223333]:[CN:1111105298]:[[USEDRATECARD=0]]
[18/12/2007 07:59:03]:[file:Class.RateEngine.php - line:889]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus= :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]]
[18/12/2007 07:59:03]:[file:Class.RateEngine.php - line:913]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop QUERY = INSERT INTO cc_call (uniqueid,sessionid,username,nasipaddress,starttime,sessiontime, calledstation, terminatecause, stoptime, calledrate, sessionbill, calledcountry, calledsub, destination, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buyrate, buycost, id_card_package_offer) VALUES ('2197982162.13', 'SIP/lfowler-274523-b7700468', '1111105298', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '573153711111', '', now(), '0.201', '-0', '', '', 'colombia', '2', '2', '27586', '3', '1112223333', '0', '0.1241', '0', '0')]]
[18/12/2007 07:59:03]:[file:Class.RateEngine.php - line:916]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]]
[18/12/2007 07:59:03]:[file:a2billing.php - line:310]:[CallerID:1112223333]:[CN:1111105298]:[[a2billing account stop]]
[18/12/2007 07:59:03]:[file:a2billing.php - line:170]:[CallerID:1112223333]:[CN:1111105298]:[[CHANNEL STATUS : -1 = There is no channel that matches SIP/lfowler-274523-b7700468]]
[18/12/2007 07:59:03]:[file:a2billing.php - line:171]:[CallerID:1112223333]:[CN:1111105298]:[[CREDIT : 12.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[18/12/2007 07:59:03]:[file:Class.A2Billing.php - line:649]:[CallerID:1112223333]:[CN:1111105298]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='1111105298']]
[18/12/2007 07:59:03]:[CallerID:1112223333]:[CN:1111105298]:[[STOP - EXIT]]
[18/12/2007 07:59:14]:[file:a2billing.php - line:76]:[CallerID:]:[CN:]:[IDCONFIG : 1]
[18/12/2007 07:59:14]:[file:a2billing.php - line:77]:[CallerID:]:[CN:]:[MODE : standard]
[18/12/2007 07:59:14]:[file:Class.A2Billing.php - line:616]:[CallerID:1112223333]:[CN:]:[ get_agi_request_parameter = 1112223333 ; SIP/lfowler-274523-b7700468 ; 1197982753.17 ; ; 6782021111]
[18/12/2007 07:59:14]:[file:a2billing.php - line:139]:[CallerID:1112223333]:[CN:]:[[ANSWER CALL]]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:555]:[CallerID:1112223333]:[CN:]:[RES Menu Language DTMF : 1]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:581]:[CallerID:1112223333]:[CN:]:[[SET LANGUAGE() en]]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:1437]:[CallerID:1112223333]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:1112223333]]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:1438]:[CallerID:1112223333]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:1112223333]]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:1455]:[CallerID:1112223333]:[CN:]:[QUERY = SELECT cc_callerid.cid, cc_callerid.id_cc_card, cc_callerid.activated, cc_card.credit, cc_card.tariff, cc_card.activated, cc_card.inuse, cc_card.simultaccess, cc_card.typepaid, cc_card.creditlimit, cc_card.language, cc_card.username, removeinterprefix, cc_card.redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias FROM cc_callerid LEFT JOIN cc_card ON cc_callerid.id_cc_card=cc_card.id LEFT JOIN cc_tariffgroup ON cc_card.tariff=cc_tariffgroup.id WHERE cc_callerid.cid='1112223333'
RESULT : ]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:1514]:[CallerID:1112223333]:[CN:]:[[CID_CONTROL - STOP - NO CALLERID]]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:1625]:[CallerID:1112223333]:[CN:]:[ - Account code - ]
[18/12/2007 07:59:17]:[file:Class.A2Billing.php - line:1769]:[CallerID:1112223333]:[CN:]:[Requesting DTMF, CARDNUMBER_LENGTH_MAX 15]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:1771]:[CallerID:1112223333]:[CN:]:[RES DTMF : 1111105298]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:1775]:[CallerID:1112223333]:[CN:1111105298]:[CARDNUMBER ::> 1111105298]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:1798]:[CallerID:1112223333]:[CN:1111105298]:[QUERY = SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id, cc_card.id_campaign, cc_card.id, useralias FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id WHERE username='1111105298'
Array
(
[0] => Array
(
[0] => 12.00000
[credit] => 12.00000
[1] => 2
[tariff] => 2
[2] => t
[activated] => t
[3] => 0
[inuse] => 0
[4] => 0
[simultaccess] => 0
[5] => 0
[typepaid] => 0
[6] =>
[creditlimit] =>
[7] => en
[language] => en
[8] => 1
[removeinterprefix] => 1
[9] =>
[redial] =>
[10] => 0
[enableexpire] => 0
[11] => 1512928406
[UNIX_TIMESTAMP(expirationdate)] => 1512928406
[12] => 0
[expiredays] => 0
[13] => 0
[nbused] => 0
[14] => 0
[UNIX_TIMESTAMP(firstusedate)] => 0
[15] => 1197309295
[UNIX_TIMESTAMP(cc_card.creationdate)] => 1197309295
[16] => USD
[currency] => USD
[17] => Patino
[lastname] => Patino
[18] => Claudia
[firstname] => Claudia
[19] =>
[email] =>
[20] => 1111
[uipass] => 1111
[21] => 7
[id] => 7
[22] => -1
[id_campaign] => -1
[23] => 7
[24] => 4045799502
[useralias] => 4045799502
)
)
]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:1922]:[CallerID:1112223333]:[CN:1111105298]:[[NOT ADDING NEW CID IN CC_CALLERID : CID LIMIT]]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:649]:[CallerID:1112223333]:[CN:1111105298]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='1111105298']]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:1950]:[CallerID:1112223333]:[CN:1111105298]:[[A2Billing] SAY BALANCE : 12.00000
]
[18/12/2007 07:59:36]:[file:Class.A2Billing.php - line:1143]:[CallerID:1112223333]:[CN:1111105298]:[[CURRENCY : USD]]
[18/12/2007 07:59:39]:[file:a2billing.php - line:156]:[CallerID:1112223333]:[CN:1111105298]:[[TRY : callingcard_ivr_authenticate]]
[18/12/2007 07:59:39]:[file:Class.A2Billing.php - line:1399]:[CallerID:1112223333]:[CN:1111105298]:[[AUTO SetCallerID]]
[18/12/2007 07:59:39]:[file:Class.A2Billing.php - line:1405]:[CallerID:1112223333]:[CN:1111105298]:[[REQUESTED SetCallerID : 1112223333]]
[18/12/2007 07:59:39]:[file:Class.A2Billing.php - line:1416]:[CallerID:1112223333]:[CN:1111105298]:[[EXEC SetCallerID : 1112223333]]
[18/12/2007 07:59:39]:[file:a2billing.php - line:170]:[CallerID:1112223333]:[CN:1111105298]:[[CHANNEL STATUS : 6 = Line is up]]
[18/12/2007 07:59:39]:[file:a2billing.php - line:171]:[CallerID:1112223333]:[CN:1111105298]:[[CREDIT : 12.00000][CREDIT MIN_CREDIT_2CALL : 0]]
[18/12/2007 07:59:49]:[file:a2billing.php - line:241]:[CallerID:1112223333]:[CN:1111105298]:[RES REFILL CARD VOUCHER DTMF : ]
[18/12/2007 07:59:49]:[file:Class.A2Billing.php - line:671]:[CallerID:1112223333]:[CN:1111105298]:[ && && 10&& 0]
[18/12/2007 08:00:08]:[file:Class.A2Billing.php - line:678]:[CallerID:1112223333]:[CN:1111105298]:[RES DTMF : 011576840341]
[18/12/2007 08:00:08]:[file:Class.A2Billing.php - line:696]:[CallerID:1112223333]:[CN:1111105298]:[DESTINATION ::> 011576840341]
[18/12/2007 08:00:08]:[file:Class.A2Billing.php - line:698]:[CallerID:1112223333]:[CN:1111105298]:[RULES APPLY ON DESTINATION ::> 576840341]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:73]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: (2, 576840341)]]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:122]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: CALLERID]
1112223333
]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:136]:[CallerID:1112223333]:[CN:1111105298]:[[CALLERID_QUERY]
SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=2 WHERE calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix))
[RESULT]Array
(
[0] => Array
(
[0] => 0
[count(calleridprefix)] => 0
)
)
]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:182]:[CallerID:1112223333]:[CN:1111105298]:[[RATE ENGINE QUERY]
SELECT tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination,
cc_ratecard.id, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock,
connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb,
timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc,
cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,
tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,
cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,
rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix,
musiconhold,
tp_trunk.failover_trunk AS tp_failover_trunk,
rt_trunk.failover_trunk AS rt_failover_trunk,
tp_trunk.addparameter AS tp_addparameter_trunk,
rt_trunk.addparameter AS rt_addparameter_trunk,
id_outbound_cidgroup,
freetimetocall_package_offer, freetimetocall, packagetype, billingtype, startday, id_cc_package_offer
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=2
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer
WHERE (dialprefix=SUBSTRING('576840341',1,length(dialprefix)) OR dialprefix='defaultprefix')
AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5)
AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5)
AND (starttime <= 1920 AND endtime >=1920)
AND idtariffgroup='2'
AND ( dnidprefix=SUBSTRING('6782021111',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0))
AND ( calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:192]:[CallerID:1112223333]:[CN:1111105298]:[[rate-engine: Count Total result 2]]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:281]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: Count Total result 2]]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:282]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: number_trunk 2]]
[18/12/2007 08:00:08]:[file:Class.A2Billing.php - line:736]:[CallerID:1112223333]:[CN:1111105298]:[OK - RESFINDRATE::> 1]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:295]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (12.00000)]]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:5647]]
[18/12/2007 08:00:08]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=1 - res_calcultimeout:5106]]
[18/12/2007 08:00:08]:[file:Class.A2Billing.php - line:758]:[CallerID:1112223333]:[CN:1111105298]:[RES_ALL_CALCULTIMEOUT ::> 1]
[18/12/2007 08:00:08]:[file:Class.A2Billing.php - line:775]:[CallerID:1112223333]:[CN:1111105298]:[TIMEOUT::> 5647 : minutes=94 - seconds=7]
[18/12/2007 08:00:14]:[file:Class.RateEngine.php - line:1025]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: Dialing 'SIP/Inphonex/011576840341|60|HRgrL(5647000:61000:30000)' with timeout of '5647'.
]
[18/12/2007 08:00:14]:[file:Class.RateEngine.php - line:1050]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:1055]:[CallerID:1112223333]:[CN:1111105298]:[DIAL SIP/Inphonex/011576840341|60|HRgrL(5647000:61000:30000)]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:1152]:[CallerID:1112223333]:[CN:1111105298]:[-> dialstatus : ANSWER, answered time is 5
]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:1156]:[CallerID:1112223333]:[CN:1111105298]:[[USEDRATECARD=0]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:834]:[CallerID:1112223333]:[CN:1111105298]:[ft2c_package_offer : 0 ; ; 0]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:660]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_CALCULCOST: K=0 - CALLDURATION:5 - freetimetocall_used=0]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:699]:[CallerID:1112223333]:[CN:1111105298]:[[TEMP - CC_RATE_ENGINE_CALCULCOST: 1. COST: -0.010625]:[ (5/60) * 0.1275 ]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:776]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_CALCULCOST: K=0 - BUYCOST: -0.00625 - SELLING COST: -0.0106]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:889]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=5 :: dialstatus=ANSWER :: buycost=0.00625 :: cost=-0.0106 : signe_cc_call=+: signe=-)]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:913]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop QUERY = INSERT INTO cc_call (uniqueid,sessionid,username,nasipaddress,starttime,sessiontime, calledstation, terminatecause, stoptime, calledrate, sessionbill, calledcountry, calledsub, destination, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buyrate, buycost, id_card_package_offer) VALUES ('1197982753.17', 'SIP/lfowler-274523-b7700468', '1111105298', '', CURRENT_TIMESTAMP - INTERVAL 5 SECOND , '5', '576840341', 'ANSWER', now(), '0.1275', '+0.0106', '', '', 'colombia - roc', '2', '2', '40115', '4', '1112223333', '0', '0.075', '0.00625', '0')]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:916]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:934]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop 1.2: SQL: UPDATE cc_card SET credit= credit-0.0106 , redial='576840341' , lastuse=now(), firstusedate=now(), nbused=nbused+1 WHERE username='1111105298']]
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:939]:[CallerID:1112223333]:[CN:1111105298]:[UPDATE cc_trunk SET secondusedreal = secondusedreal + 5 WHERE id_trunk='4']
[18/12/2007 08:00:19]:[file:Class.RateEngine.php - line:943]:[CallerID:1112223333]:[CN:1111105298]:[UPDATE cc_tariffplan SET secondusedreal = secondusedreal + 5 WHERE id='2']
[18/12/2007 08:00:19]:[file:a2billing.php - line:310]:[CallerID:1112223333]:[CN:1111105298]:[[a2billing account stop]]
[18/12/2007 08:00:19]:[file:a2billing.php - line:170]:[CallerID:1112223333]:[CN:1111105298]:[[CHANNEL STATUS : 6 = Line is up]]
[18/12/2007 08:00:19]:[file:a2billing.php - line:171]:[CallerID:1112223333]:[CN:1111105298]:[[CREDIT : 11.9894][CREDIT MIN_CREDIT_2CALL : 0]]
[18/12/2007 08:00:29]:[file:a2billing.php - line:241]:[CallerID:1112223333]:[CN:1111105298]:[RES REFILL CARD VOUCHER DTMF : ]
[18/12/2007 08:00:29]:[file:Class.A2Billing.php - line:671]:[CallerID:1112223333]:[CN:1111105298]:[0 && && 10&& 1]
[18/12/2007 08:00:41]:[file:Class.A2Billing.php - line:678]:[CallerID:1112223333]:[CN:1111105298]:[RES DTMF : 0115716840341]
[18/12/2007 08:00:41]:[file:Class.A2Billing.php - line:696]:[CallerID:1112223333]:[CN:1111105298]:[DESTINATION ::> 0115716840341]
[18/12/2007 08:00:41]:[file:Class.A2Billing.php - line:698]:[CallerID:1112223333]:[CN:1111105298]:[RULES APPLY ON DESTINATION ::> 5716840341]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:73]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: (2, 5716840341)]]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:122]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: CALLERID]
1112223333
]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:136]:[CallerID:1112223333]:[CN:1111105298]:[[CALLERID_QUERY]
SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=2 WHERE calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix))
[RESULT]Array
(
[0] => Array
(
[0] => 0
[count(calleridprefix)] => 0
)
)
]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:182]:[CallerID:1112223333]:[CN:1111105298]:[[RATE ENGINE QUERY]
SELECT tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination,
cc_ratecard.id, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock,
connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb,
timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc,
cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,
tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,
cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,
rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix,
musiconhold,
tp_trunk.failover_trunk AS tp_failover_trunk,
rt_trunk.failover_trunk AS rt_failover_trunk,
tp_trunk.addparameter AS tp_addparameter_trunk,
rt_trunk.addparameter AS rt_addparameter_trunk,
id_outbound_cidgroup,
freetimetocall_package_offer, freetimetocall, packagetype, billingtype, startday, id_cc_package_offer
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=2
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer
WHERE (dialprefix=SUBSTRING('5716840341',1,length(dialprefix)) OR dialprefix='defaultprefix')
AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5)
AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5)
AND (starttime <= 1920 AND endtime >=1920)
AND idtariffgroup='2'
AND ( dnidprefix=SUBSTRING('6782021111',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0))
AND ( calleridprefix=SUBSTRING('1112223333',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:192]:[CallerID:1112223333]:[CN:1111105298]:[[rate-engine: Count Total result 5]]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:281]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: Count Total result 1]]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:282]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_rate-engine: number_trunk 1]]
[18/12/2007 08:00:41]:[file:Class.A2Billing.php - line:736]:[CallerID:1112223333]:[CN:1111105298]:[OK - RESFINDRATE::> 1]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:295]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (11.9894)]]
[18/12/2007 08:00:41]:[file:Class.RateEngine.php - line:301]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:9465]]
[18/12/2007 08:00:41]:[file:Class.A2Billing.php - line:758]:[CallerID:1112223333]:[CN:1111105298]:[RES_ALL_CALCULTIMEOUT ::> 1]
[18/12/2007 08:00:41]:[file:Class.A2Billing.php - line:775]:[CallerID:1112223333]:[CN:1111105298]:[TIMEOUT::> 9465 : minutes=157 - seconds=45]
[18/12/2007 08:00:49]:[file:Class.RateEngine.php - line:1025]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: Dialing 'IAX2/VP-IAX2-A/0115716840341|60|HRgrL(9465000:61000:30000)' with timeout of '9465'.
]
[18/12/2007 08:00:49]:[file:Class.RateEngine.php - line:1050]:[CallerID:1112223333]:[CN:1111105298]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.]
[18/12/2007 08:23:28]:[file:Class.RateEngine.php - line:1055]:[CallerID:1112223333]:[CN:1111105298]:[DIAL IAX2/VP-IAX2-A/0115716840341|60|HRgrL(9465000:61000:30000)]
[18/12/2007 08:23:28]:[file:Class.RateEngine.php - line:1156]:[CallerID:1112223333]:[CN:1111105298]:[[USEDRATECARD=0]]
[18/12/2007 08:23:28]:[file:Class.RateEngine.php - line:889]:[CallerID:1112223333]:[CN:1111105298]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus= :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]]
[18/12/2007 08:23:28]:[file:Class.RateEngine.php - line:913]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop QUERY = INSERT INTO cc_call (uniqueid,sessionid,username,nasipaddress,starttime,sessiontime, calledstation, terminatecause, stoptime, calledrate, sessionbill, calledcountry, calledsub, destination, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax, buyrate, buycost, id_card_package_offer) VALUES ('2197982753.17', 'SIP/lfowler-274523-b7700468', '1111105298', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '5716840341', '', now(), '0.076', '-0', '', '', 'colombia', '2', '2', '27243', '3', '1112223333', '0', '0.0409', '0', '0')]]
[18/12/2007 08:23:28]:[file:Class.RateEngine.php - line:916]:[CallerID:1112223333]:[CN:1111105298]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]]
[18/12/2007 08:23:28]:[file:a2billing.php - line:310]:[CallerID:1112223333]:[CN:1111105298]:[[a2billing account stop]]
[18/12/2007 08:23:28]:[file:a2billing.php - line:170]:[CallerID:1112223333]:[CN:1111105298]:[[CHANNEL STATUS : -1 = There is no channel that matches SIP/lfowler-274523-b7700468]]
[18/12/2007 08:23:28]:[file:a2billing.php - line:171]:[CallerID:1112223333]:[CN:1111105298]:[[CREDIT : 11.9894][CREDIT MIN_CREDIT_2CALL : 0]]
[18/12/2007 08:23:28]:[file:Class.A2Billing.php - line:649]:[CallerID:1112223333]:[CN:1111105298]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='1111105298']]
[18/12/2007 08:23:28]:[CallerID:1112223333]:[CN:1111105298]:[[STOP - EXIT]]
|