chamilo / chamilo-lms

                    gt.group_id = $group_id ";

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

        $tags = array();

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

            while ($row = Database::fetch_array($res, 'ASSOC')) {

                $tags[] = $row;

            }

        }

        if ($show_tag_links) {

            if (is_array($tags) && count($tags) > 0) {

                    WHERE exercise_id = {$this->id} AND c_id = {$this->course_id} ";

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

            $list = array();

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

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

                    $list[$row['category_id']] = $row;

                }

                return $list;

            }

        }

        return false;

    }

            $sql .= "ORDER BY $order ";

        }

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

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

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

                $list[$row['category_id']] = $row;

            }

            return $list;

        }

        return false;

    }

    $sql = "SELECT add_to_calendar FROM $workTable

            WHERE c_id = $courseId AND publication_id = ".$workId;

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

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

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

        if (!empty($row['add_to_calendar'])) {

            return $row['add_to_calendar'];

        }

    }

    return 0;

}