File Manager

X7ROOT File Manager

Current Path: /var/softaculous/moodle311

ðŸ“ ..
ðŸ“„ NOTES.txt(2.24 KB)
ðŸ“„ add_admin.php(733 B)
ðŸ“„ check_utf8.php(6.99 KB)
ðŸ“„ clone.php(5.46 KB)
ðŸ“„ config.php(745 B)
ðŸ“„ edit.php(4.64 KB)
ðŸ“„ edit.xml(433 B)
ðŸ“„ extend.php(12.46 KB)
ðŸ“„ fileindex.php(933 B)
ðŸ“„ get_plugin_list.php(840 B)
ðŸ“ images
ðŸ“„ import.php(7.46 KB)
ðŸ“„ info.xml(3.51 KB)
ðŸ“„ install.js(924 B)
ðŸ“„ install.php(10.75 KB)
ðŸ“„ install.xml(2.73 KB)
ðŸ“ languages
ðŸ“„ md5(5.13 KB)
ðŸ“ php53
ðŸ“ php56
ðŸ“ php71
ðŸ“ php81
ðŸ“ php82
ðŸ“„ privatekey.php(786 B)
ðŸ“„ update_pass.php(541 B)
ðŸ“„ upgrade.php(8.87 KB)
ðŸ“„ upgrade.xml(307 B)

Editing: check_utf8.php

<?php
/**
	 * Does the database server claim to have support for UTF-8 Multibyte (utf8mb4) collation?
	 *
	 * libmysql supports utf8mb4 since 5.5.3 (same version as the MySQL server). mysqlnd supports utf8mb4 since 5.0.9.
	 *
	 * @return  boolean
	 *
	 * @since   CMS 3.5.0
	 */
	function serverClaimsUtf8mb4Support()
	{
		
		if(!is_large_prefix_enabled()){
			return false;
		}
		
		$client_version = mysqli_get_client_info();

if (strpos($client_version, 'mysqlnd') !== false)
		{
			$client_version = preg_replace('/^\D+([\d.]+).*/', '$1', $client_version);

return version_compare($client_version, '5.0.9', '>=');
		}
		else
		{
			return version_compare($client_version, '5.5.3', '>=');
		}
	}
	
	function get_dbtype() {
		
		$con = mysqli_connect("[[softdbhost]]","[[softdbuser]]","[[softdbpass]]","[[softdb]]");

$details = mysqli_get_server_info($con);
		
		if(preg_match('/mariadb/is', $details)){
			return 'mariadb';
		}
		
        return 'mysqli';
    }
	
	function get_engine_type(){
		return 'innodb';
	}
	
	/**
	 * Get the version of the database connector.
	 *
	 * @return  string  The database connector version.
	 *
	 * @since   12.1
	 */
	function getVersion(){
		global $con;
		
		$con = mysqli_connect("[[softdbhost]]","[[softdbuser]]","[[softdbpass]]","[[softdb]]");

$ver = mysqli_get_server_info($con);
		
		if(preg_match('/mariadb/is', $ver)){
			preg_match('/-(.*?)-mariadb/is', $ver, $matches);
			
			if(empty($matches[1])){
				preg_match('/(.*?)-mariadb/is', $ver, $matches);
			}
			if(!empty($matches[1])){
				$ver = $matches[1];
			}
		}

return $ver;
	}
	
	function get_row_format($table = null) {
		global $con;
		$rowformat = null;
		if (is_antelope_file_format_no_more_supported()) {
			$rowformat = 'Barracuda';
			return $rowformat;
         }

$sql = "SHOW VARIABLES LIKE 'innodb_file_format'";
        $result = mysqli_query($con, $sql);
        if ($rec = $result->fetch_assoc()) {
            // MySQL 8 BC: information_schema.* returns the fields in upper case.
            $rec = array_change_key_case($rec, CASE_LOWER);
            if (isset($table)) {
                $rowformat = $rec['row_format'];
            } else {
                $rowformat = $rec['value'];
            }
        }

return $rowformat;
    }
	
	function is_antelope_file_format_no_more_supported() {
        // Breaking change: Antelope file format support has been removed from both MySQL and MariaDB.
        // The following InnoDB file format configuration parameters were deprecated and then removed:
        // - innodb_file_format
        // - innodb_file_format_check
        // - innodb_file_format_max
        // - innodb_large_prefix
        // 1. MySQL: deprecated in 5.7.7 and removed 8.0.0+.
        $ismysqlge8d0d0 = (get_dbtype() == 'mysqli') &&
                version_compare(getVersion(), '8.0.0', '>=');
        // 2. MariaDB: deprecated in 10.2.0 and removed 10.3.1+.
        $ismariadbge10d3d1 = (get_dbtype() == 'mariadb') &&
                version_compare(getVersion(), '10.3.1', '>=');

return $ismysqlge8d0d0 || $ismariadbge10d3d1;
    }
	
	function is_compressed_row_format_supported($cached = true) {
        
		$engine = get_engine_type();
        $info = getVersion();

if (version_compare($info, '5.5.0') < 0) {
            // MySQL 5.1 is not supported here because we cannot read the file format.
            $compressedrowformatsupported = false;

} else if ($engine !== 'innodb' and $engine !== 'xtradb') {
            // Other engines are not supported, most probably not compatible.
            $compressedrowformatsupported = false;

} else if (!is_file_per_table_enabled()) {
            $compressedrowformatsupported = false;

} else if (get_row_format() !== 'Barracuda') {
            $compressedrowformatsupported = false;

} else {
            // All the tests passed, we can safely use ROW_FORMAT=Compressed in sql statements.
            $compressedrowformatsupported = true;
        }

return $compressedrowformatsupported;
    }
	
	function is_file_per_table_enabled() {
		global $con;
		$sql = "SHOW VARIABLES LIKE 'innodb_file_per_table'";
        $result = mysqli_query($con, $sql);
		if ($rec = $result->fetch_assoc()) {
            // MySQL 8 BC: information_schema.* returns the fields in upper case.
            $rec = array_change_key_case($rec, CASE_LOWER);
            if ($rec['value'] == 'ON') {
                return true;
            }
        }
		
        return false;
    }
	
	function get_row_format_sql($engine = null, $collation = null) {

$rowformat = '';
	   $serverClaimsUtf8mb4Support = serverClaimsUtf8mb4Support();
	   $engine = get_engine_type();
	   
        if (($engine === 'innodb' || $engine === 'xtradb') && !empty($serverClaimsUtf8mb4Support)) {
            if (is_compressed_row_format_supported()) {
                $rowformat = "ROW_FORMAT=COMPRESSED";
            } else {
                $rowformat = "ROW_FORMAT=DYNAMIC";
            }
        }
        return $rowformat;
    }
	
    function is_large_prefix_enabled() {
		global $con;
		
        if (is_antelope_file_format_no_more_supported()) {
            // Breaking change: Antelope file format support has been removed, only Barracuda.
            return true;
        }
		
		$sql = "SHOW VARIABLES LIKE 'innodb_large_prefix'";
        $result = mysqli_query($con, $sql);
		if ($rec = $result->fetch_assoc()) {
            // MySQL 8 BC: information_schema.* returns the fields in upper case.
            $rec = array_change_key_case($rec, CASE_LOWER);
            if ($rec['value'] == 'ON') {
                return true;
            }
        }
		
        return false;
    }

function detect_collation(){

// Create connection
    $con = mysqli_connect("[[softdbhost]]","[[softdbuser]]","[[softdbpass]]","[[softdb]]");
                   
    // We want only utf8 compatible collations.
    $collation = null;
    $query = "SHOW COLLATION WHERE Collation LIKE 'utf8mb4\_%' AND Charset = 'utf8mb4'";
    
    $result = mysqli_query($con, $query);
    
    while ($row = mysqli_fetch_assoc($result)) {
        
        $collation = $row['Collation'];
        if (strtoupper($row['Default']) === 'YES') {
            $collation = $row['Collation'];
            break;
            }
    }
    
    if (!$collation) {
        
        $result = mysqli_fetch_array(mysqli_query($con, "SELECT @@collation_database;"));
        
        $value = $result['@@collation_database'];
    
        if (strpos($value, 'utf8_') === 0 || strpos($value, 'utf8mb4_') === 0) {
            $collation = $value;
        }
    }
    
    return $collation;
}

$serverClaimsUtf8mb4Support = serverClaimsUtf8mb4Support();
	$row_format = get_row_format_sql();
	$collation = detect_collation();
	
	if(!empty($serverClaimsUtf8mb4Support) && !empty($row_format)){
		echo $utf8 = '<claim_utf8>utf8mb4</claim_utf8>';
		echo '</br>';
		echo '<row_format>'.$row_format.'</row_format>';
	}
	
	if(!empty($utf8) && $utf8 == '<claim_utf8>utf8mb4</claim_utf8>'){
		echo '</br>';
		echo '<collation>'.$collation.'</collation>';
	}

X7ROOT File Manager

Editing: check_utf8.php

Upload File

Create Folder