PHP qi_get_available_dbms Examples

Example #1

File: qi_functions.php Project: 3D-I/quickinstall

function db_connect($db_data = '')
{
    global $phpbb_root_path, $phpEx, $sql_db, $db, $quickinstall_path, $settings;
    $db_data = empty($db_data) ? $settings->get_db_data() : $db_data;
    list($dbms, $dbhost, $dbuser, $dbpasswd, $dbport) = $db_data;
    // If we get here and the extension isn't loaded it should be safe to just go ahead and load it
    $available_dbms = qi_get_available_dbms($dbms);
    if (!isset($available_dbms[$dbms]['DRIVER'])) {
        trigger_error("The {$dbms} dbms is either not supported, or the php extension for it could not be loaded.", E_USER_ERROR);
    }
    // Instantiate the database
    if (defined('PHPBB_31')) {
        $dbal = substr($available_dbms[$dbms]['DRIVER'], strrpos($available_dbms[$dbms]['DRIVER'], '\\') + 1);
        // Load the appropriate database class if not already loaded.
        if (!class_exists('dbal_' . $dbal . '_qi')) {
            // now the quickinstall dbal extension
            include $quickinstall_path . 'includes/db/31/' . $dbal . '.' . $phpEx;
        }
        $sql_db = 'dbal_' . $dbal . '_qi';
    } else {
        // Load the appropriate database class if not already loaded.
        if (!class_exists('dbal_' . $available_dbms[$dbms]['DRIVER'] . '_qi')) {
            // phpBB dbal class.
            include $phpbb_root_path . 'includes/db/' . $available_dbms[$dbms]['DRIVER'] . '.' . $phpEx;
            // now the quickinstall dbal extension
            include $quickinstall_path . 'includes/db/' . $available_dbms[$dbms]['DRIVER'] . '.' . $phpEx;
        }
        $sql_db = 'dbal_' . $available_dbms[$dbms]['DRIVER'] . '_qi';
    }
    $db = new $sql_db();
    if (defined('PHPBB_31')) {
        $db->sql_connect($dbhost, $dbuser, $dbpasswd, $settings->get_config('dbname'), $dbport, false, false);
    } else {
        $db->sql_connect($dbhost, $dbuser, $dbpasswd, false, $dbport, false, false);
    }
    $db->sql_return_on_error(true);
    return $db;
}

Example #2

File: functions_install.php Project: 3D-I/quickinstall

/**
 * Load a schema (and execute)
 *
 * @param string $install_path
 */
function load_schema_30($install_path = '', $install_dbms = false)
{
    global $settings, $db, $table_prefix;
    static $available_dbms = false;
    if ($install_dbms === false) {
        $dbms = $settings->get_config('dbms');
        $install_dbms = $dbms;
    }
    if (!function_exists('get_available_dbms') && !defined('PHPBB_32')) {
        global $phpbb_root_path, $phpEx;
        include $phpbb_root_path . 'includes/functions_install.' . $phpEx;
    }
    if (!$available_dbms) {
        $available_dbms = qi_get_available_dbms($install_dbms);
        if ($install_dbms == 'mysql') {
            if (version_compare($db->mysql_version, '4.1.3', '>=')) {
                $available_dbms[$install_dbms]['SCHEMA'] .= '_41';
            } else {
                $available_dbms[$install_dbms]['SCHEMA'] .= '_40';
            }
        }
    }
    $remove_remarks = $available_dbms[$install_dbms]['COMMENTS'];
    $delimiter = $available_dbms[$install_dbms]['DELIM'];
    $dbms_schema = $install_path . $available_dbms[$install_dbms]['SCHEMA'] . '_schema.sql';
    if (file_exists($dbms_schema)) {
        $sql_query = @file_get_contents($dbms_schema);
        $sql_query = preg_replace('#phpbb_#i', $table_prefix, $sql_query);
        $remove_remarks($sql_query);
        $sql_query = qi_split_sql_file($sql_query, $delimiter);
        foreach ($sql_query as $sql) {
            $db->sql_query($sql);
        }
        unset($sql_query);
    }
    if (file_exists($install_path . 'schema_data.sql')) {
        $sql_query = file_get_contents($install_path . 'schema_data.sql');
        switch ($install_dbms) {
            case 'mssql':
            case 'mssql_odbc':
                $sql_query = preg_replace('#\\# MSSQL IDENTITY (phpbb_[a-z_]+) (ON|OFF) \\##s', 'SET IDENTITY_INSERT \\1 \\2;', $sql_query);
                break;
            case 'postgres':
                $sql_query = preg_replace('#\\# POSTGRES (BEGIN|COMMIT) \\##s', '\\1; ', $sql_query);
                break;
        }
        $sql_query = preg_replace('# phpbb_([^\\s]*) #i', ' ' . $table_prefix . '\\1 ', $sql_query);
        $sql_query = preg_replace_callback('#\\{L_([A-Z0-9\\-_]*)\\}#s', 'adjust_language_keys_callback', $sql_query);
        remove_remarks($sql_query);
        $sql_query = qi_split_sql_file($sql_query, ';');
        foreach ($sql_query as $sql) {
            $db->sql_query($sql);
        }
        unset($sql_query);
    }
}