function nv_add_index($table, $index_name, $column)
{
global $db;
$phpbb_db_tools = new phpbb_db_tools($db);
if ($phpbb_db_tools->sql_column_exists($table, $column)) {
$phpbb_db_tools->sql_create_index($table_name, $index_name, $column);
}
}
function main($id, $mode)
{
global $config, $db, $user, $auth, $template, $cache;
global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix, $phpbb_seo;
// Start the phpbb_seo class
if (empty($phpbb_seo)) {
include_once $phpbb_root_path . 'phpbb_seo/phpbb_seo_class.' . $phpEx;
$phpbb_seo = new phpbb_seo();
}
$user->add_lang('mods/acp_phpbb_seo');
$action = request_var('action', '');
$submit = isset($_POST['submit']) ? true : false;
$form_key = 'acp_board';
add_form_key($form_key);
$display_vars = array();
// --> Zero Dupe
if (@isset($phpbb_seo->seo_opt['zero_dupe'])) {
$this->multiple_options['zero_dupe']['post_redir_values'] = array('off' => 'off', 'post' => 'post', 'guest' => 'guest', 'all' => 'all');
// do not change
$this->multiple_options['zero_dupe']['post_redir_lang'] = array('off' => $user->lang['ACP_ZERO_DUPE_OFF'], 'post' => $user->lang['ACP_ZERO_DUPE_MSG'], 'guest' => $user->lang['ACP_ZERO_DUPE_GUEST'], 'all' => $user->lang['ACP_ZERO_DUPE_ALL']);
// do not change
}
// <-- Mod rewrite selector
if ($phpbb_seo->modrtype == 1) {
$this->seo_unset_opts = array('cache_layer', 'rem_ids');
} elseif (!$phpbb_seo->seo_opt['cache_layer']) {
$this->seo_unset_opts = array('rem_ids');
}
$this->modrtype_lang = $this->set_phpbb_seo_links();
$this->multiple_options['modrtype_lang'] = $this->modrtype_lang['titles'];
if (@isset($phpbb_seo->seo_opt['modrtype'])) {
$this->multiple_options['modrtype_values'] = array(1 => 1, 2 => 2, 3 => 3);
// do not change;
}
// <-- Mod rewrite selector
foreach ($this->seo_unset_opts as $opt) {
if ($optkey = array_search($opt, $phpbb_seo->cache_config['dynamic_options'])) {
unset($phpbb_seo->cache_config['dynamic_options'][$optkey]);
}
}
// We need shorter URLs with Virtual Folder Trick
if ($phpbb_seo->seo_opt['virtual_folder']) {
$this->lengh_limit = 20;
$this->word_limit = 3;
} else {
$this->lengh_limit = 30;
$this->word_limit = 5;
}
$related_installed = false;
switch ($mode) {
case 'settings':
$this->write_type = 'forum';
$display_vars['title'] = 'ACP_PHPBB_SEO_CLASS';
$user->lang['ACP_PHPBB_SEO_CLASS_EXPLAIN'] = sprintf($user->lang['ACP_PHPBB_SEO_CLASS_EXPLAIN'], $this->modrtype_lang['ulink'], $this->modrtype_lang['uforumlink'], '</p><hr/><p><b>' . $user->lang['ACP_PHPBB_SEO_MODE'] . ' : ' . $this->modrtype_lang['link'] . ' - ' . $phpbb_seo->version . ' ( ' . $this->modrtype_lang['forumlink'] . ' )</b></p><hr/><p>');
$display_vars['vars'] = array();
$i = 2;
$display_vars['vars']['legend1'] = 'ACP_PHPBB_SEO_CLASS';
foreach ($phpbb_seo->cache_config['dynamic_options'] as $optionname => $optionvalue) {
if (@is_bool($phpbb_seo->seo_opt[$optionvalue])) {
if ($optionvalue == 'virtual_root' && !$phpbb_seo->seo_path['phpbb_script']) {
continue;
}
$display_vars['vars'][$optionvalue] = array('lang' => $optionvalue, 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true, 'lang_explain' => $optionvalue . '_explain');
$this->new_config[$optionvalue] = $phpbb_seo->seo_opt[$optionvalue];
} elseif (@isset($this->multiple_options[$optionvalue . '_values'])) {
$this->dyn_select[$optionvalue] = $this->multiple_options[$optionvalue . '_values'];
$display_vars['vars'][$optionvalue] = array('lang' => $optionvalue, 'validate' => 'string', 'type' => 'select', 'method' => 'select_string', 'explain' => true, 'lang_explain' => $optionvalue . '_explain');
$this->new_config[$optionvalue] = $phpbb_seo->seo_opt[$optionvalue];
} elseif (is_array($optionvalue)) {
$display_vars['vars']['legend' . $i] = $optionname;
$i++;
foreach ($optionvalue as $key => $value) {
$this->array_type_cfg[$optionname . '_' . $key] = array('main' => $optionname, 'sub' => $key);
if (is_bool($value)) {
$display_vars['vars'][$optionname . '_' . $key] = array('lang' => $optionname . '_' . $key, 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true, 'lang_explain' => $optionname . '_' . $key . '_explain');
$this->new_config[$optionname . '_' . $key] = $phpbb_seo->seo_opt[$optionname][$key];
} elseif (@isset($this->multiple_options[$optionname][$key . '_values'])) {
$this->dyn_select[$optionname . '_' . $key] = $this->multiple_options[$optionname][$key . '_values'];
$display_vars['vars'][$optionname . '_' . $key] = array('lang' => $optionname . '_' . $key, 'validate' => 'string', 'type' => 'select', 'method' => 'select_string', 'explain' => true, 'lang_explain' => $optionname . '_' . $key . '_explain');
$this->new_config[$optionname . '_' . $key] = $phpbb_seo->seo_opt[$optionname][$key];
} else {
$display_vars['vars'][$optionname . '_' . $key] = array('lang' => $optionname . '_' . $key, 'validate' => 'string:0:50', 'type' => 'text:50:50', 'explain' => true, 'lang_explain' => $optionname . '_' . $key . '_explain');
$this->new_config[$optionname . '_' . $key] = $phpbb_seo->seo_opt[$optionname][$key];
}
}
}
}
break;
case 'forum_url':
// used for cache
$this->write_type = 'forum';
$forbidden = array($phpbb_seo->seo_static['forum'], $phpbb_seo->seo_static['global_announce'], $phpbb_seo->seo_static['user'], $phpbb_seo->seo_static['topic'], $phpbb_seo->seo_static['atopic'], $phpbb_seo->seo_static['utopic'], $phpbb_seo->seo_static['leaders'], $phpbb_seo->seo_static['post'], $phpbb_seo->seo_static['group'], $phpbb_seo->seo_static['npost'], $phpbb_seo->seo_static['index']);
if ($phpbb_seo->modrtype == 1 || !$phpbb_seo->seo_opt['cache_layer']) {
trigger_error($user->lang['ACP_NO_FORUM_URL'] . preg_replace('`(&|&|\\?)mode=forum_url`i', '', adm_back_link($this->u_action)));
break;
}
$display_vars['title'] = 'ACP_FORUM_URL';
$user->lang['ACP_FORUM_URL_EXPLAIN'] .= '</p><hr/><p><b>' . $user->lang['ACP_PHPBB_SEO_VERSION'] . ' : ' . $this->modrtype_lang['link'] . ' - ' . $phpbb_seo->version . ' ( ' . $this->modrtype_lang['forumlink'] . ' )</b></p><hr/><p>';
$display_vars['vars'] = array();
$display_vars['vars']['legend1'] = 'ACP_FORUM_URL';
$sql = "SELECT forum_id, forum_name\n\t\t\t\t\tFROM " . FORUMS_TABLE . "\n\t\t\t\t\tORDER BY left_id ASC";
$result = $db->sql_query($sql);
$forum_url_title = $error_cust = '';
while ($row = $db->sql_fetchrow($result)) {
$this->forum_ids[$row['forum_id']] = $row['forum_name'];
}
$db->sql_freeresult($result);
// take care of deleted forums
foreach ($phpbb_seo->cache_config['forum'] as $fid => $null) {
if (!isset($this->forum_ids[$fid])) {
unset($phpbb_seo->cache_config['forum'][$fid]);
}
}
foreach ($this->forum_ids as $forum_id => $forum_name) {
$error_cust = '';
// Is the URL cached already ?
if (empty($phpbb_seo->cache_config['forum'][$forum_id])) {
// Suggest the one from the title
$forum_url_title = $phpbb_seo->format_url($forum_name, $phpbb_seo->seo_static['forum']);
if (!in_array($forum_url_title, $forbidden)) {
if (array_search($forum_url_title, $phpbb_seo->cache_config['forum'])) {
$this->new_config['forum_url' . $forum_id] = $forum_url_title . $phpbb_seo->seo_delim['forum'] . $forum_id;
$error_cust = '<li> ' . sprintf($user->lang['SEO_ADVICE_DUPE'], $forum_url_title) . '</li>';
} else {
$this->new_config['forum_url' . $forum_id] = $forum_url_title . (@$phpbb_seo->cache_config['settings']['rem_ids'] ? '' : $phpbb_seo->seo_delim['forum'] . $forum_id);
}
} else {
$this->new_config['forum_url' . $forum_id] = $forum_url_title . $phpbb_seo->seo_delim['forum'] . $forum_id;
$error_cust = '<li> ' . sprintf($user->lang['SEO_ADVICE_RESERVED'], $forum_url_title) . '</li>';
}
$title = '<b style="color:red">' . $forum_name . ' - ID ' . $forum_id . '</b>';
$status_msg = '<b style="color:red">' . $user->lang['SEO_CACHE_URL_NOT_OK'] . '</b>';
$status_msg .= '<br/><span style="color:red">' . $user->lang['SEO_CACHE_URL'] . ' :</span> ' . $this->new_config['forum_url' . $forum_id] . $phpbb_seo->seo_ext['forum'];
$display_vars['vars']['forum_url' . $forum_id] = array('lang' => $title, 'validate' => 'string', 'type' => 'custom', 'method' => 'forum_url_input', 'explain' => true, 'lang_explain_custom' => $status_msg, 'append' => $this->seo_advices($this->new_config['forum_url' . $forum_id], $forum_id, false, $error_cust));
} else {
// Cached
$this->new_config['forum_url' . $forum_id] = $phpbb_seo->cache_config['forum'][$forum_id];
$title = '<b style="color:green">' . $forum_name . ' - ID ' . $forum_id . '</b>';
$status_msg = '<span style="color:green">' . $user->lang['SEO_CACHE_URL_OK'] . ' :</span> <b style="color:green">' . $this->new_config['forum_url' . $forum_id] . '</b>';
$status_msg .= '<br/><span style="color:green">' . $user->lang['SEO_CACHE_URL'] . ' :</span> ' . $this->new_config['forum_url' . $forum_id] . $phpbb_seo->seo_ext['forum'];
$display_vars['vars']['forum_url' . $forum_id] = array('lang' => $title, 'validate' => 'string:0:100', 'type' => 'custom', 'method' => 'forum_url_input', 'explain' => true, 'lang_explain_custom' => $status_msg, 'append' => $this->seo_advices($this->new_config['forum_url' . $forum_id], $forum_id, true));
}
}
break;
case 'htaccess':
$this->write_type = 'htaccess';
$display_vars['title'] = 'ACP_HTACCESS';
$user->lang['ACP_HTACCESS_EXPLAIN'] .= '</p><hr/><p><b>' . $user->lang['ACP_PHPBB_SEO_VERSION'] . ' : ' . $this->modrtype_lang['link'] . ' - ' . $phpbb_seo->version . ' ( ' . $this->modrtype_lang['forumlink'] . ' )</b></p><p>';
$display_vars['vars'] = array();
$display_vars['vars']['legend1'] = 'ACP_HTACCESS';
$display_vars['vars']['save'] = array('lang' => 'SEO_HTACCESS_SAVE', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true);
$display_vars['vars']['more_options'] = array('lang' => 'SEO_MORE_OPTION', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true);
$this->new_config['save'] = false;
$cfg_array = isset($_REQUEST['config']) ? utf8_normalize_nfc(request_var('config', array('' => ''), true)) : $this->new_config;
$this->new_config['more_options'] = isset($cfg_array['more_options']) ? $cfg_array['more_options'] : false;
$this->new_config['slash'] = isset($cfg_array['slash']) ? $cfg_array['slash'] : false;
$this->new_config['wslash'] = isset($cfg_array['wslash']) ? $cfg_array['wslash'] : false;
$this->new_config['rbase'] = isset($cfg_array['rbase']) ? $cfg_array['rbase'] : false;
if ($this->new_config['more_options']) {
$display_vars['vars']['slash'] = array('lang' => 'SEO_HTACCESS_SLASH', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true);
$display_vars['vars']['wslash'] = array('lang' => 'SEO_HTACCESS_WSLASH', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true);
if ($phpbb_seo->seo_path['phpbb_script'] && !$phpbb_seo->seo_opt['virtual_root']) {
$display_vars['vars']['rbase'] = array('lang' => 'SEO_HTACCESS_RBASE', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true);
}
}
// Dirty yet simple templating
$user->lang['ACP_HTACCESS_EXPLAIN'] .= $this->seo_htaccess();
break;
case 'extended':
$display_vars = array('title' => 'ACP_SEO_EXTENDED', 'vars' => array('legend1' => 'SEO_EXTERNAL_LINKS', 'seo_ext_links' => array('lang' => 'SEO_EXTERNAL_LINKS', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true, 'default' => 1), 'seo_ext_subdomain' => array('lang' => 'SEO_EXTERNAL_SUBDOMAIN', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true, 'default' => 0), 'seo_ext_classes' => array('lang' => 'SEO_EXTERNAL_CLASSES', 'validate' => 'string', 'type' => 'text:40:250', 'explain' => true, 'default' => '')));
// Related topics
if (file_exists($phpbb_root_path . "phpbb_seo/phpbb_seo_related.{$phpEx}")) {
$related_installed = true;
$user->add_lang('mods/phpbb_seo_related_install');
$display_vars['vars'] += array('legend2' => 'RELATED_TOPICS', 'seo_related' => array('lang' => 'SEO_RELATED', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true, 'append' => !empty($config['seo_related']) ? '<br/>' . (!empty($config['seo_related_fulltext']) ? $user->lang['FULLTEXT_INSTALLED'] : $user->lang['FULLTEXT_NOT_INSTALLED']) : '', 'default' => 0), 'seo_related_check_ignore' => array('lang' => 'SEO_RELATED_CHECK_IGNORE', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true, 'default' => 0), 'seo_related_limit' => array('lang' => 'SEO_RELATED_LIMIT', 'validate' => 'int:2:25', 'type' => 'text:3:4', 'explain' => true, 'default' => 5), 'seo_related_allforums' => array('lang' => 'SEO_RELATED_ALLFORUMS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true, 'default' => 0));
}
// dynamic meta tag mod
if (class_exists('seo_meta')) {
$display_vars['vars'] += array('legend3' => 'SEO_META', 'seo_meta_title' => array('lang' => 'SEO_META_TITLE', 'validate' => 'string:0:225', 'type' => 'text:40:250', 'explain' => true, 'default' => $config['sitename']), 'seo_meta_desc' => array('lang' => 'SEO_META_DESC', 'validate' => 'string:0:225', 'type' => 'text:40:250', 'explain' => true, 'default' => $config['site_desc']), 'seo_meta_desc_limit' => array('lang' => 'SEO_META_DESC_LIMIT', 'validate' => 'int:5:40', 'type' => 'text:3:4', 'explain' => true, 'default' => 25), 'seo_meta_bbcode_filter' => array('lang' => 'SEO_META_BBCODE_FILTER', 'validate' => 'string:0:225', 'type' => 'text:40:250', 'explain' => true, 'default' => 'img|url|flash|code'), 'seo_meta_keywords' => array('lang' => 'SEO_META_KEYWORDS', 'validate' => 'string:0:225', 'type' => 'text:40:250', 'explain' => true, 'default' => $config['site_desc']), 'seo_meta_keywords_limit' => array('lang' => 'SEO_META_KEYWORDS_LIMIT', 'validate' => 'int:5:40', 'type' => 'text:3:4', 'explain' => true, 'default' => 15), 'seo_meta_min_len' => array('lang' => 'SEO_META_MIN_LEN', 'validate' => 'int:0:10', 'type' => 'text:3:4', 'explain' => true, 'default' => 2), 'seo_meta_check_ignore' => array('lang' => 'SEO_META_CHECK_IGNORE', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true, 'default' => 0), 'seo_meta_lang' => array('lang' => 'SEO_META_LANG', 'validate' => 'lang', 'type' => 'select', 'method' => 'language_select', 'params' => array('{CONFIG_VALUE}'), 'explain' => true, 'default' => $config['default_lang']), 'seo_meta_copy' => array('lang' => 'SEO_META_COPY', 'validate' => 'string:0:225', 'type' => 'text:40:250', 'explain' => true, 'default' => $config['sitename']), 'seo_meta_file_filter' => array('lang' => 'SEO_META_FILE_FILTER', 'validate' => 'string:0:225', 'type' => 'text:40:250', 'explain' => true, 'default' => 'ucp'), 'seo_meta_get_filter' => array('lang' => 'SEO_META_GET_FILTER', 'validate' => 'string:0:225', 'type' => 'text:40:250', 'explain' => true, 'default' => 'style,hilit,sid'), 'seo_meta_robots' => array('lang' => 'SEO_META_ROBOTS', 'validate' => 'string:0:225', 'type' => 'text:25:150', 'explain' => true, 'default' => 'index,follow'), 'seo_meta_noarchive' => array('lang' => 'SEO_META_NOARCHIVE', 'validate' => 'string:0:225', 'multiple_validate' => 'int', 'type' => 'custom', 'method' => 'select_multiple', 'params' => array('{CONFIG_VALUE}', '{KEY}', $this->forum_select()), 'explain' => true, 'default' => ''));
}
// Optimal title
if (isset($user->lang['Page'])) {
$display_vars['vars'] += array('legend4' => 'SEO_PAGE_TITLES', 'seo_append_sitename' => array('lang' => 'SEO_APPEND_SITENAME', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true, 'default' => 0));
}
// install if necessary
foreach ($display_vars['vars'] as $config_name => $config_setup) {
if (strpos($config_name, 'legend') !== false) {
continue;
}
if (!isset($config[$config_name])) {
set_config($config_name, $config_setup['default']);
unset($display_vars['vars'][$config_name]['default']);
}
}
$this->new_config = $config;
break;
default:
trigger_error('NO_MODE', E_USER_ERROR);
break;
}
$error = array();
$seo_msg = array();
$cfg_array = isset($_REQUEST['config']) ? utf8_normalize_nfc(request_var('config', array('' => ''), true)) : $this->new_config;
if ($submit && !check_form_key($form_key)) {
$error[] = $user->lang['FORM_INVALID'];
}
// We validate the complete config if whished
validate_config_vars($display_vars['vars'], $cfg_array, $error);
// Do not write values if there is an error
if (!empty($error)) {
$submit = false;
}
$additional_notes = '';
// We go through the display_vars to make sure no one is trying to set variables he/she is not allowed to...
foreach ($display_vars['vars'] as $config_name => $cfg_setup) {
if (!isset($cfg_array[$config_name]) && @$cfg_setup['method'] != 'select_multiple' || strpos($config_name, 'legend') !== false) {
continue;
}
// Handle multiple select options
if (!empty($cfg_setup['method']) && $cfg_setup['method'] == 'select_multiple') {
if (isset($_POST['multiple_' . $config_name])) {
$m_values = utf8_normalize_nfc(request_var('multiple_' . $config_name, array('' => '')));
$validate_int = !empty($cfg_setup['multiple_validate']) && $cfg_setup['multiple_validate'] == 'int' ? true : false;
foreach ($m_values as $k => $v) {
if ($validate_int) {
$v = max(0, (int) $v);
}
if (empty($v)) {
unset($m_values[$k]);
} else {
$m_values[$k] = $v;
}
}
sort($m_values);
$this->new_config[$config_name] = $m_values;
$config_value = implode(',', $m_values);
if (strlen($config_value) > 255) {
$error[] = sprintf($user->lang['SETTING_TOO_LONG'], $user->lang[$cfg_setup['lang']], 255);
}
$submit = empty($error);
} else {
if ($submit) {
$this->new_config[$config_name] = array();
$config_value = '';
} else {
$config_value = $this->new_config[$config_name];
$this->new_config[$config_name] = !empty($config_value) ? explode(',', $config_value) : array();
}
}
} else {
$this->new_config[$config_name] = $config_value = $cfg_array[$config_name];
}
if ($submit) {
// In case we deal with forum URLs
if ($mode == 'forum_url' && preg_match('`^forum_url([0-9]+)$`', $config_name, $matches)) {
// Check if this is an actual forum_id
if (isset($this->forum_ids[$matches[1]])) {
$forum_id = intval($matches[1]);
$config_value = $phpbb_seo->format_url($config_value, $phpbb_seo->seo_static['forum']);
// Remove delim if required
while (preg_match('`^[a-z0-9_-]+' . $phpbb_seo->seo_delim['forum'] . '[0-9]+$`i', $config_value)) {
$config_value = preg_replace('`^([a-z0-9_-]+)' . $phpbb_seo->seo_delim['forum'] . '[0-9]+$`i', '\\1', $config_value);
if (@$phpbb_seo->cache_config['settings']['rem_ids']) {
$seo_msg['SEO_ADVICE_DELIM_REM'] = '<li> ' . $user->lang['SEO_ADVICE_DELIM_REM'] . '</li>';
}
}
// Forums cannot end with the pagination param
while (preg_match('`^[a-z0-9_-]+' . $phpbb_seo->seo_delim['start'] . '[0-9]+$`i', $config_value)) {
$config_value = preg_replace('`^([a-z0-9_-]+)' . $phpbb_seo->seo_delim['start'] . '[0-9]+$`i', "\\1", $config_value);
$seo_msg['SEO_ADVICE_START'] = '<li> ' . $user->lang['SEO_ADVICE_START'] . '</li>';
}
// Only update if the value is not a static one for forums
if (!in_array($config_value, $forbidden)) {
// and updated (sic)
if ($config_value != @$phpbb_seo->cache_config['forum'][$forum_id]) {
// and if not already set
if (!array_search($config_value, $phpbb_seo->cache_config['forum'])) {
$phpbb_seo->cache_config['forum'][$forum_id] = $config_value . (@$phpbb_seo->cache_config['settings']['rem_ids'] ? '' : $phpbb_seo->seo_delim['forum'] . $forum_id);
} else {
$seo_msg['SEO_ADVICE_DUPE_' . $forum_id] = '<li> ' . sprintf($user->lang['SEO_ADVICE_DUPE'], $config_value) . '</li>';
}
}
} else {
$seo_msg['SEO_ADVICE_RESERVED_' . $forum_id] = '<li> ' . sprintf($user->lang['SEO_ADVICE_RESERVED'], $config_value) . '</li>';
}
}
} elseif ($mode == 'settings') {
if (isset($this->array_type_cfg[$config_name]) && isset($phpbb_seo->seo_opt[$this->array_type_cfg[$config_name]['main']][$this->array_type_cfg[$config_name]['sub']])) {
if (is_bool($phpbb_seo->seo_opt[$this->array_type_cfg[$config_name]['main']][$this->array_type_cfg[$config_name]['sub']])) {
$phpbb_seo->cache_config['settings'][$this->array_type_cfg[$config_name]['main']][$this->array_type_cfg[$config_name]['sub']] = $config_value == 1 ? true : false;
} elseif (is_numeric($phpbb_seo->seo_opt[$this->array_type_cfg[$config_name]['main']][$this->array_type_cfg[$config_name]['sub']])) {
$phpbb_seo->cache_config['settings'][$this->array_type_cfg[$config_name]['main']][$this->array_type_cfg[$config_name]['sub']] = intval($config_value);
} elseif (is_string($phpbb_seo->seo_opt[$this->array_type_cfg[$config_name]['main']][$this->array_type_cfg[$config_name]['sub']])) {
$phpbb_seo->cache_config['settings'][$this->array_type_cfg[$config_name]['main']][$this->array_type_cfg[$config_name]['sub']] = $config_value;
}
} elseif (isset($phpbb_seo->seo_opt[$config_name])) {
if (is_bool($phpbb_seo->seo_opt[$config_name])) {
$phpbb_seo->cache_config['settings'][$config_name] = $config_value == 1 ? true : false;
} elseif (is_numeric($phpbb_seo->seo_opt[$config_name])) {
$phpbb_seo->cache_config['settings'][$config_name] = intval($config_value);
} elseif (is_string($phpbb_seo->seo_opt[$config_name])) {
$phpbb_seo->cache_config['settings'][$config_name] = $config_value;
}
}
// Let's make sure that the proper field was added to the topic table
if ($config_name === 'sql_rewrite' && $config_value == 1 && !$phpbb_seo->seo_opt['sql_rewrite']) {
if (!class_exists('phpbb_db_tools')) {
require $phpbb_root_path . 'includes/db/db_tools.' . $phpEx;
}
$db_tools = new phpbb_db_tools($db);
$db_tools->db->sql_return_on_error(true);
if (!$db_tools->sql_column_exists(TOPICS_TABLE, 'topic_url')) {
$db_tools->sql_column_add(TOPICS_TABLE, 'topic_url', array('VCHAR', ''));
}
$additional_notes = sprintf($user->lang['SYNC_TOPIC_URL_NOTE'], '<a href="' . $phpbb_seo->seo_path['phpbb_url'] . 'phpbb_seo/sync_url.' . $phpEx . '" onclick="window.open(this.href); return false;">', '</a>');
if ($db_tools->db->sql_error_triggered) {
$error[] = '<b>' . $user->lang['sql_rewrite'] . '</b> : ' . $user->lang['SEO_SQL_ERROR'] . ' [ ' . $db_tools->db->sql_layer . ' ] : ' . $db_tools->db->sql_error_returned['message'] . ' [' . $db_tools->db->sql_error_returned['code'] . ']' . '<br/>' . $user->lang['SEO_SQL_TRY_MANUALLY'] . '<br/>' . $db_tools->db->sql_error_sql;
$submit = false;
}
$db_tools->db->sql_return_on_error(false);
}
// Let's make sure the proper index is added for the no dupe (in case it is installed and activated)
if ($config_name === 'no_dupe_on' && $config_value == 1 && !$phpbb_seo->seo_opt['no_dupe']['on']) {
if (!class_exists('phpbb_db_tools')) {
require $phpbb_root_path . 'includes/db/db_tools.' . $phpEx;
}
// in case we already started the phpbb_db_tools class above
if (empty($db_tools)) {
$db_tools = new phpbb_db_tools($db);
}
$db_tools->db->sql_return_on_error(true);
$indexes = $db_tools->sql_list_index(TOPICS_TABLE);
$drop_index_name = 'topic_last_post_id';
$add_index_name = 'topic_lpid';
if (in_array($drop_index_name, $indexes)) {
$db_tools->sql_index_drop(TOPICS_TABLE, $drop_index_name);
}
if (!in_array($add_index_name, $indexes)) {
// Try to override some limits - maybe it helps some...
@set_time_limit(0);
@ini_set('memory_limit', '128M');
$db_tools->sql_create_index(TOPICS_TABLE, $add_index_name, array('topic_last_post_id'));
}
if ($db_tools->db->sql_error_triggered) {
$error[] = '<b>' . $user->lang['no_dupe'] . '</b> : ' . $user->lang['SEO_SQL_ERROR'] . ' [ ' . $db_tools->db->sql_layer . ' ] : ' . $db_tools->db->sql_error_returned['message'] . ' [' . $db_tools->db->sql_error_returned['code'] . ']' . '<br/>' . $user->lang['SEO_SQL_TRY_MANUALLY'] . '<br/>' . $db_tools->db->sql_error_sql;
$submit = false;
}
$db_tools->db->sql_return_on_error(false);
}
} elseif ($mode == 'extended') {
if ($related_installed && $config_name === 'seo_related') {
$fulltext = 0;
$nothing_to_do = false;
if ($db->sql_layer == 'mysql4' || $db->sql_layer == 'mysqli') {
$add = $remove = $alter = false;
if ($config_value && !$config['seo_related']) {
$alter = $add = true;
}
if (!$config_value && $config['seo_related']) {
$alter = $remove = true;
}
// let's go
if ($alter) {
// Try to override some limits - maybe it helps some...
@set_time_limit(0);
@ini_set('memory_limit', '128M');
// use db_tools to check the index
if (!class_exists('phpbb_db_tools')) {
require $phpbb_root_path . 'includes/db/db_tools.' . $phpEx;
}
if (empty($db_tools)) {
$db_tools = new phpbb_db_tools($db);
}
$indexes = $db_tools->sql_list_index(TOPICS_TABLE);
if (in_array('topic_tft', $indexes)) {
$nothing_to_do = $add ? true : false;
$fulltext = 1;
} else {
$nothing_to_do = $remove ? true : false;
$fulltext = 0;
}
// do not use db_tools since it does not support to add FullText indexes
if (!$nothing_to_do) {
// Here we use quite a basic approach to make sure that the index is not refused for bad reasons
if ($add) {
$sql = 'ALTER TABLE ' . TOPICS_TABLE . '
ADD FULLTEXT topic_tft (topic_title)';
} else {
$sql = 'ALTER TABLE ' . TOPICS_TABLE . '
DROP INDEX topic_tft';
}
$db->sql_return_on_error(true);
$db->sql_query($sql);
if ($db->sql_error_triggered) {
$error[] = '<b>' . $user->lang['RELATED_TOPICS'] . '</b> : ' . $user->lang['SEO_SQL_ERROR'] . ' [ ' . $db->sql_layer . ' ] : ' . $db->sql_error_returned['message'] . ' [' . $db->sql_error_returned['code'] . ']' . '<br/>' . $user->lang['SEO_SQL_TRY_MANUALLY'] . '<br/>' . $db->sql_error_sql;
$submit = false;
$config_value = 0;
}
// make *sure* about the index !
$indexes = $db_tools->sql_list_index(TOPICS_TABLE);
$fulltext = in_array('topic_tft', $indexes) ? 1 : 0;
$db->sql_return_on_error(false);
}
}
}
if ($alter) {
set_config('seo_related_fulltext', $fulltext);
}
}
set_config($config_name, $config_value);
}
}
}
if (sizeof($error)) {
$submit = false;
}
if ($submit) {
if ($mode == 'htaccess') {
if ($this->new_config['save']) {
$this->write_cache($this->write_type);
add_log('admin', 'SEO_LOG_CONFIG_' . strtoupper($mode));
}
} elseif ($mode == 'extended') {
add_log('admin', 'SEO_LOG_CONFIG_' . strtoupper($mode));
trigger_error($user->lang['CONFIG_UPDATED'] . adm_back_link($this->u_action));
} else {
if ($this->write_cache($this->write_type)) {
ksort($phpbb_seo->cache_config[$this->write_type]);
add_log('admin', 'SEO_LOG_CONFIG_' . strtoupper($mode));
$msg = !empty($seo_msg) ? '<br /><h1 style="color:red;text-align:left;">' . $user->lang['SEO_VALIDATE_INFO'] . '</h1><ul style="text-align:left;">' . implode(' ', $seo_msg) . '</ul><br />' : '';
global $msg_long_text;
$msg_long_text = $user->lang['SEO_CACHE_MSG_OK'] . $msg . adm_back_link($this->u_action);
if ($additional_notes) {
$msg_long_text .= "<br/><br/>{$additional_notes}";
}
trigger_error(false);
} else {
trigger_error($user->lang['SEO_CACHE_MSG_FAIL'] . adm_back_link($this->u_action));
}
}
}
$this->tpl_name = 'acp_board';
$this->page_title = $display_vars['title'];
$phpbb_seo->seo_end();
$l_title_explain = $user->lang[$display_vars['title'] . '_EXPLAIN'];
if ($mode != 'extended') {
$l_title_explain .= $mode == 'htaccess' ? '' : $this->check_cache_folder($phpbb_root_path . $phpbb_seo->seo_opt['cache_folder']);
}
$template->assign_vars(array('L_TITLE' => $user->lang[$display_vars['title']], 'L_TITLE_EXPLAIN' => $l_title_explain, 'S_ERROR' => sizeof($error) ? true : false, 'ERROR_MSG' => implode('<br />', $error), 'U_ACTION' => $this->u_action));
// Output relevant page
foreach ($display_vars['vars'] as $config_key => $vars) {
if (!is_array($vars) && strpos($config_key, 'legend') === false) {
continue;
}
if (strpos($config_key, 'legend') !== false) {
$template->assign_block_vars('options', array('S_LEGEND' => true, 'LEGEND' => isset($user->lang[$vars]) ? $user->lang[$vars] : $vars));
continue;
}
$type = explode(':', $vars['type']);
$l_explain = '';
if ($vars['explain'] && isset($vars['lang_explain'])) {
$l_explain = isset($user->lang[$vars['lang_explain']]) ? $user->lang[$vars['lang_explain']] : $vars['lang_explain'];
} elseif ($vars['explain'] && isset($vars['lang_explain_custom'])) {
$l_explain = $vars['lang_explain_custom'];
} elseif ($vars['explain']) {
$l_explain = isset($user->lang[$vars['lang'] . '_EXPLAIN']) ? $user->lang[$vars['lang'] . '_EXPLAIN'] : '';
}
$template->assign_block_vars('options', array('KEY' => $config_key, 'TITLE' => isset($user->lang[$vars['lang']]) ? $user->lang[$vars['lang']] : $vars['lang'], 'S_EXPLAIN' => $vars['explain'], 'TITLE_EXPLAIN' => $l_explain, 'CONTENT' => build_cfg_template($type, $config_key, $this->new_config, $config_key, $vars)));
unset($display_vars['vars'][$config_key]);
}
}
/**
* Sends an email to the board administrator with their password and some useful links
*/
function final_stage($mode, $sub)
{
global $auth, $config, $db, $user, $template, $user, $phpbb_root_path, $phpEx, $phpbb_seo, $cache;
if (!sizeof($this->errors)) {
add_log('admin', 'SEO_LOG_' . strtoupper($mode), $phpbb_seo->version);
} else {
add_log('admin', 'SEO_LOG_' . strtoupper($mode) . '_FAIL', $this->errors);
$cache->purge();
$this->p_master->error($user->lang['SEO_ERROR_INSTALL'] . '<br/><pre>' . implode('<br/>', $this->errors) . '</pre>', __LINE__, __FILE__);
}
$this->page_title = $user->lang['STAGE_FINAL'];
if (!class_exists('phpbb_db_tools')) {
include $phpbb_root_path . 'includes/db/db_tools.' . $phpEx;
}
$db_tools = new phpbb_db_tools($db);
$indexes = $db_tools->sql_list_index(TOPICS_TABLE);
$drop_index_name = 'topic_last_post_id';
$add_index_name = 'topic_lpid';
if ($mode == 'install_phpbb_seo') {
if (!$db_tools->sql_column_exists(TOPICS_TABLE, 'topic_url')) {
$db_tools->sql_column_add(TOPICS_TABLE, 'topic_url', array('VCHAR', ''));
}
if (in_array($drop_index_name, $indexes)) {
$db_tools->sql_index_drop(TOPICS_TABLE, $drop_index_name);
}
if (!in_array($add_index_name, $indexes)) {
$db_tools->sql_create_index(TOPICS_TABLE, $add_index_name, array('topic_last_post_id'));
}
$submit_action = append_sid($phpbb_root_path . 'adm/index.' . $phpEx . '?sid=' . $user->session_id);
$title = $user->lang['SEO_INSTALL_CONGRATS'];
$body = sprintf($user->lang['SEO_INSTALL_CONGRATS_EXPLAIN'], $this->modrtype_lang['ulink'], $phpbb_seo->version);
} else {
$purge_topic_table = false;
if ($purge_topic_table) {
if ($db_tools->sql_column_exists(TOPICS_TABLE, 'topic_url')) {
$db_tools->sql_column_remove(TOPICS_TABLE, 'topic_url');
}
}
if (in_array($drop_index_name, $indexes)) {
$db_tools->sql_index_drop(TOPICS_TABLE, $drop_index_name);
}
if (in_array($add_index_name, $indexes)) {
$db_tools->sql_index_drop(TOPICS_TABLE, $add_index_name);
}
$submit_action = append_sid($phpbb_root_path . 'index.' . $phpEx);
$title = $user->lang['UN_SEO_INSTALL_CONGRATS'];
$body = sprintf($user->lang['UN_SEO_INSTALL_CONGRATS_EXPLAIN'], $this->modrtype_lang['ulink'], $phpbb_seo->version);
}
$cache->purge();
$template->assign_vars(array('TITLE' => $title, 'BODY' => $body, 'L_SUBMIT' => $user->lang['SEO_FINAL_' . strtoupper($mode)], 'U_ACTION' => $submit_action));
}
