$num_cur = count($result); for ($i=0;$i<$num_cur;$i++) { $currencies_list[$result[$i][1]] = array (1 => $result[$i][2], 2 => $result[$i][3]); } } $RateEngine = new RateEngine(); if ($A2B -> CC_TESTING) { $RateEngine->debug_st = 1; $accountcode = '2222222222'; } if ($mode == 'auto') { $A2B-> Reinit(); $mydnid = $agi -> request['agi_extension']; if (strlen($mydnid) > 0){ $QUERY = "SELECT 1 FROM cc_did LEFT OUTER JOIN cc_callerid ON cid = '$A2B->CallerID' AND (id_cc_card = iduser OR iduser = 0 OR allciduse = 1) AND cc_callerid.activated = 't' WHERE cc_did.activated = 1 AND did = '$mydnid' AND startingdate <= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL"; // if MYSQL if ($A2B->config["database"]['dbtype'] != "postgres") $QUERY .= " OR cc_did.expirationdate = '0000-00-00 00:00:00'"; $QUERY .= ") AND cid IS NULL LIMIT 1"; $result = $A2B -> instance_table -> SQLExec ($A2B->DBHandle, $QUERY); if (is_array($result)) { if ($caller_areacode == 'recalldidless') break; $QUERY = "SELECT src, cc_card.username, cc_card.recalltime, continuewithdid FROM cc_card, cc_call LEFT JOIN cc_did ON cc_did.id_trunk=cc_call.id_trunk