aboutsummaryrefslogtreecommitdiffstats
path: root/include
diff options
context:
space:
mode:
authorMario <mario@mariovavti.com>2022-12-26 09:08:54 +0000
committerMario <mario@mariovavti.com>2022-12-26 09:08:54 +0000
commitd2d6be73b8428c11c2461961a920ed3e3e656f64 (patch)
tree6a5216b3696ee4cdd19e7db8a3bffbbecc2c5f1b /include
parenta46e2c1e6db63b03552bba9d6699b8509fd6daa0 (diff)
downloadvolse-hubzilla-d2d6be73b8428c11c2461961a920ed3e3e656f64.tar.gz
volse-hubzilla-d2d6be73b8428c11c2461961a920ed3e3e656f64.tar.bz2
volse-hubzilla-d2d6be73b8428c11c2461961a920ed3e3e656f64.zip
fix subquery in hq widget and order by hubloc_id desc in handle_tag() to make sure we get the most recent entry when using privacy tags
Diffstat (limited to 'include')
-rw-r--r--include/text.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/include/text.php b/include/text.php
index 1608f5435..35ce465d6 100644
--- a/include/text.php
+++ b/include/text.php
@@ -2970,7 +2970,7 @@ function handle_tag(&$body, &$str_tags, $profile_uid, $tag, $in_network = true)
$newname = substr($name,1);
$newname = substr($newname,0,-1);
- $r = q("SELECT * FROM xchan WHERE ( xchan_addr = '%s' OR xchan_url = '%s' ) AND xchan_deleted = 0 AND NOT xchan_network IN ('rss', 'anon', 'unknown')",
+ $r = q("SELECT * FROM xchan LEFT JOIN hubloc ON hubloc_hash = xchan_hash WHERE ( xchan_addr = '%s' OR xchan_url = '%s' ) AND xchan_deleted = 0 AND NOT xchan_network IN ('rss', 'anon', 'unknown') ORDER BY hubloc_id DESC",
dbesc($newname),
dbesc($newname)
);
@@ -3005,7 +3005,7 @@ function handle_tag(&$body, &$str_tags, $profile_uid, $tag, $in_network = true)
if((! $r) && strpos($newname,'@')) {
$r = q("SELECT * FROM xchan LEFT JOIN hubloc ON xchan_hash = hubloc_hash
- WHERE hubloc_addr = '%s' AND xchan_deleted = 0 AND NOT xchan_network IN ('rss', 'anon', 'unknown')",
+ WHERE hubloc_addr = '%s' AND xchan_deleted = 0 AND NOT xchan_network IN ('rss', 'anon', 'unknown') ORDER BY hubloc_id DESC",
dbesc($newname)
);
}