__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
<?php
class SGCharsetHandler
{
private $utf8mb4Available = false;
private $utf8mb4520Available = false;
public function __construct()
{
$this->utf8mb4Available = $this->mysqlHasCapability('utf8mb4');
$this->utf8mb4520Available = $this->mysqlHasCapability('utf8mb4_520');
}
public function replaceInvalidCharsets($query)
{
$search = array();
$replace = array();
//check for utf8mb4_520 support first
if (!$this->utf8mb4520Available) {
$search[] = 'COLLATE=utf8mb4_unicode_520_ci';
$replace[] = $this->utf8mb4Available?'COLLATE=utf8mb4_unicode_ci':'COLLATE=utf8_general_ci';
$search[] = 'COLLATE utf8mb4_unicode_520_ci';
$replace[] = $this->utf8mb4Available?'COLLATE utf8mb4_unicode_ci':'COLLATE utf8_general_ci';
}
//then check for utf8mb4 support
if (!$this->utf8mb4Available) {
$search[] = 'COLLATE=utf8mb4_unicode_ci';
$replace[] = 'COLLATE=utf8_general_ci';
$search[] = 'COLLATE utf8mb4_unicode_ci';
$replace[] = 'COLLATE utf8_general_ci';
$search[] = 'CHARACTER SET utf8mb4';
$replace[] = 'CHARACTER SET utf8';
$search[] = 'CHARSET=utf8mb4';
$replace[] = 'CHARSET=utf8';
$search[] = 'character_set_client = utf8mb4';
$replace[] = 'character_set_client = utf8';
$search[] = 'SET NAMES utf8mb4';
$replace[] = 'SET NAMES utf8';
}
if (count($search) && count($replace)) {
$query = str_replace($search, $replace, $query);
}
return $query;
}
public function getMysqlClientInfo()
{
if (function_exists('mysqli_connect')) {
if (version_compare(phpversion(), '5.5', '>=') || !function_exists('mysql_connect')) {
return @mysqli_get_client_info();
}
}
return SG_MYSQL_VERSION;
}
public function mysqlHasCapability($cap)
{
if ($cap == 'utf8mb4') {
if (version_compare(SG_MYSQL_VERSION, '5.5.3', '<')) {
return false;
}
$clientVersion = $this->getMysqlClientInfo();
/*
* libmysql has supported utf8mb4 since 5.5.3, same as the MySQL server.
* mysqlnd has supported utf8mb4 since 5.0.9.
*/
if (false !== strpos($clientVersion, 'mysqlnd')) {
$clientVersion = preg_replace('/^\D+([\d.]+).*/', '$1', $clientVersion);
return version_compare($clientVersion, '5.0.9', '>=');
}
else {
return version_compare($clientVersion, '5.5.3', '>=');
}
}
else if ($cap == 'utf8mb4_520') {
return version_compare(SG_MYSQL_VERSION, '5.6', '>=');
}
return false;
}
}
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| BackupGuard | Folder | 0755 |
|
|
| Dropbox | Folder | 0755 |
|
|
| Request | Folder | 0755 |
|
|
| SGArchive.php | File | 21.39 KB | 0644 |
|
| SGAuthClient.php | File | 6.68 KB | 0644 |
|
| SGCallback.php | File | 870 B | 0644 |
|
| SGCdrEntry.php | File | 1.01 KB | 0644 |
|
| SGCharsetHandler.php | File | 2.37 KB | 0644 |
|
| SGDBState.php | File | 2.95 KB | 0644 |
|
| SGEntry.php | File | 155 B | 0644 |
|
| SGFileEntry.php | File | 917 B | 0644 |
|
| SGFileState.php | File | 4.42 KB | 0644 |
|
| SGMigrateState.php | File | 1.17 KB | 0644 |
|
| SGMysqldump.php | File | 45.07 KB | 0644 |
|
| SGReloadHandler.php | File | 804 B | 0644 |
|
| SGReloader.php | File | 2.27 KB | 0644 |
|
| SGReloaderState.php | File | 1.2 KB | 0644 |
|
| SGReviewManager.php | File | 12.04 KB | 0644 |
|
| SGState.php | File | 3.21 KB | 0644 |
|
| SGStatsRequests.php | File | 1.81 KB | 0644 |
|
| SGUploadHandler.php | File | 905 B | 0644 |
|
| SGUploadState.php | File | 4.04 KB | 0644 |
|