Portions created by the Initial Developer are Copyright (C) 2008-2012 the Initial Developer. All Rights Reserved. Contributor(s): Mark J Crane James Rose */ include "root.php"; require_once "resources/require.php"; require_once "resources/check_auth.php"; require_once "config.php"; if (permission_exists('content_edit')) { //access granted } else { echo "access denied"; exit; } //add multi-lingual support $language = new text; $text = $language->get(); if (count($_POST)>0) { $rss_sub_category_uuid = check_str($_POST["rss_sub_category_uuid"]); $rss_category = check_str($_POST["rss_category"]); $rss_sub_category = check_str($_POST["rss_sub_category"]); $rss_sub_category_description = check_str($_POST["rss_sub_category_description"]); $rss_add_user = check_str($_POST["rss_add_user"]); $rss_add_date = check_str($_POST["rss_add_date"]); //sql update $sql = "update v_rss_sub_category set "; $sql .= "rss_category = '$rss_category', "; $sql .= "rss_sub_category = '$rss_sub_category', "; $sql .= "rss_sub_category_description = '$rss_sub_category_description', "; $sql .= "rss_add_user = '$rss_add_user', "; $sql .= "rss_add_date = '$rss_add_date' "; $sql .= "where domain_uuid = '$domain_uuid' "; $sql .= "and rss_sub_category_uuid = '$rss_sub_category_uuid' "; $count = $db->exec(check_sql($sql)); //echo "Affected Rows: ".$count; $_SESSION["message"] = $text['message-update']; header("Location: rss_sub_categorylist.php"); return; } else { //get data from the db $rss_sub_category_uuid = $_GET["rss_sub_category_uuid"]; $sql = ""; $sql .= "select * from v_rss_sub_category "; $sql .= "where domain_uuid = '$domain_uuid' "; $sql .= "and rss_sub_category_uuid = '$rss_sub_category_uuid' "; $prep_statement = $db->prepare(check_sql($sql)); $prep_statement->execute(); $result = $prep_statement->fetchAll(PDO::FETCH_NAMED); foreach ($result as &$row) { $rss_category = $row["rss_category"]; $rss_sub_category = $row["rss_sub_category"]; $rss_sub_category_description = $row["rss_sub_category_description"]; $rss_add_user = $row["rss_add_user"]; $rss_add_date = $row["rss_add_date"]; break; //limit to 1 row } } require_once "resources/header.php"; echo "
"; echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo "
rss_category
rss_sub_category
rss_sub_category_description
rss_add_user
rss_add_date
"; echo " "; echo "

"; echo " "; echo "
"; echo "

"; echo "
"; require_once "resources/footer.php"; ?>