Ejemplo n.º 1
0
 /**
  * Initializes a new install
  *
  * @return  boolean    true/false
  */
 public function install()
 {
     $connection = Doctrine_Manager::getInstance()->getCurrentConnection();
     define('IN_PHPBB', true);
     global $table_prefix;
     $table_prefix = 'phpbb_';
     $this->setVar('table_prefix', $table_prefix);
     // check for existing tables like phpbb*
     // str_replace is because _ is wildcard character, as %
     $stmt = $connection->prepare("SHOW TABLES LIKE '" . str_replace('_', '\\_', $table_prefix) . "%'");
     $stmt->execute();
     $tablesexist = $stmt->fetchAll(Doctrine_Core::FETCH_NUM);
     if ($tablesexist) {
         $message = '';
         foreach ($tablesexist as $table) {
             $message .= $table[0] . '<br />';
         }
         return LogUtil::registerError('Similar table exist:<br />' . $message);
     }
     // create tables
     $phpbb_root_path = 'modules/ZphpBB2/vendor/phpBB2/';
     include_once $phpbb_root_path . 'extension.inc';
     include_once $phpbb_root_path . 'includes/functions.php';
     $language = getPNlanguage();
     if (!file_exists($phpbb_root_path . 'language/lang_' . $language . '/lang_pnphpbb2_admin.php')) {
         $language = "english";
     }
     include_once $phpbb_root_path . 'language/lang_' . $language . '/lang_pnphpbb2_admin.php';
     include_once $phpbb_root_path . 'language/lang_' . $language . '/lang_main.php';
     include_once $phpbb_root_path . 'language/lang_' . $language . '/lang_admin.php';
     include_once $phpbb_root_path . 'install/includes/functions_install.php';
     // determine if module have been installed
     $stmt = $connection->prepare("SHOW TABLES LIKE '" . $table_prefix . "users" . "'");
     $stmt->execute();
     $test_installed = $stmt->fetchAll(Doctrine_Core::FETCH_ASSOC);
     if (!$test_installed) {
         // INSTALL MODULE
         global $remove_remarks, $delimiter, $db, $errored, $error_ary;
         error_reporting(E_ERROR | E_WARNING | E_PARSE);
         // This will NOT report uninitialized variables
         $error = false;
         // Include some required functions
         include $phpbb_root_path . 'includes/constants.php';
         // Define schema info
         $available_dbms = array('mysql' => array('LABEL' => 'MySQL 3.x', 'SCHEMA' => 'mysql', 'DELIM' => ';', 'DELIM_BASIC' => ';', 'COMMENTS' => 'remove_remarks'), 'mysql4' => array('LABEL' => 'MySQL 4.x/5.x', 'SCHEMA' => 'mysql', 'DELIM' => ';', 'DELIM_BASIC' => ';', 'COMMENTS' => 'remove_remarks'), 'postgres' => array('LABEL' => 'PostgreSQL 7.x', 'SCHEMA' => 'postgres', 'DELIM' => ';', 'DELIM_BASIC' => ';', 'COMMENTS' => 'remove_comments'), 'mssql' => array('LABEL' => 'MS SQL Server 7/2000', 'SCHEMA' => 'mssql', 'DELIM' => 'GO', 'DELIM_BASIC' => ';', 'COMMENTS' => 'remove_comments'), 'msaccess' => array('LABEL' => 'MS Access [ ODBC ]', 'SCHEMA' => '', 'DELIM' => '', 'DELIM_BASIC' => ';', 'COMMENTS' => ''), 'mssql-odbc' => array('LABEL' => 'MS SQL Server [ ODBC ]', 'SCHEMA' => 'mssql', 'DELIM' => 'GO', 'DELIM_BASIC' => ';', 'COMMENTS' => 'remove_comments'));
         $dbms = $GLOBALS['ZConfig']['DBInfo']['databases']['default']['dbdriver'];
         $dbhost = $GLOBALS['ZConfig']['DBInfo']['databases']['default']['host'];
         $dbuser = $GLOBALS['ZConfig']['DBInfo']['databases']['default']['user'];
         $dbpasswd = $GLOBALS['ZConfig']['DBInfo']['databases']['default']['password'];
         $dbname = $GLOBALS['ZConfig']['DBInfo']['databases']['default']['dbname'];
         $server_port = '80';
         if (isset($dbms)) {
             switch ($dbms) {
                 case 'msaccess':
                 case 'mssql-odbc':
                     $check_exts = 'odbc';
                     $check_other = 'odbc';
                     break;
                 case 'mssql':
                     $check_exts = 'mssql';
                     $check_other = 'sybase';
                     break;
                 case 'mysql':
                 case 'mysql4':
                     $check_exts = 'mysql';
                     $check_other = 'mysql';
                     break;
                 case 'postgres':
                     $check_exts = 'pgsql';
                     $check_other = 'pgsql';
                     break;
             }
             if (!extension_loaded($check_exts) && !extension_loaded($check_other)) {
                 LogUtil::registerError($lang['Install_No_Ext']);
                 return false;
             }
             include $phpbb_root_path . 'includes/db.php';
         }
         $dbms_schema = $phpbb_root_path . 'install/schemas/' . $available_dbms[$dbms]['SCHEMA'] . '_schema.sql';
         $dbms_basic = $phpbb_root_path . 'install/schemas/' . $available_dbms[$dbms]['SCHEMA'] . '_basic.sql';
         $dbms_attach_schema = $phpbb_root_path . 'install/schemas/attach_' . $available_dbms[$dbms]['SCHEMA'] . '_schema.sql';
         $dbms_attach_basic = $phpbb_root_path . 'install/schemas/attach_' . $available_dbms[$dbms]['SCHEMA'] . '_basic.sql';
         //$dbms_pnphpbb2_schema = $phpbb_root_path . 'install/schemas/pnphpbb2_' . $available_dbms[$dbms]['SCHEMA'] . '_schema.sql';
         $dbms_pnphpbb2_basic = $phpbb_root_path . 'install/schemas/pnphpbb2_' . $available_dbms[$dbms]['SCHEMA'] . '_basic.sql';
         $remove_remarks = $available_dbms[$dbms]['COMMENTS'];
         $delimiter = $available_dbms[$dbms]['DELIM'];
         $delimiter_basic = $available_dbms[$dbms]['DELIM_BASIC'];
         $error_ary = array();
         $errored = FALSE;
         if ($dbms != 'msaccess') {
             // Load in the sql parser
             include $phpbb_root_path . 'includes/sql_parse.php';
             // Ok we have the db info go ahead and read in the relevant schema
             // and work on building the table.. probably ought to provide some
             // kind of feedback to the user as we are working here in order
             // to let them know we are actually doing something.
             $sql_query = @fread(@fopen($dbms_schema, 'r'), @filesize($dbms_schema));
             // Ok now lest do the same for the attachment mod schema
             $sql_query .= @fread(@fopen($dbms_attach_schema, 'r'), @filesize($dbms_attach_schema));
             // $sql_query .= @fread(@fopen($dbms_pnphpbb2_schema, 'r'), @filesize($dbms_pnphpbb2_schema));
             $result = evaluate_statement($sql_query, 'Installing tables', false, true);
             // Ok tables have been built, let's fill in the basic information
             $sql_query = @fread(@fopen($dbms_basic, 'r'), @filesize($dbms_basic));
             // Ok tables have been built, let's fill in the basic information for the attachment mod
             $sql_query .= @fread(@fopen($dbms_attach_basic, 'r'), @filesize($dbms_attach_basic));
             // Ok tables have been built, let's fill in the basic information for ZphpBB2
             $sql_query .= @fread(@fopen($dbms_pnphpbb2_basic, 'r'), @filesize($dbms_pnphpbb2_basic));
             $result = evaluate_statement($sql_query, $lang['Populate_DB_PNphpBB'], false, true);
         }
         $sql_query = '';
         // Update the default admin user with their information.
         $sql_query .= "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('board_startdate', " . time() . ");";
         $sql_query .= "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('default_lang', '" . str_replace("\\'", "''", $language) . "');";
         $update_config = array('board_email' => System::getVar('adminmail'), 'script_path' => $phpbb_root_path, 'server_port' => $server_port, 'server_name' => $_SERVER['HTTP_HOST']);
         while (list($config_name, $config_value) = each($update_config)) {
             $sql_query .= "UPDATE " . $table_prefix . "config SET config_value = '{$config_value}' WHERE config_name = '{$config_name}';";
         }
         $admin_name = UserUtil::getVar('uname');
         // Obtain PN user password
         $sql = "SELECT pass FROM users WHERE uid='2'";
         if (!($result = $db->sql_query($sql))) {
             message_die(CRITICAL_ERROR, 'Could not obtain PN user table', '', __LINE__, __FILE__, $sql);
         }
         list($admin_pass_md5) = $db->sql_fetchrow($result);
         $sql_query .= "UPDATE " . $table_prefix . "users SET username = '******'", "''", $admin_name) . "', user_password='******'", "''", $admin_pass_md5) . "', user_lang = '" . str_replace("\\'", "''", $language) . "', user_email='" . str_replace("\\'", "''", System::getVar('adminmail')) . "' WHERE username = '******';";
         $sql_query .= "UPDATE " . $table_prefix . "users SET user_regdate = " . time() . ";";
         $result = evaluate_statement($sql_query, $lang['Populate_DB_Admin'], false, false);
         if ($errored) {
             LogUtil::registerError("Error! Installing some tables failed.");
             for ($i = 0; $i < count($error_ary['sql']); $i++) {
                 LogUtil::registerError("<li>Error :: <b>" . $error_ary['error_code'][$i]['message'] . "</b><br />");
                 LogUtil::registerError("SQL &nbsp; :: <b>" . $error_ary['sql'][$i] . "</b><br /></li>");
             }
         }
     }
     // module variables
     $this->setVar('page_title', 'Forum');
     $this->setVar('page_description', 'Place for discussions and support');
     $this->setVar('page_robots', 'noindex, nofollow, noarchive');
     // Register hooks
     HookUtil::registerSubscriberBundles($this->version->getHookSubscriberBundles());
     // Register event handlers
     EventUtil::registerPersistentModuleHandler('ZphpBB2', 'user.account.create', array('ZphpBB2_Listener_UsersSynch', 'createAccountListener'));
     EventUtil::registerPersistentModuleHandler('ZphpBB2', 'user.account.update', array('ZphpBB2_Listener_UsersSynch', 'updateAccountListener'));
     EventUtil::registerPersistentModuleHandler('ZphpBB2', 'user.account.delete', array('ZphpBB2_Listener_UsersSynch', 'deleteAccountListener'));
     return true;
 }
Ejemplo n.º 2
0
} else {
    include $phpbb_root_path . 'includes/template.' . $phpEx;
}
$board_config['default_dateformat'] = '%d.%m.%Y %H:%M';
$board_config['server_name'] = System::getBaseUrl();
// ZphpBB2 commented
//$modinfo = ModUtil::getInfoFromName("ZphpBB2");
//$board_config['module_url'] = "index.php?module=" . $modinfo['url'] . "&file=";
$board_config['sitename'] = System::getVar('sitename');
$board_config['site_desc'] = System::getVar('slogan');
$board_config['require_activation'] = 0;
// $board_config['gzip_compress'] = System::getVar('UseCompression');
$board_config['gzip_compress'] = 0;
$board_config['allow_namechange'] = 0;
$board_config['cookie_secure'] = 0;
$board_config['default_lang'] = getPNlanguage();
$board_config['board_timezone'] = System::getVar('timezone_offset') - 12;
$board_config['board_email'] = System::getVar('adminmail');
$fullpage = SessionUtil::getVar('fullpage');
if ($fullpage === false) {
    SessionUtil::setVar('fullpage', $board_config['pnphpbb2_full_page']);
}
$subforum = SessionUtil::getVar('subforum');
//if ($subforum === false)
if (!$subforum) {
    SessionUtil::setVar('subforum', $board_config['pnphpbb2_sub_forum']);
}
$board_config['avatar_gallery_path'] = $board_config['avatar_gallery_path'];
// ZphpBB2 - path is from site root now, removed prefix $phpbb_root_path
$board_config['avatar_path'] = $board_config['avatar_path'];
// ZphpBB2 - path is from site root now, removed prefix $phpbb_root_path