ifthd->member['acp']['tools_backup'] )
{
$this->ifthd->skin->error('no_perm');
}
$this->ifthd->skin->set_section( 'Tools & Maintenance' );
$this->ifthd->skin->set_description( 'Run maintenance utilities, recount functions, cleaning utilities and backup functions.' );
switch( $this->ifthd->input['code'] )
{
case 'full':
$this->show_full();
break;
case 'sql':
$this->show_sql();
break;
case 'file':
$this->show_file();
break;
case 'dofull':
$this->do_full();
break;
case 'dosql':
$this->do_sql();
break;
case 'dofile':
$this->do_file();
break;
default:
$this->show_full();
break;
}
}
#=======================================
# @ Show Full
# Show the full backup page.
#=======================================
function show_full()
{
#=============================
# Do Output
#=============================
$this->output = "Full Backup
A full backup is a backup of all the files in the Trellis Desk directory, along with a backup of the SQL database. To perform a full backup backup, simply select your desired options below and then click Backup.
";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Tools",
"Backup",
"SQL Backup",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Backups & Updates' ) );
}
#=======================================
# @ Show SQL
# Show the SQL backup page.
#=======================================
function show_sql()
{
#=============================
# Do Output
#=============================
$this->output = "SQL Backup
To perform an SQL backup, simply select your desired options below and then click Backup.
";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Tools",
"Backup",
"SQL Backup",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Backups & Updates' ) );
}
#=======================================
# @ Show File
# Show the file backup page.
#=======================================
function show_file()
{
#=============================
# Do Output
#=============================
$this->output = "File Backup
To perform a file backup, simply click the Backup button below. This will take all the files and folders in the Trellis Desk directory and zips them.
";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Tools",
"Backup",
"File Backup",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Backups & Updates' ) );
}
#=======================================
# @ Do Full
# Perform a full backup.
#=======================================
function do_full()
{
if ( $this->ifthd->input['td_tables'] )
{
$tables = array(
DB_PRE .'announcements' => 1,
DB_PRE .'articles' => 1,
DB_PRE .'article_rate' => 1,
DB_PRE .'asessions' => 1,
DB_PRE .'attachments' => 1,
DB_PRE .'canned' => 1,
DB_PRE .'categories' => 1,
DB_PRE .'comments' => 1,
DB_PRE .'departments' => 1,
DB_PRE .'depart_fields' => 1,
DB_PRE .'groups' => 1,
DB_PRE .'languages' => 1,
DB_PRE .'logs' => 1,
DB_PRE .'members' => 1,
DB_PRE .'news_comments' => 1,
DB_PRE .'pages' => 1,
DB_PRE .'profile_fields' => 1,
DB_PRE .'replies' => 1,
DB_PRE .'reply_rate' => 1,
DB_PRE .'sessions' => 1,
DB_PRE .'settings' => 1,
DB_PRE .'settings_groups' => 1,
DB_PRE .'skins' => 1,
DB_PRE .'tickets' => 1,
DB_PRE .'tokens' => 1,
DB_PRE .'upg_history' => 1,
DB_PRE .'validation' => 1,
);
}
$backup = $this->ifthd->core->db->get_backup( $tables, $this->ifthd->input['drop_table'], $this->ifthd->input['if_not_exists'] );
if ( $this->ifthd->input['gzip'] )
{
$tmp_file = tempnam( HD_PATH .'core/tmp', 'sqlb_' ) .'.gz';
$sql_file = 'sql_backup_td.sql.gz';
$handle = gzopen( $tmp_file, 'w9' );
gzwrite( $handle, $backup );
gzclose( $handle );
$f_tmp = @fopen( $tmp_file, 'r');
$sql_data = @fread( $f_tmp, filesize( $tmp_file ) );
fclose( $f_tmp );
unlink( $tmp_file );
}
else
{
$sql_file = 'sql_backup_td.sql';
$sql_data = $backup;
}
require_once HD_INC .'class_zip.php';
$this->zip = new zipfile();
$this->zip_add_dir( HD_PATH );
$this->zip->addFile( $sql_data, $sql_file );
$zip_content = $this->zip->file();
header('Content-type: application/zip');
header('Content-length: ' . strlen( $zip_content ));
header('Content-Disposition: attachment; filename="full_backup_td.zip"');
print $zip_content;
}
#=======================================
# @ Do SQL
# Perform an SQL database backup.
#=======================================
function do_sql()
{
if ( $this->ifthd->input['gzip'] )
{
header('Content-type: application/x-gzip gz tgz');
header('Content-Disposition: attachment; filename="sql_backup_td.sql.gz"');
}
else
{
header('Content-type: application/sql');
header('Content-Disposition: attachment; filename="sql_backup_td.sql"');
}
if ( $this->ifthd->input['td_tables'] )
{
$tables = array(
DB_PRE .'announcements' => 1,
DB_PRE .'articles' => 1,
DB_PRE .'article_rate' => 1,
DB_PRE .'asessions' => 1,
DB_PRE .'attachments' => 1,
DB_PRE .'canned' => 1,
DB_PRE .'categories' => 1,
DB_PRE .'comments' => 1,
DB_PRE .'departments' => 1,
DB_PRE .'depart_fields' => 1,
DB_PRE .'groups' => 1,
DB_PRE .'languages' => 1,
DB_PRE .'logs' => 1,
DB_PRE .'members' => 1,
DB_PRE .'news_comments' => 1,
DB_PRE .'pages' => 1,
DB_PRE .'profile_fields' => 1,
DB_PRE .'replies' => 1,
DB_PRE .'reply_rate' => 1,
DB_PRE .'sessions' => 1,
DB_PRE .'settings' => 1,
DB_PRE .'settings_groups' => 1,
DB_PRE .'skins' => 1,
DB_PRE .'tickets' => 1,
DB_PRE .'tokens' => 1,
DB_PRE .'upg_history' => 1,
DB_PRE .'validation' => 1,
);
}
$backup = $this->ifthd->core->db->get_backup( $tables, $this->ifthd->input['drop_table'], $this->ifthd->input['if_not_exists'] );
if ( $this->ifthd->input['gzip'] )
{
$tmp_file = tempnam( HD_PATH .'core/tmp', 'sqlb_' ) .'.gz';
$handle = gzopen( $tmp_file, 'w9' );
gzwrite( $handle, $backup );
gzclose( $handle );
readgzfile( $tmp_file );
unlink( $tmp_file );
}
else
{
print $backup;
}
}
#=======================================
# @ Do File
# Perform a file backup.
#=======================================
function do_file()
{
require_once HD_INC .'class_zip.php';
$this->zip = new zipfile();
$this->zip_add_dir( HD_PATH );
$zip_content = $this->zip->file();
header('Content-type: application/zip');
header('Content-length: ' . strlen( $zip_content ));
header('Content-Disposition: attachment; filename="file_backup_td.zip"');
print $zip_content;
}
#=======================================
# @ Zip Add Directory
# Adds a directory and its content to
# the zip file.
#=======================================
function zip_add_dir($dir, $extdir="")
{
if ( $handle = opendir( $dir ) )
{
while ( ( $file = readdir($handle) ) !== false )
{
if ( $file != "." && $file != ".." )
{
if ( ! is_dir( $dir . $file ) )
{
$f_tmp = @fopen( $dir . $file, 'r');
if( $f_tmp )
{
$file_data = @fread( $f_tmp, filesize( $dir . $file ) );
$this->zip->addFile( $file_data, $extdir . $file );
fclose( $f_tmp );
}
}
else
{
$this->zip_add_dir( $dir . $file .'/', $extdir . $file .'/' );
}
}
}
closedir($handle);
}
}
}
?>