[asterisk-users] balance anouncement

[ram]

Hi

iam trying like this in my extension.conf
some one refered in the news group past


error in messages

Sep  1 21:31:42 WARNING[28610] file.c: File Goodbye does not exist in any
format
Sep  1 21:31:42 WARNING[28610] file.c: Unable to open Goodbye (format ulaw):
No such file or directory
Sep  1 21:31:42 WARNING[28610] app_playback.c: ast_streamfile failed on
SIP/88888-3ca6 for Goodbye


exten => 888,1,Read(${CALLERIDNUM})
exten => 888,2,MYSQL(Connect connid 127.0.0.1 root password  mydatabase)
exten => 888,3,MYSQL(Query resultid ${connid} select total from balance
where username=${CALLERIDNUM})
exten => 888,4,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE)
exten => 888,5,MYSQL(Clear ${resultid})
exten => 888,6,Playback(Goodbye)
exten => 888,7,Hangup


iam calling from my extension to 888

Ram


On 9/1/06, John Millican <jmillican at sentinelcommunications.com> wrote:
>
> On Friday September 01 2006 10:19 am, ram wrote:
> > Hi
> >
> > thanks for the quick reply
> >
> > any documents to read to achive this
> > or any examples would be great to read
> >
> > Ram
> >
> > On 9/1/06, John Millican <jmillican at sentinelcommunications.com> wrote:
> > > On Friday September 01 2006 9:27 am, ram wrote:
> > > > Hi
> > > >
> > > > how can i do balance anouncement by using asterisk
> > > >
> > > > take example, i have table balance , user name 99999, balance 200$
> > > >
> > > > user dial *98 or what ever, then i need anouce his balance is 200$,
> by
> > > > reading from that row
> > > >
> > > > any clues how can i achive this or is this possible ?
> > > >
> > > > Ram
> > >
> > > Create an AGI script that does a db look up for the ballance and then
> > > pass the
> > > result back to Cepstral or Festival or your favorite text to speech
> > > software.
> > > John M
> > >
> Try google or voip-info.org and search for
> Asterisk AGI  should yeid some good results.
> AGI can be called from the dial plan and written in your favorite language
> i.e. PHP, C++, Perl, C, Java
> or start here:
> http://home.cogeco.ca/~camstuff/agi.html
> http://asterisk.drunkcoder.com/agi.cgi
>
> John M
>
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060901/d1368d4d/attachment.htm