".$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 "
".$locale['457']."
".$locale['458']."
".$locale['467']." -
".$locale['465']."
\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 "\n"; while ($data = dbarray($result)) { $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); echo "\n"; $i++; } echo "
".$locale['461']." ".$locale['466']." ".$locale['462']."
".$data['article_cat_name']."
".trimlink($data['article_cat_description'], 45)."
".getgroupname($data['article_cat_access'])." ".$locale['509']." - ".$locale['510']."
\n"; } else { echo "".$locale['518']."\n\n"; } closetable(); } echo "\n"; require_once BASEDIR."footer.php"; ?>