diff -r e3d7322305bf -r 5e1f1e916419 punbb/admin_forums.php --- a/punbb/admin_forums.php Sun Sep 02 11:00:57 2007 -0400 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,460 +0,0 @@ -query('INSERT INTO '.$pun_db->prefix.'forums (cat_id) VALUES('.$add_to_cat.')') or error('Unable to create forum', __FILE__, __LINE__, $pun_db->error()); - - // Regenerate the quickjump cache - require_once PUN_ROOT.'include/cache.php'; - generate_quickjump_cache(); - - pun_redirect('admin_forums.php', 'Forum added. Redirecting …'); -} - - -// Delete a forum -else if (isset($_GET['del_forum'])) -{ - confirm_referrer('admin_forums.php'); - - $forum_id = intval($_GET['del_forum']); - if ($forum_id < 1) - message($lang_common['Bad request']); - - if (isset($_POST['del_forum_comply'])) // Delete a forum with all posts - { - @set_time_limit(0); - - // Prune all posts and topics - prune($forum_id, 1, -1); - - // Locate any "orphaned redirect topics" and delete them - $result = $pun_db->query('SELECT t1.id FROM '.$pun_db->prefix.'topics AS t1 LEFT JOIN '.$pun_db->prefix.'topics AS t2 ON t1.moved_to=t2.id WHERE t2.id IS NULL AND t1.moved_to IS NOT NULL') or error('Unable to fetch redirect topics', __FILE__, __LINE__, $pun_db->error()); - $num_orphans = $pun_db->num_rows($result); - - if ($num_orphans) - { - for ($i = 0; $i < $num_orphans; ++$i) - $orphans[] = $pun_db->result($result, $i); - - $pun_db->query('DELETE FROM '.$pun_db->prefix.'topics WHERE id IN('.implode(',', $orphans).')') or error('Unable to delete redirect topics', __FILE__, __LINE__, $pun_db->error()); - } - - // Delete the forum and any forum specific group permissions - $pun_db->query('DELETE FROM '.$pun_db->prefix.'forums WHERE id='.$forum_id) or error('Unable to delete forum', __FILE__, __LINE__, $pun_db->error()); - $pun_db->query('DELETE FROM '.$pun_db->prefix.'forum_perms WHERE forum_id='.$forum_id) or error('Unable to delete group forum permissions', __FILE__, __LINE__, $pun_db->error()); - - // Regenerate the quickjump cache - require_once PUN_ROOT.'include/cache.php'; - generate_quickjump_cache(); - - pun_redirect('admin_forums.php', 'Forum deleted. Redirecting …'); - } - else // If the user hasn't confirmed the delete - { - $result = $pun_db->query('SELECT forum_name FROM '.$pun_db->prefix.'forums WHERE id='.$forum_id) or error('Unable to fetch forum info', __FILE__, __LINE__, $pun_db->error()); - $forum_name = pun_htmlspecialchars($pun_db->result($result)); - - - $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / Admin / Forums'; - require PUN_ROOT.'header.php'; - - generate_admin_menu('forums'); - -?> -
-

Confirm delete forum

-
-
-
-
- Important! Read before deleting -
-

Are you sure that you want to delete the forum ""?

-

WARNING! Deleting a forum will delete all posts (if any) in that forum!

-
-
-
-

Go back

-
-
-
-
- -query('UPDATE '.$pun_db->prefix.'forums SET disp_position='.$disp_position.' WHERE id='.intval($forum_id)) or error('Unable to update forum', __FILE__, __LINE__, $pun_db->error()); - } - - // Regenerate the quickjump cache - require_once PUN_ROOT.'include/cache.php'; - generate_quickjump_cache(); - - pun_redirect('admin_forums.php', 'Forums updated. Redirecting …'); -} - - -else if (isset($_GET['edit_forum'])) -{ - $forum_id = intval($_GET['edit_forum']); - if ($forum_id < 1) - message($lang_common['Bad request']); - - // Update group permissions for $forum_id - if (isset($_POST['save'])) - { - confirm_referrer('admin_forums.php'); - - // Start with the forum details - $forum_name = trim($_POST['forum_name']); - $forum_desc = pun_linebreaks(trim($_POST['forum_desc'])); - $cat_id = intval($_POST['cat_id']); - $sort_by = intval($_POST['sort_by']); - $redirect_url = isset($_POST['redirect_url']) ? trim($_POST['redirect_url']) : null; - - if ($forum_name == '') - message('You must enter a forum name.'); - - if ($cat_id < 1) - message($lang_common['Bad request']); - - $forum_desc = ($forum_desc != '') ? '\''.$pun_db->escape($forum_desc).'\'' : 'NULL'; - $redirect_url = ($redirect_url != '') ? '\''.$pun_db->escape($redirect_url).'\'' : 'NULL'; - - $pun_db->query('UPDATE '.$pun_db->prefix.'forums SET forum_name=\''.$pun_db->escape($forum_name).'\', forum_desc='.$forum_desc.', redirect_url='.$redirect_url.', sort_by='.$sort_by.', cat_id='.$cat_id.' WHERE id='.$forum_id) or error('Unable to update forum', __FILE__, __LINE__, $pun_db->error()); - - // Now let's deal with the permissions - if (isset($_POST['read_forum_old'])) - { - $result = $pun_db->query('SELECT g_id, g_read_board, g_post_replies, g_post_topics FROM '.$pun_db->prefix.'groups WHERE g_id!='.PUN_ADMIN) or error('Unable to fetch user group list', __FILE__, __LINE__, $pun_db->error()); - while ($cur_group = $pun_db->fetch_assoc($result)) - { - $read_forum_new = ($cur_group['g_read_board'] == '1') ? isset($_POST['read_forum_new'][$cur_group['g_id']]) ? '1' : '0' : intval($_POST['read_forum_old'][$cur_group['g_id']]); - $post_replies_new = isset($_POST['post_replies_new'][$cur_group['g_id']]) ? '1' : '0'; - $post_topics_new = isset($_POST['post_topics_new'][$cur_group['g_id']]) ? '1' : '0'; - - // Check if the new settings differ from the old - if ($read_forum_new != $_POST['read_forum_old'][$cur_group['g_id']] || $post_replies_new != $_POST['post_replies_old'][$cur_group['g_id']] || $post_topics_new != $_POST['post_topics_old'][$cur_group['g_id']]) - { - // If the new settings are identical to the default settings for this group, delete it's row in forum_perms - if ($read_forum_new == '1' && $post_replies_new == $cur_group['g_post_replies'] && $post_topics_new == $cur_group['g_post_topics']) - $pun_db->query('DELETE FROM '.$pun_db->prefix.'forum_perms WHERE group_id='.$cur_group['g_id'].' AND forum_id='.$forum_id) or error('Unable to delete group forum permissions', __FILE__, __LINE__, $pun_db->error()); - else - { - // Run an UPDATE and see if it affected a row, if not, INSERT - $pun_db->query('UPDATE '.$pun_db->prefix.'forum_perms SET read_forum='.$read_forum_new.', post_replies='.$post_replies_new.', post_topics='.$post_topics_new.' WHERE group_id='.$cur_group['g_id'].' AND forum_id='.$forum_id) or error('Unable to insert group forum permissions', __FILE__, __LINE__, $pun_db->error()); - if (!$pun_db->affected_rows()) - $pun_db->query('INSERT INTO '.$pun_db->prefix.'forum_perms (group_id, forum_id, read_forum, post_replies, post_topics) VALUES('.$cur_group['g_id'].', '.$forum_id.', '.$read_forum_new.', '.$post_replies_new.', '.$post_topics_new.')') or error('Unable to insert group forum permissions', __FILE__, __LINE__, $pun_db->error()); - } - } - } - } - - // Regenerate the quickjump cache - require_once PUN_ROOT.'include/cache.php'; - generate_quickjump_cache(); - - pun_redirect('admin_forums.php', 'Forum updated. Redirecting …'); - } - else if (isset($_POST['revert_perms'])) - { - confirm_referrer('admin_forums.php'); - - $pun_db->query('DELETE FROM '.$pun_db->prefix.'forum_perms WHERE forum_id='.$forum_id) or error('Unable to delete group forum permissions', __FILE__, __LINE__, $pun_db->error()); - - // Regenerate the quickjump cache - require_once PUN_ROOT.'include/cache.php'; - generate_quickjump_cache(); - - pun_redirect('admin_forums.php?edit_forum='.$forum_id, 'Permissions reverted to defaults. Redirecting …'); - } - - - // Fetch forum info - $result = $pun_db->query('SELECT id, forum_name, forum_desc, redirect_url, num_topics, sort_by, cat_id FROM '.$pun_db->prefix.'forums WHERE id='.$forum_id) or error('Unable to fetch forum info', __FILE__, __LINE__, $pun_db->error()); - if (!$pun_db->num_rows($result)) - message($lang_common['Bad request']); - - $cur_forum = $pun_db->fetch_assoc($result); - - - $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / Admin / Forums'; - require PUN_ROOT.'header.php'; - - generate_admin_menu('forums'); - -?> -
-

Edit forum

-
-
-

-
-
- Edit forum details -
- - - - - - - - - - - - - - - - - - - - - -
Forum name
Description (HTML)
Category - -
Sort topics by - -
Redirect URL'; ?>
-
-
-
-
-
- Edit group permissions for this forum -
-

In this form, you can set the forum specific permissions for the different user groups. If you haven't made any changes to this forums group permissions, what you see below is the default based on settings in User groups. Administrators always have full permissions and are thus excluded. Permission settings that differ from the default permissions for the user group are marked red. The "Read forum" permission checkbox will be disabled if the group in question lacks the "Read board" permission. For redirect forums, only the "Read forum" permission is editable.

- - - - - - - - - - -query('SELECT g.g_id, g.g_title, g.g_read_board, g.g_post_replies, g.g_post_topics, fp.read_forum, fp.post_replies, fp.post_topics FROM '.$pun_db->prefix.'groups AS g LEFT JOIN '.$pun_db->prefix.'forum_perms AS fp ON (g.g_id=fp.group_id AND fp.forum_id='.$forum_id.') WHERE g.g_id!='.PUN_ADMIN.' ORDER BY g.g_id') or error('Unable to fetch group forum permission list', __FILE__, __LINE__, $pun_db->error()); - - while ($cur_perm = $pun_db->fetch_assoc($result)) - { - $read_forum = ($cur_perm['read_forum'] != '0') ? true : false; - $post_replies = (($cur_perm['g_post_replies'] == '0' && $cur_perm['post_replies'] == '1') || ($cur_perm['g_post_replies'] == '1' && $cur_perm['post_replies'] != '0')) ? true : false; - $post_topics = (($cur_perm['g_post_topics'] == '0' && $cur_perm['post_topics'] == '1') || ($cur_perm['g_post_topics'] == '1' && $cur_perm['post_topics'] != '0')) ? true : false; - - // Determine if the current sittings differ from the default or not - $read_forum_def = ($cur_perm['read_forum'] == '0') ? false : true; - $post_replies_def = (($post_replies && $cur_perm['g_post_replies'] == '0') || (!$post_replies && ($cur_perm['g_post_replies'] == '' || $cur_perm['g_post_replies'] == '1'))) ? false : true; - $post_topics_def = (($post_topics && $cur_perm['g_post_topics'] == '0') || (!$post_topics && ($cur_perm['g_post_topics'] == '' || $cur_perm['g_post_topics'] == '1'))) ? false : true; - -?> - - - > - - /> - - > - - /> - - > - - /> - - - - -
 Read forumPost repliesPost topics
-
-
-
-
-

-
-
-
-
- - - -
-

Add forum

-
-
-
-
- Create a new forum -
- - - - - -
Add forum to category
 - - Select the category to which you wish to add a new forum. -
-
-
-
-
-
- -

Edit forums

-
-
-

-query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.disp_position FROM '.$pun_db->prefix.'categories AS c INNER JOIN '.$pun_db->prefix.'forums AS f ON c.id=f.cat_id ORDER BY c.disp_position, c.id, f.disp_position') or error('Unable to fetch category/forum list', __FILE__, __LINE__, $pun_db->error()); - -$cur_category = 0; -while ($cur_forum = $pun_db->fetch_assoc($result)) -{ - if ($cur_forum['cid'] != $cur_category) // A new category since last iteration? - { - if ($cur_category != 0) - echo "\t\t\t\t\t\t\t".''."\n\t\t\t\t\t\t".'
'."\n\t\t\t\t\t".''."\n\t\t\t\t".'
'."\n"; - -?> -
-
- Category: -
- - - - - - - -
Edit - DeletePosition   -   
-
-
-
-

- - - -
- -