+++ /dev/null
-<?php
-/***************************************************************************
-* admin_forum_prune.php
-* -------------------
-* begin : Mon Jul 31, 2001
-* copyright : (C) 2001 The phpBB Group
-* email : support@phpbb.com
-*
-* $Id: admin_forum_prune.php,v 1.22.2.3 2002/12/18 14:14:07 psotfx Exp $
-*
-****************************************************************************/
-
-/***************************************************************************
- *
- * This program is free software; you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation; either version 2 of the License, or
- * (at your option) any later version.
- *
- ***************************************************************************/
-
-define('IN_PHPBB', true);
-
-if ( !empty($setmodules) )
-{
- $filename = basename(__FILE__);
- $module['Forums']['Prune'] = $filename;
-
- return;
-}
-
-//
-// Load default header
-//
-$phpbb_root_path = "./../";
-require($phpbb_root_path . 'extension.inc');
-require('./pagestart.' . $phpEx);
-require($phpbb_root_path . 'includes/prune.'.$phpEx);
-require($phpbb_root_path . 'includes/functions_admin.'.$phpEx);
-
-//
-// Get the forum ID for pruning
-//
-if( isset($HTTP_GET_VARS[POST_FORUM_URL]) || isset($HTTP_POST_VARS[POST_FORUM_URL]) )
-{
- $forum_id = ( isset($HTTP_POST_VARS[POST_FORUM_URL]) ) ? $HTTP_POST_VARS[POST_FORUM_URL] : $HTTP_GET_VARS[POST_FORUM_URL];
-
- if( $forum_id == -1 )
- {
- $forum_sql = '';
- }
- else
- {
- $forum_id = intval($forum_id);
- $forum_sql = "AND forum_id = $forum_id";
- }
-}
-else
-{
- $forum_id = '';
- $forum_sql = '';
-}
-//
-// Get a list of forum's or the data for the forum that we are pruning.
-//
-$sql = "SELECT f.*
- FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
- WHERE c.cat_id = f.cat_id
- $forum_sql
- ORDER BY c.cat_order ASC, f.forum_order ASC";
-if( !($result = $db->sql_query($sql)) )
-{
- message_die(GENERAL_ERROR, 'Could not obtain list of forums for pruning', '', __LINE__, __FILE__, $sql);
-}
-
-$forum_rows = array();
-while( $row = $db->sql_fetchrow($result) )
-{
- $forum_rows[] = $row;
-}
-
-//
-// Check for submit to be equal to Prune. If so then proceed with the pruning.
-//
-if( isset($HTTP_POST_VARS['doprune']) )
-{
- $prunedays = ( isset($HTTP_POST_VARS['prunedays']) ) ? intval($HTTP_POST_VARS['prunedays']) : 0;
-
- // Convert days to seconds for timestamp functions...
- $prunedate = time() - ( $prunedays * 86400 );
-
- $template->set_filenames(array(
- 'body' => 'admin/forum_prune_result_body.tpl')
- );
-
- for($i = 0; $i < count($forum_rows); $i++)
- {
- $p_result = prune($forum_rows[$i]['forum_id'], $prunedate);
- sync('forum', $forum_rows[$i]['forum_id']);
-
- $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
- $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
-
- $template->assign_block_vars('prune_results', array(
- 'ROW_COLOR' => '#' . $row_color,
- 'ROW_CLASS' => $row_class,
- 'FORUM_NAME' => $forum_rows[$i]['forum_name'],
- 'FORUM_TOPICS' => $p_result['topics'],
- 'FORUM_POSTS' => $p_result['posts'])
- );
- }
-
- $template->assign_vars(array(
- 'L_FORUM_PRUNE' => $lang['Forum_Prune'],
- 'L_FORUM' => $lang['Forum'],
- 'L_TOPICS_PRUNED' => $lang['Topics_pruned'],
- 'L_POSTS_PRUNED' => $lang['Posts_pruned'],
- 'L_PRUNE_RESULT' => $lang['Prune_success'])
- );
-}
-else
-{
- //
- // If they haven't selected a forum for pruning yet then
- // display a select box to use for pruning.
- //
- if( empty($HTTP_POST_VARS[POST_FORUM_URL]) )
- {
- //
- // Output a selection table if no forum id has been specified.
- //
- $template->set_filenames(array(
- 'body' => 'admin/forum_prune_select_body.tpl')
- );
-
- $select_list = '<select name="' . POST_FORUM_URL . '">';
- $select_list .= '<option value="-1">' . $lang['All_Forums'] . '</option>';
-
- for($i = 0; $i < count($forum_rows); $i++)
- {
- $select_list .= '<option value="' . $forum_rows[$i]['forum_id'] . '">' . $forum_rows[$i]['forum_name'] . '</option>';
- }
- $select_list .= '</select>';
-
- //
- // Assign the template variables.
- //
- $template->assign_vars(array(
- 'L_FORUM_PRUNE' => $lang['Forum_Prune'],
- 'L_SELECT_FORUM' => $lang['Select_a_Forum'],
- 'L_LOOK_UP' => $lang['Look_up_Forum'],
-
- 'S_FORUMPRUNE_ACTION' => append_sid("admin_forum_prune.$phpEx"),
- 'S_FORUMS_SELECT' => $select_list)
- );
- }
- else
- {
- $forum_id = intval($HTTP_POST_VARS[POST_FORUM_URL]);
-
- //
- // Output the form to retrieve Prune information.
- //
- $template->set_filenames(array(
- 'body' => 'admin/forum_prune_body.tpl')
- );
-
- $forum_name = ( $forum_id == -1 ) ? $lang['All_Forums'] : $forum_rows[0]['forum_name'];
-
- $prune_data = $lang['Prune_topics_not_posted'] . " ";
- $prune_data .= '<input class="post" type="text" name="prunedays" size="4"> ' . $lang['Days'];
-
- $hidden_input = '<input type="hidden" name="' . POST_FORUM_URL . '" value="' . $forum_id . '" />';
-
- //
- // Assign the template variables.
- //
- $template->assign_vars(array(
- 'FORUM_NAME' => $forum_name,
-
- 'L_FORUM' => $lang['Forum'],
- 'L_FORUM_PRUNE' => $lang['Forum_Prune'],
- 'L_FORUM_PRUNE_EXPLAIN' => $lang['Forum_Prune_explain'],
- 'L_DO_PRUNE' => $lang['Do_Prune'],
-
- 'S_FORUMPRUNE_ACTION' => append_sid("admin_forum_prune.$phpEx"),
- 'S_PRUNE_DATA' => $prune_data,
- 'S_HIDDEN_VARS' => $hidden_input)
- );
- }
-}
-//
-// Actually output the page here.
-//
-$template->pparse('body');
-
-include('./page_footer_admin.'.$phpEx);
-
-?>
\ No newline at end of file