diff options
author | Andrew Manning <tamanning@zoho.com> | 2016-04-20 21:05:01 -0400 |
---|---|---|
committer | Andrew Manning <tamanning@zoho.com> | 2016-04-20 21:05:01 -0400 |
commit | b96eb1c8230ae2f5986d6f22934c606bbca9728e (patch) | |
tree | fecd2279927b61da28801094dc7d6b1cfa8d98fe /Zotlabs/Module/Msearch.php | |
parent | 7594796ee11c0b245d02d145868a13ac3d84ebfc (diff) | |
parent | 635580091a227529cb491e6441a5acbfff3177be (diff) | |
download | volse-hubzilla-b96eb1c8230ae2f5986d6f22934c606bbca9728e.tar.gz volse-hubzilla-b96eb1c8230ae2f5986d6f22934c606bbca9728e.tar.bz2 volse-hubzilla-b96eb1c8230ae2f5986d6f22934c606bbca9728e.zip |
Merge branch 'dev' into toggle-context-help
Diffstat (limited to 'Zotlabs/Module/Msearch.php')
-rw-r--r-- | Zotlabs/Module/Msearch.php | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/Zotlabs/Module/Msearch.php b/Zotlabs/Module/Msearch.php new file mode 100644 index 000000000..e96f78e16 --- /dev/null +++ b/Zotlabs/Module/Msearch.php @@ -0,0 +1,47 @@ +<?php +namespace Zotlabs\Module; + + +class Msearch extends \Zotlabs\Web\Controller { + + function post() { + + $perpage = (($_POST['n']) ? $_POST['n'] : 80); + $page = (($_POST['p']) ? intval($_POST['p'] - 1) : 0); + $startrec = (($page+1) * $perpage) - $perpage; + + $search = $_POST['s']; + 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 `keywords` AGAINST ('%s') ", + dbesc($search) + ); + if(count($r)) + $total = $r[0]['total']; + + $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) + ); + + $results = array(); + if(count($r)) { + foreach($r as $rr) + $results[] = array( + 'name' => $rr['name'], + 'url' => z_root() . '/channel/' . $rr['nickname'], + 'photo' => z_root() . '/photo/avatar/' . $rr['uid'], + 'tags' => str_replace(array(',',' '),array(' ',' '),$rr['keywords']) + ); + } + + $output = array('total' => $total, 'items_page' => $perpage, 'page' => $page + 1, 'results' => $results); + + echo json_encode($output); + + killme(); + + } +} |