chamilo / chamilo-lms

     * return array answer by id else return a bool

     * @param integer $auto_id

     */

    public function selectAnswerByAutoId($auto_id)

    {

        $TBL_ANSWER = Database::get_course_table(TABLE_QUIZ_ANSWER);

        $auto_id = intval($auto_id);

        $sql = "SELECT id, answer, id_auto FROM $TBL_ANSWER

                WHERE c_id = {$this->course_id} AND id_auto='$auto_id'";

        $rs = Database::query($sql);

        if (Database::num_rows($rs) > 0) {

            $row = Database::fetch_array($rs, 'ASSOC');

            return $row;

        }

        return false;

    }

    /**

     * returns the answer title from an answer's position

 * @author Patrick Cool <[email protected]>, Ghent University

 * @version february 2006, dokeos 1.8

 */

function check_if_last_post_of_thread($thread_id)

{

    $table_posts = Database::get_course_table(TABLE_FORUM_POST);

    $course_id = api_get_course_int_id();

    $sql = "SELECT * FROM $table_posts

            WHERE c_id = $course_id AND thread_id = ".intval($thread_id)."

            ORDER BY post_date DESC";

    $result = Database::query($sql);

    if (Database::num_rows($result) > 0) {

        $row = Database::fetch_array($result);

        return $row;

    } else {

        return false;

    }

}

/**

 * @param $content what is it that we want to make (in)visible: forum category, forum, thread, post