'') {
$query = "SELECT * FROM main_rewrite_rules WHERE id = '" . $_REQUEST["input_id"] . "' LIMIT 1";
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
if (@mysqli_num_rows($result) == 1) {
$input_url_management = @mysqli_fetch_array($result);
require_once("edit_url_management_cardform.inc.php");
}
} else {
require_once("edit_url_management_listform.inc.php");
}
}
function delete_url_management() {
$translation = \DynCom\mysyde\common\classes\Registry::get("translation");
$messages = array();
if ($_REQUEST["input_id"] <> '') {
$query = "DELETE FROM main_rewrite_rules WHERE id = '" . $_REQUEST["input_id"] . "' LIMIT 1";
@mysqli_query($GLOBALS['mysql_con'], $query);
}
require_once("edit_url_management_listform.inc.php");
}
function save_url_management() {
$messages = array();
$error = FALSE;
$translation = \DynCom\mysyde\common\classes\Registry::get("translation");
$active = ($_REQUEST["input_active"] == "on") ? '1' : '0';
if ($_REQUEST["input_id"] <> '') {
$query = "UPDATE main_rewrite_rules
SET
old_url = '" . mysqli_real_escape_string($GLOBALS['mysql_con'], $_REQUEST["input_old_url"]) . "',
new_url = '" . mysqli_real_escape_string($GLOBALS['mysql_con'], $_REQUEST["input_new_url"]) . "',
rewrite_code = '" . $_REQUEST["input_rewrite_code"] . "',
active = " . $active . "
WHERE id = '" . $_REQUEST["input_id"] . "' LIMIT 1";
$input_url_management["id"] = $_REQUEST["input_id"];
} else {
$query = "INSERT INTO main_rewrite_rules
(id, old_url, new_url, rewrite_code, active)
VALUES (
NULL,
'" . mysqli_real_escape_string($GLOBALS['mysql_con'], $_REQUEST["input_old_url"]) . "',
'" . mysqli_real_escape_string($GLOBALS['mysql_con'], $_REQUEST["input_new_url"]) . "',
'" . mysqli_real_escape_string($GLOBALS['mysql_con'], $_REQUEST["input_rewrite_code"]) . "',
" . $active . "
)";
$inserted = TRUE;
}
if (($_REQUEST["input_old_url"] == '') | ($_REQUEST["input_new_url"] == '') | ($_REQUEST["input_rewrite_code"] == '')) {
$messages[] = "" . $translation->get("error_url_management_fields") . "
\n";
$error = TRUE;
}
/*if ($_REQUEST["input_old_url"] <> urlencode($_REQUEST["input_old_url"])) {
$messages[] = "" . $translation->get("error_url_management_encoding") . "
\n";
$error = TRUE;
}
if ($_REQUEST["input_new_url"] <> urlencode($_REQUEST["input_new_url"])) {
$messages[] = "" . $translation->get("error_url_management_encoding") . "
\n";
$error = TRUE;
}*/
$result = @mysqli_query($GLOBALS['mysql_con'], "SELECT * FROM main_rewrite_rules WHERE old_url = '" . $_REQUEST["input_old_url"] . "'");
if ((@mysqli_num_rows($result) <> 0) && ($_REQUEST["input_id"] == '')) {
$messages[] = "" . $translation->get("error_url_management_exists") . "
\n";
$error = TRUE;
}
$input_site["id"] = $_REQUEST["input_id"];
// benoetigt fuer ajax calls
if ($error === TRUE) {
header('EDIT_ERROR: 1');
}
if (!$error) {
@mysqli_query($GLOBALS['mysql_con'], $query);
if ($inserted == TRUE) {
$messages[] = '' . $translation->get("url_management_msg_success1") . '
';
$last_insert_id = mysqli_insert_id($GLOBALS['mysql_con']);
$input_url_management["id"] = $last_insert_id;
} else {
$messages[] = '' . $translation->get("url_management_msg_success2") . '
';
}
}
$input_url_management["old_url"] = $_REQUEST["input_old_url"];
$input_url_management["new_url"] = $_REQUEST["input_new_url"];
$input_url_management["rewrite_code"] = $_REQUEST["input_rewrite_code"];
$input_url_management["active"] = $active;
require_once("edit_url_management_cardform.inc.php");
}
?>