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/msearch.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/msearch.php')
| -rw-r--r-- | mod/msearch.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mod/msearch.php b/mod/msearch.php index 9d587d1e4..b51c4e097 100644 --- a/mod/msearch.php +++ b/mod/msearch.php @@ -10,13 +10,13 @@ function msearch_post(&$a) { if(! strlen($search)) killme(); - $r = q("SELECT COUNT(*) AS `total` FROM `profile` LEFT JOIN `user` ON `user`.`uid` = `profile`.`uid` WHERE `is_default` = 1 AND `user`.`hidewall` = 0 AND MATCH `pub_keywords` AGAINST ('%s') ", + $r = q("SELECT COUNT(*) AS `total` FROM `profile` LEFT JOIN `user` ON `user`.`uid` = `profile`.`uid` WHERE `is_default` = 1 AND `user`.`hidewall` = 0 AND MATCH `keywords` AGAINST ('%s') ", dbesc($search) ); if(count($r)) $total = $r[0]['total']; - $r = q("SELECT `pub_keywords`, `username`, `nickname`, `user`.`uid` FROM `user` LEFT JOIN `profile` ON `user`.`uid` = `profile`.`uid` WHERE `is_default` = 1 AND `user`.`hidewall` = 0 AND MATCH `pub_keywords` AGAINST ('%s') LIMIT %d , %d ", + $r = q("SELECT `keywords`, `username`, `nickname`, `user`.`uid` FROM `user` LEFT JOIN `profile` ON `user`.`uid` = `profile`.`uid` WHERE `is_default` = 1 AND `user`.`hidewall` = 0 AND MATCH `keywords` AGAINST ('%s') LIMIT %d , %d ", dbesc($search), intval($startrec), intval($perpage) @@ -29,7 +29,7 @@ function msearch_post(&$a) { 'name' => $rr['name'], 'url' => $a->get_baseurl() . '/channel/' . $rr['nickname'], 'photo' => $a->get_baseurl() . '/photo/avatar/' . $rr['uid'], - 'tags' => str_replace(array(',',' '),array(' ',' '),$rr['pub_keywords']) + 'tags' => str_replace(array(',',' '),array(' ',' '),$rr['keywords']) ); } |