diff options
| author | Mario <mario@mariovavti.com> | 2022-11-02 15:54:12 +0000 |
|---|---|---|
| committer | Mario <mario@mariovavti.com> | 2022-11-02 15:54:12 +0000 |
| commit | b2172d39f6da5c67de618d2b6d28a3a77d071c97 (patch) | |
| tree | 3d2bd1bc7ddebd8dd39f69f000a898630231f843 | |
| parent | f4d39bd3c86feebd21cfbfe61b7da5d32421113d (diff) | |
| download | volse-hubzilla-b2172d39f6da5c67de618d2b6d28a3a77d071c97.tar.gz volse-hubzilla-b2172d39f6da5c67de618d2b6d28a3a77d071c97.tar.bz2 volse-hubzilla-b2172d39f6da5c67de618d2b6d28a3a77d071c97.zip | |
re-install: if we have a cashed entry, make sure we fetch the latest
| -rw-r--r-- | Zotlabs/Lib/Connect.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/Zotlabs/Lib/Connect.php b/Zotlabs/Lib/Connect.php index 6f10bbbae..4570627fc 100644 --- a/Zotlabs/Lib/Connect.php +++ b/Zotlabs/Lib/Connect.php @@ -69,7 +69,7 @@ class Connect { $xchan_hash = ''; $sql_options = (($protocol) ? " and xchan_network = '" . dbesc($protocol) . "' " : ''); - $r = q("select * from xchan where ( xchan_hash = '%s' or xchan_url = '%s' or xchan_addr = '%s') $sql_options ", + $r = q("SELECT * FROM xchan LEFT JOIN hubloc ON xchan_hash = hubloc_hash WHERE ( xchan_hash = '%s' or xchan_url = '%s' or xchan_addr = '%s') $sql_options ORDER BY hubloc_id DESC", dbesc($url), dbesc($url), dbesc($url) @@ -80,7 +80,7 @@ class Connect { // reset results to the best record or the first if we don't have the best // note: this is a single record and not an array of results - $r = Libzot::zot_record_preferred($r,'xchan_network'); + $r = Libzot::zot_record_preferred($r, 'xchan_network'); } @@ -120,7 +120,7 @@ class Connect { // convert to a single record (once again preferring a zot solution in the case of multiples) if ($r) { - $r = Libzot::zot_record_preferred($r,'xchan_network'); + $r = Libzot::zot_record_preferred($r, 'xchan_network'); } } |