<div dir="ltr">Hello list,<div><br></div><div style>i need your help about the IVR please </div><div style><br></div><div style>i have asterisk 1.4 installed and i configure an IVR like below </div><div style><br></div><div style>
<div><div>exten => 529,1,Ringing()</div><div>exten => 529,n,Wait(4)</div><div>exten => 529,n,Goto(home,s,1)</div><div><br></div><div style>[home]</div><div>exten => s,1,SetGlobalVar(sounds_path=/var/lib/asterisk/sounds/)</div>
<div>exten => s,n,Background(${sounds_path}welcome)</div><div>exten => s,n,WaitExten(5)</div><div>exten => s,n,goto(home,s,1)</div><div>exten => i,1,Playback(${sounds_path}erreur-saisie)</div><div>exten => i,2,goto(home,s,1)</div>
<div>exten => t,1,Goto(home,s,1)</div><div>exten => 1,1,Goto(call,s,1)</div><div><br></div><div><br></div><div><br></div><div><br></div><div style>[call]</div><div>exten => s,1,NoOp(User chose support option)</div>
<div>exten => s,n,Dial(SIP/228, 30)</div><div>exten => s,n,NoOp(User chose support option)</div><div>exten => s,n,MYSQL(Connect connid localhost database login password)</div><div>exten => s,n,MYSQL(Query resultid ${connid} INSERT\ INTO\ menu\ SET\ callerid='${CALLERID(num)}'\, calldate=now()\, ext="no response"\)</div>
<div>exten => s,n,MYSQL(Clear ${resultid})</div><div>exten => s,n,MYSQL(Disconnect ${connid})</div><div>exten => s,n,hangup</div></div><div><br></div><div style>when i call the number 529 i can get the home and when i press 1 i get the call when there is no response from my sip/228 i can store the date and time in my database </div>
<div style><br></div><div style>but when i handel the call from my sip i can't store the data in my table</div><div style><br></div><div style><div>calldate <span class="" style="white-space:pre"> </span> callerid<span class="" style="white-space:pre"> </span> ext</div>
<div>2013-07-25 14:09:20<span class="" style="white-space:pre"> </span>0661xxxxxx<span class="" style="white-space:pre"> </span> No response</div><div><br></div><div style>my question how can i do in order to store the data in my database with the ext = response or no response </div>
</div><div><br></div><div style>thanks and regards</div><div><br></div></div></div>