X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fuexport.php;h=c1b3dd1e4b169e7a6f5c9ca3227f2306b9fdce0e;hb=62a61a95d3e1357a64b157136490c82aa4495d3e;hp=d886e13b27f115d06d8538854e83592cfa1c72b8;hpb=63e2695d226d195c6a97e1045d6b174591dd2487;p=friendica.git diff --git a/mod/uexport.php b/mod/uexport.php index d886e13b27..c1b3dd1e4b 100644 --- a/mod/uexport.php +++ b/mod/uexport.php @@ -1,7 +1,15 @@ tab where wanted function uexport_content(App $a) { - if ($a->argc > 1) { - header("Content-type: application/json"); - header('Content-Disposition: attachment; filename="'.$a->user['nickname'].'.'.$a->argv[1].'"'); - switch($a->argv[1]) { - case "backup": uexport_all($a); killme(); break; - case "account": uexport_account($a); killme(); break; - default: - killme(); - } - } - - /** - * options shown on "Export personal data" page - * list of array( 'link url', 'link text', 'help text' ) - */ - $options = array( - array('uexport/account',t('Export account'),t('Export your account info and contacts. Use this to make a backup of your account and/or to move it to another server.')), - array('uexport/backup',t('Export all'),t('Export your accout info, contacts and all your items as json. Could be a very big file, and could take a lot of time. Use this to make a full backup of your account (photos are not exported)')), - ); - call_hooks('uexport_options', $options); - - $tpl = get_markup_template("uexport.tpl"); - return replace_macros($tpl, array( - '$baseurl' => App::get_baseurl(), - '$title' => t('Export personal data'), - '$options' => $options - )); - + if ($a->argc > 1) { + header("Content-type: application/json"); + header('Content-Disposition: attachment; filename="' . $a->user['nickname'] . '.' . $a->argv[1] . '"'); + switch ($a->argv[1]) { + case "backup": + uexport_all($a); + killme(); + break; + case "account": + uexport_account($a); + killme(); + break; + default: + killme(); + } + } + /** + * options shown on "Export personal data" page + * list of array( 'link url', 'link text', 'help text' ) + */ + $options = [ + ['uexport/account', L10n::t('Export account'), L10n::t('Export your account info and contacts. Use this to make a backup of your account and/or to move it to another server.')], + ['uexport/backup', L10n::t('Export all'), L10n::t("Export your accout info, contacts and all your items as json. Could be a very big file, and could take a lot of time. Use this to make a full backup of your account \x28photos are not exported\x29")], + ]; + Addon::callHooks('uexport_options', $options); + + $tpl = get_markup_template("uexport.tpl"); + return replace_macros($tpl, [ + '$baseurl' => System::baseUrl(), + '$title' => L10n::t('Export personal data'), + '$options' => $options + ]); } function _uexport_multirow($query) { - $result = array(); + $result = []; $r = q($query); -// if (dbm::is_result($r)) { - if ($r){ - foreach($r as $rr){ - $p = array(); - foreach($rr as $k => $v) + if (DBM::is_result($r)) { + foreach ($r as $rr) { + $p = []; + foreach ($rr as $k => $v) { $p[$k] = $v; - $result[] = $p; - } + } + $result[] = $p; + } } - return $result; + return $result; } function _uexport_row($query) { - $result = array(); + $result = []; $r = q($query); - if ($r) { - foreach($r as $rr) - foreach($rr as $k => $v) + if (DBM::is_result($r)) { + foreach ($r as $rr) { + foreach ($rr as $k => $v) { $result[$k] = $v; - + } + } } - return $result; + return $result; } - -function uexport_account($a){ +function uexport_account($a) { $user = _uexport_row( - sprintf( "SELECT * FROM `user` WHERE `uid` = %d LIMIT 1", intval(local_user()) ) + sprintf("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1", intval(local_user())) ); $contact = _uexport_multirow( - sprintf( "SELECT * FROM `contact` WHERE `uid` = %d ",intval(local_user()) ) + sprintf("SELECT * FROM `contact` WHERE `uid` = %d ", intval(local_user())) + ); + + + $profile = _uexport_multirow( + sprintf("SELECT * FROM `profile` WHERE `uid` = %d ", intval(local_user())) ); + $photo = _uexport_multirow( + sprintf("SELECT * FROM `photo` WHERE uid = %d AND profile = 1", intval(local_user())) + ); + foreach ($photo as &$p) { + $p['data'] = bin2hex($p['data']); + } - $profile =_uexport_multirow( - sprintf( "SELECT * FROM `profile` WHERE `uid` = %d ", intval(local_user()) ) + $pconfig = _uexport_multirow( + sprintf("SELECT * FROM `pconfig` WHERE uid = %d", intval(local_user())) ); - $photo = _uexport_multirow( - sprintf( "SELECT * FROM `photo` WHERE uid = %d AND profile = 1", intval(local_user()) ) - ); - foreach ($photo as &$p) $p['data'] = bin2hex($p['data']); - - $pconfig = _uexport_multirow( - sprintf( "SELECT * FROM `pconfig` WHERE uid = %d",intval(local_user()) ) - ); - - $group = _uexport_multirow( - sprintf( "SELECT * FROM `group` WHERE uid = %d",intval(local_user()) ) - ); - - $group_member = _uexport_multirow( - sprintf( "SELECT * FROM `group_member` WHERE uid = %d",intval(local_user()) ) - ); - - $output = array( - 'version' => FRIENDICA_VERSION, - 'schema' => DB_UPDATE_VERSION, - 'baseurl' => App::get_baseurl(), - 'user' => $user, - 'contact' => $contact, - 'profile' => $profile, - 'photo' => $photo, - 'pconfig' => $pconfig, - 'group' => $group, - 'group_member' => $group_member, - ); - - //echo "
"; var_dump(json_encode($output)); killme();
-	echo json_encode($output);
+	$group = _uexport_multirow(
+		sprintf("SELECT * FROM `group` WHERE uid = %d", intval(local_user()))
+	);
+
+	$group_member = _uexport_multirow(
+		sprintf("SELECT `group_member`.`gid`, `group_member`.`contact-id` FROM `group_member` INNER JOIN `group` ON `group`.`id` = `group_member`.`gid` WHERE `group`.`uid` = %d", intval(local_user()))
+	);
 
+	$output = [
+		'version' => FRIENDICA_VERSION,
+		'schema' => DB_UPDATE_VERSION,
+		'baseurl' => System::baseUrl(),
+		'user' => $user,
+		'contact' => $contact,
+		'profile' => $profile,
+		'photo' => $photo,
+		'pconfig' => $pconfig,
+		'group' => $group,
+		'group_member' => $group_member,
+	];
+
+	//echo "
"; var_dump(json_encode($output)); killme();
+	echo json_encode($output, JSON_PARTIAL_OUTPUT_ON_ERROR);
 }
 
 /**
@@ -129,29 +141,24 @@ function uexport_all(App $a) {
 	uexport_account($a);
 	echo "\n";
 
+	$total = 0;
 	$r = q("SELECT count(*) as `total` FROM `item` WHERE `uid` = %d ",
 		intval(local_user())
 	);
-	if (dbm::is_result($r))
+	if (DBM::is_result($r)) {
 		$total = $r[0]['total'];
-
+	}
 	// chunk the output to avoid exhausting memory
 
-	for($x = 0; $x < $total; $x += 500) {
-		$item = array();
+	for ($x = 0; $x < $total; $x += 500) {
+		$item = [];
 		$r = q("SELECT * FROM `item` WHERE `uid` = %d LIMIT %d, %d",
 			intval(local_user()),
 			intval($x),
 			intval(500)
 		);
-		/*if (dbm::is_result($r)) {
-			foreach($r as $rr)
-				foreach($rr as $k => $v)
-					$item[][$k] = $v;
-		}*/
-
-		$output = array('item' => $r);
-		echo json_encode($output)."\n";
-	}
 
+		$output = ['item' => $r];
+		echo json_encode($output, JSON_PARTIAL_OUTPUT_ON_ERROR). "\n";
+	}
 }