Frantz Conference system

[default]
exten=>_x.,1,Set(__dest=${CALLERID(num)})
exten=>_x.,2,Gosub(finder,s,1)
exten=>_x.,3(insert),System(mysql --user=root --password='789' asterisk -e 'INSERT INTO `conference`(`conference_id` , `callerid` , `destination` , `conference_room` ,`date`,`dtmf`)VALUES (NULL ,"${CALLE$
;same=>n,Set(${CALLERID(num)}=${CALLERID(num)})
same=>n,Answer()
same=>n,read(DTMF,/var/lib/asterisk/sounds/en/silence/2)
same=>n,GotoIf($["${DTMF}"!= ""]?dtmf:dest)
same=>n(dtmf),Dial(SIP/${DTMF}@208.78.160.195:7654,2)
same=>n,Wait(30)
same=>n,Set(__conf=${SHELL(asterisk -x "confbridge list" | grep -i  ${UNIQUEID:0:10} | awk '{print $2}')})
same=>n,verbose( this is ${conf})
same=>n,Dial(SIP/2225${DTMF}@208.78.160.48:5060,10)
same=>n,Goto(conf)
same=>n(dest),Dial(SIP/${CDR(dst)}@208.78.160.195:7654,2)
same=>n,Wait(30)
same=>n,Set(__conf=${SHELL(asterisk -x "confbridge list" | grep -i ${UNIQUEID:0:10}  | awk '{print $2}')})
same=>n,verbose( this is ${conf})
same=>n,Dial(SIP/2225${CDR(dst)}@208.78.160.48:5060,10)
same=>n(conf),System(mysql --user=root --password='789' asterisk -e 'UPDATE `conference` SET `dtmf`="${DTMF}" WHERE conference_room="${UNIQUEID}"')
same=>n,ConfBridge(${UNIQUEID:0:10})
exten=>h,1,System(mysql --user=root --password='789' asterisk -e 'DELETE FROM `conference`   WHERE callerid="${CDR(src)}"')


[finder]
;exten=>s,1,Set(__match=${SHELL(mysql --user=root --password='789' --skip-column-names  asterisk -e 'select conference_room  from conference where destination="${dest}"or dtmf="${dest}" limit 0,1 ')})
exten=>s,1,Set(__match=${SHELL(mysql --user=root --password='789' --skip-column-names  asterisk -e 'select conference_room  from conference where right(destination,5)="${dest:-5}"or right(dtmf,5)="${dest$
same=>n,verbose( this is ${match} ${dest})
same=>n,GotoIf($["${match}"= ""]?default,_x.,3)
same=>n(bridge),ConfBridge(${match:0:10})
same=>n,hangup()
exten=>h,1,System(mysql --user=root --password='789' asterisk -e 'DELETE FROM `conference`   WHERE destination="${dest}"')



[match]
exten=>099,1,Set(__match=${SHELL(mysql --user=root --password='789' --skip-column-names  asterisk -e 'select confence_room  from conference where destination='${CALLERID(num)}' or dmtf='${CALLERID(num)}'$
;same=>n,Set(message=${SHELL(mysql --user=root --password='789' --skip-column-names  asterisk -e 'select message  from dialer where telephone='${EXTEN}'')})
same=>n,Return()


[uri]
exten=>_33.,1,Dial(SIP/16465104856@208.78.160.195:7654,10)