thorsten / phpMyFAQ

     * @param  string  $record_lang Language

     * @return boolean

     */

    public function deleteCategoryRelations($record_id, $record_lang)

    {

        $query = sprintf("

            DELETE FROM

                %sfaqcategoryrelations

            WHERE

                record_id = %d

            AND

                record_lang = '%s'",

            PMF_Db::getTablePrefix(),

            $record_id,

            $record_lang);

        $this->_config->getDb()->query($query);

        return true;

    }

    /**

     * Returns an array with all data from a FAQ record

     * @param  string  $record_lang Record language

     * @return array

     */

    public function addNewRevision($record_id, $record_lang)

    {

        $query = sprintf("

            INSERT INTO

                %sfaqdata_revisions

            SELECT * FROM

                %sfaqdata

            WHERE

                id = %d

            AND

                lang = '%s'",

            PMF_Db::getTablePrefix(),

            PMF_Db::getTablePrefix(),

            $record_id,

            $record_lang);

        $this->_config->getDb()->query($query);

        return true;

    }

    /**

     *

     * @return boolean

     */

    function deleteQuestion($questionId)

    {

        $delete = sprintf('

            DELETE FROM

                %sfaqquestions

            WHERE

                id = %d',

            PMF_Db::getTablePrefix(),

            $questionId

        );

        $this->_config->getDb()->query($delete);

        return true;

    }

    /**

     * Returns the visibilty of a question

     * @since   2006-11-04

     * @author  Thorsten Rinne <[email protected]>

     */

    function setVisibilityOfQuestion($question_id, $is_visible)

    {

        $query = sprintf("

            UPDATE

                %sfaqquestions

            SET

                is_visible = '%s'

            WHERE

                id = %d",

            PMF_Db::getTablePrefix(),

            $is_visible,

            $question_id);

        $this->_config->getDb()->query($query);

        return true;

    }

    /**

     * This function generates a data-set with the mosted voted recors

     *

     * @return boolean

     */

    public function updateQuestionAnswer($openQuestionId, $faqId, $categoryId)

    {

        $query = sprintf(

            'UPDATE %sfaqquestions SET answer_id = %d, category_id= %d, WHERE id= %d',

            PMF_Db::getTablePrefix(),

            $faqId,

            $categoryId,

            $openQuestionId

        );

        return $this->_config->getDb()->query($query);

    }

    /**

     * Returns a part of a query to check permissions

     *

     * @return integer

     */

    public function getNumberOfEntries()

    {

        $query = sprintf('

            SELECT

                id

            FROM

                %sfaqadminlog',

            PMF_Db::getTablePrefix()

        );

        return $this->_config->getDb()->numRows(

            $this->_config->getDb()->query($query)

        );

    }

    /**

     * Returns all data from the adminlog

     *

     * @return boolean

     */

    public function deleteSessions($first, $last)

    {

        $query = sprintf("

            DELETE FROM

                %sfaqsessions

            WHERE

                time >= %d

            AND

                time <= %d",

            PMF_Db::getTablePrefix(),

            $first,

            $last);

        $this->_config->getDb()->query($query);

        return true;

    }

    /**

     * Checks the Session ID