mambax7 / gwiki

     *

     * @return int

     */

    private function getNextPageSetOrder($page_set_home)

    {

        global $xoopsDB;

        $page_set_order = 1;

        $keyword = $this->escapeForDB($page_set_home);

        $sql    = 'SELECT MAX(page_set_order) FROM ' . $xoopsDB->prefix('gwiki_pages') . " WHERE active = 1 and page_set_home = '{$keyword}' ";

        $result = $xoopsDB->query($sql);

        if ($result) {

            $myrow          = $xoopsDB->fetchRow($result);

            $page_set_order = $myrow[0] + 1;

        }

        return $page_set_order;

    }

    /**

     * Check if the current user may edit the current page

     *

     * @return int

     */

    public function getPageId($keyword)

    {

        global $xoopsDB;

        $page_id = 0;

        $keyword = $this->escapeForDB($keyword);

        $sql    = 'SELECT page_id FROM ' . $xoopsDB->prefix('gwiki_pageids') . " WHERE keyword = '{$keyword}' ";

        $result = $xoopsDB->query($sql);

        if ($result) {

            $myrow   = $xoopsDB->fetchRow($result);

            $page_id = $myrow[0];

        }

        return $page_id;

    }

    /**

     * record a page hit for a keyword