errorCode(404); $page = isset($_GET['page']) && is_numeric($_GET['page']) ? intval($_GET['page']) : 1; $searchquery = isset($_GET['searchq']) ? "%".$_GET['searchq']."%" : "%"; $threadcount = Database::singleton()->run( "SELECT COUNT(*) FROM forum_threads WHERE subforumid = :id AND NOT deleted AND (subject LIKE :query OR body LIKE :query)", [":id" => $subforumInfo->id, ":query" => $searchquery] ); $pages = ceil($threadcount->fetchColumn()/20); $offset = intval(($page - 1)*20); $threads = Database::singleton()->run( "SELECT * FROM forum_threads WHERE subforumid = :id AND NOT deleted AND (subject LIKE :query OR body LIKE :query) ORDER BY pinned DESC, bumpIndex DESC LIMIT 20 OFFSET $offset", [":id" => $subforumInfo->id, ":query" => $searchquery] ); Pagination::$page = $page; Pagination::$pages = $pages; Pagination::$url = '/forum?ID='.$subforumInfo->id.'&page='; Pagination::initialize(); $isSubforum = true; } else { $forums = Database::singleton()->run("SELECT * FROM forum_forums"); $isSubforum = false; } if($isSubforum) { $pageBuilder = new PageBuilder(["title" => Polygon::ReplaceVars($subforumInfo->name)." - ".SITE_CONFIG["site"]["name_secondary"]." Forum"]); $pageBuilder->addMetaTag("og:description", $subforumInfo->description); } else { $pageBuilder = new PageBuilder(["title" => SITE_CONFIG["site"]["name_secondary"]." Forum"]); $pageBuilder->addMetaTag("og:description", "Discourse with the community here!"); } $pageBuilder->buildHeader(); ?>
= $subforumInfo->minadminlevel){ ?> Create Post
fetch(\PDO::FETCH_OBJ)) { ?>
Subject Author Replies Last Post
pinned) { ?> subject)?>
author)?> id)?> bumpIndex)?>
id.'"> Create Post'?>
= $subforumInfo->minadminlevel){ ?> Create Post
fetch(\PDO::FETCH_OBJ)){ ?>
run( "SELECT * FROM forum_subforums WHERE forumid = :id ORDER BY displayposition ASC", [":id" => $forum->id] ); while ($subforum = $subforums->fetch(\PDO::FETCH_OBJ)) { $lastactive = Database::singleton()->run( "SELECT bumpIndex FROM forum_threads WHERE subforumid = :id AND NOT deleted ORDER BY bumpIndex DESC LIMIT 1", [":id" => $subforum->id] )->fetchColumn(); ?>
name)?> Threads Posts Last Post
name)?>
description)?>
id)?> id, true)?>
buildFooter(); ?>