diff options
Diffstat (limited to 'phpBB/phpbb_seo/phpbb_seo_install.php')
| -rw-r--r-- | phpBB/phpbb_seo/phpbb_seo_install.php | 776 |
1 files changed, 0 insertions, 776 deletions
diff --git a/phpBB/phpbb_seo/phpbb_seo_install.php b/phpBB/phpbb_seo/phpbb_seo_install.php deleted file mode 100644 index 5654f97b59..0000000000 --- a/phpBB/phpbb_seo/phpbb_seo_install.php +++ /dev/null @@ -1,776 +0,0 @@ -<?php -/** -* -* @package Ultimate SEO URL phpBB SEO -* @version $Id: phpbb_seo_install.php 222 2010-02-27 13:08:48Z dcz $ -* @copyright (c) 2006 - 2010 www.phpbb-seo.com -* @license http://www.opensource.org/licenses/rpl1.5.txt Reciprocal Public License 1.5 -* -*/ -/* - * Based on the phpBB3 install package / www.phpBB.com - */ -define('IN_PHPBB', true); -define('IN_INSTALL', true); -$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './../'; -$phpEx = substr(strrchr(__FILE__, '.'), 1); -// Try to override some limits - maybe it helps some... -@set_time_limit(0); -$mem_limit = @ini_get('memory_limit'); -if (!empty($mem_limit)) { - $unit = strtolower(substr($mem_limit, -1, 1)); - $mem_limit = (int) $mem_limit; - if ($unit == 'k') { - $mem_limit = floor($mem_limit / 1024); - } else if ($unit == 'g') { - $mem_limit *= 1024; - } else if (is_numeric($unit)) { - $mem_limit = floor((int) ($mem_limit . $unit) / 1048576); - } - $mem_limit = max(128, $mem_limit) . 'M'; -} else { - $mem_limit = '128M'; -} -@ini_set('memory_limit', $mem_limit); -include($phpbb_root_path . 'common.' . $phpEx); -// Include essential scripts -require($phpbb_root_path . 'includes/functions_install.' . $phpEx); -// Start session management -$user->session_begin(); -$auth->acl($user->data); -$user->setup('mods/acp_phpbb_seo'); -// Security check -// Circumvent a potential phpbb bug with paths -$redirect = append_sid(generate_board_url() . "/phpbb_seo/phpbb_seo_install.$phpEx"); -if (!$user->data['is_registered']) { - login_box($redirect, $user->lang['SEO_LOGIN'],'', false, false); -} -if (!$auth->acl_get('a_')) { - $user->session_kill(true); - login_box($redirect, $user->lang['SEO_LOGIN_ADMIN'],'', false, false); -} -if ($user->data['user_type'] != USER_FOUNDER) { - login_box($redirect, $user->lang['SEO_LOGIN_FOUNDER'],'', false, false); -} -$user->add_lang(array('acp/common', 'acp/board', 'install', 'posting', 'acp/modules')); -$mode = request_var('mode', 'overview'); -$sub = request_var('sub', ''); -// Set some standard variables we want to force -$config['load_tplcompile'] = '1'; -$template->set_custom_template('../adm/style', '../admin'); -$template->assign_var('T_TEMPLATE_PATH', '../adm/style'); -// the acp template is never stored in the database -$user->theme['template_storedb'] = false; -// Start the installer -$install = new module(); -$install->create('install', "phpbb_seo_install.$phpEx", $mode, $sub); -$install->load(); -// Generate the page -$install->page_header(); -$install->generate_navigation(); -$template->set_filenames(array( - 'body' => $install->get_tpl_name()) -); -$install->page_footer(); -/** -* @package install -*/ -class module { - var $id = 0; - var $type = 'install'; - var $module_ary = array(); - var $filename; - var $module_url = ''; - var $tpl_name = ''; - var $mode; - var $sub; - /** - * Private methods, should not be overwritten - */ - function create($module_type, $module_url, $selected_mod = false, $selected_submod = false) { - global $db, $config, $phpEx, $phpbb_root_path, $user; - $module = array( - array( - 'module_type' => 'install', - 'module_title' => 'OVERVIEW', - 'module_filename' => 'overview_phpbb_seo', - 'module_order' => 0, - 'module_subs' => array('INTRO', 'LICENSE', 'SUPPORT'), - 'module_stages' => '', - 'module_reqs' => '' - ), - array( - 'module_type' => 'install', - 'module_title' => 'INSTALL_PHPBB_SEO', - 'module_filename' => 'install_phpbb_seo', - 'module_order' => 1, - 'module_subs' => '', - 'module_stages' => array('INTRO', 'FINAL'), - 'module_reqs' => '' - ), - array( - 'module_type' => 'uninstall', - 'module_title' => 'UNINSTALL_PHPBB_SEO', - 'module_filename' => 'install_phpbb_seo', - 'module_order' => 2, - 'module_subs' => '', - 'module_stages' => array('INTRO', 'FINAL'), - 'module_reqs' => '' - ), - ); - // Order to use and count further if modules get assigned to the same position or not having an order - $max_module_order = 1000; - foreach ($module as $row) { - // Module order not specified or module already assigned at this position? - if (!isset($row['module_order']) || isset($this->module_ary[$row['module_order']])) { - $row['module_order'] = $max_module_order; - $max_module_order++; - } - $this->module_ary[$row['module_order']]['name'] = $row['module_title']; - $this->module_ary[$row['module_order']]['filename'] = $row['module_filename']; - $this->module_ary[$row['module_order']]['subs'] = $row['module_subs']; - $this->module_ary[$row['module_order']]['stages'] = $row['module_stages']; - if (strtolower($selected_mod) == strtolower($row['module_title'])) { - $this->id = (int) $row['module_order']; - $this->filename = (string) $row['module_filename']; - $this->module_url = (string) $module_url; - $this->mode = (string) $selected_mod; - // Check that the sub-mode specified is valid or set a default if not - if (is_array($row['module_subs'])) { - $this->sub = strtolower((in_array(strtoupper($selected_submod), $row['module_subs'])) ? $selected_submod : $row['module_subs'][0]); - } else if (is_array($row['module_stages'])) { - $this->sub = strtolower((in_array(strtoupper($selected_submod), $row['module_stages'])) ? $selected_submod : $row['module_stages'][0]); - } else { - $this->sub = ''; - } - } - } // END foreach - } // END create - /** - * Load and run the relevant module if applicable - */ - function load($mode = false, $run = true) { - global $phpbb_root_path, $phpEx; - if ($run) { - if (!empty($mode)) { - $this->mode = $mode; - } - $module = $this->filename; - if (!class_exists($module)) { - $this->error('Module "' . htmlspecialchars($module) . '" not accessible.', __LINE__, __FILE__); - } - $this->module = new $module($this); - if (method_exists($this->module, 'main')) { - $this->module->main($this->mode, $this->sub); - } - } - } - /** - * Output the standard page header - */ - function page_header() { - if (defined('HEADER_INC')) { - return; - } - define('HEADER_INC', true); - global $template, $user, $stage, $phpbb_root_path; - $template->assign_vars(array( - 'L_INSTALL_PANEL' => $user->lang['SEO_INSTALL_PANEL'], - 'L_SKIP' => $user->lang['SKIP'], - 'PAGE_TITLE' => $this->get_page_title(), - 'T_IMAGE_PATH' => $phpbb_root_path . 'adm/images/', - 'S_CONTENT_DIRECTION' => $user->lang['DIRECTION'], - 'S_CONTENT_ENCODING' => 'UTF-8', - 'S_USER_LANG' => $user->lang['USER_LANG'], - ) - ); - header('Content-type: text/html; charset=UTF-8'); - header('Cache-Control: private, no-cache="set-cookie"'); - header('Expires: 0'); - header('Pragma: no-cache'); - return; - } - /** - * Output the standard page footer - */ - function page_footer() { - global $db, $template, $phpbb_seo; - $template->display('body'); - // Close our DB connection. - if (!empty($db) && is_object($db)) { - $db->sql_close(); - } - exit; - } - /** - * Returns desired template name - */ - function get_tpl_name() { - return $this->module->tpl_name . '.html'; - } - /** - * Returns the desired page title - */ - function get_page_title() { - global $user; - if (!isset($this->module->page_title)) { - return ''; - } - return (isset($user->lang[$this->module->page_title])) ? $user->lang[$this->module->page_title] : $this->module->page_title; - } - /** - * Generate an HTTP/1.1 header to redirect the user to another page - * This is used during the installation when we do not have a database available to call the normal redirect function - * @param string $page The page to redirect to relative to the installer root path - */ - function redirect($page) { - $server_name = (!empty($_SERVER['SERVER_NAME'])) ? $_SERVER['SERVER_NAME'] : getenv('SERVER_NAME'); - $server_port = (!empty($_SERVER['SERVER_PORT'])) ? (int) $_SERVER['SERVER_PORT'] : (int) getenv('SERVER_PORT'); - $secure = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') ? 1 : 0; - - $script_name = (!empty($_SERVER['PHP_SELF'])) ? $_SERVER['PHP_SELF'] : getenv('PHP_SELF'); - if (!$script_name) { - $script_name = (!empty($_SERVER['REQUEST_URI'])) ? $_SERVER['REQUEST_URI'] : getenv('REQUEST_URI'); - } - // Replace backslashes and doubled slashes (could happen on some proxy setups) - $script_name = str_replace(array('\\', '//'), '/', $script_name); - $script_path = trim(dirname($script_name)); - $url = (($secure) ? 'https://' : 'http://') . $server_name; - if ($server_port && (($secure && $server_port <> 443) || (!$secure && $server_port <> 80))) { - $url .= ':' . $server_port; - } - $url .= $script_path . '/' . $page; - header('Location: ' . $url); - exit; - } - /** - * Generate the navigation tabs - */ - function generate_navigation() { - global $user, $template, $phpEx; - if (is_array($this->module_ary)) { - @ksort($this->module_ary); - foreach ($this->module_ary as $cat_ary) { - $cat = $cat_ary['name']; - $l_cat = (!empty($user->lang['CAT_' . $cat])) ? $user->lang['CAT_' . $cat] : preg_replace('#_#', ' ', $cat); - $cat = strtolower($cat); - $url = $this->module_url . "?mode=$cat"; - if ($this->mode == $cat) { - $template->assign_block_vars('t_block1', array( - 'L_TITLE' => $l_cat, - 'S_SELECTED' => true, - 'U_TITLE' => $url, - )); - if (is_array($this->module_ary[$this->id]['subs'])) { - $subs = $this->module_ary[$this->id]['subs']; - foreach ($subs as $option) { - $l_option = (!empty($user->lang['SUB_' . $option])) ? $user->lang['SUB_' . $option] : preg_replace('#_#', ' ', $option); - $option = strtolower($option); - $url = $this->module_url . '?mode=' . $this->mode . "&sub=$option"; - $template->assign_block_vars('l_block1', array( - 'L_TITLE' => $l_option, - 'S_SELECTED' => ($this->sub == $option), - 'U_TITLE' => $url, - )); - } - } - if (is_array($this->module_ary[$this->id]['stages'])) { - $subs = $this->module_ary[$this->id]['stages']; - $matched = false; - foreach ($subs as $option) { - $l_option = (!empty($user->lang['STAGE_' . $option])) ? $user->lang['STAGE_' . $option] : preg_replace('#_#', ' ', $option); - $option = strtolower($option); - $matched = ($this->sub == $option) ? true : $matched; - - $template->assign_block_vars('l_block2', array( - 'L_TITLE' => $l_option, - 'S_SELECTED' => ($this->sub == $option), - 'S_COMPLETE' => !$matched, - )); - } - } - } else { - $template->assign_block_vars('t_block1', array( - 'L_TITLE' => $l_cat, - 'S_SELECTED' => false, - 'U_TITLE' => $url, - )); - } - } - } - } - /** - * Output an error message - * If skip is true, return and continue execution, else exit - */ - function error($error, $line = '', $file = '', $skip = false, $title = '') { - global $user, $db, $template, $phpbb_seo; - $title = !empty($title) ? $title : $user->lang['INST_ERR_FATAL']; - $file = !empty($file) ? basename($file) . ' [ ' . $line . ' ]' : ''; - if ($skip) { - $template->assign_block_vars('checks', array( - 'S_LEGEND' => true, - 'LEGEND' => $user->lang['INST_ERR'], - )); - $template->assign_block_vars('checks', array( - 'TITLE' => basename($file) . ' [ ' . $line . ' ]', - 'RESULT' => '<b style="color:red">' . $error . '</b>', - )); - return; - } - echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">'; - echo '<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr">'; - echo '<head>'; - echo '<meta http-equiv="content-type" content="text/html; charset=utf-8" />'; - echo '<title>' . $title . '</title>'; - echo '<link href="../adm/style/admin.css" rel="stylesheet" type="text/css" media="screen" />'; - echo '</head>'; - echo '<body id="errorpage">'; - echo '<div id="wrap">'; - echo ' <div id="page-header">'; - echo ' </div>'; - echo ' <div id="page-body">'; - echo ' <div id="acp">'; - echo ' <div class="panel">'; - echo ' <span class="corners-top"><span></span></span>'; - echo ' <div id="content">'; - echo ' <h1>' . $title . '</h1>'; - echo ' <p>' . $file . '</p>' . "\n"; - echo ' <p><b>' . $error . "</b></p>\n"; - echo ' </div>'; - echo ' <span class="corners-bottom"><span></span></span>'; - echo ' </div>'; - echo ' </div>'; - echo ' </div>'; - echo ' <div id="page-footer">'; - echo ' Powered by phpBB © 2000, 2002, 2005, 2007 <a href="http://www.phpbb.com/">phpBB Group</a>'; - echo $phpbb_seo->seo_end(true); - echo ' </div>'; - echo '</div>'; - echo '</body>'; - echo '</html>'; - if (!empty($db) && is_object($db)) { - $db->sql_close(); - } - exit; - } - /** - * Output an error message for a database related problem - * If skip is true, return and continue execution, else exit - */ - function db_error($error, $sql, $line, $file, $skip = false) { - global $user, $db, $template; - if ($skip) { - $template->assign_block_vars('checks', array( - 'S_LEGEND' => true, - 'LEGEND' => $user->lang['INST_ERR_FATAL'], - )); - $template->assign_block_vars('checks', array( - 'TITLE' => basename($file) . ' [ ' . $line . ' ]', - 'RESULT' => '<b style="color:red">' . $error . '</b><br />» SQL:' . $sql, - )); - return; - } - $template->set_filenames(array( - 'body' => 'install_error.html') - ); - $this->page_header(); - $this->generate_navigation(); - $template->assign_vars(array( - 'MESSAGE_TITLE' => $user->lang['INST_ERR_FATAL_DB'], - 'MESSAGE_TEXT' => '<p>' . basename($file) . ' [ ' . $line . ' ]</p><p>SQL : ' . $sql . '</p><p><b>' . $error . '</b></p>', - )); - // Rollback if in transaction - if ($db->transaction) { - $db->sql_transaction('rollback'); - } - $this->page_footer(); - } -} -/** -* Installation Tabs -*/ -class install_phpbb_seo extends module { - var $errors = array(); - var $uninst_prefix = ''; - var $modrtype_lang = array(); - function install_phpbb_seo(&$p_master) { - global $user, $phpbb_seo, $config; - $this->modrtype_lang = set_phpbb_seo_links(); - $this->p_master = &$p_master; - } - function main($mode, $sub) { - global $user, $template, $phpbb_root_path, $phpbb_seo; - $this->uninst_prefix = $mode == 'install_phpbb_seo' ? '' : 'UN_'; - switch ($sub) { - case 'intro': - $this->page_title = $user->lang['SUB_INTRO']; - $template->assign_vars(array( - 'TITLE' => $user->lang[$this->uninst_prefix . 'SEO_INSTALL_INTRO'], - 'BODY' => sprintf($user->lang[$this->uninst_prefix . 'SEO_INSTALL_INTRO_BODY'], $this->modrtype_lang['ulink'], $phpbb_seo->version), - 'L_SUBMIT' => $user->lang[$this->uninst_prefix . 'SEO_INSTALL'], - 'S_LANG_SELECT' => '', - 'U_ACTION' => $this->p_master->module_url . "?mode=$mode&sub=final", - )); - break; - case 'final': - if ($mode == 'install_phpbb_seo') { - $this->add_modules($mode, $sub); - } else { - $this->remove_modules($mode, $sub); - } - $this->final_stage($mode, $sub); - break; - } - $this->tpl_name = 'install_install'; - } - /** - * Populate the module tables - */ - function add_modules($mode, $sub) { - global $db, $user, $phpbb_root_path, $phpEx; - include_once($phpbb_root_path . 'includes/acp/acp_modules.' . $phpEx); - $_module = new acp_modules(); - if ( $this->get_module_id('ACP_MOD_REWRITE') > 0 ) { - $url_mod = !empty($sub) ? '?mode=' . $mode : ''; - $this->p_master->error(sprintf($user->lang['SEO_ERROR_INSTALLED'], $user->lang['ACP_CAT_PHPBB_SEO'] ) . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $this->p_master->module_url . $url_mod . '">', '</a>'), '', '', false, $user->lang['SEO_ERROR_INFO']); - } - $module_classes = array('acp'); - // Add categories - foreach ($module_classes as $module_class) { - $categories = array(); - // Set the module class - $_module->module_class = $module_class; - foreach ($this->module_categories[$module_class] as $cat_name => $subs) { - $module_data = array( - 'module_basename' => '', - 'module_enabled' => 1, - 'module_display' => 1, - 'parent_id' => 0, - 'module_class' => $module_class, - 'module_langname' => $cat_name, - 'module_mode' => '', - 'module_auth' => '', - ); - if ( $this->get_module_id('ACP_CAT_PHPBB_SEO') < 1 ) { - // Add category - $_module->update_module_data($module_data, true); - } else { - $module_data['module_id'] = $this->check_module_id('ACP_CAT_PHPBB_SEO'); - } - // Check for last sql error happened - if ($db->sql_error_triggered) { - $error = $db->sql_error($db->sql_error_sql); - $this->p_master->db_error($error['message'], $db->sql_error_sql, __LINE__, __FILE__); - } - $categories[$cat_name]['id'] = (int) $module_data['module_id']; - $categories[$cat_name]['parent_id'] = 0; - // Create sub-categories... - if (is_array($subs)) { - foreach ($subs as $level2_name) { - $module_data = array( - 'module_basename' => '', - 'module_enabled' => 1, - 'module_display' => 1, - 'parent_id' => (int) $categories[$cat_name]['id'], - 'module_class' => $module_class, - 'module_langname' => $level2_name, - 'module_mode' => '', - 'module_auth' => '', - ); - $_module->update_module_data($module_data, true); - // Check for last sql error happened - if ($db->sql_error_triggered) { - $error = $db->sql_error($db->sql_error_sql); - $this->p_master->db_error($error['message'], $db->sql_error_sql, __LINE__, __FILE__); - } - $categories[$level2_name]['id'] = (int) $module_data['module_id']; - $categories[$level2_name]['parent_id'] = (int) $categories[$cat_name]['id']; - } - } - } - // Get the modules we want to add... returned sorted by name - $module_info = $_module->get_module_infos('phpbb_seo', $module_class); - foreach ($module_info as $module_basename => $fileinfo) { - foreach ($fileinfo['modes'] as $module_mode => $row) { - foreach ($row['cat'] as $cat_name) { - if (!isset($categories[$cat_name])) { - continue; - } - $module_data = array( - 'module_basename' => $module_basename, - 'module_enabled' => 1, - 'module_display' => (isset($row['display'])) ? (int) $row['display'] : 1, - 'parent_id' => (int) $categories[$cat_name]['id'], - 'module_class' => $module_class, - 'module_langname' => $row['title'], - 'module_mode' => $module_mode, - 'module_auth' => $row['auth'], - ); - $_module->update_module_data($module_data, true); - // Check for last sql error happened - if ($db->sql_error_triggered) { - $error = $db->sql_error($db->sql_error_sql); - $this->p_master->db_error($error['message'], $db->sql_error_sql, __LINE__, __FILE__); - } - } - } - } - $_module->remove_cache_file(); - } - } - /** - * remove_modules - */ - function remove_modules($mode, $sub) { - global $db, $user, $phpbb_root_path, $phpEx; - include_once($phpbb_root_path . 'includes/acp/acp_modules.' . $phpEx); - $_module = new acp_modules(); - // Set the module class - $module_classes = array_keys($this->module_categories); - $_module->u_action = "phpbb_seo_install.$phpEx"; - $cat_module_data = array(); - $module_data = array(); - $delete_module_data = array(); - foreach ($module_classes as $module_class) { - $_module->module_class = $module_class; - foreach ($this->module_categories[$module_class] as $cat_name => $subs) { - // If the cat is already uninstalled break for now - if ( $this->get_module_id($cat_name) < 1 ) { - $url_mod = !empty($this->sub) ? '?mode=' . $this->mode : ''; - $this->p_master->error(sprintf($user->lang['SEO_ERROR_UNINSTALLED'], $user->lang[$cat_name] ). '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $this->p_master->module_url . $url_mod . '">', '</a>'), '', '', false, $user->lang['SEO_ERROR_INFO']); - } - $cat_module_data[$cat_name] = array( - 'module_id' => $this->check_module_id($cat_name, ''), - 'module_basename' => '', - 'module_enabled' => 1, - 'module_display' => 1, - 'parent_id' => 0, - 'module_class' => $module_class, - 'module_langname' => $cat_name, - 'module_mode' => '', - 'module_auth' => '', - ); - if (is_array($subs)) { - foreach ($subs as $sub_cat) { - $sub_cat_module_data[$sub_cat] = array( - 'module_id' => $this->check_module_id($sub_cat), - 'module_basename' => '', - 'module_enabled' => 1, - 'module_display' => 1, - 'parent_id' => (int) $cat_module_data[$cat_name]['module_id'], - 'module_class' => $module_class, - 'module_langname' => $sub_cat, - 'module_mode' => '', - 'module_auth' => '', - ); - $branch = $_module->get_module_branch($sub_cat_module_data[$sub_cat]['module_id'],'children', 'descending', false); - if (sizeof($branch)) { - foreach ($branch as $module) { - $error = $_module->delete_module($module['module_id']); - if (!sizeof($error)) { - $_module->remove_cache_file(); - $delete_module_data[$module['module_id']] = $module['module_langname'] . ' - id : ' . $module['module_id']; - } else { - $this->errors[] = implode(' ', $error); - } - } // End modules - } - if (!sizeof($this->errors)) { - $error = $_module->delete_module($sub_cat_module_data[$sub_cat]['module_id']); - if (!sizeof($error)) { - $_module->remove_cache_file(); - $delete_module_data[$sub_cat_module_data[$sub_cat]['module_id']] = $sub_cat_module_data[$sub_cat]['module_langname'] . ' - id : ' . $sub_cat_module_data[$sub_cat]['module_id']; - } else { - $this->errors[] = implode(' ', $error); - } - } - } - } // End sub categories - if (!sizeof($this->errors)) { - $branch = $_module->get_module_branch($cat_module_data[$cat_name]['module_id'],'children', 'descending', false); - if (empty($branch)) { - $error = $_module->delete_module($cat_module_data[$cat_name]['module_id']); - } - if (!sizeof($error)) { - $_module->remove_cache_file(); - $delete_module_data[$cat_module_data[$cat_name]['module_id']] = $cat_module_data[$cat_name]['module_langname'] . ' - id : ' . $cat_module_data[$cat_name]['module_id']; - } else { - $this->errors[] = implode(' ', $error); - } - } - } // End categories - } // End classes - return; - } - /** - * check_module_id by title - */ - function check_module_id($title) { - global $user; - if ( $module_id = $this->get_module_id($title)) { - return $module_id; - } else { - $url_mod = !empty($this->sub) ? '?mode=' . $this->mode : ''; - $this->p_master->error(sprintf($user->lang['SEO_ERROR_ID'], $title ) . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $this->p_master->module_url . $url_mod . '">', '</a>'), '', '', false, $user->lang['SEO_ERROR_INFO']); - } - } - /** - * get_module_id by title - */ - function get_module_id($title) { - global $db, $user, $phpEx; - $sql = 'SELECT module_id - FROM ' . MODULES_TABLE . " - WHERE module_langname = '" . $db->sql_escape($title) . "'"; - $result = $db->sql_query_limit($sql, 1); - $row = $db->sql_fetchrow($result); - if ($row['module_id'] > 1) { - return intval($row['module_id']); - } - return 0; - } - /** - * 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, - )); - } - var $module_categories = array( - 'acp' => array( - 'ACP_CAT_PHPBB_SEO' => array( - 'ACP_MOD_REWRITE', - ), - ), - ); -} -function set_phpbb_seo_links() { - global $user, $phpbb_seo, $config; - $modrtype_lang = array(); - $phpbb_seo->version = htmlspecialchars($phpbb_seo->version); - $phpbb_seo->modrtype = intval($phpbb_seo->modrtype); - if ($phpbb_seo->modrtype < 1 || $phpbb_seo->modrtype > 3) { - $phpbb_seo->modrtype = 1; - } - $modrtype_lang['titles'] = array( 1 => $user->lang['ACP_SEO_SIMPLE'], 2 => $user->lang['ACP_SEO_MIXED'], 3 => $user->lang['ACP_SEO_ADVANCED'], 'u' => $user->lang['ACP_ULTIMATE_SEO_URL']); - $modrtype_lang['title'] = $modrtype_lang['titles'][$phpbb_seo->modrtype]; - $modrtype_lang['utitle'] = $modrtype_lang['titles']['u']; - $modrtype_lang['types'] = array( 1 => 'SIMPLE', 2 => 'MIXED', 1 => 'SIMPLE', 3 => 'ADVANCED'); - $modrtype_lang['type'] = $modrtype_lang['types'][$phpbb_seo->modrtype]; - $modrtype_lang['modrlinks_en'] = array( 1 => 'http://www.phpbb-seo.com/en/simple-seo-url/simple-phpbb-seo-url-t1566.html', 2 => 'http://www.phpbb-seo.com/en/mixed-seo-url/mixed-phpbb-seo-url-t1565.html', 3 => 'http://www.phpbb-seo.com/en/advanced-seo-url/advanced-phpbb-seo-url-t1219.html', 'u' => 'http://www.phpbb-seo.com/en/phpbb-mod-rewrite/ultimate-seo-url-t4608.html' ); - $modrtype_lang['modrlinks_fr'] = array( 1 => 'http://www.phpbb-seo.com/fr/reecriture-url-simple/seo-url-phpbb-simple-t1945.html', 2 => 'http://www.phpbb-seo.com/fr/reecriture-url-intermediaire/seo-url-intermediaire-t1946.html', 3 => 'http://www.phpbb-seo.com/fr/reecriture-url-avancee/seo-url-phpbb-avance-t1501.html', 'u' => 'http://www.phpbb-seo.com/fr/mod-rewrite-phpbb/ultimate-seo-url-t4489.html' ); - $modrtype_lang['modrforumlinks_en'] = array( 1 => 'http://www.phpbb-seo.com/en/simple-seo-url/', 2 => 'http://www.phpbb-seo.com/en/mixed-seo-url/', 3 => 'http://www.phpbb-seo.com/en/advanced-seo-url/', 'u' => 'http://www.phpbb-seo.com/en/phpbb-mod-rewrite/' ); - $modrtype_lang['modrforumlinks_fr'] = array( 1 => 'http://www.phpbb-seo.com/fr/reecriture-url-simple/', 2 => 'http://www.phpbb-seo.com/fr/reecriture-url-intermediaire/', 3 => 'http://www.phpbb-seo.com/fr/reecriture-url-avancee/', 'u' => 'http://www.phpbb-seo.com/fr/mod-rewrite-phpbb/' ); - if (strpos($config['default_lang'], 'fr') !== false ) { - $modrtype_lang['linkurl'] = $modrtype_lang['modrlinks_fr'][$phpbb_seo->modrtype]; - $modrtype_lang['forumlinkurl'] = $modrtype_lang['modrforumlinks_fr'][$phpbb_seo->modrtype]; - $modrtype_lang['ulinkurl'] = $modrtype_lang['modrlinks_fr']['u']; - $modrtype_lang['uforumlinkurl'] = $modrtype_lang['modrforumlinks_fr']['u']; - } else { - $modrtype_lang['linkurl'] = $modrtype_lang['modrlinks_en'][$phpbb_seo->modrtype]; - $modrtype_lang['forumlinkurl'] = $modrtype_lang['modrforumlinks_en'][$phpbb_seo->modrtype]; - $modrtype_lang['ulinkurl'] = $modrtype_lang['modrlinks_en']['u']; - $modrtype_lang['uforumlinkurl'] = $modrtype_lang['modrforumlinks_en']['u']; - } - $modrtype_lang['link'] = '<a href="' . $modrtype_lang['linkurl'] . '" title="' . $user->lang['ACP_PHPBB_SEO_VERSION'] . ' ' . $modrtype_lang['title'] . '" onclick="window.open(this.href); return false;"><b>' . $modrtype_lang['title'] . '</b></a>'; - $modrtype_lang['forumlink'] = '<a href="' . $modrtype_lang['forumlinkurl'] . '" title="' . $user->lang['ACP_SEO_SUPPORT_FORUM'] . '" onclick="window.open(this.href); return false;"><b>' . $user->lang['ACP_SEO_SUPPORT_FORUM'] . '</b></a>'; - $modrtype_lang['ulink'] = '<a href="' . $modrtype_lang['ulinkurl'] . '" title="' . $user->lang['ACP_PHPBB_SEO_VERSION'] . ' ' . $modrtype_lang['utitle'] . '" onclick="window.open(this.href); return false;"><b>' . $modrtype_lang['utitle'] . '</b></a>'; - $modrtype_lang['uforumlink'] = '<a href="' . $modrtype_lang['uforumlinkurl'] . '" title="' . $user->lang['ACP_SEO_SUPPORT_FORUM'] . '" onclick="window.open(this.href); return false;"><b>' . $user->lang['ACP_SEO_SUPPORT_FORUM'] . '</b></a>'; - return $modrtype_lang; -} -/** -* Main Tab - Overview -*/ -class overview_phpbb_seo extends module { - var $modrtype_lang = array(); - function overview_phpbb_seo(&$p_master) { - $this->modrtype_lang = set_phpbb_seo_links(); - $this->p_master = &$p_master; - } - function main($mode, $sub) { - global $lang, $template, $language, $user, $phpbb_seo; - switch ($sub) { - case 'intro' : - $title = $user->lang['SEO_OVERVIEW_TITLE']; - $body = sprintf($user->lang['SEO_OVERVIEW_BODY'], $this->modrtype_lang['ulink'], $phpbb_seo->version, $this->modrtype_lang['ulinkurl']); - break; - case 'license' : - $title = $user->lang['SEO_LICENCE_TITLE']; - $body = '<p>' . $user->lang['SEO_LICENCE_BODY'] . '</p><br/><hr/>' . implode("<br/>\n", file('./docs/COPYING')); - break; - case 'support' : - $title = $user->lang['SEO_SUPPORT_TITLE']; - $body = sprintf($user->lang['SEO_SUPPORT_BODY'],$this->modrtype_lang['uforumlinkurl'], $this->modrtype_lang['utitle'], $this->modrtype_lang['ulinkurl'] ); - break; - } - $this->tpl_name = 'install_main'; - $this->page_title = $title; - $template->assign_vars(array( - 'TITLE' => $title, - 'BODY' => $body, - - 'S_LANG_SELECT' => '', - )); - } -} -/** -* Quick fix for using the module class outside ACP. -*/ -function adm_back_link($u_action) { - global $user, $install; - $url_mod = !empty($install->sub) ? '?mode=' . $install->mode : ''; - return '<br /><br /><a href="' . $install->module_url . $url_mod . '">« ' . $user->lang['BACK_TO_PREV'] . '</a>'; -} -?>
\ No newline at end of file |