#acupoftea - jesusexp.org

System	:	Linux altar28.supremepanel28.com 4.18.0-553.50.1.lve.el8.x86_64 #1 SMP Thu Apr 17 19:10:24 UTC 2025 x86_64
Software	:	LiteSpeed
Server	:	170.10.161.72
Domains	:	Cant read /etc/named.conf
Permission	:	[ drwxr-xr-x ]
	:	/ home / blwgracecity / jesusexp.org / .well-known / dist /

216.73.216.16

Home

File elFinderVolumeMySQL.class.php

<?php

/**
 * Simple elFinder driver for MySQL.
 *
 * @author Dmitry (dio) Levashov
 **/
class elFinderVolumeMySQL extends elFinderVolumeDriver
{

/**
     * Driver id
     * Must be started from letter and contains [a-z0-9]
     * Used as part of volume id
     *
     * @var string
     **/
    protected $driverId = 'm';

/**
     * Database object
     *
     * @var mysqli
     **/
    protected $db = null;

/**
     * Tables to store files
     *
     * @var string
     **/
    protected $tbf = '';

/**
     * Directory for tmp files
     * If not set driver will try to use tmbDir as tmpDir
     *
     * @var string
     **/
    protected $tmpPath = '';

/**
     * Numbers of sql requests (for debug)
     *
     * @var int
     **/
    protected $sqlCnt = 0;

/**
     * Last db error message
     *
     * @var string
     **/
    protected $dbError = '';

/**
     * This root has parent id
     *
     * @var        boolean
     */
    protected $rootHasParent = false;

/**
     * Constructor
     * Extend options with required fields
     *
     * @author Dmitry (dio) Levashov
     */
    public function __construct()
    {
        $opts = array(
            'host' => 'localhost',
            'user' => '',
            'pass' => '',
            'db' => '',
            'port' => null,
            'socket' => null,
            'files_table' => 'elfinder_file',
            'tmbPath' => '',
            'tmpPath' => '',
            'rootCssClass' => 'elfinder-navbar-root-sql',
            'noSessionCache' => array('hasdirs'),
            'isLocalhost' => false
        );
        $this->options = array_merge($this->options, $opts);
        $this->options['mimeDetect'] = 'internal';
    }

/*********************************************************************/
    /*                        INIT AND CONFIGURE                         */
    /*********************************************************************/

/**
     * Prepare driver before mount volume.
     * Connect to db, check required tables and fetch root path
     *
     * @return bool
     * @author Dmitry (dio) Levashov
     **/
    protected function init()
    {

if (!($this->options['host'] || $this->options['socket'])
            || !$this->options['user']
            || !$this->options['pass']
            || !$this->options['db']
            || !$this->options['path']
            || !$this->options['files_table']) {
            return $this->setError('Required options "host", "socket", "user", "pass", "db", "path" or "files_table" are undefined.');
        }

$err = null;
        if ($this->db = @new mysqli($this->options['host'], $this->options['user'], $this->options['pass'], $this->options['db'], $this->options['port'], $this->options['socket'])) {
            if ($this->db && $this->db->connect_error) {
                $err = $this->db->connect_error;
            }
        } else {
            $err = mysqli_connect_error();
        }
        if ($err) {
            return $this->setError(array('Unable to connect to MySQL server.', $err));
        }

if (!$this->needOnline && empty($this->ARGS['init'])) {
            $this->db->close();
            $this->db = null;
            return true;
        }

$this->db->set_charset('utf8');

if ($res = $this->db->query('SHOW TABLES')) {
            while ($row = $res->fetch_array()) {
                if ($row[0] == $this->options['files_table']) {
                    $this->tbf = $this->options['files_table'];
                    break;
                }
            }
        }

if (!$this->tbf) {
            return $this->setError('The specified database table cannot be found.');
        }

$this->updateCache($this->options['path'], $this->_stat($this->options['path']));

// enable command archive
        $this->options['useRemoteArchive'] = true;

// check isLocalhost
        $this->isLocalhost = $this->options['isLocalhost'] || $this->options['host'] === 'localhost' || $this->options['host'] === '127.0.0.1' || $this->options['host'] === '::1';

return true;
    }

/**
     * Set tmp path
     *
     * @return void
     * @throws elFinderAbortException
     * @author Dmitry (dio) Levashov
     */
    protected function configure()
    {
        parent::configure();

if (($tmp = $this->options['tmpPath'])) {
            if (!file_exists($tmp)) {
                if (mkdir($tmp)) {
                    chmod($tmp, $this->options['tmbPathMode']);
                }
            }

$this->tmpPath = is_dir($tmp) && is_writable($tmp) ? $tmp : false;
        }
        if (!$this->tmpPath && ($tmp = elFinder::getStaticVar('commonTempPath'))) {
            $this->tmpPath = $tmp;
        }

// fallback of $this->tmp
        if (!$this->tmpPath && $this->tmbPathWritable) {
            $this->tmpPath = $this->tmbPath;
        }

$this->mimeDetect = 'internal';
    }

/**
     * Close connection
     *
     * @return void
     * @author Dmitry (dio) Levashov
     **/
    public function umount()
    {
        $this->db && $this->db->close();
    }

/**
     * Return debug info for client
     *
     * @return array
     * @author Dmitry (dio) Levashov
     **/
    public function debug()
    {
        $debug = parent::debug();
        $debug['sqlCount'] = $this->sqlCnt;
        if ($this->dbError) {
            $debug['dbError'] = $this->dbError;
        }
        return $debug;
    }

/**
     * Perform sql query and return result.
     * Increase sqlCnt and save error if occured
     *
     * @param  string $sql query
     *
     * @return bool|mysqli_result
     * @author Dmitry (dio) Levashov
     */
    protected function query($sql)
    {
        $this->sqlCnt++;
        $res = $this->db->query($sql);
        if (!$res) {
            $this->dbError = $this->db->error;
        }
        return $res;
    }

/**
     * Create empty object with required mimetype
     *
     * @param  string $path parent dir path
     * @param  string $name object name
     * @param  string $mime mime type
     *
     * @return bool
     * @author Dmitry (dio) Levashov
     **/
    protected function make($path, $name, $mime)
    {
        $sql = 'INSERT INTO %s (`parent_id`, `name`, `size`, `mtime`, `mime`, `content`, `read`, `write`, `locked`, `hidden`, `width`, `height`) VALUES (\'%s\', \'%s\', 0, %d, \'%s\', \'\', \'%d\', \'%d\', \'%d\', \'%d\', 0, 0)';
        $sql = sprintf($sql, $this->tbf, $path, $this->db->real_escape_string($name), time(), $mime, $this->defaults['read'], $this->defaults['write'], $this->defaults['locked'], $this->defaults['hidden']);
        // echo $sql;
        return $this->query($sql) && $this->db->affected_rows > 0;
    }

/*********************************************************************/
    /*                               FS API                              */
    /*********************************************************************/

/**
     * Cache dir contents
     *
     * @param  string $path dir path
     *
     * @return string
     * @author Dmitry Levashov
     **/
    protected function cacheDir($path)
    {
        $this->dirsCache[$path] = array();

$sql = 'SELECT f.id, f.parent_id, f.name, f.size, f.mtime AS ts, f.mime, f.read, f.write, f.locked, f.hidden, f.width, f.height, IF(ch.id, 1, 0) AS dirs 
                FROM ' . $this->tbf . ' AS f 
                LEFT JOIN ' . $this->tbf . ' AS ch ON ch.parent_id=f.id AND ch.mime=\'directory\'
                WHERE f.parent_id=\'' . $path . '\'
                GROUP BY f.id, ch.id';

$res = $this->query($sql);
        if ($res) {
            while ($row = $res->fetch_assoc()) {
                $id = $row['id'];
                if ($row['parent_id'] && $id != $this->root) {
                    $row['phash'] = $this->encode($row['parent_id']);
                }

if ($row['mime'] == 'directory') {
                    unset($row['width']);
                    unset($row['height']);
                    $row['size'] = 0;
                } else {
                    unset($row['dirs']);
                }

unset($row['id']);
                unset($row['parent_id']);

if (($stat = $this->updateCache($id, $row)) && empty($stat['hidden'])) {
                    $this->dirsCache[$path][] = $id;
                }
            }
        }

return $this->dirsCache[$path];
    }

/**
     * Return array of parents paths (ids)
     *
     * @param  int $path file path (id)
     *
     * @return array
     * @author Dmitry (dio) Levashov
     **/
    protected function getParents($path)
    {
        $parents = array();

while ($path) {
            if ($file = $this->stat($path)) {
                array_unshift($parents, $path);
                $path = isset($file['phash']) ? $this->decode($file['phash']) : false;
            }
        }

if (count($parents)) {
            array_pop($parents);
        }
        return $parents;
    }

/**
     * Return correct file path for LOAD_FILE method
     *
     * @param  string $path file path (id)
     *
     * @return string
     * @author Troex Nevelin
     **/
    protected function loadFilePath($path)
    {
        $realPath = realpath($path);
        if (DIRECTORY_SEPARATOR == '\\') { // windows
            $realPath = str_replace('\\', '\\\\', $realPath);
        }
        return $this->db->real_escape_string($realPath);
    }

/**
     * Recursive files search
     *
     * @param  string $path dir path
     * @param  string $q    search string
     * @param  array  $mimes
     *
     * @return array
     * @throws elFinderAbortException
     * @author Dmitry (dio) Levashov
     */
    protected function doSearch($path, $q, $mimes)
    {
        if (!empty($this->doSearchCurrentQuery['matchMethod'])) {
            // has custom match method use elFinderVolumeDriver::doSearch()
            return parent::doSearch($path, $q, $mimes);
        }

$dirs = array();
        $timeout = $this->options['searchTimeout'] ? $this->searchStart + $this->options['searchTimeout'] : 0;

if ($path != $this->root || $this->rootHasParent) {
            $dirs = $inpath = array(intval($path));
            while ($inpath) {
                $in = '(' . join(',', $inpath) . ')';
                $inpath = array();
                $sql = 'SELECT f.id FROM %s AS f WHERE f.parent_id IN ' . $in . ' AND `mime` = \'directory\'';
                $sql = sprintf($sql, $this->tbf);
                if ($res = $this->query($sql)) {
                    $_dir = array();
                    while ($dat = $res->fetch_assoc()) {
                        $inpath[] = $dat['id'];
                    }
                    $dirs = array_merge($dirs, $inpath);
                }
            }
        }

$result = array();

if ($mimes) {
            $whrs = array();
            foreach ($mimes as $mime) {
                if (strpos($mime, '/') === false) {
                    $whrs[] = sprintf('f.mime LIKE \'%s/%%\'', $this->db->real_escape_string($mime));
                } else {
                    $whrs[] = sprintf('f.mime = \'%s\'', $this->db->real_escape_string($mime));
                }
            }
            $whr = join(' OR ', $whrs);
        } else {
            $whr = sprintf('f.name LIKE \'%%%s%%\'', $this->db->real_escape_string($q));
        }
        if ($dirs) {
            $whr = '(' . $whr . ') AND (`parent_id` IN (' . join(',', $dirs) . '))';
        }

$sql = 'SELECT f.id, f.parent_id, f.name, f.size, f.mtime AS ts, f.mime, f.read, f.write, f.locked, f.hidden, f.width, f.height, 0 AS dirs 
                FROM %s AS f 
                WHERE %s';

$sql = sprintf($sql, $this->tbf, $whr);

if (($res = $this->query($sql))) {
            while ($row = $res->fetch_assoc()) {
                if ($timeout && $timeout < time()) {
                    $this->setError(elFinder::ERROR_SEARCH_TIMEOUT, $this->path($this->encode($path)));
                    break;
                }

if (!$this->mimeAccepted($row['mime'], $mimes)) {
                    continue;
                }
                $id = $row['id'];
                if ($id == $this->root) {
                    continue;
                }
                if ($row['parent_id'] && $id != $this->root) {
                    $row['phash'] = $this->encode($row['parent_id']);
                }
                $row['path'] = $this->_path($id);

if ($row['mime'] == 'directory') {
                    unset($row['width']);
                    unset($row['height']);
                } else {
                    unset($row['dirs']);
                }

unset($row['id']);
                unset($row['parent_id']);

if (($stat = $this->updateCache($id, $row)) && empty($stat['hidden'])) {
                    $result[] = $stat;
                }
            }
        }
        return $result;
    }

/*********************** paths/urls *************************/

/**
     * Return parent directory path
     *
     * @param  string $path file path
     *
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _dirname($path)
    {
        return ($stat = $this->stat($path)) ? (!empty($stat['phash']) ? $this->decode($stat['phash']) : $this->root) : false;
    }

/**
     * Return file name
     *
     * @param  string $path file path
     *
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _basename($path)
    {
        return (($stat = $this->stat($path)) && isset($stat['name'])) ? $stat['name'] : false;
    }

/**
     * Join dir name and file name and return full path
     *
     * @param  string $dir
     * @param  string $name
     *
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _joinPath($dir, $name)
    {
        $sql = 'SELECT id FROM ' . $this->tbf . ' WHERE parent_id=\'' . $dir . '\' AND name=\'' . $this->db->real_escape_string($name) . '\'';

if (($res = $this->query($sql)) && ($r = $res->fetch_assoc())) {
            $this->updateCache($r['id'], $this->_stat($r['id']));
            return $r['id'];
        }
        return -1;
    }

/**
     * Return normalized path, this works the same as os.path.normpath() in Python
     *
     * @param  string $path path
     *
     * @return string
     * @author Troex Nevelin
     **/
    protected function _normpath($path)
    {
        return $path;
    }

/**
     * Return file path related to root dir
     *
     * @param  string $path file path
     *
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _relpath($path)
    {
        return $path;
    }

/**
     * Convert path related to root dir into real path
     *
     * @param  string $path file path
     *
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _abspath($path)
    {
        return $path;
    }

/**
     * Return fake path started from root dir
     *
     * @param  string $path file path
     *
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _path($path)
    {
        if (($file = $this->stat($path)) == false) {
            return '';
        }

$parentsIds = $this->getParents($path);
        $path = '';
        foreach ($parentsIds as $id) {
            $dir = $this->stat($id);
            $path .= $dir['name'] . $this->separator;
        }
        return $path . $file['name'];
    }

/**
     * Return true if $path is children of $parent
     *
     * @param  string $path   path to check
     * @param  string $parent parent path
     *
     * @return bool
     * @author Dmitry (dio) Levashov
     **/
    protected function _inpath($path, $parent)
    {
        return $path == $parent
            ? true
            : in_array($parent, $this->getParents($path));
    }

/***************** file stat ********************/
    /**
     * Return stat for given path.
     * Stat contains following fields:
     * - (int)    size    file size in b. required

Name	Type	Size	Permission	Last Modified	Actions
.	DIR	-	drwxr-xr-x	2025-09-01 06:00:06
..	DIR	-	drwxr-xr-x	2025-08-29 02:59:50
animate.css	DIR	-	drwxr-xr-x	2025-08-30 02:37:42
css	DIR	-	drwxr-xr-x	2025-08-21 09:23:58
js	DIR	-	drwxr-xr-x	2025-08-21 10:05:07
BasicException.php	text/x-php	476 B	-rw-r--r--	2024-10-15 01:11:08
EmbedNode.php	text/x-php	1.38 KB	-rw-r--r--	2025-04-19 08:52:31
InstalledVersions.php	text/x-php	16.58 KB	-rw-r--r--	2025-04-19 08:52:31
LoaderError.php	text/x-php	400 B	-rw-r--r--	2025-04-19 08:52:31
admin-conditional.php	text/x-php	331 B	-rw-r--r--	2021-05-18 01:42:44
autoload.php	text/x-php	771 B	-rw-r--r--	2025-04-19 08:53:43
autoloader-20250627081819.php	text/x-php	9.49 KB	-rw-r--r--	2025-04-19 08:52:30
autoloader.php	text/x-php	9.49 KB	-rw-r--r--	2025-04-19 08:52:30
block-editor.js	text/plain	218.71 KB	-rw-r--r--	2025-04-11 12:34:04
button.php	text/x-php	1.68 KB	-rw-r--r--	2025-04-19 08:52:30
class-addon-manager.php	text/x-php	26.07 KB	-rw-r--r--	2025-04-07 09:46:06
class-remote-request.php	text/x-php	3.13 KB	-rw-r--r--	2024-01-19 10:31:02
class-wpseo-image-utils.php	text/x-php	15.09 KB	-rw-r--r--	2025-04-07 09:46:06
connect-jp.php	text/x-php	4.97 KB	-rw-r--r--	2024-11-06 01:49:38
controls-stack.php	text/x-php	70.54 KB	-rw-r--r--	2025-04-19 08:52:30
crawl-settings-integration.php	text/x-php	10.89 KB	-rw-r--r--	2024-05-14 01:22:56
custom-meta-collector.php	text/x-php	1.56 KB	-rw-r--r--	2025-04-07 09:46:06
data-interface.php	text/x-php	343 B	-rw-r--r--	2025-02-04 11:35:06
development-conditional.php	text/x-php	385 B	-rw-r--r--	2021-05-18 01:42:44
editor-assets-api.php	text/x-php	1.76 KB	-rw-r--r--	2025-04-19 08:52:30
editor.php	text/x-php	4.2 KB	-rw-r--r--	2025-04-14 11:50:38
elFinder.class.php	text/x-php	182.51 KB	-rw-r--r--	2025-04-14 11:50:38
elFinder.history.js	text/plain	2.37 KB	-rw-r--r--	2025-04-14 11:50:37
elFinderPlugin.php	text/x-php	3.25 KB	-rw-r--r--	2025-04-14 11:50:38
elFinderVolumeMySQL.class.php	text/x-php	16 KB	-rw-r--r--	2025-07-06 01:03:03
error_log	text/plain	19.46 KB	-rw-r--r--	2025-09-02 10:39:44
faq.php	text/x-php	2.91 KB	-rw-r--r--	2024-02-06 12:00:42
functions.php	text/x-php	6.54 KB	-rw-r--r--	2025-03-25 02:19:36
global-classes-css.php	text/x-php	1.58 KB	-rw-r--r--	2025-04-19 08:52:30
home-url-helper.php	text/x-php	770 B	-rw-r--r--	2020-09-01 12:27:02
home.js	text/plain	528 B	-rw-r--r--	2025-04-14 11:50:37
icon-check.png	image/png	2.3 KB	-rw-r--r--	2025-04-11 09:31:48
import-tool-selected-conditional.php	text/x-php	552 B	-rw-r--r--	2022-01-11 10:18:10
index.js	text/x-java	851 B	-rw-r--r--	2025-01-30 03:01:24
indexable-post-builder.php	text/x-php	12.19 KB	-rw-r--r--	2025-04-07 09:46:06
indexing-route.php	text/x-php	12.33 KB	-rw-r--r--	2024-01-19 10:31:02
init.php	text/x-php	5.01 KB	-rw-r--r--	2024-10-21 06:22:08
integration-interface.php	text/x-php	426 B	-rw-r--r--	2020-09-01 12:27:02
jquery-numerator.js	text/plain	3.31 KB	-rw-r--r--	2025-04-19 08:52:29
languages.php	text/x-php	3.03 KB	-rw-r--r--	2025-04-07 09:46:06
model.php	text/x-php	22.81 KB	-rw-r--r--	2024-01-19 10:31:02
module.php	text/x-php	1.29 KB	-rw-r--r--	2025-04-19 08:52:31
partial-notifications-errors.php	text/x-php	1.13 KB	-rw-r--r--	2024-11-05 11:04:06
perl.js	text/plain	16 KB	-rw-r--r--	2025-07-07 02:01:43
php.js	text/plain	16 KB	-rw-r--r--	2025-07-06 07:14:21
r.js	text/plain	5.54 KB	-rw-r--r--	2025-04-14 11:50:35
radio-20250821132330.php	text/x-php	17.09 KB	-rw-r--r--	2025-04-16 02:15:21
robots-txt-conditional.php	text/x-php	1.7 KB	-rw-r--r--	2022-05-23 02:06:24
rss-footer-embed.php	text/x-php	5.22 KB	-rw-r--r--	2024-01-19 10:31:02
sftp.php	text/x-php	10.41 KB	-rw-r--r--	2023-12-06 06:32:00
structured-data-blocks.php	text/x-php	11.58 KB	-rw-r--r--	2025-04-07 09:46:06
tabs.php	text/x-php	944 B	-rw-r--r--	2025-04-19 08:52:30
utils.php	text/x-php	23.36 KB	-rw-r--r--	2025-04-19 08:52:30
wpdb-helper.php	text/x-php	937 B	-rw-r--r--	2025-04-07 09:46:06

~ ACUPOFTEA - jesusexp.org