From 72479041ae51a5af020cb405715aa7fa3d6a97f1 Mon Sep 17 00:00:00 2001 From: redmatrix Date: Tue, 26 Jul 2016 22:50:31 -0700 Subject: don't include deleted or orphaned xchans in ratings search --- Zotlabs/Module/Ratingsearch.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'Zotlabs/Module/Ratingsearch.php') 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) ); -- cgit v1.2.3