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('00901234567894',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 <= 1159 AND endtime >=1159) AND idtariffgroup='1' AND ( dnidprefix=SUBSTRING('0090',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0)) AND ( calleridprefix=SUBSTRING('1337',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0)) ORDER BY LENGTH(dialprefix) DESC ] [25/02/2008 19:19:44]:[file:Class.RateEngine.php - line:192]:[CallerID:1337]:[CN:4346644196]:[[rate-engine: Count Total result 1]] [25/02/2008 19:19:44]:[file:Class.RateEngine.php - line:281]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: Count Total result 1]] [25/02/2008 19:19:44]:[file:Class.RateEngine.php - line:282]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: number_trunk 1]] [25/02/2008 19:19:44]:[file:Class.A2Billing.php - line:736]:[CallerID:1337]:[CN:4346644196]:[OK - RESFINDRATE::> 1] [25/02/2008 19:19:44]:[file:Class.RateEngine.php - line:295]:[CallerID:1337]:[CN:4346644196]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (69.00000)]] [25/02/2008 19:19:44]:[file:Class.RateEngine.php - line:301]:[CallerID:1337]:[CN:4346644196]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:207000]] [25/02/2008 19:19:44]:[file:Class.A2Billing.php - line:758]:[CallerID:1337]:[CN:4346644196]:[RES_ALL_CALCULTIMEOUT ::> 1] [25/02/2008 19:19:44]:[file:Class.A2Billing.php - line:775]:[CallerID:1337]:[CN:4346644196]:[TIMEOUT::> 207000 : minutes=3450 - seconds=0] [25/02/2008 19:19:50]:[file:Class.RateEngine.php - line:1026]:[CallerID:1337]:[CN:4346644196]:[app_callingcard: Dialing 'SIP/sip.voicetrading.com/00901234567894|60|HRgrL(207000000:61000:30000)' with timeout of '207000'. ] [25/02/2008 19:19:50]:[file:Class.RateEngine.php - line:1051]:[CallerID:1337]:[CN:4346644196]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.] [25/02/2008 19:19:50]:[file:Class.RateEngine.php - line:1056]:[CallerID:1337]:[CN:4346644196]:[DIAL SIP/sip.voicetrading.com/00901234567894|60|HRgrL(207000000:61000:30000)] [25/02/2008 19:19:50]:[file:Class.RateEngine.php - line:1162]:[CallerID:1337]:[CN:4346644196]:[[USEDRATECARD - FAIL =0]] [25/02/2008 19:19:53]:[file:Class.RateEngine.php - line:890]:[CallerID:1337]:[CN:4346644196]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus=CONGESTION :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]] [25/02/2008 19:19:53]:[file:Class.RateEngine.php - line:914]:[CallerID:1337]:[CN:4346644196]:[[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 ('1203985134.81', 'SIP/4346644196-b770d8a8', '4346644196', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '00901234567894', 'CONGESTION', now(), '0.02', '-0', '', '', 'voicetrading turkey', '1', '1', '1', '3', '1337', '0', '0', '0', '0')]] [25/02/2008 19:19:53]:[file:Class.RateEngine.php - line:917]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]] [25/02/2008 19:19:53]:[file:a2billing.php - line:310]:[CallerID:1337]:[CN:4346644196]:[[a2billing account stop]] [25/02/2008 19:19:53]:[file:a2billing.php - line:170]:[CallerID:1337]:[CN:4346644196]:[[CHANNEL STATUS : 6 = Line is up]] [25/02/2008 19:19:53]:[file:a2billing.php - line:171]:[CallerID:1337]:[CN:4346644196]:[[CREDIT : 69.00000][CREDIT MIN_CREDIT_2CALL : 0]] [25/02/2008 19:19:53]:[file:Class.A2Billing.php - line:671]:[CallerID:1337]:[CN:4346644196]:[0 && && 4&& 1] [25/02/2008 19:19:58]:[file:Class.A2Billing.php - line:678]:[CallerID:1337]:[CN:4346644196]:[RES DTMF : -1] [25/02/2008 19:19:58]:[file:Class.A2Billing.php - line:696]:[CallerID:1337]:[CN:4346644196]:[DESTINATION ::> -1] [25/02/2008 19:19:58]:[file:Class.A2Billing.php - line:698]:[CallerID:1337]:[CN:4346644196]:[RULES APPLY ON DESTINATION ::> -1] [25/02/2008 19:19:58]:[file:a2billing.php - line:170]:[CallerID:1337]:[CN:4346644196]:[[CHANNEL STATUS : 6 = Line is up]] [25/02/2008 19:19:58]:[file:a2billing.php - line:171]:[CallerID:1337]:[CN:4346644196]:[[CREDIT : 69.00000][CREDIT MIN_CREDIT_2CALL : 0]] [25/02/2008 19:19:58]:[file:Class.A2Billing.php - line:671]:[CallerID:1337]:[CN:4346644196]:[0 && && 4&& 2] [25/02/2008 19:19:58]:[file:Class.A2Billing.php - line:678]:[CallerID:1337]:[CN:4346644196]:[RES DTMF : -1] [25/02/2008 19:19:58]:[file:Class.A2Billing.php - line:696]:[CallerID:1337]:[CN:4346644196]:[DESTINATION ::> -1] [25/02/2008 19:19:58]:[file:Class.A2Billing.php - line:698]:[CallerID:1337]:[CN:4346644196]:[RULES APPLY ON DESTINATION ::> -1] [25/02/2008 19:19:58]:[file:Class.A2Billing.php - line:649]:[CallerID:1337]:[CN:4346644196]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='4346644196']] [25/02/2008 19:19:58]:[CallerID:1337]:[CN:4346644196]:[[exit]] [25/02/2008 19:22:04]:[file:a2billing.php - line:76]:[CallerID:]:[CN:]:[IDCONFIG : 1] [25/02/2008 19:22:04]:[file:a2billing.php - line:77]:[CallerID:]:[CN:]:[MODE : standard] [25/02/2008 19:22:04]:[file:Class.A2Billing.php - line:616]:[CallerID:1337]:[CN:]:[ get_agi_request_parameter = 1337 ; SIP/4346644196-b770ad88 ; 1203985322.83 ; 4346644196 ; 880] [25/02/2008 19:22:04]:[file:a2billing.php - line:139]:[CallerID:1337]:[CN:]:[[ANSWER CALL]] [25/02/2008 19:22:04]:[file:Class.A2Billing.php - line:1437]:[CallerID:1337]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:1337]] [25/02/2008 19:22:04]:[file:Class.A2Billing.php - line:1438]:[CallerID:1337]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:1337]] [25/02/2008 19:22:04]:[file:Class.A2Billing.php - line:1455]:[CallerID:1337]:[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='1337' RESULT : Array ( [0] => Array ( [0] => 1337 [cid] => 1337 [1] => 5 [id_cc_card] => 5 [2] => t [activated] => t [3] => 69.00000 [credit] => 69.00000 [4] => 1 [tariff] => 1 [5] => t [6] => 0 [inuse] => 0 [7] => 0 [simultaccess] => 0 [8] => 0 [typepaid] => 0 [9] => [creditlimit] => [10] => en [language] => en [11] => 4346644196 [username] => 4346644196 [12] => 0 [removeinterprefix] => 0 [13] => [redial] => [14] => 0 [enableexpire] => 0 [15] => 1519171884 [UNIX_TIMESTAMP(expirationdate)] => 1519171884 [16] => 0 [expiredays] => 0 [17] => 0 [nbused] => 0 [18] => 0 [UNIX_TIMESTAMP(firstusedate)] => 0 [19] => 1203552738 [UNIX_TIMESTAMP(cc_card.creationdate)] => 1203552738 [20] => USD [currency] => USD [21] => [lastname] => [22] => [firstname] => [23] => [email] => [24] => d2r [uipass] => d2r [25] => -1 [id_campaign] => -1 [26] => 5 [id] => 5 [27] => 1337 [useralias] => 1337 ) ) ] [25/02/2008 19:22:04]:[file:Class.A2Billing.php - line:1625]:[CallerID:1337]:[CN:]:[ - Account code - 4346644196] [25/02/2008 19:22:04]:[file:Class.A2Billing.php - line:1714]:[CallerID:1337]:[CN:4346644196]:[[SET LANGUAGE() en]] [25/02/2008 19:22:04]:[file:Class.A2Billing.php - line:1717]:[CallerID:1337]:[CN:4346644196]:[[credit=69.00000 :: tariff=1 :: active=t :: isused=0 :: simultaccess=0 :: typepaid=0 :: creditlimit= :: language=en]] [25/02/2008 19:22:04]:[file:Class.A2Billing.php - line:649]:[CallerID:1337]:[CN:4346644196]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='4346644196']] [25/02/2008 19:22:04]:[file:Class.A2Billing.php - line:1950]:[CallerID:1337]:[CN:4346644196]:[[A2Billing] SAY BALANCE : 69.00000 ] [25/02/2008 19:22:04]:[file:Class.A2Billing.php - line:1143]:[CallerID:1337]:[CN:4346644196]:[[CURRENCY : USD]] [25/02/2008 19:22:08]:[file:a2billing.php - line:156]:[CallerID:1337]:[CN:4346644196]:[[TRY : callingcard_ivr_authenticate]] [25/02/2008 19:22:08]:[file:Class.A2Billing.php - line:1399]:[CallerID:1337]:[CN:4346644196]:[[AUTO SetCallerID]] [25/02/2008 19:22:08]:[file:Class.A2Billing.php - line:1403]:[CallerID:1337]:[CN:4346644196]:[[EXEC SetCallerID : 1]] [25/02/2008 19:22:08]:[file:a2billing.php - line:170]:[CallerID:1337]:[CN:4346644196]:[[CHANNEL STATUS : 6 = Line is up]] [25/02/2008 19:22:08]:[file:a2billing.php - line:171]:[CallerID:1337]:[CN:4346644196]:[[CREDIT : 69.00000][CREDIT MIN_CREDIT_2CALL : 0]] [25/02/2008 19:22:08]:[file:Class.A2Billing.php - line:671]:[CallerID:1337]:[CN:4346644196]:[ && && 3&& 0] [25/02/2008 19:22:18]:[file:Class.A2Billing.php - line:678]:[CallerID:1337]:[CN:4346644196]:[RES DTMF : 88008080] [25/02/2008 19:22:18]:[file:Class.A2Billing.php - line:696]:[CallerID:1337]:[CN:4346644196]:[DESTINATION ::> 88008080] [25/02/2008 19:22:18]:[file:Class.A2Billing.php - line:698]:[CallerID:1337]:[CN:4346644196]:[RULES APPLY ON DESTINATION ::> 88008080] [25/02/2008 19:22:18]:[file:Class.RateEngine.php - line:73]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: (1, 88008080)]] [25/02/2008 19:22:18]:[file:Class.RateEngine.php - line:122]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: CALLERID] 1337 ] [25/02/2008 19:22:18]:[file:Class.RateEngine.php - line:136]:[CallerID:1337]:[CN:4346644196]:[[CALLERID_QUERY] SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=1 WHERE calleridprefix=SUBSTRING('1337',1,length(calleridprefix)) [RESULT]Array ( [0] => Array ( [0] => 0 [count(calleridprefix)] => 0 ) ) ] [25/02/2008 19:22:18]:[file:Class.RateEngine.php - line:182]:[CallerID:1337]:[CN:4346644196]:[[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=1 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('88008080',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 <= 1162 AND endtime >=1162) AND idtariffgroup='1' AND ( dnidprefix=SUBSTRING('880',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0)) AND ( calleridprefix=SUBSTRING('1337',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0)) ORDER BY LENGTH(dialprefix) DESC ] [25/02/2008 19:22:18]:[file:Class.A2Billing.php - line:734]:[CallerID:1337]:[CN:4346644196]:[ERROR ::> RateEngine didnt succeed to match the dialed number over the ratecard (Please check : id the ratecard is well create ; if the removeInter_Prefix is set according to your prefix in the ratecard ; if you hooked the ratecard to the Call Plan)] [25/02/2008 19:22:21]:[file:a2billing.php - line:170]:[CallerID:1337]:[CN:4346644196]:[[CHANNEL STATUS : 6 = Line is up]] [25/02/2008 19:22:21]:[file:a2billing.php - line:171]:[CallerID:1337]:[CN:4346644196]:[[CREDIT : 69.00000][CREDIT MIN_CREDIT_2CALL : 0]] [25/02/2008 19:22:21]:[file:Class.A2Billing.php - line:671]:[CallerID:1337]:[CN:4346644196]:[0 && && 3&& 1] [25/02/2008 19:22:30]:[file:Class.A2Billing.php - line:678]:[CallerID:1337]:[CN:4346644196]:[RES DTMF : 8809999999999] [25/02/2008 19:22:30]:[file:Class.A2Billing.php - line:696]:[CallerID:1337]:[CN:4346644196]:[DESTINATION ::> 8809999999999] [25/02/2008 19:22:30]:[file:Class.A2Billing.php - line:698]:[CallerID:1337]:[CN:4346644196]:[RULES APPLY ON DESTINATION ::> 8809999999999] [25/02/2008 19:22:30]:[file:Class.RateEngine.php - line:73]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: (1, 8809999999999)]] [25/02/2008 19:22:30]:[file:Class.RateEngine.php - line:122]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: CALLERID] 1337 ] [25/02/2008 19:22:30]:[file:Class.RateEngine.php - line:136]:[CallerID:1337]:[CN:4346644196]:[[CALLERID_QUERY] SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=1 WHERE calleridprefix=SUBSTRING('1337',1,length(calleridprefix)) [RESULT]Array ( [0] => Array ( [0] => 0 [count(calleridprefix)] => 0 ) ) ] [25/02/2008 19:22:30]:[file:Class.RateEngine.php - line:182]:[CallerID:1337]:[CN:4346644196]:[[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=1 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('8809999999999',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 <= 1162 AND endtime >=1162) AND idtariffgroup='1' AND ( dnidprefix=SUBSTRING('880',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0)) AND ( calleridprefix=SUBSTRING('1337',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0)) ORDER BY LENGTH(dialprefix) DESC ] [25/02/2008 19:22:30]:[file:Class.A2Billing.php - line:734]:[CallerID:1337]:[CN:4346644196]:[ERROR ::> RateEngine didnt succeed to match the dialed number over the ratecard (Please check : id the ratecard is well create ; if the removeInter_Prefix is set according to your prefix in the ratecard ; if you hooked the ratecard to the Call Plan)] [25/02/2008 19:22:33]:[file:a2billing.php - line:170]:[CallerID:1337]:[CN:4346644196]:[[CHANNEL STATUS : 6 = Line is up]] [25/02/2008 19:22:33]:[file:a2billing.php - line:171]:[CallerID:1337]:[CN:4346644196]:[[CREDIT : 69.00000][CREDIT MIN_CREDIT_2CALL : 0]] [25/02/2008 19:22:33]:[file:Class.A2Billing.php - line:671]:[CallerID:1337]:[CN:4346644196]:[0 && && 3&& 2] [25/02/2008 19:22:47]:[file:Class.A2Billing.php - line:678]:[CallerID:1337]:[CN:4346644196]:[RES DTMF : 00905555555555] [25/02/2008 19:22:47]:[file:Class.A2Billing.php - line:696]:[CallerID:1337]:[CN:4346644196]:[DESTINATION ::> 00905555555555] [25/02/2008 19:22:47]:[file:Class.A2Billing.php - line:698]:[CallerID:1337]:[CN:4346644196]:[RULES APPLY ON DESTINATION ::> 00905555555555] [25/02/2008 19:22:47]:[file:Class.RateEngine.php - line:73]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: (1, 00905555555555)]] [25/02/2008 19:22:47]:[file:Class.RateEngine.php - line:122]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: CALLERID] 1337 ] [25/02/2008 19:22:47]:[file:Class.RateEngine.php - line:136]:[CallerID:1337]:[CN:4346644196]:[[CALLERID_QUERY] SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=1 WHERE calleridprefix=SUBSTRING('1337',1,length(calleridprefix)) [RESULT]Array ( [0] => Array ( [0] => 0 [count(calleridprefix)] => 0 ) ) ] [25/02/2008 19:22:47]:[file:Class.RateEngine.php - line:182]:[CallerID:1337]:[CN:4346644196]:[[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=1 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('00905555555555',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 <= 1162 AND endtime >=1162) AND idtariffgroup='1' AND ( dnidprefix=SUBSTRING('880',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0)) AND ( calleridprefix=SUBSTRING('1337',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0)) ORDER BY LENGTH(dialprefix) DESC ] [25/02/2008 19:22:47]:[file:Class.RateEngine.php - line:192]:[CallerID:1337]:[CN:4346644196]:[[rate-engine: Count Total result 1]] [25/02/2008 19:22:47]:[file:Class.RateEngine.php - line:281]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: Count Total result 1]] [25/02/2008 19:22:47]:[file:Class.RateEngine.php - line:282]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: number_trunk 1]] [25/02/2008 19:22:47]:[file:Class.A2Billing.php - line:736]:[CallerID:1337]:[CN:4346644196]:[OK - RESFINDRATE::> 1] [25/02/2008 19:22:47]:[file:Class.RateEngine.php - line:295]:[CallerID:1337]:[CN:4346644196]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (69.00000)]] [25/02/2008 19:22:47]:[file:Class.RateEngine.php - line:301]:[CallerID:1337]:[CN:4346644196]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:207000]] [25/02/2008 19:22:47]:[file:Class.A2Billing.php - line:758]:[CallerID:1337]:[CN:4346644196]:[RES_ALL_CALCULTIMEOUT ::> 1] [25/02/2008 19:22:47]:[file:Class.A2Billing.php - line:775]:[CallerID:1337]:[CN:4346644196]:[TIMEOUT::> 207000 : minutes=3450 - seconds=0] [25/02/2008 19:22:52]:[file:Class.RateEngine.php - line:1026]:[CallerID:1337]:[CN:4346644196]:[app_callingcard: Dialing 'SIP/sip.voicetrading.com/00905555555555|60|HRgrL(207000000:61000:30000)' with timeout of '207000'. ] [25/02/2008 19:22:52]:[file:Class.RateEngine.php - line:1051]:[CallerID:1337]:[CN:4346644196]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.] [25/02/2008 19:22:53]:[file:Class.RateEngine.php - line:1056]:[CallerID:1337]:[CN:4346644196]:[DIAL SIP/sip.voicetrading.com/00905555555555|60|HRgrL(207000000:61000:30000)] [25/02/2008 19:22:53]:[file:Class.RateEngine.php - line:1162]:[CallerID:1337]:[CN:4346644196]:[[USEDRATECARD - FAIL =0]] [25/02/2008 19:22:56]:[file:Class.RateEngine.php - line:890]:[CallerID:1337]:[CN:4346644196]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus=CONGESTION :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]] [25/02/2008 19:22:56]:[file:Class.RateEngine.php - line:914]:[CallerID:1337]:[CN:4346644196]:[[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 ('3203985322.83', 'SIP/4346644196-b770ad88', '4346644196', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '00905555555555', 'CONGESTION', now(), '0.02', '-0', '', '', 'voicetrading turkey', '1', '1', '1', '3', '1337', '0', '0', '0', '0')]] [25/02/2008 19:22:56]:[file:Class.RateEngine.php - line:917]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]] [25/02/2008 19:22:56]:[file:a2billing.php - line:310]:[CallerID:1337]:[CN:4346644196]:[[a2billing account stop]] [25/02/2008 19:22:56]:[file:Class.A2Billing.php - line:649]:[CallerID:1337]:[CN:4346644196]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='4346644196']] [25/02/2008 19:22:56]:[CallerID:1337]:[CN:4346644196]:[[exit]] [25/02/2008 19:47:20]:[file:a2billing.php - line:76]:[CallerID:]:[CN:]:[IDCONFIG : 1] [25/02/2008 19:47:20]:[file:a2billing.php - line:77]:[CallerID:]:[CN:]:[MODE : standard] [25/02/2008 19:47:20]:[file:Class.A2Billing.php - line:616]:[CallerID:1337]:[CN:]:[ get_agi_request_parameter = 1337 ; SIP/4346644196-b770a880 ; 1203986838.85 ; 4346644196 ; 90] [25/02/2008 19:47:20]:[file:a2billing.php - line:139]:[CallerID:1337]:[CN:]:[[ANSWER CALL]] [25/02/2008 19:47:20]:[file:Class.A2Billing.php - line:1437]:[CallerID:1337]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:1337]] [25/02/2008 19:47:20]:[file:Class.A2Billing.php - line:1438]:[CallerID:1337]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:1337]] [25/02/2008 19:47:20]:[file:Class.A2Billing.php - line:1455]:[CallerID:1337]:[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='1337' RESULT : Array ( [0] => Array ( [0] => 1337 [cid] => 1337 [1] => 5 [id_cc_card] => 5 [2] => t [activated] => t [3] => 69.00000 [credit] => 69.00000 [4] => 1 [tariff] => 1 [5] => t [6] => 0 [inuse] => 0 [7] => 0 [simultaccess] => 0 [8] => 0 [typepaid] => 0 [9] => [creditlimit] => [10] => en [language] => en [11] => 4346644196 [username] => 4346644196 [12] => 0 [removeinterprefix] => 0 [13] => [redial] => [14] => 0 [enableexpire] => 0 [15] => 1519171884 [UNIX_TIMESTAMP(expirationdate)] => 1519171884 [16] => 0 [expiredays] => 0 [17] => 0 [nbused] => 0 [18] => 0 [UNIX_TIMESTAMP(firstusedate)] => 0 [19] => 1203552738 [UNIX_TIMESTAMP(cc_card.creationdate)] => 1203552738 [20] => USD [currency] => USD [21] => [lastname] => [22] => [firstname] => [23] => [email] => [24] => d2r [uipass] => d2r [25] => -1 [id_campaign] => -1 [26] => 5 [id] => 5 [27] => 1337 [useralias] => 1337 ) ) ] [25/02/2008 19:47:20]:[file:Class.A2Billing.php - line:1625]:[CallerID:1337]:[CN:]:[ - Account code - 4346644196] [25/02/2008 19:47:20]:[file:Class.A2Billing.php - line:1714]:[CallerID:1337]:[CN:4346644196]:[[SET LANGUAGE() en]] [25/02/2008 19:47:20]:[file:Class.A2Billing.php - line:1717]:[CallerID:1337]:[CN:4346644196]:[[credit=69.00000 :: tariff=1 :: active=t :: isused=0 :: simultaccess=0 :: typepaid=0 :: creditlimit= :: language=en]] [25/02/2008 19:47:20]:[file:Class.A2Billing.php - line:649]:[CallerID:1337]:[CN:4346644196]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='4346644196']] [25/02/2008 19:47:20]:[file:Class.A2Billing.php - line:1950]:[CallerID:1337]:[CN:4346644196]:[[A2Billing] SAY BALANCE : 69.00000 ] [25/02/2008 19:47:20]:[file:Class.A2Billing.php - line:1143]:[CallerID:1337]:[CN:4346644196]:[[CURRENCY : USD]] [25/02/2008 19:47:24]:[file:a2billing.php - line:156]:[CallerID:1337]:[CN:4346644196]:[[TRY : callingcard_ivr_authenticate]] [25/02/2008 19:47:24]:[file:Class.A2Billing.php - line:1399]:[CallerID:1337]:[CN:4346644196]:[[AUTO SetCallerID]] [25/02/2008 19:47:24]:[file:Class.A2Billing.php - line:1403]:[CallerID:1337]:[CN:4346644196]:[[EXEC SetCallerID : 1]] [25/02/2008 19:47:24]:[file:a2billing.php - line:170]:[CallerID:1337]:[CN:4346644196]:[[CHANNEL STATUS : 6 = Line is up]] [25/02/2008 19:47:24]:[file:a2billing.php - line:171]:[CallerID:1337]:[CN:4346644196]:[[CREDIT : 69.00000][CREDIT MIN_CREDIT_2CALL : 0]] [25/02/2008 19:47:24]:[file:Class.A2Billing.php - line:671]:[CallerID:1337]:[CN:4346644196]:[ && && 2&& 0] [25/02/2008 19:47:34]:[file:Class.A2Billing.php - line:678]:[CallerID:1337]:[CN:4346644196]:[RES DTMF : 00902222222222] [25/02/2008 19:47:34]:[file:Class.A2Billing.php - line:696]:[CallerID:1337]:[CN:4346644196]:[DESTINATION ::> 00902222222222] [25/02/2008 19:47:34]:[file:Class.A2Billing.php - line:698]:[CallerID:1337]:[CN:4346644196]:[RULES APPLY ON DESTINATION ::> 00902222222222] [25/02/2008 19:47:34]:[file:Class.RateEngine.php - line:73]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: (1, 00902222222222)]] [25/02/2008 19:47:34]:[file:Class.RateEngine.php - line:122]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: CALLERID] 1337 ] [25/02/2008 19:47:34]:[file:Class.RateEngine.php - line:136]:[CallerID:1337]:[CN:4346644196]:[[CALLERID_QUERY] SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=1 WHERE calleridprefix=SUBSTRING('1337',1,length(calleridprefix)) [RESULT]Array ( [0] => Array ( [0] => 0 [count(calleridprefix)] => 0 ) ) ] [25/02/2008 19:47:34]:[file:Class.RateEngine.php - line:182]:[CallerID:1337]:[CN:4346644196]:[[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=1 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('00902222222222',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 <= 1187 AND endtime >=1187) AND idtariffgroup='1' AND ( dnidprefix=SUBSTRING('90',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0)) AND ( calleridprefix=SUBSTRING('1337',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0)) ORDER BY LENGTH(dialprefix) DESC ] [25/02/2008 19:47:34]:[file:Class.RateEngine.php - line:192]:[CallerID:1337]:[CN:4346644196]:[[rate-engine: Count Total result 1]] [25/02/2008 19:47:34]:[file:Class.RateEngine.php - line:281]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: Count Total result 1]] [25/02/2008 19:47:34]:[file:Class.RateEngine.php - line:282]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_rate-engine: number_trunk 1]] [25/02/2008 19:47:34]:[file:Class.A2Billing.php - line:736]:[CallerID:1337]:[CN:4346644196]:[OK - RESFINDRATE::> 1] [25/02/2008 19:47:34]:[file:Class.RateEngine.php - line:295]:[CallerID:1337]:[CN:4346644196]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (69.00000)]] [25/02/2008 19:47:34]:[file:Class.RateEngine.php - line:301]:[CallerID:1337]:[CN:4346644196]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:207000]] [25/02/2008 19:47:34]:[file:Class.A2Billing.php - line:758]:[CallerID:1337]:[CN:4346644196]:[RES_ALL_CALCULTIMEOUT ::> 1] [25/02/2008 19:47:34]:[file:Class.A2Billing.php - line:775]:[CallerID:1337]:[CN:4346644196]:[TIMEOUT::> 207000 : minutes=3450 - seconds=0] [25/02/2008 19:47:40]:[file:Class.RateEngine.php - line:1026]:[CallerID:1337]:[CN:4346644196]:[app_callingcard: Dialing 'SIP/sip.voicetrading.com/00902222222222|60|HRgrL(207000000:61000:30000)' with timeout of '207000'. ] [25/02/2008 19:47:40]:[file:Class.RateEngine.php - line:1051]:[CallerID:1337]:[CN:4346644196]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.] [25/02/2008 19:47:40]:[file:Class.RateEngine.php - line:1056]:[CallerID:1337]:[CN:4346644196]:[DIAL SIP/sip.voicetrading.com/00902222222222|60|HRgrL(207000000:61000:30000)] [25/02/2008 19:47:40]:[file:Class.RateEngine.php - line:1162]:[CallerID:1337]:[CN:4346644196]:[[USEDRATECARD - FAIL =0]] [25/02/2008 19:47:43]:[file:Class.RateEngine.php - line:890]:[CallerID:1337]:[CN:4346644196]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus=CONGESTION :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]] [25/02/2008 19:47:43]:[file:Class.RateEngine.php - line:914]:[CallerID:1337]:[CN:4346644196]:[[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 ('1203986838.85', 'SIP/4346644196-b770a880', '4346644196', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '00902222222222', 'CONGESTION', now(), '0.02', '-0', '', '', 'voicetrading turkey', '1', '1', '1', '3', '1337', '0', '0', '0', '0')]] [25/02/2008 19:47:43]:[file:Class.RateEngine.php - line:917]:[CallerID:1337]:[CN:4346644196]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]] [25/02/2008 19:47:43]:[file:a2billing.php - line:310]:[CallerID:1337]:[CN:4346644196]:[[a2billing account stop]] [25/02/2008 19:47:43]:[file:a2billing.php - line:170]:[CallerID:1337]:[CN:4346644196]:[[CHANNEL STATUS : 6 = Line is up]] [25/02/2008 19:47:43]:[file:a2billing.php - line:171]:[CallerID:1337]:[CN:4346644196]:[[CREDIT : 69.00000][CREDIT MIN_CREDIT_2CALL : 0]] [25/02/2008 19:47:43]:[file:Class.A2Billing.php - line:671]:[CallerID:1337]:[CN:4346644196]:[0 && && 2&& 1] [25/02/2008 19:47:43]:[file:Class.A2Billing.php - line:678]:[CallerID:1337]:[CN:4346644196]:[RES DTMF : -1] [25/02/2008 19:47:43]:[file:Class.A2Billing.php - line:696]:[CallerID:1337]:[CN:4346644196]:[DESTINATION ::> -1] [25/02/2008 19:47:43]:[file:Class.A2Billing.php - line:698]:[CallerID:1337]:[CN:4346644196]:[RULES APPLY ON DESTINATION ::> -1] [25/02/2008 19:47:43]:[file:a2billing.php - line:170]:[CallerID:1337]:[CN:4346644196]:[[CHANNEL STATUS : 6 = Line is up]] [25/02/2008 19:47:43]:[file:a2billing.php - line:171]:[CallerID:1337]:[CN:4346644196]:[[CREDIT : 69.00000][CREDIT MIN_CREDIT_2CALL : 0]] [25/02/2008 19:47:43]:[file:Class.A2Billing.php - line:671]:[CallerID:1337]:[CN:4346644196]:[0 && && 2&& 2] [25/02/2008 19:47:43]:[file:Class.A2Billing.php - line:678]:[CallerID:1337]:[CN:4346644196]:[RES DTMF : -1] [25/02/2008 19:47:43]:[file:Class.A2Billing.php - line:696]:[CallerID:1337]:[CN:4346644196]:[DESTINATION ::> -1] [25/02/2008 19:47:43]:[file:Class.A2Billing.php - line:698]:[CallerID:1337]:[CN:4346644196]:[RULES APPLY ON DESTINATION ::> -1] [25/02/2008 19:47:43]:[file:Class.A2Billing.php - line:649]:[CallerID:1337]:[CN:4346644196]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='4346644196']] [25/02/2008 19:47:43]:[CallerID:1337]:[CN:4346644196]:[[exit]]