INSERT INTO `forum_forums` VALUES (1, 1, 'Example Forum', 'Here is a example forum, you can edit the forums via the control panel', 1, 1, 'yes', 1); INSERT INTO `forum_forums` VALUES (0, 2, 'Test Forum 2', 'test2', 1, 1, 'yes', 3); INSERT INTO `forum_forums` VALUES (0, 3, 'Test Forum 3', 'test', 1, 1, 'yes', 4);
INSERT INTO `forumcats` VALUES (1, 'Test Cat 1', 1); INSERT INTO `forumcats` VALUES (3, 'Test Cat 2', 3); INSERT INTO `forumcats` VALUES (4, 'Test Cat 3', 4);
add to admincp.php:
PHP Code:
// Forum management if (!function_exists("autolink")) { function autolink($al_url, $al_msg) { stdhead(); begin_frame("", "center"); echo "\n<meta http-equiv=\"refresh\" content=\"3; URL=$al_url\">\n"; echo "<b>$al_msg</b>\n"; echo "<p>\n<b>Redirecting ...</b>\n"; echo "<p>\n[ <a href='$al_url'>link</a> ]\n"; end_frame(); stdfoot(); exit; } } if ($action == "forum") {
$error_ac == ""; if ($do == "add_this_forum") { if ($new_forum_name == "") $error_ac .= "<li>Forum-name was empty"; if ($new_desc == "") $error_ac .= "<li>Forum-description was empty"; if ($new_forum_sort == "") $error_ac .= "<li>Forum sort order was empty"; if ($new_forum_cat == "") $error_ac .= "<li>Forum category was empty";
if ($error_ac == "") { $res = mysql_query("INSERT INTO forum_forums (`name`, `description`, `sort`, `category`, `minclassread`, `minclasswrite`, `guest_read`) VALUES ('$new_forum_name', '$new_desc', '$new_forum_sort', '$new_forum_cat', '$minclassread', '$minclasswrite', '$guest_read')"); if ($res) autolink("admincp.php?action=forum", "Thank you, new forum added to db ..."); else echo "<h4>Could not save to DB - check your connection & settings!</h4>"; } }
if ($do == "add_this_forumcat") { if ($new_forumcat_name == "") $error_ac .= "<li>Forum cat name was empty\n"; if ($new_forumcat_sort == "") $error_ac .= "<li>Forum cat sort order was empty\n";
if ($error_ac == "") { $res = mysql_query("INSERT INTO forumcats (`name`, `sort`) VALUES ('$new_forumcat_name', '$new_forumcat_sort')"); if ($res) autolink("admincp.php?action=forum", "Thank you, new forum cat added to db ..."); else echo "<h4>Could not save to DB - check your connection & settings!</h4>"; } }
if ($do == "save_edit") { mysql_query("UPDATE forum_forums SET sort = '$changed_sort', name = '$changed_forum', description = '$changed_forum_desc', category = '$changed_forum_cat', minclassread='$minclassread', minclasswrite='$minclasswrite', guest_read='$guest_read' WHERE id='$id'"); autolink("admincp.php?action=forum", "<center><b>Update Completed</b></center>"); }
if ($do == "save_editcat") { mysql_query("UPDATE forumcats SET sort = '$changed_sortcat', name = '$changed_forumcat' WHERE id='$id'"); autolink("admincp.php?action=forum", "<center><b>Update Completed</b></center>"); }
if ($do == "delete_forum" && $delcat != "" && is_valid_id($id)) { mysql_query("DELETE FROM forum_forums WHERE id = $id"); autolink("admincp.php?action=forum", "forum deleted ..."); }
if ($do == "delete_forumcat" && $delcat != "" && is_valid_id($id)) { mysql_query("DELETE FROM forumcats WHERE id = $id"); autolink("admincp.php?action=forum", "forum cat deleted ..."); }
stdhead("Forum Management");
$groupsres = mysql_query("SELECT group_id, level FROM groups ORDER BY group_id ASC"); while ($groupsrow=mysql_fetch_row($groupsres)) $groups[$groupsrow[0]] = $groupsrow[1];
if ($do == "edit_forum") { begin_frame("Edit Forum"); $q = MYSQL_QUERY("SELECT * FROM forum_forums WHERE id = '$id'"); $r = MYSQL_FETCH_ARRAY($q); ?> <table align='center' width='80%' bgcolor='#cecece' cellspacing='2' cellpadding='2' style='border: 1px solid black'>
if ($do == "del_forum") { begin_frame("Confirm"); $t = MYSQL_QUERY("SELECT * FROM forum_forums WHERE id = '$id'"); $v = MYSQL_FETCH_ARRAY($t); ?> <form action="admincp.php" method="post"> <input type="hidden" name="action" value="forum"> <input type="hidden" name="do" value="delete_forum"> <input type="hidden" name="id" value="<?=$id?>"> Really delete the Forum <?="<b>$v[name] with ID$v[id] ???</b>"?> <input type="submit" name="delcat" class="button" value="Delete"> </form> <? end_frame(); }
if ($do == "del_forumcat") { begin_frame("Confirm"); $t = MYSQL_QUERY("SELECT * FROM forumcats WHERE id = '$id'"); $v = MYSQL_FETCH_ARRAY($t); ?> <form action="admincp.php" method="post"> <input type="hidden" name="action" value="forum"> <input type="hidden" name="do" value="delete_forumcat"> <input type="hidden" name="id" value="<?=$id?>"> Really delete the Forum category<?="<b>$v[name] with ID$v[id] ???</b> All Sub Forums will now be invisible"?> <input type="submit" name="delcat" class="button" value="Delete"> </form> <? end_frame(); }
if($error_ac != "") echo "<tr><td colspan='2' align='center' style='background:#eeeeee;border:2px red solid'><b>COULD NOT ADD NEW forum:</b><br />$error_ac</tr></td>\n";