From cb54cda17454fde783c165c37d6ece1ba2067253 Mon Sep 17 00:00:00 2001 From: Mike Macgirvin Date: Fri, 9 Jul 2010 22:47:32 -0700 Subject: more directory work --- mod/directory.php | 14 +++++++++++--- 1 file changed, 11 insertions(+), 3 deletions(-) (limited to 'mod') diff --git a/mod/directory.php b/mod/directory.php index 0a7d7355e..aec34f910 100644 --- a/mod/directory.php +++ b/mod/directory.php @@ -3,14 +3,20 @@ function directory_content(&$a) { + $search = ((x($_GET,'search')) ? notags(trim($_GET['search'])) : ''); $tpl .= file_get_contents('view/directory_header.tpl'); $o .= replace_macros($tpl, array( + '$search' => $search )); - $r = q("SELECT `profile`.*, `profile`.`uid` AS `profile_uid`, `user`.`nickname` FROM `profile` LEFT JOIN `user` ON `user`.`uid` = `profile`.`uid` WHERE `is-default` = 1 AND `publish` = 1 ORDER BY `name` ASC"); + if($search) + $search = dbesc($search); + $sql_extra = ((strlen($search)) ? " AND MATCH (`profile`.`name`, `user`.`nickname`, `locality`,`region`,`country-name`,`gender`,`marital`,`sexual`,`about`,`romance`,`employer`,`school`) AGAINST ('$search' IN BOOLEAN MODE) " : ""); + + $r = q("SELECT `profile`.*, `profile`.`uid` AS `profile_uid`, `user`.`nickname`, `user`.`timezone` FROM `profile` LEFT JOIN `user` ON `user`.`uid` = `profile`.`uid` WHERE `is-default` = 1 AND `publish` = 1 $sql_extra ORDER BY `name` ASC"); if(count($r)) { $tpl = file_get_contents('view/directory_item.tpl'); @@ -36,8 +42,10 @@ function directory_content(&$a) { $details .= ', '; $details .= $rr['country-name']; } - if(strlen($rr['dob'])) - $details .= '
Age: ' ; // . calculate age($rr['dob'])) ; + if(strlen($rr['dob'])) { + if(($years = age($rr['dob'],$rr['timezone'],'')) != 0) + $details .= "
Age: $years" ; + } if(strlen($rr['gender'])) $details .= '
Gender: ' . $rr['gender']; -- cgit v1.2.3