Exemple #1
0
function substri_count_array($haystack, $needle)
{
    $return = 0;
    foreach ($haystack as $value) {
        if (is_array($value)) {
            $return += substri_count_array($value, $needle);
        } else {
            $return += substr_count(strtolower($value), strtolower($needle));
        }
    }
    return $return;
}
Exemple #2
0
 }
 if (isset($_GET['news'])) {
     $ergebnis_news = safe_query("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\t\tdate,\r\n\t\t\t\t\t\t\t\t\t\t\t\tposter,\r\n\t\t\t\t\t\t\t\t\t\t\t\tnewsID\r\n\t\t\t\t\t\t\t\t\t\t   FROM\r\n\t\t\t\t\t\t\t\t\t\t   \t\t" . PREFIX . "news\r\n\t\t\t\t\t\t\t\t\t\t   WHERE\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tpublished = '1'\r\n\t\t\t\t\t\t\t\t\t\t\t\tAND\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tintern <= '" . isclanmember($userID) . "'\r\n\t\t\t\t\t\t\t\t\t\t\t\tAND\r\n\t\t\t\t\t\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tdate between " . $after . " AND " . $before . "\r\n\t\t\t\t\t\t\t\t\t\t\t\t)");
     while ($ds = mysql_fetch_array($ergebnis_news)) {
         $ergebnis_news_contents = safe_query("SELECT language, headline, content FROM " . PREFIX . "news_contents WHERE newsID = '" . $ds['newsID'] . "' and (content LIKE '%" . $text . "%' or headline LIKE '%" . $text . "%')");
         if (mysql_num_rows($ergebnis_news_contents)) {
             $message_array = array();
             while ($qs = mysql_fetch_array($ergebnis_news_contents)) {
                 $message_array[] = array('lang' => $qs['language'], 'headline' => $qs['headline'], 'message' => $qs['content']);
             }
             $showlang = select_language($message_array);
             $newsID = $ds['newsID'];
             $res_title[$i] = $message_array[$showlang]['headline'];
             $res_message[$i] = clearfromtags($message_array[$showlang]['message']);
             $res_link[$i] = '<a href="index.php?site=news_comments&amp;newsID=' . $newsID . '">' . $_language->module['news_link'] . '</a>';
             $res_occurr[$i] = substri_count_array($message_array, stripslashes($text));
             $res_date[$i] = $ds['date'];
             $res_type[$i] = $_language->module['news'];
             $i++;
         }
     }
 }
 $count_results = $i;
 echo "<center><b>" . $count_results . "</b> " . $_language->module['results_found'] . "</center><br /><br />";
 $pages = ceil($count_results / $results);
 if ($pages > 1) {
     echo makepagelink("index.php?site=search&amp;action=search&amp;articles=" . $_GET['articles'] . "&amp;faq=" . $_GET['faq'] . "&amp;forum=" . $_GET['forum'] . "&amp;news=" . $_GET['news'] . "&amp;r=" . $_GET['r'] . "&amp;text=" . $_GET['text'] . "&amp;am=" . $_GET['am'] . "&amp;ad=" . $_GET['ad'] . "&amp;ay=" . $_GET['ay'] . "&amp;bm=" . $_GET['bm'] . "&amp;bd=" . $_GET['bd'] . "&amp;by=" . $_GET['by'] . "&amp;order=" . $_GET['order'], $page, $pages);
 }
 // sort results
 if ($_GET['order'] == '2') {
     asort($res_occurr);