diff options
| author | friendica <info@friendica.com> | 2012-08-30 18:17:38 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-08-30 18:17:38 -0700 |
| commit | eac29badb2fade43dfe3fd6373ffc675858143dd (patch) | |
| tree | ecf3ec6007a22a755900c46a4bc1e4862cc08d06 /mod/msearch.php | |
| parent | f6d198ce5dcd9fe416975ff760439dfacbb83812 (diff) | |
| download | volse-hubzilla-eac29badb2fade43dfe3fd6373ffc675858143dd.tar.gz volse-hubzilla-eac29badb2fade43dfe3fd6373ffc675858143dd.tar.bz2 volse-hubzilla-eac29badb2fade43dfe3fd6373ffc675858143dd.zip | |
start on contacts/profiles
Diffstat (limited to 'mod/msearch.php')
| -rw-r--r-- | mod/msearch.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mod/msearch.php b/mod/msearch.php index c4d69839c..e8e7d447b 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 `pub_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 `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 ", dbesc($search), intval($startrec), intval($perpage) |