$snippet = MakeSnippet(htmlspecialchars($result['title']), $terms, true); if ($snippet != "") { $results .= Format("\n\t<tr class=\"cell0\">\n\t\t<td class=\"smallFonts\">\n\t\t\t{2}\n\t\t</td>\n\t\t<td>\n\t\t\t<a href=\"./?tid={1}\">{0}</a>\n\t\t</td>\n\t</tr>\n", $snippet, $result['id'], UserLink($result, "user"), $tags); } } if ($results != "") { $final .= Format("\n<table class=\"outline margin\">\n\t<tr class=\"header0\">\n\t\t<th colspan=\"4\">Thread title results</th>\n\t</tr>\n\t<tr class=\"header1\">\n\t\t<th>User</th>\n\t\t<th>Thread</th>\n\t</tr>\n\t{0}\n</table>\n", $results); $totalResults += NumRows($search); } } $search = Query("SELECT `text`, `pid`, `threads`.`title`, `thread`, `posts`.`user`, `name`, `displayname`, `sex`, `powerlevel` FROM `posts_text` LEFT JOIN `posts` ON `posts_text`.`pid`=`posts`.`id` LEFT JOIN `threads` ON `threads`.`id`=`posts`.`thread` LEFT JOIN `users` ON `users`.`id`=`posts`.`user` WHERE `posts_text`.`revision`=`posts`.`currentrevision` AND MATCH(`text`) AGAINST('" . $bool . "' IN BOOLEAN MODE) ORDER BY `posts`.`date` DESC LIMIT 0,100"); if (NumRows($search)) { $results = ""; while ($result = Fetch($search)) { $result['text'] = str_replace("<!--", "~#~", str_replace("-->", "~#~", $result['text'])); $snippet = MakeSnippet(htmlspecialchars($result['text']), $terms); if ($snippet != "") { $results .= Format("\n\t<tr class=\"cell0\">\n\t\t<td class=\"smallFonts\">\n\t\t\t{3}\n\t\t</td>\n\t\t<td>\n\t\t\t{0}\n\t\t</td>\n\t\t<td class=\"smallFonts\">\n\t\t\t<a href=\"./?tid={4}\">{2}</a>\n\t\t</td>\n\t\t<td class=\"smallFonts\">\n\t\t\t» <a href=\"./?pid={1}\">{1}</a>\n\t\t</td>\n\t</tr>\n", $snippet, $result['pid'], $result['title'], UserLink($result, "user"), $result['thread']); } } if ($results != "") { $final .= Format("\n<table class=\"outline margin\">\n\t<tr class=\"header0\">\n\t\t<th colspan=\"4\">Text results</th>\n\t</tr>\n\t<tr class=\"header1\">\n\t\t<th>User</th>\n\t\t<th>Text</th>\n\t\t<th>Thread</th>\n\t\t<th>ID</th>\n\t</tr>\n\t{0}\n</table>\n", $results); $totalResults += NumRows($search); } } if ($totalResults == 0) { Alert(Format("No results for \"{0}\".", htmlspecialchars($_GET['q'])), "Search"); } else { Write("\n<div class=\"outline header2 cell2 margin\" style=\"text-align: center; font-size: 130%;\">\n\t{0}\n</div>\n{1}\n", Plural($totalResults, "result"), $final); } }
$r['description'] = ''; $r['user'] = UserLink(getDataPrefix($result, "u_")); $r['formattedDate'] = formatdate($result['lastpostdate']); $rdata[] = $r; } } } else { $nres = FetchResult("\n\t\t\tSELECT COUNT(*)\n\t\t\tFROM {posts_text} pt\n\t\t\t\tLEFT JOIN {posts} p ON pt.pid = p.id\n\t\t\t\tLEFT JOIN {threads} t ON t.id = p.thread\n\t\t\tWHERE pt.pid IN ({0c}) AND t.forum IN ({1c}) AND pt.revision = p.currentrevision", $results, $viewableforums); $search = Query("\n\t\t\tSELECT\n\t\t\t\tpt.text, pt.pid,\n\t\t\t\tp.date,\n\t\t\t\tt.title, t.id,\n\t\t\t\tu.(_userfields)\n\t\t\tFROM {posts_text} pt\n\t\t\t\tLEFT JOIN {posts} p ON pt.pid = p.id\n\t\t\t\tLEFT JOIN {threads} t ON t.id = p.thread\n\t\t\t\tLEFT JOIN {users} u ON u.id = p.user\n\t\t\tWHERE pt.pid IN ({0c}) AND t.forum IN ({1c}) AND pt.revision = p.currentrevision\n\t\t\tORDER BY p.date DESC\n\t\t\tLIMIT {2u},{3u}", $results, $viewableforums, $from, $tpp); if (NumRows($search)) { $results = ""; while ($result = Fetch($search)) { $r = array(); $tags = ParseThreadTags($result['title']); // $result['text'] = str_replace("<!--", "~#~", str_replace("-->", "~#~", $result['text'])); $r['description'] = MakeSnippet($result['text'], $terms); $r['user'] = UserLink(getDataPrefix($result, "u_")); $r['link'] = actionLinkTag($tags[0], "post", $result['pid']); $r['formattedDate'] = formatdate($result['date']); $rdata[] = $r; } } } if ($nres == 0) { $restext = __('No results found'); } else { if ($nres == 1) { $restext = __('1 result found'); } else { $restext = $nres . __(' results found'); }
$threadlink = makeThreadLink($result); if ($snippet != "") { $totalResults++; $results .= "\n\t<tr class=\"cell0\">\n\t\t<td class=\"smallFonts\">\n\t\t\t{$userlink}\n\t\t</td>\n\t\t<td>\n\t\t\t{$threadlink}\n\t\t</td>\n\t</tr>"; } } if ($results != "") { $final .= "\n<table class=\"outline margin\">\n\t<tr class=\"header0\">\n\t\t<th colspan=\"4\">Thread title results</th>\n\t</tr>\n\t<tr class=\"header1\">\n\t\t<th style=\"width:15%\">User</th>\n\t\t<th>Thread</th>\n\t</tr>\n\t{$results}\n</table>"; } } $search = Query("\n\t\tSELECT\n\t\t\tpt.text, pt.pid,\n\t\t\tt.title, t.id,\n\t\t\tu.(_userfields)\n\t\tFROM {posts_text} pt\n\t\t\tLEFT JOIN {posts} p ON pt.pid = p.id\n\t\t\tLEFT JOIN {threads} t ON t.id = p.thread\n\t\t\tLEFT JOIN {users} u ON u.id = p.user\n\t\tWHERE pt.revision = p.currentrevision AND MATCH(pt.text) AGAINST({0} IN BOOLEAN MODE)\n\t\tORDER BY p.date DESC\n\t\tLIMIT 0,100", $bool); if (NumRows($search)) { $results = ""; while ($result = Fetch($search)) { // $result['text'] = str_replace("<!--", "~#~", str_replace("-->", "~#~", $result['text'])); $snippet = MakeSnippet($result['text'], $terms); $userlink = UserLink(getDataPrefix($result, "u_")); $threadlink = makeThreadLink($result); $posturl = actionLink("thread", "", "pid=" . $result['pid'] . "#" . $result['pid']); if ($snippet != "") { $totalResults++; $results .= "\n\t<tr class=\"cell0\">\n\t\t<td class=\"smallFonts\">\n\t\t\t{$userlink}\n\t\t</td>\n\t\t<td>\n\t\t\t{$snippet}\n\t\t</td>\n\t\t<td class=\"smallFonts\">\n\t\t\t{$threadlink}\n\t\t</td>\n\t\t<td class=\"smallFonts\">\n\t\t\t» <a href=\"{$posturl}\">{$result['pid']}</a>\n\t\t</td>\n\t</tr>"; } } if ($results != "") { $final .= "\n<table class=\"outline margin\">\n\t<tr class=\"header0\">\n\t\t<th colspan=\"4\">Text results</th>\n\t</tr>\n\t<tr class=\"header1\">\n\t\t<th>User</th>\n\t\t<th>Text</th>\n\t\t<th>Thread</th>\n\t\t<th>ID</th>\n\t</tr>\n\t{$results}\n</table>"; } } if ($totalResults == 0) { Alert(Format("No results for \"{0}\".", htmlspecialchars($searchQuery)), "Search"); } else {