diff -r e3d7322305bf -r 5e1f1e916419 punbb/search.php --- a/punbb/search.php Sun Sep 02 11:00:57 2007 -0400 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,778 +0,0 @@ -query('SELECT search_data FROM '.$pun_db->prefix.'search_cache WHERE id='.$search_id.' AND ident=\''.$pun_db->escape($ident).'\'') or error('Unable to fetch search results', __FILE__, __LINE__, $pun_db->error()); - if ($row = $pun_db->fetch_assoc($result)) - { - $temp = unserialize($row['search_data']); - - $search_results = $temp['search_results']; - $num_hits = $temp['num_hits']; - $sort_by = $temp['sort_by']; - $sort_dir = $temp['sort_dir']; - $show_as = $temp['show_as']; - - unset($temp); - } - else - message($lang_search['No hits']); - } - else - { - $keyword_results = $author_results = array(); - - // Search a specific forum? - $forum_sql = ($forum != -1 || ($forum == -1 && $pun_config['o_search_all_forums'] == '0')) ? ' AND t.forum_id = '.$forum : ''; - - if (!empty($author) || !empty($keywords)) - { - // If it's a search for keywords - if ($keywords) - { - $stopwords = (array)@file(PUN_ROOT.'lang/'.$pun_user['language'].'/stopwords.txt'); - $stopwords = array_map('trim', $stopwords); - - // Are we searching for multibyte charset text? - if ($multibyte) - { - // Strip out excessive whitespace - $keywords = trim(preg_replace('#\s+#', ' ', $keywords)); - - $keywords_array = explode(' ', $keywords); - } - else - { - // Filter out non-alphabetical chars - $noise_match = array('^', '$', '&', '(', ')', '<', '>', '`', '\'', '"', '|', ',', '@', '_', '?', '%', '~', '[', ']', '{', '}', ':', '\\', '/', '=', '#', '\'', ';', '!', '�'); - $noise_replace = array(' ', ' ', ' ', ' ', ' ', ' ', ' ', '', '', ' ', ' ', ' ', ' ', '', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '' , ' ', ' ', ' ', ' ', ' ', ' ', ' '); - $keywords = str_replace($noise_match, $noise_replace, $keywords); - - // Strip out excessive whitespace - $keywords = trim(preg_replace('#\s+#', ' ', $keywords)); - - // Fill an array with all the words - $keywords_array = explode(' ', $keywords); - - if (empty($keywords_array)) - message($lang_search['No hits']); - - while (list($i, $word) = @each($keywords_array)) - { - $num_chars = pun_strlen($word); - - if ($num_chars < 3 || $num_chars > 20 || in_array($word, $stopwords)) - unset($keywords_array[$i]); - } - - // Should we search in message body or topic subject specifically? - $search_in_cond = ($search_in) ? (($search_in > 0) ? ' AND m.subject_match = 0' : ' AND m.subject_match = 1') : ''; - } - - $word_count = 0; - $match_type = 'and'; - $result_list = array(); - @reset($keywords_array); - while (list(, $cur_word) = @each($keywords_array)) - { - switch ($cur_word) - { - case 'and': - case 'or': - case 'not': - $match_type = $cur_word; - break; - - default: - { - // Are we searching for multibyte charset text? - if ($multibyte) - { - $cur_word = $pun_db->escape('%'.str_replace('*', '', $cur_word).'%'); - $cur_word_like = ($db_type == 'pgsql') ? 'ILIKE \''.$cur_word.'\'' : 'LIKE \''.$cur_word.'\''; - - if ($search_in > 0) - $sql = 'SELECT id FROM '.$pun_db->prefix.'posts WHERE message '.$cur_word_like; - else if ($search_in < 0) - $sql = 'SELECT p.id FROM '.$pun_db->prefix.'posts AS p INNER JOIN '.$pun_db->prefix.'topics AS t ON t.id=p.topic_id WHERE t.subject '.$cur_word_like.' GROUP BY p.id, t.id'; - else - $sql = 'SELECT p.id FROM '.$pun_db->prefix.'posts AS p INNER JOIN '.$pun_db->prefix.'topics AS t ON t.id=p.topic_id WHERE p.message '.$cur_word_like.' OR t.subject '.$cur_word_like.' GROUP BY p.id, t.id'; - } - else - { - $cur_word = str_replace('*', '%', $cur_word); - $sql = 'SELECT m.post_id FROM '.$pun_db->prefix.'search_words AS w INNER JOIN '.$pun_db->prefix.'search_matches AS m ON m.word_id = w.id WHERE w.word LIKE \''.$cur_word.'\''.$search_in_cond; - } - - $result = $pun_db->query($sql, true) or error('Unable to search for posts', __FILE__, __LINE__, $pun_db->error()); - - $row = array(); - while ($temp = $pun_db->fetch_row($result)) - { - $row[$temp[0]] = 1; - - if (!$word_count) - $result_list[$temp[0]] = 1; - else if ($match_type == 'or') - $result_list[$temp[0]] = 1; - else if ($match_type == 'not') - $result_list[$temp[0]] = 0; - } - - if ($match_type == 'and' && $word_count) - { - @reset($result_list); - while (list($post_id,) = @each($result_list)) - { - if (!isset($row[$post_id])) - $result_list[$post_id] = 0; - } - } - - ++$word_count; - $pun_db->free_result($result); - - break; - } - } - } - - @reset($result_list); - while (list($post_id, $matches) = @each($result_list)) - { - if ($matches) - $keyword_results[] = $post_id; - } - - unset($result_list); - } - - // If it's a search for author name (and that author name isn't Guest) - if ($author && strcasecmp($author, 'Guest') && strcasecmp($author, $lang_common['Guest'])) - { - switch ($db_type) - { - case 'pgsql': - $result = $pun_db->query('SELECT id FROM '.$pun_db->prefix.'users WHERE username ILIKE \''.$pun_db->escape($author).'\'') or error('Unable to fetch users', __FILE__, __LINE__, $pun_db->error()); - break; - - default: - $result = $pun_db->query('SELECT id FROM '.$pun_db->prefix.'users WHERE username LIKE \''.$pun_db->escape($author).'\'') or error('Unable to fetch users', __FILE__, __LINE__, $pun_db->error()); - break; - } - - if ($pun_db->num_rows($result)) - { - $user_ids = ''; - while ($row = $pun_db->fetch_row($result)) - $user_ids .= (($user_ids != '') ? ',' : '').$row[0]; - - $result = $pun_db->query('SELECT id FROM '.$pun_db->prefix.'posts WHERE poster_id IN('.$user_ids.')') or error('Unable to fetch matched posts list', __FILE__, __LINE__, $pun_db->error()); - - $search_ids = array(); - while ($row = $pun_db->fetch_row($result)) - $author_results[] = $row[0]; - - $pun_db->free_result($result); - } - } - - - if ($author && $keywords) - { - // If we searched for both keywords and author name we want the intersection between the results - $search_ids = array_intersect($keyword_results, $author_results); - unset($keyword_results, $author_results); - } - else if ($keywords) - $search_ids = $keyword_results; - else - $search_ids = $author_results; - - $num_hits = count($search_ids); - if (!$num_hits) - message($lang_search['No hits']); - - - if ($show_as == 'topics') - { - $result = $pun_db->query('SELECT t.id FROM '.$pun_db->prefix.'posts AS p INNER JOIN '.$pun_db->prefix.'topics AS t ON t.id=p.topic_id INNER JOIN '.$pun_db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$pun_db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND p.id IN('.implode(',', $search_ids).')'.$forum_sql.' GROUP BY t.id', true) or error('Unable to fetch topic list', __FILE__, __LINE__, $pun_db->error()); - - $search_ids = array(); - while ($row = $pun_db->fetch_row($result)) - $search_ids[] = $row[0]; - - $pun_db->free_result($result); - - $num_hits = count($search_ids); - } - else - { - $result = $pun_db->query('SELECT p.id FROM '.$pun_db->prefix.'posts AS p INNER JOIN '.$pun_db->prefix.'topics AS t ON t.id=p.topic_id INNER JOIN '.$pun_db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$pun_db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND p.id IN('.implode(',', $search_ids).')'.$forum_sql, true) or error('Unable to fetch topic list', __FILE__, __LINE__, $pun_db->error()); - - $search_ids = array(); - while ($row = $pun_db->fetch_row($result)) - $search_ids[] = $row[0]; - - $pun_db->free_result($result); - - $num_hits = count($search_ids); - } - } - else if ($action == 'show_new' || $action == 'show_24h' || $action == 'show_user' || $action == 'show_subscriptions' || $action == 'show_unanswered') - { - // If it's a search for new posts - if ($action == 'show_new') - { - if ($pun_user['is_guest']) - message($lang_common['No permission']); - - $result = $pun_db->query('SELECT t.id FROM '.$pun_db->prefix.'topics AS t INNER JOIN '.$pun_db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$pun_db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.last_post>'.$pun_user['last_visit'].' AND t.moved_to IS NULL') or error('Unable to fetch topic list', __FILE__, __LINE__, $pun_db->error()); - $num_hits = $pun_db->num_rows($result); - - if (!$num_hits) - message($lang_search['No new posts']); - } - // If it's a search for todays posts - else if ($action == 'show_24h') - { - $result = $pun_db->query('SELECT t.id FROM '.$pun_db->prefix.'topics AS t INNER JOIN '.$pun_db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$pun_db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.last_post>'.(time() - 86400).' AND t.moved_to IS NULL') or error('Unable to fetch topic list', __FILE__, __LINE__, $pun_db->error()); - $num_hits = $pun_db->num_rows($result); - - if (!$num_hits) - message($lang_search['No recent posts']); - } - // If it's a search for posts by a specific user ID - else if ($action == 'show_user') - { - $result = $pun_db->query('SELECT t.id FROM '.$pun_db->prefix.'topics AS t INNER JOIN '.$pun_db->prefix.'posts AS p ON t.id=p.topic_id INNER JOIN '.$pun_db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$pun_db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND p.poster_id='.$user_id.' GROUP BY t.id') or error('Unable to fetch topic list', __FILE__, __LINE__, $pun_db->error()); - $num_hits = $pun_db->num_rows($result); - - if (!$num_hits) - message($lang_search['No user posts']); - } - // If it's a search for subscribed topics - else if ($action == 'show_subscriptions') - { - if ($pun_user['is_guest']) - message($lang_common['Bad request']); - - $result = $pun_db->query('SELECT t.id FROM '.$pun_db->prefix.'topics AS t INNER JOIN '.$pun_db->prefix.'subscriptions AS s ON (t.id=s.topic_id AND s.user_id='.$pun_user['id'].') INNER JOIN '.$pun_db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$pun_db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1)') or error('Unable to fetch topic list', __FILE__, __LINE__, $pun_db->error()); - $num_hits = $pun_db->num_rows($result); - - if (!$num_hits) - message($lang_search['No subscriptions']); - } - // If it's a search for unanswered posts - else - { - $result = $pun_db->query('SELECT t.id FROM '.$pun_db->prefix.'topics AS t INNER JOIN '.$pun_db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$pun_db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.num_replies=0 AND t.moved_to IS NULL') or error('Unable to fetch topic list', __FILE__, __LINE__, $pun_db->error()); - $num_hits = $pun_db->num_rows($result); - - if (!$num_hits) - message($lang_search['No unanswered']); - } - - // We want to sort things after last post - $sort_by = 4; - - $search_ids = array(); - while ($row = $pun_db->fetch_row($result)) - $search_ids[] = $row[0]; - - $pun_db->free_result($result); - - $show_as = 'topics'; - } - else - message($lang_common['Bad request']); - - - // Prune "old" search results - $old_searches = array(); - $result = $pun_db->query('SELECT ident FROM '.$pun_db->prefix.'online') or error('Unable to fetch online list', __FILE__, __LINE__, $pun_db->error()); - - if ($pun_db->num_rows($result)) - { - while ($row = $pun_db->fetch_row($result)) - $old_searches[] = '\''.$pun_db->escape($row[0]).'\''; - - $pun_db->query('DELETE FROM '.$pun_db->prefix.'search_cache WHERE ident NOT IN('.implode(',', $old_searches).')') or error('Unable to delete search results', __FILE__, __LINE__, $pun_db->error()); - } - - // Final search results - $search_results = implode(',', $search_ids); - - // Fill an array with our results and search properties - $temp['search_results'] = $search_results; - $temp['num_hits'] = $num_hits; - $temp['sort_by'] = $sort_by; - $temp['sort_dir'] = $sort_dir; - $temp['show_as'] = $show_as; - $temp = serialize($temp); - $search_id = mt_rand(1, 2147483647); - - $ident = ($pun_user['is_guest']) ? get_remote_address() : $pun_user['username']; - - $pun_db->query('INSERT INTO '.$pun_db->prefix.'search_cache (id, ident, search_data) VALUES('.$search_id.', \''.$pun_db->escape($ident).'\', \''.$pun_db->escape($temp).'\')') or error('Unable to insert search results', __FILE__, __LINE__, $pun_db->error()); - - if ($action != 'show_new' && $action != 'show_24h') - { - $pun_db->end_transaction(); - $pun_db->close(); - - // Redirect the user to the cached result page - header('Location: search.php?search_id='.$search_id); - exit; - } - } - - - // Fetch results to display - if ($search_results != '') - { - switch ($sort_by) - { - case 1: - $sort_by_sql = ($show_as == 'topics') ? 't.poster' : 'p.poster'; - break; - - case 2: - $sort_by_sql = 't.subject'; - break; - - case 3: - $sort_by_sql = 't.forum_id'; - break; - - case 4: - $sort_by_sql = 't.last_post'; - break; - - default: - $sort_by_sql = ($show_as == 'topics') ? 't.posted' : 'p.posted'; - break; - } - - if ($show_as == 'posts') - { - $substr_sql = ($db_type != 'sqlite') ? 'SUBSTRING' : 'SUBSTR'; - $sql = 'SELECT p.id AS pid, p.poster AS pposter, p.posted AS pposted, p.poster_id, '.$substr_sql.'(p.message, 1, 1000) AS message, t.id AS tid, t.poster, t.subject, t.last_post, t.last_post_id, t.last_poster, t.num_replies, t.forum_id FROM '.$pun_db->prefix.'posts AS p INNER JOIN '.$pun_db->prefix.'topics AS t ON t.id=p.topic_id WHERE p.id IN('.$search_results.') ORDER BY '.$sort_by_sql; - } - else - $sql = 'SELECT t.id AS tid, t.poster, t.subject, t.last_post, t.last_post_id, t.last_poster, t.num_replies, t.closed, t.forum_id FROM '.$pun_db->prefix.'topics AS t WHERE t.id IN('.$search_results.') ORDER BY '.$sort_by_sql; - - - // Determine the topic or post offset (based on $_GET['p']) - $per_page = ($show_as == 'posts') ? $pun_user['disp_posts'] : $pun_user['disp_topics']; - $num_pages = ceil($num_hits / $per_page); - - $p = (!isset($_GET['p']) || $_GET['p'] <= 1 || $_GET['p'] > $num_pages) ? 1 : $_GET['p']; - $start_from = $per_page * ($p - 1); - - // Generate paging links - $paging_links = $lang_common['Pages'].': '.pun_paginate($num_pages, $p, 'search.php?search_id='.$search_id); - - - $sql .= ' '.$sort_dir.' LIMIT '.$start_from.', '.$per_page; - - $result = $pun_db->query($sql) or error('Unable to fetch search results', __FILE__, __LINE__, $pun_db->error()); - - $search_set = array(); - while ($row = $pun_db->fetch_assoc($result)) - $search_set[] = $row; - - $pun_db->free_result($result); - - $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_search['Search results']; - require PUN_ROOT.'header.php'; - - -?> -
-
-

-
-
- - -
-

-
-
- - - - - - - - - - -query('SELECT id, forum_name FROM '.$pun_db->prefix.'forums') or error('Unable to fetch forum list', __FILE__, __LINE__, $pun_db->error()); - - $forum_list = array(); - while ($forum_list[] = $pun_db->fetch_row($result)) - ; - - // Finally, lets loop through the results and output them - for ($i = 0; $i < count($search_set); ++$i) - { - @reset($forum_list); - while (list(, $temp) = @each($forum_list)) - { - if ($temp[0] == $search_set[$i]['forum_id']) - $forum = ''.pun_htmlspecialchars($temp[1]).''; - } - - if ($pun_config['o_censoring'] == '1') - $search_set[$i]['subject'] = censor_words($search_set[$i]['subject']); - - - if ($show_as == 'posts') - { - $icon = '
'.$lang_common['Normal icon'].'
'."\n"; - $subject = ''.pun_htmlspecialchars($search_set[$i]['subject']).''; - - if (!$pun_user['is_guest'] && $search_set[$i]['last_post'] > $pun_user['last_visit']) - $icon = '
'.$lang_common['New icon'].'
'."\n"; - - - if ($pun_config['o_censoring'] == '1') - $search_set[$i]['message'] = censor_words($search_set[$i]['message']); - - $message = str_replace("\n", '
', pun_htmlspecialchars($search_set[$i]['message'])); - $pposter = pun_htmlspecialchars($search_set[$i]['pposter']); - - if ($search_set[$i]['poster_id'] > 1) - $pposter = ''.$pposter.''; - - if (pun_strlen($message) >= 1000) - $message .= ' …'; - - $vtpost1 = ($i == 0) ? ' vtp1' : ''; - - // Switch the background color for every message. - $bg_switch = ($bg_switch) ? $bg_switch = false : $bg_switch = true; - $vtbg = ($bg_switch) ? ' rowodd' : ' roweven'; - - -?> -
-

 »  » 

-
-
-
-
-
-
Replies:
-
-

-
-
-
-
-

-
-
-
-
-
-
-
'.$lang_common['Normal icon'].'
'."\n"; - - $icon_text = $lang_common['Normal icon']; - $item_status = ''; - $icon_type = 'icon'; - - - $subject = ''.pun_htmlspecialchars($search_set[$i]['subject']).''.$lang_common['by'].' '.pun_htmlspecialchars($search_set[$i]['poster']).''; - - if ($search_set[$i]['closed'] != '0') - { - $icon_text = $lang_common['Closed icon']; - $item_status = 'iclosed'; - } - - if (!$pun_user['is_guest'] && $search_set[$i]['last_post'] > $pun_user['last_visit']) - { - $icon_text .= ' '.$lang_common['New icon']; - $item_status .= ' inew'; - $icon_type = 'icon inew'; - $subject = ''.$subject.''; - $subject_new_posts = '[ '.$lang_common['New posts'].' ]'; - } - else - $subject_new_posts = null; - - $num_pages_topic = ceil(($search_set[$i]['num_replies'] + 1) / $pun_user['disp_posts']); - - if ($num_pages_topic > 1) - $subject_multipage = '[ '.pun_paginate($num_pages_topic, -1, 'viewtopic.php?id='.$search_set[$i]['tid']).' ]'; - else - $subject_multipage = null; - - // Should we show the "New posts" and/or the multipage links? - if (!empty($subject_new_posts) || !empty($subject_multipage)) - { - $subject .= '  '.(!empty($subject_new_posts) ? $subject_new_posts : ''); - $subject .= !empty($subject_multipage) ? ' '.$subject_multipage : ''; - } - -?> - > - - - - - -'."\n\t\t\t".'
-
-
-
- -
-
- 		'.format_time($search_set[$i]['last_post']).' '.$lang_common['by'].' '.pun_htmlspecialchars($search_set[$i]['last_poster']) ?>
'."\n\t\t".'
'."\n\t".'
'."\n".'
'."\n\n"; - -?> -
-
-

-
-
- -
-

-
- -
-
-