Subversion Repositories ALCASAR

Compare Revisions

Ignore whitespace Rev 2043 → Rev 2044

/web/acc/manager/lib/sql/change_attrs.php
79,14 → 79,6
continue;
// if value differs from the sql value then update
else{
#if attribute not set, we create it.
if(!isset($old_val) && $sql_attr=='Filter-Id')
{
$res = da_sql_query($link,$config,"UPDATE $table SET value = '$val' WHERE $query_key = '$login' AND attribute = '$sql_attr' AND value = '';");
if (!$res || !da_sql_affected_rows($link,$res,$config))
echo "<b>Change failed for attribute $key: " . da_sql_error($link,$config) . "</b><br>\n";
}
if (isset($item_vals["$key"][$j]) && (isset($old_val) && $old_val !='') || $sql_attr=='Filter-Id'){
$old_val = $item_vals["$key"][$j];
$old_val = da_sql_escape_string($link, $old_val);
95,18 → 87,42
$res = da_sql_query($link,$config,
"UPDATE $table SET value = '$val' WHERE $query_key = '$login' AND
attribute = '$sql_attr' AND value = '$old_val';");
#if filter-id does not exit, we create it (ALCASAR 2.9.2 DDB)
if (!$res || !da_sql_affected_rows($link,$res,$config))
$res = da_sql_query($link,$config,"INSERT INTO $table ($query_key,attribute,value $text2) VALUES ('$login','$sql_attr','00000000', ':=');");
if (!$res || !da_sql_affected_rows($link,$res,$config))
echo "<b>Change failed for attribute $key: " . da_sql_error($link,$config) . "</b><br>\n";
}
else{
if($val != ''){
$res = da_sql_query($link,$config,
"INSERT INTO $table ($query_key,attribute,value $text2)
VALUES ('$login','$sql_attr','$val' $op_val2);");
$old_val = $item_vals["$key"][$j];
$old_val = da_sql_escape_string($link, $old_val);
 
$res = da_sql_query($link,$config,
"UPDATE $table SET value = '$val' WHERE $query_key = '$login' AND
attribute = '$sql_attr' AND value = '$old_val';");
#if attribute does not exist, we create it.
if (!$res || !da_sql_affected_rows($link,$res,$config))
{
$res = da_sql_query($link,$config,"INSERT INTO $table ($query_key,attribute,value $text2) VALUES ('$login','$sql_attr','$val' $op_val2);");
}
 
if (!$res || !da_sql_affected_rows($link,$res,$config))
echo "<b>Change failed for attribute $key: " . da_sql_error($link,$config) . "</b><br>\n";
}
else
{
#if value is empty, we delete this attribute
$old_val = $item_vals["$key"][$j];
$old_val = da_sql_escape_string($link, $old_val);
if(isset($old_val) && $old_val != '')
{
$res = da_sql_query($link,$config,"DELETE FROM $table WHERE $query_key = '$login' AND attribute = '$sql_attr' AND value = '$old_val';");
}
}
}
}
}
/web/intercept.php
541,6 → 541,8
$domain_allowed=explode("#", $line);
if (trim($domain_allowed[1]) != ''){
$domain=explode("\"", $domain_allowed[0]);
#remove every '.' from the beginning of domain
$domain[1] = ltrim($domain[1], '.');
echo "<a href=\"http://".trim($domain[1])."\">".trim($domain_allowed[1])."</a> ";}
}
}