github/torrentpier
1
0
Fork 0
mirror of https://github.com/torrentpier/torrentpier synced 2025-07-05 12:36:12 -07:00
Code Issues Projects Releases Packages Wiki Activity Actions 1
torrentpier/search.php
Yury Pikhtarev cc9d412522
feat(test): add comprehensive testing infrastructure with Pest PHP (#1979) 
* feat(tests): integrate Pest testing framework and set up initial test structure

- Added Pest as a development dependency for enhanced testing capabilities.
- Created a PHPUnit configuration file (`phpunit.xml`) for test suite management.
- Established a base test case class (`TestCase.php`) for consistent test structure.
- Implemented example tests in both feature and unit directories to demonstrate usage.
- Introduced a custom Pest file (`Pest.php`) to extend functionality and define global helpers.

This setup streamlines the testing process and provides a foundation for future test development.

* feat(test): add comprehensive testing infrastructure with Pest PHP

- Add complete Pest PHP testing suite with extensive helper functions
- Implement unit tests for Database and DatabaseDebugger classes
- Implement unit tests for CacheManager and DatastoreManager classes
- Add comprehensive mock factories and test data generators
- Add custom Pest expectations for TorrentPier-specific validation
- Create detailed testing documentation with examples and best practices
- Update main README.md and UPGRADE_GUIDE.md with testing sections
- Update dependencies to support testing infrastructure
- Remove example test file and replace with production-ready tests

BREAKING CHANGE: None - all existing functionality maintained

The testing infrastructure includes:
- 25+ helper functions for test setup and mocking
- Singleton pattern testing for all major components
- Mock factories for Database, Cache, and external dependencies
- Custom expectations: toBeValidDatabaseConfig, toHaveDebugInfo
- Comprehensive documentation with real-world examples
- Performance testing utilities and execution time assertions
2025-06-20 22:00:12 +04:00

951 lines
32 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?php
/**
* TorrentPier – Bull-powered BitTorrent tracker engine
*
* @copyright Copyright (c) 2005-2025 TorrentPier (https://torrentpier.com)
* @link https://github.com/torrentpier/torrentpier for the canonical source repository
* @license https://github.com/torrentpier/torrentpier/blob/master/LICENSE MIT License
*/
define('BB_SCRIPT', 'search');
require __DIR__ . '/common.php';
require INC_DIR . '/bbcode.php';
$page_cfg['use_tablesorter'] = true;
$page_cfg['load_tpl_vars'] = [
'post_buttons',
'post_icons',
'topic_icons'
];
// Start session management
$user->session_start(array('req_login' => config()->get('disable_search_for_guest')));
set_die_append_msg();
if (isset($_POST['del_my_post'])) {
$template->assign_var('BB_DIE_APPEND_MSG', '
<a href="#" onclick="window.close(); window.opener.focus();">' . $lang['GOTO_MY_MESSAGE'] . '</a>
<br /><br />
<a href="index.php">' . $lang['INDEX_RETURN'] . '</a>
');
if (empty($_POST['topic_id_list']) or !$topic_csv = get_id_csv($_POST['topic_id_list'])) {
bb_die($lang['NONE_SELECTED']);
}
DB()->query("UPDATE " . BB_POSTS . " SET user_post = 0 WHERE poster_id = {$user->id} AND topic_id IN($topic_csv)");
if (DB()->affected_rows()) {
//bb_die('Выбранные темы ['. count($_POST['topic_id_list']) .' шт.] удалены из списка "Мои сообщения"');
bb_die($lang['DEL_MY_MESSAGE']);
} else {
bb_die($lang['NO_TOPICS_MY_MESSAGE']);
}
} elseif (isset($_POST['add_my_post'])) {
$template->assign_var('BB_DIE_APPEND_MSG', '
<a href="#" onclick="window.close(); window.opener.focus();">' . $lang['GOTO_MY_MESSAGE'] . '</a>
<br /><br />
<a href="index.php">' . $lang['INDEX_RETURN'] . '</a>
');
if (IS_GUEST) {
redirect('index.php');
}
DB()->query("UPDATE " . BB_POSTS . " SET user_post = 1 WHERE poster_id = {$user->id}");
redirect("search.php?" . POST_USERS_URL . "={$user->id}");
}
$tracking_topics = get_tracks('topic');
$tracking_forums = get_tracks('forum');
if ($mode =& $_REQUEST['mode']) {
// This handles the simple windowed user search functions called from various other scripts
if ($mode == 'searchuser') {
$username = $_POST['search_username'] ?? '';
username_search($username);
exit;
}
}
$excluded_forums_csv = $user->get_excluded_forums(AUTH_READ);
$search_limit = 500;
$forum_select_size = 16; // forum select box max rows
$max_forum_name_len = 60; // inside forum select box
$text_match_max_len = 60;
$poster_name_max_len = 25;
$start = isset($_REQUEST['start']) ? abs((int)$_REQUEST['start']) : 0;
$url = basename(__FILE__);
$anon_id = GUEST_UID;
$user_id = $userdata['user_id'];
$lastvisit = IS_GUEST ? TIMENOW : $userdata['user_lastvisit'];
$search_id = (isset($_GET['id']) && verify_id($_GET['id'], SEARCH_ID_LENGTH)) ? $_GET['id'] : '';
$session_id = $userdata['session_id'];
$items_found = $items_display = $previous_settings = null;
$text_match_sql = '';
$cat_tbl = BB_CATEGORIES . ' c';
$dl_stat_tbl = BB_BT_DLSTATUS . ' dl';
$forums_tbl = BB_FORUMS . ' f';
$posts_tbl = BB_POSTS . ' p';
$posts_text_tbl = BB_POSTS_TEXT . ' pt';
$posts_html_tbl = BB_POSTS_HTML . ' h';
$tr_snap_tbl = BB_BT_TRACKER_SNAP . ' sn';
$topics_tbl = BB_TOPICS . ' t';
$torrents_tbl = BB_BT_TORRENTS . ' tor';
$tracker_tbl = BB_BT_TRACKER . ' tr';
$users_tbl = BB_USERS . ' u';
// Cat/forum data
if (!$forums = $datastore->get('cat_forums')) {
$datastore->update('cat_forums');
$forums = $datastore->get('cat_forums');
}
$forum_name_html = $forums['forum_name_html'];
//
// Search options
//
// Key values
$search_all = 0;
$sort_asc = 1;
$sort_desc = 0;
$as_topics = 0;
$as_posts = 1;
$show_all = 0;
$show_briefly = 1;
$ord_posted = 1;
$ord_name = 2;
$ord_repl = 3;
$ord_views = 4;
$ord_last_p = 5;
$ord_created = 6;
// Order options
$order_opt = array(
$ord_posted => array(
'lang' => $lang['SORT_TIME'],
'sql' => 'item_id',
),
$ord_last_p => array(
'lang' => $lang['BT_LAST_POST'],
'sql' => 't.topic_last_post_id',
),
$ord_created => array(
'lang' => $lang['BT_CREATED'],
'sql' => 't.topic_time',
),
$ord_name => array(
'lang' => $lang['SORT_TOPIC_TITLE'],
'sql' => 't.topic_title',
),
$ord_repl => array(
'lang' => $lang['REPLIES'],
'sql' => 't.topic_replies',
),
);
$order_select = [];
foreach ($order_opt as $val => $opt) {
$order_select[$opt['lang']] = $val;
}
// Sort direction
$sort_opt = array(
$sort_asc => array(
'lang' => $lang['ASC'],
'sql' => ' ASC ',
),
$sort_desc => array(
'lang' => $lang['DESC'],
'sql' => ' DESC ',
),
);
$sort_select = [];
foreach ($sort_opt as $val => $opt) {
$sort_select[$opt['lang']] = $val;
}
// Previous days
$time_opt = array(
$search_all => array(
'lang' => $lang['BT_ALL_DAYS_FOR'],
'sql' => 0,
),
1 => array(
'lang' => $lang['BT_1_DAY_FOR'],
'sql' => TIMENOW - 86400,
),
3 => array(
'lang' => $lang['BT_3_DAY_FOR'],
'sql' => TIMENOW - 86400 * 3,
),
7 => array(
'lang' => $lang['BT_7_DAYS_FOR'],
'sql' => TIMENOW - 86400 * 7,
),
14 => array(
'lang' => $lang['BT_2_WEEKS_FOR'],
'sql' => TIMENOW - 86400 * 14,
),
30 => array(
'lang' => $lang['BT_1_MONTH_FOR'],
'sql' => TIMENOW - 86400 * 30,
),
);
$time_select = [];
foreach ($time_opt as $val => $opt) {
$time_select[$opt['lang']] = $val;
}
// Display as
$display_as_opt = array(
$as_topics => array(
'lang' => $lang['TOPICS'],
),
$as_posts => array(
'lang' => $lang['MESSAGE'],
),
);
$display_as_select = [];
foreach ($display_as_opt as $val => $opt) {
$display_as_select[$opt['lang']] = $val;
}
// Chars
$chars_opt = array(
$show_all => array(
'lang' => $lang['ALL_AVAILABLE'],
),
$show_briefly => array(
'lang' => $lang['BRIEFLY'],
),
);
$chars_select = [];
foreach ($chars_opt as $val => $opt) {
$chars_select[$opt['lang']] = $val;
}
$GPC = array(
# var_name key_name def_value GPC type
'all_words' => array('allw', 1, CHBOX),
'cat' => array('c', null, REQUEST),
'chars' => array('ch', $show_all, SELECT),
'display_as' => array('dm', $as_topics, SELECT),
'dl_cancel' => array('dla', 0, CHBOX),
'dl_compl' => array('dlc', 0, CHBOX),
'dl_down' => array('dld', 0, CHBOX),
'dl_user_id' => array('dlu', $user_id, CHBOX),
'dl_will' => array('dlw', 0, CHBOX),
'forum' => array('f', $search_all, REQUEST),
'my_topics' => array('myt', 0, CHBOX),
'new' => array('new', 0, CHBOX),
'new_topics' => array('nt', 0, CHBOX),
'order' => array('o', $ord_posted, SELECT),
'poster_id' => array('uid', null, REQUEST),
'poster_name' => array('pn', null, REQUEST),
'sort' => array('s', $sort_desc, SELECT),
'text_match' => array('nm', null, REQUEST),
'time' => array('tm', $search_all, SELECT),
'title_only' => array('to', 0, CHBOX),
'topic' => array('t', null, REQUEST),
);
// Define all GPC vars with default values
foreach ($GPC as $var_name => $var_options) {
$GLOBALS["{$var_name}_key"] = $var_options[KEY_NAME];
$GLOBALS["{$var_name}_val"] = $var_options[DEF_VAL];
}
// Output basic page
if (empty($_GET) && empty($_POST)) {
// Make forum select box
$forum_select_mode = explode(',', $excluded_forums_csv);
$forum_select = get_forum_select($forum_select_mode, "{$forum_key}[]", $search_all, $max_forum_name_len, $forum_select_size, 'style="width: 95%;"', $search_all);
$template->assign_vars(array(
'TPL_SEARCH_MAIN' => true,
'PAGE_TITLE' => $lang['SEARCH'],
'POSTER_ID_KEY' => $poster_id_key,
'TEXT_MATCH_KEY' => $text_match_key,
'POSTER_NAME_KEY' => $poster_name_key,
'THIS_USER_ID' => $userdata['user_id'],
'THIS_USER_NAME' => addslashes($userdata['username']),
'SEARCH_ACTION' => 'search.php',
'U_SEARCH_USER' => "search.php?mode=searchuser&amp;input_name=$poster_name_key",
'ONLOAD_FOCUS_ID' => 'text_match_input',
'MY_TOPICS_ID' => 'my_topics',
'MY_TOPICS_CHBOX' => build_checkbox($my_topics_key, $lang['SEARCH_MY_TOPICS'], $my_topics_val, true, null, 'my_topics'),
'TITLE_ONLY_CHBOX' => build_checkbox($title_only_key, $lang['SEARCH_TITLES_ONLY'], true, config()->get('disable_ft_search_in_posts')),
'ALL_WORDS_CHBOX' => build_checkbox($all_words_key, $lang['SEARCH_ALL_WORDS'], true),
'DL_CANCEL_CHBOX' => build_checkbox($dl_cancel_key, $lang['SEARCH_DL_CANCEL'], $dl_cancel_val, IS_GUEST, 'dlCancel'),
'DL_COMPL_CHBOX' => build_checkbox($dl_compl_key, $lang['SEARCH_DL_COMPLETE'], $dl_compl_val, IS_GUEST, 'dlComplete'),
'DL_DOWN_CHBOX' => build_checkbox($dl_down_key, $lang['SEARCH_DL_DOWN'], $dl_down_val, IS_GUEST, 'dlDown'),
'DL_WILL_CHBOX' => build_checkbox($dl_will_key, $lang['SEARCH_DL_WILL'], $dl_will_val, IS_GUEST, 'dlWill'),
'ONLY_NEW_CHBOX' => build_checkbox($new_key, $lang['BT_ONLY_NEW'], $new_val, IS_GUEST),
'NEW_TOPICS_CHBOX' => build_checkbox($new_topics_key, $lang['NEW_TOPICS'], $new_topics_val, IS_GUEST),
'FORUM_SELECT' => $forum_select,
'TIME_SELECT' => build_select($time_key, $time_select, $time_val),
'ORDER_SELECT' => build_select($order_key, $order_select, $order_val),
'SORT_SELECT' => build_select($sort_key, $sort_select, $sort_val),
'CHARS_SELECT' => '', # build_select ($chars_key, $chars_select, $chars_val),
'DISPLAY_AS_SELECT' => build_select($display_as_key, $display_as_select, $display_as_val),
));
print_page('search.tpl');
}
unset($forums);
$datastore->rm('cat_forums');
// Restore previously found items list and search settings if we have valid $search_id
if ($search_id) {
$row = DB()->fetch_row("
SELECT search_array, search_settings
FROM " . BB_SEARCH . "
WHERE session_id = '$session_id'
AND search_type = " . SEARCH_TYPE_POST . "
AND search_id = '" . DB()->escape($search_id) . "'
LIMIT 1
");
if (empty($row['search_settings'])) {
bb_die($lang['SESSION_EXPIRED']);
}
$previous_settings = unserialize($row['search_settings']);
$items_found = explode(',', $row['search_array']);
}
// Get simple "CHBOX" and "SELECT" type vars
foreach ($GPC as $name => $params) {
if ($params[GPC_TYPE] == CHBOX) {
checkbox_get_val($params[KEY_NAME], ${"{$name}_val"}, $params[DEF_VAL]);
} elseif ($params[GPC_TYPE] == SELECT) {
select_get_val($params[KEY_NAME], ${"{$name}_val"}, ${"{$name}_opt"}, $params[DEF_VAL]);
}
}
// Get other "REQUEST" vars
$egosearch = false;
if (!$items_found) {
// For compatibility with old-style params
if (isset($_REQUEST['search_id'])) {
switch ($_REQUEST['search_id']) {
case 'egosearch':
$egosearch = true;
$display_as_val = $as_topics;
if (empty($_REQUEST[$poster_id_key])) {
$_REQUEST[$poster_id_key] = $user_id;
}
break;
case 'newposts':
$new_val = true;
break;
}
}
// Forum
$forum_selected = [];
if ($var =& $_REQUEST[$forum_key]) {
$forum_selected = get_id_ary($var);
if (!in_array($search_all, $forum_selected)) {
$forum_val = implode(',', $forum_selected);
}
}
// Topic
if ($var =& $_REQUEST[$topic_key]) {
$topic_val = implode(',', get_id_ary($var));
}
// Poster id (from requested name or id)
if ($var = request_var($poster_id_key, 0)) {
$poster_id_val = (int)$var;
if ($poster_id_val != $user_id && !get_username($poster_id_val)) {
bb_die($lang['USER_NOT_EXIST']);
}
} elseif ($var =& $_POST[$poster_name_key]) {
$poster_name_sql = str_replace("\\'", "''", clean_username($var));
if (!$poster_id_val = get_user_id($poster_name_sql)) {
bb_die($lang['USER_NOT_EXIST']);
}
}
// Search words
if ($var =& $_REQUEST[$text_match_key]) {
if ($tmp = mb_substr(trim($var), 0, $text_match_max_len)) {
$title_match_val = $tmp;
$text_match_sql = clean_text_match($title_match_val, $all_words_val, true);
}
}
}
$dl_status = [];
if ($dl_cancel_val) {
$dl_status[] = DL_STATUS_CANCEL;
}
if ($dl_compl_val) {
$dl_status[] = DL_STATUS_COMPLETE;
}
if ($dl_down_val) {
$dl_status[] = DL_STATUS_DOWN;
}
if ($dl_will_val) {
$dl_status[] = DL_STATUS_WILL;
}
$dl_status_csv = implode(',', $dl_status);
// Switches
$dl_search = ($dl_status && !IS_GUEST);
$new_posts = ($new_val && !IS_GUEST);
$prev_days = ($time_val != $search_all);
$new_topics = (!IS_GUEST && ($new_topics_val || isset($_GET['newposts'])));
$my_topics = ($poster_id_val && $my_topics_val);
$my_posts = ($poster_id_val && !$my_topics_val);
$title_match = ($text_match_sql && ($title_only_val || config()->get('disable_ft_search_in_posts')));
// "Display as" mode (posts or topics)
$post_mode = (!$dl_search && ($display_as_val == $as_posts || isset($_GET['search_author'])));
// Start building SQL
$SQL = DB()->get_empty_sql_array();
// Displaying "as posts" mode
if ($post_mode) {
$order = $order_opt[$order_val]['sql'];
$sort = $sort_opt[$sort_val]['sql'];
$per_page = config()->get('posts_per_page');
$display_as_val = $as_posts;
// Run initial search for post_ids
if (!$items_found) {
$join_t = ($title_match || $my_topics || $new_topics || in_array($order_val, array($ord_last_p, $ord_created, $ord_name, $ord_repl)));
$join_s = ($text_match_sql && !$title_match);
$join_p = ($my_posts || $join_s);
$tbl = ($join_t && !$join_p) ? 't' : 'p';
$time_field = ($join_t && !$join_p) ? 'topic_last_post_time' : 'post_time';
// SELECT
$SQL['SELECT'][] = ($join_t && !$join_p) ? 't.topic_first_post_id AS item_id' : 'p.post_id AS item_id';
// FROM
if ($join_t) {
$SQL['FROM'][] = $topics_tbl;
}
if ($join_p) {
$SQL['FROM'][] = $posts_tbl;
}
if (!$SQL['FROM']) {
$join_p = true;
$SQL['FROM'][] = $posts_tbl;
}
// WHERE
if ($join_p && $join_t) {
$SQL['WHERE'][] = "t.topic_id = p.topic_id";
}
if ($excluded_forums_csv) {
$SQL['WHERE'][] = "$tbl.forum_id NOT IN($excluded_forums_csv)";
}
if ($forum_val) {
$SQL['WHERE'][] = "$tbl.forum_id IN($forum_val)";
}
if ($topic_val) {
$SQL['WHERE'][] = "$tbl.topic_id IN($topic_val)";
}
if ($new_posts) {
$SQL['WHERE'][] = "$tbl.$time_field > $lastvisit";
}
if ($new_topics) {
$SQL['WHERE'][] = "t.topic_time > $lastvisit";
}
if ($prev_days) {
$SQL['WHERE'][] = "$tbl.$time_field > " . $time_opt[$time_val]['sql'];
}
if ($my_posts) {
$SQL['WHERE'][] = "p.poster_id = $poster_id_val";
}
if ($my_topics) {
$SQL['WHERE'][] = "t.topic_poster = $poster_id_val";
}
if ($text_match_sql) {
$search_match_topics_csv = '';
$title_match_topics = get_title_match_topics($text_match_sql, $forum_selected);
if (!$search_match_topics_csv = implode(',', $title_match_topics)) {
bb_die($lang['NO_SEARCH_MATCH']);
}
$where_id = ($title_match) ? 'topic_id' : 'post_id';
$SQL['WHERE'][] = "$tbl.$where_id IN($search_match_topics_csv)";
prevent_huge_searches($SQL);
}
if (!$SQL['WHERE']) {
redirect(basename(__FILE__));
}
$SQL['GROUP BY'][] = "item_id";
// Fix for MySQL only_full_group_by mode: use MAX() when ordering by post_time with GROUP BY
$SQL['ORDER BY'][] = ($new_posts && $join_p) ? "p.topic_id ASC, MAX(p.post_time) ASC" : "$order $sort";
$SQL['LIMIT'][] = (string)$search_limit;
$items_display = fetch_search_ids($SQL);
} elseif (!$items_display = array_slice($items_found, $start, $per_page)) {
bb_die($lang['NO_SEARCH_MATCH']);
}
// Build SQL for displaying posts
$excluded_forums_sql = ($excluded_forums_csv) ? " AND t.forum_id NOT IN($excluded_forums_csv) " : '';
$sql = "
SELECT
p.post_id AS item_id,
t.*,
p.*,
h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text,
IF(p.poster_id = $anon_id, p.post_username, u.username) AS username, u.user_id, u.user_rank
FROM $posts_tbl
INNER JOIN $topics_tbl ON(t.topic_id = p.topic_id)
INNER JOIN $posts_text_tbl ON(pt.post_id = p.post_id)
LEFT JOIN $posts_html_tbl ON(h.post_id = pt.post_id)
INNER JOIN $users_tbl ON(u.user_id = p.poster_id)
WHERE
p.post_id IN(" . implode(',', $items_display) . ")
$excluded_forums_sql
LIMIT $per_page
";
// Fetch posts data
if (!$unsorted_rows = DB()->fetch_rowset($sql)) {
bb_die($lang['NO_SEARCH_MATCH']);
}
$tmp = $sorted_rows = [];
foreach ($unsorted_rows as $row) {
$tmp[$row['post_id']] = $row;
}
foreach ($items_display as $post_id) {
if (empty($tmp[$post_id])) {
continue; // if post was deleted but still remain in search results
}
$topic_id = $tmp[$post_id]['topic_id'];
$sorted_rows[$topic_id][] = $tmp[$post_id];
}
// Output page
$new_tracks = [];
foreach ($sorted_rows as $topic_id => $topic_posts) {
// Topic title block
$first_post = reset($topic_posts);
$topic_id = (int)$topic_id;
$forum_id = (int)$first_post['forum_id'];
$is_unread_t = is_unread($first_post['topic_last_post_time'], $topic_id, $forum_id);
$template->assign_block_vars('t', array(
'FORUM_ID' => $forum_id,
'FORUM_NAME' => $forum_name_html[$forum_id],
'TOPIC_ID' => $topic_id,
'TOPIC_TITLE' => censor()->censorString($first_post['topic_title']),
'TOPIC_ICON' => get_topic_icon($first_post, $is_unread_t),
));
$quote_btn = $edit_btn = $ip_btn = '';
$delpost_btn = IS_AM;
// Topic posts block
foreach ($topic_posts as $row_num => $post) {
if ($post['poster_id'] != BOT_UID) {
$quote_btn = !IS_GUEST;
$edit_btn = $ip_btn = IS_AM;
}
$message = get_parsed_post($post);
$message = censor()->censorString($message);
$template->assign_block_vars('t.p', array(
'ROW_NUM' => $row_num,
'POSTER_ID' => $post['poster_id'],
'POSTER' => profile_url($post),
'POST_ID' => $post['post_id'],
'POST_DATE' => bb_date($post['post_time'], config()->get('post_date_format')),
'IS_UNREAD' => is_unread($post['post_time'], $topic_id, $forum_id),
'MESSAGE' => $message,
'POSTED_AFTER' => '',
'QUOTE' => $quote_btn,
'EDIT' => $edit_btn,
'DELETE' => $delpost_btn,
'IP' => $ip_btn,
));
$curr_new_track_val = !empty($new_tracks[$topic_id]) ? $new_tracks[$topic_id] : 0;
$new_tracks[$topic_id] = max($curr_new_track_val, $post['post_time']);
}
}
set_tracks(COOKIE_TOPIC, $tracking_topics, $new_tracks);
} // Displaying "as topics" mode
else {
$order = $order_opt[$order_val]['sql'];
$sort = $sort_opt[$sort_val]['sql'];
$per_page = config()->get('topics_per_page');
$display_as_val = $as_topics;
// Run initial search for topic_ids
if (!$items_found) {
$join_t = ($title_match || $my_topics || $new_topics || $dl_search || $new_posts || in_array($order_val, array($ord_last_p, $ord_created, $ord_name, $ord_repl)));
$join_s = ($text_match_sql && !$title_match);
$join_p = ($my_posts || $join_s);
$join_dl = ($dl_search);
$tbl = ($join_p && !$join_t) ? 'p' : 't';
$time_field = ($join_p && !$join_t) ? 'post_time' : 'topic_last_post_time';
// SELECT
if ($egosearch) {
$SQL['SELECT'][] = 'p.topic_id AS item_id, MAX(p.post_time) AS max_post_time';
} else {
$SQL['SELECT'][] = ($join_p && !$join_t) ? 'p.topic_id AS item_id' : 't.topic_id AS item_id';
}
// FROM
if ($join_t) {
$SQL['FROM'][] = $topics_tbl;
}
if ($join_p) {
$SQL['FROM'][] = $posts_tbl;
}
if (!$SQL['FROM']) {
$join_t = true;
$SQL['FROM'][] = $topics_tbl;
}
// WHERE
if ($join_p && $join_t) {
$SQL['WHERE'][] = "t.topic_id = p.topic_id";
}
if ($excluded_forums_csv) {
$SQL['WHERE'][] = "$tbl.forum_id NOT IN($excluded_forums_csv)";
}
if ($join_t) {
$SQL['WHERE'][] = "t.topic_status != " . TOPIC_MOVED;
}
if ($forum_val) {
$SQL['WHERE'][] = "$tbl.forum_id IN($forum_val)";
}
if ($topic_val) {
$SQL['WHERE'][] = "$tbl.topic_id IN($topic_val)";
}
if ($new_posts) {
$SQL['WHERE'][] = "$tbl.$time_field > $lastvisit";
}
if ($new_topics) {
$SQL['WHERE'][] = "t.topic_time > $lastvisit";
}
if ($prev_days) {
$SQL['WHERE'][] = "$tbl.$time_field > " . $time_opt[$time_val]['sql'];
}
if ($my_posts) {
$SQL['WHERE'][] = "p.poster_id = $poster_id_val";
}
if ($my_posts && $user->id == $poster_id_val) {
$SQL['WHERE'][] = "p.user_post = 1";
if ($userdata['user_posts']) {
$template->assign_var('BB_DIE_APPEND_MSG', '
<form id="mod-action" method="POST" action="search.php">
<input type="submit" name="add_my_post" value="' . $lang['RESTORE_ALL_POSTS'] . '" class="bold" onclick="if (!window.confirm( this.value +\'?\' )){ return false };" />
</form>
<br /><br />
<a href="index.php">' . $lang['INDEX_RETURN'] . '</a>
');
}
}
if ($my_topics) {
$SQL['WHERE'][] = "t.topic_poster = $poster_id_val";
}
if ($text_match_sql) {
$search_match_topics_csv = '';
$title_match_topics = get_title_match_topics($text_match_sql, $forum_selected);
if (!$search_match_topics_csv = implode(',', $title_match_topics)) {
bb_die($lang['NO_SEARCH_MATCH']);
}
$where_id = ($title_match) ? 't.topic_id' : 'p.post_id';
$SQL['WHERE'][] = "$where_id IN($search_match_topics_csv)";
prevent_huge_searches($SQL);
}
if ($join_dl) {
$SQL['FROM'][] = $dl_stat_tbl;
}
if ($join_dl) {
$SQL['WHERE'][] = "dl.topic_id = t.topic_id AND dl.user_id = $dl_user_id_val AND dl.user_status IN($dl_status_csv)";
}
if (!$SQL['WHERE']) {
redirect(basename(__FILE__));
}
$SQL['GROUP BY'][] = "item_id";
$SQL['LIMIT'][] = (string)$search_limit;
if ($egosearch) {
$SQL['ORDER BY'][] = 'max_post_time DESC';
} else {
// Fix for MySQL only_full_group_by mode: use MAX() when ordering by post_time with GROUP BY
if ($order_val == $ord_posted) {
$SQL['ORDER BY'][] = "MAX($tbl.$time_field) $sort";
} else {
$SQL['ORDER BY'][] = "$order $sort";
}
}
$items_display = fetch_search_ids($SQL);
} elseif (!$items_display = array_slice($items_found, $start, $per_page)) {
bb_die($lang['NO_SEARCH_MATCH']);
}
// Build SQL for displaying topics
$SQL = DB()->get_empty_sql_array();
$join_dl = (config()->get('show_dl_status_in_search') && !IS_GUEST);
$SQL['SELECT'][] = "
t.*, t.topic_poster AS first_user_id, u1.user_rank AS first_user_rank,
IF(t.topic_poster = $anon_id, p1.post_username, u1.username) AS first_username,
p2.poster_id AS last_user_id, u2.user_rank AS last_user_rank,
IF(p2.poster_id = $anon_id, p2.post_username, u2.username) AS last_username
";
if ($join_dl) {
$SQL['SELECT'][] = "dl.user_status AS dl_status";
}
$SQL['FROM'][] = BB_TOPICS . " t";
$SQL['LEFT JOIN'][] = BB_POSTS . " p1 ON(t.topic_first_post_id = p1.post_id)";
$SQL['LEFT JOIN'][] = BB_USERS . " u1 ON(t.topic_poster = u1.user_id)";
$SQL['LEFT JOIN'][] = BB_POSTS . " p2 ON(t.topic_last_post_id = p2.post_id)";
$SQL['LEFT JOIN'][] = BB_USERS . " u2 ON(p2.poster_id = u2.user_id)";
if ($join_dl) {
$SQL['LEFT JOIN'][] = BB_BT_DLSTATUS . " dl ON(dl.user_id = $user_id AND dl.topic_id = t.topic_id)";
}
$SQL['WHERE'][] = "t.topic_id IN(" . implode(',', $items_display) . ")";
if ($excluded_forums_csv) {
$SQL['WHERE'][] = "t.forum_id NOT IN($excluded_forums_csv)";
}
$SQL['LIMIT'][] = (string)$per_page;
// Fetch topics data
$topic_rows = [];
foreach (DB()->fetch_rowset($SQL) as $row) {
$topic_rows[$row['topic_id']] = $row;
}
if (!$topic_rows) {
bb_die($lang['NO_SEARCH_MATCH']);
}
// Output page
foreach ($items_display as $row_num => $item_id) {
if (empty($topic_rows[$item_id])) {
continue; // if topic was deleted but still remain in search results
}
$topic = $topic_rows[$item_id];
$topic_id = $topic['topic_id'];
$forum_id = $topic['forum_id'];
$is_unread = is_unread($topic['topic_last_post_time'], $topic_id, $forum_id);
$moved = ($topic['topic_status'] == TOPIC_MOVED);
$template->assign_block_vars('t', array(
'ROW_NUM' => $row_num,
'FORUM_ID' => $forum_id,
'FORUM_NAME' => $forum_name_html[$forum_id],
'TOPIC_ID' => $topic_id,
'HREF_TOPIC_ID' => $moved ? $topic['topic_moved_id'] : $topic['topic_id'],
'TOPIC_TITLE' => censor()->censorString($topic['topic_title']),
'IS_UNREAD' => $is_unread,
'TOPIC_ICON' => get_topic_icon($topic, $is_unread),
'PAGINATION' => $moved ? '' : build_topic_pagination(TOPIC_URL . $topic_id, $topic['topic_replies'], config()->get('posts_per_page')),
'REPLIES' => $moved ? '' : $topic['topic_replies'],
'ATTACH' => $topic['topic_attachment'],
'STATUS' => $topic['topic_status'],
'TYPE' => $topic['topic_type'],
'DL' => ($topic['topic_dl_type'] == TOPIC_DL_TYPE_DL),
'POLL' => (bool)$topic['topic_vote'],
'DL_CLASS' => isset($topic['dl_status']) ? $dl_link_css[$topic['dl_status']] : '',
'TOPIC_AUTHOR' => profile_url(array('username' => $topic['first_username'], 'user_id' => $topic['first_user_id'], 'user_rank' => $topic['first_user_rank'])),
'LAST_POSTER' => profile_url(array('username' => $topic['last_username'], 'user_id' => $topic['last_user_id'], 'user_rank' => $topic['last_user_rank'])),
'LAST_POST_TIME' => bb_date($topic['topic_last_post_time']),
'LAST_POST_TIME_RAW' => $topic['topic_last_post_time'],
'LAST_POST_ID' => $topic['topic_last_post_id'],
));
}
}
if ($items_display) {
$items_count = count($items_found);
$pages = (!$items_count) ? 1 : ceil($items_count / $per_page);
$url = ($search_id) ? url_arg($url, 'id', $search_id) : $url;
generate_pagination($url, $items_count, $per_page, $start);
$template->assign_vars(array(
'PAGE_TITLE' => $lang['SEARCH'],
'SEARCH_MATCHES' => ($items_count) ? sprintf($lang['FOUND_SEARCH_MATCHES'], $items_count) : '',
'DISPLAY_AS_POSTS' => $post_mode,
'DL_CONTROLS' => ($dl_search && $dl_user_id_val == $user_id),
'DL_ACTION' => 'dl_list.php',
'MY_POSTS' => (!$post_mode && $my_posts && $user->id == $poster_id_val),
));
print_page('search_results.tpl');
}
redirect(basename(__FILE__));
// ----------------------------------------------------------- //
// Functions
//
function fetch_search_ids($sql, $search_type = SEARCH_TYPE_POST)
{
global $lang, $search_id, $session_id, $items_found, $per_page;
$items_found = [];
foreach (DB()->fetch_rowset($sql) as $row) {
$items_found[] = $row['item_id'];
}
if (!$items_count = count($items_found)) {
bb_die($lang['NO_SEARCH_MATCH']);
}
// Save results in DB
$search_id = make_rand_str(SEARCH_ID_LENGTH);
if ($items_count > $per_page) {
$search_array = implode(',', $items_found);
$save_in_db = array(
'order',
'sort',
'display_as',
'chars',
);
if ($GLOBALS['dl_cancel_val']) {
$save_in_db[] = 'dl_cancel';
}
if ($GLOBALS['dl_compl_val']) {
$save_in_db[] = 'dl_compl';
}
if ($GLOBALS['dl_down_val']) {
$save_in_db[] = 'dl_down';
}
if ($GLOBALS['dl_will_val']) {
$save_in_db[] = 'dl_will';
}
$curr_set = [];
foreach ($save_in_db as $name) {
$curr_set[$GLOBALS["{$name}_key"]] = $GLOBALS["{$name}_val"];
}
$search_settings = DB()->escape(serialize($curr_set));
$columns = 'session_id, search_type, search_id, search_time, search_settings, search_array';
$values = "'$session_id', $search_type, '$search_id', " . TIMENOW . ", '$search_settings', '$search_array'";
DB()->query("REPLACE INTO " . BB_SEARCH . " ($columns) VALUES ($values)");
}
return array_slice($items_found, 0, $per_page);
}
function prevent_huge_searches($SQL)
{
if (config()->get('limit_max_search_results')) {
$SQL['select_options'][] = 'SQL_CALC_FOUND_ROWS';
$SQL['ORDER BY'] = [];
$SQL['LIMIT'] = array('0');
if (DB()->query($SQL) and $row = DB()->fetch_row("SELECT FOUND_ROWS() AS rows_count")) {
if ($row['rows_count'] > config()->get('limit_max_search_results')) {
# bb_log(str_compact(DB()->build_sql($SQL)) ." [{$row['rows_count']} rows]". LOG_LF, 'sql_huge_search');
bb_die('Too_many_search_results');
}
}
}
}
function username_search($search_match)
{
global $template, $lang, $gen_simple_header;
$username_list = '';
if (!empty($search_match)) {
$username_search = str_replace('*', '%', clean_username($search_match));
$sql = "
SELECT username
FROM " . BB_USERS . "
WHERE username LIKE '" . DB()->escape($username_search) . "'
AND user_id <> " . GUEST_UID . "
ORDER BY username
LIMIT 200
";
foreach (DB()->fetch_rowset($sql) as $row) {
$username = htmlCHR(stripslashes(html_entity_decode($row['username'])));
$username_list .= '<option value="' . $username . '">' . $username . '</option>';
}
if (!$username_list) {
$username_list = '<option value="">' . $lang['NO_MATCH'] . '</option>';
}
}
$input_name = isset($_REQUEST['input_name']) ? htmlCHR($_REQUEST['input_name']) : 'username';
$template->assign_vars(array(
'TPL_SEARCH_USERNAME' => true,
'PAGE_TITLE' => $lang['SEARCH'],
'USERNAME' => !empty($search_match) ? htmlCHR(stripslashes(html_entity_decode($search_match))) : '',
'INPUT_NAME' => $input_name,
'USERNAME_OPTIONS' => $username_list,
'SEARCH_ACTION' => "search.php?mode=searchuser&amp;input_name=$input_name",
));
print_page('search.tpl', 'simple');
}
Reference in a new issue View git blame Copy permalink