Gecko [ nbspublicschool.com ]

/ var / softaculous / zen / [ HOME SHELL ]

Name	Size	Permission	Action
images	[ DIR ]	drwxr-xr-x
php53	[ DIR ]	drwxr-xr-x
php56	[ DIR ]	drwxr-xr-x
php71	[ DIR ]	drwxr-xr-x
php81	[ DIR ]	drwxr-xr-x
php82	[ DIR ]	drwxr-xr-x
upgrade	[ DIR ]	drwxr-xr-x
.htaccess	630 B	-rw-r--r--
NOTES.TXT	2.03 KB	-rw-r--r--
_.htaccess	195 B	-rw-r--r--
_index.php	5.16 KB	-rw-r--r--
check_utf8.php	2.36 KB	-rw-r--r--
clone.php	6.72 KB	-rw-r--r--
edit.php	4.78 KB	-rw-r--r--
edit.xml	433 B	-rw-r--r--
favicon.ico	1.37 KB	-rw-r--r--
fileindex.php	204 B	-rw-r--r--
import.php	3.41 KB	-rw-r--r--
index.php	5.01 KB	-rw-r--r--
info.xml	4.61 KB	-rw-r--r--
install.js	924 B	-rw-r--r--
install.php	10.74 KB	-rw-r--r--
install.xml	1.61 KB	-rw-r--r--
md5	1.43 KB	-rw-r--r--
robots.txt	560 B	-rw-r--r--
upgrade.php	9.29 KB	-rw-r--r--
upgrade.xml	277 B	-rw-r--r--
zenphoto.cfg.php	4.41 KB	-rw-r--r--

Code Editor : check_utf8.php

<?php

function getCollationSetClause() {
		if (hasUtf8mb4Support('utf8mb4_520')) { // MySQL 5.6+ 
			return ' CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci';
		} else if (hasUtf8mb4Support('utf8mb4')) { // MySQL 5.5.3+
			return ' CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci';
		} else {
			return ' CHARACTER SET utf8 COLLATE utf8_unicode_ci';
		}
	}

function hasUtf8mb4Support($which = 'utf8mb4_520') {
		$db_version = getVersion();
		if ($db_version) { // if not set no db functions available
			switch ($which) {
				case 'utf8mb4':
					if (isMariaDB() && version_compare($db_version, '5.5.0', '<')) {
						return false;
					} else if (version_compare($db_version, '5.5.3', '<')) {
						return false;
					}
					$client_version = mysqli_get_client_info();
					/*
					 * libmysql has supported utf8mb4 since 5.5.3, same as the MySQL server.
					 * mysqlnd has supported utf8mb4 since 5.0.9.
					 */
					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', '>=');
					}
				case 'utf8mb4_520':
					return version_compare($db_version, '5.6', '>=');
				case 'general':
					return (hasUtf8mb4Support('utf8mb4') || hasUtf8mb4Support('utf8mb4_520'));
			}
		}
		return false;
	}
	
function getVersion() {
		$software = getVersionComplete();
		if ($software) {
			if (isMariaDB()) {
				preg_match("/\d+(\.\d+){2,}-MariaDB/", $software, $matches);
				if ($matches) {
					return str_replace('-MariaDB', '', $matches[0]);
				}
				return $software; // just in case…
			} else {
				return $software;
			}
		}
		return '0.0.0';
	}
	
function getVersionComplete() {
	global $connection;
	
	$connection = mysqli_connect("[[softdbhost]]","[[softdbuser]]","[[softdbpass]]","[[softdb]]");

if ($connection) {
		$query = mysqli_fetch_array(mysqli_query($connection, "SELECT version()"));
		if ($query) {
			return $query['version()'];
		}
	}
	return null;
}
	
function isMariaDB() {
	$db_version = getVersionComplete();
	if ($db_version && stristr($db_version, 'mariadb')) { // version includes note if mariadb
		return true;
	}
	return false;
}
	$charset_value = getCollationSetClause();
	
	if(!empty($charset_value)){
		echo '<charset_value>'.$charset_value.'</charset_value>';
	}

?>