exten => s,3,SayNumber(${missedcall}[${i}])-Kannaiyan
----- Original Message ----- From: "Brian West" <[EMAIL PROTECTED]>
To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" <[EMAIL PROTECTED]>
Sent: Sunday, September 05, 2004 10:02 PM
Subject: RE: [Asterisk-Users] ChanSpy by anthm and more...
No it doesn't its just a nice standalone res that allows you to use SQLite from the dialplan, cli and as a CDR engine and sqlite_Switch.
Its great for a standalone pbx because you can do something like this:
exten => s,1,SQL(SELECT total,balance,lastpaydate FROM customers WHERE callerid=\'${CALLERIDNUM}\') exten => s,2,Playback(your-balance-is) exten => s,3,SayNumber(${balance}) exten => s,4,Playback(dollars)
or something crazy like that.. It turns the first row into channel vars and
you cam use those. This is a lot more powerful and flexible than
DBget/DBput.
Also say you want to do the same query from the CLI
asterisk*CLI> sql use cdr asterisk*CLI> now using /var/lib/asterisk/sqlite/cdr.db
asterisk*CLI> select count(1) from cdr; asterisk*CLI>
|count(1)| |131|
Brian Asterlink.com
-----Original Message----- From: [EMAIL PROTECTED] [mailto:asterisk-users- [EMAIL PROTECTED] On Behalf Of Kannaiyan Natesan Sent: Sunday, September 05, 2004 3:41 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] ChanSpy by anthm and more...
Does it removes the need of external databases (mysql, postgres) or it will work with existing databases?
-Kannaiyan
----- Original Message ----- From: "Brian West" <[EMAIL PROTECTED]> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" <[EMAIL PROTECTED]> Sent: Sunday, September 05, 2004 7:04 PM Subject: RE: [Asterisk-Users] ChanSpy by anthm and more...
> http://bugs.digium.com/bug_view_page.php?bug_id=0002384
>
> Also res_sqlite is out... :)
>
> bkw
>
>> -----Original Message-----
>> From: [EMAIL PROTECTED] [mailto:asterisk-users-
>> [EMAIL PROTECTED] On Behalf Of Brian West
>> Sent: Sunday, September 05, 2004 12:57 PM
>> To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
>> Subject: RE: [Asterisk-Users] ChanSpy by anthm and more...
>>
>> Also don't forget to visit us at Astricon... :)
>>
>> Brian
>> Asterlink.com
>>
>> > -----Original Message-----
>> > From: [EMAIL PROTECTED] >> > [mailto:asterisk-users-
>> > [EMAIL PROTECTED] On Behalf Of Brian West
>> > Sent: Sunday, September 05, 2004 12:26 PM
>> > To: [EMAIL PROTECTED]
>> > Subject: [Asterisk-Users] ChanSpy by anthm and more...
>> >
>> > Everyone we have a few new things to give back to the asterisk
>> community.
>> >
>> > http://bugs.digium.com/bug_view_page.php?bug_id=0002379
>> > http://bugs.digium.com/bug_view_page.php?bug_id=0002380
>> > http://bugs.digium.com/bug_view_page.php?bug_id=0002381
>> >
>> > These include app_chanspy, the ability to spy on ANY bridged call
>> > taking
>> > place inside asterisk. NOT just ZAP as with ZapScan/Barge.
>> >
>> > Native format_* files being used for moh. Reload enabled
>> res_musiconhold.
>> >
>> > format_mp3.c that produces SLNR output to asterisk, format_slinear.c
>> > for
>> > raw
>> > headerless audio, format_base65_wav_gsm.c aka wav49 held in a base64
>> > containers(it can read and playback from these .b64 files)
>> >
>> > All this is thanks to my employer asterlink.com and anthm.
>> >
>> > So everyone please test and provide feedback.
>> >
>> > Thanks,
>> > Brian
>> > Asterlink.com
>> > PS: More to come at a later date.
>> >
>> > _______________________________________________
>> > Asterisk-Users mailing list
>> > [EMAIL PROTECTED]
>> > http://lists.digium.com/mailman/listinfo/asterisk-users
>> > To UNSUBSCRIBE or update options visit:
>> > http://lists.digium.com/mailman/listinfo/asterisk-users
>>
>> _______________________________________________
>> Asterisk-Users mailing list
>> [EMAIL PROTECTED]
>> http://lists.digium.com/mailman/listinfo/asterisk-users
>> To UNSUBSCRIBE or update options visit:
>> http://lists.digium.com/mailman/listinfo/asterisk-users
>
> _______________________________________________
> Asterisk-Users mailing list
> [EMAIL PROTECTED]
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
