root/admin/admin_forum_prune.php

<?php
/***************************************************************************</span>
<span class="code-comment">*                             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.
 *
 ***************************************************************************/

if ( !empty($setmodules) )</span>
<span class="code-keyword">{
        $filename = basename(__FILE__);
        $module['forums']['prune'] = $filename;

        return;
}

define('IN_PHPBB', 1);

//</span>
<span class="code-comment">// Load default header
//
$root_path = './../';</span>
<span class="code-lang">require($root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
require($root_path . 'phpBB2/includes/prune.'.$phpEx);
require($root_path . 'include/functions_admin.'.$phpEx);

//</span>
<span class="code-comment">// Get the forum ID for pruning
//
if( isset($_GET[POST_FORUM_URL]) || isset($_POST[POST_FORUM_URL]) )</span>
<span class="code-keyword">{
        $forum_id = ( isset($_POST[POST_FORUM_URL]) ) ? $_POST[POST_FORUM_URL] : $_GET[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 = '';
}
//</span>
<span class="code-comment">// Get a list of forum's or the data for the forum that we are pruning.
//
$sql = "SELECT f.*</span>
<span class="code-lang">        FROM " . FORUMS_TABLE . " f, " . FORUM_CATEGORIES_TABLE . " c
        WHERE c.cat_id = f.cat_id
        $forum_sql
        ORDER BY c.cat_order ASC, f.forum_order ASC";
$result = $db->sql_query($sql);

$forum_rows = array();</span>
<span class="code-lang">while( $row = $db->sql_fetchrow($result) )
{
        $forum_rows[] = $row;
}

//</span>
<span class="code-comment">// Check for submit to be equal to Prune. If so then proceed with the pruning.
//
if( isset($_POST['doprune']) )</span>
<span class="code-keyword">{
        $prunedays = ( isset($_POST['prunedays']) ) ? intval($_POST['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($_POST[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($_POST[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)
                );
        }
}
//</span>
<span class="code-comment">// Actually output the page here.
//
$template->display('body');</span>
<span class="code-lang">
include('./page_footer_admin.'.$phpEx);

?>