X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fuexport.php;h=e1fb22855a6066fa8b99336b837f29ef9ebbb0ea;hb=2aa23843e401e7f448c3d12f844934da6c27f8ef;hp=423c3a82fa137c1d7d86b8f50005947d198a2f45;hpb=c4b292a4f103eb049c13dbe3c62f0438c18de816;p=friendica.git

diff --git a/mod/uexport.php b/mod/uexport.php
index 423c3a82fa..e1fb22855a 100644
--- a/mod/uexport.php
+++ b/mod/uexport.php
@@ -17,7 +17,7 @@ function uexport_init(&$a) {
 	}
 	$contact = array();
 	$r = q("SELECT * FROM `contact` WHERE `uid` = %d ",
-		local_user()
+		intval(local_user())
 	);
 	if(count($r)) {
 		foreach($r as $rr)
@@ -28,7 +28,7 @@ function uexport_init(&$a) {
 
 	$profile = array();
 	$r = q("SELECT * FROM `profile` WHERE `uid` = %d ",
-		local_user()
+		intval(local_user())
 	);
 	if(count($r)) {
 		foreach($r as $rr)
@@ -36,12 +36,36 @@ function uexport_init(&$a) {
 				$profile[][$k] = $v;
 	}
 
+	$output = array('user' => $user, 'contact' => $contact, 'profile' => $profile );
 
+	header("Content-type: application/json");
+	echo json_encode($output);
+
+	$r = q("SELECT count(*) as `total` FROM `item` WHERE `uid` = %d ",
+		intval(local_user())
+	);
+	if(count($r))
+		$total = $r[0]['total'];
 
-	$output = array('user' => $user, 'contact' => $contact, 'profile' => $profile);
+	// chunk the output to avoid exhausting memory
+
+	for($x = 0; $x < $total; $x += 500) {
+		$item = array();
+		$r = q("SELECT * FROM `item` WHERE `uid` = %d LIMIT %d, %d",
+			intval(local_user()),
+			intval($x),
+			intval(500)
+		);
+		if(count($r)) {
+			foreach($r as $rr)
+				foreach($rr as $k => $v)
+					$item[][$k] = $v;
+		}
+
+		$output = array('item' => $item);
+		echo json_encode($output);
+	}
 
-	header("Content-type: text/json");
-	echo str_replace('\\/','/',json_encode($output));
 
 	killme();