include FUSION_LANGUAGES.FUSION_LAN."search.php";
if (!isset($stype)) $stype = "n";
if (!isset($stext)) $stext = "";
openside(LAN_400." ".$settings['sitename']);
echo "\n";
closeside();
if ($stext != "") {
if ($stext != "" && strlen($stext) >= 3) {
$query = stripinput($stext);
if ($stype == "n") {
openside(LAN_403);
$sql = dbquery("SELECT * FROM ".$fusion_prefix."news WHERE news_subject REGEXP('".$query."') OR news_news REGEXP('".$query."')");
$rows = dbrows($sql);
if (!isset($rowstart)) $rowstart = 0;
if ($rows != 0) {
$sql = dbquery("SELECT * FROM ".$fusion_prefix."news WHERE news_subject REGEXP('".$query."') OR news_news REGEXP('".$query."') ORDER BY news_datestamp DESC LIMIT $rowstart,10");
while ($data = dbarray($sql)) {
$numrows = dbcount("(news_id)", "news", "news_id>='".$data['news_id']."'");
if ($numrows > 10) {
$rstart = ceil($numrows / 10);
$rstart = "?rowstart=".(($rstart-1)*10);
} else {
$rstart = "";
}
if (eregi($query, $data['news_subject']) && eregi($query, $data['news_news'])) {
echo "![](".FUSION_THEME."images/bullet.gif)
".parsesearch($data['news_subject'],$query)."
\n";
echo parsesearch(stripslashes($data['news_news']),$query)."
\n";
echo " ".LAN_420.LAN_423.LAN_421.LAN_424.LAN_422.showDate("longdate", $data['news_datestamp']).".
\n";
} else if (eregi($query, $data['news_subject']) && eregi($query, $data['news_extended'])) {
echo " ".parsesearch($data['news_subject'],$query)."
\n";
echo parsesearch(stripslashes($data['news_extended']),$query)."
\n";
echo " ".LAN_420.LAN_423.LAN_421.LAN_425.LAN_422.showDate("longdate", $data['news_datestamp']).".
\n";
} else if (eregi($query, $data['news_subject'])) {
echo " ".parsesearch($data['news_subject'],$query)."
\n";
echo trimlink(stripslashes($data['news_news']),100)."
\n";
echo "".LAN_420.LAN_423.LAN_422.showDate("longdate", $data['news_datestamp']).".
\n";
} else if (eregi($query, $data['news_news'])) {
echo " ".$data['news_subject']."
\n";
echo parsesearch(stripslashes($data['news_news']),$query)."
\n";
echo "".LAN_420.LAN_424.LAN_422.showDate("longdate", $data['news_datestamp']).".
\n";
} else if (eregi($query, $data['news_extended'])) {
echo " ".$data['news_subject']."
\n";
echo parsesearch(stripslashes($data['news_extended']),$query)."
\n";
echo "".LAN_420.LAN_425.LAN_422.showDate("longdate", $data['news_datestamp']).".
\n";
}
}
} else {
echo "
\n".LAN_440."
\n\n";
}
closeside();
echo "\n".makePageNav($rowstart,10,$rows,3,FUSION_SELF."?stype=n&stext=$stext&")."\n
\n";
} else if ($stype == "a") {
openside(LAN_403);
$sql = dbquery("SELECT * FROM ".$fusion_prefix."articles WHERE article_subject REGEXP('".$query."') OR article_article REGEXP('".$query."')");
$rows = dbrows($sql);
if (!isset($rowstart)) $rowstart = 0;
if ($rows != 0) {
$sql = dbquery("SELECT * FROM ".$fusion_prefix."articles WHERE article_subject REGEXP('".$query."') OR article_article REGEXP('".$query."') ORDER BY article_datestamp DESC LIMIT $rowstart,10");
while ($data = dbarray($sql)) {
if (eregi($query, $data['article_subject']) && eregi($query, $data['article_article'])) {
echo " ".parsesearch($data['article_subject'],$query)."
\n";
echo parsesearch(stripslashes($data['article_article']),$query)."
\n";
echo " ".LAN_420.LAN_426.LAN_421.LAN_427.LAN_422.showDate("longdate", $data['article_datestamp']).".
\n";
} else if (eregi($query, $data['article_subject'])) {
echo " ".parsesearch($data['article_subject'],$query)."
\n";
echo trimlink(stripslashes($data['article_article']),100)."
\n";
echo " ".LAN_420.LAN_426.LAN_422.showDate("longdate", $data['article_datestamp']).".
\n";
} else if (eregi($query, $data['article_article'])) {
echo " ".$data['article_subject']."
\n";
echo parsesearch(stripslashes($data['article_article']),$query)."
\n";
echo " ".LAN_420.LAN_427.LAN_422.showDate("longdate", $data['article_datestamp']).".
\n";
}
}
} else {
echo "
\n".LAN_440."
\n\n";
}
closeside();
echo "\n".makePageNav($rowstart,10,$rows,3,FUSION_SELF."?stype=a&stext=$stext&")."\n
\n";
} else if ($stype == "fp") {
if (iADMIN) {
$usr_grps = "WHERE (forum_access=0 OR forum_access=250 OR forum_access=251".(iUSER_GROUPS!="" ? " OR forum_access=".str_replace(".", " OR forum_access=", iUSER_GROUPS).")" : ")");
} elseif (iMEMBER) {
$usr_grps = "WHERE (forum_access=0 OR forum_access=250".(iUSER_GROUPS!="" ? " OR forum_access=".str_replace(".", " OR forum_access=", iUSER_GROUPS).")" : ")");
} elseif (iGUEST) {
$usr_grps = "WHERE forum_access=0";
}
openside(LAN_403);
$sql = dbquery(
"SELECT tp.*, tf.* FROM ".$fusion_prefix."posts tp
INNER JOIN ".$fusion_prefix."forums tf USING(forum_id)
".$usr_grps." AND (post_subject REGEXP('".$query."') OR post_message REGEXP('".$query."'))"
);
$rows = dbrows($sql);
if (!isset($rowstart)) $rowstart = 0;
if ($rows != 0) {
$sql = dbquery(
"SELECT tp.*, tf.* FROM ".$fusion_prefix."posts tp
INNER JOIN ".$fusion_prefix."forums tf USING(forum_id)
".$usr_grps." AND (post_subject REGEXP('".$query."') OR post_message REGEXP('".$query."'))
ORDER BY post_datestamp DESC LIMIT $rowstart,10"
);
while ($data = dbarray($sql)) {
$numrows = dbcount("(post_id)", "posts", "thread_id='".$data['thread_id']."' AND post_id<'".$data['post_id']."'");
if ($numrows > 20) {
$rstart = ceil($numrows / 20);
$rstart = "rowstart=".(($rstart-1)*20)."&";
} else {
$rstart = "";
}
if (eregi($query, $data['post_subject']) && eregi($query, $data['post_message'])) {
echo " ".parsesearch($data['post_subject'],$query)."
\n";
echo parsesearch(stripslashes($data['post_message']),$query)."
\n";
echo " ".LAN_420.LAN_428.LAN_421.LAN_429.LAN_422.showDate("longdate", $data['post_datestamp']).".
\n";
} else if (eregi($query, $data['post_subject'])) {
echo " ".parsesearch($data['post_subject'],$query)."
\n";
echo trimlink(stripslashes($data['post_message']),100)."
\n";
echo " ".LAN_420.LAN_428.LAN_422.showDate("longdate", $data['post_datestamp']).".
\n";
} else if (eregi($query, $data['post_message'])) {
echo " ".$data['post_subject']."
\n";
echo parsesearch(stripslashes($data['post_message']),$query)."
\n";
echo " ".LAN_420.LAN_429.LAN_422.showDate("longdate", $data['post_datestamp']).".
\n";
}
}
} else {
echo "
\n".LAN_440."
\n\n";
}
closeside();
echo "\n".makePageNav($rowstart,10,$rows,3,FUSION_SELF."?stype=fp&stext=$stext&")."\n
\n";
}
} else {
openside(LAN_403);
echo "
\n".LAN_441."
\n\n";
closeside();
}
}
function parsesearch($text,$match) {
$text = strip_tags($text);
$aft = stristr($text,$match);
$pos = strlen($text)-strlen($aft);
if ($pos < 50) { $text = "..".substr($text, 0, 100).".."; } else { $text = "..".substr($text, ($pos-50), 100).".."; }
$text = eregi_replace($match, "".$match."", $text);
return $text;
}
echo "\n";