X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fmsearch.php;h=b02a036ae4e1996dc4a6853892b77b6b4df71724;hb=a16dba2941bb3507faa84a13df2001a61daa3e96;hp=67b8ea6fd59e63760fad9ae02238abc0e0aa82c5;hpb=3f3422975266835fc125d1d61aae85ccc10d96d9;p=friendica.git diff --git a/mod/msearch.php b/mod/msearch.php index 67b8ea6fd5..b02a036ae4 100644 --- a/mod/msearch.php +++ b/mod/msearch.php @@ -1,4 +1,23 @@ . + * + */ use Friendica\App; use Friendica\Database\DBA; @@ -26,8 +45,7 @@ function msearch_post(App $a) "SELECT COUNT(*) AS `total` FROM `profile` JOIN `user` ON `user`.`uid` = `profile`.`uid` - WHERE `is-default` = 1 - AND `user`.`hidewall` = 0 + WHERE `profile`.`net-publish` AND MATCH(`pub_keywords`) AGAINST (?)", $search ); @@ -42,8 +60,7 @@ function msearch_post(App $a) "SELECT `pub_keywords`, `username`, `nickname`, `user`.`uid` FROM `user` JOIN `profile` ON `user`.`uid` = `profile`.`uid` - WHERE `is-default` = 1 - AND `user`.`hidewall` = 0 + WHERE `profile`.`net-publish` AND MATCH(`pub_keywords`) AGAINST (?) LIMIT ?, ?", $search,