3 function uexport_init(App &$a){
8 require_once("mod/settings.php");
12 /// @TODO Change space -> tab where wanted
13 function uexport_content(App &$a){
16 header("Content-type: application/json");
17 header('Content-Disposition: attachment; filename="'.$a->user['nickname'].'.'.$a->argv[1].'"');
19 case "backup": uexport_all($a); killme(); break;
20 case "account": uexport_account($a); killme(); break;
27 * options shown on "Export personal data" page
28 * list of array( 'link url', 'link text', 'help text' )
31 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.')),
32 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)')),
34 call_hooks('uexport_options', $options);
36 $tpl = get_markup_template("uexport.tpl");
37 return replace_macros($tpl, array(
38 '$baseurl' => App::get_baseurl(),
39 '$title' => t('Export personal data'),
40 '$options' => $options
46 function _uexport_multirow($query) {
49 // if (dbm::is_result($r)) {
53 foreach($rr as $k => $v)
61 function _uexport_row($query) {
66 foreach($rr as $k => $v)
74 function uexport_account($a){
77 sprintf( "SELECT * FROM `user` WHERE `uid` = %d LIMIT 1", intval(local_user()) )
80 $contact = _uexport_multirow(
81 sprintf( "SELECT * FROM `contact` WHERE `uid` = %d ",intval(local_user()) )
85 $profile =_uexport_multirow(
86 sprintf( "SELECT * FROM `profile` WHERE `uid` = %d ", intval(local_user()) )
89 $photo = _uexport_multirow(
90 sprintf( "SELECT * FROM `photo` WHERE uid = %d AND profile = 1", intval(local_user()) )
92 foreach ($photo as &$p) $p['data'] = bin2hex($p['data']);
94 $pconfig = _uexport_multirow(
95 sprintf( "SELECT * FROM `pconfig` WHERE uid = %d",intval(local_user()) )
98 $group = _uexport_multirow(
99 sprintf( "SELECT * FROM `group` WHERE uid = %d",intval(local_user()) )
102 $group_member = _uexport_multirow(
103 sprintf( "SELECT * FROM `group_member` WHERE uid = %d",intval(local_user()) )
107 'version' => FRIENDICA_VERSION,
108 'schema' => DB_UPDATE_VERSION,
109 'baseurl' => App::get_baseurl(),
111 'contact' => $contact,
112 'profile' => $profile,
114 'pconfig' => $pconfig,
116 'group_member' => $group_member,
119 //echo "<pre>"; var_dump(json_encode($output)); killme();
120 echo json_encode($output);
125 * echoes account data and items as separated json, one per line
127 function uexport_all(App &$a) {
132 $r = q("SELECT count(*) as `total` FROM `item` WHERE `uid` = %d ",
135 if (dbm::is_result($r))
136 $total = $r[0]['total'];
138 // chunk the output to avoid exhausting memory
140 for($x = 0; $x < $total; $x += 500) {
142 $r = q("SELECT * FROM `item` WHERE `uid` = %d LIMIT %d, %d",
143 intval(local_user()),
147 /*if (dbm::is_result($r)) {
149 foreach($rr as $k => $v)
153 $output = array('item' => $r);
154 echo json_encode($output)."\n";