class.ilWikiPage.php

Go to the documentation of this file.

<?php
 
class ilWikiPage extends ilPageObject
{
    protected \ILIAS\Wiki\Page\PageDBRepository $repo;
    protected ilLogger $wiki_log;
    protected \ILIAS\Wiki\InternalService $service;
    protected int $parent_ref_id = 0;
    protected string $title = "";
    protected bool $blocked = false;
    protected bool $rating = false;
    protected bool $hide_adv_md = false;
 
    public function getParentType(): string
    {
        return "wpg";
    }
 
    public function afterConstructor(): void
    {
        global $DIC;
        $this->service = $DIC->wiki()->internal();
        $this->getPageConfig()->configureByObjectId($this->getParentId());
        $this->wiki_log = $this->service->domain()->log();
        $this->repo = $this->service->repo()->page();
    }
 
    protected function getNotificationGUI(): \ILIAS\Wiki\Notification\NotificationGUI
    {
        return $this->service->gui()->notification();
    }
 
    public function setTitle(string $a_title): void
    {
        $this->title = ilWikiUtil::makeDbTitle($a_title);
    }
 
    public function getTitle(): string
    {
        return $this->title;
    }
 
    public function setWikiId(int $a_wikiid): void
    {
        $this->setParentId($a_wikiid);
    }
 
    public function getWikiId(): int
    {
        return $this->getParentId();
    }
 
    public function setWikiRefId(int $a_wiki_ref_id): void
    {
        $this->parent_ref_id = $a_wiki_ref_id;
    }
 
    public function getWikiRefId(): int
    {
        return $this->parent_ref_id;
    }
 
    public function setBlocked(bool $a_val): void
    {
        $this->blocked = $a_val;
    }
 
    public function getBlocked(): bool
    {
        return $this->blocked;
    }
 
    public function setRating(bool $a_val): void
    {
        $this->rating = $a_val;
    }
 
    public function getRating(): bool
    {
        return $this->rating;
    }
 
    public function hideAdvancedMetadata(bool $a_val): void
    {
        $this->hide_adv_md = $a_val;
    }
 
    public function isAdvancedMetadataHidden(): bool
    {
        return $this->hide_adv_md;
    }
 
    public function createFromXML(): void
    {
        $ilDB = $this->db;
 
        // ilWikiDataset creates wiki pages without copage objects
        // (see create function in this class, parameter $a_prevent_page_creation)
        // The ilCOPageImporter will call createFromXML without running through the read
        // method -> we will miss the important wiki id, thus we read it now
        // see also bug #12224
        $set = $ilDB->query(
            "SELECT id FROM il_wiki_page " .
            " WHERE id = " . $ilDB->quote($this->getId(), "integer") .
            " AND lang = " . $ilDB->quote($this->getLanguage(), "text")
        );
        if ($rec = $ilDB->fetchAssoc($set)) {
            $this->read(true);
        }
 
        parent::createFromXML();
    }
 
    public function create(
        bool $a_import = false
    ): void {
        $ilDB = $this->db;
 
        // get new id, if not a translation page
        if (in_array($this->getLanguage(), ["-", ""]) && $this->getId() == 0) {
            $id = $ilDB->nextId("il_wiki_page");
            $this->setId($id);
        }
 
        $query = "INSERT INTO il_wiki_page (" .
            "id" .
            ", title" .
            ", wiki_id" .
            ", blocked" .
            ", rating" .
            ", hide_adv_md" .
            ", lang" .
            " ) VALUES (" .
            $ilDB->quote($this->getId(), "integer")
            . "," . $ilDB->quote($this->getTitle(), "text")
            . "," . $ilDB->quote($this->getWikiId(), "integer")
            . "," . $ilDB->quote((int) $this->getBlocked(), "integer")
            . "," . $ilDB->quote((int) $this->getRating(), "integer")
            . "," . $ilDB->quote((int) $this->isAdvancedMetadataHidden(), "integer")
            . "," . $ilDB->quote($this->getLanguage(), "text")
            . ")";
        $this->wiki_log->debug($query);
        $ilDB->manipulate($query);
 
        // create page object
        if (!$a_import) {
            parent::create($a_import);
            $this->saveInternalLinks($this->getDomDoc());
 
            ilWikiStat::handleEvent(ilWikiStat::EVENT_PAGE_CREATED, $this);
            $this->getNotificationGUI()->send(
                "new",
                ilNotification::TYPE_WIKI,
                $this->getWikiRefId(),
                $this->getId(),
                null,
                $this->getLanguage()
            );
        }
 
        $this->updateNews();
    }
 
    public function afterUpdate(
        DOMDocument $domdoc,
        string $xml
    ): void {
        // internal == wiki links
 
        $this->wiki_log->debug("collect internal links");
        $int_links = count(ilWikiUtil::collectInternalLinks($xml, $this->getWikiId(), true));
 
        $xpath = new DOMXPath($domdoc);
 
        // external = internal + external links
        $ext_links = count($xpath->query('//IntLink'));
        $ext_links += count($xpath->query('//ExtLink'));
 
        $footnotes = count($xpath->query('//Footnote'));
 
 
        // words/characters (xml)
 
        $xml = strip_tags($xml);
 
        $num_chars = ilStr::strLen($xml);
        $num_words = count(explode(" ", $xml));
 
        $page_data = array(
            "int_links" => $int_links,
            "ext_links" => $ext_links,
            "footnotes" => $footnotes,
            "num_words" => $num_words,
            "num_chars" => $num_chars
        );
        $this->wiki_log->debug("handle stats");
        ilWikiStat::handleEvent(ilWikiStat::EVENT_PAGE_UPDATED, $this, null, $page_data);
    }
 
    public function update(
        bool $a_validate = true,
        bool $a_no_history = false
    ) {
        $ilDB = $this->db;
        $this->wiki_log->debug("start...");
        // update wiki page data
        $query = "UPDATE il_wiki_page SET " .
            " title = " . $ilDB->quote($this->getTitle(), "text") .
            ",wiki_id = " . $ilDB->quote($this->getWikiId(), "integer") .
            ",blocked = " . $ilDB->quote((int) $this->getBlocked(), "integer") .
            ",rating = " . $ilDB->quote((int) $this->getRating(), "integer") .
            ",hide_adv_md = " . $ilDB->quote((int) $this->isAdvancedMetadataHidden(), "integer") .
            " WHERE id = " . $ilDB->quote($this->getId(), "integer") .
            " AND lang = " . $ilDB->quote($this->getLanguage(), "text");
        $ilDB->manipulate($query);
        $updated = parent::update($a_validate, $a_no_history);
        if ($updated === true) {
            $this->wiki_log->debug("send notification");
            $this->getNotificationGUI()->send(
                "update",
                ilNotification::TYPE_WIKI_PAGE,
                $this->getWikiRefId(),
                $this->getId(),
                null,
                $this->getLanguage()
            );
 
            $this->wiki_log->debug("update news");
            ilObjectSearch::raiseContentChanged($this->getWikiId());
            $this->updateNews(true);
        } else {
            return $updated;
        }
 
        return true;
    }
 
    public function read(
        bool $a_omit_page_read = false
    ): void {
        $ilDB = $this->db;
 
        $query = "SELECT * FROM il_wiki_page WHERE id = " .
            $ilDB->quote($this->getId(), "integer") .
            " AND lang = " . $ilDB->quote($this->getLanguage(), "text");
 
        $set = $ilDB->query($query);
        $rec = $ilDB->fetchAssoc($set);
 
        $this->setTitle($rec["title"]);
        $this->setWikiId((int) $rec["wiki_id"]);
        $this->setBlocked((bool) $rec["blocked"]);
        $this->setRating((bool) $rec["rating"]);
        $this->hideAdvancedMetadata((bool) $rec["hide_adv_md"]);
 
        // get co page
        if (!$a_omit_page_read) {
            parent::read();
        }
    }
 
 
    public function delete(): void
    {
        $imp_pages = $this->service->domain()->importantPage($this->getWikiRefId());
 
        $ilDB = $this->db;
 
        // get other pages that link to this page
        $linking_pages = self::getLinksToPage(
            $this->getWikiId(),
            $this->getId()
        );
 
        // delete important page
        // note: the wiki might be already deleted here
        if (!$this->isTranslationPage()) {
            if ($imp_pages->isImportantPage($this->getId())) {
                $imp_pages->removeImportantPage($this->getId());
            }
        }
 
        // delete internal links information to this page
        ilInternalLink::_deleteAllLinksToTarget("wpg", $this->getId());
 
        ilWikiStat::handleEvent(ilWikiStat::EVENT_PAGE_DELETED, $this);
 
        $this->getNotificationGUI()->send(
            "delete",
            ilNotification::TYPE_WIKI_PAGE,
            $this->getWikiRefId(),
            $this->getId(),
            null,
            $this->getLanguage()
        );
 
        // remove all notifications
        ilNotification::removeForObject(ilNotification::TYPE_WIKI_PAGE, $this->getId());
 
        // delete record of table il_wiki_data
        $this->repo->delete($this->getId(), $this->getLanguage());
 
        // delete co page
        parent::delete();
 
        // make links of other pages to this page a missing link
        $missing_page_repo = $this->service->repo()->missingPage();
        foreach ($linking_pages as $lp) {
            $missing_page_repo->save(
                $this->getWikiId(),
                $lp["id"],
                $this->getTitle(),
                $this->getLanguage()
            );
        }
    }
 
    public static function deleteAllPagesOfWiki(int $a_wiki_id): void
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        // delete record of table il_wiki_data
        $query = "SELECT * FROM il_wiki_page" .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer");
        $set = $ilDB->query($query);
 
        while ($rec = $ilDB->fetchAssoc($set)) {
            $wiki_page = new ilWikiPage($rec["id"], 0, $rec["lang"]);
            $wiki_page->delete();
        }
    }
 
    public static function exists(
        int $a_wiki_id,
        string $a_title,
        string $lang = "-"
    ): bool {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $a_title = ilWikiUtil::makeDbTitle($a_title);
 
        $query = "SELECT id FROM il_wiki_page" .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " AND title = " . $ilDB->quote($a_title, "text") .
            " AND lang = " . $ilDB->quote($lang, "text");
        $set = $ilDB->query($query);
        if ($rec = $ilDB->fetchAssoc($set)) {
            return true;
        }
 
        return false;
    }
 
 
    public static function getPageIdForTitle(
        int $a_wiki_id,
        string $a_title,
        string $lang = "-"
    ): ?int {
        global $DIC;
 
        if ($lang === "") {
            $lang = "-";
        }
 
        $ilDB = $DIC->database();
 
        $a_title = ilWikiUtil::makeDbTitle($a_title);
 
        $query = "SELECT * FROM il_wiki_page" .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " AND title = " . $ilDB->quote($a_title, "text") .
            " AND lang = " . $ilDB->quote($lang, "text");
        $set = $ilDB->query($query);
        if ($rec = $ilDB->fetchAssoc($set)) {
            return (int) $rec["id"];
        }
 
        return null;
    }
 
    public static function lookupTitle(int $a_page_id, string $lang = "-"): ?string
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = "SELECT * FROM il_wiki_page" .
            " WHERE id = " . $ilDB->quote($a_page_id, "integer") .
            " AND lang = " . $ilDB->quote($lang, "text");
        $set = $ilDB->query($query);
        if ($rec = $ilDB->fetchAssoc($set)) {
            return (string) $rec["title"];
        }
        return null;
    }
 
    public static function lookupWikiId(
        int $a_page_id
    ): ?int {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = "SELECT wiki_id FROM il_wiki_page" .
            " WHERE id = " . $ilDB->quote($a_page_id, "integer");
        $set = $ilDB->query($query);
        if ($rec = $ilDB->fetchAssoc($set)) {
            return (int) $rec["wiki_id"];
        }
 
        return null;
    }
 
    public static function getAllWikiPages(
        int $a_wiki_id,
        string $lang = "-"
    ): array {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $pages = parent::getAllPages("wpg", $a_wiki_id);
 
        $query = "SELECT * FROM il_wiki_page" .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " AND lang = " . $ilDB->quote($lang, "text") .
            " ORDER BY title";
        $set = $ilDB->query($query);
 
        $pg = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            if (isset($pages[$rec["id"]])) {
                $pg[$rec["id"]] = $pages[$rec["id"]];
                $pg[$rec["id"]]["title"] = $rec["title"];
            }
        }
 
        return $pg;
    }
 
    public static function getLinksToPage(
        int $a_wiki_id,
        int $a_page_id,
        string $lang = "-"
    ): array {
        global $DIC;
 
        if ($lang === "") {
            $lang = "-";
        }
        $ilDB = $DIC->database();
 
        $sources = ilInternalLink::_getSourcesOfTarget("wpg", $a_page_id, 0);
        $ids = array();
        foreach ($sources as $source) {
            if ($source["type"] === "wpg:pg" && $source["lang"] === $lang) {
                $ids[] = $source["id"];
            }
        }
 
        // get wiki page record
        $query = "SELECT * FROM il_wiki_page wp, page_object p" .
            " WHERE " . $ilDB->in("wp.id", $ids, false, "integer") .
            " AND wp.id = p.page_id AND wp.lang = p.lang AND p.parent_type = " . $ilDB->quote("wpg", "text") .
            " AND wp.wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " AND wp.lang = " . $ilDB->quote($lang, "text") .
            " ORDER BY title";
        $set = $ilDB->query($query);
 
        $pages = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $pages[] = array_merge($rec, array("user" => $rec["last_change_user"],
                "date" => $rec["last_change"]));
        }
        return $pages;
    }
 
    public static function _wikiPageExists(
        int $a_wiki_id,
        string $a_title,
        string $lang = "-"
    ): bool {
        global $DIC;
 
        if ($lang === "") {
            $lang = "-";
        }
 
        $ilDB = $DIC->database();
 
        $a_title = ilWikiUtil::makeDbTitle($a_title);
 
        $query = "SELECT id FROM il_wiki_page" .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " AND title = " . $ilDB->quote($a_title, "text") .
            " AND lang = " . $ilDB->quote($lang, "text");
        $set = $ilDB->query($query);
 
        if ($ilDB->fetchAssoc($set)) {
            return true;
        }
 
        return false;
    }
 
    public static function getWikiContributors(
        int $a_wiki_id
    ): array {
        return parent::getParentObjectContributors("wpg", $a_wiki_id);
    }
 
    public static function getWikiPageContributors(
        int $a_page_id
    ): array {
        return parent::getPageContributors("wpg", $a_page_id);
    }
 
    public function saveInternalLinks(
        DOMDocument $a_domdoc
    ): void {
        parent::saveInternalLinks($a_domdoc);
 
        if ($this->getWikiRefId() > 0) {
            $link_manager = $this->service->domain()->links($this->getWikiRefId());
            $link_manager->saveInternalLinksForPage(
                $a_domdoc,
                $this->getId(),
                $this->getTitle(),
                $this->getLanguage()
            );
        }
    }
 
    public static function _getPageIdForWikiTitle(
        int $a_wiki_id,
        string $a_title
    ): ?int {
        return self::getPageIdForTitle($a_wiki_id, $a_title);
    }
 
    public static function getPopularPages(
        int $a_wiki_id
    ): array {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = "SELECT wp.*, po.view_cnt as cnt FROM il_wiki_page wp, page_object po" .
            " WHERE wp.wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " AND wp.id = po.page_id " .
            " AND po.parent_type = " . $ilDB->quote("wpg", "text") . " " .
            " ORDER BY po.view_cnt";
        $set = $ilDB->query($query);
 
        $pages = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $pages[] = $rec;
        }
 
        return $pages;
    }
 
    public static function countPages(
        int $a_wiki_id
    ): int {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        // delete record of table il_wiki_data
        $query = "SELECT count(*) as cnt FROM il_wiki_page" .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " WHERE lang = " . $ilDB->quote("-", "text");
        $s = $ilDB->query($query);
        $r = $ilDB->fetchAssoc($s);
 
        return $r["cnt"];
    }
 
    public static function getRandomPage(
        int $a_wiki_id
    ): string {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $cnt = self::countPages($a_wiki_id);
 
        if ($cnt < 1) {
            return "";
        }
 
        $random = new \Random\Randomizer();
        $rand = $random->getInt(1, $cnt);
 
        $ilDB->setLimit(1, $rand);
        $query = "SELECT title FROM il_wiki_page" .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer");
        $s = $ilDB->query($query);
        $r = $ilDB->fetchAssoc($s);
 
        return $r["title"];
    }
 
    public static function getNewWikiPages(
        int $a_wiki_id
    ): array {
        $pages = parent::getNewPages("wpg", $a_wiki_id);
        foreach ($pages as $k => $page) {
            $pages[$k]["title"] = self::lookupTitle($page["id"]);
        }
 
        return $pages;
    }
 
 
    public static function lookupObjIdByPage(
        int $a_page_id
    ): ?int {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = "SELECT wiki_id FROM il_wiki_page" .
            " WHERE id = " . $ilDB->quote($a_page_id, "integer");
        $set = $ilDB->query($query);
        if ($rec = $ilDB->fetchAssoc($set)) {
            return (int) $rec["wiki_id"];
        }
 
        return null;
    }
 
    public function rename(
        string $a_new_name
    ): string {
        $ilDB = $this->db;
 
        // replace unallowed characters
        $a_new_name = str_replace(array("<", ">"), '', $a_new_name);
 
        // replace multiple whitespace characters by one single space
        $a_new_name = trim(preg_replace('!\s+!', ' ', $a_new_name));
 
        $page_title = ilWikiUtil::makeDbTitle($a_new_name);
        $pg_id = self::getPageIdForTitle($this->getWikiId(), $page_title, $this->getLanguage());
 
        $xml_new_name = str_replace("&", "&amp;", $a_new_name);
 
        if ($pg_id == 0 || $pg_id == $this->getId()) {
            $sources = ilInternalLink::_getSourcesOfTarget("wpg", $this->getId(), 0);
 
            $this->log->debug("nr of pages linking to renamed page: " . count($sources));
            foreach ($sources as $s) {
                if ($s["type"] === "wpg:pg" && ilPageObject::_exists("wpg", $s["id"])) {
                    $wpage = new ilWikiPage($s["id"], 0, $s["lang"]);
                    $wpage->setWikiRefId($this->getWikiRefId());
 
                    $wiki_id = ilWikiPage::lookupWikiId($s["id"]);
                    $col = ilWikiUtil::collectInternalLinks(
                        $wpage->getXMLContent(),
                        $wiki_id,
                        false,
                        IL_WIKI_MODE_EXT_COLLECT
                    );
                    $this->log->debug("nr internal links: " . count($col));
                    $new_content = $wpage->getXMLContent();
                    foreach ($col as $c) {
                        // this complicated procedure is needed due to the fact
                        // that depending on the collation e = é is true
                        // in the (mysql) database
                        // see bug http://www.ilias.de/mantis/view.php?id=11227
                        $t1 = ilWikiUtil::makeDbTitle($c["nt"]->mTextform);
                        $t2 = ilWikiUtil::makeDbTitle($this->getTitle());
 
                        // this one replaces C2A0 (&nbsp;) by a usual space
                        // otherwise the comparision will fail, since you
                        // get these characters from tiny if more than one
                        // space is repeated in a string. This may not be
                        // 100% but we do not store $t1 anywhere and only
                        // modify it for the comparison
                        $t1 = preg_replace('/\xC2\xA0/', ' ', $t1);
                        $t2 = preg_replace('/\xC2\xA0/', ' ', $t2);
 
                        $set = $ilDB->query($q = "SELECT " . $ilDB->quote($t1, "text") . " = " . $ilDB->quote($t2, "text") . " isequal");
                        $rec = $ilDB->fetchAssoc($set);
 
                        if ($rec["isequal"]) {
                            $new_content =
                                str_replace(
                                    "[[" . $c["nt"]->mTextform . "]]",
                                    "[[" . $xml_new_name . "]]",
                                    $new_content
                                );
                            if ($c["text"] != "") {
                                $new_content =
                                    str_replace(
                                        "[[" . $c["text"] . "]]",
                                        "[[" . $xml_new_name . "]]",
                                        $new_content
                                    );
                            }
                            $add = ($c["text"] != "")
                                ? "|" . $c["text"]
                                : "";
                            $new_content =
                                str_replace(
                                    "[[" . $c["nt"]->mTextform . $add . "]]",
                                    "[[" . $xml_new_name . $add . "]]",
                                    $new_content
                                );
                        }
                    }
                    $wpage->setXMLContent($new_content);
                    //echo htmlentities($new_content);
                    $wpage->update();
                }
            }
 
            if (ilObjWiki::_lookupStartPage($this->getWikiId()) === $this->getTitle()) {
                ilObjWiki::writeStartPage($this->getWikiId(), $a_new_name);
            }
 
            $this->setTitle($a_new_name);
 
            $this->update();
        }
 
        return $a_new_name;
    }
 
 
    public function updateNews(
        bool $a_update = false
    ): void {
        $ilUser = $this->user;
 
        $news_set = new ilSetting("news");
        $default_visibility = ($news_set->get("default_visibility") != "")
                ? $news_set->get("default_visibility")
                : "users";
 
        if (!$a_update) {
            $news_item = new ilNewsItem();
            $news_item->setContext(
                $this->getWikiId(),
                "wiki",
                $this->getId(),
                "wpg"
            );
            $news_item->setPriority(NEWS_NOTICE);
            $news_item->setTitle($this->getTitle());
            $news_item->setContentTextIsLangVar(true);
            $news_item->setContent("wiki_news_page_created");
            $news_item->setUserId($ilUser->getId());
            $news_item->setVisibility($default_visibility);
            $news_item->create();
        } else {
            // get last news item of the day (if existing)
            $news_id = ilNewsItem::getLastNewsIdForContext(
                $this->getWikiId(),
                "wiki",
                $this->getId(),
                "wpg",
                true
            );
 
            if ($news_id > 0) {
                $news_item = new ilNewsItem($news_id);
                $news_item->setContent("wiki_news_page_changed");
                $news_item->setUserId($ilUser->getId());
                $news_item->setTitle($this->getTitle());
                $news_item->setContentTextIsLangVar(true);
                $news_item->update(true);
            } else {
                $news_item = new ilNewsItem();
                $news_item->setContext(
                    $this->getWikiId(),
                    "wiki",
                    $this->getId(),
                    "wpg"
                );
                $news_item->setPriority(NEWS_NOTICE);
                $news_item->setTitle($this->getTitle());
                $news_item->setContentTextIsLangVar(true);
                $news_item->setContent("wiki_news_page_changed");
                $news_item->setUserId($ilUser->getId());
                $news_item->setVisibility($default_visibility);
                $news_item->create();
            }
        }
    }
 
    public static function getGotoForWikiPageTarget(
        string $a_target,
        bool $a_offline = false
    ): string {
        if (!$a_offline) {
            $href = "./goto.php?target=wiki_wpage_" . $a_target;
        } else {
            $href = ILIAS_HTTP_PATH . "/goto.php?target=wiki_wpage_" . $a_target;
        }
        return $href;
    }
 
 
    public function getContentTemplates(): array
    {
        $wt = new ilWikiPageTemplate($this->getWikiId());
        $templates = array();
        foreach ($wt->getAllInfo(ilWikiPageTemplate::TYPE_ADD_TO_PAGE, $this->getLanguage()) as $t) {
            $templates[] = array("id" => $t["wpage_id"], "parent_type" => "wpg", "title" => $t["title"]);
        }
        return $templates;
    }
 
    public static function getPagesForSearch(
        int $a_wiki_id,
        string $a_term
    ): array {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $set = $ilDB->query("SELECT DISTINCT title FROM il_wiki_page" .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " AND " . $ilDB->like("title", "text", "%" . $a_term . "%") .
            " ORDER by title");
        $res = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $res[] = $rec["title"];
        }
 
        return $res;
    }
 
    public static function lookupAdvancedMetadataHidden(
        int $a_page_id
    ): bool {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = "SELECT * FROM il_wiki_page" .
            " WHERE id = " . $ilDB->quote($a_page_id, "integer");
        $set = $ilDB->query($query);
        if ($rec = $ilDB->fetchAssoc($set)) {
            return (bool) $rec["hide_adv_md"];
        }
 
        return false;
    }
 
    public function preparePageForCompare(ilPageObject $page): void
    {
        $page->setWikiRefId($this->getWikiRefId());
    }
 
    protected function setTranslationProperties(ilPageObject $transl_page): void
    {
        parent::setTranslationProperties($transl_page);
        $transl_page->setWikiRefId($this->getWikiRefId());
    }
 
    protected function setCopyProperties(ilPageObject $new_page): void
    {
        // see #44256
        if ($new_page->getWikiId() === 0 || $new_page->getWikiId() === $this->getWikiId()) {
            $new_page->setWikiRefId($this->getWikiRefId());
        }
    }
 
}