function thread_get()
{
global $DB;
$Search = new Search();
$offset = cmd(3, true) ? cmd(3, true) * 100 : 0;
$res = $Search->query(cmd(2), "thread", $offset);
$ids = array_keys($res['matches']);
$page = cmd(3, true) + 1;
$Query = new BoardQuery();
$List = new BoardList();
$List->type(LIST_THREAD_SEARCH);
$List->title("Search Threads: " . htmlentities(cmd(2)));
$List->subtitle(number_format($res['total']) . " results found showing " . ($offset ? $offset : 1) . "-" . ($offset + 100) . SPACE . ARROW_RIGHT . SPACE . "page: {$page}");
$List->header(false);
require_once DIR . "module/search/.content/main.php";
$List->header_menu();
if ($res['total'] == 0 || $offset > $res['total']) {
$ids = array(0);
}
$DB->query($Query->list_thread(false, false, false, $ids));
$List->data($DB->load_all());
$List->thread();
$List->footer();
}
function listfavoritesbymember_get()
{
global $DB, $Core;
// get info
$id = $Core->idfromname(id());
$name = $Core->namefromid($id);
$page = cmd(3, true) + 1;
// get threads participiated in
$DB->query("SELECT\r\n f.thread_id\r\n FROM\r\n favorite f\r\n LEFT JOIN\r\n thread t\r\n ON\r\n t.id = f.thread_id\r\n WHERE\r\n f.member_id=\$1\r\n ORDER BY\r\n t.date_last_posted DESC", array($id));
$threads = $DB->load_all('thread_id');
if (!$id || !$name) {
return to_index();
}
$Query = new BoardQuery();
$List = new BoardList();
$List->type(LIST_THREAD_HISTORY);
$List->title("Favorites: {$name}");
$List->subtitle("page: {$page}");
$List->header();
$DB->query($Query->list_thread(false, cmd(3, true), cmd(4, true), $threads));
$List->data($DB->load_all());
$List->thread();
$List->footer();
}
function listignoredthreadsbymember_get()
{
global $DB, $Core;
// get info
$id = $Core->idfromname(id());
$name = $Core->namefromid($id);
$page = cmd(3, true) + 1;
if (!$id || !$name) {
return to_index();
}
if (!IGNORED_THREADS_PUBLIC && $id != session('id')) {
return to_index();
}
// get threads participiated in
$DB->query("SELECT\n tm.thread_id\n FROM\n thread_member tm\n LEFT JOIN\n thread t\n ON\n t.id = tm.thread_id\n WHERE\n tm.member_id=\$1 AND tm.ignore=true\n ORDER BY\n t.date_last_posted DESC", array($id));
$threads = $DB->load_all('thread_id');
if (!$threads) {
$threads = array(0);
}
$Query = new BoardQuery();
$List = new BoardList();
$List->type(LIST_THREAD_HISTORY);
$List->title("Ignored threads: {$name}");
$List->subtitle("page: {$page}");
$List->header();
$DB->query($Query->list_thread(false, cmd(3, true), cmd(4, true), $threads, false, false));
$List->data($DB->load_all());
$List->thread();
$List->footer();
}
