admin/admin_forum_prune.php

   1 <?php
   2 /***************************************************************************
   3 *                             admin_forum_prune.php
   4 *                              -------------------
   5 *     begin                : Mon Jul 31, 2001
   6 *     copyright            : (C) 2001 The phpBB Group
   7 *     email                : support@phpbb.com
   8 *
   9 *     $Id: admin_forum_prune.php,v 1.22.2.3 2002/12/18 14:14:07 psotfx Exp $
  10 *
  11 ****************************************************************************/
  12
  13 /***************************************************************************
  14  *
  15  *   This program is free software; you can redistribute it and/or modify
  16  *   it under the terms of the GNU General Public License as published by
  17  *   the Free Software Foundation; either version 2 of the License, or
  18  *   (at your option) any later version.
  19  *
  20  ***************************************************************************/
  21
  22 define('IN_PHPBB', true);
  23
  24 if ( !empty($setmodules) )
  25 {
  26         $filename = basename(__FILE__);
  27         $module['Forums']['Prune'] = $filename;
  28
  29         return;
  30 }
  31
  32 //
  33 // Load default header
  34 //
  35 $phpbb_root_path = "./../";
  36 require($phpbb_root_path . 'extension.inc');
  37 require('./pagestart.' . $phpEx);
  38 require($phpbb_root_path . 'includes/prune.'.$phpEx);
  39 require($phpbb_root_path . 'includes/functions_admin.'.$phpEx);
  40
  41 //
  42 // Get the forum ID for pruning
  43 //
  44 if( isset($HTTP_GET_VARS[POST_FORUM_URL]) || isset($HTTP_POST_VARS[POST_FORUM_URL]) )
  45 {
  46         $forum_id = ( isset($HTTP_POST_VARS[POST_FORUM_URL]) ) ? $HTTP_POST_VARS[POST_FORUM_URL] : $HTTP_GET_VARS[POST_FORUM_URL];
  47
  48         if( $forum_id == -1 )
  49         {
  50                 $forum_sql = '';
  51         }
  52         else
  53         {
  54                 $forum_id = intval($forum_id);
  55                 $forum_sql = "AND forum_id = $forum_id";
  56         }
  57 }
  58 else
  59 {
  60         $forum_id = '';
  61         $forum_sql = '';
  62 }
  63 //
  64 // Get a list of forum's or the data for the forum that we are pruning.
  65 //
  66 $sql = "SELECT f.*
  67         FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
  68         WHERE c.cat_id = f.cat_id
  69         $forum_sql
  70         ORDER BY c.cat_order ASC, f.forum_order ASC";
  71 if( !($result = $db->sql_query($sql)) )
  72 {
  73         message_die(GENERAL_ERROR, 'Could not obtain list of forums for pruning', '', __LINE__, __FILE__, $sql);
  74 }
  75
  76 $forum_rows = array();
  77 while( $row = $db->sql_fetchrow($result) )
  78 {
  79         $forum_rows[] = $row;
  80 }
  81
  82 //
  83 // Check for submit to be equal to Prune. If so then proceed with the pruning.
  84 //
  85 if( isset($HTTP_POST_VARS['doprune']) )
  86 {
  87         $prunedays = ( isset($HTTP_POST_VARS['prunedays']) ) ? intval($HTTP_POST_VARS['prunedays']) : 0;
  88
  89         // Convert days to seconds for timestamp functions...
  90         $prunedate = time() - ( $prunedays * 86400 );
  91
  92         $template->set_filenames(array(
  93                 'body' => 'admin/forum_prune_result_body.tpl')
  94         );
  95
  96         for($i = 0; $i < count($forum_rows); $i++)
  97         {
  98                 $p_result = prune($forum_rows[$i]['forum_id'], $prunedate);
  99                 sync('forum', $forum_rows[$i]['forum_id']);
 100
 101                 $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
 102                 $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
 103
 104                 $template->assign_block_vars('prune_results', array(
 105                         'ROW_COLOR' => '#' . $row_color,
 106                         'ROW_CLASS' => $row_class,
 107                         'FORUM_NAME' => $forum_rows[$i]['forum_name'],
 108                         'FORUM_TOPICS' => $p_result['topics'],
 109                         'FORUM_POSTS' => $p_result['posts'])
 110                 );
 111         }
 112
 113         $template->assign_vars(array(
 114                 'L_FORUM_PRUNE' => $lang['Forum_Prune'],
 115                 'L_FORUM' => $lang['Forum'],
 116                 'L_TOPICS_PRUNED' => $lang['Topics_pruned'],
 117                 'L_POSTS_PRUNED' => $lang['Posts_pruned'],
 118                 'L_PRUNE_RESULT' => $lang['Prune_success'])
 119         );
 120 }
 121 else
 122 {
 123         //
 124         // If they haven't selected a forum for pruning yet then
 125         // display a select box to use for pruning.
 126         //
 127         if( empty($HTTP_POST_VARS[POST_FORUM_URL]) )
 128         {
 129                 //
 130                 // Output a selection table if no forum id has been specified.
 131                 //
 132                 $template->set_filenames(array(
 133                         'body' => 'admin/forum_prune_select_body.tpl')
 134                 );
 135
 136                 $select_list = '<select name="' . POST_FORUM_URL . '">';
 137                 $select_list .= '<option value="-1">' . $lang['All_Forums'] . '</option>';
 138
 139                 for($i = 0; $i < count($forum_rows); $i++)
 140                 {
 141                         $select_list .= '<option value="' . $forum_rows[$i]['forum_id'] . '">' . $forum_rows[$i]['forum_name'] . '</option>';
 142                 }
 143                 $select_list .= '</select>';
 144
 145                 //
 146                 // Assign the template variables.
 147                 //
 148                 $template->assign_vars(array(
 149                         'L_FORUM_PRUNE' => $lang['Forum_Prune'],
 150                         'L_SELECT_FORUM' => $lang['Select_a_Forum'],
 151                         'L_LOOK_UP' => $lang['Look_up_Forum'],
 152
 153                         'S_FORUMPRUNE_ACTION' => append_sid("admin_forum_prune.$phpEx"),
 154                         'S_FORUMS_SELECT' => $select_list)
 155                 );
 156         }
 157         else
 158         {
 159                 $forum_id = intval($HTTP_POST_VARS[POST_FORUM_URL]);
 160
 161                 //
 162                 // Output the form to retrieve Prune information.
 163                 //
 164                 $template->set_filenames(array(
 165                         'body' => 'admin/forum_prune_body.tpl')
 166                 );
 167
 168                 $forum_name = ( $forum_id == -1 ) ? $lang['All_Forums'] : $forum_rows[0]['forum_name'];
 169
 170                 $prune_data = $lang['Prune_topics_not_posted'] . " ";
 171                 $prune_data .= '<input class="post" type="text" name="prunedays" size="4"> ' . $lang['Days'];
 172
 173                 $hidden_input = '<input type="hidden" name="' . POST_FORUM_URL . '" value="' . $forum_id . '" />';
 174
 175                 //
 176                 // Assign the template variables.
 177                 //
 178                 $template->assign_vars(array(
 179                         'FORUM_NAME' => $forum_name,
 180
 181                         'L_FORUM' => $lang['Forum'],
 182                         'L_FORUM_PRUNE' => $lang['Forum_Prune'],
 183                         'L_FORUM_PRUNE_EXPLAIN' => $lang['Forum_Prune_explain'],
 184                         'L_DO_PRUNE' => $lang['Do_Prune'],
 185
 186                         'S_FORUMPRUNE_ACTION' => append_sid("admin_forum_prune.$phpEx"),
 187                         'S_PRUNE_DATA' => $prune_data,
 188                         'S_HIDDEN_VARS' => $hidden_input)
 189                 );
 190         }
 191 }
 192 //
 193 // Actually output the page here.
 194 //
 195 $template->pparse('body');
 196
 197 include('./page_footer_admin.'.$phpEx);
 198
 199 ?>