diff options
| author | friendica <info@friendica.com> | 2012-12-26 03:49:50 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-12-26 03:49:50 -0800 |
| commit | c8292b3cddf0a29236cb981111beb4587d7be411 (patch) | |
| tree | d9e5ed5afbf5ca90d04325c70949ea436a40c578 /mod/directory.php | |
| parent | 1aeea64311d1ae104b8fe513bf13c6f7eeb4fa42 (diff) | |
| download | volse-hubzilla-c8292b3cddf0a29236cb981111beb4587d7be411.tar.gz volse-hubzilla-c8292b3cddf0a29236cb981111beb4587d7be411.tar.bz2 volse-hubzilla-c8292b3cddf0a29236cb981111beb4587d7be411.zip | |
remove the private keywords stuff to reduce directory and search complexity
Diffstat (limited to 'mod/directory.php')
| -rw-r--r-- | mod/directory.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mod/directory.php b/mod/directory.php index b320839a7..2ab1db108 100644 --- a/mod/directory.php +++ b/mod/directory.php @@ -65,7 +65,7 @@ $localdir = true; if($localdir) { if($search) $search = dbesc($search); - $sql_extra = ((strlen($search)) ? " AND MATCH (`profile`.`name`, channel.channel_address, `pdesc`, `locality`,`region`,`country_name`,`gender`,`marital`,`sexual`,`about`,`romance`,`work`,`education`,`pub_keywords`,`prv_keywords` ) AGAINST ('$search' IN BOOLEAN MODE) " : ""); + $sql_extra = ((strlen($search)) ? " AND MATCH (`profile`.`name`, channel.channel_address, `pdesc`, `locality`,`region`,`country_name`,`gender`,`marital`,`sexual`,`about`,`romance`,`work`,`education`,`keywords` ) AGAINST ('$search' IN BOOLEAN MODE) " : ""); $r = q("SELECT COUNT(channel_id) AS `total` FROM channel left join profile on channel.channel_id = profile.uid WHERE `is_default` = 1 and not ( channel_pageflags & %d ) $sql_extra ", |