".$locale['451']."
\n".$locale['452'];
} elseif ($status == "dely") {
$title = $locale['450'];
$message = "".$locale['454']."";
}
opentable($title);
echo "
".$message."
\n";
closetable();
tablebreak();
}
if (isset($action) && $action == "delete") {
$result = dbquery("SELECT * FROM ".$db_prefix."articles WHERE article_cat='$cat_id'");
if (dbrows($result) != 0) {
redirect(FUSION_SELF.$aidlink."&status=deln");
} else {
$result = dbquery("DELETE FROM ".$db_prefix."article_cats WHERE article_cat_id='$cat_id'");
redirect(FUSION_SELF.$aidlink."&status=dely");
}
} else {
if (isset($_POST['save_cat'])) {
$cat_name = stripinput($_POST['cat_name']);
$cat_description = stripinput($_POST['cat_description']);
$cat_access = isNum($_POST['cat_access']) ? $_POST['cat_access'] : "0";
if (isNum($_POST['cat_sort_by']) && $_POST['cat_sort_by'] == "1") {
$cat_sorting = "article_id ".($_POST['cat_sort_order'] == "ASC" ? "ASC" : "DESC");
} else if (isNum($_POST['cat_sort_by']) && $_POST['cat_sort_by'] == "2") {
$cat_sorting = "article_subject ".($_POST['cat_sort_order'] == "ASC" ? "ASC" : "DESC");
} else if (isNum($_POST['cat_sort_by']) && $_POST['cat_sort_by'] == "3") {
$cat_sorting = "article_datestamp ".($_POST['cat_sort_order'] == "ASC" ? "ASC" : "DESC");
} else {
$cat_sorting = "article_subject ASC";
}
if ($action == "edit") {
$result = dbquery("UPDATE ".$db_prefix."article_cats SET article_cat_name='$cat_name', article_cat_description='$cat_description', article_cat_sorting='$cat_sorting', article_cat_access='$cat_access' WHERE article_cat_id='$cat_id'");
} else {
$result = dbquery("INSERT INTO ".$db_prefix."article_cats (article_cat_name, article_cat_description, article_cat_sorting, article_cat_access) VALUES ('$cat_name', '$cat_description', '$cat_sorting', '$cat_access')");
}
redirect("article_cats.php?aid=".iAUTH);
}
if (isset($action) && $action == "edit") {
$result = dbquery("SELECT * FROM ".$db_prefix."article_cats WHERE article_cat_id='$cat_id'");
$data = dbarray($result);
$cat_name = $data['article_cat_name'];
$cat_description = $data['article_cat_description'];
$cat_sorting = explode(" ", $data['article_cat_sorting']);
if ($cat_sorting[0] == "article_id") { $cat_sort_by = "1"; }
if ($cat_sorting[0] == "article_subject") { $cat_sort_by = "2"; }
if ($cat_sorting[0] == "article_datestamp") { $cat_sort_by = "3"; }
$cat_sort_order = $cat_sorting[1];
$cat_access = $data['article_cat_access'];
$formaction = FUSION_SELF.$aidlink."&action=edit&cat_id=".$data['article_cat_id'];
opentable($locale['455']);
} else {
$cat_name = "";
$cat_description = "";
$cat_sort_by = "2";
$cat_sort_order = "ASC";
$cat_access = "";
$formaction = FUSION_SELF.$aidlink;
opentable($locale['456']);
}
$user_groups = getusergroups(); $access_opts = ""; $sel = "";
while(list($key, $user_group) = each($user_groups)){
$sel = ($cat_access == $user_group['0'] ? " selected" : "");
$access_opts .= "\n";
}
echo "\n";
closetable();
tablebreak();
opentable($locale['460']);
echo "\n";
$result = dbquery("SELECT * FROM ".$db_prefix."article_cats ORDER BY article_cat_name");
if (dbrows($result) != 0) {
$i = 0;
echo "
".$locale['461']." |
".$locale['466']." |
".$locale['462']." |
\n";
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2");
echo "
".$data['article_cat_name']."
".trimlink($data['article_cat_description'], 45)." |
".getgroupname($data['article_cat_access'])." |
".$locale['509']." -
".$locale['510']." |
\n";
$i++;
}
echo "
\n";
} else {
echo "".$locale['518']." |
\n\n";
}
closetable();
}
echo "\n";
require_once BASEDIR."footer.php";
?>