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; }
} 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&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&action=search&articles=" . $_GET['articles'] . "&faq=" . $_GET['faq'] . "&forum=" . $_GET['forum'] . "&news=" . $_GET['news'] . "&r=" . $_GET['r'] . "&text=" . $_GET['text'] . "&am=" . $_GET['am'] . "&ad=" . $_GET['ad'] . "&ay=" . $_GET['ay'] . "&bm=" . $_GET['bm'] . "&bd=" . $_GET['bd'] . "&by=" . $_GET['by'] . "&order=" . $_GET['order'], $page, $pages); } // sort results if ($_GET['order'] == '2') { asort($res_occurr);