X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fuexport.php;h=3114add7e4a56ae325ce024b379fd232a053f9fe;hb=0c9cc29a51941eb572bf16fd5489d0947d47d033;hp=e1fb22855a6066fa8b99336b837f29ef9ebbb0ea;hpb=8aa25523721303b6883e1a793f20997f8a33ec0a;p=friendica.git diff --git a/mod/uexport.php b/mod/uexport.php old mode 100755 new mode 100644 index e1fb22855a..3114add7e4 --- a/mod/uexport.php +++ b/mod/uexport.php @@ -1,46 +1,132 @@ $v) - $user[$k] = $v; + require_once("mod/settings.php"); + settings_init($a); +} + +function uexport_content(&$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' => $a->get_baseurl(), + '$title' => t('Export personal data'), + '$options' => $options + )); + +} + +function _uexport_multirow($query) { + $result = array(); + $r = q($query); +// if(count($r)) { + if ($r){ + foreach($r as $rr){ + $p = array(); + foreach($rr as $k => $v) + $p[$k] = $v; + $result[] = $p; + } } - $contact = array(); - $r = q("SELECT * FROM `contact` WHERE `uid` = %d ", - intval(local_user()) - ); - if(count($r)) { + return $result; +} + +function _uexport_row($query) { + $result = array(); + $r = q($query); + if ($r) { foreach($r as $rr) foreach($rr as $k => $v) - $contact[][$k] = $v; + $result[$k] = $v; } + return $result; +} - $profile = array(); - $r = q("SELECT * FROM `profile` WHERE `uid` = %d ", - intval(local_user()) + +function uexport_account($a){ + + $user = _uexport_row( + sprintf( "SELECT * FROM `user` WHERE `uid` = %d LIMIT 1", intval(local_user()) ) ); - if(count($r)) { - foreach($r as $rr) - foreach($rr as $k => $v) - $profile[][$k] = $v; - } - $output = array('user' => $user, 'contact' => $contact, 'profile' => $profile ); + $contact = _uexport_multirow( + 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']); + + $pconfig = _uexport_multirow( + sprintf( "SELECT * FROM `pconfig` WHERE uid = %d",intval(local_user()) ) + ); - header("Content-type: application/json"); + $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' => $a->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); +} + +/** + * echoes account data and items as separated json, one per line + */ +function uexport_all(&$a) { + + uexport_account($a); + echo "\n"; + $r = q("SELECT count(*) as `total` FROM `item` WHERE `uid` = %d ", intval(local_user()) ); @@ -56,17 +142,14 @@ function uexport_init(&$a) { intval($x), intval(500) ); - if(count($r)) { + /*if(count($r)) { foreach($r as $rr) foreach($rr as $k => $v) $item[][$k] = $v; - } + }*/ - $output = array('item' => $item); - echo json_encode($output); + $output = array('item' => $r); + echo json_encode($output)."\n"; } - - killme(); - -} \ No newline at end of file +}