chamilo / chamilo-lms

     *

     * @return string The glossary description

     */

    public static function get_glossary_term_by_glossary_id ($glossary_id)

    {

        $glossary_table  = Database::get_course_table(TABLE_GLOSSARY);

        $course_id = api_get_course_int_id();

        $sql = "SELECT description FROM $glossary_table

                WHERE c_id = $course_id  AND glossary_id =".intval($glossary_id);

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

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

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

            return $row['description'];

        } else {

            return '';

        }

    }

    /**

     * Get glossary term by glossary id

     *

     * @return bool

     */

    public function hasChildren($eventId, $courseId)

    {

        $eventId = intval($eventId);

        $courseId = intval($courseId);

        $sql = "SELECT count(DISTINCT(id)) as count

                FROM ".$this->tbl_course_agenda."

                WHERE

                    c_id = $courseId AND

                    parent_event_id = $eventId";

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

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

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

            return $row['count'] > 0;

        }

        return false;

    }