If I modify the file
/var/www/opensips_cp/web/tools/system/dialplan/dialplan.php
and comment out the following:
// if(get_magic_quotes_gpc()==0){
// $match_exp =
mysql_real_escape_string($match_exp, *$link*);
// }
The updates work fine. I think noticed that the ref to
*$link* sits below this line in the "modify" section so I
decided to remove the $link ref in the above lines and then
uncommented the lines leaving the modify section like this
if ($errors=="") {
if(get_magic_quotes_gpc()==0){
$match_exp =
mysql_real_escape_string($match_exp);
}
$sql = "SELECT * FROM ".$table.
" WHERE dpid=" .$dpid. " AND
match_exp='" .$match_exp. "'".
" AND id!=".$id;
$resultset = *$link*->queryAll($sql);
Let me know if I've broken something as a result but this
appears to have corrected the problem I was having. Unknown
of any side effects currently :) Take a look and let me
know your thoughts.
Jeff
On Wed, Aug 24, 2016 at 6:22 PM, Jeff Wilkie
<[email protected] <mailto:[email protected]>> wrote:
Here is what it looks like to my db when I create a
DialPlan
20 QuerySELECT * FROM dialplan WHERE dpid=36 AND
match_exp='877'
20 QueryPREPARE
MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74
FROM 'INSERT INTO dialplan\n(dpid, pr, match_op,
match_exp, match_flags, subst_exp, \nrepl_exp, attrs)
VALUES \n(36, 0,1, \'877\',0,\'\',\'\',\'.30\')'
20 PrepareINSERT INTO dialplan
(dpid, pr, match_op, match_exp, match_flags, subst_exp,
repl_exp, attrs) VALUES
(36, 0,1, '877',0,'','','.30')
20 QueryEXECUTE
MDB2_STATEMENT_mysql_a9e5e113b009b855c4d690637965bc74
20 ExecuteINSERT INTO dialplan
(dpid, pr, match_op, match_exp, match_flags, subst_exp,
repl_exp, attrs) VALUES
(36, 0,1, '877',0,'','','.30')
This is what happens when I edit that same DialPlan
23 Queryselect * from dialplan where id='9030'
23 Quit
24 QuerySELECT * FROM dialplan WHERE dpid=36 AND
match_exp='' AND id!=9030
24 QueryPREPARE
MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2
FROM 'UPDATE dialplan SET dpid=36, pr = 0, match_op= 1,
match_exp =\'\', match_flags=0, subst_exp = \'\',
repl_exp=\'\', attrs= \'.30\' WHERE id=9030'
24 PrepareUPDATE dialplan SET dpid=36, pr = 0,
match_op= 1, match_exp ='', match_flags=0, subst_exp =
'', repl_exp='', attrs= '.30' WHERE id=9030
24 QueryEXECUTE
MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2
24 ExecuteUPDATE dialplan SET dpid=36, pr = 0,
match_op= 1, match_exp ='', match_flags=0, subst_exp =
'', repl_exp='', attrs= '.30' WHERE id=9030
24 QueryDEALLOCATE PREPARE
MDB2_STATEMENT_mysql_880efa45d78ebff7cbf5f617428df4d2
24 Quit
You can see that the container for match_ex is not
getting passed to the '24' SELECT statement which ends
in a 0 results query apparently.
Thanks
Jeff
On Wed, Aug 24, 2016 at 5:30 PM, Jeff Wilkie
<[email protected] <mailto:[email protected]>> wrote:
Yes. After any edits followed by a save with the
attribute field active as text causes "Matching
Regular Expression" to be deleted.
Thanks
Jeff
On Wed, Aug 24, 2016 at 5:15 PM, Bogdan-Andrei Iancu
<[email protected] <mailto:[email protected]>>
wrote:
Jeff, You mean "Matching Regular Expression",
right ? upon performing an edit + save where you
only changed the attrs, the "Matching Regular
Expression" gets to empty ? Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
<http://www.opensips-solutions.com>
On 24.08.2016 23:25, Jeff Wilkie wrote:
Ok. The value now displays but if you modify
the value and hit save, it kills the regex
value upon saving. Also, you cannot add the
regex value back into the row. All other
values appear to be kept.
Thanks
Jeff
On Wed, Aug 24, 2016 at 11:35 AM, Bogdan-Andrei
Iancu <[email protected]
<mailto:[email protected]>> wrote:
Hi Jeff, I spotted the issue and fixed it
on GIT repo. Please give it a try and let
me know if it works for you too. Thanks and
regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
<http://www.opensips-solutions.com>
On 24.08.2016 17:46, Jeff Wilkie wrote:
Yes, The text box is there but when you
place a value in a preexisting dial plan,
the result in the DB is just the value in
the text attribute field with no dial plan
information. By editing or adding an
attribute it kills the rest of the dial
plan that you were editing and you cannot
add the dial plan information back in via
the CP as long as an attribute in text
form is added. The same does not happen
if using check box. I can provide pics if
you'd like. The only var changed is the
$dialplan_attributes_mode = 1
Jeff Wilkie
Chief Technology Officer
US IP Communications 919.297.1057
<tel:919.297.1057> /"This e-mail
communication and any attachments may
contain confidential and privileged
information and is for use by the
designated addressee(s) named above only.
Any files transmitted with it are
confidential and intended solely for the
use of the individual to whom it is
addressed. Any views or opinions presented
are solely those of the author and do not
necessarily represent those of USIPCOM,
LLC. If you are not the intended
addressee, you are hereby notified that
you have received this communication in
error and that any use or reproduction of
this email or its contents is strictly
prohibited and may be unlawful. If you
have received this communication in error,
please notify us immediately by replying
to this message and deleting it from your
computer. Thank you". /
On Wed, Aug 24, 2016 at 5:20 AM,
Bogdan-Andrei Iancu <[email protected]
<mailto:[email protected]>> wrote:
Hi Jeff, You mean you do not get the
Attributes text area at all in the
Edit section ? Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
<http://www.opensips-solutions.com>
On 23.08.2016 00:56, Jeff Wilkie wrote:
New small issue with DIALPLAN in the
CP. Running OSIPS 1.10 with CP 5.0
It appears that when modifying the CP
for Dialplan attributes as text, they
do not appear in the edit section
once applied. The attributes do show
up in the view list of dial plans but
if you go back to edit the attrs
again, they are not there. I dot not
have the same problem when using
attrs as checkboxes. Is there more
code in the local files that require
editing to display these values?
Also, if an entry in the Dialplan was
once a checkbox value but I've not
converted the mode to text, the value
does not show up in the text box to
be edited.
# Attention : advanced options !!
//database tables
$config->table_dialplan = "dialplan";
$config->results_per_page = 20;
$config->results_page_range = 5;
$config->attrs_cb=array(
// name , description
array("a","Descr a"),
array("b","Descr b"),
array("c","Descr c"),
array("d","Descr d"),
array("e","Descr e"),
array("f","Descr f"),
);
$config->cb_per_row = 3;
$talk_to_this_assoc_id = 1 ;
// Dialplan - Add/Edit new
Translation Rule - Attributes input type
// 0 - checkboxes
// 1 - text
$dialplan_attributes_mode = 1 ;
?>
Jeff
_______________________________________________
Users mailing list
[email protected]
<mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
<http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
