scheduled.php

<?php
/*
+--------------------------------------------------------------------------+
| phpMyBackupPro                                                           |
+--------------------------------------------------------------------------+
| Copyright (c) 2004-2015 by Dirk Randhahn                                 |
| http://www.phpMyBackupPro.net                                            |
| version information can be found in definitions.php.                     |
|                                                                          |
| This program is free software; you can redistribute it and/or            |
| modify it under the terms of the GNU General Public License              |
| as published by the Free Software Foundation; either version 2           |
| of the License, or (at your option) any later version.                   |
|                                                                          |
| This program is distributed in the hope that it will be useful,          |
| but WITHOUT ANY WARRANTY; without even the implied warranty of           |
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the            |
| GNU General Public License for more details.                             |
|                                                                          |
| You should have received a copy of the GNU General Public License        |
| along with this program; if not, write to the Free Software              |
| Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307,USA.|
+--------------------------------------------------------------------------+
 */

require_once "login.php";

// used variables
if (!isset($_POST['db'])) {
    $_POST['db'] = false;
}

if (!isset($_POST['tables'])) {
    $_POST['tables'] = false;
}

if (!isset($_POST['data'])) {
    $_POST['data'] = false;
}

if (!isset($_POST['zip'])) {
    $_POST['zip'] = false;
}

if (!isset($_POST['drop'])) {
    $_POST['drop'] = false;
}

if (!isset($_POST['man_dirs'])) {
    $_POST['man_dirs'] = false;
}

if (!isset($_POST['comments'])) {
    $_POST['comments'] = false;
}

if (!isset($_POST['packed'])) {
    $_POST['packed'] = false;
}

PMBP_print_header(preg_replace("#.*/#", "", $_SERVER['SCRIPT_NAME']));

// if first use or no db-connection possible
if (!PMBP_mysql_connect()) {
    echo PMBP_addOutput(I_SQL_ERROR, "red");
}

// check if a db or directory was posted
if (isset($_POST['dirs'])) {
    if (is_array($_POST['db']) || is_array($_POST['dirs']) || $_POST['man_dirs']) {
        $selection_ok = true;
    } else {
        $selection_ok = false;
    }

} elseif ($_POST['man_dirs']) {
    $selection_ok = true;
} elseif (isset($_POST['db'])) {
    if (is_array($_POST['db'])) {
        $selection_ok = true;
    } else {
        $selection_ok = false;
    }

} elseif (isset($_POST)) {
    $selection_ok = false;
}

// generate and print php script
if ($selection_ok) {

    $cmp = 0;
    $pos = 0;
    while ($cmp == 0) {
        $cmp = strncasecmp($_POST['path'], $_SERVER['DOCUMENT_ROOT'], ++$pos);
    }
//    echo $_POST['path'];
    //    echo $_POST['path']= substr($_POST['path'],$pos-1);
    //    echo $_POST['path']= substr($_SERVER['DOCUMENT_ROOT'],$pos-1);

    // create path to scheduled.php
    //    $path_back="";
    //    if (strstr($_SERVER['SCRIPT_NAME'],"\\")) $delimiter="\\"; else $delimiter="/";
    //    $script_path=explode($delimiter,$_SERVER['SCRIPT_NAME']);
    //    $path_d=count(explode("..",$_POST['path']))-1;
    //    $path_u=count(explode($delimiter,$_POST['path']))-$path_d-1;
    //    for ($i=0;$i<$path_u;$i++) $path_back.="../";
    //    for ($i=count($script_path)-$path_d-1;$i<count($script_path)-1;$i++) $path_back.=$script_path[$i]."/";
    //
    //    // set sql server in multi server mode
    //    if (count($CONF['sql_passwd_s'])) {
    //        if ($CONF['sql_host']==$_SESSION['sql_host_org'] && $CONF['sql_user']==$_SESSION['sql_user_org']) {
    //            $_POST['mysql_host']=-1;
    //        } else {
    //            for($i=0;$i<count($CONF['sql_passwd_s']);$i++) {
    //                if ($CONF['sql_host']==$CONF['sql_host_s'][$i] && $CONF['sql_user']==$CONF['sql_user_s'][$i]) $_POST['mysql_host']=$i;
    //            }
    //        }
    //    }

    // generate the dynamic php script
    $result = "<?php\n";
    $result .= "// This script was created by phpMyBackupPro " . PMBP_VERSION . " (" . PMBP_WEBSITE . ")\n";
    $result .= "// In order to work probably, it must be saved in the directory " . $_POST['path'] . ".\n";

    // list dbs
    if (is_array($_POST['db'])) {
        $result .= "\$_POST['db']=array(";
        foreach ($_POST['db'] as $value) {
            $result .= "\"" . $value . "\", ";
        }

        $result .= ");\n";
    }

    // list directories
    if (isset($_POST['dirs'])) {
        $result .= "\$_POST['dirs']=array(";
        foreach ($_POST['dirs'] as $value) {
            $result .= "\"" . $value . "\", ";
        }

        $result .= ");\n";
    }

    // print the backup options
    foreach ($_POST as $key => $value) {
        $value = str_replace("\"", "'", $value);
        if ($key != "period" && $key != "path" && $key != "db" && $key != "dirs" && $key != "filename" && $value != '') {
            $result .= "\$_POST['" . $key . "']=\"" . $value . "\";\n";
        }

    }

    // print the current working database (but always only once)
    if (isset($_SESSION['wss']) && !isset($_POST['mysql_host'])) {
        $result .= "\$_POST['mysql_host']=\"" . $_SESSION['wss'] . "\";\n";
    }

    // add include(backup.php) to do all the work
    $result .= "\$period=(3600*24)" . str_replace(array(';', '$', '+'), '', $_POST['period']) . ";\n";
    $result .= "\$security_key=\"" . ($PMBP_SYS_VAR['security_key']) . "\";\n";
    $result .= "// switch to the phpMyBackupPro " . PMBP_VERSION . " directory\n";
    // $result .= "@chdir(\"" . $_SERVER['DOCUMENT_ROOT'] . "\");\n";
    $result .= "@include(\"backup.php\");\n";
    $result .= "// switch back to the directory containing this script\n";
    $result .= "@chdir(\"" . $_POST['path'] . "\");\n";
    $result .= "?>";

    // show the generated php script
    printf(PMBP_EXS_INCL, $_POST['path'] . "???.php");
    echo ":\n<br><textarea name=\"code\" rows=\"16\" cols=\"120\" readOnly>" . $result . "</textarea>\n<br><br>";
    echo "<form name=\"save\" action=\"scheduled.php\" method=\"post\">\n";

    // list all post variables as hidden fields
    foreach ($_POST as $key => $value) {
        if ($key != "db" && $key != "dirs") {
            echo "<input type=\"hidden\" name=\"" . $key . "\" value=\"" . $value . "\">\n";
        } elseif (is_array($_POST[$key])) {
            foreach ($value as $dbname) {
                echo "<input type=\"hidden\" name=\"" . $key . "[]\" value=\"" . $dbname . "\">\n";
            }
        }

    }

    // save file including the backup script
    if (isset($_POST['filename'])) {
        if (PMBP_save_to_file($_POST['path'] . $_POST['filename'], "", $result, "w")) {
            echo PMBP_addOutput(EX_SAVED . " " . $_POST['path'] . $_POST['filename'], "green_left");
            @chmod($_POST['path'] . $_POST['filename'], 0644);

            // save specific settings for scheduled backups
            if ($PMBP_SYS_VAR['EXS_scheduled_file'] != $_POST['filename']) {
                $PMBP_SYS_VAR['EXS_scheduled_file'] = $_POST['filename'];
            }

        } else {
            echo PMBP_addOutput(C_WRITE . " " . $_POST['path'] . $_POST['filename'], "red_left");
        }
    }
    echo PMBP_EXS_SAVE . ":<br>\n";
    echo $_POST['path'] . "<input type=\"text\" name=\"filename\" value=\"" . $PMBP_SYS_VAR['EXS_scheduled_file'] . "\">&nbsp;";
    echo "<input type=\"submit\" value=\"" . C_SAVE . "\">";
    if ($PMBP_SYS_VAR['EXS_scheduled_file'] != "???.php") {
        echo " (<a href=\"\">" . PMBP_pop_up("get_file.php?view=" . $_POST['path'] . $PMBP_SYS_VAR['EXS_scheduled_file'], B_VIEW, "view") . "</a>)";
    }

    echo "</form>";
    echo "\n<a href=\"scheduled.php\"> <- " . EXS_BACK . "</a>\n";

    // update specific settings for scheduled backups
    if ($_POST['path'] != $PMBP_SYS_VAR['EXS_scheduled_dir'] or $_POST['period'] != $PMBP_SYS_VAR['EXS_period']) {
        $PMBP_SYS_VAR['EXS_scheduled_dir'] = $_POST['path'];
        $PMBP_SYS_VAR['EXS_period'] = $_POST['period'];
    }

    // save PMBP_SYS_VARS
    PMBP_save_export_settings();

// print instructions and export form
} else {
    if (isset($selection_ok) && isset($_POST['period'])) {
        echo PMBP_addOutput(EX_NO_DB . "!", "red");
    }

    echo "<form name=\"backup\" action=\"scheduled.php\" method=\"post\">\n<div>\n";
    echo EXS_PERIOD . ":<br>\n";
    echo "<select name=\"period\">\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "*0") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"*0\"" . $selected . ">" . PMBP_EXS_ALWAYS . "</option>\n";
    echo "<option>---------------------</option>\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "/24") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"/24\"" . $selected . ">1 " . EXS_HOUR . "</option>\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "/4") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"/4\"" . $selected . ">6 " . EXS_HOURS . "</option>\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "/2") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"/2\"" . $selected . ">12 " . EXS_HOURS . "</option>\n";
    echo "<option>---------------------</option>\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "*1") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"*1\"" . $selected . ">1 " . EXS_DAY . "</option>\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "*2") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"*2\"" . $selected . ">2 " . EXS_DAYS . "</option>\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "*3") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"*3\"" . $selected . ">3 " . EXS_DAYS . "</option>\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "*5") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"*5\"" . $selected . ">5 " . EXS_DAYS . "</option>\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "*10") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"*10\"" . $selected . ">10 " . EXS_DAYS . "</option>\n";
    echo "<option>---------------------</option>\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "*7") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"*7\"" . $selected . ">1 " . EXS_WEEK . "</option>\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "*14") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"*14\"" . $selected . ">2 " . EXS_WEEKS . "</option>\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "*21") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"*21\"" . $selected . ">3 " . EXS_WEEKS . "</option>\n";
    echo "<option>---------------------</option>\n";
    if ($PMBP_SYS_VAR['EXS_period'] == "*30") {
        $selected = " selected";
    } else {
        $selected = "";
    }

    echo "<option value=\"*30\"" . $selected . ">1 " . EXS_MONTH . " (30 " . EXS_DAYS . ")</option>\n";
    echo "</select>\n<br><br>";

    // get content of these directories (I know, it's partly redundant - but I think this is necessary)
    if ($_SESSION['multi_user_mode']) {
        $search_path1 = $PMBP_MU_CONF['user_export_dir'];
        $search_path2 = $PMBP_MU_CONF['user_scheduled_dir'];
    } else {
        $search_path1 = substr($_SERVER['DOCUMENT_ROOT'], 0, strrpos($_SERVER['DOCUMENT_ROOT'], "/"));
        $search_path2 = substr($search_path1, 0, strrpos($search_path1, "/"));
        $search_path1 .= "/";
//        $search_path1=$_SERVER['DOCUMENT_ROOT']."/"."../";
        //        $search_path2=$_SERVER['DOCUMENT_ROOT']."/"."../../";
    }
    if ($PMBP_SYS_VAR['dir_lists'] >= 1) {
        $dirs1 = PMBP_get_dirs($search_path1);
    }
    if ($PMBP_SYS_VAR['dir_lists'] >= 2) {
        $dirs2 = PMBP_get_dirs($search_path2);
    }

    echo EXS_PATH . ": (<a href=\"scheduled.php?update_dir_list=TRUE\">" . PMBP_EXS_UPDATE_DIRS . "</a>)<br>\n";
    echo "<select name=\"path\">\n";
    //echo "      <option value=\"/\" selected>./</option>\n";
    if (isset($dirs1)) {
        foreach ($dirs1 as $value) {
            if ($PMBP_SYS_VAR['EXS_scheduled_dir'] == $search_path1 . $value) {
                echo "<option value=\"" . $search_path1 . $value . "\" selected>" . $search_path1 . $value . "</option>\n";
            } else {
                echo "<option value=\"" . $search_path1 . $value . "\">" . $search_path1 . $value . "</option>\n";
            }
        }
    }
    if (isset($dirs2)) {
        echo "<option value=\"\">----------------------------</option>\n";
        foreach ($dirs2 as $value) {
            if ($PMBP_SYS_VAR['EXS_scheduled_dir'] == $search_path1 . $value) {
                echo "<option value=\"" . $search_path2 . $value . "\" selected>" . $search_path2 . $value . "</option>\n";
            } else {
                echo "<option value=\"" . $search_path2 . $value . "\">" . $search_path2 . $value . "</option>\n";
            }
        }
    }
    echo "</select>\n<br><br>";

    // include the export form (known from the export page) and submitt the file list
    if (isset($dirs1)) {
        PMBP_print_export_form($dirs1, true);
    } else {
        PMBP_print_export_form(false, true);
    }

    echo "\n<input type=\"submit\" value=\"" . EXS_SHOW . "\" class=\"button\">\n</div>\n</form>";
}

PMBP_print_footer();