1 rizwank 1.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 rizwank 1.1 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 rizwank 1.1 //
 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 rizwank 1.1 // 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 rizwank 1.1 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 rizwank 1.1 			'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 rizwank 1.1 	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 rizwank 1.1 		$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 rizwank 1.1 
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 rizwank 1.1 	}
191             }
192             //
193             // Actually output the page here.
194             //
195             $template->pparse('body');
196             
197             include('./page_footer_admin.'.$phpEx);
198             
199             ?>