Page 582 - Asterisk™: The Future of Telephony

See Also
Hot-Desking (sip.conf), Hot-Desking (func_odbc.conf), Chapter 5, Chapter 6, Read(),
CUT, While(), ISNULL, VoiceMail(), CALLERID, Dial(), GotoIf()

Hot-Desking (func_odbc.conf) Custom dialplan functions
[INFO]
prefix=HOTDESK
dsn=asterisk
read=SELECT ${ARG1} FROM ast_hotdesk WHERE extension = '${ARG2}'

[STATUS]
prefix=HOTDESK
dsn=asterisk
write=UPDATE ast_hotdesk SET status = '${VAL1}', location = '${VAL2}' WHERE extension
= '${ARG1}'
[CHECK_PHONE_LOGINS]
prefix=HOTDESK
dsn=asterisk
read=SELECT COUNT(status) FROM ast_hotdesk WHERE status = '1' AND location = '${ARG1}'

[LOGGED_IN_USER]
prefix=HOTDESK
dsn=asterisk
read=SELECT extension FROM ast_hotdesk WHERE status = '1' AND location = '${ARG1}'
ORDER BY id LIMIT '1' OFFSET '${ARG2}'
[PHONE_STATUS]
prefix=HOTDESK
dsn=asterisk
read=SELECT extension FROM ast_hotdesk WHERE location = '${ARG1}' AND status = '1'
See Also
Hot-Desking (extensions.conf), Hot-Desking (sip.conf), res_odbc.conf

Hot-Desking (sip.conf) Two sample phone configurations and sample service provider configuration
; HOT DESK USERS
[desk_1]
type=friend
host=dynamic
secret=my_special_secret
context=hotdesk
qualify=yes

[desk_2]
type=friend
host=dynamic
secret=my_special_secret

554 | Appendix G: An Example of func_odbc