-<?php

-/***************************************************************************

-* admin_prune.php

-* -------------------

-* begin : Mon Jul 31, 2001

-* copyright : (C) 2001 The phpBB Group

-* email : support@phpbb.com

-*

-* $Id$

-*

-****************************************************************************/

-

-/***************************************************************************

- *

- * 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))

-{

- if (!$auth->acl_get('a_prune'))

- {

- return;

- }

-

- $module['FORUM']['PRUNE'] = basename(__FILE__) . $SID . '&amp;mode=forums';

-

- return;

-}

-

-define('IN_PHPBB', 1);

-// Include files

-$phpbb_root_path = '../';

-require($phpbb_root_path . 'extension.inc');

-require('pagestart.' . $phpEx);

-

-// Do we have permission?

-if (!$auth->acl_get('a_prune'))

-{

- trigger_error($user->lang['NO_ADMIN']);

-}

-

-// Get the forum ID for pruning

-if (isset($_REQUEST['f']))

-{

- $forum_id = intval($_REQUEST['f']);

- $forum_sql = ($forum_id == -1) ? '' : "AND forum_id = $forum_id";

-}

-else

-{

- $forum_id = '';

- $forum_sql = '';

-}

-

-

-// Check for submit to be equal to Prune. If so then proceed with the pruning.

-if (isset($_POST['doprune']))

-{

- $prunedays = (isset($_POST['prunedays'])) ? intval($_POST['prunedays']) : 0;

-

- // Convert days to seconds for timestamp functions...

- $prunedate = time() - ($prunedays * 86400);

-

- page_header($user->lang['PRUNE']);

-

-?>

-

-<h1><?php echo $user->lang['PRUNE']; ?></h1>

-

-<p><?php echo $user->lang['PRUNE_SUCCESS']; ?></p>

-

-<table class="bg" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th><?php echo $user->lang['FORUM']; ?></th>

- <th><?php echo $user->lang['TOPICS_PRUNED']; ?></th>

- <th><?php echo $user->lang['POSTS_PRUNED']; ?></th>

- </tr>

-<?php

-

- // Get a list of forum's or the data for the forum that we are pruning.

- $sql = "SELECT forum_id, forum_name

- FROM " . FORUMS_TABLE . "

- ORDER BY left_id ASC";

- $result = $db->sql_query($sql);

-

- if ($row = $db->sql_fetchrow($result))

- {

- $log_data = '';

- do

- {

- $p_result = prune($forum_rows[$i]['forum_id'], $prunedate);

- sync('forum', $forum_rows[$i]['forum_id']);

-

- $row_class = ($row_class == 'row1') ? 'row2' : 'row1';

-

-?>

- <tr>

- <td class="<?php echo $row_class; ?>" align="center"><?php echo $row['forum_name']; ?></td>

- <td class="<?php echo $row_class; ?>" align="center"><?php echo $p_result['topics']; ?></td>

- <td class="<?php echo $row_class; ?>" align="center"><?php echo $p_result['posts']; ?></td>

- </tr>

-<?php

-

- $log_data .= (($log_data != '') ? ', ' : '') . $forum_rows[$i]['forum_name'];

- }

- while($row = $db->sql_fetchrow($result));

-

- add_log('admin', 'log_prune', $log_data);

-

- }

- else

- {

-

-?>

- <tr>

- <td class="row1" align="center"><?php echo $user->lang['NO_PRUNE']; ?></td>

- </tr>

-<?php

-

- }

- $db->sql_freeresult($result);

-

-?>

-</table>

-

-<br clear="all" />

-

-<?php

-

- page_footer();

-

-}

-

-page_header($user->lang['PRUNE']);

-

-?>

-

-<h1><?php echo $user->lang['PRUNE']; ?></h1>

-

-<p><?php echo $user->lang['FORUM_PRUNE_EXPLAIN']; ?></p>

-

-<?php

-

-// If they haven't selected a forum for pruning yet then

-// display a select box to use for pruning.

-if (empty($forum_id))

-{

-

- // Output a selection table if no forum id has been specified.

- $select_list = '<option value="-1">' . $user->lang['ALL_FORUMS'] . '</option>' . make_forum_select(false, false, false);

-

-?>

-

-<form method="post" action="admin_prune.<?php echo $phpEx . $SID; ?>"><table class="bg" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th align="center"><?php echo $user->lang['SELECT_FORUM']; ?></th>

- </tr>

- <tr>

- <td class="row1" align="center">&nbsp;<select name="f"><?php echo $select_list; ?></select>&nbsp;&nbsp;<input type="submit" value="<?php echo $user->lang['LOOK_UP_FORUM']; ?>" class="mainoption" />&nbsp;</td>

- </tr>

-</table></form>

-

-<?php

-

-}

-else

-{

- $sql = "SELECT forum_name

- FROM " . FORUMS_TABLE . "

- WHERE forum_id = $forum_id";

- $result = $db->sql_query($sql);

-

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- $forum_name = ($forum_id == -1) ? $user->lang['ALL_FORUMS'] : $row['forum_name'];

-

-?>

-

-<h2><?php echo $user->lang['FORUM'] . ': <i>' . $forum_name; ?></i></h2>

-

-<form method="post" action="admin_prune.<?php echo $phpEx . $SID; ?>"><table class="bg" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th class="th"><?php echo $user->lang['FORUM_PRUNE']; ?></th>

- </tr>

- <tr>

- <td class="row1"><?php echo sprintf($user->lang['PRUNE_NOT_POSTED'], '<input type="text" name="prunedays" size="4" />'); ?></td>

- </tr>

- <tr>

- <td class="cat" align="center"><input type="hidden" name="f" value="<?php echo $forum_id; ?>" /><input type="submit" name="doprune" value="<?php echo $user->lang['DO_PRUNE']; ?>" class="mainoption"></td>

- </tr>

-</table></form>

-

-<?php

-

-}

-

-page_footer();

-

-?> \ No newline at end of file