> "/var/www/html/mbilling/resources/asterisk/mbilling.php": Check If Is Did
13023048486 > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_did WHERE did = '
13023048486' AND activated = 1 LIMIT 1
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_sip WHERE name = '
13023048486' OR (alias = '
13023048486' AND accountcode = '16259') LIMIT 1
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": CALL TO PSTN
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": AuthenticateUser 16259
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_sip WHERE techprefix = '130230' AND host != 'dynamic' LIMIT 1
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": Try accountcode authentication 16259
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT *,
u.id id, u.id_user id_user FROM pkg_user u INNER JOIN pkg_plan p ON u.id_plan =
p.id WHERE username = '16259' LIMIT 1
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_sip WHERE name = '16259' LIMIT 1
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": AUTHENTICATION BY ACCOUNTCODE:16259
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": use_dnid:1 && len_dnid:(11 || len_exten:11 ) && (try_num:0)
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": USE_DNID DESTINATION ->
13023048486 > "/var/www/html/mbilling/resources/asterisk/mbilling.php": REMOVE INTERNACIONAL PREFIX ->
13023048486 > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Grab : Replacement: Phone Before:
13023048486 > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Phone After translation:
13023048486 > "/var/www/html/mbilling/resources/asterisk/mbilling.php": consulta portabilidade numero
13023048486 > "/var/www/html/mbilling/resources/asterisk/mbilling.php": USERNAME=16259 DESTINATION=
13023048486 PLAN=1 CREDIT=10.0000
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT length FROM pkg_prefix_length WHERE code = '13' LIMIT 1
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT lcrtype,
pkg_plan.id AS id_plan, pkg_prefix.prefix AS dialprefix,
> "/var/www/html/mbilling/resources/asterisk/mbilling.php":
pkg_plan.name, pkg_rate.id_prefix,
pkg_rate.id AS id_rate, buyrate, buyrateinitblock buyrateinitblock,
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": buyrateincrement, rateinitial, initblock, billingblock, connectcharge, disconnectcharge disconnectcharge,
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": pkg_rate.id_trunk AS id_trunk, pkg_trunk.trunkprefix AS rc_trunkprefix, pkg_trunk.directmedia AS rc_directmedia,
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": pkg_trunk.providertech AS rc_providertech ,pkg_trunk.providerip AS rc_providerip,
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": pkg_trunk.removeprefix AS rc_removeprefix, pkg_trunk.failover_trunk AS rt_failover_trunk,
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": pkg_trunk.addparameter AS rt_addparameter_trunk, pkg_trunk.status, pkg_trunk.inuse, pkg_trunk.maxuse,
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": pkg_trunk.allow_error,pkg_trunk.if_max_use, pkg_rate.additional_grace AS additional_grace, minimal_time_charge,
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": minimal_time_buy, pkg_trunk.link_sms, pkg_trunk.user user, pkg_trunk.secret, package_offer ,
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": pkg_trunk.id_provider, pkg_provider.credit_control, pkg_provider.credit
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": FROM pkg_plan
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": LEFT JOIN pkg_rate ON
pkg_plan.id = pkg_rate.id_plan
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": LEFT JOIN pkg_trunk AS pkg_trunk ON
pkg_trunk.id = pkg_rate.id_trunk
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": LEFT JOIN pkg_prefix ON pkg_rate.id_prefix =
pkg_prefix.id > "/var/www/html/mbilling/resources/asterisk/mbilling.php": LEFT JOIN pkg_provider ON pkg_trunk.id_provider =
pkg_provider.id > "/var/www/html/mbilling/resources/asterisk/mbilling.php": WHERE
pkg_plan.id=1 AND pkg_rate.status = 1 AND (prefix LIKE '&_%' ESCAPE '&' AND '
13023048486'
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": REGEXP REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CONCAT('^', prefix, '$'),
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": 'X', '[0-9]'), 'Z', '[1-9]'), 'N', '[2-9]'), '.', '.+'), '_', ''))
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": ORDER BY LENGTH( prefix ) DESC LIMIT 1
-- "/var/www/html/mbilling/resources/asterisk/mbilling.php": The number
13023048486, no exist in the plan 1
-- "/var/www/html/mbilling/resources/asterisk/mbilling.php": prepaid-dest-unreachable
-- <SIP/16259-00000008> Playing 'prepaid-dest-unreachable.gsm' (escape_digits=#) (sample_offset 0) (language 'en')
> "/var/www/html/mbilling/resources/asterisk/mbilling.php": Hangup Call
13023048486 Username 16259
-- AGI Script Executing Application: (HANGUP) Options: (1)
-- <SIP/16259-00000008>AGI Script /var/www/html/mbilling/resources/asterisk/mbilling.php completed, returning 4
== Spawn extension (billing,
13023048486, 1) exited non-zero on 'SIP/16259-00000008'
-- Executing [h@billing:1] Hangup("SIP/16259-00000008", "") in new stack
== Spawn extension (billing, h, 1) exited non-zero on 'SIP/16259-00000008'
Can you help me with this.