[Asterisk-Users] ChanSpy by anthm and more...

[Kannaiyan Natesan]

How do you think about adding array to pbx variable so that it will be 
complete.

exten => s,3,SayNumber(${missedcall}[${i}])

-Kannaiyan


----- Original Message ----- 
From: "Brian West" <brian at bkw.org>
To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" 
<asterisk-users at lists.digium.com>
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: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
>> bounces at lists.digium.com] 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" <brian at bkw.org>
>> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'"
>> <asterisk-users at lists.digium.com>
>> 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: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
>> >> bounces at lists.digium.com] 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: asterisk-users-bounces at lists.digium.com 
>> >> > [mailto:asterisk-users-
>> >> > bounces at lists.digium.com] On Behalf Of Brian West
>> >> > Sent: Sunday, September 05, 2004 12:26 PM
>> >> > To: asterisk-users at lists.digium.com
>> >> > 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
>> >> > Asterisk-Users at lists.digium.com
>> >> > 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
>> >> Asterisk-Users at lists.digium.com
>> >> 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
>> > Asterisk-Users at lists.digium.com
>> > 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
>> Asterisk-Users at lists.digium.com
>> 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
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
>