示例#1
0
            $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&raquo;&nbsp;<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);
    }
}
示例#2
0
             $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');
     }
示例#3
0
文件: search.php 项目: knytrune/ABXD
         $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&raquo;&nbsp;<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 {