* @license GNU General Public License, version 2 (GPL-2.0)
*
* For full copyright and license information, please see
* the docs/CREDITS.txt file.
*
*/
/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
exit;
}
/**
* @todo [words] check regular expressions for special char replacements (stored specialchared in db)
*/
class acp_words
{
var $u_action;
function main($id, $mode)
{
global $db, $user, $auth, $template, $cache, $phpbb_log, $request, $phpbb_container;
global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;
$user->add_lang('acp/posting');
// Set up general vars
$action = $request->variable('action', '');
$action = (isset($_POST['add'])) ? 'add' : ((isset($_POST['save'])) ? 'save' : $action);
$s_hidden_fields = '';
$word_info = array();
$this->tpl_name = 'acp_words';
$this->page_title = 'ACP_WORDS';
$form_name = 'acp_words';
add_form_key($form_name);
switch ($action)
{
case 'edit':
$word_id = $request->variable('id', 0);
if (!$word_id)
{
trigger_error($user->lang['NO_WORD'] . adm_back_link($this->u_action), E_USER_WARNING);
}
$sql = 'SELECT *
FROM ' . WORDS_TABLE . "
WHERE word_id = $word_id";
$result = $db->sql_query($sql);
$word_info = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$s_hidden_fields .= '';
case 'add':
$template->assign_vars(array(
'S_EDIT_WORD' => true,
'U_ACTION' => $this->u_action,
'U_BACK' => $this->u_action,
'WORD' => (isset($word_info['word'])) ? $word_info['word'] : '',
'REPLACEMENT' => (isset($word_info['replacement'])) ? $word_info['replacement'] : '',
'S_HIDDEN_FIELDS' => $s_hidden_fields)
);
return;
break;
case 'save':
if (!check_form_key($form_name))
{
trigger_error($user->lang['FORM_INVALID']. adm_back_link($this->u_action), E_USER_WARNING);
}
$word_id = $request->variable('id', 0);
$word = $request->variable('word', '', true);
$replacement = $request->variable('replacement', '', true);
if ($word === '' || $replacement === '')
{
trigger_error($user->lang['ENTER_WORD'] . adm_back_link($this->u_action), E_USER_WARNING);
}
// Replace multiple consecutive asterisks with single one as those are not needed
$word = preg_replace('#\*{2,}#', '*', $word);
$sql_ary = array(
'word' => $word,
'replacement' => $replacement
);
if ($word_id)
{
$db->sql_query('UPDATE ' . WORDS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' WHERE word_id = ' . $word_id);
}
else
{
$db->sql_query('INSERT INTO ' . WORDS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));
}
$cache->destroy('_word_censors');
$phpbb_container->get('text_formatter.cache')->invalidate();
$log_action = ($word_id) ? 'LOG_WORD_EDIT' : 'LOG_WORD_ADD';
$phpbb_log->add('admin', $user->data['user_id'], $user->ip, $log_action, false, array($word));
$message = ($word_id) ? $user->lang['WORD_UPDATED'] : $user->lang['WORD_ADDED'];
trigger_error($message . adm_back_link($this->u_action));
break;
case 'delete':
$word_id = $request->variable('id', 0);
if (!$word_id)
{
trigger_error($user->lang['NO_WORD'] . adm_back_link($this->u_action), E_USER_WARNING);
}
if (confirm_box(true))
{
$sql = 'SELECT word
FROM ' . WORDS_TABLE . "
WHERE word_id = $word_id";
$result = $db->sql_query($sql);
$deleted_word = $db->sql_fetchfield('word');
$db->sql_freeresult($result);
$sql = 'DELETE FROM ' . WORDS_TABLE . "
WHERE word_id = $word_id";
$db->sql_query($sql);
$cache->destroy('_word_censors');
$phpbb_container->get('text_formatter.cache')->invalidate();
$phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_WORD_DELETE', false, array($deleted_word));
trigger_error($user->lang['WORD_REMOVED'] . adm_back_link($this->u_action));
}
else
{
confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(
'i' => $id,
'mode' => $mode,
'id' => $word_id,
'action' => 'delete',
)));
}
break;
}
$template->assign_vars(array(
'U_ACTION' => $this->u_action,
'S_HIDDEN_FIELDS' => $s_hidden_fields)
);
$sql = 'SELECT *
FROM ' . WORDS_TABLE . '
ORDER BY word';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('words', array(
'WORD' => $row['word'],
'REPLACEMENT' => $row['replacement'],
'U_EDIT' => $this->u_action . '&action=edit&id=' . $row['word_id'],
'U_DELETE' => $this->u_action . '&action=delete&id=' . $row['word_id'])
);
}
$db->sql_freeresult($result);
}
}
ۀZ_vھ☏daJr-Z2e>k㳚tthvrdf|X}-
gI]Kz$Xzf#H~BQL4O>,h=l-ݳfmtV n(b>&m=[MQYx'l\s
.dd{Kkn2qLϠRi1ԓsI%N_J
ԟ,ݙ pu.5h0=:DEBLtFf{VgwwN݀;xǀc\h~@oI"lϘoK a9GԲco܋<W٥WdB& І o^Tf3m~"?#KMVh^J-B>h}/О\|j4Wy_ @~nRgM]3>97}qY.Y^C_L@W!Ƀ=(@M]4Ս RM#䍩ҜTC|0NN늧dx/G~}#.T*X*9<')/Ty&8ȝvodFY\bAPaޒa?QPJ|"0pIr2@N$iTGhb:\gT,D:!-J
T4d.یf<; ;'1H!`#2 Y#|!rV2%"rȘG1 `|fH̙!ZnĜ e8ZS0` IALzGq9P@c}2p ;+xMp}_\xұ_B3bNewS枿 3
M1[K첓ٰb%43-J(hД?BLddY!@:!
ɤ3+4%`<(bB[f X,HN?!TbX,oJh3a4'4HlpF̀ۜWv ##&xET%ImKW<;CEO (:
q
ap᪅
/2TЕ*F tTAhY3yHH`#8Em
Ʌ~[s?_^V;N{>ߟ<*e#"&b9oL$ ,ƽ<) XAU>QaC U68{ik+uAc!b>A@`11x&ɟӉ<"4&THd7|d'I2\(ω4B?#FU p;qګ[bЋHdB<vtI ƔpFV*CCOema_E$dR8ZmϳVgY(hI/8D[oW0k:_Cן4<,x: x'$ *sqz g߅Z Ny5pDhC늹3]2p ZPSy*p<|ߚIZmlߊ݆~Q-53uZ~T~eX@x1?;c:bQ2Ϛbx /#;E\z_8ѵ#kҘ?y%DžRmͩ/'qlN!4#!ȇO8VCџ@L|]F//z>m6FXO˸H:+tյlw1㷺M`I0fϨ.}B;%@}XeP#jR}?Y^Xx?^