| Zeile 32 | Zeile 32 |
|---|
{
error_no_permission();
}
|
{
error_no_permission();
}
|
| |
$orderarrow = $sort_selected = array(
'regdate' => '',
'lastvisit' => '',
'reputation' => '',
'postnum' => '',
'threadnum' => '',
'referrals' => '',
'username' => ''
);
|
// Showing advanced search page?
if($mybb->get_input('action') == "search")
{
$plugins->run_hooks("memberlist_search");
add_breadcrumb($lang->nav_memberlist_search);
|
// Showing advanced search page?
if($mybb->get_input('action') == "search")
{
$plugins->run_hooks("memberlist_search");
add_breadcrumb($lang->nav_memberlist_search);
|
| |
if(isset($mybb->usergroup['usergroup']))
{
$usergroup = $mybb->usergroup['usergroup'];
}
else
{
$usergroup = '';
}
if(isset($mybb->usergroup['additionalgroups']))
{
$additionalgroups = $mybb->usergroup['additionalgroups'];
}
else
{
$additionalgroups = '';
}
|
$contact_fields = array();
|
$contact_fields = array();
|
foreach(array('aim', 'skype', 'google', 'yahoo', 'icq') as $field)
| foreach(array('skype', 'google') as $field)
|
{
$contact_fields[$field] = '';
$settingkey = 'allow'.$field.'field';
|
{
$contact_fields[$field] = '';
$settingkey = 'allow'.$field.'field';
|
if($mybb->settings[$settingkey] != '' && is_member($mybb->settings[$settingkey], array('usergroup' => $mybb->usergroup['usergroup'], 'additionalgroups' => $mybb->usergroup['additionalgroups'])))
| if($mybb->settings[$settingkey] != '' && is_member($mybb->settings[$settingkey], array('usergroup' => $usergroup, 'additionalgroups' => $additionalgroups)))
|
{
$tmpl = 'memberlist_search_'.$field;
| {
$tmpl = 'memberlist_search_'.$field;
|
| Zeile 55 | Zeile 82 |
|---|
$bgcolors[$field] = alt_trow();
eval('$contact_fields[\''.$field.'\'] = "'.$templates->get('memberlist_search_contact_field').'";');
}
|
$bgcolors[$field] = alt_trow();
eval('$contact_fields[\''.$field.'\'] = "'.$templates->get('memberlist_search_contact_field').'";');
}
|
| | }
$referrals_option = '';
if($mybb->settings['usereferrals'] == 1)
{
eval("\$referrals_option = \"".$templates->get("memberlist_referrals_option")."\";");
|
}
eval("\$search_page = \"".$templates->get("memberlist_search")."\";");
| }
eval("\$search_page = \"".$templates->get("memberlist_search")."\";");
|
| Zeile 71 | Zeile 104 |
|---|
$mybb->input['sort'] = strtolower($mybb->get_input('sort'));
}
else
|
$mybb->input['sort'] = strtolower($mybb->get_input('sort'));
}
else
|
{
| {
|
$mybb->input['sort'] = $mybb->settings['default_memberlist_sortby'];
}
|
$mybb->input['sort'] = $mybb->settings['default_memberlist_sortby'];
}
|
$sort_selected = array(
'regdate' => '',
'lastvisit' => '',
'reputation' => '',
'postnum' => '',
'referrals' => '',
'username' => ''
);
| |
switch($mybb->input['sort'])
{
|
switch($mybb->input['sort'])
{
|
| Zeile 91 | Zeile 115 |
|---|
break;
case "lastvisit":
$sort_field = "u.lastactive";
|
break;
case "lastvisit":
$sort_field = "u.lastactive";
|
break;
| break;
|
case "reputation":
$sort_field = "u.reputation";
break;
case "postnum":
$sort_field = "u.postnum";
|
case "reputation":
$sort_field = "u.reputation";
break;
case "postnum":
$sort_field = "u.postnum";
|
break;
| break;
|
case "threadnum":
$sort_field = "u.threadnum";
break;
case "referrals":
|
case "threadnum":
$sort_field = "u.threadnum";
break;
case "referrals":
|
$sort_field = "u.referrals";
| if($mybb->settings['usereferrals'] == 1)
{
$sort_field = "u.referrals";
}
else
{
$sort_field = "u.username";
}
|
break;
default:
$sort_field = "u.username";
| break;
default:
$sort_field = "u.username";
|
| Zeile 110 | Zeile 141 |
|---|
break;
}
$sort_selected[$mybb->input['sort']] = " selected=\"selected\"";
|
break;
}
$sort_selected[$mybb->input['sort']] = " selected=\"selected\"";
|
|
|
// Incoming sort order?
if(isset($mybb->input['order']))
{
$mybb->input['order'] = strtolower($mybb->input['order']);
|
// Incoming sort order?
if(isset($mybb->input['order']))
{
$mybb->input['order'] = strtolower($mybb->input['order']);
|
}
| }
|
else
{
$mybb->input['order'] = strtolower($mybb->settings['default_memberlist_order']);
| else
{
$mybb->input['order'] = strtolower($mybb->settings['default_memberlist_order']);
|
| Zeile 139 | Zeile 170 |
|---|
$mybb->input['order'] = "descending";
}
$order_check[$mybb->input['order']] = " checked=\"checked\"";
|
$mybb->input['order'] = "descending";
}
$order_check[$mybb->input['order']] = " checked=\"checked\"";
|
| |
if($sort_field == 'u.lastactive' && $mybb->usergroup['canviewwolinvis'] == 0)
{
$sort_field = "u.invisible ASC, CASE WHEN u.invisible = 1 THEN u.regdate ELSE u.lastactive END";
}
|
// Incoming results per page?
$mybb->input['perpage'] = $mybb->get_input('perpage', MyBB::INPUT_INT);
|
// Incoming results per page?
$mybb->input['perpage'] = $mybb->get_input('perpage', MyBB::INPUT_INT);
|
| Zeile 157 | Zeile 193 |
|---|
$search_query = '1=1';
$search_url = "";
|
$search_query = '1=1';
$search_url = "";
|
| |
switch($db->type)
{
// PostgreSQL's LIKE is case sensitive
case "pgsql":
$like = "ILIKE";
break;
default:
$like = "LIKE";
}
|
// Limiting results to a certain letter
if(isset($mybb->input['letter']))
|
// Limiting results to a certain letter
if(isset($mybb->input['letter']))
|
| Zeile 167 | Zeile 213 |
|---|
$search_query .= " AND u.username NOT REGEXP('[a-zA-Z]')";
}
else if(strlen($letter) == 1)
|
$search_query .= " AND u.username NOT REGEXP('[a-zA-Z]')";
}
else if(strlen($letter) == 1)
|
{
$search_query .= " AND u.username LIKE '".$db->escape_string_like($letter)."%'";
| {
$search_query .= " AND u.username {$like} '".$db->escape_string_like($letter)."%'";
|
}
$search_url .= "&letter={$letter}";
}
| }
$search_url .= "&letter={$letter}";
}
|
| Zeile 180 | Zeile 226 |
|---|
$username_like_query = $db->escape_string_like($search_username);
// Name begins with
|
$username_like_query = $db->escape_string_like($search_username);
// Name begins with
|
if($mybb->input['username_match'] == "begins")
{
$search_query .= " AND u.username LIKE '".$username_like_query."%'";
| if($mybb->get_input('username_match') == "begins")
{
$search_query .= " AND u.username {$like} '".$username_like_query."%'";
|
$search_url .= "&username_match=begins";
|
$search_url .= "&username_match=begins";
|
}
| }
|
// Just contains
|
// Just contains
|
| | else if($mybb->get_input('username_match') == "contains")
{
$search_query .= " AND u.username {$like} '%".$username_like_query."%'";
$search_url .= "&username_match=contains";
}
// Exact
|
else
{
|
else
{
|
$search_query .= " AND u.username LIKE '%".$username_like_query."%'";
| $username_esc = $db->escape_string(my_strtolower($search_username));
$search_query .= " AND LOWER(u.username)='{$username_esc}'";
|
}
$search_url .= "&username=".urlencode($search_username);
| }
$search_url .= "&username=".urlencode($search_username);
|
| Zeile 199 | Zeile 252 |
|---|
$search_website = htmlspecialchars_uni($mybb->input['website']);
if(trim($mybb->input['website']))
{
|
$search_website = htmlspecialchars_uni($mybb->input['website']);
if(trim($mybb->input['website']))
{
|
$search_query .= " AND u.website LIKE '%".$db->escape_string_like($mybb->input['website'])."%'";
| $search_query .= " AND u.website {$like} '%".$db->escape_string_like($mybb->input['website'])."%'";
|
$search_url .= "&website=".urlencode($mybb->input['website']);
}
// Search by contact field input
|
$search_url .= "&website=".urlencode($mybb->input['website']);
}
// Search by contact field input
|
foreach(array('aim', 'icq', 'google', 'skype', 'yahoo') as $cfield)
| foreach(array('google', 'skype') as $cfield)
|
{
$csetting = 'allow'.$cfield.'field';
$mybb->input[$cfield] = trim($mybb->get_input($cfield));
| {
$csetting = 'allow'.$cfield.'field';
$mybb->input[$cfield] = trim($mybb->get_input($cfield));
|
| Zeile 234 | Zeile 287 |
|---|
}
$search_query .= ")";
}
|
}
$search_query .= ")";
}
|
if($cfield == 'icq')
{
$search_query .= " AND u.{$cfield} LIKE '%".(int)$mybb->input[$cfield]."%'";
}
else
{
$search_query .= " AND u.{$cfield} LIKE '%".$db->escape_string_like($mybb->input[$cfield])."%'";
}
|
$search_query .= " AND u.{$cfield} {$like} '%".$db->escape_string_like($mybb->input[$cfield])."%'";
|
$search_url .= "&{$cfield}=".urlencode($mybb->input[$cfield]);
|
$search_url .= "&{$cfield}=".urlencode($mybb->input[$cfield]);
|
}
}
$usergroups_cache = $cache->read('usergroups');
| }
}
$usergroups_cache = $cache->read('usergroups');
|
$group = array();
foreach($usergroups_cache as $gid => $groupcache)
{
if($groupcache['showmemberlist'] == 0)
{
$group[] = (int)$gid;
|
$group = array();
foreach($usergroups_cache as $gid => $groupcache)
{
if($groupcache['showmemberlist'] == 0)
{
$group[] = (int)$gid;
|
}
| }
|
}
if(is_array($group) && !empty($group))
{
$hiddengroup = implode(',', $group);
|
}
if(is_array($group) && !empty($group))
{
$hiddengroup = implode(',', $group);
|
|
|
$search_query .= " AND u.usergroup NOT IN ({$hiddengroup})";
foreach($group as $hidegid)
| $search_query .= " AND u.usergroup NOT IN ({$hiddengroup})";
foreach($group as $hidegid)
|
| Zeile 290 | Zeile 337 |
|---|
if($page && $page > 0)
{
$start = ($page - 1) * $per_page;
|
if($page && $page > 0)
{
$start = ($page - 1) * $per_page;
|
| | $pages = ceil($num_users / $per_page);
if($page > $pages)
{
$start = 0;
$page = 1;
}
|
}
else
{
$start = 0;
$page = 1;
|
}
else
{
$start = 0;
$page = 1;
|
}
| }
|
$sort = htmlspecialchars_uni($mybb->input['sort']);
eval("\$orderarrow['{$sort}'] = \"".$templates->get("memberlist_orderarrow")."\";");
|
$sort = htmlspecialchars_uni($mybb->input['sort']);
eval("\$orderarrow['{$sort}'] = \"".$templates->get("memberlist_orderarrow")."\";");
|
| |
$referral_header = '';
|
// Referral?
if($mybb->settings['usereferrals'] == 1)
|
// Referral?
if($mybb->settings['usereferrals'] == 1)
|
| Zeile 336 | Zeile 391 |
|---|
$user['profilelink'] = build_profile_link($user['username'], $user['uid']);
// Get the display usergroup
|
$user['profilelink'] = build_profile_link($user['username'], $user['uid']);
// Get the display usergroup
|
if(empty($user['displaygroup']))
| if($user['usergroup'])
{
$usergroup = usergroup_permissions($user['usergroup']);
}
else
{
$usergroup = usergroup_permissions(1);
}
$displaygroupfields = array("title", "description", "namestyle", "usertitle", "stars", "starimage", "image");
if(!$user['displaygroup'])
|
{
$user['displaygroup'] = $user['usergroup'];
|
{
$user['displaygroup'] = $user['usergroup'];
|
}
$usergroup = $usergroups_cache[$user['displaygroup']];
| }
$display_group = usergroup_displaygroup($user['displaygroup']);
if(is_array($display_group))
{
$usergroup = array_merge($usergroup, $display_group);
}
$referral_bit = '';
|
// Build referral?
if($mybb->settings['usereferrals'] == 1)
{
|
// Build referral?
if($mybb->settings['usereferrals'] == 1)
{
|
eval("\$referral_bit = \"".$templates->get("memberlist_referrals_bit")."\";");
}
| $referral_count = (int) $user['referrals'];
if($referral_count > 0)
{
$uid = (int) $user['uid'];
eval("\$user['referrals'] = \"".$templates->get('member_referrals_link')."\";");
}
eval("\$referral_bit = \"".$templates->get("memberlist_referrals_bit")."\";");
}
|
$usergroup['groupimage'] = '';
// Work out the usergroup/title stuff
|
$usergroup['groupimage'] = '';
// Work out the usergroup/title stuff
|
| Zeile 405 | Zeile 485 |
|---|
}
$user['userstars'] = '';
|
}
$user['userstars'] = '';
|
if(!empty($user['starimage']))
| if(!empty($user['starimage']) && isset($user['stars']))
|
{
// Only display stars if we have an image to use...
$starimage = str_replace("{theme}", $theme['imgdir'], $user['starimage']);
| {
// Only display stars if we have an image to use...
$starimage = str_replace("{theme}", $theme['imgdir'], $user['starimage']);
|
| Zeile 425 | Zeile 505 |
|---|
$useravatar = format_avatar($user['avatar'], $user['avatardimensions'], my_strtolower($mybb->settings['memberlistmaxavatarsize']));
eval("\$user['avatar'] = \"".$templates->get("memberlist_user_avatar")."\";");
|
$useravatar = format_avatar($user['avatar'], $user['avatardimensions'], my_strtolower($mybb->settings['memberlistmaxavatarsize']));
eval("\$user['avatar'] = \"".$templates->get("memberlist_user_avatar")."\";");
|
if($user['invisible'] == 1 && $mybb->usergroup['canviewwolinvis'] != 1 && $user['uid'] != $mybb->user['uid'])
| $last_seen = max(array($user['lastactive'], $user['lastvisit']));
if(empty($last_seen))
|
{
$user['lastvisit'] = $lang->lastvisit_never;
|
{
$user['lastvisit'] = $lang->lastvisit_never;
|
if($user['lastvisit'])
| }
else
{
// We have some stamp here
if($user['invisible'] == 1 && $mybb->usergroup['canviewwolinvis'] != 1 && $user['uid'] != $mybb->user['uid'])
|
{
|
{
|
// We have had at least some active time, hide it instead
| |
$user['lastvisit'] = $lang->lastvisit_hidden;
}
|
$user['lastvisit'] = $lang->lastvisit_hidden;
}
|
}
else
{
$user['lastvisit'] = my_date('relative', $user['lastactive']);
| else
{
$user['lastvisit'] = my_date('relative', $last_seen);
}
|
}
$user['regdate'] = my_date('relative', $user['regdate']);
$user['postnum'] = my_number_format($user['postnum']);
$user['threadnum'] = my_number_format($user['threadnum']);
eval("\$users .= \"".$templates->get("memberlist_user")."\";");
|
}
$user['regdate'] = my_date('relative', $user['regdate']);
$user['postnum'] = my_number_format($user['postnum']);
$user['threadnum'] = my_number_format($user['threadnum']);
eval("\$users .= \"".$templates->get("memberlist_user")."\";");
|
}
| }
|
// Do we have no results?
if(!$users)
{
eval("\$users = \"".$templates->get("memberlist_error")."\";");
|
// Do we have no results?
if(!$users)
{
eval("\$users = \"".$templates->get("memberlist_error")."\";");
|
| | }
$referrals_option = '';
if($mybb->settings['usereferrals'] == 1)
{
eval("\$referrals_option = \"".$templates->get("memberlist_referrals_option")."\";");
|
}
$plugins->run_hooks("memberlist_end");
| }
$plugins->run_hooks("memberlist_end");
|