| Zeile 157 | Zeile 157 |
|---|
$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 168 | Zeile 178 |
|---|
}
else if(strlen($letter) == 1)
{
|
}
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 182 | Zeile 192 |
|---|
// Name begins with
if($mybb->input['username_match'] == "begins")
{
|
// Name begins with
if($mybb->input['username_match'] == "begins")
{
|
$search_query .= " AND u.username LIKE '".$username_like_query."%'";
| $search_query .= " AND u.username {$like} '".$username_like_query."%'";
|
$search_url .= "&username_match=begins";
}
// Just contains
else
{
|
$search_url .= "&username_match=begins";
}
// Just contains
else
{
|
$search_query .= " AND u.username LIKE '%".$username_like_query."%'";
| $search_query .= " AND u.username {$like} '%".$username_like_query."%'";
|
}
$search_url .= "&username=".urlencode($search_username);
| }
$search_url .= "&username=".urlencode($search_username);
|
| Zeile 199 | Zeile 209 |
|---|
$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_url .= "&website=".urlencode($mybb->input['website']);
}
|
| Zeile 240 | Zeile 250 |
|---|
}
else
{
|
}
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]);
}
|