<div>Hi</div>
<div> </div>
<div>iam trying like this in my extension.conf</div>
<div>some one refered in the news group past</div>
<div> </div>
<div> </div>
<div>error in messages</div>
<div> </div>
<div>Sep 1 21:31:42 WARNING[28610] file.c: File Goodbye does not exist in any format<br>Sep 1 21:31:42 WARNING[28610] file.c: Unable to open Goodbye (format ulaw): No such file or directory<br>Sep 1 21:31:42 WARNING[28610] app_playback.c: ast_streamfile failed on SIP/88888-3ca6 for Goodbye
<br><br><br>exten => 888,1,Read(${CALLERIDNUM})<br>exten => 888,2,MYSQL(Connect connid <a href="http://127.0.0.1">127.0.0.1</a> root password mydatabase)<br>exten => 888,3,MYSQL(Query resultid ${connid} select total from balance where username=${CALLERIDNUM})
<br>exten => 888,4,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)<br>exten => 888,5,MYSQL(Clear ${resultid})<br>exten => 888,6,Playback(Goodbye)<br>exten => 888,7,Hangup</div>
<div> </div>
<div> </div>
<div>iam calling from my extension to 888</div>
<div> </div>
<div>Ram</div>
<div><br> </div>
<div><span class="gmail_quote">On 9/1/06, <b class="gmail_sendername">John Millican</b> <<a href="mailto:jmillican@sentinelcommunications.com">jmillican@sentinelcommunications.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">On Friday September 01 2006 10:19 am, ram wrote:<br>> Hi<br>><br>> thanks for the quick reply<br>
><br>> any documents to read to achive this<br>> or any examples would be great to read<br>><br>> Ram<br>><br>> On 9/1/06, John Millican <<a href="mailto:jmillican@sentinelcommunications.com">jmillican@sentinelcommunications.com
</a>> wrote:<br>> > On Friday September 01 2006 9:27 am, ram wrote:<br>> > > Hi<br>> > ><br>> > > how can i do balance anouncement by using asterisk<br>> > ><br>> > > take example, i have table balance , user name 99999, balance 200$
<br>> > ><br>> > > user dial *98 or what ever, then i need anouce his balance is 200$, by<br>> > > reading from that row<br>> > ><br>> > > any clues how can i achive this or is this possible ?
<br>> > ><br>> > > Ram<br>> ><br>> > Create an AGI script that does a db look up for the ballance and then<br>> > pass the<br>> > result back to Cepstral or Festival or your favorite text to speech
<br>> > software.<br>> > John M<br>> ><br>Try google or <a href="http://voip-info.org">voip-info.org</a> and search for<br>Asterisk AGI should yeid some good results.<br>AGI can be called from the dial plan and written in your favorite language
<br>i.e. PHP, C++, Perl, C, Java<br>or start here:<br><a href="http://home.cogeco.ca/~camstuff/agi.html">http://home.cogeco.ca/~camstuff/agi.html</a><br><a href="http://asterisk.drunkcoder.com/agi.cgi">http://asterisk.drunkcoder.com/agi.cgi
</a><br><br>John M<br><br>_______________________________________________<br>--Bandwidth and Colocation provided by <a href="http://Easynews.com">Easynews.com</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">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br>