class.dc.export.flat.php @ 1559:b6601f74bcd2

Visit:

Revision 1559:b6601f74bcd2, 7.4 KB checked in by Anne Kozlika <kozlika@…>, 12 years ago (diff)
Import/Export? enhancements.

Rev	Line
[0]	1	<?php
	2	# -- BEGIN LICENSE BLOCK ---------------------------------------
	3	#
[840]	4	# This file is part of importExport, a plugin for DotClear2.
[0]	5	#
[840]	6	# Copyright (c) 2003-2012 Olivier Meunier & Association Dotclear
[0]	7	# Licensed under the GPL version 2.0 license.
	8	# See LICENSE file or
	9	# http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
	10	#
	11	# -- END LICENSE BLOCK -----------------------------------------
	12	if (!defined('DC_RC_PATH')) { return; }
	13
	14	class dcExportFlat extends dcIeModule
	15	{
	16	public function setInfo()
	17	{
[840]	18	$this->type = 'export';
[0]	19	$this->name = __('Flat file export');
	20	$this->description = __('Exports a blog or a full Dotclear installation to flat file.');
	21	}
	22
	23	public function process($do)
	24	{
	25	# Export a blog
	26	if ($do == 'export_blog' && $this->core->auth->check('admin',$this->core->blog->id))
	27	{
	28	$fullname = $this->core->blog->public_path.'/.backup_'.sha1(uniqid());
	29	$blog_id = $this->core->con->escape($this->core->blog->id);
	30
	31	try
	32	{
[840]	33	$exp = new flatExport($this->core->con,$fullname,$this->core->prefix);
[0]	34	fwrite($exp->fp,'///DOTCLEAR\|'.DC_VERSION."\|single\n");
	35
	36	$exp->export('category',
	37	'SELECT * FROM '.$this->core->prefix.'category '.
	38	"WHERE blog_id = '".$blog_id."'"
	39	);
	40	$exp->export('link',
	41	'SELECT * FROM '.$this->core->prefix.'link '.
	42	"WHERE blog_id = '".$blog_id."'"
	43	);
	44	$exp->export('setting',
	45	'SELECT * FROM '.$this->core->prefix.'setting '.
	46	"WHERE blog_id = '".$blog_id."'"
	47	);
	48	$exp->export('post',
	49	'SELECT * FROM '.$this->core->prefix.'post '.
	50	"WHERE blog_id = '".$blog_id."'"
	51	);
	52	$exp->export('meta',
	53	'SELECT meta_id, meta_type, M.post_id '.
	54	'FROM '.$this->core->prefix.'meta M, '.$this->core->prefix.'post P '.
	55	'WHERE P.post_id = M.post_id '.
	56	"AND P.blog_id = '".$blog_id."'"
	57	);
	58	$exp->export('media',
	59	'SELECT * FROM '.$this->core->prefix."media WHERE media_path = '".
	60	$this->core->con->escape($this->core->blog->settings->system->public_path)."'"
	61	);
	62	$exp->export('post_media',
	63	'SELECT media_id, M.post_id '.
	64	'FROM '.$this->core->prefix.'post_media M, '.$this->core->prefix.'post P '.
	65	'WHERE P.post_id = M.post_id '.
	66	"AND P.blog_id = '".$blog_id."'"
	67	);
	68	$exp->export('ping',
	69	'SELECT ping.post_id, ping_url, ping_dt '.
	70	'FROM '.$this->core->prefix.'ping ping, '.$this->core->prefix.'post P '.
	71	'WHERE P.post_id = ping.post_id '.
	72	"AND P.blog_id = '".$blog_id."'"
	73	);
	74	$exp->export('comment',
	75	'SELECT C.* '.
	76	'FROM '.$this->core->prefix.'comment C, '.$this->core->prefix.'post P '.
	77	'WHERE P.post_id = C.post_id '.
	78	"AND P.blog_id = '".$blog_id."'"
	79	);
	80
	81	# --BEHAVIOR-- exportSingle
	82	$this->core->callBehavior('exportSingle',$this->core,$exp,$blog_id);
	83
	84	$_SESSION['export_file'] = $fullname;
	85	$_SESSION['export_filename'] = $_POST['file_name'];
[840]	86	$_SESSION['export_filezip'] = !empty($_POST['file_zip']);
[0]	87	http::redirect($this->getURL().'&do=ok');
	88	}
	89	catch (Exception $e)
	90	{
	91	@unlink($fullname);
	92	throw $e;
	93	}
	94	}
	95
	96	# Export all content
	97	if ($do == 'export_all' && $this->core->auth->isSuperAdmin())
	98	{
	99	$fullname = $this->core->blog->public_path.'/.backup_'.sha1(uniqid());
	100	try
	101	{
[840]	102	$exp = new flatExport($this->core->con,$fullname,$this->core->prefix);
[0]	103	fwrite($exp->fp,'///DOTCLEAR\|'.DC_VERSION."\|full\n");
	104	$exp->exportTable('blog');
	105	$exp->exportTable('category');
	106	$exp->exportTable('link');
	107	$exp->exportTable('setting');
	108	$exp->exportTable('user');
[233]	109	$exp->exportTable('pref');
[0]	110	$exp->exportTable('permissions');
	111	$exp->exportTable('post');
	112	$exp->exportTable('meta');
	113	$exp->exportTable('media');
	114	$exp->exportTable('post_media');
	115	$exp->exportTable('log');
	116	$exp->exportTable('ping');
	117	$exp->exportTable('comment');
	118	$exp->exportTable('spamrule');
	119	$exp->exportTable('version');
	120
	121	# --BEHAVIOR-- exportFull
	122	$this->core->callBehavior('exportFull',$this->core,$exp);
	123
	124	$_SESSION['export_file'] = $fullname;
	125	$_SESSION['export_filename'] = $_POST['file_name'];
[840]	126	$_SESSION['export_filezip'] = !empty($_POST['file_zip']);
[0]	127	http::redirect($this->getURL().'&do=ok');
	128	}
	129	catch (Exception $e)
	130	{
	131	@unlink($fullname);
	132	throw $e;
	133	}
	134	}
	135
	136	# Send file content
	137	if ($do == 'ok')
	138	{
	139	if (!file_exists($_SESSION['export_file'])) {
	140	throw new Exception(__('Export file not found.'));
	141	}
	142
	143	ob_end_clean();
[840]	144
	145	if (substr($_SESSION['export_filename'],-4) == '.zip') {
	146	$_SESSION['export_filename'] = substr($_SESSION['export_filename'],0,-4);//.'.txt';
	147	}
	148
	149	# Flat export
	150	if (empty($_SESSION['export_filezip'])) {
	151
	152	header('Content-Disposition: attachment;filename='.$_SESSION['export_filename']);
	153	header('Content-Type: text/plain; charset=UTF-8');
	154	readfile($_SESSION['export_file']);
	155
	156	unlink($_SESSION['export_file']);
	157	unset($_SESSION['export_file'],$_SESSION['export_filename'],$_SESSION['export_filezip']);
	158	exit;
	159	}
	160	# Zip export
	161	else {
	162	try
	163	{
	164	$file_zipname = $_SESSION['export_filename'].'.zip';
	165
	166	$fp = fopen('php://output','wb');
	167	$zip = new fileZip($fp);
	168	$zip->addFile($_SESSION['export_file'],$_SESSION['export_filename']);
	169
	170	header('Content-Disposition: attachment;filename='.$file_zipname);
	171	header('Content-Type: application/x-zip');
	172
	173	$zip->write();
	174
	175	unlink($_SESSION['export_file']);
	176	unset($zip,$_SESSION['export_file'],$_SESSION['export_filename'],$file_zipname);
	177	exit;
	178	}
	179	catch (Exception $e)
	180	{
	181	unset($zip,$_SESSION['export_file'],$_SESSION['export_filename'],$file_zipname);
	182	@unlink($_SESSION['export_file']);
	183
	184	throw new Exception(__('Failed to compress export file.'));
	185	}
	186	}
[0]	187	}
	188	}
	189
	190	public function gui()
	191	{
	192	echo
[1499]	193	'<form action="'.$this->getURL(true).'" method="post" class="fieldset">'.
	194	'<h3>'.__('Single blog').'</h3>'.
[1559]	195	'<p>'.sprintf(__('This will create an export of your current blog: %s'),'<strong>'.html::escapeHTML($this->core->blog->name)).'</strong>.</p>'.
[840]	196
	197	'<p><label for="file_name">'.__('File name:').'</label>'.
	198	form::field(array('file_name','file_name'),50,255,date('Y-m-d-').html::escapeHTML($this->core->blog->id.'-backup.txt')).
	199	'</p>'.
	200
	201	'<p><label for="file_zip" class="classic">'.
	202	form::checkbox(array('file_zip','file_zip'),1).' '.
	203	__('Compress file').'</label>'.
	204	'</p>'.
	205
	206	'<p class="zip-dl"><a href="media.php?d=&zipdl=1">'.
	207	__('You may also want to download your media directory as a zip file').'</a></p>'.
	208
	209	'<p><input type="submit" value="'.__('Export').'" />'.
[0]	210	form::hidden(array('do'),'export_blog').
	211	$this->core->formNonce().'</p>'.
[840]	212
	213	'</form>';
[0]	214
	215	if ($this->core->auth->isSuperAdmin())
	216	{
	217	echo
[1499]	218	'<form action="'.$this->getURL(true).'" method="post" class="fieldset">'.
	219	'<h3>'.__('Multiple blogs').'</h3>'.
[840]	220	'<p>'.__('This will create an export of all the content of your database.').'</p>'.
	221
	222	'<p><label for="file_name2">'.__('File name:').'</label>'.
	223	form::field(array('file_name','file_name2'),50,255,date('Y-m-d-').'dotclear-backup.txt').
	224	'</p>'.
	225
	226	'<p><label for="file_zip2" class="classic">'.
	227	form::checkbox(array('file_zip','file_zip2'),1).' '.
	228	__('Compress file').'</label>'.
	229	'</p>'.
	230
	231	'<p><input type="submit" value="'.__('Export').'" />'.
[0]	232	form::hidden(array('do'),'export_all').
	233	$this->core->formNonce().'</p>'.
[840]	234
	235	'</form>';
[0]	236	}
	237	}
	238	}
	239	?>

Note: See TracBrowser for help on using the repository browser.

Dotclear

Context Navigation

source: plugins/importExport/inc/class.dc.export.flat.php @ 1559:b6601f74bcd2

Download in other formats:

Sites map