asterisk 操作mysql DAILPLAN
[globals] DBCurrentHost=localhost DBuser=root DBpass=passw0rd DBname=asterisk [sip] exten => _X.,1,Set(CALLERID(num)=58837999) exten => _X.,n,MySql(connect connid ${DBCurrentHost} ${DBuser} ${DBpass} ${DBname}) exten => _X.,n,set(ID=12) exten => _X.,n,MySql(query resultid ${connid} insert into jd set id=14\, name =\'ppp\') ; exten => _X.,n,MySql(query resultidr ${connid} select name from jd where id=${ID}) ; exten => _X.,n,MySql(Fetch foundrow ${resultidr} name) exten => _X.,n,MySql(clear ${resultidr}) exten => _X.,n,MySql(disconnect ${connid}) exten => _X.,n,noop(${name}) exten => _X.,n,Queue(sipqueue,t,,,150) exten => _X.,n,hangup exten => 3000,1,SetMusicOnHold(default) exten => 3000,n,WaitMusicOnHold(20)
发表评论