<?php /** @file */ function rconnect_url($channel_id,$xchan) { if(! $xchan) return ''; $r = q("select abook_id from abook where abook_channel = %d and abook_xchan = '%s' limit 1", intval($channel_id), dbesc($xchan) ); if($r) return ''; $r = q("select * from xchan where xchan_hash = '%s' limit 1", dbesc($xchan) ); if(($r) && ($r[0]['xchan_follow'])) return $r[0]['xchan_follow']; $r = q("select hubloc_url from hubloc where hubloc_hash = '%s' and hubloc_primary = 1 limit 1", dbesc($xchan) ); if($r) return $r[0]['hubloc_url'] . '/follow?f=&url=%s'; return ''; } function abook_connections($channel_id, $sql_conditions = '') { $r = q("select * from abook left join xchan on abook_xchan = xchan_hash where abook_channel = %d and abook_self = 0 $sql_conditions", intval($channel_id) ); return(($r) ? $r : array()); } function abook_self($channel_id) { $r = q("select * from abook left join xchan on abook_xchan = xchan_hash where abook_channel = %d and abook_self = 1 limit 1", intval($channel_id) ); return(($r) ? $r[0] : array()); } function vcard_from_xchan($xchan, $observer = null, $mode = '') { if(! $xchan) { if(App::$poi) { $xchan = App::$poi; } elseif(is_array(App::$profile) && App::$profile['channel_hash']) { $r = q("select * from xchan where xchan_hash = '%s' limit 1", dbesc(App::$profile['channel_hash']) ); if($r) $xchan = $r[0]; } } if(! $xchan) return; // FIXME - show connect button to observer if appropriate $connect = false; if(local_channel()) { $r = q("select * from abook where abook_xchan = '%s' and abook_channel = %d limit 1", dbesc($xchan['xchan_hash']), intval(local_channel()) ); if(! $r) $connect = t('Connect'); } if(array_key_exists('channel_id',$xchan)) App::$profile_uid = $xchan['channel_id']; $url = (($observer) ? z_root() . '/magic?f=&dest=' . $xchan['xchan_url'] . '&addr=' . $xchan['xchan_addr'] : $xchan['xchan_url'] ); return replace_macros(get_markup_template('xchan_vcard.tpl'),array( '$name' => $xchan['xchan_name'], '$photo' => ((is_array(App::$profile) && array_key_exists('photo',App::$profile)) ? App::$profile['photo'] : $xchan['xchan_photo_l']), '$follow' => $xchan['xchan_addr'], '$link' => zid($xchan['xchan_url']), '$connect' => $connect, '$newwin' => (($mode === 'chanview') ? t('New window') : ''), '$newtit' => t('Open the selected location in a different window or browser tab'), '$url' => $url, )); } function abook_toggle_flag($abook,$flag) { $field = ''; switch($flag) { case ABOOK_FLAG_BLOCKED: $field = 'abook_blocked'; break; case ABOOK_FLAG_IGNORED: $field = 'abook_ignored'; break; case ABOOK_FLAG_HIDDEN: $field = 'abook_hidden'; break; case ABOOK_FLAG_ARCHIVED: $field = 'abook_archived'; break; case ABOOK_FLAG_PENDING: $field = 'abook_pending'; break; case ABOOK_FLAG_UNCONNECTED: $field = 'abook_unconnected'; break; case ABOOK_FLAG_SELF: $field = 'abook_self'; break; case ABOOK_FLAG_FEED: $field = 'abook_feed'; break; default: break; } if(! $field) return; $r = q("UPDATE abook set $field = (1 - $field) where abook_id = %d and abook_channel = %d", intval($abook['abook_id']), intval($abook['abook_channel']) ); // if unsetting the archive bit, update the timestamps so we'll try to connect for an additional 30 days. if(($flag === ABOOK_FLAG_ARCHIVED) && (intval($abook['abook_archived']))) { $r = q("update abook set abook_connected = '%s', abook_updated = '%s' where abook_id = %d and abook_channel = %d", dbesc(datetime_convert()), dbesc(datetime_convert()), intval($abook['abook_id']), intval($abook['abook_channel']) ); } return $r; } // Included here for completeness, but this is a very dangerous operation. // It is the caller's responsibility to confirm the requestor's intent and // authorisation to do this. function user_remove($uid) { } function account_remove($account_id,$local = true,$unset_session=true) { logger('account_remove: ' . $account_id); if(! intval($account_id)) { logger('account_remove: no account.'); return false; } // Don't let anybody nuke the only admin account. $r = q("select account_id from account where (account_roles & %d) > 0", intval(ACCOUNT_ROLE_ADMIN) ); if($r !== false && count($r) == 1 && $r[0]['account_id'] == $account_id) { logger("Unable to remove the only remaining admin account"); return false; } $r = q("select * from account where account_id = %d limit 1", intval($account_id) ); $account_email=$r[0]['account_email']; if(! $r) { logger('account_remove: No account with id: ' . $account_id); return false; } $x = q("select channel_id from channel where channel_account_id = %d", intval($account_id) ); if($x) { foreach($x as $xx) { channel_remove($xx['channel_id'],$local,false); } } $r = q("delete from account where account_id = %d", intval($account_id) ); if ($unset_session) { unset($_SESSION['authenticated']); unset($_SESSION['uid']); notice( sprintf(t("User '%s' deleted"),$account_email) . EOL); goaway(z_root()); } return $r; } // recursively delete a directory function rrmdir($path) { if (is_dir($path) === true) { $files = array_diff(scandir($path), array('.', '..')); foreach ($files as $file) { rrmdir(realpath($path) . '/' . $file); } return rmdir($path); } else if (is_file($path) === true) { return unlink($path); } return false; } function channel_remove($channel_id, $local = true, $unset_session=false) { if(! $channel_id) return; logger('Removing channel: ' . $channel_id); logger('channel_remove: local only: ' . intval($local)); $r = q("select * from channel where channel_id = %d limit 1", intval($channel_id)); if(! $r) { logger('channel_remove: channel not found: ' . $channel_id); return; } $channel = $r[0]; call_hooks('channel_remove',$r[0]); if(! $local) { $r = q("update channel set channel_deleted = '%s', channel_removed = 1 where channel_id = %d", dbesc(datetime_convert()), intval($channel_id) ); q("delete from pconfig where uid = %d", intval($channel_id) ); logger('deleting hublocs',LOGGER_DEBUG); $r = q("update hubloc set hubloc_deleted = 1 where hubloc_hash = '%s'", dbesc($channel['channel_hash']) ); $r = q("update xchan set xchan_deleted = 1 where xchan_hash = '%s'", dbesc($channel['channel_hash']) ); Zotlabs\Daemon\Master::Summon(array('Notifier','purge_all',$channel_id)); } $r = q("select * from iconfig left join item on item.id = iconfig.iid where item.uid = %d", intval($channel_id) ); if($r) { foreach($r as $rr) { q("delete from iconfig where iid = %d", intval($rr['iid']) ); } } q("DELETE FROM groups WHERE uid = %d", intval($channel_id)); q("DELETE FROM group_member WHERE uid = %d", intval($channel_id)); q("DELETE FROM event WHERE uid = %d", intval($channel_id)); q("DELETE FROM item WHERE uid = %d", intval($channel_id)); q("DELETE FROM mail WHERE channel_id = %d", intval($channel_id)); q("DELETE FROM notify WHERE uid = %d", intval($channel_id)); q("DELETE FROM photo WHERE uid = %d", intval($channel_id)); q("DELETE FROM attach WHERE uid = %d", intval($channel_id)); q("DELETE FROM profile WHERE uid = %d", intval($channel_id)); q("DELETE FROM pconfig WHERE uid = %d", intval($channel_id)); // @FIXME At this stage we need to remove the file resources located under /store/$nickname q("delete from abook where abook_xchan = '%s' and abook_self = 1 ", dbesc($channel['channel_hash']) ); $r = q("update channel set channel_deleted = '%s', channel_removed = 1 where channel_id = %d", dbesc(datetime_convert()), intval($channel_id) ); // if this was the default channel, set another one as default if(App::$account['account_default_channel'] == $channel_id) { $r = q("select channel_id from channel where channel_account_id = %d and channel_removed = 0 limit 1", intval(App::$account['account_id']), intval(PAGE_REMOVED)); if ($r) { $rr = q("update account set account_default_channel = %d where account_id = %d", intval($r[0]['channel_id']), intval(App::$account['account_id'])); logger("Default channel deleted, changing default to channel_id " . $r[0]['channel_id']); } else { $rr = q("update account set account_default_channel = 0 where account_id = %d", intval(App::$account['account_id']) ); } } logger('deleting hublocs',LOGGER_DEBUG); $r = q("update hubloc set hubloc_deleted = 1 where hubloc_hash = '%s' and hubloc_url = '%s' ", dbesc($channel['channel_hash']), dbesc(z_root()) ); // Do we have any valid hublocs remaining? $hublocs = 0; $r = q("select hubloc_id from hubloc where hubloc_hash = '%s' and hubloc_deleted = 0", dbesc($channel['channel_hash']) ); if($r) $hublocs = count($r); if(! $hublocs) { $r = q("update xchan set xchan_deleted = 1 where xchan_hash = '%s' ", dbesc($channel['channel_hash']) ); } //remove from file system $r = q("select channel_address from channel where channel_id = %d limit 1", intval($channel_id) ); if($r) $channel_address = $r[0]['channel_address'] ; if ($channel_address !== '') { $f = 'store/' . $channel_address.'/'; logger ('delete '. $f); if(is_dir($f)) @rrmdir($f); } Zotlabs\Daemon\Master::Summon(array('Directory',$channel_id)); if($channel_id == local_channel() && $unset_session) { App::$session->nuke(); goaway(z_root()); } } /** * mark any hubs "offline" that haven't been heard from in more than 30 days * Allow them to redeem themselves if they come back later. * Then go through all those that are newly marked and see if any other hubs * are attached to the controlling xchan that are still alive. * If not, they're dead (although they could come back some day). */ function mark_orphan_hubsxchans() { $dirmode = intval(get_config('system','directory_mode')); if($dirmode == DIRECTORY_MODE_NORMAL) return; $r = q("update hubloc set hubloc_error = 1 where hubloc_error = 0 and hubloc_network = 'zot' and hubloc_connected < %s - interval %s", db_utcnow(), db_quoteinterval('36 day') ); // $realm = get_directory_realm(); // if($realm == DIRECTORY_REALM) { // $r = q("select * from site where site_access != 0 and site_register !=0 and ( site_realm = '%s' or site_realm = '') order by rand()", // dbesc($realm) // ); // } // else { // $r = q("select * from site where site_access != 0 and site_register !=0 and site_realm = '%s' order by rand()", // dbesc($realm) // ); // } $r = q("select hubloc_id, hubloc_hash from hubloc where hubloc_error = 0 and hubloc_orphancheck = 0"); if($r) { foreach($r as $rr) { // see if any other hublocs are still alive for this channel $x = q("select * from hubloc where hubloc_hash = '%s' and hubloc_error = 0", dbesc($rr['hubloc_hash']) ); if($x) { // yes - if the xchan was marked as an orphan, undo it $y = q("update xchan set xchan_orphan = 0 where xchan_orphan = 1 and xchan_hash = '%s'", dbesc($rr['hubloc_hash']) ); } else { // nope - mark the xchan as an orphan $y = q("update xchan set xchan_orphan = 1 where xchan_hash = '%s'", dbesc($rr['hubloc_hash']) ); } // mark that we've checked this entry so we don't need to do it again $y = q("update hubloc set hubloc_orphancheck = 1 where hubloc_id = %d", dbesc($rr['hubloc_id']) ); } } } function remove_all_xchan_resources($xchan, $channel_id = 0) { if(intval($channel_id)) { } else { $dirmode = intval(get_config('system','directory_mode')); $r = q("delete from photo where xchan = '%s'", dbesc($xchan) ); $r = q("select resource_id, resource_type, uid, id from item where ( author_xchan = '%s' or owner_xchan = '%s' ) ", dbesc($xchan), dbesc($xchan) ); if($r) { foreach($r as $rr) { drop_item($rr,false); } } $r = q("delete from event where event_xchan = '%s'", dbesc($xchan) ); $r = q("delete from group_member where xchan = '%s'", dbesc($xchan) ); $r = q("delete from mail where ( from_xchan = '%s' or to_xchan = '%s' )", dbesc($xchan), dbesc($xchan) ); $r = q("delete from xlink where ( xlink_xchan = '%s' or xlink_link = '%s' )", dbesc($xchan), dbesc($xchan) ); $r = q("delete from abook where abook_xchan = '%s'", dbesc($xchan) ); if($dirmode === false || $dirmode == DIRECTORY_MODE_NORMAL) { $r = q("delete from xchan where xchan_hash = '%s'", dbesc($xchan) ); $r = q("delete from hubloc where hubloc_hash = '%s'", dbesc($xchan) ); } else { // directory servers need to keep the record around for sync purposes - mark it deleted $r = q("update hubloc set hubloc_deleted = 1 where hubloc_hash = '%s'", dbesc($xchan) ); $r = q("update xchan set xchan_deleted = 1 where xchan_hash = '%s'", dbesc($xchan) ); } } } function contact_remove($channel_id, $abook_id) { if((! $channel_id) || (! $abook_id)) return false; logger('removing contact ' . $abook_id . ' for channel ' . $channel_id,LOGGER_DEBUG); $archive = get_pconfig($channel_id, 'system','archive_removed_contacts'); if($archive) { q("update abook set abook_archived = 1 where abook_id = %d and abook_channel = %d", intval($abook_id), intval($channel_id) ); return true; } $r = q("select * from abook where abook_id = %d and abook_channel = %d limit 1", intval($abook_id), intval($channel_id) ); if(! $r) return false; $abook = $r[0]; if(intval($abook['abook_self'])) return false; $r = q("select * from item where author_xchan = '%s' and uid = %d", dbesc($abook['abook_xchan']), intval($channel_id) ); if($r) { foreach($r as $rr) { drop_item($rr['id'],false); } } q("delete from abook where abook_id = %d and abook_channel = %d", intval($abook['abook_id']), intval($channel_id) ); $r = q("delete from event where event_xchan = '%s' and uid = %d", dbesc($abook['abook_xchan']), intval($channel_id) ); $r = q("delete from group_member where xchan = '%s' and uid = %d", dbesc($abook['abook_xchan']), intval($channel_id) ); $r = q("delete from mail where ( from_xchan = '%s' or to_xchan = '%s' ) and channel_id = %d ", dbesc($abook['abook_xchan']), dbesc($abook['abook_xchan']), intval($channel_id) ); $r = q("delete from abconfig where chan = %d and xchan = '%s'", intval($channel_id), dbesc($abook['abook_xchan']) ); return true; } function random_profile() { $randfunc = db_getfunc('rand'); $checkrandom = get_config('randprofile','check'); // False by default $retryrandom = intval(get_config('randprofile','retry')); if($retryrandom == 0) $retryrandom = 5; for($i = 0; $i < $retryrandom; $i++) { $r = q("select xchan_url from xchan left join hubloc on hubloc_hash = xchan_hash where xchan_addr not like '%s' and xchan_hidden = 0 and hubloc_connected > %s - interval %s order by $randfunc limit 1", dbesc('sys@%'), db_utcnow(), db_quoteinterval('30 day') ); if(!$r) return ''; // Couldn't get a random channel if($checkrandom) { $x = z_fetch_url($r[0]['xchan_url']); if($x['success']) return $r[0]['xchan_url']; else logger('Random channel turned out to be bad.'); } else { return $r[0]['xchan_url']; } } return ''; } function update_vcard($arr,$vcard = null) { $fn = $arr['fn']; if(! $vcard) { $vcard = new \Sabre\VObject\Component\VCard([ 'FN' => $fn, 'N' => array_reverse(explode(' ', $fn)) ]); } else { $vcard->FN = $fn; $vcard->N = array_reverse(explode(' ', $fn)); } $org = $arr['org']; if($org) { $vcard->ORG = $org; } $title = $arr['title']; if($title) { $vcard->TITLE = $title; } $tel = $arr['tel']; $tel_type = $arr['tel_type']; if($tel) { $i = 0; foreach($tel as $item) { if($item) { $vcard->add('TEL', $item, ['type' => $tel_type[$i]]); } $i++; } } $email = $arr['email']; $email_type = $arr['email_type']; if($email) { $i = 0; foreach($email as $item) { if($item) { $vcard->add('EMAIL', $item, ['type' => $email_type[$i]]); } $i++; } } $impp = $arr['impp']; $impp_type = $arr['impp_type']; if($impp) { $i = 0; foreach($impp as $item) { if($item) { $vcard->add('IMPP', $item, ['type' => $impp_type[$i]]); } $i++; } } $url = $arr['url']; $url_type = $arr['url_type']; if($url) { $i = 0; foreach($url as $item) { if($item) { $vcard->add('URL', $item, ['type' => $url_type[$i]]); } $i++; } } $adr = $arr['adr']; $adr_type = $arr['adr_type']; if($adr) { $i = 0; foreach($adr as $item) { if($item) { $vcard->add('ADR', $item, ['type' => $adr_type[$i]]); } $i++; } } $note = $arr['note']; if($note) { $vcard->NOTE = $note; } return $vcard->serialize(); } function get_vcard_array($vc,$id) { $photo = ''; if($vc->PHOTO) { $photo_value = strtolower($vc->PHOTO->getValueType()); // binary or uri if($photo_value === 'binary') { $photo_type = strtolower($vc->PHOTO['TYPE']); // mime jpeg, png or gif $photo = 'data:image/' . $photo_type . ';base64,' . base64_encode((string)$vc->PHOTO); } else { $url = parse_url((string)$vc->PHOTO); $photo = 'data:' . $url['path']; } } $fn = ''; if($vc->FN) { $fn = (string) escape_tags($vc->FN); } $org = ''; if($vc->ORG) { $org = (string) escape_tags($vc->ORG); } $title = ''; if($vc->TITLE) { $title = (string) escape_tags($vc->TITLE); } $tels = []; if($vc->TEL) { foreach($vc->TEL as $tel) { $type = (($tel['TYPE']) ? vcard_translate_type((string)$tel['TYPE']) : ''); $tels[] = [ 'type' => $type, 'nr' => (string) escape_tags($tel) ]; } } $emails = []; if($vc->EMAIL) { foreach($vc->EMAIL as $email) { $type = (($email['TYPE']) ? vcard_translate_type((string)$email['TYPE']) : ''); $emails[] = [ 'type' => $type, 'address' => (string) escape_tags($email) ]; } } $impps = []; if($vc->IMPP) { foreach($vc->IMPP as $impp) { $type = (($impp['TYPE']) ? vcard_translate_type((string)$impp['TYPE']) : ''); $impps[] = [ 'type' => $type, 'address' => (string) escape_tags($impp) ]; } } $urls = []; if($vc->URL) { foreach($vc->URL as $url) { $type = (($url['TYPE']) ? vcard_translate_type((string)$url['TYPE']) : ''); $urls[] = [ 'type' => $type, 'address' => (string) escape_tags($url) ]; } } $adrs = []; if($vc->ADR) { foreach($vc->ADR as $adr) { $type = (($adr['TYPE']) ? vcard_translate_type((string)$adr['TYPE']) : ''); $adrs[] = [ 'type' => $type, 'address' => escape_tags($adr->getParts()) ]; } } $note = ''; if($vc->NOTE) { $note = (string) escape_tags($vc->NOTE); } $card = [ 'id' => $id, 'photo' => $photo, 'fn' => $fn, 'org' => $org, 'title' => $title, 'tels' => $tels, 'emails' => $emails, 'impps' => $impps, 'urls' => $urls, 'adrs' => $adrs, 'note' => $note ]; return $card; } function vcard_translate_type($type) { if(!$type) return; $type = strtoupper($type); $map = [ 'CELL' => t('Mobile'), 'HOME' => t('Home'), 'HOME,VOICE' => t('Home, Voice'), 'HOME,FAX' => t('Home, Fax'), 'WORK' => t('Work'), 'WORK,VOICE' => t('Work, Voice'), 'WORK,FAX' => t('Work, Fax'), 'OTHER' => t('Other') ]; if (array_key_exists($type, $map)) { return [$type, $map[$type]]; } else { return [$type, t('Other') . ' (' . $type . ')']; } } function vcard_query(&$r) { $arr = []; if($r && is_array($r) && count($r)) { $uid = $r[0]['abook_channel']; foreach($r as $rv) { if($rv['abook_xchan'] && (! in_array("'" . dbesc($rv['abook_xchan']) . "'",$arr))) $arr[] = "'" . dbesc($rv['abook_xchan']) . "'"; } } if($arr) { $a = q("select * from abconfig where chan = %d and xchan in (" . protect_sprintf(implode(',', $arr)) . ") and cat = 'system' and k = 'vcard'", intval($uid) ); if($a) { foreach($a as $av) { for($x = 0; $x < count($r); $x ++) { if($r[$x]['abook_xchan'] == $av['xchan']) { $vctmp = \Sabre\VObject\Reader::read($av['v']); $r[$x]['vcard'] = (($vctmp) ? get_vcard_array($vctmp,$r[$x]['abook_id']) : [] ); } } } } } }