source: trunk/web/punbb/admin_ranks.php

<?php

/**
 * Copyright (C) 2008-2011 FluxBB
 * based on code by Rickard Andersson copyright (C) 2002-2008 PunBB
 * License: http://www.gnu.org/licenses/gpl.html GPL version 2 or higher
 */

// Tell header.php to use the admin template
define('PUN_ADMIN_CONSOLE', 1);

define('PUN_ROOT', dirname(__FILE__).'/');
require PUN_ROOT.'include/common.php';
require PUN_ROOT.'include/common_admin.php';


if ($pun_user['g_id'] != PUN_ADMIN)
        message($lang_common['No permission']);

// Load the admin_ranks.php language file
require PUN_ROOT.'lang/'.$admin_language.'/admin_ranks.php';

// Add a rank
if (isset($_POST['add_rank']))
{
        confirm_referrer('admin_ranks.php');

        $rank = pun_trim($_POST['new_rank']);
        $min_posts = trim($_POST['new_min_posts']);

        if ($rank == '')
                message($lang_admin_ranks['Must enter title message']);

        if ($min_posts == '' || preg_match('%[^0-9]%', $min_posts))
                message($lang_admin_ranks['Must be integer message']);

        // Make sure there isn't already a rank with the same min_posts value
        $result = $db->query('SELECT 1 FROM '.$db->prefix.'ranks WHERE min_posts='.$min_posts) or error('Unable to fetch rank info', __FILE__, __LINE__, $db->error());
        if ($db->num_rows($result))
                message(sprintf($lang_admin_ranks['Dupe min posts message'], $min_posts));

        $db->query('INSERT INTO '.$db->prefix.'ranks (rank, min_posts) VALUES(\''.$db->escape($rank).'\', '.$min_posts.')') or error('Unable to add rank', __FILE__, __LINE__, $db->error());

        // Regenerate the ranks cache
        if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
                require PUN_ROOT.'include/cache.php';

        generate_ranks_cache();

        redirect('admin_ranks.php', $lang_admin_ranks['Rank added redirect']);
}


// Update a rank
else if (isset($_POST['update']))
{
        confirm_referrer('admin_ranks.php');

        $id = intval(key($_POST['update']));

        $rank = pun_trim($_POST['rank'][$id]);
        $min_posts = trim($_POST['min_posts'][$id]);

        if ($rank == '')
                message($lang_admin_ranks['Must enter title message']);

        if ($min_posts == '' || preg_match('%[^0-9]%', $min_posts))
                message($lang_admin_ranks['Must be integer message']);

        // Make sure there isn't already a rank with the same min_posts value
        $result = $db->query('SELECT 1 FROM '.$db->prefix.'ranks WHERE id!='.$id.' AND min_posts='.$min_posts) or error('Unable to fetch rank info', __FILE__, __LINE__, $db->error());
        if ($db->num_rows($result))
                message(sprintf($lang_admin_ranks['Dupe min posts message'], $min_posts));

        $db->query('UPDATE '.$db->prefix.'ranks SET rank=\''.$db->escape($rank).'\', min_posts='.$min_posts.' WHERE id='.$id) or error('Unable to update rank', __FILE__, __LINE__, $db->error());

        // Regenerate the ranks cache
        if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
                require PUN_ROOT.'include/cache.php';

        generate_ranks_cache();

        redirect('admin_ranks.php', $lang_admin_ranks['Rank updated redirect']);
}


// Remove a rank
else if (isset($_POST['remove']))
{
        confirm_referrer('admin_ranks.php');

        $id = intval(key($_POST['remove']));

        $db->query('DELETE FROM '.$db->prefix.'ranks WHERE id='.$id) or error('Unable to delete rank', __FILE__, __LINE__, $db->error());

        // Regenerate the ranks cache
        if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
                require PUN_ROOT.'include/cache.php';

        generate_ranks_cache();

        redirect('admin_ranks.php', $lang_admin_ranks['Rank removed redirect']);
}

$page_title = array(pun_htmlspecialchars($pun_config['o_board_title']), $lang_admin_common['Admin'], $lang_admin_common['Ranks']);
$focus_element = array('ranks', 'new_rank');
define('PUN_ACTIVE_PAGE', 'admin');
require PUN_ROOT.'header.php';

generate_admin_menu('ranks');

?>
        <div class="blockform">
                <h2><span><?php echo $lang_admin_ranks['Ranks head'] ?></span></h2>
                <div class="box">
                        <form id="ranks" method="post" action="admin_ranks.php">
                                <div class="inform">
                                        <fieldset>
                                                <legend><?php echo $lang_admin_ranks['Add rank subhead'] ?></legend>
                                                <div class="infldset">
                                                        <p><?php echo $lang_admin_ranks['Add rank info'].' '.($pun_config['o_ranks'] == '1' ? sprintf($lang_admin_ranks['Ranks enabled'], '<a href="admin_options.php#ranks">'.$lang_admin_common['Options'].'</a>') : sprintf($lang_admin_ranks['Ranks disabled'], '<a href="admin_options.php#ranks">'.$lang_admin_common['Options'].'</a>')) ?></p>
                                                        <table cellspacing="0">
                                                        <thead>
                                                                <tr>
                                                                        <th class="tcl" scope="col"><?php echo $lang_admin_ranks['Rank title label'] ?></th>
                                                                        <th class="tc2" scope="col"><?php echo $lang_admin_ranks['Minimum posts label'] ?></th>
                                                                        <th class="hidehead" scope="col"><?php echo $lang_admin_ranks['Actions label'] ?></th>
                                                                </tr>
                                                        </thead>
                                                        <tbody>
                                                                <tr>
                                                                        <td class="tcl"><input type="text" name="new_rank" size="24" maxlength="50" tabindex="1" /></td>
                                                                        <td class="tc2"><input type="text" name="new_min_posts" size="7" maxlength="7" tabindex="2" /></td>
                                                                        <td><input type="submit" name="add_rank" value="<?php echo $lang_admin_common['Add'] ?>" tabindex="3" /></td>
                                                                </tr>
                                                        </tbody>
                                                        </table>
                                                </div>
                                        </fieldset>
                                </div>
                                <div class="inform">
                                        <fieldset>
                                                <legend><?php echo $lang_admin_ranks['Edit remove subhead'] ?></legend>
                                                <div class="infldset">
<?php

$result = $db->query('SELECT id, rank, min_posts FROM '.$db->prefix.'ranks ORDER BY min_posts') or error('Unable to fetch rank list', __FILE__, __LINE__, $db->error());
if ($db->num_rows($result))
{

?>
                                                        <table cellspacing="0">
                                                        <thead>
                                                                <tr>
                                                                        <th class="tcl" scope="col"><?php echo $lang_admin_ranks['Rank title label'] ?></th>
                                                                        <th class="tc2" scope="col"><?php echo $lang_admin_ranks['Minimum posts label'] ?></th>
                                                                        <th class="hidehead" scope="col"><?php echo $lang_admin_ranks['Actions label'] ?></th>
                                                                </tr>
                                                        </thead>
                                                        <tbody>
<?php

        while ($cur_rank = $db->fetch_assoc($result))
                echo "\t\t\t\t\t\t\t\t".'<tr><td class="tcl"><input type="text" name="rank['.$cur_rank['id'].']" value="'.pun_htmlspecialchars($cur_rank['rank']).'" size="24" maxlength="50" /></td><td class="tc2"><input type="text" name="min_posts['.$cur_rank['id'].']" value="'.$cur_rank['min_posts'].'" size="7" maxlength="7" /></td><td><input type="submit" name="update['.$cur_rank['id'].']" value="'.$lang_admin_common['Update'].'" />&#160;<input type="submit" name="remove['.$cur_rank['id'].']" value="'.$lang_admin_common['Remove'].'" /></td></tr>'."\n";

?>
                                                        </tbody>
                                                        </table>
<?php

}
else
        echo "\t\t\t\t\t\t\t".'<p>'.$lang_admin_ranks['No ranks in list'].'</p>'."\n";

?>
                                                </div>
                                        </fieldset>
                                </div>
                        </form>
                </div>
        </div>
        <div class="clearer"></div>
</div>
<?php

require PUN_ROOT.'footer.php';