?? GreyFile

?? GreyFile — Mystic File Browser

Current path: home/webdevt/www/schtroumpf.fr/classes/

?? Go up: /home/webdevt/www/schtroumpf.fr

?? Editing: PrestaShopBackup.php

<?php
/**
 * Copyright since 2007 PrestaShop SA and Contributors
 * PrestaShop is an International Registered Trademark & Property of PrestaShop SA
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is bundled with this package in the file LICENSE.md.
 * It is also available through the world-wide-web at this URL:
 * https://opensource.org/licenses/OSL-3.0
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@prestashop.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future. If you wish to customize PrestaShop for your
 * needs please refer to https://devdocs.prestashop.com/ for more information.
 *
 * @author    PrestaShop SA and Contributors <contact@prestashop.com>
 * @copyright Since 2007 PrestaShop SA and Contributors
 * @license   https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
 */

/**
 * Class PrestaShopBackupCore.
 */
class PrestaShopBackupCore
{
    /** @var string Object id */
    public $id;

/** @var string Last error messages */
    public $error;

/** @var string default backup directory. */
    public static $backupDir = '/backups/';

/** @var string custom backup directory. */
    public $customBackupDir = null;

/** @var bool|string */
    public $psBackupAll = true;
    /** @var bool|string */
    public $psBackupDropTable = true;

/**
     * Creates a new backup object.
     *
     * @param string $filename Filename of the backup file
     */
    public function __construct($filename = null)
    {
        if ($filename) {
            $this->id = $this->getRealBackupPath($filename);
        }

$psBackupAll = Configuration::get('PS_BACKUP_ALL');
        $psBackupDropTable = Configuration::get('PS_BACKUP_DROP_TABLE');
        $this->psBackupAll = $psBackupAll !== false ? $psBackupAll : true;
        $this->psBackupDropTable = $psBackupDropTable !== false ? $psBackupDropTable : true;
    }

/**
     * you can set a different path with that function.
     *
     * @TODO include the prefix name
     *
     * @param string $dir
     *
     * @return bool
     */
    public function setCustomBackupPath($dir)
    {
        $customDir = DIRECTORY_SEPARATOR . trim($dir, '/') . DIRECTORY_SEPARATOR;
        if (is_dir(_PS_ADMIN_DIR_ . $customDir)) {
            $this->customBackupDir = $customDir;

return true;
        }

return false;
    }

/**
     * get the path to use for backup (customBackupDir if specified, or default).
     *
     * @param string $filename filename to use
     *
     * @return string full path
     */
    public function getRealBackupPath($filename = null)
    {
        $backupDir = PrestaShopBackup::getBackupPath($filename);
        if (!empty($this->customBackupDir)) {
            $backupDir = str_replace(
                _PS_ADMIN_DIR_ . self::$backupDir,
                _PS_ADMIN_DIR_ . $this->customBackupDir,
                $backupDir
            );

if (strrpos($backupDir, DIRECTORY_SEPARATOR)) {
                $backupDir .= DIRECTORY_SEPARATOR;
            }
        }

return $backupDir;
    }

/**
     * Get the full path of the backup file.
     *
     * @param string $filename prefix of the backup file (datetime will be the second part)
     *
     * @return string The full path of the backup file, or false if the backup file does not exists
     */
    public static function getBackupPath($filename = '')
    {
        $backupdir = realpath(_PS_ADMIN_DIR_ . self::$backupDir);

if ($backupdir === false) {
            die(Tools::displayError(Context::getContext()->getTranslator()->trans('"Backup" directory does not exist.', [], 'Admin.Advparameters.Notification')));
        }

// Check the realpath so we can validate the backup file is under the backup directory
        if (!empty($filename)) {
            $backupfile = realpath($backupdir . DIRECTORY_SEPARATOR . $filename);
        } else {
            $backupfile = $backupdir . DIRECTORY_SEPARATOR;
        }

if ($backupfile === false || strncmp($backupdir, $backupfile, strlen($backupdir)) != 0) {
            die(Tools::displayError());
        }

return $backupfile;
    }

/**
     * Check if a backup file exist.
     *
     * @param string $filename prefix of the backup file (datetime will be the second part)
     *
     * @return bool true if backup file exist
     */
    public static function backupExist($filename)
    {
        $backupdir = realpath(_PS_ADMIN_DIR_ . self::$backupDir);

return @filemtime($backupdir . DIRECTORY_SEPARATOR . $filename);
    }

/**
     * Get the URL used to retrieve this backup file.
     *
     * @return string The url used to request the backup file
     *
     * @deprecated As the call has been duplicated in the new Controller. Get the URL from the router instead.
     */
    public function getBackupURL()
    {
        // Additionnal parameters (action, filename, ajax) are kept for backward compatibility, in case we disable the new controller
        return Context::getContext()->link->getAdminLink(
                'AdminBackup',
                true,
                [
                    'route' => 'admin_backup_download',
                    'downloadFileName' => basename($this->id),
                ],
                [
                    'action' => 'backupContent',
                    'ajax' => 1,
                    'filename' => basename($this->id),
                ]
            );
    }

/**
     * Delete the current backup file.
     *
     * @return bool Deletion result, true on success
     */
    public function delete()
    {
        if (!$this->id || !unlink($this->id)) {
            $this->error = Context::getContext()->getTranslator()->trans('Error deleting', [], 'Admin.Advparameters.Notification') . ' ' . ($this->id ? '"' . $this->id . '"' :
                Context::getContext()->getTranslator()->trans('Invalid ID', [], 'Admin.Advparameters.Notification'));

return false;
        }

return true;
    }

/**
     * Deletes a range of backup files.
     *
     * @return bool True on success
     */
    public function deleteSelection($list)
    {
        foreach ($list as $file) {
            $backup = new PrestaShopBackup($file);
            if (!$backup->delete()) {
                $this->error = $backup->error;

return false;
            }
        }

return true;
    }

/**
     * Creates a new backup file.
     *
     * @return bool true on successful backup
     */
    public function add()
    {
        if (!$this->psBackupAll) {
            $ignoreInsertTable = [_DB_PREFIX_ . 'connections', _DB_PREFIX_ . 'connections_page', _DB_PREFIX_
                . 'connections_source', _DB_PREFIX_ . 'guest', _DB_PREFIX_ . 'statssearch',
            ];
        } else {
            $ignoreInsertTable = [];
        }

// Generate some random number, to make it extra hard to guess backup file names
        $rand = dechex(mt_rand(0, min(0xFFFFFFFF, mt_getrandmax())));
        $date = time();
        $backupfile = $this->getRealBackupPath() . $date . '-' . $rand . '.sql';

// Figure out what compression is available and open the file
        if (function_exists('bzopen')) {
            $backupfile .= '.bz2';
            $fp = @bzopen($backupfile, 'w');
        } elseif (function_exists('gzopen')) {
            $backupfile .= '.gz';
            $fp = @gzopen($backupfile, 'w');
        } else {
            $fp = @fopen($backupfile, 'wb');
        }

if ($fp === false) {
            echo Context::getContext()->getTranslator()->trans('Unable to create backup file', [], 'Admin.Advparameters.Notification') . ' "' . addslashes($backupfile) . '"';

return false;
        }

$this->id = realpath($backupfile);

fwrite($fp, '/* Backup for ' . Tools::getHttpHost(false, false) . __PS_BASE_URI__ . "\n *  at " . date('Y-m-d H:i:s', $date) . "\n */\n");
        fwrite($fp, "\n" . 'SET NAMES \'utf8mb4\';');
        fwrite($fp, "\n" . 'SET FOREIGN_KEY_CHECKS = 0;');
        fwrite($fp, "\n" . 'SET SESSION sql_mode = \'\';' . "\n\n");

// Find all tables
        $tables = Db::getInstance()->executeS('SHOW TABLES');
        $found = 0;
        foreach ($tables as $table) {
            $table = current($table);

// Skip tables which do not start with _DB_PREFIX_
            if (strlen($table) < strlen(_DB_PREFIX_) || strncmp($table, _DB_PREFIX_, strlen(_DB_PREFIX_)) != 0) {
                continue;
            }

// Export the table schema
            $schema = Db::getInstance()->executeS('SHOW CREATE TABLE `' . $table . '`');

if (count($schema) != 1 || !isset($schema[0]['Table']) || !isset($schema[0]['Create Table'])) {
                fclose($fp);
                $this->delete();
                echo Context::getContext()->getTranslator()->trans('An error occurred while backing up. Unable to obtain the schema of %s', [$table], 'Admin.Advparameters.Notification');

return false;
            }

fwrite($fp, '/* Scheme for table ' . $schema[0]['Table'] . " */\n");

if ($this->psBackupDropTable) {
                fwrite($fp, 'DROP TABLE IF EXISTS `' . $schema[0]['Table'] . '`;' . "\n");
            }

fwrite($fp, $schema[0]['Create Table'] . ";\n\n");

if (!in_array($schema[0]['Table'], $ignoreInsertTable)) {
                $data = Db::getInstance()->query('SELECT * FROM `' . $schema[0]['Table'] . '`');
                $sizeof = Db::getInstance()->numRows();
                $lines = explode("\n", $schema[0]['Create Table']);

if ($data && $sizeof > 0) {
                    // Export the table data
                    fwrite($fp, 'INSERT INTO `' . $schema[0]['Table'] . "` VALUES\n");
                    $i = 1;
                    while ($row = Db::getInstance()->nextRow($data)) {
                        $s = '(';

foreach ($row as $field => $value) {
                            $tmp = "'" . pSQL($value, true) . "',";
                            if ($tmp != "'',") {
                                $s .= $tmp;
                            } else {
                                foreach ($lines as $line) {
                                    if (strpos($line, '`' . $field . '`') !== false) {
                                        if (preg_match('/(.*NOT NULL.*)/Ui', $line)) {
                                            $s .= "'',";
                                        } else {
                                            $s .= 'NULL,';
                                        }

break;
                                    }
                                }
                            }
                        }
                        $s = rtrim($s, ',');

if ($i % 200 == 0 && $i < $sizeof) {
                            $s .= ");\nINSERT INTO `" . $schema[0]['Table'] . "` VALUES\n";
                        } elseif ($i < $sizeof) {
                            $s .= "),\n";
                        } else {
                            $s .= ");\n";
                        }

fwrite($fp, $s);
                        ++$i;
                    }
                }
            }
            ++$found;
        }

fclose($fp);
        if ($found == 0) {
            $this->delete();
            echo Context::getContext()->getTranslator()->trans('No valid tables were found to backup.', [], 'Admin.Advparameters.Notification');

return false;
        }

return true;
    }
}

?? assets | ??? Delete
?? cache | ??? Delete
?? checkout | ??? Delete
?? container | ??? Delete
?? controller | ??? Delete
?? db | ??? Delete
?? exception | ??? Delete
?? form | ??? Delete
?? helper | ??? Delete
?? lang | ??? Delete
?? log | ??? Delete
?? module | ??? Delete
?? order | ??? Delete
?? pdf | ??? Delete
?? product | ??? Delete
?? proxy | ??? Delete
?? range | ??? Delete
?? shop | ??? Delete
?? Smarty | ??? Delete
?? stock | ??? Delete
?? tax | ??? Delete
?? tree | ??? Delete
?? webservice | ??? Delete
?? Access.php | ?? Edit | ??? Delete
?? Address.php | ?? Edit | ??? Delete
?? AddressChecksumCore.php | ?? Edit | ??? Delete
?? AddressFormat.php | ?? Edit | ??? Delete
?? Alias.php | ?? Edit | ??? Delete
?? Attachment.php | ?? Edit | ??? Delete
?? AttributeGroup.php | ?? Edit | ??? Delete
?? Carrier.php | ?? Edit | ??? Delete
?? Cart.php | ?? Edit | ??? Delete
?? CartRule.php | ?? Edit | ??? Delete
?? Category.php | ?? Edit | ??? Delete
?? Chart.php | ?? Edit | ??? Delete
?? ChecksumInterface.php | ?? Edit | ??? Delete
?? CMS.php | ?? Edit | ??? Delete
?? CMSCategory.php | ?? Edit | ??? Delete
?? CMSRole.php | ?? Edit | ??? Delete
?? Combination.php | ?? Edit | ??? Delete
?? Configuration.php | ?? Edit | ??? Delete
?? ConfigurationKPI.php | ?? Edit | ??? Delete
?? ConfigurationTest.php | ?? Edit | ??? Delete
?? Connection.php | ?? Edit | ??? Delete
?? ConnectionsSource.php | ?? Edit | ??? Delete
?? Contact.php | ?? Edit | ??? Delete
?? Context.php | ?? Edit | ??? Delete
?? Cookie.php | ?? Edit | ??? Delete
?? Country.php | ?? Edit | ??? Delete
?? CSV.php | ?? Edit | ??? Delete
?? Currency.php | ?? Edit | ??? Delete
?? Curve.php | ?? Edit | ??? Delete
?? Customer.php | ?? Edit | ??? Delete
?? CustomerAddress.php | ?? Edit | ??? Delete
?? CustomerMessage.php | ?? Edit | ??? Delete
?? CustomerSession.php | ?? Edit | ??? Delete
?? CustomerThread.php | ?? Edit | ??? Delete
?? Customization.php | ?? Edit | ??? Delete
?? CustomizationField.php | ?? Edit | ??? Delete
?? DateRange.php | ?? Edit | ??? Delete
?? Delivery.php | ?? Edit | ??? Delete
?? Dispatcher.php | ?? Edit | ??? Delete
?? Employee.php | ?? Edit | ??? Delete
?? EmployeeSession.php | ?? Edit | ??? Delete
?? Feature.php | ?? Edit | ??? Delete
?? FeatureFlag.php | ?? Edit | ??? Delete
?? FeatureValue.php | ?? Edit | ??? Delete
?? FileUploader.php | ?? Edit | ??? Delete
?? Gender.php | ?? Edit | ??? Delete
?? Group.php | ?? Edit | ??? Delete
?? GroupReduction.php | ?? Edit | ??? Delete
?? Guest.php | ?? Edit | ??? Delete
?? Hook.php | ?? Edit | ??? Delete
?? Image.php | ?? Edit | ??? Delete
?? ImageManager.php | ?? Edit | ??? Delete
?? ImageType.php | ?? Edit | ??? Delete
?? index.php | ?? Edit | ??? Delete
?? Language.php | ?? Edit | ??? Delete
?? Link.php | ?? Edit | ??? Delete
?? LocalizationPack.php | ?? Edit | ??? Delete
?? Mail.php | ?? Edit | ??? Delete
?? Manufacturer.php | ?? Edit | ??? Delete
?? ManufacturerAddress.php | ?? Edit | ??? Delete
?? Media.php | ?? Edit | ??? Delete
?? Message.php | ?? Edit | ??? Delete
?? Meta.php | ?? Edit | ??? Delete
?? Notification.php | ?? Edit | ??? Delete
?? ObjectModel.php | ?? Edit | ??? Delete
?? Pack.php | ?? Edit | ??? Delete
?? Page.php | ?? Edit | ??? Delete
?? PaymentFree.php | ?? Edit | ??? Delete
?? PaymentModule.php | ?? Edit | ??? Delete
?? PhpEncryption.php | ?? Edit | ??? Delete
?? PhpEncryptionEngine.php | ?? Edit | ??? Delete
?? PrestaShopAutoload.php | ?? Edit | ??? Delete
?? PrestaShopBackup.php | ?? Edit | ??? Delete
?? PrestaShopCollection.php | ?? Edit | ??? Delete
?? PrestaShopLogger.php | ?? Edit | ??? Delete
?? Product.php | ?? Edit | ??? Delete
?? ProductAssembler.php | ?? Edit | ??? Delete
?? ProductAttribute.php | ?? Edit | ??? Delete
?? ProductDownload.php | ?? Edit | ??? Delete
?? ProductPresenterFactory.php | ?? Edit | ??? Delete
?? ProductSale.php | ?? Edit | ??? Delete
?? ProductSupplier.php | ?? Edit | ??? Delete
?? Profile.php | ?? Edit | ??? Delete
?? QqUploadedFileForm.php | ?? Edit | ??? Delete
?? QqUploadedFileXhr.php | ?? Edit | ??? Delete
?? QuickAccess.php | ?? Edit | ??? Delete
?? RequestSql.php | ?? Edit | ??? Delete
?? Risk.php | ?? Edit | ??? Delete
?? Search.php | ?? Edit | ??? Delete
?? SearchEngine.php | ?? Edit | ??? Delete
?? SpecificPrice.php | ?? Edit | ??? Delete
?? SpecificPriceRule.php | ?? Edit | ??? Delete
?? State.php | ?? Edit | ??? Delete
?? Store.php | ?? Edit | ??? Delete
?? Supplier.php | ?? Edit | ??? Delete
?? SupplierAddress.php | ?? Edit | ??? Delete
?? Tab.php | ?? Edit | ??? Delete
?? Tag.php | ?? Edit | ??? Delete
?? Tools.php | ?? Edit | ??? Delete
?? Translate.php | ?? Edit | ??? Delete
?? TranslatedConfiguration.php | ?? Edit | ??? Delete
?? Upgrader.php | ?? Edit | ??? Delete
?? Uploader.php | ?? Edit | ??? Delete
?? Validate.php | ?? Edit | ??? Delete
?? ValidateConstraintTranslator.php | ?? Edit | ??? Delete
?? WarehouseAddress.php | ?? Edit | ??? Delete
?? Zone.php | ?? Edit | ??? Delete