} else { if ($_GET['sort'] == "author") { $sortby = "post_author"; } } } $ssubject = search_querylike("thread_subject"); $smessage = search_querylike("post_message"); if ($_GET['fields'] == 0) { $fieldsvar = search_fieldsvar($ssubject); } else { if ($_GET['fields'] == 1) { $fieldsvar = search_fieldsvar($smessage); } else { if ($_GET['fields'] == 2) { $fieldsvar = search_fieldsvar($ssubject, $smessage); } else { $fieldsvar = ""; } } } 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)) {
$sortby = "photo_user"; } } } $ssubject1 = search_querylike("photo_title"); $smessage1 = search_querylike("photo_description"); $ssubject2 = search_querylike("album_title"); $smessage2 = search_querylike("album_description"); if ($_GET['fields'] == 0) { $fieldsvar = search_fieldsvar($ssubject1, $ssubject2); } else { if ($_GET['fields'] == 1) { $fieldsvar = search_fieldsvar($smessage1, $smessage2); } else { if ($_GET['fields'] == 2) { $fieldsvar = search_fieldsvar($ssubject1, $ssubject2, $smessage1, $smessage2); } else { $fieldsvar = ""; } } } if ($fieldsvar) { $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']) . ")" : "")); $rows = dbrows($result); } else { $rows = 0; } 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)) {
if ($_GET['sort'] == "author") { $sortby = "news_name"; } } } $ssubject = search_querylike("news_subject"); $smessage = search_querylike("news_news"); $sextended = search_querylike("news_extended"); if ($_GET['fields'] == 0) { $fieldsvar = search_fieldsvar($ssubject); } else { if ($_GET['fields'] == 1) { $fieldsvar = search_fieldsvar($smessage, $sextended); } else { if ($_GET['fields'] == 2) { $fieldsvar = search_fieldsvar($ssubject, $smessage, $sextended); } else { $fieldsvar = ""; } } } if ($fieldsvar) { $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 = "";
$sortby = "weblink_name"; } else { $sortby = "weblink_datestamp"; } } $ssubject = search_querylike("weblink_name"); $smessage = search_querylike("weblink_description"); $surllink = search_querylike("weblink_url"); if ($_GET['fields'] == 0) { $fieldsvar = search_fieldsvar($ssubject, $surllink); } else { if ($_GET['fields'] == 1) { $fieldsvar = search_fieldsvar($smessage, $surllink); } else { if ($_GET['fields'] == 2) { $fieldsvar = search_fieldsvar($ssubject, $smessage, $surllink); } else { $fieldsvar = ""; } } } if ($fieldsvar) { $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']) : "")); $rows = dbrows($result); } 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)) {