Перекодировка БД (IPB)

         //-----------------------------------------
         // Connect
         //-----------------------------------------
         
        if ( $this->obj['persistent'] AND ! IPS_MAIN_DB_CLASS_LEGACY )
        {
            $this->connection_id = @mysql_pconnect( $this->obj['sql_host'] ,
                                                   $this->obj['sql_user'] ,
                                                   $this->obj['sql_pass'] ,
                                                   $this->obj['force_new_connection']
                                                );
        }
        else
        { 
            if ( IPS_MAIN_DB_CLASS_LEGACY )
            {
                $this->connection_id = @mysql_connect( $this->obj['sql_host'] ,
                                                      $this->obj['sql_user'] ,
                                                      $this->obj['sql_pass']
                                                    );
            }
            else
            {
                $this->connection_id = @mysql_connect( $this->obj['sql_host'] ,
                                                      $this->obj['sql_user'] ,
                                                      $this->obj['sql_pass'] ,
                                                      $this->obj['force_new_connection']
                                                    );
            }
        }
        mysql_query('SET NAMES utf8', $this->connection_id); // Добавить строку.

    /**
     * constructor(string $dsn)
     * Connect to MySQL.
     */
    function DbSimple_Mysql($dsn)
    {
        $p = DbSimple_Generic::parseDSN($dsn);
        if (!is_callable('mysql_connect')) {
            return $this->_setLastError("-1", "MySQL extension is not loaded", "mysql_connect");
        }
        $ok = $this->link = @mysql_connect(
            $p['host'] . (empty($p['port'])? "" : ":".$p['port']),
            $p['user'],
            $p['pass'],
            true
        );
        $this->_resetLastError();
        if (!$ok) return $this->_setDbError('mysql_connect()');
        mysql_query('SET NAMES utf8', $this->link); // Добавить строку.
        $ok = @mysql_select_db(preg_replace('{^/}s', '', $p['path']), $this->link);
        if (!$ok) return $this->_setDbError('mysql_select_db()');
    }

    /**
     * Подключение к дб
     *
     */
    public function connect()
    {
        $this->id = mysql_connect($this->hostname,$this->username,$this->password);
        if( !$this->id )
        {
            @elfchat_error('noconnect');
        }
        if(!mysql_select_db($this->dbname, $this->id))
        {
            @elfchat_error('noselect');
        }
        mysql_query("SET NAMES 'utf8'");
    }

    function sql_set_collation_and_cp()
    {
        $this->sql_get_version();

        if ( $this->mysql_version >= 40101 )
        {
            $res = mysql_query( "SHOW CHARSET LIKE '" . $this->obj['mysql_codepage']  .  "'", $this->connection_id );
            
            $charset = mysql_fetch_row($res);

            mysql_query( "SET NAMES " . $this->obj['mysql_codepage'], $this->connection_id );
            mysql_query( "SET CHARACTER SET " . $this->obj['mysql_codepage'], $this->connection_id );      
            mysql_query( "SET character_set_connection = " . $this->obj['mysql_codepage'], $this->connection_id );                 
            mysql_query( "SET collation_connection = " . $charset[2], $this->connection_id );
        }
        
        unset( $this->obj['sql_host'] );
        unset( $this->obj['sql_user'] );
        unset( $this->obj['sql_pass'] );
        
        return TRUE;
    }

    function sql_set_collation_and_cp()
    {
        $this->sql_get_version();
        
        if ( $this->mysql_version >= 40101 )
        {
            $res = mysqli_query( $this->connection_id, "SHOW CHARSET LIKE '" . $this->obj['mysql_codepage']  .  "'");
            
            $charset = mysqli_fetch_row($res);

            mysqli_query( $this->connection_id, "SET NAMES " . $this->obj['mysql_codepage'] );
            mysqli_query( $this->connection_id, "SET CHARACTER SET " . $this->obj['mysql_codepage'] );      
            mysqli_query( $this->connection_id, "SET character_set_connection = " . $this->obj['mysql_codepage'] );      
            mysqli_query( $this->connection_id, "SET collation_connection = " . $charset[2] );
        }
                      
        return TRUE;
    }