\n".$locale['413']."";
} elseif ($_GET['status'] == "delcy") {
$message = $locale['414'];
} elseif ($_GET['status'] == "delfn") {
$message = $locale['512']."
\n".$locale['513']."";
} elseif ($_GET['status'] == "delfy") {
$message = $locale['514'];
}
if ($message) { echo "".$message."
\n"; }
}
if (isset($_POST['save_cat'])) {
$cat_name = trim(stripinput($_POST['cat_name']));
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['forum_id']) && isnum($_GET['forum_id'])) && (isset($_GET['t']) && $_GET['t'] == "cat")) {
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_name='$cat_name' WHERE forum_id='".$_GET['forum_id']."'");
redirect(FUSION_SELF.$aidlink."&status=savecu");
} else {
if ($cat_name) {
$cat_order = isnum($_POST['cat_order']) ? $_POST['cat_order'] : "";
if(!$cat_order) $cat_order=dbresult(dbquery("SELECT MAX(forum_order) FROM ".DB_FORUMS." WHERE forum_cat='0'"),0)+1;
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_order=forum_order+1 WHERE forum_cat='0' AND forum_order>='$cat_order'");
$result = dbquery("INSERT INTO ".DB_FORUMS." (forum_cat, forum_name, forum_order, forum_description, forum_moderators, forum_access, forum_post, forum_reply, forum_poll, forum_vote, forum_attach, forum_lastpost, forum_lastuser) VALUES ('0', '$cat_name', '$cat_order', '', '', '0', '0', '0', '0', '0', '0', '0', '0')");
redirect(FUSION_SELF.$aidlink."&status=savecn");
}
}
} elseif (isset($_POST['save_forum'])) {
$forum_name = trim(stripinput($_POST['forum_name']));
$forum_description = trim(stripinput($_POST['forum_description']));
$forum_cat = isnum($_POST['forum_cat']) ? $_POST['forum_cat'] : 0;
$forum_parent = isnum($_POST['forum_parent']) ? $_POST['forum_parent'] : 0;
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['forum_id']) && isnum($_GET['forum_id'])) && (isset($_GET['t']) && $_GET['t'] == "forum")) {
$forum_mods = $_POST['forum_mods'];
$forum_access = isnum($_POST['forum_access']) ? $_POST['forum_access'] : 0;
$forum_post = isnum($_POST['forum_post']) ? $_POST['forum_post'] : 0;
$forum_reply = isnum($_POST['forum_reply']) ? $_POST['forum_reply'] : 0;
$forum_attach = isnum($_POST['forum_attach']) ? $_POST['forum_attach'] : 0;
$forum_poll = isnum($_POST['forum_poll']) ? $_POST['forum_poll'] : 0;
$forum_vote = isnum($_POST['forum_vote']) ? $_POST['forum_vote'] : 0;
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_name='$forum_name', forum_cat='$forum_cat', forum_parent='$forum_parent', forum_description='$forum_description', forum_moderators='$forum_mods', forum_access='$forum_access', forum_post='$forum_post', forum_reply='$forum_reply', forum_attach='$forum_attach', forum_poll='$forum_poll', forum_vote='$forum_vote' WHERE forum_id='".$_GET['forum_id']."'");
redirect(FUSION_SELF.$aidlink."&status=savefu");
} else {
if ($forum_name) {
$forum_order = isnum($_POST['forum_order']) ? $_POST['forum_order'] : "";
if(!$forum_order) $forum_order=dbresult(dbquery("SELECT MAX(forum_order) FROM ".DB_FORUMS." WHERE forum_parent='$forum_parent' AND forum_cat='$forum_cat'"),0)+1;
$result = dbquery("INSERT INTO ".DB_FORUMS." (forum_cat, forum_parent, forum_name, forum_order, forum_description, forum_moderators, forum_access, forum_post, forum_reply, forum_attach, forum_poll, forum_vote, forum_lastpost, forum_lastuser) VALUES ('$forum_cat', '$forum_parent', '$forum_name', '$forum_order', '$forum_description', '103', '101', '101', '101', '0', '0', '0', '0', '0')");
redirect(FUSION_SELF.$aidlink."&status=savefn");
} else {
redirect(FUSION_SELF.$aidlink);
}
}
} elseif ((isset($_GET['action']) && $_GET['action'] == "mu") && (isset($_GET['forum_id']) && isnum($_GET['forum_id'])) && (isset($_GET['order']) && isnum($_GET['order']))) {
if (isset($_GET['t']) && $_GET['t'] == "cat") {
$data = dbarray(dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_cat='0' AND forum_order='".$_GET['order']."'"));
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_order=forum_order+1 WHERE forum_id='".$data['forum_id']."'");
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_order=forum_order-1 WHERE forum_id='".$_GET['forum_id']."'");
} elseif ((isset($_GET['t']) && $_GET['t'] == "forum") && (isset($_GET['cat']) && isnum($_GET['cat']))) {
$parent = (isset($_GET['parent']) && isNum($_GET['parent']) ? " AND forum_parent='".$_GET['parent']."'" : "");
$data = dbarray(dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_cat='".$_GET['cat']."' AND forum_order='".$_GET['order']."'$parent"));
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_order=forum_order+1 WHERE forum_id='".$data['forum_id']."'");
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_order=forum_order-1 WHERE forum_id='".$_GET['forum_id']."'");
}
redirect(FUSION_SELF.$aidlink);
} elseif ((isset($_GET['action']) && $_GET['action'] == "md") && (isset($_GET['forum_id']) && isnum($_GET['forum_id'])) && (isset($_GET['order']) && isnum($_GET['order']))) {
if (isset($_GET['t']) && $_GET['t'] == "cat") {
$data = dbarray(dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_cat='0' AND forum_order='".$_GET['order']."'"));
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_order=forum_order-1 WHERE forum_id='".$data['forum_id']."'");
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_order=forum_order+1 WHERE forum_id='".$_GET['forum_id']."'");
} elseif ((isset($_GET['t']) && $_GET['t'] == "forum") && (isset($_GET['cat']) && isnum($_GET['cat']))) {
$parent = (isset($_GET['parent']) && isNum($_GET['parent']) ? " AND forum_parent='".$_GET['parent']."'" : "");
$data = dbarray(dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_cat='".$_GET['cat']."' AND forum_order='".$_GET['order']."'$parent"));
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_order=forum_order-1 WHERE forum_id='".$data['forum_id']."'");
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_order=forum_order+1 WHERE forum_id='".$_GET['forum_id']."'");
}
redirect(FUSION_SELF.$aidlink);
} elseif ((isset($_GET['action']) && $_GET['action'] == "delete") && (isset($_GET['forum_id']) && isnum($_GET['forum_id'])) && (isset($_GET['t']) && $_GET['t'] == "cat")) {
if (!dbcount("(forum_id)", DB_FORUMS, "forum_cat='".$_GET['forum_id']."'")) {
$data = dbarray(dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_id='".$_GET['forum_id']."'"));
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_order=forum_order-1 WHERE forum_cat='0' AND forum_order>'".$data['forum_order']."'");
$result = dbquery("DELETE FROM ".DB_FORUMS." WHERE forum_id='".$_GET['forum_id']."'");
redirect(FUSION_SELF.$aidlink."&status=delcy");
} else {
redirect(FUSION_SELF.$aidlink."&status=delcn");
}
} elseif ((isset($_GET['action']) && $_GET['action'] == "delete") && (isset($_GET['forum_id']) && isnum($_GET['forum_id'])) && (isset($_GET['t']) && $_GET['t'] == "forum")) {
if (!dbcount("(thread_id)", DB_THREADS, "forum_id='".$_GET['forum_id']."'") && !dbcount("(forum_id)", DB_FORUMS."", "forum_parent='".$_GET['forum_id']."'")) {
$parent = (isset($_GET['parent']) && isNum($_GET['parent']) ? " AND forum_parent='".$_GET['parent']."'" : "");
$data = dbarray(dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_id='".$_GET['forum_id']."'"));
$result = dbquery("UPDATE ".DB_FORUMS." SET forum_order=forum_order-1 WHERE forum_cat='".$data['forum_cat']."' AND forum_order>'".$data['forum_order']."'$parent");
$result = dbquery("DELETE FROM ".DB_FORUMS." WHERE forum_id='".$_GET['forum_id']."'");
redirect(FUSION_SELF.$aidlink."&status=delfy");
} else {
redirect(FUSION_SELF.$aidlink."&status=delfn");
}
} else {
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['forum_id']) && isnum($_GET['forum_id']))) {
if (isset($_GET['t']) && $_GET['t'] == "cat") {
$result = dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_id='".$_GET['forum_id']."'");
if (dbrows($result)) {
$data = dbarray($result);
$cat_name = $data['forum_name'];
$cat_title = $locale['401'];
$cat_action = FUSION_SELF.$aidlink."&action=edit&forum_id=".$data['forum_id']."&t=cat";
$forum_title = $locale['500'];
$forum_action = FUSION_SELF.$aidlink;
} else {
redirect(FUSION_SELF.$aidlink);
}
} elseif (isset($_GET['t']) && $_GET['t'] == "forum") {
$result = dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_id='".$_GET['forum_id']."'");
if (dbrows($result)) {
$data = dbarray($result);
$forum_name = $data['forum_name'];
$forum_description = $data['forum_description'];
$forum_cat = $data['forum_cat'];
$forum_parent = $data['forum_parent'];
$forum_access = $data['forum_access'];
$forum_post = $data['forum_post'];
$forum_reply = $data['forum_reply'];
$forum_attach = $data['forum_attach'];
$forum_poll = $data['forum_poll'];
$forum_vote = $data['forum_vote'];
$forum_title = $locale['501'];
$forum_action = FUSION_SELF.$aidlink."&action=edit&forum_id=".$data['forum_id']."&t=forum";
$cat_title = $locale['400'];
$cat_action = FUSION_SELF.$aidlink;
} else {
redirect(FUSION_SELF.$aidlink);
}
}
} else {
$cat_name = "";
$cat_order = "";
$cat_title = $locale['400'];
$cat_action = FUSION_SELF.$aidlink;
$forum_name = "";
$forum_description = "";
$forum_cat = 0;
$forum_parent = 0;
$forum_order = "";
$forum_access = 0;
$forum_post = 0;
$forum_reply = 0;
$forum_attach = 0;
$forum_poll = 0;
$forum_vote = 0;
$forum_title = $locale['500'];
$forum_action = FUSION_SELF.$aidlink;
}
if (!isset($_GET['t']) || $_GET['t'] != "forum") {
opentable($cat_title);
echo "\n";
closetable();
}
if (!isset($_GET['t']) || $_GET['t'] != "cat") {
$cat_opts = ""; $sel = "";
$result2 = dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_cat='0' ORDER BY forum_order");
if (dbrows($result2)) {
while ($data2 = dbarray($result2)) {
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['t']) && $_GET['t'] == "forum")) { $sel = ($data2['forum_id'] == $forum_cat ? " selected='selected'" : ""); }
$cat_opts .= "\n";
}
$parent_opts = ""; $parent_select = "";
$parent_result = dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_cat!='0' AND forum_parent='0' ORDER BY forum_order");
$parent_opts .= "\n";
while ($parent_data = dbarray($parent_result)) {
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['t']) && $_GET['t'] == "forum")) { $parent_select = ($parent_data['forum_id'] == $forum_parent ? " selected='selected'" : ""); }
$parent_opts .= "\n";
}
function create_options($selected, $hide=array(), $off=false) {
global $locale; $option_list = ""; $options = getusergroups();
if ($off) { $option_list = "\n"; }
while(list($key, $option) = each($options)){
if (!in_array($option['0'], $hide)) {
$sel = ($selected == $option['0'] ? " selected='selected'" : "");
$option_list .= "\n";
}
}
return $option_list;
}
opentable($forum_title);
echo "";
if (isset($_GET['action']) && $_GET['action'] == "edit") {
$mod_groups = getusergroups();
while(list($key, $mod_group) = each($mod_groups)){
if ($mod_group['0'] != "0" && $mod_group['0'] != "101" && $mod_group['0'] != "103") {
if (!preg_match("(^{$mod_group['0']}$|^{$mod_group['0']}\.|\.{$mod_group['0']}\.|\.{$mod_group['0']}$)", $data['forum_moderators'])) {
$mods1_user_id[] = $mod_group['0'];
$mods1_user_name[] = $mod_group['1'];
} else {
$mods2_user_id[] = $mod_group['0'];
$mods2_user_name[] = $mod_group['1'];
}
}
}
echo "\n| ".$locale['533']." | \n";
echo "
\n\n";
echo "| \n\n";
echo "\n";
echo " | \n";
echo "
\n\n";
echo "
\n";
echo "\n";
echo "\n";
echo "\n";
echo " | \n";
echo "
\n\n\n";
echo "\n";
}
closetable();
}
}
opentable($locale['550']);
$i = 1; $k = 1;
echo "\n";
$result = dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_cat='0' ORDER BY forum_order");
if (dbrows($result) != 0) {
echo "\n| ".$locale['551']." | \n";
echo "".$locale['552']." | \n";
echo "".$locale['553']." | \n";
echo "
\n";
$i = 1;
while ($data = dbarray($result)) {
echo "\n| ".$data['forum_name']." | \n";
echo "".$data['forum_order']." | \n";
echo "\n";
if (dbrows($result) != 1) {
$up = $data['forum_order'] - 1; $down = $data['forum_order'] + 1;
if ($i == 1) {
echo "![".$locale[](".get_image("down")." "\".$locale[") \n";
} elseif ($i < dbrows($result)) {
echo "![".$locale[](".get_image("up")." "\".$locale[") \n";
echo "\n";
} else {
echo "\n";
}
}
$i++;
echo " | \n";
echo "".$locale['554']." ::\n";
echo "".$locale['555']." | \n";
echo "
\n";
$result2 = dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_cat='".$data['forum_id']."' AND forum_parent='0' ORDER BY forum_order");
if (dbrows($result2)) {
$k = 1;
while ($data2 = dbarray($result2)) {
echo forum_parent($data2, $result2, $k);
echo forum($data2['forum_id']);
$k++;
}
}
echo "
\n";
}
echo "\n| [ ".$locale['562']." ] | \n
\n";
} else {
echo "\n| ".$locale['560']." | \n
\n";
}
echo "
\n";
closetable();
}
function forum_parent($data2, $result2, $k){
global $aidlink, $locale;
$forumR = "";
$forumR .= "\n";
$forumR .= "";
$forumR .= ($data2['forum_parent'] == 0 ) ? $data2['forum_name'] : "![](".IMAGES."subforum.png) ".$data2['forum_name'];
$forumR .= "\n";
$forumR .= "[".$locale['563']."]
\n";
$forumR .= ($data2['forum_description'] ? "".$data2['forum_description']."" : "")." | \n";
$forumR .= "".$data2['forum_order']." | \n";
$forumR .= "\n";
$parent = ($data2['forum_parent'] == 0 ? "" : "&parent=".$data2['forum_parent']);
if (dbrows($result2) != 1) {
$up = $data2['forum_order'] - 1; $down = $data2['forum_order'] + 1;
if ($k == 1) {
$forumR .= "\n";
} elseif ($k < dbrows($result2)) {
$forumR .= "\n";
$forumR .= "\n";
} else {
$forumR .= "\n";
}
}
$forumR .= " | \n";
$forumR .= "".$locale['554']." ::\n";
$forumR .= "".$locale['555']." | \n";
$forumR .= "
\n";
return $forumR;
}
function forum($parent){
$result = dbquery("SELECT * FROM ".DB_FORUMS." WHERE forum_parent='$parent' ORDER BY forum_order asc");
$forumR = "";
if (dbrows($result)) {
$k = 1;
while ($data = dbarray($result)) {
$forumR .= forum_parent($data, $result, $k);
$k++;
$forumR .= forum($data['forum_id']);
}
}
return $forumR;
}
require_once THEMES."templates/footer.php";
?>