CMS Made Simple Forums

Code: Select all

$command = sprintf(
'%s --user=%s --password=%s  %s %s>>%s 2>%s',
$executable,
$config['db_username'],
$config['db_password'],
$options,
$config['db_name'],
$output_file,
$output_capture );

Code: Select all

// Start Der Rudi mod
$tb_prfx = str_replace("_", "\_", $config['db_prefix']);     //Get prefix set in config.php and escape the '_'
$db =& $this->cms->GetDb();
$query = "SHOW TABLES LIKE '".$tb_prfx."%'";     //get all tables that match prefix
$result=$db->Execute($query);
if ($result) {
    $tables='';
    while ($dbr = $result->FetchRow()) {
        $tabarr = array_values($dbr);
        $tables .= "'".$tabarr[0]."' ";      //build list of table names to backup
    }
}
else {
    echo 'Error fetching table names';
    return;
}
$result->Close();
$tables = rtrim($tables);     //remove trailing space

$command = sprintf(
'%s --user=%s --password=%s %s %s %s>>%s 2>%s',     //added tables section
$executable,
$config['db_username'],
$config['db_password'],
$options,
$config['db_name'],
$tables,      //added Der Rudi
$output_file,
$output_capture );
// End Der Rudi mod