source: trunk/web/punbb/include/common_admin.php @ 1

<?php
/***********************************************************************

  Copyright (C) 2002-2005  Rickard Andersson (rickard@punbb.org)

  This file is part of PunBB.

  PunBB 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.

  PunBB is distributed in the hope that it will be useful, but
  WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with this program; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place, Suite 330, Boston,
  MA  02111-1307  USA

************************************************************************/

// Make sure no one attempts to run this script "directly"
if (!defined('PUN'))
        exit;


//
// Display the admin navigation menu
//
function generate_admin_menu($page = '')
{
        global $pun_config, $pun_user;

        $is_admin = $pun_user['g_id'] == PUN_ADMIN ? true : false;

?>
<div id="adminconsole" class="block2col">
        <div id="adminmenu" class="blockmenu">
                <h2><span>Menu <?php echo ($is_admin) ? 'Admin' : 'Modérateur' ?></span></h2>
                <div class="box">
                        <div class="inbox">
                                <ul>
                                        <li<?php if ($page == 'index') echo ' class="isactive"'; ?>><a href="admin_index.php">Index</a></li>
<?php if ($is_admin): ?>                                        <li<?php if ($page == 'categories') echo ' class="isactive"'; ?>><a href="admin_categories.php">Catégories</a></li>
<?php endif; ?><?php if ($is_admin): ?>                                 <li<?php if ($page == 'forums') echo ' class="isactive"'; ?>><a href="admin_forums.php">Forums</a></li>
<?php endif; ?>                                 <li<?php if ($page == 'users') echo ' class="isactive"'; ?>><a href="admin_users.php">Utilisateurs</a></li>
<?php if ($is_admin): ?>                                        <li<?php if ($page == 'groups') echo ' class="isactive"'; ?>><a href="admin_groups.php">Groupes</a></li>
<?php endif; ?><?php if ($is_admin): ?>                                 <li<?php if ($page == 'options') echo ' class="isactive"'; ?>><a href="admin_options.php">Options</a></li>
<?php endif; ?><?php if ($is_admin): ?>                                 <li<?php if ($page == 'permissions') echo ' class="isactive"'; ?>><a href="admin_permissions.php">Permissions</a></li>
<?php endif; ?>                                 <li<?php if ($page == 'censoring') echo ' class="isactive"'; ?>><a href="admin_censoring.php">Mots censurés</a></li>
<?php if ($is_admin): ?>                                        <li<?php if ($page == 'ranks') echo ' class="isactive"'; ?>><a href="admin_ranks.php">Rangs utilisateurs</a></li>
<?php endif; ?><?php if ($is_admin || $pun_config['p_mod_ban_users'] == '1'): ?>                                        <li<?php if ($page == 'bans') echo ' class="isactive"'; ?>><a href="admin_bans.php">Bannissements</a></li>
<?php endif; ?><?php if ($is_admin): ?>                                 <li<?php if ($page == 'prune') echo ' class="isactive"'; ?>><a href="admin_prune.php">Élaguage</a></li>
<?php endif; ?><?php if ($is_admin): ?>                                 <li<?php if ($page == 'maintenance') echo ' class="isactive"'; ?>><a href="admin_maintenance.php">Maintenance</a></li>
<?php endif; ?>                                 <li<?php if ($page == 'reports') echo ' class="isactive"'; ?>><a href="admin_reports.php">Signalements</a></li>
                                </ul>
                        </div>
                </div>
<?php

        // See if there are any plugins
        $plugins = array();
        $d = dir(PUN_ROOT.'plugins');
        while (($entry = $d->read()) !== false)
        {
                $prefix = substr($entry, 0, strpos($entry, '_'));
                $suffix = substr($entry, strlen($entry) - 4);

                if ($suffix == '.php' && ((!$is_admin && $prefix == 'AMP') || ($is_admin && ($prefix == 'AP' || $prefix == 'AMP'))))
                        $plugins[] = array(substr(substr($entry, strpos($entry, '_') + 1), 0, -4), $entry);
        }
        $d->close();

        // Did we find any plugins?
        if (!empty($plugins))
        {

?>
                <h2 class="block2"><span>Plugins</span></h2>
                <div class="box">
                        <div class="inbox">
                                <ul>
<?php

                while (list(, $cur_plugin) = @each($plugins))
                        echo "\t\t\t\t\t".'<li'.(($page == $cur_plugin[1]) ? ' class="isactive"' : '').'><a href="admin_loader.php?plugin='.$cur_plugin[1].'">'.str_replace('_', ' ', $cur_plugin[0]).'</a></li>'."\n";

?>
                                </ul>
                        </div>
                </div>
<?php

        }

?>
        </div>

<?php

}


//
// Delete topics from $forum_id that are "older than" $prune_date (if $prune_sticky is 1, sticky topics will also be deleted)
//
function prune($forum_id, $prune_sticky, $prune_date)
{
        global $db;

        $extra_sql = ($prune_date != -1) ? ' AND last_post<'.$prune_date : '';

        if (!$prune_sticky)
                $extra_sql .= ' AND sticky=\'0\'';

        // Fetch topics to prune
        $result = $db->query('SELECT id FROM '.$db->prefix.'topics WHERE forum_id='.$forum_id.$extra_sql, true) or error('Impossible de retrouver la liste des discussions', __FILE__, __LINE__, $db->error());

        $topic_ids = '';
        while ($row = $db->fetch_row($result))
                $topic_ids .= (($topic_ids != '') ? ',' : '').$row[0];

        if ($topic_ids != '')
        {
                // Fetch posts to prune
                $result = $db->query('SELECT id FROM '.$db->prefix.'posts WHERE topic_id IN('.$topic_ids.')', true) or error('Impossible de retrouver les messages', __FILE__, __LINE__, $db->error());

                $post_ids = '';
                while ($row = $db->fetch_row($result))
                        $post_ids .= (($post_ids != '') ? ',' : '').$row[0];

                if ($post_ids != '')
                {
                        // Delete topics
                        $db->query('DELETE FROM '.$db->prefix.'topics WHERE id IN('.$topic_ids.')') or error('Impossible d\'élaguer les discussions', __FILE__, __LINE__, $db->error());
                        // Delete subscriptions
                        $db->query('DELETE FROM '.$db->prefix.'subscriptions WHERE topic_id IN('.$topic_ids.')') or error('Impossible d\'élaguer les abonnements', __FILE__, __LINE__, $db->error());
                        // Delete posts
                        $db->query('DELETE FROM '.$db->prefix.'posts WHERE id IN('.$post_ids.')') or error('Impossible d\'élaguer les messages', __FILE__, __LINE__, $db->error());

                        // We removed a bunch of posts, so now we have to update the search index
                        require_once PUN_ROOT.'include/search_idx.php';
                        strip_search_index($post_ids);
                }
        }
}