$rows = dbcount("(news_id)", DB_NEWS, groupaccess('news_visibility') . " AND " . $fieldsvar . " AND (news_start='0'||news_start<=" . time() . ") AND (news_end='0'||news_end>=" . time() . ") " . ($_GET['datelimit'] != 0 ? " AND news_datestamp>=" . (time() - $_GET['datelimit']) : ""));
} else {
$rows = 0;
}
if ($rows != 0) {
$items_count .= THEME_BULLET . " <a href='" . FUSION_SELF . "?stype=news&stext=" . $_GET['stext'] . "&" . $composevars . "'>" . $rows . " " . ($rows == 1 ? $locale['n401'] : $locale['n402']) . " " . $locale['522'] . "</a><br />\n";
$result = dbquery("SELECT tn.*, tu.user_id, tu.user_name, tu.user_status FROM " . DB_NEWS . " tn\r\n\t\t\tLEFT JOIN " . DB_USERS . " tu ON tn.news_name=tu.user_id\r\n\t\t\tWHERE " . groupaccess('news_visibility') . " AND (news_start='0'||news_start<=" . time() . ")\r\n\t\t\tAND (news_end='0'||news_end>=" . time() . ") AND " . $fieldsvar . "\r\n\t\t\t" . ($_GET['datelimit'] != 0 ? " AND news_datestamp>=" . (time() - $_GET['datelimit']) : "") . "\r\n\t\t\tORDER BY " . $sortby . " " . ($_GET['order'] == 1 ? "ASC" : "DESC") . ($_GET['stype'] != "all" ? " LIMIT " . $_GET['rowstart'] . ",10" : ""));
while ($data = dbarray($result)) {
$search_result = "";
$text_all = $data['news_news'] . " " . $data['news_extended'];
$text_all = search_striphtmlbbcodes($text_all);
$text_frag = search_textfrag($text_all);
// $text_frag = highlight_words($swords, $text_frag);
$subj_c = search_stringscount($data['news_subject']);
$text_c = search_stringscount($data['news_news']);
$text_c2 = search_stringscount($data['news_extended']);
$search_result .= "<a href='news.php?readmore=" . $data['news_id'] . "'>" . $data['news_subject'] . "</a>" . "<br /><br />\n";
// $search_result .= "<a href='news.php?readmore=".$data['news_id']."'>".highlight_words($swords, $data['news_subject'])."</a>"."<br /><br />\n";
$search_result .= "<div class='quote' style='width:auto;height:auto;overflow:auto'>" . $text_frag . "</div><br />";
$search_result .= "<span class='small2'>" . $locale['global_070'] . profile_link($data['user_id'], $data['user_name'], $data['user_status']) . "\n";
$search_result .= $locale['global_071'] . showdate("longdate", $data['news_datestamp']) . "</span><br />\n";
$search_result .= "<span class='small'>" . $subj_c . " " . ($subj_c == 1 ? $locale['520'] : $locale['521']) . " " . $locale['n403'] . " " . $locale['n404'] . ", ";
$search_result .= $text_c . " " . ($text_c == 1 ? $locale['520'] : $locale['521']) . " " . $locale['n403'] . " " . $locale['n405'] . ", ";
$search_result .= $text_c2 . " " . ($text_c2 == 1 ? $locale['520'] : $locale['521']) . " " . $locale['n403'] . " " . $locale['n406'] . "</span><br /><br />\n";
search_globalarray($search_result);
}
} else {
$items_count .= THEME_BULLET . " 0 " . $locale['n402'] . " " . $locale['522'] . "<br />\n";
}
$navigation_result = search_navigation($rows);
}
}
if ($fieldsvar) {
$result = dbquery("SELECT tp.forum_id, tp.thread_id, tp.post_id, tp.post_message, tt.thread_subject,\r\n\t\t\ttf.forum_access FROM " . DB_POSTS . " tp\r\n\t\t\tLEFT JOIN " . DB_FORUMS . " tf ON tf.forum_id = tp.forum_id\r\n\t\t\tLEFT JOIN " . DB_THREADS . " tt ON tt.thread_id = tp.thread_id\t\t\t\r\n\t\t\tWHERE " . groupaccess('forum_access') . ($_GET['forum_id'] != 0 ? " AND tf.forum_id=" . $_GET['forum_id'] : "") . "\r\n\t\t\tAND " . $fieldsvar . ($_GET['datelimit'] != 0 ? " AND post_datestamp>=" . (time() - $_GET['datelimit']) : ""));
$rows = dbrows($result);
} else {
$rows = 0;
}
if ($rows) {
$items_count .= THEME_BULLET . " <a href='" . FUSION_SELF . "?stype=forums&stext=" . $_GET['stext'] . "&" . $composevars . "'>" . $rows . " " . ($rows == 1 ? $locale['f402'] : $locale['f403']) . " " . $locale['522'] . "</a><br />\n";
$result = dbquery("SELECT tp.forum_id, tp.thread_id, tp.post_id, tp.post_message, tp.post_datestamp, tt.thread_subject,\r\n\t\t\ttt.thread_sticky, tf.forum_access, tu.user_id, tu.user_name, tu.user_status FROM " . DB_POSTS . " tp\r\n\t\t\tLEFT JOIN " . DB_THREADS . " tt ON tp.thread_id = tt.thread_id\r\n\t\t\tLEFT JOIN " . DB_FORUMS . " tf ON tp.forum_id = tf.forum_id\r\n\t\t\tLEFT JOIN " . DB_USERS . " tu ON tp.post_author=tu.user_id\r\n\t\t\tWHERE " . groupaccess('forum_access') . ($_GET['forum_id'] != 0 ? " AND tf.forum_id=" . $_GET['forum_id'] : "") . "\r\n\t\t\tAND " . $fieldsvar . ($_GET['datelimit'] != 0 ? " AND post_datestamp>=" . (time() - $_GET['datelimit']) : "") . "\r\n\t\t\tORDER BY " . $sortby . " " . ($_GET['order'] == 1 ? "ASC" : "DESC") . ($_GET['stype'] != "all" ? " LIMIT " . $_GET['rowstart'] . ",10" : ""));
while ($data = dbarray($result)) {
$search_result = "";
$text_all = search_striphtmlbbcodes(iADMIN ? $data['post_message'] : preg_replace("#\\[hide\\](.*)\\[/hide\\]#si", "", $data['post_message']));
$text_frag = search_textfrag($text_all);
$subj_c = search_stringscount($data['thread_subject']);
$text_c = search_stringscount($data['post_message']);
// $text_frag = highlight_words($swords, $text_frag);
$search_result .= ($data['thread_sticky'] == 1 ? "<strong>" . $locale['f404'] . "</strong> " : "") . "<a href='" . FORUM . "viewthread.php?thread_id=" . $data['thread_id'] . "&highlight=" . urlencode($_GET['stext']) . "&pid=" . $data['post_id'] . "#post_" . $data['post_id'] . "'>" . $data['thread_subject'] . "</a>" . "<br /><br />\n";
// $search_result .= ($data['thread_sticky'] == 1 ? "<strong>".$locale['f404']."</strong> " : "")."<a href='".FORUM."viewthread.php?thread_id=".$data['thread_id']."&highlight=".urlencode($_GET['stext'])."&pid=".$data['post_id']."#post_".$data['post_id']."'>".highlight_words($swords, $data['thread_subject'])."</a>"."<br /><br />\n";
$search_result .= "<div class='quote' style='width:auto;height:auto;overflow:auto'>" . $text_frag . "</div><br />";
$search_result .= "<span class='small2'>" . $locale['global_070'] . profile_link($data['user_id'], $data['user_name'], $data['user_status']) . "\n";
$search_result .= $locale['global_071'] . showdate("longdate", $data['post_datestamp']) . "</span><br />\n";
$search_result .= "<span class='small'>" . $subj_c . " " . ($subj_c == 1 ? $locale['520'] : $locale['521']) . " " . $locale['f406'] . " " . $locale['f407'] . ", ";
$search_result .= $text_c . " " . ($text_c == 1 ? $locale['520'] : $locale['521']) . " " . $locale['f406'] . " " . $locale['f408'] . "</span><br /><br />\n";
search_globalarray($search_result);
}
} else {
$items_count .= THEME_BULLET . " 0 " . $locale['f403'] . " " . $locale['522'] . "<br />\n";
}
$navigation_result = search_navigation($rows);
}
}
}
if ($fieldsvar) {
$result = dbquery("SELECT ta.*,tac.* FROM " . DB_ARTICLES . " ta\r\n\t\t\tINNER JOIN " . DB_ARTICLE_CATS . " tac ON ta.article_cat=tac.article_cat_id\r\n\t\t\tWHERE " . groupaccess('article_cat_access') . " AND " . $fieldsvar . "\r\n\t\t\t" . ($_GET['datelimit'] != 0 ? " AND article_datestamp>=" . (time() - $_GET['datelimit']) : ""));
$rows = dbrows($result);
} else {
$rows = 0;
}
if ($rows != 0) {
$items_count .= THEME_BULLET . " <a href='" . FUSION_SELF . "?stype=articles&stext=" . $_GET['stext'] . "&" . $composevars . "'>" . $rows . " " . ($rows == 1 ? $locale['a401'] : $locale['a402']) . " " . $locale['522'] . "</a><br />\n";
$result = dbquery("SELECT ta.*,tac.*, tu.user_id, tu.user_name, tu.user_status FROM " . DB_ARTICLES . " ta\r\n\t\t\tINNER JOIN " . DB_ARTICLE_CATS . " tac ON ta.article_cat=tac.article_cat_id\r\n\t\t\tLEFT JOIN " . DB_USERS . " tu ON ta.article_name=tu.user_id\r\n\t\t\tWHERE " . groupaccess('article_cat_access') . " AND " . $fieldsvar . "\r\n\t\t\t" . ($_GET['datelimit'] != 0 ? " AND article_datestamp>=" . (time() - $_GET['datelimit']) : "") . "\r\n\t\t\tORDER BY " . $sortby . " " . ($_GET['order'] != 1 ? "ASC" : "DESC") . ($_GET['stype'] != "all" ? " LIMIT " . $_GET['rowstart'] . ",10" : ""));
while ($data = dbarray($result)) {
$search_result = "";
$text_all = search_striphtmlbbcodes($data['article_snippet'] . " " . $data['article_article']);
$text_frag = search_textfrag($text_all);
$subj_c = search_stringscount($data['article_subject']);
$text_c = search_stringscount($data['article_snippet'] . " " . $data['article_article']);
$text_frag = highlight_words($swords, $text_frag);
$search_result .= "<a href='articles.php?article_id=" . $data['article_id'] . "'>" . highlight_words($swords, $data['article_subject']) . "</a>" . "<br /><br />\n";
$search_result .= "<div class='quote' style='width:auto;height:auto;overflow:auto'>" . $text_frag . "</div><br />";
$search_result .= "<span class='small2'>" . $locale['global_070'] . profile_link($data['user_id'], $data['user_name'], $data['user_status']) . "\n";
$search_result .= $locale['global_071'] . showdate("longdate", $data['article_datestamp']) . "</span><br />\n";
$search_result .= "<span class='small'>" . $subj_c . " " . ($subj_c == 1 ? $locale['520'] : $locale['521']) . " " . $locale['522'] . " " . $locale['a404'] . ", ";
$search_result .= $text_c . " " . ($text_c == 1 ? $locale['520'] : $locale['521']) . " " . $locale['522'] . " " . $locale['a405'] . "</span><br /><br />\n";
search_globalarray($search_result);
}
} else {
$items_count .= THEME_BULLET . " 0 " . $locale['a402'] . " " . $locale['522'] . "<br />\n";
}
$navigation_result = search_navigation($rows);
}
$rows = dbrows($result);
} else {
$rows = 0;
}
if ($rows != 0) {
$items_count .= THEME_BULLET . " <a href='" . FUSION_SELF . "?stype=custompages&stext=" . $_GET['stext'] . "&" . $composevars . "'>" . $rows . " " . ($rows == 1 ? $locale['c401'] : $locale['c402']) . " " . $locale['522'] . "</a><br />\n";
$result = dbquery("SELECT * FROM " . DB_CUSTOM_PAGES . "\n\t\t\tWHERE " . groupaccess('page_access') . " AND " . $fieldsvar . "\n\t\t\tORDER BY " . $sortby . " " . ($_GET['order'] == 1 ? "ASC" : "DESC") . ($_GET['stype'] != "all" ? " LIMIT " . $_GET['rowstart'] . ",10" : ""));
while ($data = dbarray($result)) {
$search_result = "";
$text_all = stripslashes($data['page_content']);
ob_start();
eval("?>" . $text_all . "<?php ");
$text_all = ob_get_contents();
ob_end_clean();
$text_all = search_striphtmlbbcodes($text_all);
$text_frag = search_textfrag($text_all);
$subj_c = search_stringscount($data['page_title']);
$text_c = search_stringscount($text_all);
// $text_frag = highlight_words($swords, $text_frag);
$search_result .= "<a href='viewpage.php?page_id=" . $data['page_id'] . "'>" . $data['page_title'] . "</a>" . "<br /><br />\n";
// $search_result .= "<a href='viewpage.php?page_id=".$data['page_id']."'>".highlight_words($swords, $data['page_title'])."</a>"."<br /><br />\n";
$search_result .= "<div class='quote' style='width:auto;height:auto;overflow:auto'>" . $text_frag . "</div><br />\n";
$search_result .= "<span class='small'>" . $subj_c . " " . ($subj_c == 1 ? $locale['520'] : $locale['521']) . " " . $locale['c403'] . " " . $locale['c404'] . ", ";
$search_result .= $text_c . " " . ($text_c == 1 ? $locale['520'] : $locale['521']) . " " . $locale['c403'] . " " . $locale['c405'] . "</span><br /><br />\n";
search_globalarray($search_result);
}
} else {
$items_count .= THEME_BULLET . " 0 " . $locale['c402'] . " " . $locale['522'] . "<br />\n";
}
$navigation_result = search_navigation($rows);
}
if ($rows != 0) {
$items_count .= THEME_BULLET . " <a href='" . FUSION_SELF . "?stype=photos&stext=" . $_GET['stext'] . "&" . $composevars . "'>" . $rows . " " . ($rows == 1 ? $locale['p401'] : $locale['p402']) . " " . $locale['522'] . "</a><br />\n";
$result = dbquery("SELECT tp.*,ta.* FROM " . DB_PHOTOS . " tp\r\n\t\t\tINNER JOIN " . DB_PHOTO_ALBUMS . " ta ON tp.album_id=ta.album_id\r\n\t\t\tWHERE " . groupaccess('album_access') . " AND " . $fieldsvar . "\r\n\t\t\t" . ($_GET['datelimit'] != 0 ? " AND (photo_datestamp>=" . (time() - $_GET['datelimit']) . " OR album_datestamp>=" . (time() - $_GET['datelimit']) . ")" : "") . "\r\n\t\t\tORDER BY " . $sortby . " " . ($_GET['order'] == 1 ? "ASC" : "DESC") . ($_GET['stype'] != "all" ? " LIMIT " . $_GET['rowstart'] . ",10" : ""));
while ($data = dbarray($result)) {
$search_result = "";
if ($data['photo_datestamp'] + 604800 > time() + $settings['timeoffset'] * 3600) {
$new = " <span class='small'>" . $locale['p403'] . "</span>";
} else {
$new = "";
}
$text_all = $data['photo_description'];
$text_all = search_striphtmlbbcodes($text_all);
$text_frag = search_textfrag($text_all);
// $text_frag = highlight_words($swords, $text_frag);
$subj_c = search_stringscount($data['photo_title']) + search_stringscount($data['album_title']);
$text_c = search_stringscount($data['photo_description']) + search_stringscount($data['album_description']);
$search_result .= "<table width='100%'>";
$search_result .= "<tr><td width='" . $settings['thumb_w'] . "'>";
$photodir = PHOTOS . (!SAFEMODE ? "album_" . $data['album_id'] . "/" : "");
if ($data['photo_thumb1'] != "" && file_exists($photodir . $data['photo_thumb1'])) {
$search_result .= "<a href='photogallery.php?photo_id=" . $data['photo_id'] . "'><img src='" . $photodir . $data['photo_thumb1'] . "' style='border:none' alt='" . $data['photo_title'] . "' /></a>";
} else {
if ($data['photo_thumb2'] != "" && file_exists($photodir . $data['photo_thumb2'])) {
$search_result .= "<a href='photogallery.php?photo_id=" . $data['photo_id'] . "'><img src='" . $photodir . $data['photo_thumb2'] . "' style='border:none' alt='" . $data['photo_title'] . "' /></a>";
} else {
$search_result .= "<a href='photogallery.php?photo_id=" . $data['photo_id'] . "'><img src='" . get_image("imagenotfound") . "' style='border:none' alt='" . $data['photo_title'] . "' /></a>";
}
}
$search_result .= "</td><td>";
$search_result .= "<a href='photogallery.php?photo_id=" . $data['photo_id'] . "'>" . $data['photo_title'] . "</a>" . $new . " (" . $locale['p404'] . " <a href='photogallery.php?album_id=" . $data['album_id'] . "'>" . $data['album_title'] . "</a>)" . "<br /><br />\n";
// $search_result .= "<a href='photogallery.php?photo_id=".$data['photo_id']."'>".highlight_words($swords, $data['photo_title'])."</a>".$new." (".$locale['p404']." <a href='photogallery.php?album_id=".$data['album_id']."'>".highlight_words($swords, $data['album_title'])."</a>)"."<br /><br />\n";
}
if ($rows != 0) {
$items_count .= THEME_BULLET . " <a href='" . FUSION_SELF . "?stype=downloads&stext=" . $_GET['stext'] . "&" . $composevars . "'>" . $rows . " " . ($rows == 1 ? $locale['d401'] : $locale['d402']) . " " . $locale['522'] . "</a><br />\n";
$result = dbquery("SELECT td.*,tdc.* FROM " . DB_DOWNLOADS . " td\r\n\t\t\tINNER JOIN " . DB_DOWNLOAD_CATS . " tdc ON td.download_cat=tdc.download_cat_id\r\n\t\t\tWHERE " . groupaccess('download_cat_access') . " AND " . $fieldsvar . "\r\n\t\t\t" . ($_GET['datelimit'] != 0 ? " AND download_datestamp>=" . (time() - $_GET['datelimit']) : "") . "\r\n\t\t\tORDER BY " . $sortby . " " . ($_GET['order'] == 1 ? "ASC" : "DESC") . ($_GET['stype'] != "all" ? " LIMIT " . $_GET['rowstart'] . ",10" : ""));
while ($data = dbarray($result)) {
$search_result = "";
if ($data['download_datestamp'] + 604800 > time() + $settings['timeoffset'] * 3600) {
$new = " <span class='small'>" . $locale['d403'] . "</span>";
} else {
$new = "";
}
$text_all = $data['download_description'];
$text_all = search_striphtmlbbcodes($text_all);
$text_frag = search_textfrag($text_all);
$subj_c = search_stringscount($data['download_title']);
$text_c = search_stringscount($data['download_description']);
// $text_frag = highlight_words($swords, $text_frag);
$search_result .= "<a href='downloads.php?cat_id=" . $data['download_cat'] . "&download_id=" . $data['download_id'] . "' target='_blank'>" . $data['download_title'] . "</a> - " . $data['download_filesize'] . " " . $new . "<br /><br />\n";
// $search_result .= "<a href='downloads.php?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' target='_blank'>".highlight_words($swords, $data['download_title'])."</a> - ".$data['download_filesize']." ".$new."<br /><br />\n";
if ($text_frag != "") {
$search_result .= "<div class='quote' style='width:auto;height:auto;overflow:auto'>" . $text_frag . "</div><br />";
}
$search_result .= "<span class='small'><span class='alt'>" . $locale['d404'] . "</span> " . $data['download_license'] . " |\n";
$search_result .= "<span class='alt'>" . $locale['d405'] . "</span> " . $data['download_os'] . " |\n";
$search_result .= "<span class='alt'>" . $locale['d406'] . "</span> " . $data['download_version'] . "<br />\n";
$search_result .= "<span class='alt'>" . $locale['d407'] . "</span> " . showdate("%d.%m.%y", $data['download_datestamp']) . " |\n";
$search_result .= "<span class='alt'>" . $locale['d408'] . "</span> " . $data['download_count'] . "</span><br /><br />\n";
search_globalarray($search_result);
}
} else {
$items_count .= THEME_BULLET . " 0 " . $locale['d402'] . " " . $locale['522'] . "<br />\n";
} else {
$rows = 0;
}
if ($rows != 0) {
$items_count .= THEME_BULLET . " <a href='" . FUSION_SELF . "?stype=weblinks&stext=" . $_GET['stext'] . "&" . $composevars . "'>" . $rows . " " . ($rows == 1 ? $locale['w401'] : $locale['w402']) . " " . $locale['522'] . "</a><br />\n";
$result = dbquery("SELECT tw.*,twc.* FROM " . DB_WEBLINKS . " tw\r\n\t\t\tINNER JOIN " . DB_WEBLINK_CATS . " twc ON tw.weblink_cat=twc.weblink_cat_id\r\n\t\t\tWHERE " . groupaccess('weblink_cat_access') . " AND " . $fieldsvar . "\r\n\t\t\t" . ($_GET['datelimit'] != 0 ? " AND weblink_datestamp>=" . (time() - $_GET['datelimit']) : "") . "\r\n\t\t\tORDER BY " . $sortby . " " . ($_GET['order'] == 1 ? "ASC" : "DESC") . ($_GET['stype'] != "all" ? " LIMIT " . $_GET['rowstart'] . ",10" : ""));
while ($data = dbarray($result)) {
$search_result = "";
if ($data['weblink_datestamp'] + 604800 > time() + $settings['timeoffset'] * 3600) {
$new = " <span class='small'>" . $locale['w403'] . "</span>";
} else {
$new = "";
}
$text_all = $data['weblink_description'];
$text_all = search_striphtmlbbcodes($text_all);
$text_frag = search_textfrag($text_all);
$text_frag = highlight_words($swords, $text_frag);
$subj_c = search_stringscount($data['weblink_name']) + search_stringscount($data['weblink_url']);
$text_c = search_stringscount($data['weblink_description']);
$search_result .= "<a href='weblinks.php?cat_id=" . $data['weblink_cat'] . "&weblink_id=" . $data['weblink_id'] . "' target='_blank'>" . highlight_words($swords, $data['weblink_name']) . "</a>{$new}" . "<br /><br />\n";
if ($text_frag != "") {
$search_result .= "<div class='quote' style='width:auto;height:auto;overflow:auto'>" . $text_frag . "</div><br />";
}
$search_result .= "<span class='small'><font class='alt'>" . $locale['w404'] . "</font> " . showdate("%d.%m.%y", $data['weblink_datestamp']) . " | <span class='alt'>" . $locale['w405'] . "</span> " . $data['weblink_count'] . "</span><br /><br />\n";
search_globalarray($search_result);
}
} else {
$items_count .= THEME_BULLET . " 0 " . $locale['w402'] . " " . $locale['522'] . "<br />\n";
}
$navigation_result = search_navigation($rows);
}
}
}
if ($fieldsvar) {
$result = dbquery("SELECT fq.*, fc.* FROM " . DB_FAQS . " fq\n\t\t\tLEFT JOIN " . DB_FAQ_CATS . " fc ON fq.faq_cat_id=fc.faq_cat_id\n\t\t\tWHERE " . $fieldsvar);
$rows = dbrows($result);
} else {
$rows = 0;
}
if ($rows != 0) {
$items_count .= THEME_BULLET . " <a href='" . FUSION_SELF . "?stype=faqs&stext=" . $_POST['stext'] . "&" . $composevars . "'>" . $rows . " " . ($rows == 1 ? $locale['fq401'] : $locale['fq402']) . " " . $locale['522'] . "</a><br />\n";
while ($data = dbarray($result)) {
$search_result = "";
$text_all = $data['faq_answer'];
$text_all = search_striphtmlbbcodes($text_all);
$text_frag = search_textfrag($text_all);
// $text_frag = highlight_words($swords, $text_frag);
$subj_c = search_stringscount($data['faq_question']);
$text_c = search_stringscount($data['faq_answer']);
$search_result .= "<a href='infusions/faq/faq.php?cat_id=" . $data['faq_cat_id'] . "'>" . $data['faq_question'] . "</a>" . "<br /><br />\n";
// $search_result .= "<a href='faq.php?cat_id=".$data['faq_cat_id']."'>".highlight_words($swords, $data['faq_question'])."</a>"."<br /><br />\n";
$search_result .= "<div class='quote' style='width:auto;height:auto;overflow:auto'>" . $text_frag . "</div><br />";
$search_result .= "<span class='small'>" . $subj_c . " " . ($subj_c == 1 ? $locale['520'] : $locale['521']) . " " . $locale['fq403'] . " " . $locale['fq404'] . ", ";
$search_result .= $text_c . " " . ($text_c == 1 ? $locale['520'] : $locale['521']) . " " . $locale['fq403'] . " " . $locale['fq405'] . "</span><br /><br />\n";
search_globalarray($search_result);
}
} else {
$items_count .= THEME_BULLET . " 0 " . $locale['fq402'] . " " . $locale['522'] . "<br />\n";
}
$navigation_result = search_navigation($rows);
}
}
if ($fieldsvar) {
$rows = dbcount("(blog_id)", DB_BLOG, groupaccess('blog_visibility') . " AND " . $fieldsvar . " AND (blog_start='0'||blog_start<=" . time() . ") AND (blog_end='0'||blog_end>=" . time() . ") " . ($_POST['datelimit'] != 0 ? " AND blog_datestamp>=" . (time() - $_POST['datelimit']) : ""));
} else {
$rows = 0;
}
if ($rows != 0) {
$items_count .= THEME_BULLET . " <a href='" . FUSION_SELF . "?stype=blog&stext=" . $_POST['stext'] . "&" . $composevars . "'>" . $rows . " " . ($rows == 1 ? $locale['n401'] : $locale['n402']) . " " . $locale['522'] . "</a><br />\n";
$result = dbquery("SELECT tn.*, tu.user_id, tu.user_name, tu.user_status FROM " . DB_BLOG . " tn\n\t\t\tLEFT JOIN " . DB_USERS . " tu ON tn.blog_name=tu.user_id\n\t\t\tWHERE " . groupaccess('blog_visibility') . " AND (blog_start='0'||blog_start<=" . time() . ")\n\t\t\tAND (blog_end='0'||blog_end>=" . time() . ") AND " . $fieldsvar . "\n\t\t\t" . ($_POST['datelimit'] != 0 ? " AND blog_datestamp>=" . (time() - $_POST['datelimit']) : "") . "\n\t\t\tORDER BY " . $sortby . " " . ($_POST['order'] == 1 ? "ASC" : "DESC") . ($_GET['stype'] != "all" ? " LIMIT " . $_POST['rowstart'] . ",10" : ""));
while ($data = dbarray($result)) {
$search_result = "";
$text_all = $data['blog_blog'] . " " . $data['blog_extended'];
$text_all = search_striphtmlbbcodes($text_all);
$text_frag = search_textfrag($text_all);
$subj_c = search_stringscount($data['blog_subject']);
$text_c = search_stringscount($data['blog_blog']);
$text_c2 = search_stringscount($data['blog_extended']);
$search_result .= "<a href='" . INFUSIONS . "blog/blog.php?readmore=" . $data['blog_id'] . "'>" . $data['blog_subject'] . "</a>" . "<br /><br />\n";
$search_result .= "<div class='quote' style='width:auto;height:auto;overflow:auto'>" . $text_frag . "</div><br />";
$search_result .= "<span class='small2'>" . $locale['global_070'] . profile_link($data['user_id'], $data['user_name'], $data['user_status']) . "\n";
$search_result .= $locale['global_071'] . showdate("longdate", $data['blog_datestamp']) . "</span><br />\n";
$search_result .= "<span class='small'>" . $subj_c . " " . ($subj_c == 1 ? $locale['520'] : $locale['521']) . " " . $locale['n403'] . " " . $locale['n404'] . ", ";
$search_result .= $text_c . " " . ($text_c == 1 ? $locale['520'] : $locale['521']) . " " . $locale['n403'] . " " . $locale['n405'] . ", ";
$search_result .= $text_c2 . " " . ($text_c2 == 1 ? $locale['520'] : $locale['521']) . " " . $locale['n403'] . " " . $locale['n406'] . "</span><br /><br />\n";
search_globalarray($search_result);
}
} else {
$items_count .= THEME_BULLET . " 0 " . $locale['n402'] . " " . $locale['522'] . "<br />\n";
}
$navigation_result = search_navigation($rows);
}
}
