/**
* Displays News Category Form
*/
function display_news_cat_form()
{
global $aidlink;
$locale = fusion_get_locale();
if (isset($_POST['cancel'])) {
redirect(FUSION_SELF . $aidlink . "§ion=news_category");
}
/**
* Delete category images
*/
if (isset($_GET['action']) && $_GET['action'] == "delete" && (isset($_GET['cat_id']) && isnum($_GET['cat_id']))) {
$result = dbcount("(news_cat)", DB_NEWS, "news_cat='" . $_GET['cat_id'] . "'") || dbcount("(news_cat_id)", DB_NEWS_CATS, "news_cat_parent='" . $_GET['cat_id'] . "'");
if (!empty($result)) {
addNotice("success", $locale['news_0152'] . $locale['news_0153']);
} else {
$result = dbquery("DELETE FROM " . DB_NEWS_CATS . " WHERE news_cat_id='" . $_GET['cat_id'] . "'");
addNotice("success", $locale['news_0154']);
}
// FUSION_REQUEST without the "action" gets
redirect(clean_request("", array("action"), FALSE));
}
$data = array("news_cat_id" => 0, "news_cat_name" => "", "news_cat_hidden" => array(), "news_cat_parent" => 0, "news_cat_image" => "", "news_cat_draft" => FALSE, "news_cat_visibility" => iGUEST, "news_cat_sticky" => FALSE, "news_cat_featured" => FALSE, "news_cat_language" => LANGUAGE);
$formAction = FUSION_REQUEST;
$formTitle = $locale['news_0022'];
// if edit, override $data
if (isset($_POST['save_cat']) or isset($_POST['save_cat_and_close'])) {
$inputArray = array("news_cat_id" => form_sanitizer($_POST['news_cat_id'], "", "news_cat_id"), "news_cat_name" => form_sanitizer($_POST['news_cat_name'], "", "news_cat_name"), "news_cat_parent" => form_sanitizer($_POST['news_cat_parent'], 0, "news_cat_parent"), "news_cat_visibility" => form_sanitizer($_POST['news_cat_visibility'], 0, "news_cat_visibility"), "news_cat_draft" => isset($_POST['news_cat_draft']) ? 1 : 0, "news_cat_sticky" => isset($_POST['news_cat_sticky']) ? 1 : 0, "news_cat_image" => form_sanitizer($_POST['news_cat_image'], "", "news_cat_image"), "news_cat_language" => form_sanitizer($_POST['news_cat_language'], LANGUAGE, "news_cat_language"));
$categoryNameCheck = array("when_updating" => "news_cat_name='" . $inputArray['news_cat_name'] . "' and news_cat_id !='" . $inputArray['news_cat_id'] . "' " . (multilang_table("NS") ? "and news_cat_language = '" . LANGUAGE . "'" : ""), "when_saving" => "news_cat_name='" . $inputArray['news_cat_name'] . "' " . (multilang_table("NS") ? "and news_cat_language = '" . LANGUAGE . "'" : ""));
if (defender::safe()) {
// check category name is unique when updating
if (dbcount("(news_cat_id)", DB_NEWS_CATS, "news_cat_id='" . $inputArray['news_cat_id'] . "'")) {
if (!dbcount("(news_cat_id)", DB_NEWS_CATS, $categoryNameCheck['when_updating'])) {
dbquery_insert(DB_NEWS_CATS, $inputArray, "update");
addNotice("success", $locale['news_0151']);
if (isset($_POST['save_cat_and_close'])) {
redirect(clean_request("", array("action", "ref"), FALSE));
} else {
redirect(FUSION_REQUEST);
}
} else {
addNotice('danger', $locale['news_0352']);
}
} else {
// check category name is unique when saving new
if (!dbcount("(news_cat_id)", DB_NEWS_CATS, $categoryNameCheck['when_saving'])) {
dbquery_insert(DB_NEWS_CATS, $inputArray, "save");
addNotice("success", $locale['news_0150']);
if (isset($_POST['save_cat_and_close'])) {
redirect(clean_request("", array("action", "ref"), FALSE));
} else {
redirect(FUSION_REQUEST);
}
} else {
addNotice('danger', $locale['news_0352']);
}
}
}
} elseif (isset($_GET['action']) && $_GET['action'] == "edit" && (isset($_GET['cat_id']) && isnum($_GET['cat_id']))) {
$result = dbquery("SELECT * FROM " . DB_NEWS_CATS . " " . (multilang_table("NS") ? "WHERE news_cat_language='" . LANGUAGE . "' AND" : "WHERE") . " news_cat_id='" . $_GET['cat_id'] . "'");
if (dbrows($result)) {
$data = dbarray($result);
$data['news_cat_hidden'] = array($data['news_cat_id']);
$formTitle = $locale['news_0021'];
} else {
// FUSION_REQUEST without the "action" gets
redirect(clean_request("", array("action"), FALSE));
}
}
add_breadcrumb(array('link' => "", 'title' => $formTitle));
echo "<div class='m-t-20 m-b-20'>\n";
echo openform("addcat", "post", $formAction);
?>
<div class="row">
<div class="col-xs-12 col-sm-8">
<?php
echo form_hidden("news_cat_id", "", $data['news_cat_id']);
echo form_text("news_cat_name", $locale['news_0300'], $data['news_cat_name'], array("required" => TRUE, "inline" => TRUE, "error_text" => $locale['news_0351']));
echo form_select_tree("news_cat_parent", $locale['news_0305'], $data['news_cat_parent'], array("inline" => TRUE, "disable_opts" => $data['news_cat_hidden'], "hide_disabled" => TRUE, "query" => multilang_table("NS") ? "WHERE news_cat_language='" . LANGUAGE . "'" : ""), DB_NEWS_CATS, "news_cat_name", "news_cat_id", "news_cat_parent");
echo form_select("news_cat_image", $locale['news_0301'], $data['news_cat_image'], array("inline" => TRUE, "options" => newsCatImageOpts()));
echo form_select('news_cat_visibility', $locale['news_0209'], $data['news_cat_visibility'], array('options' => fusion_get_groups(), 'placeholder' => $locale['choose'], "inline" => TRUE));
?>
</div>
<div class="col-xs-12 col-sm-4">
<?php
if (multilang_table("NS")) {
echo form_select("news_cat_language", $locale['global_ML100'], $data['news_cat_language'], array("inline" => TRUE, "options" => fusion_get_enabled_languages(), "placeholder" => $locale['choose']));
} else {
echo form_hidden("news_cat_language", "", $data['news_cat_language']);
}
openside("");
echo form_checkbox("news_cat_draft", "Save Category as Draft", $data['news_cat_draft'], array("reverse_label" => TRUE));
echo form_checkbox("news_cat_sticky", "Make this Category Sticky", $data['news_cat_sticky'], array("reverse_label" => TRUE));
echo form_button("cancel", $locale['cancel'], $locale['cancel'], array("class" => "btn-default"));
echo form_button("save_cat", $locale['news_0302'], $locale['news_0302'], array("class" => "btn-success m-l-10"));
echo form_button("save_cat_and_close", "Save and Close", "save_and_close", array("class" => "btn-primary m-l-10"));
closeside();
?>
</div>
</div>
<?php
echo form_button("cancel", $locale['cancel'], $locale['cancel'], array("class" => "btn-default"));
echo form_button("save_cat", $locale['news_0302'], $locale['news_0302'], array("class" => "btn-success m-l-10"));
echo form_button("save_cat_and_close", "Save and Close", "save_and_close", array("class" => "btn-primary m-l-10"));
echo "</div>\n";
}
redirect(clean_request("", array("action"), FALSE));
}
}
add_breadcrumb(array('link' => "", 'title' => $formTitle));
opentable($formTitle);
echo openform("addcat", "post", $formAction);
openside("");
echo form_hidden("news_cat_id", "", $data['news_cat_id']);
echo form_text("news_cat_name", $locale['news_0300'], $data['news_cat_name'], array("required" => TRUE, "inline" => TRUE, "error_text" => $locale['news_0351']));
echo form_select_tree("news_cat_parent", $locale['news_0305'], $data['news_cat_parent'], array("inline" => TRUE, "disable_opts" => $data['news_cat_hidden'], "hide_disabled" => TRUE, "query" => multilang_table("NS") ? "WHERE news_cat_language='" . LANGUAGE . "'" : ""), DB_NEWS_CATS, "news_cat_name", "news_cat_id", "news_cat_parent");
if (multilang_table("NS")) {
echo form_select("news_cat_language", $locale['global_ML100'], $data['news_cat_language'], array("inline" => TRUE, "options" => fusion_get_enabled_languages(), "placeholder" => $locale['choose']));
} else {
echo form_hidden("news_cat_language", "", $data['news_cat_language']);
}
echo form_select("news_cat_image", $locale['news_0301'], $data['news_cat_image'], array("inline" => TRUE, "options" => newsCatImageOpts()));
echo form_button("save_cat", $locale['news_0302'], $locale['news_0302'], array("class" => "btn-success"));
closeside();
openside($locale['news_0020']);
$result = dbquery("SELECT news_cat_id, news_cat_name FROM " . DB_NEWS_CATS . " " . (multilang_table("NS") ? "WHERE news_cat_language='" . LANGUAGE . "'" : "") . " ORDER BY news_cat_name");
$rows = dbrows($result);
if ($rows != 0) {
$counter = 0;
$columns = 4;
echo "<div class='row'>\n";
while ($data = dbarray($result)) {
if ($counter != 0 && $counter % $columns == 0) {
echo "</div>\n<div class='row'>\n";
}
echo "<div class='col-xs-12 col-sm-3 col-md-3 col-lg-3 m-b-10 text-left'>\n";
echo "<strong>" . getNewsCatPath($data['news_cat_id']) . "</strong>\n<br/>\n";
