<?php
    $_id = isset($_GET['i']) ? intval($_GET['i']) : 0;

    $community = mysqli_query_logged("SELECT * FROM community_forums, community_sections, community WHERE community_forums.forum_id = " . sq($_id) . " AND community_forums.forum_deleted = '0' AND community_forums.section_id = community_sections.section_id AND community_sections.section_deleted = '0' AND community_sections.community_id = community.community_id");
    if (!$community_row = mysqli_fetch_assoc($community))
    {
        make_cookie('notice', 'Sorry, you don\'t have permission to modify this community.');
        header('Location: ./?s=community_create');
        die;
    }
    
    require_once('include/functions/community_permissions.php');
    community_permissions($community_row['community_id']);
    
    if (!$GLOBALS['auth']['community']['administration'])
    {
        make_cookie('notice', 'Sorry, you don\'t have permission to modify this community.');
        header('Location: ./?s=community_create');
        die;
    }
    
    $community_forums = mysqli_query_logged("SELECT * FROM community_forums WHERE section_id = '" . $community_row['section_id'] . "' AND forum_deleted = '0' AND forum_order_id < '" . $community_row['forum_order_id'] . "' ORDER BY forum_order_id DESC LIMIT 1");
    if ($community_forums_row = mysqli_fetch_array($community_forums)) 
    {
        mysqli_query_logged("UPDATE community_forums SET forum_order_id = '" . $community_forums_row['forum_order_id'] . "' WHERE forum_id = '" . $community_row['forum_id'] . "'");
        mysqli_query_logged("UPDATE community_forums SET forum_order_id = '" . $community_row['forum_order_id'] . "' WHERE forum_id = '" . $community_forums_row['forum_id'] . "'");
    }

    header('Location: ./?s=community_section_modify&i=' . $community_row['section_id']);
    die;
?>