API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 17th, 2018
64
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.33 KB | None | 0 0
raw download clone embed print report
  1. -- Executing [000037240880847@billing:1] AGI("SIP/559101002-00068646", ""/var/www/html/mbilling/resources/asterisk/mbilling.php"") in new stack
  2. -- Launched AGI Script /var/www/html/mbilling/resources/asterisk/mbilling.php
  3. -- Remote UNIX connection
  4. -- Remote UNIX connection disconnected
  5. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Start MBilling AGI
  6. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT id, config_key , config_value , config_group_title FROM pkg_configuration
  7. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Start MBilling AGI
  8. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Check If Is Did 00037240880847
  9. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_did WHERE did = '00037240880847' LIMIT 1
  10. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_sip WHERE name = '000037240880847' LIMIT 1
  11. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": CALL TO PSTN
  12. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": AuthenticateUser 559101001
  13. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Try accountcode authentication 559101001
  14. > "/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 = '559101001' LIMIT 1
  15. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_sip WHERE name = '559101002' LIMIT 1
  16. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": AUTHENTICATION BY ACCOUNTCODE:559101001
  17. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT id,portabilidadeFixed,portabilidadeMobile FROM pkg_plan WHERE techprefix = '00003' LIMIT 1
  18. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": use_dnid:1 && len_dnid:(15 || len_exten:15 ) && (try_num:0)
  19. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": USE_DNID DESTINATION -> 000037240880847
  20. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": REMOVE INTERNACIONAL PREFIX -> 0037240880847
  21. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Grab :0 Replacement: 55 Phone Before: 0037240880847
  22. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Grab :* Replacement: 5555 Phone Before: 55037240880847
  23. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Grab :* Replacement: 5555 Phone Before: 55037240880847
  24. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Phone After translation: 55037240880847
  25. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": consulta portabilidade numero 55037240880847
  26. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT company FROM pkg_portabilidade
  27. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": WHERE number = '037240880847' ORDER BY id DESC LIMIT 1
  28. -- "/var/www/html/mbilling/resources/asterisk/mbilling.php": CONSULTA DA PORTABILIDADE ->Numero sem operadora->111139955037240880847
  29. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": CONSULTA DA PORTABILIDADE ->111139955037240880847
  30. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": USERNAME=559101001 DESTINATION=111139955037240880847 PLAN=38 CREDIT=8901.3558
  31. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT length FROM pkg_prefix_length WHERE code = '11' LIMIT 1
  32. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT lcrtype, pkg_plan.id AS id_plan, pkg_prefix.prefix AS dialprefix,
  33. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": pkg_plan.name, pkg_rate.id_prefix, pkg_rate.id AS id_rate, buyrate, buyrateinitblock buyrateinitblock,
  34. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": buyrateincrement, rateinitial, initblock, billingblock, connectcharge, disconnectcharge disconnectcharge,
  35. > "/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,
  36. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": pkg_trunk.providertech AS rc_providertech ,pkg_trunk.providerip AS rc_providerip,
  37. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": pkg_trunk.removeprefix AS rc_removeprefix, pkg_trunk.failover_trunk AS rt_failover_trunk,
  38. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": pkg_trunk.addparameter AS rt_addparameter_trunk, pkg_trunk.status, pkg_trunk.inuse, pkg_trunk.maxuse,
  39. > "/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,
  40. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": minimal_time_buy, pkg_trunk.link_sms, pkg_trunk.user user, pkg_trunk.secret, package_offer ,
  41. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": pkg_trunk.id_provider, pkg_provider.credit_control, pkg_provider.credit
  42. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": FROM pkg_plan
  43. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": LEFT JOIN pkg_rate ON pkg_plan.id = pkg_rate.id_plan
  44. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": LEFT JOIN pkg_trunk AS pkg_trunk ON pkg_trunk.id = pkg_rate.id_trunk
  45. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": LEFT JOIN pkg_prefix ON pkg_rate.id_prefix = pkg_prefix.id
  46. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": LEFT JOIN pkg_provider ON pkg_trunk.id_provider = pkg_provider.id
  47. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": WHERE pkg_plan.id=38 AND pkg_rate.status = 1 AND (prefix='11113995503' OR prefix='1111399550' OR prefix='111139955' OR prefix='11113995' OR prefix='1111399' OR prefix='111139' OR prefix='11113' OR prefix='1111' OR prefix='111' OR prefix='11' OR prefix='1' )
  48. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": ORDER BY LENGTH( prefix ) DESC LIMIT 3
  49. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": SELECT * FROM pkg_user_rate WHERE id_user = 9 AND id_prefix = '11113' LIMIT 1
  50. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": NUMBER TRUNK FOUND 2
  51. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": NUMBER TARIFF FOUND -> 2
  52. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": Credit 8901.3558
  53. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": timeout ->> 1841658
  54. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": UPDATE pkg_call_chart SET total = total + 1 WHERE date > '2018-07-17 17:50' LIMIT 1
  55. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": UPDATE pkg_trunk SET call_total = call_total + 1 WHERE id=84 LIMIT 1
  56. > "/var/www/html/mbilling/resources/asterisk/mbilling.php": DIAL sip/GSM_Geral/1111037240880847,50
  57. -- AGI Script Executing Application: (DIAL) Options: (sip/GSM_Geral/1111037240880847,50)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!