aDriv4 website!

Linux server192.web-hosting.com 4.18.0-513.18.1.lve.el8.x86_64 #1 SMP Thu Feb 22 12:55:50 UTC 2024 x86_64
LiteSpeed
198.54.114.198

File Name : class-wpvivid-db-method.php

<?php

class WPvivid_DB_Method
{
    public $db_handle;
    public $type;

public function connect_db()
    {
        $common_setting = WPvivid_Setting::get_setting(false, 'wpvivid_common_setting');
        $db_connect_method = isset($common_setting['options']['wpvivid_common_setting']['db_connect_method']) ? $common_setting['options']['wpvivid_common_setting']['db_connect_method'] : 'wpdb';
        if($db_connect_method === 'wpdb'){
            global $wpdb;
            $this->db_handle=$wpdb;
            $this->type='wpdb';
            return array('result'=>WPVIVID_SUCCESS);
        }
        else{
            if(class_exists('PDO')) {
                $extensions=get_loaded_extensions();
                if(array_search('pdo_mysql',$extensions)) {
                    $res = explode(':',DB_HOST);
                    $db_host = $res[0];
                    $db_port = empty($res[1])?'':$res[1];

if(!empty($db_port)) {
                        $dsn='mysql:host=' . $db_host . ';port=' . $db_port . ';dbname=' . DB_NAME;
                    }
                    else{
                        $dsn='mysql:host=' . $db_host . ';dbname=' . DB_NAME;
                    }

$this->db_handle=new PDO($dsn, DB_USER, DB_PASSWORD);

$this->type='pdo_mysql';
                    return array('result'=>WPVIVID_SUCCESS);
                }
                else{
                    return array('result'=>WPVIVID_FAILED, 'error'=>'The pdo_mysql extension is not detected. Please install the extension first or choose wpdb option for Database connection method.');
                }
            }
            else{
                return array('result'=>WPVIVID_FAILED, 'error'=>'The pdo_mysql extension is not detected. Please install the extension first or choose wpdb option for Database connection method.');
            }
        }
    }

public function check_db($fcgi)
    {
        $ret=$this->connect_db();

if($ret['result']==WPVIVID_FAILED)
        {
            return $ret;
        }

if($this->type=='pdo_mysql')
        {
            return $this->check_db_pdo($fcgi);
        }
        else if($this->type=='wpdb')
        {
            return $this->check_db_wpdb($fcgi);
        }

return array('result' => WPVIVID_FAILED,'error' => 'db handle type not found.');
    }

public function check_db_pdo($fcgi)
    {
        $ret['alert_db']=false;
        $ret['result']=WPVIVID_SUCCESS;
        $ret['big_tables']=array();
        $db_info=array();

$sth = $this->db_handle->query('SHOW TABLE STATUS');
        $dbSize = 0;
        $sum_rows=0;
        $rows = $sth->fetchAll();
        foreach ($rows as $row)
        {
            global $wpdb;
            if (is_multisite() && !defined('MULTISITE'))
            {
                $prefix = $wpdb->base_prefix;
            } else {
                $prefix = $wpdb->get_blog_prefix(0);
            }
            if(preg_match('/^(?!'.$prefix.')/', $row["Name"]) == 1){
                continue;
            }

$db_info[$row["Name"]]["Rows"]=$row["Rows"];
            $db_info[$row["Name"]]["Data_length"]=size_format($row["Data_length"]+$row["Index_length"],2);
            if($row["Rows"]>1000000)
            {
                $ret['big_tables'][$row["Name"]]['Rows']=$row["Rows"];
                $ret['big_tables'][$row["Name"]]['Data_length']=size_format($row["Data_length"]+$row["Index_length"],2);
            }

$sum_rows+=$row["Rows"];
            $dbSize+=$row["Data_length"]+$row["Index_length"];
        }
        if($fcgi)
        {
            $alter_sum_rows=4000000;
        }
        else
        {
            $alter_sum_rows=4000000*3;
        }

$memory_limit = ini_get('memory_limit');
        $ret['memory_limit']=$memory_limit;
        $memory_limit = trim($memory_limit);
        $memory_limit_int = (int) $memory_limit;
        $last = strtolower(substr($memory_limit, -1));

if($last == 'g')
            $memory_limit_int = $memory_limit_int*1024*1024*1024;
        if($last == 'm')
            $memory_limit_int = $memory_limit_int*1024*1024;
        if($last == 'k')
            $memory_limit_int = $memory_limit_int*1024;

if($dbSize>($memory_limit_int*0.9))
        {
            $max_rows=0;
        }
        else
        {
            $max_rows=(($memory_limit_int*0.9)-$dbSize)/49;
        }

$max_rows=max($max_rows,1048576);

if($sum_rows>$alter_sum_rows||$sum_rows>$max_rows)
        {
            //big db alert
            $ret['alert_db']=true;
            $ret['sum_rows']=$sum_rows;
            $ret['db_size']=size_format($dbSize,2);
            if($fcgi)
                $ret['alter_fcgi']=true;
        }

$ret['db_size']=size_format($dbSize,2);
        return $ret;
    }

public function check_db_wpdb($fcgi)
    {
        $ret['alert_db']=false;
        $ret['result']=WPVIVID_SUCCESS;
        $ret['big_tables']=array();
        $db_info=array();

global $wpdb;
        $result=$wpdb->get_results('SHOW TABLE STATUS',ARRAY_A);

//$sth = $this->db_handle->query('SHOW TABLE STATUS');
        $dbSize = 0;
        $sum_rows=0;
        //$rows = $sth->fetchAll();
        foreach ($result as $row)
        {
            global $wpdb;
            if (is_multisite() && !defined('MULTISITE'))
            {
                $prefix = $wpdb->base_prefix;
            } else {
                $prefix = $wpdb->get_blog_prefix(0);
            }
            if(preg_match('/^(?!'.$prefix.')/', $row["Name"]) == 1){
                continue;
            }

if($dbSize>($memory_limit_int*0.9))
        {
            $max_rows=0;
        }
        else
        {
            $max_rows=(($memory_limit_int*0.9)-$dbSize)/49;
        }

$max_rows=max($max_rows,1048576);

$ret['db_size']=size_format($dbSize,2);
        return $ret;
    }

public function get_sql_mode()
    {
        try {
            $ret['result'] = WPVIVID_SUCCESS;
            $ret['mysql_mode'] = '';

global $wpdb;
            $result = $wpdb->get_results('SELECT @@SESSION.sql_mode', ARRAY_A);
            foreach ($result as $row) {
                $ret['mysql_mode'] = $row["@@SESSION.sql_mode"];
            }
        }
        catch (Exception $error) {
            $message = 'An exception has occurred. class: '.get_class($error).';msg: '.$error->getMessage().';code: '.$error->getCode().';line: '.$error->getLine().';in_file: '.$error->getFile().';';
            error_log($message);
            return array('result'=>'failed','error'=>$message);
        }

return $ret;
    }

public function get_mysql_version()
    {
        global $wpdb;

$mysql_version = $wpdb->db_version();

return $mysql_version;
    }

public function check_max_allowed_packet()
    {
        global $wpvivid_plugin,$wpdb;

$max_allowed_packet = (int) $wpdb->get_var("SELECT @@session.max_allowed_packet");

if($max_allowed_packet<1048576)
        {
            $wpvivid_plugin->wpvivid_log->WriteLog('warning: max_allowed_packet less than 1M :'.size_format($max_allowed_packet,2),'notice');
        }
        else if($max_allowed_packet<33554432)
        {
            $wpvivid_plugin->wpvivid_log->WriteLog('max_allowed_packet less than 32M :'.size_format($max_allowed_packet,2),'notice');
        }
    }
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	htllcxvj/htllcxvj	0755	2025-07-04 01:57:19
..	dir	-	htllcxvj/htllcxvj	0755	2025-07-04 01:57:21
customclass	dir	-	htllcxvj/htllcxvj	0755	2025-07-04 01:57:19
lib	dir	-	htllcxvj/htllcxvj	0755	2025-07-04 01:57:19
lib2	dir	-	htllcxvj/htllcxvj	0755	2025-07-04 01:57:19
mu-plugins	dir	-	htllcxvj/htllcxvj	0755	2025-07-04 01:57:20
new_backup	dir	-	htllcxvj/htllcxvj	0755	2025-07-04 01:57:20
snapshot	dir	-	htllcxvj/htllcxvj	0755	2025-07-04 01:57:20
staging	dir	-	htllcxvj/htllcxvj	0755	2025-07-04 01:57:20
upload-cleaner	dir	-	htllcxvj/htllcxvj	0755	2025-07-04 01:57:20
zip	dir	-	htllcxvj/htllcxvj	0755	2025-07-04 01:57:20
class-wpvivid-additional-db-method.php	text/x-php	8.73 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-backup-database.php	text/x-php	5.3 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-backup-site.php	text/x-php	1.65 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-backup-uploader.php	text/x-php	44.01 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-backup.php	text/x-php	115.67 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-backuplist.php	text/x-php	13.03 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-backuptoremote.php	text/x-php	1.89 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-compress-default.php	text/x-php	2.5 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-crypt.php	text/x-php	6.46 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-db-method.php	text/x-php	8.99 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-downloader.php	text/x-php	6.53 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-error-log.php	text/x-php	6.23 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-export-import.php	text/x-php	123.75 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-exporter.php	text/x-php	72.82 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-function-realize.php	text/x-php	9.47 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-i18n.php	text/x-php	899 B	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-importer.php	text/x-php	99.23 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-interface-mainwp.php	text/x-php	26.56 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-log.php	text/x-php	5.56 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-mail-report.php	text/x-php	64.28 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-migrate.php	text/x-php	76.51 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-mysqldump-method.php	text/x-php	100.82 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-mysqldump.php	text/x-php	43.72 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-public-interface.php	text/x-php	15.81 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-remote-collection.php	text/x-php	5.11 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-restore-data.php	text/x-php	1.56 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-schedule.php	text/x-php	13.28 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-setting.php	text/x-php	23.26 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-tab-page-container.php	text/x-php	9.69 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-taskmanager.php	text/x-php	22.64 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-tools.php	text/x-php	4.55 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-upload.php	text/x-php	5.98 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid-zipclass.php	text/x-php	53.34 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
class-wpvivid.php	text/x-php	318.46 KB	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19
index.php	text/x-php	26 B	htllcxvj/htllcxvj	0644	2025-07-04 01:57:19

For more Private tool come to me!

https://t.me/aDriv4vz