5 function uexport_init(App $a) {
10 require_once("mod/settings.php");
14 function uexport_content(App $a) {
17 header("Content-type: application/json");
18 header('Content-Disposition: attachment; filename="' . $a->user['nickname'] . '.' . $a->argv[1] . '"');
19 switch ($a->argv[1]) {
34 * options shown on "Export personal data" page
35 * list of array( 'link url', 'link text', 'help text' )
38 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.')),
39 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)')),
41 call_hooks('uexport_options', $options);
43 $tpl = get_markup_template("uexport.tpl");
44 return replace_macros($tpl, array(
45 '$baseurl' => App::get_baseurl(),
46 '$title' => t('Export personal data'),
47 '$options' => $options
51 function _uexport_multirow($query) {
54 if (dbm::is_result($r)) {
57 foreach ($rr as $k => $v) {
66 function _uexport_row($query) {
69 if (dbm::is_result($r)) {
71 foreach ($rr as $k => $v) {
79 function uexport_account($a) {
82 sprintf("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1", intval(local_user()))
85 $contact = _uexport_multirow(
86 sprintf("SELECT * FROM `contact` WHERE `uid` = %d ", intval(local_user()))
90 $profile = _uexport_multirow(
91 sprintf("SELECT * FROM `profile` WHERE `uid` = %d ", intval(local_user()))
94 $photo = _uexport_multirow(
95 sprintf("SELECT * FROM `photo` WHERE uid = %d AND profile = 1", intval(local_user()))
97 foreach ($photo as &$p) {
98 $p['data'] = bin2hex($p['data']);
101 $pconfig = _uexport_multirow(
102 sprintf("SELECT * FROM `pconfig` WHERE uid = %d", intval(local_user()))
105 $group = _uexport_multirow(
106 sprintf("SELECT * FROM `group` WHERE uid = %d", intval(local_user()))
109 $group_member = _uexport_multirow(
110 sprintf("SELECT * FROM `group_member` WHERE uid = %d", intval(local_user()))
114 'version' => FRIENDICA_VERSION,
115 'schema' => DB_UPDATE_VERSION,
116 'baseurl' => App::get_baseurl(),
118 'contact' => $contact,
119 'profile' => $profile,
121 'pconfig' => $pconfig,
123 'group_member' => $group_member,
126 //echo "<pre>"; var_dump(json_encode($output)); killme();
127 echo json_encode($output);
131 * echoes account data and items as separated json, one per line
133 function uexport_all(App $a) {
138 $r = q("SELECT count(*) as `total` FROM `item` WHERE `uid` = %d ",
141 if (dbm::is_result($r)) {
142 $total = $r[0]['total'];
144 // chunk the output to avoid exhausting memory
146 for ($x = 0; $x < $total; $x += 500) {
148 $r = q("SELECT * FROM `item` WHERE `uid` = %d LIMIT %d, %d",
149 intval(local_user()),
154 $output = array('item' => $r);
155 echo json_encode($output) . "\n";