echo " </td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td align=\"left\"> </td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td align=\"center\">", form_submit("updateforumsubmit", gettext("Save")), " ", form_submit("delete", gettext("Delete")), " ", form_submit("cancel", gettext("Back")), "</td>\n"; echo " </tr>\n"; echo " </table>\n"; html_display_warning_msg(gettext("When setting Restricted or Password Protected mode you will need to save your changes before you can change the user access privileges or password."), '700', 'center'); echo " </form>\n"; echo "</div>\n"; html_draw_bottom(); } else { html_draw_top(array('title' => gettext('Admin - Manage Forums'), 'class' => 'window_title', 'js' => array('js/admin.js'), 'main_css' => 'admin.css')); $forums_array = admin_get_forum_list($page); echo "<h1>", gettext("Admin"), html_style_image('separator'), gettext("Manage Forums"), "</h1>\n"; if (isset($error_msg_array) && sizeof($error_msg_array) > 0) { html_display_error_array($error_msg_array, '86%', 'center'); } else { if (isset($_GET['added'])) { html_display_success_msg(gettext("Successfully created new forum"), '86%', 'center', 'forum_created'); } else { if (isset($_GET['edited'])) { html_display_success_msg(gettext("Successfully updated forum"), '86%', 'center', 'forum_updated'); } else { if (isset($_GET['deleted'])) { html_display_success_msg(gettext("Successfully deleted selected forums"), '86%', 'center', 'forum_removed'); } else { if (sizeof($forums_array['forums_array']) < 1) { html_display_warning_msg(gettext("No existing forums found. To create a new forum click the 'Add New' button below."), '86%', 'center');
function admin_get_forum_list($page = 1) { if (!($db = db::get())) { return false; } if (!is_numeric($page) || $page < 1) { $page = 1; } $offset = calculate_page_offset($page, 10); $sql = "SELECT SQL_CALC_FOUND_ROWS FORUMS.FID, FORUMS.WEBTAG, FORUMS.DEFAULT_FORUM, "; $sql .= "FORUMS.ACCESS_LEVEL, FORUM_SETTINGS.SVALUE AS FORUM_NAME FROM FORUMS "; $sql .= "LEFT JOIN FORUM_SETTINGS ON (FORUM_SETTINGS.FID = FORUMS.FID "; $sql .= "AND FORUM_SETTINGS.SNAME = 'forum_name') "; $sql .= "LIMIT {$offset}, 10 "; if (!($result = $db->query($sql))) { return false; } $sql = "SELECT FOUND_ROWS() AS ROW_COUNT"; if (!($result_count = $db->query($sql))) { return false; } list($forums_count) = $result_count->fetch_row(); if ($result->num_rows == 0 && $forums_count > 0 && $page > 1) { return admin_get_forum_list($page - 1); } $forums_array = array(); while ($forum_data = $result->fetch_assoc()) { if (!isset($forum_data['ACCESS_LEVEL'])) { $forum_data['ACCESS_LEVEL'] = 0; } if ($post_count = admin_forum_get_post_count($forum_data['FID'])) { $forum_data['MESSAGES'] = $post_count; } $forums_array[] = $forum_data; } return array('forums_array' => $forums_array, 'forums_count' => $forums_count); }