FM / autoload

/home/techb158/exp.abdallabala.com/application/autoload/

/home/techb158/exp.abdallabala.com/application/autoload

Name	Size	Mode	Actions
Ib/	-	0755	rm
IBilling/	-	0755	rm
Models/	-	0755	rm
Notify/	-	0755	rm
Admin.php	1626	0644	edit dl rm
App.php	87	0644	edit dl rm
Arr.php	416	0644	edit dl rm
Asset.php	1822	0644	edit dl rm
Auth.php	1246	0644	edit dl rm
Backup.php	11650	0644	edit dl rm
Cache.php	84	0644	edit dl rm
Ccavenue.php	8458	0644	edit dl rm
class.smtp.php	39438	0644	edit dl rm
Companies.php	2564	0644	edit dl rm
Contacts.php	6607	0644	edit dl rm
Countries.php	31152	0644	edit dl rm
Currency.php	23237	0644	edit dl rm
Dashboard.php	20625	0644	edit dl rm
DB.php	62	0644	edit dl rm
Demo.php	24844	0644	edit dl rm
Dev.php	1666	0644	edit dl rm
Ed.php	1758	0644	edit dl rm
Event.php	449	0644	edit dl rm
ExtendedZip.php	1381	0644	edit dl rm
Finance.php	5874	0644	edit dl rm
Fsubmit.php	4489	0644	edit dl rm
Gravatar.php	2721	0644	edit dl rm
Image.php	69395	0644	edit dl rm
index.html	112	0644	edit dl rm
Invoice.php	15557	0644	edit dl rm
Make.php	966	0644	edit dl rm
Misc.php	1385	0644	edit dl rm
Model.php	23728	0644	edit dl rm
ORM.php	84036	0644	edit dl rm
Paginator.php	6122	0644	edit dl rm
parseCSV.php	39009	0644	edit dl rm
Parsedown.php	38137	0644	edit dl rm
Password.php	2136	0644	edit dl rm
PHPMailer.php	111411	0644	edit dl rm
Plugins.php	2973	0644	edit dl rm
Quote.php	8090	0644	edit dl rm
Reorder.php	2017	0644	edit dl rm
Repeating.php	5771	0644	edit dl rm
Schema.php	4899	0644	edit dl rm
Sms.php	1047	0644	edit dl rm
Syscpanel.php	6058	0644	edit dl rm
Syscurl.php	1075	0644	edit dl rm
Sysfile.php	579	0644	edit dl rm
Tags.php	831	0644	edit dl rm
Template.php	540	0644	edit dl rm
Timezone.php	1171	0644	edit dl rm
Transaction.php	1073	0644	edit dl rm
Uploader.php	3369	0644	edit dl rm
User.php	374	0644	edit dl rm
Util.php	9760	0644	edit dl rm
Validator.php	8634	0644	edit dl rm
View.php	2170	0644	edit dl rm

Edit: /home/techb158/exp.abdallabala.com/application/autoload/Backup.php (11650B)

<?php

use BackupManager\Config\Config;
use BackupManager\Filesystems;
use BackupManager\Databases;
use BackupManager\Compressors;
use BackupManager\Manager;

use BackupManager\Filesystems\Destination;

class Backup
{
    public function manager()
    {
        $filesystems = new Filesystems\FilesystemProvider(
            Config::fromPhpFile('system/helpers/backupfiles.php')
        );
        $filesystems->add(new Filesystems\Awss3Filesystem());
        $filesystems->add(new Filesystems\GcsFilesystem());
        $filesystems->add(new Filesystems\DropboxFilesystem());
        $filesystems->add(new Filesystems\FtpFilesystem());
        $filesystems->add(new Filesystems\LocalFilesystem());
        $filesystems->add(new Filesystems\RackspaceFilesystem());
        $filesystems->add(new Filesystems\SftpFilesystem());
        $databases = new Databases\DatabaseProvider(
            Config::fromPhpFile('system/helpers/backupdb.php')
        );
        $databases->add(new Databases\MysqlDatabase());
        $databases->add(new Databases\PostgresqlDatabase());
        $compressors = new Compressors\CompressorProvider();
        $compressors->add(new Compressors\GzipCompressor());
        $compressors->add(new Compressors\NullCompressor());
        // build manager
        return new Manager($filesystems, $databases, $compressors);
    } /**
     * MYSQL EXPORT TO GZIP
     * exporting database to sql gzip compression data.
     * if directory writable will be make directory inside of directory if not exist, else wil be die
     *
     * @param string directory , as the directory to put file
     * @param $outname as file name just the name !, if file exist will be overide as numeric next ++ as name_1.sql.gz , name_2.sql.gz next ++
     *
     * @param string $dbhost database host
     * @param string $dbuser database user
     * @param string $dbpass database password
     * @param string $dbname database name
     *
     */

public function backupDatabaseMySqli(
        $directory,
        $outname,
        $action = 'store'
    ) {
        // check mysqli extension installed
        if (!function_exists('mysqli_connect')) {
            die(
                ' This scripts need mysql extension to be running properly ! please resolve!!'
            );
        }

$mysqli = @new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

if ($mysqli->connect_error) {
            print_r($mysqli->connect_error);
            return false;
        }

$dir = $directory;
        $result =
            '<p> Could not create backup directory on :' .
            $dir .
            ' Please Please make sure you have set Directory on 755 or 777 for a while.</p>';
        $res = true;
        if (!is_dir($dir)) {
            if (!@mkdir($dir, 755)) {
                $res = false;
            }
        }

$n = 1;
        if ($res) {
            $name = $outname;
            # counts
            if (file_exists($dir . '/' . $name . '.sql.gz')) {
                for (
                    $i = 1;
                    @count(file($dir . '/' . $name . '_' . $i . '.sql.gz'));
                    $i++
                ) {
                    $name = $name;
                    if (
                        !file_exists($dir . '/' . $name . '_' . $i . '.sql.gz')
                    ) {
                        $name = $name . '_' . $i;
                        break;
                    }
                }
            }

$fullname = $dir . '/' . $name . '.sql.gz'; # full structures
            if (!$mysqli->error) {
                $sql = "SHOW TABLES";
                $show = $mysqli->query($sql);
                while ($r = $show->fetch_array()) {
                    $tables[] = $r[0];
                }

if (!empty($tables)) {
                    //cycle through
                    $return = '';
                    foreach ($tables as $table) {
                        $result = $mysqli->query('SELECT * FROM ' . $table);
                        $num_fields = $result->field_count;
                        $row2 = $mysqli->query('SHOW CREATE TABLE ' . $table);

$row2 = $row2->fetch_row();
                        $return .=
                            "\n
-- ---------------------------------------------------------
--
-- Table structure for table : `{$table}`
--
-- ---------------------------------------------------------

" .
                            $row2[1] .
                            ";\n";

for ($i = 0; $i < $num_fields; $i++) {
                            $n = 1;
                            while ($row = $result->fetch_row()) {
                                if ($n++ == 1) {
                                    # set the first statements
                                    $return .= "
--
-- Dumping data for table `{$table}`
--

";
                                    /**
                                     * Get structural of fields each tables
                                     */
                                    $array_field = []; #reset ! important to resetting when loop
                                    while ($field = $result->fetch_field()) {
                                        # get field
                                        $array_field[] =
                                            '`' . $field->name . '`';
                                    }
                                    $array_f[$table] = $array_field;
                                    // $array_f = $array_f;
                                    # endwhile
                                    $array_field = implode(
                                        ', ',
                                        $array_f[$table]
                                    ); #implode arrays
                                    $return .= "INSERT INTO `{$table}` ({$array_field}) VALUES\n(";
                                } else {
                                    $return .= '(';
                                }
                                for ($j = 0; $j < $num_fields; $j++) {
                                    $row[$j] = str_replace(
                                        '\'',
                                        '\'\'',
                                        preg_replace("/\n/", "\\n", $row[$j])
                                    );
                                    if (isset($row[$j])) {
                                        $return .= is_numeric($row[$j])
                                            ? $row[$j]
                                            : '\'' . $row[$j] . '\'';
                                    } else {
                                        $return .= '\'\'';
                                    }
                                    if ($j < $num_fields - 1) {
                                        $return .= ', ';
                                    }
                                }
                                $return .= "),\n";
                            }
                            # check matching
                            @preg_match("/\),\n/", $return, $match, false, -3); # check match
                            if (isset($match[0])) {
                                $return = substr_replace($return, ";\n", -2);
                            }
                        }

$return .= "\n";
                    }

$return =
                        "-- ---------------------------------------------------------
--
-- SIMPLE SQL Dump
-- 
--
-- Host Connection Info: " .
                        $mysqli->host_info .
                        "
-- Generation Time: " .
                        date('F d, Y \a\t H:i A ( e )') .
                        "
-- PHP Version: " .
                        PHP_VERSION .
                        "
--
-- ---------------------------------------------------------\n\n

SET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";
SET time_zone = \"+00:00\";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
" .
                        $return .
                        "
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;";

# end values result

@ini_set('zlib.output_compression', 'Off');
                    $gzipoutput = gzencode($return, 9);

if ($action == 'store') {
                        if (@file_put_contents($fullname, $gzipoutput)) {
                            # 9 as compression levels

$result = $name . '.sql.gz'; # show the name
                        } else {
                            # if could not put file , automaticly you will get the file as downloadable

$result = false;
                            // various headers, those with # are mandatory
                        }
                    } else {
                        $result = false;
                        // various headers, those with # are mandatory
                        header('Content-Type: application/x-gzip'); // change it to mimetype
                        header("Content-Description: File Transfer");
                        header('Content-Encoding: gzip'); #
                        header('Content-Length: ' . strlen($gzipoutput)); #
                        header(
                            'Content-Disposition: attachment; filename="' .
                                $name .
                                '.sql.gz' .
                                '"'
                        );
                        header(
                            'Cache-Control: no-cache, no-store, max-age=0, must-revalidate'
                        );
                        header('Connection: Keep-Alive');
                        header("Content-Transfer-Encoding: binary");
                        header('Expires: 0');
                        header('Pragma: no-cache');

echo $gzipoutput;
                        exit();
                    }
                } else {
                    //  $result = 'Error when executing database query to export - '.$mysqli->error;

$result = false;
                }
            }
        } else {
            // $result = 'Wrong mysqli input';
            $result = false;
        }

if ($mysqli && !$mysqli->error) {
            @$mysqli->close();
        }

return $result;
    }

public function backupDB($file_path = '')
    {
        $manager = $this->manager();

$file_name = time();

if ($file_path == '') {
            $file_path = 'storage/backups/db/' . $file_name . '.sql';
        }
        try {
            $manager
                ->makeBackup()
                ->run(
                    'development',
                    [new Destination('local', $file_path)],
                    'gzip'
                );

return [
                'success' => true,
                'message' => 'Backup Successful',
                'file_path' => $file_path,
            ];
        } catch (Exception $e) {
            return [
                'success' => false,
                'message' => $e->getMessage(),
                'file_path' => $file_path,
            ];
        }
    }
}

add(new Filesystems\Awss3Filesystem()); $filesystems->add(new Filesystems\GcsFilesystem()); $filesystems->add(new Filesystems\DropboxFilesystem()); $filesystems->add(new Filesystems\FtpFilesystem()); $filesystems->add(new Filesystems\LocalFilesystem()); $filesystems->add(new Filesystems\RackspaceFilesystem()); $filesystems->add(new Filesystems\SftpFilesystem()); $databases = new Databases\DatabaseProvider( Config::fromPhpFile('system/helpers/backupdb.php') ); $databases->add(new Databases\MysqlDatabase()); $databases->add(new Databases\PostgresqlDatabase()); $compressors = new Compressors\CompressorProvider(); $compressors->add(new Compressors\GzipCompressor()); $compressors->add(new Compressors\NullCompressor()); // build manager return new Manager($filesystems, $databases, $compressors); } /** * MYSQL EXPORT TO GZIP * exporting database to sql gzip compression data. * if directory writable will be make directory inside of directory if not exist, else wil be die * * @param string directory , as the directory to put file * @param $outname as file name just the name !, if file exist will be overide as numeric next ++ as name_1.sql.gz , name_2.sql.gz next ++ * * @param string $dbhost database host * @param string $dbuser database user * @param string $dbpass database password * @param string $dbname database name * */ public function backupDatabaseMySqli( $directory, $outname, $action = 'store' ) { // check mysqli extension installed if (!function_exists('mysqli_connect')) { die( ' This scripts need mysql extension to be running properly ! please resolve!!' ); } $mysqli = @new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); if ($mysqli->connect_error) { print_r($mysqli->connect_error); return false; } $dir = $directory; $result = '

Could not create backup directory on :' . $dir . ' Please Please make sure you have set Directory on 755 or 777 for a while.

'; $res = true; if (!is_dir($dir)) { if (!@mkdir($dir, 755)) { $res = false; } } $n = 1; if ($res) { $name = $outname; # counts if (file_exists($dir . '/' . $name . '.sql.gz')) { for ( $i = 1; @count(file($dir . '/' . $name . '_' . $i . '.sql.gz')); $i++ ) { $name = $name; if ( !file_exists($dir . '/' . $name . '_' . $i . '.sql.gz') ) { $name = $name . '_' . $i; break; } } } $fullname = $dir . '/' . $name . '.sql.gz'; # full structures if (!$mysqli->error) { $sql = "SHOW TABLES"; $show = $mysqli->query($sql); while ($r = $show->fetch_array()) { $tables[] = $r[0]; } if (!empty($tables)) { //cycle through $return = ''; foreach ($tables as $table) { $result = $mysqli->query('SELECT * FROM ' . $table); $num_fields = $result->field_count; $row2 = $mysqli->query('SHOW CREATE TABLE ' . $table); $row2 = $row2->fetch_row(); $return .= "\n -- --------------------------------------------------------- -- -- Table structure for table : `{$table}` -- -- --------------------------------------------------------- " . $row2[1] . ";\n"; for ($i = 0; $i < $num_fields; $i++) { $n = 1; while ($row = $result->fetch_row()) { if ($n++ == 1) { # set the first statements $return .= " -- -- Dumping data for table `{$table}` -- "; /** * Get structural of fields each tables */ $array_field = []; #reset ! important to resetting when loop while ($field = $result->fetch_field()) { # get field $array_field[] = '`' . $field->name . '`'; } $array_f[$table] = $array_field; // $array_f = $array_f; # endwhile $array_field = implode( ', ', $array_f[$table] ); #implode arrays $return .= "INSERT INTO `{$table}` ({$array_field}) VALUES\n("; } else { $return .= '('; } for ($j = 0; $j < $num_fields; $j++) { $row[$j] = str_replace( '\'', '\'\'', preg_replace("/\n/", "\\n", $row[$j]) ); if (isset($row[$j])) { $return .= is_numeric($row[$j]) ? $row[$j] : '\'' . $row[$j] . '\''; } else { $return .= '\'\''; } if ($j < $num_fields - 1) { $return .= ', '; } } $return .= "),\n"; } # check matching @preg_match("/\),\n/", $return, $match, false, -3); # check match if (isset($match[0])) { $return = substr_replace($return, ";\n", -2); } } $return .= "\n"; } $return = "-- --------------------------------------------------------- -- -- SIMPLE SQL Dump -- -- -- Host Connection Info: " . $mysqli->host_info . " -- Generation Time: " . date('F d, Y \a\t H:i A ( e )') . " -- PHP Version: " . PHP_VERSION . " -- -- ---------------------------------------------------------\n\n SET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\"; SET time_zone = \"+00:00\"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; " . $return . " /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;"; # end values result @ini_set('zlib.output_compression', 'Off'); $gzipoutput = gzencode($return, 9); if ($action == 'store') { if (@file_put_contents($fullname, $gzipoutput)) { # 9 as compression levels $result = $name . '.sql.gz'; # show the name } else { # if could not put file , automaticly you will get the file as downloadable $result = false; // various headers, those with # are mandatory } } else { $result = false; // various headers, those with # are mandatory header('Content-Type: application/x-gzip'); // change it to mimetype header("Content-Description: File Transfer"); header('Content-Encoding: gzip'); # header('Content-Length: ' . strlen($gzipoutput)); # header( 'Content-Disposition: attachment; filename="' . $name . '.sql.gz' . '"' ); header( 'Cache-Control: no-cache, no-store, max-age=0, must-revalidate' ); header('Connection: Keep-Alive'); header("Content-Transfer-Encoding: binary"); header('Expires: 0'); header('Pragma: no-cache'); echo $gzipoutput; exit(); } } else { // $result = 'Error when executing database query to export - '.$mysqli->error; $result = false; } } } else { // $result = 'Wrong mysqli input'; $result = false; } if ($mysqli && !$mysqli->error) { @$mysqli->close(); } return $result; } public function backupDB($file_path = '') { $manager = $this->manager(); $file_name = time(); if ($file_path == '') { $file_path = 'storage/backups/db/' . $file_name . '.sql'; } try { $manager ->makeBackup() ->run( 'development', [new Destination('local', $file_path)], 'gzip' ); return [ 'success' => true, 'message' => 'Backup Successful', 'file_path' => $file_path, ]; } catch (Exception $e) { return [ 'success' => false, 'message' => $e->getMessage(), 'file_path' => $file_path, ]; } } }