\n"; closetable(); tablebreak(); opentable("Wyniki wyszukiwania '$keywords':"); if (isset($_POST['keywords'])) { if ($keywords != "") { $keywords = explode(" ", stripinput($keywords)); $num_keywords = count($keywords); $query = "SELECT * FROM ".$fusion_prefix."articles INNER JOIN ".$fusion_prefix."article_cats ON ".$fusion_prefix."articles.article_cat=".$fusion_prefix."article_cats.article_cat_id WHERE ".$exc_list."article_article LIKE '%".$keywords[0]."%' "; $queryn = "SELECT * FROM ".$fusion_prefix."news WHERE ".$exc_list."news_subject LIKE '%".$keywords[0]."%' "; for ($i=1;$i<$num_keywords;$i++) { $keywords[$i] = $keywords[$i]; $query .= "OR article_article LIKE '%".$keywords[$i]."%' "; $queryn .= "OR news_news LIKE '%".$keywords[$i]."%' "; } $query .= "ORDER BY article_datestamp DESC"; $queryn .= "ORDER BY news_datestamp DESC"; $result = dbquery($query); $resultn = dbquery($queryn); if (dbrows($result) != 0) { echo "

\n"; while ($data = dbarray($result)) { // Get Category Name $result2 = dbquery("SELECT article_cat_name FROM ".$fusion_prefix."article_cats WHERE article_cat_id='$data[article_cat]'"); $data2 = dbarray($result2); $article_category = $data2[article_cat_name]; // Get User ID $result2 = dbquery("SELECT user_id FROM ".$fusion_prefix."users WHERE user_name='$data[article_name]'"); $data2 = dbarray($result2); $article_user_id = $data[article_name]; $nazwaa = $data['article_name']; $result3 = dbquery("SELECT user_name FROM ".$fusion_prefix."users WHERE user_id='$nazwaa'"); $data3 = dbarray($result3); echo "\n"; } echo "

Artykuły	Kategoria	Napisany przez	w dniu
".$data['article_subject']."	".$article_category."	".$article_user_id."	".strftime($settings['forumdate'], $data['article_datestamp']+($settings['timeoffset']*3600))."

\n"; } else { echo "
".LAN_976."

\n"; } } else { echo "
".LAN_465."

\n"; } } else { echo "
Nie znaleziono
";} //////////////////////////94///////////////////////////////// echo "

"; if (dbrows($resultn) != 0) { echo "

\n"; while ($datan = dbarray($resultn)) { // Get User ID $result2n = dbquery("SELECT user_id FROM ".$fusion_prefix."users WHERE user_name='$datan[news_name]'"); $data2n = dbarray($result2n); $news_user_id = $datan[news_name]; $nazwa = $datan['news_name']; $result3n = dbquery("SELECT user_name FROM ".$fusion_prefix."users WHERE user_id='$nazwa'"); $data3n = dbarray($result3n); echo "\n"; } echo "

Newsy	Napisany przez	w dniu
".$datan['news_subject']."	".$news_user_id."	".strftime($settings['forumdate'], $datan['news_datestamp']+($settings['timeoffset']*3600))."

\n";} else { echo "
Brak newsów*
* - wyszukiwarka przeszukuje tylko tytuły newsów";} require fusion_basedir."footer.php"; ?>