query('SELECT search_data FROM '.$db->prefix.'search_cache WHERE id='.$search_id.' AND ident=\''.$db->escape($ident).'\'') or error('Unable to fetch search results', __FILE__, __LINE__, $db->error()); if ($row = $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' && $pun_user['g_id'] >= PUN_GUEST)) ? ' 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 ($word !== 'or' && ($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 = $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 '.$db->prefix.'posts WHERE message '.$cur_word_like; else if ($search_in < 0) $sql = 'SELECT p.id FROM '.$db->prefix.'posts AS p INNER JOIN '.$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 '.$db->prefix.'posts AS p INNER JOIN '.$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 = $db->escape(str_replace('*', '%', $cur_word)); $sql = 'SELECT m.post_id FROM '.$db->prefix.'search_words AS w INNER JOIN '.$db->prefix.'search_matches AS m ON m.word_id = w.id WHERE w.word LIKE \''.$cur_word.'\''.$search_in_cond; } $result = $db->query($sql, true) or error('Unable to search for posts', __FILE__, __LINE__, $db->error()); $row = array(); while ($temp = $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; $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 = $db->query('SELECT id FROM '.$db->prefix.'users WHERE username ILIKE \''.$db->escape($author).'\'') or error('Unable to fetch users', __FILE__, __LINE__, $db->error()); break; default: $result = $db->query('SELECT id FROM '.$db->prefix.'users WHERE username LIKE \''.$db->escape($author).'\'') or error('Unable to fetch users', __FILE__, __LINE__, $db->error()); break; } if ($db->num_rows($result)) { $user_ids = ''; while ($row = $db->fetch_row($result)) $user_ids .= (($user_ids != '') ? ',' : '').$row[0]; $result = $db->query('SELECT id FROM '.$db->prefix.'posts WHERE poster_id IN('.$user_ids.')') or error('Unable to fetch matched posts list', __FILE__, __LINE__, $db->error()); $search_ids = array(); while ($row = $db->fetch_row($result)) $author_results[] = $row[0]; $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 = $db->query('SELECT t.id FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'topics AS t ON t.id=p.topic_id INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$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__, $db->error()); $search_ids = array(); while ($row = $db->fetch_row($result)) $search_ids[] = $row[0]; $db->free_result($result); $num_hits = count($search_ids); } else { $result = $db->query('SELECT p.id FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'topics AS t ON t.id=p.topic_id INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$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__, $db->error()); $search_ids = array(); while ($row = $db->fetch_row($result)) $search_ids[] = $row[0]; $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 = $db->query('SELECT t.id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$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__, $db->error()); $num_hits = $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 = $db->query('SELECT t.id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$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__, $db->error()); $num_hits = $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 = $db->query('SELECT t.id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'posts AS p ON t.id=p.topic_id INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$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__, $db->error()); $num_hits = $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 = $db->query('SELECT t.id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'subscriptions AS s ON (t.id=s.topic_id AND s.user_id='.$pun_user['id'].') INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$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__, $db->error()); $num_hits = $db->num_rows($result); if (!$num_hits) message($lang_search['No subscriptions']); } // If it's a search for unanswered posts else { $result = $db->query('SELECT t.id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$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__, $db->error()); $num_hits = $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 = $db->fetch_row($result)) $search_ids[] = $row[0]; $db->free_result($result); $show_as = 'topics'; } else message($lang_common['Bad request']); // Prune "old" search results $old_searches = array(); $result = $db->query('SELECT ident FROM '.$db->prefix.'online') or error('Unable to fetch online list', __FILE__, __LINE__, $db->error()); if ($db->num_rows($result)) { while ($row = $db->fetch_row($result)) $old_searches[] = '\''.$db->escape($row[0]).'\''; $db->query('DELETE FROM '.$db->prefix.'search_cache WHERE ident NOT IN('.implode(',', $old_searches).')') or error('Unable to delete search results', __FILE__, __LINE__, $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']; $db->query('INSERT INTO '.$db->prefix.'search_cache (id, ident, search_data) VALUES('.$search_id.', \''.$db->escape($ident).'\', \''.$db->escape($temp).'\')') or error('Unable to insert search results', __FILE__, __LINE__, $db->error()); if ($action != 'show_new' && $action != 'show_24h') { $db->end_transaction(); $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 '.$db->prefix.'posts AS p INNER JOIN '.$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 '.$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']) || !is_numeric($_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'].': '.paginate($num_pages, $p, 'search.php?search_id='.$search_id); $sql .= ' '.$sort_dir.' LIMIT '.$start_from.', '.$per_page; $result = $db->query($sql) or error('Unable to fetch search results', __FILE__, __LINE__, $db->error()); $search_set = array(); while ($row = $db->fetch_assoc($result)) $search_set[] = $row; $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 '.$db->prefix.'forums') or error('Unable to fetch forum list', __FILE__, __LINE__, $db->error()); $forum_list = array(); while ($forum_list[] = $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 = '[ '.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"; ?>