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>
