193 lines
7.3 KiB
PHP
193 lines
7.3 KiB
PHP
<?php
|
|
|
|
/**
|
|
* Copyright (C) 2008-2012 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'], false, '403 Forbidden');
|
|
|
|
// Load the admin_censoring.php language file
|
|
require PUN_ROOT.'lang/'.$admin_language.'/admin_censoring.php';
|
|
|
|
// Add a censor word
|
|
if (isset($_POST['add_word']))
|
|
{
|
|
confirm_referrer('admin_censoring.php');
|
|
|
|
$search_for = pun_trim($_POST['new_search_for'] ?? '');
|
|
$replace_with = pun_trim($_POST['new_replace_with'] ?? '');
|
|
|
|
if ($search_for == '')
|
|
message($lang_admin_censoring['Must enter word message']);
|
|
|
|
$db->query('INSERT INTO '.$db->prefix.'censoring (search_for, replace_with) VALUES (\''.$db->escape($search_for).'\', \''.$db->escape($replace_with).'\')') or error('Unable to add censor word', __FILE__, __LINE__, $db->error());
|
|
|
|
$word = $db->escape($search_for);
|
|
$result = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'censoring WHERE search_for IN (\''.$word.'\',\'*'.$word.'\',\''.$word.'*\',\'*'.$word.'*\')') or error('Unable to fetch censor word', __FILE__, __LINE__, $db->error());
|
|
$nwords = $db->result($result);
|
|
|
|
// Regenerate the censoring cache
|
|
if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
|
|
require PUN_ROOT.'include/cache.php';
|
|
|
|
generate_censoring_cache();
|
|
|
|
redirect('admin_censoring.php'.(($nwords > 1) ? '?censorflag=1' : ''), $lang_admin_censoring['Word added redirect']);
|
|
}
|
|
|
|
// Update a censor word
|
|
else if (is_array($_POST['update'] ?? null))
|
|
{
|
|
confirm_referrer('admin_censoring.php');
|
|
|
|
$id = intval(key($_POST['update']));
|
|
|
|
$search_for = pun_trim($_POST['search_for'][$id] ?? '');
|
|
$replace_with = pun_trim($_POST['replace_with'][$id] ?? '');
|
|
|
|
if ($search_for == '')
|
|
message($lang_admin_censoring['Must enter word message']);
|
|
|
|
$db->query('UPDATE '.$db->prefix.'censoring SET search_for=\''.$db->escape($search_for).'\', replace_with=\''.$db->escape($replace_with).'\' WHERE id='.$id) or error('Unable to update censor word', __FILE__, __LINE__, $db->error());
|
|
|
|
$word = $db->escape($search_for);
|
|
$result = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'censoring WHERE search_for IN (\''.$word.'\',\'*'.$word.'\',\''.$word.'*\',\'*'.$word.'*\')') or error('Unable to fetch censor word', __FILE__, __LINE__, $db->error());
|
|
$nwords = $db->result($result);
|
|
|
|
// Regenerate the censoring cache
|
|
if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
|
|
require PUN_ROOT.'include/cache.php';
|
|
|
|
generate_censoring_cache();
|
|
|
|
redirect('admin_censoring.php'.(($nwords > 1) ? '?censorflag=1' : ''), $lang_admin_censoring['Word updated redirect']);
|
|
}
|
|
|
|
// Remove a censor word
|
|
else if (is_array($_POST['remove'] ?? null))
|
|
{
|
|
confirm_referrer('admin_censoring.php');
|
|
|
|
$id = intval(key($_POST['remove']));
|
|
|
|
$db->query('DELETE FROM '.$db->prefix.'censoring WHERE id='.$id) or error('Unable to delete censor word', __FILE__, __LINE__, $db->error());
|
|
|
|
// Regenerate the censoring cache
|
|
if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
|
|
require PUN_ROOT.'include/cache.php';
|
|
|
|
generate_censoring_cache();
|
|
|
|
redirect('admin_censoring.php', $lang_admin_censoring['Word removed redirect']);
|
|
}
|
|
|
|
$page_title = array(pun_htmlspecialchars($pun_config['o_board_title']), $lang_admin_common['Admin'], $lang_admin_common['Censoring']);
|
|
$focus_element = array('censoring', 'new_search_for');
|
|
define('PUN_ACTIVE_PAGE', 'admin');
|
|
require PUN_ROOT.'header.php';
|
|
|
|
generate_admin_menu('censoring');
|
|
|
|
?>
|
|
<div class="blockform">
|
|
<h2><span><?php echo $lang_admin_censoring['Censoring head'] ?></span></h2>
|
|
<div class="box">
|
|
<form id="censoring" method="post" action="admin_censoring.php">
|
|
<div class="inform">
|
|
<input type="hidden" name="csrf_hash" value="<?php echo csrf_hash() ?>" />
|
|
<fieldset>
|
|
<legend><?php echo $lang_admin_censoring['Add word subhead'] ?></legend>
|
|
<div class="infldset">
|
|
<p><?php echo $lang_admin_censoring['Add word info'].' '.($pun_config['o_censoring'] == '1' ? sprintf($lang_admin_censoring['Censoring enabled'], '<a href="admin_options.php#censoring">'.$lang_admin_common['Options'].'</a>') : sprintf($lang_admin_censoring['Censoring disabled'], '<a href="admin_options.php#censoring">'.$lang_admin_common['Options'].'</a>')) ?></p>
|
|
<table>
|
|
<thead>
|
|
<tr>
|
|
<th class="tcl" scope="col"><?php echo $lang_admin_censoring['Censored word label'] ?></th>
|
|
<th class="tc2" scope="col"><?php echo $lang_admin_censoring['Replacement label'] ?></th>
|
|
<th class="hidehead" scope="col"><?php echo $lang_admin_censoring['Action label'] ?></th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<tr>
|
|
<td class="tcl"><input type="text" name="new_search_for" size="24" maxlength="60" tabindex="1" /></td>
|
|
<td class="tc2"><input type="text" name="new_replace_with" size="24" maxlength="60" tabindex="2" /></td>
|
|
<td><input type="submit" name="add_word" value="<?php echo $lang_admin_common['Add'] ?>" tabindex="3" /></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</fieldset>
|
|
</div>
|
|
<?php if (isset($_GET['censorflag'])): ?>
|
|
<div class="inform">
|
|
<fieldset>
|
|
<legend><?php echo $lang_admin_censoring['Double'] ?></legend>
|
|
<div class="infldset">
|
|
<p><span style="color: red"><strong><?php echo $lang_admin_censoring['Double2'] ?></strong></span></p>
|
|
</div>
|
|
</fieldset>
|
|
</div>
|
|
<?php endif; ?>
|
|
<div class="inform">
|
|
<fieldset>
|
|
<legend><?php echo $lang_admin_censoring['Edit remove subhead'] ?></legend>
|
|
<div class="infldset">
|
|
<?php
|
|
|
|
$result = $db->query('SELECT id, search_for, replace_with FROM '.$db->prefix.'censoring ORDER BY id') or error('Unable to fetch censor word list', __FILE__, __LINE__, $db->error());
|
|
$cur_word = $db->fetch_assoc($result);
|
|
|
|
if (is_array($cur_word))
|
|
{
|
|
|
|
?>
|
|
<table>
|
|
<thead>
|
|
<tr>
|
|
<th class="tcl" scope="col"><?php echo $lang_admin_censoring['Censored word label'] ?></th>
|
|
<th class="tc2" scope="col"><?php echo $lang_admin_censoring['Replacement label'] ?></th>
|
|
<th class="hidehead" scope="col"><?php echo $lang_admin_censoring['Action label'] ?></th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
|
|
do
|
|
{
|
|
echo "\t\t\t\t\t\t\t\t".'<tr><td class="tcl"><input type="text" name="search_for['.$cur_word['id'].']" value="'.pun_htmlspecialchars($cur_word['search_for']).'" size="24" maxlength="60" /></td><td class="tc2"><input type="text" name="replace_with['.$cur_word['id'].']" value="'.pun_htmlspecialchars($cur_word['replace_with']).'" size="24" maxlength="60" /></td><td><input type="submit" name="update['.$cur_word['id'].']" value="'.$lang_admin_common['Update'].'" /> <input type="submit" name="remove['.$cur_word['id'].']" value="'.$lang_admin_common['Remove'].'" /></td></tr>'."\n";
|
|
}
|
|
while ($cur_word = $db->fetch_assoc($result))
|
|
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
<?php
|
|
|
|
}
|
|
else
|
|
echo "\t\t\t\t\t\t\t".'<p>'.$lang_admin_censoring['No words in list'].'</p>'."\n";
|
|
|
|
?>
|
|
</div>
|
|
</fieldset>
|
|
</div>
|
|
</form>
|
|
</div>
|
|
</div>
|
|
<div class="clearer"></div>
|
|
</div>
|
|
<?php
|
|
|
|
require PUN_ROOT.'footer.php';
|