aboutsummaryrefslogtreecommitdiffstats
path: root/mod
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-12-26 22:44:27 -0800
committerfriendica <info@friendica.com>2012-12-26 22:44:27 -0800
commit76c2fc5afd40ff3fcd5668d377209ad2f180534a (patch)
tree8ffb3a89e0a5ef66c2f8b84846db7bc8583999a6 /mod
parent8998d86423f2b71bc07a5cfe1189727b8edacfc9 (diff)
downloadvolse-hubzilla-76c2fc5afd40ff3fcd5668d377209ad2f180534a.tar.gz
volse-hubzilla-76c2fc5afd40ff3fcd5668d377209ad2f180534a.tar.bz2
volse-hubzilla-76c2fc5afd40ff3fcd5668d377209ad2f180534a.zip
will have to search tags/keywords another way
Diffstat (limited to 'mod')
-rw-r--r--mod/directory.php8
1 files changed, 4 insertions, 4 deletions
diff --git a/mod/directory.php b/mod/directory.php
index efdbe9fa2..c9332f447 100644
--- a/mod/directory.php
+++ b/mod/directory.php
@@ -63,17 +63,17 @@ $localdir = true;
if($localdir) {
if($search)
$search = dbesc($search);
- $sql_extra = ((strlen($search)) ? " AND MATCH ( xchan_name, xchan_addr, xprof_desc, xprof_locale, xprof_region, xprof_country, xprof_gdner, xprof_marital, tags ) AGAINST ('$search' IN BOOLEAN MODE) " : "");
+ $sql_extra = ((strlen($search)) ? " AND MATCH ( xchan_name, xchan_addr, xprof_desc, xprof_locale, xprof_region, xprof_country, xprof_gender, xprof_marital ) AGAINST ('$search' IN BOOLEAN MODE) " : "");
-
- $r = q("SELECT COUNT(xchan_hash) AS `total`, group_concat(xtag_term separator ', ') as tags FROM xchan left join xprof on xchan_hash = xprof_hash left join xtag on xtag_hash = xchan_hash $sql_extra group by xchan_hash");
+ // group_concat(xtag_term separator ', ') as tags
+ $r = q("SELECT COUNT(xchan_hash) AS `total` FROM xchan left join xprof on xchan_hash = xprof_hash $sql_extra");
if($r)
$a->set_pager_total($r[0]['total']);
$order = " ORDER BY `xchan_name` ASC ";
- $r = q("SELECT xchan.*, xprof.*, group_concat(xtag_term separator ', ') as tags from xchan left join xprof on xchan_hash = xprof_hash left join xtag on xtag_hash = xchan_hash $sql_extra group by xchan_hash $order LIMIT %d , %d ",
+ $r = q("SELECT xchan.*, xprof.* from xchan left join xprof on xchan_hash = xprof_hash $sql_extra $order LIMIT %d , %d ",
intval($a->pager['start']),
intval($a->pager['itemspage'])
);