<?php namespace Zotlabs\Module; require_once('include/zot.php'); require_once('include/crypto.php'); /* fix missing or damaged hublocs */ class Fhublocs extends \Zotlabs\Web\Controller { function get() { if(! is_site_admin()) return; $o = ''; $r = q("select * from channel where channel_removed = 0"); $sitekey = get_config('system','pubkey'); if($r) { foreach($r as $rr) { $found = false; $primary_address = ''; $x = zot_get_hublocs($rr['channel_hash']); if($x) { foreach($x as $xx) { if($xx['hubloc_url'] === z_root() && $xx['hubloc_sitekey'] === $sitekey) { $found = true; break; } } if($found) { $o .= 'Hubloc exists for ' . $rr['channel_name'] . EOL; continue; } } $y = q("select xchan_addr from xchan where xchan_hash = '%s' limit 1", dbesc($rr['channel_hash']) ); if($y) $primary_address = $y[0]['xchan_addr']; $hub_address = $rr['channel']['channel_address'] . '@' . \App::get_hostname(); $primary = (($hub_address === $primary_address) ? 1 : 0); if(! $y) $primary = 1; $m = q("delete from hubloc where hubloc_hash = '%s' and hubloc_url = '%s' ", dbesc($rr['channel_hash']), dbesc(z_root()) ); // Create a verified hub location pointing to this site. $h = q("insert into hubloc ( hubloc_guid, hubloc_guid_sig, hubloc_hash, hubloc_addr, hubloc_primary, hubloc_url, hubloc_url_sig, hubloc_host, hubloc_callback, hubloc_sitekey, hubloc_network ) values ( '%s', '%s', '%s', '%s', %d, '%s', '%s', '%s', '%s', '%s', '%s' )", dbesc($rr['channel_guid']), dbesc($rr['channel_guid_sig']), dbesc($rr['channel_hash']), dbesc($rr['channel_address'] . '@' . \App::get_hostname()), intval($primary), dbesc(z_root()), dbesc(base64url_encode(rsa_sign(z_root(),$rr['channel_prvkey']))), dbesc(\App::get_hostname()), dbesc(z_root() . '/post'), dbesc($sitekey), dbesc('zot') ); if($h) $o . 'local hubloc created for ' . $rr['channel_name'] . EOL; else $o .= 'DB update failed for ' . $rr['channel_name'] . EOL; } return $o; } } }