Exemple #1
0
/**
 * db backup render start
 *
 * @since 1.2.1
 * @deprecated 2.0.0
 *
 * @package Redaxscript
 * @category Modules
 * @author Henry Ruhs
 */
function db_backup_render_start()
{
    if (LOGGED_IN == TOKEN && FIRST_PARAMETER == 'admin' && SECOND_PARAMETER == 'db-backup') {
        define('TITLE', l('database_backup', 'db_backup'));
        /* registry object */
        $registry = Redaxscript\Registry::getInstance();
        $registry->set('title', l('database_backup', 'db_backup'));
        /* config object */
        $config = Redaxscript\Config::getInstance();
        /* download database backup */
        if (THIRD_PARAMETER == 'download') {
            define('RENDER_BREAK', 1);
            db_backup($config::get('name'), 0);
        }
        /* send database backup */
        if (THIRD_PARAMETER == 'send') {
            define('CENTER_BREAK', 1);
            /* prepare body parts */
            $urlLink = anchor_element('external', '', '', ROOT, ROOT);
            $fileName = $config::get('name') . '-' . db_backup_clean_date(NOW) . '.sql';
            /* prepare mail inputs */
            $toArray = $fromArray = array(s('author') => s('email'));
            $subject = l('database_backup', 'db_backup');
            $bodyArray = array('<strong>' . l('url') . l('colon') . '</strong> ' . $urlLink, '<strong>' . l('database') . l('colon') . '</strong> ' . $config::get('name'), '<br />', '<strong>' . l('message') . l('colon') . '</strong> ' . l('save_attachment', 'db_backup') . l('point'));
            $attachmentArray = array($fileName => db_backup($config::get('name'), 1));
            /* mail object */
            $mail = new Redaxscript\Mailer($toArray, $fromArray, $subject, $bodyArray, $attachmentArray);
            $mail->send();
        }
    }
}
Exemple #2
0
function generate_backup($conn, $ext = 'no', $comm = '')
{
    $filename = db_backup($conn, $ext, $comm);
    if ($filename) {
        display_notification(_("Backup successfully generated.") . ' ' . _("Filename") . ": " . $filename);
    } else {
        display_error(_("Database backup failed."));
    }
    return $filename;
}
function db_deploy()
{
    global $dbconnects, $db_settings, $db_tools;
    $stageFile = db_backup("stage");
    $prodFile = db_backup("production");
    if (!$stageFile || !$prodFile) {
        echo "<div class='messages error'><div class='message-icon'><i class='fa fa-exclamation-triangle' /></div><div class='message'>Deployment stopped because no backups were saved.  Cannot proceed.</div></div>";
        return false;
    } else {
        $out1 = $db_tools["mysql"] . " --host=" . $db_settings['productionhost'] . " --user="******" --password="******" locator_production < ../sql-files/{$stageFile}";
        exec($out1, $output, $returncode);
        if ($returncode != 0) {
            echo "<div class='messages error'><div class='message-icon'><i class='fa fa-exclamation-triangle' /></div><div class='message'>An error occured, the stage environment could not be deployed.  No change has been made to the production environment.</div></div>";
            return false;
        } else {
            echo "<div class='messages status'><div class='message-icon'><i class='fa fa-check' /></div><div class='message'>The stage environment has been deployed to production.  Both environments have been backed up.</div></div>";
            move_files();
            return true;
        }
    }
}
Exemple #4
0
                    if (filesize($zipfile) > 0) {
                        unlink($backupFile);
                        return true;
                    } else {
                        return false;
                    }
                } else {
                    return false;
                }
            }
            return true;
        } else {
            return false;
        }
    }
    $backup = db_backup();
    if ($jobs['backup'][0] == 7) {
        $jobs['backup'][1] = $plus_week;
    } else {
        if ($jobs['backup'][0] == 30) {
            $jobs['backup'][1] = $plus_month;
        } else {
            $jobs['backup'][1] = $midnight_today;
        }
    }
    $message = $backup === true ? 'successful' : 'failed';
    doLog("Database update " . $message . " - triggered by visitor " . $displayIp);
}
if ($update == 1) {
    $new_jobs = serialize($jobs);
    yasDB_update("UPDATE `settings` SET `jobs` = '{$new_jobs}' WHERE `id` = 1");
            }
        }
    }
    return $ret;
}
$installers = get_installers();
if (get_post('Upgrade')) {
    $ret = true;
    foreach ($db_connections as $comp => $conn) {
        // connect to database
        if (!set_global_connection($comp)) {
            display_error(_("Cannot connect to database for company") . " '" . $conn['name'] . "'");
            continue;
        }
        // create security backup
        db_backup($conn, 'no', 'Security backup before upgrade', $conn['tbpref']);
        // apply all upgrade data
        foreach ($installers as $i => $inst) {
            $ret = upgrade_step($i, $conn);
            if (!$ret) {
                display_error(sprintf(_("Database upgrade to version %s failed for company '%s'."), $inst->version, $conn['name']) . '<br>' . _('You should restore company database from latest backup file'));
            }
        }
        // 		db_close($conn); ?
        if (!$ret) {
            break;
        }
    }
    set_global_connection();
    if ($ret) {
        // re-read the prefs
Exemple #6
0
<?php 
include_once "../includes/locator.php";
include_once 'log/login.php';
?>
<html>
<head>
<title>Firestone Locator | Backup on Demand</title>

</head>
<body>
<?php 
echo "<h1>Backup Process</h1>\n";
db_backup("stage");
?>
</body>


</html>
<?php 
include_once "../includes/locator.php";
include_once 'log/login.php';
?>
<html>
<head>
<title>Firestone Locator | Database Restore</title>

</head>
<body>
<?php 
echo "<h1>Restoration Process</h1>\n";
db_backup($_POST["env"]);
db_restore("../sql-files/" . $_POST["file"], $_POST["env"]);
?>
</body>


</html>
Exemple #8
0
                }
            } else {
                return false;
            }
        }
        return true;
    } else {
        return false;
    }
}
$Start = getTime();
$mem_limit = substr(ini_get("memory_limit"), 0, -1);
set_time_limit(300);
//include('backup.class.php');
if (isset($_POST['create'])) {
    $db_success = db_backup();
}
?>
<div id="center-column">
<div class="top-bar">
<h1>Cpanel - Database Backup</h1>
<div class="breadcrumbs"><a href="index.php?act=gainfo" title="Google Analytics Info">Google Analytics Login Info</a></div>
</div><br />
<div class="select-bar">
<label>
<h3>Backup Arcade Database</h3>
</label>
</div>
<div style="font-size:14px;text-align:center;">
<form id="db_backup" method="post" action="index.php?act=managedbbackup">
	<label>Create a database backup</label>
    # type: bool (true structure only)
    # droptable: bool
    # deleteall: bool
    # download: bool
    # bansonly: bool
    $user_msg = db_backup($type, $droptable, $deleteall, $download, false);
}
//create bans .sql backup
if (isset($_POST["dbbansexp"])) {
    $download = isset($_POST["download"]) ? true : false;
    # type: bool (true structure only)
    # droptable: bool
    # deleteall: bool
    # download: bool
    # bansonly: bool
    $user_msg = db_backup(false, true, false, $download, true);
}
//import banned.cfg
if (isset($_POST["bancfgupl"])) {
    $reason = mysql_real_escape_string($_POST["reason"]);
    $plnick = mysql_real_escape_string($_POST["player_nick"]);
    $server = mysql_real_escape_string($_POST["server_name"]);
    $date = explode("-", trim($_POST["ban_created"]));
    if ($reason == "" || $plnick == "" || $server == "" || $date == "" || sizeof($date) != 3) {
        $user_msg = "_NOREQUIREDFIELDS";
    } else {
        $date = (int) strtotime($date[2] . $date[1] . $date[0]);
        $file = mysql_real_escape_string($_FILES['filename']['name']);
        $types = array("cfg", "txt");
        if ($file == "") {
            $user_msg = "_FILENOFILE";