<h2>Editing File: /var/softaculous/zen/check_utf8.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?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() &amp;&amp; version_compare($db_version, '5.5.0', '&lt;')) {
						return false;
					} else if (version_compare($db_version, '5.5.3', '&lt;')) {
						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', '&gt;=');
					} else {
						return version_compare($client_version, '5.5.3', '&gt;=');
					}
				case 'utf8mb4_520':
					return version_compare($db_version, '5.6', '&gt;=');
				case 'general':
					return (hasUtf8mb4Support('utf8mb4') || hasUtf8mb4Support('utf8mb4_520'));
			}
		}
		return false;
	}
	
function getVersion() {
		$software = getVersionComplete();
		if ($software) {
			if (isMariaDB()) {
				preg_match(&quot;/\d+(\.\d+){2,}-MariaDB/&quot;, $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(&quot;[[softdbhost]]&quot;,&quot;[[softdbuser]]&quot;,&quot;[[softdbpass]]&quot;,&quot;[[softdb]]&quot;);

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

?&gt;</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fvar%2Fsoftaculous%2Fzen'>Back to Directory</a>