PHP addslashes_like函数代码示例

function search_gallery($items, $conn)
{
    global $set, $db, $apx, $user;
    require_once BASEDIR . getmodulepath('gallery') . 'functions.php';
    //Suchstring generieren
    $tagmatches = gallery_match_tags($items);
    foreach ($items as $item) {
        $tagmatch = array_shift($tagmatches);
        $search1[] = "caption LIKE '" . addslashes_like($item) . "'";
        $search2[] = " ( " . iif($tagmatch, " id IN (" . implode(',', $tagmatch) . ") OR ") . " title LIKE '%" . addslashes_like($item) . "%' OR description LIKE '%" . addslashes_like($item) . "%' ) ";
    }
    $searchstring1 = implode($conn, $search1);
    $searchstring2 = implode($conn, $search2);
    //Bilder durchsuchen
    $data = $db->fetch("SELECT galid FROM " . PRE . "_gallery_pics WHERE ( active='1' AND ( " . $searchstring1 . " ) ) GROUP BY galid");
    $galids = get_ids($data, 'galid');
    if (count($galids)) {
        $picres = " id IN (" . @implode(',', $galids) . ") OR ";
    }
    //Ergebnisse
    $data = $db->fetch("SELECT id,title FROM " . PRE . "_gallery WHERE ( searchable='1' AND '" . time() . "' BETWEEN starttime AND endtime " . section_filter() . " AND ( " . $picres . " ( " . $searchstring2 . " ) ) ) ORDER BY title ASC");
    if (count($data)) {
        foreach ($data as $res) {
            ++$i;
            $result[$i]['TITLE'] = strip_tags($res['title']);
            $result[$i]['LINK'] = mklink('gallery.php?id=' . $res['id'], 'gallery,list' . $res['id'] . ',1' . urlformat($res['title']) . '.html');
        }
    }
    return $result;
}

function products_match_tags($items)
{
    global $set, $db, $apx, $user;
    if (!is_array($items)) {
        return array();
    }
    $result = array();
    foreach ($items as $item) {
        $data = $db->fetch("\n\t\t\tSELECT DISTINCT at.id\n\t\t\tFROM " . PRE . "_products_tags AS at\n\t\t\tLEFT JOIN " . PRE . "_tags AS t USING(tagid)\n\t\t\tWHERE t.tag LIKE '%" . addslashes_like($item) . "%'\n\t\t");
        $result[$item] = get_ids($data, 'id');
    }
    return $result;
}

function search_poll($items, $conn)
{
    global $set, $db, $apx, $user;
    require_once BASEDIR . getmodulepath('poll') . 'functions.php';
    $tagmatches = poll_match_tags($items);
    foreach ($items as $item) {
        $tagmatch = array_shift($tagmatches);
        $query = " ( " . iif($tagmatch, " id IN (" . implode(',', $tagmatch) . ") OR ") . " question LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a1 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a2 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a3 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a4 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a5 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a6 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a7 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a8 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a9 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a10 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a11 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a12 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a13 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a14 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a15 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a16 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a17 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a18 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a19 LIKE '%" . addslashes_like($item) . "%'";
        $query .= " OR a20 LIKE '%" . addslashes_like($item) . "%' )";
        $search[] = $query;
    }
    $searchstring = implode($conn, $search);
    //Aktuelle Umfrage
    require_once BASEDIR . getmodulepath('poll') . 'functions.php';
    $recent = poll_recent();
    //Ergebnisse
    $data = $db->fetch("SELECT id,question FROM " . PRE . "_poll WHERE ( searchable='1' AND '" . time() . "' BETWEEN starttime AND endtime " . section_filter() . " AND ( " . $searchstring . " ) ) ORDER BY starttime DESC");
    if (count($data)) {
        foreach ($data as $res) {
            ++$i;
            if ($res['id'] == $recent) {
                $link = mklink('poll.php?recent=1', 'poll,recent.html');
            } else {
                $link = mklink('poll.php?id=' . $res['id'], 'poll,' . $res['id'] . '.html');
            }
            $result[$i]['TITLE'] = strip_tags($res['question']);
            $result[$i]['LINK'] = $link;
        }
    }
    return $result;
}

function search_user($items, $conn)
{
    global $set, $db, $apx, $user;
    //Suchstring generieren
    foreach ($items as $item) {
        $search[] = "username LIKE '%" . addslashes_like($item) . "%'";
    }
    //Ergebnisse
    $data = $db->fetch("SELECT userid,username FROM " . PRE . "_user WHERE ( " . implode($conn, $search) . " ) ORDER BY username ASC");
    if (count($data)) {
        foreach ($data as $res) {
            ++$i;
            $result[$i]['TITLE'] = $res['username'];
            $result[$i]['LINK'] = $user->mkprofile($res['userid'], $res['username']);
        }
    }
    return $result;
}

 function searchuser()
 {
     global $set, $db, $apx;
     $apx->tmpl->loaddesign('blank');
     if ($_POST['send']) {
         $data = $db->fetch("SELECT userid,username_login FROM " . PRE . "_user WHERE username_login LIKE '%" . addslashes_like($_POST['item']) . "%' OR username LIKE '%" . addslashes_like($_POST['item']) . "%' ORDER BY username_login ASC");
         if (count($data)) {
             foreach ($data as $res) {
                 ++$i;
                 $tabledata[$i]['ID'] = $res['userid'];
                 $tabledata[$i]['NAME'] = $res['username_login'];
                 $tabledata[$i]['INSERT'] = addslashes($res['username_login']);
             }
         }
     }
     $apx->tmpl->assign('RESULT', $tabledata);
     $apx->tmpl->assign('ITEM', compatible_hsc($_POST['item']));
     $apx->tmpl->assign('INSERTFUNC', $_REQUEST['insertfunc']);
     $apx->tmpl->parse('searchuser');
 }

function suggesttag()
{
    global $apx, $db, $set;
    $max = 5;
    $taglist = array();
    $data = $db->fetch("\n\t\tSELECT DISTINCT tagid, tag\n\t\tFROM " . PRE . "_tags\n\t\tWHERE tag LIKE '" . addslashes_like(utf8_decode($_REQUEST['query'])) . "%'\n\t\tORDER BY tag ASC\n\t\tLIMIT " . $max . "\n\t");
    $rows = $query->num_rows;
    $ids = array(-1);
    foreach ($data as $res) {
        echo utf8_encode($res['tag']) . "\n";
        $ids[] = $res['tagid'];
    }
    //Ergebnisliste erweitern
    if ($rows < $max) {
        $data = $db->fetch("\n\t\t\tSELECT DISTINCT tagid, tag\n\t\t\tFROM " . PRE . "_tags\n\t\t\tWHERE tag LIKE '%" . addslashes_like($_REQUEST['query']) . "%' AND tagid NOT IN (" . implode(',', $ids) . ")\n\t\t\tORDER BY tag ASC\n\t\t\tLIMIT " . ($max - $rows) . "\n\t\t");
        foreach ($data as $res) {
            echo utf8_encode($res['tag']) . "\n";
        }
    }
}

function search_faq($items, $conn)
{
    global $set, $db, $apx, $user;
    //Suchstring generieren
    foreach ($items as $item) {
        $search[] = " ( question LIKE '%" . addslashes_like($item) . "%' OR answer LIKE '%" . addslashes_like($item) . "%' ) ";
    }
    $searchstring = implode($conn, $search);
    //Ergebnisse
    $data = $db->fetch("SELECT id,question FROM " . PRE . "_faq WHERE ( searchable='1' AND starttime!='0' AND ( " . $searchstring . " ) ) ORDER BY starttime DESC");
    if (count($data)) {
        foreach ($data as $res) {
            ++$i;
            $link = mklink('faq.php?id=' . $res['id'], 'faq,' . $res['id'] . urlformat($res['question']) . '.html');
            $result[$i]['TITLE'] = strip_tags($res['question']);
            $result[$i]['LINK'] = $link;
        }
    }
    return $result;
}

function search_videos($items, $conn)
{
    global $set, $db, $apx, $user;
    require_once BASEDIR . getmodulepath('videos') . 'functions.php';
    //Suchstring generieren
    $tagmatches = videos_match_tags($items);
    foreach ($items as $item) {
        $tagmatch = array_shift($tagmatches);
        $search[] = " ( " . iif($tagmatch, " id IN (" . implode(',', $tagmatch) . ") OR ") . " title LIKE '%" . addslashes_like($item) . "%' OR text LIKE '%" . addslashes_like($item) . "%' ) ";
    }
    $searchstring = implode($conn, $search);
    //Videos durchsuchen
    $data = $db->fetch("SELECT id,title FROM " . PRE . "_videos WHERE ( searchable='1' AND '" . time() . "' BETWEEN starttime AND endtime " . section_filter() . " AND ( " . $searchstring . " ) ) ORDER BY addtime DESC");
    if (count($data)) {
        foreach ($data as $res) {
            ++$i;
            $result[$i]['TITLE'] = $res['title'];
            $result[$i]['LINK'] = mklink('videos.php?id=' . $res['id'], 'videos,id' . $res['id'] . urlformat($res['title']) . '.html');
        }
    }
    return $result;
}

function search_glossar($items, $conn)
{
    global $set, $db, $apx, $user;
    require_once BASEDIR . getmodulepath('glossar') . 'functions.php';
    //Suchstring generieren
    $tagmatches = glossar_match_tags($items);
    foreach ($items as $item) {
        $tagmatch = array_shift($tagmatches);
        $search[] = " ( " . iif($tagmatch, " id IN (" . implode(',', $tagmatch) . ") OR ") . " title LIKE '%" . addslashes_like($item) . "%' OR text LIKE '%" . addslashes_like($item) . "%' ) ";
    }
    $searchstring = implode($conn, $search);
    //Ergebnisse
    $data = $db->fetch("SELECT id,title FROM " . PRE . "_glossar WHERE ( searchable='1' AND starttime!='0' AND ( " . $searchstring . " ) ) ORDER BY title ASC");
    if (count($data)) {
        foreach ($data as $res) {
            ++$i;
            $result[$i]['TITLE'] = strip_tags($res['title']);
            $result[$i]['LINK'] = mklink('glossar.php?id=' . $res['id'], 'glossar,id' . $res['id'] . urlformat($res['title']) . '.html');
        }
    }
    return $result;
}

function search_content($items, $conn)
{
    global $set, $db, $apx, $user;
    //Suchstring generieren
    foreach ($items as $item) {
        $search[] = " ( title LIKE '%" . addslashes_like($item) . "%' OR text LIKE '%" . addslashes_like($item) . "%' ) ";
    }
    $searchstring = implode($conn, $search);
    //Ergebnisse
    $data = $db->fetch("SELECT id,title FROM " . PRE . "_content WHERE ( searchable='1' AND active='1' " . section_filter() . " AND ( " . $searchstring . " ) ) ORDER BY title ASC");
    if (count($data)) {
        foreach ($data as $res) {
            ++$i;
            $temp = explode('->', $res['title']);
            $title = array_pop($temp);
            $link = mklink('content.php?id=' . $res['id'], 'content,' . $res['id'] . urlformat($title) . '.html');
            $result[$i]['TITLE'] = strip_tags($title);
            $result[$i]['LINK'] = $link;
        }
    }
    return $result;
}

function search_calendar($items, $conn)
{
    global $set, $db, $apx, $user;
    require_once BASEDIR . getmodulepath('calendar') . 'functions.php';
    //Suchstring generieren
    $tagmatches = calendar_match_tags($items);
    foreach ($items as $item) {
        $tagmatch = array_shift($tagmatches);
        $search[] = " ( " . iif($tagmatch, " id IN (" . implode(',', $tagmatch) . ") OR ") . " title LIKE '%" . addslashes_like($item) . "%' OR text LIKE '%" . addslashes_like($item) . "%' ) ";
    }
    $searchstring = implode($conn, $search);
    //Ergebnisse
    $data = $db->fetch("SELECT id,title FROM " . PRE . "_calendar_events WHERE ( active!=0 AND private=0 " . section_filter() . " AND ( " . $searchstring . " ) ) ORDER BY startday ASC, starttime ASC, title ASC");
    if (count($data)) {
        foreach ($data as $res) {
            ++$i;
            $link = mklink('events.php?id=' . $res['id'], 'events,id' . $res['id'] . urlformat($res['title']) . '.html');
            $result[$i]['TITLE'] = strip_tags($res['title']);
            $result[$i]['LINK'] = $link;
        }
    }
    return $result;
}

function search_articles($items, $conn)
{
    global $set, $db, $apx, $user;
    require_once BASEDIR . getmodulepath('articles') . 'functions.php';
    //Suchstrings generieren
    $tagmatches = articles_match_tags($items);
    foreach ($items as $item) {
        $tagmatch = array_shift($tagmatches);
        $search1[] = "( title LIKE '%" . addslashes_like($item) . "%' OR text LIKE '%" . addslashes_like($item) . "%' ) ";
        $search2[] = "( " . iif($tagmatch, " id IN (" . implode(',', $tagmatch) . ") OR ") . " title LIKE '%" . addslashes_like($item) . "%' OR subtitle LIKE '%" . addslashes_like($item) . "%' OR teaser LIKE '%" . addslashes_like($item) . "%' ) ";
    }
    $searchstring1 = "( " . implode($conn, $search1) . " )";
    $searchstring2 = "( " . implode($conn, $search2) . " )";
    //Seiten durchsuchen
    $data = $db->fetch("SELECT artid FROM " . PRE . "_articles_pages WHERE ( " . $searchstring1 . " ) GROUP BY artid");
    $artids = get_ids($data, 'artid');
    if (count($artids)) {
        $pageres = "id IN (" . @implode(',', $artids) . ") OR";
    }
    //Artikel durchsuchen
    $data = $db->fetch("SELECT id,type,title,subtitle FROM " . PRE . "_articles WHERE ( searchable='1' AND '" . time() . "' BETWEEN starttime AND endtime " . section_filter() . " AND ( " . $pageres . " " . $searchstring2 . " ) ) ORDER BY starttime DESC");
    if (count($data)) {
        foreach ($data as $res) {
            ++$i;
            //Wohin soll verlinkt werden?
            if ($res['type'] == 'normal') {
                $link2file = 'articles';
            } else {
                $link2file = $res['type'] . 's';
            }
            $link = mklink($link2file . '.php?id=' . $res['id'], $link2file . ',id' . $res['id'] . ',0' . urlformat($res['title']) . '.html');
            $result[$i]['TITLE'] = strip_tags($res['title']) . iif($res['subtitle'], ' - ' . strip_tags($res['subtitle']));
            $result[$i]['LINK'] = $link;
        }
    }
    return $result;
}

//////////////////////////////////////////////////////////// SYSTEMSTART ///
////////////////////////////////////////////////////////////////////////////////////////////////////////
$apx->module('newsletter');
$apx->lang->drop('form');
headline($apx->lang->get('HEADLINE'), mklink('newsletter.php', 'newsletter.html'));
titlebar($apx->lang->get('HEADLINE'));
$_REQUEST['activate'] = (int) $_REQUEST['activate'];
////////////////////////////////////////////////////////////////////////////////////////////////////////
//Aktivierungscode anfordern
if ($_REQUEST['getcode']) {
    if (!$set['newsletter']['regcode']) {
        exit;
    }
    $apx->lang->drop('getcode');
    if ($_POST['send']) {
        list($aboId) = $db->first("SELECT id FROM " . PRE . "_newsletter_emails WHERE email LIKE '" . addslashes_like($_POST['email']) . "' LIMIT 1");
        if (!$_POST['email']) {
            message('back');
        } elseif (!$aboId) {
            message($apx->lang->get('MSG_NOEMAIL'), 'back');
        } else {
            $insert = array();
            $remove = array();
            //Abonnements
            $data = $db->fetch("\n\t\t\t\tSELECT catid, incode, outcode, active\n\t\t\t\tFROM " . PRE . "_newsletter_emails_cat\n\t\t\t\tWHERE eid='" . $aboId . "' AND ( ( incode!='' AND active=0 ) OR outcode!='' )\n\t\t\t");
            foreach ($data as $res) {
                if ($res['outcode']) {
                    $remove[] = $res['catid'];
                }
                if ($res['incode'] && !$res['active']) {
                    $insert[] = $res['catid'];

 function show()
 {
     global $set, $db, $apx, $html;
     $todaystamp = date('Ymd', time() - TIMEDIFF);
     //Suche durchführen
     if ($_REQUEST['item'] && ($_REQUEST['title'] || $_REQUEST['text']) || $_REQUEST['secid'] || $_REQUEST['catid'] || $_REQUEST['userid'] || $_REQUEST['start_day'] && $_REQUEST['start_month'] && $_REQUEST['start_year'] || $_REQUEST['end_day'] && $_REQUEST['end_month'] && $_REQUEST['end_year']) {
         $where = '';
         $_REQUEST['catid'] = (int) $_REQUEST['catid'];
         $_REQUEST['secid'] = (int) $_REQUEST['secid'];
         $_REQUEST['userid'] = (int) $_REQUEST['userid'];
         $_REQUEST['start_day'] = (int) $_REQUEST['start_day'];
         $_REQUEST['start_month'] = (int) $_REQUEST['start_month'];
         $_REQUEST['start_year'] = (int) $_REQUEST['start_year'];
         $_REQUEST['end_day'] = (int) $_REQUEST['end_day'];
         $_REQUEST['end_month'] = (int) $_REQUEST['end_month'];
         $_REQUEST['end_year'] = (int) $_REQUEST['end_year'];
         if (!($_REQUEST['start_day'] && $_REQUEST['start_month'] && $_REQUEST['start_year'])) {
             unset($_REQUEST['start_day'], $_REQUEST['start_month'], $_REQUEST['start_year']);
         }
         if (!($_REQUEST['end_day'] && $_REQUEST['end_month'] && $_REQUEST['end_year'])) {
             unset($_REQUEST['end_day'], $_REQUEST['end_month'], $_REQUEST['end_year']);
         }
         //Suchbegriff
         if ($_REQUEST['item']) {
             if ($_REQUEST['title']) {
                 $sc[] = "a.title LIKE '%" . addslashes_like($_REQUEST['item']) . "%'";
             }
             if ($_REQUEST['text']) {
                 $sc[] = "a.text LIKE '%" . addslashes_like($_REQUEST['item']) . "%'";
             }
             if (is_array($sc)) {
                 $where .= ' AND ( ' . implode(' OR ', $sc) . ' )';
             }
         }
         //Zeitraum
         if ($_REQUEST['start_day'] && $_REQUEST['start_month'] && $_REQUEST['start_year'] && $_REQUEST['end_day'] && $_REQUEST['end_month'] && $_REQUEST['end_year']) {
             $startstamp = sprintf('%04d%02d%02d', $_REQUEST['start_year'], $_REQUEST['start_month'], $_REQUEST['start_day']);
             $endstamp = sprintf('%04d%02d%02d', $_REQUEST['end_year'], $_REQUEST['end_month'], $_REQUEST['end_day']);
             $where .= " AND '" . $startstamp . "'<=endday AND '" . $endstamp . "'>=startday ";
         } elseif ($_REQUEST['start_day'] && $_REQUEST['start_month'] && $_REQUEST['start_year']) {
             $startstamp = sprintf('%04d%02d%02d', $_REQUEST['start_year'], $_REQUEST['start_month'], $_REQUEST['start_day']);
             $where .= " AND startday>=" . $startstamp . " ";
         } elseif ($_REQUEST['end_day'] && $_REQUEST['end_month'] && $_REQUEST['end_year']) {
             $endstamp = sprintf('%04d%02d%02d', $_REQUEST['end_year'], $_REQUEST['end_month'], $_REQUEST['end_day']);
             $where .= " AND endday<=" . $endstamp . " ";
         }
         //Sektion
         if (!$apx->session->get('section') && $_REQUEST['secid']) {
             $where .= " AND ( secid LIKE '%|" . $_REQUEST['secid'] . "|%' OR secid='all' ) ";
         }
         //Kategorie
         if ($_REQUEST['catid']) {
             if ($set['gallery']['subcats']) {
                 $tree = $this->cat->getChildrenIds($_REQUEST['catid']);
                 $tree[] = $_REQUEST['catid'];
                 if (is_array($tree)) {
                     $where .= " AND catid IN (" . implode(',', $tree) . ") ";
                 }
             } else {
                 $where .= " AND catid='" . $_REQUEST['catid'] . "' ";
             }
         }
         //Benutzer
         if ($_REQUEST['userid']) {
             $where .= " AND userid='" . $_REQUEST['userid'] . "' ";
         }
         $data = $db->fetch("SELECT id FROM " . PRE . "_calendar_events AS a WHERE 1 " . $where);
         $ids = get_ids($data, 'id');
         $ids[] = -1;
         $searchid = saveSearchResult('admin_calendar', $ids, array('item' => $_REQUEST['item'], 'title' => $_REQUEST['title'], 'text' => $_REQUEST['text'], 'catid' => $_REQUEST['catid'], 'secid' => $_REQUEST['secid'], 'userid' => $_REQUEST['userid'], 'start_day' => $_REQUEST['start_day'], 'start_month' => $_REQUEST['start_month'], 'start_year' => $_REQUEST['start_year'], 'end_day' => $_REQUEST['end_day'], 'end_month' => $_REQUEST['end_month'], 'end_year' => $_REQUEST['end_year']));
         header("HTTP/1.1 301 Moved Permanently");
         header('Location: action.php?action=calendar.show&what=' . $_REQUEST['what'] . '&searchid=' . $searchid);
         return;
     }
     //Voreinstellungen
     $_REQUEST['title'] = 1;
     $_REQUEST['text'] = 1;
     quicklink('calendar.add');
     $layerdef[] = array('LAYER_RECENT', 'action.php?action=calendar.show', !$_REQUEST['what']);
     $layerdef[] = array('LAYER_SEND', 'action.php?action=calendar.show&amp;what=send', $_REQUEST['what'] == 'send');
     $layerdef[] = array('LAYER_ARCHIVE', 'action.php?action=calendar.show&amp;what=archive', $_REQUEST['what'] == 'archive');
     //Layer Header ausgeben
     $html->layer_header($layerdef);
     $orderdef[0] = 'addtime';
     $orderdef['title'] = array('a.title', 'ASC', 'COL_TITLE');
     $orderdef['cat'] = array('catname', 'ASC', 'COL_CATEGORY');
     $orderdef['addtime'] = array('a.addtime', 'DESC', 'SORT_ADDTIME');
     $orderdef['startday'] = array('a.startday', 'ASC', 'SORT_STARTDAY');
     $orderdef['endday'] = array('a.endday', 'ASC', 'SORT_ENDDAY');
     $orderdef['hits'] = array('a.hits', 'DESC', 'COL_HITS');
     //Suchergebnis?
     $resultFilter = '';
     if ($_REQUEST['searchid']) {
         $searchRes = getSearchResult('admin_calendar', $_REQUEST['searchid']);
         if ($searchRes) {
             list($resultIds, $resultMeta) = $searchRes;
             $_REQUEST['item'] = $resultMeta['item'];
             $_REQUEST['title'] = $resultMeta['title'];
             $_REQUEST['text'] = $resultMeta['text'];
             $_REQUEST['catid'] = $resultMeta['catid'];
//.........这里部分代码省略.........

     $keyword_posts = array_unique(array_diff($tempres['posts'], $result_not['posts']));
     //Wort-Highlighting
     $highlight = array_merge($words_req, $words_one);
 }
 /////////////////////////////////////////////////////////////////////////////////////////////////
 /////////////////////////////////////////////////////////////////////////// ALS BEITRÄGE ANZEIGEN
 /////////////////////////////////////////////////////////////////////////////////////////////////
 if ($_POST['display'] == 'posts') {
     //Nur Themen aus den gewählten Foren
     $wherethread .= " forumid IN (" . implode(',', $inforum) . ") ";
     //Nur Themen vom Autor suchen
     if ($_REQUEST['author'] && $_POST['findthreads'] && !$_POST['findposts']) {
         if ($_POST['exact']) {
             $wherethread .= iif($wherethread, ' AND ') . " opener='" . addslashes($_REQUEST['author']) . "' ";
         } else {
             $wherethread .= iif($wherethread, ' AND ') . " opener LIKE '%" . addslashes_like($_REQUEST['author']) . "%' ";
         }
     }
     //Antworten: Filter erstellen
     if ($_POST['answers']) {
         $wherethread .= iif($wherethread, ' AND ') . " posts>='" . (intval($_POST['answers']) + 1) . "' ";
     }
     //Nach Präfixen suchen
     if (is_array($_POST['prefix']) && count($_POST['prefix'])) {
         $_POST['prefix'] = array_map('intval', $_POST['prefix']);
         $wherethread .= iif($wherethread, ' AND ') . " prefix IN (" . implode(',', $_POST['prefix']) . ") ";
     }
     //Relevante Themen auslesen
     $data = $db->fetch("SELECT threadid FROM " . PRE . "_forum_threads WHERE ( " . $wherethread . " AND del=0 AND moved=0 ) ORDER BY threadid ASC");
     $inthread = get_ids($data, 'threadid');
     if (isset($keyword_threads)) {