Re: [asterisk-users] PHP can't insert - Can someone please help

2010-07-10 Thread Zeeshan Zakaria
Its not wise to haste in posting for help without first spending sometime thinking yourself. Your mysql syntax is not right, you can clearly see the missing single quotes starting from 'ext-local. I would also suggest to use a different syntax for this mysql statement, i.e. using SET instead of

Re: [asterisk-users] PHP can't insert - Can someone please help

2010-07-10 Thread bruce bruce
Thank you for the amazing reply. First few lines of your e-mail was EXACTLY getting me to where I made a mistake. I guess I didn't take the () and ' ' at their face value and was looking somewhere else for the problem. For sanatizing you mean checking the numbers to make sure they are valid

Re: [asterisk-users] PHP can't insert - Can someone please help

2010-07-10 Thread bruce bruce
Further to my last post, I added this to santize. I also created a new mysql user with access to only findmefollow portion of the asterisk table for limited access and assigned only two simultaneous connections with only 10 changes queries per hour (as I know that no more queries will be put

Re: [asterisk-users] PHP can't insert - Can someone please help

2010-07-10 Thread Gerald A
Hi Bruce, On Sat, Jul 10, 2010 at 11:12 AM, bruce bruce bruceb...@gmail.com wrote: Further to my last post, I added this to santize. I also created a new mysql user with access to only findmefollow portion of the asterisk table for limited access and assigned only two simultaneous connections

[asterisk-users] How can get user inputs from called party after dial?

2010-07-10 Thread eyal goltzman
Hi, I want to dial a party, play him a message and wait for his input, i.e. DTMF digits and use them to control the rest of the dial plan. How do I do it? If I use Dial it will not return until the end of the call, isn't it? Thanks, Eyal --

Re: [asterisk-users] PHP can't insert - Can someone please help

2010-07-10 Thread bruce bruce
Thanks again. Apparently all POST variables come through as strings. The function you pointed out is I think already built in php as is_numeric() http://www.php.net/manual/en/function.is-numeric.php. http://php.net/manual/en/function.is-int.php

Re: [asterisk-users] How can get user inputs from called party after dial?

2010-07-10 Thread bruce bruce
You need read(): http://www.voip-info.org/wiki/view/Asterisk+cmd+Read http://www.voip-info.org/wiki/view/Asterisk+cmd+ReadIt's as easy as: exten = s,n,Read(variable,,11) exten = s,n,NoOp(${variable}) Above will take up to 11 digits input by user and will display it back in NoOP on Asterisk CLI.

Re: [asterisk-users] How can get user inputs from called party after dial?

2010-07-10 Thread Eyal Goltzman
Thanks, but I'm missing something here, the dial command is where? I need to do something like: Dial(1234) Read(1 digit) DoSomthing(based on digit from 1234) And as far as I understand the Dial start the call and only come back (ig you use the g option) after call finished. Eyal

Re: [asterisk-users] PHP can't insert - Can someone please help

2010-07-10 Thread bruce bruce
Here is the steel strong sanitizer: $npaa = $_POST[anpa]; $nxxa = $_POST[anxx]; $blocka = $_POST[ablock]; # Sanitize $blocka_san = strspn($blocka, 0123456789); *if ($blocka_san==4 is_numeric($npaa) is_numeric($nxxa) is_numeric($blocka) $npaa=200 $nxxa=200 $npaa!=900 $npaa!=911) * * * *

Re: [asterisk-users] How can get user inputs from called party after dial?

2010-07-10 Thread bruce bruce
You need to do some reading :-) I will give you a quick teach here. At the end of file /etc/asterisk/extensions_custom.conf (if you are running FreePBX) OR in /etc/asterisk/extensions.conf (if you are running vanilla Asterisk) add this: [first-Dialplan] exten = s,1,Answer exten =

Re: [asterisk-users] How can get user inputs from called party after dial?

2010-07-10 Thread bruce bruce
For dial you do this: [first-Dialplan] exten = s,1,Answer exten = s,n,Dial(SIP/provider/111222) exten = s,n,Playback(Welcome) exten = s,n,Read(numb,,10) exten = s,n,NoOp(${numb}) -Bruce On Sat, Jul 10, 2010 at 2:51 PM, bruce bruce bruceb...@gmail.com wrote: You need to do some reading :-)

Re: [asterisk-users] How can get user inputs from called party after dial?

2010-07-10 Thread Eyal Goltzman
Thank you Bruce, I think we are not on the same page. I have an AMI script that issue an originate command, after one channel is connected I'm in my dialplan at extensions_custom.conf (I use FreePBX). Now I'm issuing a Dial command to the another party that when he pick up the phone I

Re: [asterisk-users] How can get user inputs from called party after dial?

2010-07-10 Thread Eyal Goltzman
Thank you Bruce, In the below example you sent the dialplan will stop after Dial. I found the solution to my problem in the M option of the Dial command that let you run a macro BEFORE the parties are connected and continue the dialplan based on the MACRO_RESULT. Thanks for your help,

Re: [asterisk-users] How can get user inputs from called party after dial?

2010-07-10 Thread Steve Edwards
On Sat, 10 Jul 2010, bruce bruce wrote: You need to do some reading :-) Now that is funny -- maybe you could take your own advice and look at http://www.php.net/docs.php instead of posting please help me debug code I'm too lazy to even see if PHP says it is syntactically correct and

Re: [asterisk-users] How can get user inputs from called party after dial?

2010-07-10 Thread bruce bruce
I was under the impression that he is new to Asterisk. No need to fuss. Hence the :-) On Sat, Jul 10, 2010 at 3:35 PM, Steve Edwards asterisk@sedwards.comwrote: On Sat, 10 Jul 2010, bruce bruce wrote: You need to do some reading :-) Now that is funny -- maybe you could take your own

Re: [asterisk-users] SIP Trunk configuration problem - fromdomain

2010-07-10 Thread Trevor Benson
you need to set your external IP in the sip.conf to be your public IP after NAT (assuming your talking over a public network). That way when the sip request goes out and it sees the IP address your are sending to is outside your localnets it changes the SIP header to use the x.y.z.w IP you set

Re: [asterisk-users] PHP can't insert - Can someone please help

2010-07-10 Thread Steve Edwards
On Sat, 10 Jul 2010, bruce bruce wrote: Here is the steel strong sanitizer: $npaa = $_POST[anpa]; $nxxa = $_POST[anxx]; $blocka = $_POST[ablock]; # Sanitize $blocka_san = strspn($blocka, 0123456789); if ($blocka_san==4 is_numeric($npaa) is_numeric($nxxa) is_numeric($blocka) $npaa=200