#acupoftea - mail.ontime-ae.com

System	:	Linux server1.ontime-gulf.com 4.18.0-553.5.1.el8_10.x86_64 #1 SMP Wed Jun 5 09:12:13 EDT 2024 x86_64
Software	:	Apache
Server	:	162.0.230.206
Domains	:	40 Domain
Permission	:	[ drwxr-xr-x ]
	:	/ var / softaculous / moodle39 /

216.73.216.50

Home

File 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;
    }

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

Name	Type	Size	Permission	Last Modified	Actions
.	DIR	-	drwxr-xr-x	2025-07-15 09:41:10
..	DIR	-	drwxr-xr-x	2025-10-25 09:38:52
images	DIR	-	drwxr-xr-x	2025-07-15 09:41:10
languages	DIR	-	drwxr-xr-x	2025-07-15 09:41:10
php53	DIR	-	drwxr-xr-x	2025-07-15 09:41:10
php56	DIR	-	drwxr-xr-x	2025-07-15 09:41:10
php71	DIR	-	drwxr-xr-x	2025-07-15 09:41:10
php81	DIR	-	drwxr-xr-x	2025-07-15 09:41:10
php82	DIR	-	drwxr-xr-x	2025-07-15 09:41:10
NOTES.txt	text/plain	1.77 KB	-rw-r--r--	2024-10-30 08:35:20
add_admin.php	text/x-php	733 B	-rw-r--r--	2022-06-30 08:50:36
check_utf8.php	text/x-php	5.88 KB	-rw-r--r--	2022-03-14 01:35:14
clone.php	text/x-php	5.48 KB	-rw-r--r--	2025-07-14 08:36:36
config.php	text/x-php	745 B	-rw-r--r--	2021-12-23 06:54:36
edit.php	text/x-php	4.6 KB	-rw-r--r--	2025-07-14 08:36:36
edit.xml	text/html	433 B	-rw-r--r--	2021-12-23 06:54:36
extend.php	text/x-php	12.44 KB	-rw-r--r--	2025-07-14 08:36:36
fileindex.php	text/plain	998 B	-rw-r--r--	2024-10-30 08:35:20
import.php	text/x-php	7.52 KB	-rw-r--r--	2025-07-14 08:36:36
info.xml	text/html	3.43 KB	-rw-r--r--	2025-07-14 08:24:50
install.js	text/plain	924 B	-rw-r--r--	2021-12-23 06:54:36
install.php	text/x-php	10.74 KB	-rw-r--r--	2025-07-14 08:36:36
install.xml	text/html	2.57 KB	-rw-r--r--	2023-06-29 06:20:22
md5	text/plain	4.94 KB	-rw-r--r--	2025-07-14 08:36:36
privatekey.php	text/x-php	786 B	-rw-r--r--	2021-12-23 06:54:36
update_pass.php	text/x-php	541 B	-rw-r--r--	2021-12-23 06:54:36
upgrade.php	text/x-php	8.72 KB	-rw-r--r--	2025-07-14 08:36:36
upgrade.xml	text/plain	307 B	-rw-r--r--	2021-12-23 06:54:36

~ ACUPOFTEA - mail.ontime-ae.com