aboutsummaryrefslogtreecommitdiffstats
path: root/Zotlabs/Module
diff options
context:
space:
mode:
authorredmatrix <git@macgirvin.com>2016-07-26 22:50:31 -0700
committerredmatrix <git@macgirvin.com>2016-07-26 22:50:31 -0700
commit72479041ae51a5af020cb405715aa7fa3d6a97f1 (patch)
tree115ca9b4fb8cd50e6d7b8a9de0c2119d46d09b8b /Zotlabs/Module
parent315dafbe122829aedd80ede1db99d3e4e380dbf8 (diff)
downloadvolse-hubzilla-72479041ae51a5af020cb405715aa7fa3d6a97f1.tar.gz
volse-hubzilla-72479041ae51a5af020cb405715aa7fa3d6a97f1.tar.bz2
volse-hubzilla-72479041ae51a5af020cb405715aa7fa3d6a97f1.zip
don't include deleted or orphaned xchans in ratings search
Diffstat (limited to 'Zotlabs/Module')
-rw-r--r--Zotlabs/Module/Ratingsearch.php3
1 files changed, 2 insertions, 1 deletions
diff --git a/Zotlabs/Module/Ratingsearch.php b/Zotlabs/Module/Ratingsearch.php
index 5f463b378..b595e16b1 100644
--- a/Zotlabs/Module/Ratingsearch.php
+++ b/Zotlabs/Module/Ratingsearch.php
@@ -58,7 +58,8 @@ class Ratingsearch extends \Zotlabs\Web\Controller {
$ret['success'] = true;
$r = q("select * from xlink left join xchan on xlink_xchan = xchan_hash
- where xlink_link = '%s' and xlink_rating != 0 and xlink_static = 1 order by xchan_name asc",
+ where xlink_link = '%s' and xlink_rating != 0 and xlink_static = 1 and xchan_orphan = 0 and xchan_deleted = 0
+ order by xchan_name asc",
dbesc($target)
);