[MySQL] exten => 1234,1,Answer() exten => 1234,n,NoOp(${CALLERID(num)}) exten => 1234,n,Read(caller,,10) exten => 1234,n,Set(CID=${CALLERID(num)}) exten => 1234,n,NoOp(${caller}) exten => 1234,n,Set(userCID=${caller}) exten => 1234,n,MYSQL(Connect connid YOUR_IP username pwd Database_name) exten => 1234,n,MYSQL(Query resultid ${connid} select * from customer where caller='${userCID}') exten => 1234,n,MYSQL(Fetch fetchid ${resultid} id name) exten => 1234,n,SayAlpha(${name}) exten => 1234,n,Saydigits(${id}) exten => 1234,n,MYSQL(Clear ${resultid}) exten => 1234,n,MYSQL(Disconnect ${connid}) exten => 1234,n,Playback(vm-goodbye) Tested on Asterisk 11.22
Comments
Post a Comment