| Zeile 656 | Zeile 656 |
|---|
{
// Complex search
$keywords = " {$keywords} ";
|
{
// Complex search
$keywords = " {$keywords} ";
|
if(preg_match("# and|or #", $keywords))
| if(preg_match("#\s(and|or)\s#", $keywords))
|
{
$subject_lookin = " AND (";
$message_lookin = " AND (";
| {
$subject_lookin = " AND (";
$message_lookin = " AND (";
|
| Zeile 664 | Zeile 664 |
|---|
// Expand the string by double quotes
$keywords_exp = explode("\"", $keywords);
$inquote = false;
|
// Expand the string by double quotes
$keywords_exp = explode("\"", $keywords);
$inquote = false;
|
| | $boolean = '';
|
foreach($keywords_exp as $phrase)
{
|
foreach($keywords_exp as $phrase)
{
|
| Zeile 707 | Zeile 708 |
|---|
{
$message_lookin .= " $boolean LOWER(p.message) LIKE '%{$word}%'";
}
|
{
$message_lookin .= " $boolean LOWER(p.message) LIKE '%{$word}%'";
}
|
| | $boolean = 'AND';
|
}
}
}
| }
}
}
|
| Zeile 725 | Zeile 727 |
|---|
{
$message_lookin .= " $boolean LOWER(p.message) LIKE '%{$phrase}%'";
}
|
{
$message_lookin .= " $boolean LOWER(p.message) LIKE '%{$phrase}%'";
}
|
| | $boolean = 'AND';
|
}
if($subject_lookin == " AND (")
| }
if($subject_lookin == " AND (")
|
| Zeile 1225 | Zeile 1228 |
|---|
SELECT f.fid
FROM ".TABLE_PREFIX."forums f
LEFT JOIN ".TABLE_PREFIX."forumpermissions p ON (f.fid=p.fid AND p.gid IN (".$user_groups."))
|
SELECT f.fid
FROM ".TABLE_PREFIX."forums f
LEFT JOIN ".TABLE_PREFIX."forumpermissions p ON (f.fid=p.fid AND p.gid IN (".$user_groups."))
|
WHERE INSTR(','||parentlist||',',',$forum,') > 0 AND active!=0 AND (ISNULL(p.fid) OR p.cansearch=1)
| WHERE INSTR(','||parentlist||',',',$forum,') > 0 AND active!=0 AND ((p.fid) IS NULL OR p.cansearch=1)
|
");
break;
default:
| ");
break;
default:
|
| Zeile 1233 | Zeile 1236 |
|---|
SELECT f.fid
FROM ".TABLE_PREFIX."forums f
LEFT JOIN ".TABLE_PREFIX."forumpermissions p ON (f.fid=p.fid AND p.gid IN (".$user_groups."))
|
SELECT f.fid
FROM ".TABLE_PREFIX."forums f
LEFT JOIN ".TABLE_PREFIX."forumpermissions p ON (f.fid=p.fid AND p.gid IN (".$user_groups."))
|
WHERE INSTR(CONCAT(',',parentlist,','),',$forum,') > 0 AND active!=0 AND (ISNULL(p.fid) OR p.cansearch=1)
| WHERE INSTR(CONCAT(',',parentlist,','),',$forum,') > 0 AND active!=0 AND ((p.fid) IS NULL OR p.cansearch=1)
|
");
}
while($sforum = $db->fetch_array($query))
| ");
}
while($sforum = $db->fetch_array($query))
|