<div dir="ltr"><div>hello Noll</div>
<div> </div>
<div>thank you for your help</div>
<div> </div>
<div>i would to ask you please, i want to store the phone number of the customer in the option_name column when he press 3 in context menu</div>
<div> </div>
<div>i have created a database "aheevacss" with user "aheevaccs" and password "aheevaccs" and also i have creatd a table in this database name of table test with two columns:<br>option_name varchar(15)<br>
count int</div>
<div> </div>
<div>1-how can i check if the app_mysql module compiled and loaded i use asterisk 1.4 and if not installed how can ido in order to install and loaded it</div>
<div> </div>
<div>2- can you please veify the menu below and tell me waht is wrong</div>
<div> </div>
<div>thanks and regards</div>
<div> </div>
<div>[default]</div>
<div>exten => 529,1,Ringing()<br>exten => 529,2,Wait(4)<br>exten => 529,3,Goto(accueil,s,1)</div>
<div><br>[accueil] ; définition d’un contexte pour l’accueil<br>exten => s,1,SetGlobalVar(sounds_path=/var/lib/asterisk/sounds/)<br>exten => s,2,Background(${sounds_path}welcome)<br>exten => s,3,goto(accueil,s,1)<br>
exten => #,1,Goto(menu,s,1)<br>exten => i,1,Playback(${sounds_path}erreur-saisie)<br>exten => i,2,goto(accueil,s,1)<br>exten => t,1,Goto(accueil,s,1)</div>
<div> </div>
<div>[menu]<br>exten => s,1,Background(${sounds_path}menu)<br>exten => 0,1,Goto(menu,s,1)<br>exten => 1,1,Goto(appel,s,1)<br>exten => 2,1,Goto(message,s,1)<br>exten => 3,1,NoOp(User chose support option)<br>
exten => 3,n,MYSQL(Connect connid localhost aheevaccs aheevaccs aheevaccs)<br>exten => 3,n,MYSQL(Query resultid ${connid} update test set count = count + 1 where option_name = 'support')<br>exten => 3,n,MYSQL(Clear ${resultid})<br>
exten => 3,n,MYSQL(Disconnect ${connid})<br>exten => 3,n,Goto(support,s,1)<br>exten => s,2,goto(menu,s,1)<br>exten => i,1,Playback(${sounds_path}erreur-saisie)<br>exten => i,2,Goto(menu,s,1)<br>exten => t,1,Goto(menu,s,1)</div>
<div> </div>
<div>[appel] ; définition d’un contexte pour le menu d’appel<br>exten => s,1,Background(${sounds_path}appel)<br>exten => s,2,WaitExten(10)<br>exten => 0,1,Goto(menu,s,1)<br>exten => 223,1,Dial(SIP/${EXTEN},20,tr)<br>
exten => i,1,Playback(${sounds_path}erreur-saisie)<br>exten => i,2,Goto(appel,s,1)<br>exten => t,1,Goto(appel,s,1)</div>
<div>[message] ; définition d’un contexte pour la messagerie<br>exten => s,1,VoiceMailMain(${CALLERIDNUM})<br>exten => t,1,Hangup()</div>
<div><br>[support] ; définition d’un contexte pour le support<br>exten => s,1,GoToIfTime(09:00-17:00|mon-fri|*|*?s,4)<br>exten => s,2,Playback(${sounds_path}no-relation-support)<br>exten => s,3,Goto(menu,s,1)<br>
exten => s,4,Playback(${sounds_path}relation-support)<br>exten => s,5,Queue(default)<br>exten => t,1,Hangup()<br></div>
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">2011/11/25 Dale Noll <span dir="ltr"><<a href="mailto:dnoll@wi.rr.com">dnoll@wi.rr.com</a>></span><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"><u></u>
<div bgcolor="#ffffff" text="#000000">
<div class="im">On 11/25/2011 10:48 AM, salaheddine elharit wrote:
<blockquote type="cite">
<div dir="ltr">
<div><br>thanks for your response </div>
<div> </div>
<div>i use mysql like a database and my question when the customer press 3 in context menu i want to stok this variable in a table in my database and i want to get this variable after</div>
<div>could you please give an exemple like below</div>
<div> </div>
<div>thanks and regards</div>
<div> </div>
<div>[menu]<br>exten => s,1,Background(${sounds_path}menu)<br>exten => 0,1,Goto(menu,s,1)<br>exten => 1,1,Goto(appel,s,1)<br>exten => 2,1,Goto(message,s,1)<br>
<p style="MARGIN: 0cm 0cm 0pt" class="MsoNormal"><span style="COLOR: red"><font size="3"><font face="Times New
Roman">exten => 3,1,Goto(support,s,1) </font></font></span></p>exten => s,2,goto(menu,s,1)<br>exten => i,1,Playback(${sounds_path}erreur-saisie)<br>exten => i,2,Goto(menu,s,1)<br>exten => t,1,Goto(menu,s,1)<br>
</div><br></div></blockquote><br></div>It is difficult to get a good example because I do not know what you are looking to save. You say you want to store the variable, but the only variable you have in this case is the digit the user entered, in this case '3'. If you are trying to count the number of times callers press option '3', then it is a simple update. <br>
<br>If you have the app_mysql module compiled and loaded you can user the MYSQL() app.<br><a href="http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL" target="_blank">http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL</a><br>
<br>If you do not want would prefer to setup an ODBC connection, that is a bid more complex as you have to setup unixODBC ( /etc/odbcinst.ini, /etc/odbc.ini ), then setup res_odbc(/etc/asterisk/res_odbc.conf) and func_odbc (/etc/asterisk/func_odbc.conf).<br>
<br>How you update the database from within dialplan depends on which access method you choose.<br><br>Assume you have a mysql table with two columns:<br>option_name varchar(15)<br>count int<br><br><br>You could write something like this if you are using app_mysql<br>
<br>exten => 3,1,NoOp(User chose support option)<br>exten => 3,n,MYSQL(Connect connid localhost database_user database_password database_name)<br>exten => 3,n,MYSQL(Query resultid ${connid} update counter_table set count = count + 1 where option_name = 'support')<br>
exten => 3,n,MYSQL(Clear ${resultid})<br>exten => 3,n,MYSQL(Disconnect ${connid})<br>exten => 3,n,Goto(support,s,1)
<div class="im"><br><br><br><br><br><pre cols="72">--
"The truth speaks for itself. I'm just the messenger."
Lyta Alexander - Babylon 5
</pre></div></div><br>--<br>_____________________________________________________________________<br>-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com/" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br> <a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div>