diff options
| author | spag <spag@golwen.net> | 2013-02-12 09:41:55 +0100 |
|---|---|---|
| committer | spag <spag@golwen.net> | 2013-02-12 09:41:55 +0100 |
| commit | 0ece4561627130eceb83deef4e5c2df00ec1664e (patch) | |
| tree | f4e62ff18ac251bd813499ba54ecff818bb03a4e /misc/freeswitch/scripts/common/sip_account.lua | |
| parent | 8e55bf891a0520ba241585d8295ccc37ed57b09e (diff) | |
support for registrations to non default profiles
Diffstat (limited to 'misc/freeswitch/scripts/common/sip_account.lua')
| -rw-r--r-- | misc/freeswitch/scripts/common/sip_account.lua | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/misc/freeswitch/scripts/common/sip_account.lua b/misc/freeswitch/scripts/common/sip_account.lua index 8dd432b..d023f20 100644 --- a/misc/freeswitch/scripts/common/sip_account.lua +++ b/misc/freeswitch/scripts/common/sip_account.lua @@ -38,8 +38,12 @@ function SipAccount.find_by_sql(self, where) `a`.`sip_accountable_id`, \ `a`.`hotdeskable`, \ `a`.`gs_node_id`, \ - `b`.`host` \ - FROM `sip_accounts` `a` JOIN `sip_domains` `b` ON `a`.`sip_domain_id` = `b`.`id` \ + `b`.`host`, \ + `c`.`sip_host`, \ + `c`.`profile_name` \ + FROM `sip_accounts` `a` \ + JOIN `sip_domains` `b` ON `a`.`sip_domain_id` = `b`.`id` \ + LEFT JOIN `sip_registrations` `c` ON `a`.`auth_name` = `c`.`sip_user` \ WHERE ' .. where .. ' LIMIT 1'; local sip_account = nil; |